Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //this are the table with problem
- 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')");
- //insert info format
- 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
- 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
- //please fix all of these cmds
- }
- CMD:ban(playerid, params[])
- {
- #pragma unused params
- new giveplayerid, reason[50], string[256], query[256], sendername[256], receivername[256], receiverip[30];
- if(PlayerInfo[playerid][Level] >= 2)
- {
- if(sscanf(params, "us[50]", giveplayerid, reason)) return SendClientMessage(playerid, C_LIME, "[USAGE] "cwhite"/ban [playerid/name] [reason]");
- if(giveplayerid == INVALID_PLAYER_ID)
- {
- GetPlayerName(playerid, sendername, sizeof(sendername));
- GetPlayerName(giveplayerid, receivername, sizeof(receivername));
- GetPlayerIp(giveplayerid, receiverip, sizeof(receiverip));
- format(string,sizeof(string),"%s has been banned by Administrator %s.", receivername ,sendername);
- SendClientMessageToAll(red,string);
- format(string,sizeof(string),"[Reason: %s]", reason);
- SendClientMessageToAll(red,string);
- new hourss, minutess, secondss;
- gettime(hourss, minutess, secondss);
- new dayss, monthss, yearss;
- getdate(yearss, monthss, dayss);
- 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);
- mysql_query(query);
- } else return SCM(playerid, red, "[ERROR] "cwhite"Player Is not connected");
- } else return SCM(playerid, red, "[ERROR] "cwhite"Only Level 2+ Admins can ban players.");
- return 1;
- }
- //=============
- CMD:tban(playerid, params[])
- {
- #pragma unused params
- new giveplayerid, hoursz, reason[128], string[150], query[256], sendername[256], receivername[256], receiverip[30];
- if(PlayerInfo[playerid][Level] >= 2)
- {
- if(sscanf(params, "uds[128]", giveplayerid, hoursz, reason)) return SendClientMessage(playerid, C_LIME, "[USAGE] "cwhite"/tban [playerid/name] [hours] [reason]");
- if(giveplayerid == INVALID_PLAYER_ID)
- {
- new chours = hours*3600;
- new calculation = gettime() + chours;
- GetPlayerName(playerid, sendername, sizeof(sendername));
- GetPlayerName(giveplayerid, receivername, sizeof(receivername));
- GetPlayerIp(giveplayerid, receiverip, sizeof(receiverip));
- format(string,sizeof(string),"%s has been temporarily banned by Administrator %s for %d hours.", receivername ,sendername, hoursz);
- SendClientMessageToAll(red,string);
- format(string,sizeof(string),"[Reason: %s]", reason);
- SendClientMessageToAll(red,string);
- new hourss, minutess, secondss;
- gettime(hourss, minutess, secondss);
- new dayss, monthss, yearss;
- getdate(yearss, monthss, dayss);
- 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);
- mysql_query(query);
- } else return SCM(playerid, red, "[ERROR] "cwhite"Player Is not connected");
- } else return SCM(playerid, red, "[ERROR] "cwhite"Only Level 2+ Admins can ban players.");
- return 1;
- }
- //===========
- CMD:rban(playerid,params[]) {
- if(PlayerInfo[playerid][LoggedIn] == 1) {
- if(PlayerInfo[playerid][Level] >= 4) {
- new ip[128], tmp[256], tmp2[256], Index; tmp = strtok(params,Index), tmp2 = strtok(params,Index);
- if(!strlen(params)) return SendClientMessage(playerid, dred, "[LBAN]: /rban [playerid] [reason]");
- if(!strlen(tmp2)) return SendClientMessage(playerid, dred, "[LBAN]: /rban [playerid] [reason]");
- new player1, playername[MAX_PLAYER_NAME], adminname[MAX_PLAYER_NAME], string[128];
- player1 = strval(tmp);
- if(IsPlayerConnected(player1) && player1 != INVALID_PLAYER_ID && player1 != playerid && (PlayerInfo[player1][Level] != ServerInfo[MaxAdminLevel]) ) {
- new name[128];
- new str[128];
- GetPlayerName(player1, name, 16);
- format(str,sizeof(str),"[LBAN]: %s Attempted to Range Banned You.",GetName(playerid));
- 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);
- GetPlayerName(player1, playername, sizeof(playername)); GetPlayerName(playerid, adminname, sizeof(adminname));
- new year,month,day,hour,minuite,second; getdate(year, month, day); gettime(hour,minuite,second);
- CMDMessageToAdmins(playerid,"RBAN");
- format(string,sizeof(string),"%s has been range banned by Administrator %s.",playername,adminname);
- SendClientMessageToAll(red,string);
- format(string,sizeof(string),"[ Reason: %s ]",params[2]);
- SendClientMessageToAll(red,string);
- SaveToFile("LBanLog",string);
- print(string);
- if(udb_Exists(PlayerName2(player1)) && PlayerInfo[player1][LoggedIn] == 1) dUserSetINT(PlayerName2(player1)).("banned",1);
- GetPlayerIp(player1,ip,sizeof(ip));
- strdel(ip,strlen(ip)-2,strlen(ip));
- format(ip,128,"%s**",ip);
- format(ip,128,"banip %s",ip);
- SendRconCommand(ip);
- Kick(player1);
- return 1;
- } else return SendClientMessage(playerid, red, "Player is not connected or is yourself or is the highest level admin");
- } else return SendClientMessage(playerid,red,"ERROR: You are not a high enough level to use this command");
- } else return SendClientMessage(playerid,red,"ERROR: You must be logged in to use this commands");
- }
- //===================
- CMD:addban(playerid,params[]) {
- if(PlayerInfo[playerid][Level] >= 4) {
- new Name[50], Reason[128], string[128];
- if(sscanf(params,"s[50]s[200]",Name, Reason)) return SendClientMessage(playerid,dred,"[LBAN]: /Addban [Correct Name] [Correct Reason]");
- CMDMessageToAdmins(playerid,"ADDBAN");
- LAddBan(playerid,Name,Reason);
- format(string,sizeof(string),"[LBAN] %s has been Offline Banned by %s.",Name,GetName(playerid));
- MessageToAdmins(red,string);
- SaveToFile("LBanLog",string);
- SCM(playerid,green,"*Banned Added.");
- }
- else SendClientMessage(playerid,dred,"*You need to be Level 4+ to use this command.");
- return 1;
- }
- //============
- //please fix all these cmds so the banned player data enter to mysql
- //====================================Stock search ban==========
- stock LSEARCHBAN(playerid,Varq[])
- {
- if(!dini_Exists(Varq))
- return SendClientMessage(playerid, red,"No Results.");
- new Str[300];
- format(Str,300,"Nickname: %s | IP: %s | Reason: %s",dini_Get(Varq,"Nick") ,dini_Get(Varq,"IP"),dini_Get(Varq,"Reason"));
- SCM(playerid,red,Str);
- return 1;
- }
- //===================cmd:sban
- CMD:searchban(playerid,params[]) {
- if(PlayerInfo[playerid][LoggedIn] == 1) {
- if(PlayerInfo[playerid][Level] >= 1) {
- new string[42],nickname[50];
- if(sscanf(params, "s[50]s[48]", nickname)) return SCM(playerid, dred, "[LBAN]: /Searchban (New String)");
- CMDMessageToAdmins(playerid,"SEARCHBAN");
- format(string,sizeof(string),"/ladmin/bans/%s.ini", nickname);
- return LSEARCHBAN(playerid,string);
- } else return SendClientMessage(playerid,dred,"ERROR: You are not a high enough level to use this command");
- } else return SendClientMessage(playerid,red,"ERROR: You must be logged in to use this commands");
- }
- CMD:sban(playerid,params[]) {
- return cmd_searchban(playerid, params);
- }
- //=============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