define('IN_SAESPOT', 1); @header("content-Type: text/html; charset=UTF-8"); $sqlfile = dirname(__FILE__) . '/yunbbs_mysql.sql'; if (!is_readable($sqlfile)) { exit('数据库文件不存在或者读取失败'); } $fp = fopen($sqlfile, 'rb'); $sql = fread($fp, 2048000); fclose($fp); include dirname(__FILE__) . '/config.php'; include dirname(__FILE__) . '/include/mysql.class.php'; $DBM = new DB_MySQL(); $DBM->connect($servername_m, $dbport, $dbusername, $dbpassword, $dbname); unset($servername_m, $dbusername, $dbpassword); $DBM->select_db($dbname); if ($DBM->geterrdesc()) { if (mysql_get_server_info() > '4.1') { $DBM->query("CREATE DATABASE {$dbname} DEFAULT CHARACTER SET {$dbcharset}"); } else { $DBM->query("CREATE DATABASE {$dbname}"); } if ($DBM->geterrdesc()) { exit('指定的数据库不存在, 系统也无法自动建立, 无法安装.<br />'); } else { $DBM->select_db($dbname); //成功建立指定数据库 } } $DBM->query("SELECT COUNT(*) FROM `yunbbs_settings`", 'SILENT'); if (!$DBM->geterrdesc()) {
define('IN_SAESPOT', 1); @header("content-Type: text/html; charset=UTF-8"); $sqlfile = dirname(__FILE__) . '/yunbbs_mysql.sql'; if (!is_readable($sqlfile)) { exit('数据库文件不存在或者读取失败'); } $fp = fopen($sqlfile, 'rb'); $sql = fread($fp, 2048000); fclose($fp); include dirname(__FILE__) . '/config.php'; include dirname(__FILE__) . '/include/mysql.class.php'; $DBS = new DB_MySQL(); $DBS->connect($servername, $dbport, $dbusername, $dbpassword, $dbname); unset($servername, $dbusername, $dbpassword); $DBS->select_db($dbname); if ($DBS->geterrdesc()) { if (mysql_get_server_info() > '4.1') { $DBS->query("CREATE DATABASE {$dbname} DEFAULT CHARACTER SET {$dbcharset}"); } else { $DBS->query("CREATE DATABASE {$dbname}"); } if ($DBS->geterrdesc()) { exit('指定的数据库不存在, 系统也无法自动建立, 无法安装.<br />'); } else { $DBS->select_db($dbname); //成功建立指定数据库 } } $query - $DBS->query("SELECT COUNT(*) FROM yunbbs_settings", 'SILENT'); if (!$DBS->geterrdesc()) {
function mysqlconn($configfile) { include $configfile; //包含配置文件,并使用它连接数据库 include 'func_db_mysql.php'; $DB = new DB_MySQL(); $quit = False; //创建一个新的数据库对象 $DB->connect($servername, $dbusername, $dbpassword, $dbname, $usepconnect, $dbcharset); unset($servername, $dbusername, $dbpassword, $usepconnect); //销毁变量 $curr_php_version = PHP_VERSION; //PHP的版本 if ($curr_php_version < '4.0.6') { echo "<font color=\"#FF0000\">由于您的PHP版本过低, 无法继续安装 ,请更换版本大于4.0.6的PHP版本。3秒后返回配置页面</font></br>"; echo "<font color=\"#FF0000\"><a href='setting.php'>立即返回</a></font>"; echo "<meta http-equiv='refresh' content='3; url=setting.php'>"; exit; } $query = $DB->query("SELECT VERSION()"); //查询mysql版本信息 $curr_mysql_version = $DB->result($query, 0); if ($curr_mysql_version < '3.23') { //mysql版本< 3.23 echo "<font color=\"#FF0000\">您的MySQL版本低于3.23, 无法继续安装 ,建议您换 MySQL4 的数据库服务器。3秒后返回配置页面</font></br>"; echo "<font color=\"#FF0000\"><a href='setting.php'>立即返回</a></font>"; echo "<meta http-equiv='refresh' content='3; url=setting.php'>"; exit; } /**************执行建立数据库***************/ $DB->query("DROP DATABASE IF EXISTS {$dbname}"); if (mysql_get_server_info() > '4.1') { $DB->query("CREATE DATABASE {$dbname} DEFAULT CHARACTER SET {$dbcharset}"); } else { $DB->query("CREATE DATABASE {$dbname}"); } $DB->select_db($dbname); $tablenum = '0'; runquery($sqlfile, $DB, $db_prefix, $tablenum = '0', $dbcharset); //执行SQL 语句 }