@@ -18,11 +18,11 @@ |
||
18 | 18 | 'filename' => '\ernadoo\phpbbdirectory\acp\phpbbdirectory_module', |
19 | 19 | 'title' => 'ACP_DIRECTORY', |
20 | 20 | 'modes' => array( |
21 | - '' => array('title' => 'ACP_DIRECTORY', 'auth' => 'ext_ernadoo/phpbbdirectory', 'cat' => array('')), |
|
22 | - 'main' => array('title' => 'ACP_DIRECTORY_MAIN', 'auth' => 'ext_ernadoo/phpbbdirectory', 'cat' => array('ACP_DIRECTORY')), |
|
23 | - 'settings' => array('title' => 'ACP_DIRECTORY_SETTINGS', 'auth' => 'ext_ernadoo/phpbbdirectory', 'cat' => array('ACP_DIRECTORY')), |
|
24 | - 'cat' => array('title' => 'ACP_DIRECTORY_CATS', 'auth' => 'ext_ernadoo/phpbbdirectory', 'cat' => array('ACP_DIRECTORY')), |
|
25 | - 'val' => array('title' => 'ACP_DIRECTORY_VAL', 'auth' => 'ext_ernadoo/phpbbdirectory', 'cat' => array('ACP_DIRECTORY')), |
|
21 | + '' => array('title' => 'ACP_DIRECTORY', 'auth' => 'ext_ernadoo/phpbbdirectory', 'cat' => array('')), |
|
22 | + 'main' => array('title' => 'ACP_DIRECTORY_MAIN', 'auth' => 'ext_ernadoo/phpbbdirectory', 'cat' => array('ACP_DIRECTORY')), |
|
23 | + 'settings' => array('title' => 'ACP_DIRECTORY_SETTINGS', 'auth' => 'ext_ernadoo/phpbbdirectory', 'cat' => array('ACP_DIRECTORY')), |
|
24 | + 'cat' => array('title' => 'ACP_DIRECTORY_CATS', 'auth' => 'ext_ernadoo/phpbbdirectory', 'cat' => array('ACP_DIRECTORY')), |
|
25 | + 'val' => array('title' => 'ACP_DIRECTORY_VAL', 'auth' => 'ext_ernadoo/phpbbdirectory', 'cat' => array('ACP_DIRECTORY')), |
|
26 | 26 | ), |
27 | 27 | ); |
28 | 28 | } |
@@ -23,7 +23,7 @@ discard block |
||
23 | 23 | { |
24 | 24 | return array( |
25 | 25 | 'add_tables' => array( |
26 | - $this->table_prefix . 'directory_cats' => array( |
|
26 | + $this->table_prefix.'directory_cats' => array( |
|
27 | 27 | 'COLUMNS' => array( |
28 | 28 | 'cat_id' => array('UINT', null, 'auto_increment'), |
29 | 29 | 'parent_id' => array('UINT', 0), |
@@ -57,7 +57,7 @@ discard block |
||
57 | 57 | ), |
58 | 58 | ), |
59 | 59 | |
60 | - $this->table_prefix . 'directory_comments' => array( |
|
60 | + $this->table_prefix.'directory_comments' => array( |
|
61 | 61 | 'COLUMNS' => array( |
62 | 62 | 'comment_id' => array('UINT', null, 'auto_increment'), |
63 | 63 | 'comment_date' => array('TIMESTAMP', 0), |
@@ -73,7 +73,7 @@ discard block |
||
73 | 73 | 'PRIMARY_KEY' => array('comment_id'), |
74 | 74 | ), |
75 | 75 | |
76 | - $this->table_prefix . 'directory_links' => array( |
|
76 | + $this->table_prefix.'directory_links' => array( |
|
77 | 77 | 'COLUMNS' => array( |
78 | 78 | 'link_id' => array('UINT', null, 'auto_increment'), |
79 | 79 | 'link_time' => array('TIMESTAMP', 0), |
@@ -110,7 +110,7 @@ discard block |
||
110 | 110 | ), |
111 | 111 | ), |
112 | 112 | |
113 | - $this->table_prefix . 'directory_watch' => array( |
|
113 | + $this->table_prefix.'directory_watch' => array( |
|
114 | 114 | 'COLUMNS' => array( |
115 | 115 | 'cat_id' => array('UINT', 0), |
116 | 116 | 'user_id' => array('UINT', 0), |
@@ -125,7 +125,7 @@ discard block |
||
125 | 125 | |
126 | 126 | ), |
127 | 127 | |
128 | - $this->table_prefix . 'directory_votes' => array( |
|
128 | + $this->table_prefix.'directory_votes' => array( |
|
129 | 129 | 'COLUMNS' => array( |
130 | 130 | 'vote_id' => array('UINT', null, 'auto_increment'), |
131 | 131 | 'vote_link_id' => array('UINT', 0), |
@@ -148,11 +148,11 @@ discard block |
||
148 | 148 | { |
149 | 149 | return array( |
150 | 150 | 'drop_tables' => array( |
151 | - $this->table_prefix . 'directory_cats', |
|
152 | - $this->table_prefix . 'directory_comments', |
|
153 | - $this->table_prefix . 'directory_links', |
|
154 | - $this->table_prefix . 'directory_votes', |
|
155 | - $this->table_prefix . 'directory_watch', |
|
151 | + $this->table_prefix.'directory_cats', |
|
152 | + $this->table_prefix.'directory_comments', |
|
153 | + $this->table_prefix.'directory_links', |
|
154 | + $this->table_prefix.'directory_votes', |
|
155 | + $this->table_prefix.'directory_watch', |
|
156 | 156 | ), |
157 | 157 | ); |
158 | 158 | } |
@@ -272,10 +272,10 @@ discard block |
||
272 | 272 | |
273 | 273 | foreach ($directories as $dir) |
274 | 274 | { |
275 | - if (!file_exists($this->phpbb_root_path . $dir)) |
|
275 | + if (!file_exists($this->phpbb_root_path.$dir)) |
|
276 | 276 | { |
277 | - @mkdir($this->phpbb_root_path . $dir, 0777, true); |
|
278 | - phpbb_chmod($this->phpbb_root_path . $dir, CHMOD_READ | CHMOD_WRITE); |
|
277 | + @mkdir($this->phpbb_root_path.$dir, 0777, true); |
|
278 | + phpbb_chmod($this->phpbb_root_path.$dir, CHMOD_READ | CHMOD_WRITE); |
|
279 | 279 | } |
280 | 280 | } |
281 | 281 | } |
@@ -287,7 +287,7 @@ discard block |
||
287 | 287 | */ |
288 | 288 | public function remove_directories() |
289 | 289 | { |
290 | - $dir = $this->phpbb_root_path . 'files/ext/ernadoo/phpbbdirectory/'; |
|
290 | + $dir = $this->phpbb_root_path.'files/ext/ernadoo/phpbbdirectory/'; |
|
291 | 291 | |
292 | 292 | $this->_recursive_rmdir($dir); |
293 | 293 | } |
@@ -23,7 +23,7 @@ discard block |
||
23 | 23 | */ |
24 | 24 | public function effectively_installed() |
25 | 25 | { |
26 | - return !$this->db_tools->sql_table_exists($this->table_prefix . 'directory_notifications'); |
|
26 | + return !$this->db_tools->sql_table_exists($this->table_prefix.'directory_notifications'); |
|
27 | 27 | } |
28 | 28 | |
29 | 29 | static public function depends_on() |
@@ -54,7 +54,7 @@ discard block |
||
54 | 54 | public function copy_from_notifications() |
55 | 55 | { |
56 | 56 | $sql = 'SELECT n_user_id, n_cat_id |
57 | - FROM ' . $this->table_prefix . 'directory_notifications'; |
|
57 | + FROM ' . $this->table_prefix.'directory_notifications'; |
|
58 | 58 | $result = $this->db->sql_query($sql); |
59 | 59 | |
60 | 60 | while ($row = $this->db->sql_fetchrow($result)) |
@@ -65,7 +65,7 @@ discard block |
||
65 | 65 | 'notify_status' => 1, |
66 | 66 | ); |
67 | 67 | |
68 | - $sql = 'INSERT INTO ' . $this->table_prefix . 'directory_watch ' . $this->db->sql_build_array('INSERT', $data); |
|
68 | + $sql = 'INSERT INTO '.$this->table_prefix.'directory_watch '.$this->db->sql_build_array('INSERT', $data); |
|
69 | 69 | $this->db->sql_query($sql); |
70 | 70 | } |
71 | 71 | $this->db->sql_freeresult($result); |
@@ -204,7 +204,7 @@ discard block |
||
204 | 204 | { |
205 | 205 | $selected = ($url == $url_selected) ? 'selected="selected"' : ''; |
206 | 206 | |
207 | - $select_options .= '<option value="' . $url . '" ' . $selected . '>' . parse_url($url, PHP_URL_HOST) . '</option>'; |
|
207 | + $select_options .= '<option value="'.$url.'" '.$selected.'>'.parse_url($url, PHP_URL_HOST).'</option>'; |
|
208 | 208 | } |
209 | 209 | |
210 | 210 | return $select_options; |
@@ -237,7 +237,7 @@ discard block |
||
237 | 237 | { |
238 | 238 | $selected = ($i == $order_selected) ? 'selected="selected"' : ''; |
239 | 239 | $order_substr = trim(str_replace(' ', '_', $i)); |
240 | - $tpl .= '<option value="' . $i . '" ' . $selected . '>' . $user->lang['DIR_ORDER_' . strtoupper($order_substr)] . '</option>'; |
|
240 | + $tpl .= '<option value="'.$i.'" '.$selected.'>'.$user->lang['DIR_ORDER_'.strtoupper($order_substr)].'</option>'; |
|
241 | 241 | } |
242 | 242 | |
243 | 243 | return ($tpl); |
@@ -254,6 +254,6 @@ discard block |
||
254 | 254 | $value = $filesize['value']; |
255 | 255 | |
256 | 256 | // size and maxlength must not be specified for input of type number |
257 | - return '<input type="number" id="' . $key . '" min="0" max="999999999999999" step="any" name="config[' . $key . ']" value="' . $value . '" /> <select name="' . $key . '">' . size_select_options($size_var) . '</select>'; |
|
257 | + return '<input type="number" id="'.$key.'" min="0" max="999999999999999" step="any" name="config['.$key.']" value="'.$value.'" /> <select name="'.$key.'">'.size_select_options($size_var).'</select>'; |
|
258 | 258 | } |
259 | 259 | } |
@@ -45,7 +45,7 @@ discard block |
||
45 | 45 | { |
46 | 46 | $default_reparser = new $fast_reparsers[0][0]( |
47 | 47 | $this->db, |
48 | - $this->container->getParameter('core.table_prefix') . $fast_reparsers[0][1]); |
|
48 | + $this->container->getParameter('core.table_prefix').$fast_reparsers[0][1]); |
|
49 | 49 | |
50 | 50 | $resume_data = array( |
51 | 51 | 'reparser' => 0, |
@@ -60,7 +60,7 @@ discard block |
||
60 | 60 | { |
61 | 61 | $reparser = new $fast_reparsers[$resume_data['reparser']][0]( |
62 | 62 | $this->db, |
63 | - $this->container->getParameter('core.table_prefix') . $fast_reparsers[$resume_data['reparser']][1] |
|
63 | + $this->container->getParameter('core.table_prefix').$fast_reparsers[$resume_data['reparser']][1] |
|
64 | 64 | ); |
65 | 65 | |
66 | 66 | // New reparser |
@@ -84,21 +84,21 @@ discard block |
||
84 | 84 | */ |
85 | 85 | public function __construct(\phpbb\config\config $config, \phpbb\db\driver\driver_interface $db, \phpbb\pagination $pagination, \phpbb\language\language $language, \phpbb\log\log $log, \phpbb\notification\manager $notification, \phpbb\request\request $request, \phpbb\template\template $template, \phpbb\user $user, \ernadoo\phpbbdirectory\core\categorie $categorie, \ernadoo\phpbbdirectory\core\link $link, $root_path, $php_ext) |
86 | 86 | { |
87 | - $this->config = $config; |
|
88 | - $this->db = $db; |
|
89 | - $this->pagination = $pagination; |
|
87 | + $this->config = $config; |
|
88 | + $this->db = $db; |
|
89 | + $this->pagination = $pagination; |
|
90 | 90 | $this->language = $language; |
91 | 91 | $this->phpbb_log = $log; |
92 | - $this->notification = $notification; |
|
93 | - $this->request = $request; |
|
92 | + $this->notification = $notification; |
|
93 | + $this->request = $request; |
|
94 | 94 | $this->template = $template; |
95 | 95 | $this->user = $user; |
96 | 96 | $this->categorie = $categorie; |
97 | 97 | $this->link = $link; |
98 | 98 | $this->root_path = $root_path; |
99 | - $this->php_ext = $php_ext; |
|
99 | + $this->php_ext = $php_ext; |
|
100 | 100 | |
101 | - $this->action = $this->request->variable('action', ''); |
|
101 | + $this->action = $this->request->variable('action', ''); |
|
102 | 102 | } |
103 | 103 | |
104 | 104 | /** |
@@ -127,14 +127,14 @@ discard block |
||
127 | 127 | global $phpbb_admin_path; |
128 | 128 | |
129 | 129 | // Sort keys |
130 | - $sort_days = $this->request->variable('st', 0); |
|
130 | + $sort_days = $this->request->variable('st', 0); |
|
131 | 131 | $sort_key = $this->request->variable('sk', 't'); |
132 | 132 | $sort_dir = $this->request->variable('sd', 'd'); |
133 | 133 | |
134 | 134 | // Number of entries to display |
135 | 135 | $per_page = $this->request->variable('links_per_page', (int) $this->config['dir_show']); |
136 | 136 | |
137 | - $start = $this->request->variable('start', 0); |
|
137 | + $start = $this->request->variable('start', 0); |
|
138 | 138 | |
139 | 139 | // Categorie ordering options |
140 | 140 | $limit_days = array(0 => $this->language->lang('SEE_ALL'), 1 => $this->language->lang('1_DAY'), 7 => $this->language->lang('7_DAYS'), 14 => $this->language->lang('2_WEEKS'), 30 => $this->language->lang('1_MONTH'), 90 => $this->language->lang('3_MONTHS'), 180 => $this->language->lang('6_MONTHS'), 365 => $this->language->lang('1_YEAR')); |
@@ -150,15 +150,15 @@ discard block |
||
150 | 150 | |
151 | 151 | if (is_array($sort_by_sql[$sort_key])) |
152 | 152 | { |
153 | - $sql_sort_order = implode(' ' . $direction . ', ', $sort_by_sql[$sort_key]) . ' ' . $direction; |
|
153 | + $sql_sort_order = implode(' '.$direction.', ', $sort_by_sql[$sort_key]).' '.$direction; |
|
154 | 154 | } |
155 | 155 | else |
156 | 156 | { |
157 | - $sql_sort_order = $sort_by_sql[$sort_key] . ' ' . $direction; |
|
157 | + $sql_sort_order = $sort_by_sql[$sort_key].' '.$direction; |
|
158 | 158 | } |
159 | 159 | |
160 | 160 | $sql = 'SELECT COUNT(1) AS total_links |
161 | - FROM ' . $this->links_table . ' |
|
161 | + FROM ' . $this->links_table.' |
|
162 | 162 | WHERE link_active = 0' . |
163 | 163 | (($sql_where) ? " AND link_time >= $sql_where" : ''); |
164 | 164 | $result = $this->db->sql_query($sql); |
@@ -182,7 +182,7 @@ discard block |
||
182 | 182 | 'ON' => 'u.user_id = l.link_user_id' |
183 | 183 | ) |
184 | 184 | ), |
185 | - 'WHERE' => 'l.link_active = 0' . (($sql_where) ? " AND l.link_time >= $sql_where" : ''), |
|
185 | + 'WHERE' => 'l.link_active = 0'.(($sql_where) ? " AND l.link_time >= $sql_where" : ''), |
|
186 | 186 | 'ORDER_BY' => $sql_sort_order); |
187 | 187 | |
188 | 188 | $sql = $this->db->sql_build_query('SELECT', $sql_array); |
@@ -209,7 +209,7 @@ discard block |
||
209 | 209 | |
210 | 210 | $option_ary = array('approved' => 'DIR_LINK_ACTIVATE', 'disapproved' => 'DIR_LINK_DELETE'); |
211 | 211 | |
212 | - $base_url = $this->u_action . "&$u_sort_param&links_per_page=$per_page"; |
|
212 | + $base_url = $this->u_action."&$u_sort_param&links_per_page=$per_page"; |
|
213 | 213 | $this->pagination->generate_template_pagination($base_url, 'pagination', 'start', $total_links, $per_page, $start); |
214 | 214 | |
215 | 215 | $this->template->assign_vars(array( |
@@ -220,7 +220,7 @@ discard block |
||
220 | 220 | 'S_SORT_DIR' => $s_sort_dir, |
221 | 221 | 'LINKS_PER_PAGE' => $per_page, |
222 | 222 | |
223 | - 'U_ACTION' => $this->u_action . "&$u_sort_param&links_per_page=$per_page&start=$start", |
|
223 | + 'U_ACTION' => $this->u_action."&$u_sort_param&links_per_page=$per_page&start=$start", |
|
224 | 224 | )); |
225 | 225 | } |
226 | 226 | |
@@ -248,7 +248,7 @@ discard block |
||
248 | 248 | return; |
249 | 249 | } |
250 | 250 | |
251 | - $this->phpbb_log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_LINK_' . strtoupper($this->action), time(), array(implode(', ', $this->affected_link_name))); |
|
251 | + $this->phpbb_log->add('admin', $this->user->data['user_id'], $this->user->ip, 'LOG_LINK_'.strtoupper($this->action), time(), array(implode(', ', $this->affected_link_name))); |
|
252 | 252 | } |
253 | 253 | |
254 | 254 | /** |
@@ -260,7 +260,7 @@ discard block |
||
260 | 260 | { |
261 | 261 | if (!class_exists('messenger')) |
262 | 262 | { |
263 | - include($this->root_path . 'includes/functions_messenger.' . $this->php_ext); |
|
263 | + include($this->root_path.'includes/functions_messenger.'.$this->php_ext); |
|
264 | 264 | } |
265 | 265 | $messenger = new \messenger(false); |
266 | 266 | |
@@ -327,15 +327,15 @@ discard block |
||
327 | 327 | 'link_cat' => (int) $row['link_cat'], |
328 | 328 | ); |
329 | 329 | |
330 | - $sql = 'UPDATE ' . $this->links_table . ' |
|
331 | - SET ' . $this->db->sql_build_array('UPDATE', $sql_ary) . ' |
|
330 | + $sql = 'UPDATE '.$this->links_table.' |
|
331 | + SET ' . $this->db->sql_build_array('UPDATE', $sql_ary).' |
|
332 | 332 | WHERE link_id = ' . (int) $row['link_id']; |
333 | 333 | $this->db->sql_query($sql); |
334 | 334 | } |
335 | 335 | |
336 | 336 | foreach ($this->cat_data as $cat_id => $count) |
337 | 337 | { |
338 | - $sql = 'UPDATE ' . $this->categories_table . ' |
|
338 | + $sql = 'UPDATE '.$this->categories_table.' |
|
339 | 339 | SET cat_links = cat_links + '.$count.' |
340 | 340 | WHERE cat_id = ' . (int) $cat_id; |
341 | 341 | $this->db->sql_query($sql); |
@@ -361,7 +361,7 @@ discard block |
||
361 | 361 | } |
362 | 362 | } |
363 | 363 | |
364 | - $sql = 'DELETE FROM ' . $this->links_table . ' WHERE link_id = ' . (int) $row['link_id']; |
|
364 | + $sql = 'DELETE FROM '.$this->links_table.' WHERE link_id = '.(int) $row['link_id']; |
|
365 | 365 | $this->db->sql_query($sql); |
366 | 366 | } |
367 | 367 | } |
@@ -28,8 +28,8 @@ discard block |
||
28 | 28 | */ |
29 | 29 | public function __construct(\phpbb\db\driver\driver_interface $db, \phpbb\language\language $language) |
30 | 30 | { |
31 | - $this->db = $db; |
|
32 | - $this->language = $language; |
|
31 | + $this->db = $db; |
|
32 | + $this->language = $language; |
|
33 | 33 | } |
34 | 34 | |
35 | 35 | /** |
@@ -42,10 +42,10 @@ discard block |
||
42 | 42 | { |
43 | 43 | $this->db->sql_transaction('begin'); |
44 | 44 | |
45 | - $sql = 'INSERT INTO ' . $this->comments_table . ' ' . $this->db->sql_build_array('INSERT', $data); |
|
45 | + $sql = 'INSERT INTO '.$this->comments_table.' '.$this->db->sql_build_array('INSERT', $data); |
|
46 | 46 | $this->db->sql_query($sql); |
47 | 47 | |
48 | - $sql = 'UPDATE ' . $this->links_table . ' |
|
48 | + $sql = 'UPDATE '.$this->links_table.' |
|
49 | 49 | SET link_comment = link_comment + 1 |
50 | 50 | WHERE link_id = ' . (int) $data['comment_link_id']; |
51 | 51 | $this->db->sql_query($sql); |
@@ -62,8 +62,8 @@ discard block |
||
62 | 62 | */ |
63 | 63 | public function edit($data, $comment_id) |
64 | 64 | { |
65 | - $sql = 'UPDATE ' . $this->comments_table . ' |
|
66 | - SET ' . $this->db->sql_build_array('UPDATE', $data) . ' |
|
65 | + $sql = 'UPDATE '.$this->comments_table.' |
|
66 | + SET ' . $this->db->sql_build_array('UPDATE', $data).' |
|
67 | 67 | WHERE comment_id = ' . (int) $comment_id; |
68 | 68 | $this->db->sql_query($sql); |
69 | 69 | } |
@@ -81,10 +81,10 @@ discard block |
||
81 | 81 | |
82 | 82 | $this->db->sql_transaction('begin'); |
83 | 83 | |
84 | - $sql = 'DELETE FROM ' . $this->comments_table . ' WHERE comment_id = ' . (int) $comment_id; |
|
84 | + $sql = 'DELETE FROM '.$this->comments_table.' WHERE comment_id = '.(int) $comment_id; |
|
85 | 85 | $this->db->sql_query($sql); |
86 | 86 | |
87 | - $sql = 'UPDATE ' . $this->links_table . ' |
|
87 | + $sql = 'UPDATE '.$this->links_table.' |
|
88 | 88 | SET link_comment = link_comment - 1 |
89 | 89 | WHERE link_id = ' . (int) $link_id; |
90 | 90 | $this->db->sql_query($sql); |
@@ -94,7 +94,7 @@ discard block |
||
94 | 94 | if ($request->is_ajax()) |
95 | 95 | { |
96 | 96 | $sql = 'SELECT COUNT(comment_id) AS nb_comments |
97 | - FROM ' . $this->comments_table . ' |
|
97 | + FROM ' . $this->comments_table.' |
|
98 | 98 | WHERE comment_link_id = ' . (int) $link_id; |
99 | 99 | $result = $this->db->sql_query($sql); |
100 | 100 | $nb_comments = (int) $this->db->sql_fetchfield('nb_comments'); |
@@ -69,20 +69,20 @@ discard block |
||
69 | 69 | $match_search_query = ''; |
70 | 70 | foreach ($matches as $match) |
71 | 71 | { |
72 | - $match_search_query .= (($match_search_query) ? ' OR ' : '') . 'LOWER('. $match . ') '; |
|
73 | - $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())); |
|
72 | + $match_search_query .= (($match_search_query) ? ' OR ' : '').'LOWER('.$match.') '; |
|
73 | + $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())); |
|
74 | 74 | } |
75 | - $search_query .= ((!$search_query) ? '' : (($terms == 'all') ? ' AND ' : ' OR ')) . '(' . $match_search_query . ')'; |
|
75 | + $search_query .= ((!$search_query) ? '' : (($terms == 'all') ? ' AND ' : ' OR ')).'('.$match_search_query.')'; |
|
76 | 76 | } |
77 | 77 | $direction = (($sort_dir == 'd') ? 'DESC' : 'ASC'); |
78 | 78 | |
79 | 79 | if (is_array($sort_by_sql[$sort_key])) |
80 | 80 | { |
81 | - $sql_sort_order = implode(' ' . $direction . ', ', $sort_by_sql[$sort_key]) . ' ' . $direction; |
|
81 | + $sql_sort_order = implode(' '.$direction.', ', $sort_by_sql[$sort_key]).' '.$direction; |
|
82 | 82 | } |
83 | 83 | else |
84 | 84 | { |
85 | - $sql_sort_order = $sort_by_sql[$sort_key] . ' ' . $direction; |
|
85 | + $sql_sort_order = $sort_by_sql[$sort_key].' '.$direction; |
|
86 | 86 | } |
87 | 87 | |
88 | 88 | $sql_array = array( |
@@ -90,10 +90,10 @@ discard block |
||
90 | 90 | 'FROM' => array( |
91 | 91 | $this->links_table => 'l'), |
92 | 92 | 'WHERE' => 'l.link_active = 1 |
93 | - ' . (($search_query) ? 'AND (' . $search_query . ')' : '') . ' |
|
94 | - ' . (sizeof($ex_cid_ary) ? ' AND ' . $this->db->sql_in_set('l.link_cat', $ex_cid_ary, true) : '') . ' |
|
95 | - ' . (($cat_id) ? ' AND ' . $this->db->sql_in_set('l.link_cat', $cat_id) : '') . ' |
|
96 | - ' . (($sort_days) ? ' AND l.link_time >= ' . (time() - ($sort_days * 86400)) : ''), |
|
93 | + ' . (($search_query) ? 'AND ('.$search_query.')' : '').' |
|
94 | + ' . (sizeof($ex_cid_ary) ? ' AND '.$this->db->sql_in_set('l.link_cat', $ex_cid_ary, true) : '').' |
|
95 | + ' . (($cat_id) ? ' AND '.$this->db->sql_in_set('l.link_cat', $cat_id) : '').' |
|
96 | + ' . (($sort_days) ? ' AND l.link_time >= '.(time() - ($sort_days * 86400)) : ''), |
|
97 | 97 | 'ORDER_BY' => $sql_sort_order |
98 | 98 | ); |
99 | 99 |
@@ -44,7 +44,7 @@ discard block |
||
44 | 44 | */ |
45 | 45 | public function set_extension_manager(\phpbb\extension\manager $phpbb_extension_manager) |
46 | 46 | { |
47 | - $this->extension_manager = $phpbb_extension_manager; |
|
47 | + $this->extension_manager = $phpbb_extension_manager; |
|
48 | 48 | } |
49 | 49 | |
50 | 50 | /** |
@@ -70,11 +70,11 @@ discard block |
||
70 | 70 | */ |
71 | 71 | public function set_tables($categories_table, $comments_table, $links_table, $votes_table, $watch_table) |
72 | 72 | { |
73 | - $this->comments_table = $comments_table; |
|
73 | + $this->comments_table = $comments_table; |
|
74 | 74 | $this->links_table = $links_table; |
75 | 75 | $this->votes_table = $votes_table; |
76 | 76 | $this->watch_table = $watch_table; |
77 | - $this->categories_table = $categories_table; |
|
77 | + $this->categories_table = $categories_table; |
|
78 | 78 | } |
79 | 79 | /** |
80 | 80 | * Return ext name |
@@ -84,7 +84,7 @@ discard block |
||
84 | 84 | */ |
85 | 85 | public function get_ext_name($web_root_path = false) |
86 | 86 | { |
87 | - return (($web_root_path) ? $this->path_helper->get_web_root_path() : '') . $this->extension_manager->get_extension_path($this->ext_name); |
|
87 | + return (($web_root_path) ? $this->path_helper->get_web_root_path() : '').$this->extension_manager->get_extension_path($this->ext_name); |
|
88 | 88 | } |
89 | 89 | |
90 | 90 | /** |
@@ -96,7 +96,7 @@ discard block |
||
96 | 96 | */ |
97 | 97 | public function get_img_path($type, $image = '') |
98 | 98 | { |
99 | - return $this->get_ext_name(true) . 'images/' . $type . '/' . $image; |
|
99 | + return $this->get_ext_name(true).'images/'.$type.'/'.$image; |
|
100 | 100 | } |
101 | 101 | |
102 | 102 | /** |
@@ -107,7 +107,7 @@ discard block |
||
107 | 107 | */ |
108 | 108 | public function get_banner_path($banner = '') |
109 | 109 | { |
110 | - return 'files/' . $this->get_ext_name() . 'banners/' . $banner; |
|
110 | + return 'files/'.$this->get_ext_name().'banners/'.$banner; |
|
111 | 111 | } |
112 | 112 | |
113 | 113 | /** |