Skip to content

Instantly share code, notes, and snippets.

@geekwright
Created Mar 19, 2021
Embed
What would you like to do?
Patch for XOOPS 2.5.4 part 2 - htdocs/modules/system/admin/users/main.php
<?php
// $Id: main.php 8066 2011-11-06 05:09:33Z beckmi $
// ------------------------------------------------------------------------ //
// XOOPS - PHP Content Management System //
// Copyright (c) 2000 XOOPS.org //
// <http://www.xoops.org/> //
// ------------------------------------------------------------------------ //
// This program is free software; you can redistribute it and/or modify //
// it under the terms of the GNU General Public License as published by //
// the Free Software Foundation; either version 2 of the License, or //
// (at your option) any later version. //
// //
// You may not change or alter any portion of this comment or credits //
// of supporting developers from this source code or any supporting //
// source code which is considered copyrighted (c) material of the //
// original comment or credit authors. //
// //
// This program is distributed in the hope that it will be useful, //
// but WITHOUT ANY WARRANTY; without even the implied warranty of //
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the //
// GNU General Public License for more details. //
// //
// You should have received a copy of the GNU General Public License //
// along with this program; if not, write to the Free Software //
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA //
// ------------------------------------------------------------------------ //
// Author: Kazumi Ono (AKA onokazu) //
// URL: http://www.myweb.ne.jp/, http://www.xoops.org/, http://jp.xoops.org/ //
// Project: The XOOPS Project //
// ------------------------------------------------------------------------- //
// Check users rights
if ( !is_object($xoopsUser) || !is_object($xoopsModule) || !$xoopsUser->isAdmin($xoopsModule->mid()) ) exit( _NOPERM );
include_once XOOPS_ROOT_PATH . "/modules/system/admin/users/users.php";
// Get Action type
$op = system_CleanVars ( $_REQUEST, 'op', 'default', 'string' );
$member_handler =& xoops_gethandler('member', 'system');
// Define main template
$xoopsOption['template_main'] = 'system_users.html';
// Call Header
xoops_cp_header();
$myts =& MyTextSanitizer::getInstance();
// Define Stylesheet
$xoTheme->addStylesheet( XOOPS_URL . '/modules/system/css/admin.css');
$xoTheme->addStylesheet( XOOPS_URL . '/modules/system/css/ui/' . xoops_getModuleOption('jquery_theme', 'system') . '/ui.all.css');
// Define scripts
$xoTheme->addScript('modules/system/js/admin.js');
// Define Breadcrumb and tips
$xoBreadCrumb->addLink( _AM_SYSTEM_USERS_NAV_MAIN, system_adminVersion('users', 'adminpath') );
$uid = system_CleanVars($_REQUEST, 'uid', 0);
switch ($op) {
// Edit user
case 'users_edit':
// Assign Breadcrumb menu
$xoBreadCrumb->addHelp( system_adminVersion('users', 'help') . '#edit' );
$xoBreadCrumb->addLink( _AM_SYSTEM_USERS_NAV_EDIT_USER );
$xoBreadCrumb->render();
form_user(false, $uid);
break;
// Add user
case 'users_add':
// Assign Breadcrumb menu
$xoBreadCrumb->addHelp( system_adminVersion('users', 'help') . '#add' );
$xoBreadCrumb->addLink( _AM_SYSTEM_USERS_NAV_ADD_USER );
$xoBreadCrumb->render();
form_user(true);
break;
// Delete user
case 'users_delete':
$xoBreadCrumb->render();
$user =& $member_handler->getUser($uid);
if (isset($_REQUEST['ok']) && $_REQUEST['ok'] == 1)
{
if (!$GLOBALS['xoopsSecurity']->check()) {
redirect_header("admin.php?fct=users", 3, implode('<br />', $GLOBALS['xoopsSecurity']->getErrors()));
}
$groups = $user->getGroups();
if (in_array(XOOPS_GROUP_ADMIN, $groups)) {
xoops_error( sprintf( _AM_SYSTEM_USERS_NO_ADMINSUPP, $user->getVar("uname")) );
} elseif (!$member_handler->deleteUser($user)) {
xoops_error( sprintf( _AM_SYSTEM_USERS_NO_SUPP, $user->getVar("uname")) );
} else {
$online_handler =& xoops_gethandler('online');
$online_handler->destroy($uid);
// RMV-NOTIFY
xoops_notification_deletebyuser($uid);
redirect_header("admin.php?fct=users",1,_AM_SYSTEM_DBUPDATED);
}
} else {
//Assign Breadcrumb menu
$xoBreadCrumb->addHelp( system_adminVersion('users', 'help') . '#delete' );
$xoBreadCrumb->addLink( _AM_SYSTEM_USERS_NAV_DELETE_USER );
$xoBreadCrumb->render();
xoops_confirm(array('ok' => 1, 'uid' => $uid, 'op' => 'users_delete'), $_SERVER['REQUEST_URI'], sprintf(_AM_SYSTEM_USERS_FORM_SURE_DEL, $user->getVar('uname')));
}
break;
// Delete users
case "action_group":
if ((@isset($_REQUEST['memberslist_id']) || @$_REQUEST['memberslist_id'] != ''))
{
$xoBreadCrumb->render();
$error = '';
foreach ($_REQUEST['memberslist_id'] as $del)
{
$del = intval($del);
$user =& $member_handler->getUser($del);
$groups = $user->getGroups();
if (in_array(XOOPS_GROUP_ADMIN, $groups)) {
$error .= sprintf( _AM_SYSTEM_USERS_NO_ADMINSUPP, $user->getVar("uname"));
} elseif (!$member_handler->deleteUser($user)) {
$error .= sprintf( _AM_SYSTEM_USERS_NO_SUPP, $user->getVar("uname"));
} else {
$online_handler =& xoops_gethandler('online');
$online_handler->destroy($del);
// RMV-NOTIFY
xoops_notification_deletebyuser($del);
}
}
if( $error != ''){
redirect_header("admin.php?fct=users", 3, sprintf( _AM_SYSTEM_USERS_ERROR,$error ) );
} else {
redirect_header("admin.php?fct=users", 1, _AM_SYSTEM_DBUPDATED);
}
}
break;
// Save user
case "users_save":
global $xoopsConfig, $xoopsModule, $xoopsUser;
if (isset($_REQUEST['uid']))
{
//Update user
if (!$GLOBALS['xoopsSecurity']->check()) {
redirect_header("admin.php?fct=users", 3, implode('<br />', $GLOBALS['xoopsSecurity']->getErrors()));
}
// RMV-NOTIFY
$user_avatar = $theme = null;
if ( !isset( $_REQUEST['attachsig'] ) ) $attachsig = null;
if ( !isset( $_REQUEST['user_viewemail'] ) ) $user_viewemail = null;
$edituser =& $member_handler->getUser($uid);
if ($edituser->getVar('uname', 'n') != $_REQUEST['username'] && $member_handler->getUserCount(new Criteria('uname', $myts->addSlashes($_REQUEST['username']))) > 0) {
xoops_cp_header();
xoops_error( sprintf( _AM_SYSTEM_USERS_PSEUDO_ERROR, htmlspecialchars($_REQUEST['username'])) );
xoops_cp_footer();
} elseif ( $edituser->getVar('email', 'n') != $_REQUEST['email'] && $member_handler->getUserCount( new Criteria( 'email', $myts->addSlashes($_REQUEST['email']) ) ) > 0 ) {
xoops_cp_header();
xoops_error( sprintf( _AM_SYSTEM_USERS_MAIL_ERROR, htmlspecialchars($_REQUEST['email'])) );
xoops_cp_footer();
} else {
$edituser->setVar("name", $_REQUEST['name']);
$edituser->setVar("uname", $_REQUEST['username']);
$edituser->setVar("email", $_REQUEST['email']);
$url = isset( $_REQUEST['url'] ) ? formatURL( $_REQUEST['url'] ) : '';
$edituser->setVar( "url", $url );
$edituser->setVar("user_icq", $_REQUEST['user_icq']);
$edituser->setVar("user_from", $_REQUEST['user_from']);
$edituser->setVar("user_sig", $_REQUEST['user_sig']);
$user_viewemail = (isset($_REQUEST['user_viewemail']) && $_REQUEST['user_viewemail'] == 1) ? 1 : 0;
$edituser->setVar("user_viewemail", $user_viewemail);
$edituser->setVar("user_aim", $_REQUEST['user_aim']);
$edituser->setVar("user_yim", $_REQUEST['user_yim']);
$edituser->setVar("user_msnm", $_REQUEST['user_msnm']);
$attachsig = ( isset( $_REQUEST['attachsig'] ) && $_REQUEST['attachsig'] == 1 ) ? 1 : 0;
$edituser->setVar("attachsig", $attachsig);
$edituser->setVar("timezone_offset", $_REQUEST['timezone_offset']);
$edituser->setVar("uorder", $_REQUEST['uorder']);
$edituser->setVar("umode", $_REQUEST['umode']);
// RMV-NOTIFY
$edituser->setVar("notify_method", $_REQUEST['notify_method']);
$edituser->setVar("notify_mode", $_REQUEST['notify_mode']);
$edituser->setVar("bio", $_REQUEST['bio']);
$edituser->setVar("rank", $_REQUEST['rank']);
$edituser->setVar("user_occ", $_REQUEST['user_occ']);
$edituser->setVar("user_intrest", $_REQUEST['user_intrest']);
$edituser->setVar('user_mailok', $_REQUEST['user_mailok']);
if ($_REQUEST['pass2'] != "") {
if ( $_REQUEST['password'] != $_REQUEST['pass2'] ) {
xoops_cp_header();
echo "
<strong>"._AM_SYSTEM_USERS_STNPDNM."</strong>";
xoops_cp_footer();
exit();
}
$edituser->setVar("pass", md5($_REQUEST['password']));
}
if (!$member_handler->insertUser($edituser)) {
xoops_cp_header();
echo $edituser->getHtmlErrors();
xoops_cp_footer();
} else {
if ($_REQUEST['groups'] != array()) {
global $xoopsUser;
$oldgroups = $edituser->getGroups();
//If the edited user is the current user and the current user WAS in the webmaster's group and is NOT in the new groups array
if ($edituser->getVar('uid') == $xoopsUser->getVar('uid') && (in_array(XOOPS_GROUP_ADMIN, $oldgroups)) && !(in_array(XOOPS_GROUP_ADMIN, $_REQUEST['groups']))) {
//Add the webmaster's group to the groups array to prevent accidentally removing oneself from the webmaster's group
array_push($_REQUEST['groups'], XOOPS_GROUP_ADMIN);
}
$member_handler =& xoops_gethandler('member');
foreach ($oldgroups as $groupid) {
$member_handler->removeUsersFromGroup($groupid, array($edituser->getVar('uid')));
}
foreach ($_REQUEST['groups'] as $groupid) {
$member_handler->addUserToGroup($groupid, $edituser->getVar('uid'));
}
}
redirect_header("admin.php?fct=users",1,_AM_SYSTEM_DBUPDATED);
}
}
exit();
} else {
//Add user
if (!$GLOBALS['xoopsSecurity']->check())
{
redirect_header("admin.php?fct=users", 3, implode('<br />', $GLOBALS['xoopsSecurity']->getErrors()));
}
if (!$_REQUEST['username'] || !$_REQUEST['email'] || !$_REQUEST['password'])
{
$adduser_errormsg = _AM_SYSTEM_USERS_YMCACF;
} else
{
$member_handler =& xoops_gethandler('member');
// make sure the username doesnt exist yet
if ($member_handler->getUserCount(new Criteria('uname', $myts->addSlashes($_REQUEST['username']))) > 0)
{
$adduser_errormsg = 'User name '. htmlspecialchars($_REQUEST['username']) .' already exists';
} else
{
$newuser =& $member_handler->createUser();
if ( isset($user_viewemail) )
{
$newuser->setVar("user_viewemail",$_REQUEST['user_viewemail']);
}
if ( isset($attachsig) )
{
$newuser->setVar("attachsig",$_REQUEST['attachsig']);
}
$newuser->setVar("name", $_REQUEST['name']);
$newuser->setVar("uname", $_REQUEST['username']);
$newuser->setVar("email", $_REQUEST['email']);
$newuser->setVar("url", formatURL($_REQUEST['url']));
$newuser->setVar("user_avatar",'blank.gif');
$newuser->setVar('user_regdate', time());
$newuser->setVar("user_icq", $_REQUEST['user_icq']);
$newuser->setVar("user_from", $_REQUEST['user_from']);
$newuser->setVar("user_sig", $_REQUEST['user_sig']);
$newuser->setVar("user_aim", $_REQUEST['user_aim']);
$newuser->setVar("user_yim", $_REQUEST['user_yim']);
$newuser->setVar("user_msnm", $_REQUEST['user_msnm']);
if ($_REQUEST['pass2'] != "")
{
if ( $_REQUEST['password'] != $_REQUEST['pass2'] )
{
xoops_cp_header();
echo "<strong>" . _AM_SYSTEM_USERS_STNPDNM . "</strong>";
xoops_cp_footer();
exit();
}
$newuser->setVar("pass", md5($_REQUEST['password']));
}
$newuser->setVar("timezone_offset", $_REQUEST['timezone_offset']);
$newuser->setVar("uorder", $_REQUEST['uorder']);
$newuser->setVar("umode", $_REQUEST['umode']);
// RMV-NOTIFY
$newuser->setVar("notify_method", $_REQUEST['notify_method']);
$newuser->setVar("notify_mode", $_REQUEST['notify_mode']);
$newuser->setVar("bio", $_REQUEST['bio']);
$newuser->setVar("rank", $_REQUEST['rank']);
$newuser->setVar("level", 1);
$newuser->setVar("user_occ", $_REQUEST['user_occ']);
$newuser->setVar("user_intrest", $_REQUEST['user_intrest']);
$newuser->setVar('user_mailok', $_REQUEST['user_mailok']);
if (!$member_handler->insertUser($newuser))
{
$adduser_errormsg = _AM_SYSTEM_USERS_CNRNU;
} else
{
$groups_failed = array();
foreach ($_REQUEST['groups'] as $group)
{
$group = intval($group);
if (!$member_handler->addUserToGroup($group, $newuser->getVar('uid')))
{
$groups_failed[] = $group;
}
}
if (!empty($groups_failed))
{
$group_names = $member_handler->getGroupList(new Criteria('groupid', "(".implode(", ", $groups_failed).")", 'IN'));
$adduser_errormsg = sprintf(_AM_SYSTEM_USERS_CNRNU2, implode(", ", $group_names));
} else
{
xoops_load("XoopsUserUtility");
XoopsUserUtility::sendWelcome($newuser);
redirect_header("admin.php?fct=users", 1, _AM_SYSTEM_DBUPDATED);
exit();
}
}
}
}
xoops_error($adduser_errormsg);
}
break;
// Activ member
case 'users_active':
if (isset($_REQUEST["uid"])) {
$obj =& $member_handler->getUser($uid);
//echo $_REQUEST["uid"];
//print_r($obj);
}
$obj->setVar("level", 1);
if ($member_handler->insertUser($obj, true)) {
redirect_header("admin.php?fct=users", 1, _AM_SYSTEM_DBUPDATED);
}
echo $obj->getHtmlErrors();
break;
// Synchronize
case 'users_synchronize':
if (isset($_REQUEST['status']) && $_REQUEST['status'] == 1) {
synchronize($$uid, 'user');
} else if (isset($_REQUEST['status']) && $_REQUEST['status'] == 2) {
synchronize( '', 'all users');
}
redirect_header("admin.php?fct=users", 1, _AM_SYSTEM_DBUPDATED);
break;
default:
// Search and Display
// Define scripts
$xoTheme->addScript('browse.php?Frameworks/jquery/jquery.js');
$xoTheme->addScript('browse.php?Frameworks/jquery/plugins/jquery.ui.js');
//table sorting does not work with select boxes
//$xoTheme->addScript('browse.php?Frameworks/jquery/plugins/jquery.tablesorter.js');
$xoTheme->addScript('modules/system/js/admin.js');
//Recherche approfondie
if (isset($_REQUEST['complet_search']))
{
// Assign Breadcrumb menu
$xoBreadCrumb->addLink( _AM_SYSTEM_USERS_NAV_ADVANCED_SEARCH );
$xoBreadCrumb->addHelp( system_adminVersion('users', 'help') );
$xoBreadCrumb->addTips( _AM_SYSTEM_USERS_NAV_TIPS );
$xoBreadCrumb->render();
$acttotal = $member_handler->getUserCount(new Criteria('level', 0, '>'));
$inacttotal = $member_handler->getUserCount(new Criteria('level', 0));
//$group_select = new XoopsFormSelectGroup(_AM_SYSTEM_USERS_GROUPS, "selgroups", null, false, 1, false);
$group_select = new XoopsFormSelect(_AM_SYSTEM_USERS_GROUPS, "selgroups");
$group_handler =& xoops_gethandler('group');
$group_arr = $group_handler->getObjects();
$group_select->addOption("", "--------------");
foreach (array_keys($group_arr) as $i)
{
if($group_arr[$i]->getVar("groupid") != 3)
$group_select->addOption("".$group_arr[$i]->getVar("groupid")."", "".$group_arr[$i]->getVar("name")."");
}
$uname_text = new XoopsFormText("", "user_uname", 30, 60);
$uname_match = new XoopsFormSelectMatchOption("", "user_uname_match");
$uname_tray = new XoopsFormElementTray(_AM_SYSTEM_USERS_UNAME, "&nbsp;");
$uname_tray->addElement($uname_match);
$uname_tray->addElement($uname_text);
$name_text = new XoopsFormText("", "user_name", 30, 60);
$name_match = new XoopsFormSelectMatchOption("", "user_name_match");
$name_tray = new XoopsFormElementTray(_AM_SYSTEM_USERS_REALNAME, "&nbsp;");
$name_tray->addElement($name_match);
$name_tray->addElement($name_text);
$email_text = new XoopsFormText("", "user_email", 30, 60);
$email_match = new XoopsFormSelectMatchOption("", "user_email_match");
$email_tray = new XoopsFormElementTray(_AM_SYSTEM_USERS_EMAIL, "&nbsp;");
$email_tray->addElement($email_match);
$email_tray->addElement($email_text);
$url_text = new XoopsFormText(_AM_SYSTEM_USERS_URLC, "user_url", 30, 100);
$icq_text = new XoopsFormText("", "user_icq", 30, 100);
$icq_match = new XoopsFormSelectMatchOption("", "user_icq_match");
$icq_tray = new XoopsFormElementTray(_AM_SYSTEM_USERS_ICQ, "&nbsp;");
$icq_tray->addElement($icq_match);
$icq_tray->addElement($icq_text);
$aim_text = new XoopsFormText("", "user_aim", 30, 100);
$aim_match = new XoopsFormSelectMatchOption("", "user_aim_match");
$aim_tray = new XoopsFormElementTray(_AM_SYSTEM_USERS_AIM, "&nbsp;");
$aim_tray->addElement($aim_match);
$aim_tray->addElement($aim_text);
$yim_text = new XoopsFormText("", "user_yim", 30, 100);
$yim_match = new XoopsFormSelectMatchOption("", "user_yim_match");
$yim_tray = new XoopsFormElementTray(_AM_SYSTEM_USERS_YIM, "&nbsp;");
$yim_tray->addElement($yim_match);
$yim_tray->addElement($yim_text);
$msnm_text = new XoopsFormText("", "user_msnm", 30, 100);
$msnm_match = new XoopsFormSelectMatchOption("", "user_msnm_match");
$msnm_tray = new XoopsFormElementTray(_AM_SYSTEM_USERS_MSNM, "&nbsp;");
$msnm_tray->addElement($msnm_match);
$msnm_tray->addElement($msnm_text);
$location_text = new XoopsFormText(_AM_SYSTEM_USERS_LOCATIONC, "user_from", 30, 100);
$occupation_text = new XoopsFormText(_AM_SYSTEM_USERS_OCCUPATIONC, "user_occ", 30, 100);
$interest_text = new XoopsFormText(_AM_SYSTEM_USERS_INTERESTC, "user_intrest", 30, 100);
$lastlog_more = new XoopsFormText(_AM_SYSTEM_USERS_LASTLOGMORE, "user_lastlog_more", 10, 5);
$lastlog_less = new XoopsFormText(_AM_SYSTEM_USERS_LASTLOGLESS, "user_lastlog_less", 10, 5);
$reg_more = new XoopsFormText(_AM_SYSTEM_USERS_REGMORE, "user_reg_more", 10, 5);
$reg_less = new XoopsFormText(_AM_SYSTEM_USERS_REGLESS, "user_reg_less", 10, 5);
$posts_more = new XoopsFormText(_AM_SYSTEM_USERS_POSTSMORE, "user_posts_more", 10, 5);
$posts_less = new XoopsFormText(_AM_SYSTEM_USERS_POSTSLESS, "user_posts_less", 10, 5);
$mailok_radio = new XoopsFormRadio(_AM_SYSTEM_USERS_SHOWMAILOK, "user_mailok", "both");
$mailok_radio->addOptionArray(array("mailok"=>_AM_SYSTEM_USERS_MAILOK, "mailng"=>_AM_SYSTEM_USERS_MAILNG, "both"=>_AM_SYSTEM_USERS_BOTH));
$type_radio = new XoopsFormRadio(_AM_SYSTEM_USERS_SHOWTYPE, "user_type", "actv");
$type_radio->addOptionArray(array("actv"=>_AM_SYSTEM_USERS_ACTIVE, "inactv"=>_AM_SYSTEM_USERS_INACTIVE, "both"=>_AM_SYSTEM_USERS_BOTH));
$sort_select = new XoopsFormSelect(_AM_SYSTEM_USERS_SORT, "user_sort");
$sort_select->addOptionArray(array("uname"=>_AM_SYSTEM_USERS_UNAME,"email"=>_AM_SYSTEM_USERS_EMAIL,"last_login"=>_AM_SYSTEM_USERS_LASTLOGIN,"user_regdate"=>_AM_SYSTEM_USERS_REGDATE,"posts"=>_AM_SYSTEM_USERS_POSTS));
$order_select = new XoopsFormSelect(_AM_SYSTEM_USERS_ORDER, "user_order");
$order_select->addOptionArray(array("ASC"=>_AM_SYSTEM_USERS_ASC,"DESC"=>_AM_SYSTEM_USERS_DESC));
$limit_text = new XoopsFormText(_AM_SYSTEM_USERS_LIMIT, "user_limit", 6, 2, 20);
$submit_button = new XoopsFormButton("", "user_submit", _SUBMIT, "submit");
$form = new XoopsThemeForm(_AM_SYSTEM_USERS_FINDUS, "uesr_findform", "admin.php?fct=users", 'post', true);
$form->addElement($uname_tray);
$form->addElement($name_tray);
$form->addElement($email_tray);
$form->addElement($group_select);
$form->addElement($icq_tray);
$form->addElement($aim_tray);
$form->addElement($yim_tray);
$form->addElement($msnm_tray);
$form->addElement($url_text);
$form->addElement($location_text);
$form->addElement($occupation_text);
$form->addElement($interest_text);
$form->addElement($lastlog_more);
$form->addElement($lastlog_less);
$form->addElement($reg_more);
$form->addElement($reg_less);
$form->addElement($posts_more);
$form->addElement($posts_less);
$form->addElement($mailok_radio);
$form->addElement($type_radio);
$form->addElement($sort_select);
$form->addElement($order_select);
$form->addElement($fct_hidden);
$form->addElement($limit_text);
$form->addElement($op_hidden);
// if this is to find users for a specific group
if ( !empty($_GET['group']) && intval($_GET['group']) > 0 )
{
$group_hidden = new XoopsFormHidden("group", intval($_GET['group']));
$form->addElement($group_hidden);
}
$form->addElement($submit_button);
$form->display();
} else {
//Display data
// Assign Breadcrumb menu
$xoBreadCrumb->addHelp( system_adminVersion('users', 'help') );
$xoBreadCrumb->addTips( _AM_SYSTEM_USERS_NAV_TIPS );
$xoBreadCrumb->render();
$requete_search = '<br /><br /><strong>See search request: </strong><br /><br />';
$requete_pagenav = '';
$criteria = new CriteriaCompo();
if ( !empty($_REQUEST['user_uname']) ) {
$match = (!empty($_REQUEST['user_uname_match'])) ? intval($_REQUEST['user_uname_match']) : XOOPS_MATCH_START;
switch ($match) {
case XOOPS_MATCH_CONTAIN:
$criteria->add(new Criteria('uname', $myts->addSlashes(trim($_REQUEST['user_uname'])).'%', 'LIKE'));
break;
case XOOPS_MATCH_END:
$criteria->add(new Criteria('uname', '%'.$myts->addSlashes(trim($_REQUEST['user_uname'])), 'LIKE'));
break;
case XOOPS_MATCH_EQUAL:
$criteria->add(new Criteria('uname', $myts->addSlashes(trim($_REQUEST['user_uname']))));
break;
case XOOPS_MATCH_START:
$criteria->add(new Criteria('uname', '%'.$myts->addSlashes(trim($_REQUEST['user_uname'])).'%', 'LIKE'));
break;
}
$requete_pagenav .= '&amp;user_uname='. htmlspecialchars($_REQUEST["user_uname"]) .'&amp;user_uname_match='. htmlspecialchars($_REQUEST['user_uname_match']);
$requete_search .= 'uname : '.$_REQUEST['user_uname'].' et user_uname_match='.$_REQUEST['user_uname_match'].'<br />';
}
if ( !empty($_REQUEST['user_name']) ) {
$match = (!empty($_REQUEST['user_name_match'])) ? intval($_REQUEST['user_name_match']) : XOOPS_MATCH_START;
switch ($match) {
case XOOPS_MATCH_START:
$criteria->add(new Criteria('name', $myts->addSlashes(trim($_REQUEST['user_name'])).'%', 'LIKE'));
break;
case XOOPS_MATCH_END:
$criteria->add(new Criteria('name', '%'.$myts->addSlashes(trim($_REQUEST['user_name'])), 'LIKE'));
break;
case XOOPS_MATCH_EQUAL:
$criteria->add(new Criteria('name', $myts->addSlashes(trim($_REQUEST['user_name']))));
break;
case XOOPS_MATCH_CONTAIN:
$criteria->add(new Criteria('name', '%'.$myts->addSlashes(trim($_POST['user_name'])).'%', 'LIKE'));
break;
}
$requete_pagenav .= '&amp;user_name='. htmlspecialchars($_REQUEST["user_name"]) .'&amp;user_name_match='. htmlspecialchars($_REQUEST['user_name_match']);
$requete_search .= 'name : '.$_REQUEST['user_name'].' et user_name_match='.$_REQUEST['user_name_match'].'<br />';
}
if ( !empty($_REQUEST['user_email']) ) {
$match = (!empty($_REQUEST['user_email_match'])) ? intval($_REQUEST['user_email_match']) : XOOPS_MATCH_START;
switch ($match) {
case XOOPS_MATCH_START:
$criteria->add(new Criteria('email', $myts->addSlashes(trim($_REQUEST['user_email'])).'%', 'LIKE'));
break;
case XOOPS_MATCH_END:
$criteria->add(new Criteria('email', '%'.$myts->addSlashes(trim($_REQUEST['user_email'])), 'LIKE'));
break;
case XOOPS_MATCH_EQUAL:
$criteria->add(new Criteria('email', $myts->addSlashes(trim($_REQUEST['user_email']))));
break;
case XOOPS_MATCH_CONTAIN:
$criteria->add(new Criteria('email', '%'.$myts->addSlashes(trim($_REQUEST['user_email'])).'%', 'LIKE'));
break;
}
$requete_pagenav .= '&amp;email='. htmlspecialchars($_REQUEST["user_email"]) .'&amp;user_email_match='. htmlspecialchars($_REQUEST['user_email_match']);
$requete_search .= 'email : '.$_REQUEST['user_email'].' et user_email_match='.$_REQUEST['user_email_match'].'<br />';
}
if ( !empty($_REQUEST['user_url']) ) {
$url = formatURL(trim($_REQUEST['user_url']));
$criteria->add(new Criteria('url', $url.'%', 'LIKE'));
$requete_search .= 'url : '.$_REQUEST['user_url'].'<br />';
}
if ( !empty($_REQUEST['user_icq']) ) {
$match = (!empty($_REQUEST['user_icq_match'])) ? intval($_REQUEST['user_icq_match']) : XOOPS_MATCH_START;
switch ($match) {
case XOOPS_MATCH_START:
$criteria->add(new Criteria('user_icq', $myts->addSlashes(trim($_REQUEST['user_icq'])).'%', 'LIKE'));
break;
case XOOPS_MATCH_END:
$criteria->add(new Criteria('user_icq', '%'.$myts->addSlashes(trim($_REQUEST['user_icq'])), 'LIKE'));
break;
case XOOPS_MATCH_EQUAL:
$criteria->add(new Criteria('user_icq', '%'.$myts->addSlashes(trim($_REQUEST['user_icq']))));
break;
case XOOPS_MATCH_CONTAIN:
$criteria->add(new Criteria('user_icq', '%'.$myts->addSlashes(trim($_REQUEST['user_icq'])).'%', 'LIKE'));
break;
}
$requete_pagenav .= '&amp;user_icq='. htmlspecialchars($_REQUEST["user_icq"]) .'&amp;user_icq_match='. htmlspecialchars($_REQUEST['user_icq_match']);
$requete_search .= 'icq : '.$_REQUEST['user_icq'].' et user_icq_match='.$_REQUEST['user_icq_match'].'<br />';
}
if ( !empty($_REQUEST['user_aim']) ) {
$match = (!empty($_REQUEST['user_aim_match'])) ? intval($_REQUEST['user_aim_match']) : XOOPS_MATCH_START;
switch ($match) {
case XOOPS_MATCH_START:
$criteria->add(new Criteria('user_aim', $myts->addSlashes(trim($_REQUEST['user_aim'])).'%', 'LIKE'));
break;
case XOOPS_MATCH_END:
$criteria->add(new Criteria('user_aim', '%'.$myts->addSlashes(trim($_REQUEST['user_aim'])), 'LIKE'));
break;
case XOOPS_MATCH_EQUAL:
$criteria->add(new Criteria('user_aim', $myts->addSlashes(trim($_REQUEST['user_aim']))));
break;
case XOOPS_MATCH_CONTAIN:
$criteria->add(new Criteria('user_aim', '%'.$myts->addSlashes(trim($_REQUEST['user_aim'])).'%', 'LIKE'));
break;
}
$requete_pagenav .= '&amp;user_aim='. htmlspecialchars($_REQUEST["user_aim"]) .'&amp;user_aim_match='. htmlspecialchars($_REQUEST['user_aim_match']);
$requete_search .= 'aim : '.$_REQUEST['user_aim'].' et user_aim_match='.$_REQUEST['user_aim_match'].'<br />';
}
if ( !empty($_REQUEST['user_yim']) ) {
$match = (!empty($_REQUEST['user_yim_match'])) ? intval($_REQUEST['user_yim_match']) : XOOPS_MATCH_START;
switch ($match) {
case XOOPS_MATCH_START:
$criteria->add(new Criteria('user_yim', $myts->addSlashes(trim($_REQUEST['user_yim'])).'%', 'LIKE'));
break;
case XOOPS_MATCH_END:
$criteria->add(new Criteria('user_yim', '%'.$myts->addSlashes(trim($_REQUEST['user_yim'])), 'LIKE'));
break;
case XOOPS_MATCH_EQUAL:
$criteria->add(new Criteria('user_yim', $myts->addSlashes(trim($_REQUEST['user_yim']))));
break;
case XOOPS_MATCH_CONTAIN:
$criteria->add(new Criteria('user_yim', '%'.$myts->addSlashes(trim($_REQUEST['user_yim'])).'%', 'LIKE'));
break;
}
$requete_pagenav .= '&amp;user_yim='. htmlspecialchars($_REQUEST["user_yim"]) .'&amp;user_yim_match='. htmlspecialchars($_REQUEST['user_yim_match']);
$requete_search .= 'yim : '.$_REQUEST['user_yim'].' et user_yim_match='.$_REQUEST['user_yim_match'].'<br />';
}
if ( !empty($_REQUEST['user_msnm']) ) {
$match = (!empty($_REQUEST['user_msnm_match'])) ? intval($_REQUEST['user_msnm_match']) : XOOPS_MATCH_START;
switch ($match) {
case XOOPS_MATCH_START:
$criteria->add(new Criteria('user_msnm', $myts->addSlashes(trim($_REQUEST['user_msnm'])).'%', 'LIKE'));
break;
case XOOPS_MATCH_END:
$criteria->add(new Criteria('user_msnm', '%'.$myts->addSlashes(trim($_REQUEST['user_msnm'])), 'LIKE'));
break;
case XOOPS_MATCH_EQUAL:
$criteria->add(new Criteria('user_msnm', '%'.$myts->addSlashes(trim($_REQUEST['user_msnm']))));
break;
case XOOPS_MATCH_CONTAIN:
$criteria->add(new Criteria('user_msnm', '%'.$myts->addSlashes(trim($_REQUEST['user_msnm'])).'%', 'LIKE'));
break;
}
$requete_pagenav .= '&amp;user_msnm='. htmlspecialchars($_REQUEST["user_msnm"]) .'&amp;user_msnm_match='. htmlspecialchars($_REQUEST['user_msnm_match']);
$requete_search .= 'msn : '.$_REQUEST['user_msnm'].' et user_msnm_match='.$_REQUEST['user_msnm_match'].'<br />';
}
if ( !empty($_REQUEST['user_from']) ) {
$criteria->add(new Criteria('user_from', '%'.$myts->addSlashes(trim($_REQUEST['user_from'])).'%', 'LIKE'));
$requete_pagenav .= '&amp;user_from='. htmlspecialchars($_REQUEST["user_from"]);
$requete_search .= 'from : '.$_REQUEST['user_from'].'<br />';
}
if ( !empty($_REQUEST['user_intrest']) ) {
$criteria->add(new Criteria('user_intrest', '%'.$myts->addSlashes(trim($_REQUEST['user_intrest'])).'%', 'LIKE'));
$requete_pagenav .= '&amp;user_intrest='. htmlspecialchars($_REQUEST["user_intrest"]);
$requete_search .= 'interet : '.$_REQUEST['user_intrest'].'<br />';
}
if ( !empty($_REQUEST['user_occ']) ) {
$criteria->add(new Criteria('user_occ', '%'.$myts->addSlashes(trim($_REQUEST['user_occ'])).'%', 'LIKE'));
$requete_pagenav .= '&amp;user_occ='. htmlspecialchars($_REQUEST["user_occ"]);
$requete_search .= 'location : '.$_REQUEST['user_occ'].'<br />';
}
if ( !empty($_REQUEST['user_lastlog_more']) && is_numeric($_REQUEST['user_lastlog_more']) ) {
$f_user_lastlog_more = intval(trim($_REQUEST['user_lastlog_more']));
$time = time() - (60 * 60 * 24 * $f_user_lastlog_more);
if ( $time > 0 ) {
$criteria->add(new Criteria('last_login', $time, '<'));
}
$requete_pagenav .= '&amp;user_lastlog_more='. htmlspecialchars($_REQUEST["user_lastlog_more"]);
$requete_search .= 'derniere connexion apres : '.$_REQUEST['user_lastlog_more'].'<br />';
}
if ( !empty($_REQUEST['user_lastlog_less']) && is_numeric($_REQUEST['user_lastlog_less']) ) {
$f_user_lastlog_less = intval(trim($_REQUEST['user_lastlog_less']));
$time = time() - (60 * 60 * 24 * $f_user_lastlog_less);
if ( $time > 0 ) {
$criteria->add(new Criteria('last_login', $time, '>'));
}
$requete_pagenav .= '&amp;user_lastlog_less='. htmlspecialchars($_REQUEST["user_lastlog_less"]);
$requete_search .= 'derniere connexion avant : '.$_REQUEST['user_lastlog_less'].'<br />';
}
if ( !empty($_REQUEST['user_reg_more']) && is_numeric($_REQUEST['user_reg_more']) ) {
$f_user_reg_more = intval(trim($_REQUEST['user_reg_more']));
$time = time() - (60 * 60 * 24 * $f_user_reg_more);
if ( $time > 0 ) {
$criteria->add(new Criteria('user_regdate', $time, '<'));
}
$requete_pagenav .= '&amp;user_regdate='. htmlspecialchars($_REQUEST["user_regdate"]);
$requete_search .= 'enregistre apres : '.$_REQUEST['user_reg_more'].'<br />';
}
if ( !empty($_REQUEST['user_reg_less']) && is_numeric($_REQUEST['user_reg_less']) ) {
$f_user_reg_less = intval($_REQUEST['user_reg_less']);
$time = time() - (60 * 60 * 24 * $f_user_reg_less);
if ( $time > 0 ) {
$criteria->add(new Criteria('user_regdate', $time, '>'));
}
$requete_pagenav .= '&amp;user_reg_less='. htmlspecialchars($_REQUEST["user_reg_less"]);
$requete_search .= 'enregistre avant : '.$_REQUEST['user_reg_less'].'<br />';
}
if ( !empty($_REQUEST['user_posts_more']) && is_numeric($_REQUEST['user_posts_more']) ) {
$criteria->add(new Criteria('posts', intval($_REQUEST['user_posts_more']), '>'));
$requete_pagenav .= '&amp;user_posts_more='. htmlspecialchars($_REQUEST["user_posts_more"]);
$requete_search .= 'posts plus de : '.$_REQUEST['user_posts_more'].'<br />';
}
if ( !empty($_REQUEST['user_posts_less']) && is_numeric($_REQUEST['user_posts_less']) ) {
$criteria->add(new Criteria('posts', intval($_REQUEST['user_posts_less']), '<'));
$requete_pagenav .= '&amp;user_posts_less='. htmlspecialchars($_REQUEST["user_posts_less"]);
$requete_search .= 'post moins de : '.$_REQUEST['user_posts_less'].'<br />';
}
if ( isset($_REQUEST['user_mailok']) ) {
if ( $_REQUEST['user_mailok'] == "mailng" ) {
$criteria->add(new Criteria('user_mailok', 0));
} elseif ( $_REQUEST['user_mailok'] == "mailok" ) {
$criteria->add(new Criteria('user_mailok', 1));
} else {
$criteria->add(new Criteria('user_mailok', 0, '>='));
}
$requete_pagenav .= '&amp;user_mailok='. htmlspecialchars($_REQUEST["user_mailok"]);
$requete_search .= 'accept email : '.$_REQUEST['user_mailok'].'<br />';
}
if ( isset($_REQUEST['user_type']) && !empty($_REQUEST['user_type']) ) {
if ( $_REQUEST['user_type'] == 'inactv' ) {
$criteria->add(new Criteria('level', 0, '='));
$user_type = 'inactv';
$requete_search .= 'actif ou inactif : inactif<br />';
} elseif ( $_REQUEST['user_type'] == "actv" ) {
$criteria->add(new Criteria('level', 0, '>'));
$user_type = 'actv';
$requete_search .= 'actif ou inactif : actif<br />';
}
$requete_pagenav .= '&amp;user_type='. htmlspecialchars($_REQUEST["user_type"]);
} else {
$criteria->add(new Criteria('level', 0, '>='));
$user_type = '';
$requete_search .= 'actif ou inactif : admin et user<br />';
}
//$groups = empty($_REQUEST['selgroups']) ? array() : array_map("intval", $_REQUEST['selgroups']);
$validsort = array("uname", "email", "last_login", "user_regdate", "posts");
if ( isset($_REQUEST['user_sort']) ) {
$sort = (!in_array($_REQUEST['user_sort'], $validsort)) ? "uid" : $_REQUEST['user_sort'];
$requete_pagenav .= '&amp;user_sort='. htmlspecialchars($_REQUEST["user_sort"]);
$requete_search .= 'order by : '.$sort.'<br />';
} else {
$sort = "uid";
$requete_pagenav .= '&amp;user_sort=uid';
$requete_search .= 'order by : '.$sort.'<br />';
}
$order = "DESC";
if ( isset($_REQUEST['user_order']) && $_REQUEST['user_order'] == "ASC") {
$requete_pagenav .= '&amp;user_order=ASC';
$requete_search .= 'tris : '.$order.'<br />';
} else {
//$order = "ASC";
$requete_pagenav .= '&amp;user_order=DESC';
$requete_search .= 'tris : '.$order.'<br />';
}
$user_limit = xoops_getModuleOption('users_pager', 'system');
if (isset($_REQUEST['user_limit'])) {
$user_limit = $_REQUEST['user_limit'];
$requete_pagenav .= '&amp;user_limit='. htmlspecialchars($_REQUEST['user_limit']);
$requete_search .= 'limit : '.$user_limit.'<br />';
} else {
$requete_pagenav .= '&amp;user_limit=' . xoops_getModuleOption('users_pager', 'system');
$requete_search .= 'limit : '.$user_limit.'<br />';
}
$start = (!empty($_REQUEST['start'])) ? intval($_REQUEST['start']) : 0;
if ( isset($_REQUEST['selgroups']) ) {
if($_REQUEST['selgroups'] != 0) {
if ( count($_REQUEST['selgroups']) == 1 ) {
$groups = array( 0 => $_REQUEST['selgroups']);
} else {
$groups = array_map("intval", $_REQUEST['selgroups']);
}
} else {
$groups = array();
}
$requete_pagenav .= '&amp;selgroups='. htmlspecialchars($_REQUEST['selgroups']);
} else {
$groups = array();
}
//print_r($groups);
$member_handler =& xoops_gethandler('member');
$users_count = $member_handler->getUserCountByGroupLink($groups, $criteria);
if ( $start < $users_count ) {
echo sprintf(_AM_SYSTEM_USERS_USERSFOUND, $users_count)."<br />";
$criteria->setSort($sort);
$criteria->setOrder($order);
$criteria->setLimit($user_limit);
$criteria->setStart($start);
$users_arr = $member_handler->getUsersByGroupLink($groups, $criteria, true);
$ucount = 0;
}
$xoopsTpl->assign( 'users_count', $users_count );
$xoopsTpl->assign( 'users_display', true );
$xoopsTpl->assign( 'php_selft', $_SERVER['PHP_SELF'] );
//User limit
//$user_limit = (!isset($_REQUEST['user_limit'])) ? 20 : $_REQUEST['user_limit'];
//User type
//$user_type = (!isset($_REQUEST['user_type'])) ? '' : $_REQUEST['user_type'];
//selgroups
$selgroups = (!isset($_REQUEST['selgroups'])) ? '' : $_REQUEST['selgroups'];
$user_uname = (!isset($_REQUEST['user_uname'])) ? '' : $_REQUEST['user_uname'];
//Form tris
$form = '<form action="admin.php?fct=users" method="post">
'._AM_SYSTEM_USERS_SEARCH_USER.'<input type="text" name="user_uname" value="'.$myts->htmlSpecialChars($user_uname).'" size="15">
<select name="selgroups">
<option value="" selected="selected">'._AM_SYSTEM_USERS_ALLGROUP.'</option>';
$group_handler =& xoops_gethandler('group');
$group_arr = $group_handler->getObjects();
foreach (array_keys($group_arr) as $i)
{
if($group_arr[$i]->getVar("groupid") != 3)
$form .= '<option value="'.$group_arr[$i]->getVar("groupid").'" '.($selgroups == $group_arr[$i]->getVar("groupid") ? ' selected="selected"' : '').'>'.$group_arr[$i]->getVar("name").'</option>';
}
$form .= '</select>&nbsp;
<select name="user_type">
<option value="" '.($user_type == '' ? ' selected="selected"' : '').'>'._AM_SYSTEM_USERS_ALLUSER.'</option>
<option value="actv" '.($user_type == 'actv' ? ' selected="selected"' : '').'>'._AM_SYSTEM_USERS_ACTIVEUSER.'</option>
<option value="inactv" '.($user_type == 'inactv' ? ' selected="selected"' : '').'>'._AM_SYSTEM_USERS_INACTIVEUSER.'</option>
</select>&nbsp;
<select name="user_limit">
<option value="20" '.($user_limit == 20 ? ' selected="selected"' : '').'>20</option>
<option value="50" '.($user_limit == 50 ? ' selected="selected"' : '').'>50</option>
<option value="100" '.($user_limit == 100 ? ' selected="selected"' : '').'>100</option>
</select>&nbsp;
<input type="hidden" name="user_uname_match" value="XOOPS_MATCH_START" />
<input type="submit" value="'._AM_SYSTEM_USERS_SEARCH.'" name="speed_search">&nbsp;
<input type="submit" value="'._AM_SYSTEM_USERS_ADVANCED_SEARCH.'" name="complet_search"></form>
';
//select groupe
$form_select_groups = '<select name="selgroups" id="selgroups" style="display:none;"><option value="">---------</option>';
//$module_array[0] = _AM_SYSTEM_USERS_COMMENTS_FORM_ALL_MODS;
$group_handler =& xoops_gethandler('group');
$group_arr = $group_handler->getObjects();
foreach (array_keys($group_arr) as $i)
{
if($group_arr[$i]->getVar("groupid") != 3)
$form_select_groups .= '<option value="'.$group_arr[$i]->getVar("groupid").'" '.($selgroups == $group_arr[$i]->getVar("groupid") ? ' selected="selected"' : '').'>'.$group_arr[$i]->getVar("name").'</option>';
}
$form_select_groups .= '</select><input type="hidden" name="op" value="users_add_delete_group">';
$xoopsTpl->assign('form_sort', $form);
$xoopsTpl->assign('form_select_groups', $form_select_groups);
//echo $requete_search;
if ( $users_count > 0 )
{
//echo $requete_search;
foreach (array_keys($users_arr) as $i)
{
$users['uid'] = $users_arr[$i]->getVar("uid");
//Display group
$user_group = $member_handler->getGroupsByUser($users_arr[$i]->getVar("uid"));
if(in_array ("1", $user_group)) {
$users['group'] = system_AdminIcons('xoops/group_1.png');
//$users['icon'] = '<img src="'.XOOPS_URL.'/modules/system/images/icons/admin.png" alt="'._AM_SYSTEM_USERS_ADMIN.'" title="'._AM_SYSTEM_USERS_ADMIN.'" />';
$users['checkbox_user'] = false;
} else {
$users['group'] = system_AdminIcons('xoops/group_2.png');
//$users['icon'] = '<img src="'.XOOPS_URL.'/modules/system/images/icons/user.png" alt="'._AM_SYSTEM_USERS_USER.'" title="'._AM_SYSTEM_USERS_USER.'" />';
$users['checkbox_user'] = true;
}
$users['name'] = $users_arr[$i]->getVar("uid");
$users['name'] = $users_arr[$i]->getVar("name");
$users['uname'] = $users_arr[$i]->getVar("uname");
$users['email'] = $users_arr[$i]->getVar("email");
$users['url'] = $users_arr[$i]->getVar("url");
$users['user_avatar'] = ($users_arr[$i]->getVar("user_avatar") == 'blank.gif') ? system_AdminIcons('anonymous.png') : XOOPS_URL.'/uploads/'.$users_arr[$i]->getVar("user_avatar");
$users['reg_date'] = formatTimestamp($users_arr[$i]->getVar("user_regdate"),"m");
if ($users_arr[$i]->getVar("last_login") > 0 ) {
$users['last_login'] = formatTimestamp($users_arr[$i]->getVar("last_login"),"m");
} else {
$users['last_login'] = _AM_SYSTEM_USERS_NOT_CONNECT;
}
$users['user_level'] = $users_arr[$i]->getVar("level");
$users['user_icq'] = $users_arr[$i]->getVar("user_icq");
$users['user_aim'] = $users_arr[$i]->getVar("user_aim");
$users['user_yim'] = $users_arr[$i]->getVar("user_yim");
$users['user_msnm'] = $users_arr[$i]->getVar("user_msnm");
$users['posts'] = $users_arr[$i]->getVar("posts");
$xoopsTpl->append_by_ref( 'users', $users );
$xoopsTpl->append_by_ref( 'users_popup', $users );
unset( $users );
}
} else {
$xoopsTpl->assign( 'users_no_found', true );
}
if ($users_count > $user_limit) {
include_once XOOPS_ROOT_PATH.'/class/pagenav.php';
$nav = new XoopsPageNav($users_count, $user_limit, $start, 'start', 'fct=users&amp;op=default'.$requete_pagenav);
$xoopsTpl->assign( 'nav', $nav->renderNav() );
}
}
break;
}
// Call Footer
xoops_cp_footer();
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment