Log in

View Full Version : Username Colors on Forum Home


EvilKitty
08-12-2007, 04:31 PM
I'm using https://vborg.vbsupport.ru/showthread.php?t=126750 for use on my forum but it lacks the built in code to display my HTML username tags on the forum home.

$hook_query_fields .= ", lpuser.displaygroupid AS lpdisplaygid, lpuser.usergroupid AS lpusergid, tsuser.displaygroupid AS tsdisplaygid, tsuser.usergroupid AS tsusergid";

$hook_query_joins .= " LEFT JOIN " . TABLE_PREFIX . "user AS lpuser ON (thread.lastposter = lpuser.username)
LEFT JOIN " . TABLE_PREFIX . "user AS tsuser ON (thread.postuserid = tsuser.userid)";

Perhaps someone more talented with code can decipher this and tell me the easiest way to accomplish said task.

if($thread['lpdisplaygid']!=0)
{
$thread['lastposter'] = fetch_musername($thread, 'lpdisplaygid', 'lastposter');
}
else
{
$thread['lastposter'] = fetch_musername($thread, 'lpusergid', 'lastposter');
}

Any help would be greatly appreciated.

I looked in the forumbit for instances of 'username' to make a simple change to 'musername', but in that location all thats visible for the part i want to change is...

'$forum[lastpostinfo]'.