Graal Forums - SQLite database structure

Graal Forums (https://forums.graalonline.com/forums/index.php)

- NPC Scripting (https://forums.graalonline.com/forums/forumdisplay.php?f=8)

- - SQLite database structure (https://forums.graalonline.com/forums/showthread.php?t=85527)

Admins

05-10-2009 06:35 PM

SQLite database structure

If you want to know which databases already exist and what their structure is, use following command:

echo("databases: " @ requestsql("select * from sqlite_master", true).rows);

Soala

05-10-2009 06:54 PM

:o nice

fowlplay4

05-10-2009 10:22 PM

To avoid an echo mess, I found this would give you all the necessary information about your tables.

PHP Code:


		
			
function onSQLData() {
  for (temp.row: requestsql("select * from sqlite_master", true).rows) {
    player.sendpm(row[4]);
  }
}

All times are GMT +2. The time now is 02:02 PM.