[knackworst]

Then I don't know why it doesn't properly write information into the fields...

pawn Код:

forward public UpdateData(playerid);
public UpdateData(playerid)
{
    new
        Query[200],
        name[MAX_PLAYER_NAME]
    ;
    GetPlayerName(playerid, name, sizeof(name));
    
    format(Query,sizeof(Query),"UPDATE `USERS` SET  MONEY = '%d' WHERE `NAME` = '%s' COLLATE NOCASE",  PInfo[playerid][Money], DB_Escape(name));
    db_free_result(db_query(Admin, Query));
    
    format(Query,sizeof(Query),"UPDATE `USERS` SET  SCORE = '%d' WHERE `NAME` = '%s' COLLATE NOCASE",  PInfo[playerid][Score], DB_Escape(name));
    db_free_result(db_query(Admin, Query));
    
    format(Query,sizeof(Query),"UPDATE `USERS` SET  SKIN = '%d' WHERE `NAME` = '%s' COLLATE NOCASE",  PInfo[playerid][Skin], DB_Escape(name));
    db_free_result(db_query(Admin, Query));
    
    format(Query,sizeof(Query),"UPDATE `USERS` SET  COLOR = '%d' WHERE `NAME` = '%s' COLLATE NOCASE",  PInfo[playerid][Color], DB_Escape(name));
    db_free_result(db_query(Admin, Query));
    
    format(Query,sizeof(Query),"UPDATE `USERS` SET  KILLS = '%d' WHERE `NAME` = '%s' COLLATE NOCASE",  PInfo[playerid][Kills], DB_Escape(name));
    db_free_result(db_query(Admin, Query));
    
    format(Query,sizeof(Query),"UPDATE `USERS` SET  REPUTATION = '%d' WHERE `NAME` = '%s' COLLATE NOCASE",  PInfo[playerid][Rep], DB_Escape(name));
    db_free_result(db_query(Admin, Query));

    format(Query,sizeof(Query),"UPDATE `USERS` SET  DEATHS = '%d' WHERE `NAME` = '%s' COLLATE NOCASE",  PInfo[playerid][Deaths], DB_Escape(name));
    db_free_result(db_query(Admin, Query));

    format(Query,sizeof(Query),"UPDATE `USERS` SET  VORTEXPB = '%d' WHERE `NAME` = '%s' COLLATE NOCASE",  PInfo[playerid][VortexPB], DB_Escape(name));
    db_free_result(db_query(Admin, Query));

    format(Query,sizeof(Query),"UPDATE `USERS` SET  HOUSES = '%d' WHERE `NAME` = '%s' COLLATE NOCASE",  PInfo[playerid][Houses], DB_Escape(name));
    db_free_result(db_query(Admin, Query));

    format(Query,sizeof(Query),"UPDATE `USERS` SET  RACESWON = '%d' WHERE `NAME` = '%s' COLLATE NOCASE",  PInfo[playerid][RacesWon], DB_Escape(name));
    db_free_result(db_query(Admin, Query));
    
    format(Query,sizeof(Query),"UPDATE `USERS` SET  RACESRACED = '%d' WHERE `NAME` = '%s' COLLATE NOCASE",  PInfo[playerid][RacesRaced], DB_Escape(name));
    db_free_result(db_query(Admin, Query));
    
    return 1;
}

OnPlayerDisconnect:

pawn Код:

if (PInfo[playerid][Logged] == 1)
    {
        UpdateData(playerid);
        PInfo[playerid][Logged] = 0;
    }