Advertisement
Guest User

Beispiel

a guest
Jul 28th, 2013
28
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
HTML 2.10 KB | None | 0 0
  1. public OnPlayerDisconnect(playerid, reason)
  2. {
  3.     //================================================================//
  4.     //                              MySQL part                        //
  5.     //================================================================//
  6.     if(Logged[playerid] == 1)
  7.     {
  8.         new Float:x, Float:y, Float:z, Float:a;
  9.         GetPlayerPos(playerid, x, y, z);
  10.         GetPlayerFacingAngle(playerid, a);
  11.         PlayerInfo[playerid][pPosX] = x;
  12.         PlayerInfo[playerid][pPosY] = y;
  13.         PlayerInfo[playerid][pPosZ] = z;
  14.         PlayerInfo[playerid][pPosA] = a;
  15.         new score = GetPlayerScore(playerid);
  16.         new money = GetPlayerMoney(playerid);
  17.         new query[300], pname[24];//query muss dann dementsprechend erweitert werden!
  18.         GetPlayerName(playerid, pname, 24);
  19.         format(query, sizeof(query), "UPDATE playerdata SET score=%d, money=%d, level=%d, vip=%d, Tutorial=%d, rank=%d, kills=%d, deaths=%d, muted=%d, jailed=%d, frozen=%d, mutedtimes=%d, jailedtimes=%d, frozentimes=%d, banned=%d, bannedby='%s', logins=%d, posx=%f, posy=%f, posz=%f, posa=%f WHERE user='%s'",
  20.         score,money,PlayerInfo[playerid][pLevel],PlayerInfo[playerid][pVIP],PlayerInfo[playerid][pTutorial],PlayerInfo[playerid][pRank],PlayerInfo[playerid][pKills],PlayerInfo[playerid][pDeaths],PlayerInfo[playerid][pMuted],PlayerInfo[playerid][pJailed],PlayerInfo[playerid][pFrozen],
  21.         PlayerInfo[playerid][pMutedTimes],PlayerInfo[playerid][pJailedTimes],PlayerInfo[playerid][pFrozenTimes],PlayerInfo[playerid][pBanned],PlayerInfo[playerid][pBannedBy],PlayerInfo[playerid][pLogins],PlayerInfo[playerid][pPosX],PlayerInfo[playerid][pPosY],PlayerInfo[playerid][pPosZ],PlayerInfo[playerid][pPosA],pname,
  22. //---------------------------------------------------------------------------------------------------//
  23. // Hier das Beispiel
  24.         strcat(query,"Beispiel1=%s, Beispiel2=%s, Beispiel3=%s, Beispiel4=%s WHERE user='%s'",
  25.         PlayerInfo[playerid][Beispiel1],PlayerInfo[playerid][Beispiel2],PlayerInfo[playerid][Beispiel3],PlayerInfo[playerid][Beispiel4],
  26.         mysql_query(query);
  27.     }
  28.     return 1;
  29. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement