05.07.2012, 09:47
pawn Code:
new query[1024];
format(query, sizeof(query), "UPDATE Users SET \
Money = '%d', \
Level = '%d', \
Admin = '%d', \
Helper = '%d', \
VipLevel = '%d', \
Skin = '%d', \
Kills = '%d', \
Deaths = '%d', \
Muted = '%d', \
Cell = '%d', \
Cigs = '%d', \
Watch = '%d', \
Mask = '%d', \
GasCan = '%d', \
Sprunk = '%d', \
Stereo = '%d', \
GoldCoins = '%d', \
PaymentMethod = '%d', \
DriversLic = '%d', \
WeaponLic = '%d', \
HeavyVLic = '%d', \
PilotLic = '%d', \
BlockedPM = '%d',\
Proposing = '%d',\
Warnings = '%d'\
WHERE Username = '%s'",
GetPlayerMoney(playerid),
GetPlayerScore(playerid),
GetPVarInt(playerid,"Level"),
GetPVarInt(playerid,"Helper"),
GetPVarInt(playerid,"Vip Level"),
GetPVarInt(playerid,"Skin"),
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"),
GetPVarInt(playerid,"DriversLic"),
GetPVarInt(playerid,"WeaponLic"),
GetPVarInt(playerid,"HeavyVLic"),
GetPVarInt(playerid,"PilotLic"),
PInfo[playerid][BlockedPM],
PInfo[playerid][Proposing],
PInfo[playerid][Warnings],
PInfo[playerid][Exp],
PInfo[playerid][Phonebook],
GetPlayerNameEx(playerid));
mysql_query(query);