Raised This Month: $51 Target: $400
 12% 

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


Post New Thread Reply   
 
Thread Tools Display Modes
bzz0
Senior Member
Join Date: Oct 2005
Location: Latvia, Riga
Old 02-08-2008 , 02:49   Re: MySQL Banning - Single DB - Cover Multiple Servers
Reply With Quote #21

MoggieX - as I understand your plugin does not work with temporary (timed) bans, only with permanent??
__________________
Let's make it better
bzz0 is offline
Olly
Senior Member
Join Date: Mar 2007
Location: UK
Old 02-08-2008 , 09:08   Re: MySQL Banning - Single DB - Cover Multiple Servers
Reply With Quote #22

Quote:
Originally Posted by MoggieX View Post
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 :-)
Hi,
Iv been looking over your thing you have here, and i couldn't help wondering why you are doing it. SourceBans has all of the features your's has (afaik) - Im just wondering why you wanted to make another one, does yours have something that SourceBans doesnt have?

Also.. you may want to use use threaded sql queries, because if the mysql server hangs, then the game server will go tits-up and hang... :p
__________________
Tumblr Me: http://raspberryteen.tumblr.com


// Yarrrr!
Olly is offline
Send a message via MSN to Olly
mplostcause
Junior Member
Join Date: Feb 2008
Old 02-08-2008 , 15:25   Re: MySQL Banning - Single DB - Cover Multiple Servers
Reply With Quote #23

Personally I choose his plugin over Sourcebans because Sourcebans seems to require the web frontend for normal installation. There may be a way to install it without the web frontend but I didn't find it while going over their site. I just wanted a plugin that bans people to a mysql database, not that is included with a fancy web page. Basically, I don't want my Server 2003 machine to be hosting websites.

Also MoggieX, I did what you said and banned myself. This is what the server console put off when I did it.

Code:
L 02/08/2008 - 14:46:13: [mysql_bans.smx] [MySQL Bans] Player was admin checked
♦[MySQL Bans]♥ Player was admin checked
L 02/08/2008 - 14:47:03: [mysql_bans.smx] [MySQL Bans] [Put into DB] Auth STEAM_
0:0:2405480, Name lostcause Ban time 0, Reason "Test", Client lostcause
Dropped lostcause from server ("Test")
L 02/08/2008 - 14:47:03: [SM] Plugin encountered error 4: Invalid parameter or p
arameter type
L 02/08/2008 - 14:47:03: [SM] Native "ReplyToCommand" reported: Language phrase
"Ban added" not found
L 02/08/2008 - 14:47:03: [SM] Debug mode is not enabled for "mysql_bans.smx"
L 02/08/2008 - 14:47:03: [SM] To enable debug mode, edit plugin_settings.cfg, or
 type: sm plugins debug 14 on
Writing cfg/banned_user.cfg.
This writes my steamid to the banned_user.cfg, but it doesnt ban me from any of the other servers running the plugin so I can only guess this isn't what its suppose to do when someone is banned.

Last edited by mplostcause; 02-08-2008 at 15:54.
mplostcause is offline
MoggieX
Veteran Member
Join Date: Aug 2007
Location: n00bville
Old 02-09-2008 , 20:47   Re: MySQL Banning - Single DB - Cover Multiple Servers
Reply With Quote #24

Quote:
Originally Posted by bzz0 View Post
MoggieX - as I understand your plugin does not work with temporary (timed) bans, only with permanent??
Thats right, for now it doens't, but it will soon!

Quote:
Originally Posted by Olly View Post
Hi,
Iv been looking over your thing you have here, and i couldn't help wondering why you are doing it. SourceBans has all of the features your's has (afaik) - Im just wondering why you wanted to make another one, does yours have something that SourceBans doesnt have?
Ease of use
Because I don't want all the other stuff that comes with sourcebans, I found the interface poor and somewhat frustrating compared to HSFighters Sourcemod webadmin, which is clean and does the job perfectly for us with over 300 people in the db and +180 clan members on mulitple servers.

Although I most credit you with excellent compatibilty with Firefox. And BTW when are u updating SB's detox???

Also in the soucrebans thread you posted that it doesn't deal with the mysql bans at that time properly. The other plugin that was posted that did this was utter tosh and didn't work (even with a heavily experinced c++ coder and a DBA looking at it, infact the DBA pissed his pants[in laughter] at the queires in that plugin), I gave up with it in the end.

