<?php
include "inc/init.php";
include 'lib/pagination.class.php';
$page->title = "Users of ". $set->site_name;
$page->description = "user info";
$page->keyword = "";
$presets->setActive("userslist"); // we highlight the home link
$content = ''; // will store the html code for users list
if(!isset($_GET['page']))
$page_number = 1;
$sort_name = array("id", "name");
// sorting
if(!isset($_GET['sort']) || !in_array($_GET['sort'], array(0,1))) // check if it's a valid sort option
$sort = 0;
else
$sort = (int)$_GET['sort'];
if(!isset($_GET['sort_type']) || !in_array($_GET['sort_type'], array(0,1)))
$sort_type = 0;
else
$sort_type = (int)$_GET['sort_type'];
if($sort == 1) {
$order_by = "`username` ". (!$sort_type ? "ASC" : "DESC");
} else {
$order_by = "`userid` ". (!$sort_type ? "ASC" : "DESC");
}
$show_sort_options = '';
foreach ($sort_name as $k => $v) {
if($k != $sort)
$show_sort_options .= "<li><a href='?sort=$k'>Sort by $v</a></li>";
}
// search
$where = '';
if(isset($_GET['q']))
$where = $db->parse("WHERE `username` LIKE ?s", '%'.$_GET['q'].'%');
if($total_results = $db->getRow("SELECT COUNT(*) as count FROM `".MLS_PREFIX."users` ?p", $where)->count) {
// pagination
if(!isset($page_number))
$page_number = (int)$_GET['page'] <= 0 ? 1 : (int)$_GET['page']; // grab the page number
$perpage = 10; // number of elements perpage
if($page_number > ceil($total_results/$perpage))
$page_number = ceil($total_results/$perpage);
$start = ($page_number - 1) * $perpage;
$data = $db->getAll("SELECT * FROM `".MLS_PREFIX."users` ?p ORDER BY ?p LIMIT ?i,?i", $where, $order_by, $start, $perpage);
$pagination = new pagination($total_results, $page_number, $perpage);
foreach($data as $u) {
$content .= "
<div class='col-xs-4 col-md-2'>
<div style='text-align:center'>
<a href='$set->url/profile.php?u=$u->userid'>
<img class='img-circle img-responsive' src='".$user->getAvatar($u->userid)."' alt='".$options->html($u->username)."' style='margin: 0 auto;'></a>
<h4>
<a href='$set->url/profile.php?u=$u->userid'>".$user->showName($u->userid)."</a>
</h4>
<small>
<b>Last seen: </b> ".$options->tsince($u->lastactive)."
</small>
</div>
</div>
";
}
} else
$page->error = "No results were found !";
include 'admin/header.php';
include "admin/menu-side.php";
echo "
<h3 class='pull-left'>Users on ".$set->site_name."</h3>
<form class='form-horizontal' action='?'>
<div class='pull-right'>
<div class='input-group'>
<input class='form-control' name='q' type='text' ".( isset($_GET['q']) ? "value='".$options->html($_GET['q'])."'" : "" )." placeholder='Search...'/>
<span class='input-group-btn'>
<button type='submit' class='btn'><span class='glyphicon glyphicon-search' aria-hidden='true'></span></button>
</span>
</div><!-- /input-group -->
".$options->queryString("hidden", array("q","page"))."
</div>
</form>
<div class='clearfix'></div>
<br>
<div class='dropdown pull-right'>
<button class='btn btn-default dropdown-toggle' type='button' id='dropdownMenu1' data-toggle='dropdown' aria-haspopup='true' aria-expanded='true'>
<a class='btn btn' href='?sort=$sort&sort_type=".(!$sort_type ? 1 : 0)."'><i class='icon-chevron-".(!$sort_type ? 'up' : 'down')."'></i> Sort by ".$sort_name[$sort]."</a>
<span class='caret'></span>
</button>
<ul class='dropdown-menu'>
$show_sort_options
</ul>
</div>
<div class='clearfix'></div>";
if(isset($data))
echo "<small>Showing ".($start+1)."-".($start+count($data))." out of ".$total_results."</small><hr>";
else
echo "<hr>";
if(isset($page->error))
$options->error($page->error);
else if(isset($page->success))
$options->success($page->success);
echo "
<div class='row'>
$content
</div>
".(isset($pagination) ? $pagination->pages : "" )." ";
include 'admin/admin-footer.php';
?>
|
Download
