|
Server : Apache System : Linux iZ6xhqomji47p1Z 5.10.134-15.al8.x86_64 #1 SMP Thu Jul 20 00:44:04 CST 2023 x86_64 User : www ( 1000) PHP Version : 8.1.30 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv Directory : /www/wwwroot/fsjlkj.cn/install/ |
<?php
include 'auto.php';
if(IS_SAE)
header("Location: index_sae.php");
// php最低版本要求
$mini_php = '5.4.0';
if (file_exists('./install.lock')) {
echo '
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
</head>
<body>
你已经安装过该系统，如果想重新安装，请先删除站点install目录下的 install.lock 文件，然后再安装。
</body>
</html>';
exit;
}
//防止备份数据过程超时
function_exists('set_time_limit') && set_time_limit(0);
@ini_set('memory_limit','-1');
if (phpversion() <= $mini_php)
@set_magic_quotes_runtime(0);
if ($mini_php > phpversion()){
header("Content-type:text/html;charset=utf-8");
die('本系统要求PHP版本 >= '.$mini_php.'，当前PHP版本为：'.phpversion() . '，请到虚拟主机控制面板里切换PHP版本，或联系空间商协助切换。<a href="http://www.eyoucms.com/help/" target="_blank">点击查看易优安装教程</a>');
}
define("EYOUCMS_VERSION", '20180101');
date_default_timezone_set('PRC');
error_reporting(E_ALL & ~E_NOTICE);
header('Content-Type: text/html; charset=UTF-8');
define('SITEDIR', _dir_path(substr(dirname(__FILE__), 0, -8)));
define("SERVICE_URL", 'aHR0cDovL3NlcnZpY2UuZXlvdWNtcy5jb20=');
//define('SITEDIR2', substr(SITEDIR,0,-7));
//echo SITEDIR2;
//exit;
$step = isset($_GET['step']) ? intval($_GET['step']) : 1;
//数据库
$sqlFile = 'eyoucms.sql';
$configFile = 'config.php';
if (!file_exists(SITEDIR . 'install/' . $sqlFile) || !file_exists(SITEDIR . 'install/' . $configFile)) {
echo "缺少必要的安装文件（{$sqlFile} 或 {$configFile}）!";
exit;
}
$Title = "EyouCMS安装向导";
$Powered = "Powered by EyouCMS";
$steps = array(
'1' => '安装许可协议',
'2' => '运行环境检测',
'3' => '安装参数设置',
'4' => '安装详细过程',
'5' => '安装完成',
);
//地址
$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':
session_start();
$_SESSION['isset_author'] = null;
session_destroy();
if (phpversion() < 5) {
die('本系统需要PHP5.4.0以上 + MYSQL >= 5.0环境，当前PHP版本为：' . phpversion());
}
$err = 0;
$phpv = @ phpversion();
if ($mini_php <= phpversion()){
$phpvStr = '<img src="images/ok.png">';
}else{
$phpvStr = '<img src="images/del.png"> <a href="http://www.eyoucms.com/wenda/3132.html" target="_blank">当前版本('.phpversion().')不支持</a>';
$err++;
}
$os = PHP_OS;
//$os = php_uname();
$tmp = function_exists('gd_info') ? gd_info() : array();
$server = $_SERVER["SERVER_SOFTWARE"];
$host = (empty($_SERVER["SERVER_ADDR"]) ? $_SERVER["SERVER_HOST"] : $_SERVER["SERVER_ADDR"]);
$name = $_SERVER["SERVER_NAME"];
$max_execution_time = ini_get('max_execution_time');
$allow_reference = (ini_get('allow_call_time_pass_reference') ? '<img src="images/ok.png">' : '<img src="images/del.png">');
$allow_url_fopen = (ini_get('allow_url_fopen') ? '<img src="images/ok.png">' : '<img src="images/del.png">');
$safe_mode = (ini_get('safe_mode') ? '<img src="images/del.png"> <a href="http://www.eyoucms.com/wenda/3125.html" target="_blank">详情</a>' : '<img src="images/ok.png">');
if (empty($tmp['GD Version'])) {
$gd = '<img src="images/del.png"> <a href="http://www.eyoucms.com/wenda/3126.html" target="_blank">详情</a>';
$err++;
} else {
$gd = '<img src="images/ok.png">';
}
if (function_exists('mysqli_connect')) {
$mysql = '<img src="images/ok.png">';
} else {
$mysql = '<img src="images/del.png"> <a href="http://www.eyoucms.com/wenda/3127.html" target="_blank">详情</a>';
$err++;
}
// if (ini_get('file_uploads')) {
// $uploadSize = '<img src="images/ok.png">';
// } else {
// $uploadSize = '<img src="images/del.png"> <a href="http://www.eyoucms.com/wenda/3128.html" target="_blank">详情</a>';
// }
if (class_exists('pdo')) {
$pdo = '<img src="images/ok.png">';
} else {
$pdo = '<img src="images/del.png"> <a href="http://www.eyoucms.com/wenda/3129.html" target="_blank">详情</a>';
$err++;
}
if (extension_loaded('pdo_mysql')) {
$pdo_mysql = '<img src="images/ok.png">';
} else {
$pdo_mysql = '<img src="images/del.png"> <a href="http://www.eyoucms.com/wenda/3129.html" target="_blank">详情</a>';
$err++;
}
/* if (function_exists('session_start')) {
$session = '<img src="images/ok.png">';
} else {
$session = '<img src="images/del.png"> <a href="http://www.eyoucms.com/wenda/7115.html" target="_blank">详情</a>';
$err++;
}*/
if(function_exists('curl_init')){
$curl = '<img src="images/ok.png">';
}else{
$curl = '<img src="images/del.png"> <a href="http://www.eyoucms.com/wenda/3130.html" target="_blank">详情</a>';
$err++;
}
if(function_exists('file_put_contents')){
$file_put_contents = '<img src="images/ok.png">';
}else{
$file_put_contents = '<img src="images/del.png"> <a href="http://www.eyoucms.com/wenda/3131.html" target="_blank">详情</a>';
$err++;
}
// if(function_exists('scandir')){
// $scandir = '<img src="images/ok.png">';
// }else{
// $scandir = '<img src="images/del.png">';
// $err++;
// }
$folder = array(
'install',
'uploads',
'data/runtime',
'application/admin/conf',
'application/config.php',
'application/database.php',
);
include_once ("./templates/step2.php");
exit();
case '3':
$dbName = !empty($_POST['dbName']) ? trim(addslashes($_POST['dbName'])) : '';
$dbUser = !empty($_POST['dbUser']) ? trim(addslashes($_POST['dbUser'])) : '';
$dbport = !empty($_POST['dbport']) ? trim(addslashes($_POST['dbport'])) : '3306';
$dbPwd = !empty($_POST['dbPwd']) ? trim($_POST['dbPwd']) : '';
$dbHost = !empty($_POST['dbHost']) ? addslashes($_POST['dbHost']) : '';
if (!empty($_GET['testdbpwd'])) {
$conn = @mysqli_connect($dbHost, $dbUser, $dbPwd,NULL,$dbport);
if (mysqli_connect_error()) {
die(json_encode(array(
'errcode' => 0,
'dbpwmsg' => "<span for='dbname' generated='true' class='tips_error'>数据库连接失败，请重新设定</span>",
)));
} else {
/*针对mysql5版本，结合程序本身一些复杂SQL进行sql_mode设置*/
// $result = mysqli_query($conn,"SELECT @@global.sql_mode");
// $result = $result->fetch_array();
// $version = mysqli_get_server_info($conn);
// if ($version >= 5)
// {
// if(strstr($result[0],'STRICT_ALL_TABLES') || strstr($result[0],'TRADITIONAL') || strstr($result[0],'ANSI') || strstr($result[0],'ONLY_FULL_GROUP_BY')) {
// die(json_encode(array(
// 'errcode' => -1,
// 'dbpwmsg' => "<span for='dbname' generated='true' class='tips_error'>请在mysql配置文件修改sql-mode或sql_mode</span> <a href='http://www.eyoucms.com/wenda/2799.html' target='_blank'>点击查看操作</a>",
// )));
// }
// }
/*--end*/
if (empty($dbName)) {
die(json_encode(array(
'errcode' => -2,
'dbpwmsg' => "<span class='green'>信息正确</span>",
'dbnamemsg' => "<span class='red'>数据库不能为空，请设定</span>",
)));
} else {
/*检测数据库是否存在*/
$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) { // 存在
$dbnamemsg = "<span class='red'>数据库已经存在，系统将覆盖数据库</span>";
} else { // 不存在
$dbnamemsg = "<span class='green'>数据库不存在，系统将自动创建</span>";
}
/*--end*/
}
die(json_encode(array(
'errcode' => 1,
'dbpwmsg' => "<span class='green'>信息正确</span>",
'dbnamemsg' => $dbnamemsg,
)));
}
}
else if (!empty($_GET['check']))
{
if (!function_exists('mysqli_connect')) {
$arr = array(
'code' => -1,
'msg' => "请安装 mysqli 扩展！",
);
die(json_encode($arr));
}
$conn = @mysqli_connect($dbHost, $dbUser, $dbPwd,NULL,$dbport);
if (mysqli_connect_error()){
$arr = array(
'code' => -1,
'msg' => "请检查数据库连接信息，".iconv('gbk', 'utf-8', mysqli_connect_error($conn)),
);
die(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 = array(
'code' => -1,
'msg' => '数据库版本('.$version.')太低！必须 >= 5.1',
);
die(json_encode($arr));
}
if (!@mysqli_select_db($conn,$dbName)) {
//创建数据时同时设置编码
if (!@mysqli_query($conn,"CREATE DATABASE IF NOT EXISTS `" . $dbName . "` DEFAULT CHARACTER SET utf8;")) {
$arr = array(
'code' => -1,
'msg' => '数据库 ' . $dbName . ' 不存在，也没权限创建新的数据库，建议联系空间商或者服务器负责人！',
);
die(json_encode($arr));
}
}
$arr = array(
'code' => 0,
'msg' => '',
);
die(json_encode($arr));
}
include_once ("./templates/step3.php");
exit();
case '4':
$arr = array();
$dbHost = trim(addslashes($_POST['dbhost']));
$dbport = !empty($_POST['dbport']) ? trim(addslashes($_POST['dbport'])) : '3306';
$dbName = trim(addslashes($_POST['dbname']));
$dbUser = trim(addslashes($_POST['dbuser']));
$dbPwd = trim($_POST['dbpw']);
$dbPrefix = empty($_POST['dbprefix']) ? 'ey_' : trim(addslashes($_POST['dbprefix']));
$username = trim(addslashes($_POST['manager']));
$password = trim($_POST['manager_pwd']);
$manager_ckpwd = trim($_POST['manager_ckpwd']);
if ($password != $manager_ckpwd) {
$arr['code'] = 0;
$arr['msg'] = "管理员密码与确认密码不一致！";
echo json_encode($arr);
exit;
}
if (!function_exists('mysqli_connect')) {
$arr['code'] = 0;
$arr['msg'] = "请安装 mysqli 扩展!";
echo json_encode($arr);
exit;
}
$conn = @mysqli_connect($dbHost, $dbUser, $dbPwd,NULL,$dbport);
if (mysqli_connect_error()){
$arr['code'] = 0;
$arr['msg'] = "连接数据库失败!".mysqli_connect_error($conn);
echo json_encode($arr);
exit;
}
mysqli_set_charset($conn, "utf8"); //,character_set_client=binary,sql_mode='';
$version = mysqli_get_server_info($conn);
if ($version < 5.1) {
$arr['code'] = 0;
$arr['msg'] = '数据库版本('.$version.')太低! 必须 >= 5.1';
echo json_encode($arr);
exit;
}
if (!@mysqli_select_db($conn,$dbName)) {
//创建数据时同时设置编码
if (!@mysqli_query($conn,"CREATE DATABASE IF NOT EXISTS `" . $dbName . "` DEFAULT CHARACTER SET utf8;")) {
$arr['code'] = 0;
$arr['msg'] = '数据库 ' . $dbName . ' 不存在，也没权限创建新的数据库，建议联系空间商或者服务器负责人！';
echo json_encode($arr);
exit;
}
mysqli_select_db($conn , $dbName);
}
// 当前CMS版本
$cms_version = file_get_contents(SITEDIR .'data/conf/version.txt');
//读取数据文件
$sqldata = file_get_contents(SITEDIR . 'install/' . $sqlFile);
$sqlFormat = sql_split($sqldata, $dbPrefix);
//创建写入sql数据库文件到库中 结束
/*检测对比数据库文件版本与CMS版本*/
preg_match_all('/--\s*Version\s*:\s*#(v\d+\.\d+\.\d+([0-9\.]*))/', $sqldata, $matches1);
$database_version = !empty($matches1[1][0]) ? $matches1[1][0] : ''; // 当前数据库版本
if (!empty($cms_version) && $database_version != $cms_version) {
$is_bool = true;
if (preg_match('/^v\d+\.\d+\.\d+([0-9\.]*)$/i', $database_version)) {
$is_bool = false;
} else {
// CMS版本对应的官方远程数据库的所有表名
$cms_datatableList = getRemoteDbTable($cms_version);
if (is_array($cms_datatableList)) {
// 获取当前安装目录下数据库文件的所有内置表的集合
$datatableList = getLocalDbTable($sqldata);
// 本地与官方的数据表对比校验
$diff_datatableList = array_diff($datatableList, $cms_datatableList);
if (count($datatableList) != count($cms_datatableList) || !empty($diff_datatableList)) {
$is_bool = false;
}
}
}
if (false === $is_bool) {
$database_version = !empty($database_version) ? $database_version :'无';
$arr['code'] = 0;
$arr['msg'] = "无法安装，数据库文件版本号(<font color='red'>{$database_version}</font>)与CMS源码版本号(<font color='red'>{$cms_version}</font>)不一致，<a href='http://www.eyoucms.com/wenda/7227.html' target='_blank'>点击查看</a>！";
echo json_encode($arr);
exit;
}
}
/*--end*/
/**
* 执行SQL语句
*/
$counts = count($sqlFormat);
for ($i = 0; $i < $counts; $i++) {
$sql = trim($sqlFormat[$i]);
if (strstr($sql, 'CREATE TABLE')) {
preg_match('/CREATE TABLE `([^ ]*)`/', $sql, $matches);
mysqli_query($conn,"DROP TABLE IF EXISTS `$matches[1]");
$ret = mysqli_query($conn,$sql);
if (!$ret) {
$message = '创建数据表' . $matches[1] . '失败，请尝试F5刷新!';
$arr['code'] = 0;
$arr = array('msg' => $message);
echo json_encode($arr);
exit;
}
} else {
if(trim($sql) == '')
continue;
preg_match('/INSERT INTO `([^ ]*)`/', $sql, $matches);
$ret = mysqli_query($conn,$sql);
if (!$ret) {
$message = '写入表' . $matches[1] . '记录失败，请尝试F5刷新!';
$arr['code'] = 0;
$arr = array('msg' => $message);
echo json_encode($arr);
exit;
}
}
}
// 清空测试数据
/* if(addslashes($_POST['demo']) != 'demo')
{
$result = mysqli_query($conn,"show tables");
$tables=$result->fetch_all(MYSQLI_NUM);//参数MYSQL_ASSOC、MYSQLI_NUM、MYSQLI_BOTH规定产生数组类型
$bl_table = array('ey_admin','ey_arcrank','ey_auth_role','ey_channelfield','ey_channeltype','ey_config','ey_download_attr_field','ey_field_type','ey_language','ey_language_mark','ey_language_pack','ey_product_spec_preset','ey_region','ey_shop_express','ey_shop_shipping_template','ey_smtp_tpl','ey_users_config','ey_users_level','ey_users_menu','ey_users_parameter');
foreach($bl_table as $k => $v)
{
$bl_table[$k] = preg_replace('/^ey_/i', $dbPrefix, $v);
}
foreach($tables as $key => $val)
{
if(!in_array($val[0], $bl_table))
{
mysqli_query($conn,"truncate table ".$val[0]);
}
}
delFile('../uploads'); // 清空测试图片
}*/
/*清空缓存*/
delFile('../data/runtime');
/*--end*/
$max_i = 999999999;
if ($max_i == $i) {
$arr['code'] = 0;
$arr['msg'] = "数据库文件过大，执行条数超过{$max_i}条，请联系技术协助！";
echo json_encode($arr);
exit;
// exit('-1');
}
$time = time();
//读取配置文件，并替换真实配置数据1
$strConfig = file_get_contents(SITEDIR . '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#', $dbport, $strConfig);
$strConfig = str_replace('#DB_PREFIX#', $dbPrefix, $strConfig);
$strConfig = str_replace('#DB_CHARSET#', 'utf8', $strConfig);
$strConfig = str_replace('#DB_DEBUG#', false, $strConfig);
@chmod(SITEDIR . 'application/database.php',0777); //数据库配置文件的地址
@file_put_contents(SITEDIR . 'application/database.php', $strConfig); //数据库配置文件的地址
//读取配置文件，并替换缓存前缀
$strConfig = file_get_contents(SITEDIR . 'application/config.php');
$uniqid_str = uniqid();
$uniqid_str = md5($uniqid_str);
$strConfig = str_replace('eyoucms_cache_prefix', $uniqid_str, $strConfig);
@chmod(SITEDIR . 'application/config.php',0777); //配置文件的地址
@file_put_contents(SITEDIR . 'application/config.php', $strConfig); //配置文件的地址
$web_cmspath = preg_replace('/(.*)\/install([\w]*)\/index\.php/i', '$1', $_SERVER['SCRIPT_NAME']);
$web_basehost = 'http://'.trim($_SERVER['HTTP_HOST'], '/').$web_cmspath;
//更新网站配置的网站网址
$sql = "UPDATE `{$dbPrefix}config` SET `value` = '$web_basehost' WHERE name = 'web_basehost' AND inc_type = 'web'";
mysqli_query($conn, $sql);
//更新网站配置的CMS安装路径
$sql = "UPDATE `{$dbPrefix}config` SET `value` = '$web_cmspath' WHERE name = 'web_cmspath' AND inc_type = 'web'";
mysqli_query($conn, $sql);
//更新网站配置的CMS版本号
$sql = "UPDATE `{$dbPrefix}config` SET `value` = '$cms_version' WHERE name = 'system_version' AND inc_type = 'system'";
mysqli_query($conn, $sql);
$auth_code = get_auth_code($conn, $dbPrefix);
$result = mysqli_query($conn, "SELECT admin_id FROM `{$dbPrefix}admin`");
$adminTotal = $result->num_rows;
if (1 >= intval($adminTotal)) {
mysqli_query($conn, "truncate table `{$dbPrefix}admin`"); // 清空admin表
// 密码加密串，新安装程序，或者没有用户的程序，才随机给密码加密串
$result2 = @mysqli_query($conn, "SELECT admin_id FROM `{$dbPrefix}users`");
if (!empty($result2->num_rows) && 1 == $result2->num_rows) {
while($row = mysqli_fetch_array($result2))
{
if (!empty($row['admin_id'])) {
$result2 = false;
break;
}
}
}
if (empty($result2) || empty($result2->num_rows)) {
mysqli_query($conn, "truncate table `{$dbPrefix}users`"); // 清空users表
$rand_str = md5(uniqid(rand(), true));
$rand_str = substr($rand_str, 0, 23);
$auth_code = '$2y$11$'.$rand_str; //30位盐
mysqli_query($conn, "UPDATE `{$dbPrefix}config` SET `value` = '$auth_code' WHERE name = 'system_crypt_auth_code' AND inc_type = 'system'");
mysqli_query($conn, "UPDATE `{$dbPrefix}config` SET `value` = '$auth_code' WHERE name = 'system_auth_code' AND inc_type = 'system'");
}
} else {
mysqli_query($conn, "DELETE FROM `{$dbPrefix}admin` WHERE user_name = '$username'");
}
//插入管理员表ey_admin
$encry_type = pwd_encry_type($conn, $dbPrefix);
if ('bcrypt' == $encry_type) {
$password = crypt(trim($_POST['manager_pwd']), $auth_code);
} else {
$password = md5($auth_code.trim($_POST['manager_pwd']));
}
$ip = get_client_ip();
$ip = empty($ip) ? "0.0.0.0" : $ip;
mysqli_query($conn, " INSERT INTO `{$dbPrefix}admin` (`user_name`,`true_name`,`password`,`last_login`,`last_ip`,`login_cnt`,`status`,`add_time`) VALUES ('$username','$username','$password','0','$ip','1','1','$time')");
$url = $_SERVER['PHP_SELF']."?step=5";
$arr['code'] = 1;
$arr['msg'] = "安装成功";
$arr['url'] = $url;
echo json_encode($arr);
exit;
case '5':
$ip = get_server_ip();
$host = $_SERVER['HTTP_HOST'];
$create_date = date("Ymdhis");
$time = time();
$phpv = urlencode(phpversion());
$web_server = urlencode($_SERVER['SERVER_SOFTWARE']);
$cms_version = file_get_contents(SITEDIR .'data/conf/version.txt'); // 当前CMS版本
$mt_rand_str = $create_date.sp_random_string(6);
$service_ey = base64_decode(SERVICE_URL);
$ajax_url = 'L2luZGV4LnBocD9tPWFwaSZjPVNlcnZpY2UmYT11c2VyX3B1c2g=';
$str_constant = "<?php".PHP_EOL."define('INSTALL_DATE',".$time.");".PHP_EOL."define('SERIALNUMBER','".$mt_rand_str."');";
@file_put_contents(SITEDIR . 'application/admin/conf/constant.php', $str_constant);
// 还原sqldata目录名
try {
$dirlist = glob(SITEDIR . 'data/sqldata_*');
$sqldata_path = current($dirlist);
if (!empty($sqldata_path)) {
$sqldata_path_tmp = str_replace('\\', '/', $sqldata_path);
$arr = explode('/', $sqldata_path_tmp);
$sqldata_dirname = end($arr);
if ($sqldata_dirname != 'sqldata') {
@rename(SITEDIR."data/{$sqldata_dirname}", SITEDIR."data/sqldata");
}
}
} catch (\Exception $e) {}
include_once ("./templates/step5.php");
@touch('./install.lock');
exit();
}
function testwrite($d) {
$tfile = "_test.txt";
$fp = @fopen($d . "/" . $tfile, "w");
if (!$fp) {
return false;
}
fclose($fp);
$rs = @unlink($d . "/" . $tfile);
if ($rs) {
return true;
}
return false;
}
function sql_execute($sql, $tablepre) {
$sqls = sql_split($sql, $tablepre);
if (is_array($sqls)) {
foreach ($sqls as $sql) {
if (trim($sql) != '') {
mysqli_query($sql);
}
}
} else {
mysqli_query($sqls);
}
return true;
}
function sql_split($sql, $tablepre) {
/*从安装目录的数据库文件，提取数据库文件里的表前缀*/
$prefix = 'ey_';
preg_match_all('/CREATE\s*TABLE\s*`([^`]+)\s*/', $sql, $matches2);
$datatableList = !empty($matches2[1]) ? $matches2[1] : []; // 数据库所有表名
if (!empty($datatableList)) {
foreach ($datatableList as $key => $val) {
if (preg_match('/_admin$/i', $val)) {
$prefix = preg_replace('/_admin$/i', '', $val).'_';
break;
}
}
}
/*--end*/
if ($tablepre != $prefix)
$sql = str_replace('`'.$prefix, '`'.$tablepre, $sql);
$sql = preg_replace("/TYPE=(InnoDB|MyISAM|MEMORY)( DEFAULT CHARSET=[^; ]+)?/", "ENGINE=\\1 DEFAULT CHARSET=utf8", $sql);
$sql = str_replace("\r", "\n", $sql);
$ret = array();
$num = 0;
$queriesarray = explode(";\n", trim($sql));
unset($sql);
foreach ($queriesarray as $query) {
$ret[$num] = '';
$queries = explode("\n", trim($query));
$queries = array_filter($queries);
foreach ($queries as $query) {
$str1 = substr($query, 0, 1);
if ($str1 != '#' && $str1 != '-')
$ret[$num] .= $query;
}
$num++;
}
return $ret;
}
function _dir_path($path) {
$path = str_replace('\\', '/', $path);
if (substr($path, -1) != '/')
$path = $path . '/';
return $path;
}
// 获取客户端IP地址
function get_client_ip() {
static $ip = NULL;
if ($ip !== NULL)
return $ip;
if (isset($_SERVER['HTTP_X_FORWARDED_FOR'])) {
$arr = explode(',', $_SERVER['HTTP_X_FORWARDED_FOR']);
$pos = array_search('unknown', $arr);
if (false !== $pos)
unset($arr[$pos]);
$ip = trim($arr[0]);
}elseif (isset($_SERVER['HTTP_CLIENT_IP'])) {
$ip = $_SERVER['HTTP_CLIENT_IP'];
} elseif (isset($_SERVER['REMOTE_ADDR'])) {
$ip = $_SERVER['REMOTE_ADDR'];
}
// IP地址合法验证
$ip = (false !== ip2long($ip)) ? $ip : '0.0.0.0';
return $ip;
}
// 服务器端IP
function get_server_ip()
{
// 会因为解析问题导致后台卡
if (!empty($_SERVER['SERVER_ADDR']) && !in_array($_SERVER['SERVER_ADDR'], ['127.0.0.1'])) {
$serviceIp = $_SERVER['SERVER_ADDR'];
} else {
$serviceIp = @gethostbyname($_SERVER["SERVER_NAME"]);
}
return $serviceIp;
}
function dir_create($path, $mode = 0777) {
if (is_dir($path))
return TRUE;
$ftp_enable = 0;
$path = dir_path($path);
$temp = explode('/', $path);
$cur_dir = '';
$max = count($temp) - 1;
for ($i = 0; $i < $max; $i++) {
$cur_dir .= $temp[$i] . '/';
if (@is_dir($cur_dir))
continue;
@mkdir($cur_dir, 0777, true);
@chmod($cur_dir, 0777);
}
return is_dir($path);
}
function dir_path($path) {
$path = str_replace('\\', '/', $path);
if (substr($path, -1) != '/')
$path = $path . '/';
return $path;
}
function sp_password($pw, $pre){
$decor = md5($pre);
$mi = md5($pw);
return substr($decor,0,12).$mi.substr($decor,-4,4);
}
function sp_random_string($len = 8) {
$chars = array(
"a", "b", "c", "d", "e", "f", "g", "h", "i", "j", "k",
"l", "m", "n", "o", "p", "q", "r", "s", "t", "u", "v",
"w", "x", "y", "z", "A", "B", "C", "D", "E", "F", "G",
"H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R",
"S", "T", "U", "V", "W", "X", "Y", "Z", "0", "1", "2",
"3", "4", "5", "6", "7", "8", "9"
);
$charsLen = count($chars) - 1;
shuffle($chars); // 将数组打乱
$output = "";
for ($i = 0; $i < $len; $i++) {
$output .= $chars[mt_rand(0, $charsLen)];
}
return $output;
}
// 递归删除文件夹
function delFile($dir,$file_type='') {
if(is_dir($dir)){
$files = scandir($dir);
//打开目录 //列出目录中的所有文件并去掉 . 和 ..
foreach($files as $filename){
if($filename!='.' && $filename!='..'){
if(!is_dir($dir.'/'.$filename)){
if(empty($file_type)){
unlink($dir.'/'.$filename);
}else{
if(is_array($file_type)){
//正则匹配指定文件
if(preg_match($file_type[0],$filename)){
unlink($dir.'/'.$filename);
}
}else{
//指定包含某些字符串的文件
if(false!=stristr($filename,$file_type)){
unlink($dir.'/'.$filename);
}
}
}
}else{
delFile($dir.'/'.$filename);
rmdir($dir.'/'.$filename);
}
}
}
}else{
if(file_exists($dir)) unlink($dir);
}
}
/**
* 获取当前CMS版本对应的官方远程数据库所有内置表的集合
*/
function getRemoteDbTable($version = '')
{
if (empty($version)) {
return false;
}
$service_ey = SERVICE_URL;
$tmp_str = 'L2luZGV4LnBocD9tPWFwaSZjPVNlcnZpY2UmYT1nZXRfZGF0YWJhc2VfdHh0';
$service_url = base64_decode($service_ey).base64_decode($tmp_str);
$url = $service_url . '&version=' . $version;
$context = stream_context_set_default(array('http' => array('timeout' => 3,'method'=>'GET')));
$response = @file_get_contents($url,false,$context);
$params = json_decode($response,true);
if (is_array($params)) {
/*------------------组合官方远程数据库信息----------------------*/
$info = $params['info'];
$info = preg_replace("#[\r\n]{1,}#", "\n", $info);
$infos = explode("\n", $info);
$infolists = [];
foreach ($infos as $key => $val) {
if (!empty($val)) {
$arr = explode('|', $val);
$infolists[$arr[0]] = $val;
}
}
$cms_datatableList = array_keys($infolists);
/*------------------end----------------------*/
return $cms_datatableList;
} else {
return false;
}
}
/**
* 获取当前安装目录下数据库文件的所有内置表的集合
*/
function getLocalDbTable($sqldata = '')
{
/*从安装目录的数据库文件，提取出排除插件之外的数据表*/
preg_match_all('/CREATE\s*TABLE\s*`([^`]+)\s*/', $sqldata, $matches2);
$datatableList = !empty($matches2[1]) ? $matches2[1] : []; // 数据库所有表名
if (!empty($datatableList)) {
/*获取数据库文件里的表前缀*/
foreach ($datatableList as $key => $val) {
if (preg_match('/_admin$/i', $val)) {
$old_prefix = preg_replace('/_admin$/i', '', $val).'_';
break;
}
}
/*--end*/
/*过滤插件数据表，只保留与内置数据表*/
$new_datatableList = [];
foreach ($datatableList as $key => $val) {
if (!preg_match('/^'.$old_prefix.'weapp_/i', $val)) {
$new_datatableList[] = preg_replace('/^'.$old_prefix.'/i', 'ey_', $val);
}
}
$datatableList = $new_datatableList;
/*--end*/
}
/*--end*/
return $datatableList;
}
/**
* 获取密码加密方式
* @return [type] [description]
*/
function pwd_encry_type($conn, $dbPrefix)
{
// 识别admin表的字段长度是否支持新版加密方式
$is_newpwd_field = 0;
$ret = @mysqli_query($conn, "DESCRIBE `{$dbPrefix}admin`");
while($row = mysqli_fetch_array($ret))
{
if (!empty($row['Field']) && $row['Field'] == 'password') {
if (!stristr($row['Type'], '(32)')) {
$is_newpwd_field = 1;
break;
}
}
}
if (!empty($is_newpwd_field) && defined('CRYPT_BLOWFISH') && CRYPT_BLOWFISH == 1) {
$entry = 'bcrypt';
} else {
$entry = 'md5';
}
return $entry;
}
/**
* 密码加密串
*/
function get_auth_code($conn, $dbPrefix)
{
$encry_type = pwd_encry_type($conn, $dbPrefix);
if ('bcrypt' == $encry_type) {
$rand_str = md5(uniqid(rand(), true));
$rand_str = substr($rand_str, 0, 23);
$auth_code = '$2y$11$'.$rand_str; //30位盐
$result = mysqli_query($conn, " SELECT value FROM `{$dbPrefix}config` WHERE name = 'system_crypt_auth_code' AND inc_type = 'system' LIMIT 1 ");
if (0 < $result->num_rows) {
while($row = mysqli_fetch_array($result))
{
$auth_code = $row['value'];
}
} else {
$time = time();
mysqli_query($conn, " INSERT INTO `{$dbPrefix}config` (`name`,`value`,`inc_type`,`update_time`) VALUES ('system_crypt_auth_code','$auth_code','system','$time')");
}
} else {
$auth_code = '!*&^eyoucms<>|?';
$result = mysqli_query($conn, " SELECT value FROM `{$dbPrefix}config` WHERE name = 'system_auth_code' AND inc_type = 'system' LIMIT 1 ");
if (0 < $result->num_rows) {
while($row = mysqli_fetch_array($result))
{
$auth_code = $row['value'];
}
} else {
$time = time();
mysqli_query($conn, " INSERT INTO `{$dbPrefix}config` (`name`,`value`,`inc_type`,`update_time`) VALUES ('system_auth_code','$auth_code','system','$time')");
}
}
return $auth_code;
}
/**
* 加密函数
*
* @access public
* @param string $string 字符串
* @param string $operation 操作
* @return string
*/
function mchStrCode($string, $operation = 'ENCODE')
{
$key_length = 4;
$expiry = 0;
$key = md5('0701-eyoucms');
$fixedkey = md5($key);
$egiskeys = md5(substr($fixedkey, 16, 16));
$runtokey = $key_length ? ($operation == 'ENCODE' ? substr(md5(microtime(true)), -$key_length) : substr($string, 0, $key_length)) : '';
$keys = md5(substr($runtokey, 0, 16) . substr($fixedkey, 0, 16) . substr($runtokey, 16) . substr($fixedkey, 16));
$string = $operation == 'ENCODE' ? sprintf('%010d', $expiry ? $expiry + time() : 0) . substr(md5($string . $egiskeys), 0, 16) . $string : base64_decode(substr($string, $key_length));
$i = 0;
$result = '';
$string_length = strlen($string);
for ($i = 0; $i < $string_length; $i++) {
$result .= chr(ord($string[$i]) ^ ord($keys[$i % 32]));
}
if ($operation == 'ENCODE') {
return $runtokey . str_replace('=', '', base64_encode($result));
} else {
if ((substr($result, 0, 10) == 0 || substr($result, 0, 10) - time() > 0) && substr($result, 10, 16) == substr(md5(substr($result, 26) . $egiskeys), 0, 16)) {
return substr($result, 26);
} else {
return '';
}
}
}
/**
* CURL请求
*
* @param $url 请求url地址
* @param $method 请求方法 get post
* @param null $postfields post数据数组
* @param array $headers 请求header信息
* @param bool|false $debug 调试开启 默认false
* @return mixed
*/
function httpRequest($url, $method = "GET", $postfields = null, $headers = array(), $timeout = 30, $debug = false)
{
$method = strtoupper($method);
$ci = curl_init();
/* Curl settings */
// curl_setopt($ci, CURLOPT_HTTP_VERSION, CURL_HTTP_VERSION_1_0);
curl_setopt($ci, CURLOPT_USERAGENT, "Mozilla/5.0 (Windows NT 6.2; WOW64; rv:34.0) Gecko/20100101 Firefox/34.0");
curl_setopt($ci, CURLOPT_CONNECTTIMEOUT, 60); /* 在发起连接前等待的时间，如果设置为0，则无限等待 */
// curl_setopt($ci, CURLOPT_TIMEOUT, 7); /* 设置cURL允许执行的最长秒数 */
curl_setopt($ci, CURLOPT_TIMEOUT, $timeout); /* 设置cURL允许执行的最长秒数 */
curl_setopt($ci, CURLOPT_RETURNTRANSFER, true);
switch ($method) {
case "POST":
curl_setopt($ci, CURLOPT_POST, true);
if (!empty($postfields)) {
$tmpdatastr = is_array($postfields) ? http_build_query($postfields) : $postfields;
curl_setopt($ci, CURLOPT_POSTFIELDS, $tmpdatastr);
}
break;
default:
curl_setopt($ci, CURLOPT_CUSTOMREQUEST, $method); /* //设置请求方式 */
break;
}
$ssl = preg_match('/^https:\/\//i', $url) ? TRUE : FALSE;
curl_setopt($ci, CURLOPT_URL, $url);
if ($ssl) {
curl_setopt($ci, CURLOPT_SSL_VERIFYPEER, FALSE); // https请求 不验证证书和hosts
curl_setopt($ci, CURLOPT_SSL_VERIFYHOST, FALSE); // 不从证书中检查SSL加密算法是否存在
}
//curl_setopt($ci, CURLOPT_HEADER, true); /*启用时会将头文件的信息作为数据流输出*/
if (ini_get('open_basedir') == '' && ini_get('safe_mode' == 'Off')) {
curl_setopt($ci, CURLOPT_FOLLOWLOCATION, 1);
}
curl_setopt($ci, CURLOPT_MAXREDIRS, 2);/*指定最多的HTTP重定向的数量，这个选项是和CURLOPT_FOLLOWLOCATION一起使用的*/
curl_setopt($ci, CURLOPT_HTTPHEADER, $headers);
curl_setopt($ci, CURLINFO_HEADER_OUT, true);
/*curl_setopt($ci, CURLOPT_COOKIE, $Cookiestr); * *COOKIE带过去** */
$response = curl_exec($ci);
$requestinfo = curl_getinfo($ci);
$http_code = curl_getinfo($ci, CURLINFO_HTTP_CODE);
if ($debug) {
echo "=====post data======\r\n";
var_dump($postfields);
echo "=====info===== \r\n";
print_r($requestinfo);
echo "=====response=====\r\n";
print_r($response);
}
curl_close($ci);
return $response;
//return array($http_code, $response,$requestinfo);
}
/**
* 读取被禁止外部访问的配置文件
*
*/
function read_bidden_inc($phpfilepath = '')
{
$data = @file($phpfilepath);
if ($data) {
$data = !empty($data[1]) ? json_decode(mchStrCode($data[1], 'DECODE'), true) : [];
}
return $data;
}
/**
* 写入被禁止外部访问的配置文件
*/
function write_bidden_inc($arr = array(), $phpfilepath = '')
{
$r = tp_mkdir(dirname($phpfilepath));
if ($r) {
$setting = "<?php die('forbidden'); ?>\n";
$setting .= mchStrCode(json_encode($arr), 'ENCODE');
$setting = str_replace("\/", "/", $setting);
$incFile = fopen($phpfilepath, "w+");
if (fwrite($incFile, $setting)) {
fclose($incFile);
return true;
} else {
return false;
}
}
}
/**
* 递归创建目录
*
* @param string $path 目录路径，不带反斜杠
* @param intval $purview 目录权限码
* @return boolean
*/
function tp_mkdir($path, $purview = 0777)
{
if (!is_dir($path)) {
tp_mkdir(dirname($path), $purview);
if (!mkdir($path, $purview)) {
return false;
}
}
return true;
}
?>