$query = $wpdb->prepare("SELECT * FROM {$subscribers_table} WHERE id=%d AND hash='%s' AND active=1 AND confirmed=0", $id, $hash);
$subs = $wpdb->get_results($query);
if (count($subs) == 0) {
?>
<div align="center"><h2>Your subscription does not exist or you are already subscribed. </h2></div>
<?php
exit;
}
$subs = $subs[0];
$query = $wpdb->prepare("UPDATE {$subscribers_table} set confirmed=1, active=1 where id=%d and hash='%s';", $id, $hash);
$wpdb->query($query);
$redirectionUrl = home_url("/?wpr-confirm=2");
$subscriber = _wpr_subscriber_get($id);
_wpr_move_subscriber($subscriber->nid, $subscriber->email);
//This subscriber's follow up subscriptions' time of creation should be updated to the time of confirmation.
$currentTime = time();
$followup_subscriptions_table = $wpdb->prefix . "wpr_followup_subscriptions";
$query = $wpdb->prepare("UPDATE {$followup_subscriptions_table} SET doc='%s', last_date='%s' WHERE sid=%d;", $currentTime, $currentTime, $id);
$wpdb->query($query);
do_action("_wpr_subscriber_confirmed", $id);
sendConfirmedEmail($id);
?>
<script>
window.location='<?php
echo $redirectionUrl;
?>
';
</script>
<?php
$size = ob_get_length();
do_action("_wpr_autoresponder_process_subscriber_day_zero", $id);
$link = linkDatabase() or die(_("Connection error!"));
$qry = get_user_by_email($link, $email);
$user = mysql_fetch_assoc($qry);
$nickname_db = $user["nickname"];
$firstname_db = $user["firstname"];
$email_db = $user["email"];
$key_md5 = md5($nickname_db . $email_db);
$confirm_key = $user["confirmkey"];
$confirm_date = $user["confirmdate"];
if ($key_md5 === $confirm_key && $confirm_date) {
$form = formSigninBS();
} else {
if ($key_md5 === $key) {
$updated = update_confirmed_user($link, $nickname_db, $email_db, $key_md5);
if ($updated) {
sendConfirmedEmail($nickname_db, $firstname_db, $email_db);
$form = formConfirmedBS();
} else {
$form = "Occured a database error, please contact '*****@*****.**'";
}
} else {
$form = "Wrong data. Please enter in contact with '*****@*****.**'.";
}
}
}
break;
case "send-again-email-confirm-register":
sendRegisterEmail($nickname, $firstname, $email);
$form = formConfirmBS();
break;
case "test-register-email":
