data is'nt save to database , help me plss
https://www.youtube.com/watch?v=mRsF_Dr8HVM&feature=youtu.be
https://www.youtube.com/watch?v=mRsF_Dr8HVM&feature=youtu.be
data is'nt save to database , help me plss
//Add here...
//function onScriptLoad()
QuerySQL(sqliteDB, "CREATE TABLE IF NOT EXISTS Accounts ( Name VARCHAR(255), Password VARCHAR(255), Cash INT, Bank INT, Kills INT, Deaths INT, Level INT, LastActive INT, LastUsedIP VARCHAR(255), DateRegistered INT)" );
QuerySQL(sqliteDB, "CREATE TABLE IF NOT EXISTS Bans ( NameLower VARCHAR(255), UID VARCHAR(255), Reason VARCHAR(255))" );
QuerySQL(sqliteDB, "CREATE TABLE IF NOT EXISTS Gotoloc ( Name VARCHAR(32), x INT, y INT, z INT, Creator VARCHAR(32))" );
@ngocson389Quote from ngocson389 on June 5th, 2016, 06:01 AM data is'nt save to database , help me plss
Add this in Function OnScriptLoad;Code: [Select] //Add here...
//function onScriptLoad()
QuerySQL(sqliteDB, "CREATE TABLE IF NOT EXISTS Accounts ( Name VARCHAR(255), Password VARCHAR(255), Cash INT, Bank INT, Kills INT, Deaths INT, Level INT, LastActive INT, LastUsedIP VARCHAR(255), DateRegistered INT)" );
QuerySQL(sqliteDB, "CREATE TABLE IF NOT EXISTS Bans ( NameLower VARCHAR(255), UID VARCHAR(255), Reason VARCHAR(255))" );
QuerySQL(sqliteDB, "CREATE TABLE IF NOT EXISTS Gotoloc ( Name VARCHAR(32), x INT, y INT, z INT, Creator VARCHAR(32))" );
@ngocson389Quote from ngocson389 on June 5th, 2016, 06:01 AM data is'nt save to database , help me plss
Add this in Function OnScriptLoad;Code: [Select] //Add here...
//function onScriptLoad()
QuerySQL(sqliteDB, "CREATE TABLE IF NOT EXISTS Accounts ( Name VARCHAR(255), Password VARCHAR(255), Cash INT, Bank INT, Kills INT, Deaths INT, Level INT, LastActive INT, LastUsedIP VARCHAR(255), DateRegistered INT)" );
QuerySQL(sqliteDB, "CREATE TABLE IF NOT EXISTS Bans ( NameLower VARCHAR(255), UID VARCHAR(255), Reason VARCHAR(255))" );
QuerySQL(sqliteDB, "CREATE TABLE IF NOT EXISTS Gotoloc ( Name VARCHAR(32), x INT, y INT, z INT, Creator VARCHAR(32))" );
Quote from zeus on June 6th, 2016, 09:35 AM Okey i did it thanksQuote from ngocson389 on June 5th, 2016, 06:01 AM data is'nt save to database , help me plss
@ngocson389
Add this in Function OnScriptLoad;Code: [Select] //Add here...
//function onScriptLoad()
QuerySQL(sqliteDB, "CREATE TABLE IF NOT EXISTS Accounts ( Name VARCHAR(255), Password VARCHAR(255), Cash INT, Bank INT, Kills INT, Deaths INT, Level INT, LastActive INT, LastUsedIP VARCHAR(255), DateRegistered INT)" );
QuerySQL(sqliteDB, "CREATE TABLE IF NOT EXISTS Bans ( NameLower VARCHAR(255), UID VARCHAR(255), Reason VARCHAR(255))" );
QuerySQL(sqliteDB, "CREATE TABLE IF NOT EXISTS Gotoloc ( Name VARCHAR(32), x INT, y INT, z INT, Creator VARCHAR(32))" );
player.Cash = pstats[ player.ID ].Cash;
pstats <- array( GetMaxPlayers(), null );