ErnadoO / ext-phpbb-directory

		$this->db->sql_transaction('commit');

		if ($request->is_ajax())

		{

			$sql = 'SELECT COUNT(comment_id) AS nb_comments

				FROM ' . DIR_COMMENT_TABLE . '

				WHERE comment_link_id = ' . (int) $link_id;

			$result = $this->db->sql_query($sql);

			$nb_comments = (int) $this->db->sql_fetchfield('nb_comments');

			$this->db->sql_freeresult($result);

			$json_response = new \phpbb\json_response;

			$json_response->send(array(

				'success' => true,

				'MESSAGE_TITLE'		=> $this->user->lang['INFORMATION'],

				'MESSAGE_TEXT'		=> $this->user->lang['DIR_COMMENT_DELETE_OK'],

				'COMMENT_ID'		=> $comment_id,

				'TOTAL_COMMENTS'	=> $this->user->lang('DIR_NB_COMMS', $nb_comments),

			));

		}

	}

}

			), $link_id);

		}

		if ($this->request->is_ajax())

		{

			$sql = 'SELECT cat_links

				FROM ' . DIR_CAT_TABLE . '

				WHERE cat_id = ' . (int) $cat_id;

			$result = $this->db->sql_query($sql);

			$data = $this->db->sql_fetchrow($result);

			$json_response = new \phpbb\json_response;

			$json_response->send(array(

				'success' => true,

				'MESSAGE_TITLE'	=> $this->user->lang['INFORMATION'],

				'MESSAGE_TEXT'	=> $this->user->lang['DIR_DELETE_OK'],

				'LINK_ID'		=> $link_id,

				'TOTAL_LINKS'	=> $this->user->lang('DIR_NB_LINKS', (int) $data['cat_links']),

			));

		}

	}

	/**