12.12.2011, 13:03
Код:
UPDATE `playedata` SET `score`=%d, `money`=%d, `admin`=%d, `vip`=%d, `skin`=%d, `banned`=%d, `bannedby`=%s WHERE `user`=%s LIMIT 1
Код:
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));