<?php
require("admin/config.php");
require("admin/global.php");

$details = mysql_query("SELECT * FROM " . $pre . "lists WHERE t_name='$id'");
if(!$details) {
errorMsg("Cannot query database");
print mysql_error();
} else {

$results = mysql_fetch_array($details);
$generalHeader = $results["generalHeader"];
$generalFooter = $results["generalFooter"];
$welcomeMsg = $results["Welcome"];
$listEmail = $results["Email"];
$listName = $results["Name"];
$welcomeMsgTitle = $results["WelcomeTitle"];
$validMsg = $results["Confirm"];
$validMsgTitle = $results["ConfirmTitle"];
$use_templates = $results["use_templates"];
$use_name = $results["use_name"];
$valid = $results["Send_Confirm"];
$welcome = $results["Send_Welcome"];
$goodbye = $results["Send_Goodbye"];
$unvalid = $results["Send_UnConfirm"];


$listName = stripslashes($listName);
$welcomeMsg = stripslashes($welcomeMsg);
$welcomeMsg = str_replace("\r\n", "\n", $welcomeMsg);
$welcomeMsgTitle = stripslashes($welcomeMsgTitle);
$validMsg = stripslashes($validMsg);
$validMsg = str_replace("\r\n", "\n", $validMsg);
$validMsgTitle = stripslashes($validMsgTitle);


global $listEmail, $listID, $listName, $path;
$headers = "From: $listEmail\n" .
            "Reply-To: $listEmail\n" .
            "X-Mailer: PHP\n" .
            "Return-Path: <$listEmail>\n";

function send_welcome_msg() {
global $email, $listName, $welcomeMsg, $headers, $id, $listEmail, $mymailpath, $welcomeMsgTitle, $uid;
$welcomeMsg = str_replace("%unsub%", "$mymailpath/remove.php?id=$id&uid=$uid", $welcomeMsg);
$welcomeMsg = str_replace("%email%", $email, $welcomeMsg);

$mail_send = mail("$email", $welcomeMsgTitle, $welcomeMsg, $headers);
if(!$mail_send) {

errorMsg("لم يتم إرسال الرسالة إلى البريد: $email.");
}
}

function send_valid_msg() {
global $email, $listName, $validMsg, $headers, $id, $listEmail, $mymailpath, $validMsgTitle, $uid;


$validMsg = str_replace("%unsub%", "$mymailpath/remove.php?id=$id&uid=$uid", $validMsg);
$validMsg = str_replace("%confirm%", "$mymailpath/add.php?id=$id&uid=$uid", $validMsg);
$validMsg = str_replace("%email%", $email, $validMsg);



$mail_send = mail($email, $validMsgTitle, $validMsg, $headers);
if(!$mail_send) {
errorMsg("لم يتم إرسال الرسالة إلى البريد: $email.");
}
}



function headers() {
global $use_templates, $generalHeader, $mymailpath;
if($use_templates == 0) {
if($generalHeader == "") {
$generalHeader = $mymailpath . "/admin/files/g_header.php";
}
@include($generalHeader);
} else {
@include($generalHeader);
}
}

function footers() {
global $use_templates, $generalFooter, $mymailpath;
if($use_templates == 0) {
if($generalFooter == "") {
$generalFooter = $mymailpath . "/admin/files/g_footer.php";
}
@include($generalFooter);
} else {
@include($generalFooter);
}
}

if(mysql_numrows($details) == "0") {

if($use_templates == 0) {
errorMsg("لم يتم العثور على القائمة!");
} else {
$get_t = mysql_query("SELECT * FROM " . $pre . "templates WHERE NameID='invalidlist'");
if(!$get_t) {
errorMsg("Cannot query the database.");
print mysql_error();
} else {
$get_ts = mysql_fetch_array($get_t);
$Value = $get_ts["Value"];
$Value = stripslashes($Value);
print $Value;
}
}

exit();
} 

// CHECK ONE HAS BEEN ENTERED



if($id == "") {

if($use_templates == 0) {
errorMsg("لم تقم بإنشاء قائمة.");
} else {
$get_t = mysql_query("SELECT * FROM " . $pre . "templates WHERE NameID='invalidlist'");
if(!$get_t) {
errorMsg("Cannot query the database.");
print mysql_error();
} else {
$get_ts = mysql_fetch_array($get_t);
$Value = $get_ts["Value"];
$Value = stripslashes($Value);
print $Value;
}
}

exit();
} 

if(!$uid) {

if($email == "") {

if($use_templates == 0) {
errorMsg("لم تدخل بريدك الإلكتروني!");
} else {
$get_t = mysql_query("SELECT * FROM " . $pre . "templates WHERE NameID='noemail'");
if(!$get_t) {
errorMsg("Cannot query the database.");
print mysql_error();
} else {
$get_ts = mysql_fetch_array($get_t);
$Value = $get_ts["Value"];
$Value = stripslashes($Value);
print $Value;
}
}

exit();
} 

$email = trim($email);
if (!(eregi("^[_a-z0-9-]+(.[_a-z0-9-]+)*@([0-9a-z][0-9a-z-]*[0-9a-z].)+[a-z]{2}[mtgvu]?$", $email))) {

if($use_templates == 0) {
errorMsg("فضلاً تأكد من البريد الذي أدخلته.");
} else {
$get_t = mysql_query("SELECT * FROM " . $pre . "templates WHERE NameID='invalidemail'");
if(!$get_t) {
errorMsg("Cannot query the database.");
print mysql_error();
} else {
$get_ts = mysql_fetch_array($get_t);
$Value = $get_ts["Value"];
$Value = stripslashes($Value);
print $Value;
}
}

exit();
} 

$check = mysql_query("SELECT * FROM " . $pre . "c" . $id . " WHERE Email='$email'");
if(!$check) {

errorMsg("Cannot query the database");
print mysql_error();

exit();
} 

$count = mysql_numrows($check);
if($count == "1") {

if($use_templates == 0) {
errorMsg("فضلاً تأكد من البريد الذي أدخلته.");
} else {
$get_t = mysql_query("SELECT * FROM " . $pre . "templates WHERE NameID='already'");
if(!$get_t) {
errorMsg("Cannot query the database.");
print mysql_error();
} else {
$get_ts = mysql_fetch_array($get_t);
$Value = $get_ts["Value"];
$Value = stripslashes($Value);
print $Value;
}
}

exit();
} 

$uid = time();
$uid .= md5($email);
if($valid == "0") {

$insert = mysql_query("INSERT INTO " . $pre . "c" . $id . " SET " .
"Email='$email', " .
"Validated='1', " .
"Name='$name', " .
"Type='$type', " .
"UID='$uid', " .
"Date=CURDATE()");
if(!$insert) {

errorMsg("لم يتم إضافة البريد الإلكتروني.");
print mysql_error();

exit;
} 
if($use_templates == 0) {
errorMsg("شكراً لك، تم إضافة بريدك بنجاح!");
} else {
$get_t = mysql_query("SELECT * FROM " . $pre . "templates WHERE NameID='subsuc'");
if(!$get_t) {
errorMsg("Cannot query the database.");
print mysql_error();
} else {
$get_ts = mysql_fetch_array($get_t);
$Value = $get_ts["Value"];
$Value = stripslashes($Value);
print $Value;
}
}
if($welcome == "1") {
send_welcome_msg();
}

} else {

$insert = mysql_query("INSERT INTO " . $pre . "c" . $id . " SET " .
"Email='$email', " .
"UID='$uid', " .
"Validated='0', " .
"Type='$type', " .
"Name='$name',  " .
"Date=CURDATE()");
if(!$insert) {

errorMsg("لم يتم إضافة البريد الإلكتروني.");
print mysql_error();

exit;
} 

if($use_templates == 0) {
errorMsg("شكراً لك، تم إضافة بريدك بنجاح! <br> thanks alot ! ");

} else {
$get_t = mysql_query("SELECT * FROM " . $pre . "templates WHERE NameID='subsuc'");
if(!$get_t) {
errorMsg("Cannot query the database.");
print mysql_error();
} else {
$get_ts = mysql_fetch_array($get_t);
$Value = $get_ts["Value"];
$Value = stripslashes($Value);
print $Value;
}
}
send_valid_msg();


} #END VALID
} else {
$stuff = mysql_query("UPDATE " . $pre . "c" . $id . " SET Validated='1' WHERE UID='$uid'");
if(!$stuff) {
errorMsg("Cannot query the database.");
print mysql_error();
} else {
$num = mysql_affected_rows();
if($num == "0") {

if($use_templates == 0) {
errorMsg("فضلاً تأكد من البريد الذي أدخلته.");
} else {
$get_t = mysql_query("SELECT * FROM " . $pre . "templates WHERE NameID='existemail'");
if(!$get_t) {
errorMsg("Cannot query the database.");
print mysql_error();
} else {
$get_ts = mysql_fetch_array($get_t);
$Value = $get_ts["Value"];
$Value = stripslashes($Value);
print $Value;
}
}

} else {

if($use_templates == 0) {
errorMsg("You have successfully confirmed your email subscription.");
} else {
$get_t = mysql_query("SELECT * FROM " . $pre . "templates WHERE NameID='confirmsuc'");
if(!$get_t) {
errorMsg("Cannot query the database.");
print mysql_error();
} else {
$get_ts = mysql_fetch_array($get_t);
$Value = $get_ts["Value"];
$Value = stripslashes($Value);
print $Value;
}
}
if($welcome == "1") {
$s_msg = mysql_query("SELECT * FROM " . $pre . "c" . $id . " WHERE UID='$uid'");
if(!$s_msg) {
errorMsg("Cannot query Database.");
print mysql_error();
} else {
$s_msgs = mysql_fetch_array($s_msg);
$email = $s_msgs["Email"];
send_welcome_msg();
}
}

}

}
} #End UID
} #End Detail
?>