PHP Code:
stock loadb()
{
Database = db_open(_DB_);
db_query(Database,"CREATE TABLE IF NOT EXISTS `users`\
(`userid` INTEGER PRIMARY KEY AUTOINCREMENT, `username` TEXT, `IP` TEXT, `joindate` TEXT, `password` TEXT, `admin` NUMERIC, `kills` NUMERIC, `deaths` NUMERIC, `score` NUMERIC, `fbscore` NUMERIC, `ddscore` NUMERIC, `frscore` NUMERIC, `rscore` NUMERIC, `dmscore` NUMERIC, `money` NUMERIC, `warn` NUMERIC, `mute` NUMERIC,\
`mutesec` NUMERIC, `cmute` NUMERIC, `cmutesec` NUMERIC, `jail` NUMERIC, `jailsec` NUMERIC, `hours` NUMERIC, `minutes` NUMERIC, `seconds` NUMERIC, `question` TEXT, `answer` TEXT, `vip` NUMERIC)");
db_query(Database,"CREATE TABLE IF NOT EXISTS `bans` (`username` TEXT, `ip` TEXT, `banby` TEXT, `banreason` TEXT, `banwhen` TEXT)");
return 1;
}