Forum Display Enhancements - Alternate Last Post Display

Alternate Last Post Display
By: Idan B.

1. Description & Usage:
Alternate Last Post hack will allow the forum admin to make the "Last Post" column on forum look different (have another/better layout):
Hack will make it with user avatar picture & instead of showing post date, it will show "time diff" since the post (for example: 4 Hours, 5 Minutes ago") - See pictures in attachment for better understanding. :up:
This Hack can be enabled on both Forum Home & forum Display or Forum Display Only.
The hack was develop for request of Theater (request was made here: https://vborg.vbsupport.ru/showthread.php?t=214212 )
I assumed this request might be "handy" to other users of community, so developed it to be a fully working modification.

2. Installation:
Please click Mark as Installed.
Installation is pretty easy - just download & install:

• Extract zip for product xml & no-avatar picture.
• Goto: AdminCP->Plugin System->Manage Products : Choose "Add/Import Product" and import this product xml (product-alt_last_post.xml)
• Upload the "anonymous_avatar.gif" file onto /images/avatars/ directory. If testing it on your develop board, be sure to upload there as well.

3. Upgrade From Older Version:
1. uninstall previous version
2. Download new version xml & install as instructed in previous section.

4. Configuration:
Once installed, the "Vbulletin Options" under admincp will have extra section:
Section name: "Alternate Last Post Display"

• Enabled ? - Yes/No (default YES)
• Enable on Forum Home ? - Yes/No (default NO)
• Enable on Forum Display ? - Yes/No (default YES)
• Use "Last Post" text as title ? - Yes/No (default YES)
• Show differential time ? - Yes/No (default YES)
• Align "Never" to LEFT ? - Yes/No (default YES)
• Use profile picture instead of avatar ? - Yes/No (default NO)
• Picture width - INT (default: 40)
• Picture height - INT (default: 40)
  

5. Known Bugs:

• Forum Tabbbed modification has known competability with this mod - result it is not showing on forumhome. Currently debugging this one to allow fix on next version.
• v1.1.4 released. Since v.1.1.0 code was re-writeen completely from "scratch" and now it should support multi-languages (other than english) ! Note: Cyrillic & Latin chars reported to have some issues, still under check)
• See changelog below for full description of stuff fixed.

6. TO-DO's LIST (Next Versions):

• Allow thread view option on admincp.
• Other mods (such as Forum Tabbed Modification) conflict fixes - under checking !.
• [S]Admincp option to set avatar width/height.[/S] added in v.1.1.4
• [S]Admincp option to select between profile and avatar picture.[/S] added in v.1.1.4

NOTE: Currently supported format chars for date/time (v1.1.4) are :
Date: "j","d", "m", "n", "F", "M", "Y", "y","S"
Time: "h", "H", "g", "G", "i", "s", "a", "A".
Any other chars will result with Post Time: N/A displayed !

NOTE: i've left v1.1.3 and added in addition the v1.1.4, just in case anyone has problem, he can download old version & rollback.

Enjoy hack & dont forget to click Mark as Installed

[dancue]

question about the image sizes.

If I place a value for height and nothing for width will it automatically keep it's original ratio?

[IdanB]

Originally Posted by dancue

question about the image sizes.

If I place a values for height and nothing for width will it automatically keep it's original ratio?

No. according to feedback & common sense, my initial assumption was that for "esthetic reasons" users would want all pics to have same width & height, else result isnt looking nice (it's really matter of original avatar dimensions).

[IdanB]

Originally Posted by dancue

Same here.

I've flushed my cache through vboptimise and still not aligning to the left.

ok, i'll try to find source of problem & fix it.
Pretty much the major difference between 1.1.3 to 1.1.4 is i'v taken the replaced html from plugin code to template, but wierd thing is the "left align" is still same code as version 1.1.3, and it's defined on plugin code.

Can you try to set "left align" to NO, save settings, then set to YES & save again ?
Perhaps since options number are not the same as previous version, the db still has different value for these & needs to be updated.

[pet0etie]

last night i had the forum crashing after installing this plugin (so nobody could consult the main forum page)

on our forum we have a user called "/!\K.v.K./!\Boechie/!\" who has posted in a thread ... being the last one to post, his name, avatar and posting time is (should be) displayed on the index-page

but ... when i check your code u are using this query :

$q_text = "SELECT userid, avatarid, avatarrevision  FROM `" . TABLE_PREFIX . "user` WHERE username = \"".$lastpostinfo[lastposter]."\"";

putting in the name of "/!\K.v.K./!\Boechie/!\" into that query i get :

$q_text = "SELECT userid, avatarid, avatarrevision  FROM `user` WHERE username = \"/!\K.v.K./!\Boechie/!\\"";

your query is getting 'screwed up' because he sees the last \ of the name "/!\K.v.K./!\Boechie/!\" as an escape-character

shouldn't the query be changed towards this query ?

$q_text = "SELECT userid, avatarid, avatarrevision  FROM `" . TABLE_PREFIX . "user` WHERE username = \"". $vbulletin->db->escape_string($lastpostinfo[lastposter]) ."\"";

thanks for looking up / solving the problem

pet0etie

[IdanB]

Originally Posted by pet0etie

last night i had the forum crashing after installing this plugin (so nobody could consult the main forum page)

on our forum we have a user called "/!\K.v.K./!\Boechie/!\" who has posted in a thread ... being the last one to post, his name, avatar and posting time is (should be) displayed on the index-page

but ... when i check your code u are using this query :

$q_text = "SELECT userid, avatarid, avatarrevision  FROM `" . TABLE_PREFIX . "user` WHERE username = \"".$lastpostinfo[lastposter]."\"";

putting in the name of "/!\K.v.K./!\Boechie/!\" into that query i get :

$q_text = "SELECT userid, avatarid, avatarrevision  FROM `user` WHERE username = \"/!\K.v.K./!\Boechie/!\\"";

your query is getting 'screwed up' because he sees the last \ of the name "/!\K.v.K./!\Boechie/!\" as an escape-character

shouldn't the query be changed towards this query ?

$q_text = "SELECT userid, avatarid, avatarrevision  FROM `" . TABLE_PREFIX . "user` WHERE username = \"". $vbulletin->db->escape_string($lastpostinfo[lastposter]) ."\"";

thanks for looking up / solving the problem

pet0etie

Yes, you are correct.
I'll have it fix on upcoming revision. Thanks for the heads up.

[nascartr]

Would love to use this, has anyone found a fix for the Tabbed Forum Home mod? Thanks!

[goxy63]

not working with this mod
"Hide Last Post Date For Guests"
https://vborg.vbsupport.ru/showthrea...88#post1851088

Any suggestions, or even better making this mod working with mentioned one?

Thanks

[IdanB]

I've been busy last few weeks with coding/re-lunch of vBHackers community. Once that goes live & behind me (soon enough) i'll try to address these open issues.

[nascartr]

Thanks for the reply!

[TheLastSuperman]

I modified it a bit and have it working w/ the Forum Home Tabs mod by Bobster65!

Only setback.. which I thought was posted previously while reading this mods thread earlier is custom avatars are not showing...

We upload then create custom avatars, several categories and let our users select them... only problem is (even before I modified to work w/ the tabs) with the product installed and enabled to show on forumdisplay only it will show the "dummy" avatar but not the user selected one... if I enable to show custom profile pic it works but I need our admin defined but user selected Avatars to display... I need help with this. If you don't come on here by later tonight I might join on your site and PM if not it will be first thing in the morning... then we can have it updated to fix that as some may not have my problem and can benefit from the update.

Ok, I have some unfinished work to go do so installed but disabled for now until I find time to get it working with the custom avatars we let our members choose from.

S-MAN