ob_start();
session_start();
include("includes/dbconfig.php");
$limit = '10';
if($_GET['start']!='') {
$start = $_GET['start'];
} else {
$start = 0;
}
$filePath = "more_featuredevents.php";
//$otherParams ="&project_catid=".$_REQUEST['project_catid'];
//$Totitems="Select * from pro_events where posted_id='".$_SESSION['user_id']."' and featuredevent_status=1";
$Totitems="Select * from pro_events where featuredevent_status=1";
$total=getSqlNumber($Totitems);
$allpages=$total/$limit;
$totalpages=ceil($allpages);//echo $totalpages;exit;
$qGetgroupdetails= "Select * from pro_events where featuredevent_status=1 order by date_featured LIMIT $start,$limit";
$resgroup=getSqlQuery($qGetgroupdetails);
if($start>0)
{
$pagenumber=ceil($total/$start);
}
?>
Welcome to Hot Profolio
////////////////////////////check for enddate for classifieds////////////////////////
$currentdate=date("Y-m-d");
//echo $currentdate;
$qry_selclassi=mysql_query("select * from pro_classifiedsposted where paid_status=1");
$count_classi_paid=mysql_num_rows($qry_selclassi);
if($count_classi_paid > 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);
}
?>