24.06.2012, 11:12
I can show you the saving function, not sure if that is what you need...
If you need something else, please tell me and i will post it
pawn Код:
forward SaveStats(playerid);
public SaveStats(playerid)
{
if(GetPVarInt(playerid,"Logged") == 1)
{
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'\
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],
GetPlayerNameEx(playerid));
mysql_query(query);
SendClientMessage(playerid,COLOR_RED,"Saving 1 debugged");
print(query);
format(query, sizeof(query), "UPDATE Users SET \
Age = '%d',\
PNumber = '%d',\
PDesc = '%s',\
PMail = '%s',\
PCountry = '%s',\
PSex = '%d',\
PMailConfirmed = '%d'\
WHERE Username = '%s'",
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);
print(query);
SendClientMessage(playerid,COLOR_RED,"Saving 2 debugged");
}
}