View file components/findfriends.php

<?php
if(!defined('DRK'))die('Hacking attempt...');

$uid=IdFromSes($ses);

/////NEW USERS/////
if($mode=="newusers")
{
$time=time();
$page=get_var("page");
if(empty($page))$page=1;
$newusers=num_rows("id",users,"$time-regdate<=604800 AND banned='N'");
$query=query("*",users,"$time-regdate<=604800 AND banned='N' ORDER BY regdate DESC LIMIT ".($page-1)*$usersperpage.",$usersperpage");
if(mysql_num_rows($query)>0){
while($row=mysql_fetch_array($query)){
if(profiles_table("sex",$row['id'])=="M")$color=" style=\"color:#0000FF;\"";
else if(profiles_table("sex",$row['id'])=="F")$color=" style=\"color:#FF0066;\"";
$age=profiles_table("age",$row['id']);
$sex=profiles_table("sex",$row['id']);
$location=profiles_table("location",$row['id']);
$userlist.="<a href=\"".$action."options".$mod."profile&amp;user=$row[username]".$session."\"$color>$row[username]</a> - <small>$age/$sex/$location</small><br/>\n";
}
}
else $userlist.="<img src=\"./images/point.gif\" alt=\"[!]\"/><small>no users have registered in last 7 days!!</small><br/>";
if($page>1)$controls.="<a href=\"".$action."findfriends".$mod."newusers&amp;page=".($page-1).$session."\">&lt;- prev</a>";
if($page>1&&$newusers>$page*$usersperpage)$controls.="\n | ";
if($newusers>$page*$usersperpage)$controls.="<a href=\"".$action."findfriends".$mod."newusers&amp;page=".($page+1).$session."\">next -&gt;</a>";
if($page>1||$newusers>$page*$usersperpage)$controls.="<br/>";
$what=Array("sitename","username","newusers","userlist","controls");
$with=Array($sitename,users_table("username",$uid),$newusers,$userlist,$controls);
Template($what,$with,"newusers");
exit;
}

/////SEARCH PROPERTY/////
else if($mode=="searchproperty")
{
$page=get_var("page");
if(empty($page))$page=1;
$search=get_var("search");
if($search==1){
$get_gender=get_var("gender");
$get_age=get_var("age");
$get_country=get_var("country");
$get_other=get_var("other");
if(IllegalChars($other))$msg="<img src=\"./images/error.gif\" alt=\"[x]\"/><small>Illegal chars found!!</small><br/>";
else{
if($get_gender=="MF")$gender="(b.sex='M' OR b.sex='F')";
if($get_gender=="M")$gender="b.sex='M'";
else if($get_gender=="F")$gender="b.sex='F'";
if($get_age=="all")$age="b.age>0";
else if($get_age=="14-18")$age="b.age>=14 AND b.age<=18";
else if($get_age=="19-25")$age="b.age>=19 AND b.age<=25";
else if($get_age=="26-34")$age="b.age>=26 AND b.age<=34";
else if($get_age=="35-49")$age="b.age>=35 AND b.age<=49";
else if($get_age=="50+")$age="b.age>=50";
if(empty($get_other))$country="b.location LIKE '%$get_country%'";
else $country="b.location LIKE '%$get_other%'";
$results=mysql_num_rows(joined_query("a.id,a.username,b.age,b.sex,b.location,b.photo",users,userprofiles,"a.id=b.uid","$gender AND $age AND $country"));
$query=joined_query("a.id,a.username,b.age,b.sex,b.location,b.photo",users,userprofiles,"a.id=b.uid","$gender AND $age AND $country ORDER BY a.lastseen DESC LIMIT ".($page-1)*$usersperpage.",$usersperpage");
if(mysql_num_rows($query)>0){
while($row=mysql_fetch_array($query)){
if(!empty($row['photo']))$photo="<img src=\"/phpThumb/phpThumb.php?src=$row[photo]&amp;f=gif&amp;w=50\" alt=\"$row[username]\"/>";
else $photo="";
if(profiles_table("sex",$row[id])=="M")$sex=" style=\"color:#0000FF;\"";
else if(profiles_table("sex",$row[id])=="F")$sex=" style=\"color:#FF0066;\"";
$resultlist.="$photo<a href=\"".$action."options".$mod."profile&amp;user=$row[username]".$session."\"$sex>$row[username]</a> - <small>$row[age]/$row[sex]/$row[location]</small><br/>";
}
}
else $resultlist.="<img src=\"./images/point.gif\" alt=\"[!]\"/><small>no matches found!!</small><br/>";
if($page>1)$controls.="<a href=\"".$action."findfriends".$mod."searchproperty&amp;search=1&amp;age=$get_age&amp;gender=$get_gender&amp;country=$get_country&amp;other=$get_other&amp;page=".($page-1).$session."\">&lt;- prev</a>";
if($page>1&&$results>$page*$usersperpage)$controls.="\n | ";
if($results>$page*$usersperpage)$controls.="<a href=\"".$action."findfriends".$mod."searchproperty&amp;search=1&amp;age=$get_age&amp;gender=$get_gender&amp;country=$get_country&amp;other=$get_other&amp;page=".($page+1).$session."\">next -&gt;</a>";
if($page>1||$results>$page*$usersperpage)$controls.="<br/>";
$what=Array("sitename","username","results","resultlist","controls","return");
$with=Array($sitename,users_table("username",$uid),$results,$resultlist,$controls,$mode);
Template($what,$with,"searchresults");
exit;
}
}
$what=Array("sitename","username","msg");
$with=Array($sitename,users_table("username",$uid),$msg);
Template($what,$with,"searchproperty");
exit;
}

