TinyPortal

This is requested elsewhere, but I though I post it here. It essentially use the SSI function for collecting the recent topics, and lay them out like the threads overview of the forum.

- use a PHP type block and just insert the code down below.
- use it preferably on a centerblock or frontblock - since its quite wide.
- looks best with "do not use title/frame" for the block, it has it own titlebar.
- add board ID number like to the function if youw ant to narrow down the boards recent topics are taken from. change it to ssi_recentTopics('8', array('3','56') , 'array') where the numbers 3 and 56 are examples of board ID's.


       
global $scripturl;

echo '
                        <table border="0" width="100%" cellspacing="1" cellpadding="4" class="bordercolor">
                               <tr><td colspan="3" class="titlebg">Recent topics</td></tr> ';
       $what=ssi_recentTopics('8', NULL, 'array');


        foreach ($what as $topic)
        {
                echo '
                                <tr>
                                        <td class="windowbg" valign="middle">
                                                ', $topic['link'];

                // Is this topic new? (assuming they are logged in!)
                if (!$topic['new'] && $context['user']['is_logged'])
                        echo '
                                                <a href="', $scripturl, '?topic=', $topic['topic'], '.from', $topic['new_from'], '#new"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" border="0" /></a>';

                echo '
                                        </td>
                                        <td class="windowbg2" valign="middle" width="20%">
                                                ', $topic['poster']['link'], '
                                        </td>
                                        <td class="windowbg2" valign="middle" width="35%">';
                if ($settings['images_url'] != $settings['theme_url'] . '/images' || file_exists($settings['theme_dir'] . '/images/icons/last_post.gif'))
                        echo '
                                        <a href="', $topic['href'], '"><img src="', $settings['images_url'], '/icons/last_post.gif" alt="', $txt[111], '" title="', $txt[111], '" border="0" style="float: right;" /></a>';
                echo '
                                                <span class="smalltext">
                                                        ', $topic['time'], '
                                                </span>
                                        </td>
                                </tr>';
        }

        echo '
                        </table>';


edit: added a extra line on top, since errors were created.

[attachment deleted by admin]

Works good but will not uncheck the post after the post has been read

Ray
One of my posts was the "elsewhere" (http://www.tinyportal.net/smf/index.php?topic=583.msg4568#msg4568)ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ;)

If you check you will find that the read and unread post topics are reversed. If you read one shown as unread it will then have a 'New' but, yes, if you read one marked 'New' it doesn't change.

Ah! ok thanks

Changed the code..does it work better now?

Yup! they are the right way round again. Thanks Bloc

It was terribly confusing, when you are over 50 you have enough difficulty remembering what you've read anyway .....  ;)

Aye works OK now -- yep over 50 can be a pain sometimes lol -- like remembering how to get home from work

How hard would it be to change it To recent post and not topics -- just wondering? :-\

You mean like the "recent posts" on the forum? (action=recent)

yes on all forums that have permission to see the post

what Im looking for is here

Show forum-posts on frontpage from:(can pisck only one forum)

to be able to have more than one forum at a time.

Also, it is possible to show this at the bottom rather than the top?  I have been looing for how to do that - but cannot seem to find it...

I think that depends on what you want at the top. What would you have above the recent topics?

I've nearly finished what I'm doing with the block code. Even one page should show as Pages: [1] but I haven't got the page number to display yet.

[code]ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  global $context, $settings, $options, $txt, $scripturl, $modSettings;
echo '
<table border="0" width="100%" cellspacing="1" cellpadding="4" class="tborder">
<tr><td class="titlebg">Recent topics</td></tr></table><table border="0" width="100%" cellspacing="1" cellpadding="4" class="tborder"><tr><td class="catbg">These are our most recent topics</td></tr></table>';


echo '
<table width="100%" cellpadding="3" cellspacing="0" border="0" class="tborder" style="margin-bottom: 3px;margin-top: 3px;">
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  <tr>
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  <td align="left" class="catbg" width="100%" height="35">
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  <table cellpadding="3" cellspacing="0" width="100%">
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  <tr>
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  <td>
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ', $txt[139], ': ', $context['page_index'];

ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  // Show a "go down" link?
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  if (!empty($modSettings['topbottomEnable']))
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  echo $context['menu_separator'], '<a href="#bot">', $settings['use_image_buttons'] ? '<img src="' . $settings['images_url'] . '/' . $context['user']['language'] . '/go_down.gif" alt="' . $txt['topbottom5'] . '" border="0" align="top" />' : $txt['topbottom5'], '</a>';

ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  echo '
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  </td>

ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  </tr>
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  </table>
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  </td>
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  </tr>
</table>

<a name="top"></a>

<table border="0" width="100%" cellspacing="1" cellpadding="4" class="tborder"><tr><tdÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  class="titlebg">Subject</td><tdÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  class="titlebg">Started By</td><tdÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  class="titlebg">Last Post</td></tr>';
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ, $what=ssi_recentTopics('8', NULL, 'array');


ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  foreach ($what as $topic)
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  {
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  echo '
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  <tr>
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  <td class="windowbg" valign="middle">
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ', $topic['link'];

ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  // Is this topic new? (assuming they are logged in!)
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  if (!$topic['new'] && $context['user']['is_logged'])
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  echo '
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  <a href="', $scripturl, '?topic=', $topic['topic'], '.from', $topic['newtime'], '#new"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" border="0" /></a>';

ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  echo '
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  </td>
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  <td class="windowbg2" valign="middle" width="20%">
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ', $topic['poster']['link'], '
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  </td>
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  <td class="windowbg2" valign="middle" width="35%">';
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  if ($settings['images_url'] != $settings['theme_url'] . '/images' || file_exists($settings['theme_dir'] . '/images/icons/last_post.gif'))
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  echo '
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  <a href="', $topic['href'], '"><img src="', $settings['images_url'], '/icons/last_post.gif" alt="', $txt[111], '" title="', $txt[111], '" border="0" style="float: right;" /></a>';
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  echo '
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  <span class="smalltext">
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ', $topic['time'], '
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  </span>
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  </td>
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  </tr>';
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  }

ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  echo '
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  </table>
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  <a name="lastPost"></a>
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  <table width="100%" cellpadding="3" cellspacing="0" border="0" class="tborder" style="margin-top: 1ex;">
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  <tr>
ÃÆ'ââ,¬Å¡Ãƒâ€šÃ,  ÃÆ'ââ,¬Å

"page index" is calculated by SMF..but since you don't use SMF directly, but rather SSi..you need to do the calculating yourself. It depends upon how many posts you have fetched in the functiona and how many you like to display at one time...you would even need to transfer a variable that says "display from page 2" ( in other words skip x number of posts and then display).

I would just stick to 1 page and adjust the number "8" to your own needs.TP calculates pages for its articles and forum posts..but its perhaps difficult to transfer this approach to a block code.

Thanks Block

How many pages will be called by your Block code, would it only be one? Even if it was say 50 topics long?

If you look at the code..only 8 ? thats what you meant?

No, that is all the posts made on the last day before I made that database copy, it is set for 10. What I meant was, can the Recent Topics SSI paginate all the topics it finds or would it display them in one long page, if it was set to say 50?

I have now removed both page_index variables and got rid of two of the three errors. The frontblock error I have added to the 0.72b thread as that is my current version.

It would display them in one long line.

Recent topics only show subjects anyway, whereas "ssi_boardnews" shows posts..and thats what TP already use when showing last post from the forum - on the frontpage. TP asks a modified version of this function for the data, but calculates pagination and also add any page number needed in the querystring. Ssi_recenttopics out-of-the-box doesn not support fetching of x data from y starting point..it only fetches all, only limited by your "limit" number.

How could I make this to work in the center blocs??

http://www.rranderson.com/dvd/index.php?action=recent

You can't. It has its own template and fetching routine, and will not work inside another "action" - namely "action=tportal".

Ok thanks -- made a menu for it for now

can someone explain the code to me like I am a 4 year old so I can try and add this :uglystupid2:

You don't need to know how it works. All you need to do is add the code into your center block. Then it will automatically put the recent topics in your center block.

Goto TPadmin, then edit blocks. Scroll down to to center block and add a php block. Then put the code in it from here.

I am a DA :uglystupid2:
I have it now. Thanks for the tip !

 Any time m8.

I am still a DA
I used both codes in the code area's for the Recent topics and when I go into the forum or anywhere the topics still show ?

I will have more Q's  I am well PHP impaired :idiot2: Am I missing a setting ?
Thanks

http://www.golfdiscussions.com/smfbeta/index.php (http://www.golfdiscussions.com/smfbeta/index.php)

In the general settings for TPAdmin you can set it to display the front blocks (or not) when viewing the forums.

Quote from: IchBinÃÆ'ââ,¬Å¡ÃƒÂ¢Ã¢â,¬Å¾Ã,¢ on August 28, 2005, 07:43:23 PM
In the general settings for TPAdmin you can set it to display the front blocks (or not) when viewing the forums.

Pk I am not seeing this option ( TinyPortal v.0.6.5 beta )

Also how can you set "Number of posts to show on frontpage:" to 0 ?

Thanks

[attachment deleted by admin]

Where did you put the recent topics code? Into a Block?

Why would you want to set it to 0? You can just change it to display articles or single page?

Quote from: IchBinÃÆ'ââ,¬Å¡ÃƒÂ¢Ã¢â,¬Å¾Ã,¢ on August 29, 2005, 03:25:02 AM
Where did you put the recent topics code? Into a Block?

Why would you want to set it to 0? You can just change it to display articles or single page?

I figured out the 0 thing.
Yes into a php block and it shows in every single page

If I remember right TP 6.5 only has left and right blocks...? You can tell it to disable each of those while your in the forum. It shows it right in the picture you just posted.

Quote from: IchBinÃÆ'ââ,¬Å¡ÃƒÂ¢Ã¢â,¬Å¾Ã,¢ on August 29, 2005, 03:49:05 AM
If I remember right TP 6.5 only has left and right blocks...? You can tell it to disable each of those while your in the forum. It shows it right in the picture you just posted.

I am using 6.5 and I can use it in the sides and hide them, but it always shows in every page if I have it in a center block.

I see yours is only on the main page at http://www.tmrules.com/ and you have 7.2

Ah yes, I remember now that Bloc did not put in the option to hide the center blocks until a release after the one that you have.  I think you have to wait and see what Bloc has to say about this. Maybe he will be releasing an update for the beta testers.

i was planning to get the download manager module up and running before a release for beta-testers, but it might take longer than I figured.

So I will instead polish up a 0.7 release (with these options) and release it.

So I am not  :idiot2: after all :knuppel2: well some say I am  :uglystupid2:
Where can I get 7.2 ::) for testing :-X

Bloc has an invite only beta testing group that helps him polish it up a bit before he releases the beta to the regular beta testing group.

Quote from: IchBinÃÆ'ââ,¬Å¡ÃƒÂ¢Ã¢â,¬Å¾Ã,¢ on August 29, 2005, 02:49:43 PM
Bloc has an invite only beta testing group that helps him polish it up a bit before he releases the beta to the regular beta testing group.

Ok I stared at the cpanel on it last night for hours playing with it, opening the php files, etc. At least I know I am not crazy, insane maybe but not crazy
Thanks

if i use Frontpage Blocks, it will show a blank index page on other themes i use that are not for tinyportal. :(

I can use it in Frontpage blocks and it does not show up again, not to fond of the FP blocks though since I like the options of the blocks in the center.  Any way to get the code to only work on the main page and then stop showing up everytime ?

I just use the center blocks to have that effect -- see here

http://www.rranderson.com/

and it will only show  up on the main page not the forums pages -- is this what you want

Quote from: Ray on September 16, 2005, 08:56:52 PM
I just use the center blocks to have that effect -- see here

http://www.rranderson.com/

and it will only show  up on the main page not the forums pages -- is this what you want

I can not get mine to work that way, it always shows up on every page.. What am I missing ?
You have recent posts not topics..

Here are some pictures hope this will help

Thanks I will look at it later tonight, I am moving my site to a new server right now.

 ;D My pleasure

The top pic is kinda cut off I cant see much ;)

Just wated to show you that it was a setting in the center block

This better??

I think maybe setting "general settings" / "Hide center bar when in forum?" to "no" will give you what you seek? That way the centerblocks only show on frontpage(and all articles of course), but the forum is clear.

in the forum this is how it shows up

How can we show the recent block in the center below all the articles? Would there be a top/bottom block feature?

Not "yet"....

when i use this recent topics block for the frontpage, error logs fills up with this error.


8: Undefined index: newtime
File: \Themes\default\TPortal.template.php (eval?)
Line: 19

You need to change $topic['newtime'] to $topic['time'] in the following section of the code.
See the red text...

// Is this topic new? (assuming they are logged in!)
                if (!$topic['new'] && $context['user']['is_logged'])
                        echo '
                                                <a href="', $scripturl, '?topic=', $topic['topic'], '.from',[$topic['time'], '#new"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" border="0" /></a>';

Quote from: evillair on March 02, 2006, 05:42:00 PM
You need to change $topic['newtime'] to $topic['time'] in the following section of the code.

Thanks.... here is the new code!

global $scripturl;

echo '
                        <table border="0" width="100%" cellspacing="1" cellpadding="4" class="bordercolor">
                               <tr><td colspan="3" class="titlebg">Recent topics</td></tr> ';
       $what=ssi_recentTopics('10', NULL, 'array');


        foreach ($what as $topic)
        {
                echo '
                                <tr>
                                        <td class="windowbg" valign="middle">
                                                ', $topic['link'];

                // Is this topic new? (assuming they are logged in!)
                if (!$topic['new'] && $context['user']['is_logged'])
                        echo '
                                                <a href="', $scripturl, '?topic=', $topic['topic'], '.from', $topic['time'], '#new"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" border="0" /></a>';

                echo '
                                        </td>
                                        <td class="windowbg2" valign="middle" width="20%">
                                                ', $topic['poster']['link'], '
                                        </td>
                                        <td class="windowbg2" valign="middle" width="35%">';
                if ($settings['images_url'] != $settings['theme_url'] . '/images' || file_exists($settings['theme_dir'] . '/images/icons/last_post.gif'))
                        echo '
                                        <a href="', $topic['href'], '"><img src="', $settings['images_url'], '/icons/last_post.gif" alt="', $txt[111], '" title="', $txt[111], '" border="0" style="float: right;" /></a>';
                echo '
                                                <span class="smalltext">
                                                        ', $topic['time'], '
                                                </span>
                                        </td>
                                </tr>';
        }

        echo '
                        </table>';

Hi
Thanks a lot for this script.
I wanted to change it a little and put an exerpt of the message content. What is the correct parameter for $topic['???'] to get it ?
Couldn't get hold of the info.

Thanks a lot

Looks great, thanks for that!  8)

how about this little alteration..

Please look at the code and tell mer if I've got anything wrong.. its my first attempt at doing this.. it can be seen in action at http://ourmega.net/index.php
global $scripturl;

echo '<table border="0" width="100%" cellspacing="1" cellpadding="4" class="bordercolor">';

$what=ssi_recentTopics('10', NULL, 'array');

foreach ($what as $topic)
  {
echo '<tr class="catbg3">
<td valign="middle">Subject</td>
<td valign="middle">Board</td>
<td valign="middle">Poster</td>
<td valign="middle">Time</td>
</tr>';

    echo '<tr><td class="windowbg" valign="middle">', $topic['link'];

    // Is this topic new? (assuming they are logged in!)
       if (!$topic['new'] && $context['user']['is_logged'])


         echo '<a href="', $scripturl, '?topic=', $topic['topic'], '.from', $topic['time'], '#new"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" border="0" /></a>';

  echo '</td><td class="windowbg2" valign="middle" >', $topic['board']['link'], '</td>';

    echo '</td><td class="windowbg2" valign="middle" >', $topic['poster']['link'], '</td><td class="windowbg2" valign="middle" >';

    if ($settings['images_url'] != $settings['theme_url'] . '/images' || file_exists($settings['theme_dir'] . '/images/icons/last_post.gif'))

    echo '<a href="', $topic['href'], '"><img src="', $settings['images_url'], '/icons/last_post.gif" alt="', $txt[111], '" title="', $txt[111], '" border="0" style="float: right;" /></a>';

    echo '<span class="smalltext">', $topic['time'], '</span></td></tr>';
}

echo '</table>';

I got this from your link -  The page cannot be displayed.

arghh.. why not.. try it  www.ourmega.net

Quote from: BlueSteel on March 28, 2006, 04:02:03 AM
arghh.. why not.. try it  www.ourmega.net

I see it and like it on your site, but the code didn't work on my test site.

ok.. problem sorted out with my server.. try again to see it http://ourmega.net

Can not seem to get it to work also BlueSteel   :-\

Works for me now...

;) whew...

and are there any errors in my edited script above ???
what do you think of my changes ?

oops.. there was an error .. I've corrected it .. and also retested it by copying and pasting it into a new php block

Got it working ok but is they anyway to remove the menu ontop of each post and just have the one at the top??

ok.. looking into that.. prolly just placed it in the wrong spot in the code

ok here it is updated and re-organised and re-formatted

It should now only display the headings once


// "Recent Topics" a php Block
// Prefered settings when being designed
// Border and title on
// Title ="Recent Topics"

global $scripturl;
$what=ssi_recentTopics('10', NULL, 'array');

echo '<table border="0" width="100%" cellspacing="1" cellpadding="4" class="bordercolor">';
echo '<tr class="catbg3"><td valign="middle">Subject</td><td valign="middle">Board</td><td valign="middle">Poster</td><td valign="middle">Time</td></tr>';

foreach ($what as $topic)
  {
    echo '<tr><td class="windowbg" valign="middle">', $topic['link'];
    // Is this topic new? (assuming they are logged in!)
    if (!$topic['new'] && $context['user']['is_logged'])
      echo '<a href="', $scripturl, '?topic=', $topic['topic'], '.from', $topic['time'], '#new"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" border="0" /></a>';
      echo '</td><td class="windowbg2" valign="middle" >', $topic['board']['link'], '</td>';
      echo '</td><td class="windowbg2" valign="middle" >', $topic['poster']['link'], '</td><td class="windowbg2" valign="middle" >';
      if ($settings['images_url'] != $settings['theme_url'] . '/images' || file_exists($settings['theme_dir'] . '/images/icons/last_post.gif'))
      echo '<a href="', $topic['href'], '"><img src="', $settings['images_url'], '/icons/last_post.gif" alt="', $txt[111], '" title="', $txt[111], '" border="0" style="float: right;" /></a>';
      echo '<span class="smalltext">', $topic['time'], '</span></td></tr>';
  }

echo '</table>';


Works perfect and I am using it -- thank you

If someone is interested i can post the changes i had to make to the code to obtain this result (http://joyfund.info/forum/index.php) (see at the end of the page)

That's good stuff! Post away astpaul. :)

Quote from: IchBinâââ,¬Å¾Ã,¢ on April 03, 2006, 02:39:04 PM
That's good stuff! Post away astpaul. :)

Ok

It is a little tricky as i had to modify SSI.php in order to obtain the desired result.

So the actual block code is :
// "Recent Topics" a php Block
// Prefered settings when being designed
// Border and title on
// Title ="Recent Topics"

global $scripturl;
$what=ssi_recentTopics('10', array('1','2','3','4','5','6','7','8','9','10','12','13','14','16','17','15'), 'array', 500);

echo '<table border="0" width="100%" cellspacing="1" cellpadding="4" class="bordercolor">';
//echo '<tr class="catbg3"><td valign="middle">Subject</td><td valign="middle">Time</td></tr>';

foreach ($what as $topic)
  {
    echo '<tr><td class="windowbg" valign="middle">', $topic['link'],'<br><font color="#666666" size="1">', $topic['preview'],'</font>';
    // Is this topic new? (assuming they are logged in!)
    if (!$topic['new'] && $context['user']['is_logged'])
      echo '<a href="', $scripturl, '?topic=', $topic['topic'], '.from', $topic['time'], '#new"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" border="0" /></a>';
//      echo '</td><td class="windowbg2" valign="middle" >', $topic['board']['link'], '</td>';
//      echo '</td><td class="windowbg2" valign="middle" >', $topic['poster']['link'], '</td><td class="windowbg2" valign="middle" >';
      echo '<td class="windowbg2" valign="middle">';
      if ($settings['images_url'] != $settings['theme_url'] . '/images' || file_exists($settings['theme_dir'] . '/images/icons/last_post.gif'))
      echo '<a href="', $topic['href'], '"><img src="', $settings['images_url'], '/icons/last_post.gif" alt="', $txt[111], '" title="', $txt[111], '" border="0" style="float: right;" /></a>';
      echo '<span class="smalltext">', $topic['time'], '</span></td></tr>';
  }

echo '</table>';

For the SSI modification, here is the file. Watch for lines beginning by //MODIF ASP
I had to create a new variable in ssi_recentTopics which states the number of characters one wants to display; modify the correspoding SQL order and variables.

And voila!

Hope it helps

Thank, that's so fine in some case  :)

Ok...how can i fix this?  I keep getting a error from this in the log stating newtime is an undefined index...also db.

What do i need to change in order to stop the errors?

I'm having some trouble with the array function [example - array('3','36')]  I want to list recent topics from a specific board but I am finding that it doesn't just call from the board that i indicated but others as well.  I modified bloc's code to have two columns both 42% of the screen that each call 5 recent topics from separate boards with the board titles indicated.. but i'm having that problem that i stated above.  Does anyone know how to fix this?

global $scripturl;

echo '
<table border="0" width="100%" cellspacing="1" cellpadding="2">
<tr>
<td width="42%">
<table width="100%">News</br><div class="hr"><hr /></div>
                               ';
       $what=ssi_recentTopics('5', array('9') , 'array');


        foreach ($what as $topic)
        {
                echo '
                                <tr>
                                        <td width="70%" valign="top">
<img src="', $settings['images_url'], '/icons/arrow.gif" alt="', $txt[111], '" title="', $txt[111], '" border="0" style="float: left;" / >   

                                                ', $topic['link'];

                // Is this topic new? (assuming they are logged in!)
                if (!$topic['new'] && $context['user']['is_logged'])
                        echo '
                                                <a href="', $scripturl, '?topic=', $topic['topic'], '.from', $topic['newtime'], '#new"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" border="0" /></a>';

                echo '
                                        </td>             
                                        <td width="30%" align="center" valign="top">';
                if ($settings['images_url'] != $settings['theme_url'] . '/images' || file_exists($settings['theme_dir'] . '/images/icons/last_post.gif'))
                        echo '
                                        <a href="', $topic['href'], '"><img src="', $settings['images_url'], '/icons/last_post.gif" alt="', $txt[111], '" title="', $txt[111], '" border="0" style="float: right;" /></a>';
                echo '
                                                <span class="smalltext">
                                                        ', $topic['time'], '
                                                </span>
                                        </td>
                                </tr>';
        }

        echo '
                        </table>
</td>

<td width="42%">
<table width="100%">General Discussion</br><div class="hr"><hr /></div>
                               ';
       $what=ssi_recentTopics('5', array('1') , 'array');


        foreach ($what as $topic)
        {
                echo '
                                <tr>
                                        <td width="70%" valign="top">
<img src="', $settings['images_url'], '/icons/arrow.gif" alt="', $txt[111], '" title="', $txt[111], '" border="0" style="float: left;" / >   

                                                ', $topic['link'];

                // Is this topic new? (assuming they are logged in!)
                if (!$topic['new'] && $context['user']['is_logged'])
                        echo '
                                                <a href="', $scripturl, '?topic=', $topic['topic'], '.from', $topic['newtime'], '#new"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" border="0" /></a>';

                echo '
                                        </td>             
                                        <td width="30%" align="center" valign="top">';
                if ($settings['images_url'] != $settings['theme_url'] . '/images' || file_exists($settings['theme_dir'] . '/images/icons/last_post.gif'))
                        echo '
                                        <a href="', $topic['href'], '"><img src="', $settings['images_url'], '/icons/last_post.gif" alt="', $txt[111], '" title="', $txt[111], '" border="0" style="float: right;" /></a>';
                echo '
                                                <span class="smalltext">
                                                        ', $topic['time'], '
                                                </span>
                                        </td>
                                </tr>';
        }

        echo '
                        </table>
</td>
</tr></table>';


you put in the array the boards that you DO NOT want to be displayed!!! :)

ahh i see.. thanks, i will try that out

one more question.. how do i define the max length of a topic title so it fits on one line in the above code (42% of the screen)

Quote from: jpark on April 15, 2006, 09:11:35 PM
one more question.. how do i define the max length of a topic title so it fits on one line in the above code (42% of the screen)

You can't the way you want it.
The only thing you can do is to limit your title to a specific number of characters like this:
substr($topic['topic'],0,34)
In this case, we took the 1st 34 characters.

Quote from: technodragon73 on April 12, 2006, 05:43:02 PM
Ok...how can i fix this?  I keep getting a error from this in the log stating newtime is an undefined index...also db.

What do i need to change in order to stop the errors?

Anyone?

Technodragon73, try to find the ['newtime'] in the code, and exchange it with ['new_from'].

Quote from: Bloc on April 20, 2006, 12:07:52 PM
Technodragon73, try to find the ['newtime'] in the code, and exchange it with ['new_from'].

That fixed it...thank you!

Quote from: BlueSteel on March 29, 2006, 01:07:56 AM
ok here it is updated and re-organised and re-formatted

It should now only display the headings once

Code Select Expand


// "Recent Topics" a php Block
// Prefered settings when being designed
// Border and title on
// Title ="Recent Topics"

global $scripturl;
$what=ssi_recentTopics('10', NULL, 'array');

echo '<table border="0" width="100%" cellspacing="1" cellpadding="4" class="bordercolor">';
echo '<tr class="catbg3"><td valign="middle">Subject</td><td valign="middle">Board</td><td valign="middle">Poster</td><td valign="middle">Time</td></tr>';

foreach ($what as $topic)
  {
    echo '<tr><td class="windowbg" valign="middle">', $topic['link'];
    // Is this topic new? (assuming they are logged in!)
    if (!$topic['new'] && $context['user']['is_logged'])
      echo '<a href="', $scripturl, '?topic=', $topic['topic'], '.from', $topic['time'], '#new"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" border="0" /></a>';
      echo '</td><td class="windowbg2" valign="middle" >', $topic['board']['link'], '</td>';
      echo '</td><td class="windowbg2" valign="middle" >', $topic['poster']['link'], '</td><td class="windowbg2" valign="middle" >';
      if ($settings['images_url'] != $settings['theme_url'] . '/images' || file_exists($settings['theme_dir'] . '/images/icons/last_post.gif'))
      echo '<a href="', $topic['href'], '"><img src="', $settings['images_url'], '/icons/last_post.gif" alt="', $txt[111], '" title="', $txt[111], '" border="0" style="float: right;" /></a>';
      echo '<span class="smalltext">', $topic['time'], '</span></td></tr>';
  }

echo '</table>';


bluesteel THANK YOU SO MUCH I have been dying for this snippet of code for ages!

UR THE BOMB!

recenttopics shows about 30-40 last topics..

why ?
how can topics count increase. ?
i need according to time.. like last day, last week, last month etc. is it possible ?

Recent topics always count from the very latest post and backwards. To set a date/timespan would mean to have to adjust the routine somewhat.

Maybe something for an "archive" sort of mod/function for posts/topics?

What you could do is change the number of msgs to be in the fetching array to a larger number and then scan for those msgs by date... and only pirint out those ones.. that makes for a way more complicate block of code .. but honestly you can do anything you want if you know how (which i don't .. I just tweak others code.. i'm not smart enough to write it out fully by myself)

i was wondering is it possible to have a modification of this code so that it does the following?

1 - Only displays topics from a particular board
2 - ONLY displays new topics (from the selected board) IF they are new topics (dosent loop topics on replies)

I ask cos I am making a "in the news" board in which I and members will post the daily news from around the world and it would appear on the TP index.

Thanks

Both thinsg could be done in the actual mysql_call. It means a custom ssi_recentTopics function though.

akulion: for just one baord is easy, but the other item I am not exactly sure what you mean.."new topics" as in unread? or as in newer than a set timespan?

by new topics I mean: A topic which has been posted just recently in that board, but replying to that post does not bring it to top on the "recent post block"

So basically ONLY when the topic is initially posted it appears in the block - but afterwards no matter how many replies it gets it dosent appear there - but can only be overtaken by newer posts/threads made

I see. So just sorting on created dates then, not on last replied date. That would mean even a simpler sql call.

Yup :D

So what do I need to do? :D:D

Quote from: akulion on April 30, 2006, 11:21:35 AM

Quote from: BlueSteel on March 29, 2006, 01:07:56 AM
ok here it is updated and re-organised and re-formatted

It should now only display the headings once

Code Select Expand


// "Recent Topics" a php Block
// Prefered settings when being designed
// Border and title on
// Title ="Recent Topics"

global $scripturl;
$what=ssi_recentTopics('10', NULL, 'array');

echo '<table border="0" width="100%" cellspacing="1" cellpadding="4" class="bordercolor">';
echo '<tr class="catbg3"><td valign="middle">Subject</td><td valign="middle">Board</td><td valign="middle">Poster</td><td valign="middle">Time</td></tr>';

foreach ($what as $topic)
  {
    echo '<tr><td class="windowbg" valign="middle">', $topic['link'];
    // Is this topic new? (assuming they are logged in!)
    if (!$topic['new'] && $context['user']['is_logged'])
      echo '<a href="', $scripturl, '?topic=', $topic['topic'], '.from', $topic['time'], '#new"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" border="0" /></a>';
      echo '</td><td class="windowbg2" valign="middle" >', $topic['board']['link'], '</td>';
      echo '</td><td class="windowbg2" valign="middle" >', $topic['poster']['link'], '</td><td class="windowbg2" valign="middle" >';
      if ($settings['images_url'] != $settings['theme_url'] . '/images' || file_exists($settings['theme_dir'] . '/images/icons/last_post.gif'))
      echo '<a href="', $topic['href'], '"><img src="', $settings['images_url'], '/icons/last_post.gif" alt="', $txt[111], '" title="', $txt[111], '" border="0" style="float: right;" /></a>';
      echo '<span class="smalltext">', $topic['time'], '</span></td></tr>';
  }

echo '</table>';


bluesteel THANK YOU SO MUCH I have been dying for this snippet of code for ages!

UR THE BOMB!

Beautiful. Thanks!

So how can you add a scroll bar and fixed height to this?

Read through the thread before asking. All the answers are in this thread for you to read

I read every word of the thread before posting, I always do.  I've seen how to make it so it auto scrolls but not to where you can have a scroll bar.  I have not seen that in any of the threads I found when searching.  I really like the new layout of this design but don't see hot to add a scroll bar.

Redid this one a bit layoutwise so it would more look like the TP recent topics block.

Wanted it basicly to look the same, but with the option to hide rooms so I could make severall.
Thank you very much Bloc for the base code. I basiclly just rearranged, removed and added some comments so one would see directly in the code how to hide rooms etc.

global $scripturl; echo '

<table border="0" width="100%" cellspacing="1" cellpadding="2" class="bordercolor"> ';

// To show more posts change the number at recentTopics('8', to the amount you want.

// To hide specific rooms from the PHPscript replace the """, NULL,""" with """, array('7','56'),""" as an example.
// The numbers at the array = the rooms ID number. To find out what ID number the room you want to hide is, just klick on it.
// Then see what number it is at the end of the url. For example: /index.php?board=7.0 is the same as number 7

//This is the codeline you alter to change the amount of topics to show + hide rooms.
$what=ssi_recentTopics('10', NULL, 'array');

foreach ($what as $topic){echo '

<tr>
<td class="windowbg" valign="middle">

<span class="smalltext">', $topic['link'];

// Is this topic new? (assuming they are logged in!)
if (!$topic['new'] && $context['user']['is_logged']) echo '
<a href="', $scripturl, '?topic=', $topic['topic'], '.from', $topic['new_from'], '#new">
<img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" border="0" /></a>';

echo '
<br>
<span class="smalltext"> ', $topic['time'],'
<br>
Poster: ', $topic['poster']['link'], '
</span>
</span>
</td>
</tr>
';}echo '
</table>
';

G6 or anybody else-

Any ideas on how to make a scroll bar in the new design of this?

Read this

http://www.dyn-web.com/dhtml/scroll/

Or this one for generate costume made with colors and 3d effects

http://www.htmlbasix.com/scrollbargenerator.shtml

Isn't there a way to do it with just setting the height limit of the recent topics and by putting a call for auto wrap or something?  I saw it in a different design for the layout but can't figure out how to make it happen in the new design that is really great by the way.  Sorry for my stupid sounding questions.  I'm new to PHP and really like TP.

If you put the html code inside a div with some styling like this:

<div style="height: xxpx; overflow: auto;">

..it should show scrollbars when content is larger than set height, at least in Firefox. For IE you might need some tweaking.

Thank you bloc.  I knew it was an easy question for you pros.  Thanks for the great product and support!!

How hard would it be to add a 'Replies' and 'Views' column in-between 'Poster' and 'Time'

Replies would be just the number of replies to that thread vs. how many views up to that point?

Quote from: akulion on May 01, 2006, 09:57:26 AM
i was wondering is it possible to have a modification of this code so that it does the following?

1 - Only displays topics from a particular board

Quote from: Bloc on May 01, 2006, 03:01:41 PM
akulion: for just one baord is easy

any other way to do this instead using array('3','56') cause i have more than 80 boards and it makes my site buggy

Quote from: Bloc on May 01, 2006, 06:34:27 PM
I see. So just sorting on created dates then, not on last replied date. That would mean even a simpler sql call.

I don't know if Akulion got an answer to this but I would like to know how to do this as well.. sorry to bump and thanks in advance!  ;D

Quote from: RoarinRow on May 12, 2006, 03:46:35 PM
How hard would it be to add a 'Replies' and 'Views' column in-between 'Poster' and 'Time'

Replies would be just the number of replies to that thread vs. how many views up to that point?

Bump.  Still seeing if someone could please add the code to add 'Replies' and 'Views' column just like SMF.  See attached.  It helps our power posters.   :)

Uhm..I can help there, but what "version" are you using? The original have had a few changes by several people in this topic, so I am not sure what you are using now. :)

Quote from: Bloc on May 19, 2006, 01:41:30 PM
Uhm..I can help there, but what "version" are you using? The original have had a few changes by several people in this topic, so I am not sure what you are using now. :)

This is the version I'm using now

// "Recent Topics" a php Block
// Prefered settings when being designed
// Border and title on
// Title ="Recent Topics"

global $scripturl;
$what=ssi_recentTopics('35', NULL, 'array');

echo '<table border="0" width="100%" cellspacing="1" cellpadding="4" class="bordercolor">';
echo '<tr class="catbg3"><td valign="middle">Subject</td><td valign="middle">Board</td><td valign="middle">Poster</td><td valign="middle">Time</td></tr>';

foreach ($what as $topic)
  {
    echo '<tr><td class="windowbg" valign="middle">', $topic['link'];
    // Is this topic new? (assuming they are logged in!)
    if (!$topic['new'] && $context['user']['is_logged'])
      echo '<a href="', $scripturl, '?topic=', $topic['topic'], '.from', $topic['time'], '#new"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" border="0" /></a>';
      echo '</td><td class="windowbg2" valign="middle" >', $topic['board']['link'], '</td>';
      echo '</td><td class="windowbg2" valign="middle" >', $topic['poster']['link'], '</td><td class="windowbg2" valign="middle" >';
      if ($settings['images_url'] != $settings['theme_url'] . '/images' || file_exists($settings['theme_dir'] . '/images/icons/last_post.gif'))
      echo '<a href="', $topic['href'], '"><img src="', $settings['images_url'], '/icons/last_post.gif" alt="', $txt[111], '" title="', $txt[111], '" border="0" style="float: right;" /></a>';
      echo '<span class="smalltext">', $topic['time'], '</span></td></tr>';
  }

echo '</table>';

uhm, one problem: the SSI function doesn't collect those variables. Need to rewrite that function then.

Quote from: Bloc on May 19, 2006, 07:33:37 PM
uhm, one problem: the SSI function doesn't collect those variables. Need to rewrite that function then.

Doh!  o.k. thank Bloc   :o  no worries then.  It was a nice to have.

Quote from: RoarinRow on May 19, 2006, 06:37:14 PM

Quote from: Bloc on May 19, 2006, 01:41:30 PM
Uhm..I can help there, but what "version" are you using? The original have had a few changes by several people in this topic, so I am not sure what you are using now. :)

This is the version I'm using now

Code Select Expand

// "Recent Topics" a php Block
// Prefered settings when being designed
// Border and title on
// Title ="Recent Topics"

global $scripturl;
$what=ssi_recentTopics('35', NULL, 'array');

echo '<table border="0" width="100%" cellspacing="1" cellpadding="4" class="bordercolor">';
echo '<tr class="catbg3"><td valign="middle">Subject</td><td valign="middle">Board</td><td valign="middle">Poster</td><td valign="middle">Time</td></tr>';

foreach ($what as $topic)
  {
    echo '<tr><td class="windowbg" valign="middle">', $topic['link'];
    // Is this topic new? (assuming they are logged in!)
    if (!$topic['new'] && $context['user']['is_logged'])
      echo '<a href="', $scripturl, '?topic=', $topic['topic'], '.from', $topic['time'], '#new"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" border="0" /></a>';
      echo '</td><td class="windowbg2" valign="middle" >', $topic['board']['link'], '</td>';
      echo '</td><td class="windowbg2" valign="middle" >', $topic['poster']['link'], '</td><td class="windowbg2" valign="middle" >';
      if ($settings['images_url'] != $settings['theme_url'] . '/images' || file_exists($settings['theme_dir'] . '/images/icons/last_post.gif'))
      echo '<a href="', $topic['href'], '"><img src="', $settings['images_url'], '/icons/last_post.gif" alt="', $txt[111], '" title="', $txt[111], '" border="0" style="float: right;" /></a>';
      echo '<span class="smalltext">', $topic['time'], '</span></td></tr>';
  }

echo '</table>';

Anyone know why the number of recent topics don't show 35 like I have configured in this section of the code above:

$what=ssi_recentTopics('35', NULL, 'array'); 

Right now it shows 24 posts instead of the 35 I'd like to see.

could it be in the settings for SMF's recent topics  its self thats lower than the settings in your block ??? just guessing

Quote from: BlueSteel on June 01, 2006, 01:41:55 PM
could it be in the settings for SMF's recent topics  its self thats lower than the settings in your block ??? just guessing

Thanks, but that didn't do it  :o

I'm pretty sure that The RecentTopics function in SSI only searches for topics within the last X number of posts (where X is a function of the number of topics requested; something like 20 or 25 times that number; uses a WHERE clause like msg_id > (last_msg - X) ).

So (assuming 25 is the number used) asking for 35 topics will return up to 35 topics which were found in the last 875 (25x35) posts. It won't keep seeking backwards until 35 are found to return.

Quote from: jcortina on June 02, 2006, 03:40:31 PM
I'm pretty sure that The RecentTopics function in SSI only searches for topics within the last X number of posts (where X is a function of the number of topics requested; something like 20 or 25 times that number; uses a WHERE clause like msg_id > (last_msg - X) ).

So (assuming 25 is the number used) asking for 35 topics will return up to 35 topics which were found in the last 875 (25x35) posts. It won't keep seeking backwards until 35 are found to return.

Ah ok. that explains it, thank you!

is it possible to show limited characters in subject field.

for example original subject: "is it possible to show limited characters in subject field"

limited characters in subject: "is it possible to show limi..."

thx.

Instead of using $topic['subject'] in the code given, use $topic['short_subject'].

That's a shortened version of only 25 characters (not sure right now if that's 25 with or without the ellipsis '...').

there is no "$topic['subject']" in script ???

Sorry. $topic['link'] has the full length subject embedded in it. It is this line:



    echo '<tr><td class="windowbg" valign="middle">', $topic['link'];



Try replacing that with:



    echo '<tr><td class="windowbg" valign="middle"><a href="' . $topic['href'] . '">' . $topic['short_subject'] . '</a>';



Is it possible to make the Recent Topics view similar to the Unread Topics view. 

I would really like the 'Replies' and 'Views' columns in-between the 'Poster' and 'Time' columns.

try adding:


<td class="windowbg2" valign="middle" width="10%">
                                                ', $topic['replies']['link'], '
                                        </td>
<td class="windowbg2" valign="middle" width="10%">
                                                ', $topic['views']['link'], '
                                        </td>

in there. you may have to fiddle with the percents, and possibly find out what the function calls for replies and views actually are (though logic tells me they would be called just that)

Quote from: Techdomain on July 19, 2006, 06:31:40 AM
try adding:

Code Select Expand


<td class="windowbg2" valign="middle" width="10%">
                                                ', $topic['replies']['link'], '
                                        </td>
<td class="windowbg2" valign="middle" width="10%">
                                                ', $topic['views']['link'], '
                                        </td>

in there. you may have to fiddle with the percents, and possibly find out what the function calls for replies and views actually are (though logic tells me they would be called just that)

I'll give it a try, thanks!

That didn't work unfortunately.  But I took what I had and put in your recommendations.  Anyone know how I can make this work?

// "Recent Topics" a php Block
// Prefered settings when being designed
// Border and title on
// Title ="Recent Topics"

global $scripturl;
$what=ssi_recentTopics('35', NULL, 'array');

echo '<table border="0" width="100%" cellspacing="1" cellpadding="4" class="bordercolor">';
echo '<tr class="catbg3">
      <td valign="middle">Subject</td>
      <td valign="middle">Board</td>
      <td valign="middle">Poster</td>
      <td valign="middle">Replies</td>
      <td valign="middle">Views</td>
      <td valign="middle">Time</td></tr>';

foreach ($what as $topic)
  {
    echo '<tr><td class="windowbg" valign="middle">', $topic['link'];
    // Is this topic new? (assuming they are logged in!)
    if (!$topic['new'] && $context['user']['is_logged'])
      echo '<a href="', $scripturl, '?topic=', $topic['topic'], '.from', $topic['time'], '#new"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" border="0" /></a>';
      echo '</td><td class="windowbg2" valign="middle" >', $topic['board']['link'], '</td>';
      echo '</td><td class="windowbg2" valign="middle" >', $topic['poster']['link'], '</td>;
      echo '</td><td class="windowbg2" valign="middle" >', $topic['replies']['link'], '</td>';
      echo '</td><td class="windowbg2" valign="middle" >', $topic['views']['link'], '</td><td class="windowbg2" valign="middle" >';
      if ($settings['images_url'] != $settings['theme_url'] . '/images' || file_exists($settings['theme_dir'] . '/images/icons/last_post.gif'))
      echo '<a href="', $topic['href'], '"><img src="', $settings['images_url'], '/icons/last_post.gif" alt="', $txt[111], '" title="', $txt[111], '" border="0" style="float: right;" /></a>';
      echo '<span class="smalltext">', $topic['time'], '</span></td></tr>';
  }

echo '</table>';


This is what I have right now:

// "Recent Topics" a php Block
// Prefered settings when being designed
// Border and title on
// Title ="Recent Topics"

global $scripturl;
$what=ssi_recentTopics('25', NULL, 'array');

echo '<table border="0" width="100%" cellspacing="1" cellpadding="4" class="bordercolor">';
echo '<tr class="catbg3"><td valign="middle">Subject</td><td valign="middle">Board</td><td valign="middle">Poster</td><td valign="middle">Time</td></tr>';

foreach ($what as $topic)
  {
    echo '<tr><td class="windowbg" valign="middle">', $topic['link'];
    // Is this topic new? (assuming they are logged in!)
    if (!$topic['new'] && $context['user']['is_logged'])
      echo '<a href="', $scripturl, '?topic=', $topic['topic'], '.from', $topic['time'], '#new"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" border="0" /></a>';
      echo '</td><td class="windowbg2" valign="middle" >', $topic['board']['link'], '</td>';
      echo '</td><td class="windowbg2" valign="middle" >', $topic['poster']['link'], '</td><td class="windowbg2" valign="middle" >';
      if ($settings['images_url'] != $settings['theme_url'] . '/images' || file_exists($settings['theme_dir'] . '/images/icons/last_post.gif'))
      echo '<a href="', $topic['href'], '"><img src="', $settings['images_url'], '/icons/last_post.gif" alt="', $txt[111], '" title="', $txt[111], '" border="0" style="float: right;" /></a>';
      echo '<span class="smalltext">', $topic['time'], '</span></td></tr>';
  }

echo '</table>';

Very nice code!  :up:

however, could you please tell me how could I move 'recent topics' block below the articles?   Just like this:
http://www.samsungcommunity.net/index.php?PHPSESSID=5231c4aa4ad86fbc587e9dd3d108019a;

thanks x 10000000 :)

create a PHP Center block under your TP admin 'Block Settings"

And then simply position it below the articles using the position boxes

position boxes?

u mean u dont have those with the cool flashing ajax java and flashing lights?

lol

I meant those little boxes in which you put the number for where to display a particular block

But I got mixed up with articles and blocks there ... sorry about that

ah... ok. thought there was something I was missing!

there's no an option for show 'Both Articles and Frontpage Blocks' in the general setting/frontpage/What to show on frontpage panel.

currently, my 'recent topics' block is in a PHP centre block, and it appear above the articles in the frontpage, i would like to move it under the articles not above. :(

Could anyone tell me how to do it?

thanks!!!!

I believe that option is what is in the next release of TP...you'll just have to wait.

hello..
thanks for your reply
do you have any idea about how could this person able to move the 'recent topic' block under the articles?

http://www.samsungcommunity.net/index.php?PHPSESSID=5231c4aa4ad86fbc587e9dd3d108019a;

thanks!

this is buggin me a small big....
tryin to get the group colour to show on the posters name (if there in a group)

does anyone have an idea on how to add it to this big of code?

global $scripturl;

echo '
                        <table border="0" width="100%" cellspacing="1" cellpadding="4" class="bordercolor">
                               <tr><td colspan="3" class="titlebg">Recent topics</td></tr> ';
       $what=ssi_recentTopics('10', NULL, 'array');


        foreach ($what as $topic)
        {
                echo '
                                <tr>
                                        <td class="windowbg" valign="middle">
                                                ', $topic['link'];

                // Is this topic new? (assuming they are logged in!)
                if (!$topic['new'] && $context['user']['is_logged'])
                        echo '
                                                <a href="', $scripturl, '?topic=', $topic['topic'], '.from', $topic['time'], '#new"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" border="0" /></a>';

                echo '
                                        </td>
                                        <td class="windowbg2" valign="middle" width="20%">
                                                ', $topic['poster']['link'], '
                                        </td>
                                        <td class="windowbg2" valign="middle" width="35%">';
                if ($settings['images_url'] != $settings['theme_url'] . '/images' || file_exists($settings['theme_dir'] . '/images/icons/last_post.gif'))
                        echo '
                                        <a href="', $topic['href'], '"><img src="', $settings['images_url'], '/icons/last_post.gif" alt="', $txt[111], '" title="', $txt[111], '" border="0" style="float: right;" /></a>';
                echo '
                                                <span class="smalltext">
                                                        ', $topic['time'], '
                                                </span>
                                        </td>
                                </tr>';
        }

        echo '
                        </table>';

i know its something like "$topic['poster']['onlineColor']['link']" but im missing something else  :-\

Screenshot:
(https://www.tinyportal.net/proxy.php?request=http%3A%2F%2Fimg208.imageshack.us%2Fimg208%2F3889%2Ftutorial4pw3.jpg&hash=37986c6b80344f936f817b1909ff8dade7a553ae)

Quote from: jcortina on June 02, 2006, 03:40:31 PM
I'm pretty sure that The RecentTopics function in SSI only searches for topics within the last X number of posts (where X is a function of the number of topics requested; something like 20 or 25 times that number; uses a WHERE clause like msg_id > (last_msg - X) ).

So (assuming 25 is the number used) asking for 35 topics will return up to 35 topics which were found in the last 875 (25x35) posts. It won't keep seeking backwards until 35 are found to return.

That worked!  Thank you very much.   :up:

Quote from: RoarinRow on July 19, 2006, 05:01:00 AM
Is it possible to make the Recent Topics view similar to the Unread Topics view. 

I would really like the 'Replies' and 'Views' columns in-between the 'Poster' and 'Time' columns.

Now is someone knew how I can make the 'Recent Topics' look like the 'Unread Topics' view, I'd be set.   :uglystupid2:

Quote from: RoarinRow on August 03, 2006, 09:22:57 PM
Now is someone knew how I can make the 'Recent Topics' look like the 'Unread Topics' view, I'd be set.   :uglystupid2:

Recent Topics Block - Unread Topics View

phpbox - center block - do not use title/frame

Sorts by most recent on top (can't click headings to sort differently)

Uses setting for number of recent posts to display on board index number
(this code could be put in boardindex.template to replace most recent posts
with this format of most recent topics).

Can be used in php article with $num_to_return set to a number like 50
to give longer list of most recent topics (read or unread).



global $context, $settings, $scripturl, $txt, $db_prefix, $ID_MEMBER, $user_info, $modSettings;

  if (!empty($settings['number_recent_posts']))
    {
$num_to_return = $settings['number_recent_posts'];

$stable_icons = array('xx', 'thumbup', 'thumbdown', 'exclamation', 'question', 'lamp', 'smiley', 'angry', 'cheesy', 'grin', 'sad', 'wink', 'moved', 'recycled', 'wireless');
$icon_sources = array();
foreach ($stable_icons as $icon)
$icon_sources[$icon] = 'images_url';

$request = db_query("
SELECT
ms.subject AS firstSubject, ms.posterTime AS firstPosterTime, ms.ID_TOPIC, t.ID_BOARD, b.name AS bname,
t.numReplies, t.numViews, ms.ID_MEMBER AS ID_FIRST_MEMBER, ml.ID_MEMBER AS ID_LAST_MEMBER,
ml.posterTime AS lastPosterTime, IFNULL(mems.realName, ms.posterName) AS firstPosterName,
IFNULL(meml.realName, ml.posterName) AS lastPosterName, ml.subject AS lastSubject,
ml.icon AS lastIcon, ms.icon AS firstIcon, t.ID_POLL, t.isSticky, t.locked, ml.modifiedTime AS lastModifiedTime,
LEFT(ml.body, 384) AS lastBody, LEFT(ms.body, 384) AS firstBody,
ml.smileysEnabled AS lastSmileys, ms.smileysEnabled AS firstSmileys, t.ID_FIRST_MSG, t.ID_LAST_MSG,"
. ($user_info['is_guest'] ? '1 AS isRead, 0 AS new_from' : '
IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, 0)) >= ml.ID_MSG_MODIFIED AS isRead,
IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, -1)) + 1 AS new_from') . "
FROM ({$db_prefix}messages AS ms, {$db_prefix}messages AS ml, {$db_prefix}topics AS t, {$db_prefix}boards AS b)
LEFT JOIN {$db_prefix}members AS mems ON (mems.ID_MEMBER = ms.ID_MEMBER)
LEFT JOIN {$db_prefix}members AS meml ON (meml.ID_MEMBER = ml.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 = t.ID_BOARD AND lmr.ID_MEMBER = $ID_MEMBER)
    WHERE t.ID_LAST_MSG >= " . ($modSettings['maxMsgID'] - 35 * min($num_to_return, 5)) . "
    AND t.ID_TOPIC = ms.ID_TOPIC
AND b.ID_BOARD = t.ID_BOARD
AND $user_info[query_see_board]
AND ms.ID_MSG = t.ID_FIRST_MSG
AND ml.ID_MSG = t.ID_LAST_MSG
ORDER BY t.ID_LAST_MSG DESC
            LIMIT " . $num_to_return, __FILE__, __LINE__);


$topics = array();
$topic_ids = array();
while ($row = mysql_fetch_assoc($request))
{
if ($row['ID_POLL'] > 0 && $modSettings['pollMode'] == '0')
continue;

$topic_ids[] = $row['ID_TOPIC'];

// Clip the strings first because censoring is slow :/. (for some reason?)
$row['firstBody'] = strip_tags(strtr(parse_bbc($row['firstBody'], $row['firstSmileys'], $row['ID_FIRST_MSG']), array('<br />' => '
')));
if (strlen($row['firstBody']) > 128)
$row['firstBody'] = substr($row['firstBody'], 0, 128) . '...';
$row['lastBody'] = strip_tags(strtr(parse_bbc($row['lastBody'], $row['lastSmileys'], $row['ID_LAST_MSG']), array('<br />' => '
')));
if (strlen($row['lastBody']) > 128)
$row['lastBody'] = substr($row['lastBody'], 0, 128) . '...';

$row['lastSubject'] = $row['firstSubject'];
$row['lastBody'] = $row['firstBody'];

// Decide how many pages the topic should have.
$topic_length = $row['numReplies'] + 1;
if ($topic_length > $modSettings['defaultMaxMessages'])
{
$tmppages = array();
$tmpa = 1;
for ($tmpb = 0; $tmpb < $topic_length; $tmpb += $modSettings['defaultMaxMessages'])
{
$tmppages[] = '<a href="' . $scripturl . '?topic=' . $row['ID_TOPIC'] . '.' . $tmpb . ';topicseen">' . $tmpa . '</a>';
$tmpa++;
}
// Show links to all the pages?
if (count($tmppages) <= 5)
$pages = 'ÂÃ,« ' . implode(' ', $tmppages);
// Or skip a few?
else
$pages = 'ÂÃ,« ' . $tmppages[0] . ' ' . $tmppages[1] . ' ... ' . $tmppages[count($tmppages) - 2] . ' ' . $tmppages[count($tmppages) - 1];

if (!empty($modSettings['enableAllMessages']) && $topic_length < $modSettings['enableAllMessages'])
$pages .= '  <a href="' . $scripturl . '?topic=' . $row['ID_TOPIC'] . '.0;all">' . $txt[190] . '</a>';
$pages .= ' ÂÃ,»';
}
else
$pages = '';

// We need to check the topic icons exist... you can never be too sure!
if (empty($modSettings['messageIconChecks_disable']))
{
// First icon first... as you'd expect.
if (!isset($icon_sources[$row['firstIcon']]))
$icon_sources[$row['firstIcon']] = file_exists($settings['theme_dir'] . '/images/post/' . $row['firstIcon'] . '.gif') ? 'images_url' : 'default_images_url';
// Last icon... last... duh.
if (!isset($icon_sources[$row['lastIcon']]))
$icon_sources[$row['lastIcon']] = file_exists($settings['theme_dir'] . '/images/post/' . $row['lastIcon'] . '.gif') ? 'images_url' : 'default_images_url';
}

// And build the array.
$topics[$row['ID_TOPIC']] = array(
'id' => $row['ID_TOPIC'],
'first_post' => array(
'id' => $row['ID_FIRST_MSG'],
'member' => array(
'name' => $row['firstPosterName'],
'id' => $row['ID_FIRST_MEMBER'],
'href' => $scripturl . '?action=profile;u=' . $row['ID_FIRST_MEMBER'],
'link' => !empty($row['ID_FIRST_MEMBER']) ? '<a href="' . $scripturl . '?action=profile;u=' . $row['ID_FIRST_MEMBER'] . '" title="' . $txt[92] . ' ' . $row['firstPosterName'] . '">' . $row['firstPosterName'] . '</a>' : $row['firstPosterName']
),
'time' => timeformat($row['firstPosterTime']),
'timestamp' => forum_time(true, $row['firstPosterTime']),
'subject' => $row['firstSubject'],
'preview' => $row['firstBody'],
'icon' => $row['firstIcon'],
'icon_url' => $settings[$icon_sources[$row['firstIcon']]] . '/post/' . $row['firstIcon'] . '.gif',
'href' => $scripturl . '?topic=' . $row['ID_TOPIC'] . '.0;topicseen',
'link' => '<a href="' . $scripturl . '?topic=' . $row['ID_TOPIC'] . '.0;topicseen">' . $row['firstSubject'] . '</a>'
),
'last_post' => array(
'id' => $row['ID_LAST_MSG'],
'member' => array(
'name' => $row['lastPosterName'],
'id' => $row['ID_LAST_MEMBER'],
'href' => $scripturl . '?action=profile;u=' . $row['ID_LAST_MEMBER'],
'link' => !empty($row['ID_LAST_MEMBER']) ? '<a href="' . $scripturl . '?action=profile;u=' . $row['ID_LAST_MEMBER'] . '">' . $row['lastPosterName'] . '</a>' : $row['lastPosterName']
),
'time' => timeformat($row['lastPosterTime']),
'timestamp' => forum_time(true, $row['lastPosterTime']),
'subject' => $row['lastSubject'],
'preview' => $row['lastBody'],
'icon' => $row['lastIcon'],
'icon_url' => $settings[$icon_sources[$row['lastIcon']]] . '/post/' . $row['lastIcon'] . '.gif',
'href' => $scripturl . '?topic=' . $row['ID_TOPIC'] . ($row['numReplies'] == 0 ? '.0' : '.msg' . $row['ID_LAST_MSG']) . ';topicseen#msg' . $row['ID_LAST_MSG'],
'link' => '<a href="' . $scripturl . '?topic=' . $row['ID_TOPIC'] . ($row['numReplies'] == 0 ? '.0' : '.msg' . $row['ID_LAST_MSG']) . ';topicseen#msg' . $row['ID_LAST_MSG'] . '">' . $row['lastSubject'] . '</a>'
),
'new' => $row['isRead'],
'new_from' => $row['new_from'],
'new_href' => $scripturl . '?topic=' . $row['ID_TOPIC'] . '.msg' . $row['new_from'] . ';topicseen#new',
'href' => $scripturl . '?topic=' . $row['ID_TOPIC'] . ($row['numReplies'] == 0 ? '.0' : '.msg' . $row['new_from']) . ';topicseen' . ($row['numReplies'] == 0 ? '' : 'new'),
'link' => '<a href="' . $scripturl . '?topic=' . $row['ID_TOPIC'] . ($row['numReplies'] == 0 ? '.0' : '.msg' . $row['new_from']) . ';topicseen#msg' . $row['new_from'] . '">' . $row['firstSubject'] . '</a>',
'is_sticky' => !empty($modSettings['enableStickyTopics']) && !empty($row['isSticky']),
'is_locked' => !empty($row['locked']),
'is_poll' => $modSettings['pollMode'] == '1' && $row['ID_POLL'] > 0,
'is_hot' => $row['numReplies'] >= $modSettings['hotTopicPosts'],
'is_very_hot' => $row['numReplies'] >= $modSettings['hotTopicVeryPosts'],
'is_posted_in' => false,
'icon' => $row['firstIcon'],
'icon_url' => $settings[$icon_sources[$row['firstIcon']]] . '/post/' . $row['firstIcon'] . '.gif',
'subject' => $row['firstSubject'],
'pages' => $pages,
'replies' => $row['numReplies'],
'views' => $row['numViews'],
'board' => array(
'id' => $row['ID_BOARD'],
'name' => $row['bname'],
'href' => $scripturl . '?board=' . $row['ID_BOARD'] . '.0',
'link' => '<a href="' . $scripturl . '?board=' . $row['ID_BOARD'] . '.0">' . $row['bname'] . '</a>'
)
);

determineTopicClass($topics[$row['ID_TOPIC']]);
}
mysql_free_result($request);

if (!empty($modSettings['enableParticipation']) && !empty($topic_ids))
{
$result = db_query("
SELECT ID_TOPIC
FROM {$db_prefix}messages
WHERE ID_TOPIC IN (" . implode(', ', $topic_ids) . ")
AND ID_MEMBER = $ID_MEMBER", __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($result))
{
if (empty($topics[$row['ID_TOPIC']]['is_posted_in']))
{
$topics[$row['ID_TOPIC']]['is_posted_in'] = true;
$topics[$row['ID_TOPIC']]['class'] = 'my_' . $topics[$row['ID_TOPIC']]['class'];
}
}
mysql_free_result($result);
}

if (!empty($topics))
    {
    echo '
        <div class="tborder" ', $context['browser']['needs_size_fix'] && !$context['browser']['is_ie6'] ? 'style="width: 100%;"' : '', '>
            <table border="0" width="100%" cellspacing="1" cellpadding="1" class="bordercolor">
                <tr>';

    echo '
                    <td class="titlebg" colspan="7">', "Most Recently Posted to Topics", '</td>';
    echo '
                </tr>';

    echo '
<tr class="titlebg">
<td width="10%" colspan="2"> </td>
<td>', $txt[70], '
</td><td width="14%">', $txt[109], '
</td><td width="4%" align="center">', $txt[110], '
</td><td width="4%" align="center">', $txt[301], '
</td><td width="24%">', $txt[111], '
</td>
</tr>';

foreach ($topics as $topic)
{
// Do we want to seperate the sticky and lock status out?
if (!empty($settings['seperate_sticky_lock']) && strpos($topic['class'], 'sticky') !== false)
$topic['class'] = substr($topic['class'], 0, strrpos($topic['class'], '_sticky'));
if (!empty($settings['seperate_sticky_lock']) && strpos($topic['class'], 'locked') !== false)
$topic['class'] = substr($topic['class'], 0, strrpos($topic['class'], '_locked'));

echo '
<tr>
<td class="windowbg2" valign="middle" align="center" width="6%">
<img src="' . $settings['images_url'] . '/topic/' . $topic['class'] . '.gif" alt="" />
</td><td class="windowbg2" valign="middle" align="center" width="4%">
<img src="' . $topic['first_post']['icon_url'] . '" alt="" align="middle" />
</td><td class="windowbg' , $topic['is_sticky'] && !empty($settings['seperate_sticky_lock']) ? '3' : '' , '" width="48%" valign="middle">' , $topic['is_locked'] && !empty($settings['seperate_sticky_lock']) ? '
<img src="' . $settings['images_url'] . '/icons/quick_lock.gif" align="right" alt="" style="margin: 0;" />' : '' , $topic['is_sticky'] && !empty($settings['seperate_sticky_lock']) ? '
<img src="' . $settings['images_url'] . '/icons/show_sticky.gif" align="right" alt="" style="margin: 0;" />' : '', $topic['first_post']['link'];
if ($topic['new'] == 0)
{
echo '<a href="', $topic['new_href'], '"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" /></a>';
}
echo '
<span class="smalltext">', $topic['pages'], ' ', $txt['smf88'], ' ', $topic['board']['link'], '</span></td>
<td class="windowbg2" valign="middle" width="14%">
', $topic['first_post']['member']['link'], '</td>
<td class="windowbg" valign="middle" width="4%" align="center">
', $topic['replies'], '</td>
<td class="windowbg" valign="middle" width="4%" align="center">
', $topic['views'], '</td>
<td class="windowbg2" valign="middle" width="22%">
<a href="', $topic['last_post']['href'], '"><img src="', $settings['images_url'], '/icons/last_post.gif" alt="', $txt[111], '" title="', $txt[111], '" style="float: right;" /></a>
<span class="smalltext">
', $topic['last_post']['time'], '<br />
', $txt[525], ' ', $topic['last_post']['member']['link'], '
</span>
</td>
</tr>';
}

    echo '</table></div>';

    }
}



Great, thank you very much, this is exactly what I'm looking as far as the format and layout, just like 'Unread topics'.

One thing, when I try to change the $num_to_return to 50, it only displays the number of posts from the Current Theme setting, which I have set at 15. 

Anyway to fix that?  Please.

This is the section I changed to 50

WHERE t.ID_LAST_MSG >= " . ($modSettings['maxMsgID'] - 50 * min($num_to_return, 5)) . "

No, you do that up at the 3rd line of the code:

$num_to_return = $settings['number_recent_posts'];

to

$num_to_return = 50;

Quote from: jacortina on August 05, 2006, 11:17:57 PM
No, you do that up at the 3rd line of the code:

$num_to_return = $settings['number_recent_posts'];

to

$num_to_return = 50;

Doh!  That's the ticket!   :uglystupid2:  You're awesome!

This is a much more versatile version of it (to use as article).

This will give most recent XX posted to topics -OR-
most recent XX unreplied to topics -OR-
topics posted to in last XX hours

All in the detailed topic format

Default
index.php?page=##
most recent posted to topics - will list
number equal to  $settings['number_recent_posts']

index.php?page=##;count=50 or index.php?page=##;type=last;count=50
50 most recently posted to topics

index.php?page=##;type=unreplied or index.php?page=##;type=unreplied;count=50
Most recent unreplied to topics - will
list number specified in 'count' or default to
number equal to  $settings['number_recent_posts']

index.php?page=##;type=hours or index.php?page=##;type=hours;count=12
Topics posted to in last number of hours
specified in 'count' or default to 24.



global $context, $settings, $scripturl, $txt, $db_prefix, $ID_MEMBER, $user_info, $modSettings;

if (empty($settings['number_recent_posts']))
$number_recent_posts = 15;
else
$number_recent_posts = $settings['number_recent_posts'];

        if( isset($_GET['type']) )
$list_type = $_GET['type'];
else
$list_type = 'last';

        if( isset($_GET['count']) )
$list_count = $_GET['count'];
else
{
$list_count = $number_recent_posts;
if ($list_type == 'hours')
$list_count = 24;
}

if ($list_type == 'hours')
{
$list_from = strtotime($list_count.' hours ago');
$where_clause = 'ml.posterTime >= ' . $list_from;
$limit_clause = ' ';
$heading = 'Topics Posted To In Last '. $list_count . ' Hours';
}
elseif ($list_type == 'unreplied')
{
$where_clause = 't.numReplies = 0';
if ($list_count == 0)
{
$limit_clause = ' ';
$heading = 'Unreplied To Topics';
}
else
{
$limit_clause = 'LIMIT ' . $list_count;
$heading = $list_count . ' Most Recent Unreplied To Topics';
}
}
else
{
$where_clause = 't.ID_LAST_MSG >= ' . ($modSettings['maxMsgID'] - 90 * min($list_count, 5));
$limit_clause = 'LIMIT ' . $list_count;
$heading = $list_count . ' Most Recently Posted To Topics';
}

$stable_icons = array('xx', 'thumbup', 'thumbdown', 'exclamation', 'question', 'lamp', 'smiley', 'angry', 'cheesy', 'grin', 'sad', 'wink', 'moved', 'recycled', 'wireless');
$icon_sources = array();
foreach ($stable_icons as $icon)
$icon_sources[$icon] = 'images_url';

$request = db_query("
SELECT
ms.subject AS firstSubject, ms.posterTime AS firstPosterTime, ms.ID_TOPIC, t.ID_BOARD, b.name AS bname,
t.numReplies, t.numViews, ms.ID_MEMBER AS ID_FIRST_MEMBER, ml.ID_MEMBER AS ID_LAST_MEMBER,
ml.posterTime AS lastPosterTime, IFNULL(mems.realName, ms.posterName) AS firstPosterName,
IFNULL(meml.realName, ml.posterName) AS lastPosterName, ml.subject AS lastSubject,
ml.icon AS lastIcon, ms.icon AS firstIcon, t.ID_POLL, t.isSticky, t.locked, ml.modifiedTime AS lastModifiedTime,
LEFT(ml.body, 384) AS lastBody, LEFT(ms.body, 384) AS firstBody,
ml.smileysEnabled AS lastSmileys, ms.smileysEnabled AS firstSmileys, t.ID_FIRST_MSG, t.ID_LAST_MSG,"
. ($user_info['is_guest'] ? '1 AS isRead, 0 AS new_from' : '
IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, 0)) >= ml.ID_MSG_MODIFIED AS isRead,
IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, -1)) + 1 AS new_from') . "
FROM ({$db_prefix}messages AS ms, {$db_prefix}messages AS ml, {$db_prefix}topics AS t, {$db_prefix}boards AS b)
LEFT JOIN {$db_prefix}members AS mems ON (mems.ID_MEMBER = ms.ID_MEMBER)
LEFT JOIN {$db_prefix}members AS meml ON (meml.ID_MEMBER = ml.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 = t.ID_BOARD AND lmr.ID_MEMBER = $ID_MEMBER)
    WHERE " . $where_clause . "
    AND t.ID_TOPIC = ms.ID_TOPIC
AND b.ID_BOARD = t.ID_BOARD
AND $user_info[query_see_board]
AND ms.ID_MSG = t.ID_FIRST_MSG
AND ml.ID_MSG = t.ID_LAST_MSG
ORDER BY t.ID_LAST_MSG DESC " . $limit_clause, __FILE__, __LINE__);


$topics = array();
$topic_ids = array();
while ($row = mysql_fetch_assoc($request))
{
if ($row['ID_POLL'] > 0 && $modSettings['pollMode'] == '0')
continue;

$topic_ids[] = $row['ID_TOPIC'];

// Clip the strings first because censoring is slow :/. (for some reason?)
$row['firstBody'] = strip_tags(strtr(parse_bbc($row['firstBody'], $row['firstSmileys'], $row['ID_FIRST_MSG']), array('<br />' => '
')));
if (strlen($row['firstBody']) > 128)
$row['firstBody'] = substr($row['firstBody'], 0, 128) . '...';
$row['lastBody'] = strip_tags(strtr(parse_bbc($row['lastBody'], $row['lastSmileys'], $row['ID_LAST_MSG']), array('<br />' => '
')));
if (strlen($row['lastBody']) > 128)
$row['lastBody'] = substr($row['lastBody'], 0, 128) . '...';

$row['lastSubject'] = $row['firstSubject'];
$row['lastBody'] = $row['firstBody'];

// Decide how many pages the topic should have.
$topic_length = $row['numReplies'] + 1;
if ($topic_length > $modSettings['defaultMaxMessages'])
{
$tmppages = array();
$tmpa = 1;
for ($tmpb = 0; $tmpb < $topic_length; $tmpb += $modSettings['defaultMaxMessages'])
{
$tmppages[] = '<a href="' . $scripturl . '?topic=' . $row['ID_TOPIC'] . '.' . $tmpb . ';topicseen">' . $tmpa . '</a>';
$tmpa++;
}
// Show links to all the pages?
if (count($tmppages) <= 5)
$pages = 'ÂÃ,« ' . implode(' ', $tmppages);
// Or skip a few?
else
$pages = 'ÂÃ,« ' . $tmppages[0] . ' ' . $tmppages[1] . ' ... ' . $tmppages[count($tmppages) - 2] . ' ' . $tmppages[count($tmppages) - 1];

if (!empty($modSettings['enableAllMessages']) && $topic_length < $modSettings['enableAllMessages'])
$pages .= '  <a href="' . $scripturl . '?topic=' . $row['ID_TOPIC'] . '.0;all">' . $txt[190] . '</a>';
$pages .= ' ÂÃ,»';
}
else
$pages = '';

// We need to check the topic icons exist... you can never be too sure!
if (empty($modSettings['messageIconChecks_disable']))
{
// First icon first... as you'd expect.
if (!isset($icon_sources[$row['firstIcon']]))
$icon_sources[$row['firstIcon']] = file_exists($settings['theme_dir'] . '/images/post/' . $row['firstIcon'] . '.gif') ? 'images_url' : 'default_images_url';
// Last icon... last... duh.
if (!isset($icon_sources[$row['lastIcon']]))
$icon_sources[$row['lastIcon']] = file_exists($settings['theme_dir'] . '/images/post/' . $row['lastIcon'] . '.gif') ? 'images_url' : 'default_images_url';
}

// And build the array.
$topics[$row['ID_TOPIC']] = array(
'id' => $row['ID_TOPIC'],
'first_post' => array(
'id' => $row['ID_FIRST_MSG'],
'member' => array(
'name' => $row['firstPosterName'],
'id' => $row['ID_FIRST_MEMBER'],
'href' => $scripturl . '?action=profile;u=' . $row['ID_FIRST_MEMBER'],
'link' => !empty($row['ID_FIRST_MEMBER']) ? '<a href="' . $scripturl . '?action=profile;u=' . $row['ID_FIRST_MEMBER'] . '" title="' . $txt[92] . ' ' . $row['firstPosterName'] . '">' . $row['firstPosterName'] . '</a>' : $row['firstPosterName']
),
'time' => timeformat($row['firstPosterTime']),
'timestamp' => forum_time(true, $row['firstPosterTime']),
'subject' => $row['firstSubject'],
'preview' => $row['firstBody'],
'icon' => $row['firstIcon'],
'icon_url' => $settings[$icon_sources[$row['firstIcon']]] . '/post/' . $row['firstIcon'] . '.gif',
'href' => $scripturl . '?topic=' . $row['ID_TOPIC'] . '.0;topicseen',
'link' => '<a href="' . $scripturl . '?topic=' . $row['ID_TOPIC'] . '.0;topicseen">' . $row['firstSubject'] . '</a>'
),
'last_post' => array(
'id' => $row['ID_LAST_MSG'],
'member' => array(
'name' => $row['lastPosterName'],
'id' => $row['ID_LAST_MEMBER'],
'href' => $scripturl . '?action=profile;u=' . $row['ID_LAST_MEMBER'],
'link' => !empty($row['ID_LAST_MEMBER']) ? '<a href="' . $scripturl . '?action=profile;u=' . $row['ID_LAST_MEMBER'] . '">' . $row['lastPosterName'] . '</a>' : $row['lastPosterName']
),
'time' => timeformat($row['lastPosterTime']),
'timestamp' => forum_time(true, $row['lastPosterTime']),
'subject' => $row['lastSubject'],
'preview' => $row['lastBody'],
'icon' => $row['lastIcon'],
'icon_url' => $settings[$icon_sources[$row['lastIcon']]] . '/post/' . $row['lastIcon'] . '.gif',
'href' => $scripturl . '?topic=' . $row['ID_TOPIC'] . ($row['numReplies'] == 0 ? '.0' : '.msg' . $row['ID_LAST_MSG']) . ';topicseen#msg' . $row['ID_LAST_MSG'],
'link' => '<a href="' . $scripturl . '?topic=' . $row['ID_TOPIC'] . ($row['numReplies'] == 0 ? '.0' : '.msg' . $row['ID_LAST_MSG']) . ';topicseen#msg' . $row['ID_LAST_MSG'] . '">' . $row['lastSubject'] . '</a>'
),
'new' => $row['isRead'],
'new_from' => $row['new_from'],
'new_href' => $scripturl . '?topic=' . $row['ID_TOPIC'] . '.msg' . $row['new_from'] . ';topicseen#new',
'href' => $scripturl . '?topic=' . $row['ID_TOPIC'] . ($row['numReplies'] == 0 ? '.0' : '.msg' . $row['new_from']) . ';topicseen' . ($row['numReplies'] == 0 ? '' : 'new'),
'link' => '<a href="' . $scripturl . '?topic=' . $row['ID_TOPIC'] . ($row['numReplies'] == 0 ? '.0' : '.msg' . $row['new_from']) . ';topicseen#msg' . $row['new_from'] . '">' . $row['firstSubject'] . '</a>',
'is_sticky' => !empty($modSettings['enableStickyTopics']) && !empty($row['isSticky']),
'is_locked' => !empty($row['locked']),
'is_poll' => $modSettings['pollMode'] == '1' && $row['ID_POLL'] > 0,
'is_hot' => $row['numReplies'] >= $modSettings['hotTopicPosts'],
'is_very_hot' => $row['numReplies'] >= $modSettings['hotTopicVeryPosts'],
'is_posted_in' => false,
'icon' => $row['firstIcon'],
'icon_url' => $settings[$icon_sources[$row['firstIcon']]] . '/post/' . $row['firstIcon'] . '.gif',
'subject' => $row['firstSubject'],
'pages' => $pages,
'replies' => $row['numReplies'],
'views' => $row['numViews'],
'board' => array(
'id' => $row['ID_BOARD'],
'name' => $row['bname'],
'href' => $scripturl . '?board=' . $row['ID_BOARD'] . '.0',
'link' => '<a href="' . $scripturl . '?board=' . $row['ID_BOARD'] . '.0">' . $row['bname'] . '</a>'
)
);

determineTopicClass($topics[$row['ID_TOPIC']]);
}
mysql_free_result($request);

if (!empty($modSettings['enableParticipation']) && !empty($topic_ids))
{
$result = db_query("
SELECT ID_TOPIC
FROM {$db_prefix}messages
WHERE ID_TOPIC IN (" . implode(', ', $topic_ids) . ")
AND ID_MEMBER = $ID_MEMBER", __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($result))
{
if (empty($topics[$row['ID_TOPIC']]['is_posted_in']))
{
$topics[$row['ID_TOPIC']]['is_posted_in'] = true;
$topics[$row['ID_TOPIC']]['class'] = 'my_' . $topics[$row['ID_TOPIC']]['class'];
}
}
mysql_free_result($result);
}

if (!empty($topics))
    {
    echo '
        <div class="tborder" ', $context['browser']['needs_size_fix'] && !$context['browser']['is_ie6'] ? 'style="width: 100%;"' : '', '>
            <table border="0" width="100%" cellspacing="1" cellpadding="1" class="bordercolor">
                <tr>';

    echo '
                    <td class="titlebg" colspan="7">', $heading, '</td>';
    echo '
                </tr>';

    echo '
<tr class="titlebg">
<td width="10%" colspan="2"> </td>
<td>', $txt[70], '
</td><td width="14%">', $txt[109], '
</td><td width="4%" align="center">', $txt[110], '
</td><td width="4%" align="center">', $txt[301], '
</td><td width="24%">', $txt[111], '
</td>
</tr>';

foreach ($topics as $topic)
{
// Do we want to seperate the sticky and lock status out?
if (!empty($settings['seperate_sticky_lock']) && strpos($topic['class'], 'sticky') !== false)
$topic['class'] = substr($topic['class'], 0, strrpos($topic['class'], '_sticky'));
if (!empty($settings['seperate_sticky_lock']) && strpos($topic['class'], 'locked') !== false)
$topic['class'] = substr($topic['class'], 0, strrpos($topic['class'], '_locked'));

echo '
<tr>
<td class="windowbg2" valign="middle" align="center" width="6%">
<img src="' . $settings['images_url'] . '/topic/' . $topic['class'] . '.gif" alt="" />
</td><td class="windowbg2" valign="middle" align="center" width="4%">
<img src="' . $topic['first_post']['icon_url'] . '" alt="" align="middle" />
</td><td class="windowbg' , $topic['is_sticky'] && !empty($settings['seperate_sticky_lock']) ? '3' : '' , '" width="48%" valign="middle">' , $topic['is_locked'] && !empty($settings['seperate_sticky_lock']) ? '
<img src="' . $settings['images_url'] . '/icons/quick_lock.gif" align="right" alt="" style="margin: 0;" />' : '' , $topic['is_sticky'] && !empty($settings['seperate_sticky_lock']) ? '
<img src="' . $settings['images_url'] . '/icons/show_sticky.gif" align="right" alt="" style="margin: 0;" />' : '', $topic['first_post']['link'];
if ($topic['new'] == 0)
{
echo '<a href="', $topic['new_href'], '"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" /></a>';
}
echo '
<span class="smalltext">', $topic['pages'], ' ', $txt['smf88'], ' ', $topic['board']['link'], '</span></td>
<td class="windowbg2" valign="middle" width="14%">
', $topic['first_post']['member']['link'], '</td>
<td class="windowbg" valign="middle" width="4%" align="center">
', $topic['replies'], '</td>
<td class="windowbg" valign="middle" width="4%" align="center">
', $topic['views'], '</td>
<td class="windowbg2" valign="middle" width="22%">
<a href="', $topic['last_post']['href'], '"><img src="', $settings['images_url'], '/icons/last_post.gif" alt="', $txt[111], '" title="', $txt[111], '" style="float: right;" /></a>
<span class="smalltext">
', $topic['last_post']['time'], '<br />
', $txt[525], ' ', $topic['last_post']['member']['link'], '
</span>
</td>
</tr>';
}

    echo '</table></div>';

    }



Wow jacortina, this just got better.  For the longest time I've wanted the 'last 24 hour' option.  You rock, thank!    :up:

One question just on the layout.  Is it possible to put the board name underneath the thread title? 

Right now it shows for example, Doug's new car in Hot Cars, all in a straight line.

Is possible to make it so it shows:

Doug's new car
in Hot Cars

Thanks!

No problem (what was given was just the same format as used
in the Unread since Last).

Find:

<span class="smalltext">', $topic['pages'], ' ', $txt['smf88'], ' ', $topic['board']['link'], '</span></td>


Change to:

<span class="smalltext">', $topic['pages'], '<br>', $txt['smf88'], ' ', $topic['board']['link'], '</span></td>


Quote from: jacortina on August 08, 2006, 12:19:04 AM
No problem (what was given was just the same format as used
in the Unread since Last).

Find:

Code Select Expand


<span class="smalltext">', $topic['pages'], ' ', $txt['smf88'], ' ', $topic['board']['link'], '</span></td>


Change to:

Code Select Expand


<span class="smalltext">', $topic['pages'], '<br>', $txt['smf88'], ' ', $topic['board']['link'], '</span></td>


That's the ticket!  Thank you!!   :D

jacortina, very much improved upon! one thing, how do i get it to use the same colors as what my forum uses? where it says subject, started by, etc etc, it should be same as within forums but it isn't.

One last question jacortina, where can I make the same change of the hard return to the 'All unread topics'?  This way both my views will be consistent.

Quote from: rbh on August 08, 2006, 05:37:30 AM
jacortina, very much improved upon! one thing, how do i get it to use the same colors as what my forum uses? where it says subject, started by, etc etc, it should be same as within forums but it isn't.

As this code is based on that used for Unread Replies (Recent and All), it only does what that does. The query used there (and here) doesn't get/apply the group colors (doesn't query the membergroup table at all).

Quote from: RoarinRow on August 08, 2006, 05:49:40 AM
One last question jacortina, where can I make the same change of the hard return to the 'All unread topics'?  This way both my views will be consistent.

Recent.template.php

It will change both All Unread and Recent Unread.

Find:
<img src="' . $settings['images_url'] . '/icons/show_sticky.gif" align="right" alt="" style="margin: 0;" />' : '', $topic['first_post']['link'], ' <a href="', $topic['new_href'], '"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" /></a> <span class="smalltext">', $topic['pages'], ' ', $txt['smf88'], ' ', $topic['board']['link'], '</span></td>

Change to:
<img src="' . $settings['images_url'] . '/icons/show_sticky.gif" align="right" alt="" style="margin: 0;" />' : '', $topic['first_post']['link'], ' <a href="', $topic['new_href'], '"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" /></a> <span class="smalltext">', $topic['pages'], '<br>', $txt['smf88'], ' ', $topic['board']['link'], '</span></td>

$txt['smf88'] is the word 'in' -> "in [BoardName]"

If you want to change how Unread Replies are presented also...

Find:
' , $topic['is_sticky'] && !empty($settings['seperate_sticky_lock']) ? '<img src="' . $settings['images_url'] . '/icons/show_sticky.gif" align="right" alt="" style="margin: 0;" />' : '', ' ', $topic['first_post']['link'], ' <a href="', $topic['new_href'], '"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" /></a> <span class="smalltext">', $topic['pages'], '
', $txt['smf88'], ' ', $topic['board']['link'], '</span></td>


Change to:
' , $topic['is_sticky'] && !empty($settings['seperate_sticky_lock']) ? '<img src="' . $settings['images_url'] . '/icons/show_sticky.gif" align="right" alt="" style="margin: 0;" />' : '', ' ', $topic['first_post']['link'], ' <a href="', $topic['new_href'], '"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" /></a> <span class="smalltext">', $topic['pages'], '<br>',
$txt['smf88'], ' ', $topic['board']['link'], '</span></td>

(The < br > is put at the end of the first of these lines)

Quote from: jacortina on August 08, 2006, 07:00:22 PM

Quote from: rbh on August 08, 2006, 05:37:30 AM
jacortina, very much improved upon! one thing, how do i get it to use the same colors as what my forum uses? where it says subject, started by, etc etc, it should be same as within forums but it isn't.

As this code is based on that used for Unread Replies (Recent and All), it only does what that does. The query used there (and here) doesn't get/apply the group colors (doesn't query the membergroup table at all).

Quote from: RoarinRow on August 08, 2006, 05:49:40 AM
One last question jacortina, where can I make the same change of the hard return to the 'All unread topics'?  This way both my views will be consistent.

Recent.template.php

It will change both All Unread and Recent Unread.

Find:

Code Select Expand

<img src="' . $settings['images_url'] . '/icons/show_sticky.gif" align="right" alt="" style="margin: 0;" />' : '', $topic['first_post']['link'], ' <a href="', $topic['new_href'], '"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" /></a> <span class="smalltext">', $topic['pages'], ' ', $txt['smf88'], ' ', $topic['board']['link'], '</span></td>

Change to:

Code Select Expand

<img src="' . $settings['images_url'] . '/icons/show_sticky.gif" align="right" alt="" style="margin: 0;" />' : '', $topic['first_post']['link'], ' <a href="', $topic['new_href'], '"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" /></a> <span class="smalltext">', $topic['pages'], '<br>', $txt['smf88'], ' ', $topic['board']['link'], '</span></td>

$txt['smf88'] is the word 'in' -> "in [BoardName]"

If you want to change how Unread Replies are presented also...

Find:

Code Select Expand

' , $topic['is_sticky'] && !empty($settings['seperate_sticky_lock']) ? '<img src="' . $settings['images_url'] . '/icons/show_sticky.gif" align="right" alt="" style="margin: 0;" />' : '', ' ', $topic['first_post']['link'], ' <a href="', $topic['new_href'], '"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" /></a> <span class="smalltext">', $topic['pages'], '
', $txt['smf88'], ' ', $topic['board']['link'], '</span></td>


Change to:

Code Select Expand

' , $topic['is_sticky'] && !empty($settings['seperate_sticky_lock']) ? '<img src="' . $settings['images_url'] . '/icons/show_sticky.gif" align="right" alt="" style="margin: 0;" />' : '', ' ', $topic['first_post']['link'], ' <a href="', $topic['new_href'], '"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" /></a> <span class="smalltext">', $topic['pages'], '<br>',
$txt['smf88'], ' ', $topic['board']['link'], '</span></td>

(The < br > is put at the end of the first of these lines)

Thank you again jacortina!  The first part of the code for All unread topics works perfectly.  The second part but the board name below the topic name, but the topic name is not a URL.  I tried to redo the find and replace several times and I'm sure that's still my problem. 

Can you please look at that last part when you are available?   ::)

Could you supply a few lines of code around those lines from your file?

Quote from: jacortina on August 09, 2006, 01:52:26 AM
Could you supply a few lines of code around those lines from your file?

Hi, thanks.  In fact, here's the whole file attached.   :uglystupid2:

Just to confirm, the problem you experienced was with
Unread Replies, right?

If so, try -

Starting in Line 286:

Find:

<td class="windowbg', $topic['is_sticky'] && !empty($settings['seperate_sticky_lock']) ? '3' : '' , '" width="48%" valign="middle">
' , $topic['is_locked'] && !empty($settings['seperate_sticky_lock']) ? '<img src="' . $settings['images_url'] . '/icons/quick_lock.gif" align="right" alt="" style="margin: 0;" />' : '' , '
' , $topic['is_sticky'] && !empty($settings['seperate_sticky_lock']) ? '<img src="' . $settings['images_url'] . '/icons/show_sticky.gif" align="right" alt="" style="margin: 0;" />' : '', ' ', $topic['first_post']['link'], ' <a href="', $topic['new_href'], '"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" /></a> <span class="smalltext">', $topic['pages'], '
', $txt['smf88'], ' ', $topic['board']['link'], '</span></td>


Replace with:

<td class="windowbg', $topic['is_sticky'] && !empty($settings['seperate_sticky_lock']) ? '3' : '' , '" width="48%" valign="middle">
' , $topic['is_locked'] && !empty($settings['seperate_sticky_lock']) ? '<img src="' . $settings['images_url'] . '/icons/quick_lock.gif" align="right" alt="" style="margin: 0;" />' : '' , '
' , $topic['is_sticky'] && !empty($settings['seperate_sticky_lock']) ? '<img src="' . $settings['images_url'] . '/icons/show_sticky.gif" align="right" alt="" style="margin: 0;" />' : '', ' ', $topic['first_post']['link'], ' <a href="', $topic['new_href'], '"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" /></a> <span class="smalltext">', $topic['pages'], '<br>',
$txt['smf88'], ' ', $topic['board']['link'], '</span></td>


Quote from: jacortina on August 09, 2006, 03:43:35 AM
Just to confirm, the problem you experienced was with
Unread Replies, right?

If so, try -

Starting in Line 286:

Find:

Code Select Expand


<td class="windowbg', $topic['is_sticky'] && !empty($settings['seperate_sticky_lock']) ? '3' : '' , '" width="48%" valign="middle">
' , $topic['is_locked'] && !empty($settings['seperate_sticky_lock']) ? '<img src="' . $settings['images_url'] . '/icons/quick_lock.gif" align="right" alt="" style="margin: 0;" />' : '' , '
' , $topic['is_sticky'] && !empty($settings['seperate_sticky_lock']) ? '<img src="' . $settings['images_url'] . '/icons/show_sticky.gif" align="right" alt="" style="margin: 0;" />' : '', ' ', $topic['first_post']['link'], ' <a href="', $topic['new_href'], '"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" /></a> <span class="smalltext">', $topic['pages'], '
', $txt['smf88'], ' ', $topic['board']['link'], '</span></td>


Replace with:

Code Select Expand


<td class="windowbg', $topic['is_sticky'] && !empty($settings['seperate_sticky_lock']) ? '3' : '' , '" width="48%" valign="middle">
' , $topic['is_locked'] && !empty($settings['seperate_sticky_lock']) ? '<img src="' . $settings['images_url'] . '/icons/quick_lock.gif" align="right" alt="" style="margin: 0;" />' : '' , '
' , $topic['is_sticky'] && !empty($settings['seperate_sticky_lock']) ? '<img src="' . $settings['images_url'] . '/icons/show_sticky.gif" align="right" alt="" style="margin: 0;" />' : '', ' ', $topic['first_post']['link'], ' <a href="', $topic['new_href'], '"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" /></a> <span class="smalltext">', $topic['pages'], '<br>',
$txt['smf88'], ' ', $topic['board']['link'], '</span></td>


Yes it is with 'unreadreplies'.  This new code clear up the link, but the board name is still in the same line 

SHOW THE POSTER IN RECENT TOPICS?

What I would like with RC2 and 0.86 seems simple: it's just to show the poster in Recent Posts. It seems a major lack only having topic and date, but not 'who'.

Looks to me like 0.95 may have it, but I don't have this version, so could someone tell me how can I get it in 0.86? (I can see code in php files like, all ready to do it! - but I do not have the expertise to implement).

Thanks for the help and support given here!

Quote from: RoarinRow on August 09, 2006, 04:36:47 AM
Yes it is with 'unreadreplies'.  This new code clear up the link, but the board name is still in the same line

Well, the second to the last line of that code ends:


$topic['pages'], '<br>',


Which means there's a line break after the pages (or
the blank where page numbers would be).

I suppose you could try to change it to

$topic['pages'], '<br />',

for the proper form and see if that helps.

Quote from: jacortina on August 09, 2006, 11:12:29 PM

Quote from: RoarinRow on August 09, 2006, 04:36:47 AM
Yes it is with 'unreadreplies'.  This new code clear up the link, but the board name is still in the same line

Well, the second to the last line of that code ends:

Code Select Expand


$topic['pages'], '<br>',


Which means there's a line break after the pages (or
the blank where page numbers would be).

I suppose you could try to change it to

Code Select Expand


$topic['pages'], '<br />',

for the proper form and see if that helps.

Thank you, I found the problem.  It was 'user issue'  I had a couple of versions while I was testing, I guess I uploaded the wrong version.

All is well, thanks again.   :up:

any idea how i can get the topic to be sorted on 'creation date' as opposed to 'reply date' ?

What I want to achieve is that the topic does not get bumped up if someone replies to it...but can only be over taken by newer threads which are started

Quote from: akulion on August 19, 2006, 08:28:31 PM
any idea how i can get the topic to be sorted on 'creation date' as opposed to 'reply date' ?

What I want to achieve is that the topic does not get bumped up if someone replies to it...but can only be over taken by newer threads which are started

If using the code that I posted earlier in this thread in message:
http://www.tinyportal.net/smf/index.php?topic=596.msg58157#msg58157

You'd simply change the line:

ORDER BY t.ID_LAST_MSG DESC " . $limit_clause, __FILE__, __LINE__);


To:

ORDER BY t.ID_FIRST_MSG DESC " . $limit_clause, __FILE__, __LINE__);


Since first message ID order is in direct relation to message creation order.

While the code given is set up to present the options listed in that message, this code can be easily adapted to pull a list of topics ( t.ID_TOPIC IN (" . implode(', ', <array of topic numbers>) . ") ) or all topics in a board (t.ID_BOARD = <board number>).

Also, while this is set up to output in the style of Unread topics, the code can be changed to format the output as desired. The point of this is that the query supplies the information that it does.

I thought it best to ressurect this topic than start a new one :)

But basically how could you do it so that if there were any unread posts/topics they would have a different colour background rather than the "new" image.

Personally, I'd add new classes to the style.css for windowbgunread and windowbg2unread (use windowbg and windowbg2 as guides) and then use variables for the ones to use in the code given ($usebg is windowbg or windowbgunread; $usebg2 is windowbg2 or windowbg2unread).

But then, personally, I'd never get rid of the 'new' image. It's not just a graphic, it's a link to the  first unread messgage in the topic. Why make things LESS navigable?

Theres a link on the right anyway to the latest post so i do not see the need for it. The colour helps differentiate to the user alot quicker which threads need reading or have been missed. Ill try and see if i can manage to put something together the way you mentioned although i will probably fail  :(

thanks for the suggestion  :up:

Thats the last post, not the first unread. You're going to tell them with the background that there are new posts but take away the link to the first of the new posts. You could still give it a different background color and keep the functionality.

Just find the occurences of the windowbg and windowbg2 entries in the style sheet. Copy them, name the copies to the 'unread' versions, and give them the new background colors you want.

If you're basing this on the code from:
http://www.tinyportal.net/smf/index.php?topic=596.msg58157#msg58157

Then once you have the css in place,

Find:

echo '
<tr>
<td class="windowbg2" valign="middle" align="center" width="6%">
<img src="' . $settings['images_url'] . '/topic/' . $topic['class'] . '.gif" alt="" />
</td><td class="windowbg2" valign="middle" align="center" width="4%">
<img src="' . $topic['first_post']['icon_url'] . '" alt="" align="middle" />
</td><td class="windowbg' , $topic['is_sticky'] && !empty($settings['seperate_sticky_lock']) ? '3' : '' , '" width="48%" valign="middle">' , $topic['is_locked'] && !empty($settings['seperate_sticky_lock']) ? '
<img src="' . $settings['images_url'] . '/icons/quick_lock.gif" align="right" alt="" style="margin: 0;" />' : '' , $topic['is_sticky'] && !empty($settings['seperate_sticky_lock']) ? '
<img src="' . $settings['images_url'] . '/icons/show_sticky.gif" align="right" alt="" style="margin: 0;" />' : '', $topic['first_post']['link'];
if ($topic['new'] == 0)
{
echo '<a href="', $topic['new_href'], '"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" /></a>';
}
echo '
<span class="smalltext">', $topic['pages'], ' ', $txt['smf88'], ' ', $topic['board']['link'], '</span></td>
<td class="windowbg2" valign="middle" width="14%">
', $topic['first_post']['member']['link'], '</td>
<td class="windowbg" valign="middle" width="4%" align="center">
', $topic['replies'], '</td>
<td class="windowbg" valign="middle" width="4%" align="center">
', $topic['views'], '</td>
<td class="windowbg2" valign="middle" width="22%">
<a href="', $topic['last_post']['href'], '"><img src="', $settings['images_url'], '/icons/last_post.gif" alt="', $txt[111], '" title="', $txt[111], '" style="float: right;" /></a>
<span class="smalltext">
', $topic['last_post']['time'], '<br />
', $txt[525], ' ', $topic['last_post']['member']['link'], '
</span>
</td>
</tr>';


And replace with:

if ($topic['new'] == 0)
{
$usebg = windowbgunread;
$usebg2 = windowbg2unread;
}
else
{
$usebg = windowbg;
$usebg2 = windowbg2;
}

echo '
<tr>
<td class="'.$usebg2.'" valign="middle" align="center" width="6%">
<img src="' . $settings['images_url'] . '/topic/' . $topic['class'] . '.gif" alt="" />
</td><td class="'.$usebg2.'" valign="middle" align="center" width="4%">
<img src="' . $topic['first_post']['icon_url'] . '" alt="" align="middle" />
</td><td class="windowbg' , $topic['is_sticky'] && !empty($settings['seperate_sticky_lock']) ? '3' : '' , '" width="48%" valign="middle">' , $topic['is_locked'] && !empty($settings['seperate_sticky_lock']) ? '
<img src="' . $settings['images_url'] . '/icons/quick_lock.gif" align="right" alt="" style="margin: 0;" />' : '' , $topic['is_sticky'] && !empty($settings['seperate_sticky_lock']) ? '
<img src="' . $settings['images_url'] . '/icons/show_sticky.gif" align="right" alt="" style="margin: 0;" />' : '', $topic['first_post']['link'];
if ($topic['new'] == 0)
{
echo '<a href="', $topic['new_href'], '"><img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" /></a>';
}
echo '
<span class="smalltext">', $topic['pages'], ' ', $txt['smf88'], ' ', $topic['board']['link'], '</span></td>
<td class="'.$usebg2.'" valign="middle" width="14%">
', $topic['first_post']['member']['link'], '</td>
<td class="'.$usebg.'" valign="middle" width="4%" align="center">
', $topic['replies'], '</td>
<td class="'.$usebg.'" valign="middle" width="4%" align="center">
', $topic['views'], '</td>
<td class="'.$usebg2.'" valign="middle" width="22%">
<a href="', $topic['last_post']['href'], '"><img src="', $settings['images_url'], '/icons/last_post.gif" alt="', $txt[111], '" title="', $txt[111], '" style="float: right;" /></a>
<span class="smalltext">
', $topic['last_post']['time'], '<br />
', $txt[525], ' ', $topic['last_post']['member']['link'], '
</span>
</td>
</tr>';


And this DOES leave the 'new' icon in place.

Thanks alot that code is amazing, it also added the icons to the left which is what i wanted aswell :)

I modified it so that it didnt look too cluttered and only had the info i wanted it too, but thanks alot, you can see it at www.ps360.org

Thanks  :up:

OK. I just couldn't leave well enough alone.

Now has member color links. And can list most recently posted to 'watched' topics (topics in your notify list). And can sort by topic start (creation) date.

See code for usage. Previous parameters unchanged, so should be fine to drop into place (to enable member colors).


global $context, $settings, $scripturl, $txt, $db_prefix, $ID_MEMBER, $user_info, $modSettings, $user_profile;

//////////////////////////////////////////// ---------- Use in TP PHP Article (no title or frame from theme)
// This will give most recent XX posted to topics -OR-
// most recent XX unreplied to topics -OR-
// topics posted to in last XX hours -OR-
// most recent XX topics on topic notify list
//
// Sorts by most recent reply (descending; most recent first) -OR-
//          creation order (descending; most recent first)
//
// All in the detailed topic format
//
//
// Default
// index.php?page=##
// most recent posted to topics - will list
// number equal to  $settings['number_recent_posts']
//
// index.php?page=##;count=50 or index.php?page=##;type=last;count=50
// 50 most recently posted to topics
//
// index.php?page=##;type=unreplied or index.php?page=##;type=unreplied;count=50
// Most recent unreplied to topics - will
// list number specified in 'count' or default to
// number equal to  $settings['number_recent_posts']
//
// index.php?page=##;type=hours or index.php?page=##;type=hours;count=12
// Topics posted to in last number of hours
// specified in 'count' or default to 24.
//
// index.php?page=##;type=notify or index.php?page=##;type=notify;count=50
// Topics in topic notifcation list up to number
// specified in 'count' or a maximum of 100 topics.
//
// *** Admins Only ***
// index.php?page=##;type=notify;user=XXX or index.php?page=##;type=notify;user=XXX;count=50
// Topics in topic notifcation list of specified user up to number
// specified in 'count' or a maximum of 100 topics.
//
// Add argument order=create to sort by topic creation sequence (most recent first)
// rather than by last reply sequence

$do_query = 1;

//////////////////////////////////////////// ---------- Poor Man's Global Announcements Block (center block)
//
// $announce_topics = array(254, 568, 675, 678); // Topic ID's to be 'Announced'
//
// $heading = '<center>Announcements<center>';
// $where_clause = 't.ID_TOPIC IN (' . implode(', ', $announce_topics) . ')';
// $limit_clause = '';
// $order_clause = 't.ID_LAST_MSG DESC';
////////////////////////////////////////////   

//////////////////////////////////////////// ---------- Boardindex Most Recent Topics Arguments
//
// Comment out the Info Center's Most Recent Posts Code and Insert these lines and those below next section
// to show Most Recent Topics in full detail style instead
//
// $list_count = $settings['number_recent_posts'];
// $heading = 'Most Recently Posted To Topics';
// $where_clause = 't.ID_LAST_MSG >= ' . ($modSettings['maxMsgID'] - 50 * min($list_count, 5));
// $limit_clause = 'LIMIT ' . $list_count;
// $order_clause = 't.ID_LAST_MSG DESC';
////////////////////////////////////////////   

////////////////////////////////////////////  ------ Remove down to next mark to use in block/boardindex ------
//
if (empty($settings['number_recent_posts']))
$number_recent_posts = 20;
else
$number_recent_posts = $settings['number_recent_posts'];

        if( isset($_GET['type']) )
$list_type = $_GET['type'];
else
$list_type = 'last';

        if( isset($_GET['count']) )
$list_count = $_GET['count'];
else
{
$list_count = $number_recent_posts;
if ($list_type == 'notify')
$list_count = 100;
elseif ($list_type == 'hours')
$list_count = 24;
}

if ($list_count <= 0)
{
$list_count = $number_recent_posts;
if ($list_type == 'hours')
$list_count = 24;
}

if ($list_count > 100)
$list_count = 100;

        if( isset($_GET['order']) )
$list_order = $_GET['order'];
else
$list_order = 'lastpost';

        if( $list_order == 'create' )
$order_clause = 't.ID_FIRST_MSG DESC';
else
$order_clause = 't.ID_LAST_MSG DESC';

if ($list_type == 'hours')
{
$list_from = strtotime($list_count.' hours ago');
$where_clause = 'ml.posterTime >= ' . $list_from;
$limit_clause = ' ';
$heading = 'Topics Posted To In Last '. $list_count . ' Hours';
}
elseif ($list_type == 'unreplied')
{
$where_clause = 't.numReplies = 0';
if ($list_count == 0)
{
$limit_clause = ' ';
$heading = 'Unreplied To Topics';
}
else
{
$limit_clause = 'LIMIT ' . $list_count;
$heading = $list_count . ' Most Recent Unreplied To Topics';
}
}
elseif ($list_type == 'notify')
{
if (isset($_GET['user']) && $user_info['is_admin'])
{
$announce_topics = array();
$request = db_query("SELECT ID_TOPIC FROM {$db_prefix}log_notify WHERE ID_MEMBER = {$_GET['user']} AND ID_BOARD = 0", __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($request))
$watched_topics[] = $row['ID_TOPIC'];
mysql_free_result($request);
$heading = $list_count . ' Most Recent Topics Being Watched by User # '.$_GET['user'];
$where_clause = 't.ID_TOPIC IN (' . implode(', ', $watched_topics) . ')';
$limit_clause = 'LIMIT ' . $list_count;
if (empty($watched_topics))
$do_query = 0;
}
else
{
$announce_topics = array();
$request = db_query("SELECT ID_TOPIC FROM {$db_prefix}log_notify WHERE ID_MEMBER = {$ID_MEMBER} AND ID_BOARD = 0", __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($request))
$watched_topics[] = $row['ID_TOPIC'];
mysql_free_result($request);
$heading = $list_count . ' Most Recent Topics Being Watched';
$where_clause = 't.ID_TOPIC IN (' . implode(', ', $watched_topics) . ')';
$limit_clause = 'LIMIT ' . $list_count;
if (empty($watched_topics))
$do_query = 0;
}
}
else
{
$where_clause = 't.ID_LAST_MSG >= ' . ($modSettings['maxMsgID'] - 90 * min($list_count, 5));
$limit_clause = 'LIMIT ' . $list_count;
$heading = $list_count . ' Most Recently Posted To Topics';
}
//
////////////////////////////////////////////  ------ Remove up to first mark to use in block/boardindex ------

$stable_icons = array('xx', 'thumbup', 'thumbdown', 'exclamation', 'question', 'lamp', 'smiley', 'angry', 'cheesy', 'grin', 'sad', 'wink', 'moved', 'recycled', 'wireless');
$icon_sources = array();
foreach ($stable_icons as $icon)
$icon_sources[$icon] = 'images_url';

$topics = array();

if ($do_query == 1)
{
$request = db_query("
SELECT
ms.subject AS firstSubject, ms.posterTime AS firstPosterTime, ms.ID_TOPIC, t.ID_BOARD, b.name AS bname,
t.numReplies, t.numViews, ms.ID_MEMBER AS ID_FIRST_MEMBER, ml.ID_MEMBER AS ID_LAST_MEMBER,
ml.posterTime AS lastPosterTime, IFNULL(mems.realName, ms.posterName) AS firstPosterName,
IFNULL(meml.realName, ml.posterName) AS lastPosterName, ml.subject AS lastSubject, b.memberGroups,
ml.icon AS lastIcon, ms.icon AS firstIcon, t.ID_POLL, t.isSticky, t.locked, ml.modifiedTime AS lastModifiedTime,
LEFT(ml.body, 384) AS lastBody, LEFT(ms.body, 384) AS firstBody,
ml.smileysEnabled AS lastSmileys, ms.smileysEnabled AS firstSmileys, t.ID_FIRST_MSG, t.ID_LAST_MSG,"
. ($user_info['is_guest'] ? '1 AS isRead, 0 AS new_from' : '
IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, 0)) >= ml.ID_MSG_MODIFIED AS isRead,
IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, -1)) + 1 AS new_from') . "
FROM ({$db_prefix}messages AS ms, {$db_prefix}messages AS ml, {$db_prefix}topics AS t, {$db_prefix}boards AS b)
LEFT JOIN {$db_prefix}members AS mems ON (mems.ID_MEMBER = ms.ID_MEMBER)
LEFT JOIN {$db_prefix}members AS meml ON (meml.ID_MEMBER = ml.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 = t.ID_BOARD AND lmr.ID_MEMBER = $ID_MEMBER)
WHERE " . $where_clause . "
AND t.ID_TOPIC = ms.ID_TOPIC
AND b.ID_BOARD = t.ID_BOARD
AND ms.ID_MSG = t.ID_FIRST_MSG
AND ml.ID_MSG = t.ID_LAST_MSG
AND " . $user_info['query_see_board'] . "
ORDER BY " . $order_clause . " " . $limit_clause, __FILE__, __LINE__);


$topic_ids = array();
while ($row = mysql_fetch_assoc($request))
{
if ($row['ID_POLL'] > 0 && $modSettings['pollMode'] == '0')
continue;

$topic_ids[] = $row['ID_TOPIC'];

// Clip the strings first because censoring is slow :/. (for some reason?)
$row['firstBody'] = strip_tags(strtr(parse_bbc($row['firstBody'], $row['firstSmileys'], $row['ID_FIRST_MSG']), array('<br />' => '
')));
if (strlen($row['firstBody']) > 128)
$row['firstBody'] = substr($row['firstBody'], 0, 128) . '...';
$row['lastBody'] = strip_tags(strtr(parse_bbc($row['lastBody'], $row['lastSmileys'], $row['ID_LAST_MSG']), array('<br />' => '
')));
if (strlen($row['lastBody']) > 128)
$row['lastBody'] = substr($row['lastBody'], 0, 128) . '...';

$row['lastSubject'] = $row['firstSubject'];
$row['lastBody'] = $row['firstBody'];

// Decide how many pages the topic should have.
$topic_length = $row['numReplies'] + 1;
if ($topic_length > $modSettings['defaultMaxMessages'])
{
$tmppages = array();
$tmpa = 1;
for ($tmpb = 0; $tmpb < $topic_length; $tmpb += $modSettings['defaultMaxMessages'])
{
$tmppages[] = '<a href="' . $scripturl . '?topic=' . $row['ID_TOPIC'] . '.' . $tmpb . ';topicseen">' . $tmpa . '</a>';
$tmpa++;
}
// Show links to all the pages?
if (count($tmppages) <= 5)
$pages = 'ÂÃ,« ' . implode(' ', $tmppages);
// Or skip a few?
else
$pages = 'ÂÃ,« ' . $tmppages[0] . ' ' . $tmppages[1] . ' ... ' . $tmppages[count($tmppages) - 2] . ' ' . $tmppages[count($tmppages) - 1];

if (!empty($modSettings['enableAllMessages']) && $topic_length < $modSettings['enableAllMessages'])
$pages .= '  <a href="' . $scripturl . '?topic=' . $row['ID_TOPIC'] . '.0;all">' . $txt[190] . '</a>';
$pages .= ' ÂÃ,»';
}
else
$pages = '';

// We need to check the topic icons exist... you can never be too sure!
if (empty($modSettings['messageIconChecks_disable']))
{
// First icon first... as you'd expect.
if (!isset($icon_sources[$row['firstIcon']]))
$icon_sources[$row['firstIcon']] = file_exists($settings['theme_dir'] . '/images/post/' . $row['firstIcon'] . '.gif') ? 'images_url' : 'default_images_url';
// Last icon... last... duh.
if (!isset($icon_sources[$row['lastIcon']]))
$icon_sources[$row['lastIcon']] = file_exists($settings['theme_dir'] . '/images/post/' . $row['lastIcon'] . '.gif') ? 'images_url' : 'default_images_url';
}

        $dummy = array();
        $dummy[] = $row['ID_FIRST_MEMBER'];
        $dummy[] = $row['ID_LAST_MEMBER'];
        loadMemberData($dummy);
        $profile_first = &$user_profile[$row['ID_FIRST_MEMBER']];
        $profile_last = &$user_profile[$row['ID_LAST_MEMBER']];

// And build the array.
$topics[$row['ID_TOPIC']] = array(
'id' => $row['ID_TOPIC'],
'first_post' => array(
'id' => $row['ID_FIRST_MSG'],
'member' => array(
'name' => $row['firstPosterName'],
'id' => $row['ID_FIRST_MEMBER'],
'href' => $scripturl . '?action=profile;u=' . $row['ID_FIRST_MEMBER'],
'link' => !empty($row['ID_FIRST_MEMBER']) ? '<a href="' . $scripturl . '?action=profile;u=' . $row['ID_FIRST_MEMBER'] . '" title="' . $txt[92] . ' ' . $row['firstPosterName'] . '">' . '<font color="' . $profile_first['member_group_color'] . '">' . $row['firstPosterName'] . '</font>' . '</a>' : $row['firstPosterName']
),
'time' => timeformat($row['firstPosterTime']),
'timestamp' => forum_time(true, $row['firstPosterTime']),
'subject' => $row['firstSubject'],
'preview' => $row['firstBody'],
'icon' => $row['firstIcon'],
'icon_url' => $settings[$icon_sources[$row['firstIcon']]] . '/post/' . $row['firstIcon'] . '.gif',
'href' => $scripturl . '?topic=' . $row['ID_TOPIC'] . '.0;topicseen',
'link' => '<a href="' . $scripturl . '?topic=' . $row['ID_TOPIC'] . '.0;topicseen">' . $row['firstSubject'] . '</a>'
),
'last_post' => array(
'id' => $row['ID_LAST_MSG'],
'member' => array(
'name' => $row['lastPosterName'],
'id' => $row['ID_LAST_MEMBER'],
'href' => $scripturl . '?action=profile;u=' . $row['ID_LAST_MEMBER'],
'link' => !empty($row['ID_LAST_MEMBER']) ? '<a href="' . $scripturl . '?action=profile;u=' . $row['ID_LAST_MEMBER'] . '">' . '<font color="' . $profile_last['member_group_color'] . '">' . $row['lastPosterName'] . '</font>' . '</a>' : $row['lastPosterName']
),
'time' => timeformat($row['lastPosterTime']),
'timestamp' => forum_time(true, $row['lastPosterTime']),
'subject' => $row['lastSubject'],
'preview' => $row['lastBody'],
'icon' => $row['lastIcon'],
'icon_url' => $settings[$icon_sources[$row['lastIcon']]] . '/post/' . $row['lastIcon'] . '.gif',
'href' => $scripturl . '?topic=' . $row['ID_TOPIC'] . ($row['numReplies'] == 0 ? '.0' : '.msg' . $row['ID_LAST_MSG']) . ';topicseen#msg' . $row['ID_LAST_MSG'],
'link' => '<a href="' . $scripturl . '?topic=' . $row['ID_TOPIC'] . ($row['numReplies'] == 0 ? '.0' : '.msg' . $row['ID_LAST_MSG']) . ';topicseen#msg' . $row['ID_LAST_MSG'] . '">' . $row['lastSubject'] . '</a>'
),
'new' => $row['isRead'],
'new_from' => $row['new_from'],
'new_href' => $scripturl . '?topic=' . $row['ID_TOPIC'] . '.msg' . $row['new_from'] . ';topicseen#new',
'href' => $scripturl . '?topic=' . $row['ID_TOPIC'] . ($row['numReplies'] == 0 ? '.0' : '.msg' . $row['new_from']) . ';topicseen' . ($row['numReplies'] == 0 ? '' : 'new'),
'link' => '<a href="' . $scripturl . '?topic=' . $row['ID_TOPIC'] . ($row['numReplies'] == 0 ? '.0' : '.msg' . $row['new_from']) . ';topicseen#msg' . $row['new_from'] . '">' . $row['firstSubject'] . '</a>',
'is_sticky' => !empty($modSettings['enableStickyTopics']) && !empty($row['isSticky']),
'is_locked' => !empty($row['locked']),
'is_poll' => $modSettings['pollMode'] == '1' && $row['ID_POLL'] > 0,
'is_hot' => $row['numReplies'] >= $modSettings['hotTopicPosts'],
'is_very_hot' => $row['numReplies'] >= $modSettings['hotTopicVeryPosts'],
'is_posted_in' => false,
'icon' => $row['firstIcon'],
'icon_url' => $settings[$icon_sources[$row['firstIcon']]] . '/post/' . $row['firstIcon'] . '.gif',
'subject' => $row['firstSubject'],
'pages' => $pages,
'replies' => $row['numReplies'],
'views' => $row['numViews'],
'board' => array(
'id' => $row['ID_BOARD'],
'name' => $row['bname'],
'href' => $scripturl . '?board=' . $row['ID_BOARD'] . '.0',
'link' => '<a href="' . $scripturl . '?board=' . $row['ID_BOARD'] . '.0">' . $row['bname'] . '</a>'
)
);

determineTopicClass($topics[$row['ID_TOPIC']]);
}
mysql_free_result($request);

if (!empty($modSettings['enableParticipation']) && !empty($topic_ids))
{
$result = db_query("
SELECT ID_TOPIC
FROM {$db_prefix}messages
WHERE ID_TOPIC IN (" . implode(', ', $topic_ids) . ")
AND ID_MEMBER = $ID_MEMBER", __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($result))
{
if (empty($topics[$row['ID_TOPIC']]['is_posted_in']))
{
$topics[$row['ID_TOPIC']]['is_posted_in'] = true;
$topics[$row['ID_TOPIC']]['class'] = 'my_' . $topics[$row['ID_TOPIC']]['class'];
}
}
mysql_free_result($result);
}

}

if (!empty($topics))
    {
    echo '
        <div class="tborder" ', $context['browser']['needs_size_fix'] && !$context['browser']['is_ie6'] ? 'style="width: 100%;margin:-4px;"' : 'style="margin:-4px;"', '>
            <table border="0" width="100%" cellspacing="1" cellpadding="1" class="bordercolor">
                <tr>';

    echo '
                    <td class="titlebg" colspan="7">', $heading, '</td>';
    echo '
                </tr>';

    echo '
<tr class="titlebg">
<td width="10%" colspan="2"> </td>
<td>', $txt[70], '
</td><td width="14%">', $txt[109], '
</td><td width="4%" align="center">', $txt[110], '
</td><td width="4%" align="center">', $txt[301], '
</td><td width="24%">', $txt[111], '
</td>
</tr>';

foreach ($topics as $topic)
{
// Do we want to seperate the sticky and lock status out?
if (!empty($settings['seperate_sticky_lock']) && strpos($topic['class'], 'sticky') !== false)
$topic['class'] = substr($topic['class'], 0, strrpos($topic['class'], '_sticky'));
if (!empty($settings['seperate_sticky_lock']) && strpos($topic['class'], 'locked') !== false)
$topic['class'] = substr($topic['class'], 0, strrpos($topic['class'], '_locked'));

echo '
<tr>
<td class="windowbg2" valign="middle" align="center" width="6%">
<img src="' . $settings['images_url'] . '/topic/' . $topic['class'] . '.gif" alt="" />
</td><td class="windowbg2" valign="middle" align="center" width="4%">
<img src="' . $topic['first_post']['icon_url'] . '" alt="" align="middle" />
</td><td class="windowbg' , $topic['is_sticky'] && !empty($settings['seperate_sticky_lock']) ? '3' : '' , '" width="48%" valign="middle">' , $topic['is_locked'] && !empty($settings['seperate_sticky_lock']) ? '
<img src="' . $settings['images_url'] . '/icons/quick_lock.gif" align="right" alt="" style="margin: 0;" />' : '' , $topic['is_sticky'] && !empty($settings['seperate_sticky_lock']) ? '
<img src="' . $settings['images_url'] . '/icons/show_sticky.gif" align="right" alt="" style="margin: 0;" />' : '', $topic['first_post']['link'];
if ($topic['new'] == 0)
{
echo '<a href="', $topic['new_href'], '"> <img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" /></a>';
}
echo '
<span class="smalltext">', $topic['pages'], '<br>', $txt['smf88'], ' ', $topic['board']['link'], '</span></td>
<td class="windowbg2" valign="middle" width="14%">
', $topic['first_post']['member']['link'], '</td>
<td class="windowbg" valign="middle" width="4%" align="center">
', $topic['replies'], '</td>
<td class="windowbg" valign="middle" width="4%" align="center">
', $topic['views'], '</td>
<td class="windowbg2" valign="middle" width="22%">
<a href="', $topic['last_post']['href'], '"><img src="', $settings['images_url'], '/icons/last_post.gif" alt="', $txt[111], '" title="', $txt[111], '" style="float: right;" /></a>
<span class="smalltext">
', $topic['last_post']['time'], '<br />
', $txt[525], ' ', $topic['last_post']['member']['link'], '
</span>
</td>
</tr>';
}

    echo '</table></div>';

    }
else
    echo '<b><u>'.$heading.'<br><br>No Topics Match Search Criteria</u></b>';


Screenshot:
(https://www.tinyportal.net/proxy.php?request=http%3A%2F%2Fimg208.imageshack.us%2Fimg208%2F6262%2Ftutorial3lh0.jpg&hash=f395174f5c8a1b48d7820258e64feb673a7e9db3)

Neat I'll have to look at i later when Im not so coded out lol

Wow, it gets better and better   :up:

 O0 :up:

gomobo gomobo gomobo gomobo

la la lu lu pom pom pupu

O0 :up:

Quote from: akulion on September 27, 2006, 07:54:19 AM
O0 :up:

gomobo gomobo gomobo gomobo

la la lu lu pom pom pupu

O0 :up:

Uh... Thanks (I think). ;)

Ur welcome...and Thanks for the bloc its great!

its a song i composed using only verbal sound effects O0 :up:

so with the new code with looks great by the way :D how do we exclude a board such as my calendar board which i only want members to get through to from the calendar?

Quote from: daftdate on September 27, 2006, 11:58:02 PM
so with the new code with looks great by the way :D how do we exclude a board such as my calendar board which i only want members to get through to from the calendar?

This isn't built on any part of the SSI Recent Topics code, so that type of exclusion wasn't built in (except based on ability to see the board at all).

Give me a few and I'll fix it up.

Here you go. Specify board(s) to exclude. Not up for messing around trying to parse a passed in board list.


global $context, $settings, $scripturl, $txt, $db_prefix, $ID_MEMBER, $user_info, $modSettings, $user_profile;

//////////////////////////////////////////// ---------- Unconditional Exclude
//
$exclude_boards = array(); // KEEP (to preserve variable declaration)
// $exclude_boards = array(5); //  Exclude single board
// $exclude_boards = array(5, 8); //  Exclude multiple boards
$ex_board_clause = !empty($exclude_boards) ? ' AND b.ID_BOARD NOT IN (' . implode(', ', $exclude_boards) . ')' : '';
//
//

//////////////////////////////////////////// ---------- Use in TP PHP Article (no title or frame from theme)
// This will give most recent XX posted to topics -OR-
// most recent XX unreplied to topics -OR-
// topics posted to in last XX hours -OR-
// most recent XX topics on topic notify list
//
// Sorts by most recent reply (descending; most recent first) -OR-
//          creation order (descending; most recent first)
//
// All in the detailed topic format
//
//
// Default
// index.php?page=##
// most recent posted to topics - will list
// number equal to  $settings['number_recent_posts']
//
// index.php?page=##;count=50 or index.php?page=##;type=last;count=50
// 50 most recently posted to topics
//
// index.php?page=##;type=unreplied or index.php?page=##;type=unreplied;count=50
// Most recent unreplied to topics - will
// list number specified in 'count' or default to
// number equal to  $settings['number_recent_posts']
//
// index.php?page=##;type=hours or index.php?page=##;type=hours;count=12
// Topics posted to in last number of hours
// specified in 'count' or default to 24.
//
// index.php?page=##;type=notify or index.php?page=##;type=notify;count=50
// Topics in topic notifcation list up to number
// specified in 'count' or a maximum of 100 topics.
//
// *** Admins Only ***
// index.php?page=##;type=notify;user=XXX or index.php?page=##;type=notify;user=XXX;count=50
// Topics in topic notifcation list of specified user up to number
// specified in 'count' or a maximum of 100 topics.
//
// Add argument order=create to sort by topic creation sequence (most recent first)
// rather than by last reply sequence

$do_query = 1;

//////////////////////////////////////////// ---------- Poor Man's Global Announcements Block (center block)
//
// $announce_topics = array(254, 568, 675, 678); // Topic ID's to be 'Announced'
//
// $heading = '<center>Announcements<center>';
// $where_clause = 't.ID_TOPIC IN (' . implode(', ', $announce_topics) . ')';
// $limit_clause = '';
// $order_clause = 't.ID_LAST_MSG DESC';
////////////////////////////////////////////   

//////////////////////////////////////////// ---------- Boardindex Most Recent Topics Arguments
//
// Comment out the Info Center's Most Recent Posts Code and Insert this
// to show Most Recent Topics in full detail style instead
//
// $list_count = $settings['number_recent_posts'];
// $heading = 'Most Recently Posted To Topics';
// $where_clause = 't.ID_LAST_MSG >= ' . ($modSettings['maxMsgID'] - 50 * min($list_count, 5));
// $limit_clause = 'LIMIT ' . $list_count;
// $order_clause = 't.ID_LAST_MSG DESC';
////////////////////////////////////////////   

////////////////////////////////////////////  ------ Remove down to next mark to use in block/boardindex ------
//
if (empty($settings['number_recent_posts']))
$number_recent_posts = 20;
else
$number_recent_posts = $settings['number_recent_posts'];

        if( isset($_GET['type']) )
$list_type = $_GET['type'];
else
$list_type = 'last';

        if( isset($_GET['count']) )
$list_count = $_GET['count'];
else
{
$list_count = $number_recent_posts;
if ($list_type == 'notify')
$list_count = 100;
elseif ($list_type == 'hours')
$list_count = 24;
}

if ($list_count <= 0)
{
$list_count = $number_recent_posts;
if ($list_type == 'hours')
$list_count = 24;
}

if ($list_count > 100)
$list_count = 100;

        if( isset($_GET['order']) )
$list_order = $_GET['order'];
else
$list_order = 'lastpost';

        if( $list_order == 'create' )
$order_clause = 't.ID_FIRST_MSG DESC';
else
$order_clause = 't.ID_LAST_MSG DESC';

if ($list_type == 'hours')
{
$list_from = strtotime($list_count.' hours ago');
$where_clause = 'ml.posterTime >= ' . $list_from;
$limit_clause = ' ';
$heading = 'Topics Posted To In Last '. $list_count . ' Hours';
}
elseif ($list_type == 'unreplied')
{
$where_clause = 't.numReplies = 0';
if ($list_count == 0)
{
$limit_clause = ' ';
$heading = 'Unreplied To Topics';
}
else
{
$limit_clause = 'LIMIT ' . $list_count;
$heading = $list_count . ' Most Recent Unreplied To Topics';
}
}
elseif ($list_type == 'notify')
{
if (isset($_GET['user']) && $user_info['is_admin'])
{
$announce_topics = array();
$request = db_query("SELECT ID_TOPIC FROM {$db_prefix}log_notify WHERE ID_MEMBER = {$_GET['user']} AND ID_BOARD = 0", __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($request))
$watched_topics[] = $row['ID_TOPIC'];
mysql_free_result($request);
$heading = $list_count . ' Most Recent Topics Being Watched by User # '.$_GET['user'];
$where_clause = 't.ID_TOPIC IN (' . implode(', ', $watched_topics) . ')';
$limit_clause = 'LIMIT ' . $list_count;
if (empty($watched_topics))
$do_query = 0;
}
else
{
$announce_topics = array();
$request = db_query("SELECT ID_TOPIC FROM {$db_prefix}log_notify WHERE ID_MEMBER = {$ID_MEMBER} AND ID_BOARD = 0", __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($request))
$watched_topics[] = $row['ID_TOPIC'];
mysql_free_result($request);
$heading = $list_count . ' Most Recent Topics Being Watched';
$where_clause = 't.ID_TOPIC IN (' . implode(', ', $watched_topics) . ')';
$limit_clause = 'LIMIT ' . $list_count;
if (empty($watched_topics))
$do_query = 0;
}
}
else
{
$where_clause = 't.ID_LAST_MSG >= ' . ($modSettings['maxMsgID'] - 90 * min($list_count, 5));
$limit_clause = 'LIMIT ' . $list_count;
$heading = $list_count . ' Most Recently Posted To Topics';
}
//
////////////////////////////////////////////  ------ Remove up to first mark to use in block/boardindex ------

$stable_icons = array('xx', 'thumbup', 'thumbdown', 'exclamation', 'question', 'lamp', 'smiley', 'angry', 'cheesy', 'grin', 'sad', 'wink', 'moved', 'recycled', 'wireless');
$icon_sources = array();
foreach ($stable_icons as $icon)
$icon_sources[$icon] = 'images_url';

$topics = array();

if ($do_query == 1)
{
$request = db_query("
SELECT
ms.subject AS firstSubject, ms.posterTime AS firstPosterTime, ms.ID_TOPIC, t.ID_BOARD, b.name AS bname,
t.numReplies, t.numViews, ms.ID_MEMBER AS ID_FIRST_MEMBER, ml.ID_MEMBER AS ID_LAST_MEMBER,
ml.posterTime AS lastPosterTime, IFNULL(mems.realName, ms.posterName) AS firstPosterName,
IFNULL(meml.realName, ml.posterName) AS lastPosterName, ml.subject AS lastSubject, b.memberGroups,
ml.icon AS lastIcon, ms.icon AS firstIcon, t.ID_POLL, t.isSticky, t.locked, ml.modifiedTime AS lastModifiedTime,
LEFT(ml.body, 384) AS lastBody, LEFT(ms.body, 384) AS firstBody,
ml.smileysEnabled AS lastSmileys, ms.smileysEnabled AS firstSmileys, t.ID_FIRST_MSG, t.ID_LAST_MSG,"
. ($user_info['is_guest'] ? '1 AS isRead, 0 AS new_from' : '
IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, 0)) >= ml.ID_MSG_MODIFIED AS isRead,
IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, -1)) + 1 AS new_from') . "
FROM ({$db_prefix}messages AS ms, {$db_prefix}messages AS ml, {$db_prefix}topics AS t, {$db_prefix}boards AS b)
LEFT JOIN {$db_prefix}members AS mems ON (mems.ID_MEMBER = ms.ID_MEMBER)
LEFT JOIN {$db_prefix}members AS meml ON (meml.ID_MEMBER = ml.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 = t.ID_BOARD AND lmr.ID_MEMBER = $ID_MEMBER)
WHERE " . $where_clause . $ex_board_clause . "
AND t.ID_TOPIC = ms.ID_TOPIC
AND b.ID_BOARD = t.ID_BOARD
AND ms.ID_MSG = t.ID_FIRST_MSG
AND ml.ID_MSG = t.ID_LAST_MSG
AND " . $user_info['query_see_board'] . "
ORDER BY " . $order_clause . " " . $limit_clause, __FILE__, __LINE__);


$topic_ids = array();
while ($row = mysql_fetch_assoc($request))
{
if ($row['ID_POLL'] > 0 && $modSettings['pollMode'] == '0')
continue;

$topic_ids[] = $row['ID_TOPIC'];

// Clip the strings first because censoring is slow :/. (for some reason?)
$row['firstBody'] = strip_tags(strtr(parse_bbc($row['firstBody'], $row['firstSmileys'], $row['ID_FIRST_MSG']), array('<br />' => '
')));
if (strlen($row['firstBody']) > 128)
$row['firstBody'] = substr($row['firstBody'], 0, 128) . '...';
$row['lastBody'] = strip_tags(strtr(parse_bbc($row['lastBody'], $row['lastSmileys'], $row['ID_LAST_MSG']), array('<br />' => '
')));
if (strlen($row['lastBody']) > 128)
$row['lastBody'] = substr($row['lastBody'], 0, 128) . '...';

$row['lastSubject'] = $row['firstSubject'];
$row['lastBody'] = $row['firstBody'];

// Decide how many pages the topic should have.
$topic_length = $row['numReplies'] + 1;
if ($topic_length > $modSettings['defaultMaxMessages'])
{
$tmppages = array();
$tmpa = 1;
for ($tmpb = 0; $tmpb < $topic_length; $tmpb += $modSettings['defaultMaxMessages'])
{
$tmppages[] = '<a href="' . $scripturl . '?topic=' . $row['ID_TOPIC'] . '.' . $tmpb . ';topicseen">' . $tmpa . '</a>';
$tmpa++;
}
// Show links to all the pages?
if (count($tmppages) <= 5)
$pages = 'ÂÃ,« ' . implode(' ', $tmppages);
// Or skip a few?
else
$pages = 'ÂÃ,« ' . $tmppages[0] . ' ' . $tmppages[1] . ' ... ' . $tmppages[count($tmppages) - 2] . ' ' . $tmppages[count($tmppages) - 1];

if (!empty($modSettings['enableAllMessages']) && $topic_length < $modSettings['enableAllMessages'])
$pages .= '  <a href="' . $scripturl . '?topic=' . $row['ID_TOPIC'] . '.0;all">' . $txt[190] . '</a>';
$pages .= ' ÂÃ,»';
}
else
$pages = '';

// We need to check the topic icons exist... you can never be too sure!
if (empty($modSettings['messageIconChecks_disable']))
{
// First icon first... as you'd expect.
if (!isset($icon_sources[$row['firstIcon']]))
$icon_sources[$row['firstIcon']] = file_exists($settings['theme_dir'] . '/images/post/' . $row['firstIcon'] . '.gif') ? 'images_url' : 'default_images_url';
// Last icon... last... duh.
if (!isset($icon_sources[$row['lastIcon']]))
$icon_sources[$row['lastIcon']] = file_exists($settings['theme_dir'] . '/images/post/' . $row['lastIcon'] . '.gif') ? 'images_url' : 'default_images_url';
}

        $dummy = array();
        $dummy[] = $row['ID_FIRST_MEMBER'];
        $dummy[] = $row['ID_LAST_MEMBER'];
        loadMemberData($dummy);
        $profile_first = &$user_profile[$row['ID_FIRST_MEMBER']];
        $profile_last = &$user_profile[$row['ID_LAST_MEMBER']];

// And build the array.
$topics[$row['ID_TOPIC']] = array(
'id' => $row['ID_TOPIC'],
'first_post' => array(
'id' => $row['ID_FIRST_MSG'],
'member' => array(
'name' => $row['firstPosterName'],
'id' => $row['ID_FIRST_MEMBER'],
'href' => $scripturl . '?action=profile;u=' . $row['ID_FIRST_MEMBER'],
'link' => !empty($row['ID_FIRST_MEMBER']) ? '<a href="' . $scripturl . '?action=profile;u=' . $row['ID_FIRST_MEMBER'] . '" title="' . $txt[92] . ' ' . $row['firstPosterName'] . '">' . '<font color="' . $profile_first['member_group_color'] . '">' . $row['firstPosterName'] . '</font>' . '</a>' : $row['firstPosterName']
),
'time' => timeformat($row['firstPosterTime']),
'timestamp' => forum_time(true, $row['firstPosterTime']),
'subject' => $row['firstSubject'],
'preview' => $row['firstBody'],
'icon' => $row['firstIcon'],
'icon_url' => $settings[$icon_sources[$row['firstIcon']]] . '/post/' . $row['firstIcon'] . '.gif',
'href' => $scripturl . '?topic=' . $row['ID_TOPIC'] . '.0;topicseen',
'link' => '<a href="' . $scripturl . '?topic=' . $row['ID_TOPIC'] . '.0;topicseen">' . $row['firstSubject'] . '</a>'
),
'last_post' => array(
'id' => $row['ID_LAST_MSG'],
'member' => array(
'name' => $row['lastPosterName'],
'id' => $row['ID_LAST_MEMBER'],
'href' => $scripturl . '?action=profile;u=' . $row['ID_LAST_MEMBER'],
'link' => !empty($row['ID_LAST_MEMBER']) ? '<a href="' . $scripturl . '?action=profile;u=' . $row['ID_LAST_MEMBER'] . '">' . '<font color="' . $profile_last['member_group_color'] . '">' . $row['lastPosterName'] . '</font>' . '</a>' : $row['lastPosterName']
),
'time' => timeformat($row['lastPosterTime']),
'timestamp' => forum_time(true, $row['lastPosterTime']),
'subject' => $row['lastSubject'],
'preview' => $row['lastBody'],
'icon' => $row['lastIcon'],
'icon_url' => $settings[$icon_sources[$row['lastIcon']]] . '/post/' . $row['lastIcon'] . '.gif',
'href' => $scripturl . '?topic=' . $row['ID_TOPIC'] . ($row['numReplies'] == 0 ? '.0' : '.msg' . $row['ID_LAST_MSG']) . ';topicseen#msg' . $row['ID_LAST_MSG'],
'link' => '<a href="' . $scripturl . '?topic=' . $row['ID_TOPIC'] . ($row['numReplies'] == 0 ? '.0' : '.msg' . $row['ID_LAST_MSG']) . ';topicseen#msg' . $row['ID_LAST_MSG'] . '">' . $row['lastSubject'] . '</a>'
),
'new' => $row['isRead'],
'new_from' => $row['new_from'],
'new_href' => $scripturl . '?topic=' . $row['ID_TOPIC'] . '.msg' . $row['new_from'] . ';topicseen#new',
'href' => $scripturl . '?topic=' . $row['ID_TOPIC'] . ($row['numReplies'] == 0 ? '.0' : '.msg' . $row['new_from']) . ';topicseen' . ($row['numReplies'] == 0 ? '' : 'new'),
'link' => '<a href="' . $scripturl . '?topic=' . $row['ID_TOPIC'] . ($row['numReplies'] == 0 ? '.0' : '.msg' . $row['new_from']) . ';topicseen#msg' . $row['new_from'] . '">' . $row['firstSubject'] . '</a>',
'is_sticky' => !empty($modSettings['enableStickyTopics']) && !empty($row['isSticky']),
'is_locked' => !empty($row['locked']),
'is_poll' => $modSettings['pollMode'] == '1' && $row['ID_POLL'] > 0,
'is_hot' => $row['numReplies'] >= $modSettings['hotTopicPosts'],
'is_very_hot' => $row['numReplies'] >= $modSettings['hotTopicVeryPosts'],
'is_posted_in' => false,
'icon' => $row['firstIcon'],
'icon_url' => $settings[$icon_sources[$row['firstIcon']]] . '/post/' . $row['firstIcon'] . '.gif',
'subject' => $row['firstSubject'],
'pages' => $pages,
'replies' => $row['numReplies'],
'views' => $row['numViews'],
'board' => array(
'id' => $row['ID_BOARD'],
'name' => $row['bname'],
'href' => $scripturl . '?board=' . $row['ID_BOARD'] . '.0',
'link' => '<a href="' . $scripturl . '?board=' . $row['ID_BOARD'] . '.0">' . $row['bname'] . '</a>'
)
);

determineTopicClass($topics[$row['ID_TOPIC']]);
}
mysql_free_result($request);

if (!empty($modSettings['enableParticipation']) && !empty($topic_ids))
{
$result = db_query("
SELECT ID_TOPIC
FROM {$db_prefix}messages
WHERE ID_TOPIC IN (" . implode(', ', $topic_ids) . ")
AND ID_MEMBER = $ID_MEMBER", __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($result))
{
if (empty($topics[$row['ID_TOPIC']]['is_posted_in']))
{
$topics[$row['ID_TOPIC']]['is_posted_in'] = true;
$topics[$row['ID_TOPIC']]['class'] = 'my_' . $topics[$row['ID_TOPIC']]['class'];
}
}
mysql_free_result($result);
}

}

if (!empty($topics))
    {
    echo '
        <div class="tborder" ', $context['browser']['needs_size_fix'] && !$context['browser']['is_ie6'] ? 'style="width: 100%;margin:-4px;"' : 'style="margin:-4px;"', '>
            <table border="0" width="100%" cellspacing="1" cellpadding="1" class="bordercolor">
                <tr>';

    echo '
                    <td class="titlebg" colspan="7">', $heading, '</td>';
    echo '
                </tr>';

    echo '
<tr class="titlebg">
<td width="10%" colspan="2"> </td>
<td>', $txt[70], '
</td><td width="14%">', $txt[109], '
</td><td width="4%" align="center">', $txt[110], '
</td><td width="4%" align="center">', $txt[301], '
</td><td width="24%">', $txt[111], '
</td>
</tr>';

foreach ($topics as $topic)
{
// Do we want to seperate the sticky and lock status out?
if (!empty($settings['seperate_sticky_lock']) && strpos($topic['class'], 'sticky') !== false)
$topic['class'] = substr($topic['class'], 0, strrpos($topic['class'], '_sticky'));
if (!empty($settings['seperate_sticky_lock']) && strpos($topic['class'], 'locked') !== false)
$topic['class'] = substr($topic['class'], 0, strrpos($topic['class'], '_locked'));

echo '
<tr>
<td class="windowbg2" valign="middle" align="center" width="6%">
<img src="' . $settings['images_url'] . '/topic/' . $topic['class'] . '.gif" alt="" />
</td><td class="windowbg2" valign="middle" align="center" width="4%">
<img src="' . $topic['first_post']['icon_url'] . '" alt="" align="middle" />
</td><td class="windowbg' , $topic['is_sticky'] && !empty($settings['seperate_sticky_lock']) ? '3' : '' , '" width="48%" valign="middle">' , $topic['is_locked'] && !empty($settings['seperate_sticky_lock']) ? '
<img src="' . $settings['images_url'] . '/icons/quick_lock.gif" align="right" alt="" style="margin: 0;" />' : '' , $topic['is_sticky'] && !empty($settings['seperate_sticky_lock']) ? '
<img src="' . $settings['images_url'] . '/icons/show_sticky.gif" align="right" alt="" style="margin: 0;" />' : '', $topic['first_post']['link'];
if ($topic['new'] == 0)
{
echo '<a href="', $topic['new_href'], '"> <img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" /></a>';
}
echo '
<span class="smalltext">', $topic['pages'], '<br>', $txt['smf88'], ' ', $topic['board']['link'], '</span></td>
<td class="windowbg2" valign="middle" width="14%">
', $topic['first_post']['member']['link'], '</td>
<td class="windowbg" valign="middle" width="4%" align="center">
', $topic['replies'], '</td>
<td class="windowbg" valign="middle" width="4%" align="center">
', $topic['views'], '</td>
<td class="windowbg2" valign="middle" width="22%">
<a href="', $topic['last_post']['href'], '"><img src="', $settings['images_url'], '/icons/last_post.gif" alt="', $txt[111], '" title="', $txt[111], '" style="float: right;" /></a>
<span class="smalltext">
', $topic['last_post']['time'], '<br />
', $txt[525], ' ', $topic['last_post']['member']['link'], '
</span>
</td>
</tr>';
}

    echo '</table></div>';

    }
else
    echo '<b><u>'.$heading.'<br><br>No Topics Match Search Criteria</u></b>';


Screenshot:
(https://www.tinyportal.net/proxy.php?request=http%3A%2F%2Fimg208.imageshack.us%2Fimg208%2F753%2Ftutorial2jm0.jpg&hash=d9069b431a9825469b7c8e03ff8c0fb264c99bd1)