Gag System ( SQL connection )

Create something unique in every way possible, we will be glad to check it out. :)
The Pro
Coder
Coder
Posts: 62
Joined: Sun Sep 03, 2017 4:12 pm
x 6
x 5
Been thanked: 2 times

Gag System ( SQL connection )

Post by The Pro » Wed Sep 06, 2017 5: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:

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 11 times
Last edited by The Pro on Wed Sep 06, 2017 11:39 pm, edited 4 times in total.
0 x
Image

User avatar
Maverick
Site Admin
Site Admin
Posts: 283
Joined: Fri Sep 01, 2017 1:54 pm
Location: Sofia, Bulgaria
x 61
x 47
Has thanked: 13 times
Been thanked: 29 times
Contact:
Maverick’s avatar
Loading…

Re: Gag System ( SQL connection )

Post by Maverick » Wed Sep 06, 2017 6:07 pm

Try it as soon as possible and share if works the way it is supposed to be. :)
0 x
Image

The Pro
Coder
Coder
Posts: 62
Joined: Sun Sep 03, 2017 4:12 pm
x 6
x 5
Been thanked: 2 times

Re: Gag System ( SQL connection )

Post by The Pro » Wed Sep 06, 2017 7:43 pm

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.
0 x
Image

User avatar
LC`
VIP
VIP
Posts: 27
Joined: Mon Sep 04, 2017 7:50 am
Location: Why u need it, wonna stalk me?
x 1

Re: Gag System ( SQL connection )

Post by LC` » 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!
0 x
Say no to chalga, chalga makes you an idiot!!!

The Pro
Coder
Coder
Posts: 62
Joined: Sun Sep 03, 2017 4:12 pm
x 6
x 5
Been thanked: 2 times

Re: Gag System ( SQL connection )

Post by The Pro » Wed Sep 06, 2017 8:33 pm

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 "
0 x
Image

User avatar
Maverick
Site Admin
Site Admin
Posts: 283
Joined: Fri Sep 01, 2017 1:54 pm
Location: Sofia, Bulgaria
x 61
x 47
Has thanked: 13 times
Been thanked: 29 times
Contact:
Maverick’s avatar
Loading…

Re: Gag System ( SQL connection )

Post by Maverick » Fri Sep 08, 2017 8:25 pm

Here is the result. :)
0 x
Image

User avatar
Saad
Moderator
Moderator
Posts: 121
Joined: Sun Sep 03, 2017 5:39 pm
Location: Karachi, Pakistan
x 52
x 37
Has thanked: 44 times
Been thanked: 6 times

Re: Gag System ( SQL connection )

Post by Saad » Fri Sep 08, 2017 8:42 pm

Bravo THE PRO :)
0 x


User avatar
Maverick
Site Admin
Site Admin
Posts: 283
Joined: Fri Sep 01, 2017 1:54 pm
Location: Sofia, Bulgaria
x 61
x 47
Has thanked: 13 times
Been thanked: 29 times
Contact:
Maverick’s avatar
Loading…

Re: Gag System ( SQL connection )

Post by Maverick » Sat Sep 09, 2017 8:51 am

I have managed to put it on the navigation bar of the forum, so everyone to have quick access. :P
Image
0 x
Image

The Pro
Coder
Coder
Posts: 62
Joined: Sun Sep 03, 2017 4:12 pm
x 6
x 5
Been thanked: 2 times

Re: Gag System ( SQL connection )

Post by The Pro » Sat Sep 09, 2017 10:40 am

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!
0 x
Image

User avatar
Saad
Moderator
Moderator
Posts: 121
Joined: Sun Sep 03, 2017 5:39 pm
Location: Karachi, Pakistan
x 52
x 37
Has thanked: 44 times
Been thanked: 6 times

Re: Gag System ( SQL connection )

Post by Saad » Sat Sep 09, 2017 2:40 pm

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. :)
0 x


Post Reply