API tools faq
paste
Preda

SQLITE PROBLEM / BETA 3

Preda
Aug 23rd, 2012
67
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Pawn 29.57 KB | None | 0 0
raw download clone embed print report
  1. //  ============================================================// CREATOR: PREDA // // CREDITS MUST STAY SAME //============================================================
  2. // CREDITS //
  3. // ZCMD ; SSCANF2 ; rBITS ; SQLITE ; YOU CAN FIND THEM IN DESCRIPTION//
  4. // THANKS TO SA-MP.COM COMUNNITY FOR TUTORIALS AND FOR ITS RESPECTOUS MEMBERS //
  5. #define FILTERSCRIPT
  6. //=======INCLUDES # DEFINES=========//
  7. #include <a_samp>
  8. #include <sscanf2>
  9. #include <rbits>
  10. #include <zcmd>
  11. #define FormatQuery(%0,%1,%2) format((%0), sizeof(%0), (%1), %2)
  12. #define COL_GREEN   "{6EF83C}"
  13. #define COL_RED     "{F81414}"
  14. #define COL_BLUE    "{00C0FF}"
  15. #define SPM         SendClientMessage
  16. #define SPMALL      SendClientMessageToAll
  17. //=======INCLUDES # DEFINES=========//
  18. // ============== NEW ==========//
  19. new AdminON[MAX_PLAYERS];   // ADMIN`s STATE ( ON/OFF JOB(DUTY) )
  20. //=============================//
  21.  
  22. //=======ENUM=======//
  23. new
  24.     Bit1:  g_PlayerLogged       <MAX_PLAYERS>,
  25.     Bit16: g_AdminLevel         <MAX_PLAYERS>,
  26.     Bit16: g_Score              <MAX_PLAYERS>,
  27.     Bit16: g_Kills              <MAX_PLAYERS>,
  28.     Bit16: g_Deaths             <MAX_PLAYERS>,
  29.     Bit16: g_Money              <MAX_PLAYERS>,
  30.     Bit16: g_Respect            <MAX_PLAYERS>,
  31.     Bit16: g_Mute               <MAX_PLAYERS>,
  32.     DB: Database
  33. ;
  34. //====================//
  35. //======FORWARDS=======//
  36.  
  37. //====================//
  38.  
  39. //=====STOCKS=====//
  40. stock DB_Escape(text[])
  41. {
  42.     new
  43.         ret[80 * 2],
  44.         ch,
  45.         i,
  46.         j;
  47.     while ((ch = text[i++]) && j < sizeof (ret))
  48.     {
  49.         if (ch == '\'')
  50.         {
  51.             if (j < sizeof (ret) - 2)
  52.             {
  53.                 ret[j++] = '\'';
  54.                 ret[j++] = '\'';
  55.             }
  56.         }
  57.         else if (j < sizeof (ret))
  58.         {
  59.             ret[j++] = ch;
  60.         }
  61.         else
  62.         {
  63.             j++;
  64.         }
  65.     }
  66.     ret[sizeof (ret) - 1] = '\0';
  67.     return ret;
  68. }
  69. stock GetPlayerIPEx(playerid){
  70.     new IP[24];
  71.     GetPlayerIp(playerid, IP, 24);
  72.     return IP;
  73. }
  74. stock Name(i){
  75.     new n[24];
  76.     GetPlayerName(i,n,24);
  77.     return n;
  78. }
  79. stock IsAnyPlayerInVehicle(vehicleid)
  80. {
  81.     for(new i = 0; i < MAX_PLAYERS; i++) if (IsPlayerInVehicle(vehicleid, i)) return 1;
  82.     return 0;
  83. }
  84. stock pAdminAll(playerid)
  85. {
  86.     if(Bit16_Get(g_AdminLevel,playerid) >= 1)
  87.     {
  88.     }
  89.     else
  90.     {
  91.         SPM(playerid, -1, "NOT "COL_RED"ADMIN");
  92.     }
  93.     return 1;
  94. }
  95. stock pAdmin2(playerid)
  96. {
  97.     if(Bit16_Get(g_AdminLevel,playerid) >= 2)
  98.     {
  99.     }
  100.     else
  101.     {
  102.         SPM(playerid, -1, "NOT "COL_RED"ADMIN");
  103.     }
  104.     return 1;
  105. }
  106. stock pAdmin3(playerid)
  107. {
  108.     if(Bit16_Get(g_AdminLevel,playerid) >= 3)
  109.     {
  110.     }
  111.     else
  112.     {
  113.         SPM(playerid, -1, "NOT "COL_RED"ADMIN");
  114.     }
  115.     return 1;
  116. }
  117. //=====================================================//
  118. #if defined FILTERSCRIPT
  119. public OnFilterScriptInit( )
  120. {
  121.     Database = db_open("Players.db");
  122.     db_free_result(db_query(Database, "CREATE TABLE IF NOT EXISTS `Users` (`IP`,`UserName`,`PlayerPassword`,`PlayerMoney`,`PlayerScore`,`Respect`)"));
  123.     print("\n==============================   SIGNED, Preda ==============================");
  124.     print("==============================   ALL IN ONE SCRIPT ==============================");
  125.     print("==============================   SIGNED, Preda ==============================\n");
  126.     return 1;
  127. }
  128.  
  129. public OnFilterScriptExit( )
  130. {
  131.     db_close(Database);
  132.     return 1;
  133. }
  134. #endif
  135. public OnPlayerConnect(playerid)
  136. {
  137.     new Query[256], DBResult:Result ;
  138.  
  139.     format(Query, sizeof(Query), "SELECT * FROM `Users` WHERE `UserName` = '%s'", Name(playerid));
  140.     Result = db_query(Database,Query);
  141.  
  142.     if(db_num_rows(Result))
  143.         SPM(playerid, ~1, ""COL_BLUE"SQLITE database found you."COL_GREEN"/log "COL_RED"[PASSWORD] in order to "COL_BLUE"LOG IN");
  144.     else
  145.         SPM(playerid, ~1, ""COL_BLUE"SQLITE "COL_RED"didn't found you in our "COL_RED"database./reg [PASSWORD].");
  146.  
  147.     db_free_result(Result);
  148.    
  149.     Bit1_Set(g_PlayerLogged,playerid,false);
  150.     new string[140];
  151.     new name1[MAX_PLAYER_NAME];
  152.     GetPlayerName(playerid, name1, sizeof(name1));
  153.     format(string, sizeof(string), "{FFFFFF}== "COL_RED"!"COL_BLUE"%s "COL_GREEN"[ID: %d] {FFFFFF}joined us"COL_RED"! {FFFFFF}==", name1, playerid);
  154.     SPMALL(0xB8860BAA, string);
  155.     SPM(playerid, -1, ""COL_BLUE"[SQLITE]Use "COL_GREEN"/account In Order To See "COL_BLUE"Your Current Statistics");
  156.    
  157.     return 1;
  158. }
  159.  
  160. public OnPlayerDisconnect(playerid, reason)
  161. {
  162.     if(Bit1_Get(g_PlayerLogged,playerid) == 1)
  163.     {
  164.         new Query[256] ;
  165.         format(Query, sizeof(Query), "UPDATE `Users` SET (`PlayerMoney` = '%d', `PlayerScore` = '%d', `Respect` = '%d') WHERE `UserName` = '%s'",Bit16_Get(g_Money,playerid), Bit16_Get(g_Score,playerid), Bit16_Get(g_Respect,playerid), Name(playerid));
  166.         db_free_result(db_query(Database, Query));
  167.         Bit1_Set(g_PlayerLogged,playerid,false);
  168.     }
  169.     return 1;
  170. }
  171. public OnPlayerDeath(playerid, killerid, reason)
  172. {
  173.     Bit16_Set(g_Kills,killerid,Bit16_Get(g_Kills,killerid)+1);
  174.     Bit16_Set(g_Deaths,playerid,Bit16_Get(g_Deaths,playerid)+1);
  175.     SPM(playerid, -1, ""COL_BLUE"[SQLITE]VARIABLE "COL_RED"`DEATHS` IS INCREASING");
  176.     SPM(killerid, -1, ""COL_BLUE"[SQLITE]VARIABLE "COL_GREEN"`KILLS` IS INCREASING");
  177.     return 1;
  178. }
  179.     //=================================                 ZCMD                ================================================//
  180.  
  181. COMMAND:reg(playerid,params[])
  182. {
  183.     new Query[256], DBResult:Result;
  184.  
  185.     format(Query, sizeof(Query), "SELECT * FROM `Users` WHERE `UserName` = '%s'", Name(playerid));
  186.     Result = db_query(Database,Query);
  187.  
  188.     if(!db_num_rows(Result))
  189.     {
  190.         if(strlen(params))
  191.         {
  192.             if(strlen(params) > 5 && strlen(params) < 24)
  193.             {
  194.                 FormatQuery( Query, "INSERT INTO `Users` (`IP`,`UserName`,`PlayerPassword`,`PlayerMoney`,`PlayerScore`,`Respect`) VALUES('%s','%s','%s','%d','%d','%d')", GetPlayerIPEx(playerid), Name(playerid), params, GetPlayerMoney(playerid), GetPlayerScore(playerid), Bit16_Get(g_Respect,playerid));
  195.                 db_free_result( db_query(Database, Query) );
  196.  
  197.                 SPM(playerid, ~1, ""COL_BLUE"[SQLITE]"COL_GREEN"LOGGED IN NOW /login [PASSWORD]");
  198.                 format(Query, 256, ""COL_BLUE"[SQLITE] YOUR PASSWORD: "COL_GREEN"%s", params);
  199.                 SPM(playerid, ~1, Query);
  200.             }
  201.             else return SPM(playerid, ~1, ""COL_BLUE"[SQLITE] "COL_GREEN"AT LEAST 5 CHARACTERS");
  202.         }
  203.         else return SPM(playerid, ~1, ""COL_BLUE"[SQLITE] "COL_GREEN"CORRECT: /reg [PASSWORD]");
  204.     }
  205.     else return SPM(playerid, ~1, ""COL_BLUE"[SQLITE] "COL_GREEN"/log [PASSWORD]");
  206.     return 1;
  207. }
  208.  
  209. COMMAND:log(playerid,params[])
  210. {
  211.     if(strlen(params))
  212.     {
  213.         new Query[256], DBResult:Result ;
  214.  
  215.         FormatQuery(Query, "SELECT * FROM `Users` WHERE `UserName` = '%s'", Name(playerid));
  216.         Result = db_query(Database,Query);
  217.  
  218.         if(db_num_rows(Result))
  219.         {
  220.             FormatQuery(Query, "SELECT * FROM `Users` WHERE `UserName` = '%s' AND `PlayerPassword` = '%s'", Name(playerid), params);
  221.             Result = db_query(Database,Query);
  222.             if(db_num_rows(Result))
  223.             {
  224.                 new Field[30] ;
  225.  
  226.                 db_get_field_assoc(Result, "PlayerMoney", Field, 30 );
  227.                 Bit16_Set(g_Money,playerid,strval(Field));
  228.  
  229.                 db_get_field_assoc(Result, "PlayerScore", Field, 30 );
  230.                 Bit16_Set(g_Score,playerid,strval(Field));
  231.                
  232.                 db_get_field_assoc(Result, "Respect", Field, 30 );
  233.                 Bit16_Set(g_Respect,playerid,strval(Field));
  234.  
  235.                 ResetPlayerMoney(playerid);
  236.                 GivePlayerMoney(playerid, Bit16_Get(g_Money,playerid));
  237.  
  238.                 SetPlayerScore(playerid, Bit16_Get(g_Score,playerid));
  239.  
  240.                 new Str[129];
  241.                 format(Str, sizeof(Str), ""COL_BLUE"[SQLITE]"COL_GREEN"LOGGED IN - %d MONEY, %d SCORE, %d RESPECT", Bit16_Get(g_Money,playerid), Bit16_Get(g_Score,playerid), Bit16_Get(g_Respect,playerid));
  242.                 SPM(playerid, ~1, Str);
  243.  
  244.                 Bit1_Set(g_PlayerLogged,playerid,true);
  245.             }else SPM(playerid, ~1, ""COL_BLUE"[SQLITE]"COL_GREEN" PASSWORD DOES NOT MATCH");
  246.             db_free_result(Result);
  247.         }
  248.         else
  249.         {
  250.             new Str[129];
  251.             format(Str, sizeof(Str), ""COL_BLUE"[SQLITE]ACCOUNT DOES "COL_RED"NOT EXIST."COL_GREEN"/reg [PASSWORD]", Name(playerid));
  252.             SPM(playerid, ~1, Str);
  253.         }
  254.         db_free_result(Result);
  255.  
  256.     }else SPM(playerid, ~1, ""COL_BLUE"[SQLITE]"COL_GREEN"/log [PASSWORD]");
  257.     return 1;
  258. }
  259.  
  260.     COMMAND:account(playerid,inputtext[])
  261.     {
  262.             // STATS -------------------------//
  263.             new money = Bit16_Get(g_Money, playerid);
  264.             new admin = Bit16_Get(g_AdminLevel, playerid);
  265.             new score = Bit16_Get(g_Score, playerid);
  266.             new killss = Bit16_Get(g_Kills, playerid);
  267.             new deaths = Bit16_Get(g_Deaths, playerid);
  268.             new respectt = Bit16_Get(g_Respect, playerid);
  269.             new string1[400],stats[1500],namestring[50];
  270.             format(string1, sizeof string1, ""COL_GREEN" MONEY: "COL_RED"%d "COL_GREEN"|ADMIN LEVEL : "COL_RED"%d"COL_GREEN"| SCORE: "COL_RED"%d "COL_GREEN"| KILLS: "COL_RED"%d "COL_GREEN"| DEATHS: "COL_RED"%d "COL_GREEN"| RESPECT: "COL_RED" %d", money, admin, score, killss, deaths, respectt);
  271.             format(stats, sizeof stats, "%s", string1);
  272.             format(namestring,sizeof(namestring),""COL_GREEN"Your account, "COL_BLUE"%s",Name(playerid));
  273.             ShowPlayerDialog(playerid,3,DIALOG_STYLE_MSGBOX,namestring,stats,"OK","OK");
  274.  
  275.             // STATS -------------------------//
  276.             return 1;
  277.     }
  278.  
  279.     COMMAND:as(playerid,inputtext[])
  280.     {
  281.         new string[150],name[MAX_PLAYER_NAME],text;
  282.         if(sscanf(inputtext,"u", text))return SPM(playerid, -1, "CORRECT: /as (ADMIN SPEAK) [TEXT]");
  283.         {
  284.             GetPlayerName(playerid, name, sizeof(name));
  285.             format(string, sizeof(string),""COL_BLUE"[%d]"COL_RED"[ID:%d]"COL_GREEN"%s{FFFFFF}:%s",Bit16_Get(g_AdminLevel, playerid),playerid,name,inputtext);
  286.             if(pAdminAll(playerid))
  287.             {
  288.                 SPMALL(-1, string);
  289.                 print(string);
  290.             }
  291.         }
  292.         return 1;
  293.     }
  294.  
  295.     COMMAND:admincmds(playerid, inputtext[])
  296.     {
  297.         if(Bit16_Get(g_AdminLevel, playerid) >= 1)
  298.         {
  299.             SPM(playerid, 0xFFA500FF, "=================================== LEVEL 1 ADMIN COMMANDS ===========================================");
  300.             SPM(playerid, 0xFFA500FF, "|LVL 1|: /to,/here,/adminon,/adminoff,/health,/armour,/ls,/sf,/lv,/(re)spawn,/chatclear |LVL 1|");
  301.             SPM(playerid, 0xFFA500FF, "=================================== LEVEL 2 ADMIN COMMANDS ===========================================");
  302.             SPM(playerid, 0xFFA500FF, "|LVL 2|: /vehicle,/respawncars,/respawncar,healthall,armourall,skin |LVL 2|");
  303.             SPM(playerid, 0xFFA500FF, "=================================== LEVEL 3 ADMIN COMMANDS ===========================================");
  304.             SPM(playerid, 0xFFA500FF, "|LVL 3|: /out(kick),lockacc(ban),/givescore(all),/giveweapon(all),/spy(spectate) |LVL 3|");
  305.         }
  306.         return 1;
  307.     }
  308.  
  309.     COMMAND:spy(playerid, inputtext[])
  310.     {
  311.         new target;
  312.         if(sscanf(inputtext,"u",target))return SPM(playerid, -1, "CORRECT: /spy [playerID/playerNAME]");
  313.         {
  314.             if(target != INVALID_PLAYER_ID && IsPlayerConnected(target))
  315.             {
  316.                 if(pAdmin3(playerid))
  317.                 {
  318.                     PlayerSpectatePlayer(playerid,target);
  319.                     new string[200],string2[200],targetname[MAX_PLAYER_NAME],ip[20];
  320.                     new Float:phealth, Float:parmour;
  321.                     GetPlayerHealth(target,phealth);
  322.                     GetPlayerArmour(target,parmour);
  323.                     GetPlayerName(target,targetname,sizeof(targetname));
  324.                     GetPlayerIp(target,ip,sizeof(ip));
  325.                     format(string,sizeof(string),""COL_BLUE"==ADMIN=="COL_GREEN"%s "COL_BLUE"is now SPECTATING "COL_GREEN"%s",Name(playerid),targetname);
  326.                     format(string2,sizeof(string2),""COL_BLUE"==ADMIN==Spectating "COL_GREEN"%s IP:%d"COL_BLUE",HEALTH:"COL_GREEN"%d,"COL_BLUE"ARMOUR:"COL_GREEN"%d",targetname,ip,phealth,parmour);
  327.                     SPM(playerid,-1,string2);
  328.                     if(pAdminAll(playerid))
  329.                     {
  330.                         SPMALL(-1, string);
  331.                     }
  332.                 }
  333.             }
  334.         }
  335.         return 1;
  336.     }
  337.     COMMAND:spawn(playerid, inputtext[])
  338.     {
  339.         new target;
  340.         if(sscanf(inputtext,"u",target))return SPM(playerid, -1, "CORRECT: /spawn [playerID/playerNAME]");
  341.         {
  342.             if(target != INVALID_PLAYER_ID && IsPlayerConnected(target))
  343.             {
  344.                 if(pAdmin2(playerid))
  345.                 {
  346.                     SpawnPlayer(target);
  347.                     new string[70],string1[70],targetname[MAX_PLAYER_NAME];
  348.                     GetPlayerName(target,targetname,sizeof(targetname));
  349.                     format(string,sizeof(string),""COL_BLUE"==ADMIN=="COL_GREEN"%s "COL_BLUE"SPAWNED YOU",Name(playerid));
  350.                     SPM(target,-1,string);
  351.                     format(string1,sizeof(string1),""COL_BLUE"==ADMIN==You SPAWNED "COL_GREEN"%s",targetname);
  352.                     SPM(playerid, -1, string1);
  353.                 }
  354.             }
  355.         }
  356.         return 1;
  357.     }
  358.  
  359.     COMMAND:giveweapon(playerid, inputtext[])
  360.     {
  361.         new target,weapon;
  362.         if(sscanf(inputtext,"ud",target,weapon))return SPM(playerid, -1, "CORRECT: /giveweapon [playerID/playerNAME] [WEAPON]");
  363.         {
  364.             if(target != INVALID_PLAYER_ID && IsPlayerConnected(target))
  365.             {
  366.                 if(pAdmin3(playerid))
  367.                 {
  368.                     GivePlayerWeapon(target, weapon, 600);
  369.                     new string[90],string1[90],targetname[MAX_PLAYER_NAME];
  370.                     GetPlayerName(target,targetname,sizeof(targetname));
  371.                     format(string,sizeof(string),""COL_BLUE"==ADMIN=="COL_GREEN"%s "COL_BLUE"gave you WEAPON ID "COL_GREEN"%d",Name(playerid),weapon);
  372.                     SPM(target,-1,string);
  373.                     format(string1,sizeof(string1),""COL_BLUE"==ADMIN==You gave "COL_GREEN"%s "COL_BLUE"WEAPON ID "COL_GREEN"%d",targetname,weapon);
  374.                     SPM(playerid,-1,string1);
  375.                 }
  376.                 if(pAdminAll(playerid))
  377.                 {
  378.                         new string2[80],targetname[MAX_PLAYER_NAME];
  379.                         GetPlayerName(target,targetname,sizeof(targetname));
  380.                         format(string2,sizeof(string2),""COL_BLUE"==ADMIN=="COL_GREEN"%s "COL_BLUE"gave "COL_GREEN"%s "COL_BLUE" WEAPON ID "COL_GREEN"%d",Name(playerid),targetname,weapon);
  381.                 }
  382.  
  383.             }
  384.         }
  385.         return 1;
  386.     }
  387.     COMMAND:giveweaponall(playerid, inputtext[])
  388.     {
  389.         new weaponn;
  390.         if(sscanf(inputtext,"u",weaponn))return SPM(playerid, -1, "CORRECT: /giveweaponall [WEAPON ID]");
  391.         {
  392.             if(pAdmin3(playerid))
  393.             {
  394.                 for(new i = 0; i < MAX_PLAYERS; i++)
  395.                 {
  396.                     GivePlayerWeapon(i,weaponn,600);
  397.                 }
  398.                 new string[250];
  399.                 format(string,sizeof(string),""COL_BLUE"==ADMIN=="COL_GREEN"%s "COL_BLUE"GAVE WEAPON "COL_GREEN"%d "COL_BLUE"TO ALL",Name(playerid),weaponn);
  400.                 SPMALL(-1,string);
  401.             }
  402.         }
  403.         return 1;
  404.     }
  405.     COMMAND:givescore(playerid, inputtext[])
  406.     {
  407.         new target,score;
  408.         if(sscanf(inputtext,"ud",target,score))return SPM(playerid, -1, "CORRECT: givescore [playerID/playerNAME] [AMMOUNT]");
  409.         {
  410.             if(target != INVALID_PLAYER_ID && IsPlayerConnected(target))
  411.             {
  412.                 if(pAdmin3(playerid))
  413.                 {
  414.                     SetPlayerScore(target,GetPlayerScore(target)+score);
  415.                     new string[100],string1[100],targetname[MAX_PLAYER_NAME];
  416.                     GetPlayerName(target,targetname,sizeof(targetname));
  417.                     format(string,sizeof(string),""COL_BLUE"==ADMIN=="COL_GREEN"%s "COL_BLUE"gave you "COL_GREEN"%d SCORE",Name(playerid),score);
  418.                     SPM(target,-1,string);
  419.                     format(string1,sizeof(string1),""COL_BLUE"==ADMIN==You gave "COL_GREEN"%s %d SCORE",targetname,score);
  420.                     SPM(playerid,-1,string1);
  421.                     if(pAdminAll(playerid))
  422.                     {
  423.                         new string2[100];
  424.                         format(string2,sizeof(string2),""COL_BLUE"==ADMIN=="COL_GREEN"%s gave %s "COL_BLUE"%d SCORE",Name(playerid),targetname,score);
  425.                         SPMALL(-1, string2);
  426.                     }
  427.                 }
  428.             }
  429.         }
  430.         return 1;
  431.     }
  432.     COMMAND:givescoreall(playerid, inputtext[])
  433.     {
  434.         new score;
  435.         if(sscanf(inputtext,"u",score))return SPM(playerid, -1, "CORRECT: givescoreall [AMMOUNT]");
  436.         {
  437.                 if(pAdmin3(playerid))
  438.                 {
  439.                     for(new i = 0; i < MAX_PLAYERS; i++)
  440.                     {
  441.                         SetPlayerScore(i,GetPlayerScore(i)+score);
  442.                     }
  443.                 }
  444.                 new string[70];
  445.                 format(string,sizeof(string),""COL_BLUE"==ADMIN=="COL_GREEN"%s gave %d "COL_BLUE"SCORE TO ALL",Name(playerid),score);
  446.                 SPMALL(-1,string);
  447.         }
  448.         return 1;
  449.     }
  450.     COMMAND:ls(playerid, inputtext[])
  451.     {
  452.         if(Bit16_Get(g_AdminLevel, playerid) >= 1)
  453.         {
  454.             SetPlayerPos(playerid, 1529.6,-1691.2,13.3);
  455.             SetPlayerInterior(playerid, 0);
  456.         }
  457.         return 1;
  458.     }
  459.  
  460.     COMMAND:lv(playerid, inputtext[])
  461.     {
  462.         if(Bit16_Get(g_AdminLevel, playerid) >= 1)
  463.         {
  464.             SetPlayerPos(playerid, 1699.2,1435.1, 10.7);
  465.             SetPlayerInterior(playerid, 0);
  466.         }
  467.         return 1;
  468.     }
  469.  
  470.     COMMAND:sf(playerid, inputtext[])
  471.     {
  472.         if(Bit16_Get(g_AdminLevel, playerid) >= 1)
  473.         {
  474.             SetPlayerPos(playerid, -1417.0,-295.8,14.1);
  475.             SetPlayerInterior(playerid, 0);
  476.         }
  477.         return 1;
  478.     }
  479.  
  480.  
  481.     COMMAND:adminson(playerid, inputtext[])
  482.     {
  483.         for(new i = 0; i < MAX_PLAYERS; i++)
  484.         {
  485.             if(IsPlayerConnected(i) && pAdminAll(playerid))
  486.             {
  487.                     SPM(playerid, 0xAA3333AA, "== ADMINS ONLINE ==");
  488.                     new string[256];
  489.                     format(string, sizeof(string), "ADMIN %s[ID: %d] ; LEVEL %d ; AVALIABLE = %d", Name(playerid), i, Bit16_Get(g_AdminLevel,i), AdminON[i]);
  490.                     SPM(playerid, 0xB8860BFF, string);
  491.                     SPM(playerid, 0xAA3333AA, "== ADMINS ONLINE ==");
  492.             }
  493.         }
  494.     }
  495.  
  496.     COMMAND:adminon(playerid, inputtext[])
  497.     {
  498.         if(Bit16_Get(g_AdminLevel, playerid) >= 1 && AdminON[playerid] == 0)
  499.         {
  500.             AdminON[playerid] = 1;
  501.             new string[100];
  502.             format(string, sizeof(string), "==ADMIN== %s [ID: %d] IS NOW AVALIABLE, PM HIM ==ADMIN==",Name(playerid), playerid);
  503.             SPM(playerid, 0x33CCFFAA, string);
  504.             SetPlayerArmour(playerid, 10000);
  505.             SetPlayerHealth(playerid, 10000);
  506.             print(string);
  507.         }
  508.     }
  509.  
  510.     COMMAND:punish(playerid, inputtext[])
  511.     {
  512.         new target;
  513.         if(sscanf(inputtext,"u", target))return SPM(playerid, -1, "CORRECT: /punish [playerID/playerNAME]");
  514.         if(target != INVALID_PLAYER_ID && IsPlayerConnected(target))
  515.         {
  516.             if(Bit16_Get(g_AdminLevel, playerid) >= 2)
  517.             {
  518.                 new Float:X,Float:Y,Float:Z;
  519.                 GetPlayerPos(target, X,Y,Z);
  520.                 CreateExplosion(X,Y,Z, 1, 1000);
  521.                 new string[50], targetname[MAX_PLAYER_NAME];
  522.                 GetPlayerName(target, targetname, sizeof(targetname));
  523.                 format(string, sizeof(string), "==ADMIN== %s [ID: %d] HAS PUNISHED %s",Name(playerid), playerid, targetname);
  524.                 if(pAdminAll(playerid))
  525.                 {
  526.                     SPMALL(0x33CCFFAA, string);
  527.                     print(string);
  528.                 }
  529.             }
  530.         }
  531.         return 1;
  532.     }
  533.  
  534.     COMMAND:respawncar(playerid, inputtext[])
  535.     {
  536.         if(Bit16_Get(g_AdminLevel, playerid) >= 1 && IsPlayerInAnyVehicle(playerid))
  537.         {
  538.             SetVehicleToRespawn(GetPlayerVehicleID(playerid));
  539.             new string[70];
  540.             format(string,sizeof(string),""COL_BLUE"==ADMIN=="COL_RED"%s respawned VEHICLE "COL_GREEN"%d",Name(playerid), GetPlayerVehicleID(playerid));
  541.             if(pAdminAll(playerid))
  542.             {
  543.                 SPMALL(-1, string);
  544.                 print(string);
  545.             }
  546.         }
  547.         return 1;
  548.     }
  549.  
  550.  
  551.     COMMAND:to(playerid, inputtext[])
  552.     {
  553.         new target;
  554.         if(sscanf(inputtext,"u",target))return SPM(playerid, -1, "CORRECT: /to [playerID/playerNAME]");
  555.         if(target !=INVALID_PLAYER_ID && IsPlayerConnected(target))
  556.         {
  557.             if(Bit16_Get(g_AdminLevel, playerid) >= 1)
  558.             {
  559.                 new Float:x,Float:y,Float:z;
  560.                 GetPlayerPos(target, x, y, z);
  561.                 SetPlayerPos(playerid, x, y, z);
  562.                 new string[50],string1[50],targetname[MAX_PLAYER_NAME];
  563.                 GetPlayerName(target,targetname,sizeof(targetname));
  564.                 format(string,sizeof(string),""COL_BLUE"==ADMIN==You went TO "COL_GREEN"%s",targetname);
  565.                 SPM(playerid,-1,string);
  566.                 format(string1,sizeof(string1),""COL_BLUE"==ADMIN=="COL_RED"%s "COL_GREEN"went to you",Name(playerid));
  567.                 SPM(target,-1,string1);
  568.                 print(string);
  569.                 print(string1);
  570.             }
  571.         }
  572.         return 1;
  573.     }
  574.  
  575.     COMMAND:here(playerid, inputtext[])
  576.     {
  577.         new target;
  578.         if(sscanf(inputtext,"u",target))return SPM(playerid, -1, "CORRECT: /here [playerID/playerNAME]");
  579.         if(target !=INVALID_PLAYER_ID && IsPlayerConnected(target))
  580.         {
  581.             if(Bit16_Get(g_AdminLevel, playerid) >= 1)
  582.             {
  583.                 new Float:x,Float:y,Float:z;
  584.                 GetPlayerPos(playerid, x, y, z);
  585.                 SetPlayerPos(target, x, y, z);
  586.                 new string[50],string1[50],targetname[MAX_PLAYER_NAME];
  587.                 GetPlayerName(target,targetname,sizeof(targetname));
  588.                 format(string,sizeof(string),""COL_BLUE"==ADMIN==You GOT here "COL_GREEN"%s",targetname);
  589.                 SPM(playerid,-1,string);
  590.                 format(string1,sizeof(string1),""COL_BLUE"==ADMIN=="COL_RED"%s "COL_GREEN"got you here",Name(playerid));
  591.                 SPM(target,-1,string1);
  592.                 print(string);
  593.                 print(string1);
  594.             }
  595.         }
  596.         return 1;
  597.     }
  598.  
  599.     COMMAND:respect(playerid, inputtext[])
  600.     {
  601.         new target;
  602.         if(sscanf(inputtext,"u",target))return SPM(playerid, -1, "CORRECT: /respect [playerID/playerNAME]");
  603.         if(target !=INVALID_PLAYER_ID && IsPlayerConnected(target))
  604.         {
  605.             Bit16_Set(g_Respect,target,Bit16_Get(g_Respect,target)+1);
  606.             new string[90],targetstring[90],targetname[MAX_PLAYER_NAME];
  607.             GetPlayerName(target,targetname,sizeof(targetname));
  608.             format(targetstring,sizeof(targetstring),""COL_BLUE"[SQLITE]YOU GAVE %s "COL_RED"+1 "COL_GREEN"RESPECT.", targetname);
  609.             format(string, sizeof(string),""COL_BLUE"[SQLITE]%s gave you "COL_RED"+1 "COL_GREEN"RESPECT.",Name(playerid));
  610.             SPM(target, -1, string);
  611.             SPM(playerid, -1, targetstring);
  612.             print(string);
  613.             print(targetstring);
  614.         }
  615.         return 1;
  616.     }
  617.  
  618.     COMMAND:chatclear(playerid, inputtext[])
  619.     {
  620.         if(Bit16_Get(g_AdminLevel, playerid) >= 1)
  621.         {
  622.             for(new i = 0; i < 50; i++) SPMALL(-1," ");
  623.             new string[60];
  624.             format(string,sizeof(string),""COL_BLUE" == "COL_RED"%s CLEARED CHAT "COL_BLUE"==",Name(playerid));
  625.             SPMALL(-1, string);
  626.             print(string);
  627.         }
  628.         return 1;
  629.     }
  630.  
  631.     COMMAND:respawncars(playerid, inputtext[])
  632.     {
  633.         if(pAdmin2(playerid))
  634.         for(new car = 0; car < MAX_VEHICLES; car++)
  635.         {
  636.             if(IsAnyPlayerInVehicle(car))
  637.             {
  638.             }
  639.             else
  640.             {
  641.                 SetVehicleToRespawn(car);
  642.             }
  643.         }
  644.         new string[130];
  645.         format(string, sizeof(string), ""COL_BLUE"==ADMIN==  All cars respawned by "COL_RED"%s.", Name(playerid));
  646.         SPMALL(0x33CCFFAA,string);
  647.         print(string);
  648.         return 1;
  649.     }
  650.  
  651.     COMMAND:adminoff(playerid, inputtext[])
  652.     {
  653.         if(Bit16_Get(g_AdminLevel, playerid) >= 1 && AdminON[playerid] == 1)
  654.         {
  655.             AdminON[playerid] = 0;
  656.             new string[100];
  657.             format(string, sizeof(string), "==ADMIN== %s [ID: %d] IS NOW UNAVALIABLE ==ADMIN==",Name(playerid), playerid);
  658.             SPM(playerid, 0x33CCFFAA, string);
  659.             SetPlayerHealth(playerid, 100);
  660.             SetPlayerArmour(playerid, 0);
  661.             print(string);
  662.         }
  663.     }
  664.  
  665.  
  666.     COMMAND:admin(playerid,inputtext[])
  667.     {
  668.  
  669.         new target, alvl;
  670.         if(sscanf(inputtext,"ud",target,alvl))return SPM(playerid,0xff0000FF,"CORRECT: /admin [playerID/NAME] [ADMIN LEVEL]");
  671.         if(target != INVALID_PLAYER_ID && IsPlayerConnected(target))
  672.         {
  673.             if(alvl >= 0 || alvl <=5)
  674.             {
  675.                 if(IsPlayerAdmin(playerid) || Bit16_Get(g_AdminLevel, playerid) == 5)
  676.                 {
  677.                     Bit16_Set(g_AdminLevel,target,alvl);
  678.                     SPM(target, -1 , "PROMOTED TO ADMIN");
  679.                     GameTextForPlayer(target, "~r~PROMOTED TO ~g~ADMIN", 3500, 4);
  680.                 }
  681.                 if(pAdminAll(playerid))
  682.                 {
  683.                     new string[120],targetname[MAX_PLAYER_NAME];
  684.                     GetPlayerName(target,targetname,sizeof(targetname));
  685.                     format(string, sizeof(string), ""COL_BLUE"==ADMIN==%s PROMOTED "COL_RED"%s TO LEVEL "COL_GREEN"%d ADMIN",Name(playerid),targetname,alvl);
  686.                     SPMALL(-1, string);
  687.                     print(string);
  688.                 }
  689.             }
  690.             else SPM(playerid, 0x33CCFFAA, "CORRECT: MAX LEVEL 5 , MIN LEVEL 0");
  691.  
  692.         }
  693.         else  SPM(playerid,0xff0000FF,"Player not CONNECTED !");
  694.         return 1;
  695.     }
  696.  
  697.     COMMAND:out(playerid, inputtext[])
  698.     {
  699.         new target, reason;
  700.         if(sscanf(inputtext,"ud",target,reason))return SPM(playerid, 0xff0000FF,"CORRECT: /out (KICK) [playerID/NAME] [REASON]");
  701.         {
  702.             if(target != INVALID_PLAYER_ID && IsPlayerConnected(target))
  703.             {
  704.                 if(pAdmin3(playerid))
  705.                 {
  706.                     new string[130],targetname[MAX_PLAYER_NAME];
  707.                     GetPlayerName(target,targetname,sizeof(targetname));
  708.                     format(string,sizeof(string), ""COL_GREEN"==ADMIN=="COL_BLUE"%s HAS "COL_RED"KICKED "COL_GREEN"%s FOR: "COL_BLUE"%s", Name(playerid), targetname, reason);
  709.                     SPMALL(-1,string);
  710.                     Kick(target);
  711.                     print(string);
  712.                 }
  713.             }
  714.         }
  715.         return 1;
  716.     }
  717.     COMMAND:lockacc(playerid, inputtext[])
  718.     {
  719.         new target, reason;
  720.         if(sscanf(inputtext,"ud",target,reason))return SPM(playerid, 0xff0000FF,"CORRECT: /lockacc(BAN) [playerID/NAME] [REASON]");
  721.         {
  722.             if(target != INVALID_PLAYER_ID && IsPlayerConnected(target))
  723.             {
  724.                 if(pAdmin3(playerid))
  725.                 {
  726.                     new string[130],targetname[MAX_PLAYER_NAME];
  727.                     GetPlayerName(target,targetname,sizeof(targetname));
  728.                     format(string,sizeof(string), ""COL_GREEN"==ADMIN=="COL_BLUE"%s HAS "COL_RED"BANNED "COL_GREEN"%s FOR: "COL_BLUE"%s", Name(playerid), targetname, reason);
  729.                     SPMALL(-1,string);
  730.                     Ban(target);
  731.                     print(string);
  732.                 }
  733.             }
  734.         }
  735.         return 1;
  736.     }
  737.  
  738.     COMMAND:health(playerid, inputtext[])
  739.     {
  740.         new target, health;
  741.         if(sscanf(inputtext,"ud",target, health))return SPM(playerid, -1,"CORRECT: /health [playerID/playerNAME][HEALTH]");
  742.         if(target != INVALID_PLAYER_ID && IsPlayerConnected(target))
  743.         {
  744.             if(pAdminAll(playerid))
  745.             {
  746.                 SetPlayerHealth(target, health);
  747.                 new string[50],string1[50],targetname[MAX_PLAYER_NAME];
  748.                 GetPlayerName(target,targetname,sizeof(targetname));
  749.                 format(string,sizeof(string), ""COL_BLUE"==ADMIN==%s "COL_GREEN"set your health to "COL_RED"%d",Name(playerid), health);
  750.                 SPM(target, -1, string);
  751.                 format(string1,sizeof(string1), ""COL_BLUE"==ADMIN==You set "COL_RED"%s"COL_GREEN"'s health to "COL_RED"%d",targetname,health);
  752.                 SPM(playerid, -1, string1);
  753.                 print(string);
  754.                 print(string1);
  755.  
  756.             }
  757.         }
  758.         else SPM(playerid, 0x33CCFFAA, "PLAYER not CONNECTED !");
  759.         return 1;
  760.  
  761.     }
  762.     COMMAND:healthall(playerid, inputtext[])
  763.     {
  764.         if(pAdmin2(playerid))
  765.         {
  766.             for(new i = 0; i < MAX_PLAYERS; i++)
  767.             {
  768.                 SetPlayerHealth(i, 100);
  769.             }
  770.             new string[65];
  771.             format(string,sizeof(string),""COL_BLUE"==ADMIN==%s gave "COL_RED"everyone "COL_GREEN"HEALTH",Name(playerid));
  772.             SPMALL(-1, string);
  773.             print(string);
  774.         }
  775.         return 1;
  776.     }
  777.  
  778.     COMMAND:armour(playerid, inputtext[])
  779.     {
  780.         new target, armour;
  781.         if(sscanf(inputtext,"ud",target, armour))return SendClientMessage(playerid, -1,"CORRECT: /armour [playerID/playerNAME][ARMOUR]");
  782.         if(target != INVALID_PLAYER_ID && IsPlayerConnected(target))
  783.         {
  784.             if(pAdminAll(playerid))
  785.             {
  786.                 SetPlayerArmour(target, armour);
  787.                 new string[50],string1[50],targetname[MAX_PLAYER_NAME];
  788.                 GetPlayerName(target,targetname,sizeof(targetname));
  789.                 format(string,sizeof(string), ""COL_BLUE"==ADMIN==%s "COL_GREEN"set your ARMOUR to "COL_RED"%d",Name(playerid), armour);
  790.                 SPM(target, -1, string);
  791.                 format(string1,sizeof(string1), ""COL_BLUE"==ADMIN==You set "COL_RED"%s"COL_GREEN"'s ARMOUR to "COL_RED"%d",targetname, armour);
  792.                 SPM(playerid, -1, string1);
  793.                 print(string);
  794.                 print(string1);
  795.             }
  796.         }
  797.         else SendClientMessage(playerid, 0x33CCFFAA, "PLAYER not CONNECTED !");
  798.         return 1;
  799.  
  800.     }
  801.  
  802.     COMMAND:armourall(playerid, inputtext[])
  803.     {
  804.         if(pAdmin2(playerid))
  805.         {
  806.             for(new i = 0; i < MAX_PLAYERS; i++)
  807.             {
  808.                 SetPlayerArmour(i,100);
  809.             }
  810.             new string[65];
  811.             format(string,sizeof(string),""COL_BLUE"==ADMIN==%s gave "COL_RED"everyone "COL_GREEN"ARMOUR",Name(playerid));
  812.             SPMALL(-1, string);
  813.             print(string);
  814.         }
  815.         return 1;
  816.     }
  817.  
  818.     COMMAND:vehicle(playerid, inputtext[])
  819.     {
  820.         new vehicleidd;
  821.         if(sscanf(inputtext,"u",vehicleidd)) return SendClientMessage(playerid, -1, "CORRECT: /vehicle [VEHICLE ID]");
  822.         {
  823.             if(vehicleidd >= 400 || vehicleidd <= 611) return SendClientMessage(playerid, -1, ""COL_BLUE"INVALID "COL_GREEN"MODEL");
  824.             {
  825.                 if(pAdmin2(playerid))
  826.                 {
  827.                     new Float:x, Float:y, Float:z;
  828.                     GetPlayerPos(playerid, x, y, z);
  829.                     CreateVehicle(vehicleidd, x+2, y+2, z, 90.0, 0, 2, 2);
  830.                     new string[70];
  831.                     format(string, sizeof(string), ""COL_BLUE"==ADMIN==%s spawned VEH ID "COL_GREEN"%d",Name(playerid),vehicleidd);
  832.                     if(pAdminAll(playerid))
  833.                     {
  834.                         SPMALL(-1, string);
  835.                         print(string);
  836.                     }
  837.                 }
  838.             }
  839.         }
  840.         return 1;
  841.     }
  842.  
  843.     COMMAND:skin(playerid, inputtext[])
  844.     {
  845.         new target,skin;
  846.         if(sscanf(inputtext,"ud",target,skin)) return SPM(playerid, -1, "CORRECT: /skin [playerID/playerNAME] [skinID]");
  847.         {
  848.             if(target != INVALID_PLAYER_ID && IsPlayerConnected(target))
  849.             {
  850.                 if(pAdmin2(playerid))
  851.                 {
  852.                     SetPlayerSkin(target,skin);
  853.                     new string[70],string1[70],targetname[MAX_PLAYER_NAME];
  854.                     GetPlayerName(target,targetname,sizeof(targetname));
  855.                     format(string,sizeof(string),""COL_BLUE"==ADMIN=="COL_GREEN"%s "COL_BLUE"set your SKIN to "COL_RED"%d",Name(playerid),skin);
  856.                     SPM(target,-1,string);
  857.                     format(string1,sizeof(string1),""COL_BLUE"==ADMIN==You SET "COL_GREEN"%s"COL_BLUE"'s SKIN to "COL_GREEN"%d",targetname,skin);
  858.                     SPM(playerid, -1, string1);
  859.                 }
  860.             }
  861.         }
  862.         return 1;
  863.     }
  864.  
  865.  
  866.  
  867.     //=================================                 ZCMD                ================================================//
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!