Online Color Moderador

candidosa2 · 20 de Novembro de 2007, 07:29

sources/BoardIndex.php

Pode fazer manualmente ou baixar no attach para automatico

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 Selecionar

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

Código Selecionar

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 Selecionar

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 Selecionar

' . $row_board['modRealName'] . '

Código Selecionar

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

Online Color Moderador

candidosa2