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

[paulket]

Originally Posted by RedTurtle

This mod seems awesome but it's unfortunate that it doesn't work with sub forums.

The mod author hasn't posted in this thread for about 7 months now. I realize he must have a lot of other things to attend to but I'm wondering, is this plugin still supported?

+1. Hoping there will be an update that fixes the issue with sub forums... but no post by the creator of this mod for such a long time doesn't look good.

[Disco_Stu]

Seems like a very minor change to make this work for subforms but it's really up to the developer to release a change

[paulket]

I have absolutely no idea why but now I can see the last post avatar with my sub forums.

[Impromptu]

Originally Posted by kylek

Disabling it for now until the sub forum problem can be fixed, getting too many members complaining that someone elses avatar is showing as theirs. Otherwise this is a great feature. Any chance for a temporary fix on this in the meantime?

Originally Posted by New Joe

Same with me, hope it can be fixed

I have this issues too, ie 'someone elses avatar is showing as theirs'

Bit of a shame since a great mod

[flash84]

Excellent mod. It's working perfectly on VB4.2

[Harpo]

Originally Posted by flash84

Excellent mod. It's working perfectly on VB4.2

As long as you don't have sub forums. sure.

Uninstalled.

[L0pht]

can not see the bottom of this add-on changes in the forums?

[Adam H]

Anyone else had any problems with this mod conflicting with :

https://vborg.vbsupport.ru/showthread.php?t=271540

On the forum display something is conflicting which makes avatars on some users not show up. This is on the forum display only and not forum home .

When i disable "Hook Threadbit Query Fields & Joins" in this mods plugins everything goes back to normal .

[aryung]

was trying to add a random avatar for no avatar users not sure how i can achieve this adding a nicely hook into this one

for this i edited "functions_user.php"
original

PHP Code:

    // final case: didn't get an avatar, so use the fake one
    if (empty($userinfo['avatarurl']) AND $returnfakeavatar AND $vbulletin->options['avatarenabled'])
    { 
        $userinfo['avatarurl'] = vB_Template_Runtime::fetchStyleVar('imgdir_misc') . '/unknown.gif';
    } 


Here is my eidt

PHP Code:

if (empty($userinfo['avatarurl']) AND $returnfakeavatar AND $vbulletin->options['avatarenabled'])
    {
  $newavatar = rand(1,90);
  $userinfo['avatarurl'] = 'images/avatars/' .$newavatar. ".jpg"; 


(This assigns a random image from 1.jpg to 90.jpg)

can you help me please how can a do this under a hook instead of editing source file

[Nirjonadda]

Database error in vBulletin 4.1.10:

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.strike, thread.color,
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

, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadread.readtime AS threadread
, threadredirect.expires
, user.market_username_color AS last_color,
user.market_username_glow AS last_glow, thread.LAM_BanFromThread, post.pagetext AS previewhide, bop_ugroup.opentag as bop5_opentags, bop_ugroup.closetag AS bop5_closetags , thread.bop_global ,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 vbthread AS thread
LEFT JOIN vbuser AS user ON (user.userid = thread.lastposterid)
LEFT JOIN vbuserlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 3)
LEFT JOIN vbdeletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')

LEFT JOIN vbthreadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 3)
LEFT JOIN vbpost AS post ON(post.postid = thread.firstpostid)

LEFT JOIN vbthreadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
LEFT JOIN vbuser AS bop_user ON (thread.postuserid = bop_user.userid) LEFT JOIN vbusergroup AS bop_ugroup ON (bop_user.usergroupid = bop_ugroup.usergroupid)
LEFT JOIN vbuser AS uposter ON (uposter.userid = thread.postuserid)
LEFT JOIN vbcustomavatar AS customavatar ON (customavatar.userid = uposter.userid)
LEFT JOIN vbavatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vbcustomavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE thread.threadid IN (0,123421,164035,163423,163416,162902,163027,16340 9,162431,162433,162909,164006, 163993,163594,163415,159946,161244,162424,162945,1 62419,160385)
ORDER BY thread.sticky DESC, lastpost DESC;

MySQL Error : Not unique table/alias: 'customavatar'
Error Number : 1066
Request Date : Wednesday, January 30th 2013 @ 11:19:04 PM
Error Date : Wednesday, January 30th 2013 @ 11:19:05 PM