API tools faq
paste
Advertisement
MichaelFR

Untitled

MichaelFR
Sep 17th, 2015
163
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C++ 15.11 KB | None | 0 0
raw download clone embed print report
  1. public OnUpdatePlayerEXBan(playerid)//SQLite
  2. {
  3.          if(!IsPlayerConnected(playerid)) return printf("OnplayerupdateEXBan KRITICNA GRESKA! offline![%d]",playerid);
  4.          new query[512];
  5.          new Pname[24];
  6.          GetPlayerName(playerid, Pname, 24); //Players name
  7.           format(query, sizeof(query), "UPDATE racuni SET Level = '%d', Admin = '%d', Banan = '1', Spawn = '%d', DonatorBodovi = '%d' WHERE Nick = '%s'",
  8.          PlayerInfo[playerid][pLevel],PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pSpawn], GetPVarInt(playerid, "DonatorBodovi"), DB_Escape(Pname));
  9.          mysql_query(mysql, query );
  10.          //db_free_result( db_query(Bazarpg, query) );
  11.          //-----------------
  12.          format(query, sizeof(query), "UPDATE racuni SET ConnectTime = '%d', Spol = '%d', Godine = '%d', Porijeklo = '%d' WHERE Nick = '%s'",
  13.          PlayerInfo[playerid][pConnectTime],GetPVarInt(playerid, "Spol"),GetPVarInt(playerid, "Godine"),GetPVarInt(playerid, "Porijeklo"),DB_Escape(Pname));
  14.          mysql_query(mysql, query );
  15.          //db_free_result( db_query(Bazarpg, query) );
  16.          //-----------------
  17.          format(query, sizeof(query), "UPDATE racuni SET MuteVar ='%d', ExpPoeni = '%d', Gotovina = '%d', Racun = '%d', Zlocina = '%d', Ubojstava = '%d' WHERE Nick = '%s'",
  18.          PlayerInfo[playerid][pMuteVar],PlayerInfo[playerid][pExpPoeni],PlayerInfo[playerid][pGotovina],PlayerInfo[playerid][pRacun],PlayerInfo[playerid][pZlocina],PlayerInfo[playerid][pUbojstava],DB_Escape(Pname));
  19.          mysql_query(mysql, query );
  20.          //-----------------
  21.          format(query, sizeof(query), "UPDATE  racuni SET Umiranja = '%d', UhicenPuta = '%d', WantedSmrti = '%d', Imenik = '%d', Plovilo = '%d', IgracJob ='%d' WHERE Nick = '%s'",
  22.          PlayerInfo[playerid][pUmiranja],PlayerInfo[playerid][pUhicen],PlayerInfo[playerid][pWantedSmrti],PlayerInfo[playerid][pImenik],PlayerInfo[playerid][pPlovilo],PlayerInfo[playerid][pPosao],DB_Escape(Pname));
  23.          mysql_query(mysql, query);
  24.          //-----------------
  25.          format(query, sizeof(query), "UPDATE racuni SET PlacaCek = '%d', VrijGl = '%d', JailAdmin = '%s', Jailed = '%d', JailTime = '%d', Materijali = '%d', Droga ='%d' WHERE Nick = '%s'",
  26.          PlayerInfo[playerid][pPayCheck],PlayerInfo[playerid][pHeadValue],PlayerInfo[playerid][pJailAdmin],PlayerInfo[playerid][pJailed],GetPVarInt(playerid, "JailTime"),GetPVarInt(playerid, "Materijali"),GetPVarInt(playerid, "Droga"),DB_Escape(Pname));
  27.          mysql_query(mysql, query );
  28.          //-----------------
  29.          format(query, sizeof(query), "UPDATE racuni SET Lider='%d', Clan = '%d', Letjelica = '%d', Rank = '%d', `Char` = %d, PosUg = '%d' WHERE Nick = '%s'",
  30.          GetPVarInt(playerid, "Lider"),GetPVarInt(playerid, "Clan"),GetPVarInt(playerid, "Letjelica"),GetPVarInt(playerid, "Rank"),GetPVarInt(playerid, "Char"),GetPVarInt(playerid, "Posao_Ugovor"),DB_Escape(Pname));
  31.          mysql_query(mysql, query );
  32.          //-----------------
  33.          format(query, sizeof(query), "UPDATE racuni SET DetSkil = '%d', SexSkil = '%d', OdvjSkil = '%d', MehSkil = '%d', AutKradSkil = '%d', AutDilSkil = '%d' WHERE Nick = '%s'",
  34.          GetPVarInt(playerid, "Detektiv_Skil"),GetPVarInt(playerid, "Sex_Skil"),GetPVarInt(playerid, "Odvjetnik_Skil"),GetPVarInt(playerid, "Mehanicar_Skil"),GetPVarInt(playerid, "Auto_Kradljivac_Skil"),GetPVarInt(playerid, "Auto_Diler_Skil"),DB_Escape(Pname));
  35.          mysql_query(mysql, query );
  36.          //-----------------
  37.          format(query, sizeof(query), "UPDATE racuni SET NovSkil = '%d', DroSkil = '%d', pSHealth = '%f', pHealth = '%f', IntIgr = '%d', LocIgr = '%d' WHERE Nick = '%s'",
  38.          GetPVarInt(playerid, "Novinar_Skil"),GetPVarInt(playerid, "Droga_Skil"),PlayerInfo[playerid][pSHealth],PlayerInfo[playerid][pHealth],GetPVarInt(playerid, "Int_Igrac"),GetPVarInt(playerid, "Local_Igrac"),DB_Escape(Pname));
  39.          mysql_query(mysql, query );
  40.          //-----------------
  41.          format(query, sizeof(query), "UPDATE racuni SET TimIgr='%d',`pPnumber`='%d',`pBonIznos`='%d',`pPhousekey`='%d',`pStan`='%d' WHERE `Nick`='%s'",
  42.          GetPVarInt(playerid, "Tim_Igrac"),PlayerInfo[playerid][pPnumber],PlayerInfo[playerid][pBonIznos],PlayerInfo[playerid][pPhousekey],PlayerInfo[playerid][pStan],DB_Escape(Pname));
  43.          mysql_query(mysql, query );
  44.          //-----------------
  45.          format(query, sizeof(query), "UPDATE `racuni` SET pPbiskey='%d',`pHotelkey`='%d',`pCarLic`=%d WHERE`Nick`='%s'",
  46.          PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pHotelkey],PlayerInfo[playerid][pCarLic],DB_Escape(Pname));
  47.          mysql_query(mysql, query );
  48.          //-----------------
  49.          format(query, sizeof(query), "UPDATE `racuni` SET `pFlyLic` ='%d',`pBoatLic`='%d',`pGunLic`='%d',`Motor`='%d',`pVikendica`='%d' WHERE `Nick`='%s'",
  50.          PlayerInfo[playerid][pFlyLic],PlayerInfo[playerid][pBoatLic],PlayerInfo[playerid][pGunLic],GetPVarInt(playerid, "Motor"),PlayerInfo[playerid][pVikendica],DB_Escape(Pname));
  51.          mysql_query(mysql, query );
  52.          //-----------------
  53.          format(query, sizeof(query), "UPDATE `racuni` SET `pBicikla`='%d',`pAmmo2`='%d',`pCarTime`='%d' WHERE `Nick`='%s'",
  54.          PlayerInfo[playerid][pBicikla],GetPVarInt(playerid, "pAmmo2"),GetPVarInt(playerid, "pCarTime"),DB_Escape(Pname));
  55.          mysql_query(mysql, query );
  56.          //-----------------
  57.          format(query, sizeof(query), "UPDATE `racuni` SET `pPayDay` = '%d',`pPayDayHad`='%d',`pCDPlayer`='%d' WHERE `Nick`='%s'",
  58.          PlayerInfo[playerid][pPayDay],PlayerInfo[playerid][pPayDayHad],PlayerInfo[playerid][pCDPlayer],DB_Escape(Pname));
  59.          mysql_query(mysql, query );
  60.          //-----------------
  61.          format(query, sizeof(query), "UPDATE `racuni` SET `pTut`='%d',`pMissionNr`='%d',`pOstaloKredita`='%d',`pWarns`='%d' WHERE `Nick`='%s'",
  62.          PlayerInfo[playerid][pTut],PlayerInfo[playerid][pMissionNr],PlayerInfo[playerid][pOstaloKredita],PlayerInfo[playerid][pWarns],DB_Escape(Pname));
  63.          mysql_query(mysql, query );
  64.          //-----------------
  65.          format(query, sizeof(query), "UPDATE `racuni` SET `pMail`='%s',`Datum`='%s',`pAdjustable`='%d',`pFuel`='%d' WHERE `Nick`='%s'",
  66.          DB_Escape(PlayerInfo[playerid][pMail]),DB_Escape(PlayerInfo[playerid][pDatum]),PlayerInfo[playerid][pAdjustable],PlayerInfo[playerid][pFuel],DB_Escape(Pname));
  67.          mysql_query(mysql, query );
  68.          //-----------------
  69.          format(query, sizeof(query), "UPDATE `racuni` SET `pMarried`='%d',`pMarriedTo`='%s',`Gamesage`='%d',`pHotel`='%d',`pMisija` ='%d',`pMisijakoliko`='%d' WHERE `Nick`='%s'",
  70.          PlayerInfo[playerid][pMarried],DB_Escape(PlayerInfo[playerid][pMarriedTo]),GetPVarInt(playerid, "Gamesage"),PlayerInfo[playerid][pHotel],PlayerInfo[playerid][pMisija],PlayerInfo[playerid][pMisijakoliko],DB_Escape(Pname));
  71.          mysql_query(mysql, query );
  72.          //-----------------
  73.          format(query, sizeof(query), "UPDATE `racuni` SET `Automobil`='%d',`pTogMob`='%d',`pKaznaBanOrg`='%d',`pKolkoJeUORG`='%d',`pKazneniTut`='%d',`DMUbio`='%d' WHERE `Nick`='%s'",
  74.          GetPVarInt(playerid, "Automobil"),PlayerInfo[playerid][pTogMob],PlayerInfo[playerid][pKaznaBanOrg],PlayerInfo[playerid][pKolkoJeUORG],PlayerInfo[playerid][pKazneniTut],GetPVarInt(playerid, "DM_Ubio"),DB_Escape(Pname));
  75.          mysql_query(mysql, query );
  76.          //-----------------
  77.          format(query, sizeof(query), "UPDATE `racuni` SET `DMUmro`='%d',`DMPoeni`='%d',`pKamionLic`='%d',`pAdminAkt`='%d',`GradSpawn`='%d',`NaocaleMod`='%d',`Marama`='%d',`Kapa`='%d' WHERE `Nick`='%s'",
  78.          GetPVarInt(playerid, "DM_Umro"),GetPVarInt(playerid, "DM_Poeni"),PlayerInfo[playerid][pKamionLic],PlayerInfo[playerid][pAdminAkt],GetPVarInt(playerid, "GradSpawn"),GetPVarInt(playerid, "NaocaleMod"),GetPVarInt(playerid, "Marama"),GetPVarInt(playerid, "Kapa"),DB_Escape(Pname));
  79.          mysql_query(mysql, query );
  80.          format(query, sizeof(query), "UPDATE `racuni` SET `pAktDanPrije`='%d',`pAktDanas`='%d' WHERE`Nick`='%s'",
  81.          PlayerInfo[playerid][pAktDanPrije],PlayerInfo[playerid][pAktDanas],DB_Escape(Pname));
  82.          mysql_query(mysql, query );
  83.          //-----------------
  84.          format(query, sizeof(query), "UPDATE `racuni` SET `Kaciga`='%d',`Jezik`='%d',`SnimAcc`='%d',`Potpis`='%d',`Kosa`='%d',`pZadnjiIP`='%s' WHERE`Nick`='%s'",
  85.          GetPVarInt(playerid, "Kaciga"),PlayerInfo[playerid][pJezik],GetPVarInt(playerid, "SnimACC"),GetPVarInt(playerid, "Potpis"),GetPVarInt(playerid, "Kosa"),PlayerInfo[playerid][pZadnjiIP],DB_Escape(Pname));
  86.          mysql_query(mysql, query );
  87.  
  88.          format(query, sizeof(query), "UPDATE `racuni` SET `pStilBorbe`='%d' WHERE`Nick`='%s'",
  89.          PlayerInfo[playerid][pStilBorbe],DB_Escape(Pname));
  90.          mysql_query(mysql, query );
  91.  
  92.          format(query, sizeof(query), "UPDATE `racuni` SET `pImovina1`='%d',`pImovina1Tip`='%d',`pImovina2`='%d',`pImovina2Tip`='%d',`pImovina3`='%d',`pImovina3Tip`='%d',`pRadio`='%d',`pSpasitelj`='%d',`pMask`='%d',`pToolkit`='%d',`pGlad`='%d' WHERE`Nick`='%s'",
  93.          PlayerInfo[playerid][pImovina1], PlayerInfo[playerid][pImovina1Tip],  PlayerInfo[playerid][pImovina2], PlayerInfo[playerid][pImovina2Tip],  PlayerInfo[playerid][pImovina3], PlayerInfo[playerid][pImovina3Tip],PlayerInfo[playerid][pRadio], PlayerInfo[playerid][pSpasitelj], PlayerInfo[playerid][pMask], PlayerInfo[playerid][pToolkit], PlayerInfo[playerid][pGlad], DB_Escape(Pname));
  94.          mysql_query(mysql, query );
  95.  
  96.          format(query, sizeof(query), "UPDATE `racuni` SET `SatLogin`='%d',`SatLogout`='%d' WHERE`Nick`='%s'",
  97.          PlayerInfo[playerid][pSatLogin],PlayerInfo[playerid][pSatLogout],DB_Escape(Pname));
  98.          mysql_query(mysql, query );
  99.          return 1;
  100. }
  101.  
  102.  
  103. COMMAND:ban(playerid, params[])
  104. {
  105.     if (PlayerInfo[playerid][pAdmin] < 2)
  106.     {
  107.         SendClientMessage(playerid, COLOR_GRAD1, " "#COL_WHITE"["#COL_RED"CHAC"#COL_WHITE"] "#COL_GREY"Admini samo!");
  108.         return 1;
  109.     }
  110.     new giveplayerid;
  111.     new result[128];
  112.     if (sscanf(params, "us", giveplayerid,result)) SendClientMessage(playerid, COLOR_GRAD2, "Koristite: /ban [Korisnicki ID ili Ime Korisnika] [razlog]");
  113.     else if(giveplayerid == INVALID_PLAYER_ID)  SendClientMessage(playerid, COLOR_GRAD1, "*Pogresan ID Korisnika");
  114.     else if(strlen(result)>64) SendClientMessage(playerid, COLOR_GRAD1, "*Predug razlog");
  115.     else
  116.     {
  117.         if(IsPlayerNPC(giveplayerid))
  118.         {
  119.             SendClientMessage(playerid, COLOR_GRAD1, "*Ne mozes na NPC-u primijeniti tu funkciju!!!");
  120.             return 1;
  121.         }
  122.         new string[128];
  123.         new giveplayer[MAX_PLAYER_NAME];
  124.         new sendername[MAX_PLAYER_NAME];
  125.         GetPlayerName(giveplayerid, giveplayer, sizeof(giveplayer));
  126.         GetPlayerName(playerid, sendername, sizeof(sendername));
  127.         new year, month,day;
  128.         getdate(year, month, day);
  129.         new playersip[128];
  130.         new level = PlayerInfo[giveplayerid][pLevel];
  131.         GetPlayerIp(giveplayerid,playersip,sizeof(playersip));
  132.         format(string, sizeof(string), "BAN(%d-%d-%d)| %s[LV:%d] od admina %s, Razlog: %s ", month,day,year, giveplayer, level, sendername,(result));
  133.         BanLog(string);
  134.         SetPVarInt(giveplayerid, "Banan", 1);
  135.         StaviBanan(giveplayerid);
  136.         if(gPlayerLogged[giveplayerid] == 1) {
  137.                 //printf("[Bananje update] Start %d", giveplayerid);
  138.                 OnUpdatePlayer(giveplayerid);
  139.                 //printf("[Bananje update] Uspjesno %d", giveplayerid);
  140.                 gPlayerLogged[giveplayerid] = 2;
  141.         }
  142.         format(string, sizeof(string), "BAN | %s je banan od %s, Razlog: %s", giveplayer, sendername, (result));
  143.         SendAdminMessage(COLOR_ORANGERED, string);
  144.         if(PlayerInfo[giveplayerid][pLevel] > 1)
  145.         {
  146.             SendClientMessage(playerid,COLOR_TOMATO, "Upozorenje! - Igracev level veci od 1 ___________________");
  147.             SendClientMessage(playerid,COLOR_GREEN, "Taj igrac ima veci level od 1 i stoga je potrebno staviti njegov ban na forum! slikaj sa f8 i postaj!");
  148.             SendClientMessage(playerid,COLOR_YELLOW, "Svatko je obavezan postati ban igraca ciji je level veci od 1!");
  149.             format(string, sizeof(string), "Informacije o bananom igracu | Nick: %s, ID: %d, Level: %d", giveplayer,giveplayerid,level);
  150.             SendClientMessage(playerid,COLOR_TOMATO, string);
  151.         }
  152.         SendClientMessage(giveplayerid,COLOR_ORANGERED, "  ");
  153.         SendClientMessage(giveplayerid,COLOR_ORANGERED, "  ");
  154.         SendClientMessage(giveplayerid,COLOR_ORANGERED, "  ");
  155.         SendClientMessage(giveplayerid,COLOR_ORANGERED, "  ");
  156.         SendClientMessage(giveplayerid,COLOR_ORANGERED, "  ");
  157.         SendClientMessage(giveplayerid,COLOR_ORANGERED, "  ");
  158.         SendClientMessage(giveplayerid,COLOR_BRIGHTRED, "______________________________________________________________________________________");
  159.         SendClientMessage(giveplayerid,COLOR_BRIGHTRED, "______________________________________________________________________________________");
  160.         SendClientMessage(giveplayerid,COLOR_TOMATO, "ISKLJUCENI STE SA SERVERA(Banani)! pozorno procitajte tekst!");
  161.         format(string, sizeof(string), "%s(ID:%d) iskljucen(Banan) si sa servera od %s", giveplayer,giveplayerid, sendername);
  162.         SendClientMessage(giveplayerid,COLOR_AQUA, string);
  163.         format(string, sizeof(string), "Razlog iskljucenja: %s", (result));
  164.         SendClientMessage(giveplayerid,COLOR_AQUA, string);
  165.         format(string, sizeof(string), "Datum bana: %d-%d-%d | Vasa ip adresa je: %s",month,day,year,playersip);
  166.         SendClientMessage(giveplayerid,COLOR_AQUA, string);
  167.         SendClientMessage(giveplayerid,COLOR_AQUA, "Sa ovim banom, vas korisnicki racun je suspendiran na neodredjeno!");
  168.         SendClientMessage(giveplayerid,COLOR_YELLOW, "Ukoliko mislis da je doslo do greske slikaj ovo(f8) i zatrazi unban na forumu!");
  169.         format(string, sizeof(string), "IP Adresa bananog igraca: %s. Adresa sa banom nije banana!",playersip);
  170.         SendClientMessage(playerid,COLOR_TOMATO, string);
  171.         SendClientMessage(playerid,COLOR_YELLOW, "Ukoliko zelis banati i ip, pisi /banip [ip koji pise iznad ove poruke]");
  172.         //mysql_real_escape_string(result, razlog);
  173.         new Querystring[256];
  174.         format(Querystring, sizeof(Querystring), "UPDATE racuni SET RazlogBana = '%s' AND Banan = '1' WHERE Nick = '%s'", DB_Escape(result),giveplayer);
  175.         mysql_query(mysql, Querystring);
  176.         //db_free_result( db_query(Bazarpg, Querystring) );
  177.         if (GetPVarInt(playerid, "Gamesage") >= 4)
  178.         {
  179.             format(string, sizeof(string), "Ban | %s, GameSage: %s", giveplayer, sendername);
  180.         }
  181.         if (PlayerInfo[playerid][pAdmin] >= 2)
  182.         {
  183.             format(string, sizeof(string), "Ban | %s, Admin: %s", giveplayer, sendername);
  184.         }
  185.         SendClientMessageToAll(COLOR_ORANGERED, string);
  186.         D_Kick(giveplayerid);
  187.     }
  188.     return 1;
  189. }
  190. stock StaviBanan(playerid) {
  191.     //printf("[SQL debug] StaviBanan [%d]",playerid);
  192.     if(!IsPlayerConnected(playerid)) return 1;
  193.     if(gPlayerLogged[playerid]==1)
  194.     {
  195.         new query[128];
  196.         new playername[MAX_PLAYER_NAME];
  197.         GetPlayerName(playerid, playername, sizeof(playername));
  198.         format(query, sizeof(query), "UPDATE racuni SET Banan = '1' WHERE Nick = '%s'",
  199.         DB_Escape(playername));
  200.         mysql_query(mysql, query);
  201.     }
  202.     return true;
  203. }
  204.  
  205. stock StaviBananEX(playerid,string[]) {
  206.     //printf("[SQL debug] StaviBanan [%d]",playerid);
  207.     if(!IsPlayerConnected(playerid)) return 1;
  208.     if(gPlayerLogged[playerid]==1)
  209.     {
  210.         new query[128];
  211.         new playername[MAX_PLAYER_NAME];
  212.         GetPlayerName(playerid, playername, sizeof(playername));
  213.         format(query, sizeof(query), "UPDATE racuni SET Banan = '1', RazlogBana = '%s' WHERE Nick = '%s'",
  214.         DB_Escape(string),DB_Escape(playername));
  215.         mysql_query(mysql, query);
  216.     }
  217.     return true;
  218. }
  219. //------------------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!