SMFPT - Suporte e Manutenção de Fórum em Português

SMF 1.1.x (Móbulos Manual) => SMF 1.1.x Módulos Manual => Categoria => Tópico começado por: candidosa2 em 20 de Novembro de 2007, 07:29

Título: Online Color Moderador
Mensagem de: candidosa2 em 20 de Novembro de 2007, 07:29
sources/BoardIndex.php

Pode fazer manualmente ou baixar no attach para automatico

(http://i211.photobucket.com/albums/bb184/candidosa2/sshot-4-17.png)

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


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


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)


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)


' . $row_board['modRealName'] . '

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