Mini Mods - Last Poster Avatar

Info

This mod ads last posters' avatars next to their names on Forumdisplay pages. I've just finished a section of one of my bigger mods to come, and thought that some of you may just need this little enhancement on their forums. If so, feel free to download and test it.

Features

Not too many features for now, it's a pretty straight forward mod. I'm always open to your suggestions though.

- Display last poster avatars in threadbits on forumdisplay
- Display last poster avatars in forumbits on forumhome and forumdisplay
- Admin settings to enable display of last poster avatars in certain areas or disable globally
- Set an avatar size to best match the layout
- Choose an alternative avatar display on forumbits
- Zero database queries to keep things running smoothly

Installation

Import [phpdesk.com]-product-lpavatar.xml via AdminCP > Plugin System > Manage Products > [Add/Import Product]

Mod Support

- Do not forget to mark as installed to qualify for further assistance
- A small donation would always be welcome to support further development of this hack (Support Developer)
- I'll do my best to listen to your comments and suggestions as long as time permits

Ghangelog

1.0.0 | 2011-12-13
- First Release

1.0.1 | 2011-12-13
- Fixed file path issue affecting some forum setups

1.0.2 | 2011-12-14
- Added last poster avatars to forumbits on forumhome and forumdisplay
- Added admin options to control display of avatars

1.0.3 | 2011-12-15
- Added option to display a default avatar for users that have not uploaded a custom avatar of their own

1.0.4 | 2011-12-15
- Re-enabled last posters' avatars display on forumhome after fixing the reported issue

1.0.5 | 2011-12-16
- Added option to set the avatar size individually for the forumbits and threadbits display

1.1.0 | 2012-01-04
- Link the avatar to member profile page
- Offer additional way to position last poster avatars on forumbits
- Remove the unnecessary extra database queries

1.1.1 | 2012-01-04
- Fix display issue when avatars are set to be saved as files

1.X.X | PLANNED
- Add avatar to search results, new posts, today posts, etc

[TheSupportForum]

Originally Posted by IGOTASTi

So how do I fix this?

Admicp > Plugins & Products > Plugin Manager >
look for Hook Forumbit Query Fields & Joins

ensure that the fieldnames match the query

[I.G.O.T.A.]

Here is my code.

if( $vbulletin->options['lpavatar_enable'] == 1 && $vbulletin->options['lpavatar_forumbit'] == 1 )
{
$counter_select .= iif($vbulletin->options['avatarenabled'], ', user.avatarrevision AS avatarrevision, forum.lastposterid AS userid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight');
$tachyjoin .= iif($vbulletin->options['avatarenabled'], "LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid = user.userid)");
}

[TheSupportForum]

Originally Posted by IGOTASTi

Here is my code.

if( $vbulletin->options['lpavatar_enable'] == 1 && $vbulletin->options['lpavatar_forumbit'] == 1 )
{
$counter_select .= iif($vbulletin->options['avatarenabled'], ', user.avatarrevision AS avatarrevision, forum.lastposterid AS userid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight');
$tachyjoin .= iif($vbulletin->options['avatarenabled'], "LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid = user.userid)");
}

there are also other plugins that go with this
login to your hosting control panel and open up PHPMySQL or similar
you have to ensure that the fieldname e.g. avatarid etc exists

or the other option who be to uninstall it and reinstall the mod
sometimes it resolves the issue

[I.G.O.T.A.]

I uninstalled it and reloaded it in and it stayed the same. When I log into my PHPMySQL what do I do?

[bremereric]

Phpdesk posted the following. Did you guys uninstall and reinstall the older version. I did and it's working fine.

https://vborg.vbsupport.ru/showpost....&postcount=121

[phpdesk]

Hi guys, you have the two versions of the mod, this is a free contribution, so feel free to suggest a merge between the two, and I'll be more than happy to include it into a new release.

[goshalim]

Hi Alex ( phpdesk )
Iam just wondering whyn none of you is to replying to my request !!!!

I cant wait any longer otherwise i will delete this addon.

Someone please can tell me what is going wrong and the username is shown twice next to the picture and also a part of the code is visable to the users?

thanks

[phpdesk]

Hi, goshalim,

I'll work on an update to fix the reported issues as soon as I get a moment, you can use 1.0.5a meanwhile.

[kevius]

and what about "sub-forum" bug ? any idear ?

[goshalim]

i did try 1.0.5 but still the same problem