Search options (Page 10 of 10)

header('Content-type: text/html; charset=utf-8');

if (!defined('FORUM_ROOT'))
    define('FORUM_ROOT', './');
 
require FORUM_ROOT.'include/common.php';

$query = array(
    'SELECT'    => 'u.id, u.username, u.num_posts',
    'FROM'        => 'users AS u',
    'ORDER BY'    => 'u.num_posts DESC',
    'LIMIT'        => '10',
);

$result = $forum_db->query_build($query) or error(__FILE__, __LINE__);

echo "<ol>\n\n";
while($user = $forum_db->fetch_assoc($result)) {
    echo "<li>";
     echo "<a href='".forum_link($forum_url['user'], $user['id'])."'>";
      echo $user['username'];
     echo "</a>";
     echo " - ".$user['num_posts'];
    echo "</li>\n";
}
echo "\n</ol>";

$query = array(
    'SELECT'    => 't.id, t.poster, t.subject, t.posted, t.first_post_id, t.last_post, t.last_post_id, t.last_poster, t.num_views, t.num_replies, t.closed, t.sticky, t.moved_to',
    'FROM'        => 'topics AS t',
    'JOINS'        => array(
        array(
            'LEFT JOIN'        => 'forum_perms AS fp',
            'ON'            => '(fp.forum_id=t.forum_id AND fp.group_id='.$forum_user['g_id'].')'
        )
    ),
    'WHERE'        => '(fp.read_forum IS NULL OR fp.read_forum=1) AND t.moved_to IS NULL',
    'ORDER BY'    => 't.last_post DESC',
    'LIMIT'        => $forum_config['p_active_topics']
);