function addmail($nom, $fnom, $lnom, $tel, $mail, $service)
{
// $arrayVariable["column name"] = formatted SQL value
global $db;
$mdp = ChaineAleatoire(8);
$values["pseudo"] = MySQL::SQLValue($nom);
$values["mail"] = MySQL::SQLValue($mail);
$values["tel"] = MySQL::SQLValue($tel);
$values["fonction"] = MySQL::SQLValue($service);
$values["nom"] = MySQL::SQLValue($fnom);
$values["prenom"] = MySQL::SQLValue($lnom);
$values["mdp"] = MySQL::SQLValue($mdp);
// Execute the insert
$result = $db->InsertRow("mail", $values);
// If we have an error
if (createmail($nom, $mdp)) {
if (!$result) {
$db->Kill($result);
return false;
} else {
// createmail($nom,$mdp);
sendmail($fnom, $mail, $nom, $mdp, $lnom);
return true;
}
} else {
return false;
}
}
function createmail($query, $start)
{
$limit = $start;
$mail = new PHPMailer();
$mail->IsSMTP();
// send via SMTP
//IsSMTP(); // send via SMTP
$mail->SMTPAuth = true;
// turn on SMTP authentication
$mail->Username = "******";
// SMTP username
$mail->Password = "******";
// SMTP password
$mail->SMTPKeepAlive = true;
// SMTP connection will not close after each email sent
$webmaster_email = "*****@*****.**";
//Reply to this email ID
$webmaster_name = "admin";
$mail->From = $webmaster_email;
$mail->FromName = $webmaster_name;
$mail->AddReplyTo($webmaster_email, $webmaster_name);
$mail->IsHTML(true);
// send as HTML
$mail->WordWrap = 50;
// set word wrap //only suportsmax 500 users
//$mail->AddAttachment("/var/tmp/file.tar.gz"); // attachment
//$mail->AddAttachment("/tmp/image.jpg", "new.jpg"); // attachment
$mail->Subject = $_REQUEST['subject'];
$mail->Body = $_REQUEST['body'];
//HTML Body
$result = mysql_query($query);
if ($result) {
$count = 0;
while ($post = mysql_fetch_array($result)) {
if ($limit == 0) {
$mail->AddAddress($post['email'], $post['id']);
$count = $count + 1;
if ($count % 500 == 0) {
createmail($query, $count);
break;
}
} else {
continue;
$limit = $limit - 1;
$count = $count + 1;
}
}
if ($count == 0) {
echo "data not found";
}
} else {
echo "error";
}
if (!$mail->Send()) {
echo "Mailer Error: " . $mail->ErrorInfo;
} else {
echo "Message has been sent";
}
}
$date1 = new DateTime();
$date = $date1->format('Y-m-d');
$time = $date1->format('H:i:s');
$userid = $_POST['id'];
$sentby1 = $_POST['sentby'];
//echo $date . $time . $userid . $sentby1 . gettype($_POST['sentby']);
$query1 = "INSERT INTO `snail_mail`(`date`, `time`, `id`, `sentby`) VALUES (NOW() , NOW(), {$userid} , '' '.{$sentby1}.' '') ";
//$query1="INSERT INTO `snail_mail`(`date`, `time`, `id`, `sentby`) VALUES (2013-03-27 , '06:50:50' , '201001199' ,'spped postr') ";
$result = mysql_query($query1);
if ($result == false) {
echo 'some thing went wrong !!!!!!!!' . mysql_error();
} else {
echo '<br><br><br>';
echo 'Snail mail update added successfully for ' . $userid;
echo '<br><br><br>';
createmail($userid, $sentby1);
}
//5. close connection
?>
<?php
function createmail($userid, $sentby)
{
require_once "db.php";
$result3 = mysql_query("SELECT t2.email FROM (select * from login where login_id = '{$userid}') as t1 LEFT JOIN residents as t2 on (t1.login_id = t2.login_id ) ");
$row1 = mysql_fetch_array($result3);
$mail = new PHPMailer();
$mail->IsSMTP();
$mail->SMTPAuth = true;
// turn on SMTP authentication
$mail->Username = "******";
$id = $_GET['id'] ? intval($_GET['id']) : 0;
if (submitcheck('resendsubmit')) {
if (empty($id)) {
showmessage('send_result_3');
}
$query = $_SGLOBAL['db']->query("SELECT * FROM " . tname('invite') . " WHERE id='{$id}' AND uid='{$_SGLOBAL['supe_uid']}' ORDER BY id DESC");
if ($value = $_SGLOBAL['db']->fetch_array($query)) {
if ($reward['credit']) {
$inviteurl = "{$siteurl}invite.php?{$value[id]}{$value[code]}";
// $inviteurl = "http://openid.enjoyoung.cn/account/new?{$value[id]}{$value[code]}&renturn_to=uchome";
} else {
$inviteurl = "{$siteurl}invite.php?u={$space['uid']}&c={$invite_code}";
// $inviteurl = "http://openid.enjoyoung.cn/account/new?u=$space[uid]&c=$invite_code&renturn_to=uchome";
}
$mailvar[4] = $inviteurl;
createmail($value['email'], $mailvar);
showmessage('send_result_1', $_POST['refer']);
} else {
showmessage('send_result_3');
}
}
} elseif ($_GET['op'] == 'delete') {
$id = $_GET['id'] ? intval($_GET['id']) : 0;
if (empty($id)) {
showmessage('there_is_no_record_of_invitation_specified');
}
$query = $_SGLOBAL['db']->query("SELECT * FROM " . tname('invite') . " WHERE id='{$id}' AND uid='{$_SGLOBAL['supe_uid']}'");
if ($value = $_SGLOBAL['db']->fetch_array($query)) {
if (submitcheck('deletesubmit')) {
$_SGLOBAL['db']->query("DELETE FROM " . tname('invite') . " WHERE id='{$id}'");
showmessage('do_success', $_POST['refer']);
$value = $value + 1;
$query = $query . " where ";
} else {
if ($value == 1) {
$query = $query . " and ";
}
}
$query = $query . " floor ='" . $floor . "'";
}
if (isset($_REQUEST['cprog'])) {
$prog = $_REQUEST['prog'];
echo $prog;
if ($value == 0) {
$value = $value + 1;
$query = $query . " where ";
} else {
if ($value == 1) {
$query = $query . " and ";
}
}
$query = $query . " program ='" . $prog . "'";
}
echo $query . ";";
createmail($query);
//////
include "mail.php";
mysql_close();
?>
</body>
</html>
