nilsteampassnet /
TeamPass
@@ -54,12 +54,12 @@ discard block |
||
| 54 | 54 | && filter_input(INPUT_POST, 'session', FILTER_SANITIZE_STRING) === 'expired' |
| 55 | 55 | ) { |
| 56 | 56 | //Include files |
| 57 | - require_once $SETTINGS['cpassman_dir'] . '/includes/config/settings.php'; |
|
| 58 | - require_once $SETTINGS['cpassman_dir'] . '/includes/config/include.php'; |
|
| 59 | - require_once $SETTINGS['cpassman_dir'] . '/sources/SplClassLoader.php'; |
|
| 60 | - require_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php'; |
|
| 57 | + require_once $SETTINGS['cpassman_dir'].'/includes/config/settings.php'; |
|
| 58 | + require_once $SETTINGS['cpassman_dir'].'/includes/config/include.php'; |
|
| 59 | + require_once $SETTINGS['cpassman_dir'].'/sources/SplClassLoader.php'; |
|
| 60 | + require_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php'; |
|
| 61 | 61 | // connect to DB |
| 62 | - require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Database/Meekrodb/db.class.php'; |
|
| 62 | + require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Database/Meekrodb/db.class.php'; |
|
| 63 | 63 | if (defined('DB_PASSWD_CLEAR') === false) { |
| 64 | 64 | define('DB_PASSWD_CLEAR', defuseReturnDecrypted(DB_PASSWD, $SETTINGS)); |
| 65 | 65 | } |
@@ -69,7 +69,7 @@ discard block |
||
| 69 | 69 | // Update table by deleting ID |
| 70 | 70 | if (isset($_SESSION['user_id'])) { |
| 71 | 71 | DB::update( |
| 72 | - DB_PREFIX . 'users', |
|
| 72 | + DB_PREFIX.'users', |
|
| 73 | 73 | [ |
| 74 | 74 | 'key_tempo' => '', |
| 75 | 75 | ], |
@@ -83,7 +83,7 @@ discard block |
||
| 83 | 83 | logEvents($SETTINGS, 'user_connection', 'disconnection', (string) $_SESSION['user_id'], $_SESSION['login']); |
| 84 | 84 | } |
| 85 | 85 | } else { |
| 86 | - require_once $SETTINGS['cpassman_dir'] . '/sources/main.queries.php'; |
|
| 86 | + require_once $SETTINGS['cpassman_dir'].'/sources/main.queries.php'; |
|
| 87 | 87 | $errorCode = ''; |
| 88 | 88 | if (@$_SESSION['error']['code'] === ERR_NOT_ALLOWED) { |
| 89 | 89 | $errorCode = 'ERROR NOT ALLOWED'; |
@@ -43,15 +43,15 @@ discard block |
||
| 43 | 43 | } |
| 44 | 44 | |
| 45 | 45 | /* do checks */ |
| 46 | -require_once $SETTINGS['cpassman_dir'] . '/sources/checks.php'; |
|
| 46 | +require_once $SETTINGS['cpassman_dir'].'/sources/checks.php'; |
|
| 47 | 47 | if (checkUser($_SESSION['user_id'], $_SESSION['key'], 'roles', $SETTINGS) === false) { |
| 48 | 48 | $_SESSION['error']['code'] = ERR_NOT_ALLOWED; |
| 49 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
| 49 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
| 50 | 50 | exit; |
| 51 | 51 | } |
| 52 | 52 | |
| 53 | 53 | // Load template |
| 54 | -require_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php'; |
|
| 54 | +require_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php'; |
|
| 55 | 55 | |
| 56 | 56 | ?> |
| 57 | 57 | |
@@ -94,17 +94,17 @@ discard block |
||
| 94 | 94 | $arrUserRoles = array_filter($_SESSION['user_roles']); |
| 95 | 95 | $where = ''; |
| 96 | 96 | if (count($arrUserRoles) > 0 && (int) $_SESSION['is_admin'] !== 1) { |
| 97 | - $where = ' WHERE id IN (' . implode(',', $arrUserRoles) . ')'; |
|
| 97 | + $where = ' WHERE id IN ('.implode(',', $arrUserRoles).')'; |
|
| 98 | 98 | } |
| 99 | - $rows = DB::query('SELECT * FROM ' . prefixTable('roles_title') . $where); |
|
| 99 | + $rows = DB::query('SELECT * FROM '.prefixTable('roles_title').$where); |
|
| 100 | 100 | foreach ($rows as $reccord) { |
| 101 | 101 | echo ' |
| 102 | - <option value="' . $reccord['id'] . '" |
|
| 103 | - data-complexity-text="' . addslashes(TP_PW_COMPLEXITY[$reccord['complexity']][1]) . '" |
|
| 104 | - data-complexity-icon="' . TP_PW_COMPLEXITY[$reccord['complexity']][2] . '" |
|
| 105 | - data-complexity="' . TP_PW_COMPLEXITY[$reccord['complexity']][0] . '" |
|
| 106 | - data-allow-edit-all="' . $reccord['allow_pw_change'] . '">'. |
|
| 107 | - $reccord['title'] . '</option>'; |
|
| 102 | + <option value="' . $reccord['id'].'" |
|
| 103 | + data-complexity-text="' . addslashes(TP_PW_COMPLEXITY[$reccord['complexity']][1]).'" |
|
| 104 | + data-complexity-icon="' . TP_PW_COMPLEXITY[$reccord['complexity']][2].'" |
|
| 105 | + data-complexity="' . TP_PW_COMPLEXITY[$reccord['complexity']][0].'" |
|
| 106 | + data-allow-edit-all="' . $reccord['allow_pw_change'].'">'. |
|
| 107 | + $reccord['title'].'</option>'; |
|
| 108 | 108 | } |
| 109 | 109 | ?> |
| 110 | 110 | </select> |
@@ -125,7 +125,7 @@ discard block |
||
| 125 | 125 | <?php |
| 126 | 126 | foreach (TP_PW_COMPLEXITY as $entry) { |
| 127 | 127 | echo ' |
| 128 | - <option value="' . $entry[0] . '">' . addslashes($entry[1]) . '</option>'; |
|
| 128 | + <option value="' . $entry[0].'">'.addslashes($entry[1]).'</option>'; |
|
| 129 | 129 | } |
| 130 | 130 | ?> |
| 131 | 131 | </select> |
@@ -43,11 +43,11 @@ |
||
| 43 | 43 | } |
| 44 | 44 | echo "ici"; |
| 45 | 45 | /* do checks */ |
| 46 | -require_once $SETTINGS['cpassman_dir'] . '/sources/checks.php'; |
|
| 46 | +require_once $SETTINGS['cpassman_dir'].'/sources/checks.php'; |
|
| 47 | 47 | if (checkUser($_SESSION['user_id'], $_SESSION['key'], '2fa', $SETTINGS) === false) { |
| 48 | 48 | $_SESSION['error']['code'] = ERR_NOT_ALLOWED; |
| 49 | 49 | //not allowed page |
| 50 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
| 50 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
| 51 | 51 | exit; |
| 52 | 52 | } |
| 53 | 53 | ?> |
@@ -43,15 +43,15 @@ discard block |
||
| 43 | 43 | } |
| 44 | 44 | |
| 45 | 45 | /* do checks */ |
| 46 | -require_once $SETTINGS['cpassman_dir'] . '/sources/checks.php'; |
|
| 46 | +require_once $SETTINGS['cpassman_dir'].'/sources/checks.php'; |
|
| 47 | 47 | if (checkUser($_SESSION['user_id'], $_SESSION['key'], '2fa', $SETTINGS) === false) { |
| 48 | 48 | $_SESSION['error']['code'] = ERR_NOT_ALLOWED; |
| 49 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
| 49 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
| 50 | 50 | exit; |
| 51 | 51 | } |
| 52 | 52 | |
| 53 | 53 | // Load template |
| 54 | -require_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php'; |
|
| 54 | +require_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php'; |
|
| 55 | 55 | |
| 56 | 56 | ?> |
| 57 | 57 | |
@@ -115,7 +115,7 @@ discard block |
||
| 115 | 115 | ); |
| 116 | 116 | foreach ($roles as $role) { |
| 117 | 117 | echo ' |
| 118 | - <option value="' . $role['id'] . '"', in_array($role['id'], $arrRolesMFA) === true ? ' selected' : '', '>' . addslashes($role['title']) . '</option>'; |
|
| 118 | + <option value="' . $role['id'].'"', in_array($role['id'], $arrRolesMFA) === true ? ' selected' : '', '>'.addslashes($role['title']).'</option>'; |
|
| 119 | 119 | } |
| 120 | 120 | ?> |
| 121 | 121 | </select> |
@@ -43,15 +43,15 @@ discard block |
||
| 43 | 43 | } |
| 44 | 44 | |
| 45 | 45 | /* do checks */ |
| 46 | -require_once $SETTINGS['cpassman_dir'] . '/sources/checks.php'; |
|
| 46 | +require_once $SETTINGS['cpassman_dir'].'/sources/checks.php'; |
|
| 47 | 47 | if (checkUser($_SESSION['user_id'], $_SESSION['key'], 'ldap', $SETTINGS) === false) { |
| 48 | 48 | $_SESSION['error']['code'] = ERR_NOT_ALLOWED; |
| 49 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
| 49 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
| 50 | 50 | exit; |
| 51 | 51 | } |
| 52 | 52 | |
| 53 | 53 | // Load template |
| 54 | -require_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php'; |
|
| 54 | +require_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php'; |
|
| 55 | 55 | |
| 56 | 56 | ?> |
| 57 | 57 | |
@@ -90,14 +90,14 @@ discard block |
||
| 90 | 90 | <?php |
| 91 | 91 | echo langHdl('rebuild_config_file'); |
| 92 | 92 | $data = DB::queryfirstrow( |
| 93 | - 'SELECT field_1, date FROM ' . prefixTable('log_system') . ' |
|
| 93 | + 'SELECT field_1, date FROM '.prefixTable('log_system').' |
|
| 94 | 94 | WHERE label = %s |
| 95 | 95 | ORDER BY id DESC', |
| 96 | 96 | 'admin_action_rebuild_config_file' |
| 97 | 97 | ); |
| 98 | 98 | if (DB::count() > 0) { |
| 99 | - $tmp = langHdl('last_execution') . ' ' . |
|
| 100 | - date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $data['date']); |
|
| 99 | + $tmp = langHdl('last_execution').' '. |
|
| 100 | + date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $data['date']); |
|
| 101 | 101 | $tmp .= $data['field_1'] === 'success' ? |
| 102 | 102 | '<i class="fas fa-check ml-2 text-success"></i>' : '<i class="fas fa-times ml-2 text-danger"></i>'; |
| 103 | 103 | } else { |
@@ -119,14 +119,14 @@ discard block |
||
| 119 | 119 | </span> |
| 120 | 120 | <?php echo langHdl('admin_action_check_pf'); |
| 121 | 121 | $data = DB::queryfirstrow( |
| 122 | - 'SELECT field_1, date FROM ' . prefixTable('log_system') . ' |
|
| 122 | + 'SELECT field_1, date FROM '.prefixTable('log_system').' |
|
| 123 | 123 | WHERE label = %s |
| 124 | 124 | ORDER BY id DESC', |
| 125 | 125 | 'admin_action_check_pf' |
| 126 | 126 | ); |
| 127 | 127 | if (DB::count() > 0) { |
| 128 | - $tmp = langHdl('last_execution') . ' ' . |
|
| 129 | - date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $data['date']); |
|
| 128 | + $tmp = langHdl('last_execution').' '. |
|
| 129 | + date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $data['date']); |
|
| 130 | 130 | $tmp .= $data['field_1'] === 'success' ? |
| 131 | 131 | '<i class="fas fa-check ml-2 text-success"></i>' : '<i class="fas fa-times ml-2 text-danger"></i>'; |
| 132 | 132 | } else { |
@@ -146,14 +146,14 @@ discard block |
||
| 146 | 146 | </span> |
| 147 | 147 | <?php echo langHdl('admin_action_db_clean_items'); |
| 148 | 148 | $data = DB::queryfirstrow( |
| 149 | - 'SELECT field_1, date FROM ' . prefixTable('log_system') . ' |
|
| 149 | + 'SELECT field_1, date FROM '.prefixTable('log_system').' |
|
| 150 | 150 | WHERE label = %s |
| 151 | 151 | ORDER BY id DESC', |
| 152 | 152 | 'admin_action_db_clean_items' |
| 153 | 153 | ); |
| 154 | 154 | if (DB::count() > 0) { |
| 155 | - $tmp = langHdl('last_execution') . ' ' . |
|
| 156 | - date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $data['date']); |
|
| 155 | + $tmp = langHdl('last_execution').' '. |
|
| 156 | + date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $data['date']); |
|
| 157 | 157 | $tmp .= $data['field_1'] === 'success' ? |
| 158 | 158 | '<i class="fas fa-check ml-2 text-success"></i>' : '<i class="fas fa-times ml-2 text-danger"></i>'; |
| 159 | 159 | } else { |
@@ -175,14 +175,14 @@ discard block |
||
| 175 | 175 | </span> |
| 176 | 176 | <?php echo langHdl('admin_action_db_optimize'); |
| 177 | 177 | $data = DB::queryfirstrow( |
| 178 | - 'SELECT field_1, date FROM ' . prefixTable('log_system') . ' |
|
| 178 | + 'SELECT field_1, date FROM '.prefixTable('log_system').' |
|
| 179 | 179 | WHERE label = %s |
| 180 | 180 | ORDER BY id DESC', |
| 181 | 181 | 'admin_action_db_optimize' |
| 182 | 182 | ); |
| 183 | 183 | if (DB::count() > 0) { |
| 184 | - $tmp = langHdl('last_execution') . ' ' . |
|
| 185 | - date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $data['date']); |
|
| 184 | + $tmp = langHdl('last_execution').' '. |
|
| 185 | + date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $data['date']); |
|
| 186 | 186 | $tmp .= $data['field_1'] === 'success' ? |
| 187 | 187 | '<i class="fas fa-check ml-2 text-success"></i>' : '<i class="fas fa-times ml-2 text-danger"></i>'; |
| 188 | 188 | } else { |
@@ -201,14 +201,14 @@ discard block |
||
| 201 | 201 | </span> |
| 202 | 202 | <?php echo langHdl('admin_action_purge_old_files'); |
| 203 | 203 | $data = DB::queryfirstrow( |
| 204 | - 'SELECT field_1, date FROM ' . prefixTable('log_system') . ' |
|
| 204 | + 'SELECT field_1, date FROM '.prefixTable('log_system').' |
|
| 205 | 205 | WHERE label = %s |
| 206 | 206 | ORDER BY id DESC', |
| 207 | 207 | 'admin_action_purge_old_files' |
| 208 | 208 | ); |
| 209 | 209 | if (DB::count() > 0) { |
| 210 | - $tmp = langHdl('last_execution') . ' ' . |
|
| 211 | - date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $data['date']); |
|
| 210 | + $tmp = langHdl('last_execution').' '. |
|
| 211 | + date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $data['date']); |
|
| 212 | 212 | $tmp .= $data['field_1'] === 'success' ? |
| 213 | 213 | '<i class="fas fa-check ml-2 text-success"></i>' : '<i class="fas fa-times ml-2 text-danger"></i>'; |
| 214 | 214 | } else { |
@@ -230,14 +230,14 @@ discard block |
||
| 230 | 230 | </span> |
| 231 | 231 | <?php echo langHdl('admin_action_reload_cache_table'); |
| 232 | 232 | $data = DB::queryfirstrow( |
| 233 | - 'SELECT field_1, date FROM ' . prefixTable('log_system') . ' |
|
| 233 | + 'SELECT field_1, date FROM '.prefixTable('log_system').' |
|
| 234 | 234 | WHERE label = %s |
| 235 | 235 | ORDER BY id DESC', |
| 236 | 236 | 'admin_action_reload_cache_table' |
| 237 | 237 | ); |
| 238 | 238 | if (DB::count() > 0) { |
| 239 | - $tmp = langHdl('last_execution') . ' ' . |
|
| 240 | - date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $data['date']); |
|
| 239 | + $tmp = langHdl('last_execution').' '. |
|
| 240 | + date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $data['date']); |
|
| 241 | 241 | $tmp .= $data['field_1'] === 'success' ? |
| 242 | 242 | '<i class="fas fa-check ml-2 text-success"></i>' : '<i class="fas fa-times ml-2 text-danger"></i>'; |
| 243 | 243 | } else { |
@@ -260,14 +260,14 @@ discard block |
||
| 260 | 260 | </span> |
| 261 | 261 | <?php echo langHdl('admin_action_change_salt_key'); |
| 262 | 262 | $data = DB::queryfirstrow( |
| 263 | - 'SELECT field_1, date FROM ' . prefixTable('log_system') . ' |
|
| 263 | + 'SELECT field_1, date FROM '.prefixTable('log_system').' |
|
| 264 | 264 | WHERE label = %s |
| 265 | 265 | ORDER BY id DESC', |
| 266 | 266 | 'admin_action_change_sk' |
| 267 | 267 | ); |
| 268 | 268 | if (DB::count() > 0) { |
| 269 | - $tmp = langHdl('last_execution') . ' ' . |
|
| 270 | - date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $data['date']); |
|
| 269 | + $tmp = langHdl('last_execution').' '. |
|
| 270 | + date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $data['date']); |
|
| 271 | 271 | $tmp .= $data['field_1'] === 'success' ? |
| 272 | 272 | '<i class="fas fa-check ml-2 text-success"></i>' : '<i class="fas fa-times ml-2 text-danger"></i>'; |
| 273 | 273 | } else { |
@@ -290,14 +290,14 @@ discard block |
||
| 290 | 290 | </span> |
| 291 | 291 | <?php echo langHdl('admin_action_attachments_cryption'); |
| 292 | 292 | $data = DB::queryfirstrow( |
| 293 | - 'SELECT field_1, date FROM ' . prefixTable('log_system') . ' |
|
| 293 | + 'SELECT field_1, date FROM '.prefixTable('log_system').' |
|
| 294 | 294 | WHERE label = %s |
| 295 | 295 | ORDER BY id DESC', |
| 296 | 296 | 'admin_action_change_file_encryption' |
| 297 | 297 | ); |
| 298 | 298 | if (DB::count() > 0) { |
| 299 | - $tmp = langHdl('last_execution') . ' ' . |
|
| 300 | - date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $data['date']); |
|
| 299 | + $tmp = langHdl('last_execution').' '. |
|
| 300 | + date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $data['date']); |
|
| 301 | 301 | $tmp .= $data['field_1'] === 'success' ? |
| 302 | 302 | '<i class="fas fa-check ml-2 text-success"></i>' : '<i class="fas fa-times ml-2 text-danger"></i>'; |
| 303 | 303 | } else { |
@@ -43,16 +43,16 @@ discard block |
||
| 43 | 43 | } |
| 44 | 44 | |
| 45 | 45 | /* do checks */ |
| 46 | -require_once $SETTINGS['cpassman_dir'] . '/sources/checks.php'; |
|
| 46 | +require_once $SETTINGS['cpassman_dir'].'/sources/checks.php'; |
|
| 47 | 47 | if (checkUser($_SESSION['user_id'], $_SESSION['key'], curPage($SETTINGS), $SETTINGS) === false) { |
| 48 | 48 | $_SESSION['error']['code'] = ERR_NOT_ALLOWED; |
| 49 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
| 49 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
| 50 | 50 | exit; |
| 51 | 51 | } |
| 52 | 52 | |
| 53 | 53 | // Load template |
| 54 | -require_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php'; |
|
| 55 | -require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/protect/SuperGlobal/SuperGlobal.php'; |
|
| 54 | +require_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php'; |
|
| 55 | +require_once $SETTINGS['cpassman_dir'].'/includes/libraries/protect/SuperGlobal/SuperGlobal.php'; |
|
| 56 | 56 | $superGlobal = new protect\SuperGlobal\SuperGlobal(); |
| 57 | 57 | // Prepare GET variables |
| 58 | 58 | $get = []; |
@@ -73,25 +73,25 @@ discard block |
||
| 73 | 73 | // prepare list of timezones |
| 74 | 74 | $zones = timezone_list(); |
| 75 | 75 | // prepare list of languages |
| 76 | -$languages = DB::query('SELECT label FROM ' . prefixTable('languages') . ' ORDER BY label ASC'); |
|
| 76 | +$languages = DB::query('SELECT label FROM '.prefixTable('languages').' ORDER BY label ASC'); |
|
| 77 | 77 | // Do some stats |
| 78 | -DB::query('SELECT id_item FROM ' . prefixTable('log_items') . ' WHERE action = "at_creation" AND id_user = "' . $_SESSION['user_id'] . '"'); |
|
| 78 | +DB::query('SELECT id_item FROM '.prefixTable('log_items').' WHERE action = "at_creation" AND id_user = "'.$_SESSION['user_id'].'"'); |
|
| 79 | 79 | $userItemsNumber = DB::count(); |
| 80 | -DB::query('SELECT id_item FROM ' . prefixTable('log_items') . ' WHERE action = "at_modification" AND id_user = "' . $_SESSION['user_id'] . '"'); |
|
| 80 | +DB::query('SELECT id_item FROM '.prefixTable('log_items').' WHERE action = "at_modification" AND id_user = "'.$_SESSION['user_id'].'"'); |
|
| 81 | 81 | $userModificationNumber = DB::count(); |
| 82 | -DB::query('SELECT id_item FROM ' . prefixTable('log_items') . ' WHERE action = "at_shown" AND id_user = "' . $_SESSION['user_id'] . '"'); |
|
| 82 | +DB::query('SELECT id_item FROM '.prefixTable('log_items').' WHERE action = "at_shown" AND id_user = "'.$_SESSION['user_id'].'"'); |
|
| 83 | 83 | $userSeenItemsNumber = DB::count(); |
| 84 | -DB::query('SELECT id_item FROM ' . prefixTable('log_items') . ' WHERE action = "at_password_shown" AND id_user = "' . $_SESSION['user_id'] . '"'); |
|
| 84 | +DB::query('SELECT id_item FROM '.prefixTable('log_items').' WHERE action = "at_password_shown" AND id_user = "'.$_SESSION['user_id'].'"'); |
|
| 85 | 85 | $userSeenPasswordsNumber = DB::count(); |
| 86 | 86 | $userInfo = DB::queryFirstRow( |
| 87 | 87 | 'SELECT avatar |
| 88 | - FROM ' . prefixTable('users') . ' |
|
| 89 | - WHERE id = "' . $_SESSION['user_id'] . '"' |
|
| 88 | + FROM ' . prefixTable('users').' |
|
| 89 | + WHERE id = "' . $_SESSION['user_id'].'"' |
|
| 90 | 90 | ); |
| 91 | 91 | if (empty($userInfo['avatar']) === true) { |
| 92 | - $avatar = $SETTINGS['cpassman_url'] . '/includes/images/photo.jpg'; |
|
| 92 | + $avatar = $SETTINGS['cpassman_url'].'/includes/images/photo.jpg'; |
|
| 93 | 93 | } else { |
| 94 | - $avatar = $SETTINGS['cpassman_url'] . '/includes/avatars/' . $userInfo['avatar']; |
|
| 94 | + $avatar = $SETTINGS['cpassman_url'].'/includes/avatars/'.$userInfo['avatar']; |
|
| 95 | 95 | } |
| 96 | 96 | |
| 97 | 97 | // Get Groups name |
@@ -99,8 +99,8 @@ discard block |
||
| 99 | 99 | foreach ($_SESSION['user_roles'] as $role) { |
| 100 | 100 | $tmp = DB::queryFirstRow( |
| 101 | 101 | 'SELECT title |
| 102 | - FROM ' . prefixTable('roles_title') . ' |
|
| 103 | - WHERE id = "' . $role . '"' |
|
| 102 | + FROM ' . prefixTable('roles_title').' |
|
| 103 | + WHERE id = "' . $role.'"' |
|
| 104 | 104 | ); |
| 105 | 105 | if ($tmp !== null) { |
| 106 | 106 | array_push($userParOfGroups, $tmp['title']); |
@@ -144,7 +144,7 @@ discard block |
||
| 144 | 144 | <h3 id="profile-username" class="text-center"> |
| 145 | 145 | <?php |
| 146 | 146 | if (isset($_SESSION['name']) === true && empty($_SESSION['name']) === false) { |
| 147 | - echo $_SESSION['name'] . ' ' . $_SESSION['lastname']; |
|
| 147 | + echo $_SESSION['name'].' '.$_SESSION['lastname']; |
|
| 148 | 148 | } else { |
| 149 | 149 | echo $_SESSION['login']; |
| 150 | 150 | } |
@@ -211,7 +211,7 @@ discard block |
||
| 211 | 211 | } else { |
| 212 | 212 | echo date('d/m/Y', (int) $_SESSION['last_connection']); |
| 213 | 213 | } |
| 214 | - echo ' ' . langHdl('at') . ' '; |
|
| 214 | + echo ' '.langHdl('at').' '; |
|
| 215 | 215 | if (isset($SETTINGS['time_format']) === true) { |
| 216 | 216 | echo date($SETTINGS['time_format'], (int) $_SESSION['last_connection']); |
| 217 | 217 | } else { |
@@ -221,7 +221,7 @@ discard block |
||
| 221 | 221 | </a> |
| 222 | 222 | </li> |
| 223 | 223 | <?php |
| 224 | - if (isset($_SESSION['last_pw_change']) && ! empty($_SESSION['last_pw_change'])) { |
|
| 224 | + if (isset($_SESSION['last_pw_change']) && !empty($_SESSION['last_pw_change'])) { |
|
| 225 | 225 | // Handle last password change string |
| 226 | 226 | if (isset($_SESSION['last_pw_change']) === true) { |
| 227 | 227 | if (isset($SETTINGS['date_format']) === true) { |
@@ -241,12 +241,12 @@ discard block |
||
| 241 | 241 | ) { |
| 242 | 242 | $numDaysBeforePwExpiration = ''; |
| 243 | 243 | } else { |
| 244 | - $numDaysBeforePwExpiration = $LANG['index_pw_expiration'] . ' ' . $_SESSION['numDaysBeforePwExpiration'] . ' ' . $LANG['days'] . '.'; |
|
| 244 | + $numDaysBeforePwExpiration = $LANG['index_pw_expiration'].' '.$_SESSION['numDaysBeforePwExpiration'].' '.$LANG['days'].'.'; |
|
| 245 | 245 | } |
| 246 | 246 | echo ' |
| 247 | 247 | <li class="list-group-item"> |
| 248 | - <b><i class="fas fa-calendar-alt fa-fw fa-lg mr-2"></i>' . langHdl('index_last_pw_change') . '</b> |
|
| 249 | - <a class="float-right">' . $last_pw_change . ' ' . $numDaysBeforePwExpiration . '</a> |
|
| 248 | + <b><i class="fas fa-calendar-alt fa-fw fa-lg mr-2"></i>' . langHdl('index_last_pw_change').'</b> |
|
| 249 | + <a class="float-right">' . $last_pw_change.' '.$numDaysBeforePwExpiration.'</a> |
|
| 250 | 250 | </li>'; |
| 251 | 251 | } |
| 252 | 252 | ?> |
@@ -266,7 +266,7 @@ discard block |
||
| 266 | 266 | if (isset($SETTINGS['api']) === true && (int) $SETTINGS['api'] === 1) { |
| 267 | 267 | echo ' |
| 268 | 268 | <li class="list-group-item"> |
| 269 | - <b><i class="fas fa-paper-plane fa-fw fa-lg mr-2"></i>' . langHdl('user_profile_api_key') . '</b> |
|
| 269 | + <b><i class="fas fa-paper-plane fa-fw fa-lg mr-2"></i>' . langHdl('user_profile_api_key').'</b> |
|
| 270 | 270 | <a class="float-right" id="profile-user-api-token">', |
| 271 | 271 | isset($_SESSION['user']['api-key']) === true ? $_SESSION['user']['api-key'] : '', |
| 272 | 272 | '</a> |
@@ -278,7 +278,7 @@ discard block |
||
| 278 | 278 | ) { |
| 279 | 279 | echo ' |
| 280 | 280 | <li class="list-group-item"> |
| 281 | - <b><i class="fas fa-id-card-o fa-fw fa-lg mr-2"></i>' . langHdl('user_profile_agses_card_id') . '</b> |
|
| 281 | + <b><i class="fas fa-id-card-o fa-fw fa-lg mr-2"></i>' . langHdl('user_profile_agses_card_id').'</b> |
|
| 282 | 282 | <a class="float-right">', |
| 283 | 283 | $_SESSION['user']['agses-usercardid'] ?? '', |
| 284 | 284 | '</a> |
@@ -302,7 +302,7 @@ discard block |
||
| 302 | 302 | <ul class=""> |
| 303 | 303 | <?php |
| 304 | 304 | foreach ($_SESSION['user']['unsuccessfull_login_attempts_list'] as $entry) { |
| 305 | - echo '<li class="">' . $entry . '</li>'; |
|
| 305 | + echo '<li class="">'.$entry.'</li>'; |
|
| 306 | 306 | } ?> |
| 307 | 307 | </ul> |
| 308 | 308 | </div> |
@@ -315,12 +315,12 @@ discard block |
||
| 315 | 315 | <?php |
| 316 | 316 | $rows = DB::query( |
| 317 | 317 | 'SELECT label AS labelAction, date, null |
| 318 | - FROM ' . prefixTable('log_system') . ' |
|
| 318 | + FROM ' . prefixTable('log_system').' |
|
| 319 | 319 | WHERE qui = %i |
| 320 | 320 | UNION |
| 321 | 321 | SELECT l.action, l.date, i.label AS itemLabel |
| 322 | - FROM ' . prefixTable('log_items') . ' AS l |
|
| 323 | - INNER JOIN ' . prefixTable('items') . ' AS i ON (l.id_item = i.id) |
|
| 322 | + FROM ' . prefixTable('log_items').' AS l |
|
| 323 | + INNER JOIN ' . prefixTable('items').' AS i ON (l.id_item = i.id) |
|
| 324 | 324 | WHERE l.id_user = %i AND l.action IN ("at_access") |
| 325 | 325 | ORDER BY date DESC |
| 326 | 326 | LIMIT 0, 40', |
@@ -334,9 +334,9 @@ discard block |
||
| 334 | 334 | $text = langHdl($record['labelAction']); |
| 335 | 335 | } |
| 336 | 336 | if (empty($record['NULL']) === false) { |
| 337 | - $text .= ' ' . langHdl('for') . ' <span class="font-weight-light">' . addslashes($record['NULL']) . '</span>'; |
|
| 337 | + $text .= ' '.langHdl('for').' <span class="font-weight-light">'.addslashes($record['NULL']).'</span>'; |
|
| 338 | 338 | } |
| 339 | - echo '<li class="list-group-item">' . date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['date']) . ' - ' . $text . '</li>'; |
|
| 339 | + echo '<li class="list-group-item">'.date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['date']).' - '.$text.'</li>'; |
|
| 340 | 340 | } |
| 341 | 341 | ?> |
| 342 | 342 | </ul> |
@@ -374,11 +374,10 @@ discard block |
||
| 374 | 374 | <?php |
| 375 | 375 | foreach ($zones as $key => $zone) { |
| 376 | 376 | echo ' |
| 377 | - <option value="' . $key . '"', |
|
| 377 | + <option value="' . $key.'"', |
|
| 378 | 378 | isset($_SESSION['user']['usertimezone']) === true && $_SESSION['user']['usertimezone'] === $key ? |
| 379 | - ' selected' : |
|
| 380 | - (isset($SETTINGS['timezone']) === true && $SETTINGS['timezone'] === $key ? ' selected' : ''), |
|
| 381 | - '>' . $zone . '</option>'; |
|
| 379 | + ' selected' : (isset($SETTINGS['timezone']) === true && $SETTINGS['timezone'] === $key ? ' selected' : ''), |
|
| 380 | + '>'.$zone.'</option>'; |
|
| 382 | 381 | } |
| 383 | 382 | ?> |
| 384 | 383 | </select> |
@@ -390,11 +389,10 @@ discard block |
||
| 390 | 389 | <select class="form-control" id="profile-user-language"> |
| 391 | 390 | <?php |
| 392 | 391 | foreach ($languages as $language) { |
| 393 | - echo '<option value="' . $language['label'] . '"', |
|
| 392 | + echo '<option value="'.$language['label'].'"', |
|
| 394 | 393 | $_SESSION['user']['user_language'] === strtolower($language['label']) ? |
| 395 | - ' selected="selected"' : |
|
| 396 | - ($SETTINGS['default_language'] === strtolower($language['label']) ? ' selected="selected"' : ''), |
|
| 397 | - '>' . $language['label'] . '</option>'; |
|
| 394 | + ' selected="selected"' : ($SETTINGS['default_language'] === strtolower($language['label']) ? ' selected="selected"' : ''), |
|
| 395 | + '>'.$language['label'].'</option>'; |
|
| 398 | 396 | } |
| 399 | 397 | ?> |
| 400 | 398 | </select> |
@@ -445,7 +443,7 @@ discard block |
||
| 445 | 443 | <button type="button" class="btn btn-warning float-right ml-2" id="profile-avatar-file"><?php echo langHdl('upload_new_avatar'); ?></button> |
| 446 | 444 | <?php |
| 447 | 445 | if (isset($SETTINGS['api']) === true && (int) $SETTINGS['api'] === 1) { |
| 448 | - echo '<button type="button" class="btn btn-warning float-right" id="profile-button-api_token">' . langHdl('generate_api_token') . '</button>'; |
|
| 446 | + echo '<button type="button" class="btn btn-warning float-right" id="profile-button-api_token">'.langHdl('generate_api_token').'</button>'; |
|
| 449 | 447 | } |
| 450 | 448 | ?> |
| 451 | 449 | <div id="profile-avatar-file-container" class="hidden"></div> |
@@ -28,7 +28,7 @@ discard block |
||
| 28 | 28 | require_once 'SecureHandler.php'; |
| 29 | 29 | session_name('teampass_session'); |
| 30 | 30 | session_start(); |
| 31 | -if (! isset($_SESSION['CPM']) || $_SESSION['CPM'] === false || ! isset($_SESSION['key']) || empty($_SESSION['key'])) { |
|
| 31 | +if (!isset($_SESSION['CPM']) || $_SESSION['CPM'] === false || !isset($_SESSION['key']) || empty($_SESSION['key'])) { |
|
| 32 | 32 | die('Hacking attempt...'); |
| 33 | 33 | } |
| 34 | 34 | |
@@ -42,22 +42,22 @@ discard block |
||
| 42 | 42 | } |
| 43 | 43 | |
| 44 | 44 | // Do checks |
| 45 | -require_once $SETTINGS['cpassman_dir'] . '/includes/config/include.php'; |
|
| 46 | -require_once $SETTINGS['cpassman_dir'] . '/sources/checks.php'; |
|
| 45 | +require_once $SETTINGS['cpassman_dir'].'/includes/config/include.php'; |
|
| 46 | +require_once $SETTINGS['cpassman_dir'].'/sources/checks.php'; |
|
| 47 | 47 | if (checkUser($_SESSION['user_id'], $_SESSION['key'], 'folders', $SETTINGS) === false) { |
| 48 | 48 | // Not allowed page |
| 49 | 49 | $_SESSION['error']['code'] = ERR_NOT_ALLOWED; |
| 50 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
| 50 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
| 51 | 51 | exit; |
| 52 | 52 | } |
| 53 | 53 | |
| 54 | -require_once $SETTINGS['cpassman_dir'] . '/includes/language/' . $_SESSION['user_language'] . '.php'; |
|
| 55 | -require_once $SETTINGS['cpassman_dir'] . '/includes/config/settings.php'; |
|
| 54 | +require_once $SETTINGS['cpassman_dir'].'/includes/language/'.$_SESSION['user_language'].'.php'; |
|
| 55 | +require_once $SETTINGS['cpassman_dir'].'/includes/config/settings.php'; |
|
| 56 | 56 | header('Content-type: text/html; charset=utf-8'); |
| 57 | 57 | header('Cache-Control: no-cache, must-revalidate'); |
| 58 | 58 | require_once 'main.functions.php'; |
| 59 | 59 | // Connect to mysql server |
| 60 | -require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Database/Meekrodb/db.class.php'; |
|
| 60 | +require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Database/Meekrodb/db.class.php'; |
|
| 61 | 61 | if (defined('DB_PASSWD_CLEAR') === false) { |
| 62 | 62 | define('DB_PASSWD_CLEAR', defuseReturnDecrypted(DB_PASSWD, $SETTINGS)); |
| 63 | 63 | } |
@@ -68,9 +68,9 @@ discard block |
||
| 68 | 68 | DB::$port = DB_PORT; |
| 69 | 69 | DB::$encoding = DB_ENCODING; |
| 70 | 70 | // Class loader |
| 71 | -require_once $SETTINGS['cpassman_dir'] . '/sources/SplClassLoader.php'; |
|
| 71 | +require_once $SETTINGS['cpassman_dir'].'/sources/SplClassLoader.php'; |
|
| 72 | 72 | //Build tree |
| 73 | -$tree = new SplClassLoader('Tree\NestedTree', $SETTINGS['cpassman_dir'] . '/includes/libraries'); |
|
| 73 | +$tree = new SplClassLoader('Tree\NestedTree', $SETTINGS['cpassman_dir'].'/includes/libraries'); |
|
| 74 | 74 | $tree->register(); |
| 75 | 75 | $tree = new Tree\NestedTree\NestedTree(prefixTable('nested_tree'), 'id', 'parent_id', 'title'); |
| 76 | 76 | //Columns name |
@@ -81,22 +81,22 @@ discard block |
||
| 81 | 81 | $sOrder = $sLimit = ''; |
| 82 | 82 | // Is a date sent? |
| 83 | 83 | if (isset($_GET['dateCriteria']) === true && empty($_GET['dateCriteria']) === false) { |
| 84 | - $sWhere .= ' AND a.del_value < ' . round(filter_var($_GET['dateCriteria'], FILTER_SANITIZE_NUMBER_INT) / 1000, 0); |
|
| 84 | + $sWhere .= ' AND a.del_value < '.round(filter_var($_GET['dateCriteria'], FILTER_SANITIZE_NUMBER_INT) / 1000, 0); |
|
| 85 | 85 | } |
| 86 | 86 | //echo $sWhere; |
| 87 | 87 | /* BUILD QUERY */ |
| 88 | 88 | //Paging |
| 89 | 89 | $sLimit = ''; |
| 90 | 90 | if (isset($_GET['length']) === true && (int) $_GET['length'] !== -1) { |
| 91 | - $sLimit = ' LIMIT ' . filter_var($_GET['start'], FILTER_SANITIZE_NUMBER_INT) . ', ' . filter_var($_GET['length'], FILTER_SANITIZE_NUMBER_INT) . ''; |
|
| 91 | + $sLimit = ' LIMIT '.filter_var($_GET['start'], FILTER_SANITIZE_NUMBER_INT).', '.filter_var($_GET['length'], FILTER_SANITIZE_NUMBER_INT).''; |
|
| 92 | 92 | } |
| 93 | 93 | |
| 94 | 94 | //Ordering |
| 95 | 95 | if (isset($_GET['order'][0]['dir']) && in_array($_GET['order'][0]['dir'], $aSortTypes)) { |
| 96 | 96 | $sOrder = 'ORDER BY '; |
| 97 | 97 | if (preg_match('#^(asc|desc)$#i', $_GET['order'][0]['column'])) { |
| 98 | - $sOrder .= '' . $aColumns[filter_var($_GET['order'][0]['column'], FILTER_SANITIZE_NUMBER_INT)] . ' ' |
|
| 99 | - . filter_var($_GET['order'][0]['column'], FILTER_SANITIZE_STRING) . ', '; |
|
| 98 | + $sOrder .= ''.$aColumns[filter_var($_GET['order'][0]['column'], FILTER_SANITIZE_NUMBER_INT)].' ' |
|
| 99 | + . filter_var($_GET['order'][0]['column'], FILTER_SANITIZE_STRING).', '; |
|
| 100 | 100 | } |
| 101 | 101 | |
| 102 | 102 | $sOrder = substr_replace($sOrder, '', -2); |
@@ -117,29 +117,29 @@ discard block |
||
| 117 | 117 | && $_GET['letter'] !== 'None' |
| 118 | 118 | ) { |
| 119 | 119 | $sWhere .= ' AND '; |
| 120 | - $sWhere .= $aColumns[1] . " LIKE '" . filter_var($_GET['letter'], FILTER_SANITIZE_STRING) . "%' OR "; |
|
| 121 | - $sWhere .= $aColumns[2] . " LIKE '" . filter_var($_GET['letter'], FILTER_SANITIZE_STRING) . "%' OR "; |
|
| 122 | - $sWhere .= $aColumns[3] . " LIKE '" . filter_var($_GET['letter'], FILTER_SANITIZE_STRING) . "%' "; |
|
| 120 | + $sWhere .= $aColumns[1]." LIKE '".filter_var($_GET['letter'], FILTER_SANITIZE_STRING)."%' OR "; |
|
| 121 | + $sWhere .= $aColumns[2]." LIKE '".filter_var($_GET['letter'], FILTER_SANITIZE_STRING)."%' OR "; |
|
| 122 | + $sWhere .= $aColumns[3]." LIKE '".filter_var($_GET['letter'], FILTER_SANITIZE_STRING)."%' "; |
|
| 123 | 123 | } elseif (isset($_GET['search']['value']) === true && $_GET['search']['value'] !== '') { |
| 124 | 124 | $sWhere = ' AND '; |
| 125 | - $sWhere .= $aColumns[1] . " LIKE '" . filter_var($_GET['search']['value'], FILTER_SANITIZE_STRING) . "%' OR "; |
|
| 126 | - $sWhere .= $aColumns[2] . " LIKE '" . filter_var($_GET['search']['value'], FILTER_SANITIZE_STRING) . "%' OR "; |
|
| 127 | - $sWhere .= $aColumns[3] . " LIKE '" . filter_var($_GET['search']['value'], FILTER_SANITIZE_STRING) . "%' "; |
|
| 125 | + $sWhere .= $aColumns[1]." LIKE '".filter_var($_GET['search']['value'], FILTER_SANITIZE_STRING)."%' OR "; |
|
| 126 | + $sWhere .= $aColumns[2]." LIKE '".filter_var($_GET['search']['value'], FILTER_SANITIZE_STRING)."%' OR "; |
|
| 127 | + $sWhere .= $aColumns[3]." LIKE '".filter_var($_GET['search']['value'], FILTER_SANITIZE_STRING)."%' "; |
|
| 128 | 128 | } |
| 129 | 129 | |
| 130 | 130 | $rows = DB::query( |
| 131 | 131 | 'SELECT a.item_id, i.label, a.del_value, i.id_tree |
| 132 | - FROM ' . prefixTable('automatic_del') . ' AS a |
|
| 133 | - INNER JOIN ' . prefixTable('items') . ' AS i ON (i.id = a.item_id)' . |
|
| 132 | + FROM ' . prefixTable('automatic_del').' AS a |
|
| 133 | + INNER JOIN ' . prefixTable('items').' AS i ON (i.id = a.item_id)'. |
|
| 134 | 134 | $sWhere. |
| 135 | 135 | (string) $sOrder |
| 136 | 136 | ); |
| 137 | 137 | $iTotal = DB::count(); |
| 138 | 138 | $rows = DB::query( |
| 139 | 139 | 'SELECT a.item_id, i.label, a.del_value, i.id_tree |
| 140 | - FROM ' . prefixTable('automatic_del') . ' AS a |
|
| 141 | - INNER JOIN ' . prefixTable('items') . ' AS i ON (i.id = a.item_id)' . |
|
| 142 | - $sWhere . |
|
| 140 | + FROM ' . prefixTable('automatic_del').' AS a |
|
| 141 | + INNER JOIN ' . prefixTable('items').' AS i ON (i.id = a.item_id)'. |
|
| 142 | + $sWhere. |
|
| 143 | 143 | $sLimit |
| 144 | 144 | ); |
| 145 | 145 | $iFilteredTotal = DB::count(); |
@@ -157,18 +157,18 @@ discard block |
||
| 157 | 157 | // start the line |
| 158 | 158 | $sOutput .= '['; |
| 159 | 159 | // Column 1 |
| 160 | - $sOutput .= '"<i class=\"fas fa-external-link-alt pointer text-primary mr-2\" onclick=\"showItemCard($(this))\" data-item-id=\"' . $record['item_id'] . '\" data-item-tree-id=\"' . $record['id_tree'] . '\"></i>", '; |
|
| 160 | + $sOutput .= '"<i class=\"fas fa-external-link-alt pointer text-primary mr-2\" onclick=\"showItemCard($(this))\" data-item-id=\"'.$record['item_id'].'\" data-item-tree-id=\"'.$record['id_tree'].'\"></i>", '; |
|
| 161 | 161 | // Column 2 |
| 162 | - $sOutput .= '"' . $record['label'] . '", '; |
|
| 162 | + $sOutput .= '"'.$record['label'].'", '; |
|
| 163 | 163 | // Column 3 |
| 164 | - $sOutput .= '"' . date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) $record['del_value']) . '", '; |
|
| 164 | + $sOutput .= '"'.date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) $record['del_value']).'", '; |
|
| 165 | 165 | // Column 4 |
| 166 | 166 | $path = []; |
| 167 | 167 | $treeDesc = $tree->getPath($record['id_tree'], true); |
| 168 | 168 | foreach ($treeDesc as $t) { |
| 169 | 169 | array_push($path, $t->title); |
| 170 | 170 | } |
| 171 | - $sOutput .= '"' . implode('<i class=\"fas fa-angle-right ml-1 mr-1\"></i>', $path) . '"],'; |
|
| 171 | + $sOutput .= '"'.implode('<i class=\"fas fa-angle-right ml-1 mr-1\"></i>', $path).'"],'; |
|
| 172 | 172 | } |
| 173 | 173 | |
| 174 | 174 | if ($iTotal > 0) { |
@@ -181,4 +181,4 @@ discard block |
||
| 181 | 181 | } |
| 182 | 182 | |
| 183 | 183 | // finalize output |
| 184 | -echo '{"recordsTotal": ' . $iTotal . ', "recordsFiltered": ' . $iFilteredTotal . ', "data": ' . $sOutput; |
|
| 184 | +echo '{"recordsTotal": '.$iTotal.', "recordsFiltered": '.$iFilteredTotal.', "data": '.$sOutput; |
|
@@ -37,12 +37,12 @@ discard block |
||
| 37 | 37 | } |
| 38 | 38 | |
| 39 | 39 | // Do checks |
| 40 | -require_once $SETTINGS['cpassman_dir'] . '/includes/config/include.php'; |
|
| 41 | -require_once $SETTINGS['cpassman_dir'] . '/sources/checks.php'; |
|
| 40 | +require_once $SETTINGS['cpassman_dir'].'/includes/config/include.php'; |
|
| 41 | +require_once $SETTINGS['cpassman_dir'].'/sources/checks.php'; |
|
| 42 | 42 | if (checkUser($_SESSION['user_id'], $_SESSION['key'], 'utilities.database', $SETTINGS) === false) { |
| 43 | 43 | // Not allowed page |
| 44 | 44 | $_SESSION['error']['code'] = ERR_NOT_ALLOWED; |
| 45 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
| 45 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
| 46 | 46 | exit(); |
| 47 | 47 | } |
| 48 | 48 | |
@@ -55,14 +55,14 @@ discard block |
||
| 55 | 55 | date_default_timezone_set('UTC'); |
| 56 | 56 | } |
| 57 | 57 | |
| 58 | -require_once $SETTINGS['cpassman_dir'] . '/includes/language/' . $_SESSION['user_language'] . '.php'; |
|
| 59 | -require_once $SETTINGS['cpassman_dir'] . '/includes/config/settings.php'; |
|
| 58 | +require_once $SETTINGS['cpassman_dir'].'/includes/language/'.$_SESSION['user_language'].'.php'; |
|
| 59 | +require_once $SETTINGS['cpassman_dir'].'/includes/config/settings.php'; |
|
| 60 | 60 | header('Content-type: text/html; charset=utf-8'); |
| 61 | 61 | header('Cache-Control: no-cache, must-revalidate'); |
| 62 | 62 | require_once 'main.functions.php'; |
| 63 | 63 | |
| 64 | 64 | //Connect to DB |
| 65 | -require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Database/Meekrodb/db.class.php'; |
|
| 65 | +require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Database/Meekrodb/db.class.php'; |
|
| 66 | 66 | if (defined('DB_PASSWD_CLEAR') === false) { |
| 67 | 67 | define('DB_PASSWD_CLEAR', defuseReturnDecrypted(DB_PASSWD, $SETTINGS)); |
| 68 | 68 | } |
@@ -102,7 +102,7 @@ discard block |
||
| 102 | 102 | $arrFolders = array(); |
| 103 | 103 | $rows = DB::query( |
| 104 | 104 | 'SELECT valeur, intitule |
| 105 | - FROM ' . prefixTable('misc') . ' |
|
| 105 | + FROM ' . prefixTable('misc').' |
|
| 106 | 106 | WHERE type = %s', |
| 107 | 107 | 'folder_deleted' |
| 108 | 108 | ); |
@@ -123,10 +123,10 @@ discard block |
||
| 123 | 123 | 'SELECT u.login as login, u.name as name, u.lastname as lastname, |
| 124 | 124 | i.id as id, i.label as label, |
| 125 | 125 | i.id_tree as id_tree, l.date as date, n.title as folder_title |
| 126 | - FROM ' . prefixTable('log_items') . ' as l |
|
| 127 | - INNER JOIN ' . prefixTable('items') . ' as i ON (l.id_item=i.id) |
|
| 128 | - INNER JOIN ' . prefixTable('users') . ' as u ON (l.id_user=u.id) |
|
| 129 | - INNER JOIN ' . prefixTable('nested_tree') . ' as n ON (i.id_tree=n.id) |
|
| 126 | + FROM ' . prefixTable('log_items').' as l |
|
| 127 | + INNER JOIN ' . prefixTable('items').' as i ON (l.id_item=i.id) |
|
| 128 | + INNER JOIN ' . prefixTable('users').' as u ON (l.id_user=u.id) |
|
| 129 | + INNER JOIN ' . prefixTable('nested_tree').' as n ON (i.id_tree=n.id) |
|
| 130 | 130 | WHERE i.inactif = %i |
| 131 | 131 | AND l.action = %s', |
| 132 | 132 | 1, |
@@ -148,7 +148,7 @@ discard block |
||
| 148 | 148 | 'label' => $record['label'], |
| 149 | 149 | 'date' => date($SETTINGS['date_format'], (int) $record['date']), |
| 150 | 150 | 'login' => $record['login'], |
| 151 | - 'name' => $record['name'] . ' ' . $record['lastname'], |
|
| 151 | + 'name' => $record['name'].' '.$record['lastname'], |
|
| 152 | 152 | 'folder_label' => $record['folder_title'], |
| 153 | 153 | 'folder_deleted' => $thisFolder, |
| 154 | 154 | ) |
@@ -203,10 +203,10 @@ discard block |
||
| 203 | 203 | foreach ($post_folders as $folderId) { |
| 204 | 204 | $data = DB::queryfirstrow( |
| 205 | 205 | 'SELECT valeur |
| 206 | - FROM ' . prefixTable('misc') . " |
|
| 206 | + FROM ' . prefixTable('misc')." |
|
| 207 | 207 | WHERE type = 'folder_deleted' |
| 208 | 208 | AND intitule = %s", |
| 209 | - 'f' . $folderId |
|
| 209 | + 'f'.$folderId |
|
| 210 | 210 | ); |
| 211 | 211 | if ((int) $data['valeur'] !== 0) { |
| 212 | 212 | $folderData = explode(', ', $data['valeur']); |
@@ -232,7 +232,7 @@ discard block |
||
| 232 | 232 | prefixTable('misc'), |
| 233 | 233 | 'type = %s AND intitule = %s', |
| 234 | 234 | 'folder_deleted', |
| 235 | - 'f' . $folderId |
|
| 235 | + 'f'.$folderId |
|
| 236 | 236 | ); |
| 237 | 237 | |
| 238 | 238 | // Restore all items in this folder |
@@ -248,7 +248,7 @@ discard block |
||
| 248 | 248 | // Get list of all items in thos folder |
| 249 | 249 | $items = DB::query( |
| 250 | 250 | 'SELECT id |
| 251 | - FROM ' . prefixTable('items') . ' |
|
| 251 | + FROM ' . prefixTable('items').' |
|
| 252 | 252 | WHERE id_tree = %i', |
| 253 | 253 | $folderId |
| 254 | 254 | ); |
@@ -333,10 +333,10 @@ discard block |
||
| 333 | 333 | foreach ($post_folders as $folderId) { |
| 334 | 334 | $data = DB::queryfirstrow( |
| 335 | 335 | 'SELECT valeur |
| 336 | - FROM ' . prefixTable('misc') . " |
|
| 336 | + FROM ' . prefixTable('misc')." |
|
| 337 | 337 | WHERE type = 'folder_deleted' |
| 338 | 338 | AND intitule = %s", |
| 339 | - 'f' . $folderId |
|
| 339 | + 'f'.$folderId |
|
| 340 | 340 | ); |
| 341 | 341 | if ((int) $data['valeur'] !== 0) { |
| 342 | 342 | $folderData = explode(', ', $data['valeur']); |
@@ -368,7 +368,7 @@ discard block |
||
| 368 | 368 | prefixTable('misc'), |
| 369 | 369 | 'type = %s AND intitule = %s', |
| 370 | 370 | 'folder_deleted', |
| 371 | - 'f' . $folderData[0] |
|
| 371 | + 'f'.$folderData[0] |
|
| 372 | 372 | ); |
| 373 | 373 | |
| 374 | 374 | // Delete all items in this folder |
@@ -382,7 +382,7 @@ discard block |
||
| 382 | 382 | // Get list of all items in thos folder |
| 383 | 383 | $items = DB::query( |
| 384 | 384 | 'SELECT id |
| 385 | - FROM ' . prefixTable('items') . ' |
|
| 385 | + FROM ' . prefixTable('items').' |
|
| 386 | 386 | WHERE id_tree = %i', |
| 387 | 387 | $folderData[0] |
| 388 | 388 | ); |
@@ -478,7 +478,7 @@ discard block |
||
| 478 | 478 | ) { |
| 479 | 479 | if ($post_log_type === 'items') { |
| 480 | 480 | DB::query( |
| 481 | - 'SELECT * FROM ' . prefixTable('log_items') . ' |
|
| 481 | + 'SELECT * FROM '.prefixTable('log_items').' |
|
| 482 | 482 | WHERE action=%s ' . 'AND date BETWEEN %i AND %i' |
| 483 | 483 | . ($post_filter_action === 'all' ? '' : ' AND action = %s') |
| 484 | 484 | . ($post_filter_user === -1 ? '' : ' AND id_user = %i'), |
@@ -500,7 +500,7 @@ discard block |
||
| 500 | 500 | } elseif ($post_log_type === 'connections') { |
| 501 | 501 | db::debugmode(true); |
| 502 | 502 | DB::query( |
| 503 | - 'SELECT * FROM ' . prefixTable('log_system') . ' WHERE type=%s ' . |
|
| 503 | + 'SELECT * FROM '.prefixTable('log_system').' WHERE type=%s '. |
|
| 504 | 504 | 'AND date BETWEEN %i AND %i', |
| 505 | 505 | 'user_connection', |
| 506 | 506 | $post_date_from, |
@@ -517,7 +517,7 @@ discard block |
||
| 517 | 517 | ); |
| 518 | 518 | } elseif ($post_log_type === 'errors') { |
| 519 | 519 | DB::query( |
| 520 | - 'SELECT * FROM ' . prefixTable('log_system') . ' WHERE type=%s ' . |
|
| 520 | + 'SELECT * FROM '.prefixTable('log_system').' WHERE type=%s '. |
|
| 521 | 521 | 'AND date BETWEEN %i AND %i', |
| 522 | 522 | 'error', |
| 523 | 523 | $post_date_from, |
@@ -534,7 +534,7 @@ discard block |
||
| 534 | 534 | ); |
| 535 | 535 | } elseif ($post_log_type === 'copy') { |
| 536 | 536 | DB::query( |
| 537 | - 'SELECT * FROM ' . prefixTable('log_items') . ' WHERE action=%s ' . |
|
| 537 | + 'SELECT * FROM '.prefixTable('log_items').' WHERE action=%s '. |
|
| 538 | 538 | 'AND date BETWEEN %i AND %i', |
| 539 | 539 | 'at_copy', |
| 540 | 540 | $post_date_from, |
@@ -551,7 +551,7 @@ discard block |
||
| 551 | 551 | ); |
| 552 | 552 | } elseif ($post_log_type === 'admin') { |
| 553 | 553 | DB::query( |
| 554 | - 'SELECT * FROM ' . prefixTable('log_system') . ' WHERE type=%s ' . |
|
| 554 | + 'SELECT * FROM '.prefixTable('log_system').' WHERE type=%s '. |
|
| 555 | 555 | 'AND date BETWEEN %i AND %i', |
| 556 | 556 | 'admin_action', |
| 557 | 557 | $post_date_from, |
@@ -568,7 +568,7 @@ discard block |
||
| 568 | 568 | ); |
| 569 | 569 | } elseif ($post_log_type === 'failed') { |
| 570 | 570 | DB::query( |
| 571 | - 'SELECT * FROM ' . prefixTable('log_system') . ' WHERE type=%s ' . |
|
| 571 | + 'SELECT * FROM '.prefixTable('log_system').' WHERE type=%s '. |
|
| 572 | 572 | 'AND date BETWEEN %i AND %i', |
| 573 | 573 | 'failed_auth', |
| 574 | 574 | $post_date_from, |
@@ -50,26 +50,26 @@ discard block |
||
| 50 | 50 | } |
| 51 | 51 | |
| 52 | 52 | // Do checks |
| 53 | -require_once $SETTINGS['cpassman_dir'] . '/includes/config/include.php'; |
|
| 54 | -require_once $SETTINGS['cpassman_dir'] . '/sources/checks.php'; |
|
| 53 | +require_once $SETTINGS['cpassman_dir'].'/includes/config/include.php'; |
|
| 54 | +require_once $SETTINGS['cpassman_dir'].'/sources/checks.php'; |
|
| 55 | 55 | if (checkUser($_SESSION['user_id'], $_SESSION['key'], 'items', $SETTINGS) === false) { |
| 56 | 56 | // Not allowed page |
| 57 | 57 | $_SESSION['error']['code'] = ERR_NOT_ALLOWED; |
| 58 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
| 58 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
| 59 | 59 | exit(); |
| 60 | 60 | } |
| 61 | 61 | |
| 62 | 62 | // No time limit |
| 63 | 63 | set_time_limit(0); |
| 64 | 64 | |
| 65 | -require_once $SETTINGS['cpassman_dir'] . '/includes/config/settings.php'; |
|
| 65 | +require_once $SETTINGS['cpassman_dir'].'/includes/config/settings.php'; |
|
| 66 | 66 | header('Content-type: text/html; charset=utf-8'); |
| 67 | 67 | error_reporting(E_ERROR); |
| 68 | -require_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php'; |
|
| 69 | -require_once $SETTINGS['cpassman_dir'] . '/sources/SplClassLoader.php'; |
|
| 68 | +require_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php'; |
|
| 69 | +require_once $SETTINGS['cpassman_dir'].'/sources/SplClassLoader.php'; |
|
| 70 | 70 | |
| 71 | 71 | // Connect to mysql server |
| 72 | -require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Database/Meekrodb/db.class.php'; |
|
| 72 | +require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Database/Meekrodb/db.class.php'; |
|
| 73 | 73 | if (defined('DB_PASSWD_CLEAR') === false) { |
| 74 | 74 | define('DB_PASSWD_CLEAR', defuseReturnDecrypted(DB_PASSWD, $SETTINGS)); |
| 75 | 75 | } |
@@ -81,12 +81,12 @@ discard block |
||
| 81 | 81 | DB::$encoding = DB_ENCODING; |
| 82 | 82 | |
| 83 | 83 | // Build tree |
| 84 | -$tree = new SplClassLoader('Tree\NestedTree', $SETTINGS['cpassman_dir'] . '/includes/libraries'); |
|
| 84 | +$tree = new SplClassLoader('Tree\NestedTree', $SETTINGS['cpassman_dir'].'/includes/libraries'); |
|
| 85 | 85 | $tree->register(); |
| 86 | -$tree = new Tree\NestedTree\NestedTree($pre . 'nested_tree', 'id', 'parent_id', 'title'); |
|
| 86 | +$tree = new Tree\NestedTree\NestedTree($pre.'nested_tree', 'id', 'parent_id', 'title'); |
|
| 87 | 87 | |
| 88 | 88 | // User's language loading |
| 89 | -require_once $SETTINGS['cpassman_dir'] . '/includes/language/' . $_SESSION['user_language'] . '.php'; |
|
| 89 | +require_once $SETTINGS['cpassman_dir'].'/includes/language/'.$_SESSION['user_language'].'.php'; |
|
| 90 | 90 | |
| 91 | 91 | // Prepare POST variables |
| 92 | 92 | $id = filter_input(INPUT_POST, 'id', FILTER_SANITIZE_NUMBER_INT); |
@@ -137,9 +137,9 @@ discard block |
||
| 137 | 137 | 'SELECT i.id as id, i.id_tree as id_tree, i.restricted_to as restricted_to, i.perso as perso, |
| 138 | 138 | i.label as label, i.description as description, i.pw as pw, i.login as login, i.url as url, |
| 139 | 139 | i.email as email,l.date as date, i.pw_iv as pw_iv,n.renewal_period as renewal_period |
| 140 | - FROM ' . prefixTable('items') . ' as i |
|
| 141 | - INNER JOIN ' . prefixTable('nested_tree') . ' as n ON (i.id_tree = n.id) |
|
| 142 | - INNER JOIN ' . prefixTable('log_items') . ' as l ON (i.id = l.id_item) |
|
| 140 | + FROM ' . prefixTable('items').' as i |
|
| 141 | + INNER JOIN ' . prefixTable('nested_tree').' as n ON (i.id_tree = n.id) |
|
| 142 | + INNER JOIN ' . prefixTable('log_items').' as l ON (i.id = l.id_item) |
|
| 143 | 143 | WHERE i.inactif = %i |
| 144 | 144 | AND i.id_tree= %i |
| 145 | 145 | AND (l.action = %s OR (l.action = %s AND l.raison LIKE %s)) |
@@ -162,8 +162,8 @@ discard block |
||
| 162 | 162 | // Run query |
| 163 | 163 | $dataItem = DB::queryfirstrow( |
| 164 | 164 | 'SELECT i.pw AS pw, s.share_key AS share_key |
| 165 | - FROM ' . prefixTable('items') . ' AS i |
|
| 166 | - INNER JOIN ' . prefixTable('sharekeys_items') . ' AS s ON (s.object_id = i.id) |
|
| 165 | + FROM ' . prefixTable('items').' AS i |
|
| 166 | + INNER JOIN ' . prefixTable('sharekeys_items').' AS s ON (s.object_id = i.id) |
|
| 167 | 167 | WHERE user_id = %i AND i.id = %i', |
| 168 | 168 | $_SESSION['user_id'], |
| 169 | 169 | $record['id'] |
@@ -187,8 +187,8 @@ discard block |
||
| 187 | 187 | $arr_kbs = []; |
| 188 | 188 | $rows_kb = DB::query( |
| 189 | 189 | 'SELECT b.label, b.id |
| 190 | - FROM ' . prefixTable('kb_items') . ' AS a |
|
| 191 | - INNER JOIN ' . prefixTable('kb') . ' AS b ON (a.kb_id = b.id) |
|
| 190 | + FROM ' . prefixTable('kb_items').' AS a |
|
| 191 | + INNER JOIN ' . prefixTable('kb').' AS b ON (a.kb_id = b.id) |
|
| 192 | 192 | WHERE a.item_id = %i', |
| 193 | 193 | $record['id'] |
| 194 | 194 | ); |
@@ -200,7 +200,7 @@ discard block |
||
| 200 | 200 | $arr_tags = []; |
| 201 | 201 | $rows_tag = DB::query( |
| 202 | 202 | 'SELECT tag |
| 203 | - FROM ' . prefixTable('tags') . ' |
|
| 203 | + FROM ' . prefixTable('tags').' |
|
| 204 | 204 | WHERE item_id = %i', |
| 205 | 205 | $record['id'] |
| 206 | 206 | ); |
@@ -247,14 +247,14 @@ discard block |
||
| 247 | 247 | $tmp .= array2csv($value); |
| 248 | 248 | } |
| 249 | 249 | |
| 250 | - echo '[{"content":"' . base64_encode($tmp) . '"}]'; |
|
| 250 | + echo '[{"content":"'.base64_encode($tmp).'"}]'; |
|
| 251 | 251 | break; |
| 252 | 252 | |
| 253 | 253 | /* |
| 254 | 254 | * PDF - step 1 - Prepare database |
| 255 | 255 | */ |
| 256 | 256 | case 'initialize_export_table': |
| 257 | - DB::query('TRUNCATE TABLE ' . prefixTable('export')); |
|
| 257 | + DB::query('TRUNCATE TABLE '.prefixTable('export')); |
|
| 258 | 258 | break; |
| 259 | 259 | |
| 260 | 260 | /* |
@@ -298,9 +298,9 @@ discard block |
||
| 298 | 298 | 'SELECT i.id as id, i.restricted_to as restricted_to, i.perso as perso, i.label as label, i.description as description, i.pw as pw, i.login as login, i.url as url, i.email as email, |
| 299 | 299 | l.date as date, i.pw_iv as pw_iv, |
| 300 | 300 | n.renewal_period as renewal_period |
| 301 | - FROM ' . prefixTable('items') . ' as i |
|
| 302 | - INNER JOIN ' . prefixTable('nested_tree') . ' as n ON (i.id_tree = n.id) |
|
| 303 | - INNER JOIN ' . prefixTable('log_items') . ' as l ON (i.id = l.id_item) |
|
| 301 | + FROM ' . prefixTable('items').' as i |
|
| 302 | + INNER JOIN ' . prefixTable('nested_tree').' as n ON (i.id_tree = n.id) |
|
| 303 | + INNER JOIN ' . prefixTable('log_items').' as l ON (i.id = l.id_item) |
|
| 304 | 304 | WHERE i.inactif = %i |
| 305 | 305 | AND i.id_tree= %i |
| 306 | 306 | AND (l.action = %s OR (l.action = %s AND l.raison LIKE %s)) |
@@ -326,8 +326,8 @@ discard block |
||
| 326 | 326 | // Run query |
| 327 | 327 | $dataItem = DB::queryfirstrow( |
| 328 | 328 | 'SELECT i.pw AS pw, s.share_key AS share_key |
| 329 | - FROM ' . prefixTable('items') . ' AS i |
|
| 330 | - INNER JOIN ' . prefixTable('sharekeys_items') . ' AS s ON (s.object_id = i.id) |
|
| 329 | + FROM ' . prefixTable('items').' AS i |
|
| 330 | + INNER JOIN ' . prefixTable('sharekeys_items').' AS s ON (s.object_id = i.id) |
|
| 331 | 331 | WHERE user_id = %i AND i.id = %i', |
| 332 | 332 | $_SESSION['user_id'], |
| 333 | 333 | $record['id'] |
@@ -351,8 +351,8 @@ discard block |
||
| 351 | 351 | $arr_kbs = ''; |
| 352 | 352 | $rows_kb = DB::query( |
| 353 | 353 | 'SELECT b.label, b.id |
| 354 | - FROM ' . prefixTable('kb_items') . ' AS a |
|
| 355 | - INNER JOIN ' . prefixTable('kb') . ' AS b ON (a.kb_id = b.id) |
|
| 354 | + FROM ' . prefixTable('kb_items').' AS a |
|
| 355 | + INNER JOIN ' . prefixTable('kb').' AS b ON (a.kb_id = b.id) |
|
| 356 | 356 | WHERE a.item_id = %i', |
| 357 | 357 | $record['id'] |
| 358 | 358 | ); |
@@ -360,7 +360,7 @@ discard block |
||
| 360 | 360 | if (empty($arr_kbs)) { |
| 361 | 361 | $arr_kbs = $rec_kb['label']; |
| 362 | 362 | } else { |
| 363 | - $arr_kbs .= ' | ' . $rec_kb['label']; |
|
| 363 | + $arr_kbs .= ' | '.$rec_kb['label']; |
|
| 364 | 364 | } |
| 365 | 365 | } |
| 366 | 366 | |
@@ -368,7 +368,7 @@ discard block |
||
| 368 | 368 | $arr_tags = ''; |
| 369 | 369 | $rows_tag = DB::query( |
| 370 | 370 | 'SELECT tag |
| 371 | - FROM ' . prefixTable('tags') . ' |
|
| 371 | + FROM ' . prefixTable('tags').' |
|
| 372 | 372 | WHERE item_id = %i', |
| 373 | 373 | $record['id'] |
| 374 | 374 | ); |
@@ -376,7 +376,7 @@ discard block |
||
| 376 | 376 | if (empty($arr_tags)) { |
| 377 | 377 | $arr_tags = $rec_tag['tag']; |
| 378 | 378 | } else { |
| 379 | - $arr_tags .= ' ' . $rec_tag['tag']; |
|
| 379 | + $arr_tags .= ' '.$rec_tag['tag']; |
|
| 380 | 380 | } |
| 381 | 381 | } |
| 382 | 382 | |
@@ -444,7 +444,7 @@ discard block |
||
| 444 | 444 | header('Content-type: application/pdf'); |
| 445 | 445 | |
| 446 | 446 | // query |
| 447 | - $rows = DB::query('SELECT * FROM ' . prefixTable('export')); |
|
| 447 | + $rows = DB::query('SELECT * FROM '.prefixTable('export')); |
|
| 448 | 448 | $counter = DB::count(); |
| 449 | 449 | if ($counter > 0) { |
| 450 | 450 | |
@@ -452,8 +452,8 @@ discard block |
||
| 452 | 452 | $prev_path = ''; |
| 453 | 453 | |
| 454 | 454 | //Prepare the PDF file |
| 455 | - require_once($SETTINGS['cpassman_dir'] . '/includes/libraries/Pdf/tcpdf/config/tcpdf_config.php'); |
|
| 456 | - include $SETTINGS['cpassman_dir'] . '/includes/libraries/Pdf/tcpdf/tcpdf.php'; |
|
| 455 | + require_once($SETTINGS['cpassman_dir'].'/includes/libraries/Pdf/tcpdf/config/tcpdf_config.php'); |
|
| 456 | + include $SETTINGS['cpassman_dir'].'/includes/libraries/Pdf/tcpdf/tcpdf.php'; |
|
| 457 | 457 | |
| 458 | 458 | $pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false); |
| 459 | 459 | $pdf->SetProtection(array('print'), $dataReceived['pdf_password'], null); |
@@ -465,7 +465,7 @@ discard block |
||
| 465 | 465 | |
| 466 | 466 | // set default header data |
| 467 | 467 | $pdf->SetHeaderData( |
| 468 | - $SETTINGS['cpassman_dir'] . '/includes/images/teampass-logo2-home.png', |
|
| 468 | + $SETTINGS['cpassman_dir'].'/includes/images/teampass-logo2-home.png', |
|
| 469 | 469 | PDF_HEADER_LOGO_WIDTH, |
| 470 | 470 | 'Teampass export', |
| 471 | 471 | $_SESSION['lastname']." ".$_SESSION['name'].' @ '.date($SETTINGS['date_format']." ".$SETTINGS['time_format'], (int) time()) |
@@ -569,7 +569,7 @@ discard block |
||
| 569 | 569 | logEvents($SETTINGS, 'pdf_export', '', (string) $_SESSION['user_id'], $_SESSION['login']); |
| 570 | 570 | |
| 571 | 571 | //clean table |
| 572 | - DB::query('TRUNCATE TABLE ' . prefixTable('export')); |
|
| 572 | + DB::query('TRUNCATE TABLE '.prefixTable('export')); |
|
| 573 | 573 | |
| 574 | 574 | // Send back the file in Blob |
| 575 | 575 | echo $pdf->Output(null, 'I'); |
@@ -581,8 +581,8 @@ discard block |
||
| 581 | 581 | // step 1: |
| 582 | 582 | // - prepare export file |
| 583 | 583 | // - get full list of objects id to export |
| 584 | - include $SETTINGS['cpassman_dir'] . '/includes/config/include.php'; |
|
| 585 | - include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Encryption/GibberishAES/GibberishAES.php'; |
|
| 584 | + include $SETTINGS['cpassman_dir'].'/includes/config/include.php'; |
|
| 585 | + include_once $SETTINGS['cpassman_dir'].'/includes/libraries/Encryption/GibberishAES/GibberishAES.php'; |
|
| 586 | 586 | $idsList = array(); |
| 587 | 587 | |
| 588 | 588 | foreach (explode(';', $post_ids) as $id) { |
@@ -594,9 +594,9 @@ discard block |
||
| 594 | 594 | // count elements to display |
| 595 | 595 | $result = DB::query( |
| 596 | 596 | 'SELECT i.id AS id, i.label AS label, i.restricted_to AS restricted_to, i.perso AS perso |
| 597 | - FROM ' . prefixTable('items') . ' as i |
|
| 598 | - INNER JOIN ' . prefixTable('nested_tree') . ' as n ON (i.id_tree = n.id) |
|
| 599 | - INNER JOIN ' . prefixTable('log_items') . ' as l ON (i.id = l.id_item) |
|
| 597 | + FROM ' . prefixTable('items').' as i |
|
| 598 | + INNER JOIN ' . prefixTable('nested_tree').' as n ON (i.id_tree = n.id) |
|
| 599 | + INNER JOIN ' . prefixTable('log_items').' as l ON (i.id = l.id_item) |
|
| 600 | 600 | WHERE i.inactif = %i |
| 601 | 601 | AND i.id_tree= %i |
| 602 | 602 | AND (l.action = %s OR (l.action = %s AND l.raison LIKE %s)) |
@@ -624,9 +624,9 @@ discard block |
||
| 624 | 624 | |
| 625 | 625 | // prepare export file |
| 626 | 626 | //save the file |
| 627 | - $html_file = '/teampass_export_' . time() . '_' . generateKey() . '.html'; |
|
| 627 | + $html_file = '/teampass_export_'.time().'_'.generateKey().'.html'; |
|
| 628 | 628 | //print_r($full_listing); |
| 629 | - $outstream = fopen($SETTINGS['path_to_files_folder'] . $html_file, 'w'); |
|
| 629 | + $outstream = fopen($SETTINGS['path_to_files_folder'].$html_file, 'w'); |
|
| 630 | 630 | if ($outstream === false) { |
| 631 | 631 | echo '[{"error":"true"}]'; |
| 632 | 632 | break; |
@@ -650,12 +650,12 @@ discard block |
||
| 650 | 650 | </style> |
| 651 | 651 | </head> |
| 652 | 652 | <body> |
| 653 | - <input type="hidden" id="generation_date" value="' . GibberishAES::enc(/** @scrutinizer ignore-type */ (string) time(), $post_pdf_password) . '" /> |
|
| 653 | + <input type="hidden" id="generation_date" value="' . GibberishAES::enc(/** @scrutinizer ignore-type */ (string) time(), $post_pdf_password).'" /> |
|
| 654 | 654 | <div id="header"> |
| 655 | - ' . TP_TOOL_NAME . ' - Off Line mode |
|
| 655 | + ' . TP_TOOL_NAME.' - Off Line mode |
|
| 656 | 656 | </div> |
| 657 | 657 | <div style="margin:10px; font-size:9px;"> |
| 658 | - <i>This page was generated by <b>' . $_SESSION['name'] . ' ' . $_SESSION['lastname'] . '</b>, the ' . date('Y/m/d H:i:s') . '.</i> |
|
| 658 | + <i>This page was generated by <b>' . $_SESSION['name'].' '.$_SESSION['lastname'].'</b>, the '.date('Y/m/d H:i:s').'.</i> |
|
| 659 | 659 | <span id="info_page" style="margin-left:20px; font-weight:bold; font-size: 14px; color:red;"></span> |
| 660 | 660 | </div> |
| 661 | 661 | <div id="information"></div> |
@@ -666,11 +666,11 @@ discard block |
||
| 666 | 666 | <div> |
| 667 | 667 | <table id="itemsTable"> |
| 668 | 668 | <thead><tr> |
| 669 | - <th style="width:15%;">' . $LANG['label'] . '</th> |
|
| 670 | - <th style="width:10%;">' . $LANG['pw'] . '</th> |
|
| 671 | - <th style="width:30%;">' . $LANG['description'] . '</th> |
|
| 672 | - <th style="width:5%;">' . $LANG['user_login'] . '</th> |
|
| 673 | - <th style="width:20%;">' . $LANG['url'] . '</th> |
|
| 669 | + <th style="width:15%;">' . $LANG['label'].'</th> |
|
| 670 | + <th style="width:10%;">' . $LANG['pw'].'</th> |
|
| 671 | + <th style="width:30%;">' . $LANG['description'].'</th> |
|
| 672 | + <th style="width:5%;">' . $LANG['user_login'].'</th> |
|
| 673 | + <th style="width:20%;">' . $LANG['url'].'</th> |
|
| 674 | 674 | </tr></thead> |
| 675 | 675 | <tbody id="itemsTable_tbody">' |
| 676 | 676 | ); |
@@ -695,22 +695,22 @@ discard block |
||
| 695 | 695 | || in_array($post_idTree, $_SESSION['groupes_visibles']) === false |
| 696 | 696 | || (in_array($post_idTree, $_SESSION['no_access_folders']) === true) |
| 697 | 697 | ) { |
| 698 | - echo '[{"loop":"true", "number":"' . $post_number . '", "cpt":"' . $post_cpt . '", "file":"' . $post_file . '", "idsList":"' . $post_idsList . '" , "file_link":"' . $post_file_link . '"}]'; |
|
| 698 | + echo '[{"loop":"true", "number":"'.$post_number.'", "cpt":"'.$post_cpt.'", "file":"'.$post_file.'", "idsList":"'.$post_idsList.'" , "file_link":"'.$post_file_link.'"}]'; |
|
| 699 | 699 | break; |
| 700 | 700 | } |
| 701 | 701 | |
| 702 | 702 | $full_listing = array(); |
| 703 | 703 | $items_id_list = array(); |
| 704 | - include $SETTINGS['cpassman_dir'] . '/includes/config/include.php'; |
|
| 705 | - include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Encryption/GibberishAES/GibberishAES.php'; |
|
| 704 | + include $SETTINGS['cpassman_dir'].'/includes/config/include.php'; |
|
| 705 | + include_once $SETTINGS['cpassman_dir'].'/includes/libraries/Encryption/GibberishAES/GibberishAES.php'; |
|
| 706 | 706 | |
| 707 | 707 | $rows = DB::query( |
| 708 | 708 | 'SELECT i.id as id, i.url as url, i.perso as perso, i.label as label, i.description as description, i.pw as pw, i.login as login, i.id_tree as id_tree, |
| 709 | 709 | l.date as date, i.pw_iv as pw_iv, |
| 710 | 710 | n.renewal_period as renewal_period |
| 711 | - FROM ' . prefixTable('items') . ' as i |
|
| 712 | - INNER JOIN ' . prefixTable('nested_tree') . ' as n ON (i.id_tree = n.id) |
|
| 713 | - INNER JOIN ' . prefixTable('log_items') . ' as l ON (i.id = l.id_item) |
|
| 711 | + FROM ' . prefixTable('items').' as i |
|
| 712 | + INNER JOIN ' . prefixTable('nested_tree').' as n ON (i.id_tree = n.id) |
|
| 713 | + INNER JOIN ' . prefixTable('log_items').' as l ON (i.id = l.id_item) |
|
| 714 | 714 | WHERE i.inactif = %i |
| 715 | 715 | AND i.id_tree= %i |
| 716 | 716 | AND (l.action = %s OR (l.action = %s AND l.raison LIKE %s)) |
@@ -770,7 +770,7 @@ discard block |
||
| 770 | 770 | } |
| 771 | 771 | |
| 772 | 772 | //save in export file |
| 773 | - $outstream = fopen($post_file . '.txt', 'a'); |
|
| 773 | + $outstream = fopen($post_file.'.txt', 'a'); |
|
| 774 | 774 | if ($outstream === false) { |
| 775 | 775 | echo '[{"error":"true"}]'; |
| 776 | 776 | break; |
@@ -808,13 +808,13 @@ discard block |
||
| 808 | 808 | if (empty($arboHtml)) { |
| 809 | 809 | $arboHtml = $arboHtml_tmp; |
| 810 | 810 | } else { |
| 811 | - $arboHtml .= ' » ' . $arboHtml_tmp; |
|
| 811 | + $arboHtml .= ' » '.$arboHtml_tmp; |
|
| 812 | 812 | } |
| 813 | 813 | } |
| 814 | 814 | fputs( |
| 815 | 815 | $outstream, |
| 816 | 816 | ' |
| 817 | - <tr class="path"><td colspan="5">' . $arboHtml . '</td></tr>' |
|
| 817 | + <tr class="path"><td colspan="5">' . $arboHtml.'</td></tr>' |
|
| 818 | 818 | ); |
| 819 | 819 | $idTree = $elem['id_tree']; |
| 820 | 820 | } |
@@ -823,12 +823,12 @@ discard block |
||
| 823 | 823 | fputs( |
| 824 | 824 | $outstream, |
| 825 | 825 | ' |
| 826 | - <tr class="' . $lineType . '"> |
|
| 827 | - <td>' . addslashes($elem['label']) . '</td> |
|
| 828 | - <td align="center"><span class="span_pw" id="span_' . $elem['id'] . '"><a href="#" onclick="decryptme(' . $elem['id'] . ', \'' . $encPw . '\');return false;">Decrypt </a></span><input type="hidden" id="hide_' . $elem['id'] . '" value="' . $encPw . '" /></td> |
|
| 829 | - <td>' . $desc . '</td> |
|
| 830 | - <td align="center">' . $login . '</td> |
|
| 831 | - <td align="center">' . $url . '</td> |
|
| 826 | + <tr class="' . $lineType.'"> |
|
| 827 | + <td>' . addslashes($elem['label']).'</td> |
|
| 828 | + <td align="center"><span class="span_pw" id="span_' . $elem['id'].'"><a href="#" onclick="decryptme('.$elem['id'].', \''.$encPw.'\');return false;">Decrypt </a></span><input type="hidden" id="hide_'.$elem['id'].'" value="'.$encPw.'" /></td> |
|
| 829 | + <td>' . $desc.'</td> |
|
| 830 | + <td align="center">' . $login.'</td> |
|
| 831 | + <td align="center">' . $url.'</td> |
|
| 832 | 832 | </tr>' |
| 833 | 833 | ); |
| 834 | 834 | } |
@@ -836,29 +836,29 @@ discard block |
||
| 836 | 836 | fclose($outstream); |
| 837 | 837 | |
| 838 | 838 | // send back and continue |
| 839 | - echo '[{"loop":"true", "number":"' . $post_number . '", "cpt":"' . $post_cpt . '", "file":"' . $post_file . '", "idsList":"' . $post_idsList . '" , "file_link":"' . $post_file_link . '"}]'; |
|
| 839 | + echo '[{"loop":"true", "number":"'.$post_number.'", "cpt":"'.$post_cpt.'", "file":"'.$post_file.'", "idsList":"'.$post_idsList.'" , "file_link":"'.$post_file_link.'"}]'; |
|
| 840 | 840 | break; |
| 841 | 841 | |
| 842 | 842 | //CASE export in HTML format - Iteration loop |
| 843 | 843 | case 'export_to_html_format_finalize': |
| 844 | 844 | // Load includes |
| 845 | - include $SETTINGS['cpassman_dir'] . '/includes/config/include.php'; |
|
| 846 | - require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Encryption/GibberishAES/GibberishAES.php'; |
|
| 845 | + include $SETTINGS['cpassman_dir'].'/includes/config/include.php'; |
|
| 846 | + require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Encryption/GibberishAES/GibberishAES.php'; |
|
| 847 | 847 | |
| 848 | 848 | // read the content of the temporary file |
| 849 | - $handle = fopen($post_file . '.txt', 'r'); |
|
| 849 | + $handle = fopen($post_file.'.txt', 'r'); |
|
| 850 | 850 | if ($handle === false) { |
| 851 | 851 | echo '[{"error":"true"}]'; |
| 852 | 852 | break; |
| 853 | 853 | } |
| 854 | - $contents = fread($handle, filesize($post_file . '.txt')); |
|
| 854 | + $contents = fread($handle, filesize($post_file.'.txt')); |
|
| 855 | 855 | if ($contents === false) { |
| 856 | 856 | echo '[{"error":"true"}]'; |
| 857 | 857 | break; |
| 858 | 858 | } |
| 859 | 859 | fclose($handle); |
| 860 | - if (is_file($post_file . '.txt')) { |
|
| 861 | - unlink($post_file . '.txt'); |
|
| 860 | + if (is_file($post_file.'.txt')) { |
|
| 861 | + unlink($post_file.'.txt'); |
|
| 862 | 862 | } |
| 863 | 863 | |
| 864 | 864 | // Encrypt its content |
@@ -869,7 +869,7 @@ discard block |
||
| 869 | 869 | if (empty($encrypted_text) === true) { |
| 870 | 870 | $encrypted_text = GibberishAES::enc(/** @scrutinizer ignore-type */ $chunk, $post_pdf_password); |
| 871 | 871 | } else { |
| 872 | - $encrypted_text .= '|#|#|' . GibberishAES::enc(/** @scrutinizer ignore-type */ $chunk, $post_pdf_password); |
|
| 872 | + $encrypted_text .= '|#|#|'.GibberishAES::enc(/** @scrutinizer ignore-type */ $chunk, $post_pdf_password); |
|
| 873 | 873 | } |
| 874 | 874 | } |
| 875 | 875 | |
@@ -886,9 +886,9 @@ discard block |
||
| 886 | 886 | </table></div> |
| 887 | 887 | <input type="button" value="Hide all" onclick="hideAll()" /> |
| 888 | 888 | <div id="footer" style="text-align:center;"> |
| 889 | - <a href="https://teampass.net/about/" target="_blank" style="">' . TP_TOOL_NAME . ' ' . TP_VERSION_FULL . ' ' . TP_COPYRIGHT . '</a> |
|
| 889 | + <a href="https://teampass.net/about/" target="_blank" style="">' . TP_TOOL_NAME.' '.TP_VERSION_FULL.' '.TP_COPYRIGHT.'</a> |
|
| 890 | 890 | </div> |
| 891 | - <div id="enc_html" style="display:none;">' . $encrypted_text . '</div> |
|
| 891 | + <div id="enc_html" style="display:none;">' . $encrypted_text.'</div> |
|
| 892 | 892 | </body> |
| 893 | 893 | </html> |
| 894 | 894 | <script type="text/javascript"> |
@@ -994,9 +994,9 @@ discard block |
||
| 994 | 994 | |
| 995 | 995 | fclose($outstream); |
| 996 | 996 | |
| 997 | - echo '[{"text":"<a href=\'' . |
|
| 998 | - $post_file_link . |
|
| 999 | - '\' target=\'_blank\'>' . $LANG['pdf_download'] . '</a>"}]'; |
|
| 997 | + echo '[{"text":"<a href=\''. |
|
| 998 | + $post_file_link. |
|
| 999 | + '\' target=\'_blank\'>'.$LANG['pdf_download'].'</a>"}]'; |
|
| 1000 | 1000 | break; |
| 1001 | 1001 | } |
| 1002 | 1002 | } |
