Purpose:
This combination of es scripts and php scripts allows you and your fellow admins to ban players from ALL your servers in-game or out of game. All bans are stored in a MySQL database on your webserver, no more need to mess with valve's banned_users.cfg file! I have encompassed as much as possible into the web front end as possible, much more will be added as time goes on. If you use steambans, then this script probably is not for you, this script was written for those that wish to maintain their own ban system.

Note: Minor versions only require replacing files. A minor version is 3.x.x. A major version is 3.x. Minor versions only are released to improve performance or for emergency security fixes. Major versions are only released for new features.

Changelog:

• 12/01/2008 - v3.4.1
  
  • Fix to the .php.rar file upload exploit.
    
• 07/05/2008 - v3.4
  
  • GlobanBan works with the orangebox now.
    
  • Servers can now be grouped together with server groups. This allows you to apply 1 list of admins to multiple servers.
    
  • Admin Groups are now implemented. You can specify GlobalBan, Mani, and SourceMod powers within a group. You then can set an admin to this group. Click on the admins icon on the Server Page to edit their powers.
    
  • A new Bad Name list has been added. Any names that contain the bad name will be auto-kicked. For example, you can add myg0t to have anyone that connects with that tag to be kicked.
    
  • New script command gb_consoleBanUser allows a scripter to use this command to autoban. This lets GlobalBan know it was done by a script rather than an admin. Refer to GlobalBan.py to see an example.
    
  • Mani and SourceMod support is in place. If you plan to use it, you must disable Mani's database usage. The same is true for SourceMod. GlobalBan writes the admins lists to flat files. Please be sure to backup those files before using GlobalBan to manage your lists.
    
