< ?php global $wpdb;$your_website_s_url = get_bloginfo(‘wpurl’); $current_user = wp_get_current_user(); $current_user_s_email = $current_user->user_email;
$tableName = $wpdb->prefix . ‘newsletter’;
$the_newsletter_s_array = $wpdb->get_results( “SELECT * FROM {$tableName} WHERE email = ‘$current_user_s_email’”);
foreach ( $the_newsletter_s_array as $subscriber_s_email ){
$unsubscribe_link = $your_website_s_url . “/?na=uc&nk=” . $subscriber_s_email->id . “-” . $subscriber_s_email->token;
}
$subscribe_link = $your_website_s_url . “?na=s”;
?>