phpversion()) {
exit('您的php版本过低，不能安装本软件，兼容php版本7.1~7.4，谢谢！');
}
if (phpversion() >= '8.0.0') {
exit('您的php版本太高，不能安装本软件，兼容php版本7.1~7.4，谢谢！');
}
date_default_timezone_set('PRC');
error_reporting(E_ALL & ~E_NOTICE);
header('Content-Type: text/html; charset=UTF-8');
//数据库
$sqlFile = 'crmeb.sql';
$configFile = '.env';
if (!file_exists(SITE_DIR . 'install/' . $sqlFile) || !file_exists(SITE_DIR . 'install/' . $configFile)) {
echo '缺少必要的安装文件!';
exit;
}
$Title = "CRMEB安装向导";
$Powered = "Powered by CRMEB";
$steps = array(
'1' => '安装许可协议',
'2' => '运行环境检测',
'3' => '安装参数设置',
'4' => '安装详细过程',
'5' => '安装完成',
);
$step = $_GET['step'] ?? 1;
//地址
$scriptName = !empty($_SERVER["REQUEST_URI"]) ? $scriptName = $_SERVER["REQUEST_URI"] : $scriptName = $_SERVER["PHP_SELF"];
$rootPath = @preg_replace("/\/(I|i)nstall\/index\.php(.*)$/", "", $scriptName);
$domain = empty($_SERVER['HTTP_HOST']) ? $_SERVER['HTTP_HOST'] : $_SERVER['SERVER_NAME'];
if ((int)$_SERVER['SERVER_PORT'] != 80) {
$domain .= ":" . $_SERVER['SERVER_PORT'];
}
$domain = $domain . $rootPath;
switch ($step) {
case '1':
include_once("./templates/step1.php");
exit();
case '2':
if (phpversion() < '7.1.0' || phpversion() >= '8.0.0') {
die('本系统需要PHP为 7.1~7.4 版本，当前PHP版本为：' . phpversion());
}
$passOne = $passTwo = 'yes';
$os = PHP_OS;
$server = $_SERVER["SERVER_SOFTWARE"];
$phpv = phpversion();
if (ini_get('file_uploads')) {
$uploadSize = '
' . ini_get('upload_max_filesize');
} else {
$passOne = 'no';
$uploadSize = '
禁止上传';
}
if (function_exists('session_start')) {
$session = '启用';
} else {
$passOne = 'no';
$session = '关闭';
}
if (!ini_get('safe_mode')) {
$safe_mode = '启用';
} else {
$passOne = 'no';
$safe_mode = '关闭';
}
$tmp = function_exists('gd_info') ? gd_info() : array();
if (!empty($tmp['GD Version'])) {
$gd = '' . $tmp['GD Version'];
} else {
$passOne = 'no';
$gd = '未安装';
}
if (function_exists('mysqli_connect')) {
$mysql = '已安装';
} else {
$passOne = 'no';
$mysql = '请安装mysqli扩展';
}
if (function_exists('curl_init')) {
$curl = '启用';
} else {
$passOne = 'no';
$curl = '关闭';
}
if (function_exists('bcadd')) {
$bcmath = '启用';
} else {
$passOne = 'no';
$bcmath = '关闭';
}
if (function_exists('openssl_encrypt')) {
$openssl = '启用';
} else {
$passOne = 'no';
$openssl = '关闭';
}
$folder = array(
'backup',
'public',
'runtime',
);
foreach ($folder as $dir) {
if (!is_file(APP_DIR . $dir)) {
if (!is_dir(APP_DIR . $dir)) {
dir_create(APP_DIR . $dir);
}
}
if (!testwrite(APP_DIR . $dir) || !is_readable(APP_DIR . $dir)) {
$passTwo = 'no';
}
}
$file = array(
'.env',
'.version',
'.constant',
);
foreach ($file as $filename) {
if (!is_writeable(APP_DIR . $filename) || !is_readable(APP_DIR . $filename)) {
$passTwo = 'no';
}
}
include_once("./templates/step2.php");
exit();
case '3':
$dbName = strtolower(trim($_POST['dbName']));
$_POST['dbport'] = $_POST['dbport'] ?: '3306';
if ($_GET['mysqldbpwd']) {
$dbHost = $_POST['dbHost'];
$conn = mysqli_init();
mysqli_options($conn, MYSQLI_OPT_CONNECT_TIMEOUT, 2);
@mysqli_real_connect($conn, $dbHost, $_POST['dbUser'], $_POST['dbPwd'], NULL, $_POST['dbport']);
if ($error = mysqli_connect_errno($conn)) {
if ($error == 2002) {
die(json_encode(2002));//地址或端口错误
} else if ($error == 1045) {
die(json_encode(1045));//用户名或密码错误
} else {
die(json_encode(-1));//链接失败
}
} else {
if (mysqli_get_server_info($conn) < 5.1) {
die(json_encode(-5));//版本过低
}
$result = mysqli_query($conn, "SELECT @@global.sql_mode");
$result = $result->fetch_array();
$version = mysqli_get_server_info($conn);
if ($version >= 5.7) {
if (strstr($result[0], 'STRICT_TRANS_TABLES') || strstr($result[0], 'STRICT_ALL_TABLES') || strstr($result[0], 'TRADITIONAL') || strstr($result[0], 'ANSI'))
exit(json_encode(-2));//数据库配置需要修改
}
$result = mysqli_query($conn, "select count(table_name) as c from information_schema.`TABLES` where table_schema='$dbName'");
$result = $result->fetch_array();
if ($result['c'] > 0) {
mysqli_close($conn);
exit(json_encode(-3));//数据库存在
} else {
if (!mysqli_select_db($conn, $dbName)) {
//创建数据时同时设置编码
if (!mysqli_query($conn, "CREATE DATABASE IF NOT EXISTS `" . $dbName . "` DEFAULT CHARACTER SET utf8;")) {
exit(json_encode(-4));//无权限创建数据库
} else {
mysqli_query($conn, "DROP DATABASE `" . $dbName . "` ;");
mysqli_close($conn);
exit(json_encode(1));//数据库配置成功
}
} else {
mysqli_close($conn);
exit(json_encode(1));//数据库配置成功
}
}
}
}
if ($_GET['redisdbpwd']) {
//redis数据库信息
$rbhost = $_POST['rbhost'] ?? '127.0.0.1';
$rbport = $_POST['rbport'] ?? 6379;
$rbpw = $_POST['rbpw'] ?? '';
$rbselect = $_POST['rbselect'] ?? 0;
try {
if (!class_exists('redis')) {
exit(json_encode(-1));
}
$redis = new Redis();
if (!$redis) {
exit(json_encode(-1));
}
$redis->connect($rbhost, $rbport);
if ($rbpw) {
$redis->auth($rbpw);
}
if ($rbselect) {
$redis->select($rbselect);
}
$res = $redis->set('install', 1, 10);
if ($res) {
exit(json_encode(1));
} else {
exit(json_encode(-3));
}
} catch (Throwable $e) {
exit(json_encode(-3));
}
}
include_once("./templates/step3.php");
exit();
case '4':
if (intval($_GET['install'])) {
$n = intval($_GET['n']);
if ($n == 999999)
exit;
$arr = array();
$dbHost = trim($_POST['dbhost']);
$_POST['dbport'] = $_POST['dbport'] ?: '3306';
$dbName = strtolower(trim($_POST['dbname']));
$dbUser = trim($_POST['dbuser']);
$dbPwd = trim($_POST['dbpw']);
$dbPrefix = empty($_POST['dbprefix']) ? 'eb_' : trim($_POST['dbprefix']);
$username = trim($_POST['manager']);
$password = trim($_POST['manager_pwd']) ?: 'crmeb.com';
if (!function_exists('mysqli_connect')) {
$arr['msg'] = "请安装 mysqli 扩展!";
exit(json_encode($arr));
}
$conn = @mysqli_connect($dbHost, $dbUser, $dbPwd, NULL, $_POST['dbport']);
if (mysqli_connect_errno($conn)) {
$arr['msg'] = "连接数据库失败!" . mysqli_connect_error($conn);
exit(json_encode($arr));
}
mysqli_set_charset($conn, "utf8"); //,character_set_client=binary,sql_mode='';
$version = mysqli_get_server_info($conn);
if ($version < 5.1) {
$arr['msg'] = '数据库版本太低! 必须5.1以上';
exit(json_encode($arr));
}
if (!mysqli_select_db($conn, $dbName)) {
//创建数据时同时设置编码
if (!mysqli_query($conn, "CREATE DATABASE IF NOT EXISTS `" . $dbName . "` DEFAULT CHARACTER SET utf8;")) {
$arr['msg'] = '数据库 ' . $dbName . ' 不存在，也没权限创建新的数据库！';
exit(json_encode($arr));
}
if ($n == -1) {
$arr['n'] = 0;
$arr['msg'] = "成功创建数据库:{$dbName}";
exit(json_encode($arr));
}
mysqli_select_db($conn, $dbName);
}
//读取数据文件
$sqldata = file_get_contents(SITE_DIR . 'install/' . $sqlFile);
$sqlFormat = sql_split($sqldata, $dbPrefix);
//创建写入sql数据库文件到库中 结束
/**
* 执行SQL语句
*/
$counts = count($sqlFormat);
for ($i = $n; $i < $counts; $i++) {
$sql = trim($sqlFormat[$i]);
if (strstr($sql, 'CREATE TABLE')) {
preg_match('/CREATE TABLE (IF NOT EXISTS)? `eb_([^ ]*)`/is', $sql, $matches);
mysqli_query($conn, "DROP TABLE IF EXISTS `$matches[2]");
$sql = str_replace('`eb_', '`' . $dbPrefix, $sql);//替换表前缀
$ret = mysqli_query($conn, $sql);
if ($ret) {
$message = '创建数据表[' . $dbPrefix . $matches[2] . ']完成!';
} else {
$err = mysqli_error($conn);
$message = '创建数据表[' . $dbPrefix . $matches[2] . ']失败!失败原因：' . $err;
}
$i++;
$arr = array('n' => $i, 'count' => $counts, 'msg' => $message, 'time' => date('Y-m-d H:i:s'));
exit(json_encode($arr));
} else {
if (trim($sql) == '')
continue;
$sql = str_replace('`eb_', '`' . $dbPrefix, $sql);//替换表前缀
$sql = str_replace('demo.crmeb.com', $_SERVER['SERVER_NAME'], $sql);//替换图片域名
$ret = mysqli_query($conn, $sql);
$message = '';
$arr = array('n' => $i, 'count' => $counts, 'msg' => $message, 'time' => date('Y-m-d H:i:s'));
}
}
// 清空测试数据
if (!$_POST['demo']) {
$result = mysqli_query($conn, "show tables");
$tables = mysqli_fetch_all($result);//参数MYSQL_ASSOC、MYSQLI_NUM、MYSQLI_BOTH规定产生数组类型
$bl_table = array('eb_system_admin'
, 'eb_system_role'
, 'eb_cache'
, 'eb_agent_level'
, 'eb_page_link'
, 'eb_page_categroy'
, 'eb_system_config'
, 'eb_system_config_tab'
, 'eb_system_menus'
, 'eb_system_notification'
, 'eb_express'
, 'eb_system_group'
, 'eb_system_group_data'
, 'eb_lang_code'
, 'eb_lang_country'
, 'eb_lang_type'
, 'eb_template_message'
, 'eb_shipping_templates'
, "eb_shipping_templates_region"
, 'eb_system_city'
, 'eb_diy'
, 'eb_member_ship'
, 'eb_system_timer'
, 'eb_member_right'
, 'eb_agreement'
, 'eb_store_service_speechcraft'
, 'eb_system_user_level'
, 'eb_out_interface'
, 'eb_cache');
foreach ($bl_table as $k => $v) {
$bl_table[$k] = str_replace('eb_', $dbPrefix, $v);
}
foreach ($tables as $key => $val) {
if (!in_array($val[0], $bl_table)) {
mysqli_query($conn, "truncate table " . $val[0]);
}
}
}
$unique = uniqid();
//读取配置文件，并替换真实配置数据1
$strConfig = file_get_contents(SITE_DIR . 'install/' . $configFile);
$strConfig = str_replace('#DB_HOST#', $dbHost, $strConfig);
$strConfig = str_replace('#DB_NAME#', $dbName, $strConfig);
$strConfig = str_replace('#DB_USER#', $dbUser, $strConfig);
$strConfig = str_replace('#DB_PWD#', $dbPwd, $strConfig);
$strConfig = str_replace('#DB_PORT#', $_POST['dbport'], $strConfig);
$strConfig = str_replace('#DB_PREFIX#', $dbPrefix, $strConfig);
$strConfig = str_replace('#DB_CHARSET#', 'utf8', $strConfig);
//缓存配置
$cachetype = $_POST['cache_type'] == 0 ? 'file' : 'redis';
$strConfig = str_replace('#CACHE_TYPE#', $cachetype, $strConfig);
$strConfig = str_replace('#CACHE_PREFIX#', 'cache_' . $unique . ':', $strConfig);
$strConfig = str_replace('#CACHE_TAG_PREFIX#', 'cache_tag_' . $unique . ':', $strConfig);
//redis数据库信息
$rbhost = $_POST['rbhost'] ?? '127.0.0.1';
$rbport = $_POST['rbport'] ?? '6379';
$rbpw = $_POST['rbpw'] ?? '';
$rbselect = $_POST['rbselect'] ?? 0;
$strConfig = str_replace('#RB_HOST#', $rbhost, $strConfig);
$strConfig = str_replace('#RB_PORT#', $rbport, $strConfig);
$strConfig = str_replace('#RB_PWD#', $rbpw, $strConfig);
$strConfig = str_replace('#RB_SELECT#', $rbselect, $strConfig);
//需改队列名称
$strConfig = str_replace('#QUEUE_NAME#', $unique, $strConfig);
@chmod(APP_DIR . '/.env', 0777); //数据库配置文件的地址
@file_put_contents(APP_DIR . '/.env', $strConfig); //数据库配置文件的地址
//插入管理员表字段tp_admin表
$time = time();
$ip = get_client_ip();
$ip = empty($ip) ? "0.0.0.0" : $ip;
$password = password_hash($_POST['manager_pwd'], PASSWORD_BCRYPT);
mysqli_query($conn, "truncate table {$dbPrefix}system_admin");
$addadminsql = "INSERT INTO `{$dbPrefix}system_admin` (`id`, `account`, `head_pic`, `pwd`, `real_name`, `roles`, `last_ip`, `last_time`, `add_time`, `login_count`, `level`, `status`, `is_del`) VALUES
(1, '" . $username . "', '/statics/system_images/admin_head_pic.png', '" . $password . "', 'admin', '1', '" . $ip . "',$time , $time, 0, 0, 1, 0)";
$res = mysqli_query($conn, $addadminsql);
$res2 = true;
if (isset($_SERVER['SERVER_NAME'])) {
if (isset($_SERVER['REQUEST_SCHEME'])) {
$request_scheme = $_SERVER['REQUEST_SCHEME'];
} else {
if ($_SERVER['HTTPS'] == 'on') {
$request_scheme = 'https';
} else {
$request_scheme = 'http';
}
}
$site_url = '\'"' . $request_scheme . '://' . $_SERVER['SERVER_NAME'] . '"\'';
$res2 = mysqli_query($conn, 'UPDATE `' . $dbPrefix . 'system_config` SET `value`=' . $site_url . ' WHERE `menu_name`="site_url"');
}
$arr = array('n' => 999999, 'count' => $counts, 'msg' => '安装完成', 'time' => date('Y-m-d H:i:s'));
exit(json_encode($arr));
}
include_once("./templates/step4.php");
exit();
case '5':
$ip = get_client_ip();
$host = $_SERVER['HTTP_HOST'];
$curent_version = getversion();
$version = trim($curent_version['version']);
$platform = trim($curent_version['platform']);
installlog();
include_once("./templates/step5.php");
@touch('../install.lock');
generateSignature();
exit();
}
//读取版本号
function getversion()
{
$version_arr = [];
$curent_version = @file(APP_DIR . '.version');
foreach ($curent_version as $val) {
list($k, $v) = explode('=', $val);
$version_arr[$k] = $v;
}
return $version_arr;
}
//写入安装信息
function installlog()
{
$mt_rand_str = sp_random_string(6);
$str_constant = "
' . $str . '