function create_table_captcha_log()
{
global $wpdb;
$sql = "CREATE TABLE " . captcha_bank_log() . "(\r\n\t\t\t\tid INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,\r\n\t\t\t\tusername VARCHAR(100) NOT NULL,\r\n\t\t\t\tip_address VARCHAR(20) NOT NULL,\r\n\t\t\t\tgeo_location VARCHAR(200) NOT NULL,\r\n\t\t\t\tlatitude VARCHAR(50) NOT NULL,\r\n\t\t\t\tlongitude VARCHAR(50) NOT NULL,\r\n\t\t\t\tdate_time DATETIME,\r\n\t\t\t\tcaptcha_status INTEGER(1) NOT NULL,\r\n\t\t\t\tblock_ip INTEGER(1) NOT NULL,\r\n\t\t\t\tPRIMARY KEY (id)\r\n\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci";
dbDelta($sql);
}
switch ($captcha_role) {
case "administrator":
$user_role_permission = "manage_options";
break;
case "editor":
$user_role_permission = "publish_pages";
break;
case "author":
$user_role_permission = "publish_posts";
break;
}
if (!current_user_can($user_role_permission)) {
return;
} else {
$alternate = "";
$logs = $wpdb->get_results("SELECT * FROM " . captcha_bank_log() . " order by date_time desc");
?>
<div class="fluid-layout wpcb-page-width">
<div class="layout-span12">
<div class="widget-layout">
<div class="widget-layout-title">
<h4><?php
_e("Login Logs", captcha_bank);
?>
</h4>
</div>
<div class="widget-layout-body">
<div class="fluid-layout wpcb-page-width">
<div class="layout-span12">
<div class="widget-layout">
<div class="widget-layout-title">
if (strlen($captcha_challenge_field) > 0) {
if (isset($_SESSION["6_letters_code"])) {
if ($captcha_case_sensitive == "1") {
$code = $_SESSION["6_letters_code"];
} else {
$code = strtolower($_SESSION["6_letters_code"]);
}
if ($code != $captcha_challenge_field) {
$errors = "invalid";
$setting_value["captcha_status"] = 0;
} else {
$setting_value["captcha_status"] = 1;
}
}
}
$insert->insert_data(captcha_bank_log(), $setting_value);
}
return $errors;
}
}
if (!function_exists("captcha_errors")) {
function captcha_errors($errors = NULL)
{
global $wpdb;
if (file_exists(WP_CAPTCHA_BK_PLUGIN_DIR . "/lib/get-settings.php")) {
include WP_CAPTCHA_BK_PLUGIN_DIR . "/lib/get-settings.php";
}
if (isset($_REQUEST["captcha_challenge_field"])) {
if ($captcha_case_sensitive == "1") {
$captcha_challenge_field = trim($_REQUEST["captcha_challenge_field"]);
} else {
