Add color functionality to the usernames of this query

[shuban]

I would like to add color to the usernames of this function.

Code: [Select]

// Karma good top 10.
$members_result = db_query("
SELECT ID_MEMBER, realName, karmaGood
FROM {$db_prefix}members
WHERE karmaGood > 0
ORDER BY karmaGood DESC
LIMIT 10", __FILE__, __LINE__);
$context['top_karma_good'] = array();
$max_karma_good = 1;
while ($row_members = mysql_fetch_assoc($members_result))
{
$context['top_karma_good'][] = array(
'name' => $row_members['realName'],
'id' => $row_members['ID_MEMBER'],
'num_karma' => $row_members['karmaGood'],
'href' => $scripturl . '?action=profile;u=' . $row_members['ID_MEMBER'],
'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row_members['ID_MEMBER'] . '">' . $row_members['realName'] . '</a>'
);

if ($max_karma_good < $row_members['karmaGood'])
$max_karma_good = $row_members['karmaGood'];
}
mysql_free_result($members_result);

foreach ($context['top_karma_good'] as $i => $poster)
$context['top_karma_good'][$i]['karma_percent'] = round(($poster['num_karma'] * 100) / $max_karma_good);
How would I do this?

[SMFHacks]

Updated code

Code: [Select]

// Karma good top 10.
$members_result = db_query("
SELECT  m.ID_MEMBER,  m.realName, m.karmaGood, mg.onlineColor 
FROM {$db_prefix}members as m
            LEFT JOIN {$db_prefix}membergroups AS mg ON (mg.ID_GROUP = IF(m.ID_GROUP = 0, m.ID_POST_GROUP, m.ID_GROUP))
WHERE  m.karmaGood > 0
ORDER BY  m.karmaGood DESC
LIMIT 10", __FILE__, __LINE__);
$context['top_karma_good'] = array();
$max_karma_good = 1;
while ($row_members = mysql_fetch_assoc($members_result))
{
$context['top_karma_good'][] = array(
'name' => $row_members['realName'],
'id' => $row_members['ID_MEMBER'],
'num_karma' => $row_members['karmaGood'],
'href' => $scripturl . '?action=profile;u=' . $row_members['ID_MEMBER'],
'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row_members['ID_MEMBER'] . '"' . (!empty($row['onlineColor']) ? ' style="color: ' . $row['onlineColor'] . ';" ' :'' ) . '>' . $row_members['realName'] . '</a>'
);

if ($max_karma_good < $row_members['karmaGood'])
$max_karma_good = $row_members['karmaGood'];
}
mysql_free_result($members_result);

foreach ($context['top_karma_good'] as $i => $poster)
$context['top_karma_good'][$i]['karma_percent'] = round(($poster['num_karma'] * 100) / $max_karma_good);


[shuban]

Surprisingly, that didn't do it either. I mean, it's not even throwing an error! It just displays the name without color.

However, changing it to this works

Code: [Select]

'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row_members['ID_MEMBER'] . '"' . (!empty($row_members['onlineColor']) ? ' style="color: ' . $row_members['onlineColor'] . ';" ' :'' ) . '>' . $row_members['realName'] . '</a>'
Thank you, again!

[SMFHacks]

$row['onlineColor']  should be $row_members['onlineColor']

[shuban]

$row['onlineColor']  should be $row_members['onlineColor']

Got it

Thank you