prefix . $alertme_table; $current_user = wp_get_current_user(); if ( isset($_POST['submit-check-if-subscribed-as-visitor']) ) { check_admin_referer( 'alert-me-check-if-subscribed-as-visitor' ); $wpdb->query("UPDATE $table_name SET user_id = ". $current_user->ID . " WHERE email = '".$current_user->user_email."'"); } if ( isset($_POST['submit']) ) { check_admin_referer( 'alert-me-unsubscribed-list' ); if (!empty($_POST['unsubscribed_items'])){ foreach ($_POST['unsubscribed_items'] as $key => $unsubscribed_item) { $wpdb->delete( "{$wpdb->prefix}{$alertme_table}", [ 'id' => absint($unsubscribed_item) ], [ '%d' ] ); } } } $sql = "SELECT id, post_id FROM $table_name where id != '' AND email_confirm = 1 AND user_id = ". $current_user->ID; $results = $wpdb->get_results( $sql, 'ARRAY_A' ); $checkIfSubscribedAsVistorQuery = "SELECT count(*) FROM $table_name where id != '' AND email = '".$current_user->user_email."' AND user_id = 0"; $checkIfSubscribedAsVistorResult = $wpdb->get_var($checkIfSubscribedAsVistorQuery); ob_start(); if ( !is_admin() && is_user_logged_in() ) { ?>

0): ?>

$result) { ?>
Page