0)
$results_per_page = (int)$_GET['show'];
else
$results_per_page = 10;
// Approve users //
if (isset($_POST['approve']) && $_POST['approve'] != "")
{
$ids_arr = array();
$ids_arr = $_POST['id_arr'];
if (count($ids_arr) > 0)
{
foreach ($ids_arr as $v)
{
$userid = (int)$v;
ApproveUser($userid);
}
header("Location: users.php?".$params."msg=approved");
exit();
}
}
// DeActivate users //
if (isset($_POST['deactivate']) && $_POST['deactivate'] != "")
{
$ids_arr = array();
$ids_arr = $_POST['id_arr'];
if (count($ids_arr) > 0)
{
foreach ($ids_arr as $v)
{
$uid = (int)$v;
smart_mysql_query("UPDATE exchangerix_users SET status='inactive' WHERE user_id='$uid' LIMIT 1");
}
header("Location: users.php?".$params."msg=updated");
exit();
}
}
// Delete users //
if (isset($_POST['delete']) && $_POST['delete'] != "")
{
$ids_arr = array();
$ids_arr = $_POST['id_arr'];
if (count($ids_arr) > 0)
{
foreach ($ids_arr as $v)
{
$userid = (int)$v;
DeleteUser($userid);
}
header("Location: users.php?".$params."msg=deleted");
exit();
}
}
$where = " WHERE 1=1";
////////////////// filter //////////////////////
if (isset($_GET['column']) && $_GET['column'] != "")
{
switch ($_GET['column'])
{
case "fname": $rrorder = "fname"; break;
case "lname": $rrorder = "lname"; break;
case "email": $rrorder = "email"; break;
case "country": $rrorder = "country"; break;
case "verified_email": $rrorder = "verified_email"; break;
case "verified_phone": $rrorder = "verified_phone"; break;
case "verified_document": $rrorder = "verified_document"; break;
case "verified_address": $rrorder = "verified_address"; break;
case "reg_source": $rrorder = "reg_source"; break;
case "user_group": $rrorder = "user_group"; break;
case "ids": $rrorder = "user_id"; break;
case "status": $rrorder = "status"; break;
case "ref_id": $rrorder = "ref_id"; break;
default: $rrorder = "user_id"; break;
}
}
else
{
$rrorder = "user_id";
}
if (isset($_GET['order']) && $_GET['order'] != "")
{
switch ($_GET['order'])
{
case "asc": $rorder = "asc"; break;
case "desc": $rorder = "desc"; break;
default: $rorder = "asc"; break;
}
}
else
{
$rorder = "desc";
}
if (isset($_GET['filter']) && $_GET['filter'] != "")
{
$filter = mysqli_real_escape_string($conn, trim(getGetParameter('filter')));
$search_by = "username LIKE '%".$filter."%'";
switch ($_GET['search_type'])
{
case "username": $search_by = "username='".$filter."'"; break;
case "fullname": if (strstr($filter, " ")) { $nnn = explode(" ",$filter); $search_by = "fname LIKE '%".$nnn[0]."%' AND lname LIKE '%".$nnn[1]."%'"; }else{ $search_by = "fname LIKE '%".$filter."%' OR lname LIKE '%".$filter."%'";} break;
case "email": $search_by = "email='".$filter."'"; break;
//case "reg_source": $search_by = "reg_source='".$filter."'"; break;
case "ip": $search_by = "ip='".$filter."' OR last_ip='".$filter."'"; break;
}
$where .= " AND (".$search_by.")";
$totitle = " - Search Results";
}
///////////////////////////////////////////////////////
if (isset($_GET['page']) && is_numeric($_GET['page']) && $_GET['page'] > 0) { $page = (int)$_GET['page']; } else { $page = 1; }
$from = ($page-1)*$results_per_page;
if (isset($_GET['user_group']) && is_numeric($_GET['user_group']))
{
$user_group = (int)$_GET['user_group'];
$where .= " AND user_group='$user_group' ";
switch ($user_group)
{
case "1": $title2 = "Administrator"; break;
case "2": $title2 = "Moderator"; break;
case "3": $title2 = "Editor"; break;
}
}
if (isset($_GET['only_verifications']) && is_numeric($_GET['only_verifications']))
{
$only_verifications = (int)$_GET['only_verifications'];
$where .= " AND (length(verified_document) > 10 OR length(verified_document) > 10) ";
$title2 = "Waiting for document verification";
}
// hide other admins and moderators from non superadmin
if (!isSuperAdmin())
{
$where .= " AND user_group='0' ";
}
$query = "SELECT *, DATE_FORMAT(created, '".DATE_FORMAT."
%h:%i %p') AS signup_date FROM exchangerix_users $where ORDER BY $rrorder $rorder LIMIT $from, $results_per_page";
$result = smart_mysql_query($query);
$total_on_page = mysqli_num_rows($result);
$query2 = "SELECT * FROM exchangerix_users".$where;
$result2 = smart_mysql_query($query2);
$total = mysqli_num_rows($result2);
$cc = 0;
$title = "Users";
require_once ("inc/header.inc.php");
?>
Users 0) { ?>
0) { ?>
No user found for your search criteria.
There are no users at this time.