<?
ob_start();
session_start();
include('includes/dbconfig.php');
include('includes/constants.php');
extract($_REQUEST);
$limit = '10';
	if($_GET['start']!='') {
		$start = $_GET['start'];
	} else {
		$start = 0;
	}
$filePath = "loungesearch.php";
$otherParams ="&nickname=".$_REQUEST['nickname']."&country=".$_REQUEST['country']."&city=".$_REQUEST['city']."&state=".$_REQUEST['state']."&gender=".$_REQUEST['gender1']."&seek1=".$seek1."&age=".$_REQUEST['age']."&age1=".$_REQUEST['age1']."&ethinicity=".$_REQUEST['ethinicity'];			  
$_SESSION[lounge_otherParams]=$otherParams;
$_SESSION[loungeotherParams]=$otherParams;
//echo $_SESSION[lounge_otherParams];
?>
<?

if(isset($_REQUEST['request']) && $_REQUEST['request']=='addbiz')
{

$selfrnd=mysql_query("select * from pro_hotprofrnds where user_id='$_SESSION[user_id]' and profile_id='$_REQUEST[profile_id]'");
$selcn=mysql_num_rows($selfrnd);
if($selcn>0)
{
$da=mysql_fetch_array($selfrnd);
if($da[request_status]==0)
{
header("location:myhotprofrnds.php?act=fail");
}
if($da[request_status]==1)
{
header("location:myhotprofrnds.php?act=fail1");
}
}
else
{
//echo "Insert into pro_hotprofrnds(user_id,link,profile_id,request_status,date_requested,delete_status)values('".$_SESSION['user_id']."','".$_REQUEST['link']."','".$_REQUEST['profile_id']."',0,now(),0)";exit;
$addbizclique=mysql_query("Insert into pro_hotprofrnds(user_id,link,profile_id,request_status,date_requested,delete_status)values('".$_SESSION['user_id']."','".$_REQUEST['link']."','".$_REQUEST['profile_id']."',0,now(),0)");
	header("location:myhotprofrnds.php?act=success");
}

}

?>
<? 
				  
				 		if((isset($_REQUEST['nickname']))&($_REQUEST['nickname']<>''))
						{
							$condition=" nickname like '%".$_REQUEST['nickname']."%' and ";
						}
				  
				  		if((isset($_REQUEST['country']))&($_REQUEST['country']<>'0'))
						{
							$condition.=" country like '%".$_REQUEST['country']."%' and ";
							
						}
						
						if((isset($_REQUEST['state']))&($_REQUEST['state']<>'0'))
						{
						
							$condition.=" state like '%". $_REQUEST['state']."%' and ";
						}
						
						if((isset($_REQUEST['city']))&($_REQUEST['city']<>''))
						{
							$condition.=" city like '%". $_REQUEST['city']."%' and ";
						
						}
						
						if((isset($_REQUEST['ethinicity']))&($_REQUEST['ethinicity']<>'0'))
						{
							$condition.=" Ethnicity like '%". $_REQUEST['ethinicity']."%' and ";
						
						}
						
						if((isset($_REQUEST['gender']))&($_REQUEST['gender']<>''))
						{
							$condition1 =" gender like '%".$_REQUEST['gender']."%' and ";
						
						}
