'' . site_url('/?wpcaptcha_unblock=' . $options['global_unblock_key']) . ''));
} else if ($tool == 'empty_log') {
if(!isset($_POST['log'])){
wp_send_json_error(__('Unknown log.', 'advanced-google-recaptcha'));
}
$log = sanitize_key(wp_unslash($_POST['log']));
self::empty_log($log);
wp_send_json_success();
} else if ($tool == 'unlock_accesslock') {
if(!isset($_POST['lock_id'])){
wp_send_json_error(__('Unknown ID.', 'advanced-google-recaptcha'));
}
$lock_id = intval($_POST['lock_id']);
// phpcs:ignore db call warning as we are using a custom table
$wpdb->update( // phpcs:ignore
$wpdb->wpcatcha_accesslocks,
array(
'unlocked' => 1
),
array(
'accesslock_ID' => $lock_id
)
);
wp_send_json_success(array('id' => $lock_id));
} else if ($tool == 'delete_lock_log') {
if(!isset($_POST['lock_id'])){
wp_send_json_error(__('Unknown ID.', 'advanced-google-recaptcha'));
}
$lock_id = intval($_POST['lock_id']);
// phpcs:ignore db call warning as we are using a custom table
$wpdb->delete( // phpcs:ignore
$wpdb->wpcatcha_accesslocks,
array(
'accesslock_ID' => $lock_id
)
);
wp_send_json_success(array('id' => $lock_id));
} else if ($tool == 'delete_fail_log') {
if(!isset($_POST['fail_id'])){
wp_send_json_error(__('Unknown ID.', 'advanced-google-recaptcha'));
}
$fail_id = intval($_POST['fail_id']);
// phpcs:ignore db call warning as we are using a custom table
$wpdb->delete( // phpcs:ignore
$wpdb->wpcatcha_login_fails,
array(
'login_attempt_ID' => $fail_id
)
);
wp_send_json_success(array('id' => $fail_id));
} else if ($tool == 'wpcaptcha_dismiss_pointer') {
delete_option(WPCAPTCHA_POINTERS_KEY);
wp_send_json_success();
} else if ($tool == 'verify_captcha') {
if(!isset($_POST['captcha_type'])){
wp_send_json_error(__('Unknown captcha type.', 'advanced-google-recaptcha'));
}
$captcha_type = sanitize_key(wp_unslash($_POST['captcha_type']));
if(!isset($_POST['captcha_site_key'])){
wp_send_json_error(__('Unknown site key.', 'advanced-google-recaptcha'));
}
$captcha_site_key = sanitize_text_field(wp_unslash($_POST['captcha_site_key']));
if(!isset($_POST['captcha_secret_key'])){
wp_send_json_error(__('Unknown secret key.', 'advanced-google-recaptcha'));
}
$captcha_secret_key = sanitize_text_field(wp_unslash($_POST['captcha_secret_key']));
if(!isset($_POST['captcha_response'])){
wp_send_json_error(__('Unknown response.', 'advanced-google-recaptcha'));
}
$captcha_response = sanitize_text_field(wp_unslash($_POST['captcha_response']));
if($captcha_type == 'builtin' && !isset($_POST['captcha_response_token'])){
wp_send_json_error(__('Unknown response token.', 'advanced-google-recaptcha'));
}
if(isset($_POST['captcha_response_token'])){
$captcha_response_token = sanitize_text_field(wp_unslash($_POST['captcha_response_token']));
} else {
$captcha_response_token = '';
}
$captcha_result = self::verify_captcha($captcha_type, $captcha_site_key, $captcha_secret_key, $captcha_response, $captcha_response_token);
if (is_wp_error($captcha_result)) {
wp_send_json_error($captcha_result->get_error_message());
}
wp_send_json_success($captcha_result);
} else {
wp_send_json_error(__('Unknown tool.', 'advanced-google-recaptcha'));
}
die();
} // ajax_run_tool
/**
* Get rule row html
*
* @return string row HTML
*
* @param array $data with rule settings
*/
static function get_date_time($timestamp)
{
$interval = current_time('timestamp') - $timestamp;
return '' . self::humanTiming($interval, true) . '
' . gmdate('Y/m/d', $timestamp) . ' ' . gmdate('h:i:s A', $timestamp) . '';
}
static function verify_captcha($type, $site_key, $secret_key, $response, $captcha_response_token = false)
{
if ($type == 'builtin') {
if (wp_hash($response) === $captcha_response_token) {
return true;
} else {
return new WP_Error('wpcaptcha_builtin_captcha_failed', __("ERROR: captcha verification failed.
Please try again.", 'advanced-google-recaptcha'));
}
} else if ($type == 'recaptchav2') {
if (!isset($response) || empty($response)) {
return new WP_Error('wpcaptcha_recaptchav2_not_submitted', __("reCAPTCHA verification failed ", 'advanced-google-recaptcha'));
} else {
$response = wp_remote_get('https://www.google.com/recaptcha/api/siteverify?secret=' . $secret_key . '&response=' . $response);
$response = json_decode($response['body']);
if ($response->success) {
return true;
} else {
return new WP_Error('wpcaptcha_recaptchav2_failed', __("reCAPTCHA verification failed ", 'advanced-google-recaptcha') . (isset($response->{'error-codes'}) ? ': ' . implode(',', $response->{'error-codes'}) : ''));
}
}
} else if ($type == 'recaptchav3') {
if (!isset($response) || empty($response)) {
return new WP_Error('wpcaptcha_recaptchav3_not_submitted', __("reCAPTCHA verification failed ", 'advanced-google-recaptcha'));
} else {
$response = wp_remote_get('https://www.google.com/recaptcha/api/siteverify?secret=' . $secret_key . '&response=' . $response);
$response = json_decode($response['body']);
if ($response->success && $response->score >= 0.5) {
return $response->score;
} else {
return new WP_Error('wpcaptcha_recaptchav2_failed', __("reCAPTCHA verification failed ", 'advanced-google-recaptcha') . (isset($response->{'error-codes'}) ? ': ' . implode(',', $response->{'error-codes'}) : ''));
}
}
}
}
/**
* Get human readable timestamp like 2 hours ago
*
* @return int time
*
* @param string timestamp
*/
static function humanTiming($time)
{
$tokens = array(
31536000 => 'year',
2592000 => 'month',
604800 => 'week',
86400 => 'day',
3600 => 'hour',
60 => 'minute',
1 => 'second'
);
if ($time < 1) {
return 'just now';
}
foreach ($tokens as $unit => $text) {
if ($time < $unit) continue;
$numberOfUnits = floor($time / $unit);
return $numberOfUnits . ' ' . $text . (($numberOfUnits > 1) ? 's' : '') . ' ago';
}
}
static function empty_log($log)
{
global $wpdb;
if ($log == 'fails') {
$wpdb->query('TRUNCATE TABLE ' . $wpdb->wpcatcha_login_fails);
} else {
$wpdb->query('TRUNCATE TABLE ' . $wpdb->wpcatcha_accesslocks);
}
}
/**
* Fetch activity logs and output JSON for datatables
*
* @return null
*/
static function get_locks_logs() {
global $wpdb;
check_ajax_referer('wpcaptcha_run_tool');
if (!current_user_can('manage_options')) {
wp_send_json_error(__('You are not allowed to run this action.', 'advanced-google-recaptcha'));
}
$aColumns = array('accesslock_ID', 'unlocked', 'accesslock_date', 'release_date', 'reason', 'accesslock_IP');
$sLimit = '';
if (isset($_GET['iDisplayStart']) && isset($_GET['iDisplayLength']) && $_GET['iDisplayLength'] != '-1') {
$limit_offset = intval($_GET['iDisplayStart']);
$limit_count = intval($_GET['iDisplayLength']);
$sLimit = $wpdb->prepare(" LIMIT %d, %d", $limit_offset, $limit_count);
}
$sOrder = '';
$order_clauses = [];
if (isset($_GET['iSortCol_0']) && isset($_GET['iSortingCols'])) {
for ($i = 0; $i < intval($_GET['iSortingCols']); $i++) {
$iSortCol = isset($_GET['iSortCol_' . $i]) ? intval($_GET['iSortCol_' . $i]) : 0;
$sSortDir = isset($_GET['sSortDir_' . $i]) ? sanitize_key($_GET['sSortDir_' . $i]) : 'asc';
if (isset($_GET['bSortable_' . $iSortCol]) && $_GET['bSortable_' . $iSortCol] === "true") {
$column = $aColumns[$iSortCol];
$dir = ($sSortDir === 'desc') ? 'DESC' : 'ASC';
$order_clauses[] = "`$column` $dir";
}
}
if (!empty($order_clauses)) {
$sOrder = "ORDER BY " . implode(', ', $order_clauses);
}
}
$sWhere = '';
$where_clauses = [];
$query_vars = [];
if (!empty($_GET['sSearch'])) {
$search_term = '%' . $wpdb->esc_like(sanitize_text_field(wp_unslash($_GET['sSearch']))) . '%'; //sanitize_text_field is used to sanitize according to WordPress PCP
$sub_clauses = [];
foreach ($aColumns as $col) {
$sub_clauses[] = "`$col` LIKE %s";
$query_vars[] = $search_term;
}
$where_clauses[] = '(' . implode(' OR ', $sub_clauses) . ')';
}
for ($i = 0; $i < count($aColumns); $i++) {
if (isset($_GET['bSearchable_' . $i]) && $_GET['bSearchable_' . $i] === "true" && !empty($_GET['sSearch_' . $i])) {
$search_term = '%' . $wpdb->esc_like(sanitize_text_field(wp_unslash($_GET['sSearch_' . $i]))) . '%';
$where_clauses[] = "`" . $aColumns[$i] . "` LIKE %s";
$query_vars[] = $search_term;
}
}
if (!empty($where_clauses)) {
$sWhere = "WHERE " . implode(' AND ', $where_clauses);
}
$sql = "SELECT SQL_CALC_FOUND_ROWS " . implode(", ", $aColumns) .
" FROM `{$wpdb->wpcatcha_accesslocks}` $sWhere $sOrder";
if (!empty($sLimit)) {
$sql .= $sLimit;
}
if (!empty($query_vars)) {
$prepared_sql = $wpdb->prepare($sql, $query_vars); //phpcs:ignore
} else {
$prepared_sql = $sql;
}
$rResult = $wpdb->get_results($prepared_sql); //phpcs:ignore
$iFilteredTotal = $wpdb->get_var("SELECT FOUND_ROWS()"); //phpcs:ignore
$iTotal = $wpdb->get_var("SELECT COUNT(`accesslock_ID`) FROM `{$wpdb->wpcatcha_accesslocks}`"); //phpcs:ignore
$output = array(
"sEcho" => isset($_GET['sEcho']) ? intval($_GET['sEcho']) : '',
"iTotalRecords" => $iTotal,
"iTotalDisplayRecords" => $iFilteredTotal,
"aaData" => array()
);
foreach ($rResult as $aRow) {
$row = array();
$row['DT_RowId'] = $aRow->accesslock_ID;
if (strtotime($aRow->release_date) < time()) {
$row['DT_RowClass'] = 'lock_expired';
}
foreach ($aColumns as $col) {
if ($col === 'unlocked') {
$unblocked = $aRow->$col;
if ($unblocked == 0 && strtotime($aRow->release_date) > time()) {
$row[] = '
';
} else {
$row[] = '
';
}
} elseif ($col === 'accesslock_date') {
$row[] = self::get_date_time(strtotime($aRow->$col));
} elseif ($col === 'reason') {
$row[] = $aRow->$col;
} elseif ($col === 'accesslock_IP') {
$row[] = 'Available in PRO';
$row[] = 'Available in PRO';
}
}
$row[] = '
';
$output['aaData'][] = $row;
}
@ob_end_clean();
header('Cache-Control: no-cache, must-revalidate');
header('Expires: Sat, 26 Jul 1997 05:00:00 GMT');
echo json_encode($output);
die();
}
/**
* Fetch activity logs and output JSON for datatables
*
* @return null
*/
static function get_activity_logs() {
global $wpdb;
check_ajax_referer('wpcaptcha_run_tool');
if (!current_user_can('manage_options')) {
wp_send_json_error(__('You are not allowed to run this action.', 'advanced-google-recaptcha'));
}
$options = WPCaptcha_Setup::get_options();
$aColumns = array('login_attempt_ID', 'login_attempt_date', 'failed_user', 'failed_pass', 'login_attempt_IP', 'reason');
$sLimit = '';
if (isset($_GET['iDisplayStart']) && isset($_GET['iDisplayLength']) && $_GET['iDisplayLength'] != '-1') {
$sLimit = "LIMIT %d, %d";
$limit_offset = intval($_GET['iDisplayStart']);
$limit_count = intval($_GET['iDisplayLength']);
}
$sOrder = '';
$order_clauses = [];
if (isset($_GET['iSortCol_0']) && isset($_GET['iSortingCols'])) {
for ($i = 0; $i < intval($_GET['iSortingCols']); $i++) {
$iSortCol = isset($_GET['iSortCol_' . $i]) ? intval($_GET['iSortCol_' . $i]) : 0;
$sSortDir = isset($_GET['sSortDir_' . $i]) ? sanitize_key($_GET['sSortDir_' . $i]) : 'asc';
if (isset($_GET['bSortable_' . $iSortCol]) && $_GET['bSortable_' . $iSortCol] === "true") {
$column = $aColumns[$iSortCol];
$dir = ($sSortDir === 'desc') ? 'DESC' : 'ASC';
$order_clauses[] = "`$column` $dir";
}
}
if (!empty($order_clauses)) {
$sOrder = "ORDER BY " . implode(', ', $order_clauses);
}
}
// filtering
$sWhere = '';
$where_clauses = [];
$query_vars = [];
if (!empty($_GET['sSearch'])) {
$search_term = '%' . $wpdb->esc_like(sanitize_text_field(wp_unslash($_GET['sSearch']))) . '%'; //sanitize_text_field is used to sanitize according to WordPress PCP
$sub_clauses = [];
foreach ($aColumns as $col) {
$sub_clauses[] = "`$col` LIKE %s";
$query_vars[] = $search_term;
}
$where_clauses[] = '(' . implode(' OR ', $sub_clauses) . ')';
}
for ($i = 0; $i < count($aColumns); $i++) {
if (isset($_GET['bSearchable_' . $i]) && $_GET['bSearchable_' . $i] === "true" && !empty($_GET['sSearch_' . $i])) {
$search_term = '%' . $wpdb->esc_like(sanitize_text_field(wp_unslash($_GET['sSearch_' . $i]))) . '%';
$where_clauses[] = "`" . $aColumns[$i] . "` LIKE %s";
$query_vars[] = $search_term;
}
}
if (!empty($where_clauses)) {
$sWhere = "WHERE " . implode(' AND ', $where_clauses);
}
// build query
$sql = "SELECT SQL_CALC_FOUND_ROWS " . implode(", ", $aColumns) .
" FROM " . $wpdb->wpcatcha_login_fails . " $sWhere $sOrder";
if (!empty($sLimit)) {
$sql .= " " . $wpdb->prepare("LIMIT %d, %d", $limit_offset, $limit_count);//phpcs:ignore
}
//phpcs:ignore because the query parts are dynamic based on the number of columns
if (!empty($query_vars)) {
$prepared_sql = $wpdb->prepare($sql, $query_vars);//phpcs:ignore
} else {
$prepared_sql = $sql;
}
$rResult = $wpdb->get_results($prepared_sql); //phpcs:ignore
// filtered count
$iFilteredTotal = $wpdb->get_var("SELECT FOUND_ROWS()"); //phpcs:ignore
// total count
//phpcs: no need to prepare, $sIndexColumn
$iTotal = $wpdb->get_var("SELECT COUNT(`login_attempt_ID`) FROM {$wpdb->wpcatcha_login_fails}"); //phpcs:ignore
// output formatting
$output = array(
"sEcho" => isset($_GET['sEcho']) ? intval($_GET['sEcho']) : '',
"iTotalRecords" => $iTotal,
"iTotalDisplayRecords" => $iFilteredTotal,
"aaData" => array()
);
foreach ($rResult as $aRow) {
$row = array();
$row['DT_RowId'] = $aRow->login_attempt_ID;
foreach ($aColumns as $col) {
if ($col == 'login_attempt_date') {
$row[] = self::get_date_time(strtotime($aRow->$col));
} elseif ($col == 'failed_user') {
$failed_login = 'User: ' . htmlspecialchars($aRow->failed_user) . '
';
if ($options['log_passwords'] == 1) {
$failed_login .= 'Pass: ' . htmlspecialchars($aRow->failed_pass) . '
';
}
$row[] = $failed_login;
} elseif ($col == 'login_attempt_IP') {
$row[] = 'Available in PRO';
$row[] = 'Available in PRO';
} elseif ($col == 'reason') {
$row[] = WPCaptcha_Functions::pretty_fail_errors($aRow->$col);
}
}
$row[] = '
';
$output['aaData'][] = $row;
}
@ob_end_clean();
header('Cache-Control: no-cache, must-revalidate');
header('Expires: Sat, 26 Jul 1997 05:00:00 GMT');
echo json_encode($output);
die();
}
} // class