nilsteampassnet / TeamPass

// check that SYSLOG doesn't exist

$tmp = mysqli_fetch_row(mysqli_query($dbTmp, "SELECT COUNT(*) FROM `".$_SESSION['pre']."misc` WHERE type = 'admin' AND intitule = 'syslog_enable'"));

if ($tmp[0] == 0 || empty($tmp[0])) {

    mysqli_query($dbTmp,

        "INSERT INTO `".$_SESSION['pre']."misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'syslog_enable', '0')"

    );

    mysqli_query($dbTmp,

        "INSERT INTO `".$_SESSION['pre']."misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'syslog_host', 'localhost')"

    );

    mysqli_query($dbTmp,

        "INSERT INTO `".$_SESSION['pre']."misc` (`type`, `intitule`, `valeur`) VALUES ('admin', 'syslog_port', '514')"

    );

}

// alter table Items

            //convert tables

            $res = mysqli_query($dbTmp, "SHOW TABLES FROM `".$_SESSION['database']."`");

            while ($table = mysqli_fetch_row($res)) {

                if (substr($table[0], 0, 4) != "old_") {

                    mysqli_query($dbTmp,

                        "ALTER TABLE ".$_SESSION['database'].".`{$table[0]}`

                        CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci"

                    );

                    mysqli_query($dbTmp,

                        "ALTER TABLE".$_SESSION['database'].".`{$table[0]}`

                        DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci"

                    );

                }

            }

            echo 'document.getElementById("res_step3").innerHTML = "Done!";';