[solution][snipplet] Phpbb3 code to get user avatar

You’ll need
[code:1:927967b493]include($phpbb_root_path . ‘includes/functions_display.’ . $phpEx);[/code:1:927967b493]

Next, do this select SQL ( or merge/add with your existing SQL )..
[code:1:927967b493]SELECT user_avatar, user_avatar_type, user_avatar_width, user_avatar_height[/code:1:927967b493]

In your while loop: do this:
[code:1:927967b493]$row[’avatar’] = get_user_avatar($row[’user_avatar’], $row[’user_avatar_type’], $row[’user_avatar_width’], $row[’user_avatar_height’]);[/code:1:927967b493]

[b:927967b493]Also interesting:[/b:927967b493]
http://www.ramonfincken.com/permalink/topic149.html
http://www.ramonfincken.com/permalink/topic150.html

[b:927967b493]Source:[/b:927967b493]
[url]http://www.volasail.com/2008/04/using-phpbb3-avatars-in-custom-pages/[/url]