MySQL Ban Management by JustinHoMi

slmclarengt · **Plugin Info:**

Code:

/* AMX Mod script.
*
* MySQL Ban Management
*  by JustinHoMi
* Ported to amxx by slmclarengt
*/

Code:

#include <amxmodx>
#include <amxmisc>
#include <dbi>

Ban to your MYSQL database! Use amx_ban and amx_ban providing Authid to place a ban and to lift a ban!

Changelog:

Difference from AMXBANS:
Bans more efficiently
Bans quickly
Bans to MySQL in a more readable way.
It's much more user-friendly to operate.

August 04 2005: Fixed Typos
December 14 2005: Added reasons

Damocles · 08-02-2005 , 08:54

this may be EXACTLY what im looking for. I used to use amx_bans by Yomama but found that people that i had banned were still able to reconnect. I've had a look at the .sma but is there any chance you could expand a bit in terms of the exact functionality the plugin provides.

I could proably whip together some custom PHP pages to display the ban information on my website, just wanted to make sure this works ^^ hehe

algee2005 · 08-02-2005 , 09:25

oO is this not implemented in amxbans?

Damocles · 08-02-2005 , 09:26

this may be EXACTLY what im looking for. I used to use amx_bans by Yomama but found that people that i had banned were still able to reconnect. I've had a look at the .sma but is there any chance you could expand a bit in terms of the exact functionality the plugin provides.

I could proably whip together some custom PHP pages to display the ban information on my website, just wanted to make sure this works ^^ hehe

algee2005 · 08-02-2005 , 09:29

huh oh lol nvm

Xanimos · 08-02-2005 , 09:40

Please when you port something change it the right way....when the new release comes out this plugin will no longer work.

Quote:

Originally Posted by BAILOPAN

mysql_* - These natives have been removed entirely. Use DBI.

include <dbi> and change all mysql_ to dbi_

slmclarengt · 08-02-2005 , 16:39

will do. I read that but when I was porting this plugin, i just forgot about it. New version is in my first post.

csv · 08-04-2005 , 04:57

with a .php-front this would be very neat

Damocles · 08-04-2005 , 11:21

Quote:

Originally Posted by csv

with a .php-front this would be very neat

with a PHP front-end it would be starting to come similar to amx_bans, but i still maintain that amx_bans never worked 100%. When i used it banned people could still randomly reconnect. A streamlined version of the code...like this plugin, with some simple php interfaces would be great

123 · 08-04-2005 , 11:40

You got an error in the amx_unbans:
You missed a ","

Code:

ip varchar(25) NOT NULL default ''[b],[/b]

Here is a working version:

Code:

CREATE TABLE amx_unbans (
   player_id varchar(17) NOT NULL default '',
   player_name varchar(33) NOT NULL default '',
   admin_id varchar(17) default NULL,
   admin_name varchar(33) default NULL,
   time_unbanned timestamp(14) NOT NULL,
   server varchar(25) NOT NULL default '',
   ip varchar(25) NOT NULL default '',
   admin_ban varchar(33) default NULL,
   length int(10) unsigned NOT NULL default '0'
 ) TYPE=MyISAM;