show date under topic starter

[jenigma]

Hi. Here's a super simple one for someone (although not so simple I can figure it out myself unfortunately): How do I show the date a topic was started under the poster's name on the Message Index?

Thanks.

[[Unknown]]

I like this mod.

Code Select Expand

<edit file>
Sources/MessageIndex.php
</edit file>

<search for>
      $result = mysql_query("
         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
</search for>

<replace>
      $result = mysql_query("
         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 startedPosterTime
         FROM {$db_prefix}topics as t, {$db_prefix}messages as m, {$db_prefix}messages as m2
</replace>

<search for>
               <td class="windowbg2" valign="middle" width="14%" bgcolor="' . $color['windowbg2'] . '">
                  <font size="2">' . $mname . '</font></td>
<search for>

<replace>
               <td class="windowbg2" valign="middle" width="14%" bgcolor="' . $color['windowbg2'] . '">
                  <font size="2">' . timeformat($row['startedPosterTime']) . '<br />' . $txt[525] . $mname . '</font></td>
</replace>


That should be it.

-[Unknown]

[jenigma]

Hi Unknown. I tried it and got these errors:

Parse error: parse error, unexpected T_STRING in /home/poemki/public_html/community/Sources/MessageIndex.php on line 265

Fatal error: Call to undefined function: messageindex() in /home/poemki/public_html/community/index.php on line 310

[[Unknown]]

You changed more than I said.... line 265 should be:

Code Select Expand

            LEFT JOIN {$db_prefix}log_mark_read AS lmr ON (lmr.ID_BOARD=$currentboard AND lmr.ID_MEMBER=$ID_MEMBER)

PS: This is for 1.5.1.

-[Unknown]

[jenigma]

I got it now, thanks very much.