Forum_id Top 5 ezPortal blocks

avdv78 · Bericht door **avdv78** » 07 dec 2003, 19:59

Hallo,

Hieronder een stuk code uit de MOD "Top 5 ezPortal blocks". Kan de code aangepast worden zodat hij alleen weergeeft uit forum id 18?

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);

hotrid · Bericht door **hotrid** » 08 dec 2003, 00:29

wat bedoel je met uit forum id 18?

Bas · Bericht door **Bas** » 08 dec 2003, 07:46

het forum bij viewforum.php?f=18

Podium4 · Bericht door **Podium4** » 08 dec 2003, 09:14

ga ff gokje wagen....:

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);