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.=''; } } $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"; ?>