[maikons]

Whats worng here?

MYSQL log

Код:

[11:12:32] [DEBUG] mysql_format - connection: 1, len: 2500, format: "UPDATE `accounts` SET `Username` = '%s', `IP` = '%s', `scorelevel` = '%d', `maconha` = '%d', `material` = '%d', `sementes` = '%d..."
[11:12:32] [ERROR] mysql_format - no value for specifier "%d" available
[11:12:32] [ERROR] mysql_format - no value for specifier "%s" available
[11:12:32] [DEBUG] mysql_pquery - connection: 1, query: "UPDATE `accounts` SET `Username` = 'maikons', `IP` = '255.255.255.", callback: "(null)", format: "(null)"
[11:12:32] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[11:12:32] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 2.485 milliseconds
[11:12:32] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving

Code

Код:

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],
    GetName(playerid));
    printf("Salvou! 1");
    mysql_pquery(ConnectMYSQL, 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);

    mysql_format(ConnectMYSQL, query, sizeof(query), "UPDATE `accounts` SET `DP` = '%d', `VIP` = '%d', `fmembro` = '%d', `preso` = '%d', `presotime` = '%d', `startVIPdia` = '%d', `startVIPmes` = '%d', `startVIPano` = '%d', `carid` = '%d', `carpos0` = '%f', `carpos1` = '%f', `carpos2` = '%f', `carpos3` = '%f' WHERE Username = '%s'",
    DP[playerid],
    VIP[playerid],
    fmembro[playerid],
    preso[playerid],
    presotime[playerid],
    startVIPdia[playerid],
    startVIPmes[playerid],
    startVIPano[playerid],
    carid[playerid],
    carpos[playerid][0],
    carpos[playerid][1],
    carpos[playerid][2],
    carpos[playerid][3],
    GetName(playerid));
    printf("Salvou! 3");
    mysql_pquery(ConnectMYSQL, query);

    mysql_format(ConnectMYSQL, query, sizeof(query), "UPDATE `accounts` SET `carmtrunkarma1` = '%d', `carmtrunkarma2` = '%d', `carmtrunkarma3` = '%d', `carmtrunkarma4` = '%d', `carmtrunkarma5` = '%d', `carmtrunkbalas1` = '%d', `carmtrunkbalas2` = '%d', `carmtrunkbalas3` = '%d', `carmtrunkbalas4` = '%d', `carmtrunkbalas5` = '%d', `carmtrunktype1` = '%d', `carmtrunktype2` = '%d', `carmtrunktype3` = '%d' WHERE Username = '%s'",
    MalaInfo[carid[playerid]][arma1],
    MalaInfo[carid[playerid]][arma2],
    MalaInfo[carid[playerid]][arma3],
    MalaInfo[carid[playerid]][arma4],
    MalaInfo[carid[playerid]][arma5],
    MalaInfo[carid[playerid]][balas1],
    MalaInfo[carid[playerid]][balas2],
    MalaInfo[carid[playerid]][balas3],
    MalaInfo[carid[playerid]][balas4],
    MalaInfo[carid[playerid]][balas5],
    MalaInfo[carid[playerid]][type1],
    MalaInfo[carid[playerid]][type2],
    MalaInfo[carid[playerid]][type3],
    GetName(playerid));
    printf("Salvou! 4");
    mysql_pquery(ConnectMYSQL, query);

    mysql_format(ConnectMYSQL, query, sizeof(query), "UPDATE `accounts` SET `spawnpoint` = '%d', `housekey` = '%d', `idiom` = '%d', `tutorial` = '%d', `banned` = '%d', `expirarban` = '%d', `morto` = '%d', `mortotime` = '%d' WHERE Username = '%s'",
    spawnpoint[playerid],
    housekey[playerid],
    idiom[playerid],
    tutorial[playerid],
    banned[playerid],
    expirarban[playerid],
    morto[playerid],
    mortotime[playerid],
    GetName(playerid));
    printf("Salvou! 5");
    mysql_pquery(ConnectMYSQL, query);
}