ErnadoO / ext-phpbb-directory

search/fulltext_directory.php

Indentation +89 added lines, -89 removed lines

@@ -9,103 +9,103 @@
 
 class fulltext_directory
 {
-    /** @var \phpbb\db\driver\driver_interface */
-    protected $db;
-
-    /**
-     * Constructor.
-     *
-     * @param \phpbb\db\driver\driver_interface $db
-     */
-    public function __construct(\phpbb\db\driver\driver_interface $db)
-    {
-        $this->db = $db;
-    }
-
-    /**
-     * Performs a search on keywords depending on display specific params. You have to run split_keywords() first.
-     *
-     * @param array  $keywords_ary contains each words to search
-     * @param string $fields       contains either titleonly (link titles should be searched), desconly (only description bodies should be searched)
-     * @param string $terms        is either 'all' (use query as entered, words without prefix should default to "have to be in field") or 'any' (ignore search query parts and just return all posts that contain any of the specified words)
-     * @param array  $sort_by_sql  contains SQL code for the ORDER BY part of a query
-     * @param string $sort_key     is the key of $sort_by_sql for the selected sorting
-     * @param string $sort_dir     is either a or d representing ASC and DESC
-     * @param string $sort_days    specifies the maximum amount of days a post may be old
-     * @param array  $ex_cid_ary   specifies an array of category ids which should not be searched
-     * @param int    $cat_id       is set to 0 or a topic id, if it is not 0 then only posts in this topic should be searched
-     * @param array  &$id_ary      passed by reference, to be filled with ids for the page specified by $start and $per_page, should be ordered
-     * @param int    $start        indicates the first index of the page
-     * @param int    $per_page     number of ids each page is supposed to contain
-     *
-     * @return int total number of results
-     */
-    public function keyword_search($keywords_ary, $fields, $terms, $sort_by_sql, $sort_key, $sort_dir, $sort_days, $ex_cid_ary, $cat_id, &$id_ary, $start, $per_page)
-    {
-        $matches = [];
-
-        switch ($fields) {
-            case 'titleonly':
-                $matches[] = 'l.link_name';
-            break;
-
-            case 'desconly':
-                $matches[] = 'l.link_description';
-            break;
-
-            default:
-                $matches = ['l.link_name', 'l.link_description'];
-        }
-
-        $search_query = '';
-
-        foreach ($keywords_ary as $word) {
-            $match_search_query = '';
-            foreach ($matches as $match) {
-                $match_search_query .= (($match_search_query) ? ' OR ' : '').'LOWER('.$match.') ';
-                $match_search_query .= $this->db->sql_like_expression(str_replace('*', $this->db->get_any_char(), $this->db->get_any_char().strtolower($word).$this->db->get_any_char()));
-            }
-            $search_query .= ((!$search_query) ? '' : (($terms == 'all') ? ' AND ' : ' OR ')).'('.$match_search_query.')';
-        }
-        $direction = (($sort_dir == 'd') ? 'DESC' : 'ASC');
-
-        if (is_array($sort_by_sql[$sort_key])) {
-            $sql_sort_order = implode(' '.$direction.', ', $sort_by_sql[$sort_key]).' '.$direction;
-        } else {
-            $sql_sort_order = $sort_by_sql[$sort_key].' '.$direction;
-        }
-
-        $sql_array = [
-            'SELECT'      => 'l.link_id',
-            'FROM'        => [
-                    DIR_LINK_TABLE    => 'l', ],
-            'WHERE'        => 'l.link_active = 1
+	/** @var \phpbb\db\driver\driver_interface */
+	protected $db;
+
+	/**
+	 * Constructor.
+	 *
+	 * @param \phpbb\db\driver\driver_interface $db
+	 */
+	public function __construct(\phpbb\db\driver\driver_interface $db)
+	{
+		$this->db = $db;
+	}
+
+	/**
+	 * Performs a search on keywords depending on display specific params. You have to run split_keywords() first.
+	 *
+	 * @param array  $keywords_ary contains each words to search
+	 * @param string $fields       contains either titleonly (link titles should be searched), desconly (only description bodies should be searched)
+	 * @param string $terms        is either 'all' (use query as entered, words without prefix should default to "have to be in field") or 'any' (ignore search query parts and just return all posts that contain any of the specified words)
+	 * @param array  $sort_by_sql  contains SQL code for the ORDER BY part of a query
+	 * @param string $sort_key     is the key of $sort_by_sql for the selected sorting
+	 * @param string $sort_dir     is either a or d representing ASC and DESC
+	 * @param string $sort_days    specifies the maximum amount of days a post may be old
+	 * @param array  $ex_cid_ary   specifies an array of category ids which should not be searched
+	 * @param int    $cat_id       is set to 0 or a topic id, if it is not 0 then only posts in this topic should be searched
+	 * @param array  &$id_ary      passed by reference, to be filled with ids for the page specified by $start and $per_page, should be ordered
+	 * @param int    $start        indicates the first index of the page
+	 * @param int    $per_page     number of ids each page is supposed to contain
+	 *
+	 * @return int total number of results
+	 */
+	public function keyword_search($keywords_ary, $fields, $terms, $sort_by_sql, $sort_key, $sort_dir, $sort_days, $ex_cid_ary, $cat_id, &$id_ary, $start, $per_page)
+	{
+		$matches = [];
+
+		switch ($fields) {
+			case 'titleonly':
+				$matches[] = 'l.link_name';
+			break;
+
+			case 'desconly':
+				$matches[] = 'l.link_description';
+			break;
+
+			default:
+				$matches = ['l.link_name', 'l.link_description'];
+		}
+
+		$search_query = '';
+
+		foreach ($keywords_ary as $word) {
+			$match_search_query = '';
+			foreach ($matches as $match) {
+				$match_search_query .= (($match_search_query) ? ' OR ' : '').'LOWER('.$match.') ';
+				$match_search_query .= $this->db->sql_like_expression(str_replace('*', $this->db->get_any_char(), $this->db->get_any_char().strtolower($word).$this->db->get_any_char()));
+			}
+			$search_query .= ((!$search_query) ? '' : (($terms == 'all') ? ' AND ' : ' OR ')).'('.$match_search_query.')';
+		}
+		$direction = (($sort_dir == 'd') ? 'DESC' : 'ASC');
+
+		if (is_array($sort_by_sql[$sort_key])) {
+			$sql_sort_order = implode(' '.$direction.', ', $sort_by_sql[$sort_key]).' '.$direction;
+		} else {
+			$sql_sort_order = $sort_by_sql[$sort_key].' '.$direction;
+		}
+
+		$sql_array = [
+			'SELECT'      => 'l.link_id',
+			'FROM'        => [
+					DIR_LINK_TABLE    => 'l', ],
+			'WHERE'        => 'l.link_active = 1
 				'.(($search_query) ? 'AND ('.$search_query.')' : '').'
 				'.(count($ex_cid_ary) ? ' AND '.$this->db->sql_in_set('l.link_cat', $ex_cid_ary, true) : '').'
 				'.(($cat_id) ? ' AND '.$this->db->sql_in_set('l.link_cat', $cat_id) : '').'
 				'.(($sort_days) ? ' AND l.link_time >= '.(time() - ($sort_days * 86400)) : ''),
-            'ORDER_BY'    => $sql_sort_order,
-        ];
+			'ORDER_BY'    => $sql_sort_order,
+		];
 
-        if ($sql_sort_order[0] == 'u') {
-            $sql_array['LEFT_JOIN'][] = [
-                'FROM'    => [USERS_TABLE => 'u'],
-                'ON'      => 'u.user_id = l.link_user_id',
-            ];
-        }
+		if ($sql_sort_order[0] == 'u') {
+			$sql_array['LEFT_JOIN'][] = [
+				'FROM'    => [USERS_TABLE => 'u'],
+				'ON'      => 'u.user_id = l.link_user_id',
+			];
+		}
 
-        $sql = $this->db->sql_build_query('SELECT', $sql_array);
-        $result = $this->db->sql_query($sql);
-        while ($row = $this->db->sql_fetchrow($result)) {
-            $id_ary[] = $row['link_id'];
-        }
+		$sql = $this->db->sql_build_query('SELECT', $sql_array);
+		$result = $this->db->sql_query($sql);
+		while ($row = $this->db->sql_fetchrow($result)) {
+			$id_ary[] = $row['link_id'];
+		}
 
-        $this->db->sql_freeresult($result);
+		$this->db->sql_freeresult($result);
 
-        $total_match_count = count($id_ary);
+		$total_match_count = count($id_ary);
 
-        $id_ary = array_slice($id_ary, $start, (int) $per_page);
+		$id_ary = array_slice($id_ary, $start, (int) $per_page);
 
-        return $total_match_count;
-    }
+		return $total_match_count;
+	}
 }

