=$from and $ip<=$to);
}
}
/* -------------------------------------------------------------
Name: easyban_mysql_install
Purpose: Creates database table if it doesnt exist
Receive: $wpdb, $table_prefix
Return: -none-
------------------------------------------------------------- */
function easyban_mysql_install($wpdb) {
require_once(ABSPATH . 'wp-admin/upgrade-functions.php');
$table_name = $wpdb->prefix . "banned";
$sql = "CREATE TABLE ".$table_name." (
id mediumint(8) unsigned NOT NULL auto_increment,
address varchar(18) NOT NULL default '',
reason varchar(255) NOT NULL default '',
thetime int(15) NOT NULL,
timespan int(15) NOT NULL,
redireto varchar(255) NOT NULL default '',
PRIMARY KEY (id)
);";
dbDelta($sql);
if ( !easyban_mysql_table_exists($wpdb, "banned")) {
add_action('admin_menu', 'easyban_mysql_warning');
}
}
/* -------------------------------------------------------------
Name: easyban_mysql_table_exists
Purpose: Check if the table exists in the database
Receive: $wpdb, $table_name
Return: -none-
------------------------------------------------------------- */
function easyban_mysql_table_exists($wpdb, $table) {
if(!$wpdb->get_results("SHOW TABLES LIKE '%".$wpdb->prefix.$table."%'")) {
return FALSE;
} else {
return TRUE;
}
}
/* -------------------------------------------------------------
Name: easyban_mysql_warning
Purpose: Database errors if things go wrong
Receive: -none-
Return: -none-
------------------------------------------------------------- */
function easyban_mysql_warning() {
echo 'WARNING! The MySQL table was not created! You cannot store bans. Seek support at www.sothq.net.
';
}
/* -------------------------------------------------------------
Name: easyban_remove_expired
Purpose: Removes expired bans
Receive: -none-
Return: -none-
------------------------------------------------------------- */
function easyban_remove_expired() {
global $wpdb;
$SQL = "SELECT id, timespan FROM ".$wpdb->prefix."banned ORDER BY id asc";
$old_bans = $wpdb->get_results($SQL);
foreach($old_bans as $ban) {
if($ban->timespan >= date("U")) {
$delSQL = "DELETE FROM ".$wpdb->prefix."banned WHERE id = ".$ban->id;
$wpdb->query($delSQL);
}
}
}
/* -------------------------------------------------------------
Name: easyban_header
Purpose: Checks if a user is banned or not
Receive: -none-
Return: -none-
------------------------------------------------------------- */
function easyban_header() {
global $wpdb, $easyban_config;
if($easyban_config['status'] == "on"){ ?>
prefix."banned ORDER BY id asc";
$bans = $wpdb->get_results($SQL);
foreach($bans as $ban) {
if(netMatch($ban->address, $_SERVER['REMOTE_ADDR'])) {
if(strlen($ban->redirto)>0){
$REDIR_URL=$ban->redirto;
} else {
$REDIR_URL=$easyban_config['redirect'];
} ?>
You have been banned because of the reason bellow. Redirecting ...
Достъпът ви до този сайт е забранен поради причината по долу. Пренасочване ...
reason)>0) { ?>
reason;?>