[ancezas]

Sometimes script dosent save/loaf info from mysql data, but not every time, in server_log i seen nothing bad, in Mysql log same, nothging bad, Mysql is in FilterScripta

Saveing:

pawn Код:

stock MySQL_Save(playerid)

{

            new Query[ 512 ];

            mysql_reconnect();

         

            format( Query, sizeof( Query ),"UPDATE `"#MYSQL_TABLE"` SET pinigai = '%d', patirtis = '%d', admin = '%d', vip = '%d' WHERE vardas = '%s'",

            GetPlayerMoney( playerid ),

            GetPlayerScore( playerid ),

            zInfo[ playerid ][ Admin ],

            zInfo[ playerid ][ Vip ],

            GetPlayerNameEx( playerid ) );

         

            mysql_query(Query);

            mysql_free_result();

            return 1;

}

Loading:

pawn Код:

stock MySQL_Load(playerid)

{

        new

                fetch[ 16 ],

                Query[ 256 ];

        mysql_reconnect();

        format(Query, sizeof(Query), "SELECT * FROM `"#MYSQL_TABLE"` WHERE vardas = '%s'", GetPlayerNameEx(playerid));

        mysql_query(Query);

        mysql_store_result();

        mysql_retrieve_row();

        mysql_fetch_field_row( fetch, "pinigai" );              zInfo[ playerid ][ Pinigai ] = strval(fetch);        GivePlayerMoney(playerid, zInfo[playerid][Pinigai]);

        mysql_fetch_field_row( fetch, "patirtis" );              zInfo[ playerid ][ Patirtis ] = strval(fetch);      SetPlayerScore(playerid, zInfo[playerid][Patirtis]);

        mysql_fetch_field_row( fetch, "admin" );                  zInfo[ playerid ][ Admin ] = strval(fetch);

        mysql_fetch_field_row( fetch, "vip" );                  zInfo[ playerid ][ Vip ] = strval(fetch);

        mysql_free_result();

        printf( "Pakrautas ћaidėjas. [%s]", GetPlayerNameEx( playerid ) );

        return 1;

}

Sometimes xp, money is adding from noweahr, even it's nesesery.

pawn Код:

public OnPlayerDisconnect(playerid, reason)

{

    if( online[ playerid ] )

    {

        MySQL_Save( playerid );

    }

    return 1;

}

pawn Код:

public OnPlayerSpawn(playerid)

{

    if( from_login[ playerid ] )

    {

          MySQL_Load( playerid );

          from_login[ playerid ] = false;

        return 1;

    }

    return 1;

}

what i'm doing wrong? sorry for realy bad english