[chad777]

I add it i get this error:

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT userfield.userid,userfield.field7,moderator.forumi d
FROM moderator
LEFT JOIN userfield
ON (moderator.userid=userfield.userid)
ORDER BY user.field7
mysql error: Unknown table 'user' in order clause

mysql error number: 1109

When I try to add:

$mod = array();
$forummoderators=$DB_site->query('SELECT userfield.userid,userfield.fieldX,moderator.forumi d
FROM moderator
LEFT JOIN userfield
ON (moderator.userid=userfield.userid)
ORDER BY user.fieldX');
while ($moderator=$DB_site->fetch_array($forummoderators)) {
$imodcache["$moderator[forumid]"][] = $moderator;
$mod["$moderator[userid]"] = 1;
}

and on the forum home where it says posted by: username
It now only says "by"

and in the whos online box it has 2 of me
one with no name and one with display name



I hope I added this right i know I followed th direction good except what I posted above

Also is there a way to make the display name show up for the following?

1. in profile
2. private messages (regular private message and the private message box at the buttom of forum home)
3. in number of active users today
4. for thread starter
5. in messages posted

That is all i can see as of now, but i would like the display name to be everywhere the login name usally is on the forum.

This way on the user knows there login and everyone else thinks the display name is the login ?

Thanks and btw nice hack