index.php 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664
  1. <?php
  2. include 'auto.php';
  3. if (IS_SAE)
  4. header("Location: index_sae.php");
  5. define('APP_DIR', _dir_path(substr(dirname(__FILE__), 0, -15)));//项目目录
  6. define('SITE_DIR', _dir_path(substr(dirname(__FILE__), 0, -8)));//入口文件目录
  7. if (file_exists('./install.lock')) {
  8. echo '
  9. <html>
  10. <head>
  11. <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
  12. </head>
  13. <body>
  14. 你已经安装过该系统,如果想重新安装,请先删除install目录下的 install.lock 文件,然后再安装。
  15. </body>
  16. </html>';
  17. exit;
  18. }
  19. @set_time_limit(1000);
  20. if (PHP_EDITION > phpversion()) {
  21. header("Content-type:text/html;charset=utf-8");
  22. exit('您的php版本过低,不能安装本软件,请升级到' . PHP_EDITION . '或更高版本再安装,谢谢!');
  23. }
  24. if (phpversion() > '8.0') {
  25. header("Content-type:text/html;charset=utf-8");
  26. exit('您的php版本太高,不能安装本软件,php版本7.2,谢谢!');
  27. }
  28. define("CRMEB_VERSION", '20180601');
  29. date_default_timezone_set('PRC');
  30. error_reporting(E_ALL & ~E_NOTICE);
  31. header('Content-Type: text/html; charset=UTF-8');
  32. //define('SITEDIR2', substr(SITEDIR,0,-7));
  33. //echo SITEDIR;
  34. //exit;SITE_DIR
  35. //数据库
  36. $sqlFile = 'oddjob.sql';
  37. $configFile = '.env';
  38. if (!file_exists(SITE_DIR . 'install/' . $sqlFile) || !file_exists(SITE_DIR . 'install/' . $configFile)) {
  39. echo '缺少必要的安装文件!';
  40. exit;
  41. }
  42. $Title = "微客零工驿站安装向导";
  43. $Powered = "Powered by wike.cc";
  44. $steps = array(
  45. '1' => '安装许可协议',
  46. '2' => '运行环境检测',
  47. '3' => '安装参数设置',
  48. '4' => '安装详细过程',
  49. '5' => '安装完成',
  50. );
  51. $step = $_GET['step'] ?? 1;
  52. //地址
  53. $scriptName = !empty($_SERVER["REQUEST_URI"]) ? $scriptName = $_SERVER["REQUEST_URI"] : $scriptName = $_SERVER["PHP_SELF"];
  54. $rootpath = @preg_replace("/\/(I|i)nstall\/index\.php(.*)$/", "", $scriptName);
  55. $domain = empty($_SERVER['HTTP_HOST']) ? $_SERVER['HTTP_HOST'] : $_SERVER['SERVER_NAME'];
  56. if ((int)$_SERVER['SERVER_PORT'] != 80) {
  57. $domain .= ":" . $_SERVER['SERVER_PORT'];
  58. }
  59. $domain = $domain . $rootpath;
  60. switch ($step) {
  61. case '1':
  62. include_once("./templates/step1.php");
  63. exit();
  64. case '2':
  65. if (phpversion() <= PHP_EDITION) {
  66. die('本系统需要PHP版本 >= ' . PHP_EDITION . '环境,当前PHP版本为:' . phpversion());
  67. }
  68. $phpv = @ phpversion();
  69. $os = PHP_OS;
  70. //$os = php_uname();
  71. $tmp = function_exists('gd_info') ? gd_info() : array();
  72. $server = $_SERVER["SERVER_SOFTWARE"];
  73. $host = (empty($_SERVER["SERVER_ADDR"]) ? $_SERVER["SERVER_HOST"] : $_SERVER["SERVER_ADDR"]);
  74. $name = $_SERVER["SERVER_NAME"];
  75. $max_execution_time = ini_get('max_execution_time');
  76. $allow_reference = (ini_get('allow_call_time_pass_reference') ? '<font color=green>[√]On</font>' : '<font color=red>[×]Off</font>');
  77. $allow_url_fopen = (ini_get('allow_url_fopen') ? '<font color=green>[√]On</font>' : '<font color=red>[×]Off</font>');
  78. $safe_mode = (ini_get('safe_mode') ? '<span class="correct_span error_span">&radic;</span> 关闭' : '<span class="correct_span">&radic;</span> 启用');
  79. $err = 0;
  80. if (empty($tmp['GD Version'])) {
  81. $gd = '<span class="correct_span error_span">&radic;</span> 未安装';
  82. $err++;
  83. } else {
  84. $gd = '<span class="correct_span">&radic;</span> ' . $tmp['GD Version'];
  85. }
  86. // if (extension_loaded('redis')) {
  87. // $redis = '<span class="correct_span">&radic;</span> 已安装';
  88. // } else {
  89. // $redis = '<a href="http://help.crmeb.net/crmebpro/1707557" target="_blank"><span class="correct_span error_span">&radic;</span> 点击查看帮助</a>';
  90. // $err++;
  91. // }
  92. if (function_exists('mysqli_connect')) {
  93. $mysql = '<span class="correct_span">&radic;</span> 已安装';
  94. } else {
  95. $mysql = '<span class="correct_span error_span">&radic;</span> 请安装mysqli扩展';
  96. $err++;
  97. }
  98. if (ini_get('file_uploads')) {
  99. $uploadSize = '<span class="correct_span">&radic;</span> ' . ini_get('upload_max_filesize');
  100. } else {
  101. $uploadSize = '<span class="correct_span error_span">&radic;</span>禁止上传';
  102. }
  103. if (function_exists('session_start')) {
  104. $session = '<span class="correct_span">&radic;</span> 启用';
  105. } else {
  106. $session = '<span class="correct_span error_span">&radic;</span> 关闭';
  107. $err++;
  108. }
  109. if (function_exists('curl_init')) {
  110. $curl = '<span class="correct_span">&radic;</span> 启用';
  111. } else {
  112. $curl = '<span class="correct_span error_span">&radic;</span> 关闭';
  113. $err++;
  114. }
  115. if (function_exists('bcadd')) {
  116. $bcmath = '<span class="correct_span">&radic;</span> 启用';
  117. } else {
  118. $bcmath = '<span class="correct_span error_span">&radic;</span> 关闭';
  119. $err++;
  120. }
  121. if (function_exists('openssl_encrypt')) {
  122. $openssl = '<span class="correct_span">&radic;</span> 启用';
  123. } else {
  124. $openssl = '<span class="correct_span error_span">&radic;</span> 关闭';
  125. $err++;
  126. }
  127. if (function_exists('finfo_open')) {
  128. $finfo_open = '<span class="correct_span">&radic;</span> 启用';
  129. } else {
  130. // $finfo_open = '<a href="http://help.crmeb.net/crmebpro/1707557" target="_blank"><span class="correct_span error_span">&radic;</span>点击查看帮助</a>';
  131. $err++;
  132. }
  133. $folder = array(
  134. 'public/install',
  135. 'public/static/storage',
  136. 'runtime',
  137. );
  138. $file = array(
  139. '.env'
  140. );
  141. //必须开启函数
  142. $disabled = explode(',', ini_get('disable_functions'));
  143. if (function_exists('file_put_contents')) {
  144. $file_put_contents = '<span class="correct_span">&radic;</span> 启用';
  145. } else {
  146. $file_put_contents = '<span class="correct_span error_span">&radic;</span> 禁用';
  147. $err++;
  148. }
  149. if (function_exists('imagettftext')) {
  150. $imagettftext = '<span class="correct_span">&radic;</span> 启用';
  151. } else {
  152. $imagettftext = '<span class="correct_span error_span">&radic;</span> 禁用';
  153. $err++;
  154. }
  155. if (!in_array('pcntl_signal', $disabled)) {
  156. $pcntl_signal = '<span class="correct_span">&radic;</span> 启用';
  157. } else {
  158. $pcntl_signal = '<span class="correct_span error_span">&radic;</span> 禁用';
  159. $err++;
  160. }
  161. if (!in_array('pcntl_signal_dispatch', $disabled)) {
  162. $pcntl_signal_dispatch = '<span class="correct_span">&radic;</span> 启用';
  163. } else {
  164. $pcntl_signal_dispatch = '<span class="correct_span error_span">&radic;</span> 禁用';
  165. $err++;
  166. }
  167. if (!in_array('pcntl_fork', $disabled)) {
  168. $pcntl_fork = '<span class="correct_span">&radic;</span> 启用';
  169. } else {
  170. $pcntl_fork = '<span class="correct_span error_span">&radic;</span> 禁用';
  171. $err++;
  172. }
  173. if (!in_array('pcntl_wait', $disabled)) {
  174. $pcntl_wait = '<span class="correct_span">&radic;</span> 启用';
  175. } else {
  176. $pcntl_wait = '<span class="correct_span error_span">&radic;</span> 禁用';
  177. $err++;
  178. }
  179. if (!in_array('pcntl_alarm', $disabled)) {
  180. $pcntl_alarm = '<span class="correct_span">&radic;</span> 启用';
  181. } else {
  182. $pcntl_alarm = '<span class="correct_span error_span">&radic;</span> 禁用';
  183. $err++;
  184. }
  185. include_once("./templates/step2.php");
  186. exit();
  187. case '3':
  188. $dbName = strtolower(trim($_POST['dbName']));
  189. $_POST['dbport'] = $_POST['dbport'] ?: '3306';
  190. if ($_GET['testdbpwd']) {
  191. $dbHost = $_POST['dbHost'];
  192. $conn = @mysqli_connect($dbHost, $_POST['dbUser'], $_POST['dbPwd'], NULL, $_POST['dbport']);
  193. if (mysqli_connect_errno($conn)) {
  194. die(json_encode(0));
  195. } else {
  196. $result = mysqli_query($conn, "SELECT @@global.sql_mode");
  197. $result = $result->fetch_array();
  198. $version = mysqli_get_server_info($conn);
  199. if ($version >= 5.7) {
  200. if (strstr($result[0], 'STRICT_TRANS_TABLES') || strstr($result[0], 'STRICT_ALL_TABLES') || strstr($result[0], 'TRADITIONAL') || strstr($result[0], 'ANSI'))
  201. exit(json_encode(-4));
  202. }
  203. $result = mysqli_query($conn, "select count(table_name) as c from information_schema.`TABLES` where table_schema='$dbName'");
  204. $result = $result->fetch_array();
  205. if ($result['c'] > 0)
  206. exit(json_encode(-2));
  207. }
  208. //redis数据库信息
  209. $rbhost = $_POST['rbhost'] ?? '127.0.0.1';
  210. $rbport = $_POST['rbport'] ?? 6379;
  211. $rbpw = $_POST['rbpw'] ?? '';
  212. $rbselect = $_POST['rbselect'] ?? 0;
  213. try {
  214. $redis = new Redis();
  215. if (!$redis) {
  216. exit(json_encode(-1));
  217. }
  218. $redis->connect($rbhost, $rbport);
  219. if ($rbpw) {
  220. $redis->auth($rbpw);
  221. }
  222. if ($rbselect) {
  223. $redis->select($rbselect);
  224. }
  225. $res = $redis->set('install', 1, 10);
  226. if ($res) {
  227. exit(json_encode(1));
  228. } else {
  229. exit(json_encode(-3));
  230. }
  231. } catch (Throwable $e) {
  232. exit(json_encode(-3));
  233. }
  234. }
  235. include_once("./templates/step3.php");
  236. exit();
  237. case '4':
  238. if (intval($_GET['install'])) {
  239. $n = intval($_GET['n']);
  240. if ($n == 999999)
  241. exit;
  242. $arr = array();
  243. $dbHost = trim($_POST['dbhost']);
  244. $_POST['dbport'] = $_POST['dbport'] ?: '3306';
  245. $dbName = strtolower(trim($_POST['dbname']));
  246. $dbUser = trim($_POST['dbuser']);
  247. $dbPwd = trim($_POST['dbpw']);
  248. $dbPrefix = empty($_POST['dbprefix']) ? 'ims_' : trim($_POST['dbprefix']);
  249. $username = trim($_POST['manager']);
  250. $password = trim($_POST['manager_pwd']);
  251. $email = trim($_POST['manager_email']);
  252. if (!function_exists('mysqli_connect')) {
  253. $arr['msg'] = "请安装 mysqli 扩展!";
  254. echo json_encode($arr);
  255. exit;
  256. }
  257. $conn = @mysqli_connect($dbHost, $dbUser, $dbPwd, NULL, $_POST['dbport']);
  258. if (mysqli_connect_errno($conn)) {
  259. $arr['msg'] = "连接数据库失败!" . mysqli_connect_error($conn);
  260. echo json_encode($arr);
  261. exit;
  262. }
  263. mysqli_set_charset($conn, "utf8"); //,character_set_client=binary,sql_mode='';
  264. $version = mysqli_get_server_info($conn);
  265. if ($version < 5.1) {
  266. $arr['msg'] = '数据库版本太低! 必须5.1以上';
  267. echo json_encode($arr);
  268. exit;
  269. }
  270. if (!mysqli_select_db($conn, $dbName)) {
  271. //创建数据时同时设置编码
  272. if (!mysqli_query($conn, "CREATE DATABASE IF NOT EXISTS `" . $dbName . "` DEFAULT CHARACTER SET utf8;")) {
  273. $arr['msg'] = '数据库 ' . $dbName . ' 不存在,也没权限创建新的数据库!';
  274. echo json_encode($arr);
  275. exit;
  276. }
  277. if ($n == -1) {
  278. $arr['n'] = 0;
  279. $arr['msg'] = "成功创建数据库:{$dbName}<br>";
  280. echo json_encode($arr);
  281. exit;
  282. }
  283. mysqli_select_db($conn, $dbName);
  284. }
  285. //读取数据文件
  286. $sqldata = file_get_contents(SITE_DIR . 'install/' . $sqlFile);
  287. $sqlFormat = sql_split($sqldata, $dbPrefix);
  288. //创建写入sql数据库文件到库中 结束
  289. /**
  290. * 执行SQL语句
  291. */
  292. $counts = count($sqlFormat);
  293. for ($i = $n; $i < $counts; $i++) {
  294. $sql = trim($sqlFormat[$i]);
  295. if (strstr($sql, 'CREATE TABLE')) {
  296. // preg_match('/CREATE TABLE (IF NOT EXISTS)? `ims_([^ ]*)`/is', $sql, $matches);
  297. preg_match('`ims_([^ ]*)`', $sql, $matches);
  298. mysqli_query($conn, "DROP TABLE IF EXISTS `$matches[1]");
  299. $sql = str_replace('`ims_', '`' . $dbPrefix, $sql);//替换表前缀
  300. $ret = mysqli_query($conn, $sql);
  301. if ($ret) {
  302. $message = '<li><span class="correct_span">&radic;</span>创建数据表[' . $dbPrefix . $matches[1] . ']完成!<span style="float: right;">' . date('Y-m-d H:i:s') . '</span></li> ';
  303. } else {
  304. $err = mysqli_error($conn);
  305. $message = '<li><span class="correct_span error_span">&radic;</span>创建数据表[' . $dbPrefix . $matches[1] . ']失败!失败原因:' . $err . '<span style="float: right;">' . date('Y-m-d H:i:s') . '</span></li>';
  306. }
  307. $i++;
  308. $arr = array('n' => $i, 'msg' => $message);
  309. echo json_encode($arr);
  310. exit;
  311. } else {
  312. if (trim($sql) == '')
  313. continue;
  314. $sql = str_replace('`ims_', '`' . $dbPrefix, $sql);//替换表前缀
  315. $ret = mysqli_query($conn, $sql);
  316. $message = '';
  317. $arr = array('n' => $i, 'msg' => $message);
  318. // echo json_encode($arr); exit;
  319. }
  320. }
  321. // 清空测试数据
  322. // if (!$_POST['demo']) {
  323. // $result = mysqli_query($conn, "show tables");
  324. // $tables = mysqli_fetch_all($result);//参数MYSQL_ASSOC、MYSQLI_NUM、MYSQLI_BOTH规定产生数组类型
  325. // $bl_table = array('eb_system_admin'
  326. // , 'eb_system_role'
  327. // , 'eb_agent_level'
  328. // , 'eb_page_link'
  329. // , 'eb_page_categroy'
  330. // , 'eb_system_config'
  331. // , 'eb_system_config_tab'
  332. // , 'eb_system_menus'
  333. // , 'eb_system_notification'
  334. // , 'eb_express'
  335. // , 'eb_system_group'
  336. // , 'eb_system_group_data'
  337. // , 'eb_template_message'
  338. // , 'eb_shipping_templates'
  339. // , "eb_shipping_templates_region"
  340. // , 'eb_system_city'
  341. // , 'eb_diy'
  342. // , 'eb_member_ship'
  343. // , 'eb_member_right'
  344. // , 'eb_agreement'
  345. // , 'eb_store_service_speechcraft'
  346. // , 'eb_system_user_level'
  347. // , 'eb_cache');
  348. // foreach ($bl_table as $k => $v) {
  349. // $bl_table[$k] = str_replace('eb_', $dbPrefix, $v);
  350. // }
  351. // foreach ($tables as $key => $val) {
  352. // if (!in_array($val[0], $bl_table)) {
  353. // mysqli_query($conn, "truncate table " . $val[0]);
  354. // }
  355. // }
  356. // delFile(APP_DIR . '/uploads'); // 清空测试图片
  357. // }
  358. //读取配置文件,并替换真实配置数据1
  359. $strConfig = file_get_contents(SITE_DIR . 'install/' . $configFile);
  360. $strConfig = str_replace('#DB_HOST#', $dbHost, $strConfig);
  361. $strConfig = str_replace('#DB_NAME#', $dbName, $strConfig);
  362. $strConfig = str_replace('#DB_USER#', $dbUser, $strConfig);
  363. $strConfig = str_replace('#DB_PWD#', $dbPwd, $strConfig);
  364. $strConfig = str_replace('#DB_PORT#', $_POST['dbport'], $strConfig);
  365. $strConfig = str_replace('#DB_PREFIX#', $dbPrefix, $strConfig);
  366. $strConfig = str_replace('#DB_CHARSET#', 'utf8', $strConfig);
  367. // $strConfig = str_replace('#DB_DEBUG#', false, $strConfig);
  368. //redis数据库信息
  369. $rbhost = $_POST['rbhost'] ?? '127.0.0.1';
  370. $rbport = $_POST['rbport'] ?? '6379';
  371. $rbpw = $_POST['rbpw'] ?? '';
  372. $rbselect = $_POST['rbselect'] ?? 0;
  373. $strConfig = str_replace('#RB_HOST#', $rbhost, $strConfig);
  374. $strConfig = str_replace('#RB_PORT#', $rbport, $strConfig);
  375. $strConfig = str_replace('#RB_PWD#', $rbpw, $strConfig);
  376. $strConfig = str_replace('#RB_SELECT#', $rbselect, $strConfig);
  377. //需改队列名称
  378. $strConfig = str_replace('#QUEUE_NAME#', uniqid(), $strConfig);
  379. @chmod(APP_DIR . '/.env', 0777); //数据库配置文件的地址
  380. @file_put_contents(APP_DIR . '/.env', $strConfig); //数据库配置文件的地址
  381. //读取配置文件,并替换换配置
  382. // $strConfig = file_get_contents(SITE_DIR . '/application/config.php');
  383. // $strConfig = str_replace('CRMEB_cache_prefix', $uniqid_str, $strConfig);
  384. // @chmod(SITE_DIR . '/application/config.php',0777); //配置文件的地址
  385. // @file_put_contents(SITE_DIR . '/application/config.php', $strConfig); //配置文件的地址
  386. //更新网站配置信息2
  387. //插入管理员表字段tp_admin表
  388. $time = time();
  389. $ip = get_client_ip();
  390. $ip = empty($ip) ? "0.0.0.0" : $ip;
  391. $password = password_hash($_POST['manager_pwd'], PASSWORD_BCRYPT);
  392. mysqli_query($conn, "truncate table {$dbPrefix}wike_oddjob_admin_user");
  393. $addadminsql = "INSERT INTO `{$dbPrefix}wike_oddjob_admin_user` (`id`, `username`, `nickname`, `password`, `avatar`, `is_super_manager`, `status`, `login_time`, `login_ip`, `create_time`, `update_time`, `delete_time`) VALUES
  394. (1, '" . $username . "', '超级管理员', '" . $password . "', '', 1, 1, '2023-02-13 18:58:26', '182.146.255.250', '2022-11-01 16:54:17', '2023-02-13 18:58:26', NULL)";
  395. $res = mysqli_query($conn, $addadminsql);
  396. $res2 = true;
  397. if (isset($_SERVER['SERVER_NAME'])) {
  398. $site_url = '\'"http://' . $_SERVER['SERVER_NAME'] . '"\'';
  399. $res2 = mysqli_query($conn, 'UPDATE `' . $dbPrefix . 'system_config` SET `value`=' . $site_url . ' WHERE `menu_name`="site_url"');
  400. }
  401. if ($res) {
  402. $message = '成功添加管理员<br />成功写入配置文件<br>安装完成.';
  403. $arr = array('n' => 999999, 'msg' => $message);
  404. echo json_encode($arr);
  405. exit;
  406. } else {
  407. $message = '添加管理员失败<br />成功写入配置文件<br>安装完成.';
  408. $arr = array('n' => 999999, 'msg' => $message);
  409. echo json_encode($arr);
  410. exit;
  411. }
  412. }
  413. include_once("./templates/step4.php");
  414. exit();
  415. case '5':
  416. $ip = get_client_ip();
  417. $host = $_SERVER['HTTP_HOST'];
  418. $curent_version = getversion();
  419. $version = trim($curent_version['version']);
  420. installlog();
  421. include_once("./templates/step5.php");
  422. @touch('./install.lock');
  423. exit();
  424. }
  425. //读取版本号
  426. function getversion()
  427. {
  428. $version_arr = [];
  429. $curent_version = @file(APP_DIR . '.version');
  430. if (!is_array($curent_version)) {
  431. $curent_version = [];
  432. }
  433. foreach ($curent_version as $val) {
  434. list($k, $v) = explode('=', $val);
  435. $version_arr[$k] = $v;
  436. }
  437. return $version_arr;
  438. }
  439. //写入安装信息
  440. function installlog()
  441. {
  442. $mt_rand_str = sp_random_string(6);
  443. $str_constant = "<?php" . PHP_EOL . "define('INSTALL_DATE'," . time() . ");" . PHP_EOL . "define('SERIALNUMBER','" . $mt_rand_str . "');";
  444. @file_put_contents(APP_DIR . '.constant', $str_constant);
  445. }
  446. //判断权限
  447. function testwrite($d)
  448. {
  449. if (is_file($d)) {
  450. if (is_writeable($d)) {
  451. return true;
  452. }
  453. return false;
  454. } else {
  455. $tfile = "_test.txt";
  456. $fp = @fopen($d . "/" . $tfile, "w");
  457. if (!$fp) {
  458. return false;
  459. }
  460. fclose($fp);
  461. $rs = @unlink($d . "/" . $tfile);
  462. if ($rs) {
  463. return true;
  464. }
  465. return false;
  466. }
  467. }
  468. function sql_split($sql, $tablepre)
  469. {
  470. if ($tablepre != "tp_")
  471. $sql = str_replace("tp_", $tablepre, $sql);
  472. $sql = preg_replace("/TYPE=(InnoDB|MyISAM|MEMORY)( DEFAULT CHARSET=[^; ]+)?/", "ENGINE=\\1 DEFAULT CHARSET=utf8", $sql);
  473. $sql = str_replace("\r", "\n", $sql);
  474. $ret = array();
  475. $num = 0;
  476. $queriesarray = explode(";\n", trim($sql));
  477. unset($sql);
  478. foreach ($queriesarray as $query) {
  479. $ret[$num] = '';
  480. $queries = explode("\n", trim($query));
  481. $queries = array_filter($queries);
  482. foreach ($queries as $query) {
  483. $str1 = substr($query, 0, 1);
  484. if ($str1 != '#' && $str1 != '-')
  485. $ret[$num] .= $query;
  486. }
  487. $num++;
  488. }
  489. return $ret;
  490. }
  491. function _dir_path($path)
  492. {
  493. $path = str_replace('\\', '/', $path);
  494. if (substr($path, -1) != '/')
  495. $path = $path . '/';
  496. return $path;
  497. }
  498. // 获取客户端IP地址
  499. function get_client_ip()
  500. {
  501. static $ip = NULL;
  502. if ($ip !== NULL)
  503. return $ip;
  504. if (isset($_SERVER['HTTP_X_FORWARDED_FOR'])) {
  505. $arr = explode(',', $_SERVER['HTTP_X_FORWARDED_FOR']);
  506. $pos = array_search('unknown', $arr);
  507. if (false !== $pos)
  508. unset($arr[$pos]);
  509. $ip = trim($arr[0]);
  510. } elseif (isset($_SERVER['HTTP_CLIENT_IP'])) {
  511. $ip = $_SERVER['HTTP_CLIENT_IP'];
  512. } elseif (isset($_SERVER['REMOTE_ADDR'])) {
  513. $ip = $_SERVER['REMOTE_ADDR'];
  514. }
  515. // IP地址合法验证
  516. $ip = (false !== ip2long($ip)) ? $ip : '0.0.0.0';
  517. return $ip;
  518. }
  519. function dir_create($path, $mode = 0777)
  520. {
  521. if (is_dir($path))
  522. return TRUE;
  523. $ftp_enable = 0;
  524. $path = dir_path($path);
  525. $temp = explode('/', $path);
  526. $cur_dir = '';
  527. $max = count($temp) - 1;
  528. for ($i = 0; $i < $max; $i++) {
  529. $cur_dir .= $temp[$i] . '/';
  530. if (@is_dir($cur_dir))
  531. continue;
  532. @mkdir($cur_dir, 0777, true);
  533. @chmod($cur_dir, 0777);
  534. }
  535. return is_dir($path);
  536. }
  537. function dir_path($path)
  538. {
  539. $path = str_replace('\\', '/', $path);
  540. if (substr($path, -1) != '/')
  541. $path = $path . '/';
  542. return $path;
  543. }
  544. function sp_password($pw, $pre)
  545. {
  546. $decor = md5($pre);
  547. $mi = md5($pw);
  548. return substr($decor, 0, 12) . $mi . substr($decor, -4, 4);
  549. }
  550. function sp_random_string($len = 8)
  551. {
  552. $chars = array(
  553. "a", "b", "c", "d", "e", "f", "g", "h", "i", "j", "k",
  554. "l", "m", "n", "o", "p", "q", "r", "s", "t", "u", "v",
  555. "w", "x", "y", "z", "A", "B", "C", "D", "E", "F", "G",
  556. "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R",
  557. "S", "T", "U", "V", "W", "X", "Y", "Z", "0", "1", "2",
  558. "3", "4", "5", "6", "7", "8", "9"
  559. );
  560. $charsLen = count($chars) - 1;
  561. shuffle($chars); // 将数组打乱
  562. $output = "";
  563. for ($i = 0; $i < $len; $i++) {
  564. $output .= $chars[mt_rand(0, $charsLen)];
  565. }
  566. return $output;
  567. }
  568. // 递归删除文件夹
  569. function delFile($dir, $file_type = '')
  570. {
  571. if (is_dir($dir)) {
  572. $files = scandir($dir);
  573. //打开目录 //列出目录中的所有文件并去掉 . 和 ..
  574. foreach ($files as $filename) {
  575. if ($filename != '.' && $filename != '..') {
  576. if (!is_dir($dir . '/' . $filename)) {
  577. if (empty($file_type)) {
  578. unlink($dir . '/' . $filename);
  579. } else {
  580. if (is_array($file_type)) {
  581. //正则匹配指定文件
  582. if (preg_match($file_type[0], $filename)) {
  583. unlink($dir . '/' . $filename);
  584. }
  585. } else {
  586. //指定包含某些字符串的文件
  587. if (false != stristr($filename, $file_type)) {
  588. unlink($dir . '/' . $filename);
  589. }
  590. }
  591. }
  592. } else {
  593. delFile($dir . '/' . $filename);
  594. rmdir($dir . '/' . $filename);
  595. }
  596. }
  597. }
  598. } else {
  599. if (file_exists($dir)) unlink($dir);
  600. }
  601. }
  602. ?>