/////SEARCH DETAILS/////
else if($mode=="searchdetails")
{
$page=get_var("page");
if(empty($page))$page=1;
$search=get_var("search");
if($search==1){
$terms=get_var("terms");
$keywords=get_var("keywords");
if(IllegalChars($keywords))$msg="<img src=\"./images/error.gif\" alt=\"[x]\"/><small>Illegal chars found!!</small><br/>";
else{
if($terms=="all")$type="AND";
else if($terms=="any")$type="OR";
$get_keywords=explode(",",$keywords);
if(!empty($get_keywords[0]))$likes="(b.likes LIKE '%$get_keywords[0]%' OR b.hates LIKE '%$get_keywords[0]%')";
if(!empty($get_keywords[1]))$likes.=" $type (b.likes LIKE '%$get_keywords[1]%' OR b.hates LIKE '%$get_keywords[1]%')";
if(!empty($get_keywords[2]))$likes.=" $type (b.likes LIKE '%$get_keywords[2]%' OR b.hates LIKE '%$get_keywords[2]%')";
if(!empty($get_keywords[3]))$likes.=" $type (b.likes LIKE '%$get_keywords[3]%' OR b.hates LIKE '%$get_keywords[3]%')";
if(!empty($get_keywords[4]))$likes.=" $type (b.likes LIKE '%$get_keywords[4]%' OR b.hates LIKE '%$get_keywords[4]%')";
$results=mysql_num_rows(joined_query("a.id,a.username,b.age,b.sex,b.location,b.photo",users,userprofiles,"a.id=b.uid","$likes"));
$query=joined_query("a.id,a.username,b.age,b.sex,b.location,b.photo",users,userprofiles,"a.id=b.uid","$likes ORDER BY a.lastseen DESC LIMIT ".($page-1)*$usersperpage.",$usersperpage");
if(mysql_num_rows($query)>0){
while($row=mysql_fetch_array($query)){
if(!empty($row['photo']))$photo="<img src=\"/phpThumb/phpThumb.php?src=$row[photo]&amp;f=gif&amp;w=50\" alt=\"$row[username]\"/>";
else $photo="";
if(profiles_table("sex",$row[id])=="M")$sex=" style=\"color:#0000FF;\"";
else if(profiles_table("sex",$row[id])=="F")$sex=" style=\"color:#FF0066;\"";
$resultlist.="$photo<a href=\"".$action."options".$mod."profile&amp;user=$row[username]".$session."\"$sex>$row[username]</a> - <small>$row[age]/$row[sex]/$row[location]</small><br/>";
}
}
else $resultlist.="<img src=\"./images/point.gif\" alt=\"[!]\"/><small>no matches found!!</small><br/>";
if($page>1)$controls.="<a href=\"".$action."findfriends".$mod."searchdetails&amp;search=1&amp;keywords=$keywords&amp;terms=$terms&amp;page=".($page-1).$session."\">&lt;- prev</a>";
if($page>1&&$results>$page*$usersperpage)$controls.="\n | ";
if($results>$page*$usersperpage)$controls.="<a href=\"".$action."findfriends".$mod."searchdetails&amp;search=1&amp;keywords=$keywords&amp;terms=$terms&amp;page=".($page+1).$session."\">next -&gt;</a>";
if($page>1||$results>$page*$usersperpage)$controls.="<br/>";
$what=Array("sitename","username","results","resultlist","controls","return");
$with=Array($sitename,users_table("username",$uid),$results,$resultlist,$controls,$mode);
Template($what,$with,"searchresults");
exit;
}
}
$what=Array("sitename","username","msg");
$with=Array($sitename,users_table("username",$uid),$msg);
Template($what,$with,"searchdetails");
exit;
}


/////SEARCH PROFILE/////
else if($mode=="searchprofiles")
{
$user=get_var("user");
$return=get_var("return");
$what=Array("sitename","username","msg","user");
$with=Array($sitename,users_table("username",$uid),$msg,$user);
Template($what,$with,"searchprofiles");
exit;
}

$time=time();
$regusers=num_rows("id",users,"banned='N'");
$onlineusers=num_rows("id",users,"$time-lastseen<=$offlinetime");

?>