/*						if((isset($_REQUEST['gender1']))&($_REQUEST['gender1']<>''))
						{
						   $condition1=substr($condition1,0,-3);
							$condition1.=$_REQUEST['gender1']."%' and";
						
						}
*/					    if($condition1<>'')
						{
						$condition.=$condition1;
						}					
						
						if((isset($_REQUEST['seek']))&($_REQUEST['seek']<>''))
						{
						$condition.="(";
							foreach($_REQUEST['seek'] as $seek)
							{
							$condition.=" seeking like '%". $seek."%' or ";
							$seek1.=$seek.",";
							}
							$seek1=substr($seek1,0,-1);
							$condition=substr($condition,0,-3);
							//$seek1=substr($seek1,0,-3);
							$condition.=") and ";
						}
						
						if((isset($_REQUEST['seek1']))&($_REQUEST['seek1']<>''))
						{
							$se1=explode(",",$_REQUEST['seek1']);
							foreach($se1 as $seek)
							{
							$condition.=" seeking like '%". $seek."%' or ";
							$seek1.=$seek.",";
						}
						$seek1=substr($seek1,0,-1);
						$condition=substr($condition,0,-3);
						$condition.=") and ";
						}
						
						
						if((isset($_REQUEST['age']))&($_REQUEST['age']<>'')&($_REQUEST['age1']==''))
						{
							$condition.=" seeking like '%". $_REQUEST['seek']."%' and ";
						
						}
						
						if((isset($_REQUEST['age']))&($_REQUEST['age']<>'')&(isset($_REQUEST['age1']))&($_REQUEST['age1']<>''))
						{
							$condition.=" age between '".$_REQUEST['age']."' and '". $_REQUEST['age1']."' and ";
						
						}
						
				//echo $condition;
				  
				 $condition=substr($condition,0,-4);
				
				
				if($_REQUEST['nickname']=="" && $_REQUEST['country']=='0' && $_REQUEST['state']=='0' && $_REQUEST['city']=="" && $_REQUEST['ethinicity']=='0' && $_REQUEST['gender']=='' && $_REQUEST['age']=="" && $_REQUEST['age']=="")
				{
					//echo "select * from pro_users where hideprofile='0' and (upgrades='hotpro' or product='1')";exit;
					$Totitems=mysql_query("select * from pro_users where hideprofile='0' and (upgrades='hotpro' or product='1')");
				}else
				{
					//echo "select * from   pro_users   where ".$condition." and (upgrades='hotpro' or product='1') and hideprofile='0'";exit;
					$Totitems=mysql_query("select * from   pro_users   where ".$condition." and (upgrades='hotpro' or product='1') and hideprofile='0'");
				}
				$total=mysql_num_rows($Totitems);
				$allpages=$total/$limit;
				$totalpages=ceil($allpages);//echo $totalpages;exit;								
				if($start>0)
				{
					$pagenumber=ceil($total/$start);
				}
				if($_REQUEST['nickname']=="" && $_REQUEST['country']=='0' && $_REQUEST['state']=='0' && $_REQUEST['city']=="" && $_REQUEST['ethinicity']=='0' && $_REQUEST['gender']=='' && $_REQUEST['age']=="" && $_REQUEST['age']=="")
				{
				    //echo "select * from pro_users where hideprofile='0' and (upgrades='hotpro' or product='1') LIMIT $start,$limit";exit;
					$sql_event="select * from pro_users where hideprofile='0' and (upgrades='hotpro' or product='1') and hideprofile='0' order by boost_upgrades desc,product desc,upgrades desc  LIMIT $start,$limit";
				}else
				{
					$sql_event="select * from pro_users where ".$condition." and (upgrades='hotpro' or product='1') and hideprofile='0' order by boost_upgrades desc,product desc,upgrades desc  LIMIT $start,$limit";

				}
					//echo $sql_event;exit;
				  	$exec_query=mysql_query($sql_event);
						
						
				  ?>	
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>HotProfolio Lounge-Find Friendship Date or Penpal </title>
<META name="description" CONTENT="Professional directory connecting freelancers, professionals, and businesses of all industries.  Use free portfolio, free job posts, video ads, flyer ads, and more to promote your business or products.">
<META name="keywords" CONTENT="<portfolios, online portfolio, freelancer, jobs, advertise, developers, web design, print design, art, artist, creative, graphic design, photography, illustration, logo design, brand, promote, projects, images">
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
	background-color: #000000;
}
-->
</style>
<link href="includes/styles.css" rel="stylesheet" type="text/css" />
<script language="javascript" src="includes/menu.js"></script>
<script language="JavaScript">
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}


//-->
</script>

<script language=JavaScript>

function sendflirt(user_id)
{
	//alert(email);
window.open('sendflirt.php?userid='+user_id,'editpictures','toolbar=no,menubar=no,location=no,resizable=no,scrollbars=yes,width=480,height=250,top=250,left=225');
}

