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

Silver is our basic profile offer for free. Membership Can upload 10 photos/ samples. Professional Profile offered for free. Upload 10 samples. Join groups and post blogs. Easily Build Networks. Profile alerts   Sliver is the profolio for professionals to get to know us and the benefits of being a HotPro. Silver membership gives the opportunity to have exposure worldwide with access to self-marketing tools that allow you to showcase your skills and services, and build networks cost effectively.         Silver   Platinum   Upgrades

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