一个用此分页类的例子:admin.users.php(我有很多地方看不懂,请高手们看完后另提供一个例子,多谢!)
<?php
/**
* @version $Id: admin.users.php,v 1.14 2005/02/16 14:21:00 stingrey Exp $
* @package Mambo
* @subpackage Users
* @copyright (C) 2000 - 2005 Miro International Pty Ltd
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
* Mambo is Free Software
*//** ensure this file is being included by a parent file */
defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' );if (!$acl->acl_check( 'administration', 'manage', 'users', $my->usertype, 'components', 'com_users' )) {
mosRedirect( 'index2.php', _NOT_AUTH );
}require_once( $mainframe->getPath( 'admin_html' ) );$task = trim( mosGetParam( $_REQUEST, 'task', null ) );
$cid = mosGetParam( $_REQUEST, 'cid', array( 0 ) );
if (!is_array( $cid )) {
$cid = array ( 0 );
}switch ($task) {
case 'new':
editUser( 0, $option);
break; case 'edit':
editUser( intval( $cid[0] ), $option );
break; case 'editA':
editUser( $id, $option );
break; case 'save':
case 'apply':
saveUser( $option, $task );
break; case 'remove':
removeUsers( $cid, $option );
break; case 'block':
changeUserBlock( $cid, 1, $option );
break; case 'unblock':
changeUserBlock( $cid, 0, $option );
break; case 'logout':
logoutUser( $cid, $option, $task );
break; case 'flogout':
logoutUser( $id, $option, $task );
break; case 'cancel':
cancelUser( $option );
break; case 'contact':
$contact_id = mosGetParam( $_POST, 'contact_id', '' );
mosRedirect( 'index2.php?option=com_contact&task=editA&id='. $contact_id );
break; default:
showUsers( $option );
break;
}function showUsers( $option ) {
global $database, $mainframe, $my, $acl, $mosConfig_list_limit; $filter_type = $mainframe->getUserStateFromRequest( "filter_type{$option}", 'filter_type', 0 );
$filter_logged = $mainframe->getUserStateFromRequest( "filter_logged{$option}", 'filter_logged', 0 );
$limit = $mainframe->getUserStateFromRequest( "viewlistlimit", 'limit', $mosConfig_list_limit );
$limitstart = $mainframe->getUserStateFromRequest( "view{$option}limitstart", 'limitstart', 0 );
$search = $mainframe->getUserStateFromRequest( "search{$option}", 'search', '' );
$search = $database->getEscaped( trim( strtolower( $search ) ) );
$where = array(); if (isset( $search ) && $search!= "") {
$where[] = "(a.username LIKE '%$search%' OR a.email LIKE '%$search%' OR a.name LIKE '%$search%')";
}
if ( $filter_type ) {
if ( $filter_type == 'Public Frontend' ) {
$where[] = "a.usertype = 'Registered' OR a.usertype = 'Author' OR a.usertype = 'Editor'OR a.usertype = 'Publisher'";
} else if ( $filter_type == 'Public Backend' ) {
$where[] = "a.usertype = 'Manager' OR a.usertype = 'Administrator' OR a.usertype = 'Super Administrator'";
} else {
$where[] = "a.usertype = LOWER( '$filter_type' )";
}
}
if ( $filter_logged == 1 ) {
$where[] = "s.userid = a.id";
} else if ($filter_logged == 2) {
$where[] = "s.userid IS NULL";
} // exclude any child group id's for this user
//$acl->_debug = true;
$pgids = $acl->get_group_children( $my->gid, 'ARO', 'RECURSE' ); if (is_array( $pgids ) && count( $pgids ) > 0) {
$where[] = "(a.gid NOT IN (" . implode( ',', $pgids ) . "))";
} $query = "SELECT COUNT(*)"
. "\n FROM #__users AS a"
. "\n LEFT JOIN #__session AS s ON s.userid = a.id"
. ( count( $where ) ? "\n WHERE " . implode( ' AND ', $where ) : '' )
;
$database->setQuery( $query );
$total = $database->loadResult(); require_once( $GLOBALS['mosConfig_absolute_path'] . '/administrator/includes/pageNavigation.php' );
$pageNav = new mosPageNav( $total, $limitstart, $limit ); $query = "SELECT a.*, g.name AS groupname, s.userid AS loggedin"
. "\n FROM #__users AS a"
. "\n INNER JOIN #__core_acl_aro AS aro ON aro.value = a.id" // map user to aro
. "\n INNER JOIN #__core_acl_groups_aro_map AS gm ON gm.aro_id = aro.aro_id" // map aro to group
. "\n INNER JOIN #__core_acl_aro_groups AS g ON g.group_id = gm.group_id"
. "\n LEFT JOIN #__session AS s ON s.userid = a.id"
. (count( $where ) ? "\n WHERE " . implode( ' AND ', $where ) : "")
. "\n GROUP BY a.id"
. "\n LIMIT $pageNav->limitstart, $pageNav->limit"
;
$database->setQuery( $query );
$rows = $database->loadObjectList(); if ($database->getErrorNum()) {
echo $database->stderr();
return false;
} // get list of Groups for dropdown filter
$query = "SELECT name AS value, name AS text"
. "\n FROM #__core_acl_aro_groups"
. "\n WHERE name != 'ROOT'"
. "\n AND name != 'USERS'"
;
$types[] = mosHTML::makeOption( '0', '- Select Group -' );
$database->setQuery( $query );
$types = array_merge( $types, $database->loadObjectList() );
$lists['type'] = mosHTML::selectList( $types, 'filter_type', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'value', 'text', "$filter_type" ); // get list of Log Status for dropdown filter
$logged[] = mosHTML::makeOption( 0, '- Select Log Status - ');
$logged[] = mosHTML::makeOption( 1, 'Logged In');
$logged[] = mosHTML::makeOption( 2, 'Not Logged In');
$lists['logged'] = mosHTML::selectList( $logged, 'filter_logged', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'value', 'text', "$filter_logged" ); HTML_users::showUsers( $rows, $pageNav, $search, $option, $lists );
}function editUser( $uid='0', $option='users' ) {
global $database, $my, $acl, $adminLanguage; $row = new mosUser( $database );
// load the row from the db table
$row->load( $uid ); if ( $uid ) {
$query = "SELECT * FROM #__contact_details WHERE user_id='". $row->id ."'";
$database->setQuery( $query );
$contact = $database->loadObjectList();
} else {
$contact = NULL;
$row->block = 0;
}
<?php
/**
* @version $Id: admin.users.php,v 1.14 2005/02/16 14:21:00 stingrey Exp $
* @package Mambo
* @subpackage Users
* @copyright (C) 2000 - 2005 Miro International Pty Ltd
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
* Mambo is Free Software
*//** ensure this file is being included by a parent file */
defined( '_VALID_MOS' ) or die( 'Direct Access to this location is not allowed.' );if (!$acl->acl_check( 'administration', 'manage', 'users', $my->usertype, 'components', 'com_users' )) {
mosRedirect( 'index2.php', _NOT_AUTH );
}require_once( $mainframe->getPath( 'admin_html' ) );$task = trim( mosGetParam( $_REQUEST, 'task', null ) );
$cid = mosGetParam( $_REQUEST, 'cid', array( 0 ) );
if (!is_array( $cid )) {
$cid = array ( 0 );
}switch ($task) {
case 'new':
editUser( 0, $option);
break; case 'edit':
editUser( intval( $cid[0] ), $option );
break; case 'editA':
editUser( $id, $option );
break; case 'save':
case 'apply':
saveUser( $option, $task );
break; case 'remove':
removeUsers( $cid, $option );
break; case 'block':
changeUserBlock( $cid, 1, $option );
break; case 'unblock':
changeUserBlock( $cid, 0, $option );
break; case 'logout':
logoutUser( $cid, $option, $task );
break; case 'flogout':
logoutUser( $id, $option, $task );
break; case 'cancel':
cancelUser( $option );
break; case 'contact':
$contact_id = mosGetParam( $_POST, 'contact_id', '' );
mosRedirect( 'index2.php?option=com_contact&task=editA&id='. $contact_id );
break; default:
showUsers( $option );
break;
}function showUsers( $option ) {
global $database, $mainframe, $my, $acl, $mosConfig_list_limit; $filter_type = $mainframe->getUserStateFromRequest( "filter_type{$option}", 'filter_type', 0 );
$filter_logged = $mainframe->getUserStateFromRequest( "filter_logged{$option}", 'filter_logged', 0 );
$limit = $mainframe->getUserStateFromRequest( "viewlistlimit", 'limit', $mosConfig_list_limit );
$limitstart = $mainframe->getUserStateFromRequest( "view{$option}limitstart", 'limitstart', 0 );
$search = $mainframe->getUserStateFromRequest( "search{$option}", 'search', '' );
$search = $database->getEscaped( trim( strtolower( $search ) ) );
$where = array(); if (isset( $search ) && $search!= "") {
$where[] = "(a.username LIKE '%$search%' OR a.email LIKE '%$search%' OR a.name LIKE '%$search%')";
}
if ( $filter_type ) {
if ( $filter_type == 'Public Frontend' ) {
$where[] = "a.usertype = 'Registered' OR a.usertype = 'Author' OR a.usertype = 'Editor'OR a.usertype = 'Publisher'";
} else if ( $filter_type == 'Public Backend' ) {
$where[] = "a.usertype = 'Manager' OR a.usertype = 'Administrator' OR a.usertype = 'Super Administrator'";
} else {
$where[] = "a.usertype = LOWER( '$filter_type' )";
}
}
if ( $filter_logged == 1 ) {
$where[] = "s.userid = a.id";
} else if ($filter_logged == 2) {
$where[] = "s.userid IS NULL";
} // exclude any child group id's for this user
//$acl->_debug = true;
$pgids = $acl->get_group_children( $my->gid, 'ARO', 'RECURSE' ); if (is_array( $pgids ) && count( $pgids ) > 0) {
$where[] = "(a.gid NOT IN (" . implode( ',', $pgids ) . "))";
} $query = "SELECT COUNT(*)"
. "\n FROM #__users AS a"
. "\n LEFT JOIN #__session AS s ON s.userid = a.id"
. ( count( $where ) ? "\n WHERE " . implode( ' AND ', $where ) : '' )
;
$database->setQuery( $query );
$total = $database->loadResult(); require_once( $GLOBALS['mosConfig_absolute_path'] . '/administrator/includes/pageNavigation.php' );
$pageNav = new mosPageNav( $total, $limitstart, $limit ); $query = "SELECT a.*, g.name AS groupname, s.userid AS loggedin"
. "\n FROM #__users AS a"
. "\n INNER JOIN #__core_acl_aro AS aro ON aro.value = a.id" // map user to aro
. "\n INNER JOIN #__core_acl_groups_aro_map AS gm ON gm.aro_id = aro.aro_id" // map aro to group
. "\n INNER JOIN #__core_acl_aro_groups AS g ON g.group_id = gm.group_id"
. "\n LEFT JOIN #__session AS s ON s.userid = a.id"
. (count( $where ) ? "\n WHERE " . implode( ' AND ', $where ) : "")
. "\n GROUP BY a.id"
. "\n LIMIT $pageNav->limitstart, $pageNav->limit"
;
$database->setQuery( $query );
$rows = $database->loadObjectList(); if ($database->getErrorNum()) {
echo $database->stderr();
return false;
} // get list of Groups for dropdown filter
$query = "SELECT name AS value, name AS text"
. "\n FROM #__core_acl_aro_groups"
. "\n WHERE name != 'ROOT'"
. "\n AND name != 'USERS'"
;
$types[] = mosHTML::makeOption( '0', '- Select Group -' );
$database->setQuery( $query );
$types = array_merge( $types, $database->loadObjectList() );
$lists['type'] = mosHTML::selectList( $types, 'filter_type', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'value', 'text', "$filter_type" ); // get list of Log Status for dropdown filter
$logged[] = mosHTML::makeOption( 0, '- Select Log Status - ');
$logged[] = mosHTML::makeOption( 1, 'Logged In');
$logged[] = mosHTML::makeOption( 2, 'Not Logged In');
$lists['logged'] = mosHTML::selectList( $logged, 'filter_logged', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'value', 'text', "$filter_logged" ); HTML_users::showUsers( $rows, $pageNav, $search, $option, $lists );
}function editUser( $uid='0', $option='users' ) {
global $database, $my, $acl, $adminLanguage; $row = new mosUser( $database );
// load the row from the db table
$row->load( $uid ); if ( $uid ) {
$query = "SELECT * FROM #__contact_details WHERE user_id='". $row->id ."'";
$database->setQuery( $query );
$contact = $database->loadObjectList();
} else {
$contact = NULL;
$row->block = 0;
}
// check to ensure only super admins can edit super admin info
if ( ( $my->gid < 25 ) && ( $row->gid == 25 ) ) {
mosRedirect( 'index2.php?option=com_users', _NOT_AUTH );
} $my_group = strtolower( $acl->get_group_name( $row->gid, 'ARO' ) );
if ( $my_group == 'super administrator' ) {
$lists['gid'] = '<input type="hidden" name="gid" value="'. $my->gid .'" /><strong>'. $adminLanguage->A_COMP_USERS_SUPER_ADMIN .'</strong>';
} else if ( $my->gid == 24 && $row->gid == 24 ) {
$lists['gid'] = '<input type="hidden" name="gid" value="'. $my->gid .'" /><strong>Administrator</strong>';
} else {
// ensure user can't add group higher than themselves
$my_groups = $acl->get_object_groups( 'users', $my->id, 'ARO' );
if (is_array( $my_groups ) && count( $my_groups ) > 0) {
$ex_groups = $acl->get_group_children( $my_groups[0], 'ARO', 'RECURSE' );
} else {
$ex_groups = array();
} $gtree = $acl->get_group_children_tree( null, 'USERS', false ); // remove users 'above' me
$i = 0;
while ($i < count( $gtree )) {
if (in_array( $gtree[$i]->value, $ex_groups )) {
array_splice( $gtree, $i, 1 );
} else {
$i++;
}
} $lists['gid'] = mosHTML::selectList( $gtree, 'gid', 'size="10"', 'value', 'text', $row->gid );
} // build the html select list
$lists['block'] = mosHTML::yesnoRadioList( 'block', 'class="inputbox" size="1"', $row->block );
// build the html select list
$lists['sendEmail'] = mosHTML::yesnoRadioList( 'sendEmail', 'class="inputbox" size="1"', $row->sendEmail ); HTML_users::edituser( $row, $contact, $lists, $option, $uid );
}function saveUser( $option, $task ) {
global $database, $my;
global $mosConfig_live_site, $mosConfig_mailfrom, $mosConfig_fromname, $mosConfig_sitename; $row = new mosUser( $database );
if (!$row->bind( $_POST )) {
echo "<script> alert('".$row->getError()."'); window.history.go(-1); </script>\n";
exit();
} $isNew = !$row->id;
$pwd = ''; // MD5 hash convert passwords
if ($isNew) {
// new user stuff
if ($row->password == '') {
$pwd = mosMakePassword();
$row->password = md5( $pwd );
} else {
$pwd = $row->password;
$row->password = md5( $row->password );
}
$row->registerDate = date( 'Y-m-d H:i:s' );
} else {
// existing user stuff
if ($row->password == '') {
// password set to null if empty
$row->password = null;
} else {
$row->password = md5( $row->password );
}
} // save usertype to usetype column
$query = "SELECT name"
. "\n FROM #__core_acl_aro_groups"
. "\n WHERE group_id = $row->gid"
;
$database->setQuery( $query );
$usertype = $database->loadResult();
$row->usertype = $usertype;
if (!$row->check()) {
echo "<script> alert('".$row->getError()."'); window.history.go(-2); </script>\n";
exit();
}
if (!$row->store()) {
echo "<script> alert('".$row->getError()."'); window.history.go(-2); </script>\n";
exit();
}
$row->checkin(); // update the ACL
if ( !$isNew ) {
$query = "SELECT aro_id FROM #__core_acl_aro WHERE value='$row->id'";
$database->setQuery( $query );
$aro_id = $database->loadResult(); $query = "UPDATE #__core_acl_groups_aro_map"
. "\n SET group_id = '$row->gid'"
. "\n WHERE aro_id = '$aro_id'"
;
$database->setQuery( $query );
$database->query() or die( $database->stderr() );
} // for new users, email username and password
if ($isNew) {
$query = "SELECT email FROM #__users WHERE id=$my->id";
$database->setQuery( $query );
$adminEmail = $database->loadResult(); $subject = _NEW_USER_MESSAGE_SUBJECT;
$message = sprintf ( _NEW_USER_MESSAGE, $row->name, $mosConfig_sitename, $mosConfig_live_site, $row->username, $pwd ); if ($mosConfig_mailfrom != "" && $mosConfig_fromname != "") {
$adminName = $mosConfig_fromname;
$adminEmail = $mosConfig_mailfrom;
} else {
$query = "SELECT name, email FROM #__users WHERE usertype='superadministrator'";
$database->setQuery( $query );
$rows = $database->loadObjectList();
$row = $rows[0];
$adminName = $row->name;
$adminEmail = $row->email;
}
mosMail( $adminEmail, $adminName, $row->email, $subject, $message );
} switch ( $task ) {
case 'apply':
$msg = 'Successfully Saved changes to User: '. $row->name;
mosRedirect( 'index2.php?option=com_users&task=editA&hidemainmenu=1&id='. $row->id, $msg ); case 'save':
default:
$msg = 'Successfully Saved User: '. $row->name;
mosRedirect( 'index2.php?option=com_users', $msg ); break;
}
}/**
* Cancels an edit operation
* @param option component option to call
*/
function cancelUser( $option ) {
mosRedirect( 'index2.php?option='. $option .'&task=view' );
}function removeUsers( $cid, $option ) {
global $database, $acl, $my, $adminLanguage; if (!is_array( $cid ) || count( $cid ) < 1) {
echo "<script> alert(\"". $adminLanguage->A_COMP_CONTENT_SEL_DEL ."\"); window.history.go(-1);</script>\n";
exit;
} if ( count( $cid ) ) {
$obj = new mosUser( $database );
foreach ($cid as $id) {
// check for a super admin ... can't delete them
$groups = $acl->get_object_groups( 'users', $id, 'ARO' );
$this_group = strtolower( $acl->get_group_name( $groups[0], 'ARO' ) );
if ( $this_group == 'super administrator' ) {
$msg . $adminLanguage->A_COMP_USERS_CANNOT;
} else if ( $id == $my->id ){
$msg . $adminLanguage->A_COMP_USERS_NOT_DEL_SELF;
} else if ( ( $this_group == 'administrator' ) && ( $my->gid == 24 ) ){
$msg . $adminLanguage->A_COMP_USERS_NOT_DEL_ADMIN;
} else {
$obj->delete( $id );
$msg = $obj->getError();
}
}
} mosRedirect( 'index2.php?option='. $option, $msg );
}/**
* Blocks or Unblocks one or more user records
* @param array An array of unique category id numbers
* @param integer 0 if unblock, 1 if blocking
* @param string The current url option
*/
function changeUserBlock( $cid=null, $block=1, $option ) {
global $database, $my, $adminLanguage; if (count( $cid ) < 1) {
$action = $block ? 'block' : 'unblock';
echo "<script> alert(\"". $adminLanguage->A_COMP_SEL_ITEM ." ". $action ."\"); window.history.go(-1);</script>\n";
exit;
} $cids = implode( ',', $cid ); $query = "UPDATE #__users SET block='$block' WHERE id IN ($cids)";
$database->setQuery( $query );
if (!$database->query()) {
echo "<script> alert('".$database->getErrorMsg()."'); window.history.go(-1); </script>\n";
exit();
} mosRedirect( 'index2.php?option='. $option );
}/**
* @param array An array of unique user id numbers
* @param string The current url option
*/
function logoutUser( $cid=null, $option, $task ) {
global $database, $my; $cids = $cid;
if ( is_array( $cid ) ) {
if (count( $cid ) < 1) {
mosRedirect( 'index2.php?option='. $option, 'Please select a user' );
}
$cids = implode( ',', $cid );
} $query = "DELETE FROM #__session WHERE userid IN ($cids)";
$database->setQuery( $query );
$database->query(); switch ( $task ) {
case 'flogout':
mosRedirect( 'index2.php', $database->getErrorMsg() );
break;
default:
mosRedirect( 'index2.php?option='. $option, $database->getErrorMsg() );
break;
}
}function is_email($email){
$rBool=false; if(preg_match("/[\w\.\-]+@\w+[\w\.\-]*?\.\w{1,4}/", $email)){
$rBool=true;
}
return $rBool;
}?>.
如果高手们有时间的话,麻烦把解决方法或者示例发到我邮箱.不胜感激!!!