Page 1 of 2

Gag System ( SQL connection )

Posted: Wed Sep 06, 2017 5:13 pm
by 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 26 times

Re: Gag System ( SQL connection )

Posted: Wed Sep 06, 2017 6:07 pm
by Maverick
Try it as soon as possible and share if works the way it is supposed to be. :)

Re: Gag System ( SQL connection )

Posted: Wed Sep 06, 2017 7:43 pm
by 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.

Re: Gag System ( SQL connection )

Posted: Wed Sep 06, 2017 8:31 pm
by LC`
JEEEEZ I WANTED THIS SO MUCH, i love gaging <3.....especialy when its working properly, once again, good job, sersem prost!

Re: Gag System ( SQL connection )

Posted: Wed Sep 06, 2017 8:33 pm
by The Pro
LC` wrote:
Wed Sep 06, 2017 8:31 pm
JEEEEZ I WANTED THIS SO MUCH, i love gaging <3.....especialy when its working properly, once again, good job, sersem prost!
sersem prost!
" Мангал " / " Gypsy "

Re: Gag System ( SQL connection )

Posted: Fri Sep 08, 2017 8:25 pm
by Maverick
Here is the result. :)

Re: Gag System ( SQL connection )

Posted: Fri Sep 08, 2017 8:42 pm
by Saad
Bravo THE PRO :)

Re: Gag System ( SQL connection )

Posted: Sat Sep 09, 2017 8:51 am
by Maverick
I have managed to put it on the navigation bar of the forum, so everyone to have quick access. :P
Image

Re: Gag System ( SQL connection )

Posted: Sat Sep 09, 2017 10:40 am
by 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!

Re: Gag System ( SQL connection )

Posted: Sat Sep 09, 2017 2:40 pm
by 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. :)