[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
Brf
Support Team Member
Support Team Member
Posts: 51251
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: [20/01/07] Admin Userlist

Post by Brf » Wed Feb 13, 2008 5:56 pm

xv1600 wrote:When I use mega mail I get a reciept email sent back to me , is there any way to stop this
What does that have to do with "Admin Userlist" ?

xv1600
Registered User
Posts: 192
Joined: Tue Nov 15, 2005 4:41 am

Re: [20/01/07] Admin Userlist

Post by xv1600 » Wed Feb 13, 2008 6:02 pm

Oh I give up here this place used to be so helpful I post in one place and get sent to another I did a search for mega mail and followed the link

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

Re: [20/01/07] Admin Userlist

Post by Brf » Wed Feb 13, 2008 6:06 pm

This is the support topic for Admin Userlist. You probably want the support topic for Mega Mail, which would be the topic you downloaded it from.

xv1600
Registered User
Posts: 192
Joined: Tue Nov 15, 2005 4:41 am

Re: [20/01/07] Admin Userlist

Post by xv1600 » Wed Feb 13, 2008 6:13 pm

I am totaly lost if I post my question somewhere else I will be wrong so I will leave it thanks anyway

User avatar
Freitag
Registered User
Posts: 142
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.

Post Reply

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

Who is online

Users browsing this forum: No registered users and 11 guests