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); } ?>
Hot Profolios
  Create free profolio now  Login Login
   
   
     
 
Professionals get noticed by showcasing your skills or services and increase your work flow.
Thriving companies market, advertise and prospect with a multi-talented audience just waiting to be found.
College Grads and Newbies connect with highly experienced professionals or individuals looking for fresh new talent and ideas
See this week's featured successful Pro. find out how they did it!
 
WHERE THE HOTTEST PROFESSIONALS
WANT TO BE FOUND
  
 
     
 
Advertiser About Us r From the Creator rNew & Coming r Contact Us r Privacy Policy l Terms of Use l HotProfolio.com © 2007. All rights reserved