Tip for SMF 2.1: Add 'Start Date' to Message Index Sorting

[GL700Wing]

In response to this request to Order topics by date started for SMF 2.1 from @Steve ...

In ./Sources/MessageIndex.php
Find:

Code Select Expand

'starter' => 'COALESCE(memf.real_name, mf.poster_name)',Add After:

Code Select Expand

'date' => 'mf.poster_time',
Find:

Code Select Expand

'starter' => 'JOIN {db_prefix}messages mf ON (mf.id_msg = t.id_first_msg)
LEFT JOIN {db_prefix}members AS memf ON (memf.id_member = mf.id_member)',Add After:

Code Select Expand

'date' => 'JOIN {db_prefix}messages mf ON (mf.id_msg = t.id_first_msg)
LEFT JOIN {db_prefix}members AS memf ON (memf.id_member = mf.id_member)',
Find:

Code Select Expand

$txt['starter'] = $txt['started_by'];Add After:

Code Select Expand

$txt['date'] = $txt['topic_start_date'];
In ./Themes/default/MessageIndex.template.php
Find:

Code Select Expand

<div class="info">', $context['topics_headers']['subject'], ' / ', $context['topics_headers']['starter'], '</div>Replace With:

Code Select Expand

<div class="info">', $context['topics_headers']['subject'], ' / ', $context['topics_headers']['starter'], ' / ', $context['topics_headers']['date'], '</div>
Find:

Code Select Expand

', $txt['started_by'], ' ', $topic['first_post']['member']['link'], 'Replace With:

Code Select Expand

', $txt['started_by'], ' ', $topic['first_post']['member']['link'], ' ', $txt['on'], ' ', $topic['first_post']['time'], '
In ./Themes/default/languages/index.english.php
Add to end of file:

Code Select Expand

$txt['topic_start_date'] = 'Date Started';
You cannot view this attachment.

[Steve]

Thanks @GL700Wing. 

[Steve]

Any chance of making this a mod?

[GL700Wing]

Any chance of making this a mod?

Done - 'Topic Start Date on Message Index' mod for SMF 2.0 and 2.1 submitted for approval.

[Steve]

You're awesome! 

[Doug Heffernan]

This is a neat tip. Thanks for sharing it and making it into a mod too.

[Steve]

If I wanted it to not display the time, and still use time as one of it's sorting parameters, would I just remove [time] from Themes/default/MessageIndex.template.php?

[GL700Wing]

If I wanted it to not display the time, and still use time as one of it's sorting parameters, would I just remove [time] from Themes/default/MessageIndex.template.php?

Yes - you wouldn't make the second code change to ./Themes/default/MessageIndex.template.php

That said, I've had this implemented on my SMF forum for many years - one of which is more than 20 years old - and I find it useful/interesting to know when topics were started ...

[Steve]

Oh! So I wouldn't make the second code change in it's entirety? So the second code change would remain this?

Code Select Expand

', $txt['started_by'], ' ', $topic['first_post']['member']['link'], '

[GL700Wing]

Oh! So I wouldn't make the second code change in it's entirety? So the second code change would remain this?

Code Select Expand

', $txt['started_by'], ' ', $topic['first_post']['member']['link'], '

Correct - you wouldn't change that line at all.

[Steve]

Thanks GL. Appreciate it.   

[GL700Wing]

Thanks GL. Appreciate it.   

You're welcome.

Also, you might be interested in the mod update I just did ...

[Steve]

Also, you might be interested in the mod update I just did ..

I just installed the update and holy crap is that fast!

Awesome work GL!

[live627]

Any chance of making this a mod?

Done - 'Topic Start Date on Message Index' mod for SMF 2.0 and 2.1 submitted for approval.

I''ll be moving this to Now Available then.