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