[20/01/07] Admin Userlist

All new MODs released in our MOD Database will be announced in here. All support for released MODs needs to take place in here. No new MODs will be accepted into the MOD Database for phpBB2
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.

Rating:

Excellent!
398
72%
Very Good
98
18%
Good
38
7%
Fair
11
2%
Poor
11
2%
 
Total votes: 556

User avatar
Freitag
Registered User
Posts: 143
Joined: Mon Jul 11, 2005 10:17 pm

Re: [20/01/07] Admin Userlist

Post by Freitag » Wed Feb 13, 2008 10:57 pm

No clever .sig here

batbawls
Registered User
Posts: 3
Joined: Fri Dec 29, 2006 12:53 am

Re: [20/01/07] Admin Userlist

Post by batbawls » Wed Feb 20, 2008 4:48 am

This mod doesn't seem to work entirely correctly with phpBB2 release 2.0.23. Is there a release schedule for an update that will work correctly with this phpBB2 version?

User avatar
Ricky_Racer
Registered User
Posts: 609
Joined: Wed Feb 12, 2003 10:02 pm

Re: [20/01/07] Admin Userlist

Post by Ricky_Racer » Wed Feb 20, 2008 12:32 pm

It looks to me like you may need to apply the same code changes that were made to ./admin/admin_users.php

Code: Select all

