<?php
$captcha_settings = $wpdb->get_results("SELECT * FROM " . captcha_bank_settings());
if (count($captcha_settings) != 0) {
$captcha_settings_keys = array();
for ($flag = 0; $flag < count($captcha_settings); $flag++) {
array_push($captcha_settings_keys, $captcha_settings[$flag]->settings_key);
}
$index = array_search("captch_title", $captcha_settings_keys);
$captcha_title = $captcha_settings[$index]->settings_value;
$index = array_search("captcha_tooltip", $captcha_settings_keys);
$captcha_tooltip = $captcha_settings[$index]->settings_value;
$index = array_search("captcha_for_login", $captcha_settings_keys);
$captcha_for_login = $captcha_settings[$index]->settings_value;
$index = array_search("captcha_for_register", $captcha_settings_keys);
$captcha_for_register = $captcha_settings[$index]->settings_value;
$index = array_search("captcha_for_reset_password", $captcha_settings_keys);
$captcha_for_reset_password = $captcha_settings[$index]->settings_value;
$index = array_search("captcha_for_comment", $captcha_settings_keys);
$captcha_for_comment = $captcha_settings[$index]->settings_value;
$index = array_search("captcha_for_admin_comment", $captcha_settings_keys);
$captcha_for_admin_comment = $captcha_settings[$index]->settings_value;
$index = array_search("captcha_for_contact_bank", $captcha_settings_keys);
$captcha_for_contact_bank = $captcha_settings[$index]->settings_value;
$index = array_search("hide_captcha_for_reg_user", $captcha_settings_keys);
$hide_captcha_for_reg_user = $captcha_settings[$index]->settings_value;
$index = array_search("captcha_characters", $captcha_settings_keys);
$captcha_characters = $captcha_settings[$index]->settings_value;
$index = array_search("captcha_type", $captcha_settings_keys);
$captcha_type = $captcha_settings[$index]->settings_value;
$index = array_search("captcha_width", $captcha_settings_keys);
$captcha_settings["captcha_text_color"] = "#000000";
$captcha_settings["captcha_font"] = "AHGBold.ttf";
$captcha_settings["show_lines"] = "0";
$captcha_settings["no_of_lines"] = "5";
$captcha_settings["lines_color"] = "#707070";
$captcha_settings["show_noise"] = "0";
$captcha_settings["noise_level"] = "500";
$captcha_settings["noise_color"] = "#707070";
$captcha_settings["text_trasparency"] = "0";
$captcha_settings["trasparency_percentage"] = "40";
$captcha_settings["show_signature"] = "0";
$captcha_settings["signature"] = __("Captcha-Bank", captcha_bank);
$captcha_settings["signature_color"] = "#000000";
$captcha_settings["background_image"] = "bg4.jpg";
$captcha_settings["font_size"] = "30";
$captcha_settings["show_border"] = "0";
$captcha_settings["border_size"] = "1";
$captcha_settings["border_color"] = "#000000";
$captcha_settings["captcha_empty_msg"] = __("Captcha Code is empty. Please enter captcha code.", captcha_bank);
$captcha_settings["captcha_invalid_msg"] = __("The Captcha Code does not match. Please Try Again.", captcha_bank);
$captcha_settings["text_case"] = __("random", captcha_bank);
$captcha_settings["auto_ip_block"] = "1";
$captcha_settings["max_login_attempts"] = "5";
$captcha_settings["ip_block_msg"] = __("Your IP has been blocked!", captcha_bank);
$captcha_settings["max_login_msg"] = __("Maximum Login attempts left [maxAttempts]", captcha_bank);
$captcha_settings["max_login_exceeded_msg"] = __("You have Exceeded Maximum Login Attempts.\nSo, your IP has been blocked for today. \nKindly, try again after 24 Hours.", captcha_bank);
foreach ($captcha_settings as $val => $innerKey) {
$setting_value["settings_key"] = $val;
$setting_value["settings_value"] = $innerKey;
$insert->insert_data(captcha_bank_settings(), $setting_value);
}
global $wpdb;
$wpdb->update($tbl, $data, $where);
}
}
}
if (isset($_REQUEST["param"])) {
switch ($_REQUEST["param"]) {
case "update_captcha_settings":
if (wp_verify_nonce($_REQUEST["_wpnonce"], "captcha_settings")) {
$update = new save_captcha_setting();
$setting_value = array();
$setting_key = array();
$captcha_settings_array = json_decode(stripcslashes(html_entity_decode($_REQUEST["captcha_settings_array"])));
foreach ($captcha_settings_array as $val => $innerKey) {
$setting_value["settings_value"] = htmlspecialchars(htmlspecialchars_decode((string) current($innerKey)));
$setting_key["settings_key"] = key($innerKey);
$update->update_data(captcha_bank_settings(), $setting_value, $setting_key);
}
die;
}
break;
case "captcha_plugin_updates":
if (wp_verify_nonce($_REQUEST["_wpnonce"], "auto_update_captcha_plugin")) {
$captcha_updates = intval($_REQUEST["captcha_updates"]);
update_option("captcha-bank-automatic-update", $captcha_updates);
die;
}
break;
}
}
}
function create_table_captcha_settings()
{
global $wpdb;
$sql = "CREATE TABLE " . captcha_bank_settings() . "(\r\n\t\t\t\tsettings_id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT,\r\n\t\t\t\tsettings_key VARCHAR(200) NOT NULL,\r\n\t\t\t\tsettings_value VARCHAR(200) NOT NULL,\r\n\t\t\t\tPRIMARY KEY (settings_id)\r\n\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci";
dbDelta($sql);
}
