Gag System ( SQL connection )
Posted: Wed Sep 06, 2017 8:13 pm
Our new Gag system is UP and Currently Active on the server, sorry for the late post, but i couldn't post early, i had some work to do and yeah 
..
i will put the plugin here as soon as i get home, .amxx and .sma files with binaries.
gag menu looks like this: added menu time for gag :
5min, 10, 20, 40, 1hour, 2, 1day, 2, 3, 4, 5, 6, 1 week.
Menu can be opened with the following command: amx_gagmenu
you can write custom time, for as long as you want with writing whole the command manually in the console: amx_gag "name" "time IN MINUTES" "reason"
60 = 1 hour / 1440 = 1 day / 10080 = 1 week / you can count now it's all guaranteed to work smooth, everything is getting saved in database ( MySQL server ) can't dodge gag, no more bugs when you gag someone others wont be gagged again.
Installation:
after unzipping the plugin to it's place and add it to plugins.ini you must open sql.cfg which is located in folder " configs " and make the connection to database no matter how it's called the DB you make just point it on the " sql.cfg "
HOST:
DB USER:
DB PASS:
DB:
after making the connection in " sql.cfg " open your database and query this code:
Required MODULES:
unix Binaries is added in rar file, the others you must have them by default.
Admin Commands:
If there is any kind of problem with it Please write me PM or here I'll help.
Credits to:
Saad
Black Panther
Helped with the tests.
Edit, Plugin added.
>>> Download <<<
..i will put the plugin here as soon as i get home, .amxx and .sma files with binaries.
gag menu looks like this: added menu time for gag :
5min, 10, 20, 40, 1hour, 2, 1day, 2, 3, 4, 5, 6, 1 week.
Menu can be opened with the following command: amx_gagmenu
you can write custom time, for as long as you want with writing whole the command manually in the console: amx_gag "name" "time IN MINUTES" "reason"
60 = 1 hour / 1440 = 1 day / 10080 = 1 week / you can count now it's all guaranteed to work smooth, everything is getting saved in database ( MySQL server ) can't dodge gag, no more bugs when you gag someone others wont be gagged again.
Installation:
after unzipping the plugin to it's place and add it to plugins.ini you must open sql.cfg which is located in folder " configs " and make the connection to database no matter how it's called the DB you make just point it on the " sql.cfg "
HOST:
DB USER:
DB PASS:
DB:
after making the connection in " sql.cfg " open your database and query this code:
Code: Select all
CREATE TABLE IF NOT EXISTS `amx_gag` (
`id` int(11) NOT NULL auto_increment,
`player_name` varchar(33) NOT NULL,
`player_ip` varchar(18) NOT NULL,
`time` int(11) NOT NULL,
`reason` varchar(128) NOT NULL,
`admin_name` varchar(33) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;Code: Select all
#include <engine>
#include <unixtime>
#include <sqlx> Admin Commands:
Code: Select all
amx_gag - "Nick" "Time" "Reason"
amx_ungag - "IP of the persen whose Gagged"
amx_gagmenu - Opens the Menu
amx_gag_clean - Cleans the Database " All Gags clear " accessable by admins who's have RCON access.Credits to:
Saad
Black Panther
Helped with the tests.
Edit, Plugin added.
>>> Download <<<
GagSystem (SQL).rar- (25.92 KiB) Downloaded 214 times
