jQ Username BBCode with Group Colours

Mod Base and Testarea
http://4seven.bplaced.net/forum/6test/
http://4seven.bplaced.net/forum/6test/viewtopic.php?f=2&t=230
page_footer();
// Username [BBCode] / (c) 4seven / 2011
$sql = "SELECT user_id, username, user_colour
FROM " . USERS_TABLE . "
WHERE user_type IN (" . USER_FOUNDER . ', ' . USER_NORMAL . ")
ORDER BY username_clean";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)){
$row['user_colour'] = (!empty($row['user_colour'])) ? $row['user_colour'] : '000000';
$style_bold = ($row['user_colour'] == '000000') ? 'normal' : 'bold';
$template->assign_block_vars('username_bb', array(
'USERNAME_BB_BOLD' => $style_bold,
'USERNAME_BB_VALUE' => '|#' . $row['user_colour'] . '|' . $style_bold . '|'. $row['user_id'],
'USERNAME_BB_USER' => $row['username']));}
$db->sql_freeresult($result);
// Username [BBCode] / (c) 4seven / 2011