Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Nov 2003
Posts: 482
Enthusiast
Enthusiast
Offline
Joined: Nov 2003
Posts: 482
We have about 30 moderators on a board and dealing with them in the CPanel is a pain, when the list isn't sorted. It's also nice to have the list per forum sorted too..

This does just that.. nothing fancy, but it sorts them where visible alphabetically.

open: /admin/modmanage.php

find:
PHP Code
 SELECT t1.USER_DISPLAY_NAME,t2.USER_ID,t2.FORUM_ID
FROM
{$config['TABLE_PREFIX']}MODERATORS AS t2,
{
$config['TABLE_PREFIX']}USERS AS t1
WHERE t2
.USER_ID = t1.USER_ID
ORDER BY FORUM_ID

replace with:
PHP Code
 SELECT t1.USER_DISPLAY_NAME,t2.USER_ID,t2.FORUM_ID
FROM
{$config['TABLE_PREFIX']}MODERATORS AS t2,
{
$config['TABLE_PREFIX']}USERS AS t1
WHERE t2
.USER_ID = t1.USER_ID
ORDER BY FORUM_ID
, t1.USER_DISPLAY_NAME
done!

open: /admin/modselect.php

find:
PHP Code
 SELECT USER_ID,USER_DISPLAY_NAME
FROM
{$config['TABLE_PREFIX']}USERS
WHERE USER_MEMBERSHIP_LEVEL
='Moderator' OR USER_MEMBERSHIP_LEVEL='Administrator'

replace with:
PHP Code
 SELECT USER_ID,USER_DISPLAY_NAME
FROM
{$config['TABLE_PREFIX']}USERS
WHERE USER_MEMBERSHIP_LEVEL
='Moderator' OR USER_MEMBERSHIP_LEVEL='Administrator'
ORDER BY USER_DISPLAY_NAME
done!

open: /scripts/cfrm.inc.php

find:
PHP Code
	 SELECT t1.FORUM_ID,t1.USER_ID,t2.USER_DISPLAY_NAME
FROM
{$config['TABLE_PREFIX']}MODERATORS AS t1,
{
$config['TABLE_PREFIX']}USERS AS t2
WHERE t1
.USER_ID = t2.USER_ID
replace with:
PHP Code
	 SELECT t1.FORUM_ID,t1.USER_ID,t2.USER_DISPLAY_NAME
FROM
{$config['TABLE_PREFIX']}MODERATORS AS t1,
{
$config['TABLE_PREFIX']}USERS AS t2
WHERE t1
.USER_ID = t2.USER_ID
ORDER BY t2
.USER_DISPLAY_NAME
done!

open: /scripts/postlist.inc.php

find:
PHP Code
				 SELECT t1.USER_ID, t2.USER_DISPLAY_NAME
FROM
{$config['TABLE_PREFIX']}MODERATORS AS t1,
{
$config['TABLE_PREFIX']}USERS AS t2
WHERE t1
.USER_ID = t2.USER_ID
AND t1.FORUM_ID = ?
replace with:
PHP Code
				 SELECT t1.USER_ID, t2.USER_DISPLAY_NAME
FROM
{$config['TABLE_PREFIX']}MODERATORS AS t1,
{
$config['TABLE_PREFIX']}USERS AS t2
WHERE t1
.USER_ID = t2.USER_ID
AND t1.FORUM_ID = ?
ORDER BY t2.USER_DISPLAY_NAME
find:
PHP Code
	 SELECT t1.USER_ID,t2.USER_DISPLAY_NAME
FROM
{$config['TABLE_PREFIX']}MODERATORS AS t1,
{
$config['TABLE_PREFIX']}USERS AS t2
WHERE t1
.FORUM_ID = ?
AND
t1.USER_ID = t2.USER_ID
replace with:
PHP Code
	 SELECT t1.USER_ID,t2.USER_DISPLAY_NAME
FROM
{$config['TABLE_PREFIX']}MODERATORS AS t1,
{
$config['TABLE_PREFIX']}USERS AS t2
WHERE t1
.FORUM_ID = ?
AND
t1.USER_ID = t2.USER_ID
ORDER BY t2
.USER_DISPLAY_NAME
done!

open: /scripts/showflat.inc.php

find:
PHP Code
	 SELECT t1.USER_ID,t2.USER_DISPLAY_NAME
FROM
{$config['TABLE_PREFIX']}MODERATORS AS t1,
{
$config['TABLE_PREFIX']}USERS AS t2
WHERE t1
.FORUM_ID = ?
AND
t1.USER_ID = t2.USER_ID
replace with:
PHP Code
	 SELECT t1.USER_ID,t2.USER_DISPLAY_NAME
FROM
{$config['TABLE_PREFIX']}MODERATORS AS t1,
{
$config['TABLE_PREFIX']}USERS AS t2
WHERE t1
.FORUM_ID = ?
AND
t1.USER_ID = t2.USER_ID
ORDER BY t2
.USER_DISPLAY_NAME
done!

All done. upload files and you have sorted moderator lists where visible.

Edit for 7.2.1 smile

Last edited by sirdude; 08/21/2007 11:40 PM.
Sponsored Links

Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
isaac
isaac
California
Posts: 1,157
Joined: July 2001
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)