[TakeiT]

When I go to save everything, it's setting the variables to 0, instead of the proper one (for example, admin should save, it says 0 in the query) The password string also appears empty, and usually I would suspect query length, however my query length is 2500, which should be way more than enough to parse this.

Код:

[12:25:27] [DEBUG] mysql_format - connection: 1, len: 2500, format: "UPDATE `users` SET `pass` = '%s', `admin` = %d, `helper` = %d, `dev` = %d, `donator` = %d, `level` = %d, `hours` = %d, `paycheck..."
[12:25:27] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `users` SET `pass` = '', `admin` = 0, `helper` = 0, `dev`", callback: "(null)", format: "(null)"

Note: The password spot in the enum does get written to, which can be seen in the loading query that it's set.

pawn Код:

SavePlayer(playerid)
{
    new query[2500];
    
    mysql_format(connection, query, sizeof(query), "UPDATE `users` SET `pass` = '%s', `admin` = %d, `helper` = %d, `dev` = %d, `donator` = %d, `level` = %d, `hours` = %d, `paycheck` = %d, `faction` = %d, `factiontier` = %d, `factionrank` = '%s', `spawnhouse` = %d, `houseslots` = %d, `houseslotstotal` = %d, `bizslots` = %d, `bizslotstotal` = %d, `carslots` = %d, `carslotstotal` = %d, `cash` = %d, `bank` = %d, `phone` = %d, `mask` = %d, `skin` = %d, `sex` = %d,`wep1` = %d, `wep1ammo` = %d, `wep2` = %d, `wep2ammo` = %d, `wep3` = %d, `wep3ammo` = %d WHERE `ID` = %d", pInfo[playerid][Pass], pInfo[playerid][Admin], pInfo[playerid][Helper], pInfo[playerid][Dev], pInfo[playerid][Donator], pInfo[playerid][Level], pInfo[playerid][Hours], pInfo[playerid][Paycheck], pInfo[playerid][Faction], pInfo[playerid][FactionTier], pInfo[playerid][FactionRank], pInfo[playerid][SpawnHouse], pInfo[playerid][HouseSlots], pInfo[playerid][HouseSlotsTotal], pInfo[playerid][BizSlots], pInfo[playerid][BizSlotsTotal], pInfo[playerid][CarSlots], pInfo[playerid][CarSlotsTotal], pInfo[playerid][Cash], pInfo[playerid][Bank], pInfo[playerid][Phone], pInfo[playerid][Mask], pInfo[playerid][Skin], pInfo[playerid][Sex], pInfo[playerid][Wep1], pInfo[playerid][Wep1Ammo], pInfo[playerid][Wep2], pInfo[playerid][Wep2Ammo], pInfo[playerid][Wep3], pInfo[playerid][Wep3Ammo], pInfo[playerid][ID]);

    mysql_tquery(connection, query, "", "");
    return 1;
    
}

[TakeiT]

OMG, apologies for wasting your time, what I did was set my variables to 0 under OnPlayerDisconnect, THEN save...