[Jstylezzz]

Hi everybody!

So, i finally manage to get my MYSQL things working, so , i added some more.
The problem is, that i'm getting errors, and i'm not sure whats wrong..

Error:

pawn Код:

[20:22:39] CMySQLHandler::Query(UPDATE Users SET Money = '-1000', Level = '0', Admin = '0', Helper = '0', VipLevel = '0', Skin '240', Kills = '0', Deaths = '0', Muted = '0', Cell = '1', Cigs = '15', Watch = '1', Mask = '1', GasCan = '1', Sprunk = '5', Stereo = '1', GoldCoins = '0', PaymentMethod = '0' WHERE Username = 'Jari_Johnson') - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''240', Kills = '0', Deaths = '0', Muted = '0', Cell = '1', Cigs = '15', Watch = ' at line 1)
[20:22:39] OnQueryError() - Called.

And the line(s) where it's going wrong:

pawn Код:

new query[1024];
    format(query, sizeof(query), "UPDATE Users SET \
    Money = '%d', \
    Level = '%d', \
    Admin = '%d', \
    Helper = '%d', \
    VipLevel = '%d', \
    Skin '%i', \
    Kills = '%d', \
    Deaths = '%d', \
    Muted = '%d', \
    Cell = '%d', \
    Cigs = '%d', \
    Watch = '%d', \
    Mask = '%d', \
    GasCan = '%d', \
    Sprunk = '%d', \
    Stereo = '%d', \
    GoldCoins = '%d', \
    PaymentMethod = '%d' \
    WHERE Username = '%s'",
    GetPlayerMoney(playerid),
    GetPVarInt(playerid,"Score"),
    GetPVarInt(playerid,"Level"),
    GetPVarInt(playerid,"Helper"),
    GetPVarInt(playerid,"Vip Level"),
    GetPlayerSkin(playerid),
    GetPVarInt(playerid,"Kills"),
    GetPVarInt(playerid,"Deaths"),
    GetPVarInt(playerid,"Muted"),
    GetPVarInt(playerid,"HasCellphone"),
    GetPVarInt(playerid,"HasCigs"),
    GetPVarInt(playerid,"HasWatch"),
    GetPVarInt(playerid,"HasMask"),
    GetPVarInt(playerid,"GasCan"),
    GetPVarInt(playerid,"HasSprunk"),
    GetPVarInt(playerid,"HasStereo"),
    GetPVarInt(playerid,"GoldCoins"),
    GetPVarInt(playerid,"PMethod"),
    GetPlayerNameEx(playerid));
    mysql_query(query);

I hope someone knows the problem and knows how to solve it..

[Vince]

Код:

the right syntax to use near ''240'

It basically tells you what to do ...

[Jstylezzz]

Quote:

Originally Posted by Vince Код: the right syntax to use near ''240' It basically tells you what to do ...

Yeah, i know that, but i don't get what it means with "240"..

EDIT: solved, thanks [Diablo]!