[naris]

I have updated this plugin to change the queries to threaded queries, make "local bans" (in banned_user.cfg) optional, optionally unban players (remove from banned_user.cfg) those not found in the DB, fix several bugs and updated the version number.

New ConVar's
These are the new ConVar's used by this plugin

mysql_bans_local_ban
Also Ban players locally (using banned_user/ip.cfg), 1 = also ban locally, 0 = only store bans in DB

mysql_bans_local_unban
Also Unban players locally (using banned_user/ip.cfg), 1 = unban players when they connect and aren't in the ban DB, 0 = don't check for unbans when connecting

Modified ConVar

mysql_bans_error_check
Shows Error Messages, 0 = don't show, 1 = show in logs, 2 = show in-game chat


Updates
4.1: Fixed problem with sourcemod sometimes claiming mysql_ban is an unknown command.
4.2: Fixed banning by ip.
4.3: Fixed player not getting banned if there are more than 1 applicable bans (by IP and by ID) and 1 is expired.
Fixed PrepareBan() failing if the admin bans himself.
Refactored InsertBan()
4.4: Fixed banees not getting kicked when mysql_bans_local_ban = 0
Escape players names before inserting to DB.
4.5: Changed mysql_bans to log the Admin's name (if available) instead of the admin's player name.
Added banned_by_id to the mysql_bans table
4.6: Fixed logging the banee's steam ID instead of the admin's steam ID in banned_by_id.
4.7: Fixed errors when the source is 0.
4.8: Fixed STEAM_1: ids.