nilsteampassnet /
TeamPass
@@ -38,14 +38,14 @@ discard block |
||
| 38 | 38 | } |
| 39 | 39 | |
| 40 | 40 | // Do checks |
| 41 | -require_once $SETTINGS['cpassman_dir'] . '/includes/config/include.php'; |
|
| 42 | -require_once $SETTINGS['cpassman_dir'] . '/sources/checks.php'; |
|
| 41 | +require_once $SETTINGS['cpassman_dir'].'/includes/config/include.php'; |
|
| 42 | +require_once $SETTINGS['cpassman_dir'].'/sources/checks.php'; |
|
| 43 | 43 | |
| 44 | 44 | if (checkUser($_SESSION['user_id'], $_SESSION['key'], 'items', $SETTINGS) === false) { |
| 45 | 45 | // Not allowed page |
| 46 | 46 | echo "> ".$_SESSION['user_id']." < - > ".$_SESSION['key']." <"; |
| 47 | 47 | $_SESSION['error']['code'] = ERR_NOT_ALLOWED; |
| 48 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
| 48 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
| 49 | 49 | exit; |
| 50 | 50 | } |
| 51 | 51 | |
@@ -58,8 +58,8 @@ discard block |
||
| 58 | 58 | date_default_timezone_set('UTC'); |
| 59 | 59 | } |
| 60 | 60 | |
| 61 | -require_once $SETTINGS['cpassman_dir'] . '/includes/language/' . $_SESSION['user']['user_language'] . '.php'; |
|
| 62 | -require_once $SETTINGS['cpassman_dir'] . '/includes/config/settings.php'; |
|
| 61 | +require_once $SETTINGS['cpassman_dir'].'/includes/language/'.$_SESSION['user']['user_language'].'.php'; |
|
| 62 | +require_once $SETTINGS['cpassman_dir'].'/includes/config/settings.php'; |
|
| 63 | 63 | header('Content-type: text/html; charset=utf-8'); |
| 64 | 64 | header('Cache-Control: no-cache, must-revalidate'); |
| 65 | 65 | require_once 'main.functions.php'; |
@@ -79,7 +79,7 @@ discard block |
||
| 79 | 79 | } |
| 80 | 80 | |
| 81 | 81 | // Connect to mysql server |
| 82 | -require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Database/Meekrodb/db.class.php'; |
|
| 82 | +require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Database/Meekrodb/db.class.php'; |
|
| 83 | 83 | if (defined('DB_PASSWD_CLEAR') === false) { |
| 84 | 84 | define('DB_PASSWD_CLEAR', defuseReturnDecrypted(DB_PASSWD, $SETTINGS)); |
| 85 | 85 | } |
@@ -93,7 +93,7 @@ discard block |
||
| 93 | 93 | DB::$connect_options = DB_CONNECT_OPTIONS; |
| 94 | 94 | |
| 95 | 95 | // Load Tree |
| 96 | -require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Tree/NestedTree/NestedTree.php'; |
|
| 96 | +require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Tree/NestedTree/NestedTree.php'; |
|
| 97 | 97 | $tree = new Tree\NestedTree\NestedTree(prefixTable('nested_tree'), 'id', 'parent_id', 'title'); |
| 98 | 98 | |
| 99 | 99 | |
@@ -334,7 +334,7 @@ discard block |
||
| 334 | 334 | // About special settings |
| 335 | 335 | $dataFolderSettings = DB::queryFirstRow( |
| 336 | 336 | 'SELECT bloquer_creation, bloquer_modification, personal_folder |
| 337 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 337 | + FROM ' . prefixTable('nested_tree').' |
|
| 338 | 338 | WHERE id = %i', |
| 339 | 339 | $inputData['folderId'] |
| 340 | 340 | ); |
@@ -351,7 +351,7 @@ discard block |
||
| 351 | 351 | // Get folder complexity |
| 352 | 352 | $folderComplexity = DB::queryfirstrow( |
| 353 | 353 | 'SELECT valeur |
| 354 | - FROM ' . prefixTable('misc') . ' |
|
| 354 | + FROM ' . prefixTable('misc').' |
|
| 355 | 355 | WHERE type = %s AND intitule = %i', |
| 356 | 356 | 'complex', |
| 357 | 357 | $inputData['folderId'] |
@@ -377,7 +377,7 @@ discard block |
||
| 377 | 377 | $itemExists = 0; |
| 378 | 378 | $newID = ''; |
| 379 | 379 | $data = DB::queryfirstrow( |
| 380 | - 'SELECT * FROM ' . prefixTable('items') . ' |
|
| 380 | + 'SELECT * FROM '.prefixTable('items').' |
|
| 381 | 381 | WHERE label = %s AND inactif = %i', |
| 382 | 382 | $inputData['label'], |
| 383 | 383 | 0 |
@@ -504,7 +504,7 @@ discard block |
||
| 504 | 504 | // should we encrypt the data |
| 505 | 505 | $dataTmp = DB::queryFirstRow( |
| 506 | 506 | 'SELECT encrypted_data |
| 507 | - FROM ' . prefixTable('categories') . ' |
|
| 507 | + FROM ' . prefixTable('categories').' |
|
| 508 | 508 | WHERE id = %i', |
| 509 | 509 | $field_data[0] |
| 510 | 510 | ); |
@@ -560,7 +560,7 @@ discard block |
||
| 560 | 560 | ) { |
| 561 | 561 | DB::queryFirstRow( |
| 562 | 562 | 'SELECT * |
| 563 | - FROM ' . prefixTable('templates') . ' |
|
| 563 | + FROM ' . prefixTable('templates').' |
|
| 564 | 564 | WHERE item_id = %i', |
| 565 | 565 | $newID |
| 566 | 566 | ); |
@@ -629,11 +629,11 @@ discard block |
||
| 629 | 629 | ) { |
| 630 | 630 | foreach ($post_restricted_to as $userRest) { |
| 631 | 631 | if (empty($userRest) === false) { |
| 632 | - $dataTmp = DB::queryfirstrow('SELECT login FROM ' . prefixTable('users') . ' WHERE id= %i', $userRest); |
|
| 632 | + $dataTmp = DB::queryfirstrow('SELECT login FROM '.prefixTable('users').' WHERE id= %i', $userRest); |
|
| 633 | 633 | if (empty($listOfRestricted)) { |
| 634 | 634 | $listOfRestricted = $dataTmp['login']; |
| 635 | 635 | } else { |
| 636 | - $listOfRestricted .= ';' . $dataTmp['login']; |
|
| 636 | + $listOfRestricted .= ';'.$dataTmp['login']; |
|
| 637 | 637 | } |
| 638 | 638 | } |
| 639 | 639 | } |
@@ -647,11 +647,11 @@ discard block |
||
| 647 | 647 | if (empty($data['restricted_to']) === false) { |
| 648 | 648 | foreach (explode(';', $data['restricted_to']) as $userRest) { |
| 649 | 649 | if (empty($userRest) === false) { |
| 650 | - $dataTmp = DB::queryfirstrow('SELECT login FROM ' . prefixTable('users') . ' WHERE id= ' . $userRest); |
|
| 650 | + $dataTmp = DB::queryfirstrow('SELECT login FROM '.prefixTable('users').' WHERE id= '.$userRest); |
|
| 651 | 651 | if (empty($oldRestrictionList) === true) { |
| 652 | 652 | $oldRestrictionList = $dataTmp['login']; |
| 653 | 653 | } else { |
| 654 | - $oldRestrictionList .= ';' . $dataTmp['login']; |
|
| 654 | + $oldRestrictionList .= ';'.$dataTmp['login']; |
|
| 655 | 655 | } |
| 656 | 656 | } |
| 657 | 657 | } |
@@ -714,7 +714,7 @@ discard block |
||
| 714 | 714 | if (empty($post_uploaded_file_id) === false) { |
| 715 | 715 | $rows = DB::query( |
| 716 | 716 | 'SELECT id |
| 717 | - FROM ' . prefixTable('files') . ' |
|
| 717 | + FROM ' . prefixTable('files').' |
|
| 718 | 718 | WHERE id_item = %s', |
| 719 | 719 | $post_uploaded_file_id |
| 720 | 720 | ); |
@@ -755,7 +755,7 @@ discard block |
||
| 755 | 755 | langHdl('email_subject_item_updated'), |
| 756 | 756 | str_replace( |
| 757 | 757 | array('#label', '#link'), |
| 758 | - array($path, $SETTINGS['email_server_url'] . '/index.php?page=items&group=' . $inputData['folderId'] . '&id=' . $newID . $txt['email_body3']), |
|
| 758 | + array($path, $SETTINGS['email_server_url'].'/index.php?page=items&group='.$inputData['folderId'].'&id='.$newID.$txt['email_body3']), |
|
| 759 | 759 | langHdl('new_item_email_body') |
| 760 | 760 | ), |
| 761 | 761 | $emailAddress, |
@@ -940,7 +940,7 @@ discard block |
||
| 940 | 940 | // About special settings |
| 941 | 941 | $dataFolderSettings = DB::queryFirstRow( |
| 942 | 942 | 'SELECT bloquer_creation, bloquer_modification, personal_folder, title |
| 943 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 943 | + FROM ' . prefixTable('nested_tree').' |
|
| 944 | 944 | WHERE id = %i', |
| 945 | 945 | $inputData['folderId'] |
| 946 | 946 | ); |
@@ -956,7 +956,7 @@ discard block |
||
| 956 | 956 | // Get folder complexity |
| 957 | 957 | $folderComplexity = DB::queryfirstrow( |
| 958 | 958 | 'SELECT valeur |
| 959 | - FROM ' . prefixTable('misc') . ' |
|
| 959 | + FROM ' . prefixTable('misc').' |
|
| 960 | 960 | WHERE type = %s AND intitule = %i', |
| 961 | 961 | 'complex', |
| 962 | 962 | $inputData['folderId'] |
@@ -996,8 +996,8 @@ discard block |
||
| 996 | 996 | // Get all informations for this item |
| 997 | 997 | $dataItem = DB::queryfirstrow( |
| 998 | 998 | 'SELECT * |
| 999 | - FROM ' . prefixTable('items') . ' as i |
|
| 1000 | - INNER JOIN ' . prefixTable('log_items') . ' as l ON (l.id_item = i.id) |
|
| 999 | + FROM ' . prefixTable('items').' as i |
|
| 1000 | + INNER JOIN ' . prefixTable('log_items').' as l ON (l.id_item = i.id) |
|
| 1001 | 1001 | WHERE i.id=%i AND l.action = %s', |
| 1002 | 1002 | $inputData['itemId'], |
| 1003 | 1003 | 'at_creation' |
@@ -1007,7 +1007,7 @@ discard block |
||
| 1007 | 1007 | //db::debugmode(true); |
| 1008 | 1008 | DB::query( |
| 1009 | 1009 | 'SELECT * |
| 1010 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
| 1010 | + FROM ' . prefixTable('sharekeys_items').' |
|
| 1011 | 1011 | WHERE object_id = %i AND user_id = %s', |
| 1012 | 1012 | $inputData['itemId'], |
| 1013 | 1013 | $_SESSION['user_id'] |
@@ -1056,9 +1056,9 @@ discard block |
||
| 1056 | 1056 | '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, |
| 1057 | 1057 | 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, |
| 1058 | 1058 | u.login as user_login, u.email as user_email |
| 1059 | - FROM ' . prefixTable('items') . ' as i |
|
| 1060 | - INNER JOIN ' . prefixTable('log_items') . ' as l ON (i.id=l.id_item) |
|
| 1061 | - INNER JOIN ' . prefixTable('users') . ' as u ON (u.id=l.id_user) |
|
| 1059 | + FROM ' . prefixTable('items').' as i |
|
| 1060 | + INNER JOIN ' . prefixTable('log_items').' as l ON (i.id=l.id_item) |
|
| 1061 | + INNER JOIN ' . prefixTable('users').' as u ON (u.id=l.id_user) |
|
| 1062 | 1062 | WHERE i.id=%i', |
| 1063 | 1063 | $inputData['itemId'] |
| 1064 | 1064 | ); |
@@ -1066,7 +1066,7 @@ discard block |
||
| 1066 | 1066 | // Should we log a password change? |
| 1067 | 1067 | $userKey = DB::queryFirstRow( |
| 1068 | 1068 | 'SELECT share_key |
| 1069 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
| 1069 | + FROM ' . prefixTable('sharekeys_items').' |
|
| 1070 | 1070 | WHERE user_id = %i AND object_id = %i', |
| 1071 | 1071 | $_SESSION['user_id'], |
| 1072 | 1072 | $inputData['itemId'] |
@@ -1142,7 +1142,7 @@ discard block |
||
| 1142 | 1142 | // Get list of tags |
| 1143 | 1143 | $itemTags = DB::queryFirstColumn( |
| 1144 | 1144 | 'SELECT tag |
| 1145 | - FROM ' . prefixTable('tags') . ' |
|
| 1145 | + FROM ' . prefixTable('tags').' |
|
| 1146 | 1146 | WHERE item_id = %i', |
| 1147 | 1147 | $inputData['itemId'] |
| 1148 | 1148 | ); |
@@ -1188,7 +1188,7 @@ discard block |
||
| 1188 | 1188 | $_SESSION['user_id'], |
| 1189 | 1189 | 'at_modification', |
| 1190 | 1190 | $_SESSION['login'], |
| 1191 | - 'at_tag : ' . implode(' ', $itemTags) . ' => ' . $post_tags |
|
| 1191 | + 'at_tag : '.implode(' ', $itemTags).' => '.$post_tags |
|
| 1192 | 1192 | ); |
| 1193 | 1193 | } |
| 1194 | 1194 | |
@@ -1226,8 +1226,8 @@ discard block |
||
| 1226 | 1226 | 'SELECT c.id AS id, c.title AS title, i.data AS data, i.data_iv AS data_iv, |
| 1227 | 1227 | i.encryption_type AS encryption_type, c.encrypted_data AS encrypted_data, |
| 1228 | 1228 | c.masked AS masked, i.id AS field_item_id |
| 1229 | - FROM ' . prefixTable('categories_items') . ' AS i |
|
| 1230 | - INNER JOIN ' . prefixTable('categories') . ' AS c ON (i.field_id=c.id) |
|
| 1229 | + FROM ' . prefixTable('categories_items').' AS i |
|
| 1230 | + INNER JOIN ' . prefixTable('categories').' AS c ON (i.field_id=c.id) |
|
| 1231 | 1231 | WHERE i.field_id = %i AND i.item_id = %i', |
| 1232 | 1232 | $field['id'], |
| 1233 | 1233 | $inputData['itemId'] |
@@ -1241,7 +1241,7 @@ discard block |
||
| 1241 | 1241 | // Perform new query |
| 1242 | 1242 | $dataTmpCat = DB::queryFirstRow( |
| 1243 | 1243 | 'SELECT id, title, encrypted_data, masked |
| 1244 | - FROM ' . prefixTable('categories') . ' |
|
| 1244 | + FROM ' . prefixTable('categories').' |
|
| 1245 | 1245 | WHERE id = %i', |
| 1246 | 1246 | $field['id'] |
| 1247 | 1247 | ); |
@@ -1313,7 +1313,7 @@ discard block |
||
| 1313 | 1313 | $_SESSION['user_id'], |
| 1314 | 1314 | 'at_modification', |
| 1315 | 1315 | $_SESSION['login'], |
| 1316 | - 'at_field : ' . $dataTmpCat['title'] . ' : ' . $field['value'] |
|
| 1316 | + 'at_field : '.$dataTmpCat['title'].' : '.$field['value'] |
|
| 1317 | 1317 | ); |
| 1318 | 1318 | } else { |
| 1319 | 1319 | // compare the old and new value |
@@ -1321,7 +1321,7 @@ discard block |
||
| 1321 | 1321 | // Get user sharekey for this field |
| 1322 | 1322 | $userKey = DB::queryFirstRow( |
| 1323 | 1323 | 'SELECT share_key |
| 1324 | - FROM ' . prefixTable('sharekeys_fields') . ' |
|
| 1324 | + FROM ' . prefixTable('sharekeys_fields').' |
|
| 1325 | 1325 | WHERE user_id = %i AND object_id = %i', |
| 1326 | 1326 | $_SESSION['user_id'], |
| 1327 | 1327 | $dataTmpCat['field_item_id'] |
@@ -1391,7 +1391,7 @@ discard block |
||
| 1391 | 1391 | $_SESSION['user_id'], |
| 1392 | 1392 | 'at_modification', |
| 1393 | 1393 | $_SESSION['login'], |
| 1394 | - 'at_field : ' . $dataTmpCat['title'] . ' => ' . $oldVal |
|
| 1394 | + 'at_field : '.$dataTmpCat['title'].' => '.$oldVal |
|
| 1395 | 1395 | ); |
| 1396 | 1396 | } |
| 1397 | 1397 | } |
@@ -1416,7 +1416,7 @@ discard block |
||
| 1416 | 1416 | ) { |
| 1417 | 1417 | DB::queryFirstRow( |
| 1418 | 1418 | 'SELECT * |
| 1419 | - FROM ' . prefixTable('templates') . ' |
|
| 1419 | + FROM ' . prefixTable('templates').' |
|
| 1420 | 1420 | WHERE item_id = %i', |
| 1421 | 1421 | $inputData['itemId'] |
| 1422 | 1422 | ); |
@@ -1459,7 +1459,7 @@ discard block |
||
| 1459 | 1459 | // check if elem exists in Table. If not add it or update it. |
| 1460 | 1460 | DB::query( |
| 1461 | 1461 | 'SELECT * |
| 1462 | - FROM ' . prefixTable('automatic_del') . ' |
|
| 1462 | + FROM ' . prefixTable('automatic_del').' |
|
| 1463 | 1463 | WHERE item_id = %i', |
| 1464 | 1464 | $inputData['itemId'] |
| 1465 | 1465 | ); |
@@ -1486,7 +1486,7 @@ discard block |
||
| 1486 | 1486 | // Store updates performed |
| 1487 | 1487 | array_push( |
| 1488 | 1488 | $arrayOfChanges, |
| 1489 | - langHdl('automatic_deletion_engaged') . ': ' . langHdl('enabled') |
|
| 1489 | + langHdl('automatic_deletion_engaged').': '.langHdl('enabled') |
|
| 1490 | 1490 | ); |
| 1491 | 1491 | |
| 1492 | 1492 | // update LOG |
@@ -1529,7 +1529,7 @@ discard block |
||
| 1529 | 1529 | // Store updates performed |
| 1530 | 1530 | array_push( |
| 1531 | 1531 | $arrayOfChanges, |
| 1532 | - langHdl('automatic_deletion_engaged') . ': ' . langHdl('disabled') |
|
| 1532 | + langHdl('automatic_deletion_engaged').': '.langHdl('disabled') |
|
| 1533 | 1533 | ); |
| 1534 | 1534 | |
| 1535 | 1535 | // update LOG |
@@ -1562,7 +1562,7 @@ discard block |
||
| 1562 | 1562 | if (empty($userId) === false) { |
| 1563 | 1563 | $dataTmp = DB::queryfirstrow( |
| 1564 | 1564 | 'SELECT id, name, lastname |
| 1565 | - FROM ' . prefixTable('users') . ' |
|
| 1565 | + FROM ' . prefixTable('users').' |
|
| 1566 | 1566 | WHERE id= %i', |
| 1567 | 1567 | $userId |
| 1568 | 1568 | ); |
@@ -1570,7 +1570,7 @@ discard block |
||
| 1570 | 1570 | // Add to array |
| 1571 | 1571 | array_push( |
| 1572 | 1572 | $arrayOfUsersRestriction, |
| 1573 | - $dataTmp['name'] . ' ' . $dataTmp['lastname'] |
|
| 1573 | + $dataTmp['name'].' '.$dataTmp['lastname'] |
|
| 1574 | 1574 | ); |
| 1575 | 1575 | array_push( |
| 1576 | 1576 | $arrayOfUsersIdRestriction, |
@@ -1601,8 +1601,8 @@ discard block |
||
| 1601 | 1601 | // get values before deleting them |
| 1602 | 1602 | $rows = DB::query( |
| 1603 | 1603 | 'SELECT t.title, t.id AS id |
| 1604 | - FROM ' . prefixTable('roles_title') . ' as t |
|
| 1605 | - INNER JOIN ' . prefixTable('restriction_to_roles') . ' as r ON (t.id=r.role_id) |
|
| 1604 | + FROM ' . prefixTable('roles_title').' as t |
|
| 1605 | + INNER JOIN ' . prefixTable('restriction_to_roles').' as r ON (t.id=r.role_id) |
|
| 1606 | 1606 | WHERE r.item_id = %i |
| 1607 | 1607 | ORDER BY t.title ASC', |
| 1608 | 1608 | $inputData['itemId'] |
@@ -1636,7 +1636,7 @@ discard block |
||
| 1636 | 1636 | ); |
| 1637 | 1637 | $dataTmp = DB::queryfirstrow( |
| 1638 | 1638 | 'SELECT title |
| 1639 | - FROM ' . prefixTable('roles_title') . ' |
|
| 1639 | + FROM ' . prefixTable('roles_title').' |
|
| 1640 | 1640 | WHERE id = %i', |
| 1641 | 1641 | $role |
| 1642 | 1642 | ); |
@@ -1677,8 +1677,8 @@ discard block |
||
| 1677 | 1677 | $_SESSION['user_id'], |
| 1678 | 1678 | 'at_modification', |
| 1679 | 1679 | $_SESSION['login'], |
| 1680 | - 'at_restriction : ' . (count($diffUsersRestiction) > 0 ? |
|
| 1681 | - implode(', ', $arrayOfUsersRestriction) . (count($diffRolesRestiction) > 0 ? ', ' : '') : '') . (count($diffRolesRestiction) > 0 ? implode(', ', $arrayOfRestrictionRoles) : '') |
|
| 1680 | + 'at_restriction : '.(count($diffUsersRestiction) > 0 ? |
|
| 1681 | + implode(', ', $arrayOfUsersRestriction).(count($diffRolesRestiction) > 0 ? ', ' : '') : '').(count($diffRolesRestiction) > 0 ? implode(', ', $arrayOfRestrictionRoles) : '') |
|
| 1682 | 1682 | ); |
| 1683 | 1683 | } |
| 1684 | 1684 | |
@@ -1698,7 +1698,7 @@ discard block |
||
| 1698 | 1698 | $_SESSION['user_id'], |
| 1699 | 1699 | 'at_modification', |
| 1700 | 1700 | $_SESSION['login'], |
| 1701 | - 'at_label : ' . $data['label'] . ' => ' . $inputData['label'] |
|
| 1701 | + 'at_label : '.$data['label'].' => '.$inputData['label'] |
|
| 1702 | 1702 | ); |
| 1703 | 1703 | } |
| 1704 | 1704 | // LOGIN |
@@ -1717,7 +1717,7 @@ discard block |
||
| 1717 | 1717 | $_SESSION['user_id'], |
| 1718 | 1718 | 'at_modification', |
| 1719 | 1719 | $_SESSION['login'], |
| 1720 | - 'at_login : ' . $data['login'] . ' => ' . $post_login |
|
| 1720 | + 'at_login : '.$data['login'].' => '.$post_login |
|
| 1721 | 1721 | ); |
| 1722 | 1722 | } |
| 1723 | 1723 | |
@@ -1736,7 +1736,7 @@ discard block |
||
| 1736 | 1736 | $_SESSION['user_id'], |
| 1737 | 1737 | 'at_modification', |
| 1738 | 1738 | $_SESSION['login'], |
| 1739 | - 'at_email : ' . $data['email'] . ' => ' . $post_email |
|
| 1739 | + 'at_email : '.$data['email'].' => '.$post_email |
|
| 1740 | 1740 | ); |
| 1741 | 1741 | } |
| 1742 | 1742 | // URL |
@@ -1755,7 +1755,7 @@ discard block |
||
| 1755 | 1755 | $_SESSION['user_id'], |
| 1756 | 1756 | 'at_modification', |
| 1757 | 1757 | $_SESSION['login'], |
| 1758 | - 'at_url : ' . $data['url'] . ' => ' . $post_url |
|
| 1758 | + 'at_url : '.$data['url'].' => '.$post_url |
|
| 1759 | 1759 | ); |
| 1760 | 1760 | } |
| 1761 | 1761 | // DESCRIPTION |
@@ -1780,7 +1780,7 @@ discard block |
||
| 1780 | 1780 | // FOLDER |
| 1781 | 1781 | if ((int) $data['id_tree'] !== (int) $inputData['folderId']) { |
| 1782 | 1782 | // Get name of folders |
| 1783 | - $dataTmp = DB::query('SELECT title FROM ' . prefixTable('nested_tree') . ' WHERE id IN %li', array($data['id_tree'], $inputData['folderId'])); |
|
| 1783 | + $dataTmp = DB::query('SELECT title FROM '.prefixTable('nested_tree').' WHERE id IN %li', array($data['id_tree'], $inputData['folderId'])); |
|
| 1784 | 1784 | |
| 1785 | 1785 | // Store updates performed |
| 1786 | 1786 | array_push( |
@@ -1796,7 +1796,7 @@ discard block |
||
| 1796 | 1796 | $_SESSION['user_id'], |
| 1797 | 1797 | 'at_modification', |
| 1798 | 1798 | $_SESSION['login'], |
| 1799 | - 'at_category : ' . $dataTmp[0]['title'] . ' => ' . $dataTmp[1]['title'] |
|
| 1799 | + 'at_category : '.$dataTmp[0]['title'].' => '.$dataTmp[1]['title'] |
|
| 1800 | 1800 | ); |
| 1801 | 1801 | } |
| 1802 | 1802 | // ANYONE_CAN_MODIFY |
@@ -1804,7 +1804,7 @@ discard block |
||
| 1804 | 1804 | // Store updates performed |
| 1805 | 1805 | array_push( |
| 1806 | 1806 | $arrayOfChanges, |
| 1807 | - langHdl('at_anyoneconmodify') . ': ' . ((int) $post_anyone_can_modify === 0 ? langHdl('disabled') : langHdl('enabled')) |
|
| 1807 | + langHdl('at_anyoneconmodify').': '.((int) $post_anyone_can_modify === 0 ? langHdl('disabled') : langHdl('enabled')) |
|
| 1808 | 1808 | ); |
| 1809 | 1809 | |
| 1810 | 1810 | // Log |
@@ -1815,15 +1815,15 @@ discard block |
||
| 1815 | 1815 | $_SESSION['user_id'], |
| 1816 | 1816 | 'at_modification', |
| 1817 | 1817 | $_SESSION['login'], |
| 1818 | - 'at_anyoneconmodify : ' . ((int) $post_anyone_can_modify === 0 ? 'disabled' : 'enabled') |
|
| 1818 | + 'at_anyoneconmodify : '.((int) $post_anyone_can_modify === 0 ? 'disabled' : 'enabled') |
|
| 1819 | 1819 | ); |
| 1820 | 1820 | } |
| 1821 | 1821 | |
| 1822 | 1822 | // Reload new values |
| 1823 | 1823 | $dataItem = DB::queryfirstrow( |
| 1824 | 1824 | 'SELECT * |
| 1825 | - FROM ' . prefixTable('items') . ' as i |
|
| 1826 | - INNER JOIN ' . prefixTable('log_items') . ' as l ON (l.id_item = i.id) |
|
| 1825 | + FROM ' . prefixTable('items').' as i |
|
| 1826 | + INNER JOIN ' . prefixTable('log_items').' as l ON (l.id_item = i.id) |
|
| 1827 | 1827 | WHERE i.id = %i AND l.action = %s', |
| 1828 | 1828 | $inputData['itemId'], |
| 1829 | 1829 | 'at_creation' |
@@ -1832,8 +1832,8 @@ discard block |
||
| 1832 | 1832 | $history = ''; |
| 1833 | 1833 | $rows = DB::query( |
| 1834 | 1834 | 'SELECT l.date as date, l.action as action, l.raison as raison, u.login as login |
| 1835 | - FROM ' . prefixTable('log_items') . ' as l |
|
| 1836 | - LEFT JOIN ' . prefixTable('users') . ' as u ON (l.id_user=u.id) |
|
| 1835 | + FROM ' . prefixTable('log_items').' as l |
|
| 1836 | + LEFT JOIN ' . prefixTable('users').' as u ON (l.id_user=u.id) |
|
| 1837 | 1837 | WHERE l.action <> %s AND id_item=%s', |
| 1838 | 1838 | 'at_shown', |
| 1839 | 1839 | $inputData['itemId'] |
@@ -1842,14 +1842,14 @@ discard block |
||
| 1842 | 1842 | if ($record['raison'] === NULL) continue; |
| 1843 | 1843 | $reason = explode(':', $record['raison']); |
| 1844 | 1844 | if (count($reason) > 0) { |
| 1845 | - $sentence = date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['date']) . ' - ' |
|
| 1846 | - . $record['login'] . ' - ' . langHdl($record['action']) . ' - ' |
|
| 1847 | - . (empty($record['raison']) === false ? (count($reason) > 1 ? langHdl(trim($reason[0])) . ' : ' . $reason[1] |
|
| 1845 | + $sentence = date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['date']).' - ' |
|
| 1846 | + . $record['login'].' - '.langHdl($record['action']).' - ' |
|
| 1847 | + . (empty($record['raison']) === false ? (count($reason) > 1 ? langHdl(trim($reason[0])).' : '.$reason[1] |
|
| 1848 | 1848 | : langHdl(trim($reason[0]))) : ''); |
| 1849 | 1849 | if (empty($history)) { |
| 1850 | 1850 | $history = $sentence; |
| 1851 | 1851 | } else { |
| 1852 | - $history .= '<br />' . $sentence; |
|
| 1852 | + $history .= '<br />'.$sentence; |
|
| 1853 | 1853 | } |
| 1854 | 1854 | } |
| 1855 | 1855 | } |
@@ -1982,7 +1982,7 @@ discard block |
||
| 1982 | 1982 | ) { |
| 1983 | 1983 | // load the original record into an array |
| 1984 | 1984 | $originalRecord = DB::queryfirstrow( |
| 1985 | - 'SELECT * FROM ' . prefixTable('items') . ' |
|
| 1985 | + 'SELECT * FROM '.prefixTable('items').' |
|
| 1986 | 1986 | WHERE id = %i', |
| 1987 | 1987 | $inputData['itemId'] |
| 1988 | 1988 | ); |
@@ -2002,7 +2002,7 @@ discard block |
||
| 2002 | 2002 | |
| 2003 | 2003 | // Load the destination folder record into an array |
| 2004 | 2004 | $dataDestination = DB::queryfirstrow( |
| 2005 | - 'SELECT personal_folder FROM ' . prefixTable('nested_tree') . ' |
|
| 2005 | + 'SELECT personal_folder FROM '.prefixTable('nested_tree').' |
|
| 2006 | 2006 | WHERE id = %i', |
| 2007 | 2007 | $post_dest_id |
| 2008 | 2008 | ); |
@@ -2010,7 +2010,7 @@ discard block |
||
| 2010 | 2010 | // Get the ITEM object key for the user |
| 2011 | 2011 | $userKey = DB::queryFirstRow( |
| 2012 | 2012 | 'SELECT share_key |
| 2013 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
| 2013 | + FROM ' . prefixTable('sharekeys_items').' |
|
| 2014 | 2014 | WHERE user_id = %i AND object_id = %i', |
| 2015 | 2015 | $_SESSION['user_id'], |
| 2016 | 2016 | $inputData['itemId'] |
@@ -2083,7 +2083,7 @@ discard block |
||
| 2083 | 2083 | // Manage Custom Fields |
| 2084 | 2084 | $rows = DB::query( |
| 2085 | 2085 | 'SELECT * |
| 2086 | - FROM ' . prefixTable('categories_items') . ' |
|
| 2086 | + FROM ' . prefixTable('categories_items').' |
|
| 2087 | 2087 | WHERE item_id = %i', |
| 2088 | 2088 | $inputData['itemId'] |
| 2089 | 2089 | ); |
@@ -2131,15 +2131,15 @@ discard block |
||
| 2131 | 2131 | $rows = DB::query( |
| 2132 | 2132 | 'SELECT f.id AS id, f.file AS file, f.name AS name, f.status AS status, f.extension AS extension, |
| 2133 | 2133 | f.size AS size, f.type AS type, s.share_key AS share_key |
| 2134 | - FROM ' . prefixTable('files') . ' AS f |
|
| 2135 | - INNER JOIN ' . prefixTable('sharekeys_files') . ' AS s ON (f.id = s.object_id) |
|
| 2134 | + FROM ' . prefixTable('files').' AS f |
|
| 2135 | + INNER JOIN ' . prefixTable('sharekeys_files').' AS s ON (f.id = s.object_id) |
|
| 2136 | 2136 | WHERE s.user_id = %i AND f.id_item = %i', |
| 2137 | 2137 | $_SESSION['user_id'], |
| 2138 | 2138 | $inputData['itemId'] |
| 2139 | 2139 | ); |
| 2140 | 2140 | foreach ($rows as $record) { |
| 2141 | 2141 | // Check if file still exists |
| 2142 | - if (file_exists($SETTINGS['path_to_upload_folder'] . DIRECTORY_SEPARATOR . TP_FILE_PREFIX . base64_decode($record['file'])) === true) { |
|
| 2142 | + if (file_exists($SETTINGS['path_to_upload_folder'].DIRECTORY_SEPARATOR.TP_FILE_PREFIX.base64_decode($record['file'])) === true) { |
|
| 2143 | 2143 | // Step1 - decrypt the file |
| 2144 | 2144 | $fileContent = decryptFile( |
| 2145 | 2145 | $record['file'], |
@@ -2148,8 +2148,8 @@ discard block |
||
| 2148 | 2148 | ); |
| 2149 | 2149 | |
| 2150 | 2150 | // Step2 - create file |
| 2151 | - $newFileName = md5(time() . '_' . $record['id']) . '.' . $record['extension']; |
|
| 2152 | - $outstream = fopen($SETTINGS['path_to_upload_folder'] . DIRECTORY_SEPARATOR . $newFileName, 'ab'); |
|
| 2151 | + $newFileName = md5(time().'_'.$record['id']).'.'.$record['extension']; |
|
| 2152 | + $outstream = fopen($SETTINGS['path_to_upload_folder'].DIRECTORY_SEPARATOR.$newFileName, 'ab'); |
|
| 2153 | 2153 | if ($outstream === false) { |
| 2154 | 2154 | echo prepareExchangedData( |
| 2155 | 2155 | $SETTINGS['cpassman_dir'], |
@@ -2200,7 +2200,7 @@ discard block |
||
| 2200 | 2200 | |
| 2201 | 2201 | // ------------------------- |
| 2202 | 2202 | // Add specific restrictions |
| 2203 | - $rows = DB::query('SELECT * FROM ' . prefixTable('restriction_to_roles') . ' WHERE item_id = %i', $inputData['itemId']); |
|
| 2203 | + $rows = DB::query('SELECT * FROM '.prefixTable('restriction_to_roles').' WHERE item_id = %i', $inputData['itemId']); |
|
| 2204 | 2204 | foreach ($rows as $record) { |
| 2205 | 2205 | DB::insert( |
| 2206 | 2206 | prefixTable('restriction_to_roles'), |
@@ -2212,7 +2212,7 @@ discard block |
||
| 2212 | 2212 | } |
| 2213 | 2213 | |
| 2214 | 2214 | // Add Tags |
| 2215 | - $rows = DB::query('SELECT * FROM ' . prefixTable('tags') . ' WHERE item_id = %i', $inputData['itemId']); |
|
| 2215 | + $rows = DB::query('SELECT * FROM '.prefixTable('tags').' WHERE item_id = %i', $inputData['itemId']); |
|
| 2216 | 2216 | foreach ($rows as $record) { |
| 2217 | 2217 | DB::insert( |
| 2218 | 2218 | prefixTable('tags'), |
@@ -2242,7 +2242,7 @@ discard block |
||
| 2242 | 2242 | $_SESSION['login'] |
| 2243 | 2243 | ); |
| 2244 | 2244 | // reload cache table |
| 2245 | - include_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php'; |
|
| 2245 | + include_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php'; |
|
| 2246 | 2246 | updateCacheTable('reload', $SETTINGS, null); |
| 2247 | 2247 | |
| 2248 | 2248 | echo (string) prepareExchangedData( |
@@ -2290,7 +2290,7 @@ discard block |
||
| 2290 | 2290 | |
| 2291 | 2291 | // Decrypt and retreive data in JSON format |
| 2292 | 2292 | $dataReceived = prepareExchangedData( |
| 2293 | - $SETTINGS['cpassman_dir'],$inputData['data'], |
|
| 2293 | + $SETTINGS['cpassman_dir'], $inputData['data'], |
|
| 2294 | 2294 | 'decode' |
| 2295 | 2295 | ); |
| 2296 | 2296 | |
@@ -2316,7 +2316,7 @@ discard block |
||
| 2316 | 2316 | // then we can show it |
| 2317 | 2317 | $item_deleted = DB::queryFirstRow( |
| 2318 | 2318 | 'SELECT * |
| 2319 | - FROM ' . prefixTable('log_items') . ' |
|
| 2319 | + FROM ' . prefixTable('log_items').' |
|
| 2320 | 2320 | WHERE id_item = %i AND action = %s |
| 2321 | 2321 | ORDER BY date DESC |
| 2322 | 2322 | LIMIT 0, 1', |
@@ -2327,7 +2327,7 @@ discard block |
||
| 2327 | 2327 | |
| 2328 | 2328 | $item_restored = DB::queryFirstRow( |
| 2329 | 2329 | 'SELECT * |
| 2330 | - FROM ' . prefixTable('log_items') . ' |
|
| 2330 | + FROM ' . prefixTable('log_items').' |
|
| 2331 | 2331 | WHERE id_item = %i AND action = %s |
| 2332 | 2332 | ORDER BY date DESC |
| 2333 | 2333 | LIMIT 0, 1', |
@@ -2352,8 +2352,8 @@ discard block |
||
| 2352 | 2352 | // Get all informations for this item |
| 2353 | 2353 | $dataItem = DB::queryfirstrow( |
| 2354 | 2354 | 'SELECT * |
| 2355 | - FROM ' . prefixTable('items') . ' as i |
|
| 2356 | - INNER JOIN ' . prefixTable('log_items') . ' as l ON (l.id_item = i.id) |
|
| 2355 | + FROM ' . prefixTable('items').' as i |
|
| 2356 | + INNER JOIN ' . prefixTable('log_items').' as l ON (l.id_item = i.id) |
|
| 2357 | 2357 | WHERE i.id = %i AND l.action = %s', |
| 2358 | 2358 | $inputData['id'], |
| 2359 | 2359 | 'at_creation' |
@@ -2362,7 +2362,7 @@ discard block |
||
| 2362 | 2362 | // Notification |
| 2363 | 2363 | DB::queryfirstrow( |
| 2364 | 2364 | 'SELECT * |
| 2365 | - FROM ' . prefixTable('notification') . ' |
|
| 2365 | + FROM ' . prefixTable('notification').' |
|
| 2366 | 2366 | WHERE item_id = %i AND user_id = %i', |
| 2367 | 2367 | $inputData['id'], |
| 2368 | 2368 | $_SESSION['user_id'] |
@@ -2405,7 +2405,7 @@ discard block |
||
| 2405 | 2405 | |
| 2406 | 2406 | // manage case of API user |
| 2407 | 2407 | if ($dataItem['id_user'] === API_USER_ID) { |
| 2408 | - $arrData['author'] = 'API [' . $dataItem['description'] . ']'; |
|
| 2408 | + $arrData['author'] = 'API ['.$dataItem['description'].']'; |
|
| 2409 | 2409 | $arrData['id_user'] = API_USER_ID; |
| 2410 | 2410 | $arrData['author_email'] = ''; |
| 2411 | 2411 | $arrData['notification_status'] = false; |
@@ -2415,7 +2415,7 @@ discard block |
||
| 2415 | 2415 | $tags = array(); |
| 2416 | 2416 | $rows = DB::query( |
| 2417 | 2417 | 'SELECT tag |
| 2418 | - FROM ' . prefixTable('tags') . ' |
|
| 2418 | + FROM ' . prefixTable('tags').' |
|
| 2419 | 2419 | WHERE item_id = %i', |
| 2420 | 2420 | $inputData['id'] |
| 2421 | 2421 | ); |
@@ -2440,7 +2440,7 @@ discard block |
||
| 2440 | 2440 | // Check if user has a role that is accepted |
| 2441 | 2441 | $rows_tmp = DB::query( |
| 2442 | 2442 | 'SELECT role_id |
| 2443 | - FROM ' . prefixTable('restriction_to_roles') . ' |
|
| 2443 | + FROM ' . prefixTable('restriction_to_roles').' |
|
| 2444 | 2444 | WHERE item_id=%i', |
| 2445 | 2445 | $inputData['id'] |
| 2446 | 2446 | ); |
@@ -2454,7 +2454,7 @@ discard block |
||
| 2454 | 2454 | // Get the object key for the user |
| 2455 | 2455 | $userKey = DB::queryFirstRow( |
| 2456 | 2456 | 'SELECT share_key |
| 2457 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
| 2457 | + FROM ' . prefixTable('sharekeys_items').' |
|
| 2458 | 2458 | WHERE user_id = %i AND object_id = %i', |
| 2459 | 2459 | $_SESSION['user_id'], |
| 2460 | 2460 | $inputData['id'] |
@@ -2582,8 +2582,8 @@ discard block |
||
| 2582 | 2582 | // Add restriction if item is restricted to roles |
| 2583 | 2583 | $rows = DB::query( |
| 2584 | 2584 | 'SELECT t.title, t.id |
| 2585 | - FROM ' . prefixTable('roles_title') . ' AS t |
|
| 2586 | - INNER JOIN ' . prefixTable('restriction_to_roles') . ' AS r ON (t.id=r.role_id) |
|
| 2585 | + FROM ' . prefixTable('roles_title').' AS t |
|
| 2586 | + INNER JOIN ' . prefixTable('restriction_to_roles').' AS r ON (t.id=r.role_id) |
|
| 2587 | 2587 | WHERE r.item_id = %i |
| 2588 | 2588 | ORDER BY t.title ASC', |
| 2589 | 2589 | $inputData['id'] |
@@ -2599,8 +2599,8 @@ discard block |
||
| 2599 | 2599 | $tmp = array(); |
| 2600 | 2600 | $rows = DB::query( |
| 2601 | 2601 | 'SELECT k.label, k.id |
| 2602 | - FROM ' . prefixTable('kb_items') . ' as i |
|
| 2603 | - INNER JOIN ' . prefixTable('kb') . ' as k ON (i.kb_id=k.id) |
|
| 2602 | + FROM ' . prefixTable('kb_items').' as i |
|
| 2603 | + INNER JOIN ' . prefixTable('kb').' as k ON (i.kb_id=k.id) |
|
| 2604 | 2604 | WHERE i.item_id = %i |
| 2605 | 2605 | ORDER BY k.label ASC', |
| 2606 | 2606 | $inputData['id'] |
@@ -2681,7 +2681,7 @@ discard block |
||
| 2681 | 2681 | $arrCatList = array(); |
| 2682 | 2682 | $rows_tmp = DB::query( |
| 2683 | 2683 | 'SELECT id_category |
| 2684 | - FROM ' . prefixTable('categories_folders') . ' |
|
| 2684 | + FROM ' . prefixTable('categories_folders').' |
|
| 2685 | 2685 | WHERE id_folder=%i', |
| 2686 | 2686 | $inputData['folderId'] |
| 2687 | 2687 | ); |
@@ -2696,8 +2696,8 @@ discard block |
||
| 2696 | 2696 | 'SELECT i.id AS id, i.field_id AS field_id, i.data AS data, i.item_id AS item_id, |
| 2697 | 2697 | i.encryption_type AS encryption_type, c.encrypted_data, c.parent_id AS parent_id, |
| 2698 | 2698 | c.type as field_type, c.masked AS field_masked, c.role_visibility AS role_visibility |
| 2699 | - FROM ' . prefixTable('categories_items') . ' AS i |
|
| 2700 | - INNER JOIN ' . prefixTable('categories') . ' AS c ON (i.field_id=c.id) |
|
| 2699 | + FROM ' . prefixTable('categories_items').' AS i |
|
| 2700 | + INNER JOIN ' . prefixTable('categories').' AS c ON (i.field_id=c.id) |
|
| 2701 | 2701 | WHERE i.item_id=%i AND c.parent_id IN %ls', |
| 2702 | 2702 | $inputData['id'], |
| 2703 | 2703 | $arrCatList |
@@ -2708,11 +2708,11 @@ discard block |
||
| 2708 | 2708 | //db::debugmode(true); |
| 2709 | 2709 | $userKey = DB::queryFirstRow( |
| 2710 | 2710 | 'SELECT share_key |
| 2711 | - FROM ' . prefixTable('sharekeys_fields') . ' |
|
| 2711 | + FROM ' . prefixTable('sharekeys_fields').' |
|
| 2712 | 2712 | WHERE user_id = %i AND object_id = %i', |
| 2713 | 2713 | $_SESSION['user_id'], |
| 2714 | 2714 | $row['id'] |
| 2715 | - );//db::debugmode(false); |
|
| 2715 | + ); //db::debugmode(false); |
|
| 2716 | 2716 | $fieldText = []; |
| 2717 | 2717 | if (DB::count() === 0) { |
| 2718 | 2718 | // Not encrypted |
@@ -2754,7 +2754,7 @@ discard block |
||
| 2754 | 2754 | if (isset($SETTINGS['item_creation_templates']) && (int) $SETTINGS['item_creation_templates'] === 1) { |
| 2755 | 2755 | $rows_tmp = DB::queryfirstrow( |
| 2756 | 2756 | 'SELECT category_id |
| 2757 | - FROM ' . prefixTable('templates') . ' |
|
| 2757 | + FROM ' . prefixTable('templates').' |
|
| 2758 | 2758 | WHERE item_id = %i', |
| 2759 | 2759 | $inputData['id'] |
| 2760 | 2760 | ); |
@@ -2779,7 +2779,7 @@ discard block |
||
| 2779 | 2779 | // Is the Item to be deleted? |
| 2780 | 2780 | $dataDelete = DB::queryfirstrow( |
| 2781 | 2781 | 'SELECT * |
| 2782 | - FROM ' . prefixTable('automatic_del') . ' |
|
| 2782 | + FROM ' . prefixTable('automatic_del').' |
|
| 2783 | 2783 | WHERE item_id = %i', |
| 2784 | 2784 | $inputData['id'] |
| 2785 | 2785 | ); |
@@ -2861,11 +2861,11 @@ discard block |
||
| 2861 | 2861 | if (empty($dataItem['restricted_to']) === false) { |
| 2862 | 2862 | foreach (explode(';', $dataItem['restricted_to']) as $userRest) { |
| 2863 | 2863 | if (empty($userRest) === false) { |
| 2864 | - $dataTmp = DB::queryfirstrow('SELECT login FROM ' . prefixTable('users') . ' WHERE id= ' . $userRest); |
|
| 2864 | + $dataTmp = DB::queryfirstrow('SELECT login FROM '.prefixTable('users').' WHERE id= '.$userRest); |
|
| 2865 | 2865 | if (empty($listOfRestricted)) { |
| 2866 | 2866 | $listOfRestricted = $dataTmp['login']; |
| 2867 | 2867 | } else { |
| 2868 | - $listOfRestricted .= ';' . $dataTmp['login']; |
|
| 2868 | + $listOfRestricted .= ';'.$dataTmp['login']; |
|
| 2869 | 2869 | } |
| 2870 | 2870 | } |
| 2871 | 2871 | } |
@@ -2928,8 +2928,8 @@ discard block |
||
| 2928 | 2928 | // Load item data |
| 2929 | 2929 | $dataItem = DB::queryFirstRow( |
| 2930 | 2930 | 'SELECT i.*, n.title AS folder_title |
| 2931 | - FROM ' . prefixTable('items') . ' AS i |
|
| 2932 | - INNER JOIN ' . prefixTable('nested_tree') . ' AS n ON (i.id_tree = n.id) |
|
| 2931 | + FROM ' . prefixTable('items').' AS i |
|
| 2932 | + INNER JOIN ' . prefixTable('nested_tree').' AS n ON (i.id_tree = n.id) |
|
| 2933 | 2933 | WHERE i.id = %i', |
| 2934 | 2934 | $inputData['id'] |
| 2935 | 2935 | ); |
@@ -2951,7 +2951,7 @@ discard block |
||
| 2951 | 2951 | // Check if user has a role that is accepted |
| 2952 | 2952 | $rows_tmp = DB::query( |
| 2953 | 2953 | 'SELECT role_id |
| 2954 | - FROM ' . prefixTable('restriction_to_roles') . ' |
|
| 2954 | + FROM ' . prefixTable('restriction_to_roles').' |
|
| 2955 | 2955 | WHERE item_id=%i', |
| 2956 | 2956 | $inputData['id'] |
| 2957 | 2957 | ); |
@@ -2998,7 +2998,7 @@ discard block |
||
| 2998 | 2998 | // launch query |
| 2999 | 2999 | $rows = DB::query( |
| 3000 | 3000 | 'SELECT id, name, file, extension, size |
| 3001 | - FROM ' . prefixTable('files') . ' |
|
| 3001 | + FROM ' . prefixTable('files').' |
|
| 3002 | 3002 | WHERE id_item = %i AND confirmed = 1', |
| 3003 | 3003 | $inputData['id'] |
| 3004 | 3004 | ); |
@@ -3007,7 +3007,7 @@ discard block |
||
| 3007 | 3007 | $attachments, |
| 3008 | 3008 | array( |
| 3009 | 3009 | 'icon' => fileFormatImage(strtolower($record['extension'])), |
| 3010 | - 'filename' => basename($record['name'], '.' . $record['extension']), |
|
| 3010 | + 'filename' => basename($record['name'], '.'.$record['extension']), |
|
| 3011 | 3011 | 'extension' => $record['extension'], |
| 3012 | 3012 | 'size' => formatSizeUnits((int) $record['size']), |
| 3013 | 3013 | 'is_image' => in_array(strtolower($record['extension']), TP_IMAGE_FILE_EXT) === true ? 1 : 0, |
@@ -3033,7 +3033,7 @@ discard block |
||
| 3033 | 3033 | array( |
| 3034 | 3034 | 'latest_items' => implode(';', $_SESSION['latest_items']), |
| 3035 | 3035 | ), |
| 3036 | - 'id=' . $_SESSION['user_id'] |
|
| 3036 | + 'id='.$_SESSION['user_id'] |
|
| 3037 | 3037 | ); |
| 3038 | 3038 | } |
| 3039 | 3039 | |
@@ -3042,8 +3042,8 @@ discard block |
||
| 3042 | 3042 | $listOptionsForRoles = array(); |
| 3043 | 3043 | $rows = DB::query( |
| 3044 | 3044 | 'SELECT r.role_id AS role_id, t.title AS title |
| 3045 | - FROM ' . prefixTable('roles_values') . ' AS r |
|
| 3046 | - INNER JOIN ' . prefixTable('roles_title') . ' AS t ON (r.role_id = t.id) |
|
| 3045 | + FROM ' . prefixTable('roles_values').' AS r |
|
| 3046 | + INNER JOIN ' . prefixTable('roles_title').' AS t ON (r.role_id = t.id) |
|
| 3047 | 3047 | WHERE r.folder_id = %i', |
| 3048 | 3048 | $dataItem['id_tree'] |
| 3049 | 3049 | ); |
@@ -3057,9 +3057,9 @@ discard block |
||
| 3057 | 3057 | ); |
| 3058 | 3058 | $rows2 = DB::query( |
| 3059 | 3059 | 'SELECT id, login, fonction_id, email, name, lastname |
| 3060 | - FROM ' . prefixTable('users') . ' |
|
| 3060 | + FROM ' . prefixTable('users').' |
|
| 3061 | 3061 | WHERE fonction_id LIKE %s', |
| 3062 | - '%' . $record['role_id'] . '%' |
|
| 3062 | + '%'.$record['role_id'].'%' |
|
| 3063 | 3063 | ); |
| 3064 | 3064 | foreach ($rows2 as $record2) { |
| 3065 | 3065 | foreach (explode(';', $record2['fonction_id']) as $role) { |
@@ -3072,7 +3072,7 @@ discard block |
||
| 3072 | 3072 | array( |
| 3073 | 3073 | 'id' => (int) $record2['id'], |
| 3074 | 3074 | 'login' => $record2['login'], |
| 3075 | - 'name' => $record2['name'] . ' ' . $record2['lastname'], |
|
| 3075 | + 'name' => $record2['name'].' '.$record2['lastname'], |
|
| 3076 | 3076 | 'email' => $record2['email'], |
| 3077 | 3077 | ) |
| 3078 | 3078 | ); |
@@ -3091,16 +3091,16 @@ discard block |
||
| 3091 | 3091 | $path = ''; |
| 3092 | 3092 | foreach ($arbo as $elem) { |
| 3093 | 3093 | if (empty($path) === true) { |
| 3094 | - $path = htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES) . ' '; |
|
| 3094 | + $path = htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES).' '; |
|
| 3095 | 3095 | } else { |
| 3096 | - $path .= '→ ' . htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES); |
|
| 3096 | + $path .= '→ '.htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES); |
|
| 3097 | 3097 | } |
| 3098 | 3098 | } |
| 3099 | 3099 | // Build text to show user |
| 3100 | 3100 | if (empty($path) === true) { |
| 3101 | 3101 | $path = addslashes($dataItem['label']); |
| 3102 | 3102 | } else { |
| 3103 | - $path = addslashes($dataItem['label']) . ' (' . $path . ')'; |
|
| 3103 | + $path = addslashes($dataItem['label']).' ('.$path.')'; |
|
| 3104 | 3104 | } |
| 3105 | 3105 | |
| 3106 | 3106 | // Add Admins to notification list if expected |
@@ -3123,7 +3123,7 @@ discard block |
||
| 3123 | 3123 | array( |
| 3124 | 3124 | addslashes($_SESSION['login']), |
| 3125 | 3125 | $path, |
| 3126 | - $SETTINGS['cpassman_url'] . '/index.php?page=items&group=' . $dataItem['id_tree'] . '&id=' . $dataItem['id'], |
|
| 3126 | + $SETTINGS['cpassman_url'].'/index.php?page=items&group='.$dataItem['id_tree'].'&id='.$dataItem['id'], |
|
| 3127 | 3127 | ), |
| 3128 | 3128 | langHdl('email_on_open_notification_mail') |
| 3129 | 3129 | ), |
@@ -3134,7 +3134,7 @@ discard block |
||
| 3134 | 3134 | } |
| 3135 | 3135 | |
| 3136 | 3136 | // has this item a change proposal |
| 3137 | - DB::query('SELECT * FROM ' . prefixTable('items_change') . ' WHERE item_id = %i', $inputData['id']); |
|
| 3137 | + DB::query('SELECT * FROM '.prefixTable('items_change').' WHERE item_id = %i', $inputData['id']); |
|
| 3138 | 3138 | $returnArray['has_change_proposal'] = DB::count(); |
| 3139 | 3139 | |
| 3140 | 3140 | // Setting |
@@ -3232,7 +3232,7 @@ discard block |
||
| 3232 | 3232 | // Load item data |
| 3233 | 3233 | $data = DB::queryFirstRow( |
| 3234 | 3234 | 'SELECT id_tree |
| 3235 | - FROM ' . prefixTable('items') . ' |
|
| 3235 | + FROM ' . prefixTable('items').' |
|
| 3236 | 3236 | WHERE id = %i', |
| 3237 | 3237 | $inputData['itemId'] |
| 3238 | 3238 | ); |
@@ -3298,7 +3298,7 @@ discard block |
||
| 3298 | 3298 | } |
| 3299 | 3299 | // decrypt and retreive data in JSON format |
| 3300 | 3300 | $dataReceived = prepareExchangedData( |
| 3301 | - $SETTINGS['cpassman_dir'],$inputData['data'], 'decode'); |
|
| 3301 | + $SETTINGS['cpassman_dir'], $inputData['data'], 'decode'); |
|
| 3302 | 3302 | |
| 3303 | 3303 | // Prepare variables |
| 3304 | 3304 | $title = filter_var(htmlspecialchars_decode($dataReceived['title'], ENT_QUOTES), FILTER_SANITIZE_STRING); |
@@ -3306,13 +3306,13 @@ discard block |
||
| 3306 | 3306 | |
| 3307 | 3307 | // Check if user is allowed to access this folder |
| 3308 | 3308 | if (!in_array($inputData['folderId'], $_SESSION['groupes_visibles'])) { |
| 3309 | - echo '[{"error" : "' . langHdl('error_not_allowed_to') . '"}]'; |
|
| 3309 | + echo '[{"error" : "'.langHdl('error_not_allowed_to').'"}]'; |
|
| 3310 | 3310 | break; |
| 3311 | 3311 | } |
| 3312 | 3312 | |
| 3313 | 3313 | // Check if title doesn't contains html codes |
| 3314 | 3314 | if (preg_match_all('|<[^>]+>(.*)</[^>]+>|U', $title, $out)) { |
| 3315 | - echo '[ { "error" : "' . langHdl('error_html_codes') . '" } ]'; |
|
| 3315 | + echo '[ { "error" : "'.langHdl('error_html_codes').'" } ]'; |
|
| 3316 | 3316 | break; |
| 3317 | 3317 | } |
| 3318 | 3318 | // check that title is not numeric |
@@ -3323,9 +3323,9 @@ discard block |
||
| 3323 | 3323 | |
| 3324 | 3324 | // Check if duplicate folders name are allowed |
| 3325 | 3325 | if (isset($SETTINGS['duplicate_folder']) && $SETTINGS['duplicate_folder'] === '0') { |
| 3326 | - $data = DB::queryFirstRow('SELECT id, title FROM ' . prefixTable('nested_tree') . ' WHERE title = %s', $title); |
|
| 3326 | + $data = DB::queryFirstRow('SELECT id, title FROM '.prefixTable('nested_tree').' WHERE title = %s', $title); |
|
| 3327 | 3327 | if (empty($data['id']) === false && $dataReceived['folder'] !== $data['id']) { |
| 3328 | - echo '[ { "error" : "' . langHdl('error_group_exist') . '" } ]'; |
|
| 3328 | + echo '[ { "error" : "'.langHdl('error_group_exist').'" } ]'; |
|
| 3329 | 3329 | break; |
| 3330 | 3330 | } |
| 3331 | 3331 | } |
@@ -3333,7 +3333,7 @@ discard block |
||
| 3333 | 3333 | // query on folder |
| 3334 | 3334 | $data = DB::queryfirstrow( |
| 3335 | 3335 | 'SELECT parent_id, personal_folder |
| 3336 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 3336 | + FROM ' . prefixTable('nested_tree').' |
|
| 3337 | 3337 | WHERE id = %i', |
| 3338 | 3338 | $inputData['folderId'] |
| 3339 | 3339 | ); |
@@ -3343,20 +3343,20 @@ discard block |
||
| 3343 | 3343 | if ($_SESSION['is_admin'] !== 1 && $_SESSION['user_manager'] !== 1 && $data['personal_folder'] === '0') { |
| 3344 | 3344 | $data = DB::queryfirstrow( |
| 3345 | 3345 | 'SELECT valeur |
| 3346 | - FROM ' . prefixTable('misc') . ' |
|
| 3346 | + FROM ' . prefixTable('misc').' |
|
| 3347 | 3347 | WHERE intitule = %i AND type = %s', |
| 3348 | 3348 | $data['parent_id'], |
| 3349 | 3349 | 'complex' |
| 3350 | 3350 | ); |
| 3351 | 3351 | if (intval($dataReceived['complexity']) < intval($data['valeur'])) { |
| 3352 | - echo '[ { "error" : "' . langHdl('error_folder_complexity_lower_than_top_folder') . ' [<b>' . TP_PW_COMPLEXITY[$data['valeur']][1] . '</b>]"} ]'; |
|
| 3352 | + echo '[ { "error" : "'.langHdl('error_folder_complexity_lower_than_top_folder').' [<b>'.TP_PW_COMPLEXITY[$data['valeur']][1].'</b>]"} ]'; |
|
| 3353 | 3353 | break; |
| 3354 | 3354 | } |
| 3355 | 3355 | } |
| 3356 | 3356 | |
| 3357 | 3357 | // update Folders table |
| 3358 | 3358 | $tmp = DB::queryFirstRow( |
| 3359 | - 'SELECT title, parent_id, personal_folder FROM ' . prefixTable('nested_tree') . ' WHERE id = %i', |
|
| 3359 | + 'SELECT title, parent_id, personal_folder FROM '.prefixTable('nested_tree').' WHERE id = %i', |
|
| 3360 | 3360 | $dataReceived['folder'] |
| 3361 | 3361 | ); |
| 3362 | 3362 | if ($tmp['parent_id'] !== 0 || $tmp['title'] !== $_SESSION['user_id'] || $tmp['personal_folder'] !== 1) { |
@@ -3415,7 +3415,7 @@ discard block |
||
| 3415 | 3415 | } |
| 3416 | 3416 | // decrypt and retreive data in JSON format |
| 3417 | 3417 | $dataReceived = prepareExchangedData( |
| 3418 | - $SETTINGS['cpassman_dir'],$inputData['data'], 'decode'); |
|
| 3418 | + $SETTINGS['cpassman_dir'], $inputData['data'], 'decode'); |
|
| 3419 | 3419 | $post_source_folder_id = filter_var(htmlspecialchars_decode($dataReceived['source_folder_id']), FILTER_SANITIZE_NUMBER_INT); |
| 3420 | 3420 | $post_target_folder_id = filter_var(htmlspecialchars_decode($dataReceived['target_folder_id']), FILTER_SANITIZE_NUMBER_INT); |
| 3421 | 3421 | |
@@ -3424,42 +3424,42 @@ discard block |
||
| 3424 | 3424 | in_array($post_target_folder_id, $_SESSION['groupes_visibles']) === false) && ($post_target_folder_id === '0' && |
| 3425 | 3425 | isset($SETTINGS['can_create_root_folder']) === true && (int) $SETTINGS['can_create_root_folder'] === 1) |
| 3426 | 3426 | ) { |
| 3427 | - $returnValues = '[{"error" : "' . langHdl('error_not_allowed_to') . '"}]'; |
|
| 3427 | + $returnValues = '[{"error" : "'.langHdl('error_not_allowed_to').'"}]'; |
|
| 3428 | 3428 | echo $returnValues; |
| 3429 | 3429 | break; |
| 3430 | 3430 | } |
| 3431 | 3431 | |
| 3432 | 3432 | $tmp_source = DB::queryFirstRow( |
| 3433 | 3433 | 'SELECT title, parent_id, personal_folder |
| 3434 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 3434 | + FROM ' . prefixTable('nested_tree').' |
|
| 3435 | 3435 | WHERE id = %i', |
| 3436 | 3436 | $post_source_folder_id |
| 3437 | 3437 | ); |
| 3438 | 3438 | |
| 3439 | 3439 | $tmp_target = DB::queryFirstRow( |
| 3440 | 3440 | 'SELECT title, parent_id, personal_folder |
| 3441 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 3441 | + FROM ' . prefixTable('nested_tree').' |
|
| 3442 | 3442 | WHERE id = %i', |
| 3443 | 3443 | $post_target_folder_id |
| 3444 | 3444 | ); |
| 3445 | 3445 | |
| 3446 | 3446 | // check if target is not a child of source |
| 3447 | 3447 | if ($tree->isChildOf($post_target_folder_id, $post_source_folder_id) === true) { |
| 3448 | - $returnValues = '[{"error" : "' . langHdl('error_not_allowed_to') . '"}]'; |
|
| 3448 | + $returnValues = '[{"error" : "'.langHdl('error_not_allowed_to').'"}]'; |
|
| 3449 | 3449 | echo $returnValues; |
| 3450 | 3450 | break; |
| 3451 | 3451 | } |
| 3452 | 3452 | |
| 3453 | 3453 | // check if source or target folder is PF. If Yes, then cancel operation |
| 3454 | 3454 | if ((int) $tmp_source['personal_folder'] === 1 || (int) $tmp_target['personal_folder'] === 1) { |
| 3455 | - $returnValues = '[{"error" : "' . langHdl('error_not_allowed_to') . '"}]'; |
|
| 3455 | + $returnValues = '[{"error" : "'.langHdl('error_not_allowed_to').'"}]'; |
|
| 3456 | 3456 | echo $returnValues; |
| 3457 | 3457 | break; |
| 3458 | 3458 | } |
| 3459 | 3459 | |
| 3460 | 3460 | // check if source or target folder is PF. If Yes, then cancel operation |
| 3461 | 3461 | if ($tmp_source['title'] === $_SESSION['user_id'] || $tmp_target['title'] === $_SESSION['user_id']) { |
| 3462 | - $returnValues = '[{"error" : "' . langHdl('error_not_allowed_to') . '"}]'; |
|
| 3462 | + $returnValues = '[{"error" : "'.langHdl('error_not_allowed_to').'"}]'; |
|
| 3463 | 3463 | echo $returnValues; |
| 3464 | 3464 | break; |
| 3465 | 3465 | } |
@@ -3596,7 +3596,7 @@ discard block |
||
| 3596 | 3596 | foreach ($_SESSION['user_roles'] as $role) { |
| 3597 | 3597 | $roleQ = DB::queryfirstrow( |
| 3598 | 3598 | 'SELECT allow_pw_change |
| 3599 | - FROM ' . prefixTable('roles_title') . ' |
|
| 3599 | + FROM ' . prefixTable('roles_title').' |
|
| 3600 | 3600 | WHERE id = %i', |
| 3601 | 3601 | $role |
| 3602 | 3602 | ); |
@@ -3621,11 +3621,11 @@ discard block |
||
| 3621 | 3621 | |
| 3622 | 3622 | foreach ($_SESSION['user_roles'] as $role) { |
| 3623 | 3623 | $access = DB::queryFirstRow( |
| 3624 | - 'SELECT type FROM ' . prefixTable('roles_values') . ' WHERE role_id = %i AND folder_id = %i', |
|
| 3624 | + 'SELECT type FROM '.prefixTable('roles_values').' WHERE role_id = %i AND folder_id = %i', |
|
| 3625 | 3625 | $role, |
| 3626 | 3626 | $inputData['id'] |
| 3627 | 3627 | ); |
| 3628 | - if (DB::count()>0) { |
|
| 3628 | + if (DB::count() > 0) { |
|
| 3629 | 3629 | if ($access['type'] === 'R') { |
| 3630 | 3630 | array_push($arrTmp, 10); |
| 3631 | 3631 | } elseif ($access['type'] === 'W') { |
@@ -3690,7 +3690,7 @@ discard block |
||
| 3690 | 3690 | } else { |
| 3691 | 3691 | DB::query( |
| 3692 | 3692 | 'SELECT * |
| 3693 | - FROM ' . prefixTable('items') . ' |
|
| 3693 | + FROM ' . prefixTable('items').' |
|
| 3694 | 3694 | WHERE inactif = %i', |
| 3695 | 3695 | 0 |
| 3696 | 3696 | ); |
@@ -3700,7 +3700,7 @@ discard block |
||
| 3700 | 3700 | |
| 3701 | 3701 | // Get folder complexity |
| 3702 | 3702 | $folderComplexity = DB::queryFirstRow( |
| 3703 | - 'SELECT valeur FROM ' . prefixTable('misc') . ' WHERE type = %s AND intitule = %i', |
|
| 3703 | + 'SELECT valeur FROM '.prefixTable('misc').' WHERE type = %s AND intitule = %i', |
|
| 3704 | 3704 | 'complex', |
| 3705 | 3705 | $inputData['id'] |
| 3706 | 3706 | ); |
@@ -3712,7 +3712,7 @@ discard block |
||
| 3712 | 3712 | if (isset($SETTINGS['item_extra_fields']) && (int) $SETTINGS['item_extra_fields'] === 1) { |
| 3713 | 3713 | $folderRow = DB::query( |
| 3714 | 3714 | 'SELECT id_category |
| 3715 | - FROM ' . prefixTable('categories_folders') . ' |
|
| 3715 | + FROM ' . prefixTable('categories_folders').' |
|
| 3716 | 3716 | WHERE id_folder = %i', |
| 3717 | 3717 | $inputData['id'] |
| 3718 | 3718 | ); |
@@ -3826,13 +3826,13 @@ discard block |
||
| 3826 | 3826 | // List all ITEMS |
| 3827 | 3827 | if ($folderIsPf === false) { |
| 3828 | 3828 | $where->add('i.inactif=%i', 0); |
| 3829 | - $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)"); |
|
| 3829 | + $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)"); |
|
| 3830 | 3830 | if (empty($limited_to_items) === false) { |
| 3831 | 3831 | $where->add('i.id IN %ls', explode(',', $limited_to_items)); |
| 3832 | 3832 | } |
| 3833 | 3833 | |
| 3834 | - $query_limit = ' LIMIT ' . |
|
| 3835 | - $start . ',' . |
|
| 3834 | + $query_limit = ' LIMIT '. |
|
| 3835 | + $start.','. |
|
| 3836 | 3836 | $post_nb_items_to_display_once; |
| 3837 | 3837 | //db::debugmode(true); |
| 3838 | 3838 | $rows = DB::query( |
@@ -3843,9 +3843,9 @@ discard block |
||
| 3843 | 3843 | MIN(l.action) AS log_action, |
| 3844 | 3844 | l.id_user AS log_user, |
| 3845 | 3845 | i.url AS link |
| 3846 | - FROM ' . prefixTable('items') . ' AS i |
|
| 3847 | - INNER JOIN ' . prefixTable('nested_tree') . ' AS n ON (i.id_tree = n.id) |
|
| 3848 | - INNER JOIN ' . prefixTable('log_items') . ' AS l ON (i.id = l.id_item) |
|
| 3846 | + FROM ' . prefixTable('items').' AS i |
|
| 3847 | + INNER JOIN ' . prefixTable('nested_tree').' AS n ON (i.id_tree = n.id) |
|
| 3848 | + INNER JOIN ' . prefixTable('log_items').' AS l ON (i.id = l.id_item) |
|
| 3849 | 3849 | WHERE %l |
| 3850 | 3850 | GROUP BY i.id, l.date, l.id_user, l.action |
| 3851 | 3851 | ORDER BY i.label ASC, l.date DESC' . $query_limit, |
@@ -3864,9 +3864,9 @@ discard block |
||
| 3864 | 3864 | MIN(l.action) AS log_action, |
| 3865 | 3865 | l.id_user AS log_user, |
| 3866 | 3866 | i.url AS link |
| 3867 | - FROM ' . prefixTable('items') . ' AS i |
|
| 3868 | - INNER JOIN ' . prefixTable('nested_tree') . ' AS n ON (i.id_tree = n.id) |
|
| 3869 | - INNER JOIN ' . prefixTable('log_items') . ' AS l ON (i.id = l.id_item) |
|
| 3867 | + FROM ' . prefixTable('items').' AS i |
|
| 3868 | + INNER JOIN ' . prefixTable('nested_tree').' AS n ON (i.id_tree = n.id) |
|
| 3869 | + INNER JOIN ' . prefixTable('log_items').' AS l ON (i.id = l.id_item) |
|
| 3870 | 3870 | WHERE %l |
| 3871 | 3871 | GROUP BY i.id, l.date, l.id_user, l.action |
| 3872 | 3872 | ORDER BY i.label ASC, l.date DESC', |
@@ -3896,7 +3896,7 @@ discard block |
||
| 3896 | 3896 | $item_is_restricted_to_role = false; |
| 3897 | 3897 | DB::queryfirstrow( |
| 3898 | 3898 | 'SELECT role_id |
| 3899 | - FROM ' . prefixTable('restriction_to_roles') . ' |
|
| 3899 | + FROM ' . prefixTable('restriction_to_roles').' |
|
| 3900 | 3900 | WHERE item_id = %i', |
| 3901 | 3901 | $record['id'] |
| 3902 | 3902 | ); |
@@ -3908,7 +3908,7 @@ discard block |
||
| 3908 | 3908 | $user_is_included_in_role = false; |
| 3909 | 3909 | DB::query( |
| 3910 | 3910 | 'SELECT role_id |
| 3911 | - FROM ' . prefixTable('restriction_to_roles') . ' |
|
| 3911 | + FROM ' . prefixTable('restriction_to_roles').' |
|
| 3912 | 3912 | WHERE item_id = %i AND role_id IN %ls', |
| 3913 | 3913 | $record['id'], |
| 3914 | 3914 | $_SESSION['user_roles'] |
@@ -4113,9 +4113,9 @@ discard block |
||
| 4113 | 4113 | if ((int) $start === 0) { |
| 4114 | 4114 | DB::query( |
| 4115 | 4115 | 'SELECT i.id |
| 4116 | - FROM ' . prefixTable('items') . ' as i |
|
| 4117 | - INNER JOIN ' . prefixTable('nested_tree') . ' as n ON (i.id_tree = n.id) |
|
| 4118 | - INNER JOIN ' . prefixTable('log_items') . ' as l ON (i.id = l.id_item) |
|
| 4116 | + FROM ' . prefixTable('items').' as i |
|
| 4117 | + INNER JOIN ' . prefixTable('nested_tree').' as n ON (i.id_tree = n.id) |
|
| 4118 | + INNER JOIN ' . prefixTable('log_items').' as l ON (i.id = l.id_item) |
|
| 4119 | 4119 | WHERE %l |
| 4120 | 4120 | ORDER BY i.label ASC, l.date DESC', |
| 4121 | 4121 | $where |
@@ -4181,8 +4181,8 @@ discard block |
||
| 4181 | 4181 | // Run query |
| 4182 | 4182 | $dataItem = DB::queryfirstrow( |
| 4183 | 4183 | 'SELECT i.pw AS pw, s.share_key AS share_key |
| 4184 | - FROM ' . prefixTable('items') . ' AS i |
|
| 4185 | - INNER JOIN ' . prefixTable('sharekeys_items') . ' AS s ON (s.object_id = i.id) |
|
| 4184 | + FROM ' . prefixTable('items').' AS i |
|
| 4185 | + INNER JOIN ' . prefixTable('sharekeys_items').' AS s ON (s.object_id = i.id) |
|
| 4186 | 4186 | WHERE user_id = %i AND i.id = %i', |
| 4187 | 4187 | $_SESSION['user_id'], |
| 4188 | 4188 | $inputData['itemId'] |
@@ -4225,7 +4225,7 @@ discard block |
||
| 4225 | 4225 | if (null !== $inputData['itemId'] && empty($inputData['itemId']) === false) { |
| 4226 | 4226 | $dataItem = DB::queryfirstrow( |
| 4227 | 4227 | 'SELECT perso, anyone_can_modify |
| 4228 | - FROM ' . prefixTable('items') . ' |
|
| 4228 | + FROM ' . prefixTable('items').' |
|
| 4229 | 4229 | WHERE id=%i', |
| 4230 | 4230 | $inputData['itemId'] |
| 4231 | 4231 | ); |
@@ -4264,7 +4264,7 @@ discard block |
||
| 4264 | 4264 | */ |
| 4265 | 4265 | |
| 4266 | 4266 | // Lock Item (if already locked), go back and warn |
| 4267 | - $dataTmp = DB::queryFirstRow('SELECT timestamp, user_id FROM ' . prefixTable('items_edition') . ' WHERE item_id = %i', $inputData['itemId']); |
|
| 4267 | + $dataTmp = DB::queryFirstRow('SELECT timestamp, user_id FROM '.prefixTable('items_edition').' WHERE item_id = %i', $inputData['itemId']); |
|
| 4268 | 4268 | |
| 4269 | 4269 | // If token is taken for this Item and delay is passed then delete it. |
| 4270 | 4270 | if ( |
@@ -4275,7 +4275,7 @@ discard block |
||
| 4275 | 4275 | DB::delete(prefixTable('items_edition'), 'item_id = %i', $inputData['itemId']); |
| 4276 | 4276 | //reload the previous data |
| 4277 | 4277 | $dataTmp = DB::queryFirstRow( |
| 4278 | - 'SELECT timestamp, user_id FROM ' . prefixTable('items_edition') . ' WHERE item_id = %i', |
|
| 4278 | + 'SELECT timestamp, user_id FROM '.prefixTable('items_edition').' WHERE item_id = %i', |
|
| 4279 | 4279 | $inputData['itemId'] |
| 4280 | 4280 | ); |
| 4281 | 4281 | } |
@@ -4319,7 +4319,7 @@ discard block |
||
| 4319 | 4319 | // do query on this folder |
| 4320 | 4320 | $data_this_folder = DB::queryFirstRow( |
| 4321 | 4321 | 'SELECT id, personal_folder, title |
| 4322 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 4322 | + FROM ' . prefixTable('nested_tree').' |
|
| 4323 | 4323 | WHERE id = %s', |
| 4324 | 4324 | $inputData['folderId'] |
| 4325 | 4325 | ); |
@@ -4360,8 +4360,8 @@ discard block |
||
| 4360 | 4360 | $visibilite = ''; |
| 4361 | 4361 | $data = DB::queryFirstRow( |
| 4362 | 4362 | 'SELECT m.valeur, n.personal_folder |
| 4363 | - FROM ' . prefixTable('misc') . ' AS m |
|
| 4364 | - INNER JOIN ' . prefixTable('nested_tree') . ' AS n ON (m.intitule = n.id) |
|
| 4363 | + FROM ' . prefixTable('misc').' AS m |
|
| 4364 | + INNER JOIN ' . prefixTable('nested_tree').' AS n ON (m.intitule = n.id) |
|
| 4365 | 4365 | WHERE type=%s AND intitule = %s', |
| 4366 | 4366 | 'complex', |
| 4367 | 4367 | $inputData['folderId'] |
@@ -4374,8 +4374,8 @@ discard block |
||
| 4374 | 4374 | // Prepare Item actual visibility (what Users/Roles can see it) |
| 4375 | 4375 | $rows = DB::query( |
| 4376 | 4376 | 'SELECT t.title |
| 4377 | - FROM ' . prefixTable('roles_values') . ' as v |
|
| 4378 | - INNER JOIN ' . prefixTable('roles_title') . ' as t ON (v.role_id = t.id) |
|
| 4377 | + FROM ' . prefixTable('roles_values').' as v |
|
| 4378 | + INNER JOIN ' . prefixTable('roles_title').' as t ON (v.role_id = t.id) |
|
| 4379 | 4379 | WHERE v.folder_id = %i |
| 4380 | 4380 | GROUP BY title', |
| 4381 | 4381 | $inputData['folderId'] |
@@ -4384,7 +4384,7 @@ discard block |
||
| 4384 | 4384 | if (empty($visibilite)) { |
| 4385 | 4385 | $visibilite = $record['title']; |
| 4386 | 4386 | } else { |
| 4387 | - $visibilite .= ' - ' . $record['title']; |
|
| 4387 | + $visibilite .= ' - '.$record['title']; |
|
| 4388 | 4388 | } |
| 4389 | 4389 | } |
| 4390 | 4390 | } else { |
@@ -4394,14 +4394,14 @@ discard block |
||
| 4394 | 4394 | // do new query to know if current folder is pf |
| 4395 | 4395 | $data_pf = DB::queryFirstRow( |
| 4396 | 4396 | 'SELECT personal_folder |
| 4397 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 4397 | + FROM ' . prefixTable('nested_tree').' |
|
| 4398 | 4398 | WHERE id = %s', |
| 4399 | 4399 | $inputData['folderId'] |
| 4400 | 4400 | ); |
| 4401 | 4401 | |
| 4402 | 4402 | $folder_is_personal = $data_pf !== null ? (int) $data_pf['personal_folder'] : 0; |
| 4403 | 4403 | |
| 4404 | - $visibilite = $_SESSION['name'] . ' ' . $_SESSION['lastname'] . ' (' . $_SESSION['login'] . ')'; |
|
| 4404 | + $visibilite = $_SESSION['name'].' '.$_SESSION['lastname'].' ('.$_SESSION['login'].')'; |
|
| 4405 | 4405 | } |
| 4406 | 4406 | |
| 4407 | 4407 | recupDroitCreationSansComplexite($inputData['folderId']); |
@@ -4411,8 +4411,8 @@ discard block |
||
| 4411 | 4411 | $listOptionsForRoles = array(); |
| 4412 | 4412 | $rows = DB::query( |
| 4413 | 4413 | 'SELECT r.role_id AS role_id, t.title AS title |
| 4414 | - FROM ' . prefixTable('roles_values') . ' AS r |
|
| 4415 | - INNER JOIN ' . prefixTable('roles_title') . ' AS t ON (r.role_id = t.id) |
|
| 4414 | + FROM ' . prefixTable('roles_values').' AS r |
|
| 4415 | + INNER JOIN ' . prefixTable('roles_title').' AS t ON (r.role_id = t.id) |
|
| 4416 | 4416 | WHERE r.folder_id = %i', |
| 4417 | 4417 | $inputData['folderId'] |
| 4418 | 4418 | ); |
@@ -4426,7 +4426,7 @@ discard block |
||
| 4426 | 4426 | ); |
| 4427 | 4427 | $rows2 = DB::query( |
| 4428 | 4428 | 'SELECT id, login, fonction_id, email, name, lastname |
| 4429 | - FROM ' . prefixTable('users') . ' |
|
| 4429 | + FROM ' . prefixTable('users').' |
|
| 4430 | 4430 | WHERE admin = 0 AND fonction_id is not null' |
| 4431 | 4431 | ); |
| 4432 | 4432 | foreach ($rows2 as $record2) { |
@@ -4440,7 +4440,7 @@ discard block |
||
| 4440 | 4440 | array( |
| 4441 | 4441 | 'id' => $record2['id'], |
| 4442 | 4442 | 'login' => $record2['login'], |
| 4443 | - 'name' => $record2['name'] . ' ' . $record2['lastname'], |
|
| 4443 | + 'name' => $record2['name'].' '.$record2['lastname'], |
|
| 4444 | 4444 | 'email' => $record2['email'], |
| 4445 | 4445 | ) |
| 4446 | 4446 | ); |
@@ -4457,13 +4457,13 @@ discard block |
||
| 4457 | 4457 | //db::debugmode(true); |
| 4458 | 4458 | $access = DB::queryFirstRow( |
| 4459 | 4459 | 'SELECT type |
| 4460 | - FROM ' . prefixTable('roles_values') . ' |
|
| 4460 | + FROM ' . prefixTable('roles_values').' |
|
| 4461 | 4461 | WHERE role_id = %i AND folder_id = %i', |
| 4462 | 4462 | $role, |
| 4463 | 4463 | $inputData['folderId'] |
| 4464 | 4464 | ); |
| 4465 | 4465 | //db::debugmode(false); |
| 4466 | - if (DB::count()>0) { |
|
| 4466 | + if (DB::count() > 0) { |
|
| 4467 | 4467 | if ($access['type'] === 'R') { |
| 4468 | 4468 | array_push($arrTmp, 10); |
| 4469 | 4469 | } elseif ($access['type'] === 'W') { |
@@ -4539,7 +4539,7 @@ discard block |
||
| 4539 | 4539 | // Get some info before deleting |
| 4540 | 4540 | $data = DB::queryFirstRow( |
| 4541 | 4541 | 'SELECT name, id_item, file |
| 4542 | - FROM ' . prefixTable('files') . ' |
|
| 4542 | + FROM ' . prefixTable('files').' |
|
| 4543 | 4543 | WHERE id = %i', |
| 4544 | 4544 | $fileId |
| 4545 | 4545 | ); |
@@ -4547,7 +4547,7 @@ discard block |
||
| 4547 | 4547 | // Load item data |
| 4548 | 4548 | $data_item = DB::queryFirstRow( |
| 4549 | 4549 | 'SELECT id_tree |
| 4550 | - FROM ' . prefixTable('items') . ' |
|
| 4550 | + FROM ' . prefixTable('items').' |
|
| 4551 | 4551 | WHERE id = %i', |
| 4552 | 4552 | $data['id_item'] |
| 4553 | 4553 | ); |
@@ -4578,7 +4578,7 @@ discard block |
||
| 4578 | 4578 | $_SESSION['user_id'], |
| 4579 | 4579 | 'at_modification', |
| 4580 | 4580 | $_SESSION['login'], |
| 4581 | - 'at_del_file : ' . $data['name'] |
|
| 4581 | + 'at_del_file : '.$data['name'] |
|
| 4582 | 4582 | ); |
| 4583 | 4583 | |
| 4584 | 4584 | // DElete sharekeys |
@@ -4589,7 +4589,7 @@ discard block |
||
| 4589 | 4589 | ); |
| 4590 | 4590 | |
| 4591 | 4591 | // Delete file from server |
| 4592 | - fileDelete($SETTINGS['path_to_upload_folder'] . '/' . TP_FILE_PREFIX . base64_decode($data['file']), $SETTINGS); |
|
| 4592 | + fileDelete($SETTINGS['path_to_upload_folder'].'/'.TP_FILE_PREFIX.base64_decode($data['file']), $SETTINGS); |
|
| 4593 | 4593 | } |
| 4594 | 4594 | |
| 4595 | 4595 | echo (string) prepareExchangedData( |
@@ -4642,13 +4642,13 @@ discard block |
||
| 4642 | 4642 | // Update SESSION with this new favourite |
| 4643 | 4643 | $data = DB::queryfirstrow( |
| 4644 | 4644 | 'SELECT label,id_tree |
| 4645 | - FROM ' . prefixTable('items') . ' |
|
| 4645 | + FROM ' . prefixTable('items').' |
|
| 4646 | 4646 | WHERE id = %i', |
| 4647 | 4647 | $inputData['itemId'] |
| 4648 | 4648 | ); |
| 4649 | 4649 | $_SESSION['favourites_tab'][$inputData['itemId']] = array( |
| 4650 | 4650 | 'label' => $data['label'], |
| 4651 | - 'url' => 'index.php?page=items&group=' . $data['id_tree'] . '&id=' . $inputData['itemId'], |
|
| 4651 | + 'url' => 'index.php?page=items&group='.$data['id_tree'].'&id='.$inputData['itemId'], |
|
| 4652 | 4652 | ); |
| 4653 | 4653 | } elseif ((int) $inputData['action'] === 1) { |
| 4654 | 4654 | // delete from session |
@@ -4720,8 +4720,8 @@ discard block |
||
| 4720 | 4720 | // get data about item |
| 4721 | 4721 | $dataSource = DB::queryfirstrow( |
| 4722 | 4722 | 'SELECT i.pw, f.personal_folder,i.id_tree, f.title,i.label |
| 4723 | - FROM ' . prefixTable('items') . ' as i |
|
| 4724 | - INNER JOIN ' . prefixTable('nested_tree') . ' as f ON (i.id_tree=f.id) |
|
| 4723 | + FROM ' . prefixTable('items').' as i |
|
| 4724 | + INNER JOIN ' . prefixTable('nested_tree').' as f ON (i.id_tree=f.id) |
|
| 4725 | 4725 | WHERE i.id=%i', |
| 4726 | 4726 | $inputData['itemId'] |
| 4727 | 4727 | ); |
@@ -4729,7 +4729,7 @@ discard block |
||
| 4729 | 4729 | // get data about new folder |
| 4730 | 4730 | $dataDestination = DB::queryfirstrow( |
| 4731 | 4731 | 'SELECT personal_folder, title |
| 4732 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 4732 | + FROM ' . prefixTable('nested_tree').' |
|
| 4733 | 4733 | WHERE id = %i', |
| 4734 | 4734 | $inputData['folderId'] |
| 4735 | 4735 | ); |
@@ -4782,7 +4782,7 @@ discard block |
||
| 4782 | 4782 | // Get fields for this Item |
| 4783 | 4783 | $rows = DB::query( |
| 4784 | 4784 | 'SELECT id |
| 4785 | - FROM ' . prefixTable('categories_items') . ' |
|
| 4785 | + FROM ' . prefixTable('categories_items').' |
|
| 4786 | 4786 | WHERE item_id = %i', |
| 4787 | 4787 | $inputData['itemId'] |
| 4788 | 4788 | ); |
@@ -4799,7 +4799,7 @@ discard block |
||
| 4799 | 4799 | // Get FILES for this Item |
| 4800 | 4800 | $rows = DB::query( |
| 4801 | 4801 | 'SELECT id |
| 4802 | - FROM ' . prefixTable('files') . ' |
|
| 4802 | + FROM ' . prefixTable('files').' |
|
| 4803 | 4803 | WHERE id_item = %i', |
| 4804 | 4804 | $inputData['itemId'] |
| 4805 | 4805 | ); |
@@ -4844,7 +4844,7 @@ discard block |
||
| 4844 | 4844 | // Get the ITEM object key for the user |
| 4845 | 4845 | $userKey = DB::queryFirstRow( |
| 4846 | 4846 | 'SELECT share_key |
| 4847 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
| 4847 | + FROM ' . prefixTable('sharekeys_items').' |
|
| 4848 | 4848 | WHERE user_id = %i AND object_id = %i', |
| 4849 | 4849 | $_SESSION['user_id'], |
| 4850 | 4850 | $inputData['itemId'] |
@@ -4855,8 +4855,8 @@ discard block |
||
| 4855 | 4855 | // This is a public object |
| 4856 | 4856 | $users = DB::query( |
| 4857 | 4857 | 'SELECT id, public_key |
| 4858 | - FROM ' . prefixTable('users') . ' |
|
| 4859 | - WHERE id NOT IN ("' . OTV_USER_ID . '","' . SSH_USER_ID . '","' . API_USER_ID . '","' . $_SESSION['user_id'] . '") |
|
| 4858 | + FROM ' . prefixTable('users').' |
|
| 4859 | + WHERE id NOT IN ("' . OTV_USER_ID.'","'.SSH_USER_ID.'","'.API_USER_ID.'","'.$_SESSION['user_id'].'") |
|
| 4860 | 4860 | AND public_key != ""' |
| 4861 | 4861 | ); |
| 4862 | 4862 | foreach ($users as $user) { |
@@ -4876,14 +4876,14 @@ discard block |
||
| 4876 | 4876 | // Get fields for this Item |
| 4877 | 4877 | $rows = DB::query( |
| 4878 | 4878 | 'SELECT id |
| 4879 | - FROM ' . prefixTable('categories_items') . ' |
|
| 4879 | + FROM ' . prefixTable('categories_items').' |
|
| 4880 | 4880 | WHERE item_id = %i', |
| 4881 | 4881 | $inputData['itemId'] |
| 4882 | 4882 | ); |
| 4883 | 4883 | foreach ($rows as $field) { |
| 4884 | 4884 | $userKey = DB::queryFirstRow( |
| 4885 | 4885 | 'SELECT share_key |
| 4886 | - FROM ' . prefixTable('sharekeys_fields') . ' |
|
| 4886 | + FROM ' . prefixTable('sharekeys_fields').' |
|
| 4887 | 4887 | WHERE user_id = %i AND object_id = %i', |
| 4888 | 4888 | $_SESSION['user_id'], |
| 4889 | 4889 | $field['id'] |
@@ -4894,8 +4894,8 @@ discard block |
||
| 4894 | 4894 | // This is a public object |
| 4895 | 4895 | $users = DB::query( |
| 4896 | 4896 | 'SELECT id, public_key |
| 4897 | - FROM ' . prefixTable('users') . ' |
|
| 4898 | - WHERE id NOT IN ("' . OTV_USER_ID . '","' . SSH_USER_ID . '","' . API_USER_ID . '","' . $_SESSION['user_id'] . '") |
|
| 4897 | + FROM ' . prefixTable('users').' |
|
| 4898 | + WHERE id NOT IN ("' . OTV_USER_ID.'","'.SSH_USER_ID.'","'.API_USER_ID.'","'.$_SESSION['user_id'].'") |
|
| 4899 | 4899 | AND public_key != ""' |
| 4900 | 4900 | ); |
| 4901 | 4901 | foreach ($users as $user) { |
@@ -4916,14 +4916,14 @@ discard block |
||
| 4916 | 4916 | // Get FILES for this Item |
| 4917 | 4917 | $rows = DB::query( |
| 4918 | 4918 | 'SELECT id |
| 4919 | - FROM ' . prefixTable('files') . ' |
|
| 4919 | + FROM ' . prefixTable('files').' |
|
| 4920 | 4920 | WHERE id_item = %i', |
| 4921 | 4921 | $inputData['itemId'] |
| 4922 | 4922 | ); |
| 4923 | 4923 | foreach ($rows as $attachment) { |
| 4924 | 4924 | $userKey = DB::queryFirstRow( |
| 4925 | 4925 | 'SELECT share_key |
| 4926 | - FROM ' . prefixTable('sharekeys_files') . ' |
|
| 4926 | + FROM ' . prefixTable('sharekeys_files').' |
|
| 4927 | 4927 | WHERE user_id = %i AND object_id = %i', |
| 4928 | 4928 | $_SESSION['user_id'], |
| 4929 | 4929 | $attachment['id'] |
@@ -4934,8 +4934,8 @@ discard block |
||
| 4934 | 4934 | // This is a public object |
| 4935 | 4935 | $users = DB::query( |
| 4936 | 4936 | 'SELECT id, public_key |
| 4937 | - FROM ' . prefixTable('users') . ' |
|
| 4938 | - WHERE id NOT IN ("' . OTV_USER_ID . '","' . SSH_USER_ID . '","' . API_USER_ID . '","' . $_SESSION['user_id'] . '") |
|
| 4937 | + FROM ' . prefixTable('users').' |
|
| 4938 | + WHERE id NOT IN ("' . OTV_USER_ID.'","'.SSH_USER_ID.'","'.API_USER_ID.'","'.$_SESSION['user_id'].'") |
|
| 4939 | 4939 | AND public_key != ""' |
| 4940 | 4940 | ); |
| 4941 | 4941 | foreach ($users as $user) { |
@@ -4972,7 +4972,7 @@ discard block |
||
| 4972 | 4972 | $_SESSION['user_id'], |
| 4973 | 4973 | 'at_modification', |
| 4974 | 4974 | $_SESSION['login'], |
| 4975 | - 'at_moved : ' . $dataSource['title'] . ' -> ' . $dataDestination['title'] |
|
| 4975 | + 'at_moved : '.$dataSource['title'].' -> '.$dataDestination['title'] |
|
| 4976 | 4976 | ); |
| 4977 | 4977 | |
| 4978 | 4978 | // Update cache table |
@@ -5039,8 +5039,8 @@ discard block |
||
| 5039 | 5039 | // get data about item |
| 5040 | 5040 | $dataSource = DB::queryfirstrow( |
| 5041 | 5041 | 'SELECT i.pw, f.personal_folder,i.id_tree, f.title,i.label |
| 5042 | - FROM ' . prefixTable('items') . ' as i |
|
| 5043 | - INNER JOIN ' . prefixTable('nested_tree') . ' as f ON (i.id_tree=f.id) |
|
| 5042 | + FROM ' . prefixTable('items').' as i |
|
| 5043 | + INNER JOIN ' . prefixTable('nested_tree').' as f ON (i.id_tree=f.id) |
|
| 5044 | 5044 | WHERE i.id=%i', |
| 5045 | 5045 | $item_id |
| 5046 | 5046 | ); |
@@ -5063,7 +5063,7 @@ discard block |
||
| 5063 | 5063 | |
| 5064 | 5064 | // get data about new folder |
| 5065 | 5065 | $dataDestination = DB::queryfirstrow( |
| 5066 | - 'SELECT personal_folder, title FROM ' . prefixTable('nested_tree') . ' WHERE id = %i', |
|
| 5066 | + 'SELECT personal_folder, title FROM '.prefixTable('nested_tree').' WHERE id = %i', |
|
| 5067 | 5067 | $inputData['folderId'] |
| 5068 | 5068 | ); |
| 5069 | 5069 | |
@@ -5104,7 +5104,7 @@ discard block |
||
| 5104 | 5104 | // Get fields for this Item |
| 5105 | 5105 | $rows = DB::query( |
| 5106 | 5106 | 'SELECT id |
| 5107 | - FROM ' . prefixTable('categories_items') . ' |
|
| 5107 | + FROM ' . prefixTable('categories_items').' |
|
| 5108 | 5108 | WHERE item_id = %i', |
| 5109 | 5109 | $item_id |
| 5110 | 5110 | ); |
@@ -5121,7 +5121,7 @@ discard block |
||
| 5121 | 5121 | // Get FILES for this Item |
| 5122 | 5122 | $rows = DB::query( |
| 5123 | 5123 | 'SELECT id |
| 5124 | - FROM ' . prefixTable('files') . ' |
|
| 5124 | + FROM ' . prefixTable('files').' |
|
| 5125 | 5125 | WHERE id_item = %i', |
| 5126 | 5126 | $item_id |
| 5127 | 5127 | ); |
@@ -5174,7 +5174,7 @@ discard block |
||
| 5174 | 5174 | // Get the ITEM object key for the user |
| 5175 | 5175 | $userKey = DB::queryFirstRow( |
| 5176 | 5176 | 'SELECT share_key |
| 5177 | - FROM ' . prefixTable('sharekeys_items') . ' |
|
| 5177 | + FROM ' . prefixTable('sharekeys_items').' |
|
| 5178 | 5178 | WHERE user_id = %i AND object_id = %i', |
| 5179 | 5179 | $_SESSION['user_id'], |
| 5180 | 5180 | $item_id |
@@ -5185,8 +5185,8 @@ discard block |
||
| 5185 | 5185 | // This is a public object |
| 5186 | 5186 | $users = DB::query( |
| 5187 | 5187 | 'SELECT id, public_key |
| 5188 | - FROM ' . prefixTable('users') . ' |
|
| 5189 | - WHERE id NOT IN ("' . OTV_USER_ID . '","' . SSH_USER_ID . '","' . API_USER_ID . '","' . $_SESSION['user_id'] . '") |
|
| 5188 | + FROM ' . prefixTable('users').' |
|
| 5189 | + WHERE id NOT IN ("' . OTV_USER_ID.'","'.SSH_USER_ID.'","'.API_USER_ID.'","'.$_SESSION['user_id'].'") |
|
| 5190 | 5190 | AND public_key != ""' |
| 5191 | 5191 | ); |
| 5192 | 5192 | foreach ($users as $user) { |
@@ -5206,14 +5206,14 @@ discard block |
||
| 5206 | 5206 | // Get fields for this Item |
| 5207 | 5207 | $rows = DB::query( |
| 5208 | 5208 | 'SELECT id |
| 5209 | - FROM ' . prefixTable('categories_items') . ' |
|
| 5209 | + FROM ' . prefixTable('categories_items').' |
|
| 5210 | 5210 | WHERE item_id = %i', |
| 5211 | 5211 | $item_id |
| 5212 | 5212 | ); |
| 5213 | 5213 | foreach ($rows as $field) { |
| 5214 | 5214 | $userKey = DB::queryFirstRow( |
| 5215 | 5215 | 'SELECT share_key |
| 5216 | - FROM ' . prefixTable('sharekeys_fields') . ' |
|
| 5216 | + FROM ' . prefixTable('sharekeys_fields').' |
|
| 5217 | 5217 | WHERE user_id = %i AND object_id = %i', |
| 5218 | 5218 | $_SESSION['user_id'], |
| 5219 | 5219 | $field['id'] |
@@ -5224,8 +5224,8 @@ discard block |
||
| 5224 | 5224 | // This is a public object |
| 5225 | 5225 | $users = DB::query( |
| 5226 | 5226 | 'SELECT id, public_key |
| 5227 | - FROM ' . prefixTable('users') . ' |
|
| 5228 | - WHERE id NOT IN ("' . OTV_USER_ID . '","' . SSH_USER_ID . '","' . API_USER_ID . '","' . $_SESSION['user_id'] . '") |
|
| 5227 | + FROM ' . prefixTable('users').' |
|
| 5228 | + WHERE id NOT IN ("' . OTV_USER_ID.'","'.SSH_USER_ID.'","'.API_USER_ID.'","'.$_SESSION['user_id'].'") |
|
| 5229 | 5229 | AND public_key != ""' |
| 5230 | 5230 | ); |
| 5231 | 5231 | foreach ($users as $user) { |
@@ -5246,14 +5246,14 @@ discard block |
||
| 5246 | 5246 | // Get FILES for this Item |
| 5247 | 5247 | $rows = DB::query( |
| 5248 | 5248 | 'SELECT id |
| 5249 | - FROM ' . prefixTable('files') . ' |
|
| 5249 | + FROM ' . prefixTable('files').' |
|
| 5250 | 5250 | WHERE id_item = %i', |
| 5251 | 5251 | $item_id |
| 5252 | 5252 | ); |
| 5253 | 5253 | foreach ($rows as $attachment) { |
| 5254 | 5254 | $userKey = DB::queryFirstRow( |
| 5255 | 5255 | 'SELECT share_key |
| 5256 | - FROM ' . prefixTable('sharekeys_files') . ' |
|
| 5256 | + FROM ' . prefixTable('sharekeys_files').' |
|
| 5257 | 5257 | WHERE user_id = %i AND object_id = %i', |
| 5258 | 5258 | $_SESSION['user_id'], |
| 5259 | 5259 | $attachment['id'] |
@@ -5264,8 +5264,8 @@ discard block |
||
| 5264 | 5264 | // This is a public object |
| 5265 | 5265 | $users = DB::query( |
| 5266 | 5266 | 'SELECT id, public_key |
| 5267 | - FROM ' . prefixTable('users') . ' |
|
| 5268 | - WHERE id NOT IN ("' . OTV_USER_ID . '","' . SSH_USER_ID . '","' . API_USER_ID . '","' . $_SESSION['user_id'] . '") |
|
| 5267 | + FROM ' . prefixTable('users').' |
|
| 5268 | + WHERE id NOT IN ("' . OTV_USER_ID.'","'.SSH_USER_ID.'","'.API_USER_ID.'","'.$_SESSION['user_id'].'") |
|
| 5269 | 5269 | AND public_key != ""' |
| 5270 | 5270 | ); |
| 5271 | 5271 | foreach ($users as $user) { |
@@ -5301,13 +5301,13 @@ discard block |
||
| 5301 | 5301 | $_SESSION['user_id'], |
| 5302 | 5302 | 'at_modification', |
| 5303 | 5303 | $_SESSION['login'], |
| 5304 | - 'at_moved : ' . $dataSource['title'] . ' -> ' . $dataDestination['title'] |
|
| 5304 | + 'at_moved : '.$dataSource['title'].' -> '.$dataDestination['title'] |
|
| 5305 | 5305 | ); |
| 5306 | 5306 | } |
| 5307 | 5307 | } |
| 5308 | 5308 | |
| 5309 | 5309 | // reload cache table |
| 5310 | - require_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php'; |
|
| 5310 | + require_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php'; |
|
| 5311 | 5311 | updateCacheTable('reload', $SETTINGS, null); |
| 5312 | 5312 | |
| 5313 | 5313 | echo (string) prepareExchangedData( |
@@ -5376,7 +5376,7 @@ discard block |
||
| 5376 | 5376 | // get info |
| 5377 | 5377 | $dataSource = DB::queryfirstrow( |
| 5378 | 5378 | 'SELECT label, id_tree |
| 5379 | - FROM ' . prefixTable('items') . ' |
|
| 5379 | + FROM ' . prefixTable('items').' |
|
| 5380 | 5380 | WHERE id=%i', |
| 5381 | 5381 | $item_id |
| 5382 | 5382 | ); |
@@ -5481,8 +5481,8 @@ discard block |
||
| 5481 | 5481 | } |
| 5482 | 5482 | if ($inputData['cat'] === 'request_access_to_author') { |
| 5483 | 5483 | // Variables |
| 5484 | - $dataAuthor = DB::queryfirstrow('SELECT email,login FROM ' . prefixTable('users') . ' WHERE id = ' . $post_content[1]); |
|
| 5485 | - $dataItem = DB::queryfirstrow('SELECT label, id_tree FROM ' . prefixTable('items') . ' WHERE id = ' . $post_content[0]); |
|
| 5484 | + $dataAuthor = DB::queryfirstrow('SELECT email,login FROM '.prefixTable('users').' WHERE id = '.$post_content[1]); |
|
| 5485 | + $dataItem = DB::queryfirstrow('SELECT label, id_tree FROM '.prefixTable('items').' WHERE id = '.$post_content[0]); |
|
| 5486 | 5486 | |
| 5487 | 5487 | // Get path |
| 5488 | 5488 | $path = geItemReadablePath( |
@@ -5496,7 +5496,7 @@ discard block |
||
| 5496 | 5496 | langHdl('email_request_access_subject'), |
| 5497 | 5497 | str_replace( |
| 5498 | 5498 | array('#tp_item_author#', '#tp_user#', '#tp_item#'), |
| 5499 | - array(' ' . addslashes($dataAuthor['login']), addslashes($_SESSION['login']), $path), |
|
| 5499 | + array(' '.addslashes($dataAuthor['login']), addslashes($_SESSION['login']), $path), |
|
| 5500 | 5500 | langHdl('email_request_access_mail') |
| 5501 | 5501 | ), |
| 5502 | 5502 | $dataAuthor['email'], |
@@ -5506,7 +5506,7 @@ discard block |
||
| 5506 | 5506 | } elseif ($inputData['cat'] === 'share_this_item') { |
| 5507 | 5507 | $dataItem = DB::queryfirstrow( |
| 5508 | 5508 | 'SELECT label,id_tree |
| 5509 | - FROM ' . prefixTable('items') . ' |
|
| 5509 | + FROM ' . prefixTable('items').' |
|
| 5510 | 5510 | WHERE id= %i', |
| 5511 | 5511 | $inputData['id'] |
| 5512 | 5512 | ); |
@@ -5529,7 +5529,7 @@ discard block |
||
| 5529 | 5529 | ), |
| 5530 | 5530 | array( |
| 5531 | 5531 | empty($SETTINGS['email_server_url']) === false ? |
| 5532 | - $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'], |
|
| 5532 | + $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'], |
|
| 5533 | 5533 | addslashes($_SESSION['login']), |
| 5534 | 5534 | addslashes($path), |
| 5535 | 5535 | ), |
@@ -5555,7 +5555,7 @@ discard block |
||
| 5555 | 5555 | if ($inputData['notifyType'] === 'on_show') { |
| 5556 | 5556 | // Check if values already exist |
| 5557 | 5557 | $data = DB::queryfirstrow( |
| 5558 | - 'SELECT notification FROM ' . prefixTable('items') . ' WHERE id = %i', |
|
| 5558 | + 'SELECT notification FROM '.prefixTable('items').' WHERE id = %i', |
|
| 5559 | 5559 | $inputData['itemId'] |
| 5560 | 5560 | ); |
| 5561 | 5561 | $notifiedUsers = explode(';', $data['notification']); |
@@ -5566,8 +5566,8 @@ discard block |
||
| 5566 | 5566 | prefixTable('items'), |
| 5567 | 5567 | array( |
| 5568 | 5568 | 'notification' => empty($data['notification']) ? |
| 5569 | - $inputData['userId'] . ';' |
|
| 5570 | - : $data['notification'] . $inputData['userId'] , |
|
| 5569 | + $inputData['userId'].';' |
|
| 5570 | + : $data['notification'].$inputData['userId'], |
|
| 5571 | 5571 | ), |
| 5572 | 5572 | 'id=%i', |
| 5573 | 5573 | $inputData['itemId'] |
@@ -5583,7 +5583,7 @@ discard block |
||
| 5583 | 5583 | array( |
| 5584 | 5584 | 'notification' => empty($data['notification']) ? |
| 5585 | 5585 | $inputData['userId'] |
| 5586 | - : $data['notification'] . ';' . $inputData['userId'], |
|
| 5586 | + : $data['notification'].';'.$inputData['userId'], |
|
| 5587 | 5587 | ), |
| 5588 | 5588 | 'id=%i', |
| 5589 | 5589 | $inputData['itemId'] |
@@ -5616,8 +5616,8 @@ discard block |
||
| 5616 | 5616 | // Get all informations for this item |
| 5617 | 5617 | $dataItem = DB::queryfirstrow( |
| 5618 | 5618 | 'SELECT * |
| 5619 | - FROM ' . prefixTable('items') . ' as i |
|
| 5620 | - INNER JOIN ' . prefixTable('log_items') . ' as l ON (l.id_item = i.id) |
|
| 5619 | + FROM ' . prefixTable('items').' as i |
|
| 5620 | + INNER JOIN ' . prefixTable('log_items').' as l ON (l.id_item = i.id) |
|
| 5621 | 5621 | WHERE i.id=%i AND l.action = %s', |
| 5622 | 5622 | $dataReceived['item_id'], |
| 5623 | 5623 | 'at_creation' |
@@ -5648,14 +5648,14 @@ discard block |
||
| 5648 | 5648 | ); |
| 5649 | 5649 | // Prepare new line |
| 5650 | 5650 | $data = DB::queryfirstrow( |
| 5651 | - 'SELECT * FROM ' . prefixTable('log_items') . ' WHERE id_item = %i ORDER BY date DESC', |
|
| 5651 | + 'SELECT * FROM '.prefixTable('log_items').' WHERE id_item = %i ORDER BY date DESC', |
|
| 5652 | 5652 | $dataReceived['item_id'] |
| 5653 | 5653 | ); |
| 5654 | - $historic = date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], $data['date']) . ' - ' . $_SESSION['login'] . ' - ' . langHdl($data['action']) . ' - ' . $data['raison']; |
|
| 5654 | + $historic = date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], $data['date']).' - '.$_SESSION['login'].' - '.langHdl($data['action']).' - '.$data['raison']; |
|
| 5655 | 5655 | // send back |
| 5656 | 5656 | $data = array( |
| 5657 | 5657 | 'error' => '', |
| 5658 | - 'new_line' => '<br>' . addslashes($historic), |
|
| 5658 | + 'new_line' => '<br>'.addslashes($historic), |
|
| 5659 | 5659 | ); |
| 5660 | 5660 | echo (string) prepareExchangedData( |
| 5661 | 5661 | $SETTINGS['cpassman_dir'], |
@@ -5723,7 +5723,7 @@ discard block |
||
| 5723 | 5723 | } |
| 5724 | 5724 | |
| 5725 | 5725 | // delete all existing old otv codes |
| 5726 | - $rows = DB::query('SELECT id FROM ' . prefixTable('otv') . ' WHERE timestamp < ' . (time() - $SETTINGS['otv_expiration_period'] * 86400)); |
|
| 5726 | + $rows = DB::query('SELECT id FROM '.prefixTable('otv').' WHERE timestamp < '.(time() - $SETTINGS['otv_expiration_period'] * 86400)); |
|
| 5727 | 5727 | foreach ($rows as $record) { |
| 5728 | 5728 | DB::delete(prefixTable('otv'), 'id=%i', $record['id']); |
| 5729 | 5729 | } |
@@ -5745,8 +5745,8 @@ discard block |
||
| 5745 | 5745 | // Should we log a password change? |
| 5746 | 5746 | $itemQ = DB::queryFirstRow( |
| 5747 | 5747 | 'SELECT s.share_key, i.pw |
| 5748 | - FROM ' . prefixTable('items') . ' AS i |
|
| 5749 | - INNER JOIN ' . prefixTable('sharekeys_items') . ' AS s ON (i.id = s.object_id) |
|
| 5748 | + FROM ' . prefixTable('items').' AS i |
|
| 5749 | + INNER JOIN ' . prefixTable('sharekeys_items').' AS s ON (i.id = s.object_id) |
|
| 5750 | 5750 | WHERE s.user_id = %i AND s.object_id = %i', |
| 5751 | 5751 | $_SESSION['user_id'], |
| 5752 | 5752 | $inputData['id'] |
@@ -5796,7 +5796,7 @@ discard block |
||
| 5796 | 5796 | if (isset($SETTINGS['otv_expiration_period']) === false) { |
| 5797 | 5797 | $SETTINGS['otv_expiration_period'] = 7; |
| 5798 | 5798 | } |
| 5799 | - $url = $SETTINGS['cpassman_url'] . '/index.php?otv=true&' . http_build_query($otv_session); |
|
| 5799 | + $url = $SETTINGS['cpassman_url'].'/index.php?otv=true&'.http_build_query($otv_session); |
|
| 5800 | 5800 | //$exp_date = date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], time() + (intval($SETTINGS['otv_expiration_period']) * 86400)); |
| 5801 | 5801 | |
| 5802 | 5802 | echo json_encode( |
@@ -5835,8 +5835,8 @@ discard block |
||
| 5835 | 5835 | 'SELECT f.id AS id, f.file AS file, f.name AS name, f.status AS status, |
| 5836 | 5836 | f.extension AS extension, f.type AS type, |
| 5837 | 5837 | s.share_key AS share_key |
| 5838 | - FROM ' . prefixTable('files') . ' AS f |
|
| 5839 | - INNER JOIN ' . prefixTable('sharekeys_files') . ' AS s ON (f.id = s.object_id) |
|
| 5838 | + FROM ' . prefixTable('files').' AS f |
|
| 5839 | + INNER JOIN ' . prefixTable('sharekeys_files').' AS s ON (f.id = s.object_id) |
|
| 5840 | 5840 | WHERE s.user_id = %i AND s.object_id = %i', |
| 5841 | 5841 | $_SESSION['user_id'], |
| 5842 | 5842 | $inputData['id'] |
@@ -5858,7 +5858,7 @@ discard block |
||
| 5858 | 5858 | //$fileName = basename($file_info['name'], '.'.$file_info['extension']); |
| 5859 | 5859 | |
| 5860 | 5860 | // prepare image info |
| 5861 | - $post_title = basename($file_info['name'], '.' . $file_info['extension']); |
|
| 5861 | + $post_title = basename($file_info['name'], '.'.$file_info['extension']); |
|
| 5862 | 5862 | $post_title = isBase64($post_title) === true ? |
| 5863 | 5863 | base64_decode($post_title) : $post_title; |
| 5864 | 5864 | $image_code = $file_info['file']; |
@@ -5876,7 +5876,7 @@ discard block |
||
| 5876 | 5876 | $SETTINGS['cpassman_dir'], |
| 5877 | 5877 | array( |
| 5878 | 5878 | 'error' => false, |
| 5879 | - 'filename' => $post_title . '.' . $file_info['extension'], |
|
| 5879 | + 'filename' => $post_title.'.'.$file_info['extension'], |
|
| 5880 | 5880 | 'file_type' => $file_info['type'], |
| 5881 | 5881 | 'file_content' => $fileContent, |
| 5882 | 5882 | ), |
@@ -5930,16 +5930,16 @@ discard block |
||
| 5930 | 5930 | $idFolder = $dataReceived['idFolder']; |
| 5931 | 5931 | |
| 5932 | 5932 | // don't check if Personal Folder |
| 5933 | - $data = DB::queryFirstRow('SELECT title FROM ' . prefixTable('nested_tree') . ' WHERE id = %i', $idFolder); |
|
| 5933 | + $data = DB::queryFirstRow('SELECT title FROM '.prefixTable('nested_tree').' WHERE id = %i', $idFolder); |
|
| 5934 | 5934 | if ($data['title'] === $_SESSION['user_id']) { |
| 5935 | 5935 | // send data |
| 5936 | - echo '[{"duplicate" : "' . $duplicate . '" , error" : ""}]'; |
|
| 5936 | + echo '[{"duplicate" : "'.$duplicate.'" , error" : ""}]'; |
|
| 5937 | 5937 | } else { |
| 5938 | 5938 | if ($inputData['option'] === 'same_folder') { |
| 5939 | 5939 | // case unique folder |
| 5940 | 5940 | DB::query( |
| 5941 | 5941 | 'SELECT label |
| 5942 | - FROM ' . prefixTable('items') . ' |
|
| 5942 | + FROM ' . prefixTable('items').' |
|
| 5943 | 5943 | WHERE id_tree = %i AND label = %s', |
| 5944 | 5944 | $idFolder, |
| 5945 | 5945 | $label |
@@ -5951,7 +5951,7 @@ discard block |
||
| 5951 | 5951 | $arrayPf = array(); |
| 5952 | 5952 | if (empty($row['id']) === false) { |
| 5953 | 5953 | $rows = DB::query( |
| 5954 | - 'SELECT id FROM ' . prefixTable('nested_tree') . ' WHERE personal_folder = %i', |
|
| 5954 | + 'SELECT id FROM '.prefixTable('nested_tree').' WHERE personal_folder = %i', |
|
| 5955 | 5955 | '1' |
| 5956 | 5956 | ); |
| 5957 | 5957 | foreach ($rows as $record) { |
@@ -5966,12 +5966,12 @@ discard block |
||
| 5966 | 5966 | $where->add('id_tree = %i', $idFolder); |
| 5967 | 5967 | $where->add('label = %s', $label); |
| 5968 | 5968 | if (empty($arrayPf) === false) { |
| 5969 | - $where->add('id_tree NOT IN (' . implode(',', $arrayPf) . ')'); |
|
| 5969 | + $where->add('id_tree NOT IN ('.implode(',', $arrayPf).')'); |
|
| 5970 | 5970 | } |
| 5971 | 5971 | |
| 5972 | 5972 | DB::query( |
| 5973 | 5973 | 'SELECT label |
| 5974 | - FROM ' . prefixTable('items') . ' |
|
| 5974 | + FROM ' . prefixTable('items').' |
|
| 5975 | 5975 | WHERE %l', |
| 5976 | 5976 | $where |
| 5977 | 5977 | ); |
@@ -5983,7 +5983,7 @@ discard block |
||
| 5983 | 5983 | } |
| 5984 | 5984 | |
| 5985 | 5985 | // send data |
| 5986 | - echo '[{"duplicate" : "' . $duplicate . '" , "error" : ""}]'; |
|
| 5986 | + echo '[{"duplicate" : "'.$duplicate.'" , "error" : ""}]'; |
|
| 5987 | 5987 | } |
| 5988 | 5988 | break; |
| 5989 | 5989 | |
@@ -6028,7 +6028,7 @@ discard block |
||
| 6028 | 6028 | if (isset($dataReceived['force_refresh_cache']) === true && $dataReceived['force_refresh_cache'] === false) { |
| 6029 | 6029 | $goCachedFolders = loadFoldersListByCache('visible_folders', 'folders'); |
| 6030 | 6030 | if ($goCachedFolders['state'] === true) { |
| 6031 | - $arr_data['folders'] = json_decode($goCachedFolders['data'], true);//print_r($arr_data); |
|
| 6031 | + $arr_data['folders'] = json_decode($goCachedFolders['data'], true); //print_r($arr_data); |
|
| 6032 | 6032 | // send data |
| 6033 | 6033 | echo (string) prepareExchangedData( |
| 6034 | 6034 | $SETTINGS['cpassman_dir'], |
@@ -6065,7 +6065,7 @@ discard block |
||
| 6065 | 6065 | } |
| 6066 | 6066 | |
| 6067 | 6067 | //Build tree |
| 6068 | - require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Tree/NestedTree/NestedTree.php'; |
|
| 6068 | + require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Tree/NestedTree/NestedTree.php'; |
|
| 6069 | 6069 | $tree = new Tree\NestedTree\NestedTree(prefixTable('nested_tree'), 'id', 'parent_id', 'title'); |
| 6070 | 6070 | $tree->rebuild(); |
| 6071 | 6071 | $folders = $tree->getDescendants(); |
@@ -6115,7 +6115,7 @@ discard block |
||
| 6115 | 6115 | if (empty($arr_data['folders'][$inc]['path']) === true) { |
| 6116 | 6116 | $arr_data['folders'][$inc]['path'] = htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES); |
| 6117 | 6117 | } else { |
| 6118 | - $arr_data['folders'][$inc]['path'] .= ' / ' . htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES); |
|
| 6118 | + $arr_data['folders'][$inc]['path'] .= ' / '.htmlspecialchars(stripslashes(htmlspecialchars_decode($elem->title, ENT_QUOTES)), ENT_QUOTES); |
|
| 6119 | 6119 | } |
| 6120 | 6120 | } |
| 6121 | 6121 | |
@@ -6197,7 +6197,7 @@ discard block |
||
| 6197 | 6197 | if (is_array($foldersArray) === true && $inputData['data'] !== '[null]') { |
| 6198 | 6198 | $rows = DB::query( |
| 6199 | 6199 | 'SELECT id, categories |
| 6200 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 6200 | + FROM ' . prefixTable('nested_tree').' |
|
| 6201 | 6201 | WHERE id IN (%l)', |
| 6202 | 6202 | implode(',', $foldersArray) |
| 6203 | 6203 | ); |
@@ -6241,7 +6241,7 @@ discard block |
||
| 6241 | 6241 | // get item info |
| 6242 | 6242 | $dataItem = DB::queryFirstRow( |
| 6243 | 6243 | 'SELECT * |
| 6244 | - FROM ' . prefixTable('items') . ' |
|
| 6244 | + FROM ' . prefixTable('items').' |
|
| 6245 | 6245 | WHERE id=%i', |
| 6246 | 6246 | $inputData['itemId'] |
| 6247 | 6247 | ); |
@@ -6251,8 +6251,8 @@ discard block |
||
| 6251 | 6251 | $rows = DB::query( |
| 6252 | 6252 | 'SELECT l.date as date, l.action as action, l.raison as raison, |
| 6253 | 6253 | u.login as login, u.avatar_thumb as avatar_thumb, u.name as name, u.lastname as lastname |
| 6254 | - FROM ' . prefixTable('log_items') . ' as l |
|
| 6255 | - LEFT JOIN ' . prefixTable('users') . ' as u ON (l.id_user=u.id) |
|
| 6254 | + FROM ' . prefixTable('log_items').' as l |
|
| 6255 | + LEFT JOIN ' . prefixTable('users').' as u ON (l.id_user=u.id) |
|
| 6256 | 6256 | WHERE id_item=%i AND l.action NOT IN (%l) |
| 6257 | 6257 | ORDER BY date DESC', |
| 6258 | 6258 | $inputData['itemId'], |
@@ -6267,18 +6267,18 @@ discard block |
||
| 6267 | 6267 | |
| 6268 | 6268 | // imported via API |
| 6269 | 6269 | if (empty($record['login']) === true) { |
| 6270 | - $record['login'] = langHdl('imported_via_api') . ' [' . $record['raison'] . ']'; |
|
| 6270 | + $record['login'] = langHdl('imported_via_api').' ['.$record['raison'].']'; |
|
| 6271 | 6271 | } |
| 6272 | 6272 | |
| 6273 | 6273 | // Prepare avatar |
| 6274 | 6274 | if (isset($record['avatar_thumb']) && empty($record['avatar_thumb']) === false) { |
| 6275 | - if (file_exists($SETTINGS['cpassman_dir'] . '/includes/avatars/' . $record['avatar_thumb'])) { |
|
| 6276 | - $avatar = $SETTINGS['cpassman_url'] . '/includes/avatars/' . $record['avatar_thumb']; |
|
| 6275 | + if (file_exists($SETTINGS['cpassman_dir'].'/includes/avatars/'.$record['avatar_thumb'])) { |
|
| 6276 | + $avatar = $SETTINGS['cpassman_url'].'/includes/avatars/'.$record['avatar_thumb']; |
|
| 6277 | 6277 | } else { |
| 6278 | - $avatar = $SETTINGS['cpassman_url'] . '/includes/images/photo.jpg'; |
|
| 6278 | + $avatar = $SETTINGS['cpassman_url'].'/includes/images/photo.jpg'; |
|
| 6279 | 6279 | } |
| 6280 | 6280 | } else { |
| 6281 | - $avatar = $SETTINGS['cpassman_url'] . '/includes/images/photo.jpg'; |
|
| 6281 | + $avatar = $SETTINGS['cpassman_url'].'/includes/images/photo.jpg'; |
|
| 6282 | 6282 | } |
| 6283 | 6283 | |
| 6284 | 6284 | // Prepare action |
@@ -6295,19 +6295,19 @@ discard block |
||
| 6295 | 6295 | $action = langHdl($reason[0]); |
| 6296 | 6296 | if ($reason[0] === 'at_moved') { |
| 6297 | 6297 | $tmp = explode(' -> ', $reason[1]); |
| 6298 | - $detail = langHdl('from') . ' <span class="font-weight-light">' . $tmp[0] . '</span> ' . langHdl('to') . ' <span class="font-weight-light">' . $tmp[1] . ' </span>'; |
|
| 6298 | + $detail = langHdl('from').' <span class="font-weight-light">'.$tmp[0].'</span> '.langHdl('to').' <span class="font-weight-light">'.$tmp[1].' </span>'; |
|
| 6299 | 6299 | } elseif ($reason[0] === 'at_field') { |
| 6300 | 6300 | $tmp = explode(' => ', $reason[1]); |
| 6301 | 6301 | if (count($tmp) > 1) { |
| 6302 | - $detail = '<b>' . trim($tmp[0]) . '</b> | ' . langHdl('previous_value') . |
|
| 6303 | - ': <span class="font-weight-light">' . trim($tmp[1]) . '</span>'; |
|
| 6302 | + $detail = '<b>'.trim($tmp[0]).'</b> | '.langHdl('previous_value'). |
|
| 6303 | + ': <span class="font-weight-light">'.trim($tmp[1]).'</span>'; |
|
| 6304 | 6304 | } else { |
| 6305 | 6305 | $detail = trim($reason[1]); |
| 6306 | 6306 | } |
| 6307 | 6307 | } elseif (in_array($reason[0], array('at_restriction', 'at_email', 'at_login', 'at_label', 'at_url', 'at_tag')) === true) { |
| 6308 | 6308 | $tmp = explode(' => ', $reason[1]); |
| 6309 | 6309 | $detail = empty(trim($tmp[0])) === true ? |
| 6310 | - langHdl('no_previous_value') : langHdl('previous_value') . ': <span class="font-weight-light">' . $tmp[0] . ' </span>'; |
|
| 6310 | + langHdl('no_previous_value') : langHdl('previous_value').': <span class="font-weight-light">'.$tmp[0].' </span>'; |
|
| 6311 | 6311 | } elseif ($reason[0] === 'at_automatic_del') { |
| 6312 | 6312 | $detail = langHdl($reason[1]); |
| 6313 | 6313 | } elseif ($reason[0] === 'at_anyoneconmodify') { |
@@ -6316,7 +6316,7 @@ discard block |
||
| 6316 | 6316 | $tmp = explode(':', $reason[1]); |
| 6317 | 6317 | $tmp = explode('.', $tmp[0]); |
| 6318 | 6318 | $detail = isBase64($tmp[0]) === true ? |
| 6319 | - base64_decode($tmp[0]) . '.' . $tmp[1] : $tmp[0]; |
|
| 6319 | + base64_decode($tmp[0]).'.'.$tmp[1] : $tmp[0]; |
|
| 6320 | 6320 | } elseif ($reason[0] === 'at_import') { |
| 6321 | 6321 | $detail = ''; |
| 6322 | 6322 | } elseif (in_array($reason[0], array('csv', 'pdf')) === true) { |
@@ -6335,8 +6335,8 @@ discard block |
||
| 6335 | 6335 | array( |
| 6336 | 6336 | 'avatar' => $avatar, |
| 6337 | 6337 | 'login' => $record['login'], |
| 6338 | - 'name' => $record['name'] . ' ' . $record['lastname'], |
|
| 6339 | - 'date' => date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['date']), |
|
| 6338 | + 'name' => $record['name'].' '.$record['lastname'], |
|
| 6339 | + 'date' => date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['date']), |
|
| 6340 | 6340 | 'action' => $action, |
| 6341 | 6341 | 'detail' => $detail, |
| 6342 | 6342 | ) |
@@ -6423,18 +6423,18 @@ discard block |
||
| 6423 | 6423 | |
| 6424 | 6424 | // get some info to add to the notification email |
| 6425 | 6425 | $resp_user = DB::queryfirstrow( |
| 6426 | - 'SELECT login FROM ' . prefixTable('users') . ' WHERE id = %i', |
|
| 6426 | + 'SELECT login FROM '.prefixTable('users').' WHERE id = %i', |
|
| 6427 | 6427 | $_SESSION['user_id'] |
| 6428 | 6428 | ); |
| 6429 | 6429 | $resp_folder = DB::queryfirstrow( |
| 6430 | - 'SELECT title FROM ' . prefixTable('nested_tree') . ' WHERE id = %i', |
|
| 6430 | + 'SELECT title FROM '.prefixTable('nested_tree').' WHERE id = %i', |
|
| 6431 | 6431 | $folder |
| 6432 | 6432 | ); |
| 6433 | 6433 | |
| 6434 | 6434 | // notify Managers |
| 6435 | 6435 | $rows = DB::query( |
| 6436 | 6436 | 'SELECT email |
| 6437 | - FROM ' . prefixTable('users') . ' |
|
| 6437 | + FROM ' . prefixTable('users').' |
|
| 6438 | 6438 | WHERE `gestionnaire` = %i AND `email` IS NOT NULL', |
| 6439 | 6439 | 1 |
| 6440 | 6440 | ); |
@@ -6466,14 +6466,14 @@ discard block |
||
| 6466 | 6466 | // Get list of users |
| 6467 | 6467 | $usersList = array(); |
| 6468 | 6468 | $usersString = ''; |
| 6469 | - $rows = DB::query('SELECT id,login,email FROM ' . prefixTable('users') . ' ORDER BY login ASC'); |
|
| 6469 | + $rows = DB::query('SELECT id,login,email FROM '.prefixTable('users').' ORDER BY login ASC'); |
|
| 6470 | 6470 | foreach ($rows as $record) { |
| 6471 | 6471 | $usersList[$record['login']] = array( |
| 6472 | 6472 | 'id' => $record['id'], |
| 6473 | 6473 | 'login' => $record['login'], |
| 6474 | 6474 | 'email' => $record['email'], |
| 6475 | 6475 | ); |
| 6476 | - $usersString .= $record['id'] . '#' . $record['login'] . ';'; |
|
| 6476 | + $usersString .= $record['id'].'#'.$record['login'].';'; |
|
| 6477 | 6477 | } |
| 6478 | 6478 | |
| 6479 | 6479 | $data = array( |
@@ -6516,7 +6516,7 @@ discard block |
||
| 6516 | 6516 | // Send email |
| 6517 | 6517 | $dataItem = DB::queryfirstrow( |
| 6518 | 6518 | 'SELECT label, id_tree |
| 6519 | - FROM ' . prefixTable('items') . ' |
|
| 6519 | + FROM ' . prefixTable('items').' |
|
| 6520 | 6520 | WHERE id = %i', |
| 6521 | 6521 | $inputData['itemId'] |
| 6522 | 6522 | ); |
@@ -6616,7 +6616,7 @@ discard block |
||
| 6616 | 6616 | |
| 6617 | 6617 | DB::query( |
| 6618 | 6618 | 'SELECT * |
| 6619 | - FROM ' . prefixTable('notification') . ' |
|
| 6619 | + FROM ' . prefixTable('notification').' |
|
| 6620 | 6620 | WHERE item_id = %i AND user_id = %i', |
| 6621 | 6621 | $inputData['itemId'], |
| 6622 | 6622 | $_SESSION['user_id'] |
@@ -6691,7 +6691,7 @@ discard block |
||
| 6691 | 6691 | // And related logs |
| 6692 | 6692 | $rows = DB::query( |
| 6693 | 6693 | 'SELECT id, file AS filename |
| 6694 | - FROM ' . prefixTable('files') . ' |
|
| 6694 | + FROM ' . prefixTable('files').' |
|
| 6695 | 6695 | WHERE id_item = %i AND confirmed = %i', |
| 6696 | 6696 | $inputData['itemId'], |
| 6697 | 6697 | 0 |
@@ -6705,12 +6705,12 @@ discard block |
||
| 6705 | 6705 | ); |
| 6706 | 6706 | |
| 6707 | 6707 | // Delete file on server |
| 6708 | - unlink($SETTINGS['path_to_upload_folder'] . '/' . TP_FILE_PREFIX . base64_decode($file['filename'])); |
|
| 6708 | + unlink($SETTINGS['path_to_upload_folder'].'/'.TP_FILE_PREFIX.base64_decode($file['filename'])); |
|
| 6709 | 6709 | |
| 6710 | 6710 | // Delete related logs |
| 6711 | 6711 | $logFile = DB::query( |
| 6712 | 6712 | 'SELECT increment_id, raison |
| 6713 | - FROM ' . prefixTable('log_items') . ' |
|
| 6713 | + FROM ' . prefixTable('log_items').' |
|
| 6714 | 6714 | WHERE id_item = %i AND id_user = %i AND action = %s AND raison LIKE "at_add_file :%"', |
| 6715 | 6715 | $inputData['itemId'], |
| 6716 | 6716 | $_SESSION['user_id'], |
@@ -6772,7 +6772,7 @@ discard block |
||
| 6772 | 6772 | // Confirm attachments |
| 6773 | 6773 | $rows = DB::query( |
| 6774 | 6774 | 'SELECT id, file AS filename |
| 6775 | - FROM ' . prefixTable('files') . ' |
|
| 6775 | + FROM ' . prefixTable('files').' |
|
| 6776 | 6776 | WHERE id_item = %i AND confirmed = %i', |
| 6777 | 6777 | $inputData['itemId'], |
| 6778 | 6778 | 0 |
@@ -6833,7 +6833,7 @@ discard block |
||
| 6833 | 6833 | |
| 6834 | 6834 | $data = DB::queryFirstRow( |
| 6835 | 6835 | 'SELECT visible_folders |
| 6836 | - FROM ' . prefixTable('cache_tree') . ' WHERE user_id = %i', |
|
| 6836 | + FROM ' . prefixTable('cache_tree').' WHERE user_id = %i', |
|
| 6837 | 6837 | $inputData['userId'] |
| 6838 | 6838 | ); |
| 6839 | 6839 | // Check if tree ID is in visible folders. |
@@ -6868,15 +6868,15 @@ discard block |
||
| 6868 | 6868 | case 'autocomplete_tags': |
| 6869 | 6869 | // Get a list off all existing TAGS |
| 6870 | 6870 | $listOfTags = ''; |
| 6871 | - $rows = DB::query('SELECT tag FROM ' . prefixTable('tags') . ' WHERE tag LIKE %ss GROUP BY tag', $inputData['getTerm']); |
|
| 6871 | + $rows = DB::query('SELECT tag FROM '.prefixTable('tags').' WHERE tag LIKE %ss GROUP BY tag', $inputData['getTerm']); |
|
| 6872 | 6872 | foreach ($rows as $record) { |
| 6873 | 6873 | if (empty($listOfTags)) { |
| 6874 | - $listOfTags = '"' . $record['tag'] . '"'; |
|
| 6874 | + $listOfTags = '"'.$record['tag'].'"'; |
|
| 6875 | 6875 | } else { |
| 6876 | - $listOfTags .= ', "' . $record['tag'] . '"'; |
|
| 6876 | + $listOfTags .= ', "'.$record['tag'].'"'; |
|
| 6877 | 6877 | } |
| 6878 | 6878 | } |
| 6879 | - echo '[' . $listOfTags . ']'; |
|
| 6879 | + echo '['.$listOfTags.']'; |
|
| 6880 | 6880 | break; |
| 6881 | 6881 | } |
| 6882 | 6882 | } |
@@ -6892,7 +6892,7 @@ discard block |
||
| 6892 | 6892 | { |
| 6893 | 6893 | $data = DB::queryFirstRow( |
| 6894 | 6894 | 'SELECT bloquer_creation, bloquer_modification, personal_folder |
| 6895 | - FROM ' . prefixTable('nested_tree') . ' WHERE id = %i', |
|
| 6895 | + FROM ' . prefixTable('nested_tree').' WHERE id = %i', |
|
| 6896 | 6896 | $groupe |
| 6897 | 6897 | ); |
| 6898 | 6898 | // Check if it's in a personal folder. If yes, then force complexity overhead. |
