Login

Raweresh · 03.12.2014, 22:56

Description

It's temporary bans system using mysql database.
There is few commands:

/B <Player's id / Part of player's name> <Ban type (1 - 3)> <Time in days> <Reason>.
/Bname <Player's name> <Time in days> <Reason>.
/Bip <Player's ip> <Time in days> <Reason>.
/Bserial <Player's serial> <Time in days> <Reason>.
/Ub <Unban type (1 - 3)> <Name, ip or serial>.

And some console commands:

B <Player's id / Part of player's name> <Ban type (1 - 3)> <Time in days> <Reason>.
Bname <Player's name> <Time in days> <Reason>.
Bip <Player's ip> <Time in days> <Reason>.
Bserial <Player's serial> <Time in days> <Reason>.
Ub <Unban type (1 - 3)> <Name, ip or serial>.

Ban types:

Only ip.
Ip and serial.
Name, ip and serial.

Unban types:

Name.
Ip.
Serial.

Requirements

mysql R39-2 or newer by BlueG, click here for thread or use that one from package.
sscanf 2.8.1 or newer by ******, click here for thread or use that one from package.
zcmd 0.3.1 or newer by Zeex, click here for thread or use that one from package.

Installation

Put TBS.amx in filterscripts folder.
Put a_mysql.inc in pawno\include folder.
Put libmysql.inc in main folder.
Put mysql.dll in plugins folder.
Put sscanf.dll in plugins folder.
Put sscanf2.inc in pawno\include folder.
Put zcmd.inc in pawno\include folder.

Temporary Bans System

Here is create table query.

Код:

CREATE TABLE TBS (BannedName INT(24) NOT NULL,BannedIp CHAR(16) NOT NULL,BannedSerial CHAR(128) NOT NULL,BannerName CHAR(24) NOT NULL,Time INT(10) NOT NULL,Reason CHAR(128) NOT NULL,DateImposition CHAR(64) NOT NULL) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;

Of course you can or even need to change something in that query but i can't help you with that because i don't know what kind of phpMyAdmin and MySQL version you use.

Natives

Код:

native gpci(playerid,serial[],maxlen);

Definitions

Код:

#define TBS_MAXIMAL_BANNED_NAME 24
#define TBS_MAXIMAL_BANNED_IP 16
#define TBS_MAXIMAL_BANNED_SERIAL 128
#define TBS_MAXIMAL_BANNER_NAME 24
#define TBS_MAXIMAL_REASON 128
#define TBS_MAXIMAL_DATE_IMPOSITION 64
#define TBS_MYSQL_HOST "127.0.0.1"
#define TBS_MYSQL_USER "TBS"
#define TBS_MYSQL_DATABASE "TBS"
#define TBS_MYSQL_PASSWORD "TBS"
#define TBS_COLOR_GREEN 0x00FF00FF
#define TBS_COLOR_RED 0xFF0000FF

Change TBS_MYSQL_HOST, TBS_MYSQL_USER, TBS_MYSQL_DATABASE, TBS_MYSQL_PASSWORD to yours mysql connect informations.

Screenshots