MYSQL problem
#6

Код:
UPDATE `playedata` SET `score`=%d, `money`=%d, `admin`=%d, `vip`=%d, `skin`=%d, `banned`=%d, `bannedby`=%s WHERE `user`=%s LIMIT 1
Clears tables in the `level` onplayerconnect?


Код:
forward SaveData(playerid);
public SaveData(playerid)
{
if(Logged[playerid] == 1)
{
new score = GetPlayerScore(playerid);
new money = GetPlayerMoney(playerid);
new query[380], pname[24];
GetPlayerName(playerid, pname, 24);
format(query, sizeof(query), 
"UPDATE `playedata` SET `score`=%d, `money`=%d, `admin`=%d, `vip`=%d, `skin`=%d, `banned`=%d, `bannedby`=%s WHERE `user`=%s LIMIT 1'",score, money, PlayerInfo[playerid][pAdmin] ,PlayerInfo[playerid][pVIP] ,PlayerInfo[playerid][pSkin] ,
PlayerInfo[playerid][pBanned],
PlayerInfo[playerid][pBannedBy], pname);
mysql_query(query);
}
return 1;
}

//And use in onplayerspawn or somewhere
SetPVarInt(playerid, "SaveDatas", SetTimerEx("SaveData", 5*2000, 1, "d", playerid));
Reply


Messages In This Thread
MYSQL problem - by FrostDoggy - 10.12.2011, 11:37
Re: MYSQL problem - by THE_KNOWN - 10.12.2011, 11:40
Re: MYSQL problem - by Calgon - 10.12.2011, 11:41
Re: MYSQL problem - by FrostDoggy - 12.12.2011, 12:56
Re: MYSQL problem - by THE_KNOWN - 12.12.2011, 12:58
Re: MYSQL problem - by aniol16 - 12.12.2011, 13:03
Re: MYSQL problem - by FrostDoggy - 12.12.2011, 13:08
Re: MYSQL problem - by THE_KNOWN - 12.12.2011, 13:15
Re: MYSQL problem - by aniol16 - 12.12.2011, 13:19
Re: MYSQL problem - by FrostDoggy - 12.12.2011, 13:32

Forum Jump:


Users browsing this thread: 3 Guest(s)