[20/01/07] Admin Userlist

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

Try this: http://www.phpbb.com/community/viewtopic.php?t=325537

Or this: http://www.phpbb.com/community/viewtopic.php?p=561729

Or this: http://www.phpbb.com/search/?q=mega+mail

batbawls · 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?

Ricky_Racer · 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.

rreptile · 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.

elizdilo · 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 · 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.

Dogs and things · 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.

JsVineyard · 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.

elizdilo · 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 · 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?

Dogs and things · 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.

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 · 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!!!!

fisher318 · 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';

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.

Rating:

advertisements