|
Joined: Nov 2003
Posts: 482
Enthusiast
|
Enthusiast
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: 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
Last edited by sirdude; 08/21/2007 11:40 PM.
|
|
|
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.
|
|
Posts: 5,833
Joined: January 2000
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|