[Unknown123]

Quote:

Originally Posted by BlackWolf120 can you show us the query code? (whole saving/loading block)

pawn Код:

stock savePlayerAccount(playerid)
{
    new SaveQuery[500];
    format(SaveQuery, sizeof(SaveQuery), "UPDATE `accs` SET `aLevel` = '%d', `Donator` = '%d', `Score` = '%d', `Money` = '%d', `Kills` = '%d', `Deaths` = '%d' WHERE `pName` = '%s'",
    pInfo[playerid][aLevel],
    pInfo[playerid][pDonator],
    GetPlayerScore(playerid),
    GetPlayerMoney(playerid),
    pInfo[playerid][pKills],
    pInfo[playerid][pDeaths],
    pName(playerid));

    mysql_query(SaveQuery);
    return playerid;
}

stock isPlayerWhiteListed(playerid)
{
    new string[81];
    Format(string, "SELECT `pName` FROM `whitelist` WHERE `pName` = '%s'", pName(playerid));
    mysql_query(string);
    mysql_store_result();
    if(mysql_num_rows() != 0 && mysql_ping(connection) != -1)
    {
        mysql_free_result();
        return 1;
    }
    mysql_free_result();
    return 0;
}

stock serverInfoUpdate(bool:connect)
{
    if(connect == true)
    {
        mysql_query("UPDATE `sinfo` SET `onlineplayers` = `onlineplayers` +1");
    }
    else
    {
        mysql_query("UPDATE `sinfo` SET `onlineplayers` = `onlineplayers` -1");
    }
}