Site Structure

Short introduction to how certain elements are named on the site

  • 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.

Last updated