[Request] a code from Punbb Forum to SMF Forum

[MoneyMan]

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!