phpBB.nl

Code: Selecteer alles

$sql = 'SELECT topic_id, topic_title, topic_replies 
FROM ' . TOPICS_TABLE . ' 
WHERE forum_id IN (' . $auth_data_sql . ') AND (topic_status <> 2) AND (topic_replies > 0) 
ORDER BY topic_replies DESC 
LIMIT ' . $return_limit;

Code: Selecteer alles

$sql = 'SELECT t1.topic_id, t1.topic_title, t1.topic_replies, t2.topic_id, t2.topic_title, t2.topic_replies
FROM ' . TOPICS_TABLE . ' t1, slave1_topics t2
WHERE t1.forum_id IN (' . $auth_data_sql . ') AND (t1.topic_status <> 2) AND (t1.topic_replies > 0) AND t2.forum_id IN (' . $auth_data_sql . ') AND (t2.topic_status <> 2) AND (t2.topic_replies > 0)
ORDER BY t1.topic_replies DESC
LIMIT ' . $return_limit;

Code: Selecteer alles

$sql = "select u.user_id, u.username, count(u.user_id) as user_posts  
FROM " . USERS_TABLE . " u, " . POSTS_TABLE . " p1, phpbb_posts p2 
WHERE (p1.poster_id = p2.poster_id) AND (u.user_id = p1.poster_id) AND (p1.post_time = p2.post_time) AND (p1.post_time > '" . $time_thismonth . "') AND (u.user_id <> " . ANONYMOUS . ")
GROUP BY user_id, username
ORDER BY user_posts DESC
LIMIT " . $return_limit;