Braces +15 added lines, -7 removed lines

@@ -44,7 +44,8 @@ 
     {
         $matches = [];
 
-        switch ($fields) {
+        switch ($fields)
+        {
             case 'titleonly':
                 $matches[] = 'l.link_name';
             break;
@@ -59,9 +60,11 @@ 
 
         $search_query = '';
 
-        foreach ($keywords_ary as $word) {
+        foreach ($keywords_ary as $word)
+        {
             $match_search_query = '';
-            foreach ($matches as $match) {
+            foreach ($matches as $match)
+            {
                 $match_search_query .= (($match_search_query) ? ' OR ' : '').'LOWER('.$match.') ';
                 $match_search_query .= $this->db->sql_like_expression(str_replace('*', $this->db->get_any_char(), $this->db->get_any_char().strtolower($word).$this->db->get_any_char()));
             }
@@ -69,9 +72,12 @@ 
         }
         $direction = (($sort_dir == 'd') ? 'DESC' : 'ASC');
 
-        if (is_array($sort_by_sql[$sort_key])) {
+        if (is_array($sort_by_sql[$sort_key]))
+        {
             $sql_sort_order = implode(' '.$direction.', ', $sort_by_sql[$sort_key]).' '.$direction;
-        } else {
+        }
+        else
+        {
             $sql_sort_order = $sort_by_sql[$sort_key].' '.$direction;
         }
 
@@ -87,7 +93,8 @@ 
             'ORDER_BY'    => $sql_sort_order,
         ];
 
-        if ($sql_sort_order[0] == 'u') {
+        if ($sql_sort_order[0] == 'u')
+        {
             $sql_array['LEFT_JOIN'][] = [
                 'FROM'    => [USERS_TABLE => 'u'],
                 'ON'      => 'u.user_id = l.link_user_id',
@@ -96,7 +103,8 @@ 
 
         $sql = $this->db->sql_build_query('SELECT', $sql_array);
         $result = $this->db->sql_query($sql);
-        while ($row = $this->db->sql_fetchrow($result)) {
+        while ($row = $this->db->sql_fetchrow($result))
+        {
             $id_ary[] = $row['link_id'];
         }
 

event/listener.php

Indentation +185 added lines, -185 removed lines

@@ -14,196 +14,196 @@
 
 class listener implements EventSubscriberInterface
 {
-    /** @var \phpbb\db\driver\driver_interface */
-    protected $db;
-
-    /** @var \phpbb\controller\helper */
-    protected $helper;
-
-    /** @var \phpbb\template\template */
-    protected $template;
-
-    /** @var \phpbb\user */
-    protected $user;
-
-    /** @var \ernadoo\phpbbdirectory\core\helper */
-    protected $dir_helper;
-
-    /** @var string $table_prefix */
-    protected $table_prefix;
-
-    /** @var string phpEx */
-    protected $php_ext;
-
-    /**
-     * Constructor.
-     *
-     * @param \phpbb\db\driver\driver_interface   $db           Database object
-     * @param \phpbb\controller\helper            $helper       Controller helper object
-     * @param \phpbb\template\template            $template     Template object
-     * @param \phpbb\user                         $user         User object
-     * @param \ernadoo\phpbbdirectory\core\helper $dir_helper   PhpBB Directory extension helper object
-     * @param string                              $table_prefix prefix table
-     * @param string                              $php_ext      phpEx
-     */
-    public function __construct(\phpbb\db\driver\driver_interface $db, \phpbb\controller\helper $helper, \phpbb\template\template $template, \phpbb\user $user, \ernadoo\phpbbdirectory\core\helper $dir_helper, $table_prefix, $php_ext)
-    {
-        $this->db = $db;
-        $this->helper = $helper;
-        $this->template = $template;
-        $this->user = $user;
-        $this->dir_helper = $dir_helper;
-        $this->table_prefix = $table_prefix;
-        $this->php_ext = $php_ext;
-    }
-
-    /**
-     * Assign functions defined in this class to event listeners in the core.
-     *
-     * @return array
-     * @static
-     */
-    public static function getSubscribedEvents()
-    {
-        return [
-            'core.common'                             => 'set_constants_tables',
-            'core.delete_user_after'                  => 'update_links_with_anonymous',
-            'core.page_header'                        => 'add_page_header_variables',
-            'core.permissions'                        => 'permissions_add_directory',
-            'core.user_setup'                         => 'load_language_on_setup',
-            'core.viewonline_overwrite_location'      => 'add_page_viewonline',
-        ];
-    }
-
-    /**
-     * Define table constants.
-     *
-     * @return null
-     */
-    public function set_constants_tables()
-    {
-        define('DIR_CAT_TABLE', $this->table_prefix.'directory_cats');
-        define('DIR_COMMENT_TABLE', $this->table_prefix.'directory_comments');
-        define('DIR_LINK_TABLE', $this->table_prefix.'directory_links');
-        define('DIR_VOTE_TABLE', $this->table_prefix.'directory_votes');
-        define('DIR_WATCH_TABLE', $this->table_prefix.'directory_watch');
-    }
-
-    /**
-     * Display links to Directory.
-     *
-     * @return null
-     */
-    public function add_page_header_variables()
-    {
-        $ext_theme_path = $this->dir_helper->get_ext_name().'/styles/prosilver/theme/';
-        $theme_lang_path = $this->user->lang_name;
-
-        // Prevent 'Twig_Error_Loader' if user's lang directory doesn't exist
-        if (!file_exists($ext_theme_path.$theme_lang_path.'/directory.css')) {
-            // Fallback to English language.
-            $theme_lang_path = 'en';
-        }
-
-        $this->template->assign_vars([
-            'T_DIR_THEME_LANG_NAME'  => $theme_lang_path,
-            'U_DIRECTORY'            => $this->helper->route('ernadoo_phpbbdirectory_base_controller'),
-        ]);
-    }
-
-    /**
-     * Show users as viewing Directory on Who Is Online page.
-     *
-     * @param object $event The event object
-     *
-     * @return null
-     */
-    public function add_page_viewonline($event)
-    {
-        if (strrpos($event['row']['session_page'], 'app.'.$this->php_ext.'/directory') === 0) {
-            $event['location'] = $this->user->lang['DIRECTORY'];
-            $event['location_url'] = $this->helper->route('ernadoo_phpbbdirectory_base_controller');
-        }
-    }
-
-    /**
-     * Load common language files during user setup.
-     *
-     * @param object $event The event object
-     *
-     * @return null
-     */
-    public function load_language_on_setup($event)
-    {
-        $lang_set_ext = $event['lang_set_ext'];
-        $lang_set_ext[] = [
-            'ext_name' => 'ernadoo/phpbbdirectory',
-            'lang_set' => 'directory_common',
-        ];
-        $event['lang_set_ext'] = $lang_set_ext;
-    }
-
-    /**
-     * Add administrative permissions to manage Directory.
-     *
-     * @param object $event The event object
-     *
-     * @return null
-     */
-    public function permissions_add_directory($event)
-    {
-        $categories = $event['categories'];
-        $categories = array_merge($categories, ['dir' => 'ACL_CAT_DIRECTORY']);
-        $event['categories'] = $categories;
-
-        $permissions = $event['permissions'];
-
-        $permissions = array_merge($permissions, [
-            'm_delete_dir'            => ['lang' => 'ACL_M_DELETE_DIR',            'cat' => 'dir'],
-            'm_delete_comment_dir'    => ['lang' => 'ACL_M_DELETE_COMMENT_DIR',    'cat' => 'dir'],
-            'm_edit_dir'              => ['lang' => 'ACL_M_EDIT_DIR',            'cat' => 'dir'],
-            'm_edit_comment_dir'      => ['lang' => 'ACL_M_EDIT_COMMENT_DIR',    'cat' => 'dir'],
-
-            'u_comment_dir'            => ['lang' => 'ACL_U_COMMENT_DIR',            'cat' => 'dir'],
-            'u_delete_dir'             => ['lang' => 'ACL_U_DELETE_DIR',            'cat' => 'dir'],
-            'u_delete_comment_dir'     => ['lang' => 'ACL_U_DELETE_COMMENT_DIR',    'cat' => 'dir'],
-            'u_edit_dir'               => ['lang' => 'ACL_U_EDIT_DIR',            'cat' => 'dir'],
-            'u_edit_comment_dir'       => ['lang' => 'ACL_U_EDIT_COMMENT_DIR',    'cat' => 'dir'],
-            'u_search_dir'             => ['lang' => 'ACL_U_SEARCH_DIR',            'cat' => 'dir'],
-            'u_submit_dir'             => ['lang' => 'ACL_U_SUBMIT_DIR',            'cat' => 'dir'],
-            'u_vote_dir'               => ['lang' => 'ACL_U_VOTE_DIR',            'cat' => 'dir'],
-        ]);
-
-        $event['permissions'] = $permissions;
-    }
-
-    /**
-     * Update Directory tables if needed, after deleted an user.
-     *
-     * @param object $event The event object
-     *
-     * @return null
-     */
-    public function update_links_with_anonymous($event)
-    {
-        $user_ids = $event['user_ids'];
-
-        if (!is_array($user_ids)) {
-            $user_ids = [$user_ids];
-        }
-
-        $sql = 'UPDATE '.DIR_COMMENT_TABLE.'
+	/** @var \phpbb\db\driver\driver_interface */
+	protected $db;
+
+	/** @var \phpbb\controller\helper */
+	protected $helper;
+
+	/** @var \phpbb\template\template */
+	protected $template;
+
+	/** @var \phpbb\user */
+	protected $user;
+
+	/** @var \ernadoo\phpbbdirectory\core\helper */
+	protected $dir_helper;
+
+	/** @var string $table_prefix */
+	protected $table_prefix;
+
+	/** @var string phpEx */
+	protected $php_ext;
+
+	/**
+	 * Constructor.
+	 *
+	 * @param \phpbb\db\driver\driver_interface   $db           Database object
+	 * @param \phpbb\controller\helper            $helper       Controller helper object
+	 * @param \phpbb\template\template            $template     Template object
+	 * @param \phpbb\user                         $user         User object
+	 * @param \ernadoo\phpbbdirectory\core\helper $dir_helper   PhpBB Directory extension helper object
+	 * @param string                              $table_prefix prefix table
+	 * @param string                              $php_ext      phpEx
+	 */
+	public function __construct(\phpbb\db\driver\driver_interface $db, \phpbb\controller\helper $helper, \phpbb\template\template $template, \phpbb\user $user, \ernadoo\phpbbdirectory\core\helper $dir_helper, $table_prefix, $php_ext)
+	{
+		$this->db = $db;
+		$this->helper = $helper;
+		$this->template = $template;
+		$this->user = $user;
+		$this->dir_helper = $dir_helper;
+		$this->table_prefix = $table_prefix;
+		$this->php_ext = $php_ext;
+	}
+
+	/**
+	 * Assign functions defined in this class to event listeners in the core.
+	 *
+	 * @return array
+	 * @static
+	 */
+	public static function getSubscribedEvents()
+	{
+		return [
+			'core.common'                             => 'set_constants_tables',
+			'core.delete_user_after'                  => 'update_links_with_anonymous',
+			'core.page_header'                        => 'add_page_header_variables',
+			'core.permissions'                        => 'permissions_add_directory',
+			'core.user_setup'                         => 'load_language_on_setup',
+			'core.viewonline_overwrite_location'      => 'add_page_viewonline',
+		];
+	}
+
+	/**
+	 * Define table constants.
+	 *
+	 * @return null
+	 */
+	public function set_constants_tables()
+	{
+		define('DIR_CAT_TABLE', $this->table_prefix.'directory_cats');
+		define('DIR_COMMENT_TABLE', $this->table_prefix.'directory_comments');
+		define('DIR_LINK_TABLE', $this->table_prefix.'directory_links');
+		define('DIR_VOTE_TABLE', $this->table_prefix.'directory_votes');
+		define('DIR_WATCH_TABLE', $this->table_prefix.'directory_watch');
+	}
+
+	/**
+	 * Display links to Directory.
+	 *
+	 * @return null
+	 */
+	public function add_page_header_variables()
+	{
+		$ext_theme_path = $this->dir_helper->get_ext_name().'/styles/prosilver/theme/';
+		$theme_lang_path = $this->user->lang_name;
+
+		// Prevent 'Twig_Error_Loader' if user's lang directory doesn't exist
+		if (!file_exists($ext_theme_path.$theme_lang_path.'/directory.css')) {
+			// Fallback to English language.
+			$theme_lang_path = 'en';
+		}
+
+		$this->template->assign_vars([
+			'T_DIR_THEME_LANG_NAME'  => $theme_lang_path,
+			'U_DIRECTORY'            => $this->helper->route('ernadoo_phpbbdirectory_base_controller'),
+		]);
+	}
+
+	/**
+	 * Show users as viewing Directory on Who Is Online page.
+	 *
+	 * @param object $event The event object
+	 *
+	 * @return null
+	 */
+	public function add_page_viewonline($event)
+	{
+		if (strrpos($event['row']['session_page'], 'app.'.$this->php_ext.'/directory') === 0) {
+			$event['location'] = $this->user->lang['DIRECTORY'];
+			$event['location_url'] = $this->helper->route('ernadoo_phpbbdirectory_base_controller');
+		}
+	}
+
+	/**
+	 * Load common language files during user setup.
+	 *
+	 * @param object $event The event object
+	 *
+	 * @return null
+	 */
+	public function load_language_on_setup($event)
+	{
+		$lang_set_ext = $event['lang_set_ext'];
+		$lang_set_ext[] = [
+			'ext_name' => 'ernadoo/phpbbdirectory',
+			'lang_set' => 'directory_common',
+		];
+		$event['lang_set_ext'] = $lang_set_ext;
+	}
+
+	/**
+	 * Add administrative permissions to manage Directory.
+	 *
+	 * @param object $event The event object
+	 *
+	 * @return null
+	 */
+	public function permissions_add_directory($event)
+	{
+		$categories = $event['categories'];
+		$categories = array_merge($categories, ['dir' => 'ACL_CAT_DIRECTORY']);
+		$event['categories'] = $categories;
+
+		$permissions = $event['permissions'];
+
+		$permissions = array_merge($permissions, [
+			'm_delete_dir'            => ['lang' => 'ACL_M_DELETE_DIR',            'cat' => 'dir'],
+			'm_delete_comment_dir'    => ['lang' => 'ACL_M_DELETE_COMMENT_DIR',    'cat' => 'dir'],
+			'm_edit_dir'              => ['lang' => 'ACL_M_EDIT_DIR',            'cat' => 'dir'],
+			'm_edit_comment_dir'      => ['lang' => 'ACL_M_EDIT_COMMENT_DIR',    'cat' => 'dir'],
+
+			'u_comment_dir'            => ['lang' => 'ACL_U_COMMENT_DIR',            'cat' => 'dir'],
+			'u_delete_dir'             => ['lang' => 'ACL_U_DELETE_DIR',            'cat' => 'dir'],
+			'u_delete_comment_dir'     => ['lang' => 'ACL_U_DELETE_COMMENT_DIR',    'cat' => 'dir'],
+			'u_edit_dir'               => ['lang' => 'ACL_U_EDIT_DIR',            'cat' => 'dir'],
+			'u_edit_comment_dir'       => ['lang' => 'ACL_U_EDIT_COMMENT_DIR',    'cat' => 'dir'],
+			'u_search_dir'             => ['lang' => 'ACL_U_SEARCH_DIR',            'cat' => 'dir'],
+			'u_submit_dir'             => ['lang' => 'ACL_U_SUBMIT_DIR',            'cat' => 'dir'],
+			'u_vote_dir'               => ['lang' => 'ACL_U_VOTE_DIR',            'cat' => 'dir'],
+		]);
+
+		$event['permissions'] = $permissions;
+	}
+
+	/**
+	 * Update Directory tables if needed, after deleted an user.
+	 *
+	 * @param object $event The event object
+	 *
+	 * @return null
+	 */
+	public function update_links_with_anonymous($event)
+	{
+		$user_ids = $event['user_ids'];
+
+		if (!is_array($user_ids)) {
+			$user_ids = [$user_ids];
+		}
+
+		$sql = 'UPDATE '.DIR_COMMENT_TABLE.'
 			SET comment_user_id = '.ANONYMOUS.'
 			WHERE '.$this->db->sql_in_set('comment_user_id', $user_ids);
-        $this->db->sql_query($sql);
+		$this->db->sql_query($sql);
 
-        $sql = 'UPDATE '.DIR_LINK_TABLE.'
+		$sql = 'UPDATE '.DIR_LINK_TABLE.'
 			SET link_user_id = '.ANONYMOUS.'
 			WHERE '.$this->db->sql_in_set('link_user_id', $user_ids);
-        $this->db->sql_query($sql);
+		$this->db->sql_query($sql);
 
-        $sql = 'DELETE FROM '.DIR_WATCH_TABLE.'
+		$sql = 'DELETE FROM '.DIR_WATCH_TABLE.'
 			WHERE '.$this->db->sql_in_set('user_id', $user_ids);
-        $this->db->sql_query($sql);
-    }
+		$this->db->sql_query($sql);
+	}
 }

Spacing +13 added lines, -13 removed lines

@@ -159,19 +159,19 @@
         $permissions = $event['permissions'];
 
         $permissions = array_merge($permissions, [
-            'm_delete_dir'            => ['lang' => 'ACL_M_DELETE_DIR',            'cat' => 'dir'],
-            'm_delete_comment_dir'    => ['lang' => 'ACL_M_DELETE_COMMENT_DIR',    'cat' => 'dir'],
-            'm_edit_dir'              => ['lang' => 'ACL_M_EDIT_DIR',            'cat' => 'dir'],
-            'm_edit_comment_dir'      => ['lang' => 'ACL_M_EDIT_COMMENT_DIR',    'cat' => 'dir'],
-
-            'u_comment_dir'            => ['lang' => 'ACL_U_COMMENT_DIR',            'cat' => 'dir'],
-            'u_delete_dir'             => ['lang' => 'ACL_U_DELETE_DIR',            'cat' => 'dir'],
-            'u_delete_comment_dir'     => ['lang' => 'ACL_U_DELETE_COMMENT_DIR',    'cat' => 'dir'],
-            'u_edit_dir'               => ['lang' => 'ACL_U_EDIT_DIR',            'cat' => 'dir'],
-            'u_edit_comment_dir'       => ['lang' => 'ACL_U_EDIT_COMMENT_DIR',    'cat' => 'dir'],
-            'u_search_dir'             => ['lang' => 'ACL_U_SEARCH_DIR',            'cat' => 'dir'],
-            'u_submit_dir'             => ['lang' => 'ACL_U_SUBMIT_DIR',            'cat' => 'dir'],
-            'u_vote_dir'               => ['lang' => 'ACL_U_VOTE_DIR',            'cat' => 'dir'],
+            'm_delete_dir'            => ['lang' => 'ACL_M_DELETE_DIR', 'cat' => 'dir'],
+            'm_delete_comment_dir'    => ['lang' => 'ACL_M_DELETE_COMMENT_DIR', 'cat' => 'dir'],
+            'm_edit_dir'              => ['lang' => 'ACL_M_EDIT_DIR', 'cat' => 'dir'],
+            'm_edit_comment_dir'      => ['lang' => 'ACL_M_EDIT_COMMENT_DIR', 'cat' => 'dir'],
+
+            'u_comment_dir'            => ['lang' => 'ACL_U_COMMENT_DIR', 'cat' => 'dir'],
+            'u_delete_dir'             => ['lang' => 'ACL_U_DELETE_DIR', 'cat' => 'dir'],
+            'u_delete_comment_dir'     => ['lang' => 'ACL_U_DELETE_COMMENT_DIR', 'cat' => 'dir'],
+            'u_edit_dir'               => ['lang' => 'ACL_U_EDIT_DIR', 'cat' => 'dir'],
+            'u_edit_comment_dir'       => ['lang' => 'ACL_U_EDIT_COMMENT_DIR', 'cat' => 'dir'],
+            'u_search_dir'             => ['lang' => 'ACL_U_SEARCH_DIR', 'cat' => 'dir'],
+            'u_submit_dir'             => ['lang' => 'ACL_U_SUBMIT_DIR', 'cat' => 'dir'],
+            'u_vote_dir'               => ['lang' => 'ACL_U_VOTE_DIR', 'cat' => 'dir'],
         ]);
 
         $event['permissions'] = $permissions;

Braces +6 added lines, -3 removed lines

@@ -100,7 +100,8 @@ 
         $theme_lang_path = $this->user->lang_name;
 
         // Prevent 'Twig_Error_Loader' if user's lang directory doesn't exist
-        if (!file_exists($ext_theme_path.$theme_lang_path.'/directory.css')) {
+        if (!file_exists($ext_theme_path.$theme_lang_path.'/directory.css'))
+        {
             // Fallback to English language.
             $theme_lang_path = 'en';
         }
@@ -120,7 +121,8 @@ 
      */
     public function add_page_viewonline($event)
     {
-        if (strrpos($event['row']['session_page'], 'app.'.$this->php_ext.'/directory') === 0) {
+        if (strrpos($event['row']['session_page'], 'app.'.$this->php_ext.'/directory') === 0)
+        {
             $event['location'] = $this->user->lang['DIRECTORY'];
             $event['location_url'] = $this->helper->route('ernadoo_phpbbdirectory_base_controller');
         }
@@ -188,7 +190,8 @@ 
     {
         $user_ids = $event['user_ids'];
 
-        if (!is_array($user_ids)) {
+        if (!is_array($user_ids))
+        {
             $user_ids = [$user_ids];
         }