Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- }
- stock LoadStats(playerid)
- {
- new query[400], pname[24], savingstring[20];
- GetPlayerName(playerid, pname, 50);
- 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);
- mysql_query(query);
- mysql_store_result();
- Message(playerid, "LOADING STATS...");
- while(mysql_fetch_row_format(query,"|"))
- {
- mysql_fetch_field_row(savingstring, "score"); SetPlayerScore(playerid, strval(savingstring));
- mysql_fetch_field_row(savingstring, "money"); MoneyGiven[playerid] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "level"); PlayerInfo[playerid][pLevel] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "moneygiven"); PlayerInfo[playerid][pMoneyGiven] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "moneyearned"); PlayerInfo[playerid][pMoneyEarned] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "rank"); PlayerInfo[playerid][pRank] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "kills"); PlayerInfo[playerid][pKills] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "deaths"); PlayerInfo[playerid][pDeaths] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "muted"); PlayerInfo[playerid][pMuted] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "jailed"); PlayerInfo[playerid][pJailed] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "banned"); PlayerInfo[playerid][pBanned] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "mutedtimes"); PlayerInfo[playerid][pMutedTimes] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "jailedtimes"); PlayerInfo[playerid][pJailedTimes] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "bannedtimes"); PlayerInfo[playerid][pBannedTimes] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "kickedtimes"); PlayerInfo[playerid][pKickedTimes] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "logins"); PlayerInfo[playerid][pLogins] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "gsabre"); PlayerInfo[playerid][pGSabre] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "karma"); PlayerInfo[playerid][pKarma] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "reports"); PlayerInfo[playerid][pReports] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "weaponsbought"); PlayerInfo[playerid][pWeaponsBought] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "hours"); PlayerInfo[playerid][pHours] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "minutes"); PlayerInfo[playerid][pMinutes] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "seconds"); PlayerInfo[playerid][pSeconds] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "killstreak"); PlayerInfo[playerid][pKillStreak] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "chat"); PlayerInfo[playerid][pChat] = strval(savingstring);
- mysql_fetch_field_row(savingstring, "wonevents"); PlayerInfo[playerid][pWonEvents] = strval(savingstring);
- }
- mysql_free_result();
- Message(playerid, "LOADING STATS SUCESSFUL");
- JustLogged[playerid] = 1;
- Logged[playerid] = 1;
- PlayerInfo[playerid][pLogins]++;
- SendMessage(playerid, "~g~Info: ~w~You have been logged-in!");
- return 1;
- }
Add Comment
Please, Sign In to add comment