MoneyMan Posted July 21, 2012 Share Posted July 21, 2012 hi! Can someone replace the code from punbb to smf but it make the same job please? <?php // Get all topics $query = array( 'SELECT' => 't.id, subject, t.last_post, forum_id', 'FROM' => 'topics AS t', 'JOINS' => array( array( 'INNER JOIN' => 'forums AS f', 'ON' => 'f.id = t.forum_id' ) ), 'ORDER BY' => 't.posted DESC', 'LIMIT' => '0,10' ); $result = $forum_db->query_build($query) or error(__FILE__, __LINE__); if (!$forum_user['is_guest']) $tracked_topics = get_tracked_topics(); while ($cur_topic = $forum_db->fetch_assoc($result)) { echo '<li>'; if (!$forum_user['is_guest'] && $cur_topic['last_post'] > $forum_user['last_visit'] && (!isset($tracked_topics['topics'][$cur_topic['id']]) || $tracked_topics['topics'][$cur_topic['id']] < $cur_topic['last_post']) && (!isset($tracked_topics['forums'][ $cur_topic['forum_id'] ]) || $tracked_topics['forums'][ $cur_topic['forum_id'] ] < $cur_topic['last_post'])) echo ' '; else echo ' '; echo '<a href="'.forum_link($forum_url['topic'], array($cur_topic['id'], sef_friendly($cur_topic['subject']))).'">', $cur_topic['subject'], '</a>'; echo '</li>'; } ?> Thanks in advance! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.