Passed
Push — teampass_3.0 ( 2e6bd1...4c0075 )
by Nils
13:44 queued 05:04
created
pages/users.js.php 1 patch
Spacing   +11 added lines, -11 removed lines patch added patch discarded remove patch
@@ -43,11 +43,11 @@  discard block
 block discarded – undo
43 43
 }
44 44
 
45 45
 /* do checks */
46
-require_once $SETTINGS['cpassman_dir'] . '/sources/checks.php';
46
+require_once $SETTINGS['cpassman_dir'].'/sources/checks.php';
47 47
 if (checkUser($_SESSION['user_id'], $_SESSION['key'], 'folders', $SETTINGS) === false) {
48 48
     $_SESSION['error']['code'] = ERR_NOT_ALLOWED;
49 49
     //not allowed page
50
-    include $SETTINGS['cpassman_dir'] . '/error.php';
50
+    include $SETTINGS['cpassman_dir'].'/error.php';
51 51
     exit;
52 52
 }
53 53
 ?>
@@ -275,8 +275,8 @@  discard block
 block discarded – undo
275 275
         if (store.get('teampassApplication').formUserAction === "add_new_user") {
276 276
             var data = {
277 277
                 'receipt': $('#form-email').val(),
278
-                'subject': 'TEAMPASS - <?php echo langHdl('temporary_encryption_code');?>',
279
-                'body': '<?php echo langHdl('email_body_new_user');?>',
278
+                'subject': 'TEAMPASS - <?php echo langHdl('temporary_encryption_code'); ?>',
279
+                'body': '<?php echo langHdl('email_body_new_user'); ?>',
280 280
                 'pre_replace' : {
281 281
                     '#code#' : store.get('teampassUser').admin_new_user_temporary_encryption_code,
282 282
                     '#login#' : store.get('teampassUser').admin_new_user_login,
@@ -286,8 +286,8 @@  discard block
 block discarded – undo
286 286
         } else {
287 287
             var data = {
288 288
                 'receipt': $('#form-email').val(),
289
-                'subject': 'TEAMPASS - <?php echo langHdl('temporary_encryption_code');?>',
290
-                'body': '<?php echo langHdl('email_body_temporary_encryption_code');?>',
289
+                'subject': 'TEAMPASS - <?php echo langHdl('temporary_encryption_code'); ?>',
290
+                'body': '<?php echo langHdl('email_body_temporary_encryption_code'); ?>',
291 291
                 'pre_replace' : {
292 292
                     '#enc_code#' : store.get('teampassUser').admin_new_user_temporary_encryption_code,
293 293
                 }
@@ -464,13 +464,13 @@  discard block
 block discarded – undo
464 464
             }
465 465
             // Inform user
466 466
             $("#warningModalBody").html('<b><?php echo langHdl('encryption_keys'); ?> - ' +
467
-                stepText + '</b> [' + start + ' - ' + (parseInt(start) + <?php echo NUMBER_ITEMS_IN_BATCH;?>) + ']<span id="warningModalBody_extra">' + $nbItemsToConvert + '</span> ' +
467
+                stepText + '</b> [' + start + ' - ' + (parseInt(start) + <?php echo NUMBER_ITEMS_IN_BATCH; ?>) + ']<span id="warningModalBody_extra">' + $nbItemsToConvert + '</span> ' +
468 468
                 '... <?php echo langHdl('please_wait'); ?><i class="fas fa-spinner fa-pulse ml-3 text-primary"></i>');
469 469
 
470 470
             var data = {
471 471
                 action: step,
472 472
                 start: start,
473
-                length: <?php echo NUMBER_ITEMS_IN_BATCH;?>,
473
+                length: <?php echo NUMBER_ITEMS_IN_BATCH; ?>,
474 474
                 user_id: userId,
475 475
             }
476 476
             console.info("Envoi des données :")
@@ -1236,7 +1236,7 @@  discard block
 block discarded – undo
1236 1236
                         } else {
1237 1237
                             // Show icon or not
1238 1238
                             if ($('#user-disabled').prop('checked') === true) {
1239
-                                $('#user-login-'+userID).before('<i class="fas fa-user-slash infotip text-danger mr-2" title="<?php echo langHdl('account_is_locked');?>" id="user-disable-'+userID+'"></i>');
1239
+                                $('#user-login-'+userID).before('<i class="fas fa-user-slash infotip text-danger mr-2" title="<?php echo langHdl('account_is_locked'); ?>" id="user-disable-'+userID+'"></i>');
1240 1240
                             } else {
1241 1241
                                 $('#user-disable-'+userID).remove();
1242 1242
                             }
@@ -2081,12 +2081,12 @@  discard block
 block discarded – undo
2081 2081
                         if (step !== 'finished') {
2082 2082
                             // Inform user
2083 2083
                             $("#warningModal-progress").html('<b><?php echo langHdl('encryption_keys'); ?> - ' +
2084
-                                stepText + '</b> [' + start + ' - ' + (parseInt(start) + <?php echo NUMBER_ITEMS_IN_BATCH;?>) + ']');
2084
+                                stepText + '</b> [' + start + ' - ' + (parseInt(start) + <?php echo NUMBER_ITEMS_IN_BATCH; ?>) + ']');
2085 2085
 
2086 2086
                             var data = {
2087 2087
                                 'action': step,
2088 2088
                                 'start': start,
2089
-                                'length': <?php echo NUMBER_ITEMS_IN_BATCH;?>,
2089
+                                'length': <?php echo NUMBER_ITEMS_IN_BATCH; ?>,
2090 2090
                                 'user_id': userId,
2091 2091
                                 'self_change': false,
2092 2092
                             }
Please login to merge, or discard this patch.
sources/find.queries.php 1 patch
Spacing   +46 added lines, -46 removed lines patch added patch discarded remove patch
@@ -28,7 +28,7 @@  discard block
 block discarded – undo
28 28
 require_once 'SecureHandler.php';
29 29
 session_name('teampass_session');
30 30
 session_start();
31
-if (! isset($_SESSION['CPM']) || $_SESSION['CPM'] === false || ! isset($_SESSION['key']) || empty($_SESSION['key'])) {
31
+if (!isset($_SESSION['CPM']) || $_SESSION['CPM'] === false || !isset($_SESSION['key']) || empty($_SESSION['key'])) {
32 32
     die('Hacking attempt...');
33 33
 }
34 34
 
@@ -42,17 +42,17 @@  discard block
 block discarded – undo
42 42
 }
43 43
 
44 44
 // Do checks
45
-require_once $SETTINGS['cpassman_dir'] . '/includes/config/include.php';
46
-require_once $SETTINGS['cpassman_dir'] . '/sources/checks.php';
45
+require_once $SETTINGS['cpassman_dir'].'/includes/config/include.php';
46
+require_once $SETTINGS['cpassman_dir'].'/sources/checks.php';
47 47
 if (checkUser($_SESSION['user_id'], $_SESSION['key'], 'items', $SETTINGS) === false) {
48 48
     // Not allowed page
49 49
     $_SESSION['error']['code'] = ERR_NOT_ALLOWED;
50
-    include $SETTINGS['cpassman_dir'] . '/error.php';
50
+    include $SETTINGS['cpassman_dir'].'/error.php';
51 51
     exit;
52 52
 }
53 53
 
54
-require_once $SETTINGS['cpassman_dir'] . '/includes/language/' . $_SESSION['user_language'] . '.php';
55
-require_once $SETTINGS['cpassman_dir'] . '/includes/config/settings.php';
54
+require_once $SETTINGS['cpassman_dir'].'/includes/language/'.$_SESSION['user_language'].'.php';
55
+require_once $SETTINGS['cpassman_dir'].'/includes/config/settings.php';
56 56
 header('Content-type: text/html; charset=utf-8');
57 57
 header('Cache-Control: no-cache, must-revalidate');
58 58
 require_once 'main.functions.php';
@@ -60,12 +60,12 @@  discard block
 block discarded – undo
60 60
 if (isset($_SESSION['groupes_visibles']) === false
61 61
     || empty($_SESSION['groupes_visibles']) === true
62 62
 ) {
63
-    echo '{"sEcho": ' . intval($_GET['sEcho']) . ' ,"iTotalRecords": "0", "iTotalDisplayRecords": "0", "aaData": [] }';
63
+    echo '{"sEcho": '.intval($_GET['sEcho']).' ,"iTotalRecords": "0", "iTotalDisplayRecords": "0", "aaData": [] }';
64 64
     exit;
65 65
 }
66 66
 
67 67
 //Connect to DB
68
-require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Database/Meekrodb/db.class.php';
68
+require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Database/Meekrodb/db.class.php';
69 69
 if (defined('DB_PASSWD_CLEAR') === false) {
70 70
     define('DB_PASSWD_CLEAR', defuseReturnDecrypted(DB_PASSWD, $SETTINGS));
71 71
 }
@@ -89,7 +89,7 @@  discard block
 block discarded – undo
89 89
     $folders = $_SESSION['groupes_visibles'];
90 90
 } else {
91 91
     // Build tree
92
-    $tree = new SplClassLoader('Tree\NestedTree', $SETTINGS['cpassman_dir'] . '/includes/libraries');
92
+    $tree = new SplClassLoader('Tree\NestedTree', $SETTINGS['cpassman_dir'].'/includes/libraries');
93 93
     $tree->register();
94 94
     $tree = new Tree\NestedTree\NestedTree(prefixTable('nested_tree'), 'id', 'parent_id', 'title');
95 95
     $folders = $tree->getDescendants(filter_var($_GET['limited'], FILTER_SANITIZE_NUMBER_INT), true);
@@ -98,7 +98,7 @@  discard block
 block discarded – undo
98 98
 
99 99
 //Get current user "personal folder" ID
100 100
 $row = DB::query(
101
-    'SELECT id FROM ' . prefixTable('nested_tree') . ' WHERE title = %i',
101
+    'SELECT id FROM '.prefixTable('nested_tree').' WHERE title = %i',
102 102
     intval($_SESSION['user_id'])
103 103
 );
104 104
 //get list of personal folders
@@ -107,20 +107,20 @@  discard block
 block discarded – undo
107 107
 $listPf = '';
108 108
 if (empty($row['id']) === false) {
109 109
     $rows = DB::query(
110
-        'SELECT id FROM ' . prefixTable('nested_tree') . '
110
+        'SELECT id FROM '.prefixTable('nested_tree').'
111 111
         WHERE personal_folder = 1 AND NOT parent_id = %i AND NOT title = %i',
112 112
         filter_var($row['id'], FILTER_SANITIZE_NUMBER_INT),
113 113
         filter_var($_SESSION['user_id'], FILTER_SANITIZE_NUMBER_INT)
114 114
     );
115 115
     foreach ($rows as $record) {
116
-        if (! in_array($record['id'], $arrayPf)) {
116
+        if (!in_array($record['id'], $arrayPf)) {
117 117
             //build an array of personal folders ids
118 118
             array_push($arrayPf, $record['id']);
119 119
             //build also a string with those ids
120 120
             if (empty($listPf)) {
121 121
                 $listPf = $record['id'];
122 122
             } else {
123
-                $listPf .= ', ' . $record['id'];
123
+                $listPf .= ', '.$record['id'];
124 124
             }
125 125
         }
126 126
     }
@@ -130,7 +130,7 @@  discard block
 block discarded – undo
130 130
 //Paging
131 131
 $sLimit = '';
132 132
 if (isset($_GET['start']) === true && $_GET['length'] !== '-1') {
133
-    $sLimit = 'LIMIT ' . filter_var($_GET['start'], FILTER_SANITIZE_NUMBER_INT) . ', ' . filter_var($_GET['length'], FILTER_SANITIZE_NUMBER_INT) . '';
133
+    $sLimit = 'LIMIT '.filter_var($_GET['start'], FILTER_SANITIZE_NUMBER_INT).', '.filter_var($_GET['length'], FILTER_SANITIZE_NUMBER_INT).'';
134 134
 }
135 135
 
136 136
 //Ordering
@@ -143,8 +143,8 @@  discard block
 block discarded – undo
143 143
     }
144 144
     $sOrder = 'ORDER BY  ';
145 145
     if ($_GET['order'][0]['column'] >= 0) {
146
-        $sOrder .= '' . $aColumns[filter_var($_GET['order'][0]['column'], FILTER_SANITIZE_NUMBER_INT)] . ' '
147
-                . filter_var($_GET['order'][0]['dir'], FILTER_SANITIZE_STRING) . ', ';
146
+        $sOrder .= ''.$aColumns[filter_var($_GET['order'][0]['column'], FILTER_SANITIZE_NUMBER_INT)].' '
147
+                . filter_var($_GET['order'][0]['dir'], FILTER_SANITIZE_STRING).', ';
148 148
     }
149 149
 
150 150
     $sOrder = substr_replace($sOrder, '', -2);
@@ -152,7 +152,7 @@  discard block
 block discarded – undo
152 152
         $sOrder = '';
153 153
     }
154 154
 } else {
155
-    $sOrder = 'ORDER BY ' . $aColumns[1] . ' ASC';
155
+    $sOrder = 'ORDER BY '.$aColumns[1].' ASC';
156 156
 }
157 157
 
158 158
 // Define criteria
@@ -174,9 +174,9 @@  discard block
 block discarded – undo
174 174
 if (empty($search_criteria) === false) {
175 175
     $sWhere .= ' AND (';
176 176
     for ($i = 0; $i < count($aColumns); ++$i) {
177
-        $sWhere .= $aColumns[$i] . ' LIKE %ss_' . $i . ' OR ';
177
+        $sWhere .= $aColumns[$i].' LIKE %ss_'.$i.' OR ';
178 178
     }
179
-    $sWhere = substr_replace((string) $sWhere, '', -3) . ') ';
179
+    $sWhere = substr_replace((string) $sWhere, '', -3).') ';
180 180
     $crit = [
181 181
         'idtree' => array_unique($folders),
182 182
         '0' => $search_criteria,
@@ -214,13 +214,13 @@  discard block
 block discarded – undo
214 214
     if (empty($sWhere) === false) {
215 215
         $sWhere .= ' AND ';
216 216
     }
217
-    $sWhere = 'WHERE ' . $sWhere . 'id_tree NOT IN %ls_pf ';
217
+    $sWhere = 'WHERE '.$sWhere.'id_tree NOT IN %ls_pf ';
218 218
 } else {
219
-    $sWhere = 'WHERE ' . $sWhere;
219
+    $sWhere = 'WHERE '.$sWhere;
220 220
 }
221 221
 
222 222
 DB::query(
223
-    'SELECT id FROM ' . prefixTable('cache') . "
223
+    'SELECT id FROM '.prefixTable('cache')."
224 224
     ${sWhere}
225 225
     ${sOrder}",
226 226
     $crit
@@ -228,7 +228,7 @@  discard block
 block discarded – undo
228 228
 $iTotal = DB::count();
229 229
 $rows = DB::query(
230 230
     'SELECT id, label, description, tags, id_tree, perso, restricted_to, login, folder, author, renewal_period, url, timestamp
231
-    FROM ' . prefixTable('cache') . "
231
+    FROM ' . prefixTable('cache')."
232 232
     ${sWhere}
233 233
     ${sOrder}
234 234
     ${sLimit}",
@@ -241,7 +241,7 @@  discard block
 block discarded – undo
241 241
 if (isset($_GET['type']) === false) {
242 242
     $sOutput = '{';
243 243
     if (isset($_GET['draw']) === true) {
244
-        $sOutput .= '"draw": ' . intval($_GET['draw']) . ', ';
244
+        $sOutput .= '"draw": '.intval($_GET['draw']).', ';
245 245
     }
246 246
     $sOutput .= '"data": [';
247 247
     $sOutputConst = '';
@@ -258,7 +258,7 @@  discard block
 block discarded – undo
258 258
             foreach (explode(';', $_SESSION['fonction_id']) as $role) {
259 259
                 //db::debugmode(true);
260 260
                 $access = DB::queryFirstRow(
261
-                    'SELECT type FROM ' . prefixTable('roles_values') . ' WHERE role_id = %i AND folder_id = %i',
261
+                    'SELECT type FROM '.prefixTable('roles_values').' WHERE role_id = %i AND folder_id = %i',
262 262
                     $role,
263 263
                     $record['id_tree']
264 264
                 );
@@ -278,7 +278,7 @@  discard block
 block discarded – undo
278 278
             }
279 279
             $accessLevel = count($arrTmp) > 0 ? min($arrTmp) : $accessLevel;
280 280
             if ($accessLevel === 0) {
281
-                $checkbox = '<input type=\"checkbox\" value=\"0\" class=\"mass_op_cb\" data-id=\"' . $record['id'] . '\">';
281
+                $checkbox = '<input type=\"checkbox\" value=\"0\" class=\"mass_op_cb\" data-id=\"'.$record['id'].'\">';
282 282
             }
283 283
 
284 284
             if ((int) $accessLevel === 0) {
@@ -318,22 +318,22 @@  discard block
 block discarded – undo
318 318
             if (empty($restrictedTo)) {
319 319
                 $restrictedTo = $_SESSION['user_id'];
320 320
             } else {
321
-                $restrictedTo .= ',' . $_SESSION['user_id'];
321
+                $restrictedTo .= ','.$_SESSION['user_id'];
322 322
             }
323 323
         }
324 324
 
325 325
         //col1
326
-        $sOutputItem .= '"<i class=\"fa fa-external-link-alt infotip mr-2\" title=\"' . langHdl('open_url_link') . '\" onClick=\"window.location.href=&#039;index.php?page=items&amp;group=' . $record['id_tree'] . '&amp;id=' . $record['id'] . '&#039;\" style=\"cursor:pointer;\"></i>' .
327
-            '<i class=\"fa fa-eye infotip mr-2 item-detail\" title=\"' . langHdl('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 . '", ';
326
+        $sOutputItem .= '"<i class=\"fa fa-external-link-alt infotip mr-2\" title=\"'.langHdl('open_url_link').'\" onClick=\"window.location.href=&#039;index.php?page=items&amp;group='.$record['id_tree'].'&amp;id='.$record['id'].'&#039;\" style=\"cursor:pointer;\"></i>'.
327
+            '<i class=\"fa fa-eye infotip mr-2 item-detail\" title=\"'.langHdl('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.'", ';
328 328
         //col2
329
-        $sOutputItem .= '"<span id=\"item_label-' . $record['id'] . '\">' . stripslashes($record['label']) . '</span>", ';
329
+        $sOutputItem .= '"<span id=\"item_label-'.$record['id'].'\">'.stripslashes($record['label']).'</span>", ';
330 330
         //col3
331
-        $sOutputItem .= '"' . str_replace('&amp;', '&', htmlspecialchars(stripslashes($record['login']), ENT_QUOTES)) . '", ';
331
+        $sOutputItem .= '"'.str_replace('&amp;', '&', htmlspecialchars(stripslashes($record['login']), ENT_QUOTES)).'", ';
332 332
         //col4
333 333
         //get restriction from ROles
334 334
         $restrictedToRole = false;
335 335
         $rTmp = DB::queryFirstColumn(
336
-            'SELECT role_id FROM ' . prefixTable('restriction_to_roles') . ' WHERE item_id = %i',
336
+            'SELECT role_id FROM '.prefixTable('restriction_to_roles').' WHERE item_id = %i',
337 337
             $record['id']
338 338
         );
339 339
         // We considere here that if user has at least one group similar to the object ones
@@ -351,14 +351,14 @@  discard block
 block discarded – undo
351 351
         } else {
352 352
             $txt = str_replace(['\n', '<br />', '\\'], [' ', ' ', '', ' '], strip_tags($record['description']));
353 353
             if (strlen($txt) > 50) {
354
-                $sOutputItem .= '"' . substr(stripslashes(preg_replace('~/<[\/]{0,1}[^>]*>\//|[ \t]/~', '', $txt)), 0, 50) . '", ';
354
+                $sOutputItem .= '"'.substr(stripslashes(preg_replace('~/<[\/]{0,1}[^>]*>\//|[ \t]/~', '', $txt)), 0, 50).'", ';
355 355
             } else {
356
-                $sOutputItem .= '"' . stripslashes(preg_replace('~/<[^>]*>|[ \t]/~', '', $txt)) . '", ';
356
+                $sOutputItem .= '"'.stripslashes(preg_replace('~/<[^>]*>|[ \t]/~', '', $txt)).'", ';
357 357
             }
358 358
         }
359 359
 
360 360
         //col5 - TAGS
361
-        $sOutputItem .= '"' . htmlspecialchars(stripslashes($record['tags']), ENT_QUOTES) . '", ';
361
+        $sOutputItem .= '"'.htmlspecialchars(stripslashes($record['tags']), ENT_QUOTES).'", ';
362 362
         // col6 - URL
363 363
         if ($record['url'] !== '0') {
364 364
             $sOutputItem .= '"'.filter_var($record['url'], FILTER_SANITIZE_URL).'", ';
@@ -367,7 +367,7 @@  discard block
 block discarded – undo
367 367
         }
368 368
 
369 369
         //col7 - Prepare the Treegrid
370
-        $sOutputItem .= '"' . htmlspecialchars(stripslashes($record['folder']), ENT_QUOTES) . '"';
370
+        $sOutputItem .= '"'.htmlspecialchars(stripslashes($record['folder']), ENT_QUOTES).'"';
371 371
         //Finish the line
372 372
         $sOutputItem .= '], ';
373 373
         if ($getItemInList === true) {
@@ -376,16 +376,16 @@  discard block
 block discarded – undo
376 376
             --$iTotal;
377 377
         }
378 378
     }
379
-    if (! empty($sOutputConst)) {
379
+    if (!empty($sOutputConst)) {
380 380
         $sOutput .= substr_replace($sOutputConst, '', -2);
381 381
     }
382 382
     $sOutput .= '], ';
383
-    $sOutput .= '"recordsTotal": ' . $iTotal . ', ';
384
-    $sOutput .= '"recordsFiltered": ' . $iTotal . ' }';
383
+    $sOutput .= '"recordsTotal": '.$iTotal.', ';
384
+    $sOutput .= '"recordsFiltered": '.$iTotal.' }';
385 385
     echo $sOutput;
386 386
 } elseif (isset($_GET['type']) && ($_GET['type'] === 'search_for_items' || $_GET['type'] === 'search_for_items_with_tags')) {
387 387
     include_once 'main.functions.php';
388
-    include_once $SETTINGS['cpassman_dir'] . '/includes/language/' . $_SESSION['user_language'] . '.php';
388
+    include_once $SETTINGS['cpassman_dir'].'/includes/language/'.$_SESSION['user_language'].'.php';
389 389
     
390 390
     $arr_data = [];
391 391
     foreach ($rows as $record) {
@@ -405,7 +405,7 @@  discard block
 block discarded – undo
405 405
 
406 406
         // Anyone can modify?
407 407
         $tmp = DB::queryfirstrow(
408
-            'SELECT anyone_can_modify FROM ' . prefixTable('items') . ' WHERE id = %i',
408
+            'SELECT anyone_can_modify FROM '.prefixTable('items').' WHERE id = %i',
409 409
             $record['id']
410 410
         );
411 411
         if (count($tmp) > 0) {
@@ -436,7 +436,7 @@  discard block
 block discarded – undo
436 436
         // => récupérer un tableau contenant les roles associés à cet ID (a partir table restriction_to_roles)
437 437
         $user_is_included_in_role = 0;
438 438
         $roles = DB::query(
439
-            'SELECT role_id FROM ' . prefixTable('restriction_to_roles') . ' WHERE item_id=%i',
439
+            'SELECT role_id FROM '.prefixTable('restriction_to_roles').' WHERE item_id=%i',
440 440
             $record['id']
441 441
         );
442 442
         if (count($roles) > 0) {
@@ -459,7 +459,7 @@  discard block
 block discarded – undo
459 459
             if (empty($restrictedTo)) {
460 460
                 $restrictedTo = $_SESSION['user_id'];
461 461
             } else {
462
-                $restrictedTo .= ',' . $_SESSION['user_id'];
462
+                $restrictedTo .= ','.$_SESSION['user_id'];
463 463
             }
464 464
         }
465 465
 
@@ -557,7 +557,7 @@  discard block
 block discarded – undo
557 557
             $arrTmp = [];
558 558
             foreach (explode(';', $_SESSION['fonction_id']) as $role) {
559 559
                 $access = DB::queryFirstRow(
560
-                    'SELECT type FROM ' . prefixTable('roles_values') . ' WHERE role_id = %i AND folder_id = %i',
560
+                    'SELECT type FROM '.prefixTable('roles_values').' WHERE role_id = %i AND folder_id = %i',
561 561
                     $role,
562 562
                     $record['id_tree']
563 563
                 );
@@ -606,8 +606,8 @@  discard block
 block discarded – undo
606 606
         ) {
607 607
             $data_item = DB::queryFirstRow(
608 608
                 'SELECT i.pw AS pw, s.share_key AS share_key
609
-                FROM ' . prefixTable('items') . ' AS i
610
-                INNER JOIN ' . prefixTable('sharekeys_items') . ' AS s ON (s.object_id = i.id)
609
+                FROM ' . prefixTable('items').' AS i
610
+                INNER JOIN ' . prefixTable('sharekeys_items').' AS s ON (s.object_id = i.id)
611 611
                 WHERE i.id = %i AND s.user_id = %i',
612 612
                 $record['id'],
613 613
                 $_SESSION['user_id']
Please login to merge, or discard this patch.
sources/utilities.queries.php 1 patch
Spacing   +27 added lines, -27 removed lines patch added patch discarded remove patch
@@ -37,12 +37,12 @@  discard block
 block discarded – undo
37 37
 }
38 38
 
39 39
 // Do checks
40
-require_once $SETTINGS['cpassman_dir'] . '/includes/config/include.php';
41
-require_once $SETTINGS['cpassman_dir'] . '/sources/checks.php';
40
+require_once $SETTINGS['cpassman_dir'].'/includes/config/include.php';
41
+require_once $SETTINGS['cpassman_dir'].'/sources/checks.php';
42 42
 if (checkUser($_SESSION['user_id'], $_SESSION['key'], 'utilities.database', $SETTINGS) === false) {
43 43
     // Not allowed page
44 44
     $_SESSION['error']['code'] = ERR_NOT_ALLOWED;
45
-    include $SETTINGS['cpassman_dir'] . '/error.php';
45
+    include $SETTINGS['cpassman_dir'].'/error.php';
46 46
     exit();
47 47
 }
48 48
 
@@ -55,14 +55,14 @@  discard block
 block discarded – undo
55 55
     date_default_timezone_set('UTC');
56 56
 }
57 57
 
58
-require_once $SETTINGS['cpassman_dir'] . '/includes/language/' . $_SESSION['user_language'] . '.php';
59
-require_once $SETTINGS['cpassman_dir'] . '/includes/config/settings.php';
58
+require_once $SETTINGS['cpassman_dir'].'/includes/language/'.$_SESSION['user_language'].'.php';
59
+require_once $SETTINGS['cpassman_dir'].'/includes/config/settings.php';
60 60
 header('Content-type: text/html; charset=utf-8');
61 61
 header('Cache-Control: no-cache, must-revalidate');
62 62
 require_once 'main.functions.php';
63 63
 
64 64
 //Connect to DB
65
-require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Database/Meekrodb/db.class.php';
65
+require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Database/Meekrodb/db.class.php';
66 66
 if (defined('DB_PASSWD_CLEAR') === false) {
67 67
     define('DB_PASSWD_CLEAR', defuseReturnDecrypted(DB_PASSWD, $SETTINGS));
68 68
 }
@@ -102,7 +102,7 @@  discard block
 block discarded – undo
102 102
             $arrFolders = array();
103 103
             $rows = DB::query(
104 104
                 'SELECT valeur, intitule
105
-                FROM ' . prefixTable('misc') . '
105
+                FROM ' . prefixTable('misc').'
106 106
                 WHERE type  = %s',
107 107
                 'folder_deleted'
108 108
             );
@@ -123,10 +123,10 @@  discard block
 block discarded – undo
123 123
                 'SELECT u.login as login, u.name as name, u.lastname as lastname,
124 124
                 i.id as id, i.label as label,
125 125
                 i.id_tree as id_tree, l.date as date, n.title as folder_title
126
-                FROM ' . prefixTable('log_items') . ' as l
127
-                INNER JOIN ' . prefixTable('items') . ' as i ON (l.id_item=i.id)
128
-                INNER JOIN ' . prefixTable('users') . ' as u ON (l.id_user=u.id)
129
-                INNER JOIN ' . prefixTable('nested_tree') . ' as n ON (i.id_tree=n.id)
126
+                FROM ' . prefixTable('log_items').' as l
127
+                INNER JOIN ' . prefixTable('items').' as i ON (l.id_item=i.id)
128
+                INNER JOIN ' . prefixTable('users').' as u ON (l.id_user=u.id)
129
+                INNER JOIN ' . prefixTable('nested_tree').' as n ON (i.id_tree=n.id)
130 130
                 WHERE i.inactif = %i
131 131
                 AND l.action = %s',
132 132
                 1,
@@ -148,7 +148,7 @@  discard block
 block discarded – undo
148 148
                             'label' => $record['label'],
149 149
                             'date' => date($SETTINGS['date_format'], (int) $record['date']),
150 150
                             'login' => $record['login'],
151
-                            'name' => $record['name'] . ' ' . $record['lastname'],
151
+                            'name' => $record['name'].' '.$record['lastname'],
152 152
                             'folder_label' => $record['folder_title'],
153 153
                             'folder_deleted' => $thisFolder,
154 154
                         )
@@ -203,10 +203,10 @@  discard block
 block discarded – undo
203 203
             foreach ($post_folders as $folderId) {
204 204
                 $data = DB::queryfirstrow(
205 205
                     'SELECT valeur
206
-                    FROM ' . prefixTable('misc') . "
206
+                    FROM ' . prefixTable('misc')."
207 207
                     WHERE type = 'folder_deleted'
208 208
                     AND intitule = %s",
209
-                    'f' . $folderId
209
+                    'f'.$folderId
210 210
                 );
211 211
                 if ((int) $data['valeur'] !== 0) {
212 212
                     $folderData = explode(', ', $data['valeur']);
@@ -232,7 +232,7 @@  discard block
 block discarded – undo
232 232
                         prefixTable('misc'),
233 233
                         'type = %s AND intitule = %s',
234 234
                         'folder_deleted',
235
-                        'f' . $folderId
235
+                        'f'.$folderId
236 236
                     );
237 237
 
238 238
                     // Restore all items in this folder
@@ -248,7 +248,7 @@  discard block
 block discarded – undo
248 248
                     // Get list of all items in thos folder
249 249
                     $items = DB::query(
250 250
                         'SELECT id
251
-                        FROM ' . prefixTable('items') . '
251
+                        FROM ' . prefixTable('items').'
252 252
                         WHERE id_tree = %i',
253 253
                         $folderId
254 254
                     );
@@ -333,10 +333,10 @@  discard block
 block discarded – undo
333 333
             foreach ($post_folders as $folderId) {
334 334
                 $data = DB::queryfirstrow(
335 335
                     'SELECT valeur
336
-                    FROM ' . prefixTable('misc') . "
336
+                    FROM ' . prefixTable('misc')."
337 337
                     WHERE type = 'folder_deleted'
338 338
                     AND intitule = %s",
339
-                    'f' . $folderId
339
+                    'f'.$folderId
340 340
                 );
341 341
                 if ((int) $data['valeur'] !== 0) {
342 342
                     $folderData = explode(', ', $data['valeur']);
@@ -368,7 +368,7 @@  discard block
 block discarded – undo
368 368
                         prefixTable('misc'),
369 369
                         'type = %s AND intitule = %s',
370 370
                         'folder_deleted',
371
-                        'f' . $folderData[0]
371
+                        'f'.$folderData[0]
372 372
                     );
373 373
 
374 374
                     // Delete all items in this folder
@@ -382,7 +382,7 @@  discard block
 block discarded – undo
382 382
                     // Get list of all items in thos folder
383 383
                     $items = DB::query(
384 384
                         'SELECT id
385
-                        FROM ' . prefixTable('items') . '
385
+                        FROM ' . prefixTable('items').'
386 386
                         WHERE id_tree = %i',
387 387
                         $folderData[0]
388 388
                     );
@@ -478,7 +478,7 @@  discard block
 block discarded – undo
478 478
             ) {
479 479
                 if ($post_log_type === 'items') {
480 480
                     DB::query(
481
-                        'SELECT * FROM ' . prefixTable('log_items') . '
481
+                        'SELECT * FROM '.prefixTable('log_items').'
482 482
                         WHERE (date BETWEEN %i AND %i)'
483 483
                         . ($post_filter_action === 'all' ? '' : ' AND action = "'.$post_filter_action.'"')
484 484
                         . ((int) $post_filter_user === -1 ? '' : ' AND id_user = '.(int) $post_filter_user),
@@ -498,7 +498,7 @@  discard block
 block discarded – undo
498 498
                 } elseif ($post_log_type === 'connections') {
499 499
                     //db::debugmode(true);
500 500
                     DB::query(
501
-                        'SELECT * FROM ' . prefixTable('log_system') . '
501
+                        'SELECT * FROM '.prefixTable('log_system').'
502 502
                         WHERE type=%s '
503 503
                         . 'AND (date BETWEEN %i AND %i)'
504 504
                         . ($post_filter_action === 'all' ? '' : ' AND action = '.$post_filter_action)
@@ -521,12 +521,12 @@  discard block
 block discarded – undo
521 521
                     );
522 522
                 } elseif ($post_log_type === 'errors') {
523 523
                     //db::debugmode(true);
524
-                    echo 'SELECT * FROM ' . prefixTable('log_items') . '
524
+                    echo 'SELECT * FROM '.prefixTable('log_items').'
525 525
                     WHERE (date BETWEEN '.$post_date_from.' AND '.$post_date_to.')'
526 526
                     . ($post_filter_action === 'all' ? '' : ' AND action = '.$post_filter_action)
527 527
                     . ((int) $post_filter_user === -1 ? '' : ' AND id_user = '.(int) $post_filter_user);
528 528
                     DB::query(
529
-                        'SELECT * FROM ' . prefixTable('log_system') . ' WHERE type=%s ' .
529
+                        'SELECT * FROM '.prefixTable('log_system').' WHERE type=%s '.
530 530
                             'AND (date BETWEEN %i AND %i)',
531 531
                         'error',
532 532
                         $post_date_from,
@@ -543,7 +543,7 @@  discard block
 block discarded – undo
543 543
                     );
544 544
                 } elseif ($post_log_type === 'copy') {
545 545
                     DB::query(
546
-                        'SELECT * FROM ' . prefixTable('log_items') . ' WHERE action=%s ' .
546
+                        'SELECT * FROM '.prefixTable('log_items').' WHERE action=%s '.
547 547
                             'AND (date BETWEEN %i AND %i)',
548 548
                         'at_copy',
549 549
                         $post_date_from,
@@ -560,7 +560,7 @@  discard block
 block discarded – undo
560 560
                     );
561 561
                 } elseif ($post_log_type === 'admin') {
562 562
                     DB::query(
563
-                        'SELECT * FROM ' . prefixTable('log_system') . ' WHERE type=%s ' .
563
+                        'SELECT * FROM '.prefixTable('log_system').' WHERE type=%s '.
564 564
                             'AND (date BETWEEN %i AND %i)',
565 565
                         'admin_action',
566 566
                         $post_date_from,
@@ -577,7 +577,7 @@  discard block
 block discarded – undo
577 577
                     );
578 578
                 } elseif ($post_log_type === 'failed') {
579 579
                     DB::query(
580
-                        'SELECT * FROM ' . prefixTable('log_system') . ' WHERE type=%s ' .
580
+                        'SELECT * FROM '.prefixTable('log_system').' WHERE type=%s '.
581 581
                             'AND (date BETWEEN %i AND %i)',
582 582
                         'failed_auth',
583 583
                         $post_date_from,
Please login to merge, or discard this patch.
pages/options.php 1 patch
Spacing   +8 added lines, -8 removed lines patch added patch discarded remove patch
@@ -43,15 +43,15 @@  discard block
 block discarded – undo
43 43
 }
44 44
 
45 45
 /* do checks */
46
-require_once $SETTINGS['cpassman_dir'] . '/sources/checks.php';
46
+require_once $SETTINGS['cpassman_dir'].'/sources/checks.php';
47 47
 if (checkUser($_SESSION['user_id'], $_SESSION['key'], 'admin', $SETTINGS) === false) {
48 48
     $_SESSION['error']['code'] = ERR_NOT_ALLOWED;
49
-    include $SETTINGS['cpassman_dir'] . '/error.php';
49
+    include $SETTINGS['cpassman_dir'].'/error.php';
50 50
     exit;
51 51
 }
52 52
 
53 53
 // Load template
54
-require_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php';
54
+require_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php';
55 55
 // Generates zones
56 56
 $zones = timezone_list();
57 57
 ?>
@@ -260,7 +260,7 @@  discard block
 block discarded – undo
260 260
                                     // get list of all timezones
261 261
                                     foreach ($zones as $key => $zone) {
262 262
                                         echo '
263
-                                <option value="' . $key . '"', isset($SETTINGS['timezone']) === true && $SETTINGS['timezone'] === $key ? ' selected' : '', '>' . $zone . '</option>';
263
+                                <option value="' . $key.'"', isset($SETTINGS['timezone']) === true && $SETTINGS['timezone'] === $key ? ' selected' : '', '>'.$zone.'</option>';
264 264
                                     }
265 265
                                     ?>
266 266
                                 </select>
@@ -311,7 +311,7 @@  discard block
 block discarded – undo
311 311
                                     <?php
312 312
                                     foreach ($languagesList as $lang) {
313 313
                                         echo '
314
-                                <option value="' . $lang . '"', isset($SETTINGS['default_language']) === true && $SETTINGS['default_language'] === $lang ? ' selected' : '', '>' . $lang . '</option>';
314
+                                <option value="' . $lang.'"', isset($SETTINGS['default_language']) === true && $SETTINGS['default_language'] === $lang ? ' selected' : '', '>'.$lang.'</option>';
315 315
                                     }
316 316
                                     ?>
317 317
                                 </select>
@@ -408,7 +408,7 @@  discard block
 block discarded – undo
408 408
                                 <?php
409 409
                                 foreach (TP_PW_COMPLEXITY as $complex) {
410 410
                                     echo '
411
-                                <option value="' . $complex[0] . '"', isset($SETTINGS['personal_saltkey_security_level']) === true && $SETTINGS['personal_saltkey_security_level'] === $complex[0] ? ' selected' : '', '>' . $complex[1] . '</option>';
411
+                                <option value="' . $complex[0].'"', isset($SETTINGS['personal_saltkey_security_level']) === true && $SETTINGS['personal_saltkey_security_level'] === $complex[0] ? ' selected' : '', '>'.$complex[1].'</option>';
412 412
                                 }
413 413
                                 ?>
414 414
                             </select>
@@ -721,7 +721,7 @@  discard block
 block discarded – undo
721 721
                                     );
722 722
 foreach ($roles as $role) {
723 723
     echo '
724
-                                <option value="' . $role['id'] . '"', in_array($role['id'], $arrRolesToPrint) === true ? ' selected' : '', '>' . addslashes($role['title']) . '</option>';
724
+                                <option value="' . $role['id'].'"', in_array($role['id'], $arrRolesToPrint) === true ? ' selected' : '', '>'.addslashes($role['title']).'</option>';
725 725
 }
726 726
                                     }
727 727
                                     ?>
@@ -894,7 +894,7 @@  discard block
 block discarded – undo
894 894
                                     <?php
895 895
                                     foreach (TP_PW_COMPLEXITY as $complex) {
896 896
                                         echo '
897
-                                <option value="' . $complex[0] . '"', isset($SETTINGS['offline_key_level']) === true && $SETTINGS['offline_key_level'] === $complex[0] ? ' selected' : '', '>' . $complex[1] . '</option>';
897
+                                <option value="' . $complex[0].'"', isset($SETTINGS['offline_key_level']) === true && $SETTINGS['offline_key_level'] === $complex[0] ? ' selected' : '', '>'.$complex[1].'</option>';
898 898
                                     }
899 899
                                     ?>
900 900
                                 </select>
Please login to merge, or discard this patch.
sources/identify.php 1 patch
Spacing   +88 added lines, -88 removed lines patch added patch discarded remove patch
@@ -44,23 +44,23 @@  discard block
 block discarded – undo
44 44
     throw new Exception("Error file '/includes/config/tp.config.php' not exists", 1);
45 45
 }
46 46
 
47
-if (! isset($SETTINGS['cpassman_dir']) || empty($SETTINGS['cpassman_dir']) === true || $SETTINGS['cpassman_dir'] === '.') {
47
+if (!isset($SETTINGS['cpassman_dir']) || empty($SETTINGS['cpassman_dir']) === true || $SETTINGS['cpassman_dir'] === '.') {
48 48
     $SETTINGS = [];
49 49
     $SETTINGS['cpassman_dir'] = '..';
50 50
 }
51 51
 
52
-require_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php';
53
-require_once $SETTINGS['cpassman_dir'] . '/includes/config/include.php';
54
-require_once $SETTINGS['cpassman_dir'] . '/includes/config/settings.php';
52
+require_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php';
53
+require_once $SETTINGS['cpassman_dir'].'/includes/config/include.php';
54
+require_once $SETTINGS['cpassman_dir'].'/includes/config/settings.php';
55 55
 
56 56
 // If Debug then clean the files
57 57
 if (DEBUGLDAP === true) {
58
-    define('DEBUGLDAPFILE', $SETTINGS['path_to_files_folder'] . '/ldap.debug.txt');
58
+    define('DEBUGLDAPFILE', $SETTINGS['path_to_files_folder'].'/ldap.debug.txt');
59 59
     $fp = fopen(DEBUGLDAPFILE, 'w');
60 60
     fclose($fp);
61 61
 }
62 62
 if (DEBUGDUO === true) {
63
-    define('DEBUGDUOFILE', $SETTINGS['path_to_files_folder'] . '/duo.debug.txt');
63
+    define('DEBUGDUOFILE', $SETTINGS['path_to_files_folder'].'/duo.debug.txt');
64 64
     $fp = fopen(DEBUGDUOFILE, 'w');
65 65
     fclose($fp);
66 66
 }
@@ -76,7 +76,7 @@  discard block
 block discarded – undo
76 76
 if (defined('DB_PASSWD_CLEAR') === false) {
77 77
     define('DB_PASSWD_CLEAR', defuseReturnDecrypted(DB_PASSWD, $SETTINGS));
78 78
 }
79
-require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Database/Meekrodb/db.class.php';
79
+require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Database/Meekrodb/db.class.php';
80 80
 if (defined('DB_PASSWD_CLEAR') === false) {
81 81
     define('DB_PASSWD_CLEAR', defuseReturnDecrypted(DB_PASSWD, $SETTINGS));
82 82
 }
@@ -93,7 +93,7 @@  discard block
 block discarded – undo
93 93
     // This step creates the DUO request encrypted key
94 94
 
95 95
     // load library
96
-    include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Authentication/DuoSecurity/Duo.php';
96
+    include_once $SETTINGS['cpassman_dir'].'/includes/libraries/Authentication/DuoSecurity/Duo.php';
97 97
     $sig_request = Duo::signRequest(
98 98
         $SETTINGS['IKEY'],
99 99
         $SETTINGS['SKEY'],
@@ -104,16 +104,16 @@  discard block
 block discarded – undo
104 104
         debugIdentify(
105 105
             DEBUGDUO,
106 106
             DEBUGDUOFILE,
107
-            "\n\n-----\n\n" .
108
-                'sig request : ' . $post_login . "\n" .
109
-                'resp : ' . $sig_request . "\n"
107
+            "\n\n-----\n\n".
108
+                'sig request : '.$post_login."\n".
109
+                'resp : '.$sig_request."\n"
110 110
         );
111 111
     }
112 112
 
113 113
     // load csrfprotector
114
-    $csrfp_config = include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/csrfp/libs/csrfp.config.php';
114
+    $csrfp_config = include_once $SETTINGS['cpassman_dir'].'/includes/libraries/csrfp/libs/csrfp.config.php';
115 115
     // return result
116
-    echo '[{"sig_request" : "' . $sig_request . '" , "csrfp_token" : "' . $csrfp_config['CSRFP_TOKEN'] . '" , "csrfp_key" : "' . filter_var($_COOKIE[$csrfp_config['CSRFP_TOKEN']], FILTER_SANITIZE_STRING) . '"}]';
116
+    echo '[{"sig_request" : "'.$sig_request.'" , "csrfp_token" : "'.$csrfp_config['CSRFP_TOKEN'].'" , "csrfp_key" : "'.filter_var($_COOKIE[$csrfp_config['CSRFP_TOKEN']], FILTER_SANITIZE_STRING).'"}]';
117 117
 // ---
118 118
     // ---
119 119
 } elseif ($post_type === 'identify_duo_user_check') {
@@ -123,7 +123,7 @@  discard block
 block discarded – undo
123 123
     //--------
124 124
 
125 125
     // load library
126
-    include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Authentication/DuoSecurity/Duo.php';
126
+    include_once $SETTINGS['cpassman_dir'].'/includes/libraries/Authentication/DuoSecurity/Duo.php';
127 127
     $authenticated_username = Duo::verifyResponse(
128 128
         $SETTINGS['duo_ikey'],
129 129
         $SETTINGS['duo_skey'],
@@ -138,7 +138,7 @@  discard block
 block discarded – undo
138 138
             // is user in Teampass?
139 139
             DB::queryfirstrow(
140 140
                 'SELECT id
141
-                FROM ' . prefixTable('users') . '
141
+                FROM ' . prefixTable('users').'
142 142
                 WHERE login = %s',
143 143
                 $post_login
144 144
             );
@@ -148,9 +148,9 @@  discard block
 block discarded – undo
148 148
             }
149 149
         }
150 150
 
151
-        echo '[{"authenticated_username" : "' . $authenticated_username . '"}]';
151
+        echo '[{"authenticated_username" : "'.$authenticated_username.'"}]';
152 152
     } else {
153
-        echo '[{"authenticated_username" : "' . $authenticated_username . '"}]';
153
+        echo '[{"authenticated_username" : "'.$authenticated_username.'"}]';
154 154
     }
155 155
     // ---
156 156
     // ---
@@ -176,7 +176,7 @@  discard block
 block discarded – undo
176 176
     }
177 177
 
178 178
     // Load superGlobals
179
-    include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/protect/SuperGlobal/SuperGlobal.php';
179
+    include_once $SETTINGS['cpassman_dir'].'/includes/libraries/protect/SuperGlobal/SuperGlobal.php';
180 180
     $superGlobal = new protect\SuperGlobal\SuperGlobal();
181 181
     // Prepare GET variables
182 182
     $sessionPwdAttempts = $superGlobal->get('pwd_attempts', 'SESSION');
@@ -264,19 +264,19 @@  discard block
 block discarded – undo
264 264
     } else {
265 265
         throw new Exception("Error file '/includes/config/tp.config.php' not exists", 1);
266 266
     }
267
-    include_once $SETTINGS['cpassman_dir'] . '/includes/config/settings.php';
268
-    include_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php';
269
-    include_once $SETTINGS['cpassman_dir'] . '/sources/SplClassLoader.php';
267
+    include_once $SETTINGS['cpassman_dir'].'/includes/config/settings.php';
268
+    include_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php';
269
+    include_once $SETTINGS['cpassman_dir'].'/sources/SplClassLoader.php';
270 270
     
271 271
     header('Content-type: text/html; charset=utf-8');
272 272
     error_reporting(E_ERROR);
273 273
 
274 274
     // Load AntiXSS
275
-    include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/voku/helper/AntiXSS.php';
275
+    include_once $SETTINGS['cpassman_dir'].'/includes/libraries/voku/helper/AntiXSS.php';
276 276
     $antiXss = new voku\helper\AntiXSS();
277 277
 
278 278
     // Load superGlobals
279
-    include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/protect/SuperGlobal/SuperGlobal.php';
279
+    include_once $SETTINGS['cpassman_dir'].'/includes/libraries/protect/SuperGlobal/SuperGlobal.php';
280 280
     $superGlobal = new protect\SuperGlobal\SuperGlobal();
281 281
 
282 282
     // Prepare GET variables
@@ -290,7 +290,7 @@  discard block
 block discarded – undo
290 290
     $server['PHP_AUTH_PW'] = $superGlobal->get('PHP_AUTH_PW', 'SERVER');
291 291
 
292 292
     // connect to the server
293
-    include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Database/Meekrodb/db.class.php';
293
+    include_once $SETTINGS['cpassman_dir'].'/includes/libraries/Database/Meekrodb/db.class.php';
294 294
     DB::$host = DB_HOST;
295 295
     DB::$user = DB_USER;
296 296
     DB::$password = defined('DB_PASSWD_CLEAR') === false ? defuseReturnDecrypted(DB_PASSWD, $SETTINGS) : DB_PASSWD_CLEAR;
@@ -298,7 +298,7 @@  discard block
 block discarded – undo
298 298
     DB::$port = DB_PORT;
299 299
     DB::$encoding = DB_ENCODING;
300 300
     // User's language loading
301
-    include_once $SETTINGS['cpassman_dir'] . '/includes/language/' . $sessionUserLanguage . '.php';
301
+    include_once $SETTINGS['cpassman_dir'].'/includes/language/'.$sessionUserLanguage.'.php';
302 302
     
303 303
     // decrypt and retreive data in JSON format
304 304
     if (empty($sessionKey) === true) {
@@ -449,7 +449,7 @@  discard block
 block discarded – undo
449 449
         // Check if any unsuccessfull login tries exist
450 450
         $rows = DB::query(
451 451
             'SELECT date
452
-            FROM ' . prefixTable('log_system') . "
452
+            FROM ' . prefixTable('log_system')."
453 453
             WHERE field_1 = %s
454 454
             AND type = 'failed_auth'
455 455
             AND label = 'password_is_not_correct'
@@ -463,7 +463,7 @@  discard block
 block discarded – undo
463 463
             foreach ($rows as $record) {
464 464
                 array_push(
465 465
                     $arrAttempts,
466
-                    date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['date'])
466
+                    date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['date'])
467 467
                 );
468 468
             }
469 469
         }
@@ -578,7 +578,7 @@  discard block
 block discarded – undo
578 578
         foreach ($superGlobal->get('user_roles', 'SESSION') as $role) {
579 579
             $resRoles = DB::queryFirstRow(
580 580
                 'SELECT title, complexity
581
-                FROM ' . prefixTable('roles_title') . '
581
+                FROM ' . prefixTable('roles_title').'
582 582
                 WHERE id=%i',
583 583
                 $role
584 584
             );
@@ -599,7 +599,7 @@  discard block
 block discarded – undo
599 599
 
600 600
         // build complete array of roles
601 601
         $superGlobal->put('arr_roles_full', [], 'SESSION');
602
-        $rows = DB::query('SELECT id, title FROM ' . prefixTable('roles_title') . ' ORDER BY title ASC');
602
+        $rows = DB::query('SELECT id, title FROM '.prefixTable('roles_title').' ORDER BY title ASC');
603 603
         foreach ($rows as $record) {
604 604
             $superGlobal->put(
605 605
                 $record['id'],
@@ -677,10 +677,10 @@  discard block
 block discarded – undo
677 677
         $superGlobal->put('latest_items_tab', [], 'SESSION');
678 678
         $superGlobal->put('nb_roles', 0, 'SESSION');
679 679
         foreach ($superGlobal->get('latest_items', 'SESSION') as $item) {
680
-            if (! empty($item)) {
680
+            if (!empty($item)) {
681 681
                 $dataLastItems = DB::queryFirstRow(
682 682
                     'SELECT id,label,id_tree
683
-                    FROM ' . prefixTable('items') . '
683
+                    FROM ' . prefixTable('items').'
684 684
                     WHERE id=%i',
685 685
                     $item
686 686
                 );
@@ -689,7 +689,7 @@  discard block
 block discarded – undo
689 689
                     [
690 690
                         'id' => $item,
691 691
                         'label' => $dataLastItems['label'],
692
-                        'url' => 'index.php?page=items&amp;group=' . $dataLastItems['id_tree'] . '&amp;id=' . $item,
692
+                        'url' => 'index.php?page=items&amp;group='.$dataLastItems['id_tree'].'&amp;id='.$item,
693 693
                     ],
694 694
                     'SESSION',
695 695
                     'latest_items_tab'
@@ -706,12 +706,12 @@  discard block
 block discarded – undo
706 706
         ) {
707 707
             // get all Admin users
708 708
             $receivers = '';
709
-            $rows = DB::query('SELECT email FROM ' . prefixTable('users') . " WHERE admin = %i and email != ''", 1);
709
+            $rows = DB::query('SELECT email FROM '.prefixTable('users')." WHERE admin = %i and email != ''", 1);
710 710
             foreach ($rows as $record) {
711 711
                 if (empty($receivers)) {
712 712
                     $receivers = $record['email'];
713 713
                 } else {
714
-                    $receivers = ',' . $record['email'];
714
+                    $receivers = ','.$record['email'];
715 715
                 }
716 716
             }
717 717
             // Add email to table
@@ -727,7 +727,7 @@  discard block
 block discarded – undo
727 727
                             '#tp_time#',
728 728
                         ],
729 729
                         [
730
-                            ' ' . $superGlobal->get('login', 'SESSION') . ' (IP: ' . getClientIpServer() . ')',
730
+                            ' '.$superGlobal->get('login', 'SESSION').' (IP: '.getClientIpServer().')',
731 731
                             date($SETTINGS['date_format'], (int) $superGlobal->get('last_connection', 'SESSION')),
732 732
                             date($SETTINGS['time_format'], (int) $superGlobal->get('last_connection', 'SESSION')),
733 733
                         ],
@@ -1048,45 +1048,45 @@  discard block
 block discarded – undo
1048 1048
     }
1049 1049
 
1050 1050
     // Load expected libraries
1051
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Illuminate/Contracts/Auth/Authenticatable.php';
1052
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Tightenco/Collect/Support/Traits/EnumeratesValues.php';
1053
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Tightenco/Collect/Support/Traits/Macroable.php';
1054
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Tightenco/Collect/Support/helpers.php';
1055
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Tightenco/Collect/Support/Arr.php';
1056
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Tightenco/Collect/Contracts/Support/Jsonable.php';
1057
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Tightenco/Collect/Contracts/Support/Arrayable.php';
1058
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Tightenco/Collect/Support/Enumerable.php';
1059
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Tightenco/Collect/Support/Collection.php';
1060
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Carbon/CarbonTimeZone.php';
1061
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Carbon/Traits/Units.php';
1062
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Carbon/Traits/Week.php';
1063
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Carbon/Traits/Timestamp.php';
1064
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Carbon/Traits/Test.php';
1065
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Carbon/Traits/ObjectInitialisation.php';
1066
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Carbon/Traits/Serialization.php';
1067
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Carbon/Traits/IntervalRounding.php';
1068
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Carbon/Traits/Rounding.php';
1069
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Carbon/Traits/Localization.php';
1070
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Carbon/Traits/Options.php';
1071
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Carbon/Traits/Cast.php';
1072
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Carbon/Traits/Mutability.php';
1073
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Carbon/Traits/Modifiers.php';
1074
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Carbon/Traits/Mixin.php';
1075
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Carbon/Traits/Macro.php';
1076
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Carbon/Traits/Difference.php';
1077
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Carbon/Traits/Creator.php';
1078
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Carbon/Traits/Converter.php';
1079
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Carbon/Traits/Comparison.php';
1080
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Carbon/Traits/Boundaries.php';
1081
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Carbon/Traits/Date.php';
1082
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Carbon/CarbonInterface.php';
1083
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Carbon/Carbon.php';
1084
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/LdapRecord/DetectsErrors.php';
1085
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/LdapRecord/Connection.php';
1086
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/LdapRecord/LdapInterface.php';
1087
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/LdapRecord/LdapBase.php';
1088
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/LdapRecord/HandlesConnection.php';
1089
-    require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/LdapRecord/Ldap.php';
1051
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Illuminate/Contracts/Auth/Authenticatable.php';
1052
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Tightenco/Collect/Support/Traits/EnumeratesValues.php';
1053
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Tightenco/Collect/Support/Traits/Macroable.php';
1054
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Tightenco/Collect/Support/helpers.php';
1055
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Tightenco/Collect/Support/Arr.php';
1056
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Tightenco/Collect/Contracts/Support/Jsonable.php';
1057
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Tightenco/Collect/Contracts/Support/Arrayable.php';
1058
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Tightenco/Collect/Support/Enumerable.php';
1059
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Tightenco/Collect/Support/Collection.php';
1060
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Carbon/CarbonTimeZone.php';
1061
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Carbon/Traits/Units.php';
1062
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Carbon/Traits/Week.php';
1063
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Carbon/Traits/Timestamp.php';
1064
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Carbon/Traits/Test.php';
1065
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Carbon/Traits/ObjectInitialisation.php';
1066
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Carbon/Traits/Serialization.php';
1067
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Carbon/Traits/IntervalRounding.php';
1068
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Carbon/Traits/Rounding.php';
1069
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Carbon/Traits/Localization.php';
1070
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Carbon/Traits/Options.php';
1071
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Carbon/Traits/Cast.php';
1072
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Carbon/Traits/Mutability.php';
1073
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Carbon/Traits/Modifiers.php';
1074
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Carbon/Traits/Mixin.php';
1075
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Carbon/Traits/Macro.php';
1076
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Carbon/Traits/Difference.php';
1077
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Carbon/Traits/Creator.php';
1078
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Carbon/Traits/Converter.php';
1079
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Carbon/Traits/Comparison.php';
1080
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Carbon/Traits/Boundaries.php';
1081
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Carbon/Traits/Date.php';
1082
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Carbon/CarbonInterface.php';
1083
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Carbon/Carbon.php';
1084
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/LdapRecord/DetectsErrors.php';
1085
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/LdapRecord/Connection.php';
1086
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/LdapRecord/LdapInterface.php';
1087
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/LdapRecord/LdapBase.php';
1088
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/LdapRecord/HandlesConnection.php';
1089
+    require_once $SETTINGS['cpassman_dir'].'/includes/libraries/LdapRecord/Ldap.php';
1090 1090
     $ad = new SplClassLoader('LdapRecord', '../includes/libraries');
1091 1091
     $ad->register();
1092 1092
     $connection = new Connection($config);
@@ -1098,7 +1098,7 @@  discard block
 block discarded – undo
1098 1098
         $error = $e->getDetailedError();
1099 1099
         return [
1100 1100
             'error' => true,
1101
-            'message' => langHdl('error').' : '.$error->getErrorCode().' - '.$error->getErrorMessage(). '<br>'.$error->getDiagnosticMessage().' '.$config['username'],
1101
+            'message' => langHdl('error').' : '.$error->getErrorCode().' - '.$error->getErrorMessage().'<br>'.$error->getDiagnosticMessage().' '.$config['username'],
1102 1102
 
1103 1103
         ];
1104 1104
     }
@@ -1126,7 +1126,7 @@  discard block
 block discarded – undo
1126 1126
     }
1127 1127
 
1128 1128
     // load passwordLib library
1129
-    $pwdlib = new SplClassLoader('PasswordLib', $SETTINGS['cpassman_dir'] . '/includes/libraries');
1129
+    $pwdlib = new SplClassLoader('PasswordLib', $SETTINGS['cpassman_dir'].'/includes/libraries');
1130 1130
     $pwdlib->register();
1131 1131
     $pwdlib = new PasswordLib\PasswordLib();
1132 1132
     $hashedPassword = $pwdlib->createPasswordHash($passwordClear);
@@ -1185,7 +1185,7 @@  discard block
 block discarded – undo
1185 1185
 function yubicoMFACheck($dataReceived, string $userInfo, array $SETTINGS): array
1186 1186
 {
1187 1187
     // Load superGlobals
1188
-    include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/protect/SuperGlobal/SuperGlobal.php';
1188
+    include_once $SETTINGS['cpassman_dir'].'/includes/libraries/protect/SuperGlobal/SuperGlobal.php';
1189 1189
     $superGlobal = new protect\SuperGlobal\SuperGlobal();
1190 1190
     $sessionAdmin = $superGlobal->get('user_admin', 'SESSION');
1191 1191
     $sessionUrl = $superGlobal->get('initial_url', 'SESSION');
@@ -1224,7 +1224,7 @@  discard block
 block discarded – undo
1224 1224
     }
1225 1225
 
1226 1226
     // Now check yubico validity
1227
-    include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Authentication/Yubico/Yubico.php';
1227
+    include_once $SETTINGS['cpassman_dir'].'/includes/libraries/Authentication/Yubico/Yubico.php';
1228 1228
     $yubi = new Auth_Yubico($yubico_user_id, $yubico_user_key);
1229 1229
     $auth = $yubi->verify($yubico_key);
1230 1230
     //, null, null, null, 60
@@ -1276,7 +1276,7 @@  discard block
 block discarded – undo
1276 1276
             'gestionnaire' => '0',
1277 1277
             'can_manage_all_users' => '0',
1278 1278
             'personal_folder' => $SETTINGS['enable_pf_feature'] === '1' ? '1' : '0',
1279
-            'fonction_id' => (empty($retLDAP['user_info_from_ad'][0]['commonGroupsLdapVsTeampass']) === false ? $retLDAP['user_info_from_ad'][0]['commonGroupsLdapVsTeampass'] . ';' : '') . (isset($SETTINGS['ldap_new_user_role']) === true ? $SETTINGS['ldap_new_user_role'] : '0'),
1279
+            'fonction_id' => (empty($retLDAP['user_info_from_ad'][0]['commonGroupsLdapVsTeampass']) === false ? $retLDAP['user_info_from_ad'][0]['commonGroupsLdapVsTeampass'].';' : '').(isset($SETTINGS['ldap_new_user_role']) === true ? $SETTINGS['ldap_new_user_role'] : '0'),
1280 1280
             'groupes_interdits' => '',
1281 1281
             'groupes_visibles' => '',
1282 1282
             'last_pw_change' => (int) time(),
@@ -1301,7 +1301,7 @@  discard block
 block discarded – undo
1301 1301
             ]
1302 1302
         );
1303 1303
         // Rebuild tree
1304
-        $tree = new SplClassLoader('Tree\NestedTree', $SETTINGS['cpassman_dir'] . '/includes/libraries');
1304
+        $tree = new SplClassLoader('Tree\NestedTree', $SETTINGS['cpassman_dir'].'/includes/libraries');
1305 1305
         $tree->register();
1306 1306
         $tree = new Tree\NestedTree\NestedTree(prefixTable('nested_tree'), 'id', 'parent_id', 'title');
1307 1307
         $tree->rebuild();
@@ -1332,13 +1332,13 @@  discard block
 block discarded – undo
1332 1332
         && empty($dataReceived['GACode']) === false
1333 1333
     ) {
1334 1334
         // Load superGlobals
1335
-        include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/protect/SuperGlobal/SuperGlobal.php';
1335
+        include_once $SETTINGS['cpassman_dir'].'/includes/libraries/protect/SuperGlobal/SuperGlobal.php';
1336 1336
         $superGlobal = new protect\SuperGlobal\SuperGlobal();
1337 1337
         $sessionAdmin = $superGlobal->get('user_admin', 'SESSION');
1338 1338
         $sessionUrl = $superGlobal->get('initial_url', 'SESSION');
1339 1339
         $sessionPwdAttempts = $superGlobal->get('pwd_attempts', 'SESSION');
1340 1340
         // load library
1341
-        include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Authentication/TwoFactorAuth/TwoFactorAuth.php';
1341
+        include_once $SETTINGS['cpassman_dir'].'/includes/libraries/Authentication/TwoFactorAuth/TwoFactorAuth.php';
1342 1342
         // create new instance
1343 1343
         $tfa = new Authentication\TwoFactorAuth\TwoFactorAuth($SETTINGS['ga_website_name']);
1344 1344
         // Init
@@ -1360,7 +1360,7 @@  discard block
 block discarded – undo
1360 1360
             $mfaMessage = langHdl('ga_flash_qr_and_login');
1361 1361
             // generate new QR
1362 1362
             $new_2fa_qr = $tfa->getQRCodeImageAsDataUri(
1363
-                'Teampass - ' . $username,
1363
+                'Teampass - '.$username,
1364 1364
                 $userInfo['ga']
1365 1365
             );
1366 1366
             // clear temporary code from DB
@@ -1373,7 +1373,7 @@  discard block
 block discarded – undo
1373 1373
                 $userInfo['id']
1374 1374
             );
1375 1375
             $firstTime = [
1376
-                'value' => '<img src="' . $new_2fa_qr . '">',
1376
+                'value' => '<img src="'.$new_2fa_qr.'">',
1377 1377
                 'user_admin' => isset($sessionAdmin) ? (int) $sessionAdmin : '',
1378 1378
                 'initial_url' => isset($sessionUrl) === true ? $sessionUrl : '',
1379 1379
                 'pwd_attempts' => (int) $sessionPwdAttempts,
@@ -1424,8 +1424,8 @@  discard block
 block discarded – undo
1424 1424
     // Set to false
1425 1425
     $userPasswordVerified = false;
1426 1426
     // load passwordLib library
1427
-    include_once $SETTINGS['cpassman_dir'] . '/sources/SplClassLoader.php';
1428
-    $pwdlib = new SplClassLoader('PasswordLib', $SETTINGS['cpassman_dir'] . '/includes/libraries');
1427
+    include_once $SETTINGS['cpassman_dir'].'/sources/SplClassLoader.php';
1428
+    $pwdlib = new SplClassLoader('PasswordLib', $SETTINGS['cpassman_dir'].'/includes/libraries');
1429 1429
     $pwdlib->register();
1430 1430
     $pwdlib = new PasswordLib\PasswordLib();
1431 1431
     // Check if old encryption used
@@ -1556,7 +1556,7 @@  discard block
 block discarded – undo
1556 1556
     // Brute force management
1557 1557
     if ($sessionPwdAttempts > 3) {
1558 1558
         // Load superGlobals
1559
-        include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/protect/SuperGlobal/SuperGlobal.php';
1559
+        include_once $SETTINGS['cpassman_dir'].'/includes/libraries/protect/SuperGlobal/SuperGlobal.php';
1560 1560
         $superGlobal = new protect\SuperGlobal\SuperGlobal();
1561 1561
         $superGlobal->put('next_possible_pwd_attempts', time() + 10, 'SESSION');
1562 1562
         $superGlobal->put('pwd_attempts', 0, 'SESSION');
@@ -1598,7 +1598,7 @@  discard block
 block discarded – undo
1598 1598
     // Check if user exists
1599 1599
     $userInfo = DB::queryFirstRow(
1600 1600
         'SELECT *
1601
-        FROM ' . prefixTable('users') . ' WHERE login=%s',
1601
+        FROM ' . prefixTable('users').' WHERE login=%s',
1602 1602
         $username
1603 1603
     );
1604 1604
     
Please login to merge, or discard this patch.
sources/tree.php 1 patch
Spacing   +46 added lines, -51 removed lines patch added patch discarded remove patch
@@ -42,11 +42,11 @@  discard block
 block discarded – undo
42 42
 }
43 43
 
44 44
 // includes
45
-require_once $SETTINGS['cpassman_dir'] . '/includes/config/include.php';
46
-require_once $SETTINGS['cpassman_dir'] . '/sources/SplClassLoader.php';
47
-require_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php';
48
-require_once $SETTINGS['cpassman_dir'] . '/includes/language/' . $_SESSION['user_language'] . '.php';
49
-require_once $SETTINGS['cpassman_dir'] . '/includes/config/settings.php';
45
+require_once $SETTINGS['cpassman_dir'].'/includes/config/include.php';
46
+require_once $SETTINGS['cpassman_dir'].'/sources/SplClassLoader.php';
47
+require_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php';
48
+require_once $SETTINGS['cpassman_dir'].'/includes/language/'.$_SESSION['user_language'].'.php';
49
+require_once $SETTINGS['cpassman_dir'].'/includes/config/settings.php';
50 50
 
51 51
 // header
52 52
 header('Content-type: text/html; charset=utf-8');
@@ -60,7 +60,7 @@  discard block
 block discarded – undo
60 60
 }
61 61
 
62 62
 // Connect to mysql server
63
-require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Database/Meekrodb/db.class.php';
63
+require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Database/Meekrodb/db.class.php';
64 64
 if (defined('DB_PASSWD_CLEAR') === false) {
65 65
     define('DB_PASSWD_CLEAR', defuseReturnDecrypted(DB_PASSWD, $SETTINGS));
66 66
 }
@@ -72,7 +72,7 @@  discard block
 block discarded – undo
72 72
 DB::$encoding = DB_ENCODING;
73 73
 
74 74
 // Superglobal load
75
-require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/protect/SuperGlobal/SuperGlobal.php';
75
+require_once $SETTINGS['cpassman_dir'].'/includes/libraries/protect/SuperGlobal/SuperGlobal.php';
76 76
 $superGlobal = new protect\SuperGlobal\SuperGlobal();
77 77
 $get = [];
78 78
 $get['user_tree_structure'] = $superGlobal->get('user_tree_structure', 'GET');
@@ -92,7 +92,7 @@  discard block
 block discarded – undo
92 92
 $session['personal_visible_groups'] = $superGlobal->get('personal_visible_groups', 'SESSION');
93 93
 
94 94
 $lastFolderChange = DB::query(
95
-    'SELECT * FROM ' . prefixTable('misc') . '
95
+    'SELECT * FROM '.prefixTable('misc').'
96 96
     WHERE type = %s AND intitule = %s',
97 97
     'timestamp',
98 98
     'last_folder_change'
@@ -103,7 +103,7 @@  discard block
 block discarded – undo
103 103
     || (isset($get['force_refresh']) === true && (int) $get['force_refresh'] === 1)
104 104
 ) {
105 105
     // Build tree
106
-    $tree = new SplClassLoader('Tree\NestedTree', $SETTINGS['cpassman_dir'] . '/includes/libraries');
106
+    $tree = new SplClassLoader('Tree\NestedTree', $SETTINGS['cpassman_dir'].'/includes/libraries');
107 107
     $tree->register();
108 108
     $tree = new Tree\NestedTree\NestedTree(prefixTable('nested_tree'), 'id', 'parent_id', 'title');
109 109
 
@@ -213,7 +213,7 @@  discard block
 block discarded – undo
213 213
     $SETTINGS
214 214
 ) {
215 215
     // Load library
216
-    include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/protect/SuperGlobal/SuperGlobal.php';
216
+    include_once $SETTINGS['cpassman_dir'].'/includes/libraries/protect/SuperGlobal/SuperGlobal.php';
217 217
     $superGlobal = new protect\SuperGlobal\SuperGlobal();
218 218
 
219 219
     // Prepare superGlobal variables
@@ -263,7 +263,7 @@  discard block
 block discarded – undo
263 263
                 // get count of Items in this folder
264 264
                 DB::query(
265 265
                     'SELECT *
266
-                    FROM ' . prefixTable('items') . '
266
+                    FROM ' . prefixTable('items').'
267 267
                     WHERE inactif=%i AND id_tree = %i',
268 268
                     0,
269 269
                     $node->id
@@ -273,7 +273,7 @@  discard block
 block discarded – undo
273 273
                 // get info about current folder
274 274
                 DB::query(
275 275
                     'SELECT *
276
-                    FROM ' . prefixTable('nested_tree') . '
276
+                    FROM ' . prefixTable('nested_tree').'
277 277
                     WHERE parent_id = %i',
278 278
                     $node->id
279 279
                 );
@@ -281,11 +281,10 @@  discard block
 block discarded – undo
281 281
 
282 282
                 // If personal Folder, convert id into user name
283 283
                 $node->title = $node->title === $session_user_id && (int) $node->nlevel === 1 ?
284
-                    $session_login :
285
-                    ($node->title === null ? '' : htmlspecialchars_decode($node->title, ENT_QUOTES));
284
+                    $session_login : ($node->title === null ? '' : htmlspecialchars_decode($node->title, ENT_QUOTES));
286 285
 
287 286
                 // prepare json return for current node
288
-                $parent = $node->parent_id === 0 ? '#' : 'li_' . $node->parent_id;
287
+                $parent = $node->parent_id === 0 ? '#' : 'li_'.$node->parent_id;
289 288
 
290 289
                 // special case for READ-ONLY folder
291 290
                 $title = $session_user_read_only === true && in_array($node->id, $session_personal_folders) === false ? langHdl('read_only_account') : $title;
@@ -295,33 +294,30 @@  discard block
 block discarded – undo
295 294
 
296 295
                 if (in_array($node->id, $session_groupes_visibles)) {
297 296
                     if (in_array($node->id, $session_read_only_folders)) {
298
-                        $text = "<i class='far fa-eye fa-xs mr-1'></i>" . $text;
297
+                        $text = "<i class='far fa-eye fa-xs mr-1'></i>".$text;
299 298
                         $title = langHdl('read_only_account');
300 299
                         $restricted = 1;
301 300
                         $folderClass = 'folder_not_droppable';
302 301
                     } elseif ($session_user_read_only === true && !in_array($node->id, $session_personal_visible_groups)) {
303
-                        $text = "<i class='far fa-eye fa-xs mr-1'></i>" . $text;
302
+                        $text = "<i class='far fa-eye fa-xs mr-1'></i>".$text;
304 303
                     }
305 304
                     $text .=
306
-                        ' <span class=\'badge badge-danger ml-2 items_count\' id=\'itcount_' . $node->id . '\'>' . $itemsNb . '</span>'
305
+                        ' <span class=\'badge badge-danger ml-2 items_count\' id=\'itcount_'.$node->id.'\'>'.$itemsNb.'</span>'
307 306
                         .(isset($SETTINGS['tree_counters']) && (int) $SETTINGS['tree_counters'] === 1 ?
308
-                            '/'.$nbChildrenItems .'/'.(count($nodeDescendants) - 1)  :
309
-                            '')
307
+                            '/'.$nbChildrenItems.'/'.(count($nodeDescendants) - 1) : '')
310 308
                         .'</span>';
311 309
                 } elseif (in_array($node->id, $listFoldersLimitedKeys)) {
312 310
                     $restricted = 1;
313 311
                     $text .= 
314 312
                         $session_user_read_only === true ?
315
-                            "<i class='far fa-eye fa-xs mr-1'></i>" :
316
-                            '<span class="badge badge-danger ml-2 items_count" id="itcount_' . $node->id . '">' . count($session_list_folders_limited[$node->id]) . '</span>';
313
+                            "<i class='far fa-eye fa-xs mr-1'></i>" : '<span class="badge badge-danger ml-2 items_count" id="itcount_'.$node->id.'">'.count($session_list_folders_limited[$node->id]).'</span>';
317 314
                 } elseif (in_array($node->id, $listRestrictedFoldersForItemsKeys)) {
318 315
                     $restricted = 1;
319 316
                     if ($session_user_read_only === true) {
320
-                        $text = "<i class='far fa-eye fa-xs mr-1'></i>" . $text;
317
+                        $text = "<i class='far fa-eye fa-xs mr-1'></i>".$text;
321 318
                     }
322 319
                     $text .= $session_user_read_only === true ? 
323
-                        "<i class='far fa-eye fa-xs mr-1'></i>" :
324
-                        '<span class="badge badge-danger ml-2 items_count" id="itcount_' . $node->id . '">' . count($session_list_restricted_folders_for_items[$node->id]) . '</span>';
320
+                        "<i class='far fa-eye fa-xs mr-1'></i>" : '<span class="badge badge-danger ml-2 items_count" id="itcount_'.$node->id.'">'.count($session_list_restricted_folders_for_items[$node->id]).'</span>';
325 321
                 } else {
326 322
                     $restricted = 1;
327 323
                     $folderClass = 'folder_not_droppable';
@@ -343,22 +339,21 @@  discard block
 block discarded – undo
343 339
                 }
344 340
 
345 341
                 // json
346
-                $hide_node === true ? '' :
347
-                    array_push(
342
+                $hide_node === true ? '' : array_push(
348 343
                         $ret_json,
349 344
                         array(
350
-                            'id' => 'li_' . $node->id,
345
+                            'id' => 'li_'.$node->id,
351 346
                             'parent' => $parent,
352
-                            'text' => ($show_but_block === true ? '<i class="fas fa-times fa-xs text-danger mr-1"></i>' : '') . $text,
347
+                            'text' => ($show_but_block === true ? '<i class="fas fa-times fa-xs text-danger mr-1"></i>' : '').$text,
353 348
                             'children' => ($childrenNb === 0 ? false : true),
354 349
                             'li_attr' => array(
355 350
                                 'class' => ($show_but_block === true ? '' : 'jstreeopen'),
356
-                                'title' => 'ID [' . $node->id . '] ' . ($show_but_block === true ? angHdl('no_access') : $title),
351
+                                'title' => 'ID ['.$node->id.'] '.($show_but_block === true ? angHdl('no_access') : $title),
357 352
                             ),
358 353
                             'a_attr' => $show_but_block === true ? (array(
359
-                                'id' => 'fld_' . $node->id,
354
+                                'id' => 'fld_'.$node->id,
360 355
                                 'class' => $folderClass,
361
-                                'onclick' => 'ListerItems(' . $node->id . ', ' . $restricted . ', 0, 1)',
356
+                                'onclick' => 'ListerItems('.$node->id.', '.$restricted.', 0, 1)',
362 357
                                 'data-title' => $node->title,
363 358
                             )) : '',
364 359
                         )
@@ -451,7 +446,7 @@  discard block
 block discarded – undo
451 446
                 ) === true
452 447
             ) {
453 448
                 DB::query(
454
-                    'SELECT * FROM ' . prefixTable('items') . '
449
+                    'SELECT * FROM '.prefixTable('items').'
455 450
                     WHERE inactif=%i AND id_tree = %i',
456 451
                     0,
457 452
                     $node
@@ -538,7 +533,7 @@  discard block
 block discarded – undo
538 533
 {
539 534
     // get info about current folder
540 535
     DB::query(
541
-        'SELECT * FROM ' . prefixTable('items') . '
536
+        'SELECT * FROM '.prefixTable('items').'
542 537
         WHERE inactif=%i AND id_tree = %i',
543 538
         0,
544 539
         $completTree[$nodeId]->id
@@ -639,7 +634,7 @@  discard block
 block discarded – undo
639 634
     */
640 635
 
641 636
     // prepare json return for current node
642
-    $parent = $completTree[$nodeId]->parent_id === '0' ? '#' : 'li_' . $completTree[$nodeId]->parent_id;
637
+    $parent = $completTree[$nodeId]->parent_id === '0' ? '#' : 'li_'.$completTree[$nodeId]->parent_id;
643 638
 
644 639
     // handle displaying
645 640
     if (
@@ -659,17 +654,17 @@  discard block
 block discarded – undo
659 654
         array_push(
660 655
             $ret_json,
661 656
             array(
662
-                'id' => 'li_' . $completTree[$nodeId]->id,
657
+                'id' => 'li_'.$completTree[$nodeId]->id,
663 658
                 'parent' => $last_visible_parent === -1 ? $parent : $last_visible_parent,
664 659
                 'text' => $text.$completTree[$nodeId]->title.$nodeData['html'],
665 660
                 'li_attr' => array(
666 661
                     'class' => 'jstreeopen',
667
-                    'title' => 'ID [' . $completTree[$nodeId]->id . '] ' . $nodeData['title'],
662
+                    'title' => 'ID ['.$completTree[$nodeId]->id.'] '.$nodeData['title'],
668 663
                 ),
669 664
                 'a_attr' => array(
670
-                    'id' => 'fld_' . $completTree[$nodeId]->id,
665
+                    'id' => 'fld_'.$completTree[$nodeId]->id,
671 666
                     'class' => $nodeData['folderClass'],
672
-                    'onclick' => 'ListerItems(' . $completTree[$nodeId]->id . ', ' . $nodeData['restricted'] . ', 0, 1)',
667
+                    'onclick' => 'ListerItems('.$completTree[$nodeId]->id.', '.$nodeData['restricted'].', 0, 1)',
673 668
                     'data-title' => $completTree[$nodeId]->title,
674 669
                 ),
675 670
             )
@@ -678,12 +673,12 @@  discard block
 block discarded – undo
678 673
         array_push(
679 674
             $ret_json,
680 675
             array(
681
-                'id' => 'li_' . $completTree[$nodeId]->id,
676
+                'id' => 'li_'.$completTree[$nodeId]->id,
682 677
                 'parent' => $last_visible_parent === -1 ? $parent : $last_visible_parent,
683 678
                 'text' => '<i class="fas fa-times fa-xs text-danger mr-1"></i>'.$text.$completTree[$nodeId]->title.$nodeData['html'],
684 679
                 'li_attr' => array(
685 680
                     'class' => '',
686
-                    'title' => 'ID [' . $completTree[$nodeId]->id . '] ' . langHdl('no_access'),
681
+                    'title' => 'ID ['.$completTree[$nodeId]->id.'] '.langHdl('no_access'),
687 682
                 ),
688 683
             )
689 684
         );
@@ -746,8 +741,8 @@  discard block
 block discarded – undo
746 741
     if (in_array($nodeId, $session_groupes_visibles) === true) {
747 742
         if (in_array($nodeId, $session_read_only_folders) === true) {
748 743
             return [
749
-                'html' => '<i class="far fa-eye fa-xs mr-1"></i><span class="badge badge-pill badge-light ml-2 items_count" id="itcount_' . $nodeId . '">' . $itemsNb .
750
-                    ($tree_counters === 1 ? '/'.$nbChildrenItems .'/'.(count($nodeDescendants) - 1)  : '') . '</span>',
744
+                'html' => '<i class="far fa-eye fa-xs mr-1"></i><span class="badge badge-pill badge-light ml-2 items_count" id="itcount_'.$nodeId.'">'.$itemsNb.
745
+                    ($tree_counters === 1 ? '/'.$nbChildrenItems.'/'.(count($nodeDescendants) - 1) : '').'</span>',
751 746
                 'title' => langHdl('read_only_account'),
752 747
                 'restricted' => 1,
753 748
                 'folderClass' => 'folder_not_droppable',
@@ -761,8 +756,8 @@  discard block
 block discarded – undo
761 756
             && in_array($nodeId, $session_personal_visible_groups) === false
762 757
         ) {
763 758
             return [
764
-                'html' => '<i class="far fa-eye fa-xs mr-1"></i><span class="badge badge-pill badge-light ml-2 items_count" id="itcount_' . $nodeId . '">' . $itemsNb .
765
-                    ($tree_counters === 1 ? '/'.$nbChildrenItems .'/'.(count($nodeDescendants) - 1)  : '') . '</span>',
759
+                'html' => '<i class="far fa-eye fa-xs mr-1"></i><span class="badge badge-pill badge-light ml-2 items_count" id="itcount_'.$nodeId.'">'.$itemsNb.
760
+                    ($tree_counters === 1 ? '/'.$nbChildrenItems.'/'.(count($nodeDescendants) - 1) : '').'</span>',
766 761
                 'title' => $title,
767 762
                 'restricted' => 0,
768 763
                 'folderClass' => 'folder',
@@ -772,8 +767,8 @@  discard block
 block discarded – undo
772 767
         }
773 768
         
774 769
         return [
775
-            'html' => '<span class="badge badge-pill badge-light ml-2 items_count" id="itcount_' . $nodeId . '">' . $itemsNb .
776
-                ($tree_counters === 1 ? '/'.$nbChildrenItems .'/'.(count($nodeDescendants) - 1)  : '') . '</span>',
770
+            'html' => '<span class="badge badge-pill badge-light ml-2 items_count" id="itcount_'.$nodeId.'">'.$itemsNb.
771
+                ($tree_counters === 1 ? '/'.$nbChildrenItems.'/'.(count($nodeDescendants) - 1) : '').'</span>',
777 772
             'title' => $title,
778 773
             'restricted' => 0,
779 774
             'folderClass' => 'folder',
@@ -784,8 +779,8 @@  discard block
 block discarded – undo
784 779
     
785 780
     if (in_array($nodeId, $listFoldersLimitedKeys) === true) {
786 781
         return [
787
-            'html' => ($session_user_read_only === true ? '<i class="far fa-eye fa-xs mr-1"></i>' : '') .
788
-                '<span class="badge badge-pill badge-light ml-2 items_count" id="itcount_' . $nodeId . '">' . count($session_list_folders_limited[$nodeId]) . '</span>',
782
+            'html' => ($session_user_read_only === true ? '<i class="far fa-eye fa-xs mr-1"></i>' : '').
783
+                '<span class="badge badge-pill badge-light ml-2 items_count" id="itcount_'.$nodeId.'">'.count($session_list_folders_limited[$nodeId]).'</span>',
789 784
             'title' => $title,
790 785
             'restricted' => 1,
791 786
             'folderClass' => 'folder',
@@ -796,8 +791,8 @@  discard block
 block discarded – undo
796 791
     
797 792
     if (in_array($nodeId, $listRestrictedFoldersForItemsKeys) === true) {
798 793
         return [
799
-            'html' => $session_user_read_only === true ? '<i class="far fa-eye fa-xs mr-1"></i>' : '' .
800
-                '<span class="badge badge-pill badge-light ml-2 items_count" id="itcount_' . $nodeId . '">' . count($session_list_restricted_folders_for_items[$nodeId]) . '</span>',
794
+            'html' => $session_user_read_only === true ? '<i class="far fa-eye fa-xs mr-1"></i>' : ''.
795
+                '<span class="badge badge-pill badge-light ml-2 items_count" id="itcount_'.$nodeId.'">'.count($session_list_restricted_folders_for_items[$nodeId]).'</span>',
801 796
             'title' => $title,
802 797
             'restricted' => 1,
803 798
             'folderClass' => 'folder',
Please login to merge, or discard this patch.