0)
{
while($qry_retclassi=mysql_fetch_array($qry_selclassi))
{
if($qry_retclassi['enddate']<$currentdate)
{
$qry_updateclassifieds=mysql_query("Update pro_classifiedsposted set paid_status=0 where auto_id=$qry_retclassi[auto_id]");
//////////////////mail to user///////////////////
$qry_selclass_user=mysql_query("select * from pro_users where user_id=$qry_retclassi[user_id]");
$retclaas_user=mysql_fetch_array($qry_selclass_user);
$class_uname=$retclaas_user['fname'].''.$retclaas_user['lname'];
$email=$retclaas_user['email'];
include("includes/class.phpmailer.php");
include("includes/class.smtp.php");
include("includes/mailformat_mem_exp.php");
$mail = new PHPMailer();
$mail->IsMail();
//$mail->IsSMTP(); // set mailer to use SMTP
//$mail->Host = "smtpout.secureserver.net"; // specify main and backup server
//$mail->SMTPAuth = true; // turn on SMTP authentication
//$mail->Username = "nazia@richerwebs.com"; // SMTP username
//$mail->Password = "RWebsnazia"; // SMTP password
$mail->From = "info@hotprofolio.com";//info@hotprofolios.com
$mail->FromName = "info@hotprofolio.com";
$mail->AddAddress($email);//
$mail->AddReplyTo("info@hotprofolio.com");
$mail->IsHTML(true); // set email format to HTML
$mail->Subject = "Alert Message about expiry of Classified posted From HotProfolios";
$mail->Body = $message;
$mail->AltBody = "This is the body in plain text for non-HTML mail clients";
$mail->Send();
///////////////////////end mail//////////////////////////
}
}
}
///////////////////////////////end//////////////////////////////////////////////////////
////////////////////////////check for enddate for projects////////////////////////
$qry_selprojects=mysql_query("select * from pro_projectsposted where paid_status=1");
$count_projects_paid=mysql_num_rows($qry_selprojects);
if($count_projects_paid > 0)
{
while($qry_retprojects=mysql_fetch_array($qry_selprojects))
{
if($qry_retprojects['enddate']<$currentdate)
{
$qry_updateprojects=mysql_query("Update pro_projectsposted set paid_status=0 where auto_id=$qry_retprojects[auto_id]");
//////////////////mail to user///////////////////
$qry_selclass_user=mysql_query("select * from pro_users where user_id=$qry_retprojects[user_id]");
$retclaas_user=mysql_fetch_array($qry_selclass_user);
$class_uname=$retclaas_user['fname'].''.$retclaas_user['lname'];
$email=$retclaas_user['email'];
include("includes/class.phpmailer.php");
include("includes/class.smtp.php");
include("includes/mailexp_projects.php");
$mail = new PHPMailer();
$mail->IsMail();
//$mail->IsSMTP(); // set mailer to use SMTP
//$mail->Host = "smtpout.secureserver.net"; // specify main and backup server
//$mail->SMTPAuth = true; // turn on SMTP authentication
//$mail->Username = "nazia@richerwebs.com"; // SMTP username
//$mail->Password = "RWebsnazia"; // SMTP password
$mail->From = "info@hotprofolio.com";//info@hotprofolios.com
$mail->FromName = "info@hotprofolio.com";
$mail->AddAddress($email);//
$mail->AddReplyTo("info@hotprofolio.com");
$mail->IsHTML(true); // set email format to HTML
$mail->Subject = "Alert Message about expiry of Projects posted From HotProfolio";
$mail->Body = $message;
$mail->AltBody = "This is the body in plain text for non-HTML mail clients";
$mail->Send();
///////////////////////end mail//////////////////////////
}
}
}
//////////////////////////////////////////////end////////////////////////////////////
////////////////////////////check for enddate for events////////////////////////
$qry_selevents=mysql_query("select * from pro_events where paid_status=1");
$count_events_paid=mysql_num_rows($qry_selevents);
if($count_events_paid > 0)
{
while($qry_retevents=mysql_fetch_array($qry_selevents))
{
if($qry_retevents['enddate']<$currentdate)
{
$qry_updateevents=mysql_query("Update pro_events set paid_status=0 where event_id=$qry_retevents[event_id]");
//////////////////mail to user///////////////////
$qry_selclass_user=mysql_query("select * from pro_users where user_id=$qry_retevents[posted_id]");
$retclaas_user=mysql_fetch_array($qry_selclass_user);
$class_uname=$retclaas_user['fname'].''.$retclaas_user['lname'];
$email=$retclaas_user['email'];
include("includes/class.phpmailer.php");
include("includes/class.smtp.php");
include("includes/mailexp_events.php");
$mail = new PHPMailer();
$mail->IsMail();
//$mail->IsSMTP(); // set mailer to use SMTP
//$mail->Host = "smtpout.secureserver.net"; // specify main and backup server
//$mail->SMTPAuth = true; // turn on SMTP authentication
//$mail->Username = "nazia@richerwebs.com"; // SMTP username
//$mail->Password = "RWebsnazia"; // SMTP password
$mail->From = "info@hotprofolio.com";//info@hotprofolios.com
$mail->FromName = "info@hotprofolio.com";
$mail->AddAddress($email);//
$mail->AddReplyTo("info@hotprofolio.com");
$mail->IsHTML(true); // set email format to HTML
$mail->Subject = "Alert Message about expiry of Events posted From HotProfolio";
$mail->Body = $message;
$mail->AltBody = "This is the body in plain text for non-HTML mail clients";
$mail->Send();
///////////////////////end mail//////////////////////////
}
}
}
//////////////////////////////////////////////end////////////////////////////////////
////////////////////////////check for enddate for jobs////////////////////////
$qry_seljobs=mysql_query("select * from pro_jobsposted where paid_status=1");
$count_jobs_paid=mysql_num_rows($qry_seljobs);
if($count_jobs_paid > 0)
{
while($qry_retjobs=mysql_fetch_array($qry_seljobs))
{
if($qry_retjobs['enddate']<$currentdate)
{
//echo "Update pro_jobsposted set paid_status=0 where auto_id=$qry_retevents[auto_id]";
$qry_updatejobs=mysql_query("Update pro_jobsposted set paid_status=0 where auto_id=$qry_retjobs[auto_id]");
//////////////////mail to user///////////////////
$qry_selclass_user=mysql_query("select * from pro_users where user_id=$qry_retjobs[posted_id]");
$retclaas_user=mysql_fetch_array($qry_selclass_user);
$class_uname=$retclaas_user['fname'].''.$retclaas_user['lname'];
$email=$retclaas_user['email'];
include("includes/class.phpmailer.php");
include("includes/class.smtp.php");
include("includes/mailexp_jobs.php");
$mail = new PHPMailer();
$mail->IsMail();
//$mail->IsSMTP(); // set mailer to use SMTP
//$mail->Host = "smtpout.secureserver.net"; // specify main and backup server
//$mail->SMTPAuth = true; // turn on SMTP authentication
//$mail->Username = "nazia@richerwebs.com"; // SMTP username
//$mail->Password = "RWebsnazia"; // SMTP password
$mail->From = "info@hotprofolio.com";//info@hotprofolios.com
$mail->FromName = "info@hotprofolio.com";
$mail->AddAddress($email);//
$mail->AddReplyTo("info@hotprofolio.com");
$mail->IsHTML(true); // set email format to HTML
$mail->Subject = "Alert Message about expiry of Job posted From HotProfolio";
$mail->Body = $message;
$mail->AltBody = "This is the body in plain text for non-HTML mail clients";
$mail->Send();
///////////////////////end mail//////////////////////////
}
}
}
//////////////////////////////////////////////end////////////////////////////////////
////////////////////////////check for enddate for platinum members////////////////////////
$qry_selpl_mem=mysql_query("select * from pro_users where product=1 and paid_status=1");
$count_pl_mem=mysql_num_rows($qry_selpl_mem);
//echo $count_pl_mem;
if($count_pl_mem > 0)
{
//echo "yes";
while($qry_retpl_mem=mysql_fetch_array($qry_selpl_mem))
{
if($qry_retpl_mem['enddate'] < $currentdate)
{
//echo "yes";
//echo "Update pro_users set paid_status=0,product=0,paid_upgrade_status=0,upgrades='' where user_id=$qry_retpl_mem[user_id]";
$qry_updatepl_mem=mysql_query("Update pro_users set paid_status=0,product=0,paid_upgrade_status=0,upgrades='' where user_id=$qry_retpl_mem[user_id]");
//////////////////mail to user///////////////////
//$qry_selclass_user=mysql_query("select * from pro_users where user_id=$qry_retjobs[posted_id]");
//$retclaas_user=mysql_fetch_array($qry_selclass_user);
$class_uname=$qry_retpl_mem['fname'].''.$qry_retpl_mem['lname'];
$email=$qry_retpl_mem['email'];
include("includes/class.phpmailer.php");
include("includes/class.smtp.php");
include("includes/mailexp_platinum.php");
$mail = new PHPMailer();
$mail->IsMail();
//$mail->IsSMTP(); // set mailer to use SMTP
//$mail->Host = "smtpout.secureserver.net"; // specify main and backup server
//$mail->SMTPAuth = true; // turn on SMTP authentication
//$mail->Username = "nazia@richerwebs.com"; // SMTP username
//$mail->Password = "RWebsnazia"; // SMTP password
$mail->From = "info@hotprofolio.com";//info@hotprofolios.com
$mail->FromName = "info@hotprofolio.com";
$mail->AddAddress($email);//
$mail->AddReplyTo("info@hotprofolio.com");
$mail->IsHTML(true); // set email format to HTML
$mail->Subject = "Alert Message about expiry of Platinum Membership from HotProfolio";
$mail->Body = $message;
$mail->AltBody = "This is the body in plain text for non-HTML mail clients";
$mail->Send();
///////////////////////end mail//////////////////////////
}
}
}
//////////////////////////////////////////////end////////////////////////////////////
////////////////////////////check for enddate for hotpro lounge members////////////////////////
$qry_selhl_mem=mysql_query("select * from pro_users where upgrades='hotpro' and paid_upgrade_status=1");
$count_hl_mem=mysql_num_rows($qry_selhl_mem);
//echo $count_hl_mem;
if($count_hl_mem > 0)
{
//echo "yes";
while($qry_rethl_mem=mysql_fetch_array($qry_selhl_mem))
{
if($qry_rethl_mem['enddate'] < $currentdate)
{
//echo "yes";
//echo "Update pro_users set upgrades='' and paid_upgrade_status=0 where user_id=$qry_rethl_mem[user_id]";
$qry_updatepl_mem=mysql_query("Update pro_users set upgrades='',paid_upgrade_status=0 where user_id=$qry_rethl_mem[user_id]");
//////////////////mail to user///////////////////
//$qry_selclass_user=mysql_query("select * from pro_users where user_id=$qry_retjobs[posted_id]");
//$retclaas_user=mysql_fetch_array($qry_selclass_user);
$class_uname=$qry_rethl_mem['fname'].''.$qry_rethl_mem['lname'];
$email=$qry_rethl_mem['email'];
include("includes/class.phpmailer.php");
include("includes/class.smtp.php");
include("includes/mailexp_lounge.php");
$mail = new PHPMailer();
$mail->IsMail();
//$mail->IsSMTP(); // set mailer to use SMTP
//$mail->Host = "smtpout.secureserver.net"; // specify main and backup server
//$mail->SMTPAuth = true; // turn on SMTP authentication
//$mail->Username = "nazia@richerwebs.com"; // SMTP username
//$mail->Password = "RWebsnazia"; // SMTP password
$mail->From = "info@hotprofolio.com";//info@hotprofolios.com
$mail->FromName = "info@hotprofolio.com";
$mail->AddAddress($email);//
$mail->AddReplyTo("info@hotprofolio.com");
$mail->IsHTML(true); // set email format to HTML
$mail->Subject = "Alert Message about expiry of HotPro Lounge Membership from HotProfolio";
$mail->Body = $message;
$mail->AltBody = "This is the body in plain text for non-HTML mail clients";
$mail->Send();
///////////////////////end mail//////////////////////////
}
}
}
//////////////////////////////////////////////end////////////////////////////////////
////////////////////////////check for enddate for Boost upgrade members////////////////////////
$qry_selboost_mem=mysql_query("select * from pro_users where boost_upgrades=1 and paid_boost_status=1");
$count_boost_mem=mysql_num_rows($qry_selboost_mem);
//echo $count_hl_mem;
if($count_boost_mem > 0)
{
//echo "yes";
while($qry_boost_mem=mysql_fetch_array($qry_selboost_mem))
{
if($qry_boost_mem['boost_enddate'] < $currentdate)
{
//echo "yes";
//echo "Update pro_users set boost_upgrades=0,paid_boost_status=0 where user_id=$qry_boost_mem[user_id]";
$qry_updateboost_mem=mysql_query("Update pro_users set boost_upgrades=0,paid_boost_status=0 where user_id=$qry_boost_mem[user_id]");
//////////////////mail to user///////////////////
//$qry_selclass_user=mysql_query("select * from pro_users where user_id=$qry_retjobs[posted_id]");
//$retclaas_user=mysql_fetch_array($qry_selclass_user);
$class_uname=$qry_rethl_mem['fname'].''.$qry_rethl_mem['lname'];
$email=$qry_rethl_mem['email'];
include("includes/class.phpmailer.php");
include("includes/class.smtp.php");
include("includes/mailexp_boost.php");
$mail = new PHPMailer();
$mail->IsMail();
//$mail->IsSMTP(); // set mailer to use SMTP
//$mail->Host = "smtpout.secureserver.net"; // specify main and backup server
//$mail->SMTPAuth = true; // turn on SMTP authentication
//$mail->Username = "nazia@richerwebs.com"; // SMTP username
//$mail->Password = "RWebsnazia"; // SMTP password
$mail->From = "info@hotprofolio.com";//info@hotprofolios.com
$mail->FromName = "info@hotprofolio.com";
$mail->AddAddress($email);//
$mail->AddReplyTo("info@hotprofolio.com");
$mail->IsHTML(true); // set email format to HTML
$mail->Subject = "Alert Message about expiry of Boost Upgrade from HotProfolio";
$mail->Body = $message;
$mail->AltBody = "This is the body in plain text for non-HTML mail clients";
$mail->Send();
///////////////////////end mail//////////////////////////
}
}
}
//////////////////////////////////////////////end////////////////////////////////////
if(isset($_SESSION['us_id']))
{
//echo "Select * from pro_users where user_id = $_SESSION[us_id]";
$qry_usertype=mysql_query("Select * from pro_users where user_id = $_SESSION[us_id]");
$retusertype=mysql_fetch_array($qry_usertype);
}
?>
