Save and Load Positions[ MySQL]
#3

pawn Код:
GetPlayerPos(playerid, pos[0], pos[1], pos[2]);
    pinfo[playerid][Skin] = GetPlayerSkin(playerid);
    pinfo[playerid][Team] = GetPlayerTeam(playerid);
    pinfo[playerid][Money] = GetPlayerMoney(playerid);
    pinfo[playerid][Score] = GetPlayerScore(playerid);
    mysql_format(mysql, query, sizeof(query), "UPDATE `players` SET `Admin`=%d, `VIP`=%d, `Money`=%d, `posX`=%f, `posY`=%f, `posZ`=%f,\
    `Score` =%d, `Banned` =%d, `Cuffed` =%d, `Muted` =%d, `Jailed` =%d, `JailTime` =%d, `Drugs` =%d, `DrugAmount` =%d, `Robskill` =%d, `Hitmanskill` =%d, `Terskill` =%d, `TotalRobs` =%d,\
    `Skin` =%d, `Team` =%d, `Kills` =%d, `Deaths`=%d WHERE `ID`=%d"
,
    pinfo[playerid][Admin], pinfo[playerid][VIP],pinfo[playerid][Money], pos[0], pos[1], pos[2],
    pinfo[playerid][Score],pinfo[playerid][Banned], pinfo[playerid][Cuffed],pinfo[playerid][Muted],
    pinfo[playerid][Jailed],pinfo[playerid][JailTime],pinfo[playerid][Drug],pinfo[playerid][DrugAmount],
    pinfo[playerid][Robskill],pinfo[playerid][Hitmanskill],pinfo[playerid][Terskill],pinfo[playerid][TotalRobs],pinfo[playerid][Skin],
    pinfo[playerid][Team],pinfo[playerid][Kills],pinfo[playerid][Deaths],pinfo[playerid][ID]);
Reply


Messages In This Thread
Save and Load Positions[ MySQL] - by vassilis - 07.11.2015, 12:34
Re: Save and Load Positions[ MySQL] - by MD5 - 07.11.2015, 12:40
Re: Save and Load Positions[ MySQL] - by vassilis - 07.11.2015, 12:41
Re: Save and Load Positions[ MySQL] - by Vince - 07.11.2015, 12:47
Re: Save and Load Positions[ MySQL] - by vassilis - 07.11.2015, 12:49
Re: Save and Load Positions[ MySQL] - by MD5 - 07.11.2015, 13:08
Re: Save and Load Positions[ MySQL] - by vassilis - 07.11.2015, 13:10

Forum Jump:


Users browsing this thread: 2 Guest(s)