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.
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...
Er, what wasn't good enough, and what syntax error are you speaking off? I'm not aware of any.
Er, what wasn't good enough, and what syntax error are you speaking off? I'm not aware of any.
lol sorry two different things, the I got mine working is to you. The other statement was personal problems, I was making a remark to the fact I tried to install this Prefix hack and it caused me a lot of trouble. Your hack and the prefix hack were the last 2 I was installing of the 20+ that were in already... Thanks the hack worked great no complaints!
Can someone please help me? Again, I installed the hack and all on 2.2.0, but I got this error when I went to my 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
Originally posted by Sufian Can someone please help me? Again, I installed the hack and all on 2.2.0, but I got this error when I went to my 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
Eh, don't know what you did wrong. Make sure when you were inserting lines, you didn't insert any extra line breaks... That's the only thing I could think of at this moment. Maybe some one else will have an idea where you did wrong.
i know its just a index.php and templete hack... And trust me, ive tried it on 4 diffrent boards...
Ive copy and pasted, and typed it in myself.... for some damn reason it wont work... >_< lol