$sql_start = request_var('start', 0);
$sql_limit = request_var('limit', $config['blog_postlimit']);
$template->assign_vars(array('SCRIPT_NAME' => 'blog', 'U_NEW_POST' => append_sid("{$phpbb_root_path}blog.{$phpEx}", array($act_name => 'post_blog')), 'S_NEW_POST' => $auth->acl_get('u_blog_post') ? true : false, 'ACT_NAME' => $act_name, 'U_BLOG_MANAGE' => $auth->acl_get('a_blog_manage') ? true : false, 'U_BLOG_INDEX' => append_sid("{$phpbb_root_path}blog.{$phpEx}"), 'NEW_POST' => $user->img('button_article_new', $user->lang('NEW_POST')), 'OVERALL_BLOG_DESC' => $config['blog_description'], 'U_BLOG_FEED' => append_sid("{$phpbb_root_path}blog.rss.{$phpEx}"), 'S_CAT_ENABLED' => $config['blog_cat_on'] ? true : false, 'S_TAGCLOUD_ENABLED' => $config['blog_tag_on'] ? true : false, 'S_RSS_ENABLED' => $config['blog_rss_feed_on'] ? true : false));
$template->assign_block_vars('navlinks', array('FORUM_NAME' => $config['blog_title'], 'U_VIEW_FORUM' => append_sid("{$phpbb_root_path}blog.{$phpEx}")));
if (!$config['blog_on']) {
$message = !empty($config['blog_off_msg']) ? $config['blog_off_msg'] : $user->lang('BLOG_DISABLED');
if (!$auth->acl_get('a_')) {
trigger_error($message);
}
$template->assign_vars(array('S_BLOG_DISABLED' => true, 'BLOG_DISABLED' => $message));
}
if ($config['blog_cat_on']) {
blog::get_category_list(5, 'catrow');
}
if ($config['blog_tag_on']) {
blog::get_tag_cloud();
}
switch ($action) {
default:
case 'index':
$sql_limit = $sql_limit > MAX_BLOG_CNT_DISPLAY ? MAX_BLOG_CNT_DISPLAY : $sql_limit;
$pagination_url = append_sid("{$phpbb_root_path}blog.{$phpEx}");
$sql_ary = array('SELECT' => 'b.*,
ct.cat_title,ct.cat_id,
u.username,u.user_colour,u.user_id', 'FROM' => array(BLOGS_TABLE => 'b', BLOG_CATS_TABLE => 'ct', USERS_TABLE => 'u'), 'WHERE' => 'ct.cat_id = b.blog_cat_id AND u.user_id = b.blog_poster_id', 'ORDER_BY' => 'b.blog_id DESC');
$sql = $db->sql_build_query('SELECT', $sql_ary);
$result = $db->sql_query_limit($sql, $sql_limit, $sql_start);
while ($blogrow = $db->sql_fetchrow($result)) {
$blogrow['bbcode_options'] = ($blogrow['enable_bbcode'] ? OPTION_FLAG_BBCODE : 0) + ($blogrow['enable_smilies'] ? OPTION_FLAG_SMILIES : 0) + ($blogrow['enable_magic_url'] ? OPTION_FLAG_LINKS : 0);
$text = generate_text_for_display($blogrow['blog_text'], $blogrow['bbcode_uid'], $blogrow['bbcode_bitfield'], $blogrow['bbcode_options']);
//Generate the URL for the blog
