nilsteampassnet /
TeamPass
@@ -34,12 +34,12 @@ discard block |
||
| 34 | 34 | } |
| 35 | 35 | |
| 36 | 36 | // Do checks |
| 37 | -require_once $SETTINGS['cpassman_dir'] . '/includes/config/include.php'; |
|
| 38 | -require_once $SETTINGS['cpassman_dir'] . '/sources/checks.php'; |
|
| 37 | +require_once $SETTINGS['cpassman_dir'].'/includes/config/include.php'; |
|
| 38 | +require_once $SETTINGS['cpassman_dir'].'/sources/checks.php'; |
|
| 39 | 39 | if (checkUser($_SESSION['user_id'], $_SESSION['key'], 'items', $SETTINGS) === false) { |
| 40 | 40 | // Not allowed page |
| 41 | 41 | $_SESSION['error']['code'] = ERR_NOT_ALLOWED; |
| 42 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
| 42 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
| 43 | 43 | exit(); |
| 44 | 44 | } |
| 45 | 45 | |
@@ -52,8 +52,8 @@ discard block |
||
| 52 | 52 | date_default_timezone_set('UTC'); |
| 53 | 53 | } |
| 54 | 54 | |
| 55 | -require_once $SETTINGS['cpassman_dir'] . '/includes/language/' . $_SESSION['user_language'] . '.php'; |
|
| 56 | -require_once $SETTINGS['cpassman_dir'] . '/includes/config/settings.php'; |
|
| 55 | +require_once $SETTINGS['cpassman_dir'].'/includes/language/'.$_SESSION['user_language'].'.php'; |
|
| 56 | +require_once $SETTINGS['cpassman_dir'].'/includes/config/settings.php'; |
|
| 57 | 57 | header('Content-type: text/html; charset=utf-8'); |
| 58 | 58 | header('Cache-Control: no-cache, must-revalidate'); |
| 59 | 59 | require_once 'main.functions.php'; |
@@ -75,7 +75,7 @@ discard block |
||
| 75 | 75 | } |
| 76 | 76 | |
| 77 | 77 | // Connect to mysql server |
| 78 | -require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Database/Meekrodb/db.class.php'; |
|
| 78 | +require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Database/Meekrodb/db.class.php'; |
|
| 79 | 79 | if (defined('DB_PASSWD_CLEAR') === false) { |
| 80 | 80 | define('DB_PASSWD_CLEAR', defuseReturnDecrypted(DB_PASSWD, $SETTINGS)); |
| 81 | 81 | } |
@@ -87,7 +87,7 @@ discard block |
||
| 87 | 87 | DB::$encoding = DB_ENCODING; |
| 88 | 88 | |
| 89 | 89 | // Class loader |
| 90 | -require_once $SETTINGS['cpassman_dir'] . '/sources/SplClassLoader.php'; |
|
| 90 | +require_once $SETTINGS['cpassman_dir'].'/sources/SplClassLoader.php'; |
|
| 91 | 91 | |
| 92 | 92 | //Load Tree |
| 93 | 93 | $tree = new SplClassLoader('Tree\NestedTree', '../includes/libraries'); |
@@ -302,7 +302,7 @@ discard block |
||
| 302 | 302 | // About special settings |
| 303 | 303 | $dataFolderSettings = DB::queryFirstRow( |
| 304 | 304 | 'SELECT bloquer_creation, bloquer_modification, personal_folder |
| 305 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 305 | + FROM ' . prefixTable('nested_tree').' |
|
| 306 | 306 | WHERE id = %i', |
| 307 | 307 | $post_folder_id |
| 308 | 308 | ); |
@@ -317,7 +317,7 @@ discard block |
||
| 317 | 317 | // Get folder complexity |
| 318 | 318 | $folderComplexity = DB::queryfirstrow( |
| 319 | 319 | 'SELECT valeur |
| 320 | - FROM ' . prefixTable('misc') . ' |
|
| 320 | + FROM ' . prefixTable('misc').' |
|
| 321 | 321 | WHERE type = %s AND intitule = %i', |
| 322 | 322 | 'complex', |
| 323 | 323 | $post_folder_id |
@@ -342,7 +342,7 @@ discard block |
||
| 342 | 342 | $itemExists = 0; |
| 343 | 343 | $newID = ''; |
| 344 | 344 | $data = DB::queryfirstrow( |
| 345 | - 'SELECT * FROM ' . prefixTable('items') . ' |
|
| 345 | + 'SELECT * FROM '.prefixTable('items').' |
|
| 346 | 346 | WHERE label = %s AND inactif = %i', |
| 347 | 347 | $post_label, |
| 348 | 348 | 0 |
@@ -468,7 +468,7 @@ discard block |
||
| 468 | 468 | // should we encrypt the data |
| 469 | 469 | $dataTmp = DB::queryFirstRow( |
| 470 | 470 | 'SELECT encrypted_data |
| 471 | - FROM ' . prefixTable('categories') . ' |
|
| 471 | + FROM ' . prefixTable('categories').' |
|
| 472 | 472 | WHERE id = %i', |
| 473 | 473 | $field_data[0] |
| 474 | 474 | ); |
@@ -524,7 +524,7 @@ discard block |
||
| 524 | 524 | ) { |
| 525 | 525 | DB::queryFirstRow( |
| 526 | 526 | 'SELECT * |
| 527 | - FROM ' . prefixTable('templates') . ' |
|
| 527 | + FROM ' . prefixTable('templates').' |
|
| 528 | 528 | WHERE item_id = %i', |
| 529 | 529 | $newID |
| 530 | 530 | ); |
@@ -593,11 +593,11 @@ discard block |
||
| 593 | 593 | ) { |
| 594 | 594 | foreach ($post_restricted_to as $userRest) { |
| 595 | 595 | if (empty($userRest) === false) { |
| 596 | - $dataTmp = DB::queryfirstrow('SELECT login FROM ' . prefixTable('users') . ' WHERE id= %i', $userRest); |
|
| 596 | + $dataTmp = DB::queryfirstrow('SELECT login FROM '.prefixTable('users').' WHERE id= %i', $userRest); |
|
| 597 | 597 | if (empty($listOfRestricted)) { |
| 598 | 598 | $listOfRestricted = $dataTmp['login']; |
| 599 | 599 | } else { |
| 600 | - $listOfRestricted .= ';' . $dataTmp['login']; |
|
| 600 | + $listOfRestricted .= ';'.$dataTmp['login']; |
|
| 601 | 601 | } |
| 602 | 602 | } |
| 603 | 603 | } |
@@ -610,11 +610,11 @@ discard block |
||
| 610 | 610 | if (empty($data['restricted_to']) === false) { |
| 611 | 611 | foreach (explode(';', $data['restricted_to']) as $userRest) { |
| 612 | 612 | if (empty($userRest) === false) { |
| 613 | - $dataTmp = DB::queryfirstrow('SELECT login FROM ' . prefixTable('users') . ' WHERE id= ' . $userRest); |
|
| 613 | + $dataTmp = DB::queryfirstrow('SELECT login FROM '.prefixTable('users').' WHERE id= '.$userRest); |
|
| 614 | 614 | if (empty($oldRestrictionList) === true) { |
| 615 | 615 | $oldRestrictionList = $dataTmp['login']; |
| 616 | 616 | } else { |
| 617 | - $oldRestrictionList .= ';' . $dataTmp['login']; |
|
| 617 | + $oldRestrictionList .= ';'.$dataTmp['login']; |
|
| 618 | 618 | } |
| 619 | 619 | } |
| 620 | 620 | } |
@@ -677,7 +677,7 @@ discard block |
||
| 677 | 677 | if (empty($post_uploaded_file_id) === false) { |
| 678 | 678 | $rows = DB::query( |
| 679 | 679 | 'SELECT id |
| 680 | - FROM ' . prefixTable('files') . ' |
|
| 680 | + FROM ' . prefixTable('files').' |
|
| 681 | 681 | WHERE id_item = %s', |
| 682 | 682 | $post_uploaded_file_id |
| 683 | 683 | ); |
@@ -717,14 +717,14 @@ discard block |
||
| 717 | 717 | langHdl('email_subject'), |
| 718 | 718 | str_replace( |
| 719 | 719 | array('#label', '#link'), |
| 720 | - array($path, $SETTINGS['email_server_url'] . '/index.php?page=items&group=' . $post_folder_id . '&id=' . $newID . $txt['email_body3']), |
|
| 720 | + array($path, $SETTINGS['email_server_url'].'/index.php?page=items&group='.$post_folder_id.'&id='.$newID.$txt['email_body3']), |
|
| 721 | 721 | langHdl('new_item_email_body') |
| 722 | 722 | ), |
| 723 | 723 | $emailAddress, |
| 724 | 724 | $SETTINGS, |
| 725 | 725 | str_replace( |
| 726 | 726 | array('#label', '#link'), |
| 727 | - array($path, $SETTINGS['email_server_url'] . '/index.php?page=items&group=' . $post_folder_id . '&id=' . $newID . $txt['email_body3']), |
|
| 727 | + array($path, $SETTINGS['email_server_url'].'/index.php?page=items&group='.$post_folder_id.'&id='.$newID.$txt['email_body3']), |
|
| 728 | 728 | langHdl('new_item_email_body') |
| 729 | 729 | ) |
| 730 | 730 | ); |
@@ -889,7 +889,7 @@ discard block |
||
| 889 | 889 | // About special settings |
| 890 | 890 | $dataFolderSettings = DB::queryFirstRow( |
| 891 | 891 | 'SELECT bloquer_creation, bloquer_modification, personal_folder |
| 892 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 892 | + FROM ' . prefixTable('nested_tree').' |
|
| 893 | 893 | WHERE id = %i', |
| 894 | 894 | $post_folder_id |
| 895 | 895 | ); |
@@ -904,7 +904,7 @@ discard block |
||
| 904 | 904 | // Get folder complexity |
| 905 | 905 | $folderComplexity = DB::queryfirstrow( |
| 906 | 906 | 'SELECT valeur |
| 907 | - FROM ' . prefixTable('misc') . ' |
|
| 907 | + FROM ' . prefixTable('misc').' |
|
| 908 | 908 | WHERE type = %s AND intitule = %i', |
| 909 | 909 | 'complex', |
| 910 | 910 | $post_folder_id |
@@ -943,8 +943,8 @@ discard block |
||
| 943 | 943 | // Get all informations for this item |
| 944 | 944 | $dataItem = DB::queryfirstrow( |
| 945 | 945 | 'SELECT * |
| 946 | - FROM ' . prefixTable('items') . ' as i |
|
| 947 | - INNER JOIN ' . prefixTable('log_items') . ' as l ON (l.id_item = i.id) |
|
| 946 | + FROM ' . prefixTable('items').' as i |
|
| 947 | + INNER JOIN ' . prefixTable('log_items').' as l ON (l.id_item = i.id) |
|
| 948 | 948 | WHERE i.id=%i AND l.action = %s', |
| 949 | 949 | $post_item_id, |
| 950 | 950 | 'at_creation' |
@@ -954,7 +954,7 @@ discard block |
||
| 954 | 954 | //db::debugmode(true); |
| 955 | 955 | DB::query( |
| 956 | 956 | 'SELECT * |
| 957 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
| 957 | + FROM ' . prefixTable('sharekeys_items').' |
|
| 958 | 958 | WHERE object_id = %i AND user_id = %s', |
| 959 | 959 | $post_item_id, |
| 960 | 960 | $_SESSION['user_id'] |
@@ -1004,9 +1004,9 @@ discard block |
||
| 1004 | 1004 | 'SELECT i.id as id, i.label as label, i.description as description, i.pw as pw, i.url as url, i.id_tree as id_tree, i.perso as perso, i.login as login, |
| 1005 | 1005 | i.inactif as inactif, i.restricted_to as restricted_to, i.anyone_can_modify as anyone_can_modify, i.email as email, i.notification as notification, |
| 1006 | 1006 | u.login as user_login, u.email as user_email |
| 1007 | - FROM ' . prefixTable('items') . ' as i |
|
| 1008 | - INNER JOIN ' . prefixTable('log_items') . ' as l ON (i.id=l.id_item) |
|
| 1009 | - INNER JOIN ' . prefixTable('users') . ' as u ON (u.id=l.id_user) |
|
| 1007 | + FROM ' . prefixTable('items').' as i |
|
| 1008 | + INNER JOIN ' . prefixTable('log_items').' as l ON (i.id=l.id_item) |
|
| 1009 | + INNER JOIN ' . prefixTable('users').' as u ON (u.id=l.id_user) |
|
| 1010 | 1010 | WHERE i.id=%i', |
| 1011 | 1011 | $post_item_id |
| 1012 | 1012 | ); |
@@ -1014,7 +1014,7 @@ discard block |
||
| 1014 | 1014 | // Should we log a password change? |
| 1015 | 1015 | $userKey = DB::queryFirstRow( |
| 1016 | 1016 | 'SELECT share_key |
| 1017 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
| 1017 | + FROM ' . prefixTable('sharekeys_items').' |
|
| 1018 | 1018 | WHERE user_id = %i AND object_id = %i', |
| 1019 | 1019 | $_SESSION['user_id'], |
| 1020 | 1020 | $post_item_id |
@@ -1073,7 +1073,7 @@ discard block |
||
| 1073 | 1073 | // Get list of tags |
| 1074 | 1074 | $itemTags = DB::queryFirstColumn( |
| 1075 | 1075 | 'SELECT tag |
| 1076 | - FROM ' . prefixTable('tags') . ' |
|
| 1076 | + FROM ' . prefixTable('tags').' |
|
| 1077 | 1077 | WHERE item_id = %i', |
| 1078 | 1078 | $post_item_id |
| 1079 | 1079 | ); |
@@ -1117,7 +1117,7 @@ discard block |
||
| 1117 | 1117 | $_SESSION['user_id'], |
| 1118 | 1118 | 'at_modification', |
| 1119 | 1119 | $_SESSION['login'], |
| 1120 | - 'at_tag : ' . implode(' ', $itemTags) . ' => ' . $post_tags |
|
| 1120 | + 'at_tag : '.implode(' ', $itemTags).' => '.$post_tags |
|
| 1121 | 1121 | ); |
| 1122 | 1122 | } |
| 1123 | 1123 | |
@@ -1157,8 +1157,8 @@ discard block |
||
| 1157 | 1157 | 'SELECT c.id AS id, c.title AS title, i.data AS data, i.data_iv AS data_iv, |
| 1158 | 1158 | i.encryption_type AS encryption_type, c.encrypted_data AS encrypted_data, |
| 1159 | 1159 | c.masked AS masked, i.id AS field_item_id |
| 1160 | - FROM ' . prefixTable('categories_items') . ' AS i |
|
| 1161 | - INNER JOIN ' . prefixTable('categories') . ' AS c ON (i.field_id=c.id) |
|
| 1160 | + FROM ' . prefixTable('categories_items').' AS i |
|
| 1161 | + INNER JOIN ' . prefixTable('categories').' AS c ON (i.field_id=c.id) |
|
| 1162 | 1162 | WHERE i.field_id = %i AND i.item_id = %i', |
| 1163 | 1163 | $field['id'], |
| 1164 | 1164 | $post_item_id |
@@ -1172,7 +1172,7 @@ discard block |
||
| 1172 | 1172 | // Perform new query |
| 1173 | 1173 | $dataTmpCat = DB::queryFirstRow( |
| 1174 | 1174 | 'SELECT id, title, encrypted_data, masked |
| 1175 | - FROM ' . prefixTable('categories') . ' |
|
| 1175 | + FROM ' . prefixTable('categories').' |
|
| 1176 | 1176 | WHERE id = %i', |
| 1177 | 1177 | $field['id'] |
| 1178 | 1178 | ); |
@@ -1244,7 +1244,7 @@ discard block |
||
| 1244 | 1244 | $_SESSION['user_id'], |
| 1245 | 1245 | 'at_modification', |
| 1246 | 1246 | $_SESSION['login'], |
| 1247 | - 'at_field : ' . $dataTmpCat['title'] . ' : ' . $field['value'] |
|
| 1247 | + 'at_field : '.$dataTmpCat['title'].' : '.$field['value'] |
|
| 1248 | 1248 | ); |
| 1249 | 1249 | } else { |
| 1250 | 1250 | // compare the old and new value |
@@ -1252,7 +1252,7 @@ discard block |
||
| 1252 | 1252 | // Get user sharekey for this field |
| 1253 | 1253 | $userKey = DB::queryFirstRow( |
| 1254 | 1254 | 'SELECT share_key |
| 1255 | - FROM ' . prefixTable('sharekeys_fields') . ' |
|
| 1255 | + FROM ' . prefixTable('sharekeys_fields').' |
|
| 1256 | 1256 | WHERE user_id = %i AND object_id = %i', |
| 1257 | 1257 | $_SESSION['user_id'], |
| 1258 | 1258 | $dataTmpCat['field_item_id'] |
@@ -1321,7 +1321,7 @@ discard block |
||
| 1321 | 1321 | $_SESSION['user_id'], |
| 1322 | 1322 | 'at_modification', |
| 1323 | 1323 | $_SESSION['login'], |
| 1324 | - 'at_field : ' . $dataTmpCat['title'] . ' => ' . $oldVal |
|
| 1324 | + 'at_field : '.$dataTmpCat['title'].' => '.$oldVal |
|
| 1325 | 1325 | ); |
| 1326 | 1326 | } |
| 1327 | 1327 | } |
@@ -1346,7 +1346,7 @@ discard block |
||
| 1346 | 1346 | ) { |
| 1347 | 1347 | DB::queryFirstRow( |
| 1348 | 1348 | 'SELECT * |
| 1349 | - FROM ' . prefixTable('templates') . ' |
|
| 1349 | + FROM ' . prefixTable('templates').' |
|
| 1350 | 1350 | WHERE item_id = %i', |
| 1351 | 1351 | $post_item_id |
| 1352 | 1352 | ); |
@@ -1389,7 +1389,7 @@ discard block |
||
| 1389 | 1389 | // check if elem exists in Table. If not add it or update it. |
| 1390 | 1390 | DB::query( |
| 1391 | 1391 | 'SELECT * |
| 1392 | - FROM ' . prefixTable('automatic_del') . ' |
|
| 1392 | + FROM ' . prefixTable('automatic_del').' |
|
| 1393 | 1393 | WHERE item_id = %i', |
| 1394 | 1394 | $post_item_id |
| 1395 | 1395 | ); |
@@ -1416,7 +1416,7 @@ discard block |
||
| 1416 | 1416 | // Store updates performed |
| 1417 | 1417 | array_push( |
| 1418 | 1418 | $arrayOfChanges, |
| 1419 | - langHdl('automatic_deletion_engaged') . ': ' . langHdl('enabled') |
|
| 1419 | + langHdl('automatic_deletion_engaged').': '.langHdl('enabled') |
|
| 1420 | 1420 | ); |
| 1421 | 1421 | |
| 1422 | 1422 | // update LOG |
@@ -1459,7 +1459,7 @@ discard block |
||
| 1459 | 1459 | // Store updates performed |
| 1460 | 1460 | array_push( |
| 1461 | 1461 | $arrayOfChanges, |
| 1462 | - langHdl('automatic_deletion_engaged') . ': ' . langHdl('disabled') |
|
| 1462 | + langHdl('automatic_deletion_engaged').': '.langHdl('disabled') |
|
| 1463 | 1463 | ); |
| 1464 | 1464 | |
| 1465 | 1465 | // update LOG |
@@ -1492,7 +1492,7 @@ discard block |
||
| 1492 | 1492 | if (empty($userId) === false) { |
| 1493 | 1493 | $dataTmp = DB::queryfirstrow( |
| 1494 | 1494 | 'SELECT id, name, lastname |
| 1495 | - FROM ' . prefixTable('users') . ' |
|
| 1495 | + FROM ' . prefixTable('users').' |
|
| 1496 | 1496 | WHERE id= %i', |
| 1497 | 1497 | $userId |
| 1498 | 1498 | ); |
@@ -1500,7 +1500,7 @@ discard block |
||
| 1500 | 1500 | // Add to array |
| 1501 | 1501 | array_push( |
| 1502 | 1502 | $arrayOfUsersRestriction, |
| 1503 | - $dataTmp['name'] . ' ' . $dataTmp['lastname'] |
|
| 1503 | + $dataTmp['name'].' '.$dataTmp['lastname'] |
|
| 1504 | 1504 | ); |
| 1505 | 1505 | array_push( |
| 1506 | 1506 | $arrayOfUsersIdRestriction, |
@@ -1531,8 +1531,8 @@ discard block |
||
| 1531 | 1531 | // get values before deleting them |
| 1532 | 1532 | $rows = DB::query( |
| 1533 | 1533 | 'SELECT t.title, t.id AS id |
| 1534 | - FROM ' . prefixTable('roles_title') . ' as t |
|
| 1535 | - INNER JOIN ' . prefixTable('restriction_to_roles') . ' as r ON (t.id=r.role_id) |
|
| 1534 | + FROM ' . prefixTable('roles_title').' as t |
|
| 1535 | + INNER JOIN ' . prefixTable('restriction_to_roles').' as r ON (t.id=r.role_id) |
|
| 1536 | 1536 | WHERE r.item_id = %i |
| 1537 | 1537 | ORDER BY t.title ASC', |
| 1538 | 1538 | $post_item_id |
@@ -1566,7 +1566,7 @@ discard block |
||
| 1566 | 1566 | ); |
| 1567 | 1567 | $dataTmp = DB::queryfirstrow( |
| 1568 | 1568 | 'SELECT title |
| 1569 | - FROM ' . prefixTable('roles_title') . ' |
|
| 1569 | + FROM ' . prefixTable('roles_title').' |
|
| 1570 | 1570 | WHERE id = %i', |
| 1571 | 1571 | $role |
| 1572 | 1572 | ); |
@@ -1607,8 +1607,8 @@ discard block |
||
| 1607 | 1607 | $_SESSION['user_id'], |
| 1608 | 1608 | 'at_modification', |
| 1609 | 1609 | $_SESSION['login'], |
| 1610 | - 'at_restriction : ' . (count($diffUsersRestiction) > 0 ? |
|
| 1611 | - implode(', ', $arrayOfUsersRestriction) . (count($diffRolesRestiction) > 0 ? ', ' : '') : '') . (count($diffRolesRestiction) > 0 ? implode(', ', $arrayOfRestrictionRoles) : '') |
|
| 1610 | + 'at_restriction : '.(count($diffUsersRestiction) > 0 ? |
|
| 1611 | + implode(', ', $arrayOfUsersRestriction).(count($diffRolesRestiction) > 0 ? ', ' : '') : '').(count($diffRolesRestiction) > 0 ? implode(', ', $arrayOfRestrictionRoles) : '') |
|
| 1612 | 1612 | ); |
| 1613 | 1613 | } |
| 1614 | 1614 | |
@@ -1628,7 +1628,7 @@ discard block |
||
| 1628 | 1628 | $_SESSION['user_id'], |
| 1629 | 1629 | 'at_modification', |
| 1630 | 1630 | $_SESSION['login'], |
| 1631 | - 'at_label : ' . $data['label'] . ' => ' . $post_label |
|
| 1631 | + 'at_label : '.$data['label'].' => '.$post_label |
|
| 1632 | 1632 | ); |
| 1633 | 1633 | } |
| 1634 | 1634 | // LOGIN |
@@ -1647,7 +1647,7 @@ discard block |
||
| 1647 | 1647 | $_SESSION['user_id'], |
| 1648 | 1648 | 'at_modification', |
| 1649 | 1649 | $_SESSION['login'], |
| 1650 | - 'at_login : ' . $data['login'] . ' => ' . $post_login |
|
| 1650 | + 'at_login : '.$data['login'].' => '.$post_login |
|
| 1651 | 1651 | ); |
| 1652 | 1652 | } |
| 1653 | 1653 | |
@@ -1666,7 +1666,7 @@ discard block |
||
| 1666 | 1666 | $_SESSION['user_id'], |
| 1667 | 1667 | 'at_modification', |
| 1668 | 1668 | $_SESSION['login'], |
| 1669 | - 'at_email : ' . $data['email'] . ' => ' . $post_email |
|
| 1669 | + 'at_email : '.$data['email'].' => '.$post_email |
|
| 1670 | 1670 | ); |
| 1671 | 1671 | } |
| 1672 | 1672 | // URL |
@@ -1685,7 +1685,7 @@ discard block |
||
| 1685 | 1685 | $_SESSION['user_id'], |
| 1686 | 1686 | 'at_modification', |
| 1687 | 1687 | $_SESSION['login'], |
| 1688 | - 'at_url : ' . $data['url'] . ' => ' . $post_url |
|
| 1688 | + 'at_url : '.$data['url'].' => '.$post_url |
|
| 1689 | 1689 | ); |
| 1690 | 1690 | } |
| 1691 | 1691 | // DESCRIPTION |
@@ -1710,7 +1710,7 @@ discard block |
||
| 1710 | 1710 | // FOLDER |
| 1711 | 1711 | if ($data['id_tree'] !== $post_folder_id) { |
| 1712 | 1712 | // Get name of folders |
| 1713 | - $dataTmp = DB::query('SELECT title FROM ' . prefixTable('nested_tree') . ' WHERE id IN %li', array($data['id_tree'], $post_folder_id)); |
|
| 1713 | + $dataTmp = DB::query('SELECT title FROM '.prefixTable('nested_tree').' WHERE id IN %li', array($data['id_tree'], $post_folder_id)); |
|
| 1714 | 1714 | |
| 1715 | 1715 | // Store updates performed |
| 1716 | 1716 | array_push( |
@@ -1726,7 +1726,7 @@ discard block |
||
| 1726 | 1726 | $_SESSION['user_id'], |
| 1727 | 1727 | 'at_modification', |
| 1728 | 1728 | $_SESSION['login'], |
| 1729 | - 'at_category : ' . $dataTmp[0]['title'] . ' => ' . $dataTmp[1]['title'] |
|
| 1729 | + 'at_category : '.$dataTmp[0]['title'].' => '.$dataTmp[1]['title'] |
|
| 1730 | 1730 | ); |
| 1731 | 1731 | // ask for page reloading |
| 1732 | 1732 | $reloadPage = true; |
@@ -1736,7 +1736,7 @@ discard block |
||
| 1736 | 1736 | // Store updates performed |
| 1737 | 1737 | array_push( |
| 1738 | 1738 | $arrayOfChanges, |
| 1739 | - langHdl('at_anyoneconmodify') . ': ' . ((int) $post_anyone_can_modify === 0 ? langHdl('disabled') : langHdl('enabled')) |
|
| 1739 | + langHdl('at_anyoneconmodify').': '.((int) $post_anyone_can_modify === 0 ? langHdl('disabled') : langHdl('enabled')) |
|
| 1740 | 1740 | ); |
| 1741 | 1741 | |
| 1742 | 1742 | // Log |
@@ -1747,15 +1747,15 @@ discard block |
||
| 1747 | 1747 | $_SESSION['user_id'], |
| 1748 | 1748 | 'at_modification', |
| 1749 | 1749 | $_SESSION['login'], |
| 1750 | - 'at_anyoneconmodify : ' . ((int) $post_anyone_can_modify === 0 ? 'disabled' : 'enabled') |
|
| 1750 | + 'at_anyoneconmodify : '.((int) $post_anyone_can_modify === 0 ? 'disabled' : 'enabled') |
|
| 1751 | 1751 | ); |
| 1752 | 1752 | } |
| 1753 | 1753 | |
| 1754 | 1754 | // Reload new values |
| 1755 | 1755 | $dataItem = DB::queryfirstrow( |
| 1756 | 1756 | 'SELECT * |
| 1757 | - FROM ' . prefixTable('items') . ' as i |
|
| 1758 | - INNER JOIN ' . prefixTable('log_items') . ' as l ON (l.id_item = i.id) |
|
| 1757 | + FROM ' . prefixTable('items').' as i |
|
| 1758 | + INNER JOIN ' . prefixTable('log_items').' as l ON (l.id_item = i.id) |
|
| 1759 | 1759 | WHERE i.id = %i AND l.action = %s', |
| 1760 | 1760 | $post_item_id, |
| 1761 | 1761 | 'at_creation' |
@@ -1764,8 +1764,8 @@ discard block |
||
| 1764 | 1764 | $history = ''; |
| 1765 | 1765 | $rows = DB::query( |
| 1766 | 1766 | 'SELECT l.date as date, l.action as action, l.raison as raison, u.login as login |
| 1767 | - FROM ' . prefixTable('log_items') . ' as l |
|
| 1768 | - LEFT JOIN ' . prefixTable('users') . ' as u ON (l.id_user=u.id) |
|
| 1767 | + FROM ' . prefixTable('log_items').' as l |
|
| 1768 | + LEFT JOIN ' . prefixTable('users').' as u ON (l.id_user=u.id) |
|
| 1769 | 1769 | WHERE l.action <> %s AND id_item=%s', |
| 1770 | 1770 | 'at_shown', |
| 1771 | 1771 | $post_item_id |
@@ -1773,14 +1773,14 @@ discard block |
||
| 1773 | 1773 | foreach ($rows as $record) { |
| 1774 | 1774 | $reason = explode(':', $record['raison']); |
| 1775 | 1775 | if (count($reason) > 0) { |
| 1776 | - $sentence = date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], $record['date']) . ' - ' |
|
| 1777 | - . $record['login'] . ' - ' . langHdl($record['action']) . ' - ' |
|
| 1778 | - . (empty($record['raison']) === false ? (count($reason) > 1 ? langHdl(trim($reason[0])) . ' : ' . $reason[1] |
|
| 1776 | + $sentence = date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], $record['date']).' - ' |
|
| 1777 | + . $record['login'].' - '.langHdl($record['action']).' - ' |
|
| 1778 | + . (empty($record['raison']) === false ? (count($reason) > 1 ? langHdl(trim($reason[0])).' : '.$reason[1] |
|
| 1779 | 1779 | : langHdl(trim($reason[0]))) : ''); |
| 1780 | 1780 | if (empty($history)) { |
| 1781 | 1781 | $history = $sentence; |
| 1782 | 1782 | } else { |
| 1783 | - $history .= '<br />' . $sentence; |
|
| 1783 | + $history .= '<br />'.$sentence; |
|
| 1784 | 1784 | } |
| 1785 | 1785 | } |
| 1786 | 1786 | } |
@@ -1791,19 +1791,19 @@ discard block |
||
| 1791 | 1791 | // Prepare files listing |
| 1792 | 1792 | $files = $filesEdit = ''; |
| 1793 | 1793 | // launch query |
| 1794 | - $rows = DB::query('SELECT id, name, file, extension FROM ' . prefixTable('files') . ' WHERE id_item=%i', $post_item_id); |
|
| 1794 | + $rows = DB::query('SELECT id, name, file, extension FROM '.prefixTable('files').' WHERE id_item=%i', $post_item_id); |
|
| 1795 | 1795 | foreach ($rows as $record) { |
| 1796 | 1796 | // get icon image depending on file format |
| 1797 | 1797 | $iconImage = fileFormatImage($record['extension']); |
| 1798 | 1798 | |
| 1799 | 1799 | // If file is an image, then prepare lightbox. If not image, then prepare donwload |
| 1800 | 1800 | if (in_array($record['extension'], TP_IMAGE_FILE_EXT)) { |
| 1801 | - $files .= '<i class=\'fa fa-file-image-o\' /></i> <a class="image_dialog" href="#' . $record['id'] . '" title="' . $record['name'] . '">' . $record['name'] . '</a><br />'; |
|
| 1801 | + $files .= '<i class=\'fa fa-file-image-o\' /></i> <a class="image_dialog" href="#'.$record['id'].'" title="'.$record['name'].'">'.$record['name'].'</a><br />'; |
|
| 1802 | 1802 | } else { |
| 1803 | - $files .= '<i class=\'fa fa-file-text-o\' /></i> <a href=\'sources/downloadFile.php?name=' . urlencode($record['name']) . '&type=sub&key=' . $_SESSION['key'] . '&key_tmp=' . $_SESSION['key_tmp'] . '&fileid=' . $record['id'] . '\' target=\'_blank\'>' . $record['name'] . '</a><br />'; |
|
| 1803 | + $files .= '<i class=\'fa fa-file-text-o\' /></i> <a href=\'sources/downloadFile.php?name='.urlencode($record['name']).'&type=sub&key='.$_SESSION['key'].'&key_tmp='.$_SESSION['key_tmp'].'&fileid='.$record['id'].'\' target=\'_blank\'>'.$record['name'].'</a><br />'; |
|
| 1804 | 1804 | } |
| 1805 | 1805 | // Prepare list of files for edit dialogbox |
| 1806 | - $filesEdit .= '<span id="span_edit_file_' . $record['id'] . '"><span class="fa fa-' . $iconImage . '"></span> <span class="fa fa-eraser tip" style="cursor:pointer;" onclick="delete_attached_file(\"' . $record['id'] . '\")" title="' . langHdl('at_delete') . '"></span> ' . $record['name'] . '</span><br />'; |
|
| 1806 | + $filesEdit .= '<span id="span_edit_file_'.$record['id'].'"><span class="fa fa-'.$iconImage.'"></span> <span class="fa fa-eraser tip" style="cursor:pointer;" onclick="delete_attached_file(\"'.$record['id'].'\")" title="'.langHdl('at_delete').'"></span> '.$record['name'].'</span><br />'; |
|
| 1807 | 1807 | } |
| 1808 | 1808 | // Send email |
| 1809 | 1809 | if (is_array($post_diffusion_list) === true && count($post_diffusion_list) > 0) { |
@@ -1918,7 +1918,7 @@ discard block |
||
| 1918 | 1918 | ) { |
| 1919 | 1919 | // load the original record into an array |
| 1920 | 1920 | $originalRecord = DB::queryfirstrow( |
| 1921 | - 'SELECT * FROM ' . prefixTable('items') . ' |
|
| 1921 | + 'SELECT * FROM '.prefixTable('items').' |
|
| 1922 | 1922 | WHERE id = %i', |
| 1923 | 1923 | $post_item_id |
| 1924 | 1924 | ); |
@@ -1937,7 +1937,7 @@ discard block |
||
| 1937 | 1937 | |
| 1938 | 1938 | // Load the destination folder record into an array |
| 1939 | 1939 | $dataDestination = DB::queryfirstrow( |
| 1940 | - 'SELECT personal_folder FROM ' . prefixTable('nested_tree') . ' |
|
| 1940 | + 'SELECT personal_folder FROM '.prefixTable('nested_tree').' |
|
| 1941 | 1941 | WHERE id = %i', |
| 1942 | 1942 | $post_dest_id |
| 1943 | 1943 | ); |
@@ -1945,7 +1945,7 @@ discard block |
||
| 1945 | 1945 | // Get the ITEM object key for the user |
| 1946 | 1946 | $userKey = DB::queryFirstRow( |
| 1947 | 1947 | 'SELECT share_key |
| 1948 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
| 1948 | + FROM ' . prefixTable('sharekeys_items').' |
|
| 1949 | 1949 | WHERE user_id = %i AND object_id = %i', |
| 1950 | 1950 | $_SESSION['user_id'], |
| 1951 | 1951 | $post_item_id |
@@ -2017,7 +2017,7 @@ discard block |
||
| 2017 | 2017 | // Manage Custom Fields |
| 2018 | 2018 | $rows = DB::query( |
| 2019 | 2019 | 'SELECT * |
| 2020 | - FROM ' . prefixTable('categories_items') . ' |
|
| 2020 | + FROM ' . prefixTable('categories_items').' |
|
| 2021 | 2021 | WHERE item_id = %i', |
| 2022 | 2022 | $post_item_id |
| 2023 | 2023 | ); |
@@ -2065,15 +2065,15 @@ discard block |
||
| 2065 | 2065 | $rows = DB::query( |
| 2066 | 2066 | 'SELECT f.id AS id, f.file AS file, f.name AS name, f.status AS status, f.extension AS extension, |
| 2067 | 2067 | f.size AS size, f.type AS type, s.share_key AS share_key |
| 2068 | - FROM ' . prefixTable('files') . ' AS f |
|
| 2069 | - INNER JOIN ' . prefixTable('sharekeys_files') . ' AS s ON (f.id = s.object_id) |
|
| 2068 | + FROM ' . prefixTable('files').' AS f |
|
| 2069 | + INNER JOIN ' . prefixTable('sharekeys_files').' AS s ON (f.id = s.object_id) |
|
| 2070 | 2070 | WHERE s.user_id = %i AND f.id_item = %i', |
| 2071 | 2071 | $_SESSION['user_id'], |
| 2072 | 2072 | $post_item_id |
| 2073 | 2073 | ); |
| 2074 | 2074 | foreach ($rows as $record) { |
| 2075 | 2075 | // Check if file still exists |
| 2076 | - if (file_exists($SETTINGS['path_to_upload_folder'] . DIRECTORY_SEPARATOR . TP_FILE_PREFIX . base64_decode($record['file'])) === true) { |
|
| 2076 | + if (file_exists($SETTINGS['path_to_upload_folder'].DIRECTORY_SEPARATOR.TP_FILE_PREFIX.base64_decode($record['file'])) === true) { |
|
| 2077 | 2077 | // Step1 - decrypt the file |
| 2078 | 2078 | $fileContent = decryptFile( |
| 2079 | 2079 | $record['file'], |
@@ -2082,8 +2082,8 @@ discard block |
||
| 2082 | 2082 | ); |
| 2083 | 2083 | |
| 2084 | 2084 | // Step2 - create file |
| 2085 | - $newFileName = md5(time() . '_' . $record['id']) . '.' . $record['extension']; |
|
| 2086 | - $outstream = fopen($SETTINGS['path_to_upload_folder'] . DIRECTORY_SEPARATOR . $newFileName, 'ab'); |
|
| 2085 | + $newFileName = md5(time().'_'.$record['id']).'.'.$record['extension']; |
|
| 2086 | + $outstream = fopen($SETTINGS['path_to_upload_folder'].DIRECTORY_SEPARATOR.$newFileName, 'ab'); |
|
| 2087 | 2087 | if ($outstream === false) { |
| 2088 | 2088 | echo prepareExchangedData( |
| 2089 | 2089 | array( |
@@ -2133,7 +2133,7 @@ discard block |
||
| 2133 | 2133 | |
| 2134 | 2134 | // ------------------------- |
| 2135 | 2135 | // Add specific restrictions |
| 2136 | - $rows = DB::query('SELECT * FROM ' . prefixTable('restriction_to_roles') . ' WHERE item_id = %i', $post_item_id); |
|
| 2136 | + $rows = DB::query('SELECT * FROM '.prefixTable('restriction_to_roles').' WHERE item_id = %i', $post_item_id); |
|
| 2137 | 2137 | foreach ($rows as $record) { |
| 2138 | 2138 | DB::insert( |
| 2139 | 2139 | prefixTable('restriction_to_roles'), |
@@ -2145,7 +2145,7 @@ discard block |
||
| 2145 | 2145 | } |
| 2146 | 2146 | |
| 2147 | 2147 | // Add Tags |
| 2148 | - $rows = DB::query('SELECT * FROM ' . prefixTable('tags') . ' WHERE item_id = %i', $post_item_id); |
|
| 2148 | + $rows = DB::query('SELECT * FROM '.prefixTable('tags').' WHERE item_id = %i', $post_item_id); |
|
| 2149 | 2149 | foreach ($rows as $record) { |
| 2150 | 2150 | DB::insert( |
| 2151 | 2151 | prefixTable('tags'), |
@@ -2175,7 +2175,7 @@ discard block |
||
| 2175 | 2175 | $_SESSION['login'] |
| 2176 | 2176 | ); |
| 2177 | 2177 | // reload cache table |
| 2178 | - include_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php'; |
|
| 2178 | + include_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php'; |
|
| 2179 | 2179 | updateCacheTable('reload', $SETTINGS, ''); |
| 2180 | 2180 | |
| 2181 | 2181 | echo (string) prepareExchangedData( |
@@ -2247,7 +2247,7 @@ discard block |
||
| 2247 | 2247 | // then we can show it |
| 2248 | 2248 | $item_deleted = DB::queryFirstRow( |
| 2249 | 2249 | 'SELECT * |
| 2250 | - FROM ' . prefixTable('log_items') . ' |
|
| 2250 | + FROM ' . prefixTable('log_items').' |
|
| 2251 | 2251 | WHERE id_item = %i AND action = %s |
| 2252 | 2252 | ORDER BY date DESC |
| 2253 | 2253 | LIMIT 0, 1', |
@@ -2258,7 +2258,7 @@ discard block |
||
| 2258 | 2258 | |
| 2259 | 2259 | $item_restored = DB::queryFirstRow( |
| 2260 | 2260 | 'SELECT * |
| 2261 | - FROM ' . prefixTable('log_items') . ' |
|
| 2261 | + FROM ' . prefixTable('log_items').' |
|
| 2262 | 2262 | WHERE id_item = %i AND action = %s |
| 2263 | 2263 | ORDER BY date DESC |
| 2264 | 2264 | LIMIT 0, 1', |
@@ -2282,8 +2282,8 @@ discard block |
||
| 2282 | 2282 | // Get all informations for this item |
| 2283 | 2283 | $dataItem = DB::queryfirstrow( |
| 2284 | 2284 | 'SELECT * |
| 2285 | - FROM ' . prefixTable('items') . ' as i |
|
| 2286 | - INNER JOIN ' . prefixTable('log_items') . ' as l ON (l.id_item = i.id) |
|
| 2285 | + FROM ' . prefixTable('items').' as i |
|
| 2286 | + INNER JOIN ' . prefixTable('log_items').' as l ON (l.id_item = i.id) |
|
| 2287 | 2287 | WHERE i.id = %i AND l.action = %s', |
| 2288 | 2288 | $post_id, |
| 2289 | 2289 | 'at_creation' |
@@ -2292,7 +2292,7 @@ discard block |
||
| 2292 | 2292 | // Notification |
| 2293 | 2293 | DB::queryfirstrow( |
| 2294 | 2294 | 'SELECT * |
| 2295 | - FROM ' . prefixTable('notification') . ' |
|
| 2295 | + FROM ' . prefixTable('notification').' |
|
| 2296 | 2296 | WHERE item_id = %i AND user_id = %i', |
| 2297 | 2297 | $post_id, |
| 2298 | 2298 | $_SESSION['user_id'] |
@@ -2339,13 +2339,13 @@ discard block |
||
| 2339 | 2339 | && $SETTINGS['enable_email_notification_on_item_shown'] === '1' |
| 2340 | 2340 | && $user['admin'] === '1' |
| 2341 | 2341 | ) { |
| 2342 | - $_SESSION['listNotificationEmails'] .= $user['email'] . ','; |
|
| 2342 | + $_SESSION['listNotificationEmails'] .= $user['email'].','; |
|
| 2343 | 2343 | } |
| 2344 | 2344 | } |
| 2345 | 2345 | |
| 2346 | 2346 | // manage case of API user |
| 2347 | 2347 | if ($dataItem['id_user'] === API_USER_ID) { |
| 2348 | - $arrData['author'] = 'API [' . $dataItem['description'] . ']'; |
|
| 2348 | + $arrData['author'] = 'API ['.$dataItem['description'].']'; |
|
| 2349 | 2349 | $arrData['id_user'] = API_USER_ID; |
| 2350 | 2350 | $arrData['author_email'] = ''; |
| 2351 | 2351 | $arrData['notification_status'] = false; |
@@ -2355,7 +2355,7 @@ discard block |
||
| 2355 | 2355 | $tags = array(); |
| 2356 | 2356 | $rows = DB::query( |
| 2357 | 2357 | 'SELECT tag |
| 2358 | - FROM ' . prefixTable('tags') . ' |
|
| 2358 | + FROM ' . prefixTable('tags').' |
|
| 2359 | 2359 | WHERE item_id = %i', |
| 2360 | 2360 | $post_id |
| 2361 | 2361 | ); |
@@ -2380,7 +2380,7 @@ discard block |
||
| 2380 | 2380 | // Check if user has a role that is accepted |
| 2381 | 2381 | $rows_tmp = DB::query( |
| 2382 | 2382 | 'SELECT role_id |
| 2383 | - FROM ' . prefixTable('restriction_to_roles') . ' |
|
| 2383 | + FROM ' . prefixTable('restriction_to_roles').' |
|
| 2384 | 2384 | WHERE item_id=%i', |
| 2385 | 2385 | $post_id |
| 2386 | 2386 | ); |
@@ -2394,7 +2394,7 @@ discard block |
||
| 2394 | 2394 | // Get the object key for the user |
| 2395 | 2395 | $userKey = DB::queryFirstRow( |
| 2396 | 2396 | 'SELECT share_key |
| 2397 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
| 2397 | + FROM ' . prefixTable('sharekeys_items').' |
|
| 2398 | 2398 | WHERE user_id = %i AND object_id = %i', |
| 2399 | 2399 | $_SESSION['user_id'], |
| 2400 | 2400 | $post_id |
@@ -2479,8 +2479,8 @@ discard block |
||
| 2479 | 2479 | // Add restriction if item is restricted to roles |
| 2480 | 2480 | $rows = DB::query( |
| 2481 | 2481 | 'SELECT t.title, t.id |
| 2482 | - FROM ' . prefixTable('roles_title') . ' AS t |
|
| 2483 | - INNER JOIN ' . prefixTable('restriction_to_roles') . ' AS r ON (t.id=r.role_id) |
|
| 2482 | + FROM ' . prefixTable('roles_title').' AS t |
|
| 2483 | + INNER JOIN ' . prefixTable('restriction_to_roles').' AS r ON (t.id=r.role_id) |
|
| 2484 | 2484 | WHERE r.item_id = %i |
| 2485 | 2485 | ORDER BY t.title ASC', |
| 2486 | 2486 | $post_id |
@@ -2496,8 +2496,8 @@ discard block |
||
| 2496 | 2496 | $tmp = array(); |
| 2497 | 2497 | $rows = DB::query( |
| 2498 | 2498 | 'SELECT k.label, k.id |
| 2499 | - FROM ' . prefixTable('kb_items') . ' as i |
|
| 2500 | - INNER JOIN ' . prefixTable('kb') . ' as k ON (i.kb_id=k.id) |
|
| 2499 | + FROM ' . prefixTable('kb_items').' as i |
|
| 2500 | + INNER JOIN ' . prefixTable('kb').' as k ON (i.kb_id=k.id) |
|
| 2501 | 2501 | WHERE i.item_id = %i |
| 2502 | 2502 | ORDER BY k.label ASC', |
| 2503 | 2503 | $post_id |
@@ -2577,7 +2577,7 @@ discard block |
||
| 2577 | 2577 | $arrCatList = array(); |
| 2578 | 2578 | $rows_tmp = DB::query( |
| 2579 | 2579 | 'SELECT id_category |
| 2580 | - FROM ' . prefixTable('categories_folders') . ' |
|
| 2580 | + FROM ' . prefixTable('categories_folders').' |
|
| 2581 | 2581 | WHERE id_folder=%i', |
| 2582 | 2582 | $post_folder_id |
| 2583 | 2583 | ); |
@@ -2592,8 +2592,8 @@ discard block |
||
| 2592 | 2592 | 'SELECT i.id AS id, i.field_id AS field_id, i.data AS data, i.item_id AS item_id, |
| 2593 | 2593 | i.encryption_type AS encryption_type, c.encrypted_data, c.parent_id AS parent_id, |
| 2594 | 2594 | c.type as field_type, c.masked AS field_masked, c.role_visibility AS role_visibility |
| 2595 | - FROM ' . prefixTable('categories_items') . ' AS i |
|
| 2596 | - INNER JOIN ' . prefixTable('categories') . ' AS c ON (i.field_id=c.id) |
|
| 2595 | + FROM ' . prefixTable('categories_items').' AS i |
|
| 2596 | + INNER JOIN ' . prefixTable('categories').' AS c ON (i.field_id=c.id) |
|
| 2597 | 2597 | WHERE i.item_id=%i AND c.parent_id IN %ls', |
| 2598 | 2598 | $post_id, |
| 2599 | 2599 | $arrCatList |
@@ -2604,11 +2604,11 @@ discard block |
||
| 2604 | 2604 | //db::debugmode(true); |
| 2605 | 2605 | $userKey = DB::queryFirstRow( |
| 2606 | 2606 | 'SELECT share_key |
| 2607 | - FROM ' . prefixTable('sharekeys_fields') . ' |
|
| 2607 | + FROM ' . prefixTable('sharekeys_fields').' |
|
| 2608 | 2608 | WHERE user_id = %i AND object_id = %i', |
| 2609 | 2609 | $_SESSION['user_id'], |
| 2610 | 2610 | $row['id'] |
| 2611 | - );//db::debugmode(false); |
|
| 2611 | + ); //db::debugmode(false); |
|
| 2612 | 2612 | if (DB::count() === 0) { |
| 2613 | 2613 | // Not encrypted |
| 2614 | 2614 | $fieldText['string'] = $row['data']; |
@@ -2649,7 +2649,7 @@ discard block |
||
| 2649 | 2649 | if (isset($SETTINGS['item_creation_templates']) && $SETTINGS['item_creation_templates'] === '1') { |
| 2650 | 2650 | $rows_tmp = DB::queryfirstrow( |
| 2651 | 2651 | 'SELECT category_id |
| 2652 | - FROM ' . prefixTable('templates') . ' |
|
| 2652 | + FROM ' . prefixTable('templates').' |
|
| 2653 | 2653 | WHERE item_id = %i', |
| 2654 | 2654 | $post_id |
| 2655 | 2655 | ); |
@@ -2674,7 +2674,7 @@ discard block |
||
| 2674 | 2674 | // Is the Item to be deleted? |
| 2675 | 2675 | $dataDelete = DB::queryfirstrow( |
| 2676 | 2676 | 'SELECT * |
| 2677 | - FROM ' . prefixTable('automatic_del') . ' |
|
| 2677 | + FROM ' . prefixTable('automatic_del').' |
|
| 2678 | 2678 | WHERE item_id = %i', |
| 2679 | 2679 | $post_id |
| 2680 | 2680 | ); |
@@ -2756,11 +2756,11 @@ discard block |
||
| 2756 | 2756 | if (empty($dataItem['restricted_to']) === false) { |
| 2757 | 2757 | foreach (explode(';', $dataItem['restricted_to']) as $userRest) { |
| 2758 | 2758 | if (empty($userRest) === false) { |
| 2759 | - $dataTmp = DB::queryfirstrow('SELECT login FROM ' . prefixTable('users') . ' WHERE id= ' . $userRest); |
|
| 2759 | + $dataTmp = DB::queryfirstrow('SELECT login FROM '.prefixTable('users').' WHERE id= '.$userRest); |
|
| 2760 | 2760 | if (empty($listOfRestricted)) { |
| 2761 | 2761 | $listOfRestricted = $dataTmp['login']; |
| 2762 | 2762 | } else { |
| 2763 | - $listOfRestricted .= ';' . $dataTmp['login']; |
|
| 2763 | + $listOfRestricted .= ';'.$dataTmp['login']; |
|
| 2764 | 2764 | } |
| 2765 | 2765 | } |
| 2766 | 2766 | } |
@@ -2816,8 +2816,8 @@ discard block |
||
| 2816 | 2816 | // Load item data |
| 2817 | 2817 | $dataItem = DB::queryFirstRow( |
| 2818 | 2818 | 'SELECT i.*, n.title AS folder_title |
| 2819 | - FROM ' . prefixTable('items') . ' AS i |
|
| 2820 | - INNER JOIN ' . prefixTable('nested_tree') . ' AS n ON (i.id_tree = n.id) |
|
| 2819 | + FROM ' . prefixTable('items').' AS i |
|
| 2820 | + INNER JOIN ' . prefixTable('nested_tree').' AS n ON (i.id_tree = n.id) |
|
| 2821 | 2821 | WHERE i.id = %i', |
| 2822 | 2822 | $post_id |
| 2823 | 2823 | ); |
@@ -2839,7 +2839,7 @@ discard block |
||
| 2839 | 2839 | // Check if user has a role that is accepted |
| 2840 | 2840 | $rows_tmp = DB::query( |
| 2841 | 2841 | 'SELECT role_id |
| 2842 | - FROM ' . prefixTable('restriction_to_roles') . ' |
|
| 2842 | + FROM ' . prefixTable('restriction_to_roles').' |
|
| 2843 | 2843 | WHERE item_id=%i', |
| 2844 | 2844 | $post_id |
| 2845 | 2845 | ); |
@@ -2885,7 +2885,7 @@ discard block |
||
| 2885 | 2885 | // launch query |
| 2886 | 2886 | $rows = DB::query( |
| 2887 | 2887 | 'SELECT id, name, file, extension, size |
| 2888 | - FROM ' . prefixTable('files') . ' |
|
| 2888 | + FROM ' . prefixTable('files').' |
|
| 2889 | 2889 | WHERE id_item = %i AND confirmed = 1', |
| 2890 | 2890 | $post_id |
| 2891 | 2891 | ); |
@@ -2894,7 +2894,7 @@ discard block |
||
| 2894 | 2894 | $attachments, |
| 2895 | 2895 | array( |
| 2896 | 2896 | 'icon' => fileFormatImage(strtolower($record['extension'])), |
| 2897 | - 'filename' => basename($record['name'], '.' . $record['extension']), |
|
| 2897 | + 'filename' => basename($record['name'], '.'.$record['extension']), |
|
| 2898 | 2898 | 'extension' => $record['extension'], |
| 2899 | 2899 | 'size' => formatSizeUnits($record['size']), |
| 2900 | 2900 | 'is_image' => in_array(strtolower($record['extension']), TP_IMAGE_FILE_EXT) === true ? 1 : 0, |
@@ -2923,7 +2923,7 @@ discard block |
||
| 2923 | 2923 | array( |
| 2924 | 2924 | 'latest_items' => implode(';', $_SESSION['latest_items']), |
| 2925 | 2925 | ), |
| 2926 | - 'id=' . $_SESSION['user_id'] |
|
| 2926 | + 'id='.$_SESSION['user_id'] |
|
| 2927 | 2927 | ); |
| 2928 | 2928 | } |
| 2929 | 2929 | |
@@ -2932,8 +2932,8 @@ discard block |
||
| 2932 | 2932 | $listOptionsForRoles = array(); |
| 2933 | 2933 | $rows = DB::query( |
| 2934 | 2934 | 'SELECT r.role_id AS role_id, t.title AS title |
| 2935 | - FROM ' . prefixTable('roles_values') . ' AS r |
|
| 2936 | - INNER JOIN ' . prefixTable('roles_title') . ' AS t ON (r.role_id = t.id) |
|
| 2935 | + FROM ' . prefixTable('roles_values').' AS r |
|
| 2936 | + INNER JOIN ' . prefixTable('roles_title').' AS t ON (r.role_id = t.id) |
|
| 2937 | 2937 | WHERE r.folder_id = %i', |
| 2938 | 2938 | $dataItem['id_tree'] |
| 2939 | 2939 | ); |
@@ -2947,9 +2947,9 @@ discard block |
||
| 2947 | 2947 | ); |
| 2948 | 2948 | $rows2 = DB::query( |
| 2949 | 2949 | 'SELECT id, login, fonction_id, email, name, lastname |
| 2950 | - FROM ' . prefixTable('users') . ' |
|
| 2950 | + FROM ' . prefixTable('users').' |
|
| 2951 | 2951 | WHERE fonction_id LIKE %s', |
| 2952 | - '%' . $record['role_id'] . '%' |
|
| 2952 | + '%'.$record['role_id'].'%' |
|
| 2953 | 2953 | ); |
| 2954 | 2954 | foreach ($rows2 as $record2) { |
| 2955 | 2955 | foreach (explode(';', $record2['fonction_id']) as $role) { |
@@ -2962,7 +2962,7 @@ discard block |
||
| 2962 | 2962 | array( |
| 2963 | 2963 | 'id' => (int) $record2['id'], |
| 2964 | 2964 | 'login' => $record2['login'], |
| 2965 | - 'name' => $record2['name'] . ' ' . $record2['lastname'], |
|
| 2965 | + 'name' => $record2['name'].' '.$record2['lastname'], |
|
| 2966 | 2966 | 'email' => $record2['email'], |
| 2967 | 2967 | ) |
| 2968 | 2968 | ); |
@@ -2981,16 +2981,16 @@ discard block |
||
| 2981 | 2981 | $path = ''; |
| 2982 | 2982 | foreach ($arbo as $elem) { |
| 2983 | 2983 | if (empty($path) === true) { |
| 2984 | - $path = htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES) . ' '; |
|
| 2984 | + $path = htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES).' '; |
|
| 2985 | 2985 | } else { |
| 2986 | - $path .= '→ ' . htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES); |
|
| 2986 | + $path .= '→ '.htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES); |
|
| 2987 | 2987 | } |
| 2988 | 2988 | } |
| 2989 | 2989 | // Build text to show user |
| 2990 | 2990 | if (empty($path) === true) { |
| 2991 | 2991 | $path = addslashes($dataItem['label']); |
| 2992 | 2992 | } else { |
| 2993 | - $path = addslashes($dataItem['label']) . ' (' . $path . ')'; |
|
| 2993 | + $path = addslashes($dataItem['label']).' ('.$path.')'; |
|
| 2994 | 2994 | } |
| 2995 | 2995 | |
| 2996 | 2996 | // send back infos |
@@ -3004,7 +3004,7 @@ discard block |
||
| 3004 | 3004 | array( |
| 3005 | 3005 | addslashes($_SESSION['login']), |
| 3006 | 3006 | $path, |
| 3007 | - $SETTINGS['cpassman_url'] . '/index.php?page=items&group=' . $dataItem['id_tree'] . '&id=' . $dataItem['id'], |
|
| 3007 | + $SETTINGS['cpassman_url'].'/index.php?page=items&group='.$dataItem['id_tree'].'&id='.$dataItem['id'], |
|
| 3008 | 3008 | ), |
| 3009 | 3009 | langHdl('email_on_open_notification_mail') |
| 3010 | 3010 | ), |
@@ -3015,7 +3015,7 @@ discard block |
||
| 3015 | 3015 | } |
| 3016 | 3016 | |
| 3017 | 3017 | // has this item a change proposal |
| 3018 | - DB::query('SELECT * FROM ' . prefixTable('items_change') . ' WHERE item_id = %i', $post_id); |
|
| 3018 | + DB::query('SELECT * FROM '.prefixTable('items_change').' WHERE item_id = %i', $post_id); |
|
| 3019 | 3019 | $returnArray['has_change_proposal'] = DB::count(); |
| 3020 | 3020 | |
| 3021 | 3021 | // Setting |
@@ -3105,7 +3105,7 @@ discard block |
||
| 3105 | 3105 | // Load item data |
| 3106 | 3106 | $data = DB::queryFirstRow( |
| 3107 | 3107 | 'SELECT id_tree |
| 3108 | - FROM ' . prefixTable('items') . ' |
|
| 3108 | + FROM ' . prefixTable('items').' |
|
| 3109 | 3109 | WHERE id = %i', |
| 3110 | 3110 | $post_item_id |
| 3111 | 3111 | ); |
@@ -3174,13 +3174,13 @@ discard block |
||
| 3174 | 3174 | |
| 3175 | 3175 | // Check if user is allowed to access this folder |
| 3176 | 3176 | if (!in_array($post_folder_id, $_SESSION['groupes_visibles'])) { |
| 3177 | - echo '[{"error" : "' . langHdl('error_not_allowed_to') . '"}]'; |
|
| 3177 | + echo '[{"error" : "'.langHdl('error_not_allowed_to').'"}]'; |
|
| 3178 | 3178 | break; |
| 3179 | 3179 | } |
| 3180 | 3180 | |
| 3181 | 3181 | // Check if title doesn't contains html codes |
| 3182 | 3182 | if (preg_match_all('|<[^>]+>(.*)</[^>]+>|U', $title, $out)) { |
| 3183 | - echo '[ { "error" : "' . langHdl('error_html_codes') . '" } ]'; |
|
| 3183 | + echo '[ { "error" : "'.langHdl('error_html_codes').'" } ]'; |
|
| 3184 | 3184 | break; |
| 3185 | 3185 | } |
| 3186 | 3186 | // check that title is not numeric |
@@ -3192,9 +3192,9 @@ discard block |
||
| 3192 | 3192 | // Check if duplicate folders name are allowed |
| 3193 | 3193 | $createNewFolder = true; |
| 3194 | 3194 | if (isset($SETTINGS['duplicate_folder']) && $SETTINGS['duplicate_folder'] === '0') { |
| 3195 | - $data = DB::queryFirstRow('SELECT id, title FROM ' . prefixTable('nested_tree') . ' WHERE title = %s', $title); |
|
| 3195 | + $data = DB::queryFirstRow('SELECT id, title FROM '.prefixTable('nested_tree').' WHERE title = %s', $title); |
|
| 3196 | 3196 | if (empty($data['id']) === false && $dataReceived['folder'] != $data['id']) { |
| 3197 | - echo '[ { "error" : "' . langHdl('error_group_exist') . '" } ]'; |
|
| 3197 | + echo '[ { "error" : "'.langHdl('error_group_exist').'" } ]'; |
|
| 3198 | 3198 | break; |
| 3199 | 3199 | } |
| 3200 | 3200 | } |
@@ -3202,7 +3202,7 @@ discard block |
||
| 3202 | 3202 | // query on folder |
| 3203 | 3203 | $data = DB::queryfirstrow( |
| 3204 | 3204 | 'SELECT parent_id, personal_folder |
| 3205 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 3205 | + FROM ' . prefixTable('nested_tree').' |
|
| 3206 | 3206 | WHERE id = %i', |
| 3207 | 3207 | $post_folder_id |
| 3208 | 3208 | ); |
@@ -3212,20 +3212,20 @@ discard block |
||
| 3212 | 3212 | if ($_SESSION['is_admin'] != 1 && $_SESSION['user_manager'] != 1 && $data['personal_folder'] === '0') { |
| 3213 | 3213 | $data = DB::queryfirstrow( |
| 3214 | 3214 | 'SELECT valeur |
| 3215 | - FROM ' . prefixTable('misc') . ' |
|
| 3215 | + FROM ' . prefixTable('misc').' |
|
| 3216 | 3216 | WHERE intitule = %i AND type = %s', |
| 3217 | 3217 | $data['parent_id'], |
| 3218 | 3218 | 'complex' |
| 3219 | 3219 | ); |
| 3220 | 3220 | if (intval($dataReceived['complexity']) < intval($data['valeur'])) { |
| 3221 | - echo '[ { "error" : "' . langHdl('error_folder_complexity_lower_than_top_folder') . ' [<b>' . TP_PW_COMPLEXITY[$data['valeur']][1] . '</b>]"} ]'; |
|
| 3221 | + echo '[ { "error" : "'.langHdl('error_folder_complexity_lower_than_top_folder').' [<b>'.TP_PW_COMPLEXITY[$data['valeur']][1].'</b>]"} ]'; |
|
| 3222 | 3222 | break; |
| 3223 | 3223 | } |
| 3224 | 3224 | } |
| 3225 | 3225 | |
| 3226 | 3226 | // update Folders table |
| 3227 | 3227 | $tmp = DB::queryFirstRow( |
| 3228 | - 'SELECT title, parent_id, personal_folder FROM ' . prefixTable('nested_tree') . ' WHERE id = %i', |
|
| 3228 | + 'SELECT title, parent_id, personal_folder FROM '.prefixTable('nested_tree').' WHERE id = %i', |
|
| 3229 | 3229 | $dataReceived['folder'] |
| 3230 | 3230 | ); |
| 3231 | 3231 | if ($tmp['parent_id'] != 0 || $tmp['title'] != $_SESSION['user_id'] || $tmp['personal_folder'] != 1) { |
@@ -3289,42 +3289,42 @@ discard block |
||
| 3289 | 3289 | in_array($post_target_folder_id, $_SESSION['groupes_visibles']) === false) && ($post_target_folder_id === '0' && |
| 3290 | 3290 | isset($SETTINGS['can_create_root_folder']) === true && $SETTINGS['can_create_root_folder'] === '1') |
| 3291 | 3291 | ) { |
| 3292 | - $returnValues = '[{"error" : "' . langHdl('error_not_allowed_to') . '"}]'; |
|
| 3292 | + $returnValues = '[{"error" : "'.langHdl('error_not_allowed_to').'"}]'; |
|
| 3293 | 3293 | echo $returnValues; |
| 3294 | 3294 | break; |
| 3295 | 3295 | } |
| 3296 | 3296 | |
| 3297 | 3297 | $tmp_source = DB::queryFirstRow( |
| 3298 | 3298 | 'SELECT title, parent_id, personal_folder |
| 3299 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 3299 | + FROM ' . prefixTable('nested_tree').' |
|
| 3300 | 3300 | WHERE id = %i', |
| 3301 | 3301 | $post_source_folder_id |
| 3302 | 3302 | ); |
| 3303 | 3303 | |
| 3304 | 3304 | $tmp_target = DB::queryFirstRow( |
| 3305 | 3305 | 'SELECT title, parent_id, personal_folder |
| 3306 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 3306 | + FROM ' . prefixTable('nested_tree').' |
|
| 3307 | 3307 | WHERE id = %i', |
| 3308 | 3308 | $post_target_folder_id |
| 3309 | 3309 | ); |
| 3310 | 3310 | |
| 3311 | 3311 | // check if target is not a child of source |
| 3312 | 3312 | if ($tree->isChildOf($post_target_folder_id, $post_source_folder_id) === true) { |
| 3313 | - $returnValues = '[{"error" : "' . langHdl('error_not_allowed_to') . '"}]'; |
|
| 3313 | + $returnValues = '[{"error" : "'.langHdl('error_not_allowed_to').'"}]'; |
|
| 3314 | 3314 | echo $returnValues; |
| 3315 | 3315 | break; |
| 3316 | 3316 | } |
| 3317 | 3317 | |
| 3318 | 3318 | // check if source or target folder is PF. If Yes, then cancel operation |
| 3319 | 3319 | if ($tmp_source['personal_folder'] === '1' || $tmp_target['personal_folder'] === '1') { |
| 3320 | - $returnValues = '[{"error" : "' . langHdl('error_not_allowed_to') . '"}]'; |
|
| 3320 | + $returnValues = '[{"error" : "'.langHdl('error_not_allowed_to').'"}]'; |
|
| 3321 | 3321 | echo $returnValues; |
| 3322 | 3322 | break; |
| 3323 | 3323 | } |
| 3324 | 3324 | |
| 3325 | 3325 | // check if source or target folder is PF. If Yes, then cancel operation |
| 3326 | 3326 | if ($tmp_source['title'] === $_SESSION['user_id'] || $tmp_target['title'] === $_SESSION['user_id']) { |
| 3327 | - $returnValues = '[{"error" : "' . langHdl('error_not_allowed_to') . '"}]'; |
|
| 3327 | + $returnValues = '[{"error" : "'.langHdl('error_not_allowed_to').'"}]'; |
|
| 3328 | 3328 | echo $returnValues; |
| 3329 | 3329 | break; |
| 3330 | 3330 | } |
@@ -3447,7 +3447,7 @@ discard block |
||
| 3447 | 3447 | foreach ($_SESSION['user_roles'] as $role) { |
| 3448 | 3448 | $roleQ = DB::queryfirstrow( |
| 3449 | 3449 | 'SELECT allow_pw_change |
| 3450 | - FROM ' . prefixTable('roles_title') . ' |
|
| 3450 | + FROM ' . prefixTable('roles_title').' |
|
| 3451 | 3451 | WHERE id = %i', |
| 3452 | 3452 | $role |
| 3453 | 3453 | ); |
@@ -3473,12 +3473,12 @@ discard block |
||
| 3473 | 3473 | foreach ($_SESSION['user_roles'] as $role) { |
| 3474 | 3474 | //db::debugmode(true); |
| 3475 | 3475 | $access = DB::queryFirstRow( |
| 3476 | - 'SELECT type FROM ' . prefixTable('roles_values') . ' WHERE role_id = %i AND folder_id = %i', |
|
| 3476 | + 'SELECT type FROM '.prefixTable('roles_values').' WHERE role_id = %i AND folder_id = %i', |
|
| 3477 | 3477 | $role, |
| 3478 | 3478 | $post_id |
| 3479 | 3479 | ); |
| 3480 | 3480 | //db::debugmode(false);exit(); |
| 3481 | - if (DB::count()>0) { |
|
| 3481 | + if (DB::count() > 0) { |
|
| 3482 | 3482 | if ($access['type'] === 'R') { |
| 3483 | 3483 | array_push($arrTmp, 10); |
| 3484 | 3484 | } elseif ($access['type'] === 'W') { |
@@ -3542,7 +3542,7 @@ discard block |
||
| 3542 | 3542 | } else { |
| 3543 | 3543 | DB::query( |
| 3544 | 3544 | 'SELECT * |
| 3545 | - FROM ' . prefixTable('items') . ' |
|
| 3545 | + FROM ' . prefixTable('items').' |
|
| 3546 | 3546 | WHERE inactif = %i', |
| 3547 | 3547 | 0 |
| 3548 | 3548 | ); |
@@ -3553,7 +3553,7 @@ discard block |
||
| 3553 | 3553 | |
| 3554 | 3554 | // Get folder complexity |
| 3555 | 3555 | $folderComplexity = DB::queryFirstRow( |
| 3556 | - 'SELECT valeur FROM ' . prefixTable('misc') . ' WHERE type = %s AND intitule = %i', |
|
| 3556 | + 'SELECT valeur FROM '.prefixTable('misc').' WHERE type = %s AND intitule = %i', |
|
| 3557 | 3557 | 'complex', |
| 3558 | 3558 | $post_id |
| 3559 | 3559 | ); |
@@ -3565,7 +3565,7 @@ discard block |
||
| 3565 | 3565 | if (isset($SETTINGS['item_extra_fields']) && $SETTINGS['item_extra_fields'] === '1') { |
| 3566 | 3566 | $folderRow = DB::query( |
| 3567 | 3567 | 'SELECT id_category |
| 3568 | - FROM ' . prefixTable('categories_folders') . ' |
|
| 3568 | + FROM ' . prefixTable('categories_folders').' |
|
| 3569 | 3569 | WHERE id_folder = %i', |
| 3570 | 3570 | $post_id |
| 3571 | 3571 | ); |
@@ -3682,13 +3682,13 @@ discard block |
||
| 3682 | 3682 | // List all ITEMS |
| 3683 | 3683 | if ($folderIsPf === false) { |
| 3684 | 3684 | $where->add('i.inactif=%i', 0); |
| 3685 | - $where->add('l.date=%l', '(SELECT date FROM ' . prefixTable('log_items') . " WHERE action IN ('at_creation', 'at_modification') AND id_item=i.id ORDER BY date DESC LIMIT 1)"); |
|
| 3685 | + $where->add('l.date=%l', '(SELECT date FROM '.prefixTable('log_items')." WHERE action IN ('at_creation', 'at_modification') AND id_item=i.id ORDER BY date DESC LIMIT 1)"); |
|
| 3686 | 3686 | if (empty($limited_to_items) === false) { |
| 3687 | 3687 | $where->add('i.id IN %ls', explode(',', $limited_to_items)); |
| 3688 | 3688 | } |
| 3689 | 3689 | |
| 3690 | - $query_limit = ' LIMIT ' . |
|
| 3691 | - $start . ',' . |
|
| 3690 | + $query_limit = ' LIMIT '. |
|
| 3691 | + $start.','. |
|
| 3692 | 3692 | $post_nb_items_to_display_once; |
| 3693 | 3693 | //db::debugmode(true); |
| 3694 | 3694 | $rows = DB::query( |
@@ -3699,9 +3699,9 @@ discard block |
||
| 3699 | 3699 | MIN(l.action) AS log_action, |
| 3700 | 3700 | l.id_user AS log_user, |
| 3701 | 3701 | i.url AS link |
| 3702 | - FROM ' . prefixTable('items') . ' AS i |
|
| 3703 | - INNER JOIN ' . prefixTable('nested_tree') . ' AS n ON (i.id_tree = n.id) |
|
| 3704 | - INNER JOIN ' . prefixTable('log_items') . ' AS l ON (i.id = l.id_item) |
|
| 3702 | + FROM ' . prefixTable('items').' AS i |
|
| 3703 | + INNER JOIN ' . prefixTable('nested_tree').' AS n ON (i.id_tree = n.id) |
|
| 3704 | + INNER JOIN ' . prefixTable('log_items').' AS l ON (i.id = l.id_item) |
|
| 3705 | 3705 | WHERE %l |
| 3706 | 3706 | GROUP BY i.id, l.date, l.id_user, l.action |
| 3707 | 3707 | ORDER BY i.label ASC, l.date DESC' . $query_limit, |
@@ -3720,9 +3720,9 @@ discard block |
||
| 3720 | 3720 | MIN(l.action) AS log_action, |
| 3721 | 3721 | l.id_user AS log_user, |
| 3722 | 3722 | i.url AS link |
| 3723 | - FROM ' . prefixTable('items') . ' AS i |
|
| 3724 | - INNER JOIN ' . prefixTable('nested_tree') . ' AS n ON (i.id_tree = n.id) |
|
| 3725 | - INNER JOIN ' . prefixTable('log_items') . ' AS l ON (i.id = l.id_item) |
|
| 3723 | + FROM ' . prefixTable('items').' AS i |
|
| 3724 | + INNER JOIN ' . prefixTable('nested_tree').' AS n ON (i.id_tree = n.id) |
|
| 3725 | + INNER JOIN ' . prefixTable('log_items').' AS l ON (i.id = l.id_item) |
|
| 3726 | 3726 | WHERE %l |
| 3727 | 3727 | GROUP BY i.id, l.date, l.id_user, l.action |
| 3728 | 3728 | ORDER BY i.label ASC, l.date DESC', |
@@ -3754,7 +3754,7 @@ discard block |
||
| 3754 | 3754 | $item_is_restricted_to_role = false; |
| 3755 | 3755 | DB::queryfirstrow( |
| 3756 | 3756 | 'SELECT role_id |
| 3757 | - FROM ' . prefixTable('restriction_to_roles') . ' |
|
| 3757 | + FROM ' . prefixTable('restriction_to_roles').' |
|
| 3758 | 3758 | WHERE item_id = %i', |
| 3759 | 3759 | $record['id'] |
| 3760 | 3760 | ); |
@@ -3766,7 +3766,7 @@ discard block |
||
| 3766 | 3766 | $user_is_included_in_role = false; |
| 3767 | 3767 | $roles = DB::query( |
| 3768 | 3768 | 'SELECT role_id |
| 3769 | - FROM ' . prefixTable('restriction_to_roles') . ' |
|
| 3769 | + FROM ' . prefixTable('restriction_to_roles').' |
|
| 3770 | 3770 | WHERE item_id = %i AND role_id IN %ls', |
| 3771 | 3771 | $record['id'], |
| 3772 | 3772 | $_SESSION['user_roles'] |
@@ -3974,9 +3974,9 @@ discard block |
||
| 3974 | 3974 | if ((int) $start === 0) { |
| 3975 | 3975 | DB::query( |
| 3976 | 3976 | 'SELECT i.id |
| 3977 | - FROM ' . prefixTable('items') . ' as i |
|
| 3978 | - INNER JOIN ' . prefixTable('nested_tree') . ' as n ON (i.id_tree = n.id) |
|
| 3979 | - INNER JOIN ' . prefixTable('log_items') . ' as l ON (i.id = l.id_item) |
|
| 3977 | + FROM ' . prefixTable('items').' as i |
|
| 3978 | + INNER JOIN ' . prefixTable('nested_tree').' as n ON (i.id_tree = n.id) |
|
| 3979 | + INNER JOIN ' . prefixTable('log_items').' as l ON (i.id = l.id_item) |
|
| 3980 | 3980 | WHERE %l |
| 3981 | 3981 | ORDER BY i.label ASC, l.date DESC', |
| 3982 | 3982 | $where |
@@ -4044,8 +4044,8 @@ discard block |
||
| 4044 | 4044 | // Run query |
| 4045 | 4045 | $dataItem = DB::queryfirstrow( |
| 4046 | 4046 | 'SELECT i.pw AS pw, s.share_key AS share_key |
| 4047 | - FROM ' . prefixTable('items') . ' AS i |
|
| 4048 | - INNER JOIN ' . prefixTable('sharekeys_items') . ' AS s ON (s.object_id = i.id) |
|
| 4047 | + FROM ' . prefixTable('items').' AS i |
|
| 4048 | + INNER JOIN ' . prefixTable('sharekeys_items').' AS s ON (s.object_id = i.id) |
|
| 4049 | 4049 | WHERE user_id = %i AND i.id = %i', |
| 4050 | 4050 | $_SESSION['user_id'], |
| 4051 | 4051 | $post_item_id |
@@ -4088,7 +4088,7 @@ discard block |
||
| 4088 | 4088 | if (null !== $post_item_id && empty($post_item_id) === false) { |
| 4089 | 4089 | $dataItem = DB::queryfirstrow( |
| 4090 | 4090 | 'SELECT perso, anyone_can_modify |
| 4091 | - FROM ' . prefixTable('items') . ' |
|
| 4091 | + FROM ' . prefixTable('items').' |
|
| 4092 | 4092 | WHERE id=%i', |
| 4093 | 4093 | $post_item_id |
| 4094 | 4094 | ); |
@@ -4123,7 +4123,7 @@ discard block |
||
| 4123 | 4123 | } |
| 4124 | 4124 | |
| 4125 | 4125 | // Lock Item (if already locked), go back and warn |
| 4126 | - $dataTmp = DB::queryFirstRow('SELECT timestamp, user_id FROM ' . prefixTable('items_edition') . ' WHERE item_id = %i', $post_item_id); |
|
| 4126 | + $dataTmp = DB::queryFirstRow('SELECT timestamp, user_id FROM '.prefixTable('items_edition').' WHERE item_id = %i', $post_item_id); |
|
| 4127 | 4127 | |
| 4128 | 4128 | // If token is taken for this Item and delay is passed then delete it. |
| 4129 | 4129 | if ( |
@@ -4134,7 +4134,7 @@ discard block |
||
| 4134 | 4134 | DB::delete(prefixTable('items_edition'), 'item_id = %i', $post_item_id); |
| 4135 | 4135 | //reload the previous data |
| 4136 | 4136 | $dataTmp = DB::queryFirstRow( |
| 4137 | - 'SELECT timestamp, user_id FROM ' . prefixTable('items_edition') . ' WHERE item_id = %i', |
|
| 4137 | + 'SELECT timestamp, user_id FROM '.prefixTable('items_edition').' WHERE item_id = %i', |
|
| 4138 | 4138 | $post_item_id |
| 4139 | 4139 | ); |
| 4140 | 4140 | } |
@@ -4174,7 +4174,7 @@ discard block |
||
| 4174 | 4174 | // do query on this folder |
| 4175 | 4175 | $data_this_folder = DB::queryFirstRow( |
| 4176 | 4176 | 'SELECT id, personal_folder, title |
| 4177 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 4177 | + FROM ' . prefixTable('nested_tree').' |
|
| 4178 | 4178 | WHERE id = %s', |
| 4179 | 4179 | $post_groupe |
| 4180 | 4180 | ); |
@@ -4211,8 +4211,8 @@ discard block |
||
| 4211 | 4211 | $visibilite = ''; |
| 4212 | 4212 | $data = DB::queryFirstRow( |
| 4213 | 4213 | 'SELECT m.valeur, n.personal_folder |
| 4214 | - FROM ' . prefixTable('misc') . ' AS m |
|
| 4215 | - INNER JOIN ' . prefixTable('nested_tree') . ' AS n ON (m.intitule = n.id) |
|
| 4214 | + FROM ' . prefixTable('misc').' AS m |
|
| 4215 | + INNER JOIN ' . prefixTable('nested_tree').' AS n ON (m.intitule = n.id) |
|
| 4216 | 4216 | WHERE type=%s AND intitule = %s', |
| 4217 | 4217 | 'complex', |
| 4218 | 4218 | $post_groupe |
@@ -4225,8 +4225,8 @@ discard block |
||
| 4225 | 4225 | // Prepare Item actual visibility (what Users/Roles can see it) |
| 4226 | 4226 | $rows = DB::query( |
| 4227 | 4227 | 'SELECT t.title |
| 4228 | - FROM ' . prefixTable('roles_values') . ' as v |
|
| 4229 | - INNER JOIN ' . prefixTable('roles_title') . ' as t ON (v.role_id = t.id) |
|
| 4228 | + FROM ' . prefixTable('roles_values').' as v |
|
| 4229 | + INNER JOIN ' . prefixTable('roles_title').' as t ON (v.role_id = t.id) |
|
| 4230 | 4230 | WHERE v.folder_id = %i |
| 4231 | 4231 | GROUP BY title', |
| 4232 | 4232 | $post_groupe |
@@ -4235,7 +4235,7 @@ discard block |
||
| 4235 | 4235 | if (empty($visibilite)) { |
| 4236 | 4236 | $visibilite = $record['title']; |
| 4237 | 4237 | } else { |
| 4238 | - $visibilite .= ' - ' . $record['title']; |
|
| 4238 | + $visibilite .= ' - '.$record['title']; |
|
| 4239 | 4239 | } |
| 4240 | 4240 | } |
| 4241 | 4241 | } else { |
@@ -4245,14 +4245,14 @@ discard block |
||
| 4245 | 4245 | // do new query to know if current folder is pf |
| 4246 | 4246 | $data_pf = DB::queryFirstRow( |
| 4247 | 4247 | 'SELECT personal_folder |
| 4248 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 4248 | + FROM ' . prefixTable('nested_tree').' |
|
| 4249 | 4249 | WHERE id = %s', |
| 4250 | 4250 | $post_groupe |
| 4251 | 4251 | ); |
| 4252 | 4252 | |
| 4253 | 4253 | $folder_is_personal = $data_pf !== null ? (int) $data_pf['personal_folder'] : 0; |
| 4254 | 4254 | |
| 4255 | - $visibilite = $_SESSION['name'] . ' ' . $_SESSION['lastname'] . ' (' . $_SESSION['login'] . ')'; |
|
| 4255 | + $visibilite = $_SESSION['name'].' '.$_SESSION['lastname'].' ('.$_SESSION['login'].')'; |
|
| 4256 | 4256 | } |
| 4257 | 4257 | |
| 4258 | 4258 | recupDroitCreationSansComplexite($post_groupe); |
@@ -4262,8 +4262,8 @@ discard block |
||
| 4262 | 4262 | $listOptionsForRoles = array(); |
| 4263 | 4263 | $rows = DB::query( |
| 4264 | 4264 | 'SELECT r.role_id AS role_id, t.title AS title |
| 4265 | - FROM ' . prefixTable('roles_values') . ' AS r |
|
| 4266 | - INNER JOIN ' . prefixTable('roles_title') . ' AS t ON (r.role_id = t.id) |
|
| 4265 | + FROM ' . prefixTable('roles_values').' AS r |
|
| 4266 | + INNER JOIN ' . prefixTable('roles_title').' AS t ON (r.role_id = t.id) |
|
| 4267 | 4267 | WHERE r.folder_id = %i', |
| 4268 | 4268 | $post_groupe |
| 4269 | 4269 | ); |
@@ -4277,7 +4277,7 @@ discard block |
||
| 4277 | 4277 | ); |
| 4278 | 4278 | $rows2 = DB::query( |
| 4279 | 4279 | 'SELECT id, login, fonction_id, email, name, lastname |
| 4280 | - FROM ' . prefixTable('users') . ' |
|
| 4280 | + FROM ' . prefixTable('users').' |
|
| 4281 | 4281 | WHERE admin = 0' |
| 4282 | 4282 | ); |
| 4283 | 4283 | foreach ($rows2 as $record2) { |
@@ -4291,7 +4291,7 @@ discard block |
||
| 4291 | 4291 | array( |
| 4292 | 4292 | 'id' => $record2['id'], |
| 4293 | 4293 | 'login' => $record2['login'], |
| 4294 | - 'name' => $record2['name'] . ' ' . $record2['lastname'], |
|
| 4294 | + 'name' => $record2['name'].' '.$record2['lastname'], |
|
| 4295 | 4295 | 'email' => $record2['email'], |
| 4296 | 4296 | ) |
| 4297 | 4297 | ); |
@@ -4308,13 +4308,13 @@ discard block |
||
| 4308 | 4308 | //db::debugmode(true); |
| 4309 | 4309 | $access = DB::queryFirstRow( |
| 4310 | 4310 | 'SELECT type |
| 4311 | - FROM ' . prefixTable('roles_values') . ' |
|
| 4311 | + FROM ' . prefixTable('roles_values').' |
|
| 4312 | 4312 | WHERE role_id = %i AND folder_id = %i', |
| 4313 | 4313 | $role, |
| 4314 | 4314 | $post_groupe |
| 4315 | 4315 | ); |
| 4316 | 4316 | //db::debugmode(false); |
| 4317 | - if (DB::count()>0) { |
|
| 4317 | + if (DB::count() > 0) { |
|
| 4318 | 4318 | if ($access['type'] === 'R') { |
| 4319 | 4319 | array_push($arrTmp, 10); |
| 4320 | 4320 | } elseif ($access['type'] === 'W') { |
@@ -4384,7 +4384,7 @@ discard block |
||
| 4384 | 4384 | // Get some info before deleting |
| 4385 | 4385 | $data = DB::queryFirstRow( |
| 4386 | 4386 | 'SELECT name, id_item, file |
| 4387 | - FROM ' . prefixTable('files') . ' |
|
| 4387 | + FROM ' . prefixTable('files').' |
|
| 4388 | 4388 | WHERE id = %i', |
| 4389 | 4389 | $fileId |
| 4390 | 4390 | ); |
@@ -4392,7 +4392,7 @@ discard block |
||
| 4392 | 4392 | // Load item data |
| 4393 | 4393 | $data_item = DB::queryFirstRow( |
| 4394 | 4394 | 'SELECT id_tree |
| 4395 | - FROM ' . prefixTable('items') . ' |
|
| 4395 | + FROM ' . prefixTable('items').' |
|
| 4396 | 4396 | WHERE id = %i', |
| 4397 | 4397 | $data['id_item'] |
| 4398 | 4398 | ); |
@@ -4419,7 +4419,7 @@ discard block |
||
| 4419 | 4419 | $_SESSION['user_id'], |
| 4420 | 4420 | 'at_modification', |
| 4421 | 4421 | $_SESSION['login'], |
| 4422 | - 'at_del_file : ' . $data['name'] |
|
| 4422 | + 'at_del_file : '.$data['name'] |
|
| 4423 | 4423 | ); |
| 4424 | 4424 | |
| 4425 | 4425 | // DElete sharekeys |
@@ -4430,7 +4430,7 @@ discard block |
||
| 4430 | 4430 | ); |
| 4431 | 4431 | |
| 4432 | 4432 | // Delete file from server |
| 4433 | - fileDelete($SETTINGS['path_to_upload_folder'] . '/' . TP_FILE_PREFIX . base64_decode($data['file']), $SETTINGS); |
|
| 4433 | + fileDelete($SETTINGS['path_to_upload_folder'].'/'.TP_FILE_PREFIX.base64_decode($data['file']), $SETTINGS); |
|
| 4434 | 4434 | } |
| 4435 | 4435 | |
| 4436 | 4436 | echo (string) prepareExchangedData( |
@@ -4449,7 +4449,7 @@ discard block |
||
| 4449 | 4449 | case 'clear_html_tags': |
| 4450 | 4450 | // Get information for this item |
| 4451 | 4451 | $dataItem = DB::queryfirstrow( |
| 4452 | - 'SELECT description FROM ' . prefixTable('items') . ' WHERE id=%i', |
|
| 4452 | + 'SELECT description FROM '.prefixTable('items').' WHERE id=%i', |
|
| 4453 | 4453 | filter_input(INPUT_POST, 'id_item', FILTER_SANITIZE_NUMBER_INT) |
| 4454 | 4454 | ); |
| 4455 | 4455 | // Clean up the string |
@@ -4487,12 +4487,12 @@ discard block |
||
| 4487 | 4487 | // Update SESSION with this new favourite |
| 4488 | 4488 | $data = DB::queryfirstrow( |
| 4489 | 4489 | 'SELECT label,id_tree |
| 4490 | - FROM ' . prefixTable('items') . ' |
|
| 4490 | + FROM ' . prefixTable('items').' |
|
| 4491 | 4491 | WHERE id = ' . mysqli_real_escape_string($link, $post_item_id) |
| 4492 | 4492 | ); |
| 4493 | 4493 | $_SESSION['favourites_tab'][$post_item_id] = array( |
| 4494 | 4494 | 'label' => $data['label'], |
| 4495 | - 'url' => 'index.php?page=items&group=' . $data['id_tree'] . '&id=' . $post_item_id, |
|
| 4495 | + 'url' => 'index.php?page=items&group='.$data['id_tree'].'&id='.$post_item_id, |
|
| 4496 | 4496 | ); |
| 4497 | 4497 | } elseif ((int) filter_input(INPUT_POST, 'action', FILTER_SANITIZE_NUMBER_INT) === 1) { |
| 4498 | 4498 | // delete from session |
@@ -4560,8 +4560,8 @@ discard block |
||
| 4560 | 4560 | // get data about item |
| 4561 | 4561 | $dataSource = DB::queryfirstrow( |
| 4562 | 4562 | 'SELECT i.pw, f.personal_folder,i.id_tree, f.title,i.label |
| 4563 | - FROM ' . prefixTable('items') . ' as i |
|
| 4564 | - INNER JOIN ' . prefixTable('nested_tree') . ' as f ON (i.id_tree=f.id) |
|
| 4563 | + FROM ' . prefixTable('items').' as i |
|
| 4564 | + INNER JOIN ' . prefixTable('nested_tree').' as f ON (i.id_tree=f.id) |
|
| 4565 | 4565 | WHERE i.id=%i', |
| 4566 | 4566 | $post_item_id |
| 4567 | 4567 | ); |
@@ -4569,7 +4569,7 @@ discard block |
||
| 4569 | 4569 | // get data about new folder |
| 4570 | 4570 | $dataDestination = DB::queryfirstrow( |
| 4571 | 4571 | 'SELECT personal_folder, title |
| 4572 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 4572 | + FROM ' . prefixTable('nested_tree').' |
|
| 4573 | 4573 | WHERE id = %i', |
| 4574 | 4574 | $post_folder_id |
| 4575 | 4575 | ); |
@@ -4621,7 +4621,7 @@ discard block |
||
| 4621 | 4621 | // Get fields for this Item |
| 4622 | 4622 | $rows = DB::query( |
| 4623 | 4623 | 'SELECT id |
| 4624 | - FROM ' . prefixTable('categories_items') . ' |
|
| 4624 | + FROM ' . prefixTable('categories_items').' |
|
| 4625 | 4625 | WHERE item_id = %i', |
| 4626 | 4626 | $post_item_id |
| 4627 | 4627 | ); |
@@ -4638,7 +4638,7 @@ discard block |
||
| 4638 | 4638 | // Get FILES for this Item |
| 4639 | 4639 | $rows = DB::query( |
| 4640 | 4640 | 'SELECT id |
| 4641 | - FROM ' . prefixTable('files') . ' |
|
| 4641 | + FROM ' . prefixTable('files').' |
|
| 4642 | 4642 | WHERE id_item = %i', |
| 4643 | 4643 | $post_item_id |
| 4644 | 4644 | ); |
@@ -4683,7 +4683,7 @@ discard block |
||
| 4683 | 4683 | // Get the ITEM object key for the user |
| 4684 | 4684 | $userKey = DB::queryFirstRow( |
| 4685 | 4685 | 'SELECT share_key |
| 4686 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
| 4686 | + FROM ' . prefixTable('sharekeys_items').' |
|
| 4687 | 4687 | WHERE user_id = %i AND object_id = %i', |
| 4688 | 4688 | $_SESSION['user_id'], |
| 4689 | 4689 | $post_item_id |
@@ -4694,8 +4694,8 @@ discard block |
||
| 4694 | 4694 | // This is a public object |
| 4695 | 4695 | $users = DB::query( |
| 4696 | 4696 | 'SELECT id, public_key |
| 4697 | - FROM ' . prefixTable('users') . ' |
|
| 4698 | - WHERE id NOT IN ("' . OTV_USER_ID . '","' . SSH_USER_ID . '","' . API_USER_ID . '","' . $_SESSION['user_id'] . '") |
|
| 4697 | + FROM ' . prefixTable('users').' |
|
| 4698 | + WHERE id NOT IN ("' . OTV_USER_ID.'","'.SSH_USER_ID.'","'.API_USER_ID.'","'.$_SESSION['user_id'].'") |
|
| 4699 | 4699 | AND public_key != ""' |
| 4700 | 4700 | ); |
| 4701 | 4701 | foreach ($users as $user) { |
@@ -4715,14 +4715,14 @@ discard block |
||
| 4715 | 4715 | // Get fields for this Item |
| 4716 | 4716 | $rows = DB::query( |
| 4717 | 4717 | 'SELECT id |
| 4718 | - FROM ' . prefixTable('categories_items') . ' |
|
| 4718 | + FROM ' . prefixTable('categories_items').' |
|
| 4719 | 4719 | WHERE item_id = %i', |
| 4720 | 4720 | $post_item_id |
| 4721 | 4721 | ); |
| 4722 | 4722 | foreach ($rows as $field) { |
| 4723 | 4723 | $userKey = DB::queryFirstRow( |
| 4724 | 4724 | 'SELECT share_key |
| 4725 | - FROM ' . prefixTable('sharekeys_fields') . ' |
|
| 4725 | + FROM ' . prefixTable('sharekeys_fields').' |
|
| 4726 | 4726 | WHERE user_id = %i AND object_id = %i', |
| 4727 | 4727 | $_SESSION['user_id'], |
| 4728 | 4728 | $field['id'] |
@@ -4733,8 +4733,8 @@ discard block |
||
| 4733 | 4733 | // This is a public object |
| 4734 | 4734 | $users = DB::query( |
| 4735 | 4735 | 'SELECT id, public_key |
| 4736 | - FROM ' . prefixTable('users') . ' |
|
| 4737 | - WHERE id NOT IN ("' . OTV_USER_ID . '","' . SSH_USER_ID . '","' . API_USER_ID . '","' . $_SESSION['user_id'] . '") |
|
| 4736 | + FROM ' . prefixTable('users').' |
|
| 4737 | + WHERE id NOT IN ("' . OTV_USER_ID.'","'.SSH_USER_ID.'","'.API_USER_ID.'","'.$_SESSION['user_id'].'") |
|
| 4738 | 4738 | AND public_key != ""' |
| 4739 | 4739 | ); |
| 4740 | 4740 | foreach ($users as $user) { |
@@ -4755,14 +4755,14 @@ discard block |
||
| 4755 | 4755 | // Get FILES for this Item |
| 4756 | 4756 | $rows = DB::query( |
| 4757 | 4757 | 'SELECT id |
| 4758 | - FROM ' . prefixTable('files') . ' |
|
| 4758 | + FROM ' . prefixTable('files').' |
|
| 4759 | 4759 | WHERE id_item = %i', |
| 4760 | 4760 | $post_item_id |
| 4761 | 4761 | ); |
| 4762 | 4762 | foreach ($rows as $attachment) { |
| 4763 | 4763 | $userKey = DB::queryFirstRow( |
| 4764 | 4764 | 'SELECT share_key |
| 4765 | - FROM ' . prefixTable('sharekeys_files') . ' |
|
| 4765 | + FROM ' . prefixTable('sharekeys_files').' |
|
| 4766 | 4766 | WHERE user_id = %i AND object_id = %i', |
| 4767 | 4767 | $_SESSION['user_id'], |
| 4768 | 4768 | $attachment['id'] |
@@ -4773,8 +4773,8 @@ discard block |
||
| 4773 | 4773 | // This is a public object |
| 4774 | 4774 | $users = DB::query( |
| 4775 | 4775 | 'SELECT id, public_key |
| 4776 | - FROM ' . prefixTable('users') . ' |
|
| 4777 | - WHERE id NOT IN ("' . OTV_USER_ID . '","' . SSH_USER_ID . '","' . API_USER_ID . '","' . $_SESSION['user_id'] . '") |
|
| 4776 | + FROM ' . prefixTable('users').' |
|
| 4777 | + WHERE id NOT IN ("' . OTV_USER_ID.'","'.SSH_USER_ID.'","'.API_USER_ID.'","'.$_SESSION['user_id'].'") |
|
| 4778 | 4778 | AND public_key != ""' |
| 4779 | 4779 | ); |
| 4780 | 4780 | foreach ($users as $user) { |
@@ -4811,7 +4811,7 @@ discard block |
||
| 4811 | 4811 | $_SESSION['user_id'], |
| 4812 | 4812 | 'at_modification', |
| 4813 | 4813 | $_SESSION['login'], |
| 4814 | - 'at_moved : ' . $dataSource['title'] . ' -> ' . $dataDestination['title'] |
|
| 4814 | + 'at_moved : '.$dataSource['title'].' -> '.$dataDestination['title'] |
|
| 4815 | 4815 | ); |
| 4816 | 4816 | |
| 4817 | 4817 | $returnValues = array( |
@@ -4863,8 +4863,8 @@ discard block |
||
| 4863 | 4863 | // get data about item |
| 4864 | 4864 | $dataSource = DB::queryfirstrow( |
| 4865 | 4865 | 'SELECT i.pw, f.personal_folder,i.id_tree, f.title,i.label |
| 4866 | - FROM ' . prefixTable('items') . ' as i |
|
| 4867 | - INNER JOIN ' . prefixTable('nested_tree') . ' as f ON (i.id_tree=f.id) |
|
| 4866 | + FROM ' . prefixTable('items').' as i |
|
| 4867 | + INNER JOIN ' . prefixTable('nested_tree').' as f ON (i.id_tree=f.id) |
|
| 4868 | 4868 | WHERE i.id=%i', |
| 4869 | 4869 | $item_id |
| 4870 | 4870 | ); |
@@ -4886,7 +4886,7 @@ discard block |
||
| 4886 | 4886 | |
| 4887 | 4887 | // get data about new folder |
| 4888 | 4888 | $dataDestination = DB::queryfirstrow( |
| 4889 | - 'SELECT personal_folder, title FROM ' . prefixTable('nested_tree') . ' WHERE id = %i', |
|
| 4889 | + 'SELECT personal_folder, title FROM '.prefixTable('nested_tree').' WHERE id = %i', |
|
| 4890 | 4890 | $post_folder_id |
| 4891 | 4891 | ); |
| 4892 | 4892 | |
@@ -4927,7 +4927,7 @@ discard block |
||
| 4927 | 4927 | // Get fields for this Item |
| 4928 | 4928 | $rows = DB::query( |
| 4929 | 4929 | 'SELECT id |
| 4930 | - FROM ' . prefixTable('categories_items') . ' |
|
| 4930 | + FROM ' . prefixTable('categories_items').' |
|
| 4931 | 4931 | WHERE item_id = %i', |
| 4932 | 4932 | $item_id |
| 4933 | 4933 | ); |
@@ -4944,7 +4944,7 @@ discard block |
||
| 4944 | 4944 | // Get FILES for this Item |
| 4945 | 4945 | $rows = DB::query( |
| 4946 | 4946 | 'SELECT id |
| 4947 | - FROM ' . prefixTable('files') . ' |
|
| 4947 | + FROM ' . prefixTable('files').' |
|
| 4948 | 4948 | WHERE id_item = %i', |
| 4949 | 4949 | $item_id |
| 4950 | 4950 | ); |
@@ -4997,7 +4997,7 @@ discard block |
||
| 4997 | 4997 | // Get the ITEM object key for the user |
| 4998 | 4998 | $userKey = DB::queryFirstRow( |
| 4999 | 4999 | 'SELECT share_key |
| 5000 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
| 5000 | + FROM ' . prefixTable('sharekeys_items').' |
|
| 5001 | 5001 | WHERE user_id = %i AND object_id = %i', |
| 5002 | 5002 | $_SESSION['user_id'], |
| 5003 | 5003 | $item_id |
@@ -5008,8 +5008,8 @@ discard block |
||
| 5008 | 5008 | // This is a public object |
| 5009 | 5009 | $users = DB::query( |
| 5010 | 5010 | 'SELECT id, public_key |
| 5011 | - FROM ' . prefixTable('users') . ' |
|
| 5012 | - WHERE id NOT IN ("' . OTV_USER_ID . '","' . SSH_USER_ID . '","' . API_USER_ID . '","' . $_SESSION['user_id'] . '") |
|
| 5011 | + FROM ' . prefixTable('users').' |
|
| 5012 | + WHERE id NOT IN ("' . OTV_USER_ID.'","'.SSH_USER_ID.'","'.API_USER_ID.'","'.$_SESSION['user_id'].'") |
|
| 5013 | 5013 | AND public_key != ""' |
| 5014 | 5014 | ); |
| 5015 | 5015 | foreach ($users as $user) { |
@@ -5029,14 +5029,14 @@ discard block |
||
| 5029 | 5029 | // Get fields for this Item |
| 5030 | 5030 | $rows = DB::query( |
| 5031 | 5031 | 'SELECT id |
| 5032 | - FROM ' . prefixTable('categories_items') . ' |
|
| 5032 | + FROM ' . prefixTable('categories_items').' |
|
| 5033 | 5033 | WHERE item_id = %i', |
| 5034 | 5034 | $item_id |
| 5035 | 5035 | ); |
| 5036 | 5036 | foreach ($rows as $field) { |
| 5037 | 5037 | $userKey = DB::queryFirstRow( |
| 5038 | 5038 | 'SELECT share_key |
| 5039 | - FROM ' . prefixTable('sharekeys_fields') . ' |
|
| 5039 | + FROM ' . prefixTable('sharekeys_fields').' |
|
| 5040 | 5040 | WHERE user_id = %i AND object_id = %i', |
| 5041 | 5041 | $_SESSION['user_id'], |
| 5042 | 5042 | $field['id'] |
@@ -5047,8 +5047,8 @@ discard block |
||
| 5047 | 5047 | // This is a public object |
| 5048 | 5048 | $users = DB::query( |
| 5049 | 5049 | 'SELECT id, public_key |
| 5050 | - FROM ' . prefixTable('users') . ' |
|
| 5051 | - WHERE id NOT IN ("' . OTV_USER_ID . '","' . SSH_USER_ID . '","' . API_USER_ID . '","' . $_SESSION['user_id'] . '") |
|
| 5050 | + FROM ' . prefixTable('users').' |
|
| 5051 | + WHERE id NOT IN ("' . OTV_USER_ID.'","'.SSH_USER_ID.'","'.API_USER_ID.'","'.$_SESSION['user_id'].'") |
|
| 5052 | 5052 | AND public_key != ""' |
| 5053 | 5053 | ); |
| 5054 | 5054 | foreach ($users as $user) { |
@@ -5069,14 +5069,14 @@ discard block |
||
| 5069 | 5069 | // Get FILES for this Item |
| 5070 | 5070 | $rows = DB::query( |
| 5071 | 5071 | 'SELECT id |
| 5072 | - FROM ' . prefixTable('files') . ' |
|
| 5072 | + FROM ' . prefixTable('files').' |
|
| 5073 | 5073 | WHERE id_item = %i', |
| 5074 | 5074 | $item_id |
| 5075 | 5075 | ); |
| 5076 | 5076 | foreach ($rows as $attachment) { |
| 5077 | 5077 | $userKey = DB::queryFirstRow( |
| 5078 | 5078 | 'SELECT share_key |
| 5079 | - FROM ' . prefixTable('sharekeys_files') . ' |
|
| 5079 | + FROM ' . prefixTable('sharekeys_files').' |
|
| 5080 | 5080 | WHERE user_id = %i AND object_id = %i', |
| 5081 | 5081 | $_SESSION['user_id'], |
| 5082 | 5082 | $attachment['id'] |
@@ -5087,8 +5087,8 @@ discard block |
||
| 5087 | 5087 | // This is a public object |
| 5088 | 5088 | $users = DB::query( |
| 5089 | 5089 | 'SELECT id, public_key |
| 5090 | - FROM ' . prefixTable('users') . ' |
|
| 5091 | - WHERE id NOT IN ("' . OTV_USER_ID . '","' . SSH_USER_ID . '","' . API_USER_ID . '","' . $_SESSION['user_id'] . '") |
|
| 5090 | + FROM ' . prefixTable('users').' |
|
| 5091 | + WHERE id NOT IN ("' . OTV_USER_ID.'","'.SSH_USER_ID.'","'.API_USER_ID.'","'.$_SESSION['user_id'].'") |
|
| 5092 | 5092 | AND public_key != ""' |
| 5093 | 5093 | ); |
| 5094 | 5094 | foreach ($users as $user) { |
@@ -5124,13 +5124,13 @@ discard block |
||
| 5124 | 5124 | $_SESSION['user_id'], |
| 5125 | 5125 | 'at_modification', |
| 5126 | 5126 | $_SESSION['login'], |
| 5127 | - 'at_moved : ' . $dataSource['title'] . ' -> ' . $dataDestination['title'] |
|
| 5127 | + 'at_moved : '.$dataSource['title'].' -> '.$dataDestination['title'] |
|
| 5128 | 5128 | ); |
| 5129 | 5129 | } |
| 5130 | 5130 | } |
| 5131 | 5131 | |
| 5132 | 5132 | // reload cache table |
| 5133 | - require_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php'; |
|
| 5133 | + require_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php'; |
|
| 5134 | 5134 | updateCacheTable('reload', $SETTINGS, ''); |
| 5135 | 5135 | |
| 5136 | 5136 | echo (string) prepareExchangedData( |
@@ -5193,7 +5193,7 @@ discard block |
||
| 5193 | 5193 | // get info |
| 5194 | 5194 | $dataSource = DB::queryfirstrow( |
| 5195 | 5195 | 'SELECT label, id_tree |
| 5196 | - FROM ' . prefixTable('items') . ' |
|
| 5196 | + FROM ' . prefixTable('items').' |
|
| 5197 | 5197 | WHERE id=%i', |
| 5198 | 5198 | $item_id |
| 5199 | 5199 | ); |
@@ -5292,8 +5292,8 @@ discard block |
||
| 5292 | 5292 | $content = explode(',', filter_input(INPUT_POST, 'content', FILTER_SANITIZE_STRING)); |
| 5293 | 5293 | } |
| 5294 | 5294 | // Variables |
| 5295 | - $dataAuthor = DB::queryfirstrow('SELECT email,login FROM ' . prefixTable('users') . ' WHERE id= ' . $content[1]); |
|
| 5296 | - $dataItem = DB::queryfirstrow('SELECT label, id_tree FROM ' . prefixTable('items') . ' WHERE id= ' . $content[0]); |
|
| 5295 | + $dataAuthor = DB::queryfirstrow('SELECT email,login FROM '.prefixTable('users').' WHERE id= '.$content[1]); |
|
| 5296 | + $dataItem = DB::queryfirstrow('SELECT label, id_tree FROM '.prefixTable('items').' WHERE id= '.$content[0]); |
|
| 5297 | 5297 | |
| 5298 | 5298 | // Get path |
| 5299 | 5299 | $path = geItemReadablePath( |
@@ -5307,7 +5307,7 @@ discard block |
||
| 5307 | 5307 | langHdl('email_request_access_subject'), |
| 5308 | 5308 | str_replace( |
| 5309 | 5309 | array('#tp_item_author#', '#tp_user#', '#tp_item#'), |
| 5310 | - array(' ' . addslashes($dataAuthor['login']), addslashes($_SESSION['login']), $path), |
|
| 5310 | + array(' '.addslashes($dataAuthor['login']), addslashes($_SESSION['login']), $path), |
|
| 5311 | 5311 | langHdl('email_request_access_mail') |
| 5312 | 5312 | ), |
| 5313 | 5313 | $dataAuthor['email'], |
@@ -5318,7 +5318,7 @@ discard block |
||
| 5318 | 5318 | } elseif ($post_cat === 'share_this_item') { |
| 5319 | 5319 | $dataItem = DB::queryfirstrow( |
| 5320 | 5320 | 'SELECT label,id_tree |
| 5321 | - FROM ' . prefixTable('items') . ' |
|
| 5321 | + FROM ' . prefixTable('items').' |
|
| 5322 | 5322 | WHERE id= %i', |
| 5323 | 5323 | $post_id |
| 5324 | 5324 | ); |
@@ -5342,7 +5342,7 @@ discard block |
||
| 5342 | 5342 | ), |
| 5343 | 5343 | array( |
| 5344 | 5344 | empty($SETTINGS['email_server_url']) === false ? |
| 5345 | - $SETTINGS['email_server_url'] . '/index.php?page=items&group=' . $dataItem['id_tree'] . '&id=' . $post_id : $SETTINGS['cpassman_url'] . '/index.php?page=items&group=' . $dataItem['id_tree'] . '&id=' . $post_id, |
|
| 5345 | + $SETTINGS['email_server_url'].'/index.php?page=items&group='.$dataItem['id_tree'].'&id='.$post_id : $SETTINGS['cpassman_url'].'/index.php?page=items&group='.$dataItem['id_tree'].'&id='.$post_id, |
|
| 5346 | 5346 | addslashes($_SESSION['login']), |
| 5347 | 5347 | addslashes($path), |
| 5348 | 5348 | ), |
@@ -5377,7 +5377,7 @@ discard block |
||
| 5377 | 5377 | if (filter_input(INPUT_POST, 'notify_type', FILTER_SANITIZE_STRING) === 'on_show') { |
| 5378 | 5378 | // Check if values already exist |
| 5379 | 5379 | $data = DB::queryfirstrow( |
| 5380 | - 'SELECT notification FROM ' . prefixTable('items') . ' WHERE id = %i', |
|
| 5380 | + 'SELECT notification FROM '.prefixTable('items').' WHERE id = %i', |
|
| 5381 | 5381 | $post_item_id |
| 5382 | 5382 | ); |
| 5383 | 5383 | $notifiedUsers = explode(';', $data['notification']); |
@@ -5388,8 +5388,8 @@ discard block |
||
| 5388 | 5388 | prefixTable('items'), |
| 5389 | 5389 | array( |
| 5390 | 5390 | 'notification' => empty($data['notification']) ? |
| 5391 | - filter_input(INPUT_POST, 'user_id', FILTER_SANITIZE_NUMBER_INT) . ';' |
|
| 5392 | - : $data['notification'] . filter_input(INPUT_POST, 'user_id', FILTER_SANITIZE_NUMBER_INT), |
|
| 5391 | + filter_input(INPUT_POST, 'user_id', FILTER_SANITIZE_NUMBER_INT).';' |
|
| 5392 | + : $data['notification'].filter_input(INPUT_POST, 'user_id', FILTER_SANITIZE_NUMBER_INT), |
|
| 5393 | 5393 | ), |
| 5394 | 5394 | 'id=%i', |
| 5395 | 5395 | $post_item_id |
@@ -5404,7 +5404,7 @@ discard block |
||
| 5404 | 5404 | array( |
| 5405 | 5405 | 'notification' => empty($data['notification']) ? |
| 5406 | 5406 | filter_input(INPUT_POST, 'user_id', FILTER_SANITIZE_NUMBER_INT) |
| 5407 | - : $data['notification'] . ';' . filter_input(INPUT_POST, 'user_id', FILTER_SANITIZE_NUMBER_INT), |
|
| 5407 | + : $data['notification'].';'.filter_input(INPUT_POST, 'user_id', FILTER_SANITIZE_NUMBER_INT), |
|
| 5408 | 5408 | ), |
| 5409 | 5409 | 'id=%i', |
| 5410 | 5410 | $post_item_id |
@@ -5429,8 +5429,8 @@ discard block |
||
| 5429 | 5429 | // Get all informations for this item |
| 5430 | 5430 | $dataItem = DB::queryfirstrow( |
| 5431 | 5431 | 'SELECT * |
| 5432 | - FROM ' . prefixTable('items') . ' as i |
|
| 5433 | - INNER JOIN ' . prefixTable('log_items') . ' as l ON (l.id_item = i.id) |
|
| 5432 | + FROM ' . prefixTable('items').' as i |
|
| 5433 | + INNER JOIN ' . prefixTable('log_items').' as l ON (l.id_item = i.id) |
|
| 5434 | 5434 | WHERE i.id=%i AND l.action = %s', |
| 5435 | 5435 | $dataReceived['item_id'], |
| 5436 | 5436 | 'at_creation' |
@@ -5466,14 +5466,14 @@ discard block |
||
| 5466 | 5466 | ); |
| 5467 | 5467 | // Prepare new line |
| 5468 | 5468 | $data = DB::queryfirstrow( |
| 5469 | - 'SELECT * FROM ' . prefixTable('log_items') . ' WHERE id_item = %i ORDER BY date DESC', |
|
| 5469 | + 'SELECT * FROM '.prefixTable('log_items').' WHERE id_item = %i ORDER BY date DESC', |
|
| 5470 | 5470 | $dataReceived['item_id'] |
| 5471 | 5471 | ); |
| 5472 | - $historic = date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], $data['date']) . ' - ' . $_SESSION['login'] . ' - ' . langHdl($data['action']) . ' - ' . $data['raison']; |
|
| 5472 | + $historic = date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], $data['date']).' - '.$_SESSION['login'].' - '.langHdl($data['action']).' - '.$data['raison']; |
|
| 5473 | 5473 | // send back |
| 5474 | 5474 | $data = array( |
| 5475 | 5475 | 'error' => '', |
| 5476 | - 'new_line' => '<br>' . addslashes($historic), |
|
| 5476 | + 'new_line' => '<br>'.addslashes($historic), |
|
| 5477 | 5477 | ); |
| 5478 | 5478 | echo (string) prepareExchangedData($data, 'encode'); |
| 5479 | 5479 | } else { |
@@ -5508,7 +5508,7 @@ discard block |
||
| 5508 | 5508 | */ |
| 5509 | 5509 | case 'is_item_changed': |
| 5510 | 5510 | $data = DB::queryFirstRow( |
| 5511 | - 'SELECT date FROM ' . prefixTable('log_items') . ' WHERE action = %s AND id_item = %i ORDER BY date DESC', |
|
| 5511 | + 'SELECT date FROM '.prefixTable('log_items').' WHERE action = %s AND id_item = %i ORDER BY date DESC', |
|
| 5512 | 5512 | 'at_modification', |
| 5513 | 5513 | $post_item_id |
| 5514 | 5514 | ); |
@@ -5532,7 +5532,7 @@ discard block |
||
| 5532 | 5532 | } |
| 5533 | 5533 | |
| 5534 | 5534 | // delete all existing old otv codes |
| 5535 | - $rows = DB::query('SELECT id FROM ' . prefixTable('otv') . ' WHERE timestamp < ' . (time() - $SETTINGS['otv_expiration_period'] * 86400)); |
|
| 5535 | + $rows = DB::query('SELECT id FROM '.prefixTable('otv').' WHERE timestamp < '.(time() - $SETTINGS['otv_expiration_period'] * 86400)); |
|
| 5536 | 5536 | foreach ($rows as $record) { |
| 5537 | 5537 | DB::delete(prefixTable('otv'), 'id=%i', $record['id']); |
| 5538 | 5538 | } |
@@ -5554,8 +5554,8 @@ discard block |
||
| 5554 | 5554 | // Should we log a password change? |
| 5555 | 5555 | $itemQ = DB::queryFirstRow( |
| 5556 | 5556 | 'SELECT s.share_key, i.pw |
| 5557 | - FROM ' . prefixTable('items') . ' AS i |
|
| 5558 | - INNER JOIN ' . prefixTable('sharekeys_items') . ' AS s ON (i.id = s.object_id) |
|
| 5557 | + FROM ' . prefixTable('items').' AS i |
|
| 5558 | + INNER JOIN ' . prefixTable('sharekeys_items').' AS s ON (i.id = s.object_id) |
|
| 5559 | 5559 | WHERE s.user_id = %i AND s.object_id = %i', |
| 5560 | 5560 | $_SESSION['user_id'], |
| 5561 | 5561 | $post_id |
@@ -5605,8 +5605,8 @@ discard block |
||
| 5605 | 5605 | if (isset($SETTINGS['otv_expiration_period']) === false) { |
| 5606 | 5606 | $SETTINGS['otv_expiration_period'] = 7; |
| 5607 | 5607 | } |
| 5608 | - $url = $SETTINGS['cpassman_url'] . '/index.php?otv=true&' . http_build_query($otv_session); |
|
| 5609 | - $exp_date = date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], time() + (intval($SETTINGS['otv_expiration_period']) * 86400)); |
|
| 5608 | + $url = $SETTINGS['cpassman_url'].'/index.php?otv=true&'.http_build_query($otv_session); |
|
| 5609 | + $exp_date = date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], time() + (intval($SETTINGS['otv_expiration_period']) * 86400)); |
|
| 5610 | 5610 | |
| 5611 | 5611 | echo json_encode( |
| 5612 | 5612 | array( |
@@ -5643,8 +5643,8 @@ discard block |
||
| 5643 | 5643 | 'SELECT f.id AS id, f.file AS file, f.name AS name, f.status AS status, |
| 5644 | 5644 | f.extension AS extension, f.type AS type, |
| 5645 | 5645 | s.share_key AS share_key |
| 5646 | - FROM ' . prefixTable('files') . ' AS f |
|
| 5647 | - INNER JOIN ' . prefixTable('sharekeys_files') . ' AS s ON (f.id = s.object_id) |
|
| 5646 | + FROM ' . prefixTable('files').' AS f |
|
| 5647 | + INNER JOIN ' . prefixTable('sharekeys_files').' AS s ON (f.id = s.object_id) |
|
| 5648 | 5648 | WHERE s.user_id = %i AND s.object_id = %i', |
| 5649 | 5649 | $_SESSION['user_id'], |
| 5650 | 5650 | $post_id |
@@ -5665,7 +5665,7 @@ discard block |
||
| 5665 | 5665 | //$fileName = basename($file_info['name'], '.'.$file_info['extension']); |
| 5666 | 5666 | |
| 5667 | 5667 | // prepare image info |
| 5668 | - $post_title = basename($file_info['name'], '.' . $file_info['extension']); |
|
| 5668 | + $post_title = basename($file_info['name'], '.'.$file_info['extension']); |
|
| 5669 | 5669 | $post_title = isBase64($post_title) === true ? |
| 5670 | 5670 | base64_decode($post_title) : $post_title; |
| 5671 | 5671 | $image_code = $file_info['file']; |
@@ -5682,7 +5682,7 @@ discard block |
||
| 5682 | 5682 | echo (string) prepareExchangedData( |
| 5683 | 5683 | array( |
| 5684 | 5684 | 'error' => false, |
| 5685 | - 'filename' => $post_title . '.' . $file_info['extension'], |
|
| 5685 | + 'filename' => $post_title.'.'.$file_info['extension'], |
|
| 5686 | 5686 | 'file_type' => $file_info['type'], |
| 5687 | 5687 | 'file_content' => $fileContent, |
| 5688 | 5688 | ), |
@@ -5703,11 +5703,11 @@ discard block |
||
| 5703 | 5703 | |
| 5704 | 5704 | // get file info |
| 5705 | 5705 | $result = DB::queryfirstrow( |
| 5706 | - 'SELECT file FROM ' . prefixTable('files') . ' WHERE id=%i', |
|
| 5706 | + 'SELECT file FROM '.prefixTable('files').' WHERE id=%i', |
|
| 5707 | 5707 | intval(substr(filter_input(INPUT_POST, 'uri', FILTER_SANITIZE_STRING), 1)) |
| 5708 | 5708 | ); |
| 5709 | 5709 | |
| 5710 | - fileDelete($SETTINGS['path_to_upload_folder'] . '/' . $result['file'] . filter_input(INPUT_POST, 'file_suffix', FILTER_SANITIZE_STRING), $SETTINGS); |
|
| 5710 | + fileDelete($SETTINGS['path_to_upload_folder'].'/'.$result['file'].filter_input(INPUT_POST, 'file_suffix', FILTER_SANITIZE_STRING), $SETTINGS); |
|
| 5711 | 5711 | |
| 5712 | 5712 | break; |
| 5713 | 5713 | |
@@ -5731,16 +5731,16 @@ discard block |
||
| 5731 | 5731 | $idFolder = $dataReceived['idFolder']; |
| 5732 | 5732 | |
| 5733 | 5733 | // don't check if Personal Folder |
| 5734 | - $data = DB::queryFirstRow('SELECT title FROM ' . prefixTable('nested_tree') . ' WHERE id = %i', $idFolder); |
|
| 5734 | + $data = DB::queryFirstRow('SELECT title FROM '.prefixTable('nested_tree').' WHERE id = %i', $idFolder); |
|
| 5735 | 5735 | if ($data['title'] == $_SESSION['user_id']) { |
| 5736 | 5736 | // send data |
| 5737 | - echo '[{"duplicate" : "' . $duplicate . '" , error" : ""}]'; |
|
| 5737 | + echo '[{"duplicate" : "'.$duplicate.'" , error" : ""}]'; |
|
| 5738 | 5738 | } else { |
| 5739 | 5739 | if (filter_input(INPUT_POST, 'option', FILTER_SANITIZE_STRING) === 'same_folder') { |
| 5740 | 5740 | // case unique folder |
| 5741 | 5741 | DB::query( |
| 5742 | 5742 | 'SELECT label |
| 5743 | - FROM ' . prefixTable('items') . ' |
|
| 5743 | + FROM ' . prefixTable('items').' |
|
| 5744 | 5744 | WHERE id_tree = %i AND label = %s', |
| 5745 | 5745 | $idFolder, |
| 5746 | 5746 | $label |
@@ -5753,7 +5753,7 @@ discard block |
||
| 5753 | 5753 | $listPf = ''; |
| 5754 | 5754 | if (empty($row['id']) === false) { |
| 5755 | 5755 | $rows = DB::query( |
| 5756 | - 'SELECT id FROM ' . prefixTable('nested_tree') . ' WHERE personal_folder = %i', |
|
| 5756 | + 'SELECT id FROM '.prefixTable('nested_tree').' WHERE personal_folder = %i', |
|
| 5757 | 5757 | '1' |
| 5758 | 5758 | ); |
| 5759 | 5759 | foreach ($rows as $record) { |
@@ -5768,12 +5768,12 @@ discard block |
||
| 5768 | 5768 | $where->add('id_tree = %i', $idFolder); |
| 5769 | 5769 | $where->add('label = %s', $label); |
| 5770 | 5770 | if (empty($arrayPf) === false) { |
| 5771 | - $where->add('id_tree NOT IN (' . implode(',', $arrayPf) . ')'); |
|
| 5771 | + $where->add('id_tree NOT IN ('.implode(',', $arrayPf).')'); |
|
| 5772 | 5772 | } |
| 5773 | 5773 | |
| 5774 | 5774 | DB::query( |
| 5775 | 5775 | 'SELECT label |
| 5776 | - FROM ' . prefixTable('items') . ' |
|
| 5776 | + FROM ' . prefixTable('items').' |
|
| 5777 | 5777 | WHERE %l', |
| 5778 | 5778 | $where |
| 5779 | 5779 | ); |
@@ -5785,7 +5785,7 @@ discard block |
||
| 5785 | 5785 | } |
| 5786 | 5786 | |
| 5787 | 5787 | // send data |
| 5788 | - echo '[{"duplicate" : "' . $duplicate . '" , "error" : ""}]'; |
|
| 5788 | + echo '[{"duplicate" : "'.$duplicate.'" , "error" : ""}]'; |
|
| 5789 | 5789 | } |
| 5790 | 5790 | break; |
| 5791 | 5791 | |
@@ -5841,7 +5841,7 @@ discard block |
||
| 5841 | 5841 | } |
| 5842 | 5842 | |
| 5843 | 5843 | //Build tree |
| 5844 | - $tree = new SplClassLoader('Tree\NestedTree', $SETTINGS['cpassman_dir'] . '/includes/libraries'); |
|
| 5844 | + $tree = new SplClassLoader('Tree\NestedTree', $SETTINGS['cpassman_dir'].'/includes/libraries'); |
|
| 5845 | 5845 | $tree->register(); |
| 5846 | 5846 | $tree = new Tree\NestedTree\NestedTree(prefixTable('nested_tree'), 'id', 'parent_id', 'title'); |
| 5847 | 5847 | $tree->rebuild(); |
@@ -5903,7 +5903,7 @@ discard block |
||
| 5903 | 5903 | if (empty($arr_data['folders'][$inc]['path']) === true) { |
| 5904 | 5904 | $arr_data['folders'][$inc]['path'] = htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES); |
| 5905 | 5905 | } else { |
| 5906 | - $arr_data['folders'][$inc]['path'] .= ' / ' . htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES); |
|
| 5906 | + $arr_data['folders'][$inc]['path'] .= ' / '.htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES); |
|
| 5907 | 5907 | } |
| 5908 | 5908 | } |
| 5909 | 5909 | |
@@ -5969,8 +5969,8 @@ discard block |
||
| 5969 | 5969 | $rows_tmp = DB::query( |
| 5970 | 5970 | 'SELECT c.id, c.title, c.level, c.type, c.masked, c.order, c.encrypted_data, c.role_visibility, c.is_mandatory, |
| 5971 | 5971 | f.id_category AS category_id |
| 5972 | - FROM ' . prefixTable('categories_folders') . ' AS f |
|
| 5973 | - INNER JOIN ' . prefixTable('categories') . ' AS c ON (f.id_category = c.parent_id) |
|
| 5972 | + FROM ' . prefixTable('categories_folders').' AS f |
|
| 5973 | + INNER JOIN ' . prefixTable('categories').' AS c ON (f.id_category = c.parent_id) |
|
| 5974 | 5974 | WHERE id_folder=%i', |
| 5975 | 5975 | $folder |
| 5976 | 5976 | ); |
@@ -5997,7 +5997,7 @@ discard block |
||
| 5997 | 5997 | $valTemp = ''; |
| 5998 | 5998 | $data = DB::queryFirstRow( |
| 5999 | 5999 | 'SELECT valeur |
| 6000 | - FROM ' . prefixTable('misc') . ' |
|
| 6000 | + FROM ' . prefixTable('misc').' |
|
| 6001 | 6001 | WHERE type = %s AND intitule=%i', |
| 6002 | 6002 | 'complex', |
| 6003 | 6003 | $folder |
@@ -6014,14 +6014,14 @@ discard block |
||
| 6014 | 6014 | $valTemp = ''; |
| 6015 | 6015 | $rows_tmp = DB::query( |
| 6016 | 6016 | 'SELECT t.title |
| 6017 | - FROM ' . prefixTable('roles_values') . ' as v |
|
| 6018 | - INNER JOIN ' . prefixTable('roles_title') . ' as t ON (v.role_id = t.id) |
|
| 6017 | + FROM ' . prefixTable('roles_values').' as v |
|
| 6018 | + INNER JOIN ' . prefixTable('roles_title').' as t ON (v.role_id = t.id) |
|
| 6019 | 6019 | WHERE v.folder_id = %i |
| 6020 | 6020 | GROUP BY title', |
| 6021 | 6021 | $folder |
| 6022 | 6022 | ); |
| 6023 | 6023 | foreach ($rows_tmp as $record) { |
| 6024 | - $valTemp .= (empty($valTemp) === true ? '' : ' - ') . $record['title']; |
|
| 6024 | + $valTemp .= (empty($valTemp) === true ? '' : ' - ').$record['title']; |
|
| 6025 | 6025 | } |
| 6026 | 6026 | $arr_data[$folder]['visibilityRoles'] = $valTemp; |
| 6027 | 6027 | } |
@@ -6049,7 +6049,7 @@ discard block |
||
| 6049 | 6049 | // get item info |
| 6050 | 6050 | $dataItem = DB::queryFirstRow( |
| 6051 | 6051 | 'SELECT * |
| 6052 | - FROM ' . prefixTable('items') . ' |
|
| 6052 | + FROM ' . prefixTable('items').' |
|
| 6053 | 6053 | WHERE id=%i', |
| 6054 | 6054 | $post_item_id |
| 6055 | 6055 | ); |
@@ -6059,8 +6059,8 @@ discard block |
||
| 6059 | 6059 | $rows = DB::query( |
| 6060 | 6060 | 'SELECT l.date as date, l.action as action, l.raison as raison, l.raison_iv AS raison_iv, |
| 6061 | 6061 | u.login as login, u.avatar_thumb as avatar_thumb, u.name as name, u.lastname as lastname |
| 6062 | - FROM ' . prefixTable('log_items') . ' as l |
|
| 6063 | - LEFT JOIN ' . prefixTable('users') . ' as u ON (l.id_user=u.id) |
|
| 6062 | + FROM ' . prefixTable('log_items').' as l |
|
| 6063 | + LEFT JOIN ' . prefixTable('users').' as u ON (l.id_user=u.id) |
|
| 6064 | 6064 | WHERE id_item=%i AND action <> %s |
| 6065 | 6065 | ORDER BY date DESC', |
| 6066 | 6066 | $post_item_id, |
@@ -6074,7 +6074,7 @@ discard block |
||
| 6074 | 6074 | } |
| 6075 | 6075 | // imported via API |
| 6076 | 6076 | if (empty($record['login'])) { |
| 6077 | - $record['login'] = langHdl('imported_via_api') . ' [' . $record['raison'] . ']'; |
|
| 6077 | + $record['login'] = langHdl('imported_via_api').' ['.$record['raison'].']'; |
|
| 6078 | 6078 | } |
| 6079 | 6079 | |
| 6080 | 6080 | if ( |
@@ -6085,13 +6085,13 @@ discard block |
||
| 6085 | 6085 | ) { |
| 6086 | 6086 | // Prepare avatar |
| 6087 | 6087 | if (isset($record['avatar_thumb']) && empty($record['avatar_thumb']) === false) { |
| 6088 | - if (file_exists($SETTINGS['cpassman_dir'] . '/includes/avatars/' . $record['avatar_thumb'])) { |
|
| 6089 | - $avatar = $SETTINGS['cpassman_url'] . '/includes/avatars/' . $record['avatar_thumb']; |
|
| 6088 | + if (file_exists($SETTINGS['cpassman_dir'].'/includes/avatars/'.$record['avatar_thumb'])) { |
|
| 6089 | + $avatar = $SETTINGS['cpassman_url'].'/includes/avatars/'.$record['avatar_thumb']; |
|
| 6090 | 6090 | } else { |
| 6091 | - $avatar = $SETTINGS['cpassman_url'] . '/includes/images/photo.jpg'; |
|
| 6091 | + $avatar = $SETTINGS['cpassman_url'].'/includes/images/photo.jpg'; |
|
| 6092 | 6092 | } |
| 6093 | 6093 | } else { |
| 6094 | - $avatar = $SETTINGS['cpassman_url'] . '/includes/images/photo.jpg'; |
|
| 6094 | + $avatar = $SETTINGS['cpassman_url'].'/includes/images/photo.jpg'; |
|
| 6095 | 6095 | } |
| 6096 | 6096 | |
| 6097 | 6097 | // Prepare action |
@@ -6108,19 +6108,19 @@ discard block |
||
| 6108 | 6108 | $action = langHdl($reason[0]); |
| 6109 | 6109 | if ($reason[0] === 'at_moved') { |
| 6110 | 6110 | $tmp = explode(' -> ', $reason[1]); |
| 6111 | - $detail = langHdl('from') . ' <span class="font-weight-light">' . $tmp[0] . '</span> ' . langHdl('to') . ' <span class="font-weight-light">' . $tmp[1] . ' </span>'; |
|
| 6111 | + $detail = langHdl('from').' <span class="font-weight-light">'.$tmp[0].'</span> '.langHdl('to').' <span class="font-weight-light">'.$tmp[1].' </span>'; |
|
| 6112 | 6112 | } elseif ($reason[0] === 'at_field') { |
| 6113 | 6113 | $tmp = explode(' => ', $reason[1]); |
| 6114 | 6114 | if (count($tmp) > 1) { |
| 6115 | - $detail = '<b>' . trim($tmp[0]) . '</b> | ' . langHdl('previous_value') . |
|
| 6116 | - ': <span class="font-weight-light">' . trim($tmp[1]) . '</span>'; |
|
| 6115 | + $detail = '<b>'.trim($tmp[0]).'</b> | '.langHdl('previous_value'). |
|
| 6116 | + ': <span class="font-weight-light">'.trim($tmp[1]).'</span>'; |
|
| 6117 | 6117 | } else { |
| 6118 | 6118 | $detail = trim($reason[1]); |
| 6119 | 6119 | } |
| 6120 | 6120 | } elseif (in_array($reason[0], array('at_restriction', 'at_email', 'at_login', 'at_label', 'at_url', 'at_tag')) === true) { |
| 6121 | 6121 | $tmp = explode(' => ', $reason[1]); |
| 6122 | 6122 | $detail = empty(trim($tmp[0])) === true ? |
| 6123 | - langHdl('no_previous_value') : langHdl('previous_value') . ': <span class="font-weight-light">' . $tmp[0] . ' </span>'; |
|
| 6123 | + langHdl('no_previous_value') : langHdl('previous_value').': <span class="font-weight-light">'.$tmp[0].' </span>'; |
|
| 6124 | 6124 | } elseif ($reason[0] === 'at_automatic_del') { |
| 6125 | 6125 | $detail = langHdl($reason[1]); |
| 6126 | 6126 | } elseif ($reason[0] === 'at_anyoneconmodify') { |
@@ -6129,7 +6129,7 @@ discard block |
||
| 6129 | 6129 | $tmp = explode(':', $reason[1]); |
| 6130 | 6130 | $tmp = explode('.', $tmp[0]); |
| 6131 | 6131 | $detail = isBase64($tmp[0]) === true ? |
| 6132 | - base64_decode($tmp[0]) . '.' . $tmp[1] : $tmp[0]; |
|
| 6132 | + base64_decode($tmp[0]).'.'.$tmp[1] : $tmp[0]; |
|
| 6133 | 6133 | } elseif ($reason[0] === 'at_import') { |
| 6134 | 6134 | $detail = ''; |
| 6135 | 6135 | } elseif (in_array($reason[0], array('csv', 'pdf')) === true) { |
@@ -6148,8 +6148,8 @@ discard block |
||
| 6148 | 6148 | array( |
| 6149 | 6149 | 'avatar' => $avatar, |
| 6150 | 6150 | 'login' => $record['login'], |
| 6151 | - 'name' => $record['name'] . ' ' . $record['lastname'], |
|
| 6152 | - 'date' => date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], $record['date']), |
|
| 6151 | + 'name' => $record['name'].' '.$record['lastname'], |
|
| 6152 | + 'date' => date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], $record['date']), |
|
| 6153 | 6153 | 'action' => $action, |
| 6154 | 6154 | 'detail' => $detail, |
| 6155 | 6155 | ) |
@@ -6232,18 +6232,18 @@ discard block |
||
| 6232 | 6232 | |
| 6233 | 6233 | // get some info to add to the notification email |
| 6234 | 6234 | $resp_user = DB::queryfirstrow( |
| 6235 | - 'SELECT login FROM ' . prefixTable('users') . ' WHERE id = %i', |
|
| 6235 | + 'SELECT login FROM '.prefixTable('users').' WHERE id = %i', |
|
| 6236 | 6236 | $_SESSION['user_id'] |
| 6237 | 6237 | ); |
| 6238 | 6238 | $resp_folder = DB::queryfirstrow( |
| 6239 | - 'SELECT title FROM ' . prefixTable('nested_tree') . ' WHERE id = %i', |
|
| 6239 | + 'SELECT title FROM '.prefixTable('nested_tree').' WHERE id = %i', |
|
| 6240 | 6240 | $folder |
| 6241 | 6241 | ); |
| 6242 | 6242 | |
| 6243 | 6243 | // notify Managers |
| 6244 | 6244 | $rows = DB::query( |
| 6245 | 6245 | 'SELECT email |
| 6246 | - FROM ' . prefixTable('users') . ' |
|
| 6246 | + FROM ' . prefixTable('users').' |
|
| 6247 | 6247 | WHERE `gestionnaire` = %i AND `email` IS NOT NULL', |
| 6248 | 6248 | 1 |
| 6249 | 6249 | ); |
@@ -6274,14 +6274,14 @@ discard block |
||
| 6274 | 6274 | // Get list of users |
| 6275 | 6275 | $usersList = array(); |
| 6276 | 6276 | $usersString = ''; |
| 6277 | - $rows = DB::query('SELECT id,login,email FROM ' . prefixTable('users') . ' ORDER BY login ASC'); |
|
| 6277 | + $rows = DB::query('SELECT id,login,email FROM '.prefixTable('users').' ORDER BY login ASC'); |
|
| 6278 | 6278 | foreach ($rows as $record) { |
| 6279 | 6279 | $usersList[$record['login']] = array( |
| 6280 | 6280 | 'id' => $record['id'], |
| 6281 | 6281 | 'login' => $record['login'], |
| 6282 | 6282 | 'email' => $record['email'], |
| 6283 | 6283 | ); |
| 6284 | - $usersString .= $record['id'] . '#' . $record['login'] . ';'; |
|
| 6284 | + $usersString .= $record['id'].'#'.$record['login'].';'; |
|
| 6285 | 6285 | } |
| 6286 | 6286 | |
| 6287 | 6287 | $data = array( |
@@ -6315,20 +6315,20 @@ discard block |
||
| 6315 | 6315 | // Send email |
| 6316 | 6316 | $dataItem = DB::queryfirstrow( |
| 6317 | 6317 | 'SELECT label, id_tree |
| 6318 | - FROM ' . prefixTable('items') . ' |
|
| 6318 | + FROM ' . prefixTable('items').' |
|
| 6319 | 6319 | WHERE id = %i', |
| 6320 | 6320 | $post_item_id |
| 6321 | 6321 | ); |
| 6322 | 6322 | $dataItemLog = DB::queryfirstrow( |
| 6323 | 6323 | 'SELECT id_user |
| 6324 | - FROM ' . prefixTable('log_items') . ' |
|
| 6324 | + FROM ' . prefixTable('log_items').' |
|
| 6325 | 6325 | WHERE id_item = %i AND action = %s', |
| 6326 | 6326 | $post_item_id, |
| 6327 | 6327 | 'at_creation' |
| 6328 | 6328 | ); |
| 6329 | 6329 | $dataAuthor = DB::queryfirstrow( |
| 6330 | 6330 | 'SELECT email, login |
| 6331 | - FROM ' . prefixTable('users') . ' |
|
| 6331 | + FROM ' . prefixTable('users').' |
|
| 6332 | 6332 | WHERE id = %i', |
| 6333 | 6333 | $dataItemLog['id_user'] |
| 6334 | 6334 | ); |
@@ -6407,7 +6407,7 @@ discard block |
||
| 6407 | 6407 | |
| 6408 | 6408 | DB::query( |
| 6409 | 6409 | 'SELECT * |
| 6410 | - FROM ' . prefixTable('notification') . ' |
|
| 6410 | + FROM ' . prefixTable('notification').' |
|
| 6411 | 6411 | WHERE item_id = %i AND user_id = %i', |
| 6412 | 6412 | $post_item_id, |
| 6413 | 6413 | $_SESSION['user_id'] |
@@ -6473,7 +6473,7 @@ discard block |
||
| 6473 | 6473 | // And related logs |
| 6474 | 6474 | $rows = DB::query( |
| 6475 | 6475 | 'SELECT id, file AS filename |
| 6476 | - FROM ' . prefixTable('files') . ' |
|
| 6476 | + FROM ' . prefixTable('files').' |
|
| 6477 | 6477 | WHERE id_item = %i AND confirmed = %i', |
| 6478 | 6478 | $post_item_id, |
| 6479 | 6479 | 0 |
@@ -6487,12 +6487,12 @@ discard block |
||
| 6487 | 6487 | ); |
| 6488 | 6488 | |
| 6489 | 6489 | // Delete file on server |
| 6490 | - unlink($SETTINGS['path_to_upload_folder'] . '/' . TP_FILE_PREFIX . base64_decode($file['filename'])); |
|
| 6490 | + unlink($SETTINGS['path_to_upload_folder'].'/'.TP_FILE_PREFIX.base64_decode($file['filename'])); |
|
| 6491 | 6491 | |
| 6492 | 6492 | // Delete related logs |
| 6493 | 6493 | $logFile = DB::query( |
| 6494 | 6494 | 'SELECT increment_id, raison |
| 6495 | - FROM ' . prefixTable('log_items') . ' |
|
| 6495 | + FROM ' . prefixTable('log_items').' |
|
| 6496 | 6496 | WHERE id_item = %i AND id_user = %i AND action = %s AND raison LIKE "at_add_file :%"', |
| 6497 | 6497 | $post_item_id, |
| 6498 | 6498 | $_SESSION['user_id'], |
@@ -6545,7 +6545,7 @@ discard block |
||
| 6545 | 6545 | // Confirm attachments |
| 6546 | 6546 | $rows = DB::query( |
| 6547 | 6547 | 'SELECT id, file AS filename |
| 6548 | - FROM ' . prefixTable('files') . ' |
|
| 6548 | + FROM ' . prefixTable('files').' |
|
| 6549 | 6549 | WHERE id_item = %i AND confirmed = %i', |
| 6550 | 6550 | $post_item_id, |
| 6551 | 6551 | 0 |
@@ -6582,15 +6582,15 @@ discard block |
||
| 6582 | 6582 | case 'autocomplete_tags': |
| 6583 | 6583 | // Get a list off all existing TAGS |
| 6584 | 6584 | $listOfTags = ''; |
| 6585 | - $rows = DB::query('SELECT tag FROM ' . prefixTable('tags') . ' WHERE tag LIKE %ss GROUP BY tag', $_GET['term']); |
|
| 6585 | + $rows = DB::query('SELECT tag FROM '.prefixTable('tags').' WHERE tag LIKE %ss GROUP BY tag', $_GET['term']); |
|
| 6586 | 6586 | foreach ($rows as $record) { |
| 6587 | 6587 | if (empty($listOfTags)) { |
| 6588 | - $listOfTags = '"' . $record['tag'] . '"'; |
|
| 6588 | + $listOfTags = '"'.$record['tag'].'"'; |
|
| 6589 | 6589 | } else { |
| 6590 | - $listOfTags .= ', "' . $record['tag'] . '"'; |
|
| 6590 | + $listOfTags .= ', "'.$record['tag'].'"'; |
|
| 6591 | 6591 | } |
| 6592 | 6592 | } |
| 6593 | - echo '[' . $listOfTags . ']'; |
|
| 6593 | + echo '['.$listOfTags.']'; |
|
| 6594 | 6594 | break; |
| 6595 | 6595 | } |
| 6596 | 6596 | } |
@@ -6603,7 +6603,7 @@ discard block |
||
| 6603 | 6603 | { |
| 6604 | 6604 | $data = DB::queryFirstRow( |
| 6605 | 6605 | 'SELECT bloquer_creation, bloquer_modification, personal_folder |
| 6606 | - FROM ' . prefixTable('nested_tree') . ' WHERE id = %i', |
|
| 6606 | + FROM ' . prefixTable('nested_tree').' WHERE id = %i', |
|
| 6607 | 6607 | $groupe |
| 6608 | 6608 | ); |
| 6609 | 6609 | // Check if it's in a personal folder. If yes, then force complexity overhead. |
