29.06.2015, 23:48
Do it on two queries like this
PHP код:
new update1[300];
format(update1,sizeof(update1),"UPDATE users SET pMoney='%i', pAdmin='%i', pSkin='%i', pScore='%i', pPolice='%i', pGang='%i', pHorseshoes='%i', pDealer='%i', pWarnings='%i' WHERE pName = '%s'",GetPlayerMoney(playerid), PlayerInfo[playerid][pAdmin], GetPlayerSkin(playerid), GetPlayerScore(playerid), PlayerInfo[playerid][pPolice], PlayerInfo[playerid][pGang], PlayerInfo[playerid][pHorseshoes], PlayerInfo[playerid][pDealer], PlayerInfo[playerid][pWarnings], PlayerName(playerid));
mysql_query(1, update1);
new update2[128];
format(update2, sizeof(update2), "UPDATE users SET pJob='%i', pHouseID='%i' WHERE pName='%s'", PlayerInfo[playerid][pJob], PlayerInfo[playerid][pHouseID], PlayerName(playerid));
mysql_query(1, update2);