if (isnum(isset($_REQUEST['id'])) AND isset($_REQUEST['activate'])) {
echo "<div style='text-align:center'>\n";
$get_vc = dbquery("SELECT * FROM ".DB_NEWS_LETTER_SUBS." WHERE nl_sub_id='".$_REQUEST['id']."'");
$get_vca = dbarray($get_vc);
$get_vcr = dbrows($get_vc);
if ($get_vcr != 0) {
if ($get_vca['nl_sub_stat'] == 0) {
$get_vn = dbquery("SELECT * FROM ".DB_NEWS_LETTER_VALIDATE." WHERE validate_code='".$_REQUEST['activate']."'");
$get_vna = dbarray($get_vn);
$get_vnr = dbrows($get_vn);
if ($get_vnr != 0) {
$result = dbquery("UPDATE ".DB_NEWS_LETTER_SUBS." SET nl_sub_stat='1' WHERE nl_sub_id ='".$_REQUEST['id']."'");
$result = dbquery("DELETE FROM ".DB_NEWS_LETTER_VALIDATE." WHERE validate_code='".$_REQUEST['activate']."'");
// send pm to site admin
$pm_send = dbquery("SELECT nl_sub_id, nl_sub_mail, nl_sub_name, nl_sub_stat FROM ".DB_NEWS_LETTER_SUBS." WHERE nl_sub_stat='1' AND nl_sub_id='".$_REQUEST['id']."'");
if (dbrows($pm_send) != 0) {
require_once INCLUDES."infusions_include.php";
while($data = dbarray($pm_send)) {
$sendr = $data['nl_sub_mail'];
$pnam = $data['nl_sub_name'];
$recvr = 1;
$sndit = ($locale['nl_498']."".$pnam.$locale['nl_499']);
send_pm($recvr, $sendr, $locale['nl_497'], $sndit);
}
}
// end pm send
Category Forum
Modifications and Requests - 8Labels
Statistics
1 participant
Notifications
You are not receiving notifications from this thread.
Related Questions