MySQL Banning - Single DB - Cover Multiple Servers V3.0 [10 Jun 08] - Page 4

HSFighter · 02-25-2008 , 19:45 Re: MySQL Banning - Single DB - Cover Multiple Servers

Hi @ all,

The Sourcemod Webadmin Support's now the 'MySQL Banning Plugin' Database entry's.

Link: http://forums.alliedmods.net/showthread.php?t=60174

Enjoy

Fredd · 02-26-2008 , 23:09 Re: MySQL Banning - Single DB - Cover Multiple Servers

Good Work

SaintK · 03-25-2008 , 06:22 Re: MySQL Banning - Single DB - Cover Multiple Servers

Hi,

Thanks for the plugin!

Got a question about it;

When will you be adding timestamp checking?

HSFighter · *Last edited by HSFighter; 04-08-2008 at 19:08.*

HI @ all

PHP Code:


			
 DROP TABLE IF EXISTS `mysql_bans`;
CREATE TABLE IF NOT EXISTS `mysql_bans` (
  `id` int(11) NOT NULL auto_increment,
  `steam_id` varchar(32) NOT NULL,
  `player_name` varchar(65) NOT NULL,
  `ipaddr` varchar(24) NOT NULL,
  `ban_length` int(1) NOT NULL default '0',
  `ban_reason` varchar(100) NOT NULL,
  `banned_by` varchar(100) NOT NULL,
  `timestamp` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `steam_id` (`steam_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

I found 2 Problems with the Tablestructure!!

1.
steam_id is a UNIQUE KEY !!!
When i BAN 2 IP's on a LAN server the steam_id will be empty.
This is Impossible why the same steam_id can't wehre 2 time in the database even it is empty.
2 Times empty entry is with UNIQUE KEY is Impossible.

2.
there are "update CURRENT_TIMESTAMP" in the timestamp Column.
When i update a entry over a the webinterface the BAN date will switch to the current date.

I have fix the Database Tablestructure to this plugin in my Webinterface.
The Database will be automatic update to this changes when
your will install or Update the Webadmin to 1.9 (release this week)!

Delete "update CURRENT_TIMESTAMP"
Delete "UNIQUE KEY `steam_id` (`steam_id`)"

I hope the Plugin will run with this changes???

MoggieX · 04-22-2008 , 09:13 Re: MySQL Banning - Single DB - Cover Multiple Servers

Updated the 'todo list' and added a compatibility table as well, as we've tested it on more source mods now.

If you have any other suggestions to add, let me know, as I'll be revisiting this plugin over the next few days.

Matt

junkies · 04-22-2008 , 17:11 Re: MySQL Banning - Single DB - Cover Multiple Servers

not worked

L 04/23/2008 - 01:05:15: [SM] Native "Format" reported: Client index -1 is invalid
L 04/23/2008 - 01:05:15: [SM] Displaying call stack trace for plugin "mysql_bans.smx":
L 04/23/2008 - 01:05:15: [SM] [0] Line 646, /home/groups/alliedmodders/forums/files/2/9/7/7/1/23100.attach::Command_BanIp()

MoggieX · 04-23-2008 , 14:43 Re: MySQL Banning - Single DB - Cover Multiple Servers

Quote:

Originally Posted by junkies

not worked

L 04/23/2008 - 01:05:15: [SM] Native "Format" reported: Client index -1 is invalid
L 04/23/2008 - 01:05:15: [SM] Displaying call stack trace for plugin "mysql_bans.smx":
L 04/23/2008 - 01:05:15: [SM] [0] Line 646, /home/groups/alliedmodders/forums/files/2/9/7/7/1/23100.attach::Command_BanIp()

What is the full error list and were you trying to test it on a BOT ?

Matt

junkies · 04-24-2008 , 11:20 Re: MySQL Banning - Single DB - Cover Multiple Servers

i write in console
mysql_banip 10 192.168.32.10 test (192.168.32.10 its my ip)
i see in console mysql_banip Unknown command "mysql_banip" and in log
L 04/23/2008 - 01:05:15: [SM] Native "Format" reported: Client index -1 is invalid
L 04/23/2008 - 01:05:15: [SM] Displaying call stack trace for plugin "mysql_bans.smx":
L 04/23/2008 - 01:05:15: [SM] [0] Line 646, /home/groups/alliedmodders/forums/files/2/9/7/7/1/23100.attach::Command_BanIp()
if write mysql_banip(no parametrs) print mysql_banip <time> <ip|#userid|name> [reason]

S@ndel · *Last edited by S@ndel; 04-27-2008 at 21:26.*

Quote:

Originally Posted by junkies

i write in console
mysql_banip 10 192.168.32.10 test (192.168.32.10 its my ip)
i see in console mysql_banip Unknown command "mysql_banip" and in log
L 04/23/2008 - 01:05:15: [SM] Native "Format" reported: Client index -1 is invalid
L 04/23/2008 - 01:05:15: [SM] Displaying call stack trace for plugin "mysql_bans.smx":
L 04/23/2008 - 01:05:15: [SM] [0] Line 646, /home/groups/alliedmodders/forums/files/2/9/7/7/1/23100.attach::Command_BanIp()
if write mysql_banip(no parametrs) print mysql_banip <time> <ip|#userid|name> [reason]

same problem :/
added
lol

Quote:

// Reg commands
RegAdminCmd("mysql_ban",Command_Ban,ADMFLAG_B AN,"Bans player by STEAMID")
RegAdminCmd("mysql_addban",Command_AddBan,ADM FLAG_BAN,"Bans player by STEAMID")
RegAdminCmd("mysql_unban",Command_UnBan,ADMFL AG_BAN,"Unbans player by STEAMID")
RegAdminCmd("mysql_ipban",Command_BanIp,ADMFLAG_BAN,"Unbans player by IP")

S@ndel · 04-29-2008 , 09:56 Re: MySQL Banning - Single DB - Cover Multiple Servers

] mysql_banip 0 "77.123.161.72" "cheater"
[SM] You cannot ban that IP address

i'm also try

] mysql_banip "77.123.161.72" 0 "cheater"
Unknown command: mysql_banip

dont works!

Quote:

22nd April 2008: This is being tested live on our NINE game servers, with over 2000 bans to check for any side effects and core functionality.

very interesting.... :/