Online Color Moderador

[candidosa2]

sources/BoardIndex.php

Pode fazer manualmente ou baixar no attach para automatico

Código: [Seleccione]

IFNULL(mem.ID_MEMBER, 0) AS ID_MEMBER, m.ID_MSG,
IFNULL(mods_mem.ID_MEMBER, 0) AS ID_MODERATOR, mods_mem.realName AS modRealName

Código: [Seleccione]

IFNULL(mods_memg.ID_MEMBER, 0) AS ID_MODERATOR,
mc.onlineColor as color

Código: [Seleccione]

LEFT JOIN {$db_prefix}moderators AS mods ON (mods.ID_BOARD = b.ID_BOARD)
LEFT JOIN {$db_prefix}members AS mods_mem ON (mods_mem.ID_MEMBER = mods.ID_MEMBER)

Código: [Seleccione]

LEFT JOIN {$db_prefix}members AS mods_memg ON (mods_memg.ID_MEMBER = mods.ID_MEMBER)
LEFT JOIN {$db_prefix}membergroups AS mc ON (mods_memg.ID_GROUP = mc.ID_GROUP)

Código: [Seleccione]

' . $row_board['modRealName'] . '

Código: [Seleccione]

<font color="'.$row_board['color'].'">' . $row_board['modRealName'] . '</font>