#
#-----[ OPEN ]---------------------------------------------
#
admin/admin_users.php
#
#-----[ FIND ]---------------------------------------------
# Line 107
			$sql = "SELECT group_id
				FROM " . GROUPS_TABLE . "
				WHERE group_moderator = $user_id";
			if( !($result = $db->sql_query($sql)) )
			{
				message_die(GENERAL_ERROR, 'Could not select groups where user was moderator', '', __LINE__, __FILE__, $sql);
			}
			while ( $row_group = $db->sql_fetchrow($result) )
			{
				$group_moderator[] = $row_group['group_id'];
			}
			if ( count($group_moderator) )
			{
				$update_moderator_id = implode(', ', $group_moderator);
				$sql = "UPDATE " . GROUPS_TABLE . "
					SET group_moderator = " . $userdata['user_id'] . "
					WHERE group_moderator IN ($update_moderator_id)";
				if( !$db->sql_query($sql) )
				{
					message_die(GENERAL_ERROR, 'Could not update group moderators', '', __LINE__, __FILE__, $sql);
				}
#
#-----[ REPLACE WITH ]-------------------------------------
#
//-- mod replacement : manual update phpBB2 v.2.0.22 to phpBB2 v.2.0.23 --------
//			$sql = "SELECT group_id
//				FROM " . GROUPS_TABLE . "
//				WHERE group_moderator = $user_id";
//			if( !($result = $db->sql_query($sql)) )
//			{
//				message_die(GENERAL_ERROR, 'Could not select groups where user was moderator', '', __LINE__, __FILE__, $sql);
//			}
//			while ( $row_group = $db->sql_fetchrow($result) )
//			{
//				$group_moderator[] = $row_group['group_id'];
//			}
//			if ( count($group_moderator) )
//			{
//				$update_moderator_id = implode(', ', $group_moderator);
//				$sql = "UPDATE " . GROUPS_TABLE . "
//					SET group_moderator = " . $userdata['user_id'] . "
//					WHERE group_moderator IN ($update_moderator_id)";
//				if( !$db->sql_query($sql) )
//				{
//					message_die(GENERAL_ERROR, 'Could not update group moderators', '', __LINE__, __FILE__, $sql);
//				}
			$sql = "UPDATE " . GROUPS_TABLE . "
				SET group_moderator = " . $userdata['user_id'] . "
				WHERE group_moderator = $user_id";
			if( !$db->sql_query($sql) )
			{
				message_die(GENERAL_ERROR, 'Could not update group moderators', '', __LINE__, __FILE__, $sql);
//-- end replacement : manual update phpBB2 v.2.0.22 to phpBB2 v.2.0.23 --------
to ./admin/admin_userlist.php

Code: Select all

#
#-----[ OPEN ]---------------------------------------------
#
admin/admin_userlist.php
#
#-----[ FIND ]---------------------------------------------
#
				$sql = "SELECT group_id
					FROM " . GROUPS_TABLE . "
					WHERE group_moderator = $user_id";
				if( !($result = $db->sql_query($sql)) )
				{
					message_die(GENERAL_ERROR, 'Could not select groups where user was moderator', '', __LINE__, __FILE__, $sql);
				}
				while ( $row_group = $db->sql_fetchrow($result) )
				{
					$group_moderator[] = $row_group['group_id'];
				}
				if ( count($group_moderator) )
				{
					$update_moderator_id = implode(', ', $group_moderator);
					$sql = "UPDATE " . GROUPS_TABLE . "
						SET group_moderator = " . $userdata['user_id'] . "
						WHERE group_id IN ($update_moderator_id)";
					if( !$db->sql_query($sql) )
					{
						message_die(GENERAL_ERROR, 'Could not update group moderators', '', __LINE__, __FILE__, $sql);
					}
#
#-----[ REPLACE WITH ]-------------------------------------
#
//-- mod replacement : manual code update for use with phpBB2 v.2.0.23 ---------
//				$sql = "SELECT group_id
//					FROM " . GROUPS_TABLE . "
//					WHERE group_moderator = $user_id";
//				if( !($result = $db->sql_query($sql)) )
//				{
//					message_die(GENERAL_ERROR, 'Could not select groups where user was moderator', '', __LINE__, __FILE__, $sql);
//				}
//				while ( $row_group = $db->sql_fetchrow($result) )
//				{
//					$group_moderator[] = $row_group['group_id'];
//				}
//				if ( count($group_moderator) )
//				{
//					$update_moderator_id = implode(', ', $group_moderator);
//					$sql = "UPDATE " . GROUPS_TABLE . "
//						SET group_moderator = " . $userdata['user_id'] . "
//						WHERE group_moderator IN ($update_moderator_id)";
//					if( !$db->sql_query($sql) )
//					{
//						message_die(GENERAL_ERROR, 'Could not update group moderators', '', __LINE__, __FILE__, $sql);
//					}
				$sql = "UPDATE " . GROUPS_TABLE . "
					SET group_moderator = " . $userdata['user_id'] . "
					WHERE group_moderator = $user_id";
				if( !$db->sql_query($sql) )
				{
					message_die(GENERAL_ERROR, 'Could not update group moderators', '', __LINE__, __FILE__, $sql);
//-- end replacement : manual code update for use with phpBB2 v.2.0.23 ---------
But then again I could be mistaken, I have only updated 2 fora from v.2.0.22 to v.2.0.23 that have the admin userlist installed, and I didn't notice any problems. 8-)

rreptile
Registered User
Posts: 166
Joined: Wed Oct 06, 2004 12:51 pm
Location: Canada

Re: [20/01/07] Admin Userlist

Post by rreptile » Wed Feb 20, 2008 6:22 pm

Just upgraded from 2.0.22 to 2.0.23 and installed the latest version of Admin Userlist. I'm happy to report that it appears to be working correctly.

Please note that I made the changes to user admin/userlist_body.tpl as suggested by Ricky_Racer


FIND:

Code: Select all

				$sql = "SELECT group_id
					FROM " . GROUPS_TABLE . "
					WHERE group_moderator = $user_id";
				if( !($result = $db->sql_query($sql)) )
				{
					message_die(GENERAL_ERROR, 'Could not select groups where user was moderator', '', __LINE__, __FILE__, $sql);
				}
				
				$group_moderator = array();
				while ( $row_group = $db->sql_fetchrow($result) )
				{
					$group_moderator[] = $row_group['group_id'];
				}
				
				if ( count($group_moderator) )
				{
					$update_moderator_id = implode(', ', $group_moderator);
					
					$sql = "UPDATE " . GROUPS_TABLE . "
						SET group_moderator = " . $userdata['user_id'] . "
						WHERE group_id IN ($update_moderator_id)";
					if( !$db->sql_query($sql) )
					{
						message_die(GENERAL_ERROR, 'Could not update group moderators', '', __LINE__, __FILE__, $sql);
					} 
REPLACE WITH

Code: Select all

			$sql = "UPDATE " . GROUPS_TABLE . "
				SET group_moderator = " . $userdata['user_id'] . "
				WHERE group_moderator = $user_id";
			if( !$db->sql_query($sql) )
			{
				message_die(GENERAL_ERROR, 'Could not update group moderators', '', __LINE__, __FILE__, $sql);
					}
As far as I can tell, the MOD is indeed working correctly with 2.0.23. (Great mod!)


edit: corrected location of file to be altered.
Last edited by rreptile on Thu Feb 21, 2008 1:08 pm, edited 1 time in total.
- Reactionary (So... have you backed up your files lately? This is even more important if you're staying with phpBB2)

elizdilo
Registered User
Posts: 19
Joined: Sat Feb 16, 2008 1:42 am

Re: [20/01/07] Admin Userlist

Post by elizdilo » Wed Feb 20, 2008 11:52 pm

I uploaded this and followed the instructions on what to change. I then went to the admin section of my forum and nothing looks different. I am lost! Can anyone help??

rreptile
Registered User
Posts: 166
Joined: Wed Oct 06, 2004 12:51 pm
Location: Canada

Re: [20/01/07] Admin Userlist

Post by rreptile » Thu Feb 21, 2008 12:21 am

elizdilo wrote:I uploaded this and followed the instructions on what to change. I then went to the admin section of my forum and nothing looks different. I am lost! Can anyone help??
Are you using a different template than subsilver? If so, upload whatever subsilver files there are into your template folder.
- Reactionary (So... have you backed up your files lately? This is even more important if you're staying with phpBB2)

User avatar
Dogs and things
Registered User
Posts: 2114
Joined: Fri Sep 01, 2006 9:04 am
Location: Spain
Contact:

Re: [20/01/07] Admin Userlist

Post by Dogs and things » Thu Feb 21, 2008 3:07 pm

elizdilo wrote:I uploaded this and followed the instructions on what to change. I then went to the admin section of my forum and nothing looks different. I am lost! Can anyone help??
At the very bottom of the left pane: user list. that´s all you´ll see, until you click on it.
For phpBB2 support visit phpBB2refugees.

JsVineyard
Registered User
Posts: 78
Joined: Wed May 31, 2006 7:04 pm

Re: [20/01/07] Admin Userlist

Post by JsVineyard » Thu Feb 21, 2008 3:29 pm

Seems this one is causing me trouble with 2.0.23 too, see here.

Now, I'm not sure how to handle it. Do I change the 2.0.23 files or the 2.0.22 files in order to make this work? And I've tried looking up the code to be changed in the admin/userlist_body.tpl but it's not there. I'm kinda confused now... I'd be happy if anyone could enlighten me. In fact, I'd need a dummy manual because I'm all cross-eyed from looking at code all day. :geek:

elizdilo
Registered User
Posts: 19
Joined: Sat Feb 16, 2008 1:42 am

Re: [20/01/07] Admin Userlist

Post by elizdilo » Thu Feb 21, 2008 10:55 pm

Dogs and things wrote:
elizdilo wrote:I uploaded this and followed the instructions on what to change. I then went to the admin section of my forum and nothing looks different. I am lost! Can anyone help??
At the very bottom of the left pane: user list. that´s all you´ll see, until you click on it.

I don't even see user list. There is nothing different in my admin section.

rreptile
Registered User
Posts: 166
Joined: Wed Oct 06, 2004 12:51 pm
Location: Canada

Re: [20/01/07] Admin Userlist

Post by rreptile » Fri Feb 22, 2008 7:46 am

elizdilo wrote:I don't even see user list. There is nothing different in my admin section.
Are you certain that you have uploaded all Admin Userlist files to their correct folders?
- Reactionary (So... have you backed up your files lately? This is even more important if you're staying with phpBB2)

User avatar
Dogs and things
Registered User
Posts: 2114
Joined: Fri Sep 01, 2006 9:04 am
Location: Spain
Contact:

Re: [20/01/07] Admin Userlist

Post by Dogs and things » Fri Feb 22, 2008 8:10 am

The .tpl files should be uploaded to all your temlates, not only to subSilver, and the .tpl edit should be done to all templates, not only to subSilver.
For phpBB2 support visit phpBB2refugees.

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51889
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: [20/01/07] Admin Userlist

Post by Brf » Fri Feb 22, 2008 11:44 am

tpl files have nothing to do with the admin index.
If you are not seeing "User Admin" / "User list" on your admin menu, then you have not copied up the admin_userlist.php to your forum's /admin/ folder.

elizdilo
Registered User
Posts: 19
Joined: Sat Feb 16, 2008 1:42 am

Re: [20/01/07] Admin Userlist

Post by elizdilo » Fri Feb 22, 2008 9:24 pm

rreptile wrote:
elizdilo wrote:I don't even see user list. There is nothing different in my admin section.
Are you certain that you have uploaded all Admin Userlist files to their correct folders?

Thank you so much!!!!!!! I totally did not even upload the files to the correct folders. You just saved me so much frustration!!!! :D

fisher318
Registered User
Posts: 9
Joined: Wed Feb 06, 2008 8:31 pm

Re: [20/01/07] Admin Userlist

Post by fisher318 » Thu Feb 28, 2008 7:14 pm

O, I got confused, this is what the install instructions said to do:

#-----[ FIND ]------------------------------------------
#
# Full Line:
# $lang['Install_No_PCRE'] = 'phpBB2 Requires the Perl-Compatible Regular Expressions Module for PHP which your PHP configuration doesn\'t appear to support!';
#
$lang['Install_No_PCRE'] =

#

(Ok, so isthis AFTER,ADD below supposed to go after "$lang['Install_No_PCRE'] = ", and if so, do we leave what's written above "'phpBB2 Requires the Perl-Compatible Regular Expressions Module for PHP which your PHP configuration doesn\'t appear to support!';"?

#-----[ AFTER, ADD ]------------------------------------------
#

//
// Admin Userlist Start
//
$lang['Userlist'] = 'User list';
$lang['Userlist_description'] = 'View a complete list of your users and perform various actions on them';

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51889
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: [20/01/07] Admin Userlist

Post by Brf » Thu Feb 28, 2008 7:15 pm

AFTER, ADD mean to put it on a new line. Dont change the found line.

Post Reply

Return to “[2.0.x] MOD Database Releases”