Latest Thread (in index and forumdisplay)

This hack will add the latest thread in index.php and forumdisplay.php files, above the date and time of each forum latest post.
[HIGH]There is no need to alter any table and also, it adds only one query.[/HIGH]

ESTIMATED INSTALL TIME: 2 minutes
TESTED IN VERSION: 2.2.5

[HIGH]NOTE:[/HIGH] As a thank you for using my hack, please click on the [HIGH]INSTALL[/HIGH] button. You will receive updates in your email, whenever I add new features to it and it will let me evaluate better the quality of my hacks.
Also post a reply with your comments. Your oppinion is important to me.

[high]UPDATE[/high]
After the evaluation made by FireFly and PPN, we all came to the conclusion that this hack is reliable ONLY if it's used on medium or small boards. Busy boards SHOULD install PPN's hack.
I requested to have this hack removed from the database, but I guess FireFly is right. The code is still good and it will bring your board to it's knees only if you have alot of forums and ALOT of members browsing to them.

To download the latest version of this hack, click below:

[TECK]

i cannot answer you on this firefly. as you know, i do all my hacks on localhost. before i posted the hack, i had Zzed testing it. wooolF also test it on his board. he usually have over 100 members online.

can you please explain us why you think the query is not reliable?
maybe you could try it only temporarely at vB.org just to see it's stability. thanks.

[Scott MacVicar]

I'll try it on my local board, has alot of forums on the forum home and 90,000 posts should be ok for a test.

See if it brings my computer to its knees

[TECK]

thanks PPN. i'm curious to find out the results.

[adtestvb]

its not showing anything i had all the code the install file said to find. edited the index and forumdisplay and the template

i tried it on 2.2.2 and 2.2.5

[Admin]

BTW what's the purpose of this code?

(forum.lastpost-forum.daysprune)

You don't need to substract daysprune from it, the units are not even the same (lastpost is in UNIX time stamp, daysprune is a number of days).

[TECK]

firefly, i tried this:

PHP Code:

LEFT JOIN thread ON (thread.forumid=forum.forumid AND thread.lastpost=forum.lastpost) 


and i encountered one problem:
if the post is made other then today, it will not show. so i went with the logic and added a value to the default days that the forum is pruned.

this is the only way i could think of it. let me know if you have in mind something that will pull the trick better.

[Admin]

Using = is just fine.

[Chris M]

@nakkid - Does this provide a link to the Topic itself, or is it just the name and who created it?

Other than that question, great hack...

Satan

[TECK]

i try it.. it didn't work well on wooolF's live board, but it did ok on my local one.
so you recommend me to keep the query like this?

$forums=$DB_site->query('SELECT forum.*, thread.title AS threadtitle FROM forum LEFT JOIN thread ON (thread.forumid=forum.forumid AND thread.lastpost=(forum.lastpost-forum.daysprune)) WHERE displayorder<>0 AND active=1 ORDER BY parentid,displayorder');

let me know please.

satan, it doesnt provide a link to the thread because it would add extra queries, wich is not recommended on a large board. i think the link to the latest post will do just fine. the title of the post is more informative, for the users to see what is going on in that forum.
let us know what you think.

[Chris M]

Ok will do...

I'll get back to you after I see how the guys like it...

Satan