nilsteampassnet / TeamPass

install--ASUPPRIMER/upgrade_run_3.1.php

Spacing +7 added lines, -7 removed lines

@@ -68,8 +68,8 @@ 
         $port
     );
 } else {
-    $res = 'Impossible to get connected to server. Error is: ' . addslashes(mysqli_connect_error());
-    echo '[{"finish":"1", "msg":"", "error":"Impossible to get connected to server. Error is: ' . addslashes(mysqli_connect_error()) . '!"}]';
+    $res = 'Impossible to get connected to server. Error is: '.addslashes(mysqli_connect_error());
+    echo '[{"finish":"1", "msg":"", "error":"Impossible to get connected to server. Error is: '.addslashes(mysqli_connect_error()).'!"}]';
     mysqli_close($db_link);
     exit();
 }
@@ -85,11 +85,11 @@ 
 
 // 
 // Add new setting 'enable_refresh_task_last_execution'
-$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT * FROM `" . $pre . "misc` WHERE type = 'admin' AND intitule = 'enable_refresh_task_last_execution'"));
+$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT * FROM `".$pre."misc` WHERE type = 'admin' AND intitule = 'enable_refresh_task_last_execution'"));
 if (intval($tmp) === 0) {
     mysqli_query(
         $db_link,
-        "INSERT INTO `" . $pre . "misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'enable_refresh_task_last_execution', '1')"
+        "INSERT INTO `".$pre."misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'enable_refresh_task_last_execution', '1')"
     );
 }
 
@@ -100,7 +100,7 @@ 
 // Add new table ITEMS_OTP
 mysqli_query(
     $db_link,
-    'CREATE TABLE IF NOT EXISTS `' . $pre . 'items_otp` (
+    'CREATE TABLE IF NOT EXISTS `'.$pre.'items_otp` (
     `increment_id` int(12) NOT NULL,
     `item_id` int(12) NOT NULL,
     `secret` text NOT NULL,
@@ -115,14 +115,14 @@ 
 // Alter table TOKENS
 mysqli_query(
     $db_link,
-    'ALTER TABLE `' . $pre . 'tokens` CHANGE `end_timestamp` `end_timestamp` VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL;'
+    'ALTER TABLE `'.$pre.'tokens` CHANGE `end_timestamp` `end_timestamp` VARCHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL;'
 );
 
 
 // Alter table ldap_groups_roles
 mysqli_query(
     $db_link,
-    'ALTER TABLE `' . $pre . 'ldap_groups_roles` CHANGE `ldap_group_id` `ldap_group_id` VARCHAR(500) NOT NULL;'
+    'ALTER TABLE `'.$pre.'ldap_groups_roles` CHANGE `ldap_group_id` `ldap_group_id` VARCHAR(500) NOT NULL;'
 );
 
 //---<END 3.1.1

install--ASUPPRIMER/upgrade_run_3.0.php

Spacing +96 added lines, -96 removed lines

@@ -70,8 +70,8 @@ 
         $port
     );
 } else {
-    $res = 'Impossible to get connected to server. Error is: ' . addslashes(mysqli_connect_error());
-    echo '[{"finish":"1", "msg":"", "error":"Impossible to get connected to server. Error is: ' . addslashes(mysqli_connect_error()) . '!"}]';
+    $res = 'Impossible to get connected to server. Error is: '.addslashes(mysqli_connect_error());
+    echo '[{"finish":"1", "msg":"", "error":"Impossible to get connected to server. Error is: '.addslashes(mysqli_connect_error()).'!"}]';
     mysqli_close($db_link);
     exit();
 }
@@ -101,12 +101,12 @@ 
 
 // Add the INDEX process_id_idx to the processes_tasks table
 $res = checkIndexExist(
-    $pre . 'processes_tasks',
+    $pre.'processes_tasks',
     'process_id_idx',
     "ADD KEY `process_id_idx` (`process_id`)"
 );
 if (!$res) {
-    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding the INDEX process_id_idx to the processes_tasks table! ' . mysqli_error($db_link) . '!"}]';
+    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding the INDEX process_id_idx to the processes_tasks table! '.mysqli_error($db_link).'!"}]';
     mysqli_close($db_link);
     exit();
 }
@@ -117,38 +117,38 @@ 
 
 //--->BEGIN 3.0.6
 // Add new setting 'sending_emails_job_frequency'
-$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT * FROM `" . $pre . "misc` WHERE type = 'admin' AND intitule = 'sending_emails_job_frequency'"));
+$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT * FROM `".$pre."misc` WHERE type = 'admin' AND intitule = 'sending_emails_job_frequency'"));
 if (intval($tmp) === 0) {
     mysqli_query(
         $db_link,
-        "INSERT INTO `" . $pre . "misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'sending_emails_job_frequency', '2')"
+        "INSERT INTO `".$pre."misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'sending_emails_job_frequency', '2')"
     );
 }
 // Add new setting 'user_keys_job_frequency'
-$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT * FROM `" . $pre . "misc` WHERE type = 'admin' AND intitule = 'user_keys_job_frequency'"));
+$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT * FROM `".$pre."misc` WHERE type = 'admin' AND intitule = 'user_keys_job_frequency'"));
 if (intval($tmp) === 0) {
     mysqli_query(
         $db_link,
-        "INSERT INTO `" . $pre . "misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'user_keys_job_frequency', '1')"
+        "INSERT INTO `".$pre."misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'user_keys_job_frequency', '1')"
     );
 }
 // Add new setting 'items_statistics_job_frequency'
-$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT * FROM `" . $pre . "misc` WHERE type = 'admin' AND intitule = 'enable_tasks_items_statistics_job_frequencymanager'"));
+$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT * FROM `".$pre."misc` WHERE type = 'admin' AND intitule = 'enable_tasks_items_statistics_job_frequencymanager'"));
 if (intval($tmp) === 0) {
     mysqli_query(
         $db_link,
-        "INSERT INTO `" . $pre . "misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'items_statistics_job_frequency', '5')"
+        "INSERT INTO `".$pre."misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'items_statistics_job_frequency', '5')"
     );
 }
 
 // Add field ongoing_process_id to USERS table
 $res = addColumnIfNotExist(
-    $pre . 'users',
+    $pre.'users',
     'ongoing_process_id',
     "varchar(100) NULL;"
 );
 if ($res === false) {
-    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field ongoing_process_id to table USERS! ' . mysqli_error($db_link) . '!"}]';
+    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field ongoing_process_id to table USERS! '.mysqli_error($db_link).'!"}]';
     mysqli_close($db_link);
     exit();
 }
