📦
Community Guide
  • README
  • ❔Faq
    • Accessing Pma
    • Level Reupload 1005 Error
    • Missing Dlls Fix
    • Package Parsing Error Android
    • Phpmyadmin And Ftp
  • 🛠️In Game Help
    • Add Mod Menu
    • Level Commands
    • Remove 6 Digit Song Limit Android
    • Remove Android Anticheat
    • Texture Pack
  • 🔐Phpmyadmin
    • Actions Explain
    • Banning
    • Basic Explanation Of The Php My Admin Tables
    • Change Default Downloads Likes
    • Create Gauntlets
    • Create Mappacks
    • Create Modip
    • Create Quests
    • Create Roles
    • Detailed Explanation Of Phpmyadmin Tables And Columns
    • Elegant Sql Fixes
    • Give Permissions
    • Placing Roles
    • Site Structure
    • PhpMyAdmin FAQ
  • Misc
    • How To Use Tools
    • Making An Old GDPS Version
  • Backend
    • How Autoban Php Works
    • How Cron Works
Powered by GitBook
On this page

Was this helpful?

Edit on GitHub
  1. Phpmyadmin

Site Structure

Short introduction to how certain elements are named on the site

Last updated 1 year ago

Was this helpful?

<- Click on the image to zoom in.

  • Database - This is the root of where all the GDPS information is stored, such as accounts, levels, quests etc.

  • Tables - Each individual table holds certain data. Imagine it like an excel table or a calendar that contains a couple columns as data and the ever-expanding rows as the data's content. The individual contents is what you can see in the middle of the screen when a table is selected.

In the top menu bar you can see a few buttons. Those will show different screens and let you interact with tables in various ways.

  • Browser - This allows you to view and modify individual entries in a table. This can be helpful if you need to make changes outside of the GDPSFH web panel.

  • Structure - You can manipulate each data column in a table. You can change how they are set and indexed, and you can add new columns for more customization. However, this can be confusing for beginners.

  • SQL - Here you can run SQL scripts to manipulate a table or database as you like. It is useful for making changes to multiple entries, but be aware that wrong actions are often irreversible.

  • Search - Search up specific content or a range of content in a table. Wildcards can be used to get more results, such as searching for levels with the level name "Level No. %" which will return all levels that start with "Level No."

  • Insert - Here you can insert your own data to a table. Please note that some things, such as the ID (usually the first row) is intentionally made to be left empty as it's generated automatically.

  • Export/Import - You can export a table (or the whole database) to get a backup as a .sql. This is convenient for quickly creating a database backup or moving to a different host. You can also import an .sql file, but it can be tricky if there are existing tables or entries. Please note: Exporting the levels table does not export the levels itself, just the metadata. The actual level data can be found on the server inside the /data/levels folder.

🔐