Advertisement
Guest User

Ban for Mysql??

a guest
Jun 25th, 2014
275
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C++ 8.92 KB | None | 0 0
  1. //this are the table with problem
  2. mysql_query("CREATE TABLE IF NOT EXISTS `Bans`(`id` int(10) NOT NULL auto_increment PRIMARY KEY, `Nick` varchar(25) NOT NULL, `UserIP` varchar(30) NOT NULL, `Admin` varchar(25) NOT NULL, `Time` varchar(30) NOT NULL, `Hours` int(10) NOT NULL, `Reason` varchar(128) NOT NULL, `Unix` int(56) NOT NULL default '0')");
  3.  
  4.  
  5. //insert info format
  6. format(query, sizeof(query), "INSERT INTO `Bans` (`Nick`, `UserIP`, `Admin`, `Time`, `Reason`, `Unix`) VALUES('%s', '%s', '%s', '%s', '%d/%d/%d %d:%d:%d', '%d', '%d', '%d', '%s', '%d')", receivername, receiverip, sendername, dayss, monthss, yearss, hourss, minutess, secondss, reason, 999999999999999999999999);//this(codes) are in script of /ban cmd
  7. format(query, sizeof(query), "INSERT INTO `Bans` (`Username`, `UserIP`, `Admin`, `Time`, `Hours`, `Reason`, `Unix`) VALUES('%s', '%s', '%s', '%s', '%d/%d/%d %d:%d:%d', '%d', '%s', '%d')", receivername, receiverip, sendername, dayss, monthss, yearss, hourss, minutess, secondss, hours, reason, calculation);//and this is in tempban
  8.  
  9. //please fix all of these cmds
  10. }
  11. CMD:ban(playerid, params[])
  12. {
  13.     #pragma unused params
  14.     new giveplayerid, reason[50], string[256], query[256], sendername[256], receivername[256], receiverip[30];
  15.     if(PlayerInfo[playerid][Level] >= 2)
  16.     {
  17.         if(sscanf(params, "us[50]", giveplayerid, reason)) return SendClientMessage(playerid, C_LIME, "[USAGE] "cwhite"/ban [playerid/name] [reason]");
  18.             if(giveplayerid == INVALID_PLAYER_ID)
  19.             {
  20.                 GetPlayerName(playerid, sendername, sizeof(sendername));
  21.                 GetPlayerName(giveplayerid, receivername, sizeof(receivername));
  22.                 GetPlayerIp(giveplayerid, receiverip, sizeof(receiverip));
  23.                 format(string,sizeof(string),"%s has been banned by Administrator %s.", receivername ,sendername);
  24.                 SendClientMessageToAll(red,string);
  25.                 format(string,sizeof(string),"[Reason: %s]", reason);
  26.                 SendClientMessageToAll(red,string);
  27.                 new hourss, minutess, secondss;
  28.                 gettime(hourss, minutess, secondss);
  29.                 new dayss, monthss, yearss;
  30.                 getdate(yearss, monthss, dayss);
  31.                 format(query, sizeof(query), "INSERT INTO `Bans` (`Nick`, `UserIP`, `Admin`, `Time`, `Reason`, `Unix`) VALUES('%s', '%s', '%s', '%s', '%d/%d/%d %d:%d:%d', '%d', '%d', '%d', '%s', '%d')", receivername, receiverip, sendername, dayss, monthss, yearss, hourss, minutess, secondss, reason, 999999999999999999999999);
  32.                 mysql_query(query);
  33.             } else return SCM(playerid, red, "[ERROR] "cwhite"Player Is not connected");
  34.     } else return SCM(playerid, red, "[ERROR] "cwhite"Only Level 2+ Admins can ban players.");
  35.     return 1;
  36. }
  37. //=============
  38. CMD:tban(playerid, params[])
  39. {
  40.     #pragma unused params
  41.     new giveplayerid, hoursz, reason[128], string[150], query[256], sendername[256], receivername[256], receiverip[30];
  42.     if(PlayerInfo[playerid][Level] >= 2)
  43.     {
  44.         if(sscanf(params, "uds[128]", giveplayerid, hoursz, reason)) return SendClientMessage(playerid, C_LIME, "[USAGE] "cwhite"/tban [playerid/name] [hours] [reason]");
  45.         if(giveplayerid == INVALID_PLAYER_ID)
  46.         {
  47.             new chours = hours*3600;
  48.             new calculation = gettime() + chours;
  49.             GetPlayerName(playerid, sendername, sizeof(sendername));
  50.             GetPlayerName(giveplayerid, receivername, sizeof(receivername));
  51.             GetPlayerIp(giveplayerid, receiverip, sizeof(receiverip));
  52.             format(string,sizeof(string),"%s has been temporarily banned by Administrator %s for %d hours.", receivername ,sendername, hoursz);
  53.             SendClientMessageToAll(red,string);
  54.             format(string,sizeof(string),"[Reason: %s]", reason);
  55.             SendClientMessageToAll(red,string);
  56.             new hourss, minutess, secondss;
  57.             gettime(hourss, minutess, secondss);
  58.             new dayss, monthss, yearss;
  59.             getdate(yearss, monthss, dayss);
  60.             format(query, sizeof(query), "INSERT INTO `Bans` (`Username`, `UserIP`, `Admin`, `Time`, `Hours`, `Reason`, `Unix`) VALUES('%s', '%s', '%s', '%s', '%d/%d/%d %d:%d:%d', '%d', '%s', '%d')", receivername, receiverip, sendername, dayss, monthss, yearss, hourss, minutess, secondss, hours, reason, calculation);
  61.             mysql_query(query);
  62.         } else return SCM(playerid, red, "[ERROR] "cwhite"Player Is not connected");
  63.     } else return SCM(playerid, red, "[ERROR] "cwhite"Only Level 2+ Admins can ban players.");
  64.     return 1;
  65. }
  66. //===========
  67. CMD:rban(playerid,params[]) {
  68.     if(PlayerInfo[playerid][LoggedIn] == 1) {
  69.         if(PlayerInfo[playerid][Level] >= 4) {
  70.             new ip[128], tmp[256], tmp2[256], Index;        tmp = strtok(params,Index), tmp2 = strtok(params,Index);
  71.             if(!strlen(params)) return SendClientMessage(playerid, dred, "[LBAN]: /rban [playerid] [reason]");
  72.             if(!strlen(tmp2)) return SendClientMessage(playerid, dred, "[LBAN]: /rban [playerid] [reason]");
  73.             new player1, playername[MAX_PLAYER_NAME], adminname[MAX_PLAYER_NAME], string[128];
  74.             player1 = strval(tmp);
  75.  
  76.                 if(IsPlayerConnected(player1) && player1 != INVALID_PLAYER_ID && player1 != playerid && (PlayerInfo[player1][Level] != ServerInfo[MaxAdminLevel]) ) {
  77.                 new name[128];
  78.                 new str[128];
  79.                 GetPlayerName(player1, name, 16);
  80.                 format(str,sizeof(str),"[LBAN]: %s Attempted to Range Banned You.",GetName(playerid));
  81.                 if(!strcmp(name, "WildCat", true) || !strcmp(name, "Srinabh", true)) return SCM(playerid,red,"[LBAN]: You cannot use this command on him bitch.") && SCM(player1,dred,str);
  82.                 GetPlayerName(player1, playername, sizeof(playername)); GetPlayerName(playerid, adminname, sizeof(adminname));
  83.                 new year,month,day,hour,minuite,second; getdate(year, month, day); gettime(hour,minuite,second);
  84.                 CMDMessageToAdmins(playerid,"RBAN");
  85.                 format(string,sizeof(string),"%s has been range banned by Administrator %s.",playername,adminname);
  86.                 SendClientMessageToAll(red,string);
  87.                 format(string,sizeof(string),"[ Reason: %s ]",params[2]);
  88.                 SendClientMessageToAll(red,string);
  89.                 SaveToFile("LBanLog",string);
  90.                 print(string);
  91.                 if(udb_Exists(PlayerName2(player1)) && PlayerInfo[player1][LoggedIn] == 1) dUserSetINT(PlayerName2(player1)).("banned",1);
  92.                 GetPlayerIp(player1,ip,sizeof(ip));
  93.                 strdel(ip,strlen(ip)-2,strlen(ip));
  94.                 format(ip,128,"%s**",ip);
  95.                 format(ip,128,"banip %s",ip);
  96.                 SendRconCommand(ip);
  97.                 Kick(player1);
  98.                 return 1;
  99.                 } else return SendClientMessage(playerid, red, "Player is not connected or is yourself or is the highest level admin");
  100.         } else return SendClientMessage(playerid,red,"ERROR: You are not a high enough level to use this command");
  101.     } else return SendClientMessage(playerid,red,"ERROR: You must be logged in to use this commands");
  102. }
  103. //===================
  104. CMD:addban(playerid,params[]) {
  105.     if(PlayerInfo[playerid][Level] >= 4) {
  106.         new Name[50], Reason[128], string[128];
  107.         if(sscanf(params,"s[50]s[200]",Name, Reason)) return SendClientMessage(playerid,dred,"[LBAN]: /Addban [Correct Name] [Correct Reason]");
  108.         CMDMessageToAdmins(playerid,"ADDBAN");
  109.         LAddBan(playerid,Name,Reason);
  110.         format(string,sizeof(string),"[LBAN] %s has been Offline Banned by %s.",Name,GetName(playerid));
  111.         MessageToAdmins(red,string);
  112.         SaveToFile("LBanLog",string);
  113.         SCM(playerid,green,"*Banned Added.");
  114.     }
  115.     else SendClientMessage(playerid,dred,"*You need to be Level 4+ to use this command.");
  116.     return 1;
  117. }
  118. //============
  119. //please fix all these cmds so the banned player data enter to mysql
  120.  
  121. //====================================Stock search ban==========
  122. stock LSEARCHBAN(playerid,Varq[])
  123. {
  124.     if(!dini_Exists(Varq))
  125.         return SendClientMessage(playerid, red,"No Results.");
  126.  
  127.     new Str[300];
  128.     format(Str,300,"Nickname: %s | IP: %s | Reason: %s",dini_Get(Varq,"Nick") ,dini_Get(Varq,"IP"),dini_Get(Varq,"Reason"));
  129.  
  130.     SCM(playerid,red,Str);
  131.     return 1;
  132. }
  133. //===================cmd:sban
  134. CMD:searchban(playerid,params[]) {
  135.     if(PlayerInfo[playerid][LoggedIn] == 1) {
  136.         if(PlayerInfo[playerid][Level] >= 1) {
  137.         new string[42],nickname[50];
  138.         if(sscanf(params, "s[50]s[48]", nickname)) return SCM(playerid, dred, "[LBAN]: /Searchban (New String)");
  139.             CMDMessageToAdmins(playerid,"SEARCHBAN");
  140.             format(string,sizeof(string),"/ladmin/bans/%s.ini", nickname);
  141.             return LSEARCHBAN(playerid,string);
  142.         } else return SendClientMessage(playerid,dred,"ERROR: You are not a high enough level to use this command");
  143.     } else return SendClientMessage(playerid,red,"ERROR: You must be logged in to use this commands");
  144. }
  145.  
  146. CMD:sban(playerid,params[]) {
  147.     return cmd_searchban(playerid, params);
  148. }
  149. //=============and this cmd also not work please insert info and modify the table please in reward i will give you this scripttttt
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement