[Godless]

I played arround a bit, and it seem to crash on the SQL_Connect Handle.

There arnt any errors in the log or the console.

[HSFighter]

Fine Fine, very nice Job

Have i the permission to add the SQL-Management for this Plugin to the Sourcemod-Webadmin?

It will be a nice option to "search/edit/delte" bans for a admin via Webinterface

[MoggieX]

Originally Posted by HSFighter Fine Fine, very nice Job Have i the permission to add the SQL-Management for this Plugin to the Sourcemod-Webadmin? It will be a nice option to "search/edit/delte" bans for a admin via Webinterface

YES! That saves me writing a pretty front end for it.

Assume that the table fields will not change, as I accounted for what could possibly be needed when creating the table in the first place.

Also that will be doubly handy as I use your web-admin interface HSFighter :-)

Just to confirm the table is:

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 ; 


Matt

[Solltex]

need ban by IP to lan servers.

[MoggieX]

Originally Posted by Solltex need ban by IP to lan servers.

Done in a major re-write and tidy up!

Matt

[Solltex]

nice

[HSFighter]

Hey ho,

the integration to the webinterface is 90% Completed

1. Suggestion:
Is it possible that the Plugin write his Version and Author to the Database, when the Plungin be loadet? (from public Plugin:myinfo)

PHP Code:

CREATE TABLE IF NOT EXISTS `mysql_bans_infos` (
  `id` int(11) NOT NULL auto_increment,
  `version` varchar(12) NOT NULL,
  `author` varchar(32) NOT NULL,
  `name`  varchar(32) NOT NULL,
  `description`  varchar(255) NOT NULL,
  `url`  varchar(64) NOT NULL,
   PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 


It will be very Practically for the (Plugin Management) in the Webinterface!

2. Suggestion:
Can you add "Country" Column in the "mysql_bans" Table,
and get country data from the banned player?

3. Suggestion:
Can you add "sid" (serverid) Column in the "mysql_bans" Table,
so i can define a BAN (0 = Web-Ban, 1 = Server-BAN)?

[MoggieX]

Some answers for you:

Originally Posted by HSFighter the integration to the webinterface is 90% Completed

Spot on!

Originally Posted by HSFighter 1. Suggestion: Is it possible that the Plugin write his Version and Author to the Database, when the Plungin be loadet? (from public Plugin:myinfo) PHP Code: CREATE TABLE IF NOT EXISTS `mysql_bans_infos` (   `id` int(11) NOT NULL auto_increment,   `version` varchar(12) NOT NULL,   `author` varchar(32) NOT NULL,   `name`  varchar(32) NOT NULL,   `description`  varchar(255) NOT NULL,   `url`  varchar(64) NOT NULL,    PRIMARY KEY  (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1  It will be very Practically for the (Plugin Management) in the Webinterface!

Yes it is indeed. But see comments below, noting that we are dealing with multiple servers.

Originally Posted by HSFighter 2. Suggestion: Can you add "Country" Column in the "mysql_bans" Table, and get country data from the banned player?

Errr not sure, would have to look at this in more detail. Although it woudl eb relant upon the geoip db finding the country. That said it works most of the time and is a case of borrowing the

Originally Posted by HSFighter 3. Suggestion: Can you add "sid" (serverid) Column in the "mysql_bans" Table, so i can define a BAN (0 = Web-Ban, 1 = Server-BAN)?

Yes, although I think we could do better than that and instead not only identify which 'place' [web or server based], but the server IPORT it was made upon as well.

Whether we do that by convars, web based with Server ID's or something else I'm not sure.

---

I need to find some time to go back over what I have done before and also add the select case statement in for the timed bans and test that fully too.

Matt

[mplostcause]

I've been having some problems with our plugin and I was wondering if I could get some help with it. I decided to use your system instead of Sourcebans because I didn't want to use a web front-end. I installed just as instructed. But when I go to ban someone I run into some problems.

Just typing "mysql_ban" or "mysql_addban" in console will describe what they do but actually using them I always get the error "Unknown command" for both of them and nothing happens in game as far as individuals actually being banned and nothing makes it to the mysql tables.

[MoggieX]

Originally Posted by mplostcause I've been having some problems with our plugin and I was wondering if I could get some help with it. I decided to use your system instead of Sourcebans because I didn't want to use a web front-end. I installed just as instructed. But when I go to ban someone I run into some problems. Just typing "mysql_ban" or "mysql_addban" in console will describe what they do but actually using them I always get the error "Unknown command" for both of them and nothing happens in game as far as individuals actually being banned and nothing makes it to the mysql tables.

First off, I assume the tables is correctly made etc..

Try putting:
mysql_bans_error_check 1

In your sourcemod.cfg file and changemaps, the plugin is set to be extremely vocal in what its doing with this enabled.

Then banning yourself, so in my case it woudl be:

mysql_ban mogg 0 "Ya n00blet"

Now if you're not banned, check the error log and the normal logging file for any messages, they're prefixed with [MySQL Bans]

I'm sure its working ok, as we have it running on 5 of our servers (CSS & TF2) atm with ~30 core admins that have access to it and so far its been them typing the commands wrong.

Matt