if (confirm_box(true)) {
blog::delete_cmnt($cid, $blog_id);
$u_action = append_sid("{$phpbb_root_path}blog.{$phpEx}", array($act_name => 'view', 'id' => $blog_id));
meta_refresh('3', $u_action);
trigger_error($user->lang['GENERIC_SUCCESS'] . '<BR /><BR /><a href="' . $u_action . '">' . $user->lang['RETURN'] . '</a>');
} else {
$s_hidden_fields = build_hidden_fields(array('submit' => true, 'cid' => $cid, 'blog_id' => $blog_id));
confirm_box(false, 'CONF_DEL_CMNT', $s_hidden_fields);
trigger_error($user->lang['GENERIC_ERROR']);
}
break;
case 'tag':
$tag = request_var('t', '', true);
$tag = utf8_normalize_nfc($tag);
$tag = $db->sql_escape($tag);
$sql_ary = array('SELECT' => 'b.*, COUNT(c.cmnt_id) AS cmnt_count, ct.cat_title, u.username, u.user_colour', 'FROM' => array(BLOGS_TABLE => 'b', BLOG_CMNTS_TABLE => 'c', BLOG_CATS_TABLE => 'ct', USERS_TABLE => 'u'), 'WHERE' => "ct.cat_id = b.blog_cat_id\n\t\t\t\t\t\tAND c.cmnt_blog_id = b.blog_id\n\t\t\t\t\t\tAND u.user_id = b.blog_poster_id\n\t\t\t\t\t\tAND b.blog_tags LIKE '%{$tag}%'", 'ORDER_BY' => 'b.blog_id DESC');
$sql = $db->sql_build_query('SELECT', $sql_ary);
$result = $db->sql_query($sql);
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']);
$url = append_sid("{$phpbb_root_path}blog.{$phpEx}", array($act_name => 'view', 'id' => $blogrow['blog_id']));
$message = blog::truncate($text, $config['blog_short_msg'], '...<a href="' . $url . '">' . $user->lang('VIEW_MORE') . '</a>', '[SNIP]', false, true);
$template->assign_block_vars('blogrow', array('S_ROW_COUNT' => count($blogrow['blog_id']), 'BLOG_TITLE' => $blogrow['blog_title'], 'CAT_TITLE' => $blogrow['cat_title'], 'U_CAT' => append_sid("{$phpbb_root_path}blog.{$phpEx}", array($act_name => 'cat', 'cid' => $blogrow['blog_cat_id'])), 'TIME' => $user->format_date($blogrow['blog_posted_time']), 'BLOG_DESC' => $blogrow['blog_title'], 'U_BLOG' => append_sid("{$phpbb_root_path}blog.{$phpEx}", array($act_name => 'view', 'id' => $blogrow['blog_id'])), 'CMNT_COUNT' => $blogrow['cmnt_count'], 'CMNT_VIEW' => $blogrow['cmnt_count'] ? $user->lang['CMNT'] : $user->lang['CMNTS'], 'BLOG_TEXT' => $message, 'VIEW_MORE' => '...<a href="' . $url . '">' . $user->lang['VIEW_MORE'] . '</a>', 'BLOG_POSTER' => get_username_string('full', $blogrow['blog_poster_id'], $blogrow['username'], $blogrow['user_colour'])));
}
page_header($user->lang['BLOG']);
$template->assign_vars(array('S_ACTION' => 'tag', 'TAG' => $tag, 'U_TAG' => append_sid("{$phpbb_root_path}blog.{$phpEx}", array($act_name => 'tag', 'tag' => $tag))));
$template->set_filenames(array('body' => 'blog_index_body.html'));
page_footer();
break;
}