I needed something that works and works now, I have too many servers and too many n00bs to look after, this plugin works exactly for our needs.

Quote:
Originally Posted by Olly View Post
Hi,
Also.. you may want to use use threaded sql queries, because if the mysql server hangs, then the game server will go tits-up and hang... :p
I am a coding n00b, I understand what (and why) you are refering to, however what function() are you refering to? As we use the threaded sql plugin.

Quote:
Originally Posted by mplostcause View Post
Personally I choose his plugin over Sourcebans because Sourcebans seems to require the web frontend for normal installation. There may be a way to install it without the web frontend but I didn't find it while going over their site. I just wanted a plugin that bans people to a mysql database, not that is included with a fancy web page. Basically, I don't want my Server 2003 machine to be hosting websites.

Also MoggieX, I did what you said and banned myself. This is what the server console put off when I did it.

Code:
L 02/08/2008 - 14:46:13: [mysql_bans.smx] [MySQL Bans] Player was admin checked
♦[MySQL Bans]♥ Player was admin checked
L 02/08/2008 - 14:47:03: [mysql_bans.smx] [MySQL Bans] [Put into DB] Auth STEAM_
0:0:2405480, Name lostcause Ban time 0, Reason "Test", Client lostcause
Dropped lostcause from server ("Test")
L 02/08/2008 - 14:47:03: [SM] Plugin encountered error 4: Invalid parameter or p
arameter type
L 02/08/2008 - 14:47:03: [SM] Native "ReplyToCommand" reported: Language phrase
"Ban added" not found
L 02/08/2008 - 14:47:03: [SM] Debug mode is not enabled for "mysql_bans.smx"
L 02/08/2008 - 14:47:03: [SM] To enable debug mode, edit plugin_settings.cfg, or
 type: sm plugins debug 14 on
Writing cfg/banned_user.cfg.
This writes my steamid to the banned_user.cfg, but it doesnt ban me from any of the other servers running the plugin so I can only guess this isn't what its suppose to do when someone is banned.
That is exactly where we are coming from, I have a a dedi server dedicated to supporting the other servers. Thats the level where we are at and we're we're going. Hence we use SM, its *** brill, as we get complete control and mani admin plugin is *** laggy as hell compared to to SM.

IMO a game server should be as slick as possible, thus removing any other crap that might interfere with its core purpose, 'gaming'.

As for that bug[ or feature ;)], yes I know exactly what it is, some muppet named the the 'Ban added' replycommand() as 'Ban Added ', thus is craps itself. Its still works OK though!

Just became a dad last weekend, so my attention is else where atm, although I will come back and update the plugin with a few neat extras such as timed bans as soon as I can. Apologies for any spelling mjistakes, just got in from a night out 'wetting the babies head' and are a a little worse for wear!

HSFighter was/is on for adding a web GUI for this plugin too, with a little work I can accomodate this as well. I'd really like that so we have our stuff for the our core admins in a single place.

Matt
__________________

Last edited by MoggieX; 02-09-2008 at 20:53.
MoggieX is offline
Send a message via Skype™ to MoggieX
HSFighter
Veteran Member
Join Date: Aug 2007
Location: Flensburg - Germany
Old 02-11-2008 , 11:07   Re: MySQL Banning - Single DB - Cover Multiple Servers
Reply With Quote #25

HI @ all,

sorry for my late feedback.
I was very busy at last time.

The integration to the webinterface is to 100% Completed
And i add small useful toys to the webadmin (Ideas from MoggieX Thx )
I will post a Changelog when the relase is online this week!

I must first check some small Bugs in the new plugin-management

--

Quote:
Quote:
MoggieX - as I understand your plugin does not work with temporary (timed) bans, only with permanent??
Thats right, for now it doens't, but it will soon!

I has add a Scrollbox so you can Edit the Ban Length in the Database.
The timelength will be insert in Minutes to the database and will be show in the Interface as (Minutes, Hours, Days, Weeks or Jears)!
0 = Perm.

--

@MoggieX:

I have a smal Suggestion:

It will be very Easier to work without the "on update CURRENT_TIMESTAMP" Entry in the Mysql Dump.

