I am not linking to any vBulletin files. It's an unfeasible solution to the problem.
I have a piece of PHP code which is printing the 5 latest topic titles with the last post and poster name.
I want to get the last posters avatar in on the act here as well.
The query I have at the moment is:
Code:
select a.*, b.pagetext, b.postid from vb_thread a inner join vb_post b on a.lastpostid = b.postid order by a.lastpost desc limit 0,5;
Is there a simple way to adapt with query to bring back an avatar path as well?