function windowopen_message(user_id,results)
{
	//alert(email);
window.open('sendmessage.php?id='+user_id+'&page='+results,'editpictures','toolbar=no,menubar=no,location=no,resizable=no,scrollbars=yes,width=503,height=460,top=250,left=225');
}


function checkclear()
	{
	
		
		if (document.searchform.searchword.value=="Search Here")
		
			{
				document.searchform.searchword.value = "";
				
			}
	}

function checkform()

	{
		 if (document.searchform.searchword.value=="")
			{
				alert('Please Enter A Value To Search');
				document.searchform.searchword.focus();
				return false;
			}
		else
			{
				return true;
			}					
	}	

</script>

<script language="JavaScript" src="mm_menu.js"></script>
</head>
<body onload="MM_preloadImages('images/create1.gif','images/login1.gif');goforit();">
<script language=JavaScript>

var message="Copyright WWW.HOTPROFOLIO.COM!";


function clickIE4(){
if (event.button==2){
alert(message);
return false;
}
}

function clickNS4(e){
if (document.layers||document.getElementById&&!document.all){
if (e.which==2||e.which==3){
alert(message);
return false;
}
}
}

if (document.layers){
document.captureEvents(Event.MOUSEDOWN);
document.onmousedown=clickNS4;
}
else if (document.all&&!document.getElementById){
document.onmousedown=clickIE4;
}

document.oncontextmenu=new Function("alert(message);return false")


</script>
<script language="JavaScript1.2">mmLoadMenus();</script>
<table width="940" border="0" align="center" cellpadding="0" cellspacing="0">
 <?
////////////////////////////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);	
}
?>
<!--<body onLoad="getModule('EGXX0004',0)">
-->
<script language="javascript">
function clear_textbox()
{

if(document.sear.searchfld.value="Search Here")
{
document.sear.searchfld.value=""
}
}

</script>
<!-- Dependency -->
<script src="includes/yahoo-min.js"></script>
 <!--Source file -->
<script src="includes/connection-min.js"></script>

<script TYPE="text/javascript">
function submitenter(myfield,e)
{
	var keycode;
	if (window.event) keycode = window.event.keyCode;
	else if (e) keycode = e.which;
	else return true;

	if (keycode == 13)
	{
		getModule(myfield,0);
		return false;
	}
	else
	return true;
}

</script>
<script language="javascript">
function searchvalidate(f)
{
	//alert("success");
	if(f.search_text.value!=" ")
	{
		if(f.catsearch.value==0)
			{
				alert("Please select category from the list");
				return false;
			}
			
		//alert("success");
		else return true;
	}
	else return true;
}

</script>
<style>
.forecast {
	float:left;
	border: 1px solid #fff;
	padding: 1px;
	margin: 1px;
}

/*body, td {
	font: normal 1em Trebuchet MS, Verdana, Arial, Helvetica, sans-serif;
}*/

.loc_name {
	font-size: 1.1em;
}

.loc_text {
	text-align: center;
}

.details, .for_date {
	font-size: .7em;
}

