[Hoodie]

OK.  I know I said that I was done but I have one more, hopefully small, request.  Is there any way to implement the Member Color Link mod to the page?

http://custom.simplemachines.org/mods/index.php?mod=111

[Cal]

A super easy way, in fact!  Add g.online_color to your SELECT string, and then call that in CSS for the member name cell.  So, like this:

Code Select Expand

SELECT m.real_name, m.id_member, g.group_name, g.online_color, GROUP_CONCAT(CASE WHEN t.value = "" THEN "N/A" ELSE t.value END ORDER BY t.variable SEPARATOR "</td><td class=\"windowbg\">") AS custom_fields, m.date_registered


And then

Code Select Expand

<td class="windowbg" style="color: ' . $row['online_color'] . ';"><a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '" title="' . $txt['profile_of'] . ' ' . $row['real_name'] . '">' . $row['real_name'] . '</a></td>