29.11.2015, 15:38
Код:
stock OnPlayerSave(playerid) { new query[2500], ip[25]; GetPlayerIp(playerid, ip, sizeof(ip)); money[playerid] = GetPlayerMoneyEx(playerid); mysql_format(ConnectMYSQL, query, sizeof(query), "UPDATE `accounts` SET `Username` = '%s', `IP` = '%s', `scorelevel` = '%d', `maconha` = '%d', `material` = '%d', `sementes` = '%d', `BPsize` = '%d', `lastlogin` = '%d', `wanted` = '%d', `moneybag` = '%d', `COPskills` = '%d', `CRIMINALskills` = '%d', `PARAMEDICskills` = '%d', `admin` = '%d', `money` = '%d', `bank` = '%d', `kills` = '%d', `deaths` = '%d' WHERE `Username` = '%s' ", GetName(playerid), ip, scorelevel[playerid], maconha[playerid], material[playerid], sementes[playerid], BPsize[playerid], lastlogin[playerid], wanted[playerid], moneybag[playerid], COPskills[playerid], CRIMINALskills[playerid], PARAMEDICskills[playerid], admin[playerid], money[playerid], bank[playerid], You're missing kills[playerid], deaths[playerid], GetName(playerid)); printf("Salvou! 1"); mysql_pquery(ConnectMYSQL, query); BUT you are updating kills and deaths in the query bellow, so just remove `kills` = '%d', `deaths` = '%d' from the first query mysql_format(ConnectMYSQL, query, sizeof(query), "UPDATE `accounts` SET `kills` = '%d', `deaths` = '%d', `pistolSPAWN` = '%d', `shotgunSPAWN` = '%d', `submachineSPAWN` = '%d', `assaultSPAWN` = '%d', `sniperSPAWN` = '%d', `meleeSPAWN` = '%d', `carmtrunktype4` = '%d', `carmtrunktype5` = '%d' WHERE `Username` = '%s'", kills[playerid], deaths[playerid], pistolSPAWN[playerid], shotgunSPAWN[playerid], submachineSPAWN[playerid], assaultSPAWN[playerid], sniperSPAWN[playerid], meleeSPAWN[playerid], MalaInfo[carid[playerid]][type4], MalaInfo[carid[playerid]][type5], GetName(playerid)); printf("Salvou! 2"); mysql_pquery(ConnectMYSQL, query);