Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- YCMD:setstat(playerid, params[], help) {
- new valoare, item[50], userid, id[64], query[256], string[180];
- if(PlayerInfo[playerid][pAdmin] < 7) return 1;
- if(sscanf(params, "s[64]s[50]i", id, item, valoare)) {
- SCM(playerid, COLOR_GREY, "USAGE: {FFFFFF}/setstat <full name/id> <item> <amount>");
- SCM(playerid, COLOR_LGREEN, "Level, Money, Bank, House, Bizz, Job, Hours, Premium, premiumpoints");
- SCM(playerid, COLOR_LGREEN, "Rob, Mats, Drugs, Member, Leader, Rank, Fwarn, Warn, FPunish, Phone.");
- SCM(playerid, COLOR_LGREEN, "Slot1-10, Vip, Clan, ClanRank, Admin, Helper,SpinPoints");
- return 1;
- }
- if(IsNumeric(id)) {
- if(IsPlayerConnected(strval(id))) {
- //format(id, 64, "%s" GetName(id));
- }
- else SCM(playerid, COLOR_GREY, "Player not connected!");
- }
- new cont = MySQLCheckAccount(id);
- if(cont == 0) return SCM(playerid, COLOR_GREY, "Acest nume nu a fost gasit in baza de date!");
- userid = GetPlayerID(id);
- if(strcmp(item, "level", true) == 0) {
- if(userid != INVALID_PLAYER_ID) PlayerInfo[userid][pLevel] = valoare, SetPlayerScore(userid, valoare), UpdateProgress(playerid, 0);
- mysql_format(SQL, string, sizeof(string), "UPDATE users SET `Level`='%d' WHERE `name`='%s' LIMIT 1", valoare, id);
- mysql_tquery(SQL, string, "", "");
- }
- else if(strcmp(item, "slot1", true) == 0) {
- if(userid != INVALID_PLAYER_ID) {
- PlayerInfo[userid][pCarKey][0] = valoare;
- if(valoare > 0) {
- format(CarInfo[valoare][cOwner], 256, GetName(userid));
- CarInfo[valoare][Userid] = PlayerInfo[userid][pSQLID];
- format(query, sizeof(query), "UPDATE `cars` SET `Userid`='%d', `Name`='%s' WHERE `ID`='%d'", PlayerInfo[userid][pSQLID], GetName(userid), PlayerInfo[userid][pCarKey][0]);
- mysql_query(SQL, query);
- }
- }
- mysql_format(SQL, string, sizeof(string), "UPDATE users SET CarKey1='%d' WHERE `name`='%s' LIMIT 1", valoare, id);
- mysql_tquery(SQL, string, "", "");
- }
- else if(strcmp(item, "slot2", true) == 0) {
- if(userid != INVALID_PLAYER_ID) {
- PlayerInfo[userid][pCarKey][1] = valoare;
- if(valoare > 0) {
- format(CarInfo[valoare][cOwner], 256, GetName(userid));
- CarInfo[valoare][Userid] = PlayerInfo[userid][pSQLID];
- format(query, sizeof(query), "UPDATE `cars` SET `Userid`='%d', `Name`='%s' WHERE `ID`='%d'", PlayerInfo[userid][pSQLID], GetName(userid), PlayerInfo[userid][pCarKey][0]);
- mysql_query(SQL, query);
- }
- }
- mysql_format(SQL, string, sizeof(string), "UPDATE users SET CarKey2='%d' WHERE `name`='%s' LIMIT 1", valoare, id);
- mysql_tquery(SQL, string, "", "");
- }
- else if(strcmp(item, "slot3", true) == 0) {
- if(userid != INVALID_PLAYER_ID) {
- PlayerInfo[userid][pCarKey][2] = valoare;
- if(valoare > 0) {
- format(CarInfo[valoare][cOwner], 256, GetName(userid));
- CarInfo[valoare][Userid] = PlayerInfo[userid][pSQLID];
- format(query, sizeof(query), "UPDATE `cars` SET `Userid`='%d', `Name`='%s' WHERE `ID`='%d'", PlayerInfo[userid][pSQLID], GetName(userid), PlayerInfo[userid][pCarKey][0]);
- mysql_query(SQL, query);
- }
- }
- mysql_format(SQL, string, sizeof(string), "UPDATE users SET CarKey3='%d' WHERE `name`='%s' LIMIT 1", valoare, id);
- mysql_tquery(SQL, string, "", "");
- }
- else if(strcmp(item, "slot4", true) == 0) {
- if(userid != INVALID_PLAYER_ID) {
- PlayerInfo[userid][pCarKey][3] = valoare;
- if(valoare > 0) {
- format(CarInfo[valoare][cOwner], 256, GetName(userid));
- CarInfo[valoare][Userid] = PlayerInfo[userid][pSQLID];
- format(query, sizeof(query), "UPDATE `cars` SET `Userid`='%d', `Name`='%s' WHERE `ID`='%d'", PlayerInfo[userid][pSQLID], GetName(userid), PlayerInfo[userid][pCarKey][0]);
- mysql_query(SQL, query);
- }
- }
- mysql_format(SQL, string, sizeof(string), "UPDATE users SET CarKey4='%d' WHERE `name`='%s' LIMIT 1", valoare, id);
- mysql_tquery(SQL, string, "", "");
- }
- else if(strcmp(item, "slot5", true) == 0) {
- if(userid != INVALID_PLAYER_ID) {
- PlayerInfo[userid][pCarKey][4] = valoare;
- if(valoare > 0) {
- format(CarInfo[valoare][cOwner], 256, GetName(userid));
- CarInfo[valoare][Userid] = PlayerInfo[userid][pSQLID];
- format(query, sizeof(query), "UPDATE `cars` SET `Userid`='%d', `Name`='%s' WHERE `ID`='%d'", PlayerInfo[userid][pSQLID], GetName(userid), PlayerInfo[userid][pCarKey][0]);
- mysql_query(SQL, query);
- }
- }
- mysql_format(SQL, string, sizeof(string), "UPDATE users SET CarKey5='%d' WHERE `name`='%s' LIMIT 1", valoare, id);
- mysql_tquery(SQL, string, "", "");
- }
- else if(strcmp(item, "slot6", true) == 0) {
- if(userid != INVALID_PLAYER_ID) {
- PlayerInfo[userid][pCarKey][5] = valoare;
- if(valoare > 0) {
- format(CarInfo[valoare][cOwner], 256, GetName(userid));
- CarInfo[valoare][Userid] = PlayerInfo[userid][pSQLID];
- format(query, sizeof(query), "UPDATE `cars` SET `Userid`='%d', `Name`='%s' WHERE `ID`='%d'", PlayerInfo[userid][pSQLID], GetName(userid), PlayerInfo[userid][pCarKey][0]);
- mysql_query(SQL, query);
- }
- }
- mysql_format(SQL, string, sizeof(string), "UPDATE users SET CarKey6='%d' WHERE `name`='%s' LIMIT 1", valoare, id);
- mysql_tquery(SQL, string, "", "");
- }
- else if(strcmp(item, "slot7", true) == 0) {
- if(userid != INVALID_PLAYER_ID) {
- PlayerInfo[userid][pCarKey][6] = valoare;
- if(valoare > 0) {
- format(CarInfo[valoare][cOwner], 256, GetName(userid));
- CarInfo[valoare][Userid] = PlayerInfo[userid][pSQLID];
- format(query, sizeof(query), "UPDATE `cars` SET `Userid`='%d', `Name`='%s' WHERE `ID`='%d'", PlayerInfo[userid][pSQLID], GetName(userid), PlayerInfo[userid][pCarKey][0]);
- mysql_query(SQL, query);
- }
- }
- mysql_format(SQL, string, sizeof(string), "UPDATE users SET CarKey7='%d' WHERE `name`='%s' LIMIT 1", valoare, id);
- mysql_tquery(SQL, string, "", "");
- }
- else if(strcmp(item, "slot8", true) == 0) {
- if(userid != INVALID_PLAYER_ID) {
- PlayerInfo[userid][pCarKey][7] = valoare;
- if(valoare > 0) {
- format(CarInfo[valoare][cOwner], 256, GetName(userid));
- CarInfo[valoare][Userid] = PlayerInfo[userid][pSQLID];
- format(query, sizeof(query), "UPDATE `cars` SET `Userid`='%d', `Name`='%s' WHERE `ID`='%d'", PlayerInfo[userid][pSQLID], GetName(userid), PlayerInfo[userid][pCarKey][0]);
- mysql_query(SQL, query);
- }
- }
- mysql_format(SQL, string, sizeof(string), "UPDATE users SET CarKey8='%d' WHERE `name`='%s' LIMIT 1", valoare, id);
- mysql_tquery(SQL, string, "", "");
- }
- else if(strcmp(item, "slot9", true) == 0) {
- if(userid != INVALID_PLAYER_ID) {
- PlayerInfo[userid][pCarKey][8] = valoare;
- if(valoare > 0) {
- format(CarInfo[valoare][cOwner], 256, GetName(userid));
- CarInfo[valoare][Userid] = PlayerInfo[userid][pSQLID];
- format(query, sizeof(query), "UPDATE `cars` SET `Userid`='%d', `Name`='%s' WHERE `ID`='%d'", PlayerInfo[userid][pSQLID], GetName(userid), PlayerInfo[userid][pCarKey][0]);
- mysql_query(SQL, query);
- }
- }
- mysql_format(SQL, string, sizeof(string), "UPDATE users SET CarKey9='%d' WHERE `name`='%s' LIMIT 1", valoare, id);
- mysql_tquery(SQL, string, "", "");
- }
- else if(strcmp(item, "slot10", true) == 0) {
- if(userid != INVALID_PLAYER_ID) {
- PlayerInfo[userid][pCarKey][9] = valoare;
- if(valoare > 0) {
- format(CarInfo[valoare][cOwner], 256, GetName(userid));
- CarInfo[valoare][Userid] = PlayerInfo[userid][pSQLID];
- format(query, sizeof(query), "UPDATE `cars` SET `Userid`='%d', `Name`='%s' WHERE `ID`='%d'", PlayerInfo[userid][pSQLID], GetName(userid), PlayerInfo[userid][pCarKey][0]);
- mysql_query(SQL, query);
- }
- }
- mysql_format(SQL, string, sizeof(string), "UPDATE users SET CarKey10='%d' WHERE `name`='%s' LIMIT 1", valoare, id);
- mysql_tquery(SQL, string, "", "");
- }
- else if(strcmp(item, "admin", true) == 0) {
- if(valoare < 0 || valoare > 6) return SCM(playerid, COLOR_GREY, "Invalid admin level! (0-6)");
- if(userid != INVALID_PLAYER_ID) PlayerInfo[userid][pAdmin] = valoare;
- format(query, sizeof(query), "UPDATE `users` SET `Admin`='%d' WHERE `name`='%s'", valoare, id);
- mysql_query(SQL, query);
- }
- else if(strcmp(item, "helper", true) == 0) {
- if(valoare < 0 || valoare > 3) return SCM(playerid, COLOR_GREY, "Invalid helper level! (0-3)");
- if(userid != INVALID_PLAYER_ID) PlayerInfo[userid][pHelper] = valoare;
- format(query, sizeof(query), "UPDATE `users` SET `Helper`='%d' WHERE `name`='%s'", valoare, id);
- mysql_query(SQL, query);
- }
- else if(strcmp(item, "money", true) == 0) {
- if(userid != INVALID_PLAYER_ID) Cash[userid] = valoare;
- format(query, sizeof(query), "UPDATE `users` SET `Money`='%d' WHERE `name`='%s'", valoare, id);
- mysql_query(SQL, query);
- }
- else if(strcmp(item, "bank", true) == 0) {
- if(userid != INVALID_PLAYER_ID) PlayerInfo[userid][pAccount] = valoare;
- format(query, sizeof(query), "UPDATE `users` SET `Bank`='%d' WHERE `name`='%s'", valoare, id);
- mysql_query(SQL, query);
- }
- else if(strcmp(item, "house", true) == 0) {
- if(userid != INVALID_PLAYER_ID) PlayerInfo[userid][pHouse] = valoare;
- format(query, sizeof(query), "UPDATE `users` SET `House`='%d' WHERE `name`='%s'", valoare, id);
- mysql_query(SQL, query);
- }
- else if(strcmp(item, "bizz", true) == 0) {
- if(userid != INVALID_PLAYER_ID) PlayerInfo[userid][pBizz] = valoare;
- format(query, sizeof(query), "UPDATE `users` SET `Bizz`='%d' WHERE `name`='%s'", valoare, id);
- mysql_query(SQL, query);
- }
- else if(strcmp(item, "job", true) == 0) {
- PlayerInfo[userid][pJob] = valoare;
- format(query, sizeof(query), "UPDATE `users` SET `Job`='%d' WHERE `name`='%s'", valoare, id);
- mysql_query(SQL, query);
- }
- else if(strcmp(item, "hours", true) == 0) {
- if(userid != INVALID_PLAYER_ID) PlayerInfo[userid][pConnectTime] = valoare;
- format(query, sizeof(query), "UPDATE `users` SET `ConnectedTime`='%0.3f' WHERE `name`='%s'", valoare, id);
- mysql_query(SQL, query);
- }
- else if(strcmp(item, "premium", true) == 0) {
- if(userid != INVALID_PLAYER_ID) PlayerInfo[userid][pPremiumAccount] = valoare;
- format(query, sizeof(query), "UPDATE `users` SET `Premium`='%d' WHERE `name`='%s'", valoare, id);
- mysql_query(SQL, query);
- }
- else if(strcmp(item, "premiumpoints", true) == 0) {
- if(userid != INVALID_PLAYER_ID) PlayerInfo[userid][pPremiumPoints] = valoare;
- format(query, sizeof(query), "UPDATE `users` SET `GoldPoints`='%d' WHERE `name`='%s'", valoare, id);
- mysql_query(SQL, query);
- }
- else if(strcmp(item, "rob", true) == 0) {
- if(userid != INVALID_PLAYER_ID) PlayerInfo[userid][pRob] = valoare;
- format(query, sizeof(query), "UPDATE `users` SET `GoldCastigat`='%d' WHERE `name`='%s'", valoare, id);
- mysql_query(SQL, query);
- }
- else if(strcmp(item, "mats", true) == 0) {
- if(userid != INVALID_PLAYER_ID) PlayerInfo[userid][pMats] = valoare;
- format(query, sizeof(query), "UPDATE `users` SET `Materials`='%d' WHERE `name`='%s'", valoare, id);
- mysql_query(SQL, query);
- }
- else if(strcmp(item, "drugs", true) == 0) {
- if(userid != INVALID_PLAYER_ID) PlayerInfo[userid][pDrugs] = valoare;
- format(query, sizeof(query), "UPDATE `users` SET `Drugs`='%d' WHERE `name`='%s'", valoare, id);
- mysql_query(SQL, query);
- }
- else if(strcmp(item, "member", true) == 0) {
- if(userid != INVALID_PLAYER_ID) PlayerInfo[userid][pMember] = valoare, SetPlayerToTeamColor(userid);
- format(query, sizeof(query), "UPDATE `users` SET `Member`='%d' WHERE `name`='%s'", valoare, id);
- mysql_query(SQL, query);
- }
- else if(strcmp(item, "leader", true) == 0) {
- if(userid != INVALID_PLAYER_ID) PlayerInfo[userid][pLeader] = valoare, SetPlayerToTeamColor(userid);
- format(query, sizeof(query), "UPDATE `users` SET `Leader`='%d' WHERE `name`='%s'", valoare, id);
- mysql_query(SQL, query);
- }
- else if(strcmp(item, "rank", true) == 0) {
- if(userid != INVALID_PLAYER_ID) PlayerInfo[userid][pRank] = valoare;
- format(query, sizeof(query), "UPDATE `users` SET `Rank`='%d' WHERE `name`='%s'", valoare, id);
- mysql_query(SQL, query);
- }
- else if(strcmp(item, "fwarn", true) == 0) {
- if(userid != INVALID_PLAYER_ID) PlayerInfo[userid][pFACWarns] = valoare;
- format(query, sizeof(query), "UPDATE `users` SET `FWarn`='%d' WHERE `name`='%s'", valoare, id);
- mysql_query(SQL, query);
- }
- else if(strcmp(item, "warn", true) == 0) {
- if(userid != INVALID_PLAYER_ID) PlayerInfo[userid][pWarns] = valoare;
- format(query, sizeof(query), "UPDATE `users` SET `Warnings`='%d' WHERE `name`='%s'", valoare, id);
- mysql_query(SQL, query);
- }
- else if(strcmp(item, "fpunish", true) == 0) {
- if(userid != INVALID_PLAYER_ID) PlayerInfo[userid][pFpunish] = valoare;
- format(query, sizeof(query), "UPDATE `users` SET `FPunish`='%d' WHERE `name`='%s'", valoare, id);
- mysql_query(SQL, query);
- }
- else if(strcmp(item, "phone", true) == 0) {
- if(userid != INVALID_PLAYER_ID) PlayerInfo[userid][pPhone] = valoare;
- format(query, sizeof(query), "UPDATE `users` SET `PhoneNr`='%d' WHERE `name`='%s'", valoare, id);
- mysql_query(SQL, query);
- }
- else if(strcmp(item, "vip", true) == 0) {
- if(userid != INVALID_PLAYER_ID) PlayerInfo[userid][pVip] = valoare;
- format(query, sizeof(query), "UPDATE `users` SET `Vip`='%d' WHERE `name`='%s'", valoare, id);
- mysql_query(SQL, query);
- }
- else if(strcmp(item, "clan", true) == 0) {
- if(userid != INVALID_PLAYER_ID) PlayerInfo[userid][pClan] = valoare;
- format(query, sizeof(query), "UPDATE `users` SET `Clan`='%d' WHERE `name`='%s'", valoare, id);
- mysql_query(SQL, query);
- }
- else if(strcmp(item, "clanrank", true) == 0) {
- if(userid != INVALID_PLAYER_ID) PlayerInfo[userid][pClanRank] = valoare;
- format(query, sizeof(query), "UPDATE `users` SET `ClanRank`='%d' WHERE `name`='%s'", valoare, id);
- mysql_query(SQL, query);
- }
- else if(strcmp(item, "spinpoints", true) == 0) {
- if(userid != INVALID_PLAYER_ID) PlayerInfo[userid][pSpinPoints] = valoare;
- format(query, sizeof(query), "UPDATE `users` SET `SpinPoints`='%d' WHERE `name`='%s'", valoare, id);
- mysql_query(SQL, query);
- }
- else {
- SCM(playerid, COLOR_WHITE, "Level, Money, Bank, House, Bizz, Job, Hours, Premium, premiumpoints.");
- SCM(playerid, COLOR_WHITE, "Rob, Mats, Drugs, Member, Leader, Rank, Fwarn, Warn, FPunish, Phone.");
- SCM(playerid, COLOR_WHITE, "Slot1-10, Vip, Clan, ClanRank, Admin, Helper, SpinPoints");
- return 1;
- }
- if(userid != INVALID_PLAYER_ID) format(string, sizeof(string), "Warning: %s's %s was set to %d by admin %s.", GetName(userid), item, valoare, GetName(playerid));
- else format(string, sizeof(string), "Warning: %s's %s was set to %d by admin %s.", id, item, valoare, GetName(playerid));
- SendAdminMessage(COLOR_LIGHTRED, string, 6);
- return 1;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement