page_header($user->lang('BLOG'));
$template->set_filenames(array('body' => 'blog_comment_edit_body.html'));
page_footer();
break;
case 'delete_comment':
$cid = request_var('cid', 0);
$blog_id = request_var('id', 0);
if (!$cid) {
trigger_error($user->lang['INVALID_CMNT_ID']);
} else {
if (!$auth->acl_get('a_blog_manage')) {
trigger_error($user->lang('UNAUTHED'));
}
}
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);
