Oh god. I suggest everyone not use this script..
This is just the worst a sqlite script can get.
With bad I mean this bad:
function SetLogged( player, status )
{
QuerySQL( db, format( "UPDATE Accounts SET Logged='%s' WHERE Name='" + player.Name + "'", status ) );
}
function SetIPLogged( player, sameip )
{
QuerySQL( db, format( "UPDATE Accounts SET IP='%s' WHERE Name='" + player.Name + "'", sameip ) );
}
function GetPlayerIP( player )
{
local IP = GetSQLColumnData( QuerySQL( db, "SELECT IP FROM Accounts WHERE Name='" + player.Name + "'" ), 0 );
if ( IP ) return IP;
else return 0;
}
function GetLevel( player )
{
local lvl = GetSQLColumnData( QuerySQL( db, "SELECT Level FROM Accounts WHERE Name='" + player.Name + "'" ), 0 );
if ( lvl ) return lvl;
else return 0;
}
function GetCash( player )
{
local cash = GetSQLColumnData( QuerySQL( db, "SELECT Cash FROM Accounts WHERE Name='" + player.Name + "'" ), 0 );
if ( cash ) return cash;
else return 0;
}
function GetBankCash( player )
{
local cash = GetSQLColumnData( QuerySQL( db, "SELECT BankCash FROM Accounts WHERE Name='" + player.Name + "'" ), 0 );
if ( cash ) return cash;
else return 0;
}
function GetPass( player )
{
local pass = GetSQLColumnData( QuerySQL( db, "SELECT Pass FROM Accounts WHERE Name='" + player.Name + "'" ), 0 );
if ( pass ) return pass;
else return 0;
}
function GetLogged( player )
{
local log = GetSQLColumnData( QuerySQL( db, "SELECT Logged FROM Accounts WHERE Name='" + player.Name + "'" ), 0 );
if ( log ) return log;
else return 0;
}
Never, NEVER, use sqlite to store sessions or stuff like that. That's where squirrel and his Classes/tables/arrays kicks in.