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',\
MarriedTo = '%s',\
Age = '%d',\
PNumber = '%d',\
PDesc = '%s',\
PMail = '%s',\
PCountry = '%s',\
PSex = '%d',\
PMailConfirmed = '%d'\
WHERE Username = '%s'",
GetPlayerMoney(playerid),
GetPVarInt(playerid,"Score"),
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][MarriedTo],
PInfo[playerid][Age],
PInfo[playerid][PNumber],
PInfo[playerid][PDesc],
PInfo[playerid][PMail],
PInfo[playerid][PCountry],
PInfo[playerid][PSex],
PInfo[playerid][PMailConfirmed],
GetPlayerNameEx(playerid));
mysql_query(query);
format(var, sizeof(var), "hi hi hi");
format(var, sizeof(var), "%s hi hi hi", var);
printf("%s", var); //prints out hi hi hi hi hi hi
@jamesb93 Im sure running more queries has its disadvantages
I wouldn't say it the way you did, because it sounds like 1 or 1000 queries would be the same. and i know they wouldn't. One trip to a database is kinda what ya go for, sometimes you may have to make another trip to the db but not normally. I think you can get it all to fit in one query by using multiply format statements. |
Please feel free to show me that running 2 instead of 1 dramatically slows down the server.
On-topic: I did pharse it wrongly, I was implying to format it on multiple times. |