Help dont save MYSQL problem
#4

Код:
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);
Reply


Messages In This Thread
Help dont save MYSQL problem - by maikons - 29.11.2015, 14:51
Re: Help dont save MYSQL problem - by Antonio144 - 29.11.2015, 15:20
Re: Help dont save MYSQL problem - by maikons - 29.11.2015, 15:29
Re: Help dont save MYSQL problem - by Antonio144 - 29.11.2015, 15:38
Re: Help dont save MYSQL problem - by maikons - 29.11.2015, 17:06

Forum Jump:


Users browsing this thread: 1 Guest(s)