How to do bans across multiple servers

[Storm]

I have 7 GMod servers, all using ulx/ulib. Every time I want a person banned on all servers, I have to find the steamid in my logs, enter the ulx banid command on hlsw for each server, after I have already done the ban on one of the servers. Also, when a person disputes a ban, I have to search in each server to find the reason because they don't know from which server they were banned. I have a ton of bans and this takes soooo much of my time. I do use sourcebans on my L4D2 servers and I have read tutorials on how to integrate it with ulx but it is complicated for me and I don't want to mess with ulx/ulib because it works so perfectly now. Does anyone else have multiple servers that might have found an answer to this?

[JamminR]

If the integration of Sourcebans seems too complicated for you, any other suggestion is likely going to also.
Many discussions have been made in these forums regarding SQL database integration of bans, users, other data.
Search our releases and developers corner section of our forums for more ideas.

Unfortunately, due to Gmod not having an integrated SQL database function/sockets library, many have made custom binary libraries that work for a bit, and then stop getting maintained or break when a gmod update is made.
To my knowledge, there is no 'just place this in addons and it will magically work' solution.

[MrPresident]

There is not a magic solution. I use the MySQLOO module and a custom addon I wrote to utilize it for bans and authentication. If you have some lua skills and would like to look it over, I would be glad to provide you with the code for my addon.

You would need to install the MySQLOO module on each server and have access to a MySQL server as well. It tends to work best if the MySQL server is on the same physical server as the game servers.

[rainbow Dash]

I would recommend persevering with the sourcebans hackmodule for ULX, ill go fetch a link...

Sure, it moves the issue to a different place (struggling to make sure all your admins have access to sourcebans), but lets compare it...

Before: Struggling to ban up to 20 minges a week on 7 servers...

After: Struggling to ensure (lets say 8 staff members per server, 1 being the same across all servers, puts us at  7x7 = 49 + 1 = 50) 50 staff members have access to Sourcebans on a permanent basis, and ensuring you remove them after you demote them...

It may not sound like it, but Sourcebans actually will reduce the effort required, unless you make a universalban command which before banning from server A, it proceeds to send an RCON command to the other 6 servers to ban the players SteamID for the time specified (I say before because you want to catch his SteamID and use it for the RCON commands first)

EDIT: Use this tutorial: http://forums.ulyssesmod.net/index.php?topic=5875.0