@@ -70,7 +70,7 @@ discard block |
||
70 | 70 | ) { |
71 | 71 | // Not allowed page |
72 | 72 | $session->set('system-error_code', ERR_NOT_ALLOWED); |
73 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
73 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
74 | 74 | exit; |
75 | 75 | } |
76 | 76 | |
@@ -89,12 +89,12 @@ discard block |
||
89 | 89 | if (null === $session->get('user-accessible_folders') |
90 | 90 | || empty($session->get('user-accessible_folders')) === true |
91 | 91 | ) { |
92 | - echo '{"sEcho": ' . intval($request->query->get('sEcho')) . ' ,"iTotalRecords": "0", "iTotalDisplayRecords": "0", "aaData": [] }'; |
|
92 | + echo '{"sEcho": '.intval($request->query->get('sEcho')).' ,"iTotalRecords": "0", "iTotalDisplayRecords": "0", "aaData": [] }'; |
|
93 | 93 | exit; |
94 | 94 | } |
95 | 95 | |
96 | 96 | //Columns name |
97 | -$aColumns = ['c.id', 'c.label', 'c.login', 'c.description', 'c.tags', 'c.id_tree', 'c.folder', 'c.login', 'c.url', 'ci.data'];// |
|
97 | +$aColumns = ['c.id', 'c.label', 'c.login', 'c.description', 'c.tags', 'c.id_tree', 'c.folder', 'c.login', 'c.url', 'ci.data']; // |
|
98 | 98 | $aSortTypes = ['ASC', 'DESC']; |
99 | 99 | //init SQL variables |
100 | 100 | $sOrder = $sLimit = $sWhere = ''; |
@@ -114,7 +114,7 @@ discard block |
||
114 | 114 | |
115 | 115 | //Get current user "personal folder" ID |
116 | 116 | $row = DB::query( |
117 | - 'SELECT id FROM ' . prefixTable('nested_tree') . ' WHERE title = %i', |
|
117 | + 'SELECT id FROM '.prefixTable('nested_tree').' WHERE title = %i', |
|
118 | 118 | intval($session->get('user-id')) |
119 | 119 | ); |
120 | 120 | //get list of personal folders |
@@ -123,20 +123,20 @@ discard block |
||
123 | 123 | $listPf = ''; |
124 | 124 | if (empty($row['id']) === false) { |
125 | 125 | $rows = DB::query( |
126 | - 'SELECT id FROM ' . prefixTable('nested_tree') . ' |
|
126 | + 'SELECT id FROM '.prefixTable('nested_tree').' |
|
127 | 127 | WHERE personal_folder = 1 AND NOT parent_id = %i AND NOT title = %i', |
128 | 128 | filter_var($row['id'], FILTER_SANITIZE_NUMBER_INT), |
129 | 129 | filter_var($session->get('user-id'), FILTER_SANITIZE_NUMBER_INT) |
130 | 130 | ); |
131 | 131 | foreach ($rows as $record) { |
132 | - if (! in_array($record['id'], $arrayPf)) { |
|
132 | + if (!in_array($record['id'], $arrayPf)) { |
|
133 | 133 | //build an array of personal folders ids |
134 | 134 | array_push($arrayPf, $record['id']); |
135 | 135 | //build also a string with those ids |
136 | 136 | if (empty($listPf)) { |
137 | 137 | $listPf = $record['id']; |
138 | 138 | } else { |
139 | - $listPf .= ', ' . $record['id']; |
|
139 | + $listPf .= ', '.$record['id']; |
|
140 | 140 | } |
141 | 141 | } |
142 | 142 | } |
@@ -146,7 +146,7 @@ discard block |
||
146 | 146 | //Paging |
147 | 147 | $sLimit = ''; |
148 | 148 | if (null !== $request->query->get('start') && $request->query->get('length') !== '-1') { |
149 | - $sLimit = 'LIMIT ' . $request->query->filter('start', null, FILTER_SANITIZE_NUMBER_INT) . ', ' . $request->query->filter('length', null, FILTER_SANITIZE_NUMBER_INT) . ''; |
|
149 | + $sLimit = 'LIMIT '.$request->query->filter('start', null, FILTER_SANITIZE_NUMBER_INT).', '.$request->query->filter('length', null, FILTER_SANITIZE_NUMBER_INT).''; |
|
150 | 150 | } |
151 | 151 | |
152 | 152 | //Ordering |
@@ -160,8 +160,8 @@ discard block |
||
160 | 160 | } |
161 | 161 | $sOrder = 'ORDER BY '; |
162 | 162 | if ($orderParam[0]['column'] >= 0) { |
163 | - $sOrder .= '' . $aColumns[filter_var($orderParam[0]['column'], FILTER_SANITIZE_NUMBER_INT)] . ' ' |
|
164 | - . filter_var($orderParam[0]['dir'], FILTER_SANITIZE_FULL_SPECIAL_CHARS) . ', '; |
|
163 | + $sOrder .= ''.$aColumns[filter_var($orderParam[0]['column'], FILTER_SANITIZE_NUMBER_INT)].' ' |
|
164 | + . filter_var($orderParam[0]['dir'], FILTER_SANITIZE_FULL_SPECIAL_CHARS).', '; |
|
165 | 165 | } |
166 | 166 | |
167 | 167 | $sOrder = substr_replace($sOrder, '', -2); |
@@ -169,7 +169,7 @@ discard block |
||
169 | 169 | $sOrder = ''; |
170 | 170 | } |
171 | 171 | } else { |
172 | - $sOrder = 'ORDER BY ' . $aColumns[1] . ' ASC'; |
|
172 | + $sOrder = 'ORDER BY '.$aColumns[1].' ASC'; |
|
173 | 173 | } |
174 | 174 | |
175 | 175 | // Define criteria |
@@ -190,9 +190,9 @@ discard block |
||
190 | 190 | if (empty($search_criteria) === false) { |
191 | 191 | $sWhere .= ' AND ('; |
192 | 192 | for ($i = 0; $i < count($aColumns); ++$i) { |
193 | - $sWhere .= $aColumns[$i] . ' LIKE %ss_' . $i . ' OR '; |
|
193 | + $sWhere .= $aColumns[$i].' LIKE %ss_'.$i.' OR '; |
|
194 | 194 | } |
195 | - $sWhere = substr_replace((string) $sWhere, '', -3) . ') '; |
|
195 | + $sWhere = substr_replace((string) $sWhere, '', -3).') '; |
|
196 | 196 | $crit = [ |
197 | 197 | 'idtree' => array_unique($folders), |
198 | 198 | '0' => $search_criteria, |
@@ -232,16 +232,16 @@ discard block |
||
232 | 232 | if (empty($sWhere) === false) { |
233 | 233 | $sWhere .= ' AND '; |
234 | 234 | } |
235 | - $sWhere = 'WHERE ' . $sWhere . 'c.id_tree NOT IN %ls_pf '; |
|
235 | + $sWhere = 'WHERE '.$sWhere.'c.id_tree NOT IN %ls_pf '; |
|
236 | 236 | } else { |
237 | - $sWhere = 'WHERE ' . $sWhere; |
|
237 | + $sWhere = 'WHERE '.$sWhere; |
|
238 | 238 | } |
239 | 239 | |
240 | 240 | // Do queries |
241 | 241 | DB::query( |
242 | 242 | "SELECT c.id |
243 | - FROM " . prefixTable('cache') . " AS c |
|
244 | - LEFT JOIN " . prefixTable('categories_items') . " AS ci ON (ci.item_id = c.id) |
|
243 | + FROM " . prefixTable('cache')." AS c |
|
244 | + LEFT JOIN " . prefixTable('categories_items')." AS ci ON (ci.item_id = c.id) |
|
245 | 245 | {$sWhere} |
246 | 246 | {$sOrder}", |
247 | 247 | $crit |
@@ -249,9 +249,9 @@ discard block |
||
249 | 249 | $iTotal = DB::count(); |
250 | 250 | $rows = DB::query( |
251 | 251 | "SELECT c.*, ci.data, i.item_key |
252 | - FROM " . prefixTable('cache') . " AS c |
|
253 | - LEFT JOIN " . prefixTable('categories_items') . " AS ci ON (ci.item_id = c.id) |
|
254 | - INNER JOIN " . prefixTable('items') . " AS i ON (i.id = c.id) |
|
252 | + FROM " . prefixTable('cache')." AS c |
|
253 | + LEFT JOIN " . prefixTable('categories_items')." AS ci ON (ci.item_id = c.id) |
|
254 | + INNER JOIN " . prefixTable('items')." AS i ON (i.id = c.id) |
|
255 | 255 | {$sWhere} |
256 | 256 | {$sOrder} |
257 | 257 | {$sLimit}", |
@@ -276,7 +276,7 @@ discard block |
||
276 | 276 | if (null === $request->query->get('type')) { |
277 | 277 | $sOutput = '{'; |
278 | 278 | if (null !== $request->query->get('draw')) { |
279 | - $sOutput .= '"draw": ' . (int) $request->query->get('draw') . ', '; |
|
279 | + $sOutput .= '"draw": '.(int) $request->query->get('draw').', '; |
|
280 | 280 | } |
281 | 281 | $sOutput .= '"data": ['; |
282 | 282 | $sOutputConst = ''; |
@@ -293,7 +293,7 @@ discard block |
||
293 | 293 | foreach (explode(';', $session->get('user-roles')) as $role) { |
294 | 294 | //db::debugmode(true); |
295 | 295 | $access = DB::queryFirstRow( |
296 | - 'SELECT type FROM ' . prefixTable('roles_values') . ' WHERE role_id = %i AND folder_id = %i', |
|
296 | + 'SELECT type FROM '.prefixTable('roles_values').' WHERE role_id = %i AND folder_id = %i', |
|
297 | 297 | $role, |
298 | 298 | $record['id_tree'] |
299 | 299 | ); |
@@ -313,7 +313,7 @@ discard block |
||
313 | 313 | } |
314 | 314 | $accessLevel = count($arrTmp) > 0 ? min($arrTmp) : $accessLevel; |
315 | 315 | if ($accessLevel === 0) { |
316 | - $checkbox = '<input type=\"checkbox\" value=\"0\" class=\"mass_op_cb\" data-id=\"' . $record['id'] . '\">'; |
|
316 | + $checkbox = '<input type=\"checkbox\" value=\"0\" class=\"mass_op_cb\" data-id=\"'.$record['id'].'\">'; |
|
317 | 317 | } |
318 | 318 | |
319 | 319 | if ((int) $accessLevel === 0) { |
@@ -353,22 +353,22 @@ discard block |
||
353 | 353 | if (empty($restrictedTo)) { |
354 | 354 | $restrictedTo = $session->get('user-id'); |
355 | 355 | } else { |
356 | - $restrictedTo .= ',' . $session->get('user-id'); |
|
356 | + $restrictedTo .= ','.$session->get('user-id'); |
|
357 | 357 | } |
358 | 358 | } |
359 | 359 | |
360 | 360 | //col1 |
361 | - $sOutputItem .= '"<i class=\"fa fa-external-link-alt infotip mr-2\" title=\"' . $lang->get('open_url_link') . '\" onClick=\"window.location.href='index.php?page=items&group=' . $record['id_tree'] . '&id=' . $record['id'] . ''\" style=\"cursor:pointer;\"></i>' . |
|
362 | - '<i class=\"fa fa-eye infotip mr-2 item-detail\" title=\"' . stripslashes($lang->get('see_item_title')) . '\" data-id=\"' . $record['id'] . '\" data-perso=\"' . $record['perso'] . '\" data-tree-id=\"' . $record['id_tree'] . '\" data-expired=\"' . $expired . '\" data-restricted-to=\"' . $restrictedTo . '\" data-rights=\"' . $right . '\" style=\"cursor:pointer;\"></i>' . $checkbox . '",' ; |
|
361 | + $sOutputItem .= '"<i class=\"fa fa-external-link-alt infotip mr-2\" title=\"'.$lang->get('open_url_link').'\" onClick=\"window.location.href='index.php?page=items&group='.$record['id_tree'].'&id='.$record['id'].''\" style=\"cursor:pointer;\"></i>'. |
|
362 | + '<i class=\"fa fa-eye infotip mr-2 item-detail\" title=\"'.stripslashes($lang->get('see_item_title')).'\" data-id=\"'.$record['id'].'\" data-perso=\"'.$record['perso'].'\" data-tree-id=\"'.$record['id_tree'].'\" data-expired=\"'.$expired.'\" data-restricted-to=\"'.$restrictedTo.'\" data-rights=\"'.$right.'\" style=\"cursor:pointer;\"></i>'.$checkbox.'",'; |
|
363 | 363 | //col2 |
364 | - $sOutputItem .= '"'.base64_encode('<span id=\"item_label-' . $record['id'] . '\">' . (str_replace("\\", "\", (string) $record['label'])) . '</span>').'", '; // replace backslash #3015 |
|
364 | + $sOutputItem .= '"'.base64_encode('<span id=\"item_label-'.$record['id'].'\">'.(str_replace("\\", "\", (string) $record['label'])).'</span>').'", '; // replace backslash #3015 |
|
365 | 365 | //col3 |
366 | - $sOutputItem .= '"' . base64_encode(str_replace('&', '&', htmlspecialchars(stripslashes((string) $record['login']), ENT_QUOTES))) . '", '; |
|
366 | + $sOutputItem .= '"'.base64_encode(str_replace('&', '&', htmlspecialchars(stripslashes((string) $record['login']), ENT_QUOTES))).'", '; |
|
367 | 367 | //col4 |
368 | 368 | //get restriction from ROles |
369 | 369 | $restrictedToRole = false; |
370 | 370 | $rTmp = DB::queryFirstColumn( |
371 | - 'SELECT role_id FROM ' . prefixTable('restriction_to_roles') . ' WHERE item_id = %i', |
|
371 | + 'SELECT role_id FROM '.prefixTable('restriction_to_roles').' WHERE item_id = %i', |
|
372 | 372 | $record['id'] |
373 | 373 | ); |
374 | 374 | // We considere here that if user has at least one group similar to the object ones |
@@ -386,14 +386,14 @@ discard block |
||
386 | 386 | } else { |
387 | 387 | $txt = str_replace(['\n', '<br />', '\\'], [' ', ' ', '', ' '], strip_tags($record['description'])); |
388 | 388 | if (strlen($txt) > 50) { |
389 | - $sOutputItem .= '"' . base64_encode(substr(stripslashes(preg_replace('~/<[\/]{0,1}[^>]*>\//|[ \t]/~', '', $txt)), 0, 50)) . '", '; |
|
389 | + $sOutputItem .= '"'.base64_encode(substr(stripslashes(preg_replace('~/<[\/]{0,1}[^>]*>\//|[ \t]/~', '', $txt)), 0, 50)).'", '; |
|
390 | 390 | } else { |
391 | - $sOutputItem .= '"' . base64_encode(stripslashes(preg_replace('~/<[^>]*>|[ \t]/~', '', $txt))) . '", '; |
|
391 | + $sOutputItem .= '"'.base64_encode(stripslashes(preg_replace('~/<[^>]*>|[ \t]/~', '', $txt))).'", '; |
|
392 | 392 | } |
393 | 393 | } |
394 | 394 | |
395 | 395 | //col5 - TAGS |
396 | - $sOutputItem .= '"' . base64_encode(htmlspecialchars(stripslashes((string) $record['tags']), ENT_QUOTES)) . '", '; |
|
396 | + $sOutputItem .= '"'.base64_encode(htmlspecialchars(stripslashes((string) $record['tags']), ENT_QUOTES)).'", '; |
|
397 | 397 | // col6 - URL |
398 | 398 | if ($record['url'] !== '0') { |
399 | 399 | $sOutputItem .= '"'.filter_var($record['url'], FILTER_SANITIZE_URL).'", '; |
@@ -402,7 +402,7 @@ discard block |
||
402 | 402 | } |
403 | 403 | |
404 | 404 | //col7 - Prepare the Treegrid |
405 | - $sOutputItem .= '"' . base64_encode(htmlspecialchars(stripslashes((string) $record['folder']), ENT_QUOTES)) . '"'; |
|
405 | + $sOutputItem .= '"'.base64_encode(htmlspecialchars(stripslashes((string) $record['folder']), ENT_QUOTES)).'"'; |
|
406 | 406 | //Finish the line |
407 | 407 | //$sOutputItem .= '], '; |
408 | 408 | if ($getItemInList === true) { |
@@ -411,16 +411,16 @@ discard block |
||
411 | 411 | --$iTotal; |
412 | 412 | } |
413 | 413 | } |
414 | - if (! empty($sOutputConst)) { |
|
414 | + if (!empty($sOutputConst)) { |
|
415 | 415 | $sOutput .= substr_replace($sOutputConst, '', -2); |
416 | 416 | } |
417 | 417 | $sOutput .= '], '; |
418 | - $sOutput .= '"recordsTotal": ' . $iTotal . ', '; |
|
419 | - $sOutput .= '"recordsFiltered": ' . $iTotal . ' }'; |
|
418 | + $sOutput .= '"recordsTotal": '.$iTotal.', '; |
|
419 | + $sOutput .= '"recordsFiltered": '.$iTotal.' }'; |
|
420 | 420 | echo ($sOutput); |
421 | 421 | } elseif (null !== $request->query->get('type') && ($request->query->get('type') === 'search_for_items' || $request->query->get('type') === 'search_for_items_with_tags')) { |
422 | 422 | include_once 'main.functions.php'; |
423 | - include_once $SETTINGS['cpassman_dir'] . '/includes/language/' . $session->get('user-language') . '.php'; |
|
423 | + include_once $SETTINGS['cpassman_dir'].'/includes/language/'.$session->get('user-language').'.php'; |
|
424 | 424 | |
425 | 425 | $arr_data = []; |
426 | 426 | foreach ($rows as $record) { |
@@ -429,7 +429,7 @@ discard block |
||
429 | 429 | $arr_data[$record['id']]['tree_id'] = (int) $record['id_tree']; |
430 | 430 | $arr_data[$record['id']]['label'] = (string) $record['label']; |
431 | 431 | $arr_data[$record['id']]['desc'] = (string) strip_tags(explode('<br>', $record['description'])[0]); |
432 | - $arr_data[$record['id']]['folder'] = (string)$record['folder']; |
|
432 | + $arr_data[$record['id']]['folder'] = (string) $record['folder']; |
|
433 | 433 | $arr_data[$record['id']]['login'] = (string) strtr($record['login'], '"', '"'); |
434 | 434 | $arr_data[$record['id']]['item_key'] = (string) $record['item_key']; |
435 | 435 | $arr_data[$record['id']]['link'] = (string) $record['url'] !== '0' && empty($record['url']) === false ? filter_var($record['url'], FILTER_SANITIZE_URL) : ''; |
@@ -442,7 +442,7 @@ discard block |
||
442 | 442 | |
443 | 443 | // Anyone can modify? |
444 | 444 | $tmp = DB::queryfirstrow( |
445 | - 'SELECT anyone_can_modify FROM ' . prefixTable('items') . ' WHERE id = %i', |
|
445 | + 'SELECT anyone_can_modify FROM '.prefixTable('items').' WHERE id = %i', |
|
446 | 446 | $record['id'] |
447 | 447 | ); |
448 | 448 | if (count($tmp) > 0) { |
@@ -473,7 +473,7 @@ discard block |
||
473 | 473 | // => récupérer un tableau contenant les roles associés à cet ID (a partir table restriction_to_roles) |
474 | 474 | $user_is_included_in_role = 0; |
475 | 475 | $roles = DB::query( |
476 | - 'SELECT role_id FROM ' . prefixTable('restriction_to_roles') . ' WHERE item_id=%i', |
|
476 | + 'SELECT role_id FROM '.prefixTable('restriction_to_roles').' WHERE item_id=%i', |
|
477 | 477 | $record['id'] |
478 | 478 | ); |
479 | 479 | if (count($roles) > 0) { |
@@ -496,7 +496,7 @@ discard block |
||
496 | 496 | if (empty($restrictedTo)) { |
497 | 497 | $restrictedTo = $session->get('user-id'); |
498 | 498 | } else { |
499 | - $restrictedTo .= ',' . $session->get('user-id'); |
|
499 | + $restrictedTo .= ','.$session->get('user-id'); |
|
500 | 500 | } |
501 | 501 | } |
502 | 502 | |
@@ -594,7 +594,7 @@ discard block |
||
594 | 594 | $arrTmp = []; |
595 | 595 | foreach (explode(';', $session->get('user-roles')) as $role) { |
596 | 596 | $access = DB::queryFirstRow( |
597 | - 'SELECT type FROM ' . prefixTable('roles_values') . ' WHERE role_id = %i AND folder_id = %i', |
|
597 | + 'SELECT type FROM '.prefixTable('roles_values').' WHERE role_id = %i AND folder_id = %i', |
|
598 | 598 | $role, |
599 | 599 | $record['id_tree'] |
600 | 600 | ); |
@@ -645,8 +645,8 @@ discard block |
||
645 | 645 | ) { |
646 | 646 | $data_item = DB::queryFirstRow( |
647 | 647 | 'SELECT i.pw AS pw, s.share_key AS share_key |
648 | - FROM ' . prefixTable('items') . ' AS i |
|
649 | - INNER JOIN ' . prefixTable('sharekeys_items') . ' AS s ON (s.object_id = i.id) |
|
648 | + FROM ' . prefixTable('items').' AS i |
|
649 | + INNER JOIN ' . prefixTable('sharekeys_items').' AS s ON (s.object_id = i.id) |
|
650 | 650 | WHERE i.id = %i AND s.user_id = %i', |
651 | 651 | $record['id'], |
652 | 652 | $session->get('user-id') |
@@ -64,7 +64,7 @@ discard block |
||
64 | 64 | ) { |
65 | 65 | // Not allowed page |
66 | 66 | $session->set('system-error_code', ERR_NOT_ALLOWED); |
67 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
67 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
68 | 68 | exit; |
69 | 69 | } |
70 | 70 | |
@@ -97,7 +97,7 @@ discard block |
||
97 | 97 | $post_isNewItem = $request->request->filter('isNewItem', null, FILTER_SANITIZE_NUMBER_INT); |
98 | 98 | $post_randomId = $request->request->filter('randomId', null, FILTER_SANITIZE_NUMBER_INT); |
99 | 99 | $post_isPersonal = $request->request->filter('isPersonal', null, FILTER_SANITIZE_NUMBER_INT); |
100 | -$post_fileSize= $request->request->filter('file_size', null, FILTER_SANITIZE_NUMBER_INT); |
|
100 | +$post_fileSize = $request->request->filter('file_size', null, FILTER_SANITIZE_NUMBER_INT); |
|
101 | 101 | |
102 | 102 | // Get parameters |
103 | 103 | $chunk = isset($_REQUEST['chunk']) ? (int) $_REQUEST['chunk'] : 0; |
@@ -158,7 +158,7 @@ discard block |
||
158 | 158 | // check if token is expired |
159 | 159 | $data = DB::queryFirstRow( |
160 | 160 | 'SELECT end_timestamp |
161 | - FROM ' . prefixTable('tokens') . ' |
|
161 | + FROM ' . prefixTable('tokens').' |
|
162 | 162 | WHERE user_id = %i AND token = %s', |
163 | 163 | $session->get('user-id'), |
164 | 164 | $post_user_token |
@@ -183,12 +183,12 @@ discard block |
||
183 | 183 | } |
184 | 184 | |
185 | 185 | // Load Settings |
186 | - include_once $SETTINGS['cpassman_dir'] . '/includes/config/tp.config.php'; |
|
186 | + include_once $SETTINGS['cpassman_dir'].'/includes/config/tp.config.php'; |
|
187 | 187 | } |
188 | 188 | |
189 | 189 | // HTTP headers for no cache etc |
190 | 190 | header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); |
191 | -header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); |
|
191 | +header('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT'); |
|
192 | 192 | header('Cache-Control: no-store, no-cache, must-revalidate'); |
193 | 193 | header('Cache-Control: post-check=0, pre-check=0', false); |
194 | 194 | |
@@ -233,9 +233,9 @@ discard block |
||
233 | 233 | } |
234 | 234 | |
235 | 235 | // Validate file name (for our purposes we'll just remove invalid characters) |
236 | -$file_name = preg_replace('[^' . $valid_chars_regex . ']', '', strtolower(basename($_FILES['file']['name']))); |
|
236 | +$file_name = preg_replace('[^'.$valid_chars_regex.']', '', strtolower(basename($_FILES['file']['name']))); |
|
237 | 237 | if (strlen($file_name) == 0 || strlen($file_name) > $MAX_FILENAME_LENGTH) { |
238 | - handleAttachmentError('Invalid file name: ' . $file_name . '.', 114); |
|
238 | + handleAttachmentError('Invalid file name: '.$file_name.'.', 114); |
|
239 | 239 | } |
240 | 240 | |
241 | 241 | // Validate file extension |
@@ -245,8 +245,8 @@ discard block |
||
245 | 245 | $ext, |
246 | 246 | explode( |
247 | 247 | ',', |
248 | - $SETTINGS['upload_docext'] . ',' . $SETTINGS['upload_imagesext'] . |
|
249 | - ',' . $SETTINGS['upload_pkgext'] . ',' . $SETTINGS['upload_otherext'] |
|
248 | + $SETTINGS['upload_docext'].','.$SETTINGS['upload_imagesext']. |
|
249 | + ','.$SETTINGS['upload_pkgext'].','.$SETTINGS['upload_otherext'] |
|
250 | 250 | ) |
251 | 251 | ) === false |
252 | 252 | ) { |
@@ -258,24 +258,24 @@ discard block |
||
258 | 258 | |
259 | 259 | // Clean the fileName for security reasons |
260 | 260 | $fileInfo = pathinfo($fileName); |
261 | -$fileName = base64_encode($fileInfo['filename']) . '.' . $fileInfo['extension']; |
|
261 | +$fileName = base64_encode($fileInfo['filename']).'.'.$fileInfo['extension']; |
|
262 | 262 | $fileFullSize = 0; |
263 | 263 | |
264 | 264 | // Make sure the fileName is unique but only if chunking is disabled |
265 | -if ($chunks < 2 && file_exists($targetDir . DIRECTORY_SEPARATOR . $fileName)) { |
|
265 | +if ($chunks < 2 && file_exists($targetDir.DIRECTORY_SEPARATOR.$fileName)) { |
|
266 | 266 | $ext = strrpos($fileName, '.'); |
267 | 267 | $fileNameA = substr($fileName, 0, $ext); |
268 | 268 | $fileNameB = substr($fileName, $ext); |
269 | 269 | |
270 | 270 | $count = 1; |
271 | - while (file_exists($targetDir . DIRECTORY_SEPARATOR . $fileNameA . '_' . $count . $fileNameB)) { |
|
271 | + while (file_exists($targetDir.DIRECTORY_SEPARATOR.$fileNameA.'_'.$count.$fileNameB)) { |
|
272 | 272 | ++$count; |
273 | 273 | } |
274 | 274 | |
275 | - $fileName = $fileNameA . '_' . $count . $fileNameB; |
|
275 | + $fileName = $fileNameA.'_'.$count.$fileNameB; |
|
276 | 276 | } |
277 | 277 | |
278 | -$filePath = $targetDir . DIRECTORY_SEPARATOR . $fileName; |
|
278 | +$filePath = $targetDir.DIRECTORY_SEPARATOR.$fileName; |
|
279 | 279 | |
280 | 280 | // Create target dir |
281 | 281 | if (file_exists($targetDir) === false) { |
@@ -289,7 +289,7 @@ discard block |
||
289 | 289 | // Remove old temp files |
290 | 290 | if ($cleanupTargetDir && is_dir($targetDir) && ($dir = opendir($targetDir))) { |
291 | 291 | while (($file = readdir($dir)) !== false) { |
292 | - $tmpfilePath = $targetDir . DIRECTORY_SEPARATOR . $file; |
|
292 | + $tmpfilePath = $targetDir.DIRECTORY_SEPARATOR.$file; |
|
293 | 293 | |
294 | 294 | // Remove temp file if it is older than the max age and is not the current file |
295 | 295 | if ( |
@@ -411,8 +411,8 @@ discard block |
||
411 | 411 | // This is a public object |
412 | 412 | $users = DB::query( |
413 | 413 | 'SELECT id, public_key |
414 | - FROM ' . prefixTable('users') . ' |
|
415 | - WHERE id NOT IN ("' . OTV_USER_ID . '","' . SSH_USER_ID . '","' . API_USER_ID . '") |
|
414 | + FROM ' . prefixTable('users').' |
|
415 | + WHERE id NOT IN ("' . OTV_USER_ID.'","'.SSH_USER_ID.'","'.API_USER_ID.'") |
|
416 | 416 | AND public_key != ""' |
417 | 417 | ); |
418 | 418 | foreach ($users as $user) { |
@@ -450,14 +450,14 @@ discard block |
||
450 | 450 | 'date' => time(), |
451 | 451 | 'id_user' => $session->get('user-id'), |
452 | 452 | 'action' => 'at_modification', |
453 | - 'raison' => 'at_add_file : ' . $fileName . ':' . $newID, |
|
453 | + 'raison' => 'at_add_file : '.$fileName.':'.$newID, |
|
454 | 454 | ) |
455 | 455 | ); |
456 | 456 | } |
457 | 457 | } |
458 | 458 | |
459 | 459 | // Return JSON-RPC response |
460 | -die('{"jsonrpc" : "2.0", "result" : null, "id" : "' . $newID . '"}'); |
|
460 | +die('{"jsonrpc" : "2.0", "result" : null, "id" : "'.$newID.'"}'); |
|
461 | 461 | |
462 | 462 | /** |
463 | 463 | * Undocumented function. |
@@ -467,5 +467,5 @@ discard block |
||
467 | 467 | */ |
468 | 468 | function handleAttachmentError($message, $code) |
469 | 469 | { |
470 | - echo '{"jsonrpc" : "2.0", "error" : {"code": ' . htmlentities((string) $code, ENT_QUOTES) . ', "message": "' . htmlentities((string) $message, ENT_QUOTES) . '"}, "id" : "id"}'; |
|
470 | + echo '{"jsonrpc" : "2.0", "error" : {"code": '.htmlentities((string) $code, ENT_QUOTES).', "message": "'.htmlentities((string) $message, ENT_QUOTES).'"}, "id" : "id"}'; |
|
471 | 471 | } |
@@ -70,7 +70,7 @@ discard block |
||
70 | 70 | ) { |
71 | 71 | // Not allowed page |
72 | 72 | $session->set('system-error_code', ERR_NOT_ALLOWED); |
73 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
73 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
74 | 74 | exit; |
75 | 75 | } |
76 | 76 | |
@@ -293,7 +293,7 @@ discard block |
||
293 | 293 | * @param string $post_key |
294 | 294 | * @return string |
295 | 295 | */ |
296 | -function userHandler(string $post_type, array|null|string $dataReceived, array $SETTINGS, string $post_key): string |
|
296 | +function userHandler(string $post_type, array | null | string $dataReceived, array $SETTINGS, string $post_key): string |
|
297 | 297 | { |
298 | 298 | $session = SessionManager::getSession(); |
299 | 299 | |
@@ -533,7 +533,7 @@ discard block |
||
533 | 533 | $pwdlib = new PasswordLib(); |
534 | 534 | // generate key |
535 | 535 | $key = $pwdlib->getRandomToken(filter_input(INPUT_POST, 'size', FILTER_SANITIZE_NUMBER_INT)); |
536 | - return '[{"key" : "' . htmlentities($key, ENT_QUOTES) . '"}]'; |
|
536 | + return '[{"key" : "'.htmlentities($key, ENT_QUOTES).'"}]'; |
|
537 | 537 | |
538 | 538 | /* |
539 | 539 | * Launch user keys change on his demand |
@@ -584,7 +584,7 @@ discard block |
||
584 | 584 | * @param array $SETTINGS |
585 | 585 | * @return string |
586 | 586 | */ |
587 | -function systemHandler(string $post_type, array|null|string $dataReceived, array $SETTINGS): string |
|
587 | +function systemHandler(string $post_type, array | null | string $dataReceived, array $SETTINGS): string |
|
588 | 588 | { |
589 | 589 | $session = SessionManager::getSession(); |
590 | 590 | switch ($post_type) { |
@@ -687,7 +687,7 @@ discard block |
||
687 | 687 | ) |
688 | 688 | ); |
689 | 689 | |
690 | - return '[{"token" : "' . $token . '"}]'; |
|
690 | + return '[{"token" : "'.$token.'"}]'; |
|
691 | 691 | |
692 | 692 | /* |
693 | 693 | * Default case |
@@ -703,7 +703,7 @@ discard block |
||
703 | 703 | } |
704 | 704 | |
705 | 705 | |
706 | -function utilsHandler(string $post_type, array|null|string $dataReceived, array $SETTINGS): string |
|
706 | +function utilsHandler(string $post_type, array | null | string $dataReceived, array $SETTINGS): string |
|
707 | 707 | { |
708 | 708 | switch ($post_type) { |
709 | 709 | /* |
@@ -772,7 +772,7 @@ discard block |
||
772 | 772 | array( |
773 | 773 | 'error' => false, |
774 | 774 | 'timestamp' => $session->get('user-session_duration'), |
775 | - 'max_time_to_add' => intdiv((($maximum_session_expiration_time*60) - ((int) $session->get('user-session_duration') - time())), 60), |
|
775 | + 'max_time_to_add' => intdiv((($maximum_session_expiration_time * 60) - ((int) $session->get('user-session_duration') - time())), 60), |
|
776 | 776 | 'max_session_duration' => $maximum_session_expiration_time, |
777 | 777 | ), |
778 | 778 | 'encode' |
@@ -824,7 +824,7 @@ discard block |
||
824 | 824 | // get number of items |
825 | 825 | DB::queryFirstRow( |
826 | 826 | 'SELECT increment_id |
827 | - FROM ' . prefixTable('sharekeys_items') . |
|
827 | + FROM ' . prefixTable('sharekeys_items'). |
|
828 | 828 | ' WHERE user_id = %i', |
829 | 829 | $userId |
830 | 830 | ); |
@@ -880,7 +880,7 @@ discard block |
||
880 | 880 | // check if expected security level is reached |
881 | 881 | $dataUser = DB::queryfirstrow( |
882 | 882 | 'SELECT * |
883 | - FROM ' . prefixTable('users') . ' WHERE id = %i', |
|
883 | + FROM ' . prefixTable('users').' WHERE id = %i', |
|
884 | 884 | $post_user_id |
885 | 885 | ); |
886 | 886 | |
@@ -901,8 +901,8 @@ discard block |
||
901 | 901 | if (empty($dataUser['fonction_id']) === false) { |
902 | 902 | $data = DB::queryFirstRow( |
903 | 903 | 'SELECT complexity |
904 | - FROM ' . prefixTable('roles_title') . ' |
|
905 | - WHERE id IN (' . $dataUser['fonction_id'] . ') |
|
904 | + FROM ' . prefixTable('roles_title').' |
|
905 | + WHERE id IN (' . $dataUser['fonction_id'].') |
|
906 | 906 | ORDER BY complexity DESC' |
907 | 907 | ); |
908 | 908 | } else { |
@@ -915,8 +915,8 @@ discard block |
||
915 | 915 | return prepareExchangedData( |
916 | 916 | array( |
917 | 917 | 'error' => true, |
918 | - 'message' => '<div style="margin:10px 0 10px 15px;">' . $lang->get('complexity_level_not_reached') . '.<br>' . |
|
919 | - $lang->get('expected_complexity_level') . ': <b>' . TP_PW_COMPLEXITY[$data['complexity']][1] . '</b></div>', |
|
918 | + 'message' => '<div style="margin:10px 0 10px 15px;">'.$lang->get('complexity_level_not_reached').'.<br>'. |
|
919 | + $lang->get('expected_complexity_level').': <b>'.TP_PW_COMPLEXITY[$data['complexity']][1].'</b></div>', |
|
920 | 920 | ), |
921 | 921 | 'encode' |
922 | 922 | ); |
@@ -1019,14 +1019,14 @@ discard block |
||
1019 | 1019 | // Get data about user |
1020 | 1020 | $dataUser = DB::queryfirstrow( |
1021 | 1021 | 'SELECT id, email, pw |
1022 | - FROM ' . prefixTable('users') . ' |
|
1022 | + FROM ' . prefixTable('users').' |
|
1023 | 1023 | WHERE login = %s', |
1024 | 1024 | $post_login |
1025 | 1025 | ); |
1026 | 1026 | } else { |
1027 | 1027 | $dataUser = DB::queryfirstrow( |
1028 | 1028 | 'SELECT id, login, email, pw |
1029 | - FROM ' . prefixTable('users') . ' |
|
1029 | + FROM ' . prefixTable('users').' |
|
1030 | 1030 | WHERE id = %i', |
1031 | 1031 | $post_id |
1032 | 1032 | ); |
@@ -1081,7 +1081,7 @@ discard block |
||
1081 | 1081 | // Check if token already used |
1082 | 1082 | $dataToken = DB::queryfirstrow( |
1083 | 1083 | 'SELECT end_timestamp, reason |
1084 | - FROM ' . prefixTable('tokens') . ' |
|
1084 | + FROM ' . prefixTable('tokens').' |
|
1085 | 1085 | WHERE token = %s AND user_id = %i', |
1086 | 1086 | $post_token, |
1087 | 1087 | $dataUser['id'] |
@@ -1092,11 +1092,11 @@ discard block |
||
1092 | 1092 | return prepareExchangedData( |
1093 | 1093 | array( |
1094 | 1094 | 'error' => true, |
1095 | - 'message' => 'TOKEN already used',//$lang->get('no_email_set'), |
|
1095 | + 'message' => 'TOKEN already used', //$lang->get('no_email_set'), |
|
1096 | 1096 | ), |
1097 | 1097 | 'encode' |
1098 | 1098 | ); |
1099 | - } elseif(DB::count() === 0) { |
|
1099 | + } elseif (DB::count() === 0) { |
|
1100 | 1100 | // Store token for this action |
1101 | 1101 | DB::insert( |
1102 | 1102 | prefixTable('tokens'), |
@@ -1158,7 +1158,7 @@ discard block |
||
1158 | 1158 | 'email' => $dataUser['email'], |
1159 | 1159 | 'email_result' => str_replace( |
1160 | 1160 | '#email#', |
1161 | - '<b>' . obfuscateEmail($dataUser['email']) . '</b>', |
|
1161 | + '<b>'.obfuscateEmail($dataUser['email']).'</b>', |
|
1162 | 1162 | addslashes($lang->get('admin_email_result_ok')) |
1163 | 1163 | ), |
1164 | 1164 | ), |
@@ -1174,7 +1174,7 @@ discard block |
||
1174 | 1174 | 'email' => $dataUser['email'], |
1175 | 1175 | 'email_result' => str_replace( |
1176 | 1176 | '#email#', |
1177 | - '<b>' . obfuscateEmail($dataUser['email']) . '</b>', |
|
1177 | + '<b>'.obfuscateEmail($dataUser['email']).'</b>', |
|
1178 | 1178 | addslashes($lang->get('admin_email_result_ok')) |
1179 | 1179 | ), |
1180 | 1180 | ), |
@@ -1188,7 +1188,7 @@ discard block |
||
1188 | 1188 | { |
1189 | 1189 | if (isKeyExistingAndEqual('enable_send_email_on_user_login', 1, $SETTINGS) === true) { |
1190 | 1190 | $row = DB::queryFirstRow( |
1191 | - 'SELECT valeur FROM ' . prefixTable('misc') . ' WHERE type = %s AND intitule = %s', |
|
1191 | + 'SELECT valeur FROM '.prefixTable('misc').' WHERE type = %s AND intitule = %s', |
|
1192 | 1192 | 'cron', |
1193 | 1193 | 'sending_emails' |
1194 | 1194 | ); |
@@ -1196,7 +1196,7 @@ discard block |
||
1196 | 1196 | if ((int) (time() - $row['valeur']) >= 300 || (int) $row['valeur'] === 0) { |
1197 | 1197 | $rows = DB::query( |
1198 | 1198 | 'SELECT * |
1199 | - FROM ' . prefixTable('emails') . |
|
1199 | + FROM ' . prefixTable('emails'). |
|
1200 | 1200 | ' WHERE status != %s', |
1201 | 1201 | 'sent' |
1202 | 1202 | ); |
@@ -1294,8 +1294,8 @@ discard block |
||
1294 | 1294 | $arr_html = array(); |
1295 | 1295 | $rows = DB::query( |
1296 | 1296 | 'SELECT i.id AS id, i.label AS label, i.id_tree AS id_tree, l.date, i.perso AS perso, i.restricted_to AS restricted |
1297 | - FROM ' . prefixTable('log_items') . ' AS l |
|
1298 | - RIGHT JOIN ' . prefixTable('items') . ' AS i ON (l.id_item = i.id) |
|
1297 | + FROM ' . prefixTable('log_items').' AS l |
|
1298 | + RIGHT JOIN ' . prefixTable('items').' AS i ON (l.id_item = i.id) |
|
1299 | 1299 | WHERE l.action = %s AND l.id_user = %i |
1300 | 1300 | ORDER BY l.date DESC |
1301 | 1301 | LIMIT 0, 100', |
@@ -1327,7 +1327,7 @@ discard block |
||
1327 | 1327 | if (isKeyExistingAndEqual('enable_suggestion', 1, $SETTINGS) === true |
1328 | 1328 | && ((int) $session->get('user-admin') === 1 || (int) $session->get('user-manager') === 1) |
1329 | 1329 | ) { |
1330 | - DB::query('SELECT * FROM ' . prefixTable('suggestion')); |
|
1330 | + DB::query('SELECT * FROM '.prefixTable('suggestion')); |
|
1331 | 1331 | $nb_suggestions_waiting = DB::count(); |
1332 | 1332 | } |
1333 | 1333 | |
@@ -1362,13 +1362,13 @@ discard block |
||
1362 | 1362 | if ($data === 'stat_languages') { |
1363 | 1363 | $tmp = ''; |
1364 | 1364 | foreach ($stats_data[$data] as $key => $value) { |
1365 | - $tmp .= $tmp === '' ? $key . '-' . $value : ',' . $key . '-' . $value; |
|
1365 | + $tmp .= $tmp === '' ? $key.'-'.$value : ','.$key.'-'.$value; |
|
1366 | 1366 | } |
1367 | 1367 | $statsToSend[$data] = $tmp; |
1368 | 1368 | } elseif ($data === 'stat_country') { |
1369 | 1369 | $tmp = ''; |
1370 | 1370 | foreach ($stats_data[$data] as $key => $value) { |
1371 | - $tmp .= $tmp === '' ? $key . '-' . $value : ',' . $key . '-' . $value; |
|
1371 | + $tmp .= $tmp === '' ? $key.'-'.$value : ','.$key.'-'.$value; |
|
1372 | 1372 | } |
1373 | 1373 | $statsToSend[$data] = $tmp; |
1374 | 1374 | } else { |
@@ -1455,8 +1455,8 @@ discard block |
||
1455 | 1455 | $url_found = substr($line, 19, strlen($line) - 22); |
1456 | 1456 | if (empty($url_found) === false) { |
1457 | 1457 | $tmp = parse_url($url_found); |
1458 | - $anonym_url = $tmp['scheme'] . '://<anonym_url>' . (isset($tmp['path']) === true ? $tmp['path'] : ''); |
|
1459 | - $line = "'cpassman_url' => '" . $anonym_url . "\n"; |
|
1458 | + $anonym_url = $tmp['scheme'].'://<anonym_url>'.(isset($tmp['path']) === true ? $tmp['path'] : ''); |
|
1459 | + $line = "'cpassman_url' => '".$anonym_url."\n"; |
|
1460 | 1460 | } else { |
1461 | 1461 | $line = "'cpassman_url' => \n"; |
1462 | 1462 | } |
@@ -1486,7 +1486,7 @@ discard block |
||
1486 | 1486 | $teampass_errors = ''; |
1487 | 1487 | $rows = DB::query( |
1488 | 1488 | 'SELECT label, date AS error_date |
1489 | - FROM ' . prefixTable('log_system') . " |
|
1489 | + FROM ' . prefixTable('log_system')." |
|
1490 | 1490 | WHERE `type` LIKE 'error' |
1491 | 1491 | ORDER BY `date` DESC |
1492 | 1492 | LIMIT 0, 10" |
@@ -1494,9 +1494,9 @@ discard block |
||
1494 | 1494 | if (DB::count() > 0) { |
1495 | 1495 | foreach ($rows as $record) { |
1496 | 1496 | if (empty($teampass_errors) === true) { |
1497 | - $teampass_errors = ' * ' . date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['error_date']) . ' - ' . $record['label']; |
|
1497 | + $teampass_errors = ' * '.date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['error_date']).' - '.$record['label']; |
|
1498 | 1498 | } else { |
1499 | - $teampass_errors .= ' * ' . date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['error_date']) . ' - ' . $record['label']; |
|
1499 | + $teampass_errors .= ' * '.date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['error_date']).' - '.$record['label']; |
|
1500 | 1500 | } |
1501 | 1501 | } |
1502 | 1502 | } |
@@ -1505,7 +1505,7 @@ discard block |
||
1505 | 1505 | |
1506 | 1506 | // Now prepare text |
1507 | 1507 | $txt = '### Page on which it happened |
1508 | -' . $data['current_page'] . ' |
|
1508 | +' . $data['current_page'].' |
|
1509 | 1509 | |
1510 | 1510 | ### Steps to reproduce |
1511 | 1511 | 1. |
@@ -1520,39 +1520,39 @@ discard block |
||
1520 | 1520 | Tell us what happens instead |
1521 | 1521 | |
1522 | 1522 | ### Server configuration |
1523 | -**Operating system**: ' . php_uname() . ' |
|
1523 | +**Operating system**: ' . php_uname().' |
|
1524 | 1524 | |
1525 | -**Web server:** ' . $_SERVER['SERVER_SOFTWARE'] . ' |
|
1525 | +**Web server:** ' . $_SERVER['SERVER_SOFTWARE'].' |
|
1526 | 1526 | |
1527 | -**Database:** ' . ($link === false ? $lang->get('undefined') : mysqli_get_server_info($link)) . ' |
|
1527 | +**Database:** ' . ($link === false ? $lang->get('undefined') : mysqli_get_server_info($link)).' |
|
1528 | 1528 | |
1529 | -**PHP version:** ' . PHP_VERSION . ' |
|
1529 | +**PHP version:** ' . PHP_VERSION.' |
|
1530 | 1530 | |
1531 | -**Teampass version:** ' . TP_VERSION . ' |
|
1531 | +**Teampass version:** ' . TP_VERSION.' |
|
1532 | 1532 | |
1533 | 1533 | **Teampass configuration file:** |
1534 | 1534 | ``` |
1535 | -' . $list_of_options . ' |
|
1535 | +' . $list_of_options.' |
|
1536 | 1536 | ``` |
1537 | 1537 | |
1538 | 1538 | **Updated from an older Teampass or fresh install:** |
1539 | 1539 | |
1540 | 1540 | ### Client configuration |
1541 | 1541 | |
1542 | -**Browser:** ' . $data['browser_name'] . ' - ' . $data['browser_version'] . ' |
|
1542 | +**Browser:** ' . $data['browser_name'].' - '.$data['browser_version'].' |
|
1543 | 1543 | |
1544 | -**Operating system:** ' . $data['os'] . ' - ' . $data['os_archi'] . 'bits |
|
1544 | +**Operating system:** ' . $data['os'].' - '.$data['os_archi'].'bits |
|
1545 | 1545 | |
1546 | 1546 | ### Logs |
1547 | 1547 | |
1548 | 1548 | #### Web server error log |
1549 | 1549 | ``` |
1550 | -' . $err['message'] . ' - ' . $err['file'] . ' (' . $err['line'] . ') |
|
1550 | +' . $err['message'].' - '.$err['file'].' ('.$err['line'].') |
|
1551 | 1551 | ``` |
1552 | 1552 | |
1553 | 1553 | #### Teampass 10 last system errors |
1554 | 1554 | ``` |
1555 | -' . $teampass_errors . ' |
|
1555 | +' . $teampass_errors.' |
|
1556 | 1556 | ``` |
1557 | 1557 | |
1558 | 1558 | #### Log from the web-browser developer console (CTRL + SHIFT + i) |
@@ -1592,7 +1592,7 @@ discard block |
||
1592 | 1592 | // Check if user exists |
1593 | 1593 | $userInfo = DB::queryFirstRow( |
1594 | 1594 | 'SELECT public_key, private_key, pw, auth_type |
1595 | - FROM ' . prefixTable('users') . ' |
|
1595 | + FROM ' . prefixTable('users').' |
|
1596 | 1596 | WHERE id = %i', |
1597 | 1597 | $post_user_id |
1598 | 1598 | ); |
@@ -1601,9 +1601,9 @@ discard block |
||
1601 | 1601 | // Get one item |
1602 | 1602 | $currentUserKey = DB::queryFirstRow( |
1603 | 1603 | 'SELECT object_id, share_key, increment_id |
1604 | - FROM ' . prefixTable('sharekeys_items') . ' AS si |
|
1605 | - INNER JOIN ' . prefixTable('items') . ' AS i ON (i.id = si.object_id) |
|
1606 | - INNER JOIN ' . prefixTable('nested_tree') . ' AS nt ON (i.id_tree = nt.id) |
|
1604 | + FROM ' . prefixTable('sharekeys_items').' AS si |
|
1605 | + INNER JOIN ' . prefixTable('items').' AS i ON (i.id = si.object_id) |
|
1606 | + INNER JOIN ' . prefixTable('nested_tree').' AS nt ON (i.id_tree = nt.id) |
|
1607 | 1607 | WHERE user_id = %i AND nt.personal_folder = %i', |
1608 | 1608 | $post_user_id, |
1609 | 1609 | 0 |
@@ -1702,7 +1702,7 @@ discard block |
||
1702 | 1702 | // Get user info |
1703 | 1703 | $userData = DB::queryFirstRow( |
1704 | 1704 | 'SELECT private_key |
1705 | - FROM ' . prefixTable('users') . ' |
|
1705 | + FROM ' . prefixTable('users').' |
|
1706 | 1706 | WHERE id = %i', |
1707 | 1707 | $post_user_id |
1708 | 1708 | ); |
@@ -1767,7 +1767,7 @@ discard block |
||
1767 | 1767 | // Get user info |
1768 | 1768 | $userData = DB::queryFirstRow( |
1769 | 1769 | 'SELECT email, auth_type, login |
1770 | - FROM ' . prefixTable('users') . ' |
|
1770 | + FROM ' . prefixTable('users').' |
|
1771 | 1771 | WHERE id = %i', |
1772 | 1772 | $post_user_id |
1773 | 1773 | ); |
@@ -1903,7 +1903,7 @@ discard block |
||
1903 | 1903 | // Get user info |
1904 | 1904 | $userData = DB::queryFirstRow( |
1905 | 1905 | 'SELECT email, auth_type, login |
1906 | - FROM ' . prefixTable('users') . ' |
|
1906 | + FROM ' . prefixTable('users').' |
|
1907 | 1907 | WHERE id = %i', |
1908 | 1908 | $post_user_id |
1909 | 1909 | ); |
@@ -1968,7 +1968,7 @@ discard block |
||
1968 | 1968 | // Check if user exists |
1969 | 1969 | DB::queryFirstRow( |
1970 | 1970 | 'SELECT * |
1971 | - FROM ' . prefixTable('users') . ' |
|
1971 | + FROM ' . prefixTable('users').' |
|
1972 | 1972 | WHERE id = %i', |
1973 | 1973 | $post_user_id |
1974 | 1974 | ); |
@@ -2037,7 +2037,7 @@ discard block |
||
2037 | 2037 | // Check if user exists |
2038 | 2038 | $userInfo = DB::queryFirstRow( |
2039 | 2039 | 'SELECT public_key |
2040 | - FROM ' . prefixTable('users') . ' |
|
2040 | + FROM ' . prefixTable('users').' |
|
2041 | 2041 | WHERE id = %i', |
2042 | 2042 | $post_user_id |
2043 | 2043 | ); |
@@ -2185,15 +2185,15 @@ discard block |
||
2185 | 2185 | // Loop on items |
2186 | 2186 | $rows = DB::query( |
2187 | 2187 | 'SELECT id, pw |
2188 | - FROM ' . prefixTable('items') . ' |
|
2188 | + FROM ' . prefixTable('items').' |
|
2189 | 2189 | WHERE perso = 0 |
2190 | - LIMIT ' . $post_start . ', ' . $post_length |
|
2190 | + LIMIT ' . $post_start.', '.$post_length |
|
2191 | 2191 | ); |
2192 | 2192 | foreach ($rows as $record) { |
2193 | 2193 | // Get itemKey from current user |
2194 | 2194 | $currentUserKey = DB::queryFirstRow( |
2195 | 2195 | 'SELECT share_key, increment_id |
2196 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
2196 | + FROM ' . prefixTable('sharekeys_items').' |
|
2197 | 2197 | WHERE object_id = %i AND user_id = %i', |
2198 | 2198 | $record['id'], |
2199 | 2199 | $session->get('user-id') |
@@ -2225,7 +2225,7 @@ discard block |
||
2225 | 2225 | if ((int) $post_user_id !== (int) $session->get('user-id')) { |
2226 | 2226 | $currentUserKey = DB::queryFirstRow( |
2227 | 2227 | 'SELECT increment_id |
2228 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
2228 | + FROM ' . prefixTable('sharekeys_items').' |
|
2229 | 2229 | WHERE object_id = %i AND user_id = %i', |
2230 | 2230 | $record['id'], |
2231 | 2231 | $post_user_id |
@@ -2258,7 +2258,7 @@ discard block |
||
2258 | 2258 | // SHould we change step? |
2259 | 2259 | DB::query( |
2260 | 2260 | 'SELECT * |
2261 | - FROM ' . prefixTable('items') . ' |
|
2261 | + FROM ' . prefixTable('items').' |
|
2262 | 2262 | WHERE perso = 0' |
2263 | 2263 | ); |
2264 | 2264 | |
@@ -2283,15 +2283,15 @@ discard block |
||
2283 | 2283 | // Loop on logs |
2284 | 2284 | $rows = DB::query( |
2285 | 2285 | 'SELECT increment_id |
2286 | - FROM ' . prefixTable('log_items') . ' |
|
2286 | + FROM ' . prefixTable('log_items').' |
|
2287 | 2287 | WHERE raison LIKE "at_pw :%" AND encryption_type = "teampass_aes" |
2288 | - LIMIT ' . $post_start . ', ' . $post_length |
|
2288 | + LIMIT ' . $post_start.', '.$post_length |
|
2289 | 2289 | ); |
2290 | 2290 | foreach ($rows as $record) { |
2291 | 2291 | // Get itemKey from current user |
2292 | 2292 | $currentUserKey = DB::queryFirstRow( |
2293 | 2293 | 'SELECT share_key |
2294 | - FROM ' . prefixTable('sharekeys_logs') . ' |
|
2294 | + FROM ' . prefixTable('sharekeys_logs').' |
|
2295 | 2295 | WHERE object_id = %i AND user_id = %i', |
2296 | 2296 | $record['increment_id'], |
2297 | 2297 | $session->get('user-id') |
@@ -2323,7 +2323,7 @@ discard block |
||
2323 | 2323 | if ((int) $post_user_id !== (int) $session->get('user-id')) { |
2324 | 2324 | $currentUserKey = DB::queryFirstRow( |
2325 | 2325 | 'SELECT increment_id |
2326 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
2326 | + FROM ' . prefixTable('sharekeys_items').' |
|
2327 | 2327 | WHERE object_id = %i AND user_id = %i', |
2328 | 2328 | $record['id'], |
2329 | 2329 | $post_user_id |
@@ -2345,7 +2345,7 @@ discard block |
||
2345 | 2345 | // SHould we change step? |
2346 | 2346 | DB::query( |
2347 | 2347 | 'SELECT increment_id |
2348 | - FROM ' . prefixTable('log_items') . ' |
|
2348 | + FROM ' . prefixTable('log_items').' |
|
2349 | 2349 | WHERE raison LIKE "at_pw :%" AND encryption_type = "teampass_aes"' |
2350 | 2350 | ); |
2351 | 2351 | |
@@ -2370,15 +2370,15 @@ discard block |
||
2370 | 2370 | // Loop on fields |
2371 | 2371 | $rows = DB::query( |
2372 | 2372 | 'SELECT id |
2373 | - FROM ' . prefixTable('categories_items') . ' |
|
2373 | + FROM ' . prefixTable('categories_items').' |
|
2374 | 2374 | WHERE encryption_type = "teampass_aes" |
2375 | - LIMIT ' . $post_start . ', ' . $post_length |
|
2375 | + LIMIT ' . $post_start.', '.$post_length |
|
2376 | 2376 | ); |
2377 | 2377 | foreach ($rows as $record) { |
2378 | 2378 | // Get itemKey from current user |
2379 | 2379 | $currentUserKey = DB::queryFirstRow( |
2380 | 2380 | 'SELECT share_key |
2381 | - FROM ' . prefixTable('sharekeys_fields') . ' |
|
2381 | + FROM ' . prefixTable('sharekeys_fields').' |
|
2382 | 2382 | WHERE object_id = %i AND user_id = %i', |
2383 | 2383 | $record['id'], |
2384 | 2384 | $session->get('user-id') |
@@ -2410,7 +2410,7 @@ discard block |
||
2410 | 2410 | if ((int) $post_user_id !== (int) $session->get('user-id')) { |
2411 | 2411 | $currentUserKey = DB::queryFirstRow( |
2412 | 2412 | 'SELECT increment_id |
2413 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
2413 | + FROM ' . prefixTable('sharekeys_items').' |
|
2414 | 2414 | WHERE object_id = %i AND user_id = %i', |
2415 | 2415 | $record['id'], |
2416 | 2416 | $post_user_id |
@@ -2432,7 +2432,7 @@ discard block |
||
2432 | 2432 | // SHould we change step? |
2433 | 2433 | DB::query( |
2434 | 2434 | 'SELECT * |
2435 | - FROM ' . prefixTable('categories_items') . ' |
|
2435 | + FROM ' . prefixTable('categories_items').' |
|
2436 | 2436 | WHERE encryption_type = "teampass_aes"' |
2437 | 2437 | ); |
2438 | 2438 | |
@@ -2457,14 +2457,14 @@ discard block |
||
2457 | 2457 | // Loop on suggestions |
2458 | 2458 | $rows = DB::query( |
2459 | 2459 | 'SELECT id |
2460 | - FROM ' . prefixTable('suggestion') . ' |
|
2461 | - LIMIT ' . $post_start . ', ' . $post_length |
|
2460 | + FROM ' . prefixTable('suggestion').' |
|
2461 | + LIMIT ' . $post_start.', '.$post_length |
|
2462 | 2462 | ); |
2463 | 2463 | foreach ($rows as $record) { |
2464 | 2464 | // Get itemKey from current user |
2465 | 2465 | $currentUserKey = DB::queryFirstRow( |
2466 | 2466 | 'SELECT share_key |
2467 | - FROM ' . prefixTable('sharekeys_suggestions') . ' |
|
2467 | + FROM ' . prefixTable('sharekeys_suggestions').' |
|
2468 | 2468 | WHERE object_id = %i AND user_id = %i', |
2469 | 2469 | $record['id'], |
2470 | 2470 | $session->get('user-id') |
@@ -2496,7 +2496,7 @@ discard block |
||
2496 | 2496 | if ((int) $post_user_id !== (int) $session->get('user-id')) { |
2497 | 2497 | $currentUserKey = DB::queryFirstRow( |
2498 | 2498 | 'SELECT increment_id |
2499 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
2499 | + FROM ' . prefixTable('sharekeys_items').' |
|
2500 | 2500 | WHERE object_id = %i AND user_id = %i', |
2501 | 2501 | $record['id'], |
2502 | 2502 | $post_user_id |
@@ -2542,15 +2542,15 @@ discard block |
||
2542 | 2542 | // Loop on files |
2543 | 2543 | $rows = DB::query( |
2544 | 2544 | 'SELECT id |
2545 | - FROM ' . prefixTable('files') . ' |
|
2546 | - WHERE status = "' . TP_ENCRYPTION_NAME . '" |
|
2547 | - LIMIT ' . $post_start . ', ' . $post_length |
|
2545 | + FROM ' . prefixTable('files').' |
|
2546 | + WHERE status = "' . TP_ENCRYPTION_NAME.'" |
|
2547 | + LIMIT ' . $post_start.', '.$post_length |
|
2548 | 2548 | ); //aes_encryption |
2549 | 2549 | foreach ($rows as $record) { |
2550 | 2550 | // Get itemKey from current user |
2551 | 2551 | $currentUserKey = DB::queryFirstRow( |
2552 | 2552 | 'SELECT share_key |
2553 | - FROM ' . prefixTable('sharekeys_files') . ' |
|
2553 | + FROM ' . prefixTable('sharekeys_files').' |
|
2554 | 2554 | WHERE object_id = %i AND user_id = %i', |
2555 | 2555 | $record['id'], |
2556 | 2556 | $session->get('user-id') |
@@ -2582,7 +2582,7 @@ discard block |
||
2582 | 2582 | if ((int) $post_user_id !== (int) $session->get('user-id')) { |
2583 | 2583 | $currentUserKey = DB::queryFirstRow( |
2584 | 2584 | 'SELECT increment_id |
2585 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
2585 | + FROM ' . prefixTable('sharekeys_items').' |
|
2586 | 2586 | WHERE object_id = %i AND user_id = %i', |
2587 | 2587 | $record['id'], |
2588 | 2588 | $post_user_id |
@@ -2604,8 +2604,8 @@ discard block |
||
2604 | 2604 | // SHould we change step? |
2605 | 2605 | DB::query( |
2606 | 2606 | 'SELECT * |
2607 | - FROM ' . prefixTable('files') . ' |
|
2608 | - WHERE status = "' . TP_ENCRYPTION_NAME . '"' |
|
2607 | + FROM ' . prefixTable('files').' |
|
2608 | + WHERE status = "' . TP_ENCRYPTION_NAME.'"' |
|
2609 | 2609 | ); |
2610 | 2610 | |
2611 | 2611 | $next_start = (int) $post_start + (int) $post_length; |
@@ -2638,16 +2638,16 @@ discard block |
||
2638 | 2638 | if (count($session->get('user-personal_folders')) > 0) { |
2639 | 2639 | $rows = DB::query( |
2640 | 2640 | 'SELECT id, pw |
2641 | - FROM ' . prefixTable('items') . ' |
|
2641 | + FROM ' . prefixTable('items').' |
|
2642 | 2642 | WHERE perso = 1 AND id_tree IN %ls |
2643 | - LIMIT ' . $post_start . ', ' . $post_length, |
|
2643 | + LIMIT ' . $post_start.', '.$post_length, |
|
2644 | 2644 | $session->get('user-personal_folders') |
2645 | 2645 | ); |
2646 | 2646 | foreach ($rows as $record) { |
2647 | 2647 | // Get itemKey from current user |
2648 | 2648 | $currentUserKey = DB::queryFirstRow( |
2649 | 2649 | 'SELECT share_key, increment_id |
2650 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
2650 | + FROM ' . prefixTable('sharekeys_items').' |
|
2651 | 2651 | WHERE object_id = %i AND user_id = %i', |
2652 | 2652 | $record['id'], |
2653 | 2653 | $session->get('user-id') |
@@ -2674,7 +2674,7 @@ discard block |
||
2674 | 2674 | if ((int) $post_user_id !== (int) $session->get('user-id')) { |
2675 | 2675 | $currentUserKey = DB::queryFirstRow( |
2676 | 2676 | 'SELECT increment_id |
2677 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
2677 | + FROM ' . prefixTable('sharekeys_items').' |
|
2678 | 2678 | WHERE object_id = %i AND user_id = %i', |
2679 | 2679 | $record['id'], |
2680 | 2680 | $post_user_id |
@@ -2697,7 +2697,7 @@ discard block |
||
2697 | 2697 | // SHould we change step? |
2698 | 2698 | DB::query( |
2699 | 2699 | 'SELECT * |
2700 | - FROM ' . prefixTable('items') . ' |
|
2700 | + FROM ' . prefixTable('items').' |
|
2701 | 2701 | WHERE perso = 0' |
2702 | 2702 | ); |
2703 | 2703 | |
@@ -2724,7 +2724,7 @@ discard block |
||
2724 | 2724 | // Check if user exists |
2725 | 2725 | $userInfo = DB::queryFirstRow( |
2726 | 2726 | 'SELECT public_key, encrypted_psk |
2727 | - FROM ' . prefixTable('users') . ' |
|
2727 | + FROM ' . prefixTable('users').' |
|
2728 | 2728 | WHERE id = %i', |
2729 | 2729 | $post_user_id |
2730 | 2730 | ); |
@@ -2749,9 +2749,9 @@ discard block |
||
2749 | 2749 | // Loop on persoanl items |
2750 | 2750 | $rows = DB::query( |
2751 | 2751 | 'SELECT id, pw |
2752 | - FROM ' . prefixTable('items') . ' |
|
2752 | + FROM ' . prefixTable('items').' |
|
2753 | 2753 | WHERE perso = 1 AND id_tree IN %ls |
2754 | - LIMIT ' . $post_start . ', ' . $post_length, |
|
2754 | + LIMIT ' . $post_start.', '.$post_length, |
|
2755 | 2755 | $session->get('user-personal_folders') |
2756 | 2756 | ); |
2757 | 2757 | $countUserPersonalItems = DB::count(); |
@@ -2794,7 +2794,7 @@ discard block |
||
2794 | 2794 | // Loop on files |
2795 | 2795 | $rows = DB::query( |
2796 | 2796 | 'SELECT id, file |
2797 | - FROM ' . prefixTable('files') . ' |
|
2797 | + FROM ' . prefixTable('files').' |
|
2798 | 2798 | WHERE status != %s |
2799 | 2799 | AND id_item = %i', |
2800 | 2800 | TP_ENCRYPTION_NAME, |
@@ -2805,14 +2805,14 @@ discard block |
||
2805 | 2805 | // Now decrypt the file |
2806 | 2806 | prepareFileWithDefuse( |
2807 | 2807 | 'decrypt', |
2808 | - $SETTINGS['path_to_upload_folder'] . '/' . $record2['file'], |
|
2809 | - $SETTINGS['path_to_upload_folder'] . '/' . $record2['file'] . '.delete', |
|
2808 | + $SETTINGS['path_to_upload_folder'].'/'.$record2['file'], |
|
2809 | + $SETTINGS['path_to_upload_folder'].'/'.$record2['file'].'.delete', |
|
2810 | 2810 | $SETTINGS, |
2811 | 2811 | $post_user_psk |
2812 | 2812 | ); |
2813 | 2813 | |
2814 | 2814 | // Encrypt the file |
2815 | - $encryptedFile = encryptFile($record2['file'] . '.delete', $SETTINGS['path_to_upload_folder']); |
|
2815 | + $encryptedFile = encryptFile($record2['file'].'.delete', $SETTINGS['path_to_upload_folder']); |
|
2816 | 2816 | |
2817 | 2817 | DB::update( |
2818 | 2818 | prefixTable('files'), |
@@ -2835,7 +2835,7 @@ discard block |
||
2835 | 2835 | ); |
2836 | 2836 | |
2837 | 2837 | // Unlink original file |
2838 | - unlink($SETTINGS['path_to_upload_folder'] . '/' . $record2['file']); |
|
2838 | + unlink($SETTINGS['path_to_upload_folder'].'/'.$record2['file']); |
|
2839 | 2839 | } |
2840 | 2840 | } |
2841 | 2841 | } |
@@ -2907,7 +2907,7 @@ discard block |
||
2907 | 2907 | // Get user info |
2908 | 2908 | $userData = DB::queryFirstRow( |
2909 | 2909 | 'SELECT '.$post_fields.' |
2910 | - FROM ' . prefixTable('users') . ' |
|
2910 | + FROM ' . prefixTable('users').' |
|
2911 | 2911 | WHERE id = %i', |
2912 | 2912 | $post_user_id |
2913 | 2913 | ); |
@@ -2954,7 +2954,7 @@ discard block |
||
2954 | 2954 | // Get user info |
2955 | 2955 | $userData = DB::queryFirstRow( |
2956 | 2956 | 'SELECT auth_type, login, private_key |
2957 | - FROM ' . prefixTable('users') . ' |
|
2957 | + FROM ' . prefixTable('users').' |
|
2958 | 2958 | WHERE id = %i', |
2959 | 2959 | $post_user_id |
2960 | 2960 | ); |
@@ -3004,7 +3004,7 @@ discard block |
||
3004 | 3004 | return prepareExchangedData( |
3005 | 3005 | array( |
3006 | 3006 | 'error' => false, |
3007 | - 'message' => $lang->get('done'),'', |
|
3007 | + 'message' => $lang->get('done'), '', |
|
3008 | 3008 | ), |
3009 | 3009 | 'encode' |
3010 | 3010 | ); |
@@ -3054,7 +3054,7 @@ discard block |
||
3054 | 3054 | // Get user info |
3055 | 3055 | $userData = DB::queryFirstRow( |
3056 | 3056 | 'SELECT auth_type, login, private_key, special |
3057 | - FROM ' . prefixTable('users') . ' |
|
3057 | + FROM ' . prefixTable('users').' |
|
3058 | 3058 | WHERE id = %i', |
3059 | 3059 | $post_user_id |
3060 | 3060 | ); |
@@ -3088,7 +3088,7 @@ discard block |
||
3088 | 3088 | return prepareExchangedData( |
3089 | 3089 | array( |
3090 | 3090 | 'error' => false, |
3091 | - 'message' => $lang->get('done'),'', |
|
3091 | + 'message' => $lang->get('done'), '', |
|
3092 | 3092 | ), |
3093 | 3093 | 'encode' |
3094 | 3094 | ); |
@@ -3112,14 +3112,14 @@ discard block |
||
3112 | 3112 | // Get one item |
3113 | 3113 | $record = DB::queryFirstRow( |
3114 | 3114 | 'SELECT id, pw |
3115 | - FROM ' . prefixTable('items') . ' |
|
3115 | + FROM ' . prefixTable('items').' |
|
3116 | 3116 | WHERE perso = 0' |
3117 | 3117 | ); |
3118 | 3118 | |
3119 | 3119 | // Get itemKey from current user |
3120 | 3120 | $currentUserKey = DB::queryFirstRow( |
3121 | 3121 | 'SELECT share_key, increment_id |
3122 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
3122 | + FROM ' . prefixTable('sharekeys_items').' |
|
3123 | 3123 | WHERE object_id = %i AND user_id = %i', |
3124 | 3124 | $record['id'], |
3125 | 3125 | $post_user_id |
@@ -3208,7 +3208,7 @@ discard block |
||
3208 | 3208 | $session->get('user-id') |
3209 | 3209 | ); |
3210 | 3210 | // Return data |
3211 | - return '[{"new_value":"' . $session->get('user-session_duration') . '"}]'; |
|
3211 | + return '[{"new_value":"'.$session->get('user-session_duration').'"}]'; |
|
3212 | 3212 | } |
3213 | 3213 | |
3214 | 3214 | return '[{"new_value":"expired"}]'; |
@@ -72,7 +72,7 @@ discard block |
||
72 | 72 | ) { |
73 | 73 | // Not allowed page |
74 | 74 | $session->set('system-error_code', ERR_NOT_ALLOWED); |
75 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
75 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
76 | 76 | exit; |
77 | 77 | } |
78 | 78 | |
@@ -119,7 +119,7 @@ discard block |
||
119 | 119 | if (isset($order['column']) && preg_match('#^(asc|desc)$#i', $order['dir'])) { |
120 | 120 | $columnIndex = filter_var($order['column'], FILTER_SANITIZE_NUMBER_INT); |
121 | 121 | $dir = filter_var($order['dir'], FILTER_SANITIZE_FULL_SPECIAL_CHARS); |
122 | - $sOrder .= $aColumns[$columnIndex] . ' ' . $dir . ', '; |
|
122 | + $sOrder .= $aColumns[$columnIndex].' '.$dir.', '; |
|
123 | 123 | } |
124 | 124 | |
125 | 125 | $sOrder = substr_replace($sOrder, '', -2); |
@@ -143,15 +143,15 @@ discard block |
||
143 | 143 | |
144 | 144 | if ($letter !== '' && $letter !== 'None') { |
145 | 145 | $sWhere .= ' AND ('; |
146 | - $sWhere .= $aColumns[1] . " LIKE '" . $letter . "%' OR "; |
|
147 | - $sWhere .= $aColumns[2] . " LIKE '" . $letter . "%' OR "; |
|
148 | - $sWhere .= $aColumns[3] . " LIKE '" . $letter . "%' "; |
|
146 | + $sWhere .= $aColumns[1]." LIKE '".$letter."%' OR "; |
|
147 | + $sWhere .= $aColumns[2]." LIKE '".$letter."%' OR "; |
|
148 | + $sWhere .= $aColumns[3]." LIKE '".$letter."%' "; |
|
149 | 149 | $sWhere .= ')'; |
150 | 150 | } elseif ($searchValue !== '') { |
151 | 151 | $sWhere .= ' AND ('; |
152 | - $sWhere .= $aColumns[1] . " LIKE '" . $searchValue . "%' OR "; |
|
153 | - $sWhere .= $aColumns[2] . " LIKE '" . $searchValue . "%' OR "; |
|
154 | - $sWhere .= $aColumns[3] . " LIKE '" . $searchValue . "%' "; |
|
152 | + $sWhere .= $aColumns[1]." LIKE '".$searchValue."%' OR "; |
|
153 | + $sWhere .= $aColumns[2]." LIKE '".$searchValue."%' OR "; |
|
154 | + $sWhere .= $aColumns[3]." LIKE '".$searchValue."%' "; |
|
155 | 155 | $sWhere .= ')'; |
156 | 156 | } |
157 | 157 | |
@@ -239,22 +239,20 @@ discard block |
||
239 | 239 | |
240 | 240 | // Get some infos about user |
241 | 241 | $userDisplayInfos = |
242 | - (isset($userDate['date']) ? '<i class=\"fas fa-calendar-day infotip text-info ml-2\" title=\"'.$lang->get('creation_date').': '.date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $userDate['date']).'\"></i>' : '') |
|
242 | + (isset($userDate['date']) ? '<i class=\"fas fa-calendar-day infotip text-info ml-2\" title=\"'.$lang->get('creation_date').': '.date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $userDate['date']).'\"></i>' : '') |
|
243 | 243 | . |
244 | 244 | ((int) $record['last_connexion'] > 0 ? '<i class=\"far fa-clock infotip text-info ml-2\" title=\"'.$lang->get('index_last_seen').": ". |
245 | - date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['last_connexion']).'\"></i>' : '') |
|
245 | + date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['last_connexion']).'\"></i>' : '') |
|
246 | 246 | . |
247 | 247 | ((int) $record['user_ip'] > 0 ? '<i class=\"fas fa-street-view infotip text-info ml-1\" title=\"'.$lang->get('ip').": ".($record['user_ip']).'\"></i>' : '') |
248 | 248 | . |
249 | 249 | ($record['auth_type'] === 'ldap' ? '<i class=\"far fa-address-book infotip text-warning ml-1\" title=\"'.$lang->get('managed_through_ad').'\"></i>' : '') |
250 | 250 | . |
251 | 251 | ((in_array($record['id'], [OTV_USER_ID, TP_USER_ID, SSH_USER_ID, API_USER_ID]) === false && (int) $record['admin'] !== 1 && ((int) $SETTINGS['duo'] === 1 || (int) $SETTINGS['google_authentication'] === 1)) ? |
252 | - ((int) $record['mfa_enabled'] === 1 ? '' : '<i class=\"fa-solid fa-fingerprint infotip ml-1\" style=\"color:Tomato\" title=\"'.$lang->get('mfa_disabled_for_user').'\"></i>') : |
|
253 | - '' |
|
252 | + ((int) $record['mfa_enabled'] === 1 ? '' : '<i class=\"fa-solid fa-fingerprint infotip ml-1\" style=\"color:Tomato\" title=\"'.$lang->get('mfa_disabled_for_user').'\"></i>') : '' |
|
254 | 253 | ). |
255 | 254 | ((in_array($record['id'], [OTV_USER_ID, TP_USER_ID, SSH_USER_ID, API_USER_ID]) === false && (int) $record['admin'] !== 1 && is_null($record['keys_recovery_time']) === true) ? |
256 | - '<i class=\"fa-solid fa-download infotip ml-1\" style=\"color:Tomato\" title=\"'.$lang->get('recovery_keys_not_downloaded').'\"></i>' : |
|
257 | - '' |
|
255 | + '<i class=\"fa-solid fa-download infotip ml-1\" style=\"color:Tomato\" title=\"'.$lang->get('recovery_keys_not_downloaded').'\"></i>' : '' |
|
258 | 256 | ); |
259 | 257 | |
260 | 258 | $sOutput .= '["<span data-id=\"'.$record['id'].'\" data-fullname=\"'. |
@@ -73,7 +73,7 @@ discard block |
||
73 | 73 | ) { |
74 | 74 | // Not allowed page |
75 | 75 | $session->set('system-error_code', ERR_NOT_ALLOWED); |
76 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
76 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
77 | 77 | exit; |
78 | 78 | } |
79 | 79 | |
@@ -98,7 +98,7 @@ discard block |
||
98 | 98 | // Is a date sent? |
99 | 99 | $dateCriteria = $request->query->get('dateCriteria'); |
100 | 100 | if ($dateCriteria !== null && !empty($dateCriteria)) { |
101 | - $sWhere .= ' AND a.del_value < ' . round(filter_var($dateCriteria, FILTER_SANITIZE_NUMBER_INT) / 1000, 0); |
|
101 | + $sWhere .= ' AND a.del_value < '.round(filter_var($dateCriteria, FILTER_SANITIZE_NUMBER_INT) / 1000, 0); |
|
102 | 102 | } |
103 | 103 | //echo $sWhere; |
104 | 104 | /* BUILD QUERY */ |
@@ -107,7 +107,7 @@ discard block |
||
107 | 107 | $start = $request->query->getInt('start', 0); |
108 | 108 | $length = $request->query->getInt('length', -1); |
109 | 109 | if ($length !== -1) { |
110 | - $sLimit = ' LIMIT ' . $start . ', ' . $length; |
|
110 | + $sLimit = ' LIMIT '.$start.', '.$length; |
|
111 | 111 | } |
112 | 112 | |
113 | 113 | //Ordering |
@@ -120,7 +120,7 @@ discard block |
||
120 | 120 | $columnIndex = filter_var($order[0]['column'], FILTER_SANITIZE_NUMBER_INT); |
121 | 121 | |
122 | 122 | if (array_key_exists($columnIndex, $aColumns)) { |
123 | - $sOrder .= $aColumns[$columnIndex] . ' ' . $order[0]['dir']; |
|
123 | + $sOrder .= $aColumns[$columnIndex].' '.$order[0]['dir']; |
|
124 | 124 | } |
125 | 125 | |
126 | 126 | // Supprimez la virgule finale si elle existe |
@@ -145,9 +145,9 @@ discard block |
||
145 | 145 | |
146 | 146 | if ($letter !== '' && $letter !== 'None') { |
147 | 147 | $sWhere .= ' AND '; |
148 | - $sWhere .= $aColumns[1] . " LIKE '" . $letter . "%' OR "; |
|
149 | - $sWhere .= $aColumns[2] . " LIKE '" . $letter . "%' OR "; |
|
150 | - $sWhere .= $aColumns[3] . " LIKE '" . $letter . "%' "; |
|
148 | + $sWhere .= $aColumns[1]." LIKE '".$letter."%' OR "; |
|
149 | + $sWhere .= $aColumns[2]." LIKE '".$letter."%' OR "; |
|
150 | + $sWhere .= $aColumns[3]." LIKE '".$letter."%' "; |
|
151 | 151 | } |
152 | 152 | } |
153 | 153 | |
@@ -159,26 +159,26 @@ discard block |
||
159 | 159 | |
160 | 160 | if ($searchValue !== '') { |
161 | 161 | $sWhere = ' AND '; |
162 | - $sWhere .= $aColumns[1] . " LIKE '" . $searchValue . "%' OR "; |
|
163 | - $sWhere .= $aColumns[2] . " LIKE '" . $searchValue . "%' OR "; |
|
164 | - $sWhere .= $aColumns[3] . " LIKE '" . $searchValue . "%' "; |
|
162 | + $sWhere .= $aColumns[1]." LIKE '".$searchValue."%' OR "; |
|
163 | + $sWhere .= $aColumns[2]." LIKE '".$searchValue."%' OR "; |
|
164 | + $sWhere .= $aColumns[3]." LIKE '".$searchValue."%' "; |
|
165 | 165 | } |
166 | 166 | } |
167 | 167 | } |
168 | 168 | |
169 | 169 | $rows = DB::query( |
170 | 170 | 'SELECT a.item_id, i.label, a.del_value, i.id_tree |
171 | - FROM ' . prefixTable('automatic_del') . ' AS a |
|
172 | - INNER JOIN ' . prefixTable('items') . ' AS i ON (i.id = a.item_id)' . |
|
171 | + FROM ' . prefixTable('automatic_del').' AS a |
|
172 | + INNER JOIN ' . prefixTable('items').' AS i ON (i.id = a.item_id)'. |
|
173 | 173 | $sWhere. |
174 | 174 | (string) $sOrder |
175 | 175 | ); |
176 | 176 | $iTotal = DB::count(); |
177 | 177 | $rows = DB::query( |
178 | 178 | 'SELECT a.item_id, i.label, a.del_value, i.id_tree |
179 | - FROM ' . prefixTable('automatic_del') . ' AS a |
|
180 | - INNER JOIN ' . prefixTable('items') . ' AS i ON (i.id = a.item_id)' . |
|
181 | - $sWhere . |
|
179 | + FROM ' . prefixTable('automatic_del').' AS a |
|
180 | + INNER JOIN ' . prefixTable('items').' AS i ON (i.id = a.item_id)'. |
|
181 | + $sWhere. |
|
182 | 182 | $sLimit |
183 | 183 | ); |
184 | 184 | $iFilteredTotal = DB::count(); |
@@ -196,18 +196,18 @@ discard block |
||
196 | 196 | // start the line |
197 | 197 | $sOutput .= '['; |
198 | 198 | // Column 1 |
199 | - $sOutput .= '"<i class=\"fas fa-external-link-alt pointer text-primary mr-2\" onclick=\"showItemCard($(this))\" data-item-id=\"' . $record['item_id'] . '\" data-item-tree-id=\"' . $record['id_tree'] . '\"></i>", '; |
|
199 | + $sOutput .= '"<i class=\"fas fa-external-link-alt pointer text-primary mr-2\" onclick=\"showItemCard($(this))\" data-item-id=\"'.$record['item_id'].'\" data-item-tree-id=\"'.$record['id_tree'].'\"></i>", '; |
|
200 | 200 | // Column 2 |
201 | - $sOutput .= '"' . $record['label'] . '", '; |
|
201 | + $sOutput .= '"'.$record['label'].'", '; |
|
202 | 202 | // Column 3 |
203 | - $sOutput .= '"' . date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['del_value']) . '", '; |
|
203 | + $sOutput .= '"'.date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['del_value']).'", '; |
|
204 | 204 | // Column 4 |
205 | 205 | $path = []; |
206 | 206 | $treeDesc = $tree->getPath($record['id_tree'], true); |
207 | 207 | foreach ($treeDesc as $t) { |
208 | 208 | array_push($path, $t->title); |
209 | 209 | } |
210 | - $sOutput .= '"' . implode('<i class=\"fas fa-angle-right ml-1 mr-1\"></i>', $path) . '"],'; |
|
210 | + $sOutput .= '"'.implode('<i class=\"fas fa-angle-right ml-1 mr-1\"></i>', $path).'"],'; |
|
211 | 211 | } |
212 | 212 | |
213 | 213 | if ($iTotal > 0) { |
@@ -220,4 +220,4 @@ discard block |
||
220 | 220 | } |
221 | 221 | |
222 | 222 | // finalize output |
223 | -echo '{"recordsTotal": ' . $iTotal . ', "recordsFiltered": ' . $iFilteredTotal . ', "data": ' . $sOutput; |
|
223 | +echo '{"recordsTotal": '.$iTotal.', "recordsFiltered": '.$iFilteredTotal.', "data": '.$sOutput; |
@@ -71,7 +71,7 @@ discard block |
||
71 | 71 | ) { |
72 | 72 | // Not allowed page |
73 | 73 | $session->set('system-error_code', ERR_NOT_ALLOWED); |
74 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
74 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
75 | 75 | exit; |
76 | 76 | } |
77 | 77 | |
@@ -115,9 +115,9 @@ discard block |
||
115 | 115 | |
116 | 116 | $columnIndex = filter_var($order['column'], FILTER_SANITIZE_NUMBER_INT); |
117 | 117 | $dir = filter_var($order['dir'], FILTER_SANITIZE_FULL_SPECIAL_CHARS); |
118 | - $sOrder = 'ORDER BY ' . $aColumns[$columnIndex] . ' ' . $dir . ' '; |
|
118 | + $sOrder = 'ORDER BY '.$aColumns[$columnIndex].' '.$dir.' '; |
|
119 | 119 | } else { |
120 | - $sOrder = 'ORDER BY ' . $aColumns[0] . ' DESC'; |
|
120 | + $sOrder = 'ORDER BY '.$aColumns[0].' DESC'; |
|
121 | 121 | } |
122 | 122 | } |
123 | 123 | |
@@ -128,9 +128,9 @@ discard block |
||
128 | 128 | if ($searchValue !== '') { |
129 | 129 | $sWhere .= ' AND ('; |
130 | 130 | foreach ($aColumns as $column) { |
131 | - $sWhere .= $column . " LIKE '%" . $searchValue . "%' OR "; |
|
131 | + $sWhere .= $column." LIKE '%".$searchValue."%' OR "; |
|
132 | 132 | } |
133 | - $sWhere = substr_replace($sWhere, '', -3) . ')'; |
|
133 | + $sWhere = substr_replace($sWhere, '', -3).')'; |
|
134 | 134 | } |
135 | 135 | } |
136 | 136 | |
@@ -155,7 +155,7 @@ discard block |
||
155 | 155 | * Output |
156 | 156 | */ |
157 | 157 | $sOutput = '{'; |
158 | - $sOutput .= '"sEcho": '. (int) $request->query->get('draw') . ', '; |
|
158 | + $sOutput .= '"sEcho": '.(int) $request->query->get('draw').', '; |
|
159 | 159 | $sOutput .= '"iTotalRecords": '.$iTotal.', '; |
160 | 160 | $sOutput .= '"iTotalDisplayRecords": '.$iTotal.', '; |
161 | 161 | $sOutput .= '"aaData": '; |
@@ -194,9 +194,9 @@ discard block |
||
194 | 194 | |
195 | 195 | $columnIndex = filter_var($order['column'], FILTER_SANITIZE_NUMBER_INT); |
196 | 196 | $dir = filter_var($order['dir'], FILTER_SANITIZE_FULL_SPECIAL_CHARS); |
197 | - $sOrder = 'ORDER BY ' . $aColumns[$columnIndex] . ' ' . $dir . ' '; |
|
197 | + $sOrder = 'ORDER BY '.$aColumns[$columnIndex].' '.$dir.' '; |
|
198 | 198 | } else { |
199 | - $sOrder = 'ORDER BY ' . $aColumns[0] . ' DESC'; |
|
199 | + $sOrder = 'ORDER BY '.$aColumns[0].' DESC'; |
|
200 | 200 | } |
201 | 201 | |
202 | 202 | // Filtering |
@@ -205,9 +205,9 @@ discard block |
||
205 | 205 | if ($sSearch !== '') { |
206 | 206 | $sWhere .= ' AND ('; |
207 | 207 | foreach ($aColumns as $i => $column) { |
208 | - $sWhere .= $column . " LIKE '%". filter_var($sSearch, FILTER_SANITIZE_FULL_SPECIAL_CHARS) . "%' OR "; |
|
208 | + $sWhere .= $column." LIKE '%".filter_var($sSearch, FILTER_SANITIZE_FULL_SPECIAL_CHARS)."%' OR "; |
|
209 | 209 | } |
210 | - $sWhere = substr_replace($sWhere, '', -3) . ')'; |
|
210 | + $sWhere = substr_replace($sWhere, '', -3).')'; |
|
211 | 211 | } |
212 | 212 | |
213 | 213 | $iTotal = DB::queryFirstField( |
@@ -230,7 +230,7 @@ discard block |
||
230 | 230 | $iFilteredTotal = DB::count(); |
231 | 231 | // Output |
232 | 232 | $sOutput = '{'; |
233 | - $sOutput .= '"sEcho": '. (int) $request->query->get('draw') . ', '; |
|
233 | + $sOutput .= '"sEcho": '.(int) $request->query->get('draw').', '; |
|
234 | 234 | $sOutput .= '"iTotalRecords": '.$iTotal.', '; |
235 | 235 | $sOutput .= '"iTotalDisplayRecords": '.$iTotal.', '; |
236 | 236 | $sOutput .= '"aaData": '; |
@@ -269,9 +269,9 @@ discard block |
||
269 | 269 | |
270 | 270 | $columnIndex = filter_var($order['column'], FILTER_SANITIZE_NUMBER_INT); |
271 | 271 | $dir = filter_var($order['dir'], FILTER_SANITIZE_FULL_SPECIAL_CHARS); |
272 | - $sOrder = 'ORDER BY ' . $aColumns[$columnIndex] . ' ' . $dir . ' '; |
|
272 | + $sOrder = 'ORDER BY '.$aColumns[$columnIndex].' '.$dir.' '; |
|
273 | 273 | } else { |
274 | - $sOrder = 'ORDER BY ' . $aColumns[0] . ' DESC'; |
|
274 | + $sOrder = 'ORDER BY '.$aColumns[0].' DESC'; |
|
275 | 275 | } |
276 | 276 | |
277 | 277 | // Filtering |
@@ -280,9 +280,9 @@ discard block |
||
280 | 280 | if ($searchValue !== '') { |
281 | 281 | $sWhere .= ' AND ('; |
282 | 282 | foreach ($aColumns as $column) { |
283 | - $sWhere .= $column . " LIKE '%" . filter_var($searchValue, FILTER_SANITIZE_FULL_SPECIAL_CHARS) . "%' OR "; |
|
283 | + $sWhere .= $column." LIKE '%".filter_var($searchValue, FILTER_SANITIZE_FULL_SPECIAL_CHARS)."%' OR "; |
|
284 | 284 | } |
285 | - $sWhere = substr_replace($sWhere, '', -3) . ')'; |
|
285 | + $sWhere = substr_replace($sWhere, '', -3).')'; |
|
286 | 286 | } |
287 | 287 | |
288 | 288 | $iTotal = DB::queryFirstField( |
@@ -305,7 +305,7 @@ discard block |
||
305 | 305 | $iFilteredTotal = DB::count(); |
306 | 306 | // Output |
307 | 307 | $sOutput = '{'; |
308 | - $sOutput .= '"sEcho": '. (int) $request->query->get('draw') . ', '; |
|
308 | + $sOutput .= '"sEcho": '.(int) $request->query->get('draw').', '; |
|
309 | 309 | $sOutput .= '"iTotalRecords": '.$iTotal.', '; |
310 | 310 | $sOutput .= '"iTotalDisplayRecords": '.$iTotal.', '; |
311 | 311 | $sOutput .= '"aaData": '; |
@@ -344,9 +344,9 @@ discard block |
||
344 | 344 | |
345 | 345 | $columnIndex = filter_var($order['column'], FILTER_SANITIZE_NUMBER_INT); |
346 | 346 | $dir = filter_var($order['dir'], FILTER_SANITIZE_FULL_SPECIAL_CHARS); |
347 | - $sOrder = 'ORDER BY ' . $aColumns[$columnIndex] . ' ' . $dir . ' '; |
|
347 | + $sOrder = 'ORDER BY '.$aColumns[$columnIndex].' '.$dir.' '; |
|
348 | 348 | } else { |
349 | - $sOrder = 'ORDER BY ' . $aColumns[0] . ' DESC'; |
|
349 | + $sOrder = 'ORDER BY '.$aColumns[0].' DESC'; |
|
350 | 350 | } |
351 | 351 | |
352 | 352 | // Filtering |
@@ -355,9 +355,9 @@ discard block |
||
355 | 355 | if ($searchValue !== '') { |
356 | 356 | $sWhere .= ' AND ('; |
357 | 357 | foreach ($aColumns as $column) { |
358 | - $sWhere .= $column . " LIKE '%" . filter_var($searchValue, FILTER_SANITIZE_FULL_SPECIAL_CHARS) . "%' OR "; |
|
358 | + $sWhere .= $column." LIKE '%".filter_var($searchValue, FILTER_SANITIZE_FULL_SPECIAL_CHARS)."%' OR "; |
|
359 | 359 | } |
360 | - $sWhere = substr_replace($sWhere, '', -3) . ')'; |
|
360 | + $sWhere = substr_replace($sWhere, '', -3).')'; |
|
361 | 361 | } |
362 | 362 | |
363 | 363 | $iTotal = DB::queryFirstField( |
@@ -379,7 +379,7 @@ discard block |
||
379 | 379 | * Output |
380 | 380 | */ |
381 | 381 | $sOutput = '{'; |
382 | - $sOutput .= '"sEcho": '. (int) $request->query->get('draw') . ', '; |
|
382 | + $sOutput .= '"sEcho": '.(int) $request->query->get('draw').', '; |
|
383 | 383 | $sOutput .= '"iTotalRecords": '.$iTotal.', '; |
384 | 384 | $sOutput .= '"iTotalDisplayRecords": '.$iTotal.', '; |
385 | 385 | $sOutput .= '"aaData": [ '; |
@@ -447,9 +447,9 @@ discard block |
||
447 | 447 | |
448 | 448 | $columnIndex = filter_var($order['column'], FILTER_SANITIZE_NUMBER_INT); |
449 | 449 | $dir = filter_var($order['dir'], FILTER_SANITIZE_FULL_SPECIAL_CHARS); |
450 | - $sOrder = 'ORDER BY ' . $aColumns[$columnIndex] . ' ' . $dir . ' '; |
|
450 | + $sOrder = 'ORDER BY '.$aColumns[$columnIndex].' '.$dir.' '; |
|
451 | 451 | } else { |
452 | - $sOrder = 'ORDER BY ' . $aColumns[0] . ' DESC'; |
|
452 | + $sOrder = 'ORDER BY '.$aColumns[0].' DESC'; |
|
453 | 453 | } |
454 | 454 | |
455 | 455 | // Filtering |
@@ -459,12 +459,12 @@ discard block |
||
459 | 459 | if ($searchValue !== '') { |
460 | 460 | $sWhere .= ' WHERE ('; |
461 | 461 | if (isset($search['column']) && $search['column'] !== 'all') { |
462 | - $sWhere .= $search['column'] . " LIKE '%" . filter_var($searchValue, FILTER_SANITIZE_FULL_SPECIAL_CHARS) . "%') "; |
|
462 | + $sWhere .= $search['column']." LIKE '%".filter_var($searchValue, FILTER_SANITIZE_FULL_SPECIAL_CHARS)."%') "; |
|
463 | 463 | } else { |
464 | 464 | foreach ($aColumns as $column) { |
465 | - $sWhere .= $column . " LIKE '%" . filter_var($searchValue, FILTER_SANITIZE_FULL_SPECIAL_CHARS) . "%' OR "; |
|
465 | + $sWhere .= $column." LIKE '%".filter_var($searchValue, FILTER_SANITIZE_FULL_SPECIAL_CHARS)."%' OR "; |
|
466 | 466 | } |
467 | - $sWhere = substr($sWhere, 0, -3) . ') '; |
|
467 | + $sWhere = substr($sWhere, 0, -3).') '; |
|
468 | 468 | } |
469 | 469 | } |
470 | 470 | |
@@ -493,7 +493,7 @@ discard block |
||
493 | 493 | $iFilteredTotal = DB::count(); |
494 | 494 | // Output |
495 | 495 | $sOutput = '{'; |
496 | - $sOutput .= '"sEcho": '. (int) $request->query->get('draw') . ', '; |
|
496 | + $sOutput .= '"sEcho": '.(int) $request->query->get('draw').', '; |
|
497 | 497 | $sOutput .= '"iTotalRecords": '.$iTotal.', '; |
498 | 498 | $sOutput .= '"iTotalDisplayRecords": '.$iTotal.', '; |
499 | 499 | $sOutput .= '"aaData": [ '; |
@@ -542,9 +542,9 @@ discard block |
||
542 | 542 | |
543 | 543 | $columnIndex = filter_var($order['column'], FILTER_SANITIZE_NUMBER_INT); |
544 | 544 | $dir = filter_var($order['dir'], FILTER_SANITIZE_FULL_SPECIAL_CHARS); |
545 | - $sOrder = 'ORDER BY ' . $aColumns[$columnIndex] . ' ' . $dir . ' '; |
|
545 | + $sOrder = 'ORDER BY '.$aColumns[$columnIndex].' '.$dir.' '; |
|
546 | 546 | } else { |
547 | - $sOrder = 'ORDER BY ' . $aColumns[0] . ' DESC'; |
|
547 | + $sOrder = 'ORDER BY '.$aColumns[0].' DESC'; |
|
548 | 548 | } |
549 | 549 | |
550 | 550 | // Filtering |
@@ -553,9 +553,9 @@ discard block |
||
553 | 553 | if ($searchValue !== '') { |
554 | 554 | $sWhere .= ' AND ('; |
555 | 555 | foreach ($aColumns as $column) { |
556 | - $sWhere .= $column . " LIKE '%" . filter_var($searchValue, FILTER_SANITIZE_FULL_SPECIAL_CHARS) . "%' OR "; |
|
556 | + $sWhere .= $column." LIKE '%".filter_var($searchValue, FILTER_SANITIZE_FULL_SPECIAL_CHARS)."%' OR "; |
|
557 | 557 | } |
558 | - $sWhere = substr_replace($sWhere, '', -3) . ')'; |
|
558 | + $sWhere = substr_replace($sWhere, '', -3).')'; |
|
559 | 559 | } |
560 | 560 | |
561 | 561 | $iTotal = DB::queryFirstField( |
@@ -576,7 +576,7 @@ discard block |
||
576 | 576 | $iTotal = 0; |
577 | 577 | } |
578 | 578 | $sOutput = '{'; |
579 | - $sOutput .= '"sEcho": '. (int) $request->query->get('draw') . ', '; |
|
579 | + $sOutput .= '"sEcho": '.(int) $request->query->get('draw').', '; |
|
580 | 580 | $sOutput .= '"iTotalRecords": '.$iTotal.', '; |
581 | 581 | $sOutput .= '"iTotalDisplayRecords": '.$iTotal.', '; |
582 | 582 | $sOutput .= '"aaData": '; |
@@ -618,9 +618,9 @@ discard block |
||
618 | 618 | |
619 | 619 | $columnIndex = filter_var($order['column'], FILTER_SANITIZE_NUMBER_INT); |
620 | 620 | $dir = filter_var($order['dir'], FILTER_SANITIZE_FULL_SPECIAL_CHARS); |
621 | - $sOrder = 'ORDER BY ' . $aColumns[$columnIndex] . ' ' . $dir . ' '; |
|
621 | + $sOrder = 'ORDER BY '.$aColumns[$columnIndex].' '.$dir.' '; |
|
622 | 622 | } else { |
623 | - $sOrder = 'ORDER BY ' . $aColumns[0] . ' DESC'; |
|
623 | + $sOrder = 'ORDER BY '.$aColumns[0].' DESC'; |
|
624 | 624 | } |
625 | 625 | |
626 | 626 | // Filtering |
@@ -629,9 +629,9 @@ discard block |
||
629 | 629 | if ($searchValue !== '') { |
630 | 630 | $sWhere .= ' AND ('; |
631 | 631 | foreach ($aColumns as $column) { |
632 | - $sWhere .= $column . " LIKE '%" . filter_var($searchValue, FILTER_SANITIZE_FULL_SPECIAL_CHARS) . "%' OR "; |
|
632 | + $sWhere .= $column." LIKE '%".filter_var($searchValue, FILTER_SANITIZE_FULL_SPECIAL_CHARS)."%' OR "; |
|
633 | 633 | } |
634 | - $sWhere = substr_replace($sWhere, '', -3) . ')'; |
|
634 | + $sWhere = substr_replace($sWhere, '', -3).')'; |
|
635 | 635 | } |
636 | 636 | |
637 | 637 | $iTotal = DB::queryFirstField( |
@@ -653,7 +653,7 @@ discard block |
||
653 | 653 | $iFilteredTotal = DB::count(); |
654 | 654 | // Output |
655 | 655 | $sOutput = '{'; |
656 | - $sOutput .= '"sEcho": '. (int) $request->query->get('draw') . ', '; |
|
656 | + $sOutput .= '"sEcho": '.(int) $request->query->get('draw').', '; |
|
657 | 657 | $sOutput .= '"iTotalRecords": '.$iTotal.', '; |
658 | 658 | $sOutput .= '"iTotalDisplayRecords": '.$iTotal.', '; |
659 | 659 | $sOutput .= '"aaData": '; |
@@ -690,9 +690,9 @@ discard block |
||
690 | 690 | |
691 | 691 | $columnIndex = filter_var($order['column'], FILTER_SANITIZE_NUMBER_INT); |
692 | 692 | $dir = filter_var($order['dir'], FILTER_SANITIZE_FULL_SPECIAL_CHARS); |
693 | - $sOrder = 'ORDER BY ' . $aColumns[$columnIndex] . ' ' . $dir . ' '; |
|
693 | + $sOrder = 'ORDER BY '.$aColumns[$columnIndex].' '.$dir.' '; |
|
694 | 694 | } else { |
695 | - $sOrder = 'ORDER BY ' . $aColumns[0] . ' DESC'; |
|
695 | + $sOrder = 'ORDER BY '.$aColumns[0].' DESC'; |
|
696 | 696 | } |
697 | 697 | |
698 | 698 | // Filtering |
@@ -701,9 +701,9 @@ discard block |
||
701 | 701 | if ($searchValue !== '') { |
702 | 702 | $sWhere = ' WHERE ('; |
703 | 703 | foreach ($aColumns as $column) { |
704 | - $sWhere .= $column . " LIKE '%" . filter_var($searchValue, FILTER_SANITIZE_FULL_SPECIAL_CHARS) . "%' OR "; |
|
704 | + $sWhere .= $column." LIKE '%".filter_var($searchValue, FILTER_SANITIZE_FULL_SPECIAL_CHARS)."%' OR "; |
|
705 | 705 | } |
706 | - $sWhere = substr_replace($sWhere, '', -3) . ')'; |
|
706 | + $sWhere = substr_replace($sWhere, '', -3).')'; |
|
707 | 707 | } |
708 | 708 | |
709 | 709 | $iTotal = DB::queryFirstField( |
@@ -726,7 +726,7 @@ discard block |
||
726 | 726 | $iFilteredTotal = DB::count(); |
727 | 727 | // Output |
728 | 728 | $sOutput = '{'; |
729 | - $sOutput .= '"sEcho": '. (int) $request->query->get('draw') . ', '; |
|
729 | + $sOutput .= '"sEcho": '.(int) $request->query->get('draw').', '; |
|
730 | 730 | $sOutput .= '"iTotalRecords": '.$iTotal.', '; |
731 | 731 | $sOutput .= '"iTotalDisplayRecords": '.$iTotal.', '; |
732 | 732 | $sOutput .= '"aaData": '; |
@@ -768,9 +768,9 @@ discard block |
||
768 | 768 | |
769 | 769 | $columnIndex = filter_var($order['column'], FILTER_SANITIZE_NUMBER_INT); |
770 | 770 | $dir = filter_var($order['dir'], FILTER_SANITIZE_FULL_SPECIAL_CHARS); |
771 | - $sOrder = 'ORDER BY ' . $aColumns[$columnIndex] . ' ' . $dir . ' '; |
|
771 | + $sOrder = 'ORDER BY '.$aColumns[$columnIndex].' '.$dir.' '; |
|
772 | 772 | } else { |
773 | - $sOrder = 'ORDER BY ' . $aColumns[0] . ' DESC'; |
|
773 | + $sOrder = 'ORDER BY '.$aColumns[0].' DESC'; |
|
774 | 774 | } |
775 | 775 | |
776 | 776 | // Where clause |
@@ -779,9 +779,9 @@ discard block |
||
779 | 779 | if ($searchValue !== '') { |
780 | 780 | $sWhere .= ' AND ('; |
781 | 781 | foreach ($aColumns as $column) { |
782 | - $sWhere .= $column . " LIKE '%" . filter_var($searchValue, FILTER_SANITIZE_FULL_SPECIAL_CHARS) . "%' OR "; |
|
782 | + $sWhere .= $column." LIKE '%".filter_var($searchValue, FILTER_SANITIZE_FULL_SPECIAL_CHARS)."%' OR "; |
|
783 | 783 | } |
784 | - $sWhere = substr_replace($sWhere, '', -3) . ') '; |
|
784 | + $sWhere = substr_replace($sWhere, '', -3).') '; |
|
785 | 785 | } |
786 | 786 | $sWhere .= ') '; |
787 | 787 | $iTotal = DB::queryFirstField( |
@@ -799,7 +799,7 @@ discard block |
||
799 | 799 | $iFilteredTotal = DB::count(); |
800 | 800 | // Output |
801 | 801 | $sOutput = '{'; |
802 | - $sOutput .= '"sEcho": '. (int) $request->query->get('draw') . ', '; |
|
802 | + $sOutput .= '"sEcho": '.(int) $request->query->get('draw').', '; |
|
803 | 803 | $sOutput .= '"iTotalRecords": '.$iTotal.', '; |
804 | 804 | $sOutput .= '"iTotalDisplayRecords": '.$iTotal.', '; |
805 | 805 | $sOutput .= '"aaData": '; |
@@ -848,9 +848,9 @@ discard block |
||
848 | 848 | |
849 | 849 | $columnIndex = filter_var($order['column'], FILTER_SANITIZE_NUMBER_INT); |
850 | 850 | $dir = filter_var($order['dir'], FILTER_SANITIZE_FULL_SPECIAL_CHARS); |
851 | - $sOrder = 'ORDER BY ' . $aColumns[$columnIndex] . ' ' . $dir . ' '; |
|
851 | + $sOrder = 'ORDER BY '.$aColumns[$columnIndex].' '.$dir.' '; |
|
852 | 852 | } else { |
853 | - $sOrder = 'ORDER BY ' . $aColumns[0] . ' DESC'; |
|
853 | + $sOrder = 'ORDER BY '.$aColumns[0].' DESC'; |
|
854 | 854 | } |
855 | 855 | |
856 | 856 | // Where clause |
@@ -859,9 +859,9 @@ discard block |
||
859 | 859 | if ($searchValue !== '') { |
860 | 860 | $sWhere .= ' AND ('; |
861 | 861 | foreach ($aColumns as $column) { |
862 | - $sWhere .= $column . " LIKE '%" . filter_var($searchValue, FILTER_SANITIZE_FULL_SPECIAL_CHARS) . "%' OR "; |
|
862 | + $sWhere .= $column." LIKE '%".filter_var($searchValue, FILTER_SANITIZE_FULL_SPECIAL_CHARS)."%' OR "; |
|
863 | 863 | } |
864 | - $sWhere = substr_replace($sWhere, '', -3) . ')'; |
|
864 | + $sWhere = substr_replace($sWhere, '', -3).')'; |
|
865 | 865 | } |
866 | 866 | $sWhere .= ') '; |
867 | 867 | DB::debugmode(false); |
@@ -882,7 +882,7 @@ discard block |
||
882 | 882 | $iFilteredTotal = DB::count(); |
883 | 883 | // Output |
884 | 884 | $sOutput = '{'; |
885 | - $sOutput .= '"sEcho": '. (int) $request->query->get('draw') . ', '; |
|
885 | + $sOutput .= '"sEcho": '.(int) $request->query->get('draw').', '; |
|
886 | 886 | $sOutput .= '"iTotalRecords": '.$iTotal.', '; |
887 | 887 | $sOutput .= '"iTotalDisplayRecords": '.$iTotal.', '; |
888 | 888 | $sOutput .= '"aaData": '; |
@@ -894,15 +894,15 @@ discard block |
||
894 | 894 | //col1 |
895 | 895 | $sOutput .= '"<span data-done=\"'.$record['is_in_progress'].'\" data-type=\"'.$record['process_type'].'\" data-process-id=\"'.$record['increment_id'].'\"></span>", '; |
896 | 896 | //col2 |
897 | - $sOutput .= '"'.date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['created_at']).'", '; |
|
897 | + $sOutput .= '"'.date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['created_at']).'", '; |
|
898 | 898 | //col3 |
899 | - $sOutput .= '"'.($record['updated_at'] === '' ? '-' : date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['updated_at'])).'", '; |
|
899 | + $sOutput .= '"'.($record['updated_at'] === '' ? '-' : date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['updated_at'])).'", '; |
|
900 | 900 | //col4 |
901 | 901 | $sOutput .= '"'.$record['process_type'].'", '; |
902 | 902 | // col5 |
903 | 903 | if (in_array($record['process_type'], array('create_user_keys', 'item_copy')) === true) { |
904 | 904 | $data_user = DB::queryfirstrow( |
905 | - 'SELECT name, lastname FROM ' . prefixTable('users') . ' |
|
905 | + 'SELECT name, lastname FROM '.prefixTable('users').' |
|
906 | 906 | WHERE id = %i', |
907 | 907 | json_decode($record['arguments'], true)['new_user_id'] |
908 | 908 | ); |
@@ -934,9 +934,9 @@ discard block |
||
934 | 934 | |
935 | 935 | $columnIndex = filter_var($order['column'], FILTER_SANITIZE_NUMBER_INT); |
936 | 936 | $dir = filter_var($order['dir'], FILTER_SANITIZE_FULL_SPECIAL_CHARS); |
937 | - $sOrder = 'ORDER BY ' . $aColumns[$columnIndex] . ' ' . $dir . ' '; |
|
937 | + $sOrder = 'ORDER BY '.$aColumns[$columnIndex].' '.$dir.' '; |
|
938 | 938 | } else { |
939 | - $sOrder = 'ORDER BY ' . $aColumns[0] . ' DESC'; |
|
939 | + $sOrder = 'ORDER BY '.$aColumns[0].' DESC'; |
|
940 | 940 | } |
941 | 941 | |
942 | 942 | // Where clause |
@@ -945,9 +945,9 @@ discard block |
||
945 | 945 | if ($searchValue !== '') { |
946 | 946 | $sWhere .= ' AND ('; |
947 | 947 | foreach ($aColumns as $column) { |
948 | - $sWhere .= $column . " LIKE '%" . filter_var($searchValue, FILTER_SANITIZE_FULL_SPECIAL_CHARS) . "%' OR "; |
|
948 | + $sWhere .= $column." LIKE '%".filter_var($searchValue, FILTER_SANITIZE_FULL_SPECIAL_CHARS)."%' OR "; |
|
949 | 949 | } |
950 | - $sWhere = substr_replace($sWhere, '', -3) . ')'; |
|
950 | + $sWhere = substr_replace($sWhere, '', -3).')'; |
|
951 | 951 | } |
952 | 952 | $sWhere .= ') '; |
953 | 953 | |
@@ -970,7 +970,7 @@ discard block |
||
970 | 970 | $iFilteredTotal = DB::count(); |
971 | 971 | // Output |
972 | 972 | $sOutput = '{'; |
973 | - $sOutput .= '"sEcho": '. (int) $request->query->get('draw') . ', '; |
|
973 | + $sOutput .= '"sEcho": '.(int) $request->query->get('draw').', '; |
|
974 | 974 | $sOutput .= '"iTotalRecords": '.$iTotal.', '; |
975 | 975 | $sOutput .= '"iTotalDisplayRecords": '.$iTotal.', '; |
976 | 976 | $sOutput .= '"aaData": '; |
@@ -986,13 +986,12 @@ discard block |
||
986 | 986 | //col1 |
987 | 987 | $sOutput .= '"", '; |
988 | 988 | //col2 |
989 | - $sOutput .= '"'.date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['created_at']).'", '; |
|
989 | + $sOutput .= '"'.date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['created_at']).'", '; |
|
990 | 990 | //col3 |
991 | 991 | $sOutput .= is_null($record['started_at']) === false ? |
992 | - ('"'.date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['started_at']).'", ') : |
|
993 | - ('"'.date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['created_at']).'", '); |
|
992 | + ('"'.date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['started_at']).'", ') : ('"'.date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['created_at']).'", '); |
|
994 | 993 | //col4 |
995 | - $sOutput .= '"'.date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['finished_at']).'", '; |
|
994 | + $sOutput .= '"'.date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['finished_at']).'", '; |
|
996 | 995 | // col7 |
997 | 996 | $sOutput .= '"'.gmdate('H:i:s', (int) $record['finished_at'] - (is_null($record['started_at']) === false ? (int) $record['started_at'] : (int) $record['created_at'])).'",'; |
998 | 997 | //col5 |
@@ -1011,7 +1010,7 @@ discard block |
||
1011 | 1010 | $newUserId = array_key_exists('new_user_id', $arguments) ? $arguments['new_user_id'] : null; |
1012 | 1011 | if ($record['process_type'] === 'create_user_keys' && is_null($newUserId) === false && empty($newUserId) === false) { |
1013 | 1012 | $data_user = DB::queryfirstrow( |
1014 | - 'SELECT name, lastname, login FROM ' . prefixTable('users') . ' |
|
1013 | + 'SELECT name, lastname, login FROM '.prefixTable('users').' |
|
1015 | 1014 | WHERE id = %i', |
1016 | 1015 | $newUserId |
1017 | 1016 | ); |
@@ -1027,7 +1026,7 @@ discard block |
||
1027 | 1026 | } elseif ($record['process_type'] === 'user_build_cache_tree') { |
1028 | 1027 | $user = json_decode($record['arguments'], true)['user_id']; |
1029 | 1028 | $data_user = DB::queryfirstrow( |
1030 | - 'SELECT name, lastname, login FROM ' . prefixTable('users') . ' |
|
1029 | + 'SELECT name, lastname, login FROM '.prefixTable('users').' |
|
1031 | 1030 | WHERE id = %i', |
1032 | 1031 | $user |
1033 | 1032 | ); |
@@ -68,7 +68,7 @@ discard block |
||
68 | 68 | if ($checkUserAccess->checkSession() === false || $checkUserAccess->userAccessPage('backups') === false) { |
69 | 69 | // Not allowed page |
70 | 70 | $session->set('system-error_code', ERR_NOT_ALLOWED); |
71 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
71 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
72 | 72 | exit; |
73 | 73 | } |
74 | 74 | ?> |
@@ -137,7 +137,7 @@ discard block |
||
137 | 137 | // ERROR |
138 | 138 | toastr.remove(); |
139 | 139 | toastr.error( |
140 | - '<?php echo $lang->get('server_answer_error') . '<br />' . $lang->get('server_returned_data') . ':<br />'; ?>' + data.error, |
|
140 | + '<?php echo $lang->get('server_answer_error').'<br />'.$lang->get('server_returned_data').':<br />'; ?>' + data.error, |
|
141 | 141 | '<?php echo $lang->get('error'); ?>', { |
142 | 142 | timeOut: 5000, |
143 | 143 | progressBar: true |
@@ -164,7 +164,7 @@ discard block |
||
164 | 164 | // error |
165 | 165 | toastr.remove(); |
166 | 166 | toastr.error( |
167 | - '<?php echo $lang->get('server_answer_error') . '<br />' . $lang->get('server_returned_data') . ':<br />'; ?>' + data.error, |
|
167 | + '<?php echo $lang->get('server_answer_error').'<br />'.$lang->get('server_returned_data').':<br />'; ?>' + data.error, |
|
168 | 168 | '<?php echo $lang->get('error'); ?>', { |
169 | 169 | timeOut: 5000, |
170 | 170 | progressBar: true |
@@ -235,7 +235,7 @@ discard block |
||
235 | 235 | // ERROR |
236 | 236 | toastr.remove(); |
237 | 237 | toastr.error( |
238 | - '<?php echo $lang->get('server_answer_error') . '<br />' . $lang->get('server_returned_data') . ':<br />'; ?>' + data.error, |
|
238 | + '<?php echo $lang->get('server_answer_error').'<br />'.$lang->get('server_returned_data').':<br />'; ?>' + data.error, |
|
239 | 239 | '<?php echo $lang->get('error'); ?>', { |
240 | 240 | timeOut: 5000, |
241 | 241 | progressBar: true |
@@ -271,7 +271,7 @@ discard block |
||
271 | 271 | // PREPARE UPLOADER with plupload |
272 | 272 | <?php |
273 | 273 | $maxFileSize = (strrpos($SETTINGS['upload_maxfilesize'], 'mb') === false) |
274 | - ? $SETTINGS['upload_maxfilesize'] . 'mb' |
|
274 | + ? $SETTINGS['upload_maxfilesize'].'mb' |
|
275 | 275 | : $SETTINGS['upload_maxfilesize']; |
276 | 276 | ?> |
277 | 277 |
@@ -66,7 +66,7 @@ discard block |
||
66 | 66 | if ($checkUserAccess->checkSession() === false || $checkUserAccess->userAccessPage('utilities.logs') === false) { |
67 | 67 | // Not allowed page |
68 | 68 | $session->set('system-error_code', ERR_NOT_ALLOWED); |
69 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
69 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
70 | 70 | exit; |
71 | 71 | } |
72 | 72 | |
@@ -203,7 +203,7 @@ discard block |
||
203 | 203 | echo $session->has('user-admin') && (int) $session->get('user-admin') && null !== $session->get('user-admin') && (int) $session->get('user-admin') === 1 ? '' : ' hidden'; |
204 | 204 | ?>"> |
205 | 205 | <div class="form-group"> |
206 | - <h5><i class="fas fa-broom mr-2"></i><?php echo $lang->get('purge') . ' ' . $lang->get('date_range'); ?></h5> |
|
206 | + <h5><i class="fas fa-broom mr-2"></i><?php echo $lang->get('purge').' '.$lang->get('date_range'); ?></h5> |
|
207 | 207 | <div class="input-group"> |
208 | 208 | <div class="input-group-prepend"> |
209 | 209 | <span class="input-group-text"> |
@@ -226,7 +226,7 @@ discard block |
||
226 | 226 | <select class="form-control" id="purge-filter-user"> |
227 | 227 | <option value="-1"><?php echo $lang->get('all'); ?></option> |
228 | 228 | <?php |
229 | - $rows = DB::query('SELECT id, name, lastname FROM ' . prefixTable('users') . ' WHERE admin = 0'); |
|
229 | + $rows = DB::query('SELECT id, name, lastname FROM '.prefixTable('users').' WHERE admin = 0'); |
|
230 | 230 | foreach ($rows as $record) { |
231 | 231 | echo ' |
232 | 232 | <option value="'.$record['id'].'">'.$record['name'].' '.$record['lastname'].'</option>'; |
@@ -64,7 +64,7 @@ discard block |
||
64 | 64 | if ($checkUserAccess->checkSession() === false || $checkUserAccess->userAccessPage('profile') === false) { |
65 | 65 | // Not allowed page |
66 | 66 | $session->set('system-error_code', ERR_NOT_ALLOWED); |
67 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
67 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
68 | 68 | exit; |
69 | 69 | } |
70 | 70 | |
@@ -96,25 +96,25 @@ discard block |
||
96 | 96 | // prepare list of timezones |
97 | 97 | $zones = timezone_list(); |
98 | 98 | // prepare list of languages |
99 | -$languages = DB::query('SELECT label, name FROM ' . prefixTable('languages') . ' ORDER BY label ASC'); |
|
99 | +$languages = DB::query('SELECT label, name FROM '.prefixTable('languages').' ORDER BY label ASC'); |
|
100 | 100 | // Do some stats |
101 | -DB::query('SELECT id_item FROM ' . prefixTable('log_items') . ' WHERE action = "at_creation" AND id_user = "' . $session->get('user-id') . '"'); |
|
101 | +DB::query('SELECT id_item FROM '.prefixTable('log_items').' WHERE action = "at_creation" AND id_user = "'.$session->get('user-id').'"'); |
|
102 | 102 | $userItemsNumber = DB::count(); |
103 | -DB::query('SELECT id_item FROM ' . prefixTable('log_items') . ' WHERE action = "at_modification" AND id_user = "' . $session->get('user-id') . '"'); |
|
103 | +DB::query('SELECT id_item FROM '.prefixTable('log_items').' WHERE action = "at_modification" AND id_user = "'.$session->get('user-id').'"'); |
|
104 | 104 | $userModificationNumber = DB::count(); |
105 | -DB::query('SELECT id_item FROM ' . prefixTable('log_items') . ' WHERE action = "at_shown" AND id_user = "' . $session->get('user-id') . '"'); |
|
105 | +DB::query('SELECT id_item FROM '.prefixTable('log_items').' WHERE action = "at_shown" AND id_user = "'.$session->get('user-id').'"'); |
|
106 | 106 | $userSeenItemsNumber = DB::count(); |
107 | -DB::query('SELECT id_item FROM ' . prefixTable('log_items') . ' WHERE action = "at_password_shown" AND id_user = "' . $session->get('user-id') . '"'); |
|
107 | +DB::query('SELECT id_item FROM '.prefixTable('log_items').' WHERE action = "at_password_shown" AND id_user = "'.$session->get('user-id').'"'); |
|
108 | 108 | $userSeenPasswordsNumber = DB::count(); |
109 | 109 | $userInfo = DB::queryFirstRow( |
110 | 110 | 'SELECT avatar, last_pw_change |
111 | - FROM ' . prefixTable('users') . ' |
|
112 | - WHERE id = "' . $session->get('user-id') . '"' |
|
111 | + FROM ' . prefixTable('users').' |
|
112 | + WHERE id = "' . $session->get('user-id').'"' |
|
113 | 113 | ); |
114 | 114 | if (empty($userInfo['avatar']) === true) { |
115 | - $avatar = $SETTINGS['cpassman_url'] . '/includes/images/photo.jpg'; |
|
115 | + $avatar = $SETTINGS['cpassman_url'].'/includes/images/photo.jpg'; |
|
116 | 116 | } else { |
117 | - $avatar = $SETTINGS['cpassman_url'] . '/includes/avatars/' . $userInfo['avatar']; |
|
117 | + $avatar = $SETTINGS['cpassman_url'].'/includes/avatars/'.$userInfo['avatar']; |
|
118 | 118 | } |
119 | 119 | |
120 | 120 | // Get Groups name |
@@ -122,8 +122,8 @@ discard block |
||
122 | 122 | foreach ($session->get('user-roles_array') as $role) { |
123 | 123 | $tmp = DB::queryFirstRow( |
124 | 124 | 'SELECT title |
125 | - FROM ' . prefixTable('roles_title') . ' |
|
126 | - WHERE id = "' . $role . '"' |
|
125 | + FROM ' . prefixTable('roles_title').' |
|
126 | + WHERE id = "' . $role.'"' |
|
127 | 127 | ); |
128 | 128 | if ($tmp !== null) { |
129 | 129 | array_push($userParOfGroups, $tmp['title']); |
@@ -167,7 +167,7 @@ discard block |
||
167 | 167 | <h3 id="profile-username" class="text-center"> |
168 | 168 | <?php |
169 | 169 | if (null !== $session->get('user-name') && empty($session->get('user-name')) === false) { |
170 | - echo $session->get('user-name') . ' ' . $session->get('user-lastname'); |
|
170 | + echo $session->get('user-name').' '.$session->get('user-lastname'); |
|
171 | 171 | } else { |
172 | 172 | echo $session->get('user-login'); |
173 | 173 | } |
@@ -235,7 +235,7 @@ discard block |
||
235 | 235 | } else { |
236 | 236 | echo date('d/m/Y', (int) $session->get('user-last_connection')); |
237 | 237 | } |
238 | - echo ' ' . $lang->get('at') . ' '; |
|
238 | + echo ' '.$lang->get('at').' '; |
|
239 | 239 | if (isset($SETTINGS['time_format']) === true) { |
240 | 240 | echo date($SETTINGS['time_format'], (int) $session->get('user-last_connection')); |
241 | 241 | } else { |
@@ -245,7 +245,7 @@ discard block |
||
245 | 245 | </a> |
246 | 246 | </li> |
247 | 247 | <?php |
248 | - if (null !== $session->get('user-last_pw_change') && ! empty($session->get('user-last_pw_change') === true)) { |
|
248 | + if (null !== $session->get('user-last_pw_change') && !empty($session->get('user-last_pw_change') === true)) { |
|
249 | 249 | // Handle last password change string |
250 | 250 | if ($session->has('user-last_pw_change') && null !== $session->get('user-last_pw_change')) { |
251 | 251 | if (isset($SETTINGS['date_format']) === true) { |
@@ -265,12 +265,12 @@ discard block |
||
265 | 265 | ) { |
266 | 266 | $numDaysBeforePwExpiration = ''; |
267 | 267 | } else { |
268 | - $numDaysBeforePwExpiration = $LANG['index_pw_expiration'] . ' ' . $session->get('user-num_days_before_exp') . ' ' . $LANG['days'] . '.'; |
|
268 | + $numDaysBeforePwExpiration = $LANG['index_pw_expiration'].' '.$session->get('user-num_days_before_exp').' '.$LANG['days'].'.'; |
|
269 | 269 | } |
270 | 270 | echo ' |
271 | 271 | <li class="list-group-item"> |
272 | - <b><i class="fas fa-calendar-alt fa-fw fa-lg mr-2"></i>' . $lang->get('index_last_pw_change') . '</b> |
|
273 | - <a class="float-right">' . $last_pw_change . ' ' . $numDaysBeforePwExpiration . '</a> |
|
272 | + <b><i class="fas fa-calendar-alt fa-fw fa-lg mr-2"></i>' . $lang->get('index_last_pw_change').'</b> |
|
273 | + <a class="float-right">' . $last_pw_change.' '.$numDaysBeforePwExpiration.'</a> |
|
274 | 274 | </li>'; |
275 | 275 | } |
276 | 276 | ?> |
@@ -290,7 +290,7 @@ discard block |
||
290 | 290 | if (isset($SETTINGS['api']) === true && (int) $SETTINGS['api'] === 1) { |
291 | 291 | echo ' |
292 | 292 | <li class="list-group-item"> |
293 | - <b><i class="fas fa-paper-plane fa-fw fa-lg mr-2"></i>' . $lang->get('user_profile_api_key') . '</b> |
|
293 | + <b><i class="fas fa-paper-plane fa-fw fa-lg mr-2"></i>' . $lang->get('user_profile_api_key').'</b> |
|
294 | 294 | <a class="float-right" id="profile-user-api-token">', |
295 | 295 | null !== $session->get('user-api_key') ? $session->get('user-api_key') : '', |
296 | 296 | '</a> |
@@ -326,7 +326,7 @@ discard block |
||
326 | 326 | <ul class=""> |
327 | 327 | <?php |
328 | 328 | foreach ($session->get('user-unsuccessfull_login_attempts_list') as $entry) { |
329 | - echo '<li class="">' . $entry . '</li>'; |
|
329 | + echo '<li class="">'.$entry.'</li>'; |
|
330 | 330 | } ?> |
331 | 331 | </ul> |
332 | 332 | </div> |
@@ -339,12 +339,12 @@ discard block |
||
339 | 339 | <?php |
340 | 340 | $rows = DB::query( |
341 | 341 | 'SELECT label AS labelAction, date, null |
342 | - FROM ' . prefixTable('log_system') . ' |
|
342 | + FROM ' . prefixTable('log_system').' |
|
343 | 343 | WHERE qui = %i |
344 | 344 | UNION |
345 | 345 | SELECT l.action, l.date, i.label AS itemLabel |
346 | - FROM ' . prefixTable('log_items') . ' AS l |
|
347 | - INNER JOIN ' . prefixTable('items') . ' AS i ON (l.id_item = i.id) |
|
346 | + FROM ' . prefixTable('log_items').' AS l |
|
347 | + INNER JOIN ' . prefixTable('items').' AS i ON (l.id_item = i.id) |
|
348 | 348 | WHERE l.id_user = %i AND l.action IN ("at_access") |
349 | 349 | ORDER BY date DESC |
350 | 350 | LIMIT 0, 40', |
@@ -358,9 +358,9 @@ discard block |
||
358 | 358 | $text = $lang->get($record['labelAction']); |
359 | 359 | } |
360 | 360 | if (empty($record['NULL']) === false) { |
361 | - $text .= ' ' . $lang->get('for') . ' <span class="font-weight-light">' . addslashes($record['NULL']) . '</span>'; |
|
361 | + $text .= ' '.$lang->get('for').' <span class="font-weight-light">'.addslashes($record['NULL']).'</span>'; |
|
362 | 362 | } |
363 | - echo '<li class="list-group-item">' . date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['date']) . ' - ' . $text . '</li>'; |
|
363 | + echo '<li class="list-group-item">'.date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['date']).' - '.$text.'</li>'; |
|
364 | 364 | } |
365 | 365 | ?> |
366 | 366 | </ul> |
@@ -398,11 +398,10 @@ discard block |
||
398 | 398 | <?php |
399 | 399 | foreach ($zones as $key => $zone) { |
400 | 400 | echo ' |
401 | - <option value="' . $key . '"', |
|
401 | + <option value="' . $key.'"', |
|
402 | 402 | $session->has('user-timezone') && $session->get('user-timezone') && null !== $session->get('user-timezone') && $session->get('user-timezone') === $key ? |
403 | - ' selected' : |
|
404 | - (isset($SETTINGS['timezone']) === true && $SETTINGS['timezone'] === $key ? ' selected' : ''), |
|
405 | - '>' . $zone . '</option>'; |
|
403 | + ' selected' : (isset($SETTINGS['timezone']) === true && $SETTINGS['timezone'] === $key ? ' selected' : ''), |
|
404 | + '>'.$zone.'</option>'; |
|
406 | 405 | } |
407 | 406 | ?> |
408 | 407 | </select> |
@@ -414,10 +413,10 @@ discard block |
||
414 | 413 | <select class="form-control" id="profile-user-language"> |
415 | 414 | <?php |
416 | 415 | foreach ($languages as $language) { |
417 | - echo '<option value="' . $language['name'] . '"', |
|
416 | + echo '<option value="'.$language['name'].'"', |
|
418 | 417 | strtolower($session->get('user-language')) === strtolower($language['name']) ? |
419 | 418 | ' selected="selected"' : '', |
420 | - '>' . $language['label'] . '</option>'; |
|
419 | + '>'.$language['label'].'</option>'; |
|
421 | 420 | } |
422 | 421 | ?> |
423 | 422 | </select> |
@@ -429,11 +428,11 @@ discard block |
||
429 | 428 | <div class="col-sm-10"> |
430 | 429 | <select class="form-control" id="profile-user-treeloadstrategy"> |
431 | 430 | |
432 | - <option value="sequential" <?php echo $session->has('user-tree_load_strategy') && $session->get('user-tree_load_strategy') && null !== $session->get('user-tree_load_strategy') && $session->get('user-tree_load_strategy') === 'sequential' ? ' selected' : '';?>> |
|
431 | + <option value="sequential" <?php echo $session->has('user-tree_load_strategy') && $session->get('user-tree_load_strategy') && null !== $session->get('user-tree_load_strategy') && $session->get('user-tree_load_strategy') === 'sequential' ? ' selected' : ''; ?>> |
|
433 | 432 | <?php echo $lang->get('sequential'); ?> |
434 | 433 | </option> |
435 | 434 | |
436 | - <option value="full" <?php echo $session->has('user-tree_load_strategy') && $session->get('user-tree_load_strategy') && null !== $session->get('user-tree_load_strategy') && $session->get('user-tree_load_strategy') === 'full' ? ' selected' : '';?>> |
|
435 | + <option value="full" <?php echo $session->has('user-tree_load_strategy') && $session->get('user-tree_load_strategy') && null !== $session->get('user-tree_load_strategy') && $session->get('user-tree_load_strategy') === 'full' ? ' selected' : ''; ?>> |
|
437 | 436 | <?php echo $lang->get('full'); ?> |
438 | 437 | </option> |
439 | 438 | </select> |
@@ -468,7 +467,7 @@ discard block |
||
468 | 467 | <button type="button" class="btn btn-warning float-right ml-2" id="profile-avatar-file"><?php echo $lang->get('upload_new_avatar'); ?></button> |
469 | 468 | <?php |
470 | 469 | if (isset($SETTINGS['api']) === true && (int) $SETTINGS['api'] === 1) { |
471 | - echo '<button type="button" class="btn btn-warning float-right" id="profile-button-api_token">' . $lang->get('generate_api_token') . '</button>'; |
|
470 | + echo '<button type="button" class="btn btn-warning float-right" id="profile-button-api_token">'.$lang->get('generate_api_token').'</button>'; |
|
472 | 471 | } |
473 | 472 | ?> |
474 | 473 | <div id="profile-avatar-file-container" class="hidden"></div> |