Detailed Latest Posts - Version 2

I finally got around to addressing some issues with the 'Detailed Latest Posts' hack I posted last year. This version uses a cron file to generate and cache the required data, saving your index from having to do all the work. This should also reduce the cpu load on large boards since the timing of the update is now controlled by the cron task. This has been tested and is live on my own board. Full instructions for installation are included in the download. For a demo please visit my board via the homepage listed in my profile.

All comments, suggestions, and other related discussion are welcome. Please inform me immediately upon discovering an error, either with the hack or the documentation.

[alderwazeh]

Honestly this is very nice hack and before saying that your site is even nicer ..decent design and layout ..and the hack looks like a super star in this romantic sky..great work although the hack is rather complicated in installation but this coding having said though deserve it. thanks a lot.

[Albus]

Originally Posted by alderwazeh

Honestly this is very nice hack and before saying that your site is even nicer ..decent design and layout ..and the hack looks like a super star in this romantic sky..great work although the hack is rather complicated in installation but this coding having said though deserve it. thanks a lot.

Thanks for the kind words. It's not that difficult to install really. There's two arrays you have to add one item too, one template to edit, one to create, one cut-n-paste, one upload, setup some vbphrases and some tasks, and that's it. Is there a way I could've made my instructions read better perhaps? Of course, I'm going to try and have an installer by the time all intended features are worked in.

[lasto]

so if someone replys to a new thread or post it dont auto update on the stats till the cron job is run is that correct ?

[Albus]

Originally Posted by lasto

so if someone replys to a new thread or post it dont auto update on the stats till the cron job is run is that correct ?

That is correct. It may not be realtime, but it saves a ton of cpu load, especially for large boards.

[TTG]

Great hack .. clicked install.

How can I exclude certain forum ID's from being shown on the updated list.
I have 4 categorys that provide RSS news feeds and don't want those to appear.

[Albus]

Originally Posted by TTG

Great hack .. clicked install.

How can I exclude certain forum ID's from being shown on the updated list.
I have 4 categorys that provide RSS news feeds and don't want those to appear.

Edit /includes/cron/detailedlatestposts.php and add the following...

PHP Code:

        and
        f.forumid not in (1, 2, 3, 4) 


...so that it reads...

PHP Code:

$dlp_query = "
    select 
        t.threadid,
        t.title as threadtitle,
        f.forumid,
        f.title as forumtitle,
        t.postuserid,
        t.postusername,
        p.username,
        t.replycount,
        t.views
    from
        " . TABLE_PREFIX . "thread as t
        left join " . TABLE_PREFIX . "forum as f on f.forumid = t.forumid
        left join " . TABLE_PREFIX . "post as p on p.dateline = t.lastpost and p.threadid = t.threadid
        left join " . TABLE_PREFIX . "deletionlog AS d ON d.primaryid = t.threadid and d.type = 'thread'
    where
        t.open = '1'
        and
        t.visible = '1'
        and
        d.primaryid is null
        and
        f.forumid not in (1, 2, 3, 4)
    order by
        t.lastpost desc
    limit $dlp_limit
"; 


...replacing 1, 2, 3, and 4 with your four values. Let me know if this does not do the trick.

[EDIT]

Just make sure that whatever ID''syou use are for the forums the posts directly reside in, and not a parent forum, or one that is marked as no-post.

[TTG]

Thanks Albus .. that solved it

[Albus]

Originally Posted by TTG

Thanks Albus .. that solved it

Looks good on your cafe too. Personally, I think I'd switch the alt class used though. Your darker color might look better.



Expect a minor update either tonight or tomorrow that will add this feature as a variable and one or two minor xhtml url goofs. You can change these manually if you wish. In the forumhome_latestpostbits template, there are some urls that use & instead of & .

[Albus]

Originally Posted by Albus

Looks good on your cafe too. Personally, I think I'd switch the alt class used though. Your darker color might look better.



Expect a minor update either tonight or tomorrow that will add this feature as a variable and one or two minor xhtml url goofs. You can change these manually if you wish. In the forumhome_latestpostbits template, there are some urls that use & instead of & .

Just a quick update...

I am going through a major overhaul, both in format and concept, of my forum. Until that is complete, I am putting further development of this on hold. Please be patient with me during this time. I will post the update mentioned earlier shortly after the renovation is complete.

Thanks.

[Piratos]

any Demo!!!
Please