Display username (not your own) on non-vb pages

[charlie71]

You can use something like this for getting the username by a userid:

$username = mysql_result($db->query_read("select username from " . TABLE_PREFIX . "user where userid = '$userid' order by userid desc limit 1"), 0);

Don't forget to escape $userid properly by using the vbulletin escape functions...