Messages

HI now my databse is loaded and my register login function is also working but when i reconnect my all stats money and kills are back to 0 plzz help me and thanks in advance

Hi everyone
                    I am creating a server and i am stuck at a point can u guys plz help me i will e thankful can u tell me how to create databse frm this code

Code Select Expand

constructor( playerName, dbGlobal )
   {
local query = ::QuerySQL( dbGlobal, "SELECT Cash, Bank, Kills, Deaths, Level, LastUsedIP FROM Accounts WHERE Name='" + playerName + "' AND NameLower='" + playerName.tolower() + "'" );
if( ::GetSQLColumnData( query, 5 ) )
{
Cash = ::GetSQLColumnData( query, 0 );
Bank = ::GetSQLColumnData( query, 1 );
Kills = ::GetSQLColumnData( query, 2 );
Deaths = ::GetSQLColumnData( query, 3 );
Level = ::GetSQLColumnData( query, 4 );
LastUsedIP = ::GetSQLColumnData( query, 5 );
}
::FreeSQLQuery( query );

        local q = ::QuerySQL( dbGlobal, "SELECT Played, Won, Lost FROM LMS WHERE Name='" + playerName.tolower() + "'" );
if( ::GetSQLColumnData( q, 2 ) )
{
     Played = ::GetSQLColumnData( q, 0 );
     Wins = ::GetSQLColumnData( q, 1 );
     Lost = ::GetSQLColumnData( q, 2 );
}
::FreeSQLQuery( q );
}

function Join( player ){
if( Level == 0 ){
::MessagePlayer( "Please register to play.", player );
::MessagePlayer( "Register with /register <password>", player );
}
else if( LastUsedIP == player.IP ){
Logged = true;
player.Cash = stats[ player.ID ].Cash;
::MessagePlayer( "Welcome back!", player );
}
else{
::MessagePlayer( "Please login to play.", player );
::MessagePlayer( "Login with /login <password>", player );
}
}

function Update( player, dbGlobal ){
::QuerySQL( dbGlobal, "UPDATE Accounts SET Cash=" + Cash + ", Bank=" + Bank + ", Kills=" + Kills + ", Deaths=" + Deaths + ", Level=" + Level + ", LastUsedIP='" + LastUsedIP + "' WHERE Name='" + player.Name + "' AND NameLower='" + player.Name.tolower() + "'" );
        ::QuerySQL( dbGlobal, "UPDATE LMS SET Lost=" + Lost + ", Played=" + Played + ", Won=" + Wins + " WHERE Name='" + player.Name.tolower() + "'" );
}

I want to ask about the folder in stores handling can i create myown handling file a new one if you do, what folder it should be and what should remain in the .cfg file itself or even xml

Can someone correct the link the download link is not working

Hi guys i am making a server it has all admin commands accept to spawn a vehicle can someone tell me a admin command to spawn vehicles thanks in advance

I am trying many codes for register login system but everything fails can u plz tell me code for it