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
   
   
     
 
 
Come here to see new and upcoming features offered to enhance your hotprofolio experience.

Schedule bizchat - this is a feature that allows users to click a button on a profile and schedule a chat about a possible job or project you think he or she might be good for.

Scrum - ask questions to get answers and opinions from the HotPro community. There is a vast of knowledge from all industries here.  Take advantage of not having to schedule a consultation or surfing the net for hours to find what could be right here.  Just simply ask the question. 


 
Hot Post - Your next gig is possibly right here. View jobs, and projects posted by other hotpros. Could be professionals that’s in your bizclique. That’s the art of the deal. Connecting to the right people.
Crickets-Hotpros can purchase cheap ad flyers that are displayed throughout our site. It’s another opportunity to be found.
 
 
 
  Who We Are
  Form the Creator
  New & Coming
     
 
 
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