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:
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:
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:
SELECT USER_ID,USER_DISPLAY_NAME
FROM {$config['TABLE_PREFIX']}USERS
WHERE USER_MEMBERSHIP_LEVEL='Moderator' OR USER_MEMBERSHIP_LEVEL='Administrator'
replace with:
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:
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:
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:
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:
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:
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:
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:
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:
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