IP Range Ban based on MySQL
Description:
Ban range IP's on MySQL.
Cvars:
sm_iprangeban_mysql_version
sm_iprangeban_mysql_enable - Enables this plugin. Default: "1"
sm_iprangeban_mysql_prefix - Table prefix in database. Default: "sm_iprangeban"
sm_iprangeban_mysql_dbconfig - Name of database config in database.cfg. Default: "ip_range_ban"
sm_iprangeban_mysql_uwl_ip - Enable\disable use white list IP's. Default: "0"
sm_iprangeban_mysql_uwl_id - Enable\disable use white list SteamID's. Default: "0"
sm_iprangeban_mysql_logging - Enable\disable logging kicked players. Default: "0"
DB structure description:
Table prefix_ip_range:
`id` - range ID
`start` start IP range
`end` end IP range
`text_to_kick` - text to kicking reason
`comment` range comment for administrators
Table prefix_kicked_players:
`id` - row ID
`ip` - blocked player IP
`steam` - blocked player SteamID (if
sm_iprangeban_mysql_uwl_id is
1)
`name` - blocked player name
`time` - time
Table prefix_white_list_ip:
`ip` - allowed player IP
Table prefix_white_list_id:
`steam` - allowed player SteamID
If there are no tables, they will be created automatically )
Installation:
1. Edit your addons/sourcemod/configs/databases.cfg file and add a new section (or declare existing in
sm_iprangeban_mysql_prefix):
Code:
"ip_range_ban"
{
"driver" "mysql"
"host" ""
"database" ""
"user" ""
"pass" ""
//"timeout" "0"
//"port" "3306"
}
2. Upload the plugin in the 'addons/sourcemod/plugins/' folder and refrash plugin list or change map or restart server.