@@ -161,7 +161,7 @@ 
 try {
     mysqli_query(
         $db_link,
-        'ALTER TABLE `' . $pre . 'cache_tree` CHANGE `data` `data` LONGTEXT DEFAULT NULL;'
+        'ALTER TABLE `'.$pre.'cache_tree` CHANGE `data` `data` LONGTEXT DEFAULT NULL;'
     );
 } catch (Exception $e) {
     // Do nothing
@@ -170,7 +170,7 @@ 
 // Fix for #3679
 mysqli_query(
     $db_link,
-    "UPDATE `" . $pre . "users` SET `treeloadstrategy` = 'full' WHERE treeloadstrategy NOT IN ('full','sequential');"
+    "UPDATE `".$pre."users` SET `treeloadstrategy` = 'full' WHERE treeloadstrategy NOT IN ('full','sequential');"
 );
 
 //---<END 3.0.7
@@ -180,12 +180,12 @@ 
 //--->BEGIN 3.0.8
 // Add field mfa_disabled to USERS table
 $res = addColumnIfNotExist(
-    $pre . 'users',
+    $pre.'users',
     'mfa_enabled',
     "tinyint(1) NOT null DEFAULT '1';"
 );
 if ($res === false) {
-    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field mfa_disabled to table USERS! ' . mysqli_error($db_link) . '!"}]';
+    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field mfa_disabled to table USERS! '.mysqli_error($db_link).'!"}]';
     mysqli_close($db_link);
     exit();
 }
@@ -196,124 +196,124 @@ 
 
 //--->BEGIN 3.0.9
 // Add new setting 'reload_cache_table_task'
-$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT * FROM `" . $pre . "misc` WHERE type = 'admin' AND intitule = 'reload_cache_table_task'"));
+$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT * FROM `".$pre."misc` WHERE type = 'admin' AND intitule = 'reload_cache_table_task'"));
 if (intval($tmp) === 0) {
     mysqli_query(
         $db_link,
-        "INSERT INTO `" . $pre . "misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'reload_cache_table_task', '')"
+        "INSERT INTO `".$pre."misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'reload_cache_table_task', '')"
     );
 }
 // Add new setting 'rebuild_config_file'
-$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT * FROM `" . $pre . "misc` WHERE type = 'admin' AND intitule = 'rebuild_config_file'"));
+$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT * FROM `".$pre."misc` WHERE type = 'admin' AND intitule = 'rebuild_config_file'"));
 if (intval($tmp) === 0) {
     mysqli_query(
         $db_link,
-        "INSERT INTO `" . $pre . "misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'rebuild_config_file', '')"
+        "INSERT INTO `".$pre."misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'rebuild_config_file', '')"
     );
 }// Add new setting 'purge_temporary_files_task'
-$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT * FROM `" . $pre . "misc` WHERE type = 'admin' AND intitule = 'purge_temporary_files_task'"));
+$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT * FROM `".$pre."misc` WHERE type = 'admin' AND intitule = 'purge_temporary_files_task'"));
 if (intval($tmp) === 0) {
     mysqli_query(
         $db_link,
-        "INSERT INTO `" . $pre . "misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'purge_temporary_files_task', '')"
+        "INSERT INTO `".$pre."misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'purge_temporary_files_task', '')"
     );
 }
 // Add new setting 'clean_orphan_objects_task'
-$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT * FROM `" . $pre . "misc` WHERE type = 'admin' AND intitule = 'clean_orphan_objects_task'"));
+$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT * FROM `".$pre."misc` WHERE type = 'admin' AND intitule = 'clean_orphan_objects_task'"));
 if (intval($tmp) === 0) {
     mysqli_query(
         $db_link,
-        "INSERT INTO `" . $pre . "misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'clean_orphan_objects_task', '')"
+        "INSERT INTO `".$pre."misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'clean_orphan_objects_task', '')"
     );
 }
 // Add new setting 'users_personal_folder_task'
-$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT * FROM `" . $pre . "misc` WHERE type = 'admin' AND intitule = 'users_personal_folder_task'"));
+$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT * FROM `".$pre."misc` WHERE type = 'admin' AND intitule = 'users_personal_folder_task'"));
 if (intval($tmp) === 0) {
     mysqli_query(
         $db_link,
-        "INSERT INTO `" . $pre . "misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'users_personal_folder_task', '')"
+        "INSERT INTO `".$pre."misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'users_personal_folder_task', '')"
     );
 }
 
 // Remove unused settings
 mysqli_query(
     $db_link,
-    "DELETE FROM `" . $pre . "misc` WHERE `intitule`='maintenance_job_tasks';"
+    "DELETE FROM `".$pre."misc` WHERE `intitule`='maintenance_job_tasks';"
 );
 mysqli_query(
     $db_link,
-    "DELETE FROM `" . $pre . "misc` WHERE `intitule`='maintenance_job_frequency';"
+    "DELETE FROM `".$pre."misc` WHERE `intitule`='maintenance_job_frequency';"
 );
 
 // Add field item_key to ITEMS table
 $res = addColumnIfNotExist(
-    $pre . 'items',
+    $pre.'items',
     'item_key',
     "varchar(500) NOT NULL DEFAULT '-1';"
 );
 if ($res === false) {
-    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field item_key to table ITEMS! ' . mysqli_error($db_link) . '!"}]';
+    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field item_key to table ITEMS! '.mysqli_error($db_link).'!"}]';
     mysqli_close($db_link);
     exit();
 }
 
 // Remove column unique from ITEMS table
 $res = removeColumnIfNotExist(
-    $pre . 'items',
+    $pre.'items',
     'unique'
 );
 
 // Add field export_tag to EXPORT table
 $res = addColumnIfNotExist(
-    $pre . 'export',
+    $pre.'export',
     'export_tag',
     "varchar(20) NOT NULL;"
 );
 if ($res === false) {
-    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field export_tag to table EXPORT! ' . mysqli_error($db_link) . '!"}]';
+    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field export_tag to table EXPORT! '.mysqli_error($db_link).'!"}]';
     mysqli_close($db_link);
     exit();
 }
 
 // Add field folder_id to EXPORT table
 $res = addColumnIfNotExist(
-    $pre . 'export',
+    $pre.'export',
     'folder_id',
     "varchar(10) NOT NULL;"
 );
 if ($res === false) {
-    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field folder_id to table EXPORT! ' . mysqli_error($db_link) . '!"}]';
+    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field folder_id to table EXPORT! '.mysqli_error($db_link).'!"}]';
     mysqli_close($db_link);
     exit();
 }
 
 // Add field perso to EXPORT table
 $res = addColumnIfNotExist(
-    $pre . 'export',
+    $pre.'export',
     'perso',
     "tinyint(1) NOT NULL default '0';"
 );
 if ($res === false) {
-    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field perso to table EXPORT! ' . mysqli_error($db_link) . '!"}]';
+    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field perso to table EXPORT! '.mysqli_error($db_link).'!"}]';
     mysqli_close($db_link);
     exit();
 }
 
 // Add field restricted_to to EXPORT table
 $res = addColumnIfNotExist(
-    $pre . 'export',
+    $pre.'export',
     'restricted_to',
     "varchar(200) DEFAULT NULL;"
 );
 if ($res === false) {
-    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field restricted_to to table EXPORT! ' . mysqli_error($db_link) . '!"}]';
+    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field restricted_to to table EXPORT! '.mysqli_error($db_link).'!"}]';
     mysqli_close($db_link);
     exit();
 }
 
 // Rename column id to item_id in EXPORT table
 changeColumnName(
-    $pre . 'export',
+    $pre.'export',
     'id',
     'item_id',
     "int(12) NOT NULL"
@@ -321,42 +321,42 @@ 
 
 // Add field created_at to USERS table
 $res = addColumnIfNotExist(
-    $pre . 'users',
+    $pre.'users',
     'created_at',
     "varchar(30) NULL;"
 );
 if ($res === false) {
-    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field created_at to table USERS! ' . mysqli_error($db_link) . '!"}]';
+    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field created_at to table USERS! '.mysqli_error($db_link).'!"}]';
     mysqli_close($db_link);
     exit();
 }
 
 // Add field updated_at to USERS table
 $res = addColumnIfNotExist(
-    $pre . 'users',
+    $pre.'users',
     'updated_at',
     "varchar(30) NULL;"
 );
 if ($res === false) {
-    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field updated_at to table USERS! ' . mysqli_error($db_link) . '!"}]';
+    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field updated_at to table USERS! '.mysqli_error($db_link).'!"}]';
     mysqli_close($db_link);
     exit();
 }
 
 // Add field deleted_at to USERS table
 $res = addColumnIfNotExist(
-    $pre . 'users',
+    $pre.'users',
     'deleted_at',
     "varchar(30) NULL;"
 );
 if ($res === false) {
-    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field deleted_at to table USERS! ' . mysqli_error($db_link) . '!"}]';
+    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field deleted_at to table USERS! '.mysqli_error($db_link).'!"}]';
     mysqli_close($db_link);
     exit();
 }
 
 // populate created_at, updated_at and deleted_at fields in USERS table
-$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT * FROM `" . $pre . "users` WHERE created_at IS NOT NULL"));
+$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT * FROM `".$pre."users` WHERE created_at IS NOT NULL"));
 if (intval($tmp) === 0) {
     populateUsersTable($pre);
 }
@@ -368,36 +368,36 @@ 
 
 // Add field created_at to ITEMS table
 $res = addColumnIfNotExist(
-    $pre . 'items',
+    $pre.'items',
     'created_at',
     "varchar(30) NULL;"
 );
 if ($res === false) {
-    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field created_at to table ITEMS! ' . mysqli_error($db_link) . '!"}]';
+    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field created_at to table ITEMS! '.mysqli_error($db_link).'!"}]';
     mysqli_close($db_link);
     exit();
 }
 
 // Add field updated_at to ITEMS table
 $res = addColumnIfNotExist(
-    $pre . 'items',
+    $pre.'items',
     'updated_at',
     "varchar(30) NULL;"
 );
 if ($res === false) {
-    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field updated_at to table ITEMS! ' . mysqli_error($db_link) . '!"}]';
+    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field updated_at to table ITEMS! '.mysqli_error($db_link).'!"}]';
     mysqli_close($db_link);
     exit();
 }
 
 // Add field deleted_at to ITEMS table
 $res = addColumnIfNotExist(
-    $pre . 'items',
+    $pre.'items',
     'deleted_at',
     "varchar(30) NULL;"
 );
 if ($res === false) {
-    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field deleted_at to table ITEMS! ' . mysqli_error($db_link) . '!"}]';
+    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field deleted_at to table ITEMS! '.mysqli_error($db_link).'!"}]';
     mysqli_close($db_link);
     exit();
 }
@@ -406,29 +406,29 @@ 
 try {
     mysqli_query(
         $db_link,
-        'ALTER TABLE `' . $pre . 'processes` CHANGE `process_type` `process_type` VARCHAR(100) NOT NULL;'
+        'ALTER TABLE `'.$pre.'processes` CHANGE `process_type` `process_type` VARCHAR(100) NOT NULL;'
     );
 } catch (Exception $e) {
     // Do nothing
 }
 
 // Add new setting 'maximum_session_expiration_time'
-$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT * FROM `" . $pre . "misc` WHERE type = 'admin' AND intitule = 'maximum_session_expiration_time'"));
+$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT * FROM `".$pre."misc` WHERE type = 'admin' AND intitule = 'maximum_session_expiration_time'"));
 if (intval($tmp) === 0) {
     mysqli_query(
         $db_link,
-        "INSERT INTO `" . $pre . "misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'maximum_session_expiration_time', '60')"
+        "INSERT INTO `".$pre."misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'maximum_session_expiration_time', '60')"
     );
 }
 
 // Add field treated_objects to processes_logs table
 $res = addColumnIfNotExist(
-    $pre . 'processes_logs',
+    $pre.'processes_logs',
     'treated_objects',
     "varchar(20) NULL;"
 );
 if ($res === false) {
-    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field treated_objects to table processes_logs! ' . mysqli_error($db_link) . '!"}]';
+    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field treated_objects to table processes_logs! '.mysqli_error($db_link).'!"}]';
     mysqli_close($db_link);
     exit();
 }
@@ -437,7 +437,7 @@ 
 $resAdmin = mysqli_query(
     $db_link,
     "select name, lastname
-    from `" . $pre . "users`
+    from `" . $pre."users`
     WHERE id = 1"
 );
 $admin = mysqli_fetch_array($resAdmin);
@@ -445,54 +445,54 @@ 
     // update created_at field
     mysqli_query(
         $db_link,
-        "UPDATE `" . $pre . "users` SET name = 'Change me', lastname = 'Change me' WHERE id = 1"
+        "UPDATE `".$pre."users` SET name = 'Change me', lastname = 'Change me' WHERE id = 1"
     );
 }
 
 // Add field started_at to processes table
 $res = addColumnIfNotExist(
-    $pre . 'processes',
+    $pre.'processes',
     'started_at',
     "varchar(50) NULL;"
 );
 if ($res === false) {
-    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field started_at to table processes! ' . mysqli_error($db_link) . '!"}]';
+    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field started_at to table processes! '.mysqli_error($db_link).'!"}]';
     mysqli_close($db_link);
     exit();
 }
 
 // Add field views to otv table
 $res = addColumnIfNotExist(
-    $pre . 'otv',
+    $pre.'otv',
     'views',
     "INT(10) NOT NULL DEFAULT '0';"
 );
 if ($res === false) {
-    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field views to table otv! ' . mysqli_error($db_link) . '!"}]';
+    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field views to table otv! '.mysqli_error($db_link).'!"}]';
     mysqli_close($db_link);
     exit();
 }
 
 // Add field max_views to otv table
 $res = addColumnIfNotExist(
-    $pre . 'otv',
+    $pre.'otv',
     'max_views',
     "INT(10) NULL DEFAULT NULL;"
 );
 if ($res === false) {
-    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field max_views to table otv! ' . mysqli_error($db_link) . '!"}]';
+    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field max_views to table otv! '.mysqli_error($db_link).'!"}]';
     mysqli_close($db_link);
     exit();
 }
 
 // Add field time_limit to otv table
 $res = addColumnIfNotExist(
-    $pre . 'otv',
+    $pre.'otv',
     'time_limit',
     "varchar(100) DEFAULT NULL;"
 );
 if ($res === false) {
-    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field time_limit to table otv! ' . mysqli_error($db_link) . '!"}]';
+    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field time_limit to table otv! '.mysqli_error($db_link).'!"}]';
     mysqli_close($db_link);
     exit();
 }
@@ -500,14 +500,14 @@ 
 // delete old otv
 mysqli_query(
     $db_link,
-    "DELETE FROM `" . $pre . "otv` WHERE max_views IS NULL;"
+    "DELETE FROM `".$pre."otv` WHERE max_views IS NULL;"
 );
 
 // Alter encrypted_psk in Users
 try {
     mysqli_query(
         $db_link,
-        'ALTER TABLE `' . $pre . 'users` CHANGE `encrypted_psk` `encrypted_psk` text NULL DEFAULT NULL;'
+        'ALTER TABLE `'.$pre.'users` CHANGE `encrypted_psk` `encrypted_psk` text NULL DEFAULT NULL;'
     );
 } catch (Exception $e) {
     // Do nothing
@@ -517,7 +517,7 @@ 
 try {
     mysqli_query(
         $db_link,
-        'ALTER TABLE `' . $pre . 'items` CHANGE `url` `url` TEXT NULL DEFAULT NULL;'
+        'ALTER TABLE `'.$pre.'items` CHANGE `url` `url` TEXT NULL DEFAULT NULL;'
     );
 } catch (Exception $e) {
     // Do nothing
@@ -527,7 +527,7 @@ 
 try {
     mysqli_query(
         $db_link,
-        'ALTER TABLE `' . $pre . 'cache` CHANGE `url` `url` TEXT NULL DEFAULT NULL;'
+        'ALTER TABLE `'.$pre.'cache` CHANGE `url` `url` TEXT NULL DEFAULT NULL;'
     );
 } catch (Exception $e) {
     // Do nothing
@@ -535,12 +535,12 @@ 
 
 // Add field item_id to processes table
 $res = addColumnIfNotExist(
-    $pre . 'processes',
+    $pre.'processes',
     'item_id',
     "INT(12) NULL;"
 );
 if ($res === false) {
-    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field item_id to table processes! ' . mysqli_error($db_link) . '!"}]';
+    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field item_id to table processes! '.mysqli_error($db_link).'!"}]';
     mysqli_close($db_link);
     exit();
 }
@@ -549,18 +549,18 @@ 
 try {
     mysqli_query(
         $db_link,
-        'ALTER TABLE `' . $pre . 'users` CHANGE `login` `login` VARCHAR(500) NOT NULL;'
+        'ALTER TABLE `'.$pre.'users` CHANGE `login` `login` VARCHAR(500) NOT NULL;'
     );
 } catch (Exception $e) {
     // Do nothing
 }
 
 // Add new setting 'items_ops_job_frequency'
-$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT * FROM `" . $pre . "misc` WHERE type = 'admin' AND intitule = 'items_ops_job_frequency'"));
+$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT * FROM `".$pre."misc` WHERE type = 'admin' AND intitule = 'items_ops_job_frequency'"));
 if (intval($tmp) === 0) {
     mysqli_query(
         $db_link,
-        "INSERT INTO `" . $pre . "misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'items_ops_job_frequency', '1')"
+        "INSERT INTO `".$pre."misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'items_ops_job_frequency', '1')"
     );
 }
 
@@ -568,7 +568,7 @@ 
 try {
     mysqli_query(
         $db_link,
-        'ALTER TABLE `' . $pre . 'log_items` CHANGE `raison_iv` `old_value` MEDIUMTEXT NULL DEFAULT NULL;'
+        'ALTER TABLE `'.$pre.'log_items` CHANGE `raison_iv` `old_value` MEDIUMTEXT NULL DEFAULT NULL;'
     );
 } catch (Exception $e) {
     // Do nothing
@@ -578,7 +578,7 @@ 
 try {
     mysqli_query(
         $db_link,
-        'ALTER TABLE `' . $pre . 'cache` CHANGE `description` `description` MEDIUMTEXT NULL DEFAULT NULL;'
+        'ALTER TABLE `'.$pre.'cache` CHANGE `description` `description` MEDIUMTEXT NULL DEFAULT NULL;'
     );
 } catch (Exception $e) {
     // Do nothing
@@ -586,24 +586,24 @@ 
 
 // Add field shared_globaly to otv table
 $res = addColumnIfNotExist(
-    $pre . 'otv',
+    $pre.'otv',
     'shared_globaly',
     "INT(1) NOT NULL DEFAULT '0';"
 );
 if ($res === false) {
-    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field shared_globaly to table otv! ' . mysqli_error($db_link) . '!"}]';
+    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field shared_globaly to table otv! '.mysqli_error($db_link).'!"}]';
     mysqli_close($db_link);
     exit();
 }
 
 // Add field keys_recovery_time to users table
 $res = addColumnIfNotExist(
-    $pre . 'users',
+    $pre.'users',
     'keys_recovery_time',
     "VARCHAR(500) NULL DEFAULT NULL;"
 );
 if ($res === false) {
-    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field keys_recovery_time to table users! ' . mysqli_error($db_link) . '!"}]';
+    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field keys_recovery_time to table users! '.mysqli_error($db_link).'!"}]';
     mysqli_close($db_link);
     exit();
 }
@@ -612,7 +612,7 @@ 
 try {
     mysqli_query(
         $db_link,
-        'ALTER TABLE `' . $pre . 'users` CHANGE `favourites` `favourites` varchar(1000) NULL DEFAULT NULL;'
+        'ALTER TABLE `'.$pre.'users` CHANGE `favourites` `favourites` varchar(1000) NULL DEFAULT NULL;'
     );
 } catch (Exception $e) {
     // Do nothing
@@ -620,12 +620,12 @@ 
 
 // Add field aes_iv to users table
 $res = addColumnIfNotExist(
-    $pre . 'users',
+    $pre.'users',
     'aes_iv',
     "TEXT NULL DEFAULT NULL;"
 );
 if ($res === false) {
-    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field aes_iv to table users! ' . mysqli_error($db_link) . '!"}]';
+    echo '[{"finish":"1", "msg":"", "error":"An error appears when adding field aes_iv to table users! '.mysqli_error($db_link).'!"}]';
     mysqli_close($db_link);
     exit();
 }
@@ -634,7 +634,7 @@ 
 try {
     mysqli_query(
         $db_link,
-        'ALTER TABLE `' . $pre . 'users` CHANGE `psk` `psk` VARCHAR(400) NULL DEFAULT NULL;'
+        'ALTER TABLE `'.$pre.'users` CHANGE `psk` `psk` VARCHAR(400) NULL DEFAULT NULL;'
     );
 } catch (Exception $e) {
     // Do nothing
@@ -642,7 +642,7 @@ 
 
 // Now removing all old libraries
 deleteAll([
-    "Illuminate","Encryption","Tightenco","portable-ascii-master","Pdf","ForceUTF8","portable-utf8-master","GO","Symfony","Elegant","Firebase","Database","anti-xss-master","LdapRecord","misc","PasswordGenerator","Authentication","Goodby","Plupload","PHPMailer","TiBeN","protect","Cron","PasswordLib","Fork","Carbon","Tree","Webmozart"
+    "Illuminate", "Encryption", "Tightenco", "portable-ascii-master", "Pdf", "ForceUTF8", "portable-utf8-master", "GO", "Symfony", "Elegant", "Firebase", "Database", "anti-xss-master", "LdapRecord", "misc", "PasswordGenerator", "Authentication", "Goodby", "Plupload", "PHPMailer", "TiBeN", "protect", "Cron", "PasswordLib", "Fork", "Carbon", "Tree", "Webmozart"
 ]);
 
 //---<END 3.0.10
@@ -650,16 +650,16 @@ 
 //---------------------------------------------------------------------
 
 // Save timestamp
-$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT * FROM `" . $pre . "misc` WHERE type = 'admin' AND intitule = 'upgrade_timestamp'"));
+$tmp = mysqli_num_rows(mysqli_query($db_link, "SELECT * FROM `".$pre."misc` WHERE type = 'admin' AND intitule = 'upgrade_timestamp'"));
 if (intval($tmp) === 0) {
     mysqli_query(
         $db_link,
-        "INSERT INTO `" . $pre . "misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'upgrade_timestamp', ".time().")"
+        "INSERT INTO `".$pre."misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'upgrade_timestamp', ".time().")"
     );
 } else {
     mysqli_query(
         $db_link,
-        "UPDATE `" . $pre . "misc` SET valeur = ".time()." WHERE type = 'admin' AND intitule = 'upgrade_timestamp'"
+        "UPDATE `".$pre."misc` SET valeur = ".time()." WHERE type = 'admin' AND intitule = 'upgrade_timestamp'"
     );
 }
 
@@ -681,8 +681,8 @@ 
     $users = mysqli_query(
         $db_link,
         "select u.id as uid, ls.date as datetime
-        from `" . $pre . "users` as u
-        inner join `" . $pre . "log_system` as ls on ls.field_1 = u.id
+        from `" . $pre."users` as u
+        inner join `" . $pre."log_system` as ls on ls.field_1 = u.id
         WHERE ls.type = 'user_mngt' AND ls.label = 'at_user_added'"
     );
     while ($user = mysqli_fetch_assoc($users)) {
@@ -690,7 +690,7 @@ 
             // update created_at field
             mysqli_query(
                 $db_link,
-                "UPDATE `" . $pre . "users` SET created_at = '".$user['datetime']."' WHERE id = ".$user['uid']
+                "UPDATE `".$pre."users` SET created_at = '".$user['datetime']."' WHERE id = ".$user['uid']
             );
         }
     }
@@ -698,14 +698,14 @@ 
     // loop on users - updated_at
     $users = mysqli_query(
         $db_link,
-        "select u.id as uid, (select date from " . $pre . "log_system where type = 'user_mngt' and field_1=uid order by date DESC limit 1) as datetime from `" . $pre . "users` as u;"
+        "select u.id as uid, (select date from ".$pre."log_system where type = 'user_mngt' and field_1=uid order by date DESC limit 1) as datetime from `".$pre."users` as u;"
     );
     while ($user = mysqli_fetch_assoc($users)) {
         if (empty((string) $user['datetime']) === false && is_null($user['datetime']) === false) {
             // update updated_at field
             mysqli_query(
                 $db_link,
-                "UPDATE `" . $pre . "users` SET updated_at = '".$user['datetime']."' WHERE id = ".$user['uid']
+                "UPDATE `".$pre."users` SET updated_at = '".$user['datetime']."' WHERE id = ".$user['uid']
             );
         }
     }

install--ASUPPRIMER/libs/SecureHandler.php

Spacing +8 added lines, -8 removed lines

@@ -25,13 +25,13 @@ 
      */
     public function __construct()
     {
-        if (! extension_loaded('openssl')) {
+        if (!extension_loaded('openssl')) {
             throw new \RuntimeException(sprintf(
                 "You need the OpenSSL extension to use %s",
                 __CLASS__
             ));
         }
-        if (! extension_loaded('mbstring')) {
+        if (!extension_loaded('mbstring')) {
             throw new \RuntimeException(sprintf(
                 "You need the Multibytes extension to use %s",
                 __CLASS__
@@ -47,7 +47,7 @@ 
      */
     public function open($save_path, $session_name): bool
     {
-        $this->key = $this->getKey('KEY_' . $session_name);
+        $this->key = $this->getKey('KEY_'.$session_name);
         return parent::open($save_path, $session_name);
     }
 
@@ -94,11 +94,11 @@ 
         // Authentication
         $hmac = hash_hmac(
             'SHA256',
-            $iv . $ciphertext,
+            $iv.$ciphertext,
             mb_substr($key, 32, null, '8bit'),
             true
         );
-        return $hmac . $iv . $ciphertext;
+        return $hmac.$iv.$ciphertext;
     }
 
     /**
@@ -116,11 +116,11 @@ 
         // Authentication
         $hmacNew = hash_hmac(
             'SHA256',
-            $iv . $ciphertext,
+            $iv.$ciphertext,
             mb_substr($key, 32, null, '8bit'),
             true
         );
-        if (! hash_equals($hmac, $hmacNew)) {
+        if (!hash_equals($hmac, $hmacNew)) {
             throw new Exception\AuthenticationFailedException('Authentication failed');
         }
         // Decrypt
@@ -148,7 +148,7 @@ 
             // if session cookie lifetime > 0 then add to current time
             // otherwise leave it as zero, honoring zero's special meaning
             // expire at browser close.
-            $arr_cookie_options = array (
+            $arr_cookie_options = array(
                 'expires' => ($cookieParam['lifetime'] > 0) ? time() + $cookieParam['lifetime'] : 0,
                 'path' => '/',
                 'secure' => true,

install--ASUPPRIMER/upgrade_ajax.php

Indentation +7 added lines, -7 removed lines

@@ -66,7 +66,7 @@ 
 
 // Do we need to rewrite the settings.php file?
 if (defined("DB_PASSWD") === false) {
-	$settingsFile = '../includes/config/settings.php';
+    $settingsFile = '../includes/config/settings.php';
     if (null !== SECUREPATH) { //3.0.0.23
         //Do a copy of the existing file
         if (!copy(
@@ -191,17 +191,17 @@ 
 define("SECUREPATH", "' . str_replace('\\', '\\\\', SECUREPATH) . '");';
 define("SECUREFILE", "' . SECUREFILE. '");
 
-		if (defined('IKEY') === true) $settingsTxt .= '
+        if (defined('IKEY') === true) $settingsTxt .= '
 define("IKEY", "' . IKEY . '");';
-		else $settingsTxt .= '
+        else $settingsTxt .= '
 define("IKEY", "");';
-		if (defined('SKEY') === true) $settingsTxt .= '
+        if (defined('SKEY') === true) $settingsTxt .= '
 define("SKEY", "' . SKEY . '");';
-		else $settingsTxt .= '
+        else $settingsTxt .= '
 define("SKEY", "");';
-		if (defined('HOST') === true) $settingsTxt .= '
+        if (defined('HOST') === true) $settingsTxt .= '
 define("HOST", "' . HOST . '");';
-		else $settingsTxt .= '
+        else $settingsTxt .= '
 define("HOST", "");';
 
 

Spacing +143 added lines, -143 removed lines

@@ -71,7 +71,7 @@ 
         //Do a copy of the existing file
         if (!copy(
             $settingsFile,
-            $settingsFile . '.' . date(
+            $settingsFile.'.'.date(
                 'Y_m_d_H_i_s',
                 mktime((int) date('H'), (int) date('i'), (int) date('s'), (int) date('m'), (int) date('d'), (int) date('y'))
             )
@@ -88,7 +88,7 @@ 
         // CHeck if old sk.php exists.
         // If yes then get keys to database and delete it
         if (empty($post_sk_path) === false || defined('SECUREPATH') === true) {
-            $filename = (empty($post_sk_path) === false ? $post_sk_path : SECUREPATH) . '/sk.php';
+            $filename = (empty($post_sk_path) === false ? $post_sk_path : SECUREPATH).'/sk.php';
             if (file_exists($filename)) {
                 include_once $filename;
                 unlink($filename);
@@ -97,63 +97,63 @@ 
                 // SKEY
                 $tmp = mysqli_query(
                     $db_link,
-                    "SELECT INTO `" . $pre . "misc`
+                    "SELECT INTO `".$pre."misc`
                     WHERE type = 'admin' AND intitule = 'duo_skey'"
                 );
                 if ($tmp) {
                     mysqli_query(
                         $db_link,
-                        "UPDATE `" . $pre . "misc`
-                        set valeur = '" . SKEY . "', type = 'admin', intitule = 'duo_skey'"
+                        "UPDATE `".$pre."misc`
+                        set valeur = '" . SKEY."', type = 'admin', intitule = 'duo_skey'"
                     );
                 } else {
                     mysqli_query(
                         $db_link,
-                        "INSERT INTO `" . $pre . "misc`
+                        "INSERT INTO `".$pre."misc`
                         (`valeur`, `type`, `intitule`)
-                        VALUES ('" . SKEY . "', 'admin', 'duo_skey')"
+                        VALUES ('" . SKEY."', 'admin', 'duo_skey')"
                     );
                 }
 
                 // IKEY
                 $tmp = mysqli_query(
                     $db_link,
-                    "SELECT INTO `" . $pre . "misc`
+                    "SELECT INTO `".$pre."misc`
                     WHERE type = 'admin' AND intitule = 'duo_ikey'"
                 );
                 if ($tmp) {
                     mysqli_query(
                         $db_link,
-                        "UPDATE `" . $pre . "misc`
-                        set valeur = '" . IKEY . "', type = 'admin', intitule = 'duo_ikey'"
+                        "UPDATE `".$pre."misc`
+                        set valeur = '" . IKEY."', type = 'admin', intitule = 'duo_ikey'"
                     );
                 } else {
                     mysqli_query(
                         $db_link,
-                        "INSERT INTO `" . $pre . "misc`
+                        "INSERT INTO `".$pre."misc`
                         (`valeur`, `type`, `intitule`)
-                        VALUES ('" . IKEY . "', 'admin', 'duo_ikey')"
+                        VALUES ('" . IKEY."', 'admin', 'duo_ikey')"
                     );
                 }
 
                 // HOST
                 $tmp = mysqli_query(
                     $db_link,
-                    "SELECT INTO `" . $pre . "misc`
+                    "SELECT INTO `".$pre."misc`
                     WHERE type = 'admin' AND intitule = 'duo_host'"
                 );
                 if ($tmp) {
                     mysqli_query(
                         $db_link,
-                        "UPDATE `" . $pre . "misc`
-                        set valeur = '" . HOST . "', type = 'admin', intitule = 'duo_host'"
+                        "UPDATE `".$pre."misc`
+                        set valeur = '" . HOST."', type = 'admin', intitule = 'duo_host'"
                     );
                 } else {
                     mysqli_query(
                         $db_link,
-                        "INSERT INTO `" . $pre . "misc`
+                        "INSERT INTO `".$pre."misc`
                         (`valeur`, `type`, `intitule`)
-                        VALUES ('" . HOST . "', 'admin', 'duo_host')"
+                        VALUES ('" . HOST."', 'admin', 'duo_host')"
                     );
                 }
             }
@@ -169,13 +169,13 @@ 
         
         $settingsTxt = '<?php
 // DATABASE connexion parameters
-define("DB_HOST", "' . $server . '");
-define("DB_USER", "' . $user . '");
-define("DB_PASSWD", "' . $pass . '");
-define("DB_NAME", "' . $database . '");
-define("DB_PREFIX", "' . $pre . '");
-define("DB_PORT", "' . $port . '");
-define("DB_ENCODING", "' . $encoding . '");
+define("DB_HOST", "' . $server.'");
+define("DB_USER", "' . $user.'");
+define("DB_PASSWD", "' . $pass.'");
+define("DB_NAME", "' . $database.'");
+define("DB_PREFIX", "' . $pre.'");
+define("DB_PORT", "' . $port.'");
+define("DB_ENCODING", "' . $encoding.'");
 define("DB_SSL", false); // if DB over SSL then comment this line
 // if DB over SSL then uncomment the following lines
 //define("DB_SSL", array(
@@ -188,19 +188,19 @@ 
 define("DB_CONNECT_OPTIONS", array(
     MYSQLI_OPT_CONNECT_TIMEOUT => 10
 ));
-define("SECUREPATH", "' . str_replace('\\', '\\\\', SECUREPATH) . '");';
+define("SECUREPATH", "' . str_replace('\\', '\\\\', SECUREPATH).'");';
 define("SECUREFILE", "' . SECUREFILE. '");
 
 		if (defined('IKEY') === true) $settingsTxt .= '
-define("IKEY", "' . IKEY . '");';
+define("IKEY", "' . IKEY.'");';
 		else $settingsTxt .= '
 define("IKEY", "");';
 		if (defined('SKEY') === true) $settingsTxt .= '
-define("SKEY", "' . SKEY . '");';
+define("SKEY", "' . SKEY.'");';
 		else $settingsTxt .= '
 define("SKEY", "");';
 		if (defined('HOST') === true) $settingsTxt .= '
-define("HOST", "' . HOST . '");';
+define("HOST", "' . HOST.'");';
 		else $settingsTxt .= '
 define("HOST", "");';
 
@@ -296,7 +296,7 @@ 
                     '}]';
                     break;
                 }
-                if (!file_exists(SECUREPATH . '/sk.php')) {
+                if (!file_exists(SECUREPATH.'/sk.php')) {
                     echo '[{'.
                         '"error" : "Error in settings.php file!<br>Check correctness of path indicated in file `includes/config/settings.php`.<br>Reload this page and retry.",'.
                         '"index" : ""'.
@@ -312,8 +312,8 @@ 
             $user_info = mysqli_fetch_array(
                 mysqli_query(
                     $db_link,
-                    'SELECT id, pw, admin FROM ' . $pre . "users
-                    WHERE login='" . mysqli_escape_string($db_link, stripslashes($post_login)) . "'"
+                    'SELECT id, pw, admin FROM '.$pre."users
+                    WHERE login='" . mysqli_escape_string($db_link, stripslashes($post_login))."'"
                 )
             );
 
@@ -332,9 +332,9 @@ 
                     echo '[{'.
                         '"error" : "",'.
                         '"index" : 1,'.
-                        '"info" : "' . base64_encode(json_encode(
+                        '"info" : "'.base64_encode(json_encode(
                             array(mysqli_escape_string($db_link, stripslashes($post_login)), $post_pwd, $user_info['id'])
-                        )) . '"'.
+                        )).'"'.
                     '}]';
                 } else {
                     $superGlobal->put('user_granted', false, 'SESSION');
@@ -367,14 +367,14 @@ 
             $txt = '';
             $var_x = 1;
             $tab = array(
-                $abspath . '/includes/config/settings.php',
-                $abspath . '/includes/libraries/csrfp/libs/',
-                $abspath . '/install/',
-                $abspath . '/includes/',
-                $abspath . '/includes/config/',
-                $abspath . '/includes/avatars/',
-                $abspath . '/files/',
-                $abspath . '/upload/',
+                $abspath.'/includes/config/settings.php',
+                $abspath.'/includes/libraries/csrfp/libs/',
+                $abspath.'/install/',
+                $abspath.'/includes/',
+                $abspath.'/includes/config/',
+                $abspath.'/includes/avatars/',
+                $abspath.'/files/',
+                $abspath.'/upload/',
             );
             foreach ($tab as $elem) {
                 // try to create it if not existing
@@ -383,11 +383,11 @@ 
                 }
                 // check if writable
                 if (is_writable($elem)) {
-                    $txt .= '<span>' .
-                        $elem . '<i class=\"fa-solid fa-circle-check text-success ml-2\"></i></span><br />';
+                    $txt .= '<span>'.
+                        $elem.'<i class=\"fa-solid fa-circle-check text-success ml-2\"></i></span><br />';
                 } else {
-                    $txt .= '<span>' .
-                        $elem . '<i class=\"fa-solid fa-circle-minus text-danger ml-2\"></i></span><br />';
+                    $txt .= '<span>'.
+                        $elem.'<i class=\"fa-solid fa-circle-minus text-danger ml-2\"></i></span><br />';
                     $okWritable = false;
                 }
                 ++$var_x;
@@ -395,105 +395,105 @@ 
 
             if (!extension_loaded('openssl')) {
                 //$okExtensions = false;
-                $txt .= '<span>PHP extension \"openssl\"' .
+                $txt .= '<span>PHP extension \"openssl\"'.
                     '<i class=\"fa-solid fa-circle-minus text-danger ml-2\"></i></span><br />';
             } else {
-                $txt .= '<span>PHP extension \"openssl\"' .
+                $txt .= '<span>PHP extension \"openssl\"'.
                     '<i class=\"fa-solid fa-circle-check text-success ml-2\"></i></span><br />';
             }
             if (!extension_loaded('gd')) {
                 //$okExtensions = false;
-                $txt .= '<span>PHP extension \"gd\"' .
+                $txt .= '<span>PHP extension \"gd\"'.
                     '<i class=\"fa-solid fa-circle-minus text-danger ml-2\"></i></span><br />';
             } else {
-                $txt .= '<span>PHP extension \"gd\"' .
+                $txt .= '<span>PHP extension \"gd\"'.
                     '<i class=\"fa-solid fa-circle-check text-success ml-2\"></i></span><br />';
             }
             if (!extension_loaded('mbstring')) {
                 //$okExtensions = false;
-                $txt .= '<span>PHP extension \"mbstring\"' .
+                $txt .= '<span>PHP extension \"mbstring\"'.
                     '<i class=\"fa-solid fa-circle-minus text-danger ml-2\"></i></span><br />';
             } else {
-                $txt .= '<span>PHP extension \"mbstring\"' .
+                $txt .= '<span>PHP extension \"mbstring\"'.
                     '<i class=\"fa-solid fa-circle-check text-success ml-2\"></i></span><br />';
             }
             if (!extension_loaded('bcmath')) {
                 //$okExtensions = false;
-                $txt .= '<span>PHP extension \"bcmath\"' .
+                $txt .= '<span>PHP extension \"bcmath\"'.
                     '<i class=\"fa-solid fa-circle-minus text-danger ml-2\"></i></span><br />';
             } else {
-                $txt .= '<span>PHP extension \"bcmath\"' .
+                $txt .= '<span>PHP extension \"bcmath\"'.
                     '<i class=\"fa-solid fa-circle-check text-success ml-2\"></i></span><br />';
             }
             if (!extension_loaded('iconv')) {
                 //$okExtensions = false;
-                $txt .= '<span>PHP extension \"iconv\"' .
+                $txt .= '<span>PHP extension \"iconv\"'.
                     '<i class=\"fa-solid fa-circle-minus text-danger ml-2\"></i></span><br />';
             } else {
-                $txt .= '<span>PHP extension \"iconv\"' .
+                $txt .= '<span>PHP extension \"iconv\"'.
                     '<i class=\"fa-solid fa-circle-check text-success ml-2\"></i></span><br />';
             }
             if (!extension_loaded('xml')) {
                 //$okExtensions = false;
-                $txt .= '<span>PHP extension \"xml\"' .
+                $txt .= '<span>PHP extension \"xml\"'.
                     '<i class=\"fa-solid fa-circle-minus text-danger ml-2\"></i></span><br />';
             } else {
-                $txt .= '<span>PHP extension \"xml\"' .
+                $txt .= '<span>PHP extension \"xml\"'.
                     '<i class=\"fa-solid fa-circle-check text-success ml-2\"></i></span><br />';
             }
             if (!extension_loaded('curl')) {
-                $txt .= '<span>PHP extension \"curl\"' .
+                $txt .= '<span>PHP extension \"curl\"'.
                     '<i class=\"fa-solid fa-circle-minus text-danger ml-2\"></i></span><br />';
             } else {
-                $txt .= '<span>PHP extension \"curl\"' .
+                $txt .= '<span>PHP extension \"curl\"'.
                     '<i class=\"fa-solid fa-circle-check text-success ml-2\"></i></span><br />';
             }
             if (!extension_loaded('gmp')) {
-                $txt .= '<span>PHP extension \"gmp\"' .
+                $txt .= '<span>PHP extension \"gmp\"'.
                     '<i class=\"fa-solid fa-circle-minus text-danger ml-2\"></i></span><br />';
             } else {
-                $txt .= '<span>PHP extension \"gmp\"' .
+                $txt .= '<span>PHP extension \"gmp\"'.
                     '<i class=\"fa-solid fa-circle-check text-success ml-2\"></i></span><br />';
             }
             if (ini_get('max_execution_time') < 30) {
-                $txt .= '<span>PHP \"Maximum ' .
-                    'execution time\" is set to ' . ini_get('max_execution_time') . ' seconds.' .
-                    ' Please try to set to 60s at least until Upgrade is finished.&nbsp;' .
+                $txt .= '<span>PHP \"Maximum '.
+                    'execution time\" is set to '.ini_get('max_execution_time').' seconds.'.
+                    ' Please try to set to 60s at least until Upgrade is finished.&nbsp;'.
                     '&nbsp;<img src=\"images/minus-circle.png\"></span> <br />';
             } else {
-                $txt .= '<span>PHP \"Maximum ' .
-                    'execution time\" is set to ' . ini_get('max_execution_time') . ' seconds' .
+                $txt .= '<span>PHP \"Maximum '.
+                    'execution time\" is set to '.ini_get('max_execution_time').' seconds'.
                     '<i class=\"fa-solid fa-circle-check text-success ml-2\"></i></span><br />';
             }
             if (version_compare(phpversion(), MIN_PHP_VERSION, '<')) {
-                $txt .= '<span>PHP version ' .
-                    phpversion() . ' is not OK (minimum is '.MIN_PHP_VERSION.') &nbsp;&nbsp;' .
+                $txt .= '<span>PHP version '.
+                    phpversion().' is not OK (minimum is '.MIN_PHP_VERSION.') &nbsp;&nbsp;'.
                     '<img src=\"images/minus-circle.png\"></span><br />';
             } else {
-                $txt .= '<span>PHP version ' .
-                    phpversion() . ' is OK<i class=\"fa-solid fa-circle-check text-success ml-2\"></i>' .
+                $txt .= '<span>PHP version '.
+                    phpversion().' is OK<i class=\"fa-solid fa-circle-check text-success ml-2\"></i>'.
                     '</span><br />';
             }
-            $mysqlVersion = version_compare($db_link -> server_version, MIN_MYSQL_VERSION, '<') ;
-            $mariadbVersion = version_compare($db_link -> server_version, MIN_MARIADB_VERSION, '<') ;
+            $mysqlVersion = version_compare($db_link -> server_version, MIN_MYSQL_VERSION, '<');
+            $mariadbVersion = version_compare($db_link -> server_version, MIN_MARIADB_VERSION, '<');
             if ($mysqlVersion && $mariadbVersion) {
                 if ($mariadbVersion === '') {
-                    $txt .= '<span>MySQL version ' .
-                        $db_link -> server_version . ' is not OK (minimum is '.MIN_MYSQL_VERSION.') &nbsp;&nbsp;' .
+                    $txt .= '<span>MySQL version '.
+                        $db_link -> server_version.' is not OK (minimum is '.MIN_MYSQL_VERSION.') &nbsp;&nbsp;'.
                         '<img src=\"images/minus-circle.png\"></span><br />';
                 } else {
-                    $txt .= '<span>MySQL version ' .
-                        $db_link -> server_version . ' is not OK (minimum is '.MIN_MARIADB_VERSION.') &nbsp;&nbsp;' .
+                    $txt .= '<span>MySQL version '.
+                        $db_link -> server_version.' is not OK (minimum is '.MIN_MARIADB_VERSION.') &nbsp;&nbsp;'.
                         '<img src=\"images/minus-circle.png\"></span><br />';
                 }
             } else {
                 if ($mariadbVersion === '') {
-                    $txt .= '<span>MySQL version ' .
-                        $db_link -> server_info . ' is OK<i class=\"fa-solid fa-circle-check text-success ml-2\"></i>' .
+                    $txt .= '<span>MySQL version '.
+                        $db_link -> server_info.' is OK<i class=\"fa-solid fa-circle-check text-success ml-2\"></i>'.
                         '</span><br />';
                 } else {
-                    $txt .= '<span>MySQL version ' .
-                        $db_link -> server_info . ' is OK<i class=\"fa-solid fa-circle-check text-success ml-2\"></i>' .
+                    $txt .= '<span>MySQL version '.
+                        $db_link -> server_info.' is OK<i class=\"fa-solid fa-circle-check text-success ml-2\"></i>'.
                         '</span><br />';
                 }
                 
@@ -503,22 +503,22 @@ 
             // check if 2.1.27 already installed
             if (defined(SECUREPATH) === true) {
                 $okEncryptKey = false;
-                $defuse_file = SECUREPATH . '/teampass-seckey.txt';
+                $defuse_file = SECUREPATH.'/teampass-seckey.txt';
                 if (file_exists($defuse_file)) {
                     $okEncryptKey = true;
                     $superGlobal->put('tp_defuse_installed', true, 'SESSION');
-                    $txt .= '<span>Defuse encryption key is defined<i class=\"fa-solid fa-circle-check text-success ml-2\"></i>' .
+                    $txt .= '<span>Defuse encryption key is defined<i class=\"fa-solid fa-circle-check text-success ml-2\"></i>'.
                         '</span><br />';
                 }
 
                 if ($okEncryptKey === false) {
                     $superGlobal->put('tp_defuse_installed', false, 'SESSION');
-                    $txt .= '<span>Encryption Key (SALT) ' .
-                        ' could not be recovered from ' . $defuse_file . '&nbsp;&nbsp;' .
+                    $txt .= '<span>Encryption Key (SALT) '.
+                        ' could not be recovered from '.$defuse_file.'&nbsp;&nbsp;'.
                         '<img src=\"images/minus-circle.png\"></span><br />';
                 } else {
                     $okEncryptKey = true;
-                    $txt .= '<span>Encryption Key (SALT) is available<i class=\"fa-solid fa-circle-check text-success ml-2\"></i>' .
+                    $txt .= '<span>Encryption Key (SALT) is available<i class=\"fa-solid fa-circle-check text-success ml-2\"></i>'.
                         '</span><br />';
                 }
             } else {
@@ -534,10 +534,10 @@ 
             }
 
             echo '[{'.
-                '"error" : "' . $error . '",'.
-                '"info" : "' . $txt . '",'.
+                '"error" : "'.$error.'",'.
+                '"info" : "'.$txt.'",'.
                 '"index" : "'.($error === "" ? "" : $nextStep).'",'.
-                '"infos" : "' . $okWritable." ; ".$okExtensions." ; ".$okEncryptKey." ; " . '"'.
+                '"infos" : "'.$okWritable." ; ".$okExtensions." ; ".$okEncryptKey." ; ".'"'.
             '}]';
             break;
 
@@ -562,14 +562,14 @@ 
             if (@mysqli_fetch_row(
                 mysqli_query(
                     $db_link,
-                    'SELECT valeur FROM ' . $pre . "misc
+                    'SELECT valeur FROM '.$pre."misc
                     WHERE type='admin' AND intitule = 'utf8_enabled'"
                 )
             )) {
                 $cpmIsUTF8 = mysqli_fetch_row(
                     mysqli_query(
                         $db_link,
-                        'SELECT valeur FROM ' . $pre . "misc
+                        'SELECT valeur FROM '.$pre."misc
                         WHERE type='admin' AND intitule = 'utf8_enabled'"
                     )
                 );
@@ -579,9 +579,9 @@ 
             // put TP in maintenance mode or not
             @mysqli_query(
                 $db_link,
-                "UPDATE `" . $pre . "misc`
+                "UPDATE `".$pre."misc`
                 SET `valeur` = 'maintenance_mode'
-                WHERE type = 'admin' AND intitule = '" . $post_no_maintenance_mode . "'"
+                WHERE type = 'admin' AND intitule = '" . $post_no_maintenance_mode."'"
             );
 
             echo '[{'.
@@ -608,9 +608,9 @@ 
             if (isset($post_prefix_before_convert) && $post_prefix_before_convert == 'true') {
                 $tables = mysqli_query($db_link, 'SHOW TABLES');
                 while ($table = mysqli_fetch_row($tables)) {
-                    if (tableExists('old_' . $table[0]) != 1 && substr($table[0], 0, 4) != 'old_') {
-                        mysqli_query($db_link, 'CREATE TABLE old_' . $table[0] . ' LIKE ' . $table[0]);
-                        mysqli_query($db_link, 'INSERT INTO old_' . $table[0] . ' SELECT * FROM ' . $table[0]);
+                    if (tableExists('old_'.$table[0]) != 1 && substr($table[0], 0, 4) != 'old_') {
+                        mysqli_query($db_link, 'CREATE TABLE old_'.$table[0].' LIKE '.$table[0]);
+                        mysqli_query($db_link, 'INSERT INTO old_'.$table[0].' SELECT * FROM '.$table[0]);
                     }
                 }
             }
@@ -618,22 +618,22 @@ 
             //convert database
             mysqli_query(
                 $db_link,
-                'ALTER DATABASE `' . $database . '`
+                'ALTER DATABASE `'.$database.'`
                 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci'
             );
 
             //convert tables
-            $res = mysqli_query($db_link, 'SHOW TABLES FROM `' . $database . '`');
+            $res = mysqli_query($db_link, 'SHOW TABLES FROM `'.$database.'`');
             while ($table = mysqli_fetch_row($res)) {
                 if (substr($table[0], 0, 4) != 'old_') {
                     mysqli_query(
                         $db_link,
-                        'ALTER TABLE ' . $database . '.`{$table[0]}`
+                        'ALTER TABLE '.$database.'.`{$table[0]}`
                         CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci'
                     );
                     mysqli_query(
                         $db_link,
-                        'ALTER TABLE' . $database . '.`{$table[0]}`
+                        'ALTER TABLE'.$database.'.`{$table[0]}`
                         DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci'
                     );
                 }
@@ -670,7 +670,7 @@ 
                 //Do a copy of the existing file
                 if (!copy(
                     $settingsFile,
-                    $settingsFile . '.' . date(
+                    $settingsFile.'.'.date(
                         'Y_m_d_H_i_s',
                         mktime((int) date('H'), (int) date('i'), (int) date('s'), (int) date('m'), (int) date('d'), (int) date('y'))
                     )
@@ -687,7 +687,7 @@ 
                 // CHeck if old sk.php exists.
                 // If yes then get keys to database and delete it
                 if (empty($post_sk_path) === false || defined('SECUREPATH') === true) {
-                    $filename = (empty($post_sk_path) === false ? $post_sk_path : SECUREPATH) . '/sk.php';
+                    $filename = (empty($post_sk_path) === false ? $post_sk_path : SECUREPATH).'/sk.php';
                     if (file_exists($filename)) {
                         include_once $filename;
                         unlink($filename);
@@ -696,63 +696,63 @@ 
                         // SKEY
                         $tmp = mysqli_query(
                             $db_link,
-                            "SELECT INTO `" . $pre . "misc`
+                            "SELECT INTO `".$pre."misc`
                             WHERE type = 'admin' AND intitule = 'duo_skey'"
                         );
                         if ($tmp) {
                             mysqli_query(
                                 $db_link,
-                                "UPDATE `" . $pre . "misc`
-                                set valeur = '" . SKEY . "', type = 'admin', intitule = 'duo_skey'"
+                                "UPDATE `".$pre."misc`
+                                set valeur = '" . SKEY."', type = 'admin', intitule = 'duo_skey'"
                             );
                         } else {
                             mysqli_query(
                                 $db_link,
-                                "INSERT INTO `" . $pre . "misc`
+                                "INSERT INTO `".$pre."misc`
                                 (`valeur`, `type`, `intitule`)
-                                VALUES ('" . SKEY . "', 'admin', 'duo_skey')"
+                                VALUES ('" . SKEY."', 'admin', 'duo_skey')"
                             );
                         }
 
                         // IKEY
                         $tmp = mysqli_query(
                             $db_link,
-                            "SELECT INTO `" . $pre . "misc`
+                            "SELECT INTO `".$pre."misc`
                             WHERE type = 'admin' AND intitule = 'duo_ikey'"
                         );
                         if ($tmp) {
                             mysqli_query(
                                 $db_link,
-                                "UPDATE `" . $pre . "misc`
-                                set valeur = '" . IKEY . "', type = 'admin', intitule = 'duo_ikey'"
+                                "UPDATE `".$pre."misc`
+                                set valeur = '" . IKEY."', type = 'admin', intitule = 'duo_ikey'"
                             );
                         } else {
                             mysqli_query(
                                 $db_link,
-                                "INSERT INTO `" . $pre . "misc`
+                                "INSERT INTO `".$pre."misc`
                                 (`valeur`, `type`, `intitule`)
-                                VALUES ('" . IKEY . "', 'admin', 'duo_ikey')"
+                                VALUES ('" . IKEY."', 'admin', 'duo_ikey')"
                             );
                         }
 
                         // HOST
                         $tmp = mysqli_query(
                             $db_link,
-                            "SELECT INTO `" . $pre . "misc`
+                            "SELECT INTO `".$pre."misc`
                             WHERE type = 'admin' AND intitule = 'duo_host'"
                         );
                         if ($tmp) {
                             mysqli_query(
                                 $db_link,
-                                "UPDATE `" . $pre . "misc`
-                                set valeur = '" . HOST . "', type = 'admin', intitule = 'duo_host'"
+                                "UPDATE `".$pre."misc`
+                                set valeur = '" . HOST."', type = 'admin', intitule = 'duo_host'"
                             );
                         } else {
                             mysqli_query(
                                 $db_link,
-                                "INSERT INTO `" . $pre . "misc`
+                                "INSERT INTO `".$pre."misc`
                                 (`valeur`, `type`, `intitule`)
-                                VALUES ('" . HOST . "', 'admin', 'duo_host')"
+                                VALUES ('" . HOST."', 'admin', 'duo_host')"
                             );
                         }
                     }
@@ -771,13 +771,13 @@ 
                     utf8_encode(
                         '<?php
     // DATABASE connexion parameters
-    define("DB_HOST", "' . DB_HOST . '");
-    define("DB_USER", "' . DB_USER . '");
-    define("DB_PASSWD", "' . defuse_return_decrypted(DB_PASSWD) . '");
-    define("DB_NAME", "' . DB_NAME . '");
-    define("DB_PREFIX", "' . DB_PREFIX . '");
-    define("DB_PORT", "' . DB_PORT . '");
-    define("DB_ENCODING", "' . DB_ENCODING . '");
+    define("DB_HOST", "' . DB_HOST.'");
+    define("DB_USER", "' . DB_USER.'");
+    define("DB_PASSWD", "' . defuse_return_decrypted(DB_PASSWD).'");
+    define("DB_NAME", "' . DB_NAME.'");
+    define("DB_PREFIX", "' . DB_PREFIX.'");
+    define("DB_PORT", "' . DB_PORT.'");
+    define("DB_ENCODING", "' . DB_ENCODING.'");
     define("DB_SSL", false); // if DB over SSL then comment this line
     // if DB over SSL then uncomment the following lines
     //define("DB_SSL", array(
@@ -790,7 +790,7 @@ 
     define("DB_CONNECT_OPTIONS", array(
         MYSQLI_OPT_CONNECT_TIMEOUT => 10
     ));
-    define("SECUREPATH", "' . SECUREPATH. '");
+    define("SECUREPATH", "' . SECUREPATH.'");
 
     if (isset($_SESSION[\'settings\'][\'timezone\']) === true) {
     date_default_timezone_set($_SESSION[\'settings\'][\'timezone\']);
@@ -885,7 +885,7 @@ 
                     if (
                         copy(
                             $csrfp_file,
-                            $csrfp_file . '.' . date(
+                            $csrfp_file.'.'.date(
                                 'Y_m_d_H_i_s',
                                 mktime((int) date('H'), (int) date('i'), (int) date('s'), (int) date('m'), (int) date('d'), (int) date('y'))
                             )
@@ -904,17 +904,17 @@ 
                 unlink($csrfp_file); // delete existing csrfp.config file
                 copy($csrfp_file_sample, $csrfp_file); // make a copy of csrfp.config.sample file
                 $data = file_get_contents('../includes/libraries/csrfp/libs/csrfp.config.php');
-                $newdata = str_replace('"CSRFP_TOKEN" => ""', '"CSRFP_TOKEN" => "' . bin2hex(openssl_random_pseudo_bytes(25)) . '"', $data);
+                $newdata = str_replace('"CSRFP_TOKEN" => ""', '"CSRFP_TOKEN" => "'.bin2hex(openssl_random_pseudo_bytes(25)).'"', $data);
                 $newdata = str_replace('"tokenLength" => "25"', '"tokenLength" => "50"', $newdata);
-                $jsUrl = $post_url_path . '/includes/libraries/csrfp/js/csrfprotector.js';
-                $newdata = str_replace('"jsUrl" => ""', '"jsUrl" => "' . $jsUrl . '"', $newdata);
+                $jsUrl = $post_url_path.'/includes/libraries/csrfp/js/csrfprotector.js';
+                $newdata = str_replace('"jsUrl" => ""', '"jsUrl" => "'.$jsUrl.'"', $newdata);
                 $newdata = str_replace('"verifyGetFor" => array()', '"verifyGetFor" => array("*page=items&type=duo_check*")', $newdata);
                 file_put_contents('../includes/libraries/csrfp/libs/csrfp.config.php', $newdata);
 
                 // Mark a tag to force Install stuff (folders, files and table) to be cleanup while first login
                 mysqli_query(
                     $db_link,
-                    'INSERT INTO `' . $pre . 'misc` (`type`, `intitule`, `valeur`) VALUES ("install", "clear_install_folder", "true")'
+                    'INSERT INTO `'.$pre.'misc` (`type`, `intitule`, `valeur`) VALUES ("install", "clear_install_folder", "true")'
                 );
 
                 array_push(
@@ -936,19 +936,19 @@ 
 
             // update with correct version
             // 1st - check if teampass_version exists
-            $data = mysqli_fetch_row(mysqli_query($db_link, "SELECT COUNT(*) FROM ".$pre . "misc WHERE type = 'admin' AND intitule = 'teampass_version';"));
+            $data = mysqli_fetch_row(mysqli_query($db_link, "SELECT COUNT(*) FROM ".$pre."misc WHERE type = 'admin' AND intitule = 'teampass_version';"));
             if ((int) $data[0] === 0) {
                 // change variable name and put version
                 mysqli_query(
                     $db_link,
-                    "UPDATE `" . $pre . "misc`
+                    "UPDATE `".$pre."misc`
                     SET `valeur` = '".TP_VERSION."', `intitule` = 'teampass_version'
                     WHERE intitule = 'cpassman_version' AND type = 'admin';"
                 );
             } else {
                 mysqli_query(
                     $db_link,
-                    "UPDATE `" . $pre . "misc`
+                    "UPDATE `".$pre."misc`
                     SET `valeur` = '".TP_VERSION."'
                     WHERE intitule = 'teampass_version' AND type = 'admin';"
                 );
@@ -978,7 +978,7 @@ 
                             ->setDayOfMonth('*')
                             ->setMonths('*')
                             ->setDayOfWeek('*')
-                            ->setTaskCommandLine($phpLocation['path'] . ' ' . $SETTINGS['cpassman_dir'] . '/sources/scheduler.php')
+                            ->setTaskCommandLine($phpLocation['path'].' '.$SETTINGS['cpassman_dir'].'/sources/scheduler.php')
                             ->setComments('Teampass scheduler');
                         
                         $crontabRepository->addJob($crontabJob);
@@ -1034,7 +1034,7 @@ 
 
             $mysqli = new mysqli($server, $user, $pass, $database, $port);
             if ($mysqli->connect_error) {
-                die('Error : (' . $mysqli->connect_errno . ') ' . $mysqli->connect_error);
+                die('Error : ('.$mysqli->connect_errno.') '.$mysqli->connect_error);
             }
 
             $results = $mysqli->query('SHOW TABLES');
@@ -1044,11 +1044,11 @@ 
             }
 
             // Prepare file
-            $backup_file_name = 'sql-backup-' . date('d-m-Y--h-i-s') . '.sql';
-            $fp = fopen('../files/' . $backup_file_name, 'a');
+            $backup_file_name = 'sql-backup-'.date('d-m-Y--h-i-s').'.sql';
+            $fp = fopen('../files/'.$backup_file_name, 'a');
 
             foreach ($mtables as $table) {
-                $contents = '-- Table `' . $table . "` --\n";
+                $contents = '-- Table `'.$table."` --\n";
                 if (fwrite($fp, $contents) === false) {
                     echo '[{'.
                         '"error" : "Backup fails - please do it manually",'.
@@ -1058,9 +1058,9 @@ 
                     return false;
                 }
 
-                $results = $mysqli->query('SHOW CREATE TABLE ' . $table);
+                $results = $mysqli->query('SHOW CREATE TABLE '.$table);
                 while ($row = $results->fetch_array()) {
-                    $contents = $row[1] . ";\n\n";
+                    $contents = $row[1].";\n\n";
                     if (fwrite($fp, $contents) === false) {
                         echo '[{'.
                             '"error" : "Backup fails - please do it manually",'.
@@ -1071,14 +1071,14 @@ 
                     }
                 }
 
-                $results = $mysqli->query('SELECT * FROM ' . $table);
+                $results = $mysqli->query('SELECT * FROM '.$table);
                 $row_count = $results->num_rows;
                 $fields = $results->fetch_fields();
                 $fields_count = count($fields);
 
-                $insert_head = 'INSERT INTO `' . $table . '` (';
+                $insert_head = 'INSERT INTO `'.$table.'` (';
                 for ($i = 0; $i < $fields_count; ++$i) {
-                    $insert_head .= '`' . $fields[$i]->name . '`';
+                    $insert_head .= '`'.$fields[$i]->name.'`';
                     if ($i < $fields_count - 1) {
                         $insert_head .= ', ';
                     }
@@ -1127,7 +1127,7 @@ 
                                     break;
                                 default:
                                     //$contents .= "'".$row_content."'";
-                                    if (fwrite($fp, "'" . $row_content . "'") === false) {
+                                    if (fwrite($fp, "'".$row_content."'") === false) {
                                         echo '[{'.
                                             '"error" : "Backup fails - please do it manually",'.
                                             '"index" : ""'.

Braces +15 added lines, -6 removed lines

@@ -191,18 +191,27 @@
 define("SECUREPATH", "' . str_replace('\\', '\\\\', SECUREPATH) . '");';
 define("SECUREFILE", "' . SECUREFILE. '");
 
-		if (defined('IKEY') === true) $settingsTxt .= '
+		if (defined('IKEY') === true) {
+		    $settingsTxt .= '
 define("IKEY", "' . IKEY . '");';
-		else $settingsTxt .= '
+		} else {
+		    $settingsTxt .= '
 define("IKEY", "");';
-		if (defined('SKEY') === true) $settingsTxt .= '
+		}
+		if (defined('SKEY') === true) {
+		    $settingsTxt .= '
 define("SKEY", "' . SKEY . '");';
-		else $settingsTxt .= '
+		} else {
+		    $settingsTxt .= '
 define("SKEY", "");';
-		if (defined('HOST') === true) $settingsTxt .= '
+		}
+		if (defined('HOST') === true) {
+		    $settingsTxt .= '
 define("HOST", "' . HOST . '");';
-		else $settingsTxt .= '
+		} else {
+		    $settingsTxt .= '
 define("HOST", "");';
+		}
 
 
         $settingsTxt .= '

install--ASUPPRIMER/upgrade_operations.php

Spacing +38 added lines, -38 removed lines

@@ -81,8 +81,8 @@ 
         $port
     );
 } else {
-    $res = 'Impossible to get connected to server. Error is: ' . addslashes(mysqli_connect_error());
-    echo '[{"finish":"1", "msg":"", "error":"Impossible to get connected to server. Error is: ' . addslashes(mysqli_connect_error()) . '!"}]';
+    $res = 'Impossible to get connected to server. Error is: '.addslashes(mysqli_connect_error());
+    echo '[{"finish":"1", "msg":"", "error":"Impossible to get connected to server. Error is: '.addslashes(mysqli_connect_error()).'!"}]';
     mysqli_close($db_link);
     exit();
 }
@@ -147,7 +147,7 @@ 
             // OPERATION - 20231017_1 - remove all existing keys
             // if item is personal and user is not owner
 
-            installPurgeUnnecessaryKeys(true, 0,$pre);
+            installPurgeUnnecessaryKeys(true, 0, $pre);
     }
     // Return back
     echo '[{"finish":"'.$finish.'" , "next":"", "error":"", "total":"'.$total.'"}]';
@@ -161,8 +161,8 @@ 
     $items = mysqli_query(
         $db_link,
         "select i.id as id, ls.date as datetime
-        from `" . $pre . "items` as i
-        inner join `" . $pre . "log_items` as ls on ls.id_item = i.id
+        from `" . $pre."items` as i
+        inner join `" . $pre."log_items` as ls on ls.id_item = i.id
         WHERE ls.action = 'at_creation' AND i.created_at IS NULL
         LIMIT " . $post_nb.";"
     );
@@ -171,7 +171,7 @@ 
             // update created_at field
             mysqli_query(
                 $db_link,
-                "UPDATE `" . $pre . "items` SET created_at = '".$item['datetime']."' WHERE id = ".$item['id']
+                "UPDATE `".$pre."items` SET created_at = '".$item['datetime']."' WHERE id = ".$item['id']
             );
         }
     }
@@ -180,7 +180,7 @@ 
     $remainingItems = mysqli_num_rows(
         mysqli_query(
             $db_link,
-            "SELECT * FROM `" . $pre . "items` WHERE created_at IS NULL"
+            "SELECT * FROM `".$pre."items` WHERE created_at IS NULL"
         )
     );
     return $remainingItems > 0 ? 0 : 1;
@@ -192,15 +192,15 @@ 
     // loop on items - updated_at
     $items = mysqli_query(
         $db_link,
-        "select i.id as id, (select date from " . $pre . "log_items where action = 'at_modification' and id_item=id order by date DESC limit 1) as datetime 
-        from `" . $pre . "items` as i;"
+        "select i.id as id, (select date from ".$pre."log_items where action = 'at_modification' and id_item=id order by date DESC limit 1) as datetime 
+        from `" . $pre."items` as i;"
     );
     while ($item = mysqli_fetch_assoc($items)) {
         if (is_null($item['datetime']) === false) {
             // update updated_at field
             mysqli_query(
                 $db_link,
-                "UPDATE `" . $pre . "items` SET updated_at = '".$item['datetime']."' WHERE id = ".$item['id']
+                "UPDATE `".$pre."items` SET updated_at = '".$item['datetime']."' WHERE id = ".$item['id']
             );
         }
     }
@@ -214,15 +214,15 @@ 
     // loop on items - deleted_at
     $items = mysqli_query(
         $db_link,
-        "select i.id as id, (select date from " . $pre . "log_items where action = 'at_deleted' and id_item=id order by date DESC limit 1) as datetime
-        from `" . $pre . "items` as i;"
+        "select i.id as id, (select date from ".$pre."log_items where action = 'at_deleted' and id_item=id order by date DESC limit 1) as datetime
+        from `" . $pre."items` as i;"
     );
     while ($item = mysqli_fetch_assoc($items)) {
         if (is_null($item['datetime']) === false) {
             // update updated_at field
             mysqli_query(
                 $db_link,
-                "UPDATE `" . $pre . "items` SET deleted_at = '".$item['datetime']."' WHERE id = ".$item['id']
+                "UPDATE `".$pre."items` SET deleted_at = '".$item['datetime']."' WHERE id = ".$item['id']
             );
         }
     }
@@ -238,14 +238,14 @@ 
  * @param integer $user_id
  * @return void
  */
-function installPurgeUnnecessaryKeys(bool $allUsers = true, int $user_id=0, string $pre)
+function installPurgeUnnecessaryKeys(bool $allUsers = true, int $user_id = 0, string $pre)
 {
     global $db_link;
     if ($allUsers === true) {
         $users = mysqli_query(
             $db_link,
             'SELECT id
-            FROM ' . $pre . 'users
+            FROM ' . $pre.'users
             WHERE id NOT IN ('.OTV_USER_ID.', '.TP_USER_ID.', '.SSH_USER_ID.', '.API_USER_ID.')
             ORDER BY login ASC'
         );
@@ -263,7 +263,7 @@ 
  * @param integer $user_id
  * @return void
  */
-function installPurgeUnnecessaryKeysForUser(int $user_id=0, string $pre)
+function installPurgeUnnecessaryKeysForUser(int $user_id = 0, string $pre)
 {
     global $db_link;
     if ($user_id === 0) {
@@ -273,8 +273,8 @@ 
     $result = mysqli_query(
         $db_link,
         'SELECT id
-        FROM ' . $pre . 'items AS i
-        INNER JOIN ' . $pre . 'log_items AS li ON li.id_item = i.id
+        FROM ' . $pre.'items AS i
+        INNER JOIN ' . $pre.'log_items AS li ON li.id_item = i.id
         WHERE i.perso = 1 AND li.action = "at_creation" AND li.id_user IN ('.TP_USER_ID.', '.$user_id.')',
     );
     $rowcount = mysqli_num_rows($result);
@@ -290,25 +290,25 @@ 
         // Item keys
         mysqli_query(
             $db_link,
-            'DELETE FROM ' . $pre . 'sharekeys_items
+            'DELETE FROM '.$pre.'sharekeys_items
             WHERE object_id IN ('.$pfItemsList.') AND user_id NOT IN ('.TP_USER_ID.', '.$user_id.')'
         );
         // Files keys
         mysqli_query(
             $db_link,
-            'DELETE FROM ' . $pre . 'sharekeys_files
+            'DELETE FROM '.$pre.'sharekeys_files
             WHERE object_id IN ('.$pfItemsList.') AND user_id NOT IN ('.TP_USER_ID.', '.$user_id.')'
         );
         // Fields keys
         mysqli_query(
             $db_link,
-            'DELETE FROM ' . $pre . 'sharekeys_fields
+            'DELETE FROM '.$pre.'sharekeys_fields
             WHERE object_id IN ('.$pfItemsList.') AND user_id NOT IN ('.TP_USER_ID.', '.$user_id.')'
         );
         // Logs keys
         mysqli_query(
             $db_link,
-            'DELETE FROM ' . $pre . 'sharekeys_logs
+            'DELETE FROM '.$pre.'sharekeys_logs
             WHERE object_id IN ('.$pfItemsList.') AND user_id NOT IN ('.TP_USER_ID.', '.$user_id.')'
         );
     }
@@ -340,7 +340,7 @@ 
     // force full list of folders
     if (count($folderIds) === 0) {
         $result = $mysqli2->query('SELECT id
-            FROM ' . $pre . 'nested_tree
+            FROM ' . $pre.'nested_tree
             WHERE personal_folder = 0',
         );
         $rowcount = $result->num_rows;
@@ -361,8 +361,8 @@ 
         $arrCatList = array();
         $result = $mysqli2->query('SELECT c.id, c.title, c.level, c.type, c.masked, c.order, c.encrypted_data, c.role_visibility, c.is_mandatory,
             f.id_category AS category_id
-            FROM ' . $pre . 'categories_folders AS f
-            INNER JOIN ' . $pre . 'categories AS c ON (f.id_category = c.parent_id)
+            FROM ' . $pre.'categories_folders AS f
+            INNER JOIN ' . $pre.'categories AS c ON (f.id_category = c.parent_id)
             WHERE id_folder = '.$folder
         );
         $rowcount = $result->num_rows;
@@ -387,7 +387,7 @@ 
         // Now get complexity
         $valTemp = '';
         $result = $mysqli2->query('SELECT valeur
-            FROM ' . $pre . 'misc
+            FROM ' . $pre.'misc
             WHERE type = "complex" AND intitule = '.$folder
         );
         $rowcount = $result->num_rows;
@@ -404,21 +404,21 @@ 
         // Now get Roles
         $valTemp = '';
         $result = $mysqli2->query('SELECT t.title
-            FROM ' . $pre . 'roles_values as v
-            INNER JOIN ' . $pre . 'roles_title as t ON (v.role_id = t.id)
+            FROM ' . $pre.'roles_values as v
+            INNER JOIN ' . $pre.'roles_title as t ON (v.role_id = t.id)
             WHERE v.folder_id = '.$folder.'
             GROUP BY title'
         );
         $rowcount = $result->num_rows;
         if ($rowcount > 0) {
             while ($row = $result->fetch_assoc()) {
-                $valTemp .= (empty($valTemp) === true ? '' : ' - ') . $row['title'];
+                $valTemp .= (empty($valTemp) === true ? '' : ' - ').$row['title'];
             }
         }
         $arr_data['visibilityRoles'] = $valTemp;
 
         // now save in DB
-        $mysqli2->query("UPDATE " . $pre . "nested_tree SET categories = '".json_encode($arr_data)."' WHERE id = ".$folder);
+        $mysqli2->query("UPDATE ".$pre."nested_tree SET categories = '".json_encode($arr_data)."' WHERE id = ".$folder);
     }
     
     mysqli_close($mysqli2);
@@ -437,7 +437,7 @@ 
  */
 function installHandleConfigFile($action, $SETTINGS, $field = null, $value = null)
 {
-    $tp_config_file = $SETTINGS['cpassman_dir'] . '/includes/config/tp.config.php';
+    $tp_config_file = $SETTINGS['cpassman_dir'].'/includes/config/tp.config.php';
     $filename = '../includes/config/settings.php';
     include_once '../sources/main.functions.php';
     $pass = defuse_return_decrypted(DB_PASSWD);
@@ -452,8 +452,8 @@ 
     if (file_exists($tp_config_file) === false || $action === 'rebuild') {
         // perform a copy
         if (file_exists($tp_config_file)) {
-            if (! copy($tp_config_file, $tp_config_file . '.' . date('Y_m_d_His', time()))) {
-                return "ERROR: Could not copy file '" . $tp_config_file . "'";
+            if (!copy($tp_config_file, $tp_config_file.'.'.date('Y_m_d_His', time()))) {
+                return "ERROR: Could not copy file '".$tp_config_file."'";
             }
         }
 
@@ -464,13 +464,13 @@ 
         $data[2] = "\$SETTINGS = array (\n";
 
         $result = $mysqli2->query('SELECT *
-            FROM ' . $pre . 'misc
+            FROM ' . $pre.'misc
             WHERE type = "admin"'
         );
         $rowcount = $result->num_rows;
         if ($rowcount > 0) {
             while ($row = $result->fetch_assoc()) {
-                array_push($data, "    '" . $row['intitule'] . "' => '" . htmlspecialchars_decode($row['valeur'], ENT_COMPAT) . "',\n");
+                array_push($data, "    '".$row['intitule']."' => '".htmlspecialchars_decode($row['valeur'], ENT_COMPAT)."',\n");
             }
         }
         array_push($data, ");\n");
@@ -485,15 +485,15 @@ 
                 break;
             }
 
-            if (stristr($line, "'" . $field . "' => '")) {
-                $data[$inc] = "    '" . $field . "' => '" . htmlspecialchars_decode($value ?? '', ENT_COMPAT) . "',\n";
+            if (stristr($line, "'".$field."' => '")) {
+                $data[$inc] = "    '".$field."' => '".htmlspecialchars_decode($value ?? '', ENT_COMPAT)."',\n";
                 $bFound = true;
                 break;
             }
             ++$inc;
         }
         if ($bFound === false) {
-            $data[$inc] = "    '" . $field . "' => '" . htmlspecialchars_decode($value ?? '', ENT_COMPAT). "',\n);\n";
+            $data[$inc] = "    '".$field."' => '".htmlspecialchars_decode($value ?? '', ENT_COMPAT)."',\n);\n";
         }
     }
     mysqli_close($mysqli2);

install--ASUPPRIMER/migrate_users_to_v3.php

Spacing +1 added lines, -1 removed lines

@@ -41,4 +41,4 @@
 } else {
     $finished = 0;
 }
-echo '[{"finish":"' . $finished . '", "scriptname":"' . $scripts_list[$post_file_number][0] . '", "parameter":"' . $scripts_list[$post_file_number][1] . '"}]';
+echo '[{"finish":"'.$finished.'", "scriptname":"'.$scripts_list[$post_file_number][0].'", "parameter":"'.$scripts_list[$post_file_number][1].'"}]';

install--ASUPPRIMER/install.php

Indentation +117 added lines, -117 removed lines

@@ -39,68 +39,68 @@ 
 
 <body>
 	<?php
-	// define root path
-	$abs_path = rtrim(
-		filter_var($_SERVER['DOCUMENT_ROOT'], FILTER_SANITIZE_FULL_SPECIAL_CHARS),
-		'/'
-	) . substr(
-		filter_var($_SERVER['PHP_SELF'], FILTER_SANITIZE_FULL_SPECIAL_CHARS),
-		0,
-		strlen(filter_var($_SERVER['PHP_SELF'], FILTER_SANITIZE_FULL_SPECIAL_CHARS)) - 20
-	);
-	if (isset($_SERVER['HTTPS'])) {
-		$protocol = 'https://';
-	} else {
-		$protocol = 'http://';
-	}
+    // define root path
+    $abs_path = rtrim(
+        filter_var($_SERVER['DOCUMENT_ROOT'], FILTER_SANITIZE_FULL_SPECIAL_CHARS),
+        '/'
+    ) . substr(
+        filter_var($_SERVER['PHP_SELF'], FILTER_SANITIZE_FULL_SPECIAL_CHARS),
+        0,
+        strlen(filter_var($_SERVER['PHP_SELF'], FILTER_SANITIZE_FULL_SPECIAL_CHARS)) - 20
+    );
+    if (isset($_SERVER['HTTPS'])) {
+        $protocol = 'https://';
+    } else {
+        $protocol = 'http://';
+    }
 
 
-	$post_step = filter_input(INPUT_POST, 'step', FILTER_SANITIZE_NUMBER_INT);
-	$post_db_host = filter_input(INPUT_POST, 'db_host', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
-	if (empty($post_db_host) === true) {
-		$post_db_host = filter_input(INPUT_POST, 'hid_db_host', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
-	}
-	$post_db_login = filter_input(INPUT_POST, 'db_login', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
-	if (empty($post_db_login) === true) {
-		$post_db_login = filter_input(INPUT_POST, 'hid_db_login', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
-	}
-	$post_db_pwd = filter_input(INPUT_POST, 'db_pwd', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
-	if (empty($post_db_pwd) === true) {
-		$post_db_pwd = filter_input(INPUT_POST, 'hid_db_pwd', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
-	}
-	$post_db_port = filter_input(INPUT_POST, 'db_port', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
-	if (empty($post_db_port) === true) {
-		$post_db_port = filter_input(INPUT_POST, 'hid_db_port', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
-	}
-	$post_db_bdd = filter_input(INPUT_POST, 'db_bdd', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
-	if (empty($post_db_bdd) === true) {
-		$post_db_bdd = filter_input(INPUT_POST, 'hid_db_bdd', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
-	}
-	$post_db_pre = filter_input(INPUT_POST, 'db_pre', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
-	if (empty($post_db_pre) === true) {
-		$post_db_pre = filter_input(INPUT_POST, 'hid_db_pre', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
-	}
-	$post_absolute_path = filter_input(INPUT_POST, 'absolute_path', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
-	if (empty($post_absolute_path) === true) {
-		$post_absolute_path = filter_input(INPUT_POST, 'hid_absolute_path', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
-	}
-	$post_url_path = filter_input(INPUT_POST, 'url_path', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
-	if (empty($post_url_path) === true) {
-		$post_url_path = filter_input(INPUT_POST, 'hid_url_path', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
-	}
-	$post_sk_path = filter_input(INPUT_POST, 'sk_path', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
-	if (empty($post_sk_path) === true) {
-		$post_sk_path = filter_input(INPUT_POST, 'hid_sk_path', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
-	}
+    $post_step = filter_input(INPUT_POST, 'step', FILTER_SANITIZE_NUMBER_INT);
+    $post_db_host = filter_input(INPUT_POST, 'db_host', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
+    if (empty($post_db_host) === true) {
+        $post_db_host = filter_input(INPUT_POST, 'hid_db_host', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
+    }
+    $post_db_login = filter_input(INPUT_POST, 'db_login', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
+    if (empty($post_db_login) === true) {
+        $post_db_login = filter_input(INPUT_POST, 'hid_db_login', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
+    }
+    $post_db_pwd = filter_input(INPUT_POST, 'db_pwd', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
+    if (empty($post_db_pwd) === true) {
+        $post_db_pwd = filter_input(INPUT_POST, 'hid_db_pwd', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
+    }
+    $post_db_port = filter_input(INPUT_POST, 'db_port', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
+    if (empty($post_db_port) === true) {
+        $post_db_port = filter_input(INPUT_POST, 'hid_db_port', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
+    }
+    $post_db_bdd = filter_input(INPUT_POST, 'db_bdd', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
+    if (empty($post_db_bdd) === true) {
+        $post_db_bdd = filter_input(INPUT_POST, 'hid_db_bdd', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
+    }
+    $post_db_pre = filter_input(INPUT_POST, 'db_pre', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
+    if (empty($post_db_pre) === true) {
+        $post_db_pre = filter_input(INPUT_POST, 'hid_db_pre', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
+    }
+    $post_absolute_path = filter_input(INPUT_POST, 'absolute_path', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
+    if (empty($post_absolute_path) === true) {
+        $post_absolute_path = filter_input(INPUT_POST, 'hid_absolute_path', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
+    }
+    $post_url_path = filter_input(INPUT_POST, 'url_path', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
+    if (empty($post_url_path) === true) {
+        $post_url_path = filter_input(INPUT_POST, 'hid_url_path', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
+    }
+    $post_sk_path = filter_input(INPUT_POST, 'sk_path', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
+    if (empty($post_sk_path) === true) {
+        $post_sk_path = filter_input(INPUT_POST, 'hid_sk_path', FILTER_SANITIZE_FULL_SPECIAL_CHARS);
+    }
 
-	// Get some data
-	include "../includes/config/include.php";
+    // Get some data
+    include "../includes/config/include.php";
 
-	// # LOADER
-	echo '
+    // # LOADER
+    echo '
     <div style="position:absolute;top:49%;left:49%;display:none;z-index:9999999;" id="loader"><img src="images/76.gif" /></div>';
-	// # HEADER ##
-	echo '
+    // # HEADER ##
+    echo '
 	<div id="top">
 		<div id="logo" class="lcol"><img src="../includes/images/teampass-logo2-home.png" /></div>
 		<div class="lcol">
@@ -131,9 +131,9 @@ 
                 </h3>
             </div>
             <div class="card-body">';
-	if (!isset($_GET['step']) && !isset($post_step)) {
-		//ETAPE O
-		echo '
+    if (!isset($_GET['step']) && !isset($post_step)) {
+        //ETAPE O
+        echo '
 				<div class="row">
                     <div class="callout callout-warning col-12">
                         <h5><i class="fas fa-info-circle text-warning mr-2"></i>Welcome to Teampass installation</h5>
@@ -159,13 +159,13 @@ 
 						<p><a class="text-primary" target="_blank" href="https://spdx.org/licenses/GPL-3.0-only.html#licenseText">Read complete license</a>
                     </div>
                 </div>';
-		// STEP1
-	} elseif ((isset($post_step) && $post_step == 2)
-		|| (isset($_GET['step']) && $_GET['step'] == 2)
-		&& $post_user_granted === '1'
-	) {
-		//ETAPE 1
-		echo '
+        // STEP1
+    } elseif ((isset($post_step) && $post_step == 2)
+        || (isset($_GET['step']) && $_GET['step'] == 2)
+        && $post_user_granted === '1'
+    ) {
+        //ETAPE 1
+        echo '
 	<div class="row">
 		<div class="col-12">
 			<div class="card card-primary">
@@ -186,7 +186,7 @@ 
 		</div>
 	</div>';
 
-	echo '
+    echo '
 	<div class="row">
 		<div class="col-12">
 			<div class="card card-primary">
@@ -225,13 +225,13 @@ 
 			</div>
 		</div>
 	</div>';
-		// STEP2
-	} elseif ((isset($post_step) && $post_step == 3)
-		|| (isset($_GET['step']) && $_GET['step'] == 3)
-		&& $post_user_granted === '1'
-	) {
-		//ETAPE 2
-		echo '
+        // STEP2
+    } elseif ((isset($post_step) && $post_step == 3)
+        || (isset($_GET['step']) && $_GET['step'] == 3)
+        && $post_user_granted === '1'
+    ) {
+        //ETAPE 2
+        echo '
 	<div class="row">
 		<div class="col-12">
 			<div class="card card-primary">
@@ -268,13 +268,13 @@ 
 		</div>
 	</div>';
 
-		// STEP3
-	} elseif ((isset($post_step) && $post_step == 4)
-		|| (isset($_GET['step']) && $_GET['step'] == 4)
-		&& $post_user_granted === '1'
-	) {
-		//ETAPE 3
-		echo '
+        // STEP3
+    } elseif ((isset($post_step) && $post_step == 4)
+        || (isset($_GET['step']) && $_GET['step'] == 4)
+        && $post_user_granted === '1'
+    ) {
+        //ETAPE 3
+        echo '
 	<div class="row">
 		<div class="col-12">
 			<div class="card card-primary">
@@ -310,13 +310,13 @@ 
 	</div>';
 
 
-		// STEP4
-	} elseif ((isset($post_step) && $post_step == 5)
-		|| (isset($_GET['step']) && $_GET['step'] == 5)
-		&& $post_user_granted === '1'
-	) {
-		//ETAPE 4
-		echo '
+        // STEP4
+    } elseif ((isset($post_step) && $post_step == 5)
+        || (isset($_GET['step']) && $_GET['step'] == 5)
+        && $post_user_granted === '1'
+    ) {
+        //ETAPE 4
+        echo '
 	<div class="row">
 		<div class="col-12">
 			<div class="card card-primary">
@@ -330,13 +330,13 @@ 
 		</div>
 	</div>';
 
-		// STEP5
-	} elseif ((isset($post_step) && $post_step == 6)
-		|| (isset($_GET['step']) && $_GET['step'] == 6)
-		&& $post_user_granted === '1'
-	) {
-		//ETAPE 5
-		echo '
+        // STEP5
+    } elseif ((isset($post_step) && $post_step == 6)
+        || (isset($_GET['step']) && $_GET['step'] == 6)
+        && $post_user_granted === '1'
+    ) {
+        //ETAPE 5
+        echo '
 	<div class="row">
 		<div class="col-12">
 			<div class="card card-primary">
@@ -357,13 +357,13 @@ 
 		</div>
 	</div>';
 
-		// STEP6
-	} elseif ((isset($post_step) && $post_step == 7)
-		|| (isset($_GET['step']) && $_GET['step'] == 7)
-		&& $post_user_granted === '1'
-	) {
-		//ETAPE 6
-		echo '
+        // STEP6
+    } elseif ((isset($post_step) && $post_step == 7)
+        || (isset($_GET['step']) && $_GET['step'] == 7)
+        && $post_user_granted === '1'
+    ) {
+        //ETAPE 6
+        echo '
 	<div class="row">
 		<div class="callout callout-primary col-12">
 			<h4>Thank you for installing <b>Teampass</b>.</h4>
@@ -391,32 +391,32 @@ 
 			</div>
 		</div>
 	</div>';
-	}
+    }
 
-	echo '	
+    echo '	
 	</div>	
         <div class="card-footer">';
-	//buttons
-	if (!isset($post_step)) {
-		echo '
+    //buttons
+    if (!isset($post_step)) {
+        echo '
             <input type="button" class="btn btn-primary" id="but_next" target_id="2" class="button" value="START" />
             <input type="button" class="btn btn-primary" id="but_start" onclick="document.location = \'' . $protocol . $_SERVER['HTTP_HOST'] . substr($_SERVER['PHP_SELF'], 0, strrpos($_SERVER['PHP_SELF'], '/') - 8) . '\'" class="button" style="display: none;" value="Start" />';
-	} elseif ($post_step == 7) {
-		// Nothong to do
-	} else {
-		echo '
+    } elseif ($post_step == 7) {
+        // Nothong to do
+    } else {
+        echo '
             <input type="button" id="but_launch" onclick="checkPage(\'step' . $post_step . '\')" class="btn btn-primary" value="START" />
             <input type="button" id="but_next" target_id="' . (intval($post_step) + 1) . '" class="btn btn-primary" value="NEXT" disabled="disabled">
 			<input type="button" class="btn btn-primary" id="but_restart" onclick="document.location = \'install.php\'" class="button" value="RESTART" />';
-	}
+    }
 
-	echo '
+    echo '
         </div>
 	</form>
 	</div>';
 
-	//FOOTER
-	echo '
+    //FOOTER
+    echo '
     <div id="footer">
         <div style="width:500px; font-size:16px;">
             ' . TP_TOOL_NAME . ' ' . TP_VERSION . ' <i class="far fa-copyright"></i> copyright 2009-2019
@@ -424,7 +424,7 @@ 
         <div style="float:right;margin-top:-15px;">
         </div>
     </div>';
-	?>
+    ?>
 </body>
 
 </html>

Spacing +9 added lines, -9 removed lines

@@ -43,7 +43,7 @@ 
 	$abs_path = rtrim(
 		filter_var($_SERVER['DOCUMENT_ROOT'], FILTER_SANITIZE_FULL_SPECIAL_CHARS),
 		'/'
-	) . substr(
+	).substr(
 		filter_var($_SERVER['PHP_SELF'], FILTER_SANITIZE_FULL_SPECIAL_CHARS),
 		0,
 		strlen(filter_var($_SERVER['PHP_SELF'], FILTER_SANITIZE_FULL_SPECIAL_CHARS)) - 20
@@ -104,7 +104,7 @@ 
 	<div id="top">
 		<div id="logo" class="lcol"><img src="../includes/images/teampass-logo2-home.png" /></div>
 		<div class="lcol">
-			<span class="header-title">' . strtoupper(TP_TOOL_NAME) . '</span>
+			<span class="header-title">' . strtoupper(TP_TOOL_NAME).'</span>
 		</div>
 		
         <div id="content">
@@ -139,7 +139,7 @@ 
                         <h5><i class="fas fa-info-circle text-warning mr-2"></i>Welcome to Teampass installation</h5>
     
                         <p>This seems to be the 1st time Teampass will be installed on this server.<br>
-						It will proceed with installation of release <b>' . TP_VERSION . '</b>.</p>
+						It will proceed with installation of release <b>' . TP_VERSION.'</b>.</p>
                     </div>
 
                     <div class="callout callout-info col-12 mt-3">
@@ -175,11 +175,11 @@ 
 				<div class="card-body">
 					<div class="form-group">
 						<label>Absolute path to TeamPass folder</label>
-						<input type="text" class="form-control" name="absolute_path" id="absolute_path" class="ui-widget" value="' . $abs_path . '">
+						<input type="text" class="form-control" name="absolute_path" id="absolute_path" class="ui-widget" value="' . $abs_path.'">
 					</div>
 					<div class="form-group">
 						<label>Full URL to TeamPass</label>
-						<input type="text" class="form-control" name="url_path" id="url_path" class="ui-widget" value="' . $protocol . $_SERVER['HTTP_HOST'] . substr($_SERVER['PHP_SELF'], 0, strrpos($_SERVER['PHP_SELF'], '/') - 8) . '">
+						<input type="text" class="form-control" name="url_path" id="url_path" class="ui-widget" value="' . $protocol.$_SERVER['HTTP_HOST'].substr($_SERVER['PHP_SELF'], 0, strrpos($_SERVER['PHP_SELF'], '/') - 8).'">
 					</div>
 				</div>
 			</div>
@@ -400,13 +400,13 @@ 
 	if (!isset($post_step)) {
 		echo '
             <input type="button" class="btn btn-primary" id="but_next" target_id="2" class="button" value="START" />
-            <input type="button" class="btn btn-primary" id="but_start" onclick="document.location = \'' . $protocol . $_SERVER['HTTP_HOST'] . substr($_SERVER['PHP_SELF'], 0, strrpos($_SERVER['PHP_SELF'], '/') - 8) . '\'" class="button" style="display: none;" value="Start" />';
+            <input type="button" class="btn btn-primary" id="but_start" onclick="document.location = \'' . $protocol.$_SERVER['HTTP_HOST'].substr($_SERVER['PHP_SELF'], 0, strrpos($_SERVER['PHP_SELF'], '/') - 8).'\'" class="button" style="display: none;" value="Start" />';
 	} elseif ($post_step == 7) {
 		// Nothong to do
 	} else {
 		echo '
-            <input type="button" id="but_launch" onclick="checkPage(\'step' . $post_step . '\')" class="btn btn-primary" value="START" />
-            <input type="button" id="but_next" target_id="' . (intval($post_step) + 1) . '" class="btn btn-primary" value="NEXT" disabled="disabled">
+            <input type="button" id="but_launch" onclick="checkPage(\'step' . $post_step.'\')" class="btn btn-primary" value="START" />
+            <input type="button" id="but_next" target_id="' . (intval($post_step) + 1).'" class="btn btn-primary" value="NEXT" disabled="disabled">
 			<input type="button" class="btn btn-primary" id="but_restart" onclick="document.location = \'install.php\'" class="button" value="RESTART" />';
 	}
 
@@ -419,7 +419,7 @@ 
 	echo '
     <div id="footer">
         <div style="width:500px; font-size:16px;">
-            ' . TP_TOOL_NAME . ' ' . TP_VERSION . ' <i class="far fa-copyright"></i> copyright 2009-2019
+            ' . TP_TOOL_NAME.' '.TP_VERSION.' <i class="far fa-copyright"></i> copyright 2009-2019
         </div>
         <div style="float:right;margin-top:-15px;">
         </div>

install--ASUPPRIMER/upgrade.php

Spacing +2 added lines, -2 removed lines

@@ -275,7 +275,7 @@ 
     echo '
         <div class="row">
             <div class="col-12">
-                <div class="card card-',$dbSettings === true ? 'primary' : 'warning','">
+                <div class="card card-',$dbSettings === true ? 'primary' : 'warning', '">
                     <div class="card-header">
                         <h5>DataBase Informations</h5>
                     </div>
@@ -802,7 +802,7 @@ 
     console.log("> "+step+" - Number: "+number + " - Previous step: "+previousStep);
     console.log(usersList);
     var d = new Date(),
-        count_in_loop = <?php echo (int) NUMBER_ITEMS_IN_BATCH;?>,
+        count_in_loop = <?php echo (int) NUMBER_ITEMS_IN_BATCH; ?>,
         userSteps = {};
 
 

install--ASUPPRIMER/tp.functions.php

Spacing +16 added lines, -16 removed lines

@@ -34,13 +34,13 @@ 
         
         $settingsTxt = '<?php
 // DATABASE connexion parameters
-define("DB_HOST", "' . DB_HOST . '");
-define("DB_USER", "' . DB_USER . '");
-define("DB_PASSWD", "' . DB_PASSWD . '");
-define("DB_NAME", "' . DB_NAME . '");
-define("DB_PREFIX", "' . DB_PREFIX . '");
-define("DB_PORT", "' . DB_PORT . '");
-define("DB_ENCODING", "' . DB_ENCODING . '");';
+define("DB_HOST", "' . DB_HOST.'");
+define("DB_USER", "' . DB_USER.'");
+define("DB_PASSWD", "' . DB_PASSWD.'");
+define("DB_NAME", "' . DB_NAME.'");
+define("DB_PREFIX", "' . DB_PREFIX.'");
+define("DB_PORT", "' . DB_PORT.'");
+define("DB_ENCODING", "' . DB_ENCODING.'");';
 
 if (isset(DB_SSL['key']) === true && empty(DB_SSL['key']) === false) {
     $settingsTxt .= '
@@ -70,19 +70,19 @@ 
 define("DB_CONNECT_OPTIONS", array(
     MYSQLI_OPT_CONNECT_TIMEOUT => 10
 ));
-define("SECUREPATH", "' . str_replace('\\', '\\\\', SECUREPATH) . '");
-define("SECUREFILE", "' . SECUREFILE. '");';
+define("SECUREPATH", "' . str_replace('\\', '\\\\', SECUREPATH).'");
+define("SECUREFILE", "' . SECUREFILE.'");';
 
         if (defined('IKEY') === true) $settingsTxt .= '
-define("IKEY", "' . IKEY . '");';
+define("IKEY", "' . IKEY.'");';
         else $settingsTxt .= '
 define("IKEY", "");';
         if (defined('SKEY') === true) $settingsTxt .= '
-define("SKEY", "' . SKEY . '");';
+define("SKEY", "' . SKEY.'");';
         else $settingsTxt .= '
 define("SKEY", "");';
         if (defined('HOST') === true) $settingsTxt .= '
-define("HOST", "' . HOST . '");';
+define("HOST", "' . HOST.'");';
         else $settingsTxt .= '
 define("HOST", "");';
 
@@ -407,7 +407,7 @@ 
     global $db_link;
 
     // check if column already exists
-    $columns = mysqli_query($db_link, "show columns from `" . $table . "`");
+    $columns = mysqli_query($db_link, "show columns from `".$table."`");
     while ($col = mysqli_fetch_assoc($columns)) {
         if ((string) $col['Field'] === $oldName) {
             // change column name
@@ -432,7 +432,7 @@ 
     // Essayer de trouver le fichier binaire de PHP dans les chemins de recherche standards
     $paths = explode(PATH_SEPARATOR, getenv('PATH'));
     foreach ($paths as $path) {
-        $phpBinary = $path . DIRECTORY_SEPARATOR . 'php';
+        $phpBinary = $path.DIRECTORY_SEPARATOR.'php';
         if (is_executable($phpBinary)) {
         $phpPath = $phpBinary;
         break;
@@ -467,7 +467,7 @@ 
 function deleteAll(array $folders)
 {
 
-    foreach($folders as $folder) {
+    foreach ($folders as $folder) {
         deleteAllFolder($folder);
     }
 }
@@ -493,7 +493,7 @@ 
         $scan = glob(rtrim($str, '/').'/*'); 
 
         // Loop through the list of files 
-        foreach($scan as $index=>$path) { 
+        foreach ($scan as $index=>$path) { 
 
             // Call recursive function 
             deleteAllFolder($path); 

Braces +15 added lines, -6 removed lines

@@ -73,18 +73,27 @@
 define("SECUREPATH", "' . str_replace('\\', '\\\\', SECUREPATH) . '");
 define("SECUREFILE", "' . SECUREFILE. '");';
 
-        if (defined('IKEY') === true) $settingsTxt .= '
+        if (defined('IKEY') === true) {
+            $settingsTxt .= '
 define("IKEY", "' . IKEY . '");';
-        else $settingsTxt .= '
+        } else {
+            $settingsTxt .= '
 define("IKEY", "");';
-        if (defined('SKEY') === true) $settingsTxt .= '
+        }
+        if (defined('SKEY') === true) {
+            $settingsTxt .= '
 define("SKEY", "' . SKEY . '");';
-        else $settingsTxt .= '
+        } else {
+            $settingsTxt .= '
 define("SKEY", "");';
-        if (defined('HOST') === true) $settingsTxt .= '
+        }
+        if (defined('HOST') === true) {
+            $settingsTxt .= '
 define("HOST", "' . HOST . '");';
-        else $settingsTxt .= '
+        } else {
+            $settingsTxt .= '
 define("HOST", "");';
+        }
 
 
         $settingsTxt .= '