phpBB.nl

Code: Selecteer alles

$active_topics_sql="SELECT a.topic_id,a.topic_title,  a.topic_replies,  a.topic_last_post_id, c.post_time 
			FROM phpbb_topics a, phpbb_users b, phpbb_posts c, phpbb_forums d 
			where a.topic_last_post_id=c.post_id and b.user_id=c.poster_id 
				and d.forum_id=a.forum_id 
				and d.auth_view=0 
			ORDER BY topic_last_post_id DESC 
			LIMIT 10"; 
$active_topics = $db->sql_query($active_topics_sql); 

Code: Selecteer alles

$active_topics_sql="SELECT a.topic_id,a.topic_title,  a.topic_replies,  a.topic_last_post_id, c.post_time 
         FROM phpbb_topics a, phpbb_users b, phpbb_posts c, phpbb_forums d 
         where a.topic_last_post_id=c.post_id and b.user_id=c.poster_id 
            and d.forum_id=a.forum_id=18.d.auth_view=0 
         ORDER BY topic_last_post_id DESC 
         LIMIT 10"; 
$active_topics = $db->sql_query($active_topics_sql);