Guest User

Untitled

a guest
Jan 22nd, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 3.70 KB | None | 0 0
  1. }
  2.  
  3. stock LoadStats(playerid)
  4. {
  5.     new query[400], pname[24], savingstring[20];
  6.     GetPlayerName(playerid, pname, 50);
  7.     format(query, sizeof(query), "SELECT score, money, level, moneygiven, moneyearned, rank, kills, deaths, muted, jailed, banned, mutedtimes, jailedtimes, bannedtimes, kickedtimes, logins, gsabre, karma, reports, weaponsbought, hours, minutes, seconds, registerdate, killstreak, chat, wonevents FROM playerdata WHERE user = '%s'", pname);
  8.     mysql_query(query);
  9.     mysql_store_result();
  10.     Message(playerid, "LOADING STATS...");
  11.     while(mysql_fetch_row_format(query,"|"))
  12.     {
  13.         mysql_fetch_field_row(savingstring, "score"); SetPlayerScore(playerid, strval(savingstring));
  14.         mysql_fetch_field_row(savingstring, "money"); MoneyGiven[playerid] = strval(savingstring);
  15.         mysql_fetch_field_row(savingstring, "level"); PlayerInfo[playerid][pLevel] = strval(savingstring);
  16.         mysql_fetch_field_row(savingstring, "moneygiven"); PlayerInfo[playerid][pMoneyGiven] = strval(savingstring);
  17.         mysql_fetch_field_row(savingstring, "moneyearned"); PlayerInfo[playerid][pMoneyEarned] = strval(savingstring);
  18.         mysql_fetch_field_row(savingstring, "rank"); PlayerInfo[playerid][pRank] = strval(savingstring);
  19.         mysql_fetch_field_row(savingstring, "kills"); PlayerInfo[playerid][pKills] = strval(savingstring);
  20.         mysql_fetch_field_row(savingstring, "deaths"); PlayerInfo[playerid][pDeaths] = strval(savingstring);
  21.         mysql_fetch_field_row(savingstring, "muted"); PlayerInfo[playerid][pMuted] = strval(savingstring);
  22.         mysql_fetch_field_row(savingstring, "jailed"); PlayerInfo[playerid][pJailed] = strval(savingstring);
  23.         mysql_fetch_field_row(savingstring, "banned"); PlayerInfo[playerid][pBanned] = strval(savingstring);
  24.         mysql_fetch_field_row(savingstring, "mutedtimes"); PlayerInfo[playerid][pMutedTimes] = strval(savingstring);
  25.         mysql_fetch_field_row(savingstring, "jailedtimes"); PlayerInfo[playerid][pJailedTimes] = strval(savingstring);
  26.         mysql_fetch_field_row(savingstring, "bannedtimes"); PlayerInfo[playerid][pBannedTimes] = strval(savingstring);
  27.         mysql_fetch_field_row(savingstring, "kickedtimes"); PlayerInfo[playerid][pKickedTimes] = strval(savingstring);
  28.         mysql_fetch_field_row(savingstring, "logins"); PlayerInfo[playerid][pLogins] = strval(savingstring);
  29.         mysql_fetch_field_row(savingstring, "gsabre"); PlayerInfo[playerid][pGSabre] = strval(savingstring);
  30.         mysql_fetch_field_row(savingstring, "karma"); PlayerInfo[playerid][pKarma] = strval(savingstring);
  31.         mysql_fetch_field_row(savingstring, "reports"); PlayerInfo[playerid][pReports] = strval(savingstring);
  32.         mysql_fetch_field_row(savingstring, "weaponsbought"); PlayerInfo[playerid][pWeaponsBought] = strval(savingstring);
  33.         mysql_fetch_field_row(savingstring, "hours"); PlayerInfo[playerid][pHours] = strval(savingstring);
  34.         mysql_fetch_field_row(savingstring, "minutes"); PlayerInfo[playerid][pMinutes] = strval(savingstring);
  35.         mysql_fetch_field_row(savingstring, "seconds"); PlayerInfo[playerid][pSeconds] = strval(savingstring);
  36.         mysql_fetch_field_row(savingstring, "killstreak"); PlayerInfo[playerid][pKillStreak] = strval(savingstring);
  37.         mysql_fetch_field_row(savingstring, "chat"); PlayerInfo[playerid][pChat] = strval(savingstring);
  38.         mysql_fetch_field_row(savingstring, "wonevents"); PlayerInfo[playerid][pWonEvents] = strval(savingstring);
  39.     }
  40.     mysql_free_result();
  41.     Message(playerid, "LOADING STATS SUCESSFUL");
  42.     JustLogged[playerid] = 1;
  43.     Logged[playerid] = 1;
  44.     PlayerInfo[playerid][pLogins]++;
  45.     SendMessage(playerid, "~g~Info: ~w~You have been logged-in!");
  46.     return 1;
  47. }
Add Comment
Please, Sign In to add comment