[PHPBB3] Pobranie avatara z bazy i wyświetlenie w Custom Page.. Opcje

[pa-jong]

Żarło żarło i zdechło..
Zgłupiałem :/

Tak pobieram ->

[PHP] pobierz, plaintext 
$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;
       	$template->assign_block_vars('pokerow', array(
			'NR' 		=> $nr,
			'ID'		=> $row['id'],
       		        'ILE'		=> $row['ile'],
        		'NICK'		=> $row['nick'],
        		'COLOUR'	=> $row['colour'],
			'AVATAR'	=> $row['avatar'],
       	));
        }
[PHP] pobierz, plaintext 

A tak wyświetlam.

[HTML] pobierz, plaintext 
<!-- BEGIN pokerow -->
 
<tr class="<!-- IF pokerow.S_ROW_COUNT is even -->row1<!-- ELSE -->row2<!-- ENDIF -->">
	<td class="cell2">{pokerow.NR}</td>
	<td class="cell"><img src="{ROOT_PATH}download/file.php?avatar={pokerow.AVATAR}"></td>
	<td class="cell"><b ><a href="{ROOT_PATH}memberlist.php?mode=viewprofile&u={pokerow.ID}" style="color: #{pokerow.COLOUR}">{pokerow.NICK}</a></b></td>
	<td class="cell">{pokerow.ILE}</td>
</tr>
 
<!-- END pokerow -->
[HTML] pobierz, plaintext 

Wszystko poza avatarem działa.
Źrodło zwraca puste pole w miejscu gdzie daje {pokerow.AVATAR}

[HTML] pobierz, plaintext 
<tr class="row1">
	<td class="cell2">3</td>
	<td class="cell"><img src="./download/file.php?avatar="></td>
        <td class="cell"><b><a href="./memberlist.php?mode=viewprofile&u=56" style="color: rgb(238, 134, 50);">NICK</a></b></td>
	<td class="cell">2656</td>
</tr>
[HTML] pobierz, plaintext 

Niech mnie ktoś sprowadzi na ziemie... :/

Powód edycji: [erix]: przeniosłem

[napus]

[PHP] pobierz, plaintext 
include($phpbb_root_path . '/includes/functions_display.' . $phpEx);
 
$template->assign_vars(array(
        'MY_AVATAR'        => get_user_avatar($user->data['user_avatar'], $user->data['user_avatar_type'], $user->data['user_avatar_width'], $user->data['user_avatar_height']),
    ));
[PHP] pobierz, plaintext