Files
Testing/search_advanced1.php

493 lines
20 KiB
PHP
Raw Permalink Normal View History

2026-11-17 16:15:01 -05:00
<?php
/* $Id: search_advanced.php 42 2009-01-29 04:55:14Z john $ */
$page = "search_advanced";
include "header.php";
$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 = ""; }
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['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['p'])) { $p = $_POST['p']; } elseif(isset($_GET['p'])) { $p = $_GET['p']; } else { $p = 1; }
if(isset($_POST['field_13'])) { $city = $_POST['field_13']; } elseif(isset($_GET['field_13'])) { $city = $_GET['field_13']; } else { $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 = ""; }
if(isset($_POST['username'])) { $username = $_POST['username']; } elseif(isset($_GET['username'])) { $username = $_GET['username']; } else { $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['introvids'])) { $introvids = $_POST['introvids']; } elseif(isset($_GET['introvids'])) { $introvids = $_GET['introvids']; } else { $introvids = ""; }
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='".$zip."' AND bateworldcom_zips.countries.id='".$country."' AND bateworldcom_zips.provinces.id='".$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='".$zip."' AND bateworldcom_zips.countries.id='".$country."' AND bateworldcom_zips.tbl_state.state_id='".$state."' AND bateworldcom_zips.tbl_state.state_abbr=admin_code1 AND bateworldcom_zips.countries.alpha_2=bateworldcom_zips.zipcodes1.country_code 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='".$zip."' AND bateworldcom_zips.countries.id='".$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='".$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"]);
$sql1="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 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="se_profilevalues.profilevalue_27='".$row1["postal_code"]."'";
}
else{
$zips.=" OR se_profilevalues.profilevalue_27='".$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 * 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."'";
}
$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 (".$zips.")";}
if($user_online=="1"){
$sql=$sql." AND user_lastactive>'".(time()-10*60)."' AND user_invisible=0 ";
}
if($user_withphoto=="1"){
$sql=$sql." AND user_photo <> '' ";
}
if($introvids=="1"){
$sql=$sql." AND (introvid <> '' AND introapproved=1) ";
}
if($_GET["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);
$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);
// ASSIGN VARIABLES AND INCLUDE FOOTER
$smarty->assign('friend', $friend);
$smarty->assign('introvids', $introvids);
$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";
?>