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); } ?>

You have successfully registered as a platinum member You have successfully registered as a Hotpro Lounge member   Everything you need is right here. Update, Manage and Modify your profolio and marketing efforts as often as you like. Remember good business is staying connected. Good Luck! Profile Alerts : Your Profile has been viewed times   You have a: Profolio You are logged in as:         Manage Profile Upgrade View Profile Inbox0) { ?>() Hot Posts Crickets Scrum HotPro Lounge My Bizclique Invite a friend Upload Samples Supply Bin

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