$mail->SetFrom(MAIL_FROM, 'SEffervescence IIITA');
$mail->From = MAIL_FROM; //From Address -- CHANGE --^M
$mail->FromName = "Effervescence IIITA"; //From Name -- CHANGE --^M
$mail->AddAddress($subscriberEmail, ""); //To Address -- CHANGE --^M
if(!$mail->Send()) {
return 0;
}
return 1;
}
*/
function getInactiveUsers()
{
$sql = "SELECT * FROM `users` WHERE isactive=0 AND isdeleted=0 ORDER BY `added_on` DESC LIMIT 151,200";
$result = DatabaseHandler::GetAll($sql);
return $result;
}
function updateIssent($username)
{
$sql = "UPDATE users SET issent=1 WHERE username=:username";
$params = array(':username' => $username);
$result = DatabaseHandler::Execute($sql, $params);
}
$iUsers = getInactiveUsers();
for ($i = 0; $i < count($iUsers); $i++) {
echo $iUsers[$i]['email'] . "<br/>";
sendAccountConfmail($iUsers[$i]['username']);
updateIssent($iUsers[$i]['username']);
}
sendAccountConfmail('testingAgain');
updateIssent('testingAgain');
<?php
require_once "config/config.php";
require_once "models/database.php";
require_once "api/contentFunctions.php";
require_once "api/sessionFunctions.php";
require_once 'api/mailFunctions.php';
require_once "business/Database_handler.class.php";
require_once "business/Link.class.php";
function getInactiveUsers()
{
$sql = "SELECT * FROM `users` WHERE isactive=0 AND isdeleted=0";
$result = DatabaseHandler::GetAll($sql);
return $result;
}
$iUsers = getInactiveUsers();
for ($i = 0; $i < count($iUsers); $i++) {
echo $iUsers[$i]['email'] . "<br/>";
sendAccountConfmail($iUsers[$i]['username']);
// sendAccountConfmail('test');
}
