Customizing SMF > Modifications and Packages

Recent Topics On "Recent Posts" Page

<< < (4/19) > >>

Nathaniel:
@akyhne,
No, the idea is that it shows a list of the lastest topics that have been posted (thus it shows the first post), not the lastest updated topics. It could however be edited so that it shows the lastest post, or even the 'Most Recently Updated Topics' instead of the 'Most Recent Topics'. I could post the edits if you want, although I will need to know your SMF version.

Akyhne:
People are using the most recent posts to view the most recent posts. I think your mod is great because it "hides" all new posts in a topic. I have a forum with a high post count (1.1.6) and people are complaining that there are to many posts to read in the most recent posts.
 
But they can't use the first post to anything, only the latest. So it would be great if you made the mod to show the latest, or even an option in admin part to choose wether it should show the most recent post of the topic or the first post.
 
I'll take your code with open arms.
 
Aky

Nathaniel:
Open up your 'Recent.php' file, find the code below:

--- Code: ---   $request = db_query("
      SELECT m.ID_MSG
      FROM ({$db_prefix}messages AS m, {$db_prefix}topics AS t, {$db_prefix}boards AS b)
      WHERE b.ID_BOARD = m.ID_BOARD
         AND m.ID_MSG = t.ID_FIRST_MSG
--- End code ---

Replace with this code:

--- Code: ---   $request = db_query("
      SELECT m.ID_MSG
      FROM ({$db_prefix}messages AS m, {$db_prefix}topics AS t, {$db_prefix}boards AS b)
      WHERE b.ID_BOARD = m.ID_BOARD
         AND m.ID_MSG = t.ID_LAST_MSG
--- End code ---

Please note, that its still just showing a list of the most recent topics, just with the last post instead of the first post, the edit will be slightly different if you want the 'Most Recently Updated topics'.

Akyhne:
Hmm, it must be the 'most recently topics' I'm looking for.

What my users requires is this:
When they visit the "recent posts", they get all the posts. So if a topic has 10 new posts, they are shown. They just want the latest post shown from each topic.

Nathaniel:
Thats odd, the code I posted should actually work. It should show the lastest posts, but only the lastest from each topic.... Its amazing what you can archieve by changing a single part of an SQL query. ;)

Navigation

[0] Message Index

[#] Next page

[*] Previous page