Guest User

Untitled

a guest
Apr 20th, 2013
201
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Pawn 2.31 KB | None | 0 0
  1. stock SaveAccount(playerid)
  2. {
  3.     // The query threads continue in the callback for finished queries.
  4.     if(GetPVarInt(playerid, "TempName") != 1 && gPlayerLogged[playerid] && AdminDuty[playerid] == 0)
  5.     {
  6.  
  7.         new
  8.             szPlayerName[MAX_PLAYER_NAME],
  9.             szPlayerName2[MAX_PLAYER_NAME],
  10.             szAdminName[MAX_PLAYER_NAME],
  11.             szQuery[2065];
  12.  
  13.         GetPlayerName(playerid, szPlayerName, MAX_PLAYER_NAME);
  14.  
  15.         mysql_real_escape_string(szPlayerName, szPlayerName2, g_MySQLConnections[0]);
  16.         mysql_real_escape_string(PlayerInfo[playerid][pAdminName], szAdminName, g_MySQLConnections[0]);
  17.        
  18.         format(szQuery, sizeof(szQuery), "UPDATE players SET Username = '%s', Password = '%s', Level = %d, AdminLevel = %d, AdminName = '%s', BanAppealer = %d, Donator = %d, Tokens = %d, Banned = %d, Permabanned = %d, Disabled = %d, LastIP = '%s', Registered = %d, Tutorial = %d, Sex = %d, Age = %d, Skin = %d WHERE ID = %d",szPlayerName, PlayerInfo[playerid][pKey], PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], szAdminName, PlayerInfo[playerid][pBanAppealer], PlayerInfo[playerid][pDonator], PlayerInfo[playerid][pTokens], PlayerInfo[playerid][pBanned], PlayerInfo[playerid][pPermaBanned], PlayerInfo[playerid][pDisabled], PlayerInfo[playerid][pIP], PlayerInfo[playerid][pReg], PlayerInfo[playerid][pTut], PlayerInfo[playerid][pSex], PlayerInfo[playerid][pAge], PlayerInfo[playerid][pSkin], PlayerInfo[playerid][pID]);
  19.         format(szQuery, sizeof(szQuery), "UPDATE players SET PosX = '%f', PosY = '%f', PosZ = '%f', PosR = '%f', ConnectTime = %d, Respect = %d, PhoneNumber = %d, Warnings = %d, Gang = %d, Faction = %d, Leader = %d, Rank = %d, GarageKey = %d, TogVIP = %d, GiftTime = %d, BuddyInvited = %d WHERE ID = %d", PlayerInfo[playerid][pPos_x],PlayerInfo[playerid][pPos_y], PlayerInfo[playerid][pPos_z], PlayerInfo[playerid][pPos_r], PlayerInfo[playerid][pConnectTime], PlayerInfo[playerid][pRespect], PlayerInfo[playerid][pNumber], PlayerInfo[playerid][pWarns], PlayerInfo[playerid][pGang],PlayerInfo[playerid][pFaction], PlayerInfo[playerid][pLeader], PlayerInfo[playerid][pRank],PlayerInfo[playerid][pPgaragekey], PlayerInfo[playerid][pToggedVIPChat], PlayerInfo[playerid][pGiftTime], PlayerInfo[playerid][pBuddyInvited], PlayerInfo[playerid][pID]);
  20.  
  21.         mysql_query(szQuery, THREAD_SAVE_ACCOUNT_CHAIN_1, playerid, g_MySQLConnections[0]);
  22.     }
  23.     return 1;
  24. }
Advertisement
Add Comment
Please, Sign In to add comment