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

[bremereric]

Okay I installed your 1.1.1 version and it didn't have the default avatar option in the admin options. It also had some of the same avatars overriding others on another new post. I did not take screen shots of this. I rolled back to 1.0.5a version and got the default avatar back and they worked like a charm. Lost the option to move the avatar to the left though. I have attached screen shots of the 1.0.5a version installed.

[TheSupportForum]

Originally Posted by bremereric

Okay I installed your 1.1.1 version and it didn't have the default avatar option in the admin options. It also had some of the same avatars overriding others on another new post. I did not take screen shots of this. I rolled back to 1.0.5a version and got the default avatar back and they worked like a charm. Lost the option to move the avatar to the left though. I have attached screen shots of the 1.0.5a version installed.

i've had the same problem

i created a new forum/category
i was the first person to post in it, it decided to show a different users avatar and profile, this mod needs to be checked for errors in coding it seriously messed up my board showing the other guys avatar as the last peron who posted even though i was the only poster in that forum

[TheSupportForum]

current issues

Hook Forumbit Query Fields & Joins

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)");
}

[goshalim]

Originally Posted by goshalim

Hi , this is a very nice mod , good job man !!

I have only a small problem which iam sure that you will help me to solve it.
Please see the link from my web site.

The user name is shown twice and also a part of the code.

http://www.canarybreeder.net/up/forum/forum.php

Please i really need some help here ............

[bulldog51981]

Originally Posted by bada_bing

Here is the full error

Database error in vBulletin 4.1.9:

Invalid SQL:

		SELECT 
			IF(votenum >= 1, votenum, 0) AS votenum,
			IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
		 post.pagetext AS preview,thread.firstpostid, post.pagetext AS thumb,
			thread.threadid, thread.title AS threadtitle, thread.forumid, thread.pollid, thread.open, thread.postusername, thread.postuserid, thread.iconid AS threadiconid,
			thread.dateline, thread.notes, thread.visible, thread.sticky, thread.votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
			thread.prefixid, thread.taglist, thread.hiddencount, thread.deletedcount,
			user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend,
			user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible
			, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
			, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
			
			, threadredirect.expires
			,IF(customavatar.userid, 1, 0) AS useavatar, user.avatarrevision
, user.avatarrevision AS avatarrevision, thread.lastposterid AS userid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
		FROM thread AS thread
			LEFT JOIN user AS user ON (user.userid = thread.lastposterid)
			LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 1)
			LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
			 LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
			
			LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
			
			LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
			
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = thread.postuserid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
		WHERE thread.threadid IN (0,7,1) 
		ORDER BY thread.sticky DESC, lastpost DESC;

MySQL Error   : Not unique table/alias: 'customavatar'
Error Number  : 1066
Request Date  : Wednesday, January 11th 2012 @ 01:07:59 PM
Error Date    : Wednesday, January 11th 2012 @ 01:07:59 PM
Script        : http://www.mysite.com/forums/forumdisplay.php?2-mysite-com-Announcements
Referrer      : http://www.mysite.com/forums/forum.php
IP Address    : 67.59.x.x
Username      : adminaccount
Classname     : vB_Database
MySQL Version : 5.0.90-community-nt

I upgraded to ver 1.1.1 last night and didn't realize it until this morning but I am getting the same error on Sub Forums only. Reverted back to 1.0.5a and problem solved. Will upgrade again after issue is fixed.

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

I just upgraded forum to 4.1.10 and now my avatars are not lining up like they where on 4.1.8. Any got any ideas?

[kfyonur]

same database problem.

[TheSupportForum]

Originally Posted by IGOTASTi

I just upgraded forum to 4.1.10 and now my avatars are not lining up like they where on 4.1.8. Any got any ideas?

Originally Posted by kfyonur

same database problem.

its a plugin issue

look at the plugins you will see references to the database fieldnames
they may of changed in 4.1.10

details below on which one to check

Hook Forumbit Query Fields & Joins

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)");
}

[kevius]

Originally Posted by Fready

Found a bug/problem.
On the Forums Home, say you have Sub-Forums, if a poster posts on a Thread in the Sub-Forum it doesn't show their av on the Forums Home, it will show the av of the last poster within the main Forum not the Sub Forum even though the last post showing on the Forums Home is from the Sub Forum.
Hope you understand what I mean.

Hi there, i've got the same problem too !

Can anybody help us to resolve this bug with sub-forum ?

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

Originally Posted by simonhind

its a plugin issue

look at the plugins you will see references to the database fieldnames
they may of changed in 4.1.10

details below on which one to check

Hook Forumbit Query Fields & Joins

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)");
}

So how do I fix this?