.for_border {
	border: 1px solid #FFF;
	background-color: #ccc;
}
.temp_u {
	background: url('temp_u.gif') repeat-y;
}
.temp_0 {
	background: url('temp_0.gif') repeat-y;
}
.temp_10 {
	background: url('temp_10.gif') repeat-y;
}
.temp_20 {
	background: url('temp_20.gif') repeat-y;
}
.temp_30 {
	background: url('temp_30.gif') repeat-y;
}
.temp_40 {
	background: url('temp_40.gif') repeat-y;
}
.temp_50 {
	background: url('temp_50.gif') repeat-y;
}
.temp_60 {
	background: url('temp_60.gif') repeat-y;
}
.temp_70 {
	background: url('temp_70.gif') repeat-y;
}
.temp_80 {
	background: url('temp_80.gif') repeat-y;
}
.temp_90 {
	background: url('temp_90.gif') repeat-y;
}
.temp_100 {
	background: url('temp_100.gif') repeat-y;
}
</style>
<tr>
    <td background="images/bg.gif"><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td width="33%"><a href="index.php"><img src="images/logo_beta.gif" alt="Hot Profolios" width="364" height="96" border="0"/></a></td>
		<td width="39%" align="right" valign="top" style="padding-top:15px;"><? // include("includes/datetime.php");?></td>
	
       
        <td width="28%" background="images/bg_left.gif">
		<table width="250" border="0" align="right" cellpadding="0" cellspacing="0">
          <tr>
            <td align="center" valign="middle"></td>
            <td width="134"></td>
            <td width="22" align="center" valign="middle"></td>
            <td width="79"></td>
          </tr>
          <tr>
            <td align="right" valign="middle"><? if(!isset($_SESSION['user_id'])){ ?><img src="images/icon.gif" width="20" height="27" hspace="3" /><? } else { ?>&nbsp;<? } ?></td>
            <td><? if(!isset($_SESSION['user_id'])){ ?><a href="signup_new.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image30','','images/create1.gif',1)"><img src="images/create_big.gif" alt="Create free profolio now" name="Image30" width="153" height="17" border="0" id="Image30" /></a><? } else { ?>&nbsp;<? } ?></td>
            <td align="right" valign="middle"><? if(isset($_SESSION['user_id']) && $_SESSION['user_id']!="" ) { ?><img src="images/icon1.gif" width="20" height="27" hspace="3" /><? } else { ?><img src="images/icon2.gif" width="20" height="27" hspace="3" /><? } ?></td>
            <td align="left" valign="middle"><? if(isset($_SESSION['user_id']) && $_SESSION['user_id']!="" ) { ?><a href="logout.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image55','','images/logout1.gif',1)"><img src="images/logout.gif" alt="Login" name="Image55" width="40" height="16" border="0" id="Image55" /></a><? } else { ?><a href="login.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image55','','images/login1.gif',1)">
		<img src="images/login.gif" alt="Login" name="Image55" width="29" height="16" border="0" id="Image55" /></a><? } ?></td>
          
		
		  </tr>
          <tr>
            <td width="45" align="center" valign="middle"></td>
            <td colspan="3" align="right" valign="top"><table width="100%" border="0" align="center" cellpadding="1" cellspacing="1">
			<form name="sear" method="post" action="search_site1.php">
                <tr>
                  <td width="73%" align="right" valign="top">&nbsp;</td>
                  <td width="27%" align="left">&nbsp;</td>
                </tr>
				<tr>
                  <td width="73%" align="right" valign="top">&nbsp;</td>
                  <td width="27%" align="left">&nbsp;</td>
				</tr>
				</form>
                
                <tr>
                  <td height="10" colspan="2" align="center" valign="top"></td>
                </tr>
				<? if($_SESSION['user_id']==''){?>
                <tr>
                  <td colspan="2" align="center" valign="top"><!--<a href="forgot_password.php"class="password_txt">Forgot Password </a>--></td>
                  </tr><? }?>
            </table></td>
          </tr>
          <tr>
            <td colspan="4"></td>
          </tr>
        </table></td>
      </tr>
    </table></td>
  </tr>
  <td>
    <table width="940" border="0" align="center" cellpadding="0" cellspacing="0">
      <tr>
        <td width="613" align="left" valign="middle" background="images/top_navigation.gif"><table width="510" border="0" align="left" cellpadding="0" cellspacing="0">
          <tr>
            <td width="15" align="left" valign="top"></td>
            <td width="10" align="center" valign="middle">&nbsp;</td>
            <td width="10" align="center" valign="middle">&nbsp;</td>
            <td width="99" align="center" valign="middle"><a href="#"><img src="images/search.gif" name="image2" width="99" height="14" border="0" id="image2" onmouseover="MM_showMenu(window.mm_menu_1026170441_0,-25,26,null,'image2')" onmouseout="MM_startTimeout();" /></a></td>
            <td width="10" align="left" valign="top">&nbsp;</td>
            <td width="206" align="center" valign="middle"><a href="#"></a></td>
			<td width="15" align="center" valign="middle"></td>
			<td width="145" align="center" valign="middle"></td>
                      </tr>
        </table></td>
        <td width="27" align="left" valign="top"><img src="images/top_navi.gif" width="37" height="31" /></td>
        <td width="317" align="left" valign="middle" background="images/top_bgred.gif"><table width="289" border="0" align="left" cellpadding="0" cellspacing="0">
          <tr>
            <td width="85" align="center" valign="middle">
			<? if(!isset($_SESSION['user_id'])){?>
			<a href="myprofolio.php"><img src="images/myprofolio.gif" name="image5" width="74" height="15" border="0" id="image5" onMouseOver="MM_showMenu(window.mm_menu_1026170815_0,-35,26,null,'image5')" onMouseOut="MM_startTimeout();"/></a>
			<? } else { ?><a href="myprofolio.php"><img src="images/myprofolio.gif" name="image5" width="74" height="15" border="0" id="image5" /></a> <? }?>   
			
			</td>
            <td width="1" align="left" valign="top"><img src="images/div1.gif" width="2" height="23" /></td>
            <td width="116" align="center" valign="middle"><a href="<? if(isset($_SESSION['user_id'])) { if($retusertype['product']==1 || $retusertype['upgrades']=='hotpro') { ?>hotprolounge.php<? } else { ?>upgrades.php?msg=reqlounge<? } } else { ?>login.php<? } ?>"><img src="images/hotpro.gif" name="image6" width="96" height="15" border="0" id="image6" onMouseOver="MM_showMenu(window.mm_menu_1029181932_0,-10,26,null,'image6')" onMouseOut="MM_startTimeout();" /></a></td>
            <td width="1" align="left" valign="top"><img src="images/div1.gif" width="2" height="23" /></td>
            <td width="60" align="right" valign="middle"><a href="<? if(isset($_SESSION['user_id'])) { ?> hotposts.php <? } else { ?>login.php <? } ?>"><img src="images/hotpost.gif" name="image7" width="54" height="15" border="0" id="image7" onMouseOver="MM_showMenu(window.mm_menu_1026171137_0,-49,26,null,'image7')" onMouseOut="MM_startTimeout();" /></a></td>
          </tr>
        </table></td>
      </tr>
    </table></td> 
  <tr>
    <td bgcolor="#FFFFFF"><table width="940" border="0" align="center" cellpadding="0" cellspacing="0">
     
    </table></td>
  </tr>
  <tr>
    <td colspan="3" align="left" valign="bottom" bgcolor="#FFFFFF"><table width="940" border="0" align="center" cellpadding="0" cellspacing="0">
      <tr>
        <td width="182" align="left" valign="top" background="images/side_nav_bg.gif"><? include("includes/profile_leftinclude.php");?>
          <p>&nbsp;</p></td>
        <td width="758" rowspan="4" align="left" valign="top"><table width="758" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td width="10">&nbsp;</td>
            <td><table width="713" border="0" cellpadding="0" cellspacing="0">
                  <tr>
                    <td align="left" valign="top"><table width="710" border="0" cellpadding="0" cellspacing="0">
                        <tr>
                          <td width="627" align="left" valign="middle" class="red_stare">Profolios Related to : <span class="bold_blue_txt">Hot Pro Lounge</span></td>
                          <td width="83" align="right" valign="middle" class="bigbold_red_txt1"><img src="images/result.jpg" width="83" height="23" /></td>
                        </tr>
                    </table></td>
                  </tr>
                  <tr>
                    <td><table width="713" border="0" cellpadding="0" cellspacing="0">
                        <tr>
                          <td height="4" background="images/dot.gif"></td>
                        </tr>
                    </table></td>
                  </tr>
                  <tr>
                    <td height="14"></td>
                  </tr>
				  
				<?   if($total>0)
				  
				  {?>
                  <tr>
                    <td height="10"><table width="680" border="0" align="center" cellpadding="0" cellspacing="0" class="txt-box-bdr-four"  bgcolor="">
                      <tr>
                        <td width="115" height="20" align="center" bgcolor="#EEEEEE" class="red_stare"><? 
							    $pagnum=($start+$limit)/($limit);
							  ?>
							Page 
							<? 
							 if($start==0) { echo "1"; } else { echo $pagnum; }   
							?> of 
							</td>
                        <td width="450" align="center" bgcolor="#DADADA"><table width="451" border="0" align="center" cellpadding="0" cellspacing="0">
                          <tr>
                            <td width="410" align="right" >