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

[SoHelpMe]

Originally Posted by findingpeace

Well, I finally figured out the subforum thing. Requires code edits, as there aren't any hooks nearby. Open up /includes/functions.php

Find:

$threadinfo = array(

Add in your avatar variables like below (be careful with commas!)

					$threadinfo = array(
						'title'    => $lastpostinfo['lastthread'],
						'threadid' => $lastpostinfo['lastthreadid'],
                                                'avatardateline' => $lastpostinfo['avatardateline'],
                                                'hascustomavatar' => $lastpostinfo['hascustomavatar']

Then you can simply call these variables in a forumhome plugin like so:

$lp_dateline = $lastpostinfo['avatardateline'];
$lp_userid = $lastpostinfo['userid'];
$hascustomavatar = $lastpostinfo['hascustomavatar'];

You can even do this without the forumhome plugin just by getting the variables from template. (Still need the query plugin, of course).

Best of luck!

I have been thinking about picking up this app and installing it but I have been a bit concerned to get it and load it based on it requiring source code edits to work correctly. Findingpeace have you considered making the required posts and updating the source code posted on this thread? From what I have seen elsewhere on other non supported mods you don't have to take over sustaining ownership but you could make an incremental improvement. I hope you consider making tha changes and reposting the files... Thanks

[concepts]

Works amazing for me on 4.2.2, great Mod!

[Manoel J?nior]

Error vB 4.2.3 Beta 3

Database error in vBulletin 4.2.3 Beta 3:

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.userid,
			user.membergroupids, user.infractiongroupids, 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
			, usergrouphasann.opentag as opentaghasann, usergrouphasann.closetag AS closetaghasann, usergrouphuseyinn.opentag AS opentaghuseyinn, usergrouphuseyinn.closetag AS closetaghuseyinn,IF(customavatar.userid, 1, 0) AS useavatar, uposter.userid AS useravatarid, uposter.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 user AS userhasann ON ( userhasann.userid = thread.postuserid )  LEFT JOIN usergroup AS usergrouphasann ON ( usergrouphasann.usergroupid = userhasann.usergroupid )  LEFT JOIN user AS userhuseyinn ON ( userhuseyinn.userid = thread.lastposterid )  LEFT JOIN usergroup AS usergrouphuseyinn ON ( usergrouphuseyinn.usergroupid = userhuseyinn.usergroupid ) 
LEFT JOIN user AS uposter ON (uposter.userid = thread.postuserid)
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = uposter.userid)
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,1104,1103,1108,1123,1101,1110) 
		ORDER BY thread.sticky DESC, lastpost DESC;

MySQL Error   : Not unique table/alias: 'customavatar'
Error Number  : 1066

[Ang3ls]

how to I can show Avatar in mobile Style?
Thank you very much!

[tanzeelniazi]

Hello all today install last post avatar but its not showing correctly
I want this type


Mine showing is this


See first avatar showing after Last post icon is showing and name is showing below so i want above pic like this
hope all understand
My skin is Ideal VB Black

Also How to Turn Off last post icon ???
if i use last post avatar and showing avatar and last post icon looking bad so i want to turf off last post icon

[Tibiaspy]

Originally Posted by findingpeace

Well, I finally figured out the subforum thing. Requires code edits, as there aren't any hooks nearby. Open up /includes/functions.php

Find:

$threadinfo = array(

Add in your avatar variables like below (be careful with commas!)

					$threadinfo = array(
						'title'    => $lastpostinfo['lastthread'],
						'threadid' => $lastpostinfo['lastthreadid'],
                                                'avatardateline' => $lastpostinfo['avatardateline'],
                                                'hascustomavatar' => $lastpostinfo['hascustomavatar']

Then you can simply call these variables in a forumhome plugin like so:

$lp_dateline = $lastpostinfo['avatardateline'];
$lp_userid = $lastpostinfo['userid'];
$hascustomavatar = $lastpostinfo['hascustomavatar'];

You can even do this without the forumhome plugin just by getting the variables from template. (Still need the query plugin, of course).

Best of luck!

I can do the whole edit file thing no problem but I don't get what should I do next? What is forumhome plugin? Where do I put all this stuff?

Developer is long gone, is anyone willing to repair this bug for him? This is very nic plugin but with subforums not working it's not usable atm :/

[ku-med]

Originally Posted by tanzeelniazi

Hello all today install last post avatar but its not showing correctly
I want this type


Mine showing is this


See first avatar showing after Last post icon is showing and name is showing below so i want above pic like this
hope all understand
My skin is Ideal VB Black

Also How to Turn Off last post icon ???
if i use last post avatar and showing avatar and last post icon looking bad so i want to turf off last post icon

I've the same problem

To remove last post icon -> edit the following template [ forumhome_lastpostby ]

find and remove:

<vb:if condition="$show['icon']"><img src="{vb:raw icon.iconpath}" class="postimg" alt="{vb:raw icon.title}" border="0" /></vb:if>

[kikaclub]

Originally Posted by findingpeace

Well, I finally figured out the subforum thing. Requires code edits, as there aren't any hooks nearby. Open up /includes/functions.php

Find:

$threadinfo = array(

Add in your avatar variables like below (be careful with commas!)

					$threadinfo = array(
						'title'    => $lastpostinfo['lastthread'],
						'threadid' => $lastpostinfo['lastthreadid'],
                                                'avatardateline' => $lastpostinfo['avatardateline'],
                                                'hascustomavatar' => $lastpostinfo['hascustomavatar']

Then you can simply call these variables in a forumhome plugin like so:

$lp_dateline = $lastpostinfo['avatardateline'];
$lp_userid = $lastpostinfo['userid'];
$hascustomavatar = $lastpostinfo['hascustomavatar'];

You can even do this without the forumhome plugin just by getting the variables from template. (Still need the query plugin, of course).

Best of luck!

not working... and this

$threadinfo = array(

is not in functions.php

[keyla31]

looked like it worked on 4.2.2 Patch Level 4 but upon entering forums received database error page, uninstalled

[ku-med]

Originally Posted by keyla31

looked like it worked on 4.2.2 Patch Level 4 but upon entering forums received database error page, uninstalled

Works great for me on 4.2.2 pl 4 .. anyway might this work for ya ->
https://vborg.vbsupport.ru/showthread.php?t=268618