Whenever I get a update to the Entry... example edit the BAN-length, Name e.t.c.,
the BAN-Date will be set to the currend date.
The correct bandate is not understandable more!
__________________



Sorry for my very bad english
Greetings HSFighter

Last edited by HSFighter; 02-12-2008 at 07:19.
HSFighter is offline
Send a message via ICQ to HSFighter
HSFighter
Veteran Member
Join Date: Aug 2007
Location: Flensburg - Germany
Old 02-11-2008 , 15:36   Re: MySQL Banning - Single DB - Cover Multiple Servers
Reply With Quote #26

P.s.
I have a fine Idea to delete a tempban in the database :-)
Explode unixtimestamp's from Bandate and the servertime.

banlength_sec = banlength * 60

When
(unixtimestamp_bandate + banlength_sec) < unixtimestamp_currentime
unban the client

OR

unixtimestamp_bandate + banlength_sec = Unbanntime
set a unban timestamp in the database!




Why unixtimestamp?
unixtimestamp is defined in seconds,
and is verry easy to work with it :-)

Is only a small idea for your SM-Plugin!
__________________



Sorry for my very bad english
Greetings HSFighter

Last edited by HSFighter; 02-20-2008 at 08:41.
HSFighter is offline
Send a message via ICQ to HSFighter
pRED*
Join Date: Dec 2006
Old 02-20-2008 , 18:18   Re: MySQL Banning - Single DB - Cover Multiple Servers
Reply With Quote #27

Look good Moggie.

I do you think you should look into using threaded queries. Note this nothing to do with running the threaded query admin plugin but rather the usage of the 'TConnect' and 'TQuery' natives for your queries. Instead of returning the results they call another function when the results have been found (similar to how timers work). Their main advantage is the game doesn't have to wait for the query to finish and can continue processing other things in the meantime.

Also you are encouraged to not attach the .smx file to your first post and just let people use the 'Get Plugin' link. This means it is always compiled against the latest compiler and includes.

Other than that good work. Approved
pRED* is offline
MoggieX
Veteran Member
Join Date: Aug 2007
Location: n00bville
Old 02-21-2008 , 09:17   Re: MySQL Banning - Single DB - Cover Multiple Servers
Reply With Quote #28

Quote:
Originally Posted by pRED* View Post
Look good Moggie.

I do you think you should look into using threaded queries. Note this nothing to do with running the threaded query admin plugin but rather the usage of the 'TConnect' and 'TQuery' natives for your queries. Instead of returning the results they call another function when the results have been found (similar to how timers work). Their main advantage is the game doesn't have to wait for the query to finish and can continue processing other things in the meantime.

Also you are encouraged to not attach the .smx file to your first post and just let people use the 'Get Plugin' link. This means it is always compiled against the latest compiler and includes.

Other than that good work. Approved
Heya pRED*,

I'll go with what I ahve for now as time is tight, however if I get stuck, I'll no doubt bug you on IRC :-)

Time is tight atm (new baby), but will be back to update this shortly!

Matt
__________________
MoggieX is offline
Send a message via Skype™ to MoggieX
Procyon
Junior Member
Join Date: Dec 2007
Old 02-21-2008 , 14:01   Re: MySQL Banning - Single DB - Cover Multiple Servers
Reply With Quote #29

Good initiative. I always wanted something like this to to be shipped with sourcemod alongside sql admins as an alternative to bans on flat files. keep it simple, just the core functionality.

As this is the most promising candidate, I urge experienced sourcemod plugin programmers to assist and make this a robust, reliable and bugfree alternative to sourcebans.
Procyon is offline
DaRk NiGhT
Junior Member
Join Date: Nov 2007
Old 02-21-2008 , 19:50   Re: MySQL Banning - Single DB - Cover Multiple Servers
Reply With Quote #30

I agree with MoggieX about using this over SourceBans...

SourceBans is nice for people with no system to manage their admins and bans but for people who already have systems for admins and such, it's annoying... I already have a system i've written for admins and everything else so SourceBans is useless. This plugin, however, adds the one peice my system is missing.

I will say, thought, that I'm writing my own plugin for MySQL Banning that uses threading and conforms more to my database structure.

Nice job Moggiex!
__________________
-: DaRk NiGhT :-

DaRk NiGhT is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 04:45.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode