pull musername by userid

[ohadpartuck]

Hi,
I am trying to retrieve the musername (directly from the vbulletin db) in order to display the username + it's color.

anyone knows where to look?

[kh99]

It's a little complicated - the html markup for the user name is in the opentag and closetag columns of the usergroup table in the db. But which usergroup you use can be affected by the user having a displaygroupid or infractiongroupid set. You might want to look at function fetch_musername() in includes/functions.php, around line 1567.