Last thread with last post icon instead of clear image

(The creator of the original hack is DR2000; I have since then modified it further)

Here's the hack in a handy dandy text file:

Hack:lastthreadlastposticon.txt

It is incredibly simple...you need only edit one file and one template! It can be done in a couple minutes!

###Features###

- Shows the thread name of the last active post on the front page
- Shows the lastpost.gif icon for the theme you're using, instead of either A, using a clear (invisible) image, or using the default lastpost.gif image for the lastpost icon
- If the subject is long enough to start stretching the field on the index page, it'll show a shrinked version (i.e. "I need help with version.....).

Note: This has only been tested on version 2.2.1!

To see it in action, just visit www.ConsoleBoards.com !

[Island Roots]

Hmmm...are you sure you don't have any other hacks that have effected that line or need that line in order to function properly? This has been installed numerous times at my forums as well as at other vB forums, so it isn't an error in the hack. Try it again.

[epic]

no any other hacks !

[Lesane]

[QUOTE]Originally posted by epic
when i install this hack i got a error at this line

$forums=$DB_site->query('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');

no other info.Can u help me?

[Lesane]

hmm.. somehow the forum dont shows \ \ in the code.

Epic, change in the select code in index.php this:

PHP Code:

THEN '' 


to:

THEN \ ' \ '

(without spaces)

[epic]

[QUOTE]Originally posted by Lesane
hmm.. somehow the forum dont shows \ \ in the code.

Epic, change in the select code in index.php this:

PHP Code:

THEN '' 


to:

THEN \ ' \ '

(without spaces)

[LeThaLNjEcTiOn]

Nice Hack. How do I get to my index.php file to make the changes?? My friend installed my vbulletin for me and I am just learning the ins and outs of the thing myself. Also, does this hack work for php3, I think that was the problem we had when we tried to install a version of this a while back. Where do I got to find the .php3 files to edit them??

~LeThaLNjEcTiOn

[Sadie Frost]

Well, I am just learning as well, but here's how I do it. You need an FTP program, and using that you have to download the user.php file to your computer, then open it using a text editor (ie Notepad - don't use Word as I just did and it screwed up my files! lol)

Make the changes in the instructions, and then re-upload the file.

Also be sure to make a backup copy of the file before you make changes to it.

I think (but I'm sure someone else could tell you better) for php3 you just rename file extensions to "php3"

Hope that helps!

[Lesane]

[QUOTE]Originally posted by epic


This has a db error!

[Island Roots]

Hmmm...are you sure you are running 2.2.1? As I stated in the file, it has only been tested on 2.2.1.

[epic]

[QUOTE]Originally posted by Lesane


Epic, try to change the select code in index.php to:

PHP Code:

$forums=$DB_site->query('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');