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

Platinum gives the ultimate experience by allowing you access to all features and marketing tools of the site for a low monthly investment of $9.99. Show up to 25 samples, and video Professional and Personal profile. Upload 25 samples and video Chance to display as a Featured HotPro. Free HotPro Lounge membership Unlimited Posts for jobs, projects, classifieds, events, blogs, and forums Enhanced search rank   Platinum is the profolio for the serious professional. Platinum's complete arena of self-marketing tools are perfect for creative professionals and businesses who want to expand their business worldwide.  Get exposed and connected to a wide audience in need of your skills and services. Easily create and join groups and build networks with other professionals that will enhance and elevate you to the next level.   Signup to Become Platinum Member       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