All pastes #835024 Raw Edit

Untitled

public text v1 · immutable
#835024 ·published 2007-12-28 17:14 UTC
rendered paste body
function generate_blabla()
{
	global $db, $pun_config, $lang_common, $pun_user;

$result = $db->query('SELECT c.id AS cid, c.cat_name, f.id AS fid, f.forum_name, f.forum_desc, f.redirect_url, f.moderators, f.num_topics, f.num_posts, f.last_post, f.last_post_id, f.last_poster FROM '.$db->prefix.'categories AS c INNER JOIN '.$db->prefix.'forums AS f ON c.id=f.cat_id LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE cat_id=13 ORDER BY c.disp_position, c.id, f.disp_position', true) or error('Unable to fetch category/forum list', __FILE__, __LINE__, $db->error());

$cur_category = 0;
$cat_count = 0;
$num_topics = $cur_forum['num_topics'];

while ($cur_forum = $db->fetch_assoc($result))
	$forum_field = '<a href="list.php?id='.$cur_forum['fid'].'">&raquo; '.pun_htmlspecialchars($cur_forum['forum_name']).' ('.$cur_forum['num_topics'].')</a>';
{
	
return $forum_field;
	}
}