[TUT]Latest Topics On Portal

[Lease]

IPB 2.1.x.

How to make the latest topics block on the IPB Portal show the topics in order of when the last post was made, and show who made the last post!

Go into FTP and download: forums/sources/portal_plugins/recent_topics.php

FIND:

$this->ipsclass->DB->simple_construct( array( 'select' => 'tid, title, posts, starter_id as member_id, starter_name as member_name, start_date as post_date, views',
                                                      'from'   => 'topics',
                                                      'where'  => "$qe approved=1 and state != 'closed' and (moved_to is null or moved_to = '')",
                                                      'order'  => 'start_date DESC',

REPLACE WITH:

$this->ipsclass->DB->simple_construct( array( 'select' => 'tid, title, posts, last_poster_id as member_id, last_poster_name as member_name, last_post as post_date, views',
                                                      'from'   => 'topics',
                                                      'where'  => "$qe approved=1 and state != 'closed' and (moved_to is null or moved_to = '')",
                                                      'order'  => 'last_post DESC',

Thats it, pretty straight forward!

Edited by 3DKiwi

Fabulous little modification. However the link takes you to the very first message. Thankfully another member came to my rescue and you can make the link in the recent reply go to the last reply as you would normally want. The following solution supplied by putermom:

It's a skin edit.
Go to your Admin ACP > Look and Feel > Pick a Skin > Edit Template HTML >
IPB Portal > tmpl_topic_row

Find this link:

<b><a href="http://resources.invisionpower.com/index.php?appcomponent=cms&module=articlesshowtopic=$tid">$title</a></b>

and Replace it with:

<b><a href="http://resources.invisionpower.com/index.php?appcomponent=cms&module=articlesshowtopic=$tid&amp;view=getlastpost">$title</a></b>

Update for 2.2. The first part is just the same as it was in 2.1 but the edit to make the link take you to the last post has changed slightly.

Find this link:

<b><a href="{$this->ipsclass->base_url}showtopic=$tid">$title</a></b>

and replace with:

<b><a href="{$this->ipsclass->base_url}showtopic=$tid&view=getlastpost">$title</a></b>

Do that with all of your skins.

Lease Reviewed by Lease on 13th Jan 2008. [TUT]Latest Topics On Portal IPB 2.1.x. How to make the latest topics block on the IPB Portal show the topics in order of when the last post was made, and show who made the last post! Go into FTP and download: forums/sources/portal_plugins/recent_topics.php FIND: $this->ipsclass->DB->simple_construct( array( 'select' => 'tid, title, posts, starter_id as member_id, starter_name as member_name, start_date as post_date, views', 'from' => 'topics', Rating: 5