Advertisement
Guest User

Untitled

a guest
May 13th, 2017
159
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Pawn 4.94 KB | None | 0 0
  1. mysql_free_result();
  2.         new pName1[MAX_PLAYER_NAME];
  3.         GetPlayerName(playerid,pName1,sizeof(pName1));
  4.         format(query,sizeof(query),"SELECT * FROM `"TABLENAME"` WHERE Username = '%s' AND Password = '%s' LIMIT 1",pName1,md5(password));
  5.         mysql_query(query);
  6.  
  7.         mysql_store_result();
  8.  
  9.  
  10.         new intstring[128];
  11.         new row[1024];
  12.        
  13.         mysql_fetch_row_format(row,"|");
  14.        
  15.         mysql_fetch_field_row(intstring, "Level");
  16.         PlayerInfo[playerid][pLevel] = strval(intstring);
  17.         mysql_fetch_field_row(intstring, "Admin");
  18.         PlayerInfo[playerid][pAdmin] = strval(intstring);
  19.         mysql_fetch_field_row(intstring, "DonateRank");
  20.         PlayerInfo[playerid][pDonateRank] = strval(intstring);
  21.         mysql_fetch_field_row(intstring, "Registered");
  22.         PlayerInfo[playerid][pRegistered] = strval(intstring);
  23.         mysql_fetch_field_row(intstring, "Sex");
  24.         PlayerInfo[playerid][pSex] =strval(intstring);
  25.         mysql_fetch_field_row(intstring, "Age");
  26.         PlayerInfo[playerid][pAge] = strval(intstring);
  27.         mysql_fetch_field_row(intstring, "Experience");
  28.         PlayerInfo[playerid][pExp] = strval(intstring);
  29.         mysql_fetch_field_row(intstring, "Cash");
  30.         PlayerInfo[playerid][pCash] = strval(intstring);
  31.         mysql_fetch_field_row(intstring, "Bank");
  32.         PlayerInfo[playerid][pBank] = strval(intstring);
  33.         mysql_fetch_field_row(intstring, "Skin");
  34.         PlayerInfo[playerid][pSkin] = strval(intstring);
  35.         mysql_fetch_field_row(intstring, "Drugs");
  36.         PlayerInfo[playerid][pDrugs] = strval(intstring);
  37.         mysql_fetch_field_row(intstring, "Materials");
  38.         PlayerInfo[playerid][pMaterials] = strval(intstring);
  39.         mysql_fetch_field_row(intstring, "Job");
  40.         PlayerInfo[playerid][pJob] = strval(intstring);
  41.         mysql_fetch_field_row(intstring, "PlayingHours");
  42.         PlayerInfo[playerid][pPlayingHours] = strval(intstring);
  43.         mysql_fetch_field_row(intstring, "AllowedPayday");
  44.         PlayerInfo[playerid][pAllowedPayday] = strval(intstring);
  45.         mysql_fetch_field_row(intstring, "Paycheck");
  46.         PlayerInfo[playerid][pPayCheck] = strval(intstring);
  47.         mysql_fetch_field_row(intstring, "Faction");
  48.         PlayerInfo[playerid][pFaction] = strval(intstring);
  49.         mysql_fetch_field_row(intstring, "Rank");
  50.         PlayerInfo[playerid][pRank] = strval(intstring);
  51.         mysql_fetch_field_row(intstring, "HouseKey");
  52.         PlayerInfo[playerid][pHouseKey] = strval(intstring);
  53.         mysql_fetch_field_row(intstring, "BizKey");
  54.         PlayerInfo[playerid][pBizKey] = strval(intstring);
  55.         mysql_fetch_field_row(intstring, "SpawnPoint");
  56.         PlayerInfo[playerid][pSpawnPoint] = strval(intstring);
  57.         mysql_fetch_field_row(intstring, "Banned");
  58.         PlayerInfo[playerid][pBanned] = strval(intstring);
  59.         mysql_fetch_field_row(intstring, "Warnings");
  60.         PlayerInfo[playerid][pWarnings] = strval(intstring);
  61.         mysql_fetch_field_row(intstring, "CarLic");
  62.         PlayerInfo[playerid][pCarLic] = strval(intstring);
  63.         mysql_fetch_field_row(intstring, "FlyLic");
  64.         PlayerInfo[playerid][pFlyLic] = strval(intstring);
  65.         mysql_fetch_field_row(intstring, "WepLic");
  66.         PlayerInfo[playerid][pWepLic] = strval(intstring);
  67.         mysql_fetch_field_row(intstring, "PhoneNumber");
  68.         PlayerInfo[playerid][pPhoneNumber] = strval(intstring);
  69.         mysql_fetch_field_row(intstring, "PhoneC");
  70.         PlayerInfo[playerid][pPhoneC] = strval(intstring);
  71.         mysql_fetch_field_row(intstring, "PhoneBook");
  72.         PlayerInfo[playerid][pPhoneBook] = strval(intstring);
  73.         mysql_fetch_field_row(intstring, "ListNumber");
  74.         PlayerInfo[playerid][pListNumber] = strval(intstring);
  75.         mysql_fetch_field_row(intstring, "Donator");
  76.         PlayerInfo[playerid][pDonator] = strval(intstring);
  77.         mysql_fetch_field_row(intstring, "Jailed");
  78.         PlayerInfo[playerid][pJailed] = strval(intstring);
  79.         mysql_fetch_field_row(intstring, "JailTime");
  80.         PlayerInfo[playerid][pJailTime] = strval(intstring);
  81.         mysql_fetch_field_row(intstring, "Products");
  82.         PlayerInfo[playerid][pProducts] = strval(intstring);
  83.         mysql_fetch_field_row(intstring, "CrashX");
  84.         PlayerInfo[playerid][pCrashX] = floatstr(intstring);
  85.         mysql_fetch_field_row(intstring, "CrashY");
  86.         PlayerInfo[playerid][pCrashY] = floatstr(intstring);
  87.         mysql_fetch_field_row(intstring, "CrashZ");
  88.         PlayerInfo[playerid][pCrashZ] = floatstr(intstring);
  89.         mysql_fetch_field_row(intstring, "Crashint");
  90.         PlayerInfo[playerid][pCrashInt] = strval(intstring);
  91.         mysql_fetch_field_row(intstring, "CrashVW");
  92.         PlayerInfo[playerid][pCrashW] = strval(intstring);
  93.         mysql_fetch_field_row(intstring, "Crashed");
  94.         PlayerInfo[playerid][pCrashed] = strval(intstring);
  95.         mysql_free_result();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement