Recent posts

[Jade Elizabeth]

since no one can make this for me, can someone make a whole new page thats linked on the index that works as this websites recent posts does?

basically i want a separate page that views TOPICS, in order of posting, and then if a new post comes along ajax highlights it and moves it up to the top of the list. i want it to have the following info: board, topic, last poster. just like in the picture.

i dont want it to behave like the recent posts allready on the forum. i want it to be fixed, and not change in relation to the users last visit, or if they have read the post or not.
i dont want it to show topics multiple times because there was 6 posts in that topic.


can someone please make this for me?

[Jade Elizabeth]

[Ryan]

bump

[rockinaway]

Right, I could have a crack at this.

So you just want a page that lists alll the topics in your forum (I would suggest the top 50 or something!, all could be drastic!)....

Then the info is listed and depending on the latest post in that topic they are ranked, and it doesn't matter if you have viewed it or not, or if you have logged out..

Is that right?

If that is, then it shouldn't be that hard...

[Jade Elizabeth]

yes thats right!!
ordered from most recent, to least recent please!!
perfect!!

if you can do the ajax thing too, that would be awesome (with a new post the topic is BUMPED up to the top, and highlighted)

[rockinaway]

I may not be able to do this quickly or straight away as I am quite busy at the moment

[Jade Elizabeth]

if theres anything i can do lemme know (and ill try to help lol)

[Assistance]

 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 = ' ';

}

elseif ($list_type == 'unreplied')

{

$where_clause = 't.numReplies = 0';

if ($list_count == 0)

{

$limit_clause = ' ';

}

else

{

$limit_clause = 'LIMIT ' . $list_count;

}

}

else

{

$where_clause = 't.ID_LAST_MSG >= ' . ($modSettings['maxMsgID'] - 90 * min($list_count, 5));

$limit_clause = 'LIMIT ' . $list_count;

}

$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 class="titlebg">

<td width="5%"> </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" align="center" width="5%">

<img src="' . $topic['last_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;" />' : '';

if ($topic['new'] == 0)

{

echo '<b>',  $topic['first_post']['link'], '</b>';

echo '<a href="', $topic['new_href'], '"> <img src="', $settings['images_url'], '/', $context['user']['language'], '/new.gif" alt="', $txt[302], '" /></a>';

}

else

{

echo $topic['first_post']['link'];

}
 

echo '

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

<td class="windowbg" valign="middle" width="12%">

', $topic['first_post']['member']['link'], '</td>

<td class="windowbg2" 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="20%">

<div align=right><span class="smalltext">

', $topic['last_post']['time'], '<br />
<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>

', $txt[525], ' ', $topic['last_post']['member']['link'], ' 

</span></div>

</td>

</tr>';

}

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

    }

[Jade Elizabeth]

what do i do with that? LOL

[digit]

Try installing the custom action mod, then create a new php action.   I just did it and it seems to work AWESOME.

Now - how would I filter OUT a board or two?

[Jade Elizabeth]

Try installing the custom action mod, then create a new php action.   I just did it and it seems to work AWESOME.

Now - how would I filter OUT a board or two?

i dunno how to use that mod...can you tell me what you did?

[digit]

i dunno how to use that mod...can you tell me what you did?

1. Install this first...

http://custom.simplemachines.org/mods/index.php?mod=331

Once that is installed, go into Features and Options in your admin panel, and click on Custom Actions.

2. Create a New Action. 

3. Name it MyRecent (no spaces)

4. Name the page title whatever you want.

Come back here and copy all that text - NOTE: to avoid funky characters, you will need to click on "Quote" of that post, then copy and paste the text, removing the  quote and php bbc tags!!!

I hope that helps!

digit

[Jade Elizabeth]

seems to work well, thankyou

[digit]

Glad I could help!  Thank you for digging for it! 

[Jade Elizabeth]

do you know how to make it display more topics?
how long does it collect from?

[Assistance]

        
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>';

- add board ID number like to the function if you want 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.


this code will look better on a custom page

[Jade Elizabeth]

^ it doesnt want to work for me

[babjusi]

@Alundra, I can take a shot at this. To pull up the top 10 posters, topics, 10 newest members  with Ajax so it refreshes every time a new post is made it bumps up etc. It will be displayed just under the Home, Help, Admin etc buttons. Let me know if you are interested

[Jade Elizabeth]

@Alundra, I can take a shot at this. To pull up the top 10 posters, topics, 10 newest members  with Ajax so it refreshes every time a new post is made it bumps up etc. It will be displayed just under the Home, Help, Admin etc buttons. Let me know if you are interested

VERY interested, could you make it about 25 topics though?

[babjusi]

I guess I can, but I wouldn''t advice it as it tends to strech and sometime it won''t load properly. With 10 topics it works like a charm