users.php

Go to the documentation of this file.

<?php
// $Id: users.php 902 2012-01-03 07:09:16Z i.bitcero $
// --------------------------------------------------------------
// EXM System
// Content Management System
// Author: BitC3R0 <bitc3r0@gmail.com>
// Email: bitc3r0@gmail.com
// License: GPL 2.0
// --------------------------------------------------------------

include '../../../mainfile.php';
include_once XOOPS_ROOT_PATH.'/modules/rmcommon/loader.php';

// Deactivate the logger
error_reporting(0);
$xoopsLogger->activated = false;

// Check Security settings
if (!$xoopsSecurity->check()){
        _e('Sorry, you are not allowed to view this page','rmcommon');
        die();
}

$token = $xoopsSecurity->createToken();

$tpl = new RMTemplate();
$db = XoopsDatabaseFactory::getDatabaseConnection();

$type = 0;
$s = '';
$kw = '';
$ord = 2;
$all = false;

foreach($_REQUEST as $k => $v){
        $$k = $v;
}

if (!isset($field) || $field==''){
        _e('Sorry, you are not allowed to view this page','rmcommon');
        die();
}

$field = addslashes($field);
$kw = addSlashes($kw);

if (is_string($s) && $s!=''){
        $selected = explode(',',$s);
} elseif (is_array($s)) {
        $selected = $s;
} else {
        $selected = array();
}

$selected_string = implode(',',$selected);

$sql = "SELECT COUNT(*) FROM ".$db->prefix("users")." WHERE level>0";
if ($kw!=''){
        $sql .= " AND (uname LIKE '%$kw%' OR name LIKE '%$kw%')";
}

list($num) = $db->fetchRow($db->query($sql));

$page = isset($pag) ? $pag : 1;
$limit = isset($limit) && $limit>0 ? $limit : 36;
        
$tpages = ceil($num / $limit);
$page = $page > $tpages ? $tpages : $page;
if($num % $limit > 0) $tpages++;

$start = $num<=0 ? 0 : ($page - 1) * $limit;

$nav = new RMPageNav($num, $limit, $page, 4);
$nav->target_url('javascript:usersField.goto_page({PAGE_NUM}, '.$type.');');

$sql = str_replace('COUNT(*)','uid, uname', $sql);
switch($ord){
        case '0':
                $sql .= " ORDER BY user_regdate";
                break;
        case '1':
                $sql .= " ORDER BY uname";
                break;
        default:
                $sql .= " ORDER BY uid";
                break;
}
$sql .= " LIMIT $start,$limit";
//$sql = "SELECT uid, uname FROM ".$db->prefix("users")." WHERE level>0 LIMIT $start,$limit";
$result = $db->query($sql);

$users = array();
if ($all){
        $users[] = array('id'=>0,'name'=>__('All','rmcommon'),'check'=>in_array(0, $selected));
}

while ($row = $db->fetchArray($result)){
        $users[] = array('id'=>$row['uid'],'name'=>$row['uname'],'check'=>in_array($row['uid'], $selected));
}

$selecteds = array();
if (is_array($selected) && count($selected)>0){
        $sql = "SELECT uid,uname FROM ".$db->prefix("users")." WHERE level>0 AND uid IN (".implode(',',$selected).")";
        $result = $db->query($sql);
        while ($row = $db->fetchArray($result)){
                $selecteds[] = array('id'=>$row['uid'],'name'=>$row['uname'],'check'=>true);
        }
        
}

$field_type = $type ? 'checkbox' : 'radio';

$nav->render(false);

include RMTemplate::get()->get_template("form_users.php", 'module','rmcommon');