コード例 #1
0
ファイル: install.php プロジェクト: jpgil/tematres-mirror
function checkInstall($lang)
{
    global $install_message;
    //1. check if config file exist
    if (!file_exists('db.tematres.php')) {
        return message("<span class=\"error\">{$install_message['201']}</span>");
    } else {
        message("<span class=\"success\">{$install_message['202']}</span>");
        include 'db.tematres.php';
    }
    //2. check connection to server
    if (!($linkDB = @mysqli_connect($DBCFG["Server"], $DBCFG["DBLogin"], $DBCFG["DBPass"]))) {
        return message('<span class="error">' . sprintf($install_message[203], $DBCFG[Server], $DBCFG[DBLogin]) . '</span>');
    } else {
        message('<span class="success">' . sprintf($install_message[204], $DBCFG[Server]) . '</span>');
    }
    //3. check connection to database
    if (!mysqli_select_db($linkDB, $DBCFG["DBName"])) {
        return message('<span class="error">' . sprintf($install_message[205], $DBCFG[DBName], $DBCFG[Server]) . '</span>');
    } else {
        message('<span class="success">' . sprintf($install_message[206], $DBCFG[DBName], $DBCFG[Server]) . '</span>');
    }
    //4. check tables
    $sql = mysqli_query($linkDB, "SHOW TABLES from {$DBCFG['DBName']} where Tables_in_{$DBCFG['DBName']} in ('{$DBCFG['DBprefix']}config','{$DBCFG['DBprefix']}indice','{$DBCFG['DBprefix']}notas','{$DBCFG['DBprefix']}tabla_rel','{$DBCFG['DBprefix']}tema','{$DBCFG['DBprefix']}usuario','{$DBCFG['DBprefix']}values')");
    if (mysqli_affected_rows($linkDB) == '7') {
        return message("<span class=\"error\">{$install_message['301']}</span>");
    } else {
        //Final step: dump or form
        if (isset($_POST['send'])) {
            $sqlInstall = SQLtematres($DBCFG, $linkDB);
        } else {
            echo HTMLformInstall($lang);
        }
    }
}
コード例 #2
0
function checkInstall($lang)
{
    global $install_message;
    $conf_file_path = str_replace("install.php", "db.tematres.php", "http://" . $_SERVER['SERVER_NAME'] . $_SERVER['PHP_SELF']);
    //1. check if config file exist
    if (!file_exists('db.tematres.php')) {
        return message('<div class="alert alert-danger" role="alert">' . sprintf($install_message[201], $conf_file_path) . '</div><br/>');
    } else {
        include 'db.tematres.php';
    }
    if ($DBCFG["debugMode"] == 0) {
        //silent warnings
        error_reporting(0);
        $label_login = '';
        $label_dbname = '';
        $label_server = '';
    } else {
        $label_login = $DBCFG["DBLogin"];
        $label_dbname = $DBCFG["DBName"];
        $label_server = $DBCFG["Server"];
    }
    //2. check connection to server
    require_once T3_ABSPATH . 'common/include/adodb5/adodb.inc.php';
    //default driver
    $DBCFG["DBdriver"] = $DBCFG["DBdriver"] ? $DBCFG["DBdriver"] : "mysqli";
    $DB = NewADOConnection($DBCFG["DBdriver"]);
    if (!$DB->Connect($DBCFG["Server"], $DBCFG["DBLogin"], $DBCFG["DBPass"])) {
        return message('<div class="alert alert-danger" role="alert">' . sprintf($install_message[203], $label_server, $label_login, $conf_file_path) . '</div><br/>');
    }
    //~
    //3. check connection to database
    if (!$DB->Connect($DBCFG["Server"], $DBCFG["DBLogin"], $DBCFG["DBPass"], $DBCFG["DBName"])) {
        return message('<div class="alert alert-danger" role="alert">' . sprintf($install_message[205], $label_dbname, $label_server, $conf_file_path) . '</div><br/>');
    }
    //4. check tables
    $sql = $DB->Execute('SHOW TABLES from `' . $DBCFG["DBName"] . '` where `tables_in_' . $DBCFG["DBName"] . '` in (\'' . $DBCFG["DBprefix"] . 'config\',\'' . $DBCFG["DBprefix"] . 'indice\',\'' . $DBCFG["DBprefix"] . 'notas\',\'' . $DBCFG["DBprefix"] . 'tabla_rel\',\'' . $DBCFG["DBprefix"] . 'tema\',\'' . $DBCFG["DBprefix"] . 'usuario\',\'' . $DBCFG["DBprefix"] . 'values\')');
    if ($DB->Affected_Rows() == '7') {
        return message('<div class="alert alert-danger" role="alert">' . $install_message["301"] . '</div>');
    } else {
        //Final step: dump or form
        if (isset($_POST['send'])) {
            $arrayInstallData = checkDataInstall($_POST);
            if (count($arrayInstallData) == 7) {
                SQLtematres($DBCFG, $DB, $arrayInstallData);
            } else {
                echo $arrayInstallData["error_msg"];
                echo HTMLformInstall($lang);
            }
        } else {
            echo HTMLformInstall($lang);
        }
    }
}