Version: , by DR2000
Developer Last Online: Jun 2008
Version: 2.2.x
Rating:
Released: 11-13-2001
Last Update: Never
Installs: 18
No support by the author.
#### Subject Preview by DR2000 ####
I looked at all other hack avaliable for this, and all of them
are trying to do too much by editing your database structure,
and modifying the way data is inserted. Why overcomplicate
things, when all data is already there, and it only needs to be
extracted...
#### FEATURES ####
- Shows the subject of the last active post on the front page
- Shows the icon of the last active post on the front page
- No need to alter database, and risk to screwing something up
- Only one file to change
- If the subject was very long, shows trunkated version of it,
and replaces the rest with '...', preventing your main page
layout from being screwed up.
#### #### ####
Nov 14, 2001
#### #### ####
Note: Tested with 2.0.3, 2.2.0 and 2.2.1.
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
Originally posted by Alien So which one of these similiar hacks (between this and PPN's) uses the least amount of server resources and end user loadtime?
I had PPN's code, and it's great and all but you edit way to many files and it has no icons. With this hack you edit index.php then setup lastpostby template and boom you have yourself a thread title hack
If you use the default template change (the one I suggested), then with a shorter time format (24:00) it looks better. Otherwise your last post by takes up too much space. But that's only my opinion.
Installed it on my board running 2.2.0 and it works great. I noticed in the code that the max number of characters was set at 23 so I upped it. But I also saw a zero before that 23, what does that 0 control?
0 stands for the begging of string, so leave it. And you are right about 23. The title is being trunkated to 23 symbols. If you want to make it longer just change 23 to something else.
Originally posted by Syphin I cant get this to work on 2.2.1 for some reason... >_< it just wont show up... O.o
-Syphin
That's weird. The only file you edit is index.php and that didn't change from 2.2.0 to 2.2.1. Are you sure you have the forumhome_lastpostby template edited correctly?
I updated but it wasn't good enough, I had to instal lthat damn prefix hack and now I'm waitin for the creator to get back to me to fix his syntax error...
I tried using the hack with 2.2.0 and I got this when I loaded up the forum:
Database error in vBulletin 2.2.0:
Invalid SQL: SELECT forum.*, CASE WHEN icon.iconpath IS NULL THEN '' ELSE icon.iconpath END as icon, thread.title as thtitle FROM forum left outer join thread on thread.forumid = forum.forumid and thread.lastpost >= (forum.lastpost-30) LEFT OUTER JOIN icon ON icon.iconid=thread.iconid WHERE displayorder<>0 AND active=1 ORDER BY parentid,displayorder
mysql error: You have an error in your SQL syntax near 'WHEN icon.iconpath IS NULL THEN '' ELSE icon.iconpath END as icon, thread.title ' at line 1