assign('zip', $zip); $smarty->assign('f_level', $f_level); $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($f_level!="") { $sql=$sql." AND se_users.user_level_id='".$f_level."'"; } 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["from"]!=""&&$_GET["to"]!=""){ $sql=$sql." AND (user_lastactive > $activefrom AND user_lastactive <= $activeto) "; } if($_GET["lfrom"]!=""&&$_GET["lto"]!=""){ $sql=$sql." AND (user_lastlogindate > $lactivefrom AND user_lastlogindate <= $lactiveto) "; } 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; } } // 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.=''; } } $smarty->assign('hidden', $hidden); // ASSIGN VARIABLES AND INCLUDE FOOTER $smarty->assign('to', $_GET["to"]); $smarty->assign('from', $_GET["from"]); $smarty->assign('lto', $_GET["lto"]); $smarty->assign('lfrom', $_GET["lfrom"]); $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 "admin_footer.php"; ?>