• 01/25/2008 - v3.3
  
  • Threading removed. Replaced with wget and requires your webserver to be able to send rcon commands to your servers.
    
  • Banlist now hides expired bans to normal users, admins can still see all bans.
    
  • Top menu changed in preparation for new features in 3.4.
    
  • gb_externalBanUser has been modified. It now accepts either the admin's ingame userid, or the admin's steam id.
    
  • Admins can be enabled or disabled.
    
  • Mouseover explainations added to most admin functions (green ticks and red x's).
    
  • Admins can now disable their own bans.
    
• 12/21/2007 - v3.2
  
  • Admin list, ban lengths, and ban reasons automatically retrieved from web server on script load and map change. No longer required to click "Save to Server" for these 3. "Save Configuration" is still a requirement.
    
  • Server List page improved. Server status (online/offline) is now shown with an icon and mouseover. Player information now show as well. Known bug that connect time shows incorrectly.
    
  • Installer improved drastically and designed to look like the "Configuration" page. Super user is now created during install process.
    
  • RCON password is now ALWAYS required whenever updating a server. RCON password is also masked and requires the current password to change it.
    
  • Sample GlobalBan.cfg file and class.Config.php files added incase these files do not get created due to permission issues or firewall issues.
    
  • Ban history is now viewable to admins when viewing an individual ban.
    
  • Some minor display fixes on various pages.
    
• 11/17/2007 - v3.1
  
  • Threading in GlobalBan ES script improved to fix odd delays.
    
  • New way to define ban lengths. Ban lengths can be in minutes, hours, days, weeks, or months. All done through web.
    
  • New Configuration page added to web. Saving the configuration will automatically generate the GlobalBan.cfg file on all CSS servers. No need to touch the CSS server to configure!
    
  • Other minor bugs fixed.
    
• 11/04/2007 - v3.0
  
  • GlobalBan es script converted to python for Eventscripts 2.0!
    
  • clan_db script merged into GlobalBan, no longer need clan_db.
    
  • Mattie's system plugin no longer needed due to added functionality in ES2.0.
    
  • The webpage database/tables and configurations can now be done by executing install.php after placing the pages on your webserver. Execute upgrade.php if you are upgrading from GlobalBan 2.2.
    

Requirements:

• PHP 4 or 5 (short_open_tag must be enabled)
• MySQL 4.1 or 5
• EventScripts v2.0
• Special Case for Windows Servers Only: If you do not trust my included wget.exe file, then grab it from here: http://gnuwin32.sourceforge.net/packages/wget.htm

Download:

:arrow: Stable - http://addons.eventscripts.com/addons/download/GlobalBan
Latest - http://www.unbuinc.net/gban-latest.zip (Use at own risk, must run upgrade.php and always pick last option. Updated every day at 12am.)

Installation:
Installation (Full Install): I have done my best to be as descriptive as possible with installation of this ban application. Either post or email if any step is unclear. It is assumed that you already have knowledge with mysql and installing websites. If you are upgrading, skip down to the upgrade section.
Web Server (Full Install):

1. Within the GlobalBan zip file, there is a "banned" folder. Save this folder to your webserver. If you save it to htdocs everything will be in htdocs/banned. You should then be able to access the web front end by going to yourdomain.com/banned. If you wish to use SMF integration, extract banned folder to your SMF folder.
2. Once extracted, point your browser to http://www.yourdomain.com/banned/install.php and enter the input it asks for. (if you use an external web host, you may need to set config/class.Config.php as writable)
3. Login and add your servers through the "Server List" link.
4. (SMF users can skip this step) At this point you can get all your other "members" to create a user, but you will need to give them the basic user create code. This will create them as a basic user. You modify their level of admin rights on the webpages through the "Manage Admins" link. (This is an optional step if they wish to be able to add bans through the website).
5. There are now multiple css style sheets in the css folder. Pick one you want by re-naming it to banned.css
6. Before saving your configuration through the web, be sure to install and load the GlobalBan ES script

Note: Make sure you have outgoing UDP/TCP port 27015 (or whatever port you server is on) open on your web server. This will require you to ask you web host to open the port.

CSS Server (Full Install):

1. Make sure ES 2.0 is installed.
2. Within the GlobalBan zip file, there is an eventscripts folder.
3. Save GlobalBan to your addons/eventscripts folder.
4. Add all your admins/members through the web application (if you wish for them to be able to access the website you must have them sign up with the special code or enter in an email address for each of them and execute the "reset password" to send them a password to login). Those flagged as "admin" or higher will be allowed to add bans right away, however memebers who add a ban greater than 1 day are placed in "pending" mode for review (config value determines if the banned person is banned during the pending period for X days; if X days is set to 0, the banned person can rejoin until the pending flag is removed).
5. Add es_load GlobalBan to your autoexec.cfg
6. Restart your server OR exec the above two es_loads through rcon.
7. All members can access the banmenu buy typing !banmenu in say.
8. Once on you CSS server and loaded, add the server(s) through the web and then click "Save Configuration" on the Configuration page. This will sync all of your CSS servers with the GlobalBan webapp. If you modified the Ban Reasons or Ban Lengths, be sure to save those as well.
9. At this point, it is recommended to change maps or execute es_reload GlobalBan.
10. You may need to reload GlobalBan twice if you add an admin group with Mani or SourceMod powers.

Installation (Upgrade from 2.2+ to 3.4):
Web Server (Upgrade):

1. Point your browser to http://www.yourdomain.com/banned/upgrade.php, select the right upgrade option for you and click upgrade!
2. The web upgrade is now complete!

CSS Server (Upgrade):

1. Extract the new GlobalBan files into the GlobalBan folder.
2. Delete or rename es_GlobalBan.txt if it still exists
3. Reload your admins through the webapp at the end of this upgrade guide if you are upgrading from 2.2
4. You can now remove clan_db completely if you upgraded from 2.2.
5. On the Configuration Page, do a "Save Configuration". On the Ban Reasons and Ban Lengths pages, do a "Save to CSS Servers".
6. You may need to reload GlobalBan twice if you add an admin group with Mani or SourceMod powers.
7. The upgrade is complete!

Levels of Power:
Super User - Full access to the web site (setting up servers, managing admins) and full ban privs.
Ban Manager - They can modify ALL bans and recieve email notifications for bans and/or demos and full ban privs.
Admins - They can only modify their own bans only and have full ban privs (includes ip banning)
Members - They can only modify their own bans, and any ban they do that is greater than 1 hour is placed in "pending mode" if you have the pending day variable > 0. If it's pending, the ban is only active for x days. If no action is taken (the pending not removed), the banned person is able to re-join the server after x days.

Reporting Bugs:
Report all bugs to http://code.google.com/p/esglobalban/issues/list

Subversion Repository for the latest working version:
http://code.google.com/p/esglobalban/

This application has been tested on both windows and linux as well as on mysql 4.1 and 5 and php 4 and 5.

FAQ:
Question: I get a blank page after running the install.php page, why?
Answer: This means the installer successfully installed the database tables and created your super-user, however, due to permissions with your webserver, it failed to write the class.Config.php file to the config directory. To fix this, copy or rename class.Config.php.sample to class.Config.php and manually edit that file to suit your needs. Next, set the permission of that file to 777 so that it can be saved to in the future.

Question: All of my db files in the GlobalBan folder are 0 bytes! Why?
Answer: This is an access issue on your webserver. Please make sure you have a .htaccess file setup correctly that allows appropriate access.

Question: I banned a player and it shows up on the website, but they don't get kicked when they re-join, why?
Answer: You did not read the installation instructions fully. There is a note right after step 6 of the web install.

Very cool. +woot

Finally! Good tos ee you finlly released it. Seems to be working okay on one of my sites so far. I'll let you know if I run into any issues.

Congrats again on a great script!

Only issue I am having so far is trying to create a new user. I see no where to put my steamid and it keeps saying invalid steamid

What does the screen look like? It should look like http://unbuinc.net/public/banned/index.php?page=newuser

I use a regular expression to determine if the steamid is valid or not, which is /^STEAM_[01]:[01]:\d{0,10}$/

From your wording, it sounds like the steam id box is not visible or something? Or am I mis-interpretting you?

nope I see exactly that but there is no where to input your steamid.

The field right after username is steam id which is followed by password.

Web pages have been updated to fix the paging bug. Visit my test site at http://unbuinc.net/public/banned/index.php?page=banlist to see what the new paging system looks like.

System plugin + wget is a good idea, but i think it is better to use http://forums.mattie.info/cs/forums/vie ... hp?t=13605 (Source Utils). A MySQL plugin for ES.

If you like having to connect every time you want to make a query then it's fine.

Not a problem.

And what happens if the web server that you are potentially trying to connect to does not allow outside connections through port 3306 or whatever the default port is for mysql? I know I've been with some web server providers where you just could not access the database like that and all sql connections had to be done locally on the webpage.

The other issue would be double configuration of database connection information. I'ld rather the user just set that all up once on the webpage instead of doing it in multiple places; in the script and the webpge.

If an admin bans through an admin program that adds to the ban_user.cfg will this be added to the sql data base?

No. However, you can import all bans that you currently have added to banned_users.cfg through my web front end (with a super-user account only). Once that is done, there is no reason to use any other admin banner as I provide es scripts for this sole purpose. I, myself, have totally stopped using banned_users.cfg and don't even bother to exec that file in my server.cfg file anymore and I don't allow banning through mani anymore.

This is an all in one Ban application that applies to ALL servers you choose to run it on. It allows you to ban in-game and it allows you ban out of game if the person you wanted to ban left or if someone reports a hacker with a demo.

I should note, you don't have to have every admin sign-up on the webiste. The only reason to have them do so is to that they can add bans through the website or to edit a ban they have done. If the admin is registered to ban through my in-game es scripts but not on the webapp, it will still ban the person, but it will just say that the banner was "blank".

Thanks for the clarification.

I've just been informed by one of my testers that the person does have to be registered on the web site in-order for in-game bans to register properly. So I will be making modifications so that that does not have to be the case and will hopefully have a new version for this in a couple of days.

My initial intention of adding admins to the website was to both show who the banner really was (ie, if the admin was actually incongito) and to allow admins to add bans through the website. But there has been interest in just making it so that they don't have to be registered on the site in order to add bans in game to the database. I'm still working out the details on how exactly I want to handle this. Maybe I'll add an import method so that you can import admins from the es_clanMembers_db.txt file, add an "add new admin" area to the website, and an export button to generate es_clanMembers_db.txt. That way server admins can keep both areas consistent easily, either consistent by the es db file or consistent by the mysql database tables.

Is there anyway to create this plugin without the need for Mani's System plugin or wget both of which my server provider will not allow to be installed.

If there was I would have used it.