post starter date

[acf [delete me]!]

"Last post" has a post date can the topic starter olso have an post date?

example:

[Grudge]

OK - took me a while to see the doctored screenshot

open messageindex.php and find

Code Select Expand

         SELECT t.ID_LAST_MSG, t.ID_TOPIC, t.numReplies, t.locked, m.posterName, m.ID_MEMBER, IFNULL(mem.realName, m.posterName) AS posterDisplayName, t.numViews, m.posterTime, m.modifiedTime, t.ID_FIRST_MSG, t.isSticky, t.ID_POLL, m2.posterName as mname, m2.ID_MEMBER as mid, IFNULL(mem2.realName, m2.posterName) AS firstPosterDisplayName, m2.subject as msub, m2.icon as micon, IFNULL(lt.logTime, 0) AS isRead, IFNULL(lmr.logTime, 0) AS isMarkedRead
         FROM {$db_prefix}topics as t, {$db_prefix}messages as m, {$db_prefix}messages as m2
            LEFT JOIN {$db_prefix}members AS mem ON (mem.ID_MEMBER=m.ID_MEMBER)
            LEFT JOIN {$db_prefix}members AS mem2 ON (mem2.ID_MEMBER=m2.ID_MEMBER)
            LEFT JOIN {$db_prefix}log_topics AS lt ON (lt.ID_TOPIC=t.ID_TOPIC AND lt.ID_MEMBER=$ID_MEMBER)
            LEFT JOIN {$db_prefix}log_mark_read AS lmr ON (lmr.ID_BOARD=$currentboard AND lmr.ID_MEMBER=$ID_MEMBER)
         WHERE t.ID_TOPIC IN (" . implode(',', $topics) . ")
            AND m.ID_MSG=t.ID_LAST_MSG
            AND m2.ID_MSG=t.ID_FIRST_MSG
         ORDER BY $stickyOrder m.posterTime DESC") or database_error(__FILE__, __LINE__);
and change it to:

Code Select Expand

         SELECT t.ID_LAST_MSG, t.ID_TOPIC, t.numReplies, t.locked, m.posterName, m.ID_MEMBER, IFNULL(mem.realName, m.posterName) AS posterDisplayName, t.numViews, m.posterTime, m.modifiedTime, t.ID_FIRST_MSG, t.isSticky, t.ID_POLL, m2.posterName as mname, m2.ID_MEMBER as mid, IFNULL(mem2.realName, m2.posterName) AS firstPosterDisplayName, m2.subject as msub, m2.icon as micon, IFNULL(lt.logTime, 0) AS isRead, IFNULL(lmr.logTime, 0) AS isMarkedRead, m2.posterTime AS mtime
         FROM {$db_prefix}topics as t, {$db_prefix}messages as m, {$db_prefix}messages as m2
            LEFT JOIN {$db_prefix}members AS mem ON (mem.ID_MEMBER=m.ID_MEMBER)
            LEFT JOIN {$db_prefix}members AS mem2 ON (mem2.ID_MEMBER=m2.ID_MEMBER)
            LEFT JOIN {$db_prefix}log_topics AS lt ON (lt.ID_TOPIC=t.ID_TOPIC AND lt.ID_MEMBER=$ID_MEMBER)
            LEFT JOIN {$db_prefix}log_mark_read AS lmr ON (lmr.ID_BOARD=$currentboard AND lmr.ID_MEMBER=$ID_MEMBER)
         WHERE t.ID_TOPIC IN (" . implode(',', $topics) . ")
            AND m.ID_MSG=t.ID_LAST_MSG
            AND m2.ID_MSG=t.ID_FIRST_MSG
         ORDER BY $stickyOrder m.posterTime DESC") or database_error(__FILE__, __LINE__);
(the additional is the: "m2.posterTime AS mtime" bit)

Then just down from there in the while loop there is a:

Code Select Expand


         $name1 = $row['posterDisplayName'];
         $name2 = $row['firstPosterDisplayName'];

bit. just add:

Code Select Expand


$mtime=$row['mtime'];


Finally find:

Code Select Expand


         $mydate = timeformat($mdate);

and add:

Code Select Expand


         $mytime = timeformat($mtime);


Oh - to actually display it, a few lines down find:

Code Select Expand

                  <font size="2">' . $mname . '</font></td>
               <td class="windowbg" valign="middle" width="4%" align="center" bgcolor="' . $color['windowbg'] . '">

and change it to:

Code Select Expand

                  <font size="2">' . $mytime . '<br />' . $txt[525] . ' ' . $mname . '</font></td>
               <td class="windowbg" valign="middle" width="4%" align="center" bgcolor="' . $color['windowbg'] . '">


I'm fairly sure that will all work - but backup it up first just in case

[acf [delete me]!]

thanx ill start modding again

[acf [delete me]!]

thanx!! it worked perfect!!

[Grudge]

excellent... the only thing I'd suggest is changing either the text of the "started by" to "started on" or chaning the format of that column from
"date by poster" to "poster on date" as it currently reads:
"Started by june 16th 2003 on Grudge" etc instead of:

"Started by Grudge on june 16th 2003"
OR
"Started on June 16th 2003 by Grudge"

It should make sense as you read down the column what I'm talking about

[acf [delete me]!]

excellent... the only thing I'd suggest is changing either the text of the "started by" to "started on" or chaning the format of that column from
"date by poster" to "poster on date" as it currently reads:
"Started by june 16th 2003 on Grudge" etc instead of:

"Started by Grudge on june 16th 2003"
OR
"Started on June 16th 2003 by Grudge"

It should make sense as you read down the column what I'm talking about

Yep now it realy works like a dream  

[Anguz]

wow... very useful

this should probably be moved to Completed Mods and labelled correctly... I'm sure many will love it

[Anguz]

I installed it in my test board and it's working great

laakademia.com/forums

I also fixed the TD widths so that Started and Replied are the same