''))
{
if($_REQUEST['profession']=='All')
{
$condition="(profession LIKE '%Freelancer%' OR profession LIKE '%Executive%' OR profession LIKE '%Rookie%') and ";
}
elseif($_REQUEST['profession']=='Freelancer')
{
$condition="(profession = 'Freelancer-professional' OR profession = 'Freelancer-business owner') and ";
}
elseif($_REQUEST['profession']=='Executive')
{
$condition="(profession = 'Executive-business owner' OR profession = 'Executive-professional') and ";
}
elseif($_REQUEST['profession']=='Rookie')
{
$condition="(profession = 'Rookie-college grad' OR profession = 'Rookie-new business owner') and ";
}
}
if((isset($_REQUEST['country']))&($_REQUEST['country']<>'0'))
{
$condition.=" country = '".$_REQUEST['country']."' and ";
}
if((isset($_REQUEST['state']))&($_REQUEST['state']<>'0'))
{
$condition.=" state = '". $_REQUEST['state']."' and ";
}
if((isset($_REQUEST['city']))&($_REQUEST['city']<>'0'))
{
$condition.=" city like '". $_REQUEST['city']."' and ";
}
if((isset($_REQUEST['industry']))&($_REQUEST['industry']<>'0'))
{
$condition.=" industry = '". $_REQUEST['industry']."' and ";
}
if((isset($_REQUEST['functional_area']))&($_REQUEST['functional_area']<>'0'))
{
$condition.=" specialization like '%". $_REQUEST['functional_area']."%' and ";
}
if((isset($_REQUEST['searchfld']))&($_REQUEST['searchfld']<>''))
{
$condition.="(fname like '%".$_REQUEST['searchfld']."%' OR lname LIKE '%".$_REQUEST['searchfld']."%' OR email LIKE '%".$_REQUEST['searchfld']."%' OR phone LIKE '%".$_REQUEST['searchfld']."%' OR gender LIKE '%".$_REQUEST['searchfld']."%' OR state LIKE '%".$_REQUEST['searchfld']."%' OR country LIKE '%".$_REQUEST['searchfld']."%' OR zipcode LIKE '%".$_REQUEST['searchfld']."%' OR profession LIKE '%".$_REQUEST['searchfld']."%' OR industry LIKE '%".$_REQUEST['searchfld']."%' OR product LIKE '%".$_REQUEST['searchfld']."%' OR company_name LIKE '%".$_REQUEST['searchfld']."%' OR specialization LIKE '%".$_REQUEST['searchfld']."%' OR motto LIKE '%".$_REQUEST['searchfld']."%' OR usertype LIKE '%".$_REQUEST['searchfld']."%' OR nickname LIKE '%".$_REQUEST['searchfld']."%' OR interest LIKE '%".$_REQUEST['searchfld']."%' OR favorite_books LIKE '%".$_REQUEST['searchfld']."%' OR favourite_movies LIKE '%".$_REQUEST['searchfld']."%' OR favourite_flash LIKE '%".$_REQUEST['searchfld']."%' OR personalmotto LIKE '%".$_REQUEST['searchfld']."%' OR seeking LIKE '%".$_REQUEST['searchfld']."%' OR Ethnicity LIKE '%".$_REQUEST['searchfld']."%' OR Interestedinseeking LIKE '%".$_REQUEST['searchfld']."%' OR city LIKE '%".$_REQUEST['searchfld']."%' OR age LIKE '%".$_REQUEST['searchfld']."%') and ";
}
$condition=substr($condition,0,-4);
//echo "select * from pro_users where hideprofile=0 and ".$condition;exit;
$Totitems="select * from pro_users where hideprofile=0 and ".$condition;
$total=getSqlNumber($Totitems);
$allpages=$total/$limit;
$totalpages=ceil($allpages);//echo $totalpages;exit;
if($start>0)
{
$pagenumber=ceil($total/$start);
}
//echo "select * from pro_users where hideprofile=0 and".$condition." order by boost_upgrades desc, product desc LIMIT $start,$limit";exit;
$sql_event="select * from pro_users where hideprofile=0 and".$condition." order by boost_upgrades desc, product desc LIMIT $start,$limit";
$exec_query=mysql_query($sql_event);
?>
HotProfolio Search Results
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);
}
?>
