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

[phpdesk]

The quoted error message seems to be cut and does not include the actual note related to the error. Would it be possible to post the full error message so that I could track it down?

Either way, I have reuploaded the previous version of the mod for those of you having issues with v1.1.1.

Thanks.

Originally Posted by bada_bing

I have uninstalled this mod because it it not working with vb 4.19 it give a database errro

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 de

[sadiq6210]

Originally Posted by phpdesk

The quoted error message seems to be cut and does not include the actual note related to the error. Would it be possible to post the full error message so that I could track it down?

Either way, I have reuploaded the previous version of the mod for those of you having issues with v1.1.1.

Thanks.

What about this?
https://vborg.vbsupport.ru/showpost....&postcount=115

Thanks

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

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.
Check it out and test it with a Forum which has a Sub Forum to it.

I have the same problem. I'm on 4.1.8

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

Is there a way to fix this issue?

[garybrun]

works ok for me in 4.19a
http://Www.minelabowners.com

[bada_bing]

Originally Posted by phpdesk

The quoted error message seems to be cut and does not include the actual note related to the error. Would it be possible to post the full error message so that I could track it down?

Either way, I have reuploaded the previous version of the mod for those of you having issues with v1.1.1.

Thanks.

That is the exact copy and past of the error message I get this this plugin enabled

[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

[chiggy]

Hey Bro U Done Great Job Installed And Working Perfectly And Realy I Like Your Mod And Ur Work
This Modification Give My Forum Something Good Look Bcoz My All Forum Members Almost Using GIF Animated Avatars And In Home Page Its Looking Coolll Man Than You Very Much...... U R The Man
My Side +1000 For You.

[bada_bing]

Originally Posted by phpdesk

The quoted error message seems to be cut and does not include the actual note related to the error. Would it be possible to post the full error message so that I could track it down?

Either way, I have reuploaded the previous version of the mod for those of you having issues with v1.1.1.

Thanks.

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

[bremereric]

Will this hack also grab pre-defined avatars or only the one's that members have uploaded?