function LoadAccInfo( player, dbGlobal )
{
pinfo[ player.ID ] = PlayerStats();
local id = player.ID;
local ip = player.IP;
local pad = getsleeptime(player);
local player_total_uptime = getPlayerTotalUptime(player);
local q = ::mysql_query( dbGlobal, "SELECT IP, Level, Pass, Kills, Flags, Deaths, Cash, Joins, DateRegistered, Stats, UID, Online, VIP, LADate, LAST, TTP, Spree, Warn, Mute, Bank, Skin FROM Account WHERE Name='" + player.Name.tolower() + "' " );
local result = ::mysql_fetch_assoc( q );
if( ::mysql_num_rows( q ) == 0 )
{
if ( ip == result[ "IP" ] )
{
pinfo[ player.ID ].rentskin = Skin.tointeger();
pinfo[ player.ID ].Level = Level;
pinfo[ player.ID ].IP = IP;
pinfo[ player.ID ].Joins = Joins;
pinfo[ player.ID ].Kills = Kills;
pinfo[ player.ID ].Flags = Flags;
pinfo[ player.ID ].Deaths = Deaths;
pinfo[ player.ID ].Cash = Cash;
mysql_query( dbGlobal, "UPDATE Account SET Online= 'true' WHERE Name='" + player.Name.tolower() + "'");
MessagePlayer(ORANGE+" Welcome to xxx.",player);
Message(YELLOW+" "+player.Name+" has auto logged-in successfully!");
MessagePlayer(ORANGE+" Your IP "+YELLOW+"< "+player.IP+" > "+ORANGE+"| Level "+YELLOW+"< "+GetLevelTag(player)+" >",player);
EchoMessage(ICOL_ORANGE+" "+player.Name+" has auto logged-in successfully!");
pinfo[ player.ID ].IsReg = true;
pinfo[ player.ID ].IsLogged = true;
pinfo[ player.ID ].Joins++;
player.Cash = Cash;
mysql_query( dbGlobal, "UPDATE Account SET UID='" + player.UniqueID + "' WHERE Name='" + player.Name.tolower() + "'");
}
else
{
MessagePlayer(ORANGE+" Welcome to xxx.",player);
MessagePlayer(YELLOW+" Logg-In to your account, in order to spawn.",player);
MessagePlayer(ORANGE+" Syntax: /Login <Password>.",player);
pinfo[ player.ID ].IsReg = true;
pinfo[ player.ID ].IsLogged = false;
}
}
else
{
MessagePlayer(ORANGE+" Welcome to xxx",player);
MessagePlayer(YELLOW+" Your nick is not registered, so register now to protect it.",player);
MessagePlayer(ORANGE+" Syntax: /Register <Password>.",player);
}
}