$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":