Files
Testing/batorquiz.php
sean 0e8a8b3028
Some checks are pending
deploy-testing / deploy (push) Waiting to run
Initial testing snapshot
2026-11-17 16:15:01 -05:00

217 lines
8.2 KiB
PHP

<?php
/* $Id: search_advanced.php 42 2009-01-29 04:55:14Z john $ */
$page = "motmbrowse";
include "header.php";
// 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";
}
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.='<input type="hidden" name="'.$key.'" value="'.$value.'" />';
}
}
$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";
?>