Zgłupiałem :/
Tak pobieram ->
$sql = 'SELECT count(chat.message) AS ile, users.username as nick, users.user_colour as colour, users.user_id as id, users.user_avatar as avatar FROM phpbb_users as users,phpbb_mchat as chat WHERE users.user_id = chat.user_id GROUP BY chat.user_id ORDER BY ile DESC'; $result = $db->sql_query($sql); $nr = 0; while( $row = $db->sql_fetchrow($result) ) { $nr = $nr+1; 'NR' => $nr, 'ID' => $row['id'], 'ILE' => $row['ile'], 'NICK' => $row['nick'], 'COLOUR' => $row['colour'], 'AVATAR' => $row['avatar'], )); }
A tak wyświetlam.
<!-- BEGIN pokerow --> </tr> <!-- END pokerow -->
Wszystko poza avatarem działa.
Źrodło zwraca puste pole w miejscu gdzie daje {pokerow.AVATAR}
Niech mnie ktoś sprowadzi na ziemie... :/