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"; } 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['sortby'])) { $sortby = $_POST['sortby']; } elseif(isset($_GET['sortby'])) { $sortby = $_GET['sortby']; } else { $sortby ="1"; } if($sortby==1) { $sort="introtime DESC"; } elseif($sortby==2) { $sort="user_id DESC"; } else{$sort="introtime DESC";} // SET VARS $showfields = 1; $linked_field_title = ""; $linked_field_value = ""; $users_per_page = 40; // BROWSE USERS WITH A VALUE IN A SPECIFIC FIELD // LINKED FROM PROFILE if($task == "browse") {} // SEARCH THROUGH USERS BASED ON NUMEROUS PROFILE CRITERIA else { // START FIELD OBJECT $field = new se_field("profile"); // GET CATS TO DISPLAY ACROSS TOP $field->cat_list(0, 0, 0, "(SELECT TRUE FROM se_profilecats AS t2 LEFT JOIN se_profilefields ON t2.profilecat_id=se_profilefields.profilefield_profilecat_id WHERE t2.profilecat_dependency=se_profilecats.profilecat_id AND profilefield_search<>0 LIMIT 1)", "profilecat_id=0"); $cat_menu_array = $field->cats; if(isset($_POST['cat_selected'])) { $cat_selected = $_POST['cat_selected']; } elseif(isset($_GET['cat_selected'])) { $cat_selected = $_GET['cat_selected']; } else { $cat_selected = $cat_menu_array[0]['cat_id']; } // GET LIST OF FIELDS $field->cat_list(0, 0, 1, "profilecat_id='{$cat_selected}'", "", "profilefield_search<>'0'"); $cat_array = $field->cats; $url_string = $field->url_string; // PERFORM SEARCH if(isset($_POST['user_online'])) { $user_online = $_POST['user_online']; } elseif(isset($_GET['user_online'])) { $user_online = $_GET['user_online']; } else { $user_online = 0; } if(isset($_POST['user_withphoto'])) { $user_withphoto = $_POST['user_withphoto']; } elseif(isset($_GET['user_withphoto'])) { $user_withphoto = $_GET['user_withphoto']; } else { $user_withphoto = 0; } if(isset($_POST['uservideos'])) { $uservideos = $_POST['uservideos']; } elseif(isset($_GET['uservideos'])) { $uservideos = $_GET['uservideos']; } else { $uservideos = 0; } $introvids=1; // BEGIN CONSTRUCTING SEARCH QUERY $search_query = "SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo FROM motm_answers,se_users 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') AND se_users.user_id=motm_answers.user_id GROUP BY se_users.user_id "; if($uservideos == 1) { //$search_query .= " AND se_users.user_id IN (SELECT video_user_id FROM se_videos WHERE video_admin_approved='1')"; } if($field->field_query != "") { $search_query .= " AND ".$field->field_query; } // GET TOTAL USERS $total_users = $database->database_num_rows($database->database_query($search_query)); // MAKE SEARCH PAGES $page_vars = make_page($total_users, $users_per_page, $p); // ADD LIMIT TO QUERY $search_query .= " ORDER BY $sort LIMIT $page_vars[0], $users_per_page"; //if(SE_DEBUG){echo $search_query; } // GET USERS if(SE_DEBUG1){echo $search_query;} $online_users_array = online_users(); $users = $database->database_query($search_query) or die($database->database_error()); 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; } $search_query = "SELECT COUNT(*) FROM motm_answers, se_users 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') AND se_users.user_id=motm_answers.user_id GROUP BY se_users.user_id "; // GET TOTAL USERS $total_users = $database->database_num_rows($database->database_query($search_query)); $rand=rand(1, $total_users-56); // BEGIN CONSTRUCTING SEARCH QUERY $search_query = "SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo FROM motm_answers,se_users 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') AND se_users.user_id=motm_answers.user_id GROUP BY se_users.user_id "; // GET TOTAL USERS $total_users = $database->database_num_rows($database->database_query($search_query)); // MAKE SEARCH PAGES $page_vars = make_page($total_users, $users_per_page, $p); // ADD LIMIT TO QUERY $search_query .= " ORDER BY $sort LIMIT $page_vars[0], $users_per_page"; //if(SE_DEBUG){echo $search_query; } // GET USERS $online_users_array = online_users(); $users = $database->database_query($search_query); while($user_info = $database->database_fetch_assoc($users)) { $group_files1 = new se_user(); $group_files1->user_info['user_id'] = $user_info['user_id']; $group_files1->user_info['user_username'] = $user_info['user_username']; $group_files1->user_info['user_fname'] = $user_info['user_fname']; $group_files1->user_info['user_lname'] = $user_info['user_lname']; $group_files1->user_info['user_photo'] = $user_info['user_photo']; $group_files1->user_displayname(); // DETERMINE IF USER IS ONLINE if(in_array($group_files1->user_info['user_username'], $online_users_array[2])) { $group_files1->is_online = 1; } else { $group_files1->is_online = 0; } $group_files[] = $group_files1; } // SET GLOBAL PAGE TITLE $global_page_title[0] = 926; $global_page_description[0] = 1088; }$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); $smarty->assign_by_ref('signups', $group_files); // ASSIGN VARIABLES AND INCLUDE FOOTER $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('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', $sortby); $smarty->assign('task', $task); $smarty->assign('user_online', $user_online); $smarty->assign('user_withphoto', $user_withphoto); include "footer.php"; ?>