<?php
session_start();

//code from index1 (redirecting to other page)
$SiteNameURL = $_SERVER['HTTP_HOST'];

switch (strtolower($SiteNameURL)) {
 
case "txt-zone.com": //MUST BE LOWER CASE
            break;
 
case "www.txt-zone.com": //MUST BE LOWER CASE
            break;

case "noypeepz.com": //MUST BE LOWER CASE
            {
			//header("Location: http://" . $_SERVER['HTTP_HOST'] . "/wala.php");
			header("Location: http://txt-zone.com");
            break;
            } 
case "www.noypeepz.com": //MUST BE LOWER CASE
			{
			header("Location: http://txt-zone.com");
            break;
            }
case "chatterbox.txt-zone.com": //MUST BE LOWER CASE
			{
			header("Location: http://txt-zone.com/chatterbox_index.php");
            break;
            }
case "www.chatterbox.txt-zone.com": //MUST BE LOWER CASE
			{
			header("Location: http://txt-zone.com/chatterbox_index.php");
            break;
            }
case "ims-data.com": //MUST BE LOWER CASE
            {
			header("Location: http://" . $_SERVER['HTTP_HOST'] . "/CP/index.php");
            break;
            }
 case "www.ims-data.com": //MUST BE LOWER CASE
           {
			header("Location: http://" . $_SERVER['HTTP_HOST'] . "/CP/index.php");
            break;
            }
case "clicknaclick.com": //MUST BE LOWER CASE
case "www.clicknaclick.com":
		$server_string = $_SERVER["QUERY_STRING"];
		$php_self = $_SERVER["PHP_SELF"];

		if (empty($server_string))
			{
			header("Location: http://" . $_SERVER['HTTP_HOST'] . "/ads/index.php");
			}
		else
			{
			header("Location: http://" . $_SERVER['HTTP_HOST'] . "/ads/index.php?$server_string");
			}
            break; 
case "124.107.14.5": //MUST BE LOWER CASE
           {
			header("Location: http://" . $_SERVER['HTTP_HOST'] . "/index.htm");
            break;
			}
case "www.kampilan.org":
			{
			header("Location: http://" . $_SERVER['HTTP_HOST'] . "/index.htm");
            break;
			}
case "kampilan.org":
			{
			header("Location: http://" . $_SERVER['HTTP_HOST'] . "/index.htm");
            break;
			}
case "ims-data.com":
		die();
		break;
default:
        echo "WELCOME TO IMS-DATA.COM";
 		
}
/////////////////

$memid = $_SESSION['memid'];
$searchname = $_REQUEST['searchname'];

include("connect.php");
include("iploc.php");
ConnectDB('sms');
$p_date = date("Y-m-d");
$p_time = date("H:i:s");
$mo_now = date("m");
$yr_now = date("Y");
if(isset($_REQUEST['uname']))
	$uname = $_REQUEST['uname'];
else
	$uname = "";
if(isset($_REQUEST['pix']))
	$pix = $_REQUEST['pix'];
else
	$pix = "";
if(isset($_REQUEST['age_from']))
	$age_from = $_REQUEST['age_from'];
else
	$age_from = "";
if(isset($_REQUEST['age_to']))	
	$age_to = $_REQUEST['age_to'];
else
	$age_to = "";
if(isset($_REQUEST['gender1']))		
	$gender1 = $_REQUEST['gender1'];
else
	$gender1 = "";
if(isset($_REQUEST['gender2']))		
	$gender2 = $_REQUEST['gender2'];
else
	$gender2 = "";
	
//$age_from = $_REQUEST['age_from'];
//$age_to = $_REQUEST['age_to'];
if(isset($_REQUEST['country']))		
	$country = $_REQUEST['country'];
else
	$country = "";
if(isset($_REQUEST['username']))			
	$username = $_REQUEST['username'];
else
	$username = "";
if(isset($_REQUEST['pwd']))	
	$pwd = $_REQUEST['pwd'];
else
	$pwd = ""; 
if(isset($_REQUEST['act_on']))	
	$act_on = $_REQUEST['act_on'];
else
	$act_on = ""; 
if(isset($_REQUEST['message']))	
	$message = $_REQUEST['message'];
else
	$message = ""; 

