Gag System ( SQL connection )

[The Pro]

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:

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 ;

Required MODULES:

Code: Select all

#include <engine>
#include <unixtime>
#include <sqlx> 

unix Binaries is added in rar file, the others you must have them by default.

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.

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 <<<

GagSystem (SQL).rar

(25.92 KiB) Downloaded 214 times

[Maverick]

Try it as soon as possible and share if works the way it is supposed to be.

[The Pro]

Mav it's working as it supposed to be, we already tested it as i mention on my 1-st post with Saad and Black Panther.

[LC`]

JEEEEZ I WANTED THIS SO MUCH, i love gaging <3.....especialy when its working properly, once again, good job, sersem prost!

[The Pro]

JEEEEZ I WANTED THIS SO MUCH, i love gaging <3.....especialy when its working properly, once again, good job, sersem prost!

sersem prost!

" Мангал " / " Gypsy "

[Maverick]

Here is the result.

[Saad]

Bravo THE PRO

[Maverick]

I have managed to put it on the navigation bar of the forum, so everyone to have quick access.

[The Pro]

nice job " Maverick The Developer " Thanks for giving us quick access my niqqa, we all love you, you know right

Thumbs up for the case!

[Saad]

Best Gag ever specially with that SQL Database <3
Kudos to The Pro.
and great work Maverick for adding that button here so it'll be very easy for us to have a look at gagged players.