SA-MP Forums Archive
LARP + MYSQL = LAAAAAGGGGG - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: LARP + MYSQL = LAAAAAGGGGG (/showthread.php?tid=110980)


LARP + MYSQL = LAAAAAGGGGG - kLx - 29.11.2009

Hi people,

After we paid one Lithuanian scripter, to remake our modification, to use mySQL, we used windows to test it. It was huge lag when i connected to server. He said "When you'll run in on VPS, it will be okay". Two days ago, we ran it on vps, and guess what - same lag!
We can't contact him now, because he's now in sanatorium. I don't know what to do, players are waiting for our server, but the game mode is not even working ! Guys, what the problem could be? Maybe you need some callback's of my mode to look.

Like always.. Sorry for my bad english ,
Simas

Re: LARP + MYSQL = LAAAAAGGGGG - dice7 - 29.11.2009

Check if the db saving system is under OnPlayerUpdate

Re: LARP + MYSQL = LAAAAAGGGGG - kLx - 29.11.2009

There is:
pawn Код:
UpdatePlayer( playerid );
in OnPlayerDisconnect

and the UpdatePlayer( playerid ):
pawn Код:
stock UpdatePlayer( playerid )
{
    // Funkcija: UpdatePlayer( playerid )
    // Atnaujins юaidлjo duomenш bazлs duomenis
    
    MySQL_Check( );
    
    if ( gPlayerLogged[ playerid ] )
    {
      new
            string[ 1024 ],
            length,
            sqlid = PlayerInfo[ playerid ][ pSQLID ];
            
        format( string, 1024, "UPDATE `zaidejai` SET WHERE `id`=%d",
                    PlayerInfo[ playerid ][ pSQLID ] );
        length = strlen( string );
        
         ALL STUFF TO SAVE THE ACCOUNT.
        
        if ( strlen( string ) > length )
          samp_mysql_query( string );
    }
}


Re: LARP + MYSQL = LAAAAAGGGGG - kLx - 05.12.2009

No ideas?