nilsteampassnet /
TeamPass
@@ -69,7 +69,7 @@ discard block |
||
| 69 | 69 | ) { |
| 70 | 70 | // Not allowed page |
| 71 | 71 | $superGlobal->put('code', ERR_NOT_ALLOWED, 'SESSION', 'error'); |
| 72 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
| 72 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
| 73 | 73 | exit; |
| 74 | 74 | } |
| 75 | 75 | |
@@ -94,7 +94,7 @@ discard block |
||
| 94 | 94 | date_default_timezone_set('UTC'); |
| 95 | 95 | } |
| 96 | 96 | |
| 97 | -require_once $SETTINGS['cpassman_dir'] . '/includes/language/' . $_SESSION['user']['user_language'] . '.php'; |
|
| 97 | +require_once $SETTINGS['cpassman_dir'].'/includes/language/'.$_SESSION['user']['user_language'].'.php'; |
|
| 98 | 98 | header('Content-type: text/html; charset=utf-8'); |
| 99 | 99 | header('Cache-Control: no-cache, must-revalidate'); |
| 100 | 100 | |
@@ -346,7 +346,7 @@ discard block |
||
| 346 | 346 | // About special settings |
| 347 | 347 | $dataFolderSettings = DB::queryFirstRow( |
| 348 | 348 | 'SELECT bloquer_creation, bloquer_modification, personal_folder |
| 349 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 349 | + FROM ' . prefixTable('nested_tree').' |
|
| 350 | 350 | WHERE id = %i', |
| 351 | 351 | $inputData['folderId'] |
| 352 | 352 | ); |
@@ -363,7 +363,7 @@ discard block |
||
| 363 | 363 | // Get folder complexity |
| 364 | 364 | $folderComplexity = DB::queryfirstrow( |
| 365 | 365 | 'SELECT valeur |
| 366 | - FROM ' . prefixTable('misc') . ' |
|
| 366 | + FROM ' . prefixTable('misc').' |
|
| 367 | 367 | WHERE type = %s AND intitule = %i', |
| 368 | 368 | 'complex', |
| 369 | 369 | $inputData['folderId'] |
@@ -388,7 +388,7 @@ discard block |
||
| 388 | 388 | $itemExists = 0; |
| 389 | 389 | $newID = ''; |
| 390 | 390 | $data = DB::queryfirstrow( |
| 391 | - 'SELECT * FROM ' . prefixTable('items') . ' |
|
| 391 | + 'SELECT * FROM '.prefixTable('items').' |
|
| 392 | 392 | WHERE label = %s AND inactif = %i', |
| 393 | 393 | $inputData['label'], |
| 394 | 394 | 0 |
@@ -477,8 +477,8 @@ discard block |
||
| 477 | 477 | (int) $newID, |
| 478 | 478 | $objectKey['pwd'], |
| 479 | 479 | $SETTINGS, |
| 480 | - true, // only for the item creator |
|
| 481 | - false, // no delete all |
|
| 480 | + true, // only for the item creator |
|
| 481 | + false, // no delete all |
|
| 482 | 482 | ); |
| 483 | 483 | |
| 484 | 484 | // update fields |
@@ -491,7 +491,7 @@ discard block |
||
| 491 | 491 | // should we encrypt the data |
| 492 | 492 | $dataTmp = DB::queryFirstRow( |
| 493 | 493 | 'SELECT encrypted_data |
| 494 | - FROM ' . prefixTable('categories') . ' |
|
| 494 | + FROM ' . prefixTable('categories').' |
|
| 495 | 495 | WHERE id = %i', |
| 496 | 496 | $field['id'] |
| 497 | 497 | ); |
@@ -531,8 +531,8 @@ discard block |
||
| 531 | 531 | (int) $newObjectId, |
| 532 | 532 | $cryptedStuff['objectKey'], |
| 533 | 533 | $SETTINGS, |
| 534 | - true, // only for the item creator |
|
| 535 | - false, // no delete all |
|
| 534 | + true, // only for the item creator |
|
| 535 | + false, // no delete all |
|
| 536 | 536 | ); |
| 537 | 537 | |
| 538 | 538 | } else { |
@@ -561,7 +561,7 @@ discard block |
||
| 561 | 561 | ) { |
| 562 | 562 | DB::queryFirstRow( |
| 563 | 563 | 'SELECT * |
| 564 | - FROM ' . prefixTable('templates') . ' |
|
| 564 | + FROM ' . prefixTable('templates').' |
|
| 565 | 565 | WHERE item_id = %i', |
| 566 | 566 | $newID |
| 567 | 567 | ); |
@@ -630,11 +630,11 @@ discard block |
||
| 630 | 630 | ) { |
| 631 | 631 | foreach ($post_restricted_to as $userRest) { |
| 632 | 632 | if (empty($userRest) === false) { |
| 633 | - $dataTmp = DB::queryfirstrow('SELECT login FROM ' . prefixTable('users') . ' WHERE id= %i', $userRest); |
|
| 633 | + $dataTmp = DB::queryfirstrow('SELECT login FROM '.prefixTable('users').' WHERE id= %i', $userRest); |
|
| 634 | 634 | if (empty($listOfRestricted)) { |
| 635 | 635 | $listOfRestricted = $dataTmp['login']; |
| 636 | 636 | } else { |
| 637 | - $listOfRestricted .= ';' . $dataTmp['login']; |
|
| 637 | + $listOfRestricted .= ';'.$dataTmp['login']; |
|
| 638 | 638 | } |
| 639 | 639 | } |
| 640 | 640 | } |
@@ -648,11 +648,11 @@ discard block |
||
| 648 | 648 | if (empty($data['restricted_to']) === false) { |
| 649 | 649 | foreach (explode(';', $data['restricted_to']) as $userRest) { |
| 650 | 650 | if (empty($userRest) === false) { |
| 651 | - $dataTmp = DB::queryfirstrow('SELECT login FROM ' . prefixTable('users') . ' WHERE id= ' . $userRest); |
|
| 651 | + $dataTmp = DB::queryfirstrow('SELECT login FROM '.prefixTable('users').' WHERE id= '.$userRest); |
|
| 652 | 652 | if (empty($oldRestrictionList) === true) { |
| 653 | 653 | $oldRestrictionList = $dataTmp['login']; |
| 654 | 654 | } else { |
| 655 | - $oldRestrictionList .= ';' . $dataTmp['login']; |
|
| 655 | + $oldRestrictionList .= ';'.$dataTmp['login']; |
|
| 656 | 656 | } |
| 657 | 657 | } |
| 658 | 658 | } |
@@ -715,7 +715,7 @@ discard block |
||
| 715 | 715 | if (empty($post_uploaded_file_id) === false) { |
| 716 | 716 | $rows = DB::query( |
| 717 | 717 | 'SELECT id |
| 718 | - FROM ' . prefixTable('files') . ' |
|
| 718 | + FROM ' . prefixTable('files').' |
|
| 719 | 719 | WHERE id_item = %s', |
| 720 | 720 | $post_uploaded_file_id |
| 721 | 721 | ); |
@@ -769,7 +769,7 @@ discard block |
||
| 769 | 769 | $lang->get('email_subject_item_updated'), |
| 770 | 770 | str_replace( |
| 771 | 771 | array('#label', '#link'), |
| 772 | - array($path, $SETTINGS['email_server_url'] . '/index.php?page=items&group=' . $inputData['folderId'] . '&id=' . $newID . $txt['email_body3']), |
|
| 772 | + array($path, $SETTINGS['email_server_url'].'/index.php?page=items&group='.$inputData['folderId'].'&id='.$newID.$txt['email_body3']), |
|
| 773 | 773 | $lang->get('new_item_email_body') |
| 774 | 774 | ), |
| 775 | 775 | $emailAddress, |
@@ -897,8 +897,7 @@ discard block |
||
| 897 | 897 | $post_to_be_deleted_after_date = isset($dataReceived['to_be_deleted_after_date']) === true ? filter_var( |
| 898 | 898 | $dataReceived['to_be_deleted_after_date'], |
| 899 | 899 | FILTER_SANITIZE_FULL_SPECIAL_CHARS |
| 900 | - ) : |
|
| 901 | - ''; |
|
| 900 | + ) : ''; |
|
| 902 | 901 | $post_fields = (filter_var_array( |
| 903 | 902 | $dataReceived['fields'], |
| 904 | 903 | FILTER_SANITIZE_FULL_SPECIAL_CHARS |
@@ -955,7 +954,7 @@ discard block |
||
| 955 | 954 | // About special settings |
| 956 | 955 | $dataFolderSettings = DB::queryFirstRow( |
| 957 | 956 | 'SELECT bloquer_creation, bloquer_modification, personal_folder, title |
| 958 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 957 | + FROM ' . prefixTable('nested_tree').' |
|
| 959 | 958 | WHERE id = %i', |
| 960 | 959 | $inputData['folderId'] |
| 961 | 960 | ); |
@@ -971,7 +970,7 @@ discard block |
||
| 971 | 970 | // Get folder complexity |
| 972 | 971 | $folderComplexity = DB::queryfirstrow( |
| 973 | 972 | 'SELECT valeur |
| 974 | - FROM ' . prefixTable('misc') . ' |
|
| 973 | + FROM ' . prefixTable('misc').' |
|
| 975 | 974 | WHERE type = %s AND intitule = %i', |
| 976 | 975 | 'complex', |
| 977 | 976 | $inputData['folderId'] |
@@ -1009,8 +1008,8 @@ discard block |
||
| 1009 | 1008 | // Get all informations for this item |
| 1010 | 1009 | $dataItem = DB::queryfirstrow( |
| 1011 | 1010 | 'SELECT * |
| 1012 | - FROM ' . prefixTable('items') . ' as i |
|
| 1013 | - INNER JOIN ' . prefixTable('log_items') . ' as l ON (l.id_item = i.id) |
|
| 1011 | + FROM ' . prefixTable('items').' as i |
|
| 1012 | + INNER JOIN ' . prefixTable('log_items').' as l ON (l.id_item = i.id) |
|
| 1014 | 1013 | WHERE i.id=%i AND l.action = %s', |
| 1015 | 1014 | $inputData['itemId'], |
| 1016 | 1015 | 'at_creation' |
@@ -1020,7 +1019,7 @@ discard block |
||
| 1020 | 1019 | //db::debugmode(true); |
| 1021 | 1020 | DB::query( |
| 1022 | 1021 | 'SELECT * |
| 1023 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
| 1022 | + FROM ' . prefixTable('sharekeys_items').' |
|
| 1024 | 1023 | WHERE object_id = %i AND user_id = %s', |
| 1025 | 1024 | $inputData['itemId'], |
| 1026 | 1025 | $_SESSION['user_id'] |
@@ -1068,9 +1067,9 @@ discard block |
||
| 1068 | 1067 | '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, |
| 1069 | 1068 | 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, |
| 1070 | 1069 | u.login as user_login, u.email as user_email |
| 1071 | - FROM ' . prefixTable('items') . ' as i |
|
| 1072 | - INNER JOIN ' . prefixTable('log_items') . ' as l ON (i.id=l.id_item) |
|
| 1073 | - INNER JOIN ' . prefixTable('users') . ' as u ON (u.id=l.id_user) |
|
| 1070 | + FROM ' . prefixTable('items').' as i |
|
| 1071 | + INNER JOIN ' . prefixTable('log_items').' as l ON (i.id=l.id_item) |
|
| 1072 | + INNER JOIN ' . prefixTable('users').' as u ON (u.id=l.id_user) |
|
| 1074 | 1073 | WHERE i.id=%i', |
| 1075 | 1074 | $inputData['itemId'] |
| 1076 | 1075 | ); |
@@ -1078,7 +1077,7 @@ discard block |
||
| 1078 | 1077 | // Should we log a password change? |
| 1079 | 1078 | $userKey = DB::queryFirstRow( |
| 1080 | 1079 | 'SELECT share_key |
| 1081 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
| 1080 | + FROM ' . prefixTable('sharekeys_items').' |
|
| 1082 | 1081 | WHERE user_id = %i AND object_id = %i', |
| 1083 | 1082 | $_SESSION['user_id'], |
| 1084 | 1083 | $inputData['itemId'] |
@@ -1146,7 +1145,7 @@ discard block |
||
| 1146 | 1145 | // Get list of tags |
| 1147 | 1146 | $itemTags = DB::queryFirstColumn( |
| 1148 | 1147 | 'SELECT tag |
| 1149 | - FROM ' . prefixTable('tags') . ' |
|
| 1148 | + FROM ' . prefixTable('tags').' |
|
| 1150 | 1149 | WHERE item_id = %i', |
| 1151 | 1150 | $inputData['itemId'] |
| 1152 | 1151 | ); |
@@ -1192,7 +1191,7 @@ discard block |
||
| 1192 | 1191 | $_SESSION['user_id'], |
| 1193 | 1192 | 'at_modification', |
| 1194 | 1193 | $_SESSION['login'], |
| 1195 | - 'at_tag : ' . implode(' ', $itemTags) . ' => ' . $post_tags |
|
| 1194 | + 'at_tag : '.implode(' ', $itemTags).' => '.$post_tags |
|
| 1196 | 1195 | ); |
| 1197 | 1196 | } |
| 1198 | 1197 | |
@@ -1231,8 +1230,8 @@ discard block |
||
| 1231 | 1230 | 'SELECT c.id AS id, c.title AS title, i.data AS data, i.data_iv AS data_iv, |
| 1232 | 1231 | i.encryption_type AS encryption_type, c.encrypted_data AS encrypted_data, |
| 1233 | 1232 | c.masked AS masked, i.id AS field_item_id |
| 1234 | - FROM ' . prefixTable('categories_items') . ' AS i |
|
| 1235 | - INNER JOIN ' . prefixTable('categories') . ' AS c ON (i.field_id=c.id) |
|
| 1233 | + FROM ' . prefixTable('categories_items').' AS i |
|
| 1234 | + INNER JOIN ' . prefixTable('categories').' AS c ON (i.field_id=c.id) |
|
| 1236 | 1235 | WHERE i.field_id = %i AND i.item_id = %i', |
| 1237 | 1236 | $field['id'], |
| 1238 | 1237 | $inputData['itemId'] |
@@ -1246,7 +1245,7 @@ discard block |
||
| 1246 | 1245 | // Perform new query |
| 1247 | 1246 | $dataTmpCat = DB::queryFirstRow( |
| 1248 | 1247 | 'SELECT id, title, encrypted_data, masked |
| 1249 | - FROM ' . prefixTable('categories') . ' |
|
| 1248 | + FROM ' . prefixTable('categories').' |
|
| 1250 | 1249 | WHERE id = %i', |
| 1251 | 1250 | $field['id'] |
| 1252 | 1251 | ); |
@@ -1318,7 +1317,7 @@ discard block |
||
| 1318 | 1317 | $_SESSION['user_id'], |
| 1319 | 1318 | 'at_modification', |
| 1320 | 1319 | $_SESSION['login'], |
| 1321 | - 'at_field : ' . $dataTmpCat['title'] . ' : ' . $field['value'] |
|
| 1320 | + 'at_field : '.$dataTmpCat['title'].' : '.$field['value'] |
|
| 1322 | 1321 | ); |
| 1323 | 1322 | } else { |
| 1324 | 1323 | // compare the old and new value |
@@ -1326,7 +1325,7 @@ discard block |
||
| 1326 | 1325 | // Get user sharekey for this field |
| 1327 | 1326 | $userKey = DB::queryFirstRow( |
| 1328 | 1327 | 'SELECT share_key |
| 1329 | - FROM ' . prefixTable('sharekeys_fields') . ' |
|
| 1328 | + FROM ' . prefixTable('sharekeys_fields').' |
|
| 1330 | 1329 | WHERE user_id = %i AND object_id = %i', |
| 1331 | 1330 | $_SESSION['user_id'], |
| 1332 | 1331 | $dataTmpCat['field_item_id'] |
@@ -1400,7 +1399,7 @@ discard block |
||
| 1400 | 1399 | $_SESSION['user_id'], |
| 1401 | 1400 | 'at_modification', |
| 1402 | 1401 | $_SESSION['login'], |
| 1403 | - 'at_field : ' . $dataTmpCat['title'] . ' => ' . $oldVal |
|
| 1402 | + 'at_field : '.$dataTmpCat['title'].' => '.$oldVal |
|
| 1404 | 1403 | ); |
| 1405 | 1404 | } |
| 1406 | 1405 | } |
@@ -1425,7 +1424,7 @@ discard block |
||
| 1425 | 1424 | ) { |
| 1426 | 1425 | DB::queryFirstRow( |
| 1427 | 1426 | 'SELECT * |
| 1428 | - FROM ' . prefixTable('templates') . ' |
|
| 1427 | + FROM ' . prefixTable('templates').' |
|
| 1429 | 1428 | WHERE item_id = %i', |
| 1430 | 1429 | $inputData['itemId'] |
| 1431 | 1430 | ); |
@@ -1468,7 +1467,7 @@ discard block |
||
| 1468 | 1467 | // check if elem exists in Table. If not add it or update it. |
| 1469 | 1468 | DB::query( |
| 1470 | 1469 | 'SELECT * |
| 1471 | - FROM ' . prefixTable('automatic_del') . ' |
|
| 1470 | + FROM ' . prefixTable('automatic_del').' |
|
| 1472 | 1471 | WHERE item_id = %i', |
| 1473 | 1472 | $inputData['itemId'] |
| 1474 | 1473 | ); |
@@ -1495,7 +1494,7 @@ discard block |
||
| 1495 | 1494 | // Store updates performed |
| 1496 | 1495 | array_push( |
| 1497 | 1496 | $arrayOfChanges, |
| 1498 | - $lang->get('automatic_deletion_engaged') . ': ' . $lang->get('enabled') |
|
| 1497 | + $lang->get('automatic_deletion_engaged').': '.$lang->get('enabled') |
|
| 1499 | 1498 | ); |
| 1500 | 1499 | |
| 1501 | 1500 | // update LOG |
@@ -1538,7 +1537,7 @@ discard block |
||
| 1538 | 1537 | // Store updates performed |
| 1539 | 1538 | array_push( |
| 1540 | 1539 | $arrayOfChanges, |
| 1541 | - $lang->get('automatic_deletion_engaged') . ': ' . $lang->get('disabled') |
|
| 1540 | + $lang->get('automatic_deletion_engaged').': '.$lang->get('disabled') |
|
| 1542 | 1541 | ); |
| 1543 | 1542 | |
| 1544 | 1543 | // update LOG |
@@ -1571,7 +1570,7 @@ discard block |
||
| 1571 | 1570 | if (empty($userId) === false) { |
| 1572 | 1571 | $dataTmp = DB::queryfirstrow( |
| 1573 | 1572 | 'SELECT id, name, lastname |
| 1574 | - FROM ' . prefixTable('users') . ' |
|
| 1573 | + FROM ' . prefixTable('users').' |
|
| 1575 | 1574 | WHERE id= %i', |
| 1576 | 1575 | $userId |
| 1577 | 1576 | ); |
@@ -1579,7 +1578,7 @@ discard block |
||
| 1579 | 1578 | // Add to array |
| 1580 | 1579 | array_push( |
| 1581 | 1580 | $arrayOfUsersRestriction, |
| 1582 | - $dataTmp['name'] . ' ' . $dataTmp['lastname'] |
|
| 1581 | + $dataTmp['name'].' '.$dataTmp['lastname'] |
|
| 1583 | 1582 | ); |
| 1584 | 1583 | array_push( |
| 1585 | 1584 | $arrayOfUsersIdRestriction, |
@@ -1610,8 +1609,8 @@ discard block |
||
| 1610 | 1609 | // get values before deleting them |
| 1611 | 1610 | $rows = DB::query( |
| 1612 | 1611 | 'SELECT t.title, t.id AS id |
| 1613 | - FROM ' . prefixTable('roles_title') . ' as t |
|
| 1614 | - INNER JOIN ' . prefixTable('restriction_to_roles') . ' as r ON (t.id=r.role_id) |
|
| 1612 | + FROM ' . prefixTable('roles_title').' as t |
|
| 1613 | + INNER JOIN ' . prefixTable('restriction_to_roles').' as r ON (t.id=r.role_id) |
|
| 1615 | 1614 | WHERE r.item_id = %i |
| 1616 | 1615 | ORDER BY t.title ASC', |
| 1617 | 1616 | $inputData['itemId'] |
@@ -1645,7 +1644,7 @@ discard block |
||
| 1645 | 1644 | ); |
| 1646 | 1645 | $dataTmp = DB::queryfirstrow( |
| 1647 | 1646 | 'SELECT title |
| 1648 | - FROM ' . prefixTable('roles_title') . ' |
|
| 1647 | + FROM ' . prefixTable('roles_title').' |
|
| 1649 | 1648 | WHERE id = %i', |
| 1650 | 1649 | $role |
| 1651 | 1650 | ); |
@@ -1686,8 +1685,8 @@ discard block |
||
| 1686 | 1685 | $_SESSION['user_id'], |
| 1687 | 1686 | 'at_modification', |
| 1688 | 1687 | $_SESSION['login'], |
| 1689 | - 'at_restriction : ' . (count($diffUsersRestiction) > 0 ? |
|
| 1690 | - implode(', ', $arrayOfUsersRestriction) . (count($diffRolesRestiction) > 0 ? ', ' : '') : '') . (count($diffRolesRestiction) > 0 ? implode(', ', $arrayOfRestrictionRoles) : '') |
|
| 1688 | + 'at_restriction : '.(count($diffUsersRestiction) > 0 ? |
|
| 1689 | + implode(', ', $arrayOfUsersRestriction).(count($diffRolesRestiction) > 0 ? ', ' : '') : '').(count($diffRolesRestiction) > 0 ? implode(', ', $arrayOfRestrictionRoles) : '') |
|
| 1691 | 1690 | ); |
| 1692 | 1691 | } |
| 1693 | 1692 | |
@@ -1707,7 +1706,7 @@ discard block |
||
| 1707 | 1706 | $_SESSION['user_id'], |
| 1708 | 1707 | 'at_modification', |
| 1709 | 1708 | $_SESSION['login'], |
| 1710 | - 'at_label : ' . $data['label'] . ' => ' . $inputData['label'] |
|
| 1709 | + 'at_label : '.$data['label'].' => '.$inputData['label'] |
|
| 1711 | 1710 | ); |
| 1712 | 1711 | } |
| 1713 | 1712 | // LOGIN |
@@ -1726,7 +1725,7 @@ discard block |
||
| 1726 | 1725 | $_SESSION['user_id'], |
| 1727 | 1726 | 'at_modification', |
| 1728 | 1727 | $_SESSION['login'], |
| 1729 | - 'at_login : ' . $data['login'] . ' => ' . $post_login |
|
| 1728 | + 'at_login : '.$data['login'].' => '.$post_login |
|
| 1730 | 1729 | ); |
| 1731 | 1730 | } |
| 1732 | 1731 | |
@@ -1745,7 +1744,7 @@ discard block |
||
| 1745 | 1744 | $_SESSION['user_id'], |
| 1746 | 1745 | 'at_modification', |
| 1747 | 1746 | $_SESSION['login'], |
| 1748 | - 'at_email : ' . $data['email'] . ' => ' . $post_email |
|
| 1747 | + 'at_email : '.$data['email'].' => '.$post_email |
|
| 1749 | 1748 | ); |
| 1750 | 1749 | } |
| 1751 | 1750 | // URL |
@@ -1764,7 +1763,7 @@ discard block |
||
| 1764 | 1763 | $_SESSION['user_id'], |
| 1765 | 1764 | 'at_modification', |
| 1766 | 1765 | $_SESSION['login'], |
| 1767 | - 'at_url : ' . $data['url'] . ' => ' . $post_url |
|
| 1766 | + 'at_url : '.$data['url'].' => '.$post_url |
|
| 1768 | 1767 | ); |
| 1769 | 1768 | } |
| 1770 | 1769 | // DESCRIPTION |
@@ -1789,7 +1788,7 @@ discard block |
||
| 1789 | 1788 | // FOLDER |
| 1790 | 1789 | if ((int) $data['id_tree'] !== (int) $inputData['folderId']) { |
| 1791 | 1790 | // Get name of folders |
| 1792 | - $dataTmp = DB::query('SELECT title FROM ' . prefixTable('nested_tree') . ' WHERE id IN %li', array($data['id_tree'], $inputData['folderId'])); |
|
| 1791 | + $dataTmp = DB::query('SELECT title FROM '.prefixTable('nested_tree').' WHERE id IN %li', array($data['id_tree'], $inputData['folderId'])); |
|
| 1793 | 1792 | |
| 1794 | 1793 | // Store updates performed |
| 1795 | 1794 | array_push( |
@@ -1805,7 +1804,7 @@ discard block |
||
| 1805 | 1804 | $_SESSION['user_id'], |
| 1806 | 1805 | 'at_modification', |
| 1807 | 1806 | $_SESSION['login'], |
| 1808 | - 'at_category : ' . $dataTmp[0]['title'] . ' => ' . $dataTmp[1]['title'] |
|
| 1807 | + 'at_category : '.$dataTmp[0]['title'].' => '.$dataTmp[1]['title'] |
|
| 1809 | 1808 | ); |
| 1810 | 1809 | } |
| 1811 | 1810 | // ANYONE_CAN_MODIFY |
@@ -1813,7 +1812,7 @@ discard block |
||
| 1813 | 1812 | // Store updates performed |
| 1814 | 1813 | array_push( |
| 1815 | 1814 | $arrayOfChanges, |
| 1816 | - $lang->get('at_anyoneconmodify') . ': ' . ((int) $post_anyone_can_modify === 0 ? $lang->get('disabled') : $lang->get('enabled')) |
|
| 1815 | + $lang->get('at_anyoneconmodify').': '.((int) $post_anyone_can_modify === 0 ? $lang->get('disabled') : $lang->get('enabled')) |
|
| 1817 | 1816 | ); |
| 1818 | 1817 | |
| 1819 | 1818 | // Log |
@@ -1824,15 +1823,15 @@ discard block |
||
| 1824 | 1823 | $_SESSION['user_id'], |
| 1825 | 1824 | 'at_modification', |
| 1826 | 1825 | $_SESSION['login'], |
| 1827 | - 'at_anyoneconmodify : ' . ((int) $post_anyone_can_modify === 0 ? 'disabled' : 'enabled') |
|
| 1826 | + 'at_anyoneconmodify : '.((int) $post_anyone_can_modify === 0 ? 'disabled' : 'enabled') |
|
| 1828 | 1827 | ); |
| 1829 | 1828 | } |
| 1830 | 1829 | |
| 1831 | 1830 | // Reload new values |
| 1832 | 1831 | $dataItem = DB::queryfirstrow( |
| 1833 | 1832 | 'SELECT * |
| 1834 | - FROM ' . prefixTable('items') . ' as i |
|
| 1835 | - INNER JOIN ' . prefixTable('log_items') . ' as l ON (l.id_item = i.id) |
|
| 1833 | + FROM ' . prefixTable('items').' as i |
|
| 1834 | + INNER JOIN ' . prefixTable('log_items').' as l ON (l.id_item = i.id) |
|
| 1836 | 1835 | WHERE i.id = %i AND l.action = %s', |
| 1837 | 1836 | $inputData['itemId'], |
| 1838 | 1837 | 'at_creation' |
@@ -1841,8 +1840,8 @@ discard block |
||
| 1841 | 1840 | $history = ''; |
| 1842 | 1841 | $rows = DB::query( |
| 1843 | 1842 | 'SELECT l.date as date, l.action as action, l.raison as raison, u.login as login |
| 1844 | - FROM ' . prefixTable('log_items') . ' as l |
|
| 1845 | - LEFT JOIN ' . prefixTable('users') . ' as u ON (l.id_user=u.id) |
|
| 1843 | + FROM ' . prefixTable('log_items').' as l |
|
| 1844 | + LEFT JOIN ' . prefixTable('users').' as u ON (l.id_user=u.id) |
|
| 1846 | 1845 | WHERE l.action <> %s AND id_item=%s', |
| 1847 | 1846 | 'at_shown', |
| 1848 | 1847 | $inputData['itemId'] |
@@ -1851,14 +1850,14 @@ discard block |
||
| 1851 | 1850 | if ($record['raison'] === NULL) continue; |
| 1852 | 1851 | $reason = explode(':', $record['raison']); |
| 1853 | 1852 | if (count($reason) > 0) { |
| 1854 | - $sentence = date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['date']) . ' - ' |
|
| 1855 | - . $record['login'] . ' - ' . $lang->get($record['action']) . ' - ' |
|
| 1856 | - . (empty($record['raison']) === false ? (count($reason) > 1 ? $lang->get(trim($reason[0])) . ' : ' . $reason[1] |
|
| 1853 | + $sentence = date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['date']).' - ' |
|
| 1854 | + . $record['login'].' - '.$lang->get($record['action']).' - ' |
|
| 1855 | + . (empty($record['raison']) === false ? (count($reason) > 1 ? $lang->get(trim($reason[0])).' : '.$reason[1] |
|
| 1857 | 1856 | : $lang->get(trim($reason[0]))) : ''); |
| 1858 | 1857 | if (empty($history)) { |
| 1859 | 1858 | $history = $sentence; |
| 1860 | 1859 | } else { |
| 1861 | - $history .= '<br />' . $sentence; |
|
| 1860 | + $history .= '<br />'.$sentence; |
|
| 1862 | 1861 | } |
| 1863 | 1862 | } |
| 1864 | 1863 | } |
@@ -1985,7 +1984,7 @@ discard block |
||
| 1985 | 1984 | ) { |
| 1986 | 1985 | // load the original record into an array |
| 1987 | 1986 | $originalRecord = DB::queryfirstrow( |
| 1988 | - 'SELECT * FROM ' . prefixTable('items') . ' |
|
| 1987 | + 'SELECT * FROM '.prefixTable('items').' |
|
| 1989 | 1988 | WHERE id = %i', |
| 1990 | 1989 | $inputData['itemId'] |
| 1991 | 1990 | ); |
@@ -2004,7 +2003,7 @@ discard block |
||
| 2004 | 2003 | |
| 2005 | 2004 | // Load the destination folder record into an array |
| 2006 | 2005 | $dataDestination = DB::queryfirstrow( |
| 2007 | - 'SELECT personal_folder FROM ' . prefixTable('nested_tree') . ' |
|
| 2006 | + 'SELECT personal_folder FROM '.prefixTable('nested_tree').' |
|
| 2008 | 2007 | WHERE id = %i', |
| 2009 | 2008 | $post_dest_id |
| 2010 | 2009 | ); |
@@ -2012,7 +2011,7 @@ discard block |
||
| 2012 | 2011 | // Get the ITEM object key for the user |
| 2013 | 2012 | $userKey = DB::queryFirstRow( |
| 2014 | 2013 | 'SELECT share_key |
| 2015 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
| 2014 | + FROM ' . prefixTable('sharekeys_items').' |
|
| 2016 | 2015 | WHERE user_id = %i AND object_id = %i', |
| 2017 | 2016 | $_SESSION['user_id'], |
| 2018 | 2017 | $inputData['itemId'] |
@@ -2093,7 +2092,7 @@ discard block |
||
| 2093 | 2092 | // Manage Custom Fields |
| 2094 | 2093 | $rows = DB::query( |
| 2095 | 2094 | 'SELECT * |
| 2096 | - FROM ' . prefixTable('categories_items') . ' |
|
| 2095 | + FROM ' . prefixTable('categories_items').' |
|
| 2097 | 2096 | WHERE item_id = %i', |
| 2098 | 2097 | $inputData['itemId'] |
| 2099 | 2098 | ); |
@@ -2151,15 +2150,15 @@ discard block |
||
| 2151 | 2150 | $rows = DB::query( |
| 2152 | 2151 | 'SELECT f.id AS id, f.file AS file, f.name AS name, f.status AS status, f.extension AS extension, |
| 2153 | 2152 | f.size AS size, f.type AS type, s.share_key AS share_key |
| 2154 | - FROM ' . prefixTable('files') . ' AS f |
|
| 2155 | - INNER JOIN ' . prefixTable('sharekeys_files') . ' AS s ON (f.id = s.object_id) |
|
| 2153 | + FROM ' . prefixTable('files').' AS f |
|
| 2154 | + INNER JOIN ' . prefixTable('sharekeys_files').' AS s ON (f.id = s.object_id) |
|
| 2156 | 2155 | WHERE s.user_id = %i AND f.id_item = %i', |
| 2157 | 2156 | $_SESSION['user_id'], |
| 2158 | 2157 | $inputData['itemId'] |
| 2159 | 2158 | ); |
| 2160 | 2159 | foreach ($rows as $record) { |
| 2161 | 2160 | // Check if file still exists |
| 2162 | - if (file_exists($SETTINGS['path_to_upload_folder'] . DIRECTORY_SEPARATOR . TP_FILE_PREFIX . base64_decode($record['file'])) === true) { |
|
| 2161 | + if (file_exists($SETTINGS['path_to_upload_folder'].DIRECTORY_SEPARATOR.TP_FILE_PREFIX.base64_decode($record['file'])) === true) { |
|
| 2163 | 2162 | // Step1 - decrypt the file |
| 2164 | 2163 | $fileContent = decryptFile( |
| 2165 | 2164 | $record['file'], |
@@ -2168,8 +2167,8 @@ discard block |
||
| 2168 | 2167 | ); |
| 2169 | 2168 | |
| 2170 | 2169 | // Step2 - create file |
| 2171 | - $newFileName = md5(time() . '_' . $record['id']) . '.' . $record['extension']; |
|
| 2172 | - $outstream = fopen($SETTINGS['path_to_upload_folder'] . DIRECTORY_SEPARATOR . $newFileName, 'ab'); |
|
| 2170 | + $newFileName = md5(time().'_'.$record['id']).'.'.$record['extension']; |
|
| 2171 | + $outstream = fopen($SETTINGS['path_to_upload_folder'].DIRECTORY_SEPARATOR.$newFileName, 'ab'); |
|
| 2173 | 2172 | if ($outstream === false) { |
| 2174 | 2173 | echo prepareExchangedData( |
| 2175 | 2174 | array( |
@@ -2242,7 +2241,7 @@ discard block |
||
| 2242 | 2241 | |
| 2243 | 2242 | // ------------------------- |
| 2244 | 2243 | // Add specific restrictions |
| 2245 | - $rows = DB::query('SELECT * FROM ' . prefixTable('restriction_to_roles') . ' WHERE item_id = %i', $inputData['itemId']); |
|
| 2244 | + $rows = DB::query('SELECT * FROM '.prefixTable('restriction_to_roles').' WHERE item_id = %i', $inputData['itemId']); |
|
| 2246 | 2245 | foreach ($rows as $record) { |
| 2247 | 2246 | DB::insert( |
| 2248 | 2247 | prefixTable('restriction_to_roles'), |
@@ -2254,7 +2253,7 @@ discard block |
||
| 2254 | 2253 | } |
| 2255 | 2254 | |
| 2256 | 2255 | // Add Tags |
| 2257 | - $rows = DB::query('SELECT * FROM ' . prefixTable('tags') . ' WHERE item_id = %i', $inputData['itemId']); |
|
| 2256 | + $rows = DB::query('SELECT * FROM '.prefixTable('tags').' WHERE item_id = %i', $inputData['itemId']); |
|
| 2258 | 2257 | foreach ($rows as $record) { |
| 2259 | 2258 | DB::insert( |
| 2260 | 2259 | prefixTable('tags'), |
@@ -2284,7 +2283,7 @@ discard block |
||
| 2284 | 2283 | $_SESSION['login'] |
| 2285 | 2284 | ); |
| 2286 | 2285 | // reload cache table |
| 2287 | - include_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php'; |
|
| 2286 | + include_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php'; |
|
| 2288 | 2287 | updateCacheTable('reload', null); |
| 2289 | 2288 | |
| 2290 | 2289 | echo (string) prepareExchangedData( |
@@ -2355,7 +2354,7 @@ discard block |
||
| 2355 | 2354 | // then we can show it |
| 2356 | 2355 | $item_deleted = DB::queryFirstRow( |
| 2357 | 2356 | 'SELECT * |
| 2358 | - FROM ' . prefixTable('log_items') . ' |
|
| 2357 | + FROM ' . prefixTable('log_items').' |
|
| 2359 | 2358 | WHERE id_item = %i AND action = %s |
| 2360 | 2359 | ORDER BY date DESC |
| 2361 | 2360 | LIMIT 0, 1', |
@@ -2366,7 +2365,7 @@ discard block |
||
| 2366 | 2365 | |
| 2367 | 2366 | $item_restored = DB::queryFirstRow( |
| 2368 | 2367 | 'SELECT * |
| 2369 | - FROM ' . prefixTable('log_items') . ' |
|
| 2368 | + FROM ' . prefixTable('log_items').' |
|
| 2370 | 2369 | WHERE id_item = %i AND action = %s |
| 2371 | 2370 | ORDER BY date DESC |
| 2372 | 2371 | LIMIT 0, 1', |
@@ -2390,8 +2389,8 @@ discard block |
||
| 2390 | 2389 | // Get all informations for this item |
| 2391 | 2390 | $dataItem = DB::queryfirstrow( |
| 2392 | 2391 | 'SELECT * |
| 2393 | - FROM ' . prefixTable('items') . ' as i |
|
| 2394 | - INNER JOIN ' . prefixTable('log_items') . ' as l ON (l.id_item = i.id) |
|
| 2392 | + FROM ' . prefixTable('items').' as i |
|
| 2393 | + INNER JOIN ' . prefixTable('log_items').' as l ON (l.id_item = i.id) |
|
| 2395 | 2394 | WHERE i.id = %i AND l.action = %s', |
| 2396 | 2395 | $inputData['id'], |
| 2397 | 2396 | 'at_creation' |
@@ -2400,7 +2399,7 @@ discard block |
||
| 2400 | 2399 | // Notification |
| 2401 | 2400 | DB::queryfirstrow( |
| 2402 | 2401 | 'SELECT * |
| 2403 | - FROM ' . prefixTable('notification') . ' |
|
| 2402 | + FROM ' . prefixTable('notification').' |
|
| 2404 | 2403 | WHERE item_id = %i AND user_id = %i', |
| 2405 | 2404 | $inputData['id'], |
| 2406 | 2405 | $_SESSION['user_id'] |
@@ -2443,7 +2442,7 @@ discard block |
||
| 2443 | 2442 | |
| 2444 | 2443 | // manage case of API user |
| 2445 | 2444 | if ($dataItem['id_user'] === API_USER_ID) { |
| 2446 | - $arrData['author'] = 'API [' . $dataItem['description'] . ']'; |
|
| 2445 | + $arrData['author'] = 'API ['.$dataItem['description'].']'; |
|
| 2447 | 2446 | $arrData['id_user'] = API_USER_ID; |
| 2448 | 2447 | $arrData['author_email'] = ''; |
| 2449 | 2448 | $arrData['notification_status'] = false; |
@@ -2453,7 +2452,7 @@ discard block |
||
| 2453 | 2452 | $tags = array(); |
| 2454 | 2453 | $rows = DB::query( |
| 2455 | 2454 | 'SELECT tag |
| 2456 | - FROM ' . prefixTable('tags') . ' |
|
| 2455 | + FROM ' . prefixTable('tags').' |
|
| 2457 | 2456 | WHERE item_id = %i', |
| 2458 | 2457 | $inputData['id'] |
| 2459 | 2458 | ); |
@@ -2478,7 +2477,7 @@ discard block |
||
| 2478 | 2477 | // Check if user has a role that is accepted |
| 2479 | 2478 | $rows_tmp = DB::query( |
| 2480 | 2479 | 'SELECT role_id |
| 2481 | - FROM ' . prefixTable('restriction_to_roles') . ' |
|
| 2480 | + FROM ' . prefixTable('restriction_to_roles').' |
|
| 2482 | 2481 | WHERE item_id=%i', |
| 2483 | 2482 | $inputData['id'] |
| 2484 | 2483 | ); |
@@ -2492,7 +2491,7 @@ discard block |
||
| 2492 | 2491 | // Get the object key for the user |
| 2493 | 2492 | $userKey = DB::queryFirstRow( |
| 2494 | 2493 | 'SELECT share_key |
| 2495 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
| 2494 | + FROM ' . prefixTable('sharekeys_items').' |
|
| 2496 | 2495 | WHERE user_id = %i AND object_id = %i', |
| 2497 | 2496 | $_SESSION['user_id'], |
| 2498 | 2497 | $inputData['id'] |
@@ -2610,8 +2609,8 @@ discard block |
||
| 2610 | 2609 | // Add restriction if item is restricted to roles |
| 2611 | 2610 | $rows = DB::query( |
| 2612 | 2611 | 'SELECT t.title, t.id |
| 2613 | - FROM ' . prefixTable('roles_title') . ' AS t |
|
| 2614 | - INNER JOIN ' . prefixTable('restriction_to_roles') . ' AS r ON (t.id=r.role_id) |
|
| 2612 | + FROM ' . prefixTable('roles_title').' AS t |
|
| 2613 | + INNER JOIN ' . prefixTable('restriction_to_roles').' AS r ON (t.id=r.role_id) |
|
| 2615 | 2614 | WHERE r.item_id = %i |
| 2616 | 2615 | ORDER BY t.title ASC', |
| 2617 | 2616 | $inputData['id'] |
@@ -2627,8 +2626,8 @@ discard block |
||
| 2627 | 2626 | $tmp = array(); |
| 2628 | 2627 | $rows = DB::query( |
| 2629 | 2628 | 'SELECT k.label, k.id |
| 2630 | - FROM ' . prefixTable('kb_items') . ' as i |
|
| 2631 | - INNER JOIN ' . prefixTable('kb') . ' as k ON (i.kb_id=k.id) |
|
| 2629 | + FROM ' . prefixTable('kb_items').' as i |
|
| 2630 | + INNER JOIN ' . prefixTable('kb').' as k ON (i.kb_id=k.id) |
|
| 2632 | 2631 | WHERE i.item_id = %i |
| 2633 | 2632 | ORDER BY k.label ASC', |
| 2634 | 2633 | $inputData['id'] |
@@ -2711,7 +2710,7 @@ discard block |
||
| 2711 | 2710 | $arrCatList = array(); |
| 2712 | 2711 | $rows_tmp = DB::query( |
| 2713 | 2712 | 'SELECT id_category |
| 2714 | - FROM ' . prefixTable('categories_folders') . ' |
|
| 2713 | + FROM ' . prefixTable('categories_folders').' |
|
| 2715 | 2714 | WHERE id_folder=%i', |
| 2716 | 2715 | $inputData['folderId'] |
| 2717 | 2716 | ); |
@@ -2726,8 +2725,8 @@ discard block |
||
| 2726 | 2725 | 'SELECT i.id AS id, i.field_id AS field_id, i.data AS data, i.item_id AS item_id, |
| 2727 | 2726 | i.encryption_type AS encryption_type, c.encrypted_data AS encrypted_data, c.parent_id AS parent_id, |
| 2728 | 2727 | c.type as field_type, c.masked AS field_masked, c.role_visibility AS role_visibility |
| 2729 | - FROM ' . prefixTable('categories_items') . ' AS i |
|
| 2730 | - INNER JOIN ' . prefixTable('categories') . ' AS c ON (i.field_id=c.id) |
|
| 2728 | + FROM ' . prefixTable('categories_items').' AS i |
|
| 2729 | + INNER JOIN ' . prefixTable('categories').' AS c ON (i.field_id=c.id) |
|
| 2731 | 2730 | WHERE i.item_id=%i AND c.parent_id IN %ls', |
| 2732 | 2731 | $inputData['id'], |
| 2733 | 2732 | $arrCatList |
@@ -2738,7 +2737,7 @@ discard block |
||
| 2738 | 2737 | //db::debugmode(true); |
| 2739 | 2738 | $userKey = DB::queryFirstRow( |
| 2740 | 2739 | 'SELECT share_key |
| 2741 | - FROM ' . prefixTable('sharekeys_fields') . ' |
|
| 2740 | + FROM ' . prefixTable('sharekeys_fields').' |
|
| 2742 | 2741 | WHERE user_id = %i AND object_id = %i', |
| 2743 | 2742 | $_SESSION['user_id'], |
| 2744 | 2743 | $row['id'] |
@@ -2756,7 +2755,7 @@ discard block |
||
| 2756 | 2755 | } else if (DB::count() === 0 && (int) $row['encrypted_data'] === 0) { |
| 2757 | 2756 | // Data is not encrypted in DB |
| 2758 | 2757 | $fieldText = [ |
| 2759 | - 'string' => $row['data'],//#3945 - isBase64($row['data']) === true ? base64_decode($row['data']) : |
|
| 2758 | + 'string' => $row['data'], //#3945 - isBase64($row['data']) === true ? base64_decode($row['data']) : |
|
| 2760 | 2759 | 'encrypted' => false, |
| 2761 | 2760 | 'error' => false, |
| 2762 | 2761 | ]; |
@@ -2801,7 +2800,7 @@ discard block |
||
| 2801 | 2800 | if (isset($SETTINGS['item_creation_templates']) && (int) $SETTINGS['item_creation_templates'] === 1) { |
| 2802 | 2801 | $rows_tmp = DB::queryfirstrow( |
| 2803 | 2802 | 'SELECT category_id |
| 2804 | - FROM ' . prefixTable('templates') . ' |
|
| 2803 | + FROM ' . prefixTable('templates').' |
|
| 2805 | 2804 | WHERE item_id = %i', |
| 2806 | 2805 | $inputData['id'] |
| 2807 | 2806 | ); |
@@ -2818,7 +2817,7 @@ discard block |
||
| 2818 | 2817 | // Evaluate if item is ready for all users |
| 2819 | 2818 | $rows_tmp = DB::queryfirstrow( |
| 2820 | 2819 | 'SELECT finished_at |
| 2821 | - FROM ' . prefixTable('processes') . ' |
|
| 2820 | + FROM ' . prefixTable('processes').' |
|
| 2822 | 2821 | WHERE item_id = %i', |
| 2823 | 2822 | $inputData['id'] |
| 2824 | 2823 | ); |
@@ -2835,7 +2834,7 @@ discard block |
||
| 2835 | 2834 | // Is the Item to be deleted? |
| 2836 | 2835 | $dataDelete = DB::queryfirstrow( |
| 2837 | 2836 | 'SELECT * |
| 2838 | - FROM ' . prefixTable('automatic_del') . ' |
|
| 2837 | + FROM ' . prefixTable('automatic_del').' |
|
| 2839 | 2838 | WHERE item_id = %i', |
| 2840 | 2839 | $inputData['id'] |
| 2841 | 2840 | ); |
@@ -2914,11 +2913,11 @@ discard block |
||
| 2914 | 2913 | if (empty($dataItem['restricted_to']) === false) { |
| 2915 | 2914 | foreach (explode(';', $dataItem['restricted_to']) as $userRest) { |
| 2916 | 2915 | if (empty($userRest) === false) { |
| 2917 | - $dataTmp = DB::queryfirstrow('SELECT login FROM ' . prefixTable('users') . ' WHERE id= ' . $userRest); |
|
| 2916 | + $dataTmp = DB::queryfirstrow('SELECT login FROM '.prefixTable('users').' WHERE id= '.$userRest); |
|
| 2918 | 2917 | if (empty($listOfRestricted)) { |
| 2919 | 2918 | $listOfRestricted = $dataTmp['login']; |
| 2920 | 2919 | } else { |
| 2921 | - $listOfRestricted .= ';' . $dataTmp['login']; |
|
| 2920 | + $listOfRestricted .= ';'.$dataTmp['login']; |
|
| 2922 | 2921 | } |
| 2923 | 2922 | } |
| 2924 | 2923 | } |
@@ -2978,8 +2977,8 @@ discard block |
||
| 2978 | 2977 | // Load item data |
| 2979 | 2978 | $dataItem = DB::queryFirstRow( |
| 2980 | 2979 | 'SELECT i.*, n.title AS folder_title |
| 2981 | - FROM ' . prefixTable('items') . ' AS i |
|
| 2982 | - INNER JOIN ' . prefixTable('nested_tree') . ' AS n ON (i.id_tree = n.id) |
|
| 2980 | + FROM ' . prefixTable('items').' AS i |
|
| 2981 | + INNER JOIN ' . prefixTable('nested_tree').' AS n ON (i.id_tree = n.id) |
|
| 2983 | 2982 | WHERE i.id = %i', |
| 2984 | 2983 | $inputData['id'] |
| 2985 | 2984 | ); |
@@ -3001,7 +3000,7 @@ discard block |
||
| 3001 | 3000 | // Check if user has a role that is accepted |
| 3002 | 3001 | $rows_tmp = DB::query( |
| 3003 | 3002 | 'SELECT role_id |
| 3004 | - FROM ' . prefixTable('restriction_to_roles') . ' |
|
| 3003 | + FROM ' . prefixTable('restriction_to_roles').' |
|
| 3005 | 3004 | WHERE item_id=%i', |
| 3006 | 3005 | $inputData['id'] |
| 3007 | 3006 | ); |
@@ -3047,7 +3046,7 @@ discard block |
||
| 3047 | 3046 | // launch query |
| 3048 | 3047 | $rows = DB::query( |
| 3049 | 3048 | 'SELECT id, name, file, extension, size |
| 3050 | - FROM ' . prefixTable('files') . ' |
|
| 3049 | + FROM ' . prefixTable('files').' |
|
| 3051 | 3050 | WHERE id_item = %i AND confirmed = 1', |
| 3052 | 3051 | $inputData['id'] |
| 3053 | 3052 | ); |
@@ -3056,7 +3055,7 @@ discard block |
||
| 3056 | 3055 | $attachments, |
| 3057 | 3056 | array( |
| 3058 | 3057 | 'icon' => fileFormatImage(strtolower($record['extension'])), |
| 3059 | - 'filename' => basename($record['name'], '.' . $record['extension']), |
|
| 3058 | + 'filename' => basename($record['name'], '.'.$record['extension']), |
|
| 3060 | 3059 | 'extension' => $record['extension'], |
| 3061 | 3060 | 'size' => formatSizeUnits((int) $record['size']), |
| 3062 | 3061 | 'is_image' => in_array(strtolower($record['extension']), TP_IMAGE_FILE_EXT) === true ? 1 : 0, |
@@ -3082,7 +3081,7 @@ discard block |
||
| 3082 | 3081 | array( |
| 3083 | 3082 | 'latest_items' => implode(';', $_SESSION['latest_items']), |
| 3084 | 3083 | ), |
| 3085 | - 'id=' . $_SESSION['user_id'] |
|
| 3084 | + 'id='.$_SESSION['user_id'] |
|
| 3086 | 3085 | ); |
| 3087 | 3086 | } |
| 3088 | 3087 | |
@@ -3091,8 +3090,8 @@ discard block |
||
| 3091 | 3090 | $listOptionsForRoles = array(); |
| 3092 | 3091 | $rows = DB::query( |
| 3093 | 3092 | 'SELECT r.role_id AS role_id, t.title AS title |
| 3094 | - FROM ' . prefixTable('roles_values') . ' AS r |
|
| 3095 | - INNER JOIN ' . prefixTable('roles_title') . ' AS t ON (r.role_id = t.id) |
|
| 3093 | + FROM ' . prefixTable('roles_values').' AS r |
|
| 3094 | + INNER JOIN ' . prefixTable('roles_title').' AS t ON (r.role_id = t.id) |
|
| 3096 | 3095 | WHERE r.folder_id = %i', |
| 3097 | 3096 | $dataItem['id_tree'] |
| 3098 | 3097 | ); |
@@ -3106,9 +3105,9 @@ discard block |
||
| 3106 | 3105 | ); |
| 3107 | 3106 | $rows2 = DB::query( |
| 3108 | 3107 | 'SELECT id, login, fonction_id, email, name, lastname |
| 3109 | - FROM ' . prefixTable('users') . ' |
|
| 3108 | + FROM ' . prefixTable('users').' |
|
| 3110 | 3109 | WHERE fonction_id LIKE %s', |
| 3111 | - '%' . $record['role_id'] . '%' |
|
| 3110 | + '%'.$record['role_id'].'%' |
|
| 3112 | 3111 | ); |
| 3113 | 3112 | foreach ($rows2 as $record2) { |
| 3114 | 3113 | foreach (explode(';', $record2['fonction_id']) as $role) { |
@@ -3121,7 +3120,7 @@ discard block |
||
| 3121 | 3120 | array( |
| 3122 | 3121 | 'id' => (int) $record2['id'], |
| 3123 | 3122 | 'login' => $record2['login'], |
| 3124 | - 'name' => $record2['name'] . ' ' . $record2['lastname'], |
|
| 3123 | + 'name' => $record2['name'].' '.$record2['lastname'], |
|
| 3125 | 3124 | 'email' => $record2['email'], |
| 3126 | 3125 | ) |
| 3127 | 3126 | ); |
@@ -3140,16 +3139,16 @@ discard block |
||
| 3140 | 3139 | $path = ''; |
| 3141 | 3140 | foreach ($arbo as $elem) { |
| 3142 | 3141 | if (empty($path) === true) { |
| 3143 | - $path = htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES) . ' '; |
|
| 3142 | + $path = htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES).' '; |
|
| 3144 | 3143 | } else { |
| 3145 | - $path .= '→ ' . htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES); |
|
| 3144 | + $path .= '→ '.htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES); |
|
| 3146 | 3145 | } |
| 3147 | 3146 | } |
| 3148 | 3147 | // Build text to show user |
| 3149 | 3148 | if (empty($path) === true) { |
| 3150 | 3149 | $path = addslashes($dataItem['label']); |
| 3151 | 3150 | } else { |
| 3152 | - $path = addslashes($dataItem['label']) . ' (' . $path . ')'; |
|
| 3151 | + $path = addslashes($dataItem['label']).' ('.$path.')'; |
|
| 3153 | 3152 | } |
| 3154 | 3153 | |
| 3155 | 3154 | // Add Admins to notification list if expected |
@@ -3172,7 +3171,7 @@ discard block |
||
| 3172 | 3171 | array( |
| 3173 | 3172 | addslashes($_SESSION['login']), |
| 3174 | 3173 | $path, |
| 3175 | - $SETTINGS['cpassman_url'] . '/index.php?page=items&group=' . $dataItem['id_tree'] . '&id=' . $dataItem['id'], |
|
| 3174 | + $SETTINGS['cpassman_url'].'/index.php?page=items&group='.$dataItem['id_tree'].'&id='.$dataItem['id'], |
|
| 3176 | 3175 | ), |
| 3177 | 3176 | $lang->get('email_on_open_notification_mail') |
| 3178 | 3177 | ), |
@@ -3183,7 +3182,7 @@ discard block |
||
| 3183 | 3182 | } |
| 3184 | 3183 | |
| 3185 | 3184 | // has this item a change proposal |
| 3186 | - DB::query('SELECT * FROM ' . prefixTable('items_change') . ' WHERE item_id = %i', $inputData['id']); |
|
| 3185 | + DB::query('SELECT * FROM '.prefixTable('items_change').' WHERE item_id = %i', $inputData['id']); |
|
| 3187 | 3186 | $returnArray['has_change_proposal'] = DB::count(); |
| 3188 | 3187 | |
| 3189 | 3188 | // Setting |
@@ -3194,7 +3193,7 @@ discard block |
||
| 3194 | 3193 | if (isset($SETTINGS['otv_is_enabled']) === true && (int) $SETTINGS['otv_is_enabled'] === 1) { |
| 3195 | 3194 | DB::query( |
| 3196 | 3195 | 'SELECT * |
| 3197 | - FROM ' . prefixTable('otv') . ' |
|
| 3196 | + FROM ' . prefixTable('otv').' |
|
| 3198 | 3197 | WHERE item_id = %i |
| 3199 | 3198 | AND time_limit > %i', |
| 3200 | 3199 | $inputData['id'], |
@@ -3287,7 +3286,7 @@ discard block |
||
| 3287 | 3286 | // Load item data |
| 3288 | 3287 | $data = DB::queryFirstRow( |
| 3289 | 3288 | 'SELECT id_tree, id, label |
| 3290 | - FROM ' . prefixTable('items') . ' |
|
| 3289 | + FROM ' . prefixTable('items').' |
|
| 3291 | 3290 | WHERE id = %i OR item_key = %s', |
| 3292 | 3291 | $inputData['itemId'], |
| 3293 | 3292 | $inputData['itemKey'] |
@@ -3368,13 +3367,13 @@ discard block |
||
| 3368 | 3367 | |
| 3369 | 3368 | // Check if user is allowed to access this folder |
| 3370 | 3369 | if (!in_array($inputData['folderId'], $_SESSION['groupes_visibles'])) { |
| 3371 | - echo '[{"error" : "' . $lang->get('error_not_allowed_to') . '"}]'; |
|
| 3370 | + echo '[{"error" : "'.$lang->get('error_not_allowed_to').'"}]'; |
|
| 3372 | 3371 | break; |
| 3373 | 3372 | } |
| 3374 | 3373 | |
| 3375 | 3374 | // Check if title doesn't contains html codes |
| 3376 | 3375 | if (preg_match_all('|<[^>]+>(.*)</[^>]+>|U', $title, $out)) { |
| 3377 | - echo '[ { "error" : "' . $lang->get('error_html_codes') . '" } ]'; |
|
| 3376 | + echo '[ { "error" : "'.$lang->get('error_html_codes').'" } ]'; |
|
| 3378 | 3377 | break; |
| 3379 | 3378 | } |
| 3380 | 3379 | // check that title is not numeric |
@@ -3385,9 +3384,9 @@ discard block |
||
| 3385 | 3384 | |
| 3386 | 3385 | // Check if duplicate folders name are allowed |
| 3387 | 3386 | if (isset($SETTINGS['duplicate_folder']) && $SETTINGS['duplicate_folder'] === '0') { |
| 3388 | - $data = DB::queryFirstRow('SELECT id, title FROM ' . prefixTable('nested_tree') . ' WHERE title = %s', $title); |
|
| 3387 | + $data = DB::queryFirstRow('SELECT id, title FROM '.prefixTable('nested_tree').' WHERE title = %s', $title); |
|
| 3389 | 3388 | if (empty($data['id']) === false && $dataReceived['folder'] !== $data['id']) { |
| 3390 | - echo '[ { "error" : "' . $lang->get('error_group_exist') . '" } ]'; |
|
| 3389 | + echo '[ { "error" : "'.$lang->get('error_group_exist').'" } ]'; |
|
| 3391 | 3390 | break; |
| 3392 | 3391 | } |
| 3393 | 3392 | } |
@@ -3395,7 +3394,7 @@ discard block |
||
| 3395 | 3394 | // query on folder |
| 3396 | 3395 | $data = DB::queryfirstrow( |
| 3397 | 3396 | 'SELECT parent_id, personal_folder |
| 3398 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 3397 | + FROM ' . prefixTable('nested_tree').' |
|
| 3399 | 3398 | WHERE id = %i', |
| 3400 | 3399 | $inputData['folderId'] |
| 3401 | 3400 | ); |
@@ -3405,20 +3404,20 @@ discard block |
||
| 3405 | 3404 | if ($_SESSION['is_admin'] !== 1 && $_SESSION['user_manager'] !== 1 && $data['personal_folder'] === '0') { |
| 3406 | 3405 | $data = DB::queryfirstrow( |
| 3407 | 3406 | 'SELECT valeur |
| 3408 | - FROM ' . prefixTable('misc') . ' |
|
| 3407 | + FROM ' . prefixTable('misc').' |
|
| 3409 | 3408 | WHERE intitule = %i AND type = %s', |
| 3410 | 3409 | $data['parent_id'], |
| 3411 | 3410 | 'complex' |
| 3412 | 3411 | ); |
| 3413 | 3412 | if (intval($dataReceived['complexity']) < intval($data['valeur'])) { |
| 3414 | - echo '[ { "error" : "' . $lang->get('error_folder_complexity_lower_than_top_folder') . ' [<b>' . TP_PW_COMPLEXITY[$data['valeur']][1] . '</b>]"} ]'; |
|
| 3413 | + echo '[ { "error" : "'.$lang->get('error_folder_complexity_lower_than_top_folder').' [<b>'.TP_PW_COMPLEXITY[$data['valeur']][1].'</b>]"} ]'; |
|
| 3415 | 3414 | break; |
| 3416 | 3415 | } |
| 3417 | 3416 | } |
| 3418 | 3417 | |
| 3419 | 3418 | // update Folders table |
| 3420 | 3419 | $tmp = DB::queryFirstRow( |
| 3421 | - 'SELECT title, parent_id, personal_folder FROM ' . prefixTable('nested_tree') . ' WHERE id = %i', |
|
| 3420 | + 'SELECT title, parent_id, personal_folder FROM '.prefixTable('nested_tree').' WHERE id = %i', |
|
| 3422 | 3421 | $dataReceived['folder'] |
| 3423 | 3422 | ); |
| 3424 | 3423 | if ($tmp['parent_id'] !== 0 || $tmp['title'] !== $_SESSION['user_id'] || $tmp['personal_folder'] !== 1) { |
@@ -3486,42 +3485,42 @@ discard block |
||
| 3486 | 3485 | in_array($post_target_folder_id, $_SESSION['groupes_visibles']) === false) && ($post_target_folder_id === '0' && |
| 3487 | 3486 | isset($SETTINGS['can_create_root_folder']) === true && (int) $SETTINGS['can_create_root_folder'] === 1) |
| 3488 | 3487 | ) { |
| 3489 | - $returnValues = '[{"error" : "' . $lang->get('error_not_allowed_to') . '"}]'; |
|
| 3488 | + $returnValues = '[{"error" : "'.$lang->get('error_not_allowed_to').'"}]'; |
|
| 3490 | 3489 | echo $returnValues; |
| 3491 | 3490 | break; |
| 3492 | 3491 | } |
| 3493 | 3492 | |
| 3494 | 3493 | $tmp_source = DB::queryFirstRow( |
| 3495 | 3494 | 'SELECT title, parent_id, personal_folder |
| 3496 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 3495 | + FROM ' . prefixTable('nested_tree').' |
|
| 3497 | 3496 | WHERE id = %i', |
| 3498 | 3497 | $post_source_folder_id |
| 3499 | 3498 | ); |
| 3500 | 3499 | |
| 3501 | 3500 | $tmp_target = DB::queryFirstRow( |
| 3502 | 3501 | 'SELECT title, parent_id, personal_folder |
| 3503 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 3502 | + FROM ' . prefixTable('nested_tree').' |
|
| 3504 | 3503 | WHERE id = %i', |
| 3505 | 3504 | $post_target_folder_id |
| 3506 | 3505 | ); |
| 3507 | 3506 | |
| 3508 | 3507 | // check if target is not a child of source |
| 3509 | 3508 | if ($tree->isChildOf($post_target_folder_id, $post_source_folder_id) === true) { |
| 3510 | - $returnValues = '[{"error" : "' . $lang->get('error_not_allowed_to') . '"}]'; |
|
| 3509 | + $returnValues = '[{"error" : "'.$lang->get('error_not_allowed_to').'"}]'; |
|
| 3511 | 3510 | echo $returnValues; |
| 3512 | 3511 | break; |
| 3513 | 3512 | } |
| 3514 | 3513 | |
| 3515 | 3514 | // check if source or target folder is PF. If Yes, then cancel operation |
| 3516 | 3515 | if ((int) $tmp_source['personal_folder'] === 1 || (int) $tmp_target['personal_folder'] === 1) { |
| 3517 | - $returnValues = '[{"error" : "' . $lang->get('error_not_allowed_to') . '"}]'; |
|
| 3516 | + $returnValues = '[{"error" : "'.$lang->get('error_not_allowed_to').'"}]'; |
|
| 3518 | 3517 | echo $returnValues; |
| 3519 | 3518 | break; |
| 3520 | 3519 | } |
| 3521 | 3520 | |
| 3522 | 3521 | // check if source or target folder is PF. If Yes, then cancel operation |
| 3523 | 3522 | if ($tmp_source['title'] === $_SESSION['user_id'] || $tmp_target['title'] === $_SESSION['user_id']) { |
| 3524 | - $returnValues = '[{"error" : "' . $lang->get('error_not_allowed_to') . '"}]'; |
|
| 3523 | + $returnValues = '[{"error" : "'.$lang->get('error_not_allowed_to').'"}]'; |
|
| 3525 | 3524 | echo $returnValues; |
| 3526 | 3525 | break; |
| 3527 | 3526 | } |
@@ -3641,7 +3640,7 @@ discard block |
||
| 3641 | 3640 | $uniqueLoadData['path'] = $arr_arbo; |
| 3642 | 3641 | |
| 3643 | 3642 | // store last folder accessed in cookie |
| 3644 | - $arr_cookie_options = array ( |
|
| 3643 | + $arr_cookie_options = array( |
|
| 3645 | 3644 | 'expires' => time() + TP_ONE_DAY_SECONDS * 5, |
| 3646 | 3645 | 'path' => '/', |
| 3647 | 3646 | 'secure' => true, |
@@ -3659,7 +3658,7 @@ discard block |
||
| 3659 | 3658 | foreach ($_SESSION['user_roles'] as $role) { |
| 3660 | 3659 | $roleQ = DB::queryfirstrow( |
| 3661 | 3660 | 'SELECT allow_pw_change |
| 3662 | - FROM ' . prefixTable('roles_title') . ' |
|
| 3661 | + FROM ' . prefixTable('roles_title').' |
|
| 3663 | 3662 | WHERE id = %i', |
| 3664 | 3663 | $role |
| 3665 | 3664 | ); |
@@ -3684,11 +3683,11 @@ discard block |
||
| 3684 | 3683 | |
| 3685 | 3684 | foreach ($_SESSION['user_roles'] as $role) { |
| 3686 | 3685 | $access = DB::queryFirstRow( |
| 3687 | - 'SELECT type FROM ' . prefixTable('roles_values') . ' WHERE role_id = %i AND folder_id = %i', |
|
| 3686 | + 'SELECT type FROM '.prefixTable('roles_values').' WHERE role_id = %i AND folder_id = %i', |
|
| 3688 | 3687 | $role, |
| 3689 | 3688 | $inputData['id'] |
| 3690 | 3689 | ); |
| 3691 | - if (DB::count()>0) { |
|
| 3690 | + if (DB::count() > 0) { |
|
| 3692 | 3691 | if ($access['type'] === 'R') { |
| 3693 | 3692 | array_push($arrTmp, 10); |
| 3694 | 3693 | } elseif ($access['type'] === 'W') { |
@@ -3752,7 +3751,7 @@ discard block |
||
| 3752 | 3751 | } else { |
| 3753 | 3752 | DB::query( |
| 3754 | 3753 | 'SELECT * |
| 3755 | - FROM ' . prefixTable('items') . ' |
|
| 3754 | + FROM ' . prefixTable('items').' |
|
| 3756 | 3755 | WHERE inactif = %i', |
| 3757 | 3756 | 0 |
| 3758 | 3757 | ); |
@@ -3762,7 +3761,7 @@ discard block |
||
| 3762 | 3761 | |
| 3763 | 3762 | // Get folder complexity |
| 3764 | 3763 | $folderComplexity = DB::queryFirstRow( |
| 3765 | - 'SELECT valeur FROM ' . prefixTable('misc') . ' WHERE type = %s AND intitule = %i', |
|
| 3764 | + 'SELECT valeur FROM '.prefixTable('misc').' WHERE type = %s AND intitule = %i', |
|
| 3766 | 3765 | 'complex', |
| 3767 | 3766 | $inputData['id'] |
| 3768 | 3767 | ); |
@@ -3774,7 +3773,7 @@ discard block |
||
| 3774 | 3773 | if (isset($SETTINGS['item_extra_fields']) && (int) $SETTINGS['item_extra_fields'] === 1) { |
| 3775 | 3774 | $folderRow = DB::query( |
| 3776 | 3775 | 'SELECT id_category |
| 3777 | - FROM ' . prefixTable('categories_folders') . ' |
|
| 3776 | + FROM ' . prefixTable('categories_folders').' |
|
| 3778 | 3777 | WHERE id_folder = %i', |
| 3779 | 3778 | $inputData['id'] |
| 3780 | 3779 | ); |
@@ -3888,13 +3887,13 @@ discard block |
||
| 3888 | 3887 | // List all ITEMS |
| 3889 | 3888 | if ($folderIsPf === false) { |
| 3890 | 3889 | $where->add('i.inactif=%i', 0); |
| 3891 | - $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)"); |
|
| 3890 | + $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)"); |
|
| 3892 | 3891 | if (empty($limited_to_items) === false) { |
| 3893 | 3892 | $where->add('i.id IN %ls', explode(',', $limited_to_items)); |
| 3894 | 3893 | } |
| 3895 | 3894 | |
| 3896 | - $query_limit = ' LIMIT ' . |
|
| 3897 | - $start . ',' . |
|
| 3895 | + $query_limit = ' LIMIT '. |
|
| 3896 | + $start.','. |
|
| 3898 | 3897 | $post_nb_items_to_display_once; |
| 3899 | 3898 | //db::debugmode(true); |
| 3900 | 3899 | $rows = DB::query( |
@@ -3905,9 +3904,9 @@ discard block |
||
| 3905 | 3904 | MIN(l.action) AS log_action, |
| 3906 | 3905 | l.id_user AS log_user, |
| 3907 | 3906 | i.url AS link |
| 3908 | - FROM ' . prefixTable('items') . ' AS i |
|
| 3909 | - INNER JOIN ' . prefixTable('nested_tree') . ' AS n ON (i.id_tree = n.id) |
|
| 3910 | - INNER JOIN ' . prefixTable('log_items') . ' AS l ON (i.id = l.id_item) |
|
| 3907 | + FROM ' . prefixTable('items').' AS i |
|
| 3908 | + INNER JOIN ' . prefixTable('nested_tree').' AS n ON (i.id_tree = n.id) |
|
| 3909 | + INNER JOIN ' . prefixTable('log_items').' AS l ON (i.id = l.id_item) |
|
| 3911 | 3910 | WHERE %l |
| 3912 | 3911 | GROUP BY i.id, l.date, l.id_user, l.action |
| 3913 | 3912 | ORDER BY i.label ASC, l.date DESC' . $query_limit, |
@@ -3926,9 +3925,9 @@ discard block |
||
| 3926 | 3925 | MIN(l.action) AS log_action, |
| 3927 | 3926 | l.id_user AS log_user, |
| 3928 | 3927 | i.url AS link |
| 3929 | - FROM ' . prefixTable('items') . ' AS i |
|
| 3930 | - INNER JOIN ' . prefixTable('nested_tree') . ' AS n ON (i.id_tree = n.id) |
|
| 3931 | - INNER JOIN ' . prefixTable('log_items') . ' AS l ON (i.id = l.id_item) |
|
| 3928 | + FROM ' . prefixTable('items').' AS i |
|
| 3929 | + INNER JOIN ' . prefixTable('nested_tree').' AS n ON (i.id_tree = n.id) |
|
| 3930 | + INNER JOIN ' . prefixTable('log_items').' AS l ON (i.id = l.id_item) |
|
| 3932 | 3931 | WHERE %l |
| 3933 | 3932 | GROUP BY i.id, l.date, l.id_user, l.action |
| 3934 | 3933 | ORDER BY i.label ASC, l.date DESC', |
@@ -3959,7 +3958,7 @@ discard block |
||
| 3959 | 3958 | $item_is_restricted_to_role = false; |
| 3960 | 3959 | DB::queryfirstrow( |
| 3961 | 3960 | 'SELECT role_id |
| 3962 | - FROM ' . prefixTable('restriction_to_roles') . ' |
|
| 3961 | + FROM ' . prefixTable('restriction_to_roles').' |
|
| 3963 | 3962 | WHERE item_id = %i', |
| 3964 | 3963 | $record['id'] |
| 3965 | 3964 | ); |
@@ -3971,7 +3970,7 @@ discard block |
||
| 3971 | 3970 | $user_is_included_in_role = false; |
| 3972 | 3971 | DB::query( |
| 3973 | 3972 | 'SELECT role_id |
| 3974 | - FROM ' . prefixTable('restriction_to_roles') . ' |
|
| 3973 | + FROM ' . prefixTable('restriction_to_roles').' |
|
| 3975 | 3974 | WHERE item_id = %i AND role_id IN %ls', |
| 3976 | 3975 | $record['id'], |
| 3977 | 3976 | $_SESSION['user_roles'] |
@@ -4177,9 +4176,9 @@ discard block |
||
| 4177 | 4176 | if ((int) $start === 0) { |
| 4178 | 4177 | DB::query( |
| 4179 | 4178 | 'SELECT i.id |
| 4180 | - FROM ' . prefixTable('items') . ' as i |
|
| 4181 | - INNER JOIN ' . prefixTable('nested_tree') . ' as n ON (i.id_tree = n.id) |
|
| 4182 | - INNER JOIN ' . prefixTable('log_items') . ' as l ON (i.id = l.id_item) |
|
| 4179 | + FROM ' . prefixTable('items').' as i |
|
| 4180 | + INNER JOIN ' . prefixTable('nested_tree').' as n ON (i.id_tree = n.id) |
|
| 4181 | + INNER JOIN ' . prefixTable('log_items').' as l ON (i.id = l.id_item) |
|
| 4183 | 4182 | WHERE %l |
| 4184 | 4183 | ORDER BY i.label ASC, l.date DESC', |
| 4185 | 4184 | $where |
@@ -4243,8 +4242,8 @@ discard block |
||
| 4243 | 4242 | // Run query |
| 4244 | 4243 | $dataItem = DB::queryfirstrow( |
| 4245 | 4244 | 'SELECT i.pw AS pw, s.share_key AS share_key |
| 4246 | - FROM ' . prefixTable('items') . ' AS i |
|
| 4247 | - INNER JOIN ' . prefixTable('sharekeys_items') . ' AS s ON (s.object_id = i.id) |
|
| 4245 | + FROM ' . prefixTable('items').' AS i |
|
| 4246 | + INNER JOIN ' . prefixTable('sharekeys_items').' AS s ON (s.object_id = i.id) |
|
| 4248 | 4247 | WHERE user_id = %i AND i.item_key = %s', |
| 4249 | 4248 | $_SESSION['user_id'], |
| 4250 | 4249 | $inputData['itemKey'] |
@@ -4295,7 +4294,7 @@ discard block |
||
| 4295 | 4294 | if (null !== $inputData['itemId'] && empty($inputData['itemId']) === false) { |
| 4296 | 4295 | $dataItem = DB::queryfirstrow( |
| 4297 | 4296 | 'SELECT perso, anyone_can_modify |
| 4298 | - FROM ' . prefixTable('items') . ' |
|
| 4297 | + FROM ' . prefixTable('items').' |
|
| 4299 | 4298 | WHERE id=%i', |
| 4300 | 4299 | $inputData['itemId'] |
| 4301 | 4300 | ); |
@@ -4334,7 +4333,7 @@ discard block |
||
| 4334 | 4333 | */ |
| 4335 | 4334 | |
| 4336 | 4335 | // Lock Item (if already locked), go back and warn |
| 4337 | - $dataTmp = DB::queryFirstRow('SELECT timestamp, user_id FROM ' . prefixTable('items_edition') . ' WHERE item_id = %i', $inputData['itemId']); |
|
| 4336 | + $dataTmp = DB::queryFirstRow('SELECT timestamp, user_id FROM '.prefixTable('items_edition').' WHERE item_id = %i', $inputData['itemId']); |
|
| 4338 | 4337 | |
| 4339 | 4338 | // If token is taken for this Item and delay is passed then delete it. |
| 4340 | 4339 | if ( |
@@ -4345,7 +4344,7 @@ discard block |
||
| 4345 | 4344 | DB::delete(prefixTable('items_edition'), 'item_id = %i', $inputData['itemId']); |
| 4346 | 4345 | //reload the previous data |
| 4347 | 4346 | $dataTmp = DB::queryFirstRow( |
| 4348 | - 'SELECT timestamp, user_id FROM ' . prefixTable('items_edition') . ' WHERE item_id = %i', |
|
| 4347 | + 'SELECT timestamp, user_id FROM '.prefixTable('items_edition').' WHERE item_id = %i', |
|
| 4349 | 4348 | $inputData['itemId'] |
| 4350 | 4349 | ); |
| 4351 | 4350 | } |
@@ -4388,7 +4387,7 @@ discard block |
||
| 4388 | 4387 | // do query on this folder |
| 4389 | 4388 | $data_this_folder = DB::queryFirstRow( |
| 4390 | 4389 | 'SELECT id, personal_folder, title |
| 4391 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 4390 | + FROM ' . prefixTable('nested_tree').' |
|
| 4392 | 4391 | WHERE id = %s', |
| 4393 | 4392 | $inputData['folderId'] |
| 4394 | 4393 | ); |
@@ -4428,8 +4427,8 @@ discard block |
||
| 4428 | 4427 | $visibilite = ''; |
| 4429 | 4428 | $data = DB::queryFirstRow( |
| 4430 | 4429 | 'SELECT m.valeur, n.personal_folder |
| 4431 | - FROM ' . prefixTable('misc') . ' AS m |
|
| 4432 | - INNER JOIN ' . prefixTable('nested_tree') . ' AS n ON (m.intitule = n.id) |
|
| 4430 | + FROM ' . prefixTable('misc').' AS m |
|
| 4431 | + INNER JOIN ' . prefixTable('nested_tree').' AS n ON (m.intitule = n.id) |
|
| 4433 | 4432 | WHERE type=%s AND intitule = %s', |
| 4434 | 4433 | 'complex', |
| 4435 | 4434 | $inputData['folderId'] |
@@ -4442,8 +4441,8 @@ discard block |
||
| 4442 | 4441 | // Prepare Item actual visibility (what Users/Roles can see it) |
| 4443 | 4442 | $rows = DB::query( |
| 4444 | 4443 | 'SELECT t.title |
| 4445 | - FROM ' . prefixTable('roles_values') . ' as v |
|
| 4446 | - INNER JOIN ' . prefixTable('roles_title') . ' as t ON (v.role_id = t.id) |
|
| 4444 | + FROM ' . prefixTable('roles_values').' as v |
|
| 4445 | + INNER JOIN ' . prefixTable('roles_title').' as t ON (v.role_id = t.id) |
|
| 4447 | 4446 | WHERE v.folder_id = %i |
| 4448 | 4447 | GROUP BY title', |
| 4449 | 4448 | $inputData['folderId'] |
@@ -4452,7 +4451,7 @@ discard block |
||
| 4452 | 4451 | if (empty($visibilite)) { |
| 4453 | 4452 | $visibilite = $record['title']; |
| 4454 | 4453 | } else { |
| 4455 | - $visibilite .= ' - ' . $record['title']; |
|
| 4454 | + $visibilite .= ' - '.$record['title']; |
|
| 4456 | 4455 | } |
| 4457 | 4456 | } |
| 4458 | 4457 | } else { |
@@ -4462,14 +4461,14 @@ discard block |
||
| 4462 | 4461 | // do new query to know if current folder is pf |
| 4463 | 4462 | $data_pf = DB::queryFirstRow( |
| 4464 | 4463 | 'SELECT personal_folder |
| 4465 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 4464 | + FROM ' . prefixTable('nested_tree').' |
|
| 4466 | 4465 | WHERE id = %s', |
| 4467 | 4466 | $inputData['folderId'] |
| 4468 | 4467 | ); |
| 4469 | 4468 | |
| 4470 | 4469 | $folder_is_personal = $data_pf !== null ? (int) $data_pf['personal_folder'] : 0; |
| 4471 | 4470 | |
| 4472 | - $visibilite = $_SESSION['name'] . ' ' . $_SESSION['lastname'] . ' (' . $_SESSION['login'] . ')'; |
|
| 4471 | + $visibilite = $_SESSION['name'].' '.$_SESSION['lastname'].' ('.$_SESSION['login'].')'; |
|
| 4473 | 4472 | } |
| 4474 | 4473 | |
| 4475 | 4474 | recupDroitCreationSansComplexite($inputData['folderId']); |
@@ -4479,8 +4478,8 @@ discard block |
||
| 4479 | 4478 | $listOptionsForRoles = array(); |
| 4480 | 4479 | $rows = DB::query( |
| 4481 | 4480 | 'SELECT r.role_id AS role_id, t.title AS title |
| 4482 | - FROM ' . prefixTable('roles_values') . ' AS r |
|
| 4483 | - INNER JOIN ' . prefixTable('roles_title') . ' AS t ON (r.role_id = t.id) |
|
| 4481 | + FROM ' . prefixTable('roles_values').' AS r |
|
| 4482 | + INNER JOIN ' . prefixTable('roles_title').' AS t ON (r.role_id = t.id) |
|
| 4484 | 4483 | WHERE r.folder_id = %i', |
| 4485 | 4484 | $inputData['folderId'] |
| 4486 | 4485 | ); |
@@ -4494,7 +4493,7 @@ discard block |
||
| 4494 | 4493 | ); |
| 4495 | 4494 | $rows2 = DB::query( |
| 4496 | 4495 | 'SELECT id, login, fonction_id, email, name, lastname |
| 4497 | - FROM ' . prefixTable('users') . ' |
|
| 4496 | + FROM ' . prefixTable('users').' |
|
| 4498 | 4497 | WHERE admin = 0 AND fonction_id is not null' |
| 4499 | 4498 | ); |
| 4500 | 4499 | foreach ($rows2 as $record2) { |
@@ -4508,7 +4507,7 @@ discard block |
||
| 4508 | 4507 | array( |
| 4509 | 4508 | 'id' => $record2['id'], |
| 4510 | 4509 | 'login' => $record2['login'], |
| 4511 | - 'name' => $record2['name'] . ' ' . $record2['lastname'], |
|
| 4510 | + 'name' => $record2['name'].' '.$record2['lastname'], |
|
| 4512 | 4511 | 'email' => $record2['email'], |
| 4513 | 4512 | ) |
| 4514 | 4513 | ); |
@@ -4525,13 +4524,13 @@ discard block |
||
| 4525 | 4524 | //db::debugmode(true); |
| 4526 | 4525 | $access = DB::queryFirstRow( |
| 4527 | 4526 | 'SELECT type |
| 4528 | - FROM ' . prefixTable('roles_values') . ' |
|
| 4527 | + FROM ' . prefixTable('roles_values').' |
|
| 4529 | 4528 | WHERE role_id = %i AND folder_id = %i', |
| 4530 | 4529 | $role, |
| 4531 | 4530 | $inputData['folderId'] |
| 4532 | 4531 | ); |
| 4533 | 4532 | //db::debugmode(false); |
| 4534 | - if (DB::count()>0) { |
|
| 4533 | + if (DB::count() > 0) { |
|
| 4535 | 4534 | if ($access['type'] === 'R') { |
| 4536 | 4535 | array_push($arrTmp, 10); |
| 4537 | 4536 | } elseif ($access['type'] === 'W') { |
@@ -4604,7 +4603,7 @@ discard block |
||
| 4604 | 4603 | // Get some info before deleting |
| 4605 | 4604 | $data = DB::queryFirstRow( |
| 4606 | 4605 | 'SELECT name, id_item, file |
| 4607 | - FROM ' . prefixTable('files') . ' |
|
| 4606 | + FROM ' . prefixTable('files').' |
|
| 4608 | 4607 | WHERE id = %i', |
| 4609 | 4608 | $fileId |
| 4610 | 4609 | ); |
@@ -4612,7 +4611,7 @@ discard block |
||
| 4612 | 4611 | // Load item data |
| 4613 | 4612 | $data_item = DB::queryFirstRow( |
| 4614 | 4613 | 'SELECT id_tree |
| 4615 | - FROM ' . prefixTable('items') . ' |
|
| 4614 | + FROM ' . prefixTable('items').' |
|
| 4616 | 4615 | WHERE id = %i', |
| 4617 | 4616 | $data['id_item'] |
| 4618 | 4617 | ); |
@@ -4642,7 +4641,7 @@ discard block |
||
| 4642 | 4641 | $_SESSION['user_id'], |
| 4643 | 4642 | 'at_modification', |
| 4644 | 4643 | $_SESSION['login'], |
| 4645 | - 'at_del_file : ' . $data['name'] |
|
| 4644 | + 'at_del_file : '.$data['name'] |
|
| 4646 | 4645 | ); |
| 4647 | 4646 | |
| 4648 | 4647 | // DElete sharekeys |
@@ -4653,7 +4652,7 @@ discard block |
||
| 4653 | 4652 | ); |
| 4654 | 4653 | |
| 4655 | 4654 | // Delete file from server |
| 4656 | - fileDelete($SETTINGS['path_to_upload_folder'] . '/' . TP_FILE_PREFIX . base64_decode($data['file']), $SETTINGS); |
|
| 4655 | + fileDelete($SETTINGS['path_to_upload_folder'].'/'.TP_FILE_PREFIX.base64_decode($data['file']), $SETTINGS); |
|
| 4657 | 4656 | } |
| 4658 | 4657 | |
| 4659 | 4658 | echo (string) prepareExchangedData( |
@@ -4704,13 +4703,13 @@ discard block |
||
| 4704 | 4703 | // Update SESSION with this new favourite |
| 4705 | 4704 | $data = DB::queryfirstrow( |
| 4706 | 4705 | 'SELECT label,id_tree |
| 4707 | - FROM ' . prefixTable('items') . ' |
|
| 4706 | + FROM ' . prefixTable('items').' |
|
| 4708 | 4707 | WHERE id = %i', |
| 4709 | 4708 | $inputData['itemId'] |
| 4710 | 4709 | ); |
| 4711 | 4710 | $_SESSION['favourites_tab'][$inputData['itemId']] = array( |
| 4712 | 4711 | 'label' => $data['label'], |
| 4713 | - 'url' => 'index.php?page=items&group=' . $data['id_tree'] . '&id=' . $inputData['itemId'], |
|
| 4712 | + 'url' => 'index.php?page=items&group='.$data['id_tree'].'&id='.$inputData['itemId'], |
|
| 4714 | 4713 | ); |
| 4715 | 4714 | } elseif ((int) $inputData['action'] === 1) { |
| 4716 | 4715 | // delete from session |
@@ -4779,8 +4778,8 @@ discard block |
||
| 4779 | 4778 | // get data about item |
| 4780 | 4779 | $dataSource = DB::queryfirstrow( |
| 4781 | 4780 | 'SELECT i.pw, f.personal_folder,i.id_tree, f.title,i.label |
| 4782 | - FROM ' . prefixTable('items') . ' as i |
|
| 4783 | - INNER JOIN ' . prefixTable('nested_tree') . ' as f ON (i.id_tree=f.id) |
|
| 4781 | + FROM ' . prefixTable('items').' as i |
|
| 4782 | + INNER JOIN ' . prefixTable('nested_tree').' as f ON (i.id_tree=f.id) |
|
| 4784 | 4783 | WHERE i.id=%i', |
| 4785 | 4784 | $inputData['itemId'] |
| 4786 | 4785 | ); |
@@ -4788,7 +4787,7 @@ discard block |
||
| 4788 | 4787 | // get data about new folder |
| 4789 | 4788 | $dataDestination = DB::queryfirstrow( |
| 4790 | 4789 | 'SELECT personal_folder, title |
| 4791 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 4790 | + FROM ' . prefixTable('nested_tree').' |
|
| 4792 | 4791 | WHERE id = %i', |
| 4793 | 4792 | $inputData['folderId'] |
| 4794 | 4793 | ); |
@@ -4841,7 +4840,7 @@ discard block |
||
| 4841 | 4840 | // Get fields for this Item |
| 4842 | 4841 | $rows = DB::query( |
| 4843 | 4842 | 'SELECT id |
| 4844 | - FROM ' . prefixTable('categories_items') . ' |
|
| 4843 | + FROM ' . prefixTable('categories_items').' |
|
| 4845 | 4844 | WHERE item_id = %i', |
| 4846 | 4845 | $inputData['itemId'] |
| 4847 | 4846 | ); |
@@ -4858,7 +4857,7 @@ discard block |
||
| 4858 | 4857 | // Get FILES for this Item |
| 4859 | 4858 | $rows = DB::query( |
| 4860 | 4859 | 'SELECT id |
| 4861 | - FROM ' . prefixTable('files') . ' |
|
| 4860 | + FROM ' . prefixTable('files').' |
|
| 4862 | 4861 | WHERE id_item = %i', |
| 4863 | 4862 | $inputData['itemId'] |
| 4864 | 4863 | ); |
@@ -4905,7 +4904,7 @@ discard block |
||
| 4905 | 4904 | // Get the ITEM object key for the user |
| 4906 | 4905 | $userKey = DB::queryFirstRow( |
| 4907 | 4906 | 'SELECT share_key |
| 4908 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
| 4907 | + FROM ' . prefixTable('sharekeys_items').' |
|
| 4909 | 4908 | WHERE user_id = %i AND object_id = %i', |
| 4910 | 4909 | $_SESSION['user_id'], |
| 4911 | 4910 | $inputData['itemId'] |
@@ -4916,8 +4915,8 @@ discard block |
||
| 4916 | 4915 | // This is a public object |
| 4917 | 4916 | $users = DB::query( |
| 4918 | 4917 | 'SELECT id, public_key |
| 4919 | - FROM ' . prefixTable('users') . ' |
|
| 4920 | - WHERE id NOT IN ("' . OTV_USER_ID . '","' . SSH_USER_ID . '","' . API_USER_ID . '","' . $_SESSION['user_id'] . '") |
|
| 4918 | + FROM ' . prefixTable('users').' |
|
| 4919 | + WHERE id NOT IN ("' . OTV_USER_ID.'","'.SSH_USER_ID.'","'.API_USER_ID.'","'.$_SESSION['user_id'].'") |
|
| 4921 | 4920 | AND public_key != ""' |
| 4922 | 4921 | ); |
| 4923 | 4922 | foreach ($users as $user) { |
@@ -4937,14 +4936,14 @@ discard block |
||
| 4937 | 4936 | // Get fields for this Item |
| 4938 | 4937 | $rows = DB::query( |
| 4939 | 4938 | 'SELECT id |
| 4940 | - FROM ' . prefixTable('categories_items') . ' |
|
| 4939 | + FROM ' . prefixTable('categories_items').' |
|
| 4941 | 4940 | WHERE item_id = %i', |
| 4942 | 4941 | $inputData['itemId'] |
| 4943 | 4942 | ); |
| 4944 | 4943 | foreach ($rows as $field) { |
| 4945 | 4944 | $userKey = DB::queryFirstRow( |
| 4946 | 4945 | 'SELECT share_key |
| 4947 | - FROM ' . prefixTable('sharekeys_fields') . ' |
|
| 4946 | + FROM ' . prefixTable('sharekeys_fields').' |
|
| 4948 | 4947 | WHERE user_id = %i AND object_id = %i', |
| 4949 | 4948 | $_SESSION['user_id'], |
| 4950 | 4949 | $field['id'] |
@@ -4955,8 +4954,8 @@ discard block |
||
| 4955 | 4954 | // This is a public object |
| 4956 | 4955 | $users = DB::query( |
| 4957 | 4956 | 'SELECT id, public_key |
| 4958 | - FROM ' . prefixTable('users') . ' |
|
| 4959 | - WHERE id NOT IN ("' . OTV_USER_ID . '","' . SSH_USER_ID . '","' . API_USER_ID . '","' . $_SESSION['user_id'] . '") |
|
| 4957 | + FROM ' . prefixTable('users').' |
|
| 4958 | + WHERE id NOT IN ("' . OTV_USER_ID.'","'.SSH_USER_ID.'","'.API_USER_ID.'","'.$_SESSION['user_id'].'") |
|
| 4960 | 4959 | AND public_key != ""' |
| 4961 | 4960 | ); |
| 4962 | 4961 | foreach ($users as $user) { |
@@ -4977,14 +4976,14 @@ discard block |
||
| 4977 | 4976 | // Get FILES for this Item |
| 4978 | 4977 | $rows = DB::query( |
| 4979 | 4978 | 'SELECT id |
| 4980 | - FROM ' . prefixTable('files') . ' |
|
| 4979 | + FROM ' . prefixTable('files').' |
|
| 4981 | 4980 | WHERE id_item = %i', |
| 4982 | 4981 | $inputData['itemId'] |
| 4983 | 4982 | ); |
| 4984 | 4983 | foreach ($rows as $attachment) { |
| 4985 | 4984 | $userKey = DB::queryFirstRow( |
| 4986 | 4985 | 'SELECT share_key |
| 4987 | - FROM ' . prefixTable('sharekeys_files') . ' |
|
| 4986 | + FROM ' . prefixTable('sharekeys_files').' |
|
| 4988 | 4987 | WHERE user_id = %i AND object_id = %i', |
| 4989 | 4988 | $_SESSION['user_id'], |
| 4990 | 4989 | $attachment['id'] |
@@ -4995,8 +4994,8 @@ discard block |
||
| 4995 | 4994 | // This is a public object |
| 4996 | 4995 | $users = DB::query( |
| 4997 | 4996 | 'SELECT id, public_key |
| 4998 | - FROM ' . prefixTable('users') . ' |
|
| 4999 | - WHERE id NOT IN ("' . OTV_USER_ID . '","' . SSH_USER_ID . '","' . API_USER_ID . '","' . $_SESSION['user_id'] . '") |
|
| 4997 | + FROM ' . prefixTable('users').' |
|
| 4998 | + WHERE id NOT IN ("' . OTV_USER_ID.'","'.SSH_USER_ID.'","'.API_USER_ID.'","'.$_SESSION['user_id'].'") |
|
| 5000 | 4999 | AND public_key != ""' |
| 5001 | 5000 | ); |
| 5002 | 5001 | foreach ($users as $user) { |
@@ -5034,7 +5033,7 @@ discard block |
||
| 5034 | 5033 | $_SESSION['user_id'], |
| 5035 | 5034 | 'at_modification', |
| 5036 | 5035 | $_SESSION['login'], |
| 5037 | - 'at_moved : ' . $dataSource['title'] . ' -> ' . $dataDestination['title'] |
|
| 5036 | + 'at_moved : '.$dataSource['title'].' -> '.$dataDestination['title'] |
|
| 5038 | 5037 | ); |
| 5039 | 5038 | |
| 5040 | 5039 | // Update cache table |
@@ -5093,8 +5092,8 @@ discard block |
||
| 5093 | 5092 | // get data about item |
| 5094 | 5093 | $dataSource = DB::queryfirstrow( |
| 5095 | 5094 | 'SELECT i.pw, f.personal_folder,i.id_tree, f.title,i.label |
| 5096 | - FROM ' . prefixTable('items') . ' as i |
|
| 5097 | - INNER JOIN ' . prefixTable('nested_tree') . ' as f ON (i.id_tree=f.id) |
|
| 5095 | + FROM ' . prefixTable('items').' as i |
|
| 5096 | + INNER JOIN ' . prefixTable('nested_tree').' as f ON (i.id_tree=f.id) |
|
| 5098 | 5097 | WHERE i.id=%i', |
| 5099 | 5098 | $item_id |
| 5100 | 5099 | ); |
@@ -5116,7 +5115,7 @@ discard block |
||
| 5116 | 5115 | |
| 5117 | 5116 | // get data about new folder |
| 5118 | 5117 | $dataDestination = DB::queryfirstrow( |
| 5119 | - 'SELECT personal_folder, title FROM ' . prefixTable('nested_tree') . ' WHERE id = %i', |
|
| 5118 | + 'SELECT personal_folder, title FROM '.prefixTable('nested_tree').' WHERE id = %i', |
|
| 5120 | 5119 | $inputData['folderId'] |
| 5121 | 5120 | ); |
| 5122 | 5121 | |
@@ -5158,7 +5157,7 @@ discard block |
||
| 5158 | 5157 | // Get fields for this Item |
| 5159 | 5158 | $rows = DB::query( |
| 5160 | 5159 | 'SELECT id |
| 5161 | - FROM ' . prefixTable('categories_items') . ' |
|
| 5160 | + FROM ' . prefixTable('categories_items').' |
|
| 5162 | 5161 | WHERE item_id = %i', |
| 5163 | 5162 | $item_id |
| 5164 | 5163 | ); |
@@ -5175,7 +5174,7 @@ discard block |
||
| 5175 | 5174 | // Get FILES for this Item |
| 5176 | 5175 | $rows = DB::query( |
| 5177 | 5176 | 'SELECT id |
| 5178 | - FROM ' . prefixTable('files') . ' |
|
| 5177 | + FROM ' . prefixTable('files').' |
|
| 5179 | 5178 | WHERE id_item = %i', |
| 5180 | 5179 | $item_id |
| 5181 | 5180 | ); |
@@ -5230,7 +5229,7 @@ discard block |
||
| 5230 | 5229 | // Get the ITEM object key for the user |
| 5231 | 5230 | $userKey = DB::queryFirstRow( |
| 5232 | 5231 | 'SELECT share_key |
| 5233 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
| 5232 | + FROM ' . prefixTable('sharekeys_items').' |
|
| 5234 | 5233 | WHERE user_id = %i AND object_id = %i', |
| 5235 | 5234 | $_SESSION['user_id'], |
| 5236 | 5235 | $item_id |
@@ -5241,8 +5240,8 @@ discard block |
||
| 5241 | 5240 | // This is a public object |
| 5242 | 5241 | $users = DB::query( |
| 5243 | 5242 | 'SELECT id, public_key |
| 5244 | - FROM ' . prefixTable('users') . ' |
|
| 5245 | - WHERE id NOT IN ("' . OTV_USER_ID . '","' . SSH_USER_ID . '","' . API_USER_ID . '","' . $_SESSION['user_id'] . '") |
|
| 5243 | + FROM ' . prefixTable('users').' |
|
| 5244 | + WHERE id NOT IN ("' . OTV_USER_ID.'","'.SSH_USER_ID.'","'.API_USER_ID.'","'.$_SESSION['user_id'].'") |
|
| 5246 | 5245 | AND public_key != ""' |
| 5247 | 5246 | ); |
| 5248 | 5247 | foreach ($users as $user) { |
@@ -5262,14 +5261,14 @@ discard block |
||
| 5262 | 5261 | // Get fields for this Item |
| 5263 | 5262 | $rows = DB::query( |
| 5264 | 5263 | 'SELECT id |
| 5265 | - FROM ' . prefixTable('categories_items') . ' |
|
| 5264 | + FROM ' . prefixTable('categories_items').' |
|
| 5266 | 5265 | WHERE item_id = %i', |
| 5267 | 5266 | $item_id |
| 5268 | 5267 | ); |
| 5269 | 5268 | foreach ($rows as $field) { |
| 5270 | 5269 | $userKey = DB::queryFirstRow( |
| 5271 | 5270 | 'SELECT share_key |
| 5272 | - FROM ' . prefixTable('sharekeys_fields') . ' |
|
| 5271 | + FROM ' . prefixTable('sharekeys_fields').' |
|
| 5273 | 5272 | WHERE user_id = %i AND object_id = %i', |
| 5274 | 5273 | $_SESSION['user_id'], |
| 5275 | 5274 | $field['id'] |
@@ -5280,8 +5279,8 @@ discard block |
||
| 5280 | 5279 | // This is a public object |
| 5281 | 5280 | $users = DB::query( |
| 5282 | 5281 | 'SELECT id, public_key |
| 5283 | - FROM ' . prefixTable('users') . ' |
|
| 5284 | - WHERE id NOT IN ("' . OTV_USER_ID . '","' . SSH_USER_ID . '","' . API_USER_ID . '","' . $_SESSION['user_id'] . '") |
|
| 5282 | + FROM ' . prefixTable('users').' |
|
| 5283 | + WHERE id NOT IN ("' . OTV_USER_ID.'","'.SSH_USER_ID.'","'.API_USER_ID.'","'.$_SESSION['user_id'].'") |
|
| 5285 | 5284 | AND public_key != ""' |
| 5286 | 5285 | ); |
| 5287 | 5286 | foreach ($users as $user) { |
@@ -5302,14 +5301,14 @@ discard block |
||
| 5302 | 5301 | // Get FILES for this Item |
| 5303 | 5302 | $rows = DB::query( |
| 5304 | 5303 | 'SELECT id |
| 5305 | - FROM ' . prefixTable('files') . ' |
|
| 5304 | + FROM ' . prefixTable('files').' |
|
| 5306 | 5305 | WHERE id_item = %i', |
| 5307 | 5306 | $item_id |
| 5308 | 5307 | ); |
| 5309 | 5308 | foreach ($rows as $attachment) { |
| 5310 | 5309 | $userKey = DB::queryFirstRow( |
| 5311 | 5310 | 'SELECT share_key |
| 5312 | - FROM ' . prefixTable('sharekeys_files') . ' |
|
| 5311 | + FROM ' . prefixTable('sharekeys_files').' |
|
| 5313 | 5312 | WHERE user_id = %i AND object_id = %i', |
| 5314 | 5313 | $_SESSION['user_id'], |
| 5315 | 5314 | $attachment['id'] |
@@ -5320,8 +5319,8 @@ discard block |
||
| 5320 | 5319 | // This is a public object |
| 5321 | 5320 | $users = DB::query( |
| 5322 | 5321 | 'SELECT id, public_key |
| 5323 | - FROM ' . prefixTable('users') . ' |
|
| 5324 | - WHERE id NOT IN ("' . OTV_USER_ID . '","' . SSH_USER_ID . '","' . API_USER_ID . '","' . $_SESSION['user_id'] . '") |
|
| 5322 | + FROM ' . prefixTable('users').' |
|
| 5323 | + WHERE id NOT IN ("' . OTV_USER_ID.'","'.SSH_USER_ID.'","'.API_USER_ID.'","'.$_SESSION['user_id'].'") |
|
| 5325 | 5324 | AND public_key != ""' |
| 5326 | 5325 | ); |
| 5327 | 5326 | foreach ($users as $user) { |
@@ -5358,13 +5357,13 @@ discard block |
||
| 5358 | 5357 | $_SESSION['user_id'], |
| 5359 | 5358 | 'at_modification', |
| 5360 | 5359 | $_SESSION['login'], |
| 5361 | - 'at_moved : ' . $dataSource['title'] . ' -> ' . $dataDestination['title'] |
|
| 5360 | + 'at_moved : '.$dataSource['title'].' -> '.$dataDestination['title'] |
|
| 5362 | 5361 | ); |
| 5363 | 5362 | } |
| 5364 | 5363 | } |
| 5365 | 5364 | |
| 5366 | 5365 | // reload cache table |
| 5367 | - require_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php'; |
|
| 5366 | + require_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php'; |
|
| 5368 | 5367 | updateCacheTable('reload', null); |
| 5369 | 5368 | |
| 5370 | 5369 | echo (string) prepareExchangedData( |
@@ -5428,7 +5427,7 @@ discard block |
||
| 5428 | 5427 | // get info |
| 5429 | 5428 | $dataSource = DB::queryfirstrow( |
| 5430 | 5429 | 'SELECT label, id_tree |
| 5431 | - FROM ' . prefixTable('items') . ' |
|
| 5430 | + FROM ' . prefixTable('items').' |
|
| 5432 | 5431 | WHERE id=%i', |
| 5433 | 5432 | $item_id |
| 5434 | 5433 | ); |
@@ -5527,8 +5526,8 @@ discard block |
||
| 5527 | 5526 | } |
| 5528 | 5527 | if ($inputData['cat'] === 'request_access_to_author') { |
| 5529 | 5528 | // Variables |
| 5530 | - $dataAuthor = DB::queryfirstrow('SELECT email,login FROM ' . prefixTable('users') . ' WHERE id = ' . $post_content[1]); |
|
| 5531 | - $dataItem = DB::queryfirstrow('SELECT label, id_tree FROM ' . prefixTable('items') . ' WHERE id = ' . $post_content[0]); |
|
| 5529 | + $dataAuthor = DB::queryfirstrow('SELECT email,login FROM '.prefixTable('users').' WHERE id = '.$post_content[1]); |
|
| 5530 | + $dataItem = DB::queryfirstrow('SELECT label, id_tree FROM '.prefixTable('items').' WHERE id = '.$post_content[0]); |
|
| 5532 | 5531 | |
| 5533 | 5532 | // Get path |
| 5534 | 5533 | $path = geItemReadablePath( |
@@ -5542,7 +5541,7 @@ discard block |
||
| 5542 | 5541 | $lang->get('email_request_access_subject'), |
| 5543 | 5542 | str_replace( |
| 5544 | 5543 | array('#tp_item_author#', '#tp_user#', '#tp_item#'), |
| 5545 | - array(' ' . addslashes($dataAuthor['login']), addslashes($_SESSION['login']), $path), |
|
| 5544 | + array(' '.addslashes($dataAuthor['login']), addslashes($_SESSION['login']), $path), |
|
| 5546 | 5545 | $lang->get('email_request_access_mail') |
| 5547 | 5546 | ), |
| 5548 | 5547 | $dataAuthor['email'], |
@@ -5552,7 +5551,7 @@ discard block |
||
| 5552 | 5551 | } elseif ($inputData['cat'] === 'share_this_item') { |
| 5553 | 5552 | $dataItem = DB::queryfirstrow( |
| 5554 | 5553 | 'SELECT label,id_tree |
| 5555 | - FROM ' . prefixTable('items') . ' |
|
| 5554 | + FROM ' . prefixTable('items').' |
|
| 5556 | 5555 | WHERE id= %i', |
| 5557 | 5556 | $inputData['id'] |
| 5558 | 5557 | ); |
@@ -5575,7 +5574,7 @@ discard block |
||
| 5575 | 5574 | ), |
| 5576 | 5575 | array( |
| 5577 | 5576 | empty($SETTINGS['email_server_url']) === false ? |
| 5578 | - $SETTINGS['email_server_url'] . '/index.php?page=items&group=' . $dataItem['id_tree'] . '&id=' . $inputData['id'] : $SETTINGS['cpassman_url'] . '/index.php?page=items&group=' . $dataItem['id_tree'] . '&id=' . $inputData['id'], |
|
| 5577 | + $SETTINGS['email_server_url'].'/index.php?page=items&group='.$dataItem['id_tree'].'&id='.$inputData['id'] : $SETTINGS['cpassman_url'].'/index.php?page=items&group='.$dataItem['id_tree'].'&id='.$inputData['id'], |
|
| 5579 | 5578 | addslashes($_SESSION['login']), |
| 5580 | 5579 | addslashes($path), |
| 5581 | 5580 | ), |
@@ -5675,8 +5674,8 @@ discard block |
||
| 5675 | 5674 | // Get all informations for this item |
| 5676 | 5675 | $dataItem = DB::queryfirstrow( |
| 5677 | 5676 | 'SELECT * |
| 5678 | - FROM ' . prefixTable('items') . ' as i |
|
| 5679 | - INNER JOIN ' . prefixTable('log_items') . ' as l ON (l.id_item = i.id) |
|
| 5677 | + FROM ' . prefixTable('items').' as i |
|
| 5678 | + INNER JOIN ' . prefixTable('log_items').' as l ON (l.id_item = i.id) |
|
| 5680 | 5679 | WHERE i.id=%i AND l.action = %s', |
| 5681 | 5680 | $item_id, |
| 5682 | 5681 | 'at_creation' |
@@ -5705,18 +5704,18 @@ discard block |
||
| 5705 | 5704 | $_SESSION['login'], |
| 5706 | 5705 | htmlspecialchars_decode($label, ENT_QUOTES), |
| 5707 | 5706 | null, |
| 5708 | - (string) dateToStamp($date.' '.$time, $SETTINGS['date_format'] . ' ' . $SETTINGS['time_format']) |
|
| 5707 | + (string) dateToStamp($date.' '.$time, $SETTINGS['date_format'].' '.$SETTINGS['time_format']) |
|
| 5709 | 5708 | ); |
| 5710 | 5709 | // Prepare new line |
| 5711 | 5710 | $data = DB::queryfirstrow( |
| 5712 | - 'SELECT * FROM ' . prefixTable('log_items') . ' WHERE id_item = %i ORDER BY date DESC', |
|
| 5711 | + 'SELECT * FROM '.prefixTable('log_items').' WHERE id_item = %i ORDER BY date DESC', |
|
| 5713 | 5712 | $item_id |
| 5714 | 5713 | ); |
| 5715 | - $historic = date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $data['date']) . ' - ' . $_SESSION['login'] . ' - ' . $lang->get($data['action']) . ' - ' . $data['raison']; |
|
| 5714 | + $historic = date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $data['date']).' - '.$_SESSION['login'].' - '.$lang->get($data['action']).' - '.$data['raison']; |
|
| 5716 | 5715 | // send back |
| 5717 | 5716 | $data = array( |
| 5718 | 5717 | 'error' => '', |
| 5719 | - 'new_line' => '<br>' . addslashes($historic), |
|
| 5718 | + 'new_line' => '<br>'.addslashes($historic), |
|
| 5720 | 5719 | ); |
| 5721 | 5720 | echo (string) prepareExchangedData( |
| 5722 | 5721 | $data, |
@@ -5788,7 +5787,7 @@ discard block |
||
| 5788 | 5787 | ); |
| 5789 | 5788 | |
| 5790 | 5789 | // delete all existing old otv codes |
| 5791 | - $rows = DB::query('SELECT id FROM ' . prefixTable('otv') . ' WHERE time_limit < ' . time()); |
|
| 5790 | + $rows = DB::query('SELECT id FROM '.prefixTable('otv').' WHERE time_limit < '.time()); |
|
| 5792 | 5791 | foreach ($rows as $record) { |
| 5793 | 5792 | DB::delete(prefixTable('otv'), 'id=%i', $record['id']); |
| 5794 | 5793 | } |
@@ -5810,8 +5809,8 @@ discard block |
||
| 5810 | 5809 | // Should we log a password change? |
| 5811 | 5810 | $itemQ = DB::queryFirstRow( |
| 5812 | 5811 | 'SELECT s.share_key, i.pw |
| 5813 | - FROM ' . prefixTable('items') . ' AS i |
|
| 5814 | - INNER JOIN ' . prefixTable('sharekeys_items') . ' AS s ON (i.id = s.object_id) |
|
| 5812 | + FROM ' . prefixTable('items').' AS i |
|
| 5813 | + INNER JOIN ' . prefixTable('sharekeys_items').' AS s ON (i.id = s.object_id) |
|
| 5815 | 5814 | WHERE s.user_id = %i AND s.object_id = %i', |
| 5816 | 5815 | $_SESSION['user_id'], |
| 5817 | 5816 | $dataReceived['id'] |
@@ -5864,7 +5863,7 @@ discard block |
||
| 5864 | 5863 | if (isset($SETTINGS['otv_expiration_period']) === false) { |
| 5865 | 5864 | $SETTINGS['otv_expiration_period'] = 7; |
| 5866 | 5865 | } |
| 5867 | - $url = $SETTINGS['cpassman_url'] . '/index.php?otv=true&' . http_build_query($otv_session); |
|
| 5866 | + $url = $SETTINGS['cpassman_url'].'/index.php?otv=true&'.http_build_query($otv_session); |
|
| 5868 | 5867 | |
| 5869 | 5868 | echo json_encode( |
| 5870 | 5869 | array( |
@@ -5906,7 +5905,7 @@ discard block |
||
| 5906 | 5905 | ); |
| 5907 | 5906 | |
| 5908 | 5907 | $data = DB::queryFirstRow( |
| 5909 | - 'SELECT * FROM ' . prefixTable('otv') . ' WHERE id = %i', |
|
| 5908 | + 'SELECT * FROM '.prefixTable('otv').' WHERE id = %i', |
|
| 5910 | 5909 | $dataReceived['otv_id'] |
| 5911 | 5910 | ); |
| 5912 | 5911 | |
@@ -5915,13 +5914,13 @@ discard block |
||
| 5915 | 5914 | $domain_scheme = parse_url($SETTINGS['cpassman_url'], PHP_URL_SCHEME); |
| 5916 | 5915 | $domain_host = parse_url($SETTINGS['cpassman_url'], PHP_URL_HOST); |
| 5917 | 5916 | if (str_contains($domain_host, 'www.') === true) { |
| 5918 | - $domain_host = (string) $SETTINGS['otv_subdomain'] . '.' . substr($domain_host, 4); |
|
| 5917 | + $domain_host = (string) $SETTINGS['otv_subdomain'].'.'.substr($domain_host, 4); |
|
| 5919 | 5918 | } else { |
| 5920 | - $domain_host = (string) $SETTINGS['otv_subdomain'] . '.' . $domain_host; |
|
| 5919 | + $domain_host = (string) $SETTINGS['otv_subdomain'].'.'.$domain_host; |
|
| 5921 | 5920 | } |
| 5922 | - $url = $domain_scheme.'://'.$domain_host . '/index.php?otv=true&code=' . $data['code'] . '&key=' . $data['encrypted'] . '&stamp=' . $data['time_limit']; |
|
| 5921 | + $url = $domain_scheme.'://'.$domain_host.'/index.php?otv=true&code='.$data['code'].'&key='.$data['encrypted'].'&stamp='.$data['time_limit']; |
|
| 5923 | 5922 | } else { |
| 5924 | - $url = $SETTINGS['cpassman_url'] . '/index.php?otv=true&code=' . $data['code'] . '&key=' . $data['encrypted'] . '&stamp=' . $data['time_limit']; |
|
| 5923 | + $url = $SETTINGS['cpassman_url'].'/index.php?otv=true&code='.$data['code'].'&key='.$data['encrypted'].'&stamp='.$data['time_limit']; |
|
| 5925 | 5924 | } |
| 5926 | 5925 | |
| 5927 | 5926 | echo (string) prepareExchangedData( |
@@ -5956,8 +5955,8 @@ discard block |
||
| 5956 | 5955 | 'SELECT f.id AS id, f.file AS file, f.name AS name, f.status AS status, |
| 5957 | 5956 | f.extension AS extension, f.type AS type, |
| 5958 | 5957 | s.share_key AS share_key |
| 5959 | - FROM ' . prefixTable('files') . ' AS f |
|
| 5960 | - INNER JOIN ' . prefixTable('sharekeys_files') . ' AS s ON (f.id = s.object_id) |
|
| 5958 | + FROM ' . prefixTable('files').' AS f |
|
| 5959 | + INNER JOIN ' . prefixTable('sharekeys_files').' AS s ON (f.id = s.object_id) |
|
| 5961 | 5960 | WHERE s.user_id = %i AND s.object_id = %i', |
| 5962 | 5961 | $_SESSION['user_id'], |
| 5963 | 5962 | $inputData['id'] |
@@ -5978,7 +5977,7 @@ discard block |
||
| 5978 | 5977 | //$fileName = basename($file_info['name'], '.'.$file_info['extension']); |
| 5979 | 5978 | |
| 5980 | 5979 | // prepare image info |
| 5981 | - $post_title = basename($file_info['name'], '.' . $file_info['extension']); |
|
| 5980 | + $post_title = basename($file_info['name'], '.'.$file_info['extension']); |
|
| 5982 | 5981 | $post_title = isBase64($post_title) === true ? |
| 5983 | 5982 | base64_decode($post_title) : $post_title; |
| 5984 | 5983 | $image_code = $file_info['file']; |
@@ -5995,7 +5994,7 @@ discard block |
||
| 5995 | 5994 | echo (string) prepareExchangedData( |
| 5996 | 5995 | array( |
| 5997 | 5996 | 'error' => false, |
| 5998 | - 'filename' => $post_title . '.' . $file_info['extension'], |
|
| 5997 | + 'filename' => $post_title.'.'.$file_info['extension'], |
|
| 5999 | 5998 | 'file_type' => $file_info['type'], |
| 6000 | 5999 | 'file_content' => $fileContent, |
| 6001 | 6000 | ), |
@@ -6048,16 +6047,16 @@ discard block |
||
| 6048 | 6047 | $idFolder = $dataReceived['idFolder']; |
| 6049 | 6048 | |
| 6050 | 6049 | // don't check if Personal Folder |
| 6051 | - $data = DB::queryFirstRow('SELECT title FROM ' . prefixTable('nested_tree') . ' WHERE id = %i', $idFolder); |
|
| 6050 | + $data = DB::queryFirstRow('SELECT title FROM '.prefixTable('nested_tree').' WHERE id = %i', $idFolder); |
|
| 6052 | 6051 | if ($data['title'] === $_SESSION['user_id']) { |
| 6053 | 6052 | // send data |
| 6054 | - echo '[{"duplicate" : "' . $duplicate . '" , error" : ""}]'; |
|
| 6053 | + echo '[{"duplicate" : "'.$duplicate.'" , error" : ""}]'; |
|
| 6055 | 6054 | } else { |
| 6056 | 6055 | if ($inputData['option'] === 'same_folder') { |
| 6057 | 6056 | // case unique folder |
| 6058 | 6057 | DB::query( |
| 6059 | 6058 | 'SELECT label |
| 6060 | - FROM ' . prefixTable('items') . ' |
|
| 6059 | + FROM ' . prefixTable('items').' |
|
| 6061 | 6060 | WHERE id_tree = %i AND label = %s', |
| 6062 | 6061 | $idFolder, |
| 6063 | 6062 | $label |
@@ -6069,7 +6068,7 @@ discard block |
||
| 6069 | 6068 | $arrayPf = array(); |
| 6070 | 6069 | if (empty($row['id']) === false) { |
| 6071 | 6070 | $rows = DB::query( |
| 6072 | - 'SELECT id FROM ' . prefixTable('nested_tree') . ' WHERE personal_folder = %i', |
|
| 6071 | + 'SELECT id FROM '.prefixTable('nested_tree').' WHERE personal_folder = %i', |
|
| 6073 | 6072 | '1' |
| 6074 | 6073 | ); |
| 6075 | 6074 | foreach ($rows as $record) { |
@@ -6084,12 +6083,12 @@ discard block |
||
| 6084 | 6083 | $where->add('id_tree = %i', $idFolder); |
| 6085 | 6084 | $where->add('label = %s', $label); |
| 6086 | 6085 | if (empty($arrayPf) === false) { |
| 6087 | - $where->add('id_tree NOT IN (' . implode(',', $arrayPf) . ')'); |
|
| 6086 | + $where->add('id_tree NOT IN ('.implode(',', $arrayPf).')'); |
|
| 6088 | 6087 | } |
| 6089 | 6088 | |
| 6090 | 6089 | DB::query( |
| 6091 | 6090 | 'SELECT label |
| 6092 | - FROM ' . prefixTable('items') . ' |
|
| 6091 | + FROM ' . prefixTable('items').' |
|
| 6093 | 6092 | WHERE %l', |
| 6094 | 6093 | $where |
| 6095 | 6094 | ); |
@@ -6101,7 +6100,7 @@ discard block |
||
| 6101 | 6100 | } |
| 6102 | 6101 | |
| 6103 | 6102 | // send data |
| 6104 | - echo '[{"duplicate" : "' . $duplicate . '" , "error" : ""}]'; |
|
| 6103 | + echo '[{"duplicate" : "'.$duplicate.'" , "error" : ""}]'; |
|
| 6105 | 6104 | } |
| 6106 | 6105 | break; |
| 6107 | 6106 | |
@@ -6144,7 +6143,7 @@ discard block |
||
| 6144 | 6143 | if (isset($dataReceived['force_refresh_cache']) === true && $dataReceived['force_refresh_cache'] === false) { |
| 6145 | 6144 | $goCachedFolders = loadFoldersListByCache('visible_folders', 'folders'); |
| 6146 | 6145 | if ($goCachedFolders['state'] === true) { |
| 6147 | - $arr_data['folders'] = json_decode($goCachedFolders['data'], true);//print_r($arr_data); |
|
| 6146 | + $arr_data['folders'] = json_decode($goCachedFolders['data'], true); //print_r($arr_data); |
|
| 6148 | 6147 | // send data |
| 6149 | 6148 | echo (string) prepareExchangedData( |
| 6150 | 6149 | [ |
@@ -6228,7 +6227,7 @@ discard block |
||
| 6228 | 6227 | if (empty($arr_data['folders'][$inc]['path']) === true) { |
| 6229 | 6228 | $arr_data['folders'][$inc]['path'] = htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES); |
| 6230 | 6229 | } else { |
| 6231 | - $arr_data['folders'][$inc]['path'] .= ' / ' . htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES); |
|
| 6230 | + $arr_data['folders'][$inc]['path'] .= ' / '.htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES); |
|
| 6232 | 6231 | } |
| 6233 | 6232 | } |
| 6234 | 6233 | |
@@ -6308,7 +6307,7 @@ discard block |
||
| 6308 | 6307 | if (is_array($foldersArray) === true && $inputData['data'] !== '[null]') { |
| 6309 | 6308 | $rows = DB::query( |
| 6310 | 6309 | 'SELECT id, categories |
| 6311 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 6310 | + FROM ' . prefixTable('nested_tree').' |
|
| 6312 | 6311 | WHERE id IN (%l)', |
| 6313 | 6312 | implode(',', $foldersArray) |
| 6314 | 6313 | ); |
@@ -6350,7 +6349,7 @@ discard block |
||
| 6350 | 6349 | // get item info |
| 6351 | 6350 | $dataItem = DB::queryFirstRow( |
| 6352 | 6351 | 'SELECT * |
| 6353 | - FROM ' . prefixTable('items') . ' |
|
| 6352 | + FROM ' . prefixTable('items').' |
|
| 6354 | 6353 | WHERE id=%i', |
| 6355 | 6354 | $inputData['itemId'] |
| 6356 | 6355 | ); |
@@ -6362,8 +6361,8 @@ discard block |
||
| 6362 | 6361 | 'SELECT l.date as date, l.action as action, l.raison as raison, |
| 6363 | 6362 | u.login as login, u.avatar_thumb as avatar_thumb, u.name as name, u.lastname as lastname, |
| 6364 | 6363 | l.old_value as old_value |
| 6365 | - FROM ' . prefixTable('log_items') . ' as l |
|
| 6366 | - INNER JOIN ' . prefixTable('users') . ' as u ON (l.id_user=u.id) |
|
| 6364 | + FROM ' . prefixTable('log_items').' as l |
|
| 6365 | + INNER JOIN ' . prefixTable('users').' as u ON (l.id_user=u.id) |
|
| 6367 | 6366 | WHERE id_item=%i AND l.action NOT IN (%l) |
| 6368 | 6367 | ORDER BY date DESC', |
| 6369 | 6368 | $inputData['itemId'], |
@@ -6378,18 +6377,18 @@ discard block |
||
| 6378 | 6377 | |
| 6379 | 6378 | // imported via API |
| 6380 | 6379 | if (empty($record['login']) === true) { |
| 6381 | - $record['login'] = $lang->get('imported_via_api') . ' [' . $record['raison'] . ']'; |
|
| 6380 | + $record['login'] = $lang->get('imported_via_api').' ['.$record['raison'].']'; |
|
| 6382 | 6381 | } |
| 6383 | 6382 | |
| 6384 | 6383 | // Prepare avatar |
| 6385 | 6384 | if (isset($record['avatar_thumb']) && empty($record['avatar_thumb']) === false) { |
| 6386 | - if (file_exists($SETTINGS['cpassman_dir'] . '/includes/avatars/' . $record['avatar_thumb'])) { |
|
| 6387 | - $avatar = $SETTINGS['cpassman_url'] . '/includes/avatars/' . $record['avatar_thumb']; |
|
| 6385 | + if (file_exists($SETTINGS['cpassman_dir'].'/includes/avatars/'.$record['avatar_thumb'])) { |
|
| 6386 | + $avatar = $SETTINGS['cpassman_url'].'/includes/avatars/'.$record['avatar_thumb']; |
|
| 6388 | 6387 | } else { |
| 6389 | - $avatar = $SETTINGS['cpassman_url'] . '/includes/images/photo.jpg'; |
|
| 6388 | + $avatar = $SETTINGS['cpassman_url'].'/includes/images/photo.jpg'; |
|
| 6390 | 6389 | } |
| 6391 | 6390 | } else { |
| 6392 | - $avatar = $SETTINGS['cpassman_url'] . '/includes/images/photo.jpg'; |
|
| 6391 | + $avatar = $SETTINGS['cpassman_url'].'/includes/images/photo.jpg'; |
|
| 6393 | 6392 | } |
| 6394 | 6393 | |
| 6395 | 6394 | // Prepare action |
@@ -6409,7 +6408,7 @@ discard block |
||
| 6409 | 6408 | $previous_passwords, |
| 6410 | 6409 | [ |
| 6411 | 6410 | 'password' => htmlentities($previous_pwd['string']), |
| 6412 | - 'date' => date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['date']), |
|
| 6411 | + 'date' => date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['date']), |
|
| 6413 | 6412 | ] |
| 6414 | 6413 | ); |
| 6415 | 6414 | } |
@@ -6422,19 +6421,19 @@ discard block |
||
| 6422 | 6421 | $action = $lang->get($reason[0]); |
| 6423 | 6422 | if ($reason[0] === 'at_moved') { |
| 6424 | 6423 | $tmp = explode(' -> ', $reason[1]); |
| 6425 | - $detail = $lang->get('from') . ' <span class="font-weight-light">' . $tmp[0] . '</span> ' . $lang->get('to') . ' <span class="font-weight-light">' . $tmp[1] . ' </span>'; |
|
| 6424 | + $detail = $lang->get('from').' <span class="font-weight-light">'.$tmp[0].'</span> '.$lang->get('to').' <span class="font-weight-light">'.$tmp[1].' </span>'; |
|
| 6426 | 6425 | } elseif ($reason[0] === 'at_field') { |
| 6427 | 6426 | $tmp = explode(' => ', $reason[1]); |
| 6428 | 6427 | if (count($tmp) > 1) { |
| 6429 | - $detail = '<b>' . trim($tmp[0]) . '</b> | ' . $lang->get('previous_value') . |
|
| 6430 | - ': <span class="font-weight-light">' . trim($tmp[1]) . '</span>'; |
|
| 6428 | + $detail = '<b>'.trim($tmp[0]).'</b> | '.$lang->get('previous_value'). |
|
| 6429 | + ': <span class="font-weight-light">'.trim($tmp[1]).'</span>'; |
|
| 6431 | 6430 | } else { |
| 6432 | 6431 | $detail = trim($reason[1]); |
| 6433 | 6432 | } |
| 6434 | 6433 | } elseif (in_array($reason[0], array('at_restriction', 'at_email', 'at_login', 'at_label', 'at_url', 'at_tag')) === true) { |
| 6435 | 6434 | $tmp = explode(' => ', $reason[1]); |
| 6436 | 6435 | $detail = empty(trim($tmp[0])) === true ? |
| 6437 | - $lang->get('no_previous_value') : $lang->get('previous_value') . ': <span class="font-weight-light">' . $tmp[0] . ' </span>'; |
|
| 6436 | + $lang->get('no_previous_value') : $lang->get('previous_value').': <span class="font-weight-light">'.$tmp[0].' </span>'; |
|
| 6438 | 6437 | } elseif ($reason[0] === 'at_automatic_del') { |
| 6439 | 6438 | $detail = $lang->get($reason[1]); |
| 6440 | 6439 | } elseif ($reason[0] === 'at_anyoneconmodify') { |
@@ -6443,7 +6442,7 @@ discard block |
||
| 6443 | 6442 | $tmp = explode(':', $reason[1]); |
| 6444 | 6443 | $tmp = explode('.', $tmp[0]); |
| 6445 | 6444 | $detail = isBase64($tmp[0]) === true ? |
| 6446 | - base64_decode($tmp[0]) . '.' . $tmp[1] : $tmp[0]; |
|
| 6445 | + base64_decode($tmp[0]).'.'.$tmp[1] : $tmp[0]; |
|
| 6447 | 6446 | } elseif ($reason[0] === 'at_import') { |
| 6448 | 6447 | $detail = ''; |
| 6449 | 6448 | } elseif (in_array($reason[0], array('csv', 'pdf')) === true) { |
@@ -6462,8 +6461,8 @@ discard block |
||
| 6462 | 6461 | array( |
| 6463 | 6462 | 'avatar' => $avatar, |
| 6464 | 6463 | 'login' => $record['login'], |
| 6465 | - 'name' => $record['name'] . ' ' . $record['lastname'], |
|
| 6466 | - 'date' => date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['date']), |
|
| 6464 | + 'name' => $record['name'].' '.$record['lastname'], |
|
| 6465 | + 'date' => date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['date']), |
|
| 6467 | 6466 | 'action' => $action, |
| 6468 | 6467 | 'detail' => $detail, |
| 6469 | 6468 | ) |
@@ -6552,18 +6551,18 @@ discard block |
||
| 6552 | 6551 | |
| 6553 | 6552 | // get some info to add to the notification email |
| 6554 | 6553 | $resp_user = DB::queryfirstrow( |
| 6555 | - 'SELECT login FROM ' . prefixTable('users') . ' WHERE id = %i', |
|
| 6554 | + 'SELECT login FROM '.prefixTable('users').' WHERE id = %i', |
|
| 6556 | 6555 | $_SESSION['user_id'] |
| 6557 | 6556 | ); |
| 6558 | 6557 | $resp_folder = DB::queryfirstrow( |
| 6559 | - 'SELECT title FROM ' . prefixTable('nested_tree') . ' WHERE id = %i', |
|
| 6558 | + 'SELECT title FROM '.prefixTable('nested_tree').' WHERE id = %i', |
|
| 6560 | 6559 | $folder |
| 6561 | 6560 | ); |
| 6562 | 6561 | |
| 6563 | 6562 | // notify Managers |
| 6564 | 6563 | $rows = DB::query( |
| 6565 | 6564 | 'SELECT email |
| 6566 | - FROM ' . prefixTable('users') . ' |
|
| 6565 | + FROM ' . prefixTable('users').' |
|
| 6567 | 6566 | WHERE `gestionnaire` = %i AND `email` IS NOT NULL', |
| 6568 | 6567 | 1 |
| 6569 | 6568 | ); |
@@ -6594,14 +6593,14 @@ discard block |
||
| 6594 | 6593 | // Get list of users |
| 6595 | 6594 | $usersList = array(); |
| 6596 | 6595 | $usersString = ''; |
| 6597 | - $rows = DB::query('SELECT id,login,email FROM ' . prefixTable('users') . ' ORDER BY login ASC'); |
|
| 6596 | + $rows = DB::query('SELECT id,login,email FROM '.prefixTable('users').' ORDER BY login ASC'); |
|
| 6598 | 6597 | foreach ($rows as $record) { |
| 6599 | 6598 | $usersList[$record['login']] = array( |
| 6600 | 6599 | 'id' => $record['id'], |
| 6601 | 6600 | 'login' => $record['login'], |
| 6602 | 6601 | 'email' => $record['email'], |
| 6603 | 6602 | ); |
| 6604 | - $usersString .= $record['id'] . '#' . $record['login'] . ';'; |
|
| 6603 | + $usersString .= $record['id'].'#'.$record['login'].';'; |
|
| 6605 | 6604 | } |
| 6606 | 6605 | |
| 6607 | 6606 | $data = array( |
@@ -6641,7 +6640,7 @@ discard block |
||
| 6641 | 6640 | // Send email |
| 6642 | 6641 | $dataItem = DB::queryfirstrow( |
| 6643 | 6642 | 'SELECT label, id_tree |
| 6644 | - FROM ' . prefixTable('items') . ' |
|
| 6643 | + FROM ' . prefixTable('items').' |
|
| 6645 | 6644 | WHERE id = %i', |
| 6646 | 6645 | $inputData['itemId'] |
| 6647 | 6646 | ); |
@@ -6738,7 +6737,7 @@ discard block |
||
| 6738 | 6737 | |
| 6739 | 6738 | DB::query( |
| 6740 | 6739 | 'SELECT * |
| 6741 | - FROM ' . prefixTable('notification') . ' |
|
| 6740 | + FROM ' . prefixTable('notification').' |
|
| 6742 | 6741 | WHERE item_id = %i AND user_id = %i', |
| 6743 | 6742 | $inputData['itemId'], |
| 6744 | 6743 | $_SESSION['user_id'] |
@@ -6810,7 +6809,7 @@ discard block |
||
| 6810 | 6809 | // And related logs |
| 6811 | 6810 | $rows = DB::query( |
| 6812 | 6811 | 'SELECT id, file AS filename |
| 6813 | - FROM ' . prefixTable('files') . ' |
|
| 6812 | + FROM ' . prefixTable('files').' |
|
| 6814 | 6813 | WHERE id_item = %i AND confirmed = %i', |
| 6815 | 6814 | $inputData['itemId'], |
| 6816 | 6815 | 0 |
@@ -6824,12 +6823,12 @@ discard block |
||
| 6824 | 6823 | ); |
| 6825 | 6824 | |
| 6826 | 6825 | // Delete file on server |
| 6827 | - unlink($SETTINGS['path_to_upload_folder'] . '/' . TP_FILE_PREFIX . base64_decode($file['filename'])); |
|
| 6826 | + unlink($SETTINGS['path_to_upload_folder'].'/'.TP_FILE_PREFIX.base64_decode($file['filename'])); |
|
| 6828 | 6827 | |
| 6829 | 6828 | // Delete related logs |
| 6830 | 6829 | $logFile = DB::query( |
| 6831 | 6830 | 'SELECT increment_id, raison |
| 6832 | - FROM ' . prefixTable('log_items') . ' |
|
| 6831 | + FROM ' . prefixTable('log_items').' |
|
| 6833 | 6832 | WHERE id_item = %i AND id_user = %i AND action = %s AND raison LIKE "at_add_file :%"', |
| 6834 | 6833 | $inputData['itemId'], |
| 6835 | 6834 | $_SESSION['user_id'], |
@@ -6888,7 +6887,7 @@ discard block |
||
| 6888 | 6887 | // Confirm attachments |
| 6889 | 6888 | $rows = DB::query( |
| 6890 | 6889 | 'SELECT id, file AS filename |
| 6891 | - FROM ' . prefixTable('files') . ' |
|
| 6890 | + FROM ' . prefixTable('files').' |
|
| 6892 | 6891 | WHERE id_item = %i AND confirmed = %i', |
| 6893 | 6892 | $inputData['itemId'], |
| 6894 | 6893 | 0 |
@@ -6946,7 +6945,7 @@ discard block |
||
| 6946 | 6945 | |
| 6947 | 6946 | $data = DB::queryFirstRow( |
| 6948 | 6947 | 'SELECT visible_folders |
| 6949 | - FROM ' . prefixTable('cache_tree') . ' WHERE user_id = %i', |
|
| 6948 | + FROM ' . prefixTable('cache_tree').' WHERE user_id = %i', |
|
| 6950 | 6949 | $inputData['userId'] |
| 6951 | 6950 | ); |
| 6952 | 6951 | // Check if tree ID is in visible folders. |
@@ -6980,15 +6979,15 @@ discard block |
||
| 6980 | 6979 | case 'autocomplete_tags': |
| 6981 | 6980 | // Get a list off all existing TAGS |
| 6982 | 6981 | $listOfTags = ''; |
| 6983 | - $rows = DB::query('SELECT tag FROM ' . prefixTable('tags') . ' WHERE tag LIKE %ss GROUP BY tag', $inputData['getTerm']); |
|
| 6982 | + $rows = DB::query('SELECT tag FROM '.prefixTable('tags').' WHERE tag LIKE %ss GROUP BY tag', $inputData['getTerm']); |
|
| 6984 | 6983 | foreach ($rows as $record) { |
| 6985 | 6984 | if (empty($listOfTags)) { |
| 6986 | - $listOfTags = '"' . $record['tag'] . '"'; |
|
| 6985 | + $listOfTags = '"'.$record['tag'].'"'; |
|
| 6987 | 6986 | } else { |
| 6988 | - $listOfTags .= ', "' . $record['tag'] . '"'; |
|
| 6987 | + $listOfTags .= ', "'.$record['tag'].'"'; |
|
| 6989 | 6988 | } |
| 6990 | 6989 | } |
| 6991 | - echo '[' . $listOfTags . ']'; |
|
| 6990 | + echo '['.$listOfTags.']'; |
|
| 6992 | 6991 | break; |
| 6993 | 6992 | } |
| 6994 | 6993 | } |
@@ -7004,7 +7003,7 @@ discard block |
||
| 7004 | 7003 | { |
| 7005 | 7004 | $data = DB::queryFirstRow( |
| 7006 | 7005 | 'SELECT bloquer_creation, bloquer_modification, personal_folder |
| 7007 | - FROM ' . prefixTable('nested_tree') . ' WHERE id = %i', |
|
| 7006 | + FROM ' . prefixTable('nested_tree').' WHERE id = %i', |
|
| 7008 | 7007 | $groupe |
| 7009 | 7008 | ); |
| 7010 | 7009 | // Check if it's in a personal folder. If yes, then force complexity overhead. |
