LARP + MYSQL = LAAAAAGGGGG
#1

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
Reply
#2

Check if the db saving system is under OnPlayerUpdate
Reply
#3

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 );
    }
}
Reply
#4

No ideas?
Reply


Forum Jump:


Users browsing this thread: 3 Guest(s)