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'; |
@@ -90,7 +90,7 @@ discard block |
||
| 90 | 90 | console.log('User has to regenerate keys') |
| 91 | 91 | // HIde |
| 92 | 92 | $('.content-header, .content').addClass('hidden'); |
| 93 | - $('#dialog-user-temporary-code-info').html('<i class="icon fas fa-info mr-2"></i><?php echo langHdl('renecyption_expected');?>'); |
|
| 93 | + $('#dialog-user-temporary-code-info').html('<i class="icon fas fa-info mr-2"></i><?php echo langHdl('renecyption_expected'); ?>'); |
|
| 94 | 94 | |
| 95 | 95 | // Show passwords inputs and form |
| 96 | 96 | $('#dialog-user-temporary-code').removeClass('hidden'); |
@@ -104,7 +104,7 @@ discard block |
||
| 104 | 104 | |
| 105 | 105 | // Show passwords inputs and form |
| 106 | 106 | $('#dialog-user-change-password-info') |
| 107 | - .html('<i class="icon fas fa-info mr-2"></i><?php echo langHdl('user_has_to_change_password_info');?>') |
|
| 107 | + .html('<i class="icon fas fa-info mr-2"></i><?php echo langHdl('user_has_to_change_password_info'); ?>') |
|
| 108 | 108 | .removeClass('hidden'); |
| 109 | 109 | $('#dialog-user-change-password').removeClass('hidden'); |
| 110 | 110 | |
@@ -117,7 +117,7 @@ discard block |
||
| 117 | 117 | |
| 118 | 118 | // Show passwords inputs and form |
| 119 | 119 | $('#dialog-ldap-user-change-password-info') |
| 120 | - .html('<i class="icon fas fa-info mr-2"></i><?php echo langHdl('ldap_user_has_changed_his_password');?>') |
|
| 120 | + .html('<i class="icon fas fa-info mr-2"></i><?php echo langHdl('ldap_user_has_changed_his_password'); ?>') |
|
| 121 | 121 | .removeClass('hidden'); |
| 122 | 122 | $('#dialog-ldap-user-change-password').removeClass('hidden'); |
| 123 | 123 | |
@@ -191,7 +191,7 @@ discard block |
||
| 191 | 191 | console.log('User has to regenerate keys') |
| 192 | 192 | // HIde |
| 193 | 193 | $('.content-header, .content').addClass('hidden'); |
| 194 | - $('#dialog-user-temporary-code-info').html('<i class="icon fas fa-info mr-2"></i><?php echo langHdl('renecyption_expected');?>'); |
|
| 194 | + $('#dialog-user-temporary-code-info').html('<i class="icon fas fa-info mr-2"></i><?php echo langHdl('renecyption_expected'); ?>'); |
|
| 195 | 195 | |
| 196 | 196 | // Show passwords inputs and form |
| 197 | 197 | $('#dialog-user-temporary-code').removeClass('hidden'); |
@@ -764,15 +764,15 @@ discard block |
||
| 764 | 764 | // Prepare data |
| 765 | 765 | var data = { |
| 766 | 766 | 'receipt': $('#temp-user-email').val(), |
| 767 | - 'subject': '[Teampass] <?php echo langHdl('temporary_encryption_code');?>', |
|
| 768 | - 'body': '<?php echo langHdl('email_body_temporary_encryption_code');?>', |
|
| 767 | + 'subject': '[Teampass] <?php echo langHdl('temporary_encryption_code'); ?>', |
|
| 768 | + 'body': '<?php echo langHdl('email_body_temporary_encryption_code'); ?>', |
|
| 769 | 769 | 'pre_replace' : { |
| 770 | 770 | '#enc_code#' : $('#temp-user-pwd').val(), |
| 771 | 771 | } |
| 772 | 772 | } |
| 773 | 773 | |
| 774 | 774 | // Prepare form |
| 775 | - $('#dialog-admin-change-user-password-info').html('<?php echo langHdl('sending_email_message');?>'); |
|
| 775 | + $('#dialog-admin-change-user-password-info').html('<?php echo langHdl('sending_email_message'); ?>'); |
|
| 776 | 776 | |
| 777 | 777 | // Launch action |
| 778 | 778 | $.post( |
@@ -1234,7 +1234,7 @@ discard block |
||
| 1234 | 1234 | '#warningModal', |
| 1235 | 1235 | '<i class="fas fa-clock fa-lg warning mr-2"></i><?php echo langHdl('index_add_one_hour'); ?>', |
| 1236 | 1236 | '<div class="form-group">' + |
| 1237 | - '<label for="warningModal-input" class="col-form-label"><?php echo langHdl('index_session_duration') . ' (' . langHdl('minutes') . ')'; ?>:</label>' + |
|
| 1237 | + '<label for="warningModal-input" class="col-form-label"><?php echo langHdl('index_session_duration').' ('.langHdl('minutes').')'; ?>:</label>' + |
|
| 1238 | 1238 | '<input type="text" class="form-control" id="warningModal-input" value="<?php echo isset($_SESSION['user']['session_duration']) === true ? (int) $_SESSION['user']['session_duration'] / 60 : 60; ?>">' + |
| 1239 | 1239 | '</div>', |
| 1240 | 1240 | '<?php echo langHdl('confirm'); ?>', |
@@ -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; |
|
@@ -46,25 +46,25 @@ discard block |
||
| 46 | 46 | } |
| 47 | 47 | |
| 48 | 48 | /* do checks */ |
| 49 | -require_once $SETTINGS['cpassman_dir'] . '/includes/config/include.php'; |
|
| 50 | -require_once $SETTINGS['cpassman_dir'] . '/sources/checks.php'; |
|
| 49 | +require_once $SETTINGS['cpassman_dir'].'/includes/config/include.php'; |
|
| 50 | +require_once $SETTINGS['cpassman_dir'].'/sources/checks.php'; |
|
| 51 | 51 | if (!checkUser($_SESSION['user_id'], $_SESSION['key'], 'options', $SETTINGS)) { |
| 52 | 52 | $_SESSION['error']['code'] = ERR_NOT_ALLOWED; //not allowed page |
| 53 | - include $SETTINGS['cpassman_dir'] . '/error.php'; |
|
| 53 | + include $SETTINGS['cpassman_dir'].'/error.php'; |
|
| 54 | 54 | exit; |
| 55 | 55 | } |
| 56 | 56 | |
| 57 | -require_once $SETTINGS['cpassman_dir'] . '/includes/language/' . $_SESSION['user_language'] . '.php'; |
|
| 58 | -require_once $SETTINGS['cpassman_dir'] . '/includes/config/settings.php'; |
|
| 59 | -require_once $SETTINGS['cpassman_dir'] . '/includes/config/tp.config.php'; |
|
| 57 | +require_once $SETTINGS['cpassman_dir'].'/includes/language/'.$_SESSION['user_language'].'.php'; |
|
| 58 | +require_once $SETTINGS['cpassman_dir'].'/includes/config/settings.php'; |
|
| 59 | +require_once $SETTINGS['cpassman_dir'].'/includes/config/tp.config.php'; |
|
| 60 | 60 | |
| 61 | 61 | header('Content-type: text/html; charset=utf-8'); |
| 62 | 62 | header('Cache-Control: no-cache, no-store, must-revalidate'); |
| 63 | 63 | |
| 64 | -require_once $SETTINGS['cpassman_dir'] . '/sources/SplClassLoader.php'; |
|
| 64 | +require_once $SETTINGS['cpassman_dir'].'/sources/SplClassLoader.php'; |
|
| 65 | 65 | |
| 66 | 66 | // connect to the server |
| 67 | -require_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Database/Meekrodb/db.class.php'; |
|
| 67 | +require_once $SETTINGS['cpassman_dir'].'/includes/libraries/Database/Meekrodb/db.class.php'; |
|
| 68 | 68 | if (defined('DB_PASSWD_CLEAR') === false) { |
| 69 | 69 | define('DB_PASSWD_CLEAR', defuseReturnDecrypted(DB_PASSWD, $SETTINGS)); |
| 70 | 70 | } |
@@ -117,7 +117,7 @@ discard block |
||
| 117 | 117 | array( |
| 118 | 118 | 'http' => array( |
| 119 | 119 | 'ignore_errors' => true, |
| 120 | - 'proxy' => $SETTINGS['proxy_ip'] . ':' . $SETTINGS['proxy_port'], |
|
| 120 | + 'proxy' => $SETTINGS['proxy_ip'].':'.$SETTINGS['proxy_port'], |
|
| 121 | 121 | ), |
| 122 | 122 | ) |
| 123 | 123 | ); |
@@ -136,16 +136,16 @@ discard block |
||
| 136 | 136 | $json_array = json_decode($json, true); |
| 137 | 137 | |
| 138 | 138 | // About version |
| 139 | - $text .= '<li><u>' . $LANG['your_version'] . '</u> : ' . TP_VERSION_FULL; |
|
| 139 | + $text .= '<li><u>'.$LANG['your_version'].'</u> : '.TP_VERSION_FULL; |
|
| 140 | 140 | if (floatval(TP_VERSION_FULL) < floatval($json_array['info']['version'])) { |
| 141 | - $text .= ' <b>' . $LANG['please_update'] . '</b>'; |
|
| 141 | + $text .= ' <b>'.$LANG['please_update'].'</b>'; |
|
| 142 | 142 | } |
| 143 | 143 | $text .= '</li>'; |
| 144 | 144 | |
| 145 | 145 | // Libraries |
| 146 | 146 | $text .= '<li><u>Libraries</u> :</li>'; |
| 147 | 147 | foreach ($json_array['libraries'] as $key => $val) { |
| 148 | - $text .= "<li> <span class='fa fa-caret-right'></span> " . $key . " (<a href='" . $val . "' target='_blank'>" . $val . '</a>)</li>'; |
|
| 148 | + $text .= "<li> <span class='fa fa-caret-right'></span> ".$key." (<a href='".$val."' target='_blank'>".$val.'</a>)</li>'; |
|
| 149 | 149 | } |
| 150 | 150 | } |
| 151 | 151 | } else { |
@@ -156,7 +156,7 @@ discard block |
||
| 156 | 156 | } |
| 157 | 157 | $text .= '</ul>'; |
| 158 | 158 | |
| 159 | - echo '[{"error":"' . $error . '" , "output":"' . str_replace(array("\n", "\t", "\r"), '', $text) . '"}]'; |
|
| 159 | + echo '[{"error":"'.$error.'" , "output":"'.str_replace(array("\n", "\t", "\r"), '', $text).'"}]'; |
|
| 160 | 160 | break; |
| 161 | 161 | |
| 162 | 162 | //########################################################## |
@@ -188,7 +188,7 @@ discard block |
||
| 188 | 188 | //get through all users |
| 189 | 189 | $rows = DB::query( |
| 190 | 190 | 'SELECT id, login, email |
| 191 | - FROM ' . prefixTable('users') . ' |
|
| 191 | + FROM ' . prefixTable('users').' |
|
| 192 | 192 | ORDER BY login ASC' |
| 193 | 193 | ); |
| 194 | 194 | foreach ($rows as $record) { |
@@ -205,7 +205,7 @@ discard block |
||
| 205 | 205 | //if folder doesn't exist then create it |
| 206 | 206 | $data = DB::queryfirstrow( |
| 207 | 207 | 'SELECT id |
| 208 | - FROM ' . prefixTable('nested_tree') . ' |
|
| 208 | + FROM ' . prefixTable('nested_tree').' |
|
| 209 | 209 | WHERE title = %s AND parent_id = %i', |
| 210 | 210 | $record['id'], |
| 211 | 211 | 0 |
@@ -267,8 +267,8 @@ discard block |
||
| 267 | 267 | echo prepareExchangedData( |
| 268 | 268 | array( |
| 269 | 269 | 'error' => false, |
| 270 | - 'message' => langHdl('last_execution') . ' ' . |
|
| 271 | - date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) time()) . |
|
| 270 | + 'message' => langHdl('last_execution').' '. |
|
| 271 | + date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) time()). |
|
| 272 | 272 | '<i class="fas fa-check text-success ml-2"></i>', |
| 273 | 273 | ), |
| 274 | 274 | 'encode' |
@@ -302,7 +302,7 @@ discard block |
||
| 302 | 302 | } |
| 303 | 303 | |
| 304 | 304 | //Libraries call |
| 305 | - require_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php'; |
|
| 305 | + require_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php'; |
|
| 306 | 306 | |
| 307 | 307 | //init |
| 308 | 308 | $foldersIds = array(); |
@@ -316,7 +316,7 @@ discard block |
||
| 316 | 316 | } |
| 317 | 317 | } |
| 318 | 318 | |
| 319 | - $items = DB::query('SELECT id,label FROM ' . prefixTable('items') . ' WHERE id_tree NOT IN %li', $foldersIds); |
|
| 319 | + $items = DB::query('SELECT id,label FROM '.prefixTable('items').' WHERE id_tree NOT IN %li', $foldersIds); |
|
| 320 | 320 | foreach ($items as $item) { |
| 321 | 321 | //Delete item |
| 322 | 322 | DB::DELETE(prefixTable('items'), 'id = %i', $item['id']); |
@@ -337,12 +337,12 @@ discard block |
||
| 337 | 337 | // delete orphan items |
| 338 | 338 | $rows = DB::query( |
| 339 | 339 | 'SELECT id |
| 340 | - FROM ' . prefixTable('items') . ' |
|
| 340 | + FROM ' . prefixTable('items').' |
|
| 341 | 341 | ORDER BY id ASC' |
| 342 | 342 | ); |
| 343 | 343 | foreach ($rows as $item) { |
| 344 | 344 | DB::query( |
| 345 | - 'SELECT * FROM ' . prefixTable('log_items') . ' WHERE id_item = %i AND action = %s', |
|
| 345 | + 'SELECT * FROM '.prefixTable('log_items').' WHERE id_item = %i AND action = %s', |
|
| 346 | 346 | $item['id'], |
| 347 | 347 | 'at_creation' |
| 348 | 348 | ); |
@@ -372,11 +372,11 @@ discard block |
||
| 372 | 372 | echo prepareExchangedData( |
| 373 | 373 | array( |
| 374 | 374 | 'error' => false, |
| 375 | - 'message' => langHdl('last_execution') . ' ' . |
|
| 376 | - date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) time()) . |
|
| 375 | + 'message' => langHdl('last_execution').' '. |
|
| 376 | + date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) time()). |
|
| 377 | 377 | '<i class="fas fa-check text-success ml-2 mr-3"></i> |
| 378 | 378 | <i class="fas fa-chevron-right mr-2"></i>' . |
| 379 | - $nbItemsDeleted . ' ' . langHdl('deleted_items'), |
|
| 379 | + $nbItemsDeleted.' '.langHdl('deleted_items'), |
|
| 380 | 380 | ), |
| 381 | 381 | 'encode' |
| 382 | 382 | ); |
@@ -408,21 +408,21 @@ discard block |
||
| 408 | 408 | break; |
| 409 | 409 | } |
| 410 | 410 | |
| 411 | - require_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php'; |
|
| 411 | + require_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php'; |
|
| 412 | 412 | $return = ''; |
| 413 | 413 | |
| 414 | 414 | //Get all tables |
| 415 | 415 | $tables = array(); |
| 416 | 416 | $result = DB::query('SHOW TABLES'); |
| 417 | 417 | foreach ($result as $row) { |
| 418 | - $tables[] = $row['Tables_in_' . $database]; |
|
| 418 | + $tables[] = $row['Tables_in_'.$database]; |
|
| 419 | 419 | } |
| 420 | 420 | |
| 421 | 421 | //cycle through |
| 422 | 422 | foreach ($tables as $table) { |
| 423 | 423 | if (defined('DB_PREFIX') || substr_count($table, DB_PREFIX) > 0) { |
| 424 | 424 | // Do query |
| 425 | - $result = DB::queryRaw('SELECT * FROM ' . $table); |
|
| 425 | + $result = DB::queryRaw('SELECT * FROM '.$table); |
|
| 426 | 426 | DB::queryRaw( |
| 427 | 427 | 'SELECT * |
| 428 | 428 | FROM INFORMATION_SCHEMA.COLUMNS |
@@ -434,19 +434,19 @@ discard block |
||
| 434 | 434 | $numFields = DB::count(); |
| 435 | 435 | |
| 436 | 436 | // prepare a drop table |
| 437 | - $return .= 'DROP TABLE ' . $table . ';'; |
|
| 438 | - $row2 = DB::queryfirstrow('SHOW CREATE TABLE ' . $table); |
|
| 439 | - $return .= "\n\n" . $row2['Create Table'] . ";\n\n"; |
|
| 437 | + $return .= 'DROP TABLE '.$table.';'; |
|
| 438 | + $row2 = DB::queryfirstrow('SHOW CREATE TABLE '.$table); |
|
| 439 | + $return .= "\n\n".$row2['Create Table'].";\n\n"; |
|
| 440 | 440 | |
| 441 | 441 | //prepare all fields and datas |
| 442 | 442 | for ($i = 0; $i < $numFields; ++$i) { |
| 443 | 443 | while ($row = $result->fetch_row()) { |
| 444 | - $return .= 'INSERT INTO ' . $table . ' VALUES('; |
|
| 444 | + $return .= 'INSERT INTO '.$table.' VALUES('; |
|
| 445 | 445 | for ($j = 0; $j < $numFields; ++$j) { |
| 446 | 446 | $row[$j] = addslashes($row[$j]); |
| 447 | 447 | $row[$j] = preg_replace("/\n/", '\\n', $row[$j]); |
| 448 | 448 | if (isset($row[$j])) { |
| 449 | - $return .= '"' . $row[$j] . '"'; |
|
| 449 | + $return .= '"'.$row[$j].'"'; |
|
| 450 | 450 | } else { |
| 451 | 451 | $return .= 'NULL'; |
| 452 | 452 | } |
@@ -466,8 +466,8 @@ discard block |
||
| 466 | 466 | $token = GenerateCryptKey(20, false, true, true, false, true, $SETTINGS); |
| 467 | 467 | |
| 468 | 468 | //save file |
| 469 | - $filename = time() . '-' . $token . '.sql'; |
|
| 470 | - $handle = fopen($SETTINGS['path_to_files_folder'] . '/' . $filename, 'w+'); |
|
| 469 | + $filename = time().'-'.$token.'.sql'; |
|
| 470 | + $handle = fopen($SETTINGS['path_to_files_folder'].'/'.$filename, 'w+'); |
|
| 471 | 471 | if ($handle !== false) { |
| 472 | 472 | //write file |
| 473 | 473 | fwrite($handle, $return); |
@@ -479,17 +479,17 @@ discard block |
||
| 479 | 479 | // Encrypt the file |
| 480 | 480 | prepareFileWithDefuse( |
| 481 | 481 | 'encrypt', |
| 482 | - $SETTINGS['path_to_files_folder'] . '/' . $filename, |
|
| 483 | - $SETTINGS['path_to_files_folder'] . '/defuse_temp_' . $filename, |
|
| 482 | + $SETTINGS['path_to_files_folder'].'/'.$filename, |
|
| 483 | + $SETTINGS['path_to_files_folder'].'/defuse_temp_'.$filename, |
|
| 484 | 484 | $SETTINGS, |
| 485 | 485 | $post_option |
| 486 | 486 | ); |
| 487 | 487 | |
| 488 | 488 | // Do clean |
| 489 | - unlink($SETTINGS['path_to_files_folder'] . '/' . $filename); |
|
| 489 | + unlink($SETTINGS['path_to_files_folder'].'/'.$filename); |
|
| 490 | 490 | rename( |
| 491 | - $SETTINGS['path_to_files_folder'] . '/defuse_temp_' . $filename, |
|
| 492 | - $SETTINGS['path_to_files_folder'] . '/' . $filename |
|
| 491 | + $SETTINGS['path_to_files_folder'].'/defuse_temp_'.$filename, |
|
| 492 | + $SETTINGS['path_to_files_folder'].'/'.$filename |
|
| 493 | 493 | ); |
| 494 | 494 | } |
| 495 | 495 | |
@@ -499,7 +499,7 @@ discard block |
||
| 499 | 499 | //update LOG |
| 500 | 500 | logEvents($SETTINGS, 'admin_action', 'dataBase backup', (string) $_SESSION['user_id'], $_SESSION['login']); |
| 501 | 501 | |
| 502 | - echo '[{"result":"db_backup" , "href":"sources/downloadFile.php?name=' . urlencode($filename) . '&sub=files&file=' . $filename . '&type=sql&key=' . $_SESSION['key'] . '&key_tmp=' . $_SESSION['key_tmp'] . '&pathIsFiles=1"}]'; |
|
| 502 | + echo '[{"result":"db_backup" , "href":"sources/downloadFile.php?name='.urlencode($filename).'&sub=files&file='.$filename.'&type=sql&key='.$_SESSION['key'].'&key_tmp='.$_SESSION['key_tmp'].'&pathIsFiles=1"}]'; |
|
| 503 | 503 | } |
| 504 | 504 | break; |
| 505 | 505 | |
@@ -528,7 +528,7 @@ discard block |
||
| 528 | 528 | ); |
| 529 | 529 | break; |
| 530 | 530 | } |
| 531 | - include_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php'; |
|
| 531 | + include_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php'; |
|
| 532 | 532 | |
| 533 | 533 | $dataPost = explode('&', $post_option); |
| 534 | 534 | $file = htmlspecialchars($dataPost[0]); |
@@ -537,7 +537,7 @@ discard block |
||
| 537 | 537 | // Get filename from database |
| 538 | 538 | $data = DB::queryFirstRow( |
| 539 | 539 | 'SELECT valeur |
| 540 | - FROM ' . prefixTable('misc') . ' |
|
| 540 | + FROM ' . prefixTable('misc').' |
|
| 541 | 541 | WHERE increment_id = %i', |
| 542 | 542 | $file |
| 543 | 543 | ); |
@@ -556,22 +556,22 @@ discard block |
||
| 556 | 556 | // Decrypt the file |
| 557 | 557 | $ret = prepareFileWithDefuse( |
| 558 | 558 | 'decrypt', |
| 559 | - $SETTINGS['path_to_files_folder'] . '/' . $file, |
|
| 560 | - $SETTINGS['path_to_files_folder'] . '/defuse_temp_' . $file, |
|
| 559 | + $SETTINGS['path_to_files_folder'].'/'.$file, |
|
| 560 | + $SETTINGS['path_to_files_folder'].'/defuse_temp_'.$file, |
|
| 561 | 561 | $SETTINGS, |
| 562 | 562 | $key |
| 563 | 563 | ); |
| 564 | 564 | |
| 565 | 565 | if (empty($ret) === false) { |
| 566 | - echo '[{"result":"db_restore" , "message":"' . $ret . '"}]'; |
|
| 566 | + echo '[{"result":"db_restore" , "message":"'.$ret.'"}]'; |
|
| 567 | 567 | break; |
| 568 | 568 | } |
| 569 | 569 | |
| 570 | 570 | // Do clean |
| 571 | - fileDelete($SETTINGS['path_to_files_folder'] . '/' . $file, $SETTINGS); |
|
| 572 | - $file = $SETTINGS['path_to_files_folder'] . '/defuse_temp_' . $file; |
|
| 571 | + fileDelete($SETTINGS['path_to_files_folder'].'/'.$file, $SETTINGS); |
|
| 572 | + $file = $SETTINGS['path_to_files_folder'].'/defuse_temp_'.$file; |
|
| 573 | 573 | } else { |
| 574 | - $file = $SETTINGS['path_to_files_folder'] . '/' . $file; |
|
| 574 | + $file = $SETTINGS['path_to_files_folder'].'/'.$file; |
|
| 575 | 575 | } |
| 576 | 576 | |
| 577 | 577 | //read sql file |
@@ -588,7 +588,7 @@ discard block |
||
| 588 | 588 | fclose($handle); |
| 589 | 589 | |
| 590 | 590 | //delete file |
| 591 | - unlink($SETTINGS['path_to_files_folder'] . '/' . $file); |
|
| 591 | + unlink($SETTINGS['path_to_files_folder'].'/'.$file); |
|
| 592 | 592 | |
| 593 | 593 | //Show done |
| 594 | 594 | echo '[{"result":"db_restore" , "message":""}]'; |
@@ -626,8 +626,8 @@ discard block |
||
| 626 | 626 | foreach ($table as $i => $tablename) { |
| 627 | 627 | if (substr_count($tablename, DB_PREFIX) > 0) { |
| 628 | 628 | // launch optimization quieries |
| 629 | - DB::query('ANALYZE TABLE `' . $tablename . '`'); |
|
| 630 | - DB::query('OPTIMIZE TABLE `' . $tablename . '`'); |
|
| 629 | + DB::query('ANALYZE TABLE `'.$tablename.'`'); |
|
| 630 | + DB::query('OPTIMIZE TABLE `'.$tablename.'`'); |
|
| 631 | 631 | } |
| 632 | 632 | } |
| 633 | 633 | } |
@@ -635,12 +635,12 @@ discard block |
||
| 635 | 635 | //Clean up LOG_ITEMS table |
| 636 | 636 | $rows = DB::query( |
| 637 | 637 | 'SELECT id |
| 638 | - FROM ' . prefixTable('items') . ' |
|
| 638 | + FROM ' . prefixTable('items').' |
|
| 639 | 639 | ORDER BY id ASC' |
| 640 | 640 | ); |
| 641 | 641 | foreach ($rows as $item) { |
| 642 | 642 | DB::query( |
| 643 | - 'SELECT * FROM ' . prefixTable('log_items') . ' WHERE id_item = %i AND action = %s', |
|
| 643 | + 'SELECT * FROM '.prefixTable('log_items').' WHERE id_item = %i AND action = %s', |
|
| 644 | 644 | $item['id'], |
| 645 | 645 | 'at_creation' |
| 646 | 646 | ); |
@@ -648,7 +648,7 @@ discard block |
||
| 648 | 648 | if ($counter === 0) { |
| 649 | 649 | //Create new at_creation entry |
| 650 | 650 | $rowTmp = DB::queryFirstRow( |
| 651 | - 'SELECT date, id_user FROM ' . prefixTable('log_items') . ' WHERE id_item=%i ORDER BY date ASC', |
|
| 651 | + 'SELECT date, id_user FROM '.prefixTable('log_items').' WHERE id_item=%i ORDER BY date ASC', |
|
| 652 | 652 | $item['id'] |
| 653 | 653 | ); |
| 654 | 654 | DB::insert( |
@@ -678,8 +678,8 @@ discard block |
||
| 678 | 678 | echo prepareExchangedData( |
| 679 | 679 | array( |
| 680 | 680 | 'error' => false, |
| 681 | - 'message' => langHdl('last_execution') . ' ' . |
|
| 682 | - date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) time()) . |
|
| 681 | + 'message' => langHdl('last_execution').' '. |
|
| 682 | + date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) time()). |
|
| 683 | 683 | '<i class="fas fa-check text-success ml-2"></i>', |
| 684 | 684 | ), |
| 685 | 685 | 'encode' |
@@ -712,14 +712,14 @@ discard block |
||
| 712 | 712 | break; |
| 713 | 713 | } |
| 714 | 714 | |
| 715 | - require_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php'; |
|
| 715 | + require_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php'; |
|
| 716 | 716 | |
| 717 | 717 | //read folder |
| 718 | 718 | if (is_dir($SETTINGS['path_to_files_folder']) === false) { |
| 719 | 719 | echo prepareExchangedData( |
| 720 | 720 | array( |
| 721 | 721 | 'error' => true, |
| 722 | - 'message' => langHdl('file_folder_not_accessible') . ": " . $SETTINGS['path_to_files_folder'], |
|
| 722 | + 'message' => langHdl('file_folder_not_accessible').": ".$SETTINGS['path_to_files_folder'], |
|
| 723 | 723 | ), |
| 724 | 724 | 'encode' |
| 725 | 725 | ); |
@@ -731,8 +731,8 @@ discard block |
||
| 731 | 731 | //delete file FILES |
| 732 | 732 | while (false !== ($f = readdir($dir))) { |
| 733 | 733 | if ($f !== '.' && $f !== '..' && $f !== '.htaccess') { |
| 734 | - if (file_exists($dir . $f) && ((time() - filectime($dir . $f)) > 604800)) { |
|
| 735 | - fileDelete($dir . '/' . $f, $SETTINGS); |
|
| 734 | + if (file_exists($dir.$f) && ((time() - filectime($dir.$f)) > 604800)) { |
|
| 735 | + fileDelete($dir.'/'.$f, $SETTINGS); |
|
| 736 | 736 | } |
| 737 | 737 | } |
| 738 | 738 | } |
@@ -746,7 +746,7 @@ discard block |
||
| 746 | 746 | echo prepareExchangedData( |
| 747 | 747 | array( |
| 748 | 748 | 'error' => true, |
| 749 | - 'message' => langHdl('file_folder_not_accessible') . ": " . $SETTINGS['path_to_upload_folder'], |
|
| 749 | + 'message' => langHdl('file_folder_not_accessible').": ".$SETTINGS['path_to_upload_folder'], |
|
| 750 | 750 | ), |
| 751 | 751 | 'encode' |
| 752 | 752 | ); |
@@ -760,7 +760,7 @@ discard block |
||
| 760 | 760 | while (false !== ($f = readdir($dir))) { |
| 761 | 761 | if ($f !== '.' && $f !== '..') { |
| 762 | 762 | if (strpos($f, '_delete.') > 0) { |
| 763 | - fileDelete($SETTINGS['path_to_upload_folder'] . '/' . $f, $SETTINGS); |
|
| 763 | + fileDelete($SETTINGS['path_to_upload_folder'].'/'.$f, $SETTINGS); |
|
| 764 | 764 | } |
| 765 | 765 | } |
| 766 | 766 | } |
@@ -782,11 +782,11 @@ discard block |
||
| 782 | 782 | echo prepareExchangedData( |
| 783 | 783 | array( |
| 784 | 784 | 'error' => false, |
| 785 | - 'message' => langHdl('last_execution') . ' ' . |
|
| 786 | - date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) time()) . |
|
| 785 | + 'message' => langHdl('last_execution').' '. |
|
| 786 | + date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) time()). |
|
| 787 | 787 | '<i class="fas fa-check text-success ml-2 mr-3"></i> |
| 788 | 788 | <i class="fas fa-chevron-right mr-2"></i>' . |
| 789 | - $nbItemsDeleted . ' ' . langHdl('deleted_items'), |
|
| 789 | + $nbItemsDeleted.' '.langHdl('deleted_items'), |
|
| 790 | 790 | ), |
| 791 | 791 | 'encode' |
| 792 | 792 | ); |
@@ -819,7 +819,7 @@ discard block |
||
| 819 | 819 | break; |
| 820 | 820 | } |
| 821 | 821 | |
| 822 | - require_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php'; |
|
| 822 | + require_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php'; |
|
| 823 | 823 | updateCacheTable('reload', $SETTINGS, ''); |
| 824 | 824 | |
| 825 | 825 | // Log |
@@ -835,8 +835,8 @@ discard block |
||
| 835 | 835 | echo prepareExchangedData( |
| 836 | 836 | [ |
| 837 | 837 | 'error' => false, |
| 838 | - 'message' => langHdl('last_execution') . ' ' . |
|
| 839 | - date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) time()) . |
|
| 838 | + 'message' => langHdl('last_execution').' '. |
|
| 839 | + date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) time()). |
|
| 840 | 840 | '<i class="fas fa-check text-success mr-2"></i>', |
| 841 | 841 | ], |
| 842 | 842 | 'encode' |
@@ -871,7 +871,7 @@ discard block |
||
| 871 | 871 | } |
| 872 | 872 | |
| 873 | 873 | // Perform |
| 874 | - include_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php'; |
|
| 874 | + include_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php'; |
|
| 875 | 875 | $ret = handleConfigFile('rebuild', $SETTINGS); |
| 876 | 876 | |
| 877 | 877 | // Log |
@@ -898,8 +898,8 @@ discard block |
||
| 898 | 898 | echo prepareExchangedData( |
| 899 | 899 | array( |
| 900 | 900 | 'error' => false, |
| 901 | - 'message' => langHdl('last_execution') . ' ' . |
|
| 902 | - date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) time()) . |
|
| 901 | + 'message' => langHdl('last_execution').' '. |
|
| 902 | + date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) time()). |
|
| 903 | 903 | '<i class="fas fa-check text-success ml-2"></i>', |
| 904 | 904 | ), |
| 905 | 905 | 'encode' |
@@ -939,33 +939,33 @@ discard block |
||
| 939 | 939 | $filename = $post_option; |
| 940 | 940 | $tp_settings = []; |
| 941 | 941 | //get backups infos |
| 942 | - $rows = DB::query('SELECT * FROM ' . prefixTable('misc') . ' WHERE type = %s', 'admin'); |
|
| 942 | + $rows = DB::query('SELECT * FROM '.prefixTable('misc').' WHERE type = %s', 'admin'); |
|
| 943 | 943 | foreach ($rows as $record) { |
| 944 | 944 | $tp_settings[$record['intitule']] = $record['valeur']; |
| 945 | 945 | } |
| 946 | 946 | |
| 947 | 947 | // check if backup file is in DB. |
| 948 | 948 | // If YES then it is encrypted with DEFUSE |
| 949 | - $bck = DB::queryFirstRow('SELECT valeur FROM ' . prefixTable('misc') . ' WHERE type = %s AND intitule = %s', 'backup', 'filename'); |
|
| 949 | + $bck = DB::queryFirstRow('SELECT valeur FROM '.prefixTable('misc').' WHERE type = %s AND intitule = %s', 'backup', 'filename'); |
|
| 950 | 950 | |
| 951 | 951 | //read file |
| 952 | 952 | $return = ''; |
| 953 | - $Fnm = $tp_settings['bck_script_path'] . '/' . $filename . '.sql'; |
|
| 953 | + $Fnm = $tp_settings['bck_script_path'].'/'.$filename.'.sql'; |
|
| 954 | 954 | if (file_exists($Fnm)) { |
| 955 | 955 | if (!empty($bck) && $bck['valeur'] === $filename) { |
| 956 | 956 | $err = ''; |
| 957 | 957 | |
| 958 | 958 | // it means that file is DEFUSE encrypted |
| 959 | - include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Encryption/Encryption/Crypto.php'; |
|
| 960 | - include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Encryption/Encryption/DerivedKeys.php'; |
|
| 961 | - include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Encryption/Encryption/KeyOrPassword.php'; |
|
| 962 | - include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Encryption/Encryption/File.php'; |
|
| 963 | - include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Encryption/Encryption/Core.php'; |
|
| 959 | + include_once $SETTINGS['cpassman_dir'].'/includes/libraries/Encryption/Encryption/Crypto.php'; |
|
| 960 | + include_once $SETTINGS['cpassman_dir'].'/includes/libraries/Encryption/Encryption/DerivedKeys.php'; |
|
| 961 | + include_once $SETTINGS['cpassman_dir'].'/includes/libraries/Encryption/Encryption/KeyOrPassword.php'; |
|
| 962 | + include_once $SETTINGS['cpassman_dir'].'/includes/libraries/Encryption/Encryption/File.php'; |
|
| 963 | + include_once $SETTINGS['cpassman_dir'].'/includes/libraries/Encryption/Encryption/Core.php'; |
|
| 964 | 964 | |
| 965 | 965 | try { |
| 966 | 966 | \Defuse\Crypto\File::decryptFileWithPassword( |
| 967 | - $SETTINGS['bck_script_path'] . '/' . $post_option . '.sql', |
|
| 968 | - $SETTINGS['bck_script_path'] . '/' . str_replace('encrypted', 'clear', $filename) . '.sql', |
|
| 967 | + $SETTINGS['bck_script_path'].'/'.$post_option.'.sql', |
|
| 968 | + $SETTINGS['bck_script_path'].'/'.str_replace('encrypted', 'clear', $filename).'.sql', |
|
| 969 | 969 | base64_decode($SETTINGS['bck_script_key']) |
| 970 | 970 | ); |
| 971 | 971 | } catch (Defuse\Crypto\Exception\WrongKeyOrModifiedCiphertextException $ex) { |
@@ -973,7 +973,7 @@ discard block |
||
| 973 | 973 | } |
| 974 | 974 | |
| 975 | 975 | if (!empty($err)) { |
| 976 | - echo '[{ "result":"backup_decrypt_fails" , "msg":"' . $err . '"}]'; |
|
| 976 | + echo '[{ "result":"backup_decrypt_fails" , "msg":"'.$err.'"}]'; |
|
| 977 | 977 | break; |
| 978 | 978 | } |
| 979 | 979 | } else { |
@@ -995,19 +995,19 @@ discard block |
||
| 995 | 995 | ); |
| 996 | 996 | |
| 997 | 997 | //save the file |
| 998 | - $handle = fopen($tp_settings['bck_script_path'] . '/' . $filename . '.clear.sql', 'w+'); |
|
| 998 | + $handle = fopen($tp_settings['bck_script_path'].'/'.$filename.'.clear.sql', 'w+'); |
|
| 999 | 999 | if ($handle !== false) { |
| 1000 | 1000 | fwrite($handle, $return); |
| 1001 | 1001 | fclose($handle); |
| 1002 | 1002 | } |
| 1003 | 1003 | } |
| 1004 | 1004 | $result = 'backup_decrypt_success'; |
| 1005 | - $msg = $tp_settings['bck_script_path'] . '/' . $filename . '.clear.sql'; |
|
| 1005 | + $msg = $tp_settings['bck_script_path'].'/'.$filename.'.clear.sql'; |
|
| 1006 | 1006 | } else { |
| 1007 | 1007 | $result = 'backup_decrypt_fails'; |
| 1008 | - $msg = 'File not found: ' . $Fnm; |
|
| 1008 | + $msg = 'File not found: '.$Fnm; |
|
| 1009 | 1009 | } |
| 1010 | - echo '[{ "result":"' . $result . '" , "msg":"' . $msg . '"}]'; |
|
| 1010 | + echo '[{ "result":"'.$result.'" , "msg":"'.$msg.'"}]'; |
|
| 1011 | 1011 | break; |
| 1012 | 1012 | |
| 1013 | 1013 | /* |
@@ -1041,22 +1041,22 @@ discard block |
||
| 1041 | 1041 | require_once 'main.functions.php'; |
| 1042 | 1042 | |
| 1043 | 1043 | // store old sk |
| 1044 | - $_SESSION['reencrypt_old_salt'] = file_get_contents(SECUREPATH . '/teampass-seckey.txt'); |
|
| 1044 | + $_SESSION['reencrypt_old_salt'] = file_get_contents(SECUREPATH.'/teampass-seckey.txt'); |
|
| 1045 | 1045 | |
| 1046 | 1046 | // generate new saltkey |
| 1047 | - $old_sk_filename = SECUREPATH . '/teampass-seckey.txt.' . date('Y_m_d', mktime(0, 0, 0, (int) date('m'), (int) date('d'), (int) date('y'))) . '.' . time(); |
|
| 1047 | + $old_sk_filename = SECUREPATH.'/teampass-seckey.txt.'.date('Y_m_d', mktime(0, 0, 0, (int) date('m'), (int) date('d'), (int) date('y'))).'.'.time(); |
|
| 1048 | 1048 | copy( |
| 1049 | - SECUREPATH . '/teampass-seckey.txt', |
|
| 1049 | + SECUREPATH.'/teampass-seckey.txt', |
|
| 1050 | 1050 | $old_sk_filename |
| 1051 | 1051 | ); |
| 1052 | 1052 | $new_key = defuse_generate_key(); |
| 1053 | 1053 | file_put_contents( |
| 1054 | - SECUREPATH . '/teampass-seckey.txt', |
|
| 1054 | + SECUREPATH.'/teampass-seckey.txt', |
|
| 1055 | 1055 | $new_key |
| 1056 | 1056 | ); |
| 1057 | 1057 | |
| 1058 | 1058 | // store new sk |
| 1059 | - $_SESSION['reencrypt_new_salt'] = file_get_contents(SECUREPATH . '/teampass-seckey.txt'); |
|
| 1059 | + $_SESSION['reencrypt_new_salt'] = file_get_contents(SECUREPATH.'/teampass-seckey.txt'); |
|
| 1060 | 1060 | |
| 1061 | 1061 | //put tool in maintenance. |
| 1062 | 1062 | DB::update( |
@@ -1072,13 +1072,13 @@ discard block |
||
| 1072 | 1072 | logEvents($SETTINGS, 'system', 'change_salt_key', (string) $_SESSION['user_id'], $_SESSION['login']); |
| 1073 | 1073 | |
| 1074 | 1074 | // get number of items to change |
| 1075 | - DB::query('SELECT id FROM ' . prefixTable('items') . ' WHERE perso = %i', 0); |
|
| 1075 | + DB::query('SELECT id FROM '.prefixTable('items').' WHERE perso = %i', 0); |
|
| 1076 | 1076 | $nb_of_items = DB::count(); |
| 1077 | 1077 | |
| 1078 | 1078 | // create backup table |
| 1079 | - DB::query('DROP TABLE IF EXISTS ' . prefixTable('sk_reencrypt_backup')); |
|
| 1079 | + DB::query('DROP TABLE IF EXISTS '.prefixTable('sk_reencrypt_backup')); |
|
| 1080 | 1080 | DB::query( |
| 1081 | - 'CREATE TABLE `' . prefixTable('sk_reencrypt_backup') . '` ( |
|
| 1081 | + 'CREATE TABLE `'.prefixTable('sk_reencrypt_backup').'` ( |
|
| 1082 | 1082 | `id` int(12) NOT null AUTO_INCREMENT, |
| 1083 | 1083 | `current_table` varchar(100) NOT NULL, |
| 1084 | 1084 | `current_field` varchar(500) NOT NULL, |
@@ -1106,7 +1106,7 @@ discard block |
||
| 1106 | 1106 | ); |
| 1107 | 1107 | |
| 1108 | 1108 | // delete previous backup files |
| 1109 | - $files = glob($SETTINGS['path_to_upload_folder'] . '/*'); // get all file names |
|
| 1109 | + $files = glob($SETTINGS['path_to_upload_folder'].'/*'); // get all file names |
|
| 1110 | 1110 | foreach ($files as $file) { // iterate files |
| 1111 | 1111 | if (is_file($file)) { |
| 1112 | 1112 | $file_parts = pathinfo($file); |
@@ -1188,7 +1188,7 @@ discard block |
||
| 1188 | 1188 | echo prepareExchangedData( |
| 1189 | 1189 | array( |
| 1190 | 1190 | 'error' => true, |
| 1191 | - 'message' => 'Input `' . $objects[0] . '` is not allowed', |
|
| 1191 | + 'message' => 'Input `'.$objects[0].'` is not allowed', |
|
| 1192 | 1192 | 'nbOfItems' => '', |
| 1193 | 1193 | 'nextAction' => '', |
| 1194 | 1194 | ), |
@@ -1201,9 +1201,9 @@ discard block |
||
| 1201 | 1201 | //change all encrypted data in Items (passwords) |
| 1202 | 1202 | $rows = DB::query( |
| 1203 | 1203 | 'SELECT id, pw, pw_iv |
| 1204 | - FROM ' . prefixTable('items') . ' |
|
| 1204 | + FROM ' . prefixTable('items').' |
|
| 1205 | 1205 | WHERE perso = %s |
| 1206 | - LIMIT ' . $post_start . ', ' . $post_length, |
|
| 1206 | + LIMIT ' . $post_start.', '.$post_length, |
|
| 1207 | 1207 | '0' |
| 1208 | 1208 | ); |
| 1209 | 1209 | foreach ($rows as $record) { |
@@ -1215,7 +1215,7 @@ discard block |
||
| 1215 | 1215 | 'current_field' => 'pw', |
| 1216 | 1216 | 'value_id' => $record['id'], |
| 1217 | 1217 | 'value' => $record['pw'], |
| 1218 | - 'current_sql' => 'UPDATE ' . prefixTable('items') . " SET pw = '" . $record['pw'] . "' WHERE id = '" . $record['id'] . "';", |
|
| 1218 | + 'current_sql' => 'UPDATE '.prefixTable('items')." SET pw = '".$record['pw']."' WHERE id = '".$record['id']."';", |
|
| 1219 | 1219 | 'value2' => 'none', |
| 1220 | 1220 | 'result' => 'none', |
| 1221 | 1221 | ) |
@@ -1264,9 +1264,9 @@ discard block |
||
| 1264 | 1264 | //change all encrypted data in Logs (passwords) |
| 1265 | 1265 | $rows = DB::query( |
| 1266 | 1266 | 'SELECT raison, increment_id |
| 1267 | - FROM ' . prefixTable('log_items') . " |
|
| 1267 | + FROM ' . prefixTable('log_items')." |
|
| 1268 | 1268 | WHERE action = %s AND raison LIKE 'at_pw :%' |
| 1269 | - LIMIT " . $post_start . ', ' . $post_length, |
|
| 1269 | + LIMIT " . $post_start.', '.$post_length, |
|
| 1270 | 1270 | 'at_modification' |
| 1271 | 1271 | ); |
| 1272 | 1272 | foreach ($rows as $record) { |
@@ -1278,7 +1278,7 @@ discard block |
||
| 1278 | 1278 | 'current_field' => 'raison', |
| 1279 | 1279 | 'value_id' => $record['increment_id'], |
| 1280 | 1280 | 'value' => $record['raison'], |
| 1281 | - 'current_sql' => 'UPDATE ' . prefixTable('log_items') . " SET raison = '" . $record['raison'] . "' WHERE increment_id = '" . $record['increment_id'] . "';", |
|
| 1281 | + 'current_sql' => 'UPDATE '.prefixTable('log_items')." SET raison = '".$record['raison']."' WHERE increment_id = '".$record['increment_id']."';", |
|
| 1282 | 1282 | 'value2' => 'none', |
| 1283 | 1283 | 'result' => 'none', |
| 1284 | 1284 | ) |
@@ -1306,7 +1306,7 @@ discard block |
||
| 1306 | 1306 | DB::update( |
| 1307 | 1307 | prefixTable('log_items'), |
| 1308 | 1308 | array( |
| 1309 | - 'raison' => 'at_pw :' . $encrypt['string'], |
|
| 1309 | + 'raison' => 'at_pw :'.$encrypt['string'], |
|
| 1310 | 1310 | 'encryption_type' => 'defuse', |
| 1311 | 1311 | ), |
| 1312 | 1312 | 'increment_id = %i', |
@@ -1331,8 +1331,8 @@ discard block |
||
| 1331 | 1331 | //change all encrypted data in CATEGORIES (passwords) |
| 1332 | 1332 | $rows = DB::query( |
| 1333 | 1333 | 'SELECT id, data |
| 1334 | - FROM ' . prefixTable('categories_items') . ' |
|
| 1335 | - LIMIT ' . $post_start . ', ' . $post_length |
|
| 1334 | + FROM ' . prefixTable('categories_items').' |
|
| 1335 | + LIMIT ' . $post_start.', '.$post_length |
|
| 1336 | 1336 | ); |
| 1337 | 1337 | foreach ($rows as $record) { |
| 1338 | 1338 | // backup data |
@@ -1343,7 +1343,7 @@ discard block |
||
| 1343 | 1343 | 'current_field' => 'data', |
| 1344 | 1344 | 'value_id' => $record['id'], |
| 1345 | 1345 | 'value' => $record['data'], |
| 1346 | - 'current_sql' => 'UPDATE ' . prefixTable('categories_items') . " SET data = '" . $record['data'] . "' WHERE id = '" . $record['id'] . "';", |
|
| 1346 | + 'current_sql' => 'UPDATE '.prefixTable('categories_items')." SET data = '".$record['data']."' WHERE id = '".$record['id']."';", |
|
| 1347 | 1347 | 'value2' => 'none', |
| 1348 | 1348 | 'result' => 'none', |
| 1349 | 1349 | ) |
@@ -1391,9 +1391,9 @@ discard block |
||
| 1391 | 1391 | // Change all encrypted data in FILES (passwords) |
| 1392 | 1392 | $rows = DB::query( |
| 1393 | 1393 | 'SELECT id, file, status |
| 1394 | - FROM ' . prefixTable('files') . " |
|
| 1394 | + FROM ' . prefixTable('files')." |
|
| 1395 | 1395 | WHERE status = 'encrypted' |
| 1396 | - LIMIT " . $post_start . ', ' . $post_length |
|
| 1396 | + LIMIT " . $post_start.', '.$post_length |
|
| 1397 | 1397 | ); |
| 1398 | 1398 | foreach ($rows as $record) { |
| 1399 | 1399 | // backup data |
@@ -1411,20 +1411,20 @@ discard block |
||
| 1411 | 1411 | ); |
| 1412 | 1412 | $newID = DB::insertId(); |
| 1413 | 1413 | |
| 1414 | - if (file_exists($SETTINGS['path_to_upload_folder'] . '/' . $record['file'])) { |
|
| 1414 | + if (file_exists($SETTINGS['path_to_upload_folder'].'/'.$record['file'])) { |
|
| 1415 | 1415 | // make a copy of file |
| 1416 | 1416 | if (!copy( |
| 1417 | - $SETTINGS['path_to_upload_folder'] . '/' . $record['file'], |
|
| 1418 | - $SETTINGS['path_to_upload_folder'] . '/' . $record['file'] . '.copy' |
|
| 1417 | + $SETTINGS['path_to_upload_folder'].'/'.$record['file'], |
|
| 1418 | + $SETTINGS['path_to_upload_folder'].'/'.$record['file'].'.copy' |
|
| 1419 | 1419 | )) { |
| 1420 | 1420 | $error = 'Copy not possible'; |
| 1421 | 1421 | exit; |
| 1422 | 1422 | } else { |
| 1423 | 1423 | // prepare a bck of file (that will not be deleted) |
| 1424 | - $backup_filename = $record['file'] . '.bck-change-sk.' . time(); |
|
| 1424 | + $backup_filename = $record['file'].'.bck-change-sk.'.time(); |
|
| 1425 | 1425 | copy( |
| 1426 | - $SETTINGS['path_to_upload_folder'] . '/' . $record['file'], |
|
| 1427 | - $SETTINGS['path_to_upload_folder'] . '/' . $backup_filename |
|
| 1426 | + $SETTINGS['path_to_upload_folder'].'/'.$record['file'], |
|
| 1427 | + $SETTINGS['path_to_upload_folder'].'/'.$backup_filename |
|
| 1428 | 1428 | ); |
| 1429 | 1429 | } |
| 1430 | 1430 | |
@@ -1432,24 +1432,24 @@ discard block |
||
| 1432 | 1432 | // STEP1 - Do decryption |
| 1433 | 1433 | prepareFileWithDefuse( |
| 1434 | 1434 | 'decrypt', |
| 1435 | - $SETTINGS['path_to_upload_folder'] . '/' . $record['file'], |
|
| 1436 | - $SETTINGS['path_to_upload_folder'] . '/' . $record['file'] . '_encrypted', |
|
| 1435 | + $SETTINGS['path_to_upload_folder'].'/'.$record['file'], |
|
| 1436 | + $SETTINGS['path_to_upload_folder'].'/'.$record['file'].'_encrypted', |
|
| 1437 | 1437 | $SETTINGS |
| 1438 | 1438 | ); |
| 1439 | 1439 | |
| 1440 | 1440 | // Do cleanup of files |
| 1441 | - unlink($SETTINGS['path_to_upload_folder'] . '/' . $record['file']); |
|
| 1441 | + unlink($SETTINGS['path_to_upload_folder'].'/'.$record['file']); |
|
| 1442 | 1442 | |
| 1443 | 1443 | // STEP2 - Do encryption |
| 1444 | 1444 | prepareFileWithDefuse( |
| 1445 | 1445 | 'encryp', |
| 1446 | - $SETTINGS['path_to_upload_folder'] . '/' . $record['file'] . '_encrypted', |
|
| 1447 | - $SETTINGS['path_to_upload_folder'] . '/' . $record['file'], |
|
| 1446 | + $SETTINGS['path_to_upload_folder'].'/'.$record['file'].'_encrypted', |
|
| 1447 | + $SETTINGS['path_to_upload_folder'].'/'.$record['file'], |
|
| 1448 | 1448 | $SETTINGS |
| 1449 | 1449 | ); |
| 1450 | 1450 | |
| 1451 | 1451 | // Do cleanup of files |
| 1452 | - unlink($SETTINGS['path_to_upload_folder'] . '/' . $record['file'] . '_encrypted'); |
|
| 1452 | + unlink($SETTINGS['path_to_upload_folder'].'/'.$record['file'].'_encrypted'); |
|
| 1453 | 1453 | |
| 1454 | 1454 | // Update backup table |
| 1455 | 1455 | DB::update( |
@@ -1475,13 +1475,13 @@ discard block |
||
| 1475 | 1475 | // do some things for new object |
| 1476 | 1476 | if (isset($objects[0])) { |
| 1477 | 1477 | if ($objects[0] === 'logs') { |
| 1478 | - DB::query('SELECT increment_id FROM ' . prefixTable('log_items') . " WHERE action = %s AND raison LIKE 'at_pw :%'", 'at_modification'); |
|
| 1478 | + DB::query('SELECT increment_id FROM '.prefixTable('log_items')." WHERE action = %s AND raison LIKE 'at_pw :%'", 'at_modification'); |
|
| 1479 | 1479 | } elseif ($objects[0] === 'files') { |
| 1480 | - DB::query('SELECT id FROM ' . prefixTable('files')); |
|
| 1480 | + DB::query('SELECT id FROM '.prefixTable('files')); |
|
| 1481 | 1481 | } elseif ($objects[0] === 'categories') { |
| 1482 | - DB::query('SELECT id FROM ' . prefixTable('categories_items')); |
|
| 1482 | + DB::query('SELECT id FROM '.prefixTable('categories_items')); |
|
| 1483 | 1483 | } elseif ($objects[0] === 'custfields') { |
| 1484 | - DB::query('SELECT raison FROM ' . prefixTable('log_items') . " WHERE action = %s AND raison LIKE 'at_pw :%'", 'at_modification'); |
|
| 1484 | + DB::query('SELECT raison FROM '.prefixTable('log_items')." WHERE action = %s AND raison LIKE 'at_pw :%'", 'at_modification'); |
|
| 1485 | 1485 | } |
| 1486 | 1486 | $nb_of_items = DB::count(); |
| 1487 | 1487 | } else { |
@@ -1600,12 +1600,12 @@ discard block |
||
| 1600 | 1600 | ); |
| 1601 | 1601 | } elseif ($record['current_table'] === 'files') { |
| 1602 | 1602 | // restore backup file |
| 1603 | - if (file_exists($SETTINGS['path_to_upload_folder'] . '/' . $record['value'])) { |
|
| 1604 | - unlink($SETTINGS['path_to_upload_folder'] . '/' . $record['value']); |
|
| 1605 | - if (file_exists($SETTINGS['path_to_upload_folder'] . '/' . $record['value2'])) { |
|
| 1603 | + if (file_exists($SETTINGS['path_to_upload_folder'].'/'.$record['value'])) { |
|
| 1604 | + unlink($SETTINGS['path_to_upload_folder'].'/'.$record['value']); |
|
| 1605 | + if (file_exists($SETTINGS['path_to_upload_folder'].'/'.$record['value2'])) { |
|
| 1606 | 1606 | rename( |
| 1607 | - $SETTINGS['path_to_upload_folder'] . '/' . $record['value2'], |
|
| 1608 | - $SETTINGS['path_to_upload_folder'] . '/' . $record['value'] |
|
| 1607 | + $SETTINGS['path_to_upload_folder'].'/'.$record['value2'], |
|
| 1608 | + $SETTINGS['path_to_upload_folder'].'/'.$record['value'] |
|
| 1609 | 1609 | ); |
| 1610 | 1610 | } |
| 1611 | 1611 | } |
@@ -1616,15 +1616,15 @@ discard block |
||
| 1616 | 1616 | |
| 1617 | 1617 | // restore saltkey file |
| 1618 | 1618 | if (file_exists($previous_saltkey_filename)) { |
| 1619 | - unlink(SECUREPATH . '/teampass-seckey.txt'); |
|
| 1619 | + unlink(SECUREPATH.'/teampass-seckey.txt'); |
|
| 1620 | 1620 | rename( |
| 1621 | 1621 | $previous_saltkey_filename, |
| 1622 | - SECUREPATH . '/teampass-seckey.txt' |
|
| 1622 | + SECUREPATH.'/teampass-seckey.txt' |
|
| 1623 | 1623 | ); |
| 1624 | 1624 | } |
| 1625 | 1625 | |
| 1626 | 1626 | // drop table |
| 1627 | - DB::query('DROP TABLE IF EXISTS ' . prefixTable('sk_reencrypt_backup')); |
|
| 1627 | + DB::query('DROP TABLE IF EXISTS '.prefixTable('sk_reencrypt_backup')); |
|
| 1628 | 1628 | |
| 1629 | 1629 | // Send back |
| 1630 | 1630 | echo prepareExchangedData( |
@@ -1667,17 +1667,17 @@ discard block |
||
| 1667 | 1667 | // delete files |
| 1668 | 1668 | $rows = DB::query( |
| 1669 | 1669 | 'SELECT value, value2 |
| 1670 | - FROM ' . prefixTable('sk_reencrypt_backup') . " |
|
| 1670 | + FROM ' . prefixTable('sk_reencrypt_backup')." |
|
| 1671 | 1671 | WHERE current_table = 'files'" |
| 1672 | 1672 | ); |
| 1673 | 1673 | foreach ($rows as $record) { |
| 1674 | - if (file_exists($SETTINGS['path_to_upload_folder'] . '/' . $record['value2'])) { |
|
| 1675 | - unlink($SETTINGS['path_to_upload_folder'] . '/' . $record['value2']); |
|
| 1674 | + if (file_exists($SETTINGS['path_to_upload_folder'].'/'.$record['value2'])) { |
|
| 1675 | + unlink($SETTINGS['path_to_upload_folder'].'/'.$record['value2']); |
|
| 1676 | 1676 | } |
| 1677 | 1677 | } |
| 1678 | 1678 | |
| 1679 | 1679 | // drop table |
| 1680 | - DB::query('DROP TABLE IF EXISTS ' . prefixTable('sk_reencrypt_backup')); |
|
| 1680 | + DB::query('DROP TABLE IF EXISTS '.prefixTable('sk_reencrypt_backup')); |
|
| 1681 | 1681 | |
| 1682 | 1682 | echo '[{"status":"done"}]'; |
| 1683 | 1683 | break; |
@@ -1709,7 +1709,7 @@ discard block |
||
| 1709 | 1709 | ); |
| 1710 | 1710 | break; |
| 1711 | 1711 | } else { |
| 1712 | - require_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php'; |
|
| 1712 | + require_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php'; |
|
| 1713 | 1713 | |
| 1714 | 1714 | //send email |
| 1715 | 1715 | sendEmail( |
@@ -1745,11 +1745,11 @@ discard block |
||
| 1745 | 1745 | break; |
| 1746 | 1746 | } |
| 1747 | 1747 | |
| 1748 | - include_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php'; |
|
| 1748 | + include_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php'; |
|
| 1749 | 1749 | |
| 1750 | 1750 | $rows = DB::query( |
| 1751 | 1751 | 'SELECT * |
| 1752 | - FROM ' . prefixTable('emails') . ' |
|
| 1752 | + FROM ' . prefixTable('emails').' |
|
| 1753 | 1753 | WHERE status = %s OR status = %s', |
| 1754 | 1754 | 'not_sent', |
| 1755 | 1755 | '' |
@@ -1834,9 +1834,9 @@ discard block |
||
| 1834 | 1834 | break; |
| 1835 | 1835 | } |
| 1836 | 1836 | |
| 1837 | - include_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php'; |
|
| 1837 | + include_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php'; |
|
| 1838 | 1838 | |
| 1839 | - $rows = DB::query('SELECT * FROM ' . prefixTable('emails') . ' WHERE status = %s OR status = %s', 'not_sent', ''); |
|
| 1839 | + $rows = DB::query('SELECT * FROM '.prefixTable('emails').' WHERE status = %s OR status = %s', 'not_sent', ''); |
|
| 1840 | 1840 | foreach ($rows as $record) { |
| 1841 | 1841 | //send email |
| 1842 | 1842 | $ret = json_decode( |
@@ -1904,7 +1904,7 @@ discard block |
||
| 1904 | 1904 | break; |
| 1905 | 1905 | } |
| 1906 | 1906 | |
| 1907 | - require_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php'; |
|
| 1907 | + require_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php'; |
|
| 1908 | 1908 | |
| 1909 | 1909 | // init |
| 1910 | 1910 | $filesList = array(); |
@@ -1917,7 +1917,7 @@ discard block |
||
| 1917 | 1917 | FROM ' . prefixTable('files') |
| 1918 | 1918 | ); |
| 1919 | 1919 | foreach ($rows as $record) { |
| 1920 | - if (is_file($SETTINGS['path_to_upload_folder'] . '/' . $record['file'])) { |
|
| 1920 | + if (is_file($SETTINGS['path_to_upload_folder'].'/'.$record['file'])) { |
|
| 1921 | 1921 | $addFile = false; |
| 1922 | 1922 | if (($post_option === 'attachments-decrypt' && $record['status'] === 'encrypted') |
| 1923 | 1923 | || ($post_option === 'attachments-encrypt' && $record['status'] === 'clear') |
@@ -1982,8 +1982,8 @@ discard block |
||
| 1982 | 1982 | $post_list = filter_var_array($post_list, FILTER_SANITIZE_STRING); |
| 1983 | 1983 | $post_counter = filter_var($post_counter, FILTER_SANITIZE_NUMBER_INT); |
| 1984 | 1984 | |
| 1985 | - include $SETTINGS['cpassman_dir'] . '/includes/config/settings.php'; |
|
| 1986 | - include_once $SETTINGS['cpassman_dir'] . '/sources/main.functions.php'; |
|
| 1985 | + include $SETTINGS['cpassman_dir'].'/includes/config/settings.php'; |
|
| 1986 | + include_once $SETTINGS['cpassman_dir'].'/sources/main.functions.php'; |
|
| 1987 | 1987 | |
| 1988 | 1988 | $cpt = 0; |
| 1989 | 1989 | $continu = true; |
@@ -1991,15 +1991,15 @@ discard block |
||
| 1991 | 1991 | $message = ''; |
| 1992 | 1992 | |
| 1993 | 1993 | // load PhpEncryption library |
| 1994 | - include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Encryption/Encryption/Crypto.php'; |
|
| 1995 | - include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Encryption/Encryption/Encoding.php'; |
|
| 1996 | - include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Encryption/Encryption/DerivedKeys.php'; |
|
| 1997 | - include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Encryption/Encryption/Key.php'; |
|
| 1998 | - include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Encryption/Encryption/KeyOrPassword.php'; |
|
| 1999 | - include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Encryption/Encryption/File.php'; |
|
| 2000 | - include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Encryption/Encryption/RuntimeTests.php'; |
|
| 2001 | - include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Encryption/Encryption/KeyProtectedByPassword.php'; |
|
| 2002 | - include_once $SETTINGS['cpassman_dir'] . '/includes/libraries/Encryption/Encryption/Core.php'; |
|
| 1994 | + include_once $SETTINGS['cpassman_dir'].'/includes/libraries/Encryption/Encryption/Crypto.php'; |
|
| 1995 | + include_once $SETTINGS['cpassman_dir'].'/includes/libraries/Encryption/Encryption/Encoding.php'; |
|
| 1996 | + include_once $SETTINGS['cpassman_dir'].'/includes/libraries/Encryption/Encryption/DerivedKeys.php'; |
|
| 1997 | + include_once $SETTINGS['cpassman_dir'].'/includes/libraries/Encryption/Encryption/Key.php'; |
|
| 1998 | + include_once $SETTINGS['cpassman_dir'].'/includes/libraries/Encryption/Encryption/KeyOrPassword.php'; |
|
| 1999 | + include_once $SETTINGS['cpassman_dir'].'/includes/libraries/Encryption/Encryption/File.php'; |
|
| 2000 | + include_once $SETTINGS['cpassman_dir'].'/includes/libraries/Encryption/Encryption/RuntimeTests.php'; |
|
| 2001 | + include_once $SETTINGS['cpassman_dir'].'/includes/libraries/Encryption/Encryption/KeyProtectedByPassword.php'; |
|
| 2002 | + include_once $SETTINGS['cpassman_dir'].'/includes/libraries/Encryption/Encryption/Core.php'; |
|
| 2003 | 2003 | |
| 2004 | 2004 | // treat 10 files |
| 2005 | 2005 | foreach ($post_list as $file) { |
@@ -2007,35 +2007,35 @@ discard block |
||
| 2007 | 2007 | // Get file name |
| 2008 | 2008 | $file_info = DB::queryfirstrow( |
| 2009 | 2009 | 'SELECT file |
| 2010 | - FROM ' . prefixTable('files') . ' |
|
| 2010 | + FROM ' . prefixTable('files').' |
|
| 2011 | 2011 | WHERE id = %i', |
| 2012 | 2012 | $file |
| 2013 | 2013 | ); |
| 2014 | 2014 | |
| 2015 | 2015 | // skip file is Coherancey not respected |
| 2016 | - if (is_file($SETTINGS['path_to_upload_folder'] . '/' . $file_info['file'])) { |
|
| 2016 | + if (is_file($SETTINGS['path_to_upload_folder'].'/'.$file_info['file'])) { |
|
| 2017 | 2017 | // Case where we want to decrypt |
| 2018 | 2018 | if ($post_option === 'decrypt') { |
| 2019 | 2019 | prepareFileWithDefuse( |
| 2020 | 2020 | 'decrypt', |
| 2021 | - $SETTINGS['path_to_upload_folder'] . '/' . $file_info['file'], |
|
| 2022 | - $SETTINGS['path_to_upload_folder'] . '/defuse_temp_' . $file_info['file'], |
|
| 2021 | + $SETTINGS['path_to_upload_folder'].'/'.$file_info['file'], |
|
| 2022 | + $SETTINGS['path_to_upload_folder'].'/defuse_temp_'.$file_info['file'], |
|
| 2023 | 2023 | $SETTINGS |
| 2024 | 2024 | ); |
| 2025 | 2025 | // Case where we want to encrypt |
| 2026 | 2026 | } elseif ($post_option === 'encrypt') { |
| 2027 | 2027 | prepareFileWithDefuse( |
| 2028 | 2028 | 'encrypt', |
| 2029 | - $SETTINGS['path_to_upload_folder'] . '/' . $file_info['file'], |
|
| 2030 | - $SETTINGS['path_to_upload_folder'] . '/defuse_temp_' . $file_info['file'], |
|
| 2029 | + $SETTINGS['path_to_upload_folder'].'/'.$file_info['file'], |
|
| 2030 | + $SETTINGS['path_to_upload_folder'].'/defuse_temp_'.$file_info['file'], |
|
| 2031 | 2031 | $SETTINGS |
| 2032 | 2032 | ); |
| 2033 | 2033 | } |
| 2034 | 2034 | // Do file cleanup |
| 2035 | - fileDelete($SETTINGS['path_to_upload_folder'] . '/' . $file_info['file'], $SETTINGS); |
|
| 2035 | + fileDelete($SETTINGS['path_to_upload_folder'].'/'.$file_info['file'], $SETTINGS); |
|
| 2036 | 2036 | rename( |
| 2037 | - $SETTINGS['path_to_upload_folder'] . '/defuse_temp_' . $file_info['file'], |
|
| 2038 | - $SETTINGS['path_to_upload_folder'] . '/' . $file_info['file'] |
|
| 2037 | + $SETTINGS['path_to_upload_folder'].'/defuse_temp_'.$file_info['file'], |
|
| 2038 | + $SETTINGS['path_to_upload_folder'].'/'.$file_info['file'] |
|
| 2039 | 2039 | ); |
| 2040 | 2040 | |
| 2041 | 2041 | // store in DB |
@@ -2070,8 +2070,8 @@ discard block |
||
| 2070 | 2070 | $post_option === 'attachments-decrypt' ? 'clear' : 'encrypted' |
| 2071 | 2071 | ); |
| 2072 | 2072 | |
| 2073 | - $message = langHdl('last_execution') . ' ' . |
|
| 2074 | - date($SETTINGS['date_format'] . ' ' . $SETTINGS['time_format'], (int) time()) . |
|
| 2073 | + $message = langHdl('last_execution').' '. |
|
| 2074 | + date($SETTINGS['date_format'].' '.$SETTINGS['time_format'], (int) time()). |
|
| 2075 | 2075 | '<i class="fas fa-check text-success ml-2 mr-3"></i>'; |
| 2076 | 2076 | } |
| 2077 | 2077 | |
@@ -2157,7 +2157,7 @@ discard block |
||
| 2157 | 2157 | $post_id = filter_var($dataReceived['id'], FILTER_SANITIZE_STRING); |
| 2158 | 2158 | |
| 2159 | 2159 | DB::query( |
| 2160 | - 'DELETE FROM ' . prefixTable('api') . ' WHERE id = %i', |
|
| 2160 | + 'DELETE FROM '.prefixTable('api').' WHERE id = %i', |
|
| 2161 | 2161 | $post_id |
| 2162 | 2162 | ); |
| 2163 | 2163 | } |
@@ -2249,7 +2249,7 @@ discard block |
||
| 2249 | 2249 | // Delete existing key |
| 2250 | 2250 | } elseif (null !== $post_action && $post_action === 'delete') { |
| 2251 | 2251 | $post_id = filter_var($dataReceived['id'], FILTER_SANITIZE_STRING); |
| 2252 | - DB::query('DELETE FROM ' . prefixTable('api') . ' WHERE id=%i', $post_id); |
|
| 2252 | + DB::query('DELETE FROM '.prefixTable('api').' WHERE id=%i', $post_id); |
|
| 2253 | 2253 | } |
| 2254 | 2254 | |
| 2255 | 2255 | echo prepareExchangedData( |
@@ -2264,7 +2264,7 @@ discard block |
||
| 2264 | 2264 | |
| 2265 | 2265 | case 'save_api_status': |
| 2266 | 2266 | // Do query |
| 2267 | - DB::query('SELECT * FROM ' . prefixTable('misc') . ' WHERE type = %s AND intitule = %s', 'admin', 'api'); |
|
| 2267 | + DB::query('SELECT * FROM '.prefixTable('misc').' WHERE type = %s AND intitule = %s', 'admin', 'api'); |
|
| 2268 | 2268 | $counter = DB::count(); |
| 2269 | 2269 | if ($counter === 0) { |
| 2270 | 2270 | DB::insert( |
@@ -2290,7 +2290,7 @@ discard block |
||
| 2290 | 2290 | break; |
| 2291 | 2291 | |
| 2292 | 2292 | case 'save_duo_status': |
| 2293 | - DB::query('SELECT * FROM ' . prefixTable('misc') . ' WHERE type = %s AND intitule = %s', 'admin', 'duo'); |
|
| 2293 | + DB::query('SELECT * FROM '.prefixTable('misc').' WHERE type = %s AND intitule = %s', 'admin', 'duo'); |
|
| 2294 | 2294 | $counter = DB::count(); |
| 2295 | 2295 | if ($counter === 0) { |
| 2296 | 2296 | DB::insert( |
@@ -2333,7 +2333,7 @@ discard block |
||
| 2333 | 2333 | foreach ($dataReceived as $key => $value) { |
| 2334 | 2334 | DB::query( |
| 2335 | 2335 | 'SELECT * |
| 2336 | - FROM ' . prefixTable('misc') . ' |
|
| 2336 | + FROM ' . prefixTable('misc').' |
|
| 2337 | 2337 | WHERE type = %s AND intitule = %s', |
| 2338 | 2338 | 'admin', |
| 2339 | 2339 | $key |
@@ -2401,7 +2401,7 @@ discard block |
||
| 2401 | 2401 | } else { |
| 2402 | 2402 | $tmp = 1; |
| 2403 | 2403 | } |
| 2404 | - DB::query('SELECT * FROM ' . prefixTable('misc') . ' WHERE type = %s AND intitule = %s', 'admin', 'google_authentication'); |
|
| 2404 | + DB::query('SELECT * FROM '.prefixTable('misc').' WHERE type = %s AND intitule = %s', 'admin', 'google_authentication'); |
|
| 2405 | 2405 | $counter = DB::count(); |
| 2406 | 2406 | if ($counter === 0) { |
| 2407 | 2407 | DB::insert( |
@@ -2427,7 +2427,7 @@ discard block |
||
| 2427 | 2427 | |
| 2428 | 2428 | // ga_website_name |
| 2429 | 2429 | if (is_null($dataReceived['ga_website_name']) === false) { |
| 2430 | - DB::query('SELECT * FROM ' . prefixTable('misc') . ' WHERE type = %s AND intitule = %s', 'admin', 'ga_website_name'); |
|
| 2430 | + DB::query('SELECT * FROM '.prefixTable('misc').' WHERE type = %s AND intitule = %s', 'admin', 'ga_website_name'); |
|
| 2431 | 2431 | $counter = DB::count(); |
| 2432 | 2432 | if ($counter === 0) { |
| 2433 | 2433 | DB::insert( |
@@ -2458,7 +2458,7 @@ discard block |
||
| 2458 | 2458 | } |
| 2459 | 2459 | |
| 2460 | 2460 | // send data |
| 2461 | - echo '[{"result" : "' . addslashes($LANG['done']) . '" , "error" : ""}]'; |
|
| 2461 | + echo '[{"result" : "'.addslashes($LANG['done']).'" , "error" : ""}]'; |
|
| 2462 | 2462 | break; |
| 2463 | 2463 | |
| 2464 | 2464 | case 'save_agses_options': |
@@ -2481,7 +2481,7 @@ discard block |
||
| 2481 | 2481 | |
| 2482 | 2482 | // agses_hosted_url |
| 2483 | 2483 | if (!is_null($dataReceived['agses_hosted_url'])) { |
| 2484 | - DB::query('SELECT * FROM ' . prefixTable('misc') . ' WHERE type = %s AND intitule = %s', 'admin', 'agses_hosted_url'); |
|
| 2484 | + DB::query('SELECT * FROM '.prefixTable('misc').' WHERE type = %s AND intitule = %s', 'admin', 'agses_hosted_url'); |
|
| 2485 | 2485 | $counter = DB::count(); |
| 2486 | 2486 | if ($counter === 0) { |
| 2487 | 2487 | DB::insert( |
@@ -2510,7 +2510,7 @@ discard block |
||
| 2510 | 2510 | |
| 2511 | 2511 | // agses_hosted_id |
| 2512 | 2512 | if (!is_null($dataReceived['agses_hosted_id'])) { |
| 2513 | - DB::query('SELECT * FROM ' . prefixTable('misc') . ' WHERE type = %s AND intitule = %s', 'admin', 'agses_hosted_id'); |
|
| 2513 | + DB::query('SELECT * FROM '.prefixTable('misc').' WHERE type = %s AND intitule = %s', 'admin', 'agses_hosted_id'); |
|
| 2514 | 2514 | $counter = DB::count(); |
| 2515 | 2515 | if ($counter === 0) { |
| 2516 | 2516 | DB::insert( |
@@ -2539,7 +2539,7 @@ discard block |
||
| 2539 | 2539 | |
| 2540 | 2540 | // agses_hosted_apikey |
| 2541 | 2541 | if (!is_null($dataReceived['agses_hosted_apikey'])) { |
| 2542 | - DB::query('SELECT * FROM ' . prefixTable('misc') . ' WHERE type = %s AND intitule = %s', 'admin', 'agses_hosted_apikey'); |
|
| 2542 | + DB::query('SELECT * FROM '.prefixTable('misc').' WHERE type = %s AND intitule = %s', 'admin', 'agses_hosted_apikey'); |
|
| 2543 | 2543 | $counter = DB::count(); |
| 2544 | 2544 | if ($counter === 0) { |
| 2545 | 2545 | DB::insert( |
@@ -2567,7 +2567,7 @@ discard block |
||
| 2567 | 2567 | } |
| 2568 | 2568 | |
| 2569 | 2569 | // send data |
| 2570 | - echo '[{"result" : "' . addslashes($LANG['done']) . '" , "error" : ""}]'; |
|
| 2570 | + echo '[{"result" : "'.addslashes($LANG['done']).'" , "error" : ""}]'; |
|
| 2571 | 2571 | break; |
| 2572 | 2572 | |
| 2573 | 2573 | case 'save_option_change': |
@@ -2603,7 +2603,7 @@ discard block |
||
| 2603 | 2603 | |
| 2604 | 2604 | // Check if setting is already in DB. If NO then insert, if YES then update. |
| 2605 | 2605 | $data = DB::query( |
| 2606 | - 'SELECT * FROM ' . prefixTable('misc') . ' |
|
| 2606 | + 'SELECT * FROM '.prefixTable('misc').' |
|
| 2607 | 2607 | WHERE type = %s AND intitule = %s', |
| 2608 | 2608 | $type, |
| 2609 | 2609 | $dataReceived['field'] |
@@ -2625,7 +2625,7 @@ discard block |
||
| 2625 | 2625 | array( |
| 2626 | 2626 | 'valeur' => time(), |
| 2627 | 2627 | 'type' => $type, |
| 2628 | - 'intitule' => $dataReceived['field'] . '_time', |
|
| 2628 | + 'intitule' => $dataReceived['field'].'_time', |
|
| 2629 | 2629 | ) |
| 2630 | 2630 | ); |
| 2631 | 2631 | } |
@@ -2643,10 +2643,10 @@ discard block |
||
| 2643 | 2643 | if ($dataReceived['field'] === 'send_stats') { |
| 2644 | 2644 | // Check if previous time exists, if not them insert this value in DB |
| 2645 | 2645 | DB::query( |
| 2646 | - 'SELECT * FROM ' . prefixTable('misc') . ' |
|
| 2646 | + 'SELECT * FROM '.prefixTable('misc').' |
|
| 2647 | 2647 | WHERE type = %s AND intitule = %s', |
| 2648 | 2648 | $type, |
| 2649 | - $dataReceived['field'] . '_time' |
|
| 2649 | + $dataReceived['field'].'_time' |
|
| 2650 | 2650 | ); |
| 2651 | 2651 | $counter = DB::count(); |
| 2652 | 2652 | if ($counter === 0) { |
@@ -2655,7 +2655,7 @@ discard block |
||
| 2655 | 2655 | array( |
| 2656 | 2656 | 'valeur' => 0, |
| 2657 | 2657 | 'type' => $type, |
| 2658 | - 'intitule' => $dataReceived['field'] . '_time', |
|
| 2658 | + 'intitule' => $dataReceived['field'].'_time', |
|
| 2659 | 2659 | ) |
| 2660 | 2660 | ); |
| 2661 | 2661 | } else { |
@@ -2675,13 +2675,13 @@ discard block |
||
| 2675 | 2675 | // special Cases |
| 2676 | 2676 | if ($dataReceived['field'] === 'cpassman_url') { |
| 2677 | 2677 | // update also jsUrl for CSFP protection |
| 2678 | - $jsUrl = $dataReceived['value'] . '/includes/libraries/csrfp/js/csrfprotector.js'; |
|
| 2678 | + $jsUrl = $dataReceived['value'].'/includes/libraries/csrfp/js/csrfprotector.js'; |
|
| 2679 | 2679 | $csrfp_file = '../includes/libraries/csrfp/libs/csrfp.config.php'; |
| 2680 | 2680 | $data = file_get_contents($csrfp_file); |
| 2681 | 2681 | $posJsUrl = strpos($data, '"jsUrl" => "'); |
| 2682 | 2682 | $posEndLine = strpos($data, '",', $posJsUrl); |
| 2683 | 2683 | $line = substr($data, $posJsUrl, ($posEndLine - $posJsUrl + 2)); |
| 2684 | - $newdata = str_replace($line, '"jsUrl" => "' . filter_var($jsUrl, FILTER_SANITIZE_STRING) . '",', $data); |
|
| 2684 | + $newdata = str_replace($line, '"jsUrl" => "'.filter_var($jsUrl, FILTER_SANITIZE_STRING).'",', $data); |
|
| 2685 | 2685 | file_put_contents($csrfp_file, $newdata); |
| 2686 | 2686 | } elseif ($dataReceived['field'] === 'restricted_to_input' && $dataReceived['value'] === '0') { |
| 2687 | 2687 | DB::update( |
@@ -2705,7 +2705,7 @@ discard block |
||
| 2705 | 2705 | echo prepareExchangedData( |
| 2706 | 2706 | array( |
| 2707 | 2707 | 'error' => false, |
| 2708 | - 'misc' => $counter . ' ; ' . $SETTINGS[$dataReceived['field']], |
|
| 2708 | + 'misc' => $counter.' ; '.$SETTINGS[$dataReceived['field']], |
|
| 2709 | 2709 | ), |
| 2710 | 2710 | 'encode' |
| 2711 | 2711 | ); |
@@ -2747,7 +2747,7 @@ discard block |
||
| 2747 | 2747 | |
| 2748 | 2748 | // send statistics |
| 2749 | 2749 | if (null !== $post_status) { |
| 2750 | - DB::query('SELECT * FROM ' . prefixTable('misc') . ' WHERE type = %s AND intitule = %s', 'admin', 'send_stats'); |
|
| 2750 | + DB::query('SELECT * FROM '.prefixTable('misc').' WHERE type = %s AND intitule = %s', 'admin', 'send_stats'); |
|
| 2751 | 2751 | $counter = DB::count(); |
| 2752 | 2752 | if ($counter === 0) { |
| 2753 | 2753 | DB::insert( |
@@ -2779,7 +2779,7 @@ discard block |
||
| 2779 | 2779 | |
| 2780 | 2780 | // send statistics items |
| 2781 | 2781 | if (null !== $post_list) { |
| 2782 | - DB::query('SELECT * FROM ' . prefixTable('misc') . ' WHERE type = %s AND intitule = %s', 'admin', 'send_statistics_items'); |
|
| 2782 | + DB::query('SELECT * FROM '.prefixTable('misc').' WHERE type = %s AND intitule = %s', 'admin', 'send_statistics_items'); |
|
| 2783 | 2783 | $counter = DB::count(); |
| 2784 | 2784 | if ($counter === 0) { |
| 2785 | 2785 | DB::insert( |
@@ -2826,7 +2826,7 @@ discard block |
||
| 2826 | 2826 | break; |
| 2827 | 2827 | } |
| 2828 | 2828 | |
| 2829 | - if (DB::query("SHOW TABLES LIKE '" . prefixTable('sk_reencrypt_backup') . "'")) { |
|
| 2829 | + if (DB::query("SHOW TABLES LIKE '".prefixTable('sk_reencrypt_backup')."'")) { |
|
| 2830 | 2830 | if (DB::count() === 1) { |
| 2831 | 2831 | echo 1; |
| 2832 | 2832 | } else { |
@@ -2864,7 +2864,7 @@ discard block |
||
| 2864 | 2864 | |
| 2865 | 2865 | $rows = DB::query( |
| 2866 | 2866 | 'SELECT id, title |
| 2867 | - FROM ' . prefixTable('roles_title') . ' |
|
| 2867 | + FROM ' . prefixTable('roles_title').' |
|
| 2868 | 2868 | ORDER BY title ASC' |
| 2869 | 2869 | ); |
| 2870 | 2870 | foreach ($rows as $record) { |
