View GitHub Repository TeamPass

Schedule Inspection
Subscribe

Code Duplication    Length = 9-9 lines in 2 locations

install/install.queries.php 2 locations

@@ 157-165 (lines=9) @@
154 
                    ) CHARSET=utf8;"
155 
                );
156 
                // store values
157 
                foreach ($data as $key => $value) {
158 
                    $_SESSION[$key] = $value;
159 
                    $tmp = mysqli_fetch_row(mysqli_query($dbTmp, "SELECT COUNT(*) FROM `_install` WHERE `key` = '".$key."'"));
160 
                    if ($tmp[0] == 0 || empty($tmp[0])) {
161 
                        mysqli_query($dbTmp, "INSERT INTO `_install` (`key`, `value`) VALUES ('".$key."', '".$value."');");
162 
                    } else {
163 
                        mysqli_query($dbTmp, "UPDATE `_install` SET `value` = '".$value."' WHERE `key` = '".$key."';");
164 
                    }
165 
                }
166 
                $tmp = mysqli_fetch_row(mysqli_query($dbTmp, "SELECT COUNT(*) FROM `_install` WHERE `key` = 'url_path'"));
167 
                if ($tmp[0] == 0 || empty($tmp[0])) {
168 
                    mysqli_query($dbTmp, "INSERT INTO `_install` (`key`, `value`) VALUES ('url_path', '", empty($_SESSION['url_path']) ? $db['url_path'] : $_SESSION['url_path'], "');");
@@ 213-221 (lines=9) @@
210 
            if (is_dir($data['sk_path'])) {
211 
                if (is_writable($data['sk_path'])) {
212 
                    // store all variables in SESSION
213 
                    foreach ($data as $key => $value) {
214 
                        $_SESSION[$key] = $value;
215 
                        $tmp = mysqli_fetch_row(mysqli_query($dbTmp, "SELECT COUNT(*) FROM `_install` WHERE `key` = '".$key."'"));
216 
                        if ($tmp[0] == 0 || empty($tmp[0])) {
217 
                            mysqli_query($dbTmp, "INSERT INTO `_install` (`key`, `value`) VALUES ('".$key."', '".$value."');");
218 
                        } else {
219 
                            mysqli_query($dbTmp, "UPDATE `_install` SET `value` = '".$value."' WHERE `key` = '".$key."';");
220 
                        }
221 
                    }
222 
                    echo '[{"error" : "", "result" : "Information stored", "multiple" : ""}]';
223 
                } else {
224 
                    echo '[{"error" : "The Directory must be writable!", "result" : "Information stored", "multiple" : ""}]';