618 lines
25 KiB
PHP
618 lines
25 KiB
PHP
<?php
|
|
|
|
|
|
|
|
/* $Id: search_advanced.php 42 2009-01-29 04:55:14Z john $ */
|
|
|
|
|
|
|
|
$page = "local_bators";
|
|
|
|
include "header.php";
|
|
if(isset($_POST['p'])) { $p = $_POST['p']; } elseif(isset($_GET['p'])) { $p = $_GET['p']; } else { $p = 1; }
|
|
if(isset($_POST['favorites'])) { $fave = $_POST['favorites']; } elseif(isset($_GET['favorites'])) { $fave = $_GET['favorites']; } else { $fave = 0; }
|
|
|
|
$p1=$p;
|
|
|
|
if(isset($_GET["field_27"])){
|
|
$database->database_query("UPDATE se_usersettings SET browsesettings='".serialize($_GET)."' WHERE usersetting_user_id='{$user->user_info['user_id']}' LIMIT 1");
|
|
|
|
}
|
|
else{$_GET=unserialize($user->usersetting_info['browsesettings']);}
|
|
|
|
$p=$p1;
|
|
$url_string1 ="";
|
|
$users_per_page = 24;
|
|
$showfields = 1;
|
|
if(isset($_POST['field_27'])) { $zip = $_POST['field_27']; } elseif(isset($_GET['field_27'])) { $zip = $_GET['field_27']; } else { $zip = ""; }
|
|
$zip=trim($zip);
|
|
if(isset($_POST['field_29'])) { $country = $_POST['field_29']; } elseif(isset($_GET['field_29'])) { $country = $_GET['field_29']; } else { $country = "236"; }
|
|
if(isset($_POST['field_30'])) { $state = $_POST['field_30']; } elseif(isset($_GET['field_30'])) { $state = $_GET['field_30']; } else { $state = "-1"; }
|
|
if(isset($_POST['field_31'])) { $province = $_POST['field_31']; } elseif(isset($_GET['field_31'])) { $province = $_GET['field_31']; } else { $province = "-1"; }
|
|
|
|
if(isset($_POST['field_32'])) { $hosting = $_POST['field_32']; } elseif(isset($_GET['field_32'])) { $hosting = $_GET['field_32']; } else { $hosting = "-1"; }
|
|
|
|
if(isset($_POST['distance'])) { $distance = $_POST['distance']; } elseif(isset($_GET['distance'])) { $distance = $_GET['distance']; } else { $distance = "5"; }
|
|
|
|
if(isset($_POST['task'])) { $task = $_POST['task']; } elseif(isset($_GET['task'])) { $task = $_GET['task']; } else { $task = "main"; }
|
|
|
|
|
|
if(isset($_POST['field_13'])) { $city = $_POST['field_13']; } elseif(isset($_GET['field_13'])) { $city = $_GET['field_13']; } else { $city = ""; }
|
|
$city=trim($city);
|
|
if(isset($_POST['friend'])) { $friend = $_POST['friend']; } elseif(isset($_GET['friend'])) { $friend = $_GET['friend']; } else { $friend = ""; }
|
|
|
|
|
|
if(isset($_POST['about'])) { $about = $_POST['about']; } elseif(isset($_GET['about'])) { $about = $_GET['about']; } else { $about = ""; }
|
|
$about=trim($about);
|
|
if(isset($_POST['username'])) { $username = $_POST['username']; } elseif(isset($_GET['username'])) { $username = $_GET['username']; } else { $username = ""; }
|
|
$username=trim($username);
|
|
if(isset($_POST['field_4_3_min'])) { $min = $_POST['field_4_3_min']; } elseif(isset($_GET['field_4_3_min'])) { $min = $_GET['field_4_3_min']; } else { $min = "-1"; }
|
|
if(isset($_POST['field_4_3_max'])) { $max = $_POST['field_4_3_max']; } elseif(isset($_GET['field_4_3_max'])) { $max = $_GET['field_4_3_max']; } else { $max = "-1"; }
|
|
if(isset($_POST['field_10'])) { $orientation = $_POST['field_10']; } elseif(isset($_GET['field_10'])) { $orientation = $_GET['field_10']; } else { $orientation = "-1"; }
|
|
if(isset($_POST['field_9'])) { $size = $_POST['field_9']; } elseif(isset($_GET['field_9'])) { $size = $_GET['field_9']; } else { $size = "-1"; }
|
|
|
|
if(isset($_POST['field_15'])) { $cut = $_POST['field_15']; } elseif(isset($_GET['field_15'])) { $cut = $_GET['field_15']; } else { $cut = "-1"; }
|
|
|
|
if(isset($_POST['field_16'])) { $hair = $_POST['field_16']; } elseif(isset($_GET['field_16'])) { $hair = $_GET['field_16']; } else { $hair = "-1"; }
|
|
if(isset($_POST['field_28'])) { $bodytype = $_POST['field_28']; } elseif(isset($_GET['field_28'])) { $bodytype = $_GET['field_28']; } else { $bodytype = "-1"; }
|
|
if(isset($_POST['field_17'])) { $decoration = $_POST['field_17']; } elseif(isset($_GET['field_17'])) { $decoration = $_GET['field_17']; } else { $decoration = "-1"; }
|
|
if(isset($_POST['user_online'])) { $user_online = $_POST['user_online']; } elseif(isset($_GET['user_online'])) { $user_online = $_GET['user_online']; } else { $user_online = ""; }
|
|
|
|
if(isset($_POST['user_withphoto'])) { $user_withphoto = $_POST['user_withphoto']; } elseif(isset($_GET['user_withphoto'])) { $user_withphoto = $_GET['user_withphoto']; } else { $user_withphoto = ""; }
|
|
|
|
if(isset($_POST['chaturbate'])) { $chaturbate = $_POST['chaturbate']; } elseif(isset($_GET['chaturbate'])) { $chaturbate = $_GET['chaturbate']; } else { $chaturbate = ""; }
|
|
|
|
if(isset($_POST['jff'])) { $jff = $_POST['jff']; } elseif(isset($_GET['jff'])) { $jff = $_GET['jff']; } else { $jff = ""; }
|
|
|
|
if(isset($_POST['verified'])) { $verified = $_POST['verified']; } elseif(isset($_GET['verified'])) { $verified = $_GET['verified']; } else { $verified = ""; }
|
|
|
|
if(isset($_POST['onlyfans'])) { $onlyfans = $_POST['onlyfans']; } elseif(isset($_GET['onlyfans'])) { $onlyfans = $_GET['onlyfans']; } else { $onlyfans = ""; }
|
|
|
|
if(isset($_POST['introvids'])) { $introvids = $_POST['introvids']; } elseif(isset($_GET['introvids'])) { $introvids = $_GET['introvids']; } else { $introvids = ""; }
|
|
if(isset($_POST['motm'])) { $motm = $_POST['motm']; } elseif(isset($_GET['motm'])) { $motm = $_GET['motm']; } else { $motm = ""; }
|
|
|
|
|
|
if(isset($_POST['field_2'])) { $membername = $_POST['field_2']; } elseif(isset($_GET['field_2'])) { $membername = $_GET['field_2']; } else { $membername = ""; }
|
|
$smarty->assign('zip', $zip);
|
|
$smarty->assign('state', $state);
|
|
$smarty->assign('province', $province);
|
|
$smarty->assign('distance', $distance);
|
|
$smarty->assign('min', $min);
|
|
$smarty->assign('max', $max);
|
|
$smarty->assign('orientation', $orientation);
|
|
$smarty->assign('size', $size);
|
|
$smarty->assign('cut', $cut);
|
|
$smarty->assign('hair', $hair);
|
|
$smarty->assign('bodytype', $bodytype);
|
|
$smarty->assign('decoration', $decoration);
|
|
$smarty->assign('membername', $membername);
|
|
|
|
|
|
if(isset($_POST['sort'])) { $sort = $_POST['sort']; } elseif(isset($_GET['sort'])) { $sort = $_GET['sort']; } else {$sort = "user_dateupdated DESC"; }
|
|
|
|
|
|
if($task!="browse"){
|
|
|
|
if($zip!="")
|
|
{
|
|
if($country=="40"&&$province>0){
|
|
$query=$database->database_query("SELECT latitude, longitude FROM bateworldcom_zips.zipcodes1, bateworldcom_zips.countries, bateworldcom_zips.provinces WHERE bateworldcom_zips.zipcodes1.postal_code='".$database->database_real_escape_string($zip)."' AND bateworldcom_zips.countries.id='".$database->database_real_escape_string($country)."' AND bateworldcom_zips.provinces.id='".$database->database_real_escape_string($province)."' AND bateworldcom_zips.provinces.abbr=admin_code1 AND bateworldcom_zips.countries.alpha_2=bateworldcom_zips.zipcodes1.country_code LIMIT 1");
|
|
}
|
|
elseif($country=="236"&&$state>0){
|
|
|
|
|
|
|
|
$query=$database->database_query("SELECT latitude, longitude FROM bateworldcom_zips.zipcodes1, bateworldcom_zips.countries, bateworldcom_zips.tbl_state WHERE bateworldcom_zips.zipcodes1.postal_code='".$database->database_real_escape_string($zip)."' AND bateworldcom_zips.countries.id='".$database->database_real_escape_string($country)."' AND bateworldcom_zips.tbl_state.state_id='".$database->database_real_escape_string($state)."' AND bateworldcom_zips.tbl_state.state_abbr=admin_code1 AND bateworldcom_zips.countries.alpha_2=bateworldcom_zips.zipcodes1.country_code AND bateworldcom_zips.zipcodes1.country_code='US' LIMIT 1");
|
|
}
|
|
elseif($country!="-1"){
|
|
$query=$database->database_query("SELECT latitude, longitude FROM bateworldcom_zips.zipcodes1, bateworldcom_zips.countries WHERE bateworldcom_zips.zipcodes1.postal_code='".$database->database_real_escape_string($zip)."' AND bateworldcom_zips.countries.id='".$database->database_real_escape_string($country)."' AND bateworldcom_zips.countries.alpha_2=bateworldcom_zips.zipcodes1.country_code LIMIT 1");
|
|
|
|
}
|
|
else{
|
|
|
|
$query=$database->database_query("SELECT latitude, longitude FROM bateworldcom_zips.zipcodes1 WHERE postal_code='".$database->database_real_escape_string($zip)."' LIMIT 1");
|
|
}
|
|
|
|
$row=$database->database_fetch_array($query);
|
|
|
|
|
|
if($row["latitude"]!=""){
|
|
$coslat=cos(deg2rad($row["latitude"]));
|
|
$sinlat=sin( deg2rad($row["latitude"]) );
|
|
$radlon=deg2rad($row["longitude"]);
|
|
/*
|
|
"(SELECT country_code, place_name, admin_name1, admin_code1, postal_code, 0 AS distance FROM bateworldcom_zips.zipcodes1 WHERE postal_code='11237')
|
|
UNION
|
|
(SELECT country_code, place_name, admin_name1, admin_code1, postal_code, ( 3959 * acos( 0.75812750739757
|
|
* cos( radianslat ) * cos( radianslon - -1.2901124764892 )
|
|
+ 0.65210634295884 * sin( radianslat ) ) )
|
|
AS distance FROM bateworldcom_zips.zipcodes1 HAVING distance <= 5)
|
|
ORDER BY distance ASC LIMIT 0 , 10000"
|
|
*/
|
|
$sql1=" (SELECT country_code, place_name, admin_name1, admin_code1, postal_code, 0 AS distance FROM bateworldcom_zips.zipcodes1 WHERE postal_code='".$database->database_real_escape_string($zip)."')
|
|
UNION
|
|
(SELECT country_code, place_name, admin_name1, admin_code1, postal_code, ( 3959 * acos( ".$coslat."
|
|
* cos( radianslat ) * cos( radianslon - ".$radlon." )
|
|
+ ".$sinlat." * sin( radianslat ) ) )
|
|
AS distance FROM bateworldcom_zips.zipcodes1 WHERE (latitude<=".($row["latitude"]+1)." AND latitude>=".($row["latitude"]-1).") AND (longitude<=".($row["longitude"]+1)." AND longitude>=".($row["longitude"]-1).") HAVING distance <= ".$database->database_real_escape_string($distance).")
|
|
ORDER BY distance ASC LIMIT 0 , 10000";
|
|
|
|
$url_string1 .="field_27=".urlencode($zip)."&";
|
|
|
|
|
|
$query1=$database->database_query($sql1);
|
|
$o=1;
|
|
while($row1=$database->database_fetch_array($query1))
|
|
{
|
|
if($o==1){
|
|
$zips="'".$row1["postal_code"]."'";
|
|
|
|
}
|
|
else{
|
|
$zips.=", '".$row1["postal_code"]."'";
|
|
}
|
|
$o++;
|
|
}
|
|
|
|
}
|
|
else{$total_users=0;}
|
|
|
|
|
|
|
|
}
|
|
if($friend!="")
|
|
{
|
|
|
|
$friends=$database->database_query("SELECT * FROM se_friends WHERE (friend_user_id1='".$user->user_info["user_id"]."') AND friend_status=1");
|
|
|
|
$i=1;
|
|
while($row3=$database->database_fetch_array($friends))
|
|
{
|
|
if($row3["friend_user_id2"]==$user->user_info["user_id"]){$friend1=$row3["friend_user_id1"];}
|
|
else{$friend1=$row3["friend_user_id2"];}
|
|
if($i==1){$friendly="AND (se_users.user_id='".$friend1."'";}
|
|
else{
|
|
$friendly.="OR se_users.user_id='".$friend1."'";
|
|
}
|
|
$i++;
|
|
|
|
}
|
|
if($i>1){ $friendly.=") ";}
|
|
|
|
}
|
|
|
|
|
|
$sql="SELECT user_username, user_photo, user_id, user_photo FROM se_users, se_profilevalues WHERE se_users.user_id=se_profilevalues.profilevalue_user_id AND se_users.user_enabled=1 ";
|
|
|
|
if($friend!="")
|
|
{
|
|
|
|
$sql=$sql.$friendly;
|
|
}$url_string1 .="friend=".urlencode($friend)."&";
|
|
|
|
|
|
if($min!="-1"){
|
|
$sql=$sql." AND se_profilevalues.profilevalue_4<='".$min."-".date("m")."-".date("d")."'";
|
|
|
|
}$url_string1 .="field_4_3_min=".urlencode($min)."&";
|
|
if($max!="-1"){
|
|
$sql=$sql." AND se_profilevalues.profilevalue_4>='".$max."-".date("m")."-".date("d")."'";
|
|
|
|
}$url_string1 .="field_4_3_max=".urlencode($max)."&";
|
|
$url_string1 .="distance=".urlencode($distance)."&";
|
|
if($orientation!="-1"){
|
|
$sql=$sql." AND se_profilevalues.profilevalue_10='".$orientation."'";
|
|
|
|
}$url_string1 .="field_10=".urlencode($orientation)."&";
|
|
if($size!="-1"){
|
|
$sql=$sql." AND se_profilevalues.profilevalue_9='".$size."'";
|
|
|
|
}$url_string1 .="field_9=".urlencode($size)."&";
|
|
if($cut!="-1"){
|
|
$sql=$sql." AND se_profilevalues.profilevalue_15='".$cut."'";
|
|
|
|
}$url_string1 .="field_15=".urlencode($cut)."&";
|
|
if($bodytype!="-1"){
|
|
$sql=$sql." AND se_profilevalues.profilevalue_28='".$bodytype."'";
|
|
|
|
}$url_string1 .="field_28=".urlencode($bodytype)."&";
|
|
if($hair!="-1"){
|
|
$sql=$sql." AND se_profilevalues.profilevalue_16='".$hair."'";
|
|
|
|
}
|
|
$url_string1 .="field_16=".urlencode($hair)."&";
|
|
|
|
if($about!=""){
|
|
$sql=$sql." AND se_profilevalues.profilevalue_21 LIKE'%".$about."%'";
|
|
|
|
}
|
|
|
|
$url_string1 .="about=".urlencode($about)."&";
|
|
if($username!=""){
|
|
$sql=$sql." AND se_users.user_username='".$username."'";
|
|
|
|
}
|
|
|
|
$url_string1 .="username=".urlencode($username)."&";
|
|
|
|
if($city!=""){
|
|
$sql=$sql." AND se_profilevalues.profilevalue_13='".$city."'";
|
|
|
|
}
|
|
if($hosting!="-1"){
|
|
$sql=$sql." AND se_profilevalues.profilevalue_32='".$hosting."'";
|
|
|
|
}
|
|
$url_string1 .="field_13=".urlencode($city)."&";
|
|
if($country!="-1"){
|
|
$sql=$sql." AND se_profilevalues.profilevalue_29='".$country."'";
|
|
|
|
}
|
|
$url_string1 .="field_29=".urlencode($country)."&";
|
|
if($state!="-1"&&$country==236){
|
|
$sql=$sql." AND se_profilevalues.profilevalue_30='".$state."'";
|
|
|
|
}
|
|
$url_string1 .="field_30=".urlencode($state)."&";
|
|
if($province!="-1"&&$country==40){
|
|
$sql=$sql." AND se_profilevalues.profilevalue_31='".$province."'";
|
|
|
|
}
|
|
$url_string1 .="field_31=".urlencode($province)."&";
|
|
if($decoration!="-1"){
|
|
$sql=$sql." AND se_profilevalues.profilevalue_17='".$decoration."'";
|
|
|
|
}
|
|
$url_string1 .="field_17=".urlencode($decoration)."&";
|
|
|
|
if($zips!=""){$sql=$sql."AND se_profilevalues.profilevalue_27 IN (".$zips.")";}
|
|
if($user_online=="1"){
|
|
$sql=$sql." AND `online`=1 AND user_invisible=0 ";
|
|
}
|
|
|
|
if($user_withphoto=="1"){
|
|
$sql=$sql." AND user_photo <> '' ";
|
|
}
|
|
if($introvids=="1"){
|
|
$sql=$sql." AND (introvid <> '' AND introapproved=1) ";
|
|
}
|
|
if($chaturbate=="1"){
|
|
$sql=$sql." AND se_profilevalues.profilevalue_41 <> '' ";
|
|
}
|
|
if($jff=="1"){
|
|
$sql=$sql." AND se_profilevalues.profilevalue_34 <> '' ";
|
|
}
|
|
if($verified=="1"){
|
|
$sql=$sql." AND se_users.verified = '1' ";
|
|
}
|
|
if($onlyfans=="1"){
|
|
$sql=$sql." AND se_profilevalues.profilevalue_33 <> '' ";
|
|
}
|
|
|
|
if($motm=="1"){
|
|
$sql=$sql." AND se_users.user_id IN (SELECT user_id FROM motm_answers GROUP BY user_id) ";
|
|
}
|
|
if($total_users===0){ $sql=$sql." AND 2=1 ";}
|
|
|
|
//$query1=$database->database_query($sql);
|
|
|
|
$blocked=explode(",", $user->user_info["user_blocklist"]);
|
|
foreach($blocked as $block){
|
|
if($block!=""){$blockstr="'".$block."',";}
|
|
|
|
}
|
|
$blockstr.="0";
|
|
|
|
|
|
$blocked="";
|
|
|
|
$query=$database->database_query("SELECT user_id FROM se_users WHERE user_enabled=1 AND MATCH(user_blocklist) AGAINST('".$user->user_info["user_id"]."' IN NATURAL LANGUAGE MODE)");
|
|
while($row2=$database->database_fetch_array($query))
|
|
{
|
|
if($blocked==""){$blocked="'".$database->database_real_escape_string($row2["user_id"])."'";}
|
|
else{
|
|
$blocked.=",'".$database->database_real_escape_string($row2["user_id"])."'";
|
|
}
|
|
}
|
|
if($blocked==""){$blocked="0";}
|
|
|
|
$sql .=" AND se_users.user_id NOT IN(".$blockstr.") ";
|
|
|
|
$sql.=" AND se_users.user_id NOT IN (".$blocked.")";
|
|
|
|
|
|
$online_users_array = online_users();
|
|
|
|
|
|
$total_users = $database->database_num_rows($database->database_query($sql));
|
|
|
|
// MAKE BROWSE PAGES
|
|
$page_vars = make_page($total_users, $users_per_page, $p);
|
|
|
|
// ADD LIMIT TO QUERY
|
|
$sql .= " ORDER BY $sort LIMIT $page_vars[0], $users_per_page";
|
|
|
|
$users = $database->database_query($sql);
|
|
|
|
while($user_info = $database->database_fetch_assoc($users))
|
|
{
|
|
$search_user = new se_user();
|
|
$search_user->user_info['user_id'] = $user_info['user_id'];
|
|
$search_user->user_info['user_username'] = $user_info['user_username'];
|
|
$search_user->user_info['user_fname'] = $user_info['user_fname'];
|
|
$search_user->user_info['user_lname'] = $user_info['user_lname'];
|
|
$search_user->user_info['user_photo'] = $user_info['user_photo'];
|
|
$search_user->user_displayname();
|
|
|
|
// DETERMINE IF USER IS ONLINE
|
|
if(in_array($search_user->user_info['user_username'], $online_users_array[2])) { $search_user->is_online = 1; } else { $search_user->is_online = 0; }
|
|
|
|
$user_array[] = $search_user;
|
|
}
|
|
|
|
}
|
|
|
|
|
|
|
|
// DISPLAY ERROR PAGE IF USER IS NOT LOGGED IN AND ADMIN SETTING REQUIRES REGISTRATION
|
|
if($user->user_exists == 0 && $setting['setting_permission_search'] == 0)
|
|
{
|
|
$page = "error";
|
|
$smarty->assign('error_header', 639);
|
|
$smarty->assign('error_message', 656);
|
|
$smarty->assign('error_submit', 641);
|
|
include "footer.php";
|
|
}
|
|
|
|
|
|
|
|
|
|
// SET VARS
|
|
$showfields = 1;
|
|
$linked_field_title = "";
|
|
$linked_field_value = "";
|
|
|
|
$users_per_page = 24;
|
|
|
|
|
|
// BROWSE USERS WITH A VALUE IN A SPECIFIC FIELD
|
|
// LINKED FROM PROFILE
|
|
if($task == "browse")
|
|
{
|
|
// GET BASIC VARIABLES
|
|
$field_id = $_GET['field_id'];
|
|
$field_value = $_GET['field_value'];
|
|
$linked_field_value = $field_value;
|
|
$url_string = "field_id=".$field_id."&field_value=".urlencode($field_value)."&";
|
|
$showfields = 0;
|
|
|
|
// BEGIN CONSTRUCTING BROWSE QUERY
|
|
$browse_query = "SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo FROM se_profilevalues LEFT JOIN se_users ON se_profilevalues.profilevalue_user_id=se_users.user_id LEFT JOIN se_levels ON se_levels.level_id=se_users.user_level_id WHERE se_users.user_verified='1' AND se_users.user_enabled='1' AND (se_users.user_search='1' OR se_levels.level_profile_search='0')";
|
|
|
|
// GET FIELD INFO
|
|
$field_info = $database->database_fetch_assoc($database->database_query("SELECT profilefield_id AS field_id, profilefield_title AS field_title, profilefield_type AS field_type, profilefield_options AS field_options, profilefield_dependency AS field_dependency FROM se_profilefields WHERE profilefield_id='$field_id'"));
|
|
|
|
// GET PARENT FIELD INFO
|
|
$parent_field_title = 0;
|
|
$parent_field_option = 0;
|
|
if($field_info['field_dependency'] != 0)
|
|
{
|
|
$parent_field_info = $database->database_fetch_assoc($database->database_query("SELECT profilefield_title AS field_title, profilefield_type AS field_type, profilefield_options AS field_options FROM se_profilefields WHERE profilefield_id='{$field_info['field_dependency']}'"));
|
|
$parent_field_title = $parent_field_info['field_title'];
|
|
if($parent_field_info['field_type'] == 3 || $parent_field_info['field_type'] == 4 || $parent_field_info['field_type'] == 6)
|
|
{
|
|
$options = unserialize($parent_field_info['field_options']);
|
|
for($i=0,$max=count($options);$i<$max;$i++)
|
|
{
|
|
if($field_info['field_id'] == $options[$i]['dependent_id']) { $parent_field_option = $options[$i]['label']; }
|
|
}
|
|
}
|
|
}
|
|
|
|
SE_Language::_preload_multi($field_info['field_title'], $parent_field_title, $parent_field_option);
|
|
SE_Language::load();
|
|
if(SE_Language::_get($parent_field_title) != "") { $linked_field_title = SE_Language::_get($parent_field_title).": "; }
|
|
if(SE_Language::_get($parent_field_option) != "") { $linked_field_title .= SE_Language::_get($parent_field_option); }
|
|
if($linked_field_title != "") { $linked_field_title .= " "; }
|
|
$linked_field_title .= SE_Language::_get($field_info['field_title']);
|
|
|
|
// GET FIELD VALUE
|
|
switch($field_info['field_type'])
|
|
{
|
|
case 1:
|
|
case 2:
|
|
$browse_query .= " AND profilevalue_{$field_info['field_id']} LIKE '%{$field_value}%'";
|
|
break;
|
|
case 3:
|
|
case 4:
|
|
$browse_query .= " AND profilevalue_{$field_info['field_id']}='{$field_value}'";
|
|
$options = unserialize($field_info['field_options']);
|
|
for($i=0,$max=count($options);$i<$max;$i++)
|
|
{
|
|
if($field_value == $options[$i]['value'])
|
|
{
|
|
SE_Language::_preload($options[$i]['label']);
|
|
SE_Language::load();
|
|
$linked_field_value = SE_Language::_get($options[$i]['label']);
|
|
|
|
}
|
|
}
|
|
break;
|
|
case 5:
|
|
$browse_query .= " AND (MONTH(profilevalue_{$field_info['field_id']})=MONTH('{$field_value}') OR MONTH('{$field_value}')=0) AND (DAY(profilevalue_{$field_info['field_id']})=DAY('{$field_value}') OR DAY('{$field_value}')=0) AND (YEAR(profilevalue_{$field_info['field_id']})=YEAR('{$field_value}') OR YEAR('{$field_value}')=0)";
|
|
|
|
// SET MONTH, DAY, AND YEAR FORMAT FROM SETTINGS
|
|
switch($setting['setting_dateformat'])
|
|
{
|
|
case "n/j/Y": case "n.j.Y": case "n-j-Y": case "M. j, Y": case "F j, Y": case "l, F j, Y": $date_order = "mdy"; break;
|
|
case "Y/n/j": case "Ynj": case "Y-n-d": case "Y-m-d": case "Y-M-j": $date_order = "ymd"; break;
|
|
case "j/n/Y": case "j.n.Y": case "j F Y": case "D j F Y": case "l j F Y": case "D-j-M-Y": case "D j M Y": case "j-M-Y": $date_order = "dmy"; break;
|
|
}
|
|
|
|
$year = substr($field_value, 0, 4);
|
|
$month = substr($field_value, 5, 2);
|
|
$day = substr($field_value, 8, 2);
|
|
if($field_value != "0000-00-00")
|
|
{
|
|
if($year == "0000") { $year = ""; }
|
|
if($month == "00") { $month = ""; } else { $month = $datetime->cdate("F", mktime(0, 0, 0, $month, 1, 1990)); }
|
|
if($day == "00") { $day = ""; } else { $day = $datetime->cdate("j", mktime(0, 0, 0, 1, $day, 1990)); }
|
|
switch($date_order)
|
|
{
|
|
case "mdy": $linked_field_value = "$month $day $year"; break;
|
|
case "ymd": $linked_field_value = "$year $month $day"; break;
|
|
case "dmy": $linked_field_value = "$day $month $year"; break;
|
|
}
|
|
}
|
|
break;
|
|
case 6:
|
|
$browse_query .= " AND FIND_IN_SET('{$field_value}', profilevalue_{$field_info['field_id']})";
|
|
$options = unserialize($field_info['field_options']);
|
|
for($i=0,$max=count($options);$i<$max;$i++)
|
|
{
|
|
if($field_value == $options[$i]['value'])
|
|
{
|
|
SE_Language::_preload($options[$i]['label']);
|
|
SE_Language::load();
|
|
$linked_field_value = SE_Language::_get($options[$i]['label']);
|
|
}
|
|
}
|
|
break;
|
|
}
|
|
|
|
// GET TOTAL USERS
|
|
$total_users = $database->database_num_rows($database->database_query($browse_query));
|
|
|
|
// MAKE BROWSE PAGES
|
|
$page_vars = make_page($total_users, $users_per_page, $p);
|
|
|
|
// ADD LIMIT TO QUERY
|
|
$browse_query .= " ORDER BY $sort LIMIT $page_vars[0], $users_per_page";
|
|
|
|
// GET USERS
|
|
$online_users_array = online_users();
|
|
$users = $database->database_query($browse_query);
|
|
while($user_info = $database->database_fetch_assoc($users))
|
|
{
|
|
$browse_user = new se_user();
|
|
$browse_user->user_info['user_id'] = $user_info['user_id'];
|
|
$browse_user->user_info['user_username'] = $user_info['user_username'];
|
|
$browse_user->user_info['user_fname'] = $user_info['user_fname'];
|
|
$browse_user->user_info['user_lname'] = $user_info['user_lname'];
|
|
$browse_user->user_info['user_photo'] = $user_info['user_photo'];
|
|
$browse_user->user_displayname();
|
|
|
|
// DETERMINE IF USER IS ONLINE
|
|
if(in_array($browse_user->user_info['user_username'], $online_users_array[2])) { $browse_user->is_online = 1; } else { $browse_user->is_online = 0; }
|
|
|
|
$user_array[] = $browse_user;
|
|
}
|
|
|
|
|
|
// SET GLOBAL PAGE TITLE/DESCRIPTION
|
|
$global_page_title[0] = 1083;
|
|
$global_page_title[1] = "$linked_field_title: $linked_field_value";
|
|
$global_page_description[0] = 1084;
|
|
$global_page_description[1] = $total_users;
|
|
$global_page_description[2] = "$linked_field_title: $linked_field_value";
|
|
|
|
}
|
|
|
|
|
|
// SEARCH THROUGH USERS BASED ON NUMEROUS PROFILE CRITERIA
|
|
$y=0;
|
|
for($x=$page_vars[1]; $x<=$page_vars[2]; $x++)
|
|
{
|
|
|
|
if(($page_vars[1]+10)==$x)
|
|
{break;}
|
|
$for[$y]=$x;
|
|
$y++;
|
|
}
|
|
$query_string = "";
|
|
if ($_POST) {
|
|
$kv = array();
|
|
foreach ($_POST as $key => $value) {
|
|
$kv[] = "$key=$value";
|
|
}
|
|
$query_string = join("&", $kv);
|
|
}
|
|
else {
|
|
$query_string = $_SERVER['QUERY_STRING'];
|
|
}
|
|
|
|
|
|
//echo $_SERVER['QUERY_STRING'];
|
|
parse_str($query_string, $myarray);
|
|
foreach($myarray as $key=>$value)
|
|
{
|
|
if($key!="p"){
|
|
$hidden.='<input type="hidden" name="'.$key.'" value="'.$value.'" />';
|
|
}
|
|
}
|
|
|
|
|
|
$smarty->assign('hidden', $hidden);
|
|
|
|
|
|
$_GET["fave"]="";
|
|
$_POST["fave"]="";
|
|
$str=http_build_query($_POST);
|
|
$str.=http_build_query($_GET);
|
|
$str="local_bators.php?".$str;
|
|
$str=str_replace("fave=&", "", $str);
|
|
$str=str_replace("&fave=", "", $str);
|
|
$str=str_replace("fave=", "", $str);
|
|
if($fave==="delete"){
|
|
|
|
$database->database_query("DELETE FROM favorites WHERE user='".$user->user_info["user_id"]."' AND type='browse' AND urlstring='".$database->database_real_escape_string($str)."'");
|
|
|
|
}
|
|
|
|
|
|
if($fave==="addto"){
|
|
$_GET["fave"]="";
|
|
$_POST["fave"]="";
|
|
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND type='browse' AND urlstring='".$database->database_real_escape_string($str)."'");
|
|
|
|
if($database->database_num_rows($query)==0){
|
|
$database->database_query("INSERT INTO favorites SET user='".$user->user_info["user_id"]."', type='browse', urlstring='".$database->database_real_escape_string($str)."'");
|
|
}
|
|
}
|
|
|
|
$query=$database->database_query("SELECT * FROM favorites WHERE user='".$user->user_info["user_id"]."' AND type='browse' AND urlstring='".$database->database_real_escape_string($str)."'");
|
|
if($database->database_num_rows($query)>0){$smarty->assign('favorites1', 1);}
|
|
|
|
$smarty->assign('favorites', 1);
|
|
|
|
|
|
$smarty->assign('for', $for);
|
|
$smarty->assign('verified', $verified);
|
|
// ASSIGN VARIABLES AND INCLUDE FOOTER
|
|
$smarty->assign('friend', $friend);
|
|
$smarty->assign('introvids', $introvids);
|
|
$smarty->assign('motm', $motm);
|
|
$smarty->assign('onlyfans', $onlyfans);
|
|
$smarty->assign('jff', $jff);
|
|
$smarty->assign('chaturbate', $chaturbate);
|
|
$smarty->assign('for', $for);
|
|
$smarty->assign('users', $user_array);
|
|
$smarty->assign('total_users', $total_users);
|
|
$smarty->assign('maxpage', $page_vars[2]);
|
|
$smarty->assign('p', $page_vars[1]);
|
|
$smarty->assign('p_start', $page_vars[0]+1);
|
|
$smarty->assign('p_end', $page_vars[0]+count($user_array));
|
|
$smarty->assign('showfields', $showfields);
|
|
$smarty->assign('url_string', $url_string);
|
|
$smarty->assign('url_string1', $url_string1);
|
|
$smarty->assign('linked_field_title', $linked_field_title);
|
|
$smarty->assign('linked_field_value', $linked_field_value);
|
|
$smarty->assign('cats_menu', $cat_menu_array);
|
|
$smarty->assign('cat_selected', $cat_selected);
|
|
$smarty->assign('cats', $cat_array);
|
|
$smarty->assign('sort', $sort);
|
|
$smarty->assign('task', $task);
|
|
$smarty->assign('user_online', $user_online);
|
|
$smarty->assign('user_withphoto', $user_withphoto);
|
|
include "footer.php";
|
|
?>
|