//echo "post". $_POST['Search'];
if ($_POST)
	{
	if ($_POST['Search'])
	 	{
	 	$act_on = "Search";
	 	//echo "SEARCH";
		if(empty($searchname))
			{
			if ($gender1 == "---")
				$message = "Please indicate what your gender is.";
			elseif ($gender2 == "---")
				$message = "Please indicate what your gender you are looking for.";
			elseif ($age_from == "---")
				$message = "Please input start age you are looking for.";
			elseif ($age_to == "---")
				$message = "Please input end age you are looking for.";
			elseif ($age_from > $age_to)
				$message = "Starting Age should be less than or equal to Ending Age.";
			elseif ($country == "")
				$message = "Please input the country.";
			else
				{
				$startdate = $yr_now - $age_from;
				$startdate = $startdate."-01-01";
				$enddate = $yr_now - $age_to;
				$enddate = $enddate."-01-01";
				}
			}
		}
	elseif ($_POST['Login'])
		{
		$act_on = "Login";
		//echo "LOGIN"; 
		//echo "username".$username;
		if (empty($username))
	 		$message = "Please input username.";
	 	elseif (empty($pwd))
	 		$message = "Please input password.";
	 	else
	 		{
	 		$query =  "select mem_id,username,pwd from members where username = '$username'";
			$results = ExecuteQuery($query);
			if(mysql_num_rows($results))
				{
				$row = mysql_fetch_assoc($results);
				if($pwd == $row['pwd'])
					{
					$_SESSION['memid'] = strtolower($row[mem_id]);
					$_SESSION['username'] = $row['username'];
					$_SESSION['sms_username'] = $row['username'];
					$_SESSION['pwd'] = $row['pwd'];
										
					//add 10 points to credit points of this user
					$rsCheckIfLoggedIn = ExecuteQuery("select mem_id, sms_available from members where mem_id = $row[mem_id] and 

(lastlogin<>date(now()) or lastlogin is null)");
					if(mysql_num_rows($rsCheckIfLoggedIn))
					{
						
						$rowCheckIfLoggedIn=mysql_fetch_assoc($rsCheckIfLoggedIn);
						//$message = $rowCheckIfLoggedIn[sms_available];
						if($rowCheckIfLoggedIn[sms_available]<=50)
						{
							$sms_now=$rowCheckIfLoggedIn[sms_available]+10;
							if($sms_now>50)
								$sms_now=50;
							ExecuteQuery("update members set sms_available=$sms_now where mem_id = $row[mem_id]");
						}
					}

					//$message = "OK.";
					$query = "update members set ";	
					$query =  $query."lastlogin = '$p_date' ";
					$query =  $query."where username = '$username' ";
					ExecuteQuery($query);		
					
					//delete all activities that are greater than one month
					ExecuteQuery("delete from activity where memid = '$row[mem_id]' and datediff(now(),dateentry) > 

datediff(date_add(date_format(now(),'%Y-%m-%d'),interval 1 month),date_format(now(),'%Y-%m-%d'))");
										
					$query = "insert into logins set ";
					$query =  $query."ip_add = '$ip_add', ";
					$query =  $query."http_referrer = '" . addslashes($http_referrer) . "', ";
					$query =  $query."remote_addr ='" . addslashes($remote_addr) . "', ";
					$query =  $query."server ='" . addslashes($server) . "', ";
					$query =  $query."php_self = '" . addslashes($php_self) . "', ";
					$query =  $query."useragent = '" . addslashes($useragent) . "', ";
					$query =  $query."server_string = '" . addslashes($server_string) . "', ";
					$query =  $query."country = '" . addslashes($mcountabv) ."', ";
					$query =  $query."entrydate = '$p_date', ";
					$query =  $query."entrytime = '$p_time', ";
					$query =  $query."mem_id = '$_SESSION[memid]' ";
					ExecuteQuery($query);
					//$result = ExecuteQuery($query);
					
					if($p_time > '09:00:00')
						{
						//echo "Im Here 0!!!";
						if($p_time < '10:00:00')
							{
							$query = "select bday from bday_greetings where bday='$p_date'";
							$result = ExecuteQuery($query);
							//$row = mysql_fetch_assoc($result);
							if(!mysql_num_rows($result))
								{
								//echo "Im Here 1!!!";
								$query = "SELECT members.fname,members.provider,members.cel_num,members.mem_id, 

If(cellchoices.provider='GLOBE' And TM='Y','TOUCH',cellchoices.provider) AS prov,members.provider,members.cel_num";
								$query = $query . " FROM members LEFT JOIN cellchoices ON members.provider = 

cellchoices.providercode";
								$query = $query . " WHERE members.provider Like '+63%' AND date_format(members.dob,'%m 

%d')=date_format(curdate(),'%m %d')";
								$query = $query . " ORDER BY If(cellchoices.provider='GLOBE' And 

TM='Y','TOUCH',cellchoices.provider)";
								//echo $query;
								$result = ExecuteQuery($query);
								if(mysql_num_rows($result))
									{
									//echo "Im Here 2!!!";
									while ($row=mysql_fetch_assoc($result))
										{
										//echo "Im Here 3!!!";
										$sms_msg = "Happy Bday " . $row['fname'] . ", its Ur special day 2day.  Visit 

us at www.txt-zone.com and U myt b our next cellphone load winner.";
										$smsconn = "friends-".$row['provider'].$row['cel_num'];
										//echo $smsconn;
										
										$query = "insert into sms set ";
										$query =  $query."sms_connection = '$smsconn', ";
										$query =  $query."provider = '" . $row['prov'] . "', ";
										$query =  $query."msg ='$sms_msg', ";
										$query =  $query."fromwhat ='A', ";
										$query =  $query."entrydate = '$p_date', ";
										$query =  $query."entrytime = '$p_time', ";
										$query =  $query."msgname = 'admin', ";
										$query =  $query."mem_id = '" . $row['mem_id'] . "', ";
										$query =  $query."act = 'S', ";
										$query =  $query."sendmsg = 'Y', ";
										$query =  $query."had_read = '0', ";
										$query =  $query."cport = '0' ";
										//echo $query;
										ExecuteQuery($query);
					
										}
									$query = "insert into bday_greetings set ";
									$query =  $query."bday = '$p_date' ";
									ExecuteQuery($query);
									}
								}
							else
								{
								//echo "Im there";
								}	
							}
						}	
					//include("mail/reg_email_fornew.php");
					//include("mail/reg_email.php");
					echo "<script type=\"text/javascript\">
						<!--
						window.location = 'profile.php'
						//-->
						</script>";
					//header("location: profile.php");	
					//header("location: grid.php");	
		 			}
		 		else
		 			{
		 			//echo "pwd ".$pwd;
		 			//echo "pwd 2 ".$row['pwd'];
		 			$message = "Invalid password.";
		 			}
		 		}
		  	else
		 		{
		 		$message = "Username does not exist.";
		 		}	
		 	}
	 	}
	}
$_POST = "";
?>

<!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=iso-8859-1" />
<meta name="Description" content="Txt-Zone is the site that you can meet other people and can enjoy the power of SMS." />
<meta name="keywords" content="txt-zone.com,www.txt-zone.com,txt-zone,txt zone">
<title>Txt-Zone - The Fastest Growing Filipino Community</title>
<script>//PopUnder Power
//Credit notice must stay intact for use.

//Paste this entire javascript between the <head> & </head> tags of your page,
//or option 2: Save it as an external file, "popunder.js", and call it from between
//the <head>&</head> tags of the parent page, with this command:
// <script src="/popunder.js" LANGUAGE="JAVASCRIPT">


// Visit http://www.mikenew.net/downloads/scripts.asp for more scripts.
// by Mike New, with special thanks to
// Jeff Phillips of http://classadrivers.com, for some good mods
// If you use this script, or make it better, I'd love to see it in action! webmaster@mikenew.net



// Begin. Specify URLs to randomly select from and pop-under. Add or take away freely.
var popunder=new Array()

popunder[0]="http://twickn11.ecreditdirectory.com/"
//popunder[0]="http://xfastinfo.com/info/index.asp?main1=Financial_Services&cat=Credit_Cards"
//popunder[1]="http://xfastinfo.com/info/index.asp?main1=Financial_Services&cat=Credit_Repair"
//popunder[2]="http://xfastinfo.com/info/index.asp?main1=Financial_Services&cat=Debt_Consolidation"
//popunder[3]="http://xfastinfo.com/info/index.asp?main1=Financial_Services&cat=Financial_Advice"
//popunder[4]="http://xfastinfo.com/info/index.asp?main1=Financial_Services&cat=Home_Loans"
//popunder[5]="http://xfastinfo.com/info/index.asp?main1=Financial_Services&cat=Personal_Loans"




// Specify the width and height of new popunder window (in pixels).

var width = '900';
var height = '700';



var p = 'scrollbars=yes,resizable=yes,toolbar=yes,' + //these are obvious variables. set "yes" or "no".
'menubar=yes,status=yes,location=no,left=85,top=20,height=' + //the location on the user's screen
height + ',width=' + width;




// Load new PopUnder only once per browser session? (0=no, 1=yes)
// Putting 0 will cause the Popunder to load every time page is loaded
// Specifying 1 will cause it to load only once per session
var one_time=1


// That's it! Don't edit the code below unless you're really good. :-P //








function get_cookie(Name) {
var search = Name + "="
var returnvalue = "";
if (document.cookie.length > 0) {
offset = document.cookie.indexOf(search)
if (offset != -1) { // if the cookie exists
offset += search.length
end = document.cookie.indexOf(";", offset); // set the index of beginning value
if (end == -1) // set the index of the end of cookie value
end = document.cookie.length;
returnvalue=unescape(document.cookie.substring(offset, end))
}
}
return returnvalue;
}
function loadornot(){
if (get_cookie('popunder')==''){
load_pop_power()
document.cookie="popunder=yes"
}
}
function load_pop_power(){
win2=window.open(popunder[Math.floor(Math.random()*(popunder.length))],"bw",p)
win2.blur()
window.focus()
}
if (one_time==0)
load_pop_power()
else
loadornot()
</script>

<link rel="alternate" ty
Meet New Friends and Enjoy Unlimited Text to your friends for FREE at www.txt-zone.com Your Filipino SMS Community...pe="application/rss+xml" title="RSS 2.0" 

href="http://www.txt-zone.com/feed/rss.xml" />
<SCRIPT LANGUAGE = "JavaScript">
<!--
var secs
var timerID = null
var timerRunning = false
var delay = 1000

function InitializeTimer()
{
    // Set the length of the timer, in seconds
    secs = 30
    StopTheClock()
    StartTheTimer()
}

			ahmead_rakhafunction StopTheClock()
{
    if(timerRunning)
        clearTimeout(timerID)
    timerRunning = false
}

function StartTheTimer()
{
    if (secs==0)
    {
        //StopTheClock()
        //alert("You have just wasted 5 seconds of your life.")
        
        ajaxFunction()
        //document.getElementById('msg').disabled = "false";
        InitializeTimer()
        
        
        // Here's where you put something useful that's
        // supposed to happen after the allotted time.
        // For example, you could display a message:
        
    }
    else
    {
        //self.status = secs
        secs = secs - 1
        timerRunning = true
        timerID = self.setTimeout("StartTheTimer()", delay)
    }
}

function ajaxFunction(act)
	{
	var ajaxRequest;  // The variable that makes Ajax possible!
	
	try
		{
		// Opera 8.0+, Firefox, Safari
		ajaxRequest = new XMLHttpRequest();
		} 
	catch (e)
	//alert("OK");
		{
		// Internet Explorer Browsers
		try
			{
			ajaxRequest = new ActiveXObject("Msxml2.XMLHTTP");
			} 
		catch (e) 
			{
			try
				{
				ajaxRequest = new ActiveXObject("Microsoft.XMLHTTP");
				} 
			catch (e)
				{
				// Something went wrong
				alert("Your browser broke!");
				return false;
				}
			}
		}
	// Create a function that will receive data sent from the server
	ajaxRequest.onreadystatechange = function()
		{
		//alert("ready.");
		if(ajaxRequest.readyState == 4)
			{
			//alert("ready state.");
			var ajaxDisplay = document.getElementById('ajaxDiv');
			ajaxDisplay.innerHTML = ajaxRequest.responseText;

			//document.myForm.time.value = ajaxRequest.responseText;
			}
		}
	//var queryString = "?num_text=" + num_text;
	ajaxRequest.open("GET", "feature.php", true);
	//ajaxRequest.open("GET", "smsmsgreader.php" + queryString, true);
	ajaxRequest.send(null);
	
	InitializeTimer()
	}	

//-->
</script>
</head>
<link rel="stylesheet" type="text/css" href="css/StyleSheet.css">
<body>
<form action="index.php" method="post" name="frmlogin">
<table width="803" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><?php include('heading.php')?></td>
  </tr>
  <tr>
    <td>
    <?php 
    include('menu.php');
    ?></td>
   </tr>
   <tr bgcolor="#FFFFFF" align="center">
    <td>
    <br>
 	<?php 
 	include('banner_ads_image.php');
 	?>   
	</td>
  </tr>
  <tr>
    <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td><table width="100%" border="0" cellspacing="0" cellpadding="0" class="bgMainContent">
          <tr>
            <td width="59%" height="467"><table width="95%" border="0" align="center" cellpadding="0" cellspacing="0" class="tblBorder">
              <tr>
                <td valign="top"><img src="img/banner_img.jpg" width="455" height="173" />
                    <table width="100%" border="0" cellspacing="0" cellpadding="0" height="28">
                      <tr>
                        <td class="paddingl5 bgAttn" height="28"><marquee direction="up" scrolldelay="200">
                          <p>&quot;Now you can send text messages to your friends and other txt-zone members via computer for FREE. <br><br>
 	                   			Take advantage of your unlimited text. If you are our member you may also text other members (using other 

providers) for FREE using your cellphone. <br><br>
    			                For more information on how to use your cellphone <a href="faq.php">click here</a> <br><br>
                    			So <a href="signup.php">sign-up</a> and join us today. It's all FREE.&quot;<br />
                          </p></marquee></td>
                      </tr>
                  </table></td>
              </tr>
            </table></td>
            <td width="41%" height="467" valign="top"><br>
            <table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
              <tr>
                <td>
                <?
				if(empty($_SESSION['memid']))
					{
            	  ?>
            
                <table width="100%" border="0" cellspacing="0" cellpadding="0">
                    <tr>
                      <td>
                      
                      <table width="100%" border="0" cellspacing="0" cellpadding="0">
                          <tr>
                            <td class="rightpanel_Leftimg">&nbsp;</td>
                            <td class="rightpanel_Middleimg"><span class="txtTitleLogin">LOG-IN</span></td>
                            <td class="rightpanel_Rightimg">&nbsp;</td>
                          </tr>
                      </table></td>
                    </tr>
                    <tr>
                      <td class="rightpanelbg tblBorder"><div class="txtlabelLogin">
                          <table width="100%" border="0" cellspacing="0" cellpadding="0">
                            <tr>
                              <td colspan="2">&nbsp;</td>
                            </tr>
                            <tr>
                              <td></td>
                              <td colspan="2"><span class="txtlabelMsg">
                              <?php
								if ($act_on == "Login")
									{
									echo "<center>";
					                echo "<b><font face='Verdana' size='1.5' color='#FF0000'>"; 
					                echo $message;
					            	echo "</font></b> </center>";
					            	}
								?>
                              </span> </td>
                            </tr>
                            <tr>
                              <td align="right">Username:</td>
                              <td><font face="Verdana"> 
                    			<input type="text" name="username" size="24"  value="<?=$username?>">
                    			</font>
                    			</td>
                            </tr>
                            <tr>
                              <td align="right">Password:</td>
                              <td><font face="Verdana"> 
		                    	<input type="password" name="pwd" size="25"  value="<?=$pwd?>">

		                    	</font>
								</td>
                            </tr>
                            <tr>
                              <td>&nbsp;</td>
                              <td>&nbsp;</td>
                            </tr>
                            <tr>
                              <td>&nbsp;</td>
                              <td>
                              	<table width="100%" border="0" cellspacing="0" cellpadding="0">
                                  <tr>
                                    <td align="center"><label>
                                      <!--
                                      <input type="submit" name="signup" value="Sign In" class="bgbtn_login" id="signup" onclick="document.location.href = 

'http://txt-zone.com/signup.php'" />
                                      -->
                                      <input type="button" class="bgbtn_login" value="Sign Up" name="signup" id="signup" onclick="document.location.href = 

'http://txt-zone.com/signup.php'" onMouseOut="document.getElementById('signup').className='bgbtn_login'">
                                    </label></td>
                                    <td align="center">
                                    <!--
                                    <input type="submit" name="Login" value="Log In" class="bgbtn_login" onclick="bgbtnhover_login" />
                                    -->
                                    <input type="submit" value="Login" name="Login" id="login" class="bgbtn_login" 

onMouseOut="document.getElementById('login').className='bgbtn_login'" >
                                    </td>
                                  </tr>
                              </table></td>
                            </tr>
                            <tr>
                              <td>&nbsp;</td>
                              <td align="center">&nbsp;</td>
                            </tr>
                            <tr>
                              <td>&nbsp;</td>
                              <td align="center" id="linkLogin"><a href="forgot_password.php">Forgot your password</a></td>
                            </tr>
                            <tr>
                              <td>&nbsp;</td>
                              <td align="center">&nbsp;</td>
                            </tr>
                          </table>
                          
                      </div></td>
                    </tr>
                </table>
               	<br>
               	<?php
					}
				?>
                </td>
              </tr>
              <tr>
                <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
                    <tr>
                      <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
                          <tr>
                            <td class="rightpanel_Leftimg">&nbsp;</td>
                            <td class="rightpanel_Middleimg">
							<span class="txtTitleLogin">SEARCH</span></td>
                            <td class="rightpanel_Rightimg">&nbsp;</td>
                          </tr>
                      </table></td>
                    </tr>
                    <tr>
                      <td class="rightpanelbg tblBorder"><div class="txtlabelLogin">
                          <table width="100%" border="0" cellspacing="0" cellpadding="0">
                            <tr>
                              
                              <td colspan="2"><span class="txtlabelMsg">
                              <?php
								if ($act_on == "Search")
									{
									echo "<center>";
					                echo "<b><font face='Verdana' size='1.5' color='#FF0000'>"; 
					                echo $message;
					            	echo "</font></b> </center>";
					            	}
								?>
							</span> </td>
                            </tr>
                            <tr>
                              <td colspan="2">&nbsp;</td>
                            </tr>
                            
                            <tr>
                              <td align="right">
								<p align="center">I am a&nbsp; </td>
                              <td><font face="Verdana"> 
			                    <select name="gender1" size="1" onChange="searchname.value=''">
			                      <option selected>---</option>
			                      <option value="M" <?if($gender1=="M") echo " selected ";?>>Man</option>
			                      <option value="F" <?if($gender1=="F") echo " selected ";?>>Woman</option>
			                    </select></font>
                              </td>
                            </tr>
                            <tr>
                              <td align="right">
								<p align="center">Looking for a</td>
                              <td> <font face="Verdana"> 
		                    <select name="gender2" size="1" onChange="searchname.value=''">
		                      <option selected>---</option>
		                      <option value="M" <?if($gender2=="M") echo " selected ";?>>Man</option>
		                      <option value="F" <?if($gender2=="F") echo " selected ";?>>Woman</option>
		                    </select></font></td>
                            </tr>
                            <tr>
                              <td>
								<p align="center">Between</td>
                              <td> <font face="Verdana"> 
			                    <select name="age_from" size="1" onChange="searchname.value=''">
			                      <option selected>---</option>
			                      <?
						for ($i=18; $i <= 77; $i++)
							{
							echo "<option value='$i'";
							if ($age_from == $i)
							 	{
							 	echo " selected >".$i."</option>
                                  ";
							 	}
							else
							 	{	
							 	echo " >".$i."</option>";
							 	}
							}
						?>
			                    </select>
			                    <select name="age_to" size="1" onChange="searchname.value=''">
			                      <option selected>---</option>
			                      <?
						for ($i=18; $i <= 77; $i++)
							{
							echo "<option value='$i'";
							if ($age_to == $i)
							 	{
							 	echo " selected >".$i."</option>
                                  ";
							 	}
							else
							 	{	
							 	echo " >".$i."</option>";
							 	}
							}
						?>
			                    </select></font></td>
                            </tr>
                            <tr>
                              <td>
								<p align="center">Country</td>
                              <td> <font face="Arial Narrow"> 
					                    <select name="country" onChange="searchname.value=''">
					                      <option value="">country</option>
					                      <?
								$query = "Select country_code,country from countries order by country";
								$result = ExecuteQuery($query);
								if (mysql_num_rows($result))
									{
									while ($row=mysql_fetch_assoc($result))
										{
										if ($country == $row['country_code'])
											echo "<option value=" . $row[country_code] . " selected>" . 

$row['country'] . "</option>" ;
										else
											echo "<option value=" . $row[country_code] . ">" . $row['country'] . 

"</option>" ;
										}
									}
								?>
					                    </select></font></td>
                            </tr>
							<tr>
                              <td colspan="2"><hr></td>
                            </tr>
                            <tr>
                              <td>
								<p align="center">Or looking for</td>
                              <td align="center">
								<p align="left"><input type="text" name="searchname" value="<?=$searchname?>" 

class="textlabel" size="30"
				  	onKeyDown="gender1.value='';gender2.value='';age_from.value='';age_to.value='';country.value='';"
					onKeyUp="gender1.value='';gender2.value='';age_from.value='';age_to.value='';country.value=''"></td>
                            </tr>
                            <tr>
                              <td height="22">&nbsp;</td>
                              <td height="22"><label class="textlabel">
                    (username, email or lastname)</label></td>
                            </tr>
                            <tr>
                              <td>&nbsp;</td>
                              <td><label>
		                              <input type="submit" name="Search" value="Search" class="bgbtn_login">
                                      
                                    </label>
                               </td>
                            </tr>
                            
                            <tr>
                              <td>&nbsp;</td>
                              <td align="center">&nbsp;</td>
                            </tr>
                          </table>
                      </div></td>
                    </tr>
                </table></td>
              </tr>
            </table></td>
          </tr>
          <tr>
            <td colspan="2" align="center">
            <?php 
             	include('banner_ads_image.php');
 			?> 
 			</td>
 		 </tr>
          <tr>
            <td colspan="2">
			  
			  <br>
			  <table width="95%">
				<tr>
					<td width="20%" valign="top">
					<p align="center">&nbsp;<A HREF=http://filipinofriendfinder.com/go/g668334-pmem target=_top><img 

src=http://ads.filipinofriendfinder.com/banners/ffp/pff120x600.gif WIDTH=120 HEIGHT=600 BORDER=0></A></td>
					<td valign="top">
					<?php
  						if ($act_on == "" || $act_on == "Login")
  						{
  					?>
  					<table width="100%" border="0" cellspacing="0" cellpadding="0">
                    <tr>
                      
                      <td class="bgtblHome paddingl5"><span class="txtTitleLogin">FEATURED MEMBERS</span> </td>
                    </tr>
                    <tr>
                      <td>
                      <?
                    
			            $datetoday = date("Y-m-d"); 
						$date7daysago = dateadd('d',-7,date("Y-m-d"));
					        
						//$query = "select * from photos where photo_primary = 'Y' order by rand() limit 5";
						$query = "SELECT photos.photo_id, photos.memletter, members.mem_id, members.username, members.mo_viewed, 

members.times_viewed, members.lastlogin";
						$query = $query. " FROM photos INNER JOIN members ON photos.mem_id = members.mem_id";
						$query = $query. " WHERE (((photos.photo_primary)='Y') AND ((members.lastlogin)>= '$date7daysago'))";
						$query = $query. " ORDER BY rand() limit 5";
			
						$result = ExecuteQuery($query);
						//echo $query;
						//$row = mysql_fetch_assoc($result);
						//echo $result;
						if(mysql_num_rows($result))
							{
							//echo "im here";
							$x = 0;
							echo "<div id='tblborder_img'><table width='100%' border='0' cellspacing='0' cellpadding='0' 

class='tblBorder'>";
							echo "	<tr>";
							while ($row=mysql_fetch_assoc($result))
								{
								$photo_id[$x] = $row['photo_id'];
								$memletter = $row['memletter'];
								$friendid = $row['mem_id'];
								$username = $row['username'];
								if ($x < 5)
									{
									$rsCheckOnline=ExecuteQuery("select mem_id from online where mem_id=$row[mem_id]");
									if(mysql_num_rows($rsCheckOnline))
										$imonline=true;
									else
										$imonline=false;
								
									if($imonline)//'#CC0000'
										{
										$pix = $pix."<td width='20%' align='center'><a 

href='fprofile.php?friendid=".$friendid."'><img border='0' src='../uploads/".$memletter."/".$memletter.$photo_id[$x].".jpeg' alt='Hey! Im online'></a></td>";
										$uname = $uname."<td width='20%' align='center'><font 

color='#CC0000'><b>*</b></font><a href='fprofile.php?friendid=".$friendid."' class='nav'><font face='Verdana' size='2'>$username</font></a></td>";
										}
									else
										{
										$pix = $pix."<td width='20%' align='center'><a 

href='fprofile.php?friendid=".$friendid."'><img border='0' src='../uploads/".$memletter."/".$memletter.$photo_id[$x].".jpeg'></a></td>";
										$uname = $uname."<td width='20%' align='center'><a 

href='fprofile.php?friendid=".$friendid."' class='nav'><font face='Verdana' size='2'>$username</font></a></td>";
										}
									$x = $x + 1;
									}
								}
							echo $pix;	
							echo "</tr>";
							echo "<tr>";
							echo $uname;	
							echo "	</tr>";
							echo "</table></div>";
							}
						?>
                      
                      </td>
                    </tr>
                    <tr>
                        <td>&nbsp; </td>
                    </tr>
                    <tr>
                        <td class="bgtblHome paddingl5"><span class="txtTitleLogin">MOST POPULAR</span> </td>
                    </tr>
                    <tr>
                    	<td>
                    	<?
							$query = "";
							
							$query = "SELECT photos.photo_id, photos.memletter, members.mem_id, members.username, 

members.mo_viewed, members.times_viewed";
							$query = $query. " FROM photos INNER JOIN members ON photos.mem_id = members.mem_id";
							$query = $query. " WHERE (((photos.photo_primary)='Y') AND ((members.mo_viewed)='$mo_now'))";
							$query = $query. " ORDER BY members.times_viewed DESC LIMIT 1";
							$result = ExecuteQuery($query);
							if(mysql_num_rows($result))
								{
								while ($row=mysql_fetch_assoc($result))
									{
									$times_viewed = $row['times_viewed'];
									if($times_viewed < 1)
										{
										$times_viewed = 1;
										}
									else
										{
										$times_viewed = $times_viewed / 5;
										}
									}
								}
								//echo "times_viewed".$times_viewed;
							$query = "SELECT photos.photo_id, photos.memletter, members.mem_id, members.username, 

members.mo_viewed, members.times_viewed";
							$query = $query. " FROM photos INNER JOIN members ON photos.mem_id = members.mem_id";
							$query = $query. " WHERE (((photos.photo_primary)='Y') AND ((members.times_viewed)>$times_viewed) AND 

((members.mo_viewed)='$mo_now'))";
							$query = $query. " ORDER BY rand() limit 5";
							//echo $query;
							$result = ExecuteQuery($query);
							if(mysql_num_rows($result))
							//if($result)
								{
								//echo "im here";
								$x = 0;
								$pix = "";
								$uname = "";
								echo "<div id='tblborder_img'><table width='100%' border='0' cellspacing='0' cellpadding='0' 

class='tblBorder'>";
								echo "	<tr>";
								while ($row=mysql_fetch_assoc($result))
									{
									//echo "im here 2";
									$photo_id[$x] = $row['photo_id'];
									$memletter = $row['memletter'];
									$friendid = $row['mem_id'];
									$username = $row['username'];
									
									if ($x < 5)
										{
										$rsCheckOnline=ExecuteQuery("select mem_id from online where 

mem_id=$row[mem_id]");
										if(mysql_num_rows($rsCheckOnline))
											$imonline=true;
										else
											$imonline=false;
									
										if($imonline)//'#CC0000'
											{
											$pix = $pix."<td width='20%' align='center'><a 

href='fprofile.php?friendid=".$friendid."'><img border='0' src='../uploads/".$memletter."/".$memletter.$photo_id[$x].".jpeg' alt='Hey! Im online'></a></td>";
											$uname = $uname."<td width='20%' align='center'><font 

color='#CC0000'><b>*</b></font><a href='fprofile.php?friendid=".$friendid."' class='nav'><font face='Verdana' size='2'>$username</font></a></td>";
											}
										else
											{
											$pix = $pix."<td width='20%' align='center'><a 

href='fprofile.php?friendid=".$friendid."'><img border='0' src='../uploads/".$memletter."/".$memletter.$photo_id[$x].".jpeg'></a></td>";
											$uname = $uname."<td width='20%' align='center'><a 

href='fprofile.php?friendid=".$friendid."' class='nav'><font face='Verdana' size='2'>$username</font></a></td>";
											}
										$x = $x + 1;
										}
									}
								echo $pix;	
								echo "</tr>";
								echo "<tr>";
								echo $uname;	
								echo "	</tr>";
								echo "</table></div>";		
								}
							?>
                    	</td>
                    </tr>
                    <tr>
                        <td>&nbsp; </td>
                    </tr>
                    <tr>
                        <td class="bgtblHome paddingl5"><span class="txtTitleLogin">NEW MEMBERS</span> </td>
                    </tr>
					<tr>
                    	<td>
                    	<?
							//$query = "select * from photos where photo_primary = 'Y' order by photo_id desc";
							$query = "SELECT photos.photo_id, photos.memletter, members.mem_id, members.username, 

members.mo_viewed, members.times_viewed";
							$query = $query. " FROM photos INNER JOIN members ON photos.mem_id = members.mem_id";
							$query = $query. " WHERE (((photos.photo_primary)='Y'))";
							$query = $query. " ORDER BY members.mem_id desc";
							
							$result = ExecuteQuery($query);
							//echo $query;
							//$row = mysql_fetch_assoc($result);
							//echo $result;
							if(mysql_num_rows($result))
								{
								//echo "im here";
								$x = 0;
								$pix = "";
								$uname = "";
								echo "<div id='tblborder_img'><table width='100%' border='0' cellspacing='0' cellpadding='0' 

class='tblBorder'>";
								echo "	<tr>";
								while ($row=mysql_fetch_assoc($result))
									{
									//echo "im here 2";
									$photo_id[$x] = $row['photo_id'];
									$memletter = $row['memletter'];
									$friendid = $row['mem_id'];
									$username = $row['username'];
									if ($x < 5)
										{
										$rsCheckOnline=ExecuteQuery("select mem_id from online where 

mem_id=$row[mem_id]");
										if(mysql_num_rows($rsCheckOnline))
											$imonline=true;
										else
											$imonline=false;
									
										if($imonline)//'#CC0000'
											{
											$pix = $pix."<td width='20%' align='center'><a 

href='fprofile.php?friendid=".$friendid."'><img border='0' src='../uploads/".$memletter."/".$memletter.$photo_id[$x].".jpeg' alt='Hey! Im online'></a></td>";
											$uname = $uname."<td width='20%' align='center'><font 

color='#CC0000'><b>*</b></font><a href='fprofile.php?friendid=".$friendid."' class='nav'><font face='Verdana' size='2'>$username</font></a></td>";
											}
										else
											{
											$pix = $pix."<td width='20%' align='center'><a 

href='fprofile.php?friendid=".$friendid."'><img border='0' src='../uploads/".$memletter."/".$memletter.$photo_id[$x].".jpeg'></a></td>";
											$uname = $uname."<td width='20%' align='center'><a 

href='fprofile.php?friendid=".$friendid."' class='nav'><font face='Verdana' size='2'>$username</font></a></td>";
											}
										$x = $x + 1;
										}
									}
								echo $pix;	
								echo "</tr>";
								echo "<tr>";
								echo $uname;	
								echo "	</tr>";
								echo "</table></div>";		
								}
							?>
						<?php
								$rsonline = ExecuteQuery("SELECT 

username,concat(left(username,1),'/',left(username,1),photos.photo_id,'.jpeg') as picturename,online.*
															FROM (online inner join members on 

members.mem_id = online.mem_id) inner join photos on members.mem_id = photos.mem_id
															Where photos.photo_primary='Y'
															ORDER BY rand() limit 5");
								if(mysql_num_rows($rsonline))
								{
								?>
							  <br>
							  <table class="bgtblHome paddingl5" width="100%" border="0">
				                <tr> 
				                  <td> <span class="txtTitleLogin">Hey! 
				                    We're online</span></td>
				                </tr>
<tr> 
				                  <td>&nbsp; </td>
				                </tr>
				                <tr> 
				                  <td><label class="fontstyle"> 
				                    <?php
									if(mysql_num_rows($rsonline))
									$i=1;
									echo "<table border='0' width='100%' cellpadding='0' cellspacing='0'>";
									while($rowonline=mysql_fetch_assoc($rsonline) and $i<=5)
									{
										$online .= "<td width='20%' align='center'>
													<div id='tblborder_img'><table width='100%'>
													<tr>
													  <td align='center'><a 

href='fprofile.php?friendid=$rowonline[mem_id]'><img border=0 src='uploads/$rowonline[picturename]' alt=\"Hey! I'm online\"></a></td>
													</tr>
													<tr>
													  <td align='center'><font 

color='#CC0000'><b>*</b></font><a href='fprofile.php?friendid=$rowonline[mem_id]' class='nav'><font face='Verdana' 

size='2'>$rowonline[username]</font></a></td>
													</tr>
												  </table></div>
												</td>";
								
										if($i%5 == 0 or $i==mysql_num_rows($rsonline))
										{
											echo "<tr>$online</tr>";
											$online="";
										}
									$i++;
									}
									echo "</table>";
									?>
				                    </label> </td>
				                </tr>
				                <tr> 
				                  <td> </td>
				                </tr>
				              </table>
				              <br>
								<?php
								}
				      	}
					else	
				      	{
				      	?>
				              <table class="bgtblHome paddingl5" width="100%" cellpadding="0" cellspacing="0">
				                <tr> 
				                  <td align="center"> <span class="txtTitleLogin">Search 
				                    Results</span></td>
				                </tr>
				                <tr> 
				                  <td align="center">&nbsp; </td>
				                </tr>
				                <tr> 
				                  <td> 
				                    <?
							if(empty($searchname))
							{
								
								$query = "SELECT photos.photo_id, photos.memletter, members.mo_viewed, members.times_viewed, 

members.mem_id, members.username, members.city_town, members.province_state, members.country AS countrycode, members.dob, members.gender, countries.country";
								$query = $query." FROM (photos INNER JOIN members ON photos.mem_id = members.mem_id) INNER 

JOIN countries ON members.country = countries.country_code";
								$query = $query." WHERE (((members.mo_viewed)='$mo_now') AND ((members.country)='$country') 

AND ((members.dob)>='$enddate' And (members.dob)<='$startdate') AND ((members.gender)='$gender2') AND ((photos.photo_primary)='Y'))";
								$query = $query." ORDER BY members.dob DESC";
				
							}
							else
							{
								$query = "SELECT photos.photo_id, photos.memletter, members.mo_viewed, members.times_viewed, 

members.mem_id, members.username, members.city_town, members.province_state, countries.country, members.dob, members.gender
											FROM (photos INNER JOIN members ON photos.mem_id = members.mem_id) 

INNER JOIN countries ON members.country = countries.country_code
											WHERE (((members.emailadd)='$searchname') AND 

((photos.photo_primary)='Y')) OR (((members.username)='$searchname') AND ((photos.photo_primary)='Y')) OR (((photos.photo_primary)='Y') AND ((members.lname) 

Like '$searchname%'))
											ORDER BY members.times_viewed DESC";
							}
							//echo $query;
							//$query = "SELECT photos.photo_id, members.mo_viewed, members.times_viewed, members.mem_id, members.username, members.gender, members.stat, members.city_town, members.province_state, members.country, members.dob";
							//$query = $query. " FROM photos INNER JOIN members ON photos.mem_id = members.mem_id";
							//$query = $query. " WHERE (((photos.photo_primary)='Y') AND ((members.mo_viewed)='$mo_now'))";
							//$query = $query. " ORDER BY members.times_viewed DESC";
							
							$result = ExecuteQuery($query);
							//echo $query;
							//$row = mysql_fetch_assoc($result);
							//echo $result;
							if(mysql_num_rows($result))
								{
								//echo "im here";
								$x = 0;
								$y = 0;
								$pix = "";
								$uname = "";
								echo "<table width='100%' align='center' style='table-layout: fixed'>";
								echo "	<tr>";
								while ($row=mysql_fetch_assoc($result))
									{
									//echo "im here 2";
									$photo_id[$x] = $row['photo_id'];
									$memletter = $row['memletter'];
									$friendid = $row['mem_id'];
									$f_username = $row['username'];
									$f_gender = $row['gender'];
									$f_stat = $row['stat'];
									if($f_stat == 1)
										$f_stat = "SINGLE";
									else if($f_stat == 2)
										$f_stat = "IN A RELATIONSHIP";
									else if($f_stat == 3)
										$f_stat = "DOMESTIC PARTNER";
									else if($f_stat == 4)
										$f_stat = "MARRIED";
									else if($f_stat == 0)
										$f_stat = "IT'S COMPLICATED";
									$f_city = $row['city_town'];
									$f_province_state = $row['province_state'];
									$f_country = $row['country'];
									$f_dob = $row['dob'];
									$f_age = datediff('Y',$f_dob,$p_date);
							
									if ($x < 50)
										{
										echo "<tr>";
										echo "<td witdth='100%'>";
										echo "<div id='tblborder_img'><table width='100%'>";
										echo "<tr>";
										echo "<td width='20%' align='center'><a 

href='fprofile.php?friendid=".$friendid."'><img border='0' src='uploads/".$memletter."/".$memletter.$photo_id[$x].".jpeg'></a></td>";
										echo "<td width='380' valign='top'><font face='Verdana' 

size='2'>&nbsp;&nbsp;Username:  <a href='fprofile.php?friendid=".$friendid."' class='nav'>".$f_username."</a><br>&nbsp;&nbsp;Age:  

".$f_age."<br>&nbsp;&nbsp;Gender:  ".$f_gender."<br>&nbsp;&nbsp;Status:  ".$f_stat."<br>&nbsp;&nbsp;City:  ".$f_city."<br>&nbsp;&nbsp;Province/State:  

".$f_province_state."<br>&nbsp;&nbsp;Country:  ".$f_country."</font></td>";
										//echo "<td valign='top'><a href='fprofile.php?friendid=".$friendid."'><font face='Verdana' size='2'>$fusername</font></a></td>";
										echo "</tr>";
										echo "</table>";		
										echo "</td>";
										echo "</tr>";
										}
										$x = $x + 1;
									}
								echo "</table></div>";		
								}
							else
								{
								echo "<label class='textlabel'>NO RECORD WAS FOUND</label>";
								}
							?>
				                  </td>
				                </tr>
				              </table></div>
				              <?
				      	}
				      	?>	

					</td>
				</tr>
				
			</table>
			          	</td>
                    </tr>
                  <tr>
                  <td colspan="2" align="center">
                  <br>
				 	<?php 
				 	include('banner_ads_image.php');
				 	?>   
				</td>
                </tr>  
                  </table></td>
                </tr>
                <tr>
                  <td colspan="2" align="center" bgcolor=#FFFFFF>
                  <br>
				 	<?php 
				 	include('b_menu.php');
				 	?>   
				</td>
                </tr>  

              </table></td>
            </tr>
        </table></td>
      </tr>
      
    </table>
<p align="center"></td>
  </tr>
  <tr>
    <td align="center" class="bgFooter "></td>
  </tr>
</table>
</p>
</form>
<script src="http://www.google-analytics.com/urchin.js" type="text/javascript">
</script>
<script type="text/javascript">
_uacct = "UA-239978-4";
urchinTracker();
</script>

</body>
</html>
<?

//include("mail/reg_email.php");
//include("mail/reg_emailfornew11.php");
/*
	if($p_time > '18:00:00')
		{
		if($p_time < '24:00:00')
			{
			//echo "im here1";
			include("mail/reg_email_fornew11.php");
			}
		//echo "im here2";	
		}
	else if($p_time > '00:00:00')
		{
		if($p_time < '08:00:00')
			{
			echo "im here1";
			include("mail/reg_email_fornew11.php");
			}
		echo "im here2";	
		}
	else if($p_time > '12:00:00')
		{
		if($p_time < '13:00:00')
			{
			//echo "im here1";
			include("mail/reg_email_fornew11.php");
			}
		//echo "im here2";	
		}
	else
		{
		echo "im here";
		
		}	

*/


if($p_time > '05:00:00')
		{
		//echo "Im Here 1!!!";
		if($p_time < '24:00:00')
			{
			//echo "Im Here 2!!!";
			//$sun_celnum = str_replace("63922".Randomize(1000000 - 9999999),"-","");
			//$random_sun_celnum = Randomize(1000000 - 9999999);
			
			//$sun_celnum = str_replace($random_sun_celnum,"-","");
			//$sun_celnum = strstr("63922".Randomize(1000000 - 9999999));
			$sun_celnum = rand(1000000, 9999999);
			$sun_celnum = "63922".$sun_celnum;
			//echo "sun_celnum".$sun_celnum;
			//$sun_celnum = ereg_replace($sun_celnum,"-","");
			//echo "sun_celnum".$sun_celnum;
			if($sun_celnum > 1000000)
				{
				ExecuteQuery("insert into sms set 
					sms_connection = 'admin-+". trim($sun_celnum) . "', 
					provider = 'SUN', 
					msg = 'We lyk 2 invite U 2 meet other members & experience out unlimited texting @ www.txt-zone.com. U may be our nxt 

cell phone load winner.',
					fromwhat = 'F', 
					mem_id = '0',
					msgname = 'admin',
					act = 'S',
					sendmsg = 'N',
					entrydate = '$p_date',
					entrytime = '$p_time'");
				}
			
					
			$txtdate = dateadd("d", -15, $p_date);	
			//echo "txtdate".$txtdate;
			$query =  "SELECT members.lastemail, members.username, cellchoices.providercode, cellchoices.provider, members.entrydate, 

members.cel_num ";
			$query = $query."FROM members INNER JOIN cellchoices ON members.provider = cellchoices.providercode ";
			$query = $query."WHERE cellchoices.provider='SMART' AND (members.lastemail<'$txtdate' Or members.lastemail Is Null) AND 

members.lastlogin<'$txtdate' ";
			$query = $query."ORDER BY members.lastemail, members.username";
			echo $query;

			$result = ExecuteQuery($query);
			$row = mysql_fetch_assoc($result);

			if(mysql_num_rows($result))
				{
				
				ExecuteQuery("insert into sms set 
					sms_connection = 'admin-". trim($row['providercode'].$row['cel_num']) . "', 
					provider = 'SMART', 
					msg = 'Hi ".$row['username'].", na miss ka na namin sa www.txt-zone.com.  Sana magkita-kita tayo ngayon.  Antay ka 

namin k.',
					fromwhat = 'F', 
					mem_id = '0',
					msgname = 'admin',
					act = 'S',
					sendmsg = 'N',
					entrydate = '$p_date',
					entrytime = '$p_time'");
					
				$query = "update members set lastemail='$p_date' where username='$row[username]'";    
				ExecuteQuery($query);	
				}
			else
				{
				//echo "yari im here.";
				}
			
			$txtdate = dateadd("d", -15, $p_date);	
			//echo "txtdate".$txtdate;
			$query =  "SELECT members.lastemail, members.username, cellchoices.providercode, cellchoices.provider, members.entrydate, 

members.cel_num ";
			$query = $query."FROM members INNER JOIN cellchoices ON members.provider = cellchoices.providercode ";
			$query = $query."WHERE cellchoices.provider='GLOBE' AND (members.lastemail<'$txtdate' Or members.lastemail Is Null) AND 

members.lastlogin<'$txtdate' ";
			$query = $query."ORDER BY members.lastemail, members.username";
			//echo $query;

			$result = ExecuteQuery($query);
			$row = mysql_fetch_assoc($result);

			if(mysql_num_rows($result))
				{
				
				ExecuteQuery("insert into sms set 
					sms_connection = 'admin-". trim($row['providercode'].$row['cel_num']) . "', 
					provider = 'GLOBE', 
					msg = 'Hi ".$row['username'].", na miss ka na namin sa www.txt-zone.com.  Sana magkita-kita tayo ngayon.  Antay ka 

namin k.',
					fromwhat = 'F', 
					mem_id = '0',
					msgname = 'admin',
					act = 'S',
					sendmsg = 'N',
					entrydate = '$p_date',
					entrytime = '$p_time'");
					
				$query = "update members set lastemail='$p_date' where username='$row[username]'";    
				ExecuteQuery($query);	
				}
			else
				{
				//echo "yari im here.";
				}

			}
		else
			{
			//echo "wala sa time.";
			}	
		}
	else
		{
		//echo "Im Here at Else!!!";
		}	

if($p_time > '12:00:00')
		{
		//echo "Im Here 1!!!";
		if($p_time < '13:00:00')
			{
			//echo "Im Here 2!!!";
			//$sun_celnum = str_replace("63922".Randomize(1000000 - 9999999),"-","");
			//$random_sun_celnum = Randomize(1000000 - 9999999);
			
			//$sun_celnum = str_replace($random_sun_celnum,"-","");
			//$sun_celnum = strstr("63922".Randomize(1000000 - 9999999));
			$sun_celnum = rand(1000000, 9999999);
			$sun_celnum = "63922".$sun_celnum;
			//echo "sun_celnum".$sun_celnum;
			//$sun_celnum = ereg_replace($sun_celnum,"-","");
			//echo "sun_celnum".$sun_celnum;
			if($sun_celnum > 1000000)
				{
				ExecuteQuery("insert into sms set 
					sms_connection = 'admin-+". trim($sun_celnum) . "', 
					provider = 'SUN', 
					msg = 'We lyk 2 invite U 2 meet other members & experience out unlimited texting @ www.txt-zone.com. U may be our nxt 

cell phone load winner.',
					fromwhat = 'F', 
					mem_id = '0',
					msgname = 'admin',
					act = 'S',
					sendmsg = 'N',
					entrydate = '$p_date',
					entrytime = '$p_time'");
				}
			
					
			$txtdate = dateadd("d", -15, $p_date);	
			//echo "txtdate".$txtdate;
			$query =  "SELECT members.lastemail, members.username, cellchoices.providercode, cellchoices.provider, members.entrydate, 

members.cel_num ";
			$query = $query."FROM members INNER JOIN cellchoices ON members.provider = cellchoices.providercode ";
			$query = $query."WHERE cellchoices.provider='SMART' AND (members.lastemail<'$txtdate' Or members.lastemail Is Null) AND 

members.lastlogin<'$txtdate' ";
			$query = $query."ORDER BY members.lastemail, members.username";
			//echo $query;

			$result = ExecuteQuery($query);
			$row = mysql_fetch_assoc($result);

			if(mysql_num_rows($result))
				{
				
				ExecuteQuery("insert into sms set 
					sms_connection = 'admin-". trim($row['providercode'].$row['cel_num']) . "', 
					provider = 'SMART', 
					msg = 'Hi ".$row['username'].", na miss ka na namin sa www.txt-zone.com.  Sana magkita-kita tayo ngayon.  Antay ka 

namin k.',
					fromwhat = 'F', 
					mem_id = '0',
					msgname = 'admin',
					act = 'S',
					sendmsg = 'N',
					entrydate = '$p_date',
					entrytime = '$p_time'");
					
				$query = "update members set lastemail='$p_date' where username='$row[username]'";    
				ExecuteQuery($query);	
				}
			else
				{
				//echo "yari im here.";
				}
			
			$txtdate = dateadd("d", -15, $p_date);	
			//echo "txtdate".$txtdate;
			$query =  "SELECT members.lastemail, members.username, cellchoices.providercode, cellchoices.provider, members.entrydate, 

members.cel_num ";
			$query = $query."FROM members INNER JOIN cellchoices ON members.provider = cellchoices.providercode ";
			$query = $query."WHERE cellchoices.provider='GLOBE' AND (members.lastemail<'$txtdate' Or members.lastemail Is Null) AND 

members.lastlogin<'$txtdate' ";
			$query = $query."ORDER BY members.lastemail, members.username";
			//echo $query;

			$result = ExecuteQuery($query);
			$row = mysql_fetch_assoc($result);

			if(mysql_num_rows($result))
				{
				
				ExecuteQuery("insert into sms set 
					sms_connection = 'admin-". trim($row['providercode'].$row['cel_num']) . "', 
					provider = 'GLOBE', 
					msg = 'Hi ".$row['username'].", na miss ka na namin sa www.txt-zone.com.  Sana magkita-kita tayo ngayon.  Antay ka 

namin k.',
					fromwhat = 'F', 
					mem_id = '0',
					msgname = 'admin',
					act = 'S',
					sendmsg = 'N',
					entrydate = '$p_date',
					entrytime = '$p_time'");
					
				$query = "update members set lastemail='$p_date' where username='$row[username]'";    
				ExecuteQuery($query);	
				}
			else
				{
				//echo "yari im here.";
				}

			}
		else
			{
			//echo "wala sa time.";
			}	
		}
	else
		{
		//echo "Im Here at Else!!!";
		}	


if($p_time > '20:00:00')
		{
		//echo "Im Here 1!!!";
		if($p_time < '20:10:00')
			{
			//echo "Im Here 2!!!";
			//$sun_celnum = str_replace("63922".Randomize(1000000 - 9999999),"-","");
			//$random_sun_celnum = Randomize(1000000 - 9999999);
			
			//$sun_celnum = str_replace($random_sun_celnum,"-","");
			//$sun_celnum = strstr("63922".Randomize(1000000 - 9999999));
			$sun_celnum = rand(1000000, 9999999);
			$sun_celnum = "63922".$sun_celnum;
			//echo "sun_celnum".$sun_celnum;
			//$sun_celnum = ereg_replace($sun_celnum,"-","");
			//echo "sun_celnum".$sun_celnum;
			if($sun_celnum > 1000000)
				{
				ExecuteQuery("insert into sms set 
					sms_connection = 'admin-+". trim($sun_celnum) . "', 
					provider = 'SUN', 
					msg = 'We lyk 2 invite U 2 meet other members & experience out unlimited texting @ www.txt-zone.com. U may be our nxt 

cell phone load winner.',
					fromwhat = 'F', 
					mem_id = '0',
					msgname = 'admin',
					act = 'S',
					sendmsg = 'N',
					entrydate = '$p_date',
					entrytime = '$p_time'");
				}
			
					
			$txtdate = dateadd("d", -15, $p_date);	
			//echo "txtdate".$txtdate;
			$query =  "SELECT members.lastemail, members.username, cellchoices.providercode, cellchoices.provider, members.entrydate, 

members.cel_num ";
			$query = $query."FROM members INNER JOIN cellchoices ON members.provider = cellchoices.providercode ";
			$query = $query."WHERE cellchoices.provider='SMART' AND (members.lastemail<'$txtdate' Or members.lastemail Is Null) AND 

members.lastlogin<'$txtdate' ";
			$query = $query."ORDER BY members.lastemail, members.username";
			//echo $query;

			$result = ExecuteQuery($query);
			$row = mysql_fetch_assoc($result);

			if(mysql_num_rows($result))
				{
				
				ExecuteQuery("insert into sms set 
					sms_connection = 'admin-". trim($row['providercode'].$row['cel_num']) . "', 
					provider = 'SMART', 
					msg = 'Hi ".$row['username'].", na miss ka na namin sa www.txt-zone.com.  Sana magkita-kita tayo ngayon.  Antay ka 

namin k.',
					fromwhat = 'F', 
					mem_id = '0',
					msgname = 'admin',
					act = 'S',
					sendmsg = 'N',
					entrydate = '$p_date',
					entrytime = '$p_time'");
					
				$query = "update members set lastemail='$p_date' where username='$row[username]'";    
				ExecuteQuery($query);	
				}
			else
				{
				//echo "yari im here.";
				}
			
			$txtdate = dateadd("d", -15, $p_date);	
			//echo "txtdate".$txtdate;
			$query =  "SELECT members.lastemail, members.username, cellchoices.providercode, cellchoices.provider, members.entrydate, 

members.cel_num ";
			$query = $query."FROM members INNER JOIN cellchoices ON members.provider = cellchoices.providercode ";
			$query = $query."WHERE cellchoices.provider='GLOBE' AND (members.lastemail<'$txtdate' Or members.lastemail Is Null) AND 

members.lastlogin<'$txtdate' ";
			$query = $query."ORDER BY members.lastemail, members.username";
			//echo $query;

			$result = ExecuteQuery($query);
			$row = mysql_fetch_assoc($result);

			if(mysql_num_rows($result))
				{
				
				ExecuteQuery("insert into sms set 
					sms_connection = 'admin-". trim($row['providercode'].$row['cel_num']) . "', 
					provider = 'GLOBE', 
					msg = 'Hi ".$row['username'].", na miss ka na namin sa www.txt-zone.com.  Sana magkita-kita tayo ngayon.  Antay ka 

namin k.',
					fromwhat = 'F', 
					mem_id = '0',
					msgname = 'admin',
					act = 'S',
					sendmsg = 'N',
					entrydate = '$p_date',
					entrytime = '$p_time'");
					
				$query = "update members set lastemail='$p_date' where username='$row[username]'";    
				ExecuteQuery($query);	
				}
			else
				{
				//echo "yari im here.";
				}

			}
		else
			{
			//echo "wala sa time.";
			}	
		}
	else
		{
		//echo "Im Here at Else!!!";
		}	


?>