You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
310 lines
12 KiB
310 lines
12 KiB
<?php
|
|
|
|
/* 鍒濆?鍖栧彉閲忓畾涔 */
|
|
$charset = 'utf-8';
|
|
$tools_version = "v1.0";
|
|
$mysql_version = '';
|
|
$ecshop_version = '';
|
|
$mysql_charset = '';
|
|
$ecshop_charset = '';
|
|
$convert_charset = array('utf-8' => 'gbk', 'gbk' => 'utf-8');
|
|
$convert_tables_file = 'data/convert_tables.php';
|
|
$rpp = 500; // 姣忔?澶勭悊鐨勮?褰曟暟
|
|
|
|
/* ECShop鐨勭珯鐐圭洰褰 */
|
|
define('ROOT_PATH', str_replace('\\', '/', substr(__FILE__, 0, -20)));
|
|
define('IN_ECS', true);
|
|
|
|
require(ROOT_PATH . 'data/config.php');
|
|
require(ROOT_PATH . 'includes/cls_ecshop.php');
|
|
require(ROOT_PATH . 'includes/cls_mysql.php');
|
|
require(ROOT_PATH . 'includes/lib_common.php');
|
|
|
|
/* 鏈?崌绾у墠锛岃?甯搁噺涓嶅瓨鍦 */
|
|
if (defined('EC_CHARSET')) {
|
|
$ec_charset = EC_CHARSET;
|
|
} else {
|
|
$ec_charset = '';
|
|
}
|
|
$ecshop_version = str_replace('v', '', VERSION);
|
|
$ecshop_charset = $ec_charset;
|
|
$db = new cls_mysql($db_host, $db_user, $db_pass, $db_name, '', 0, 1);
|
|
$mysql_version = $db->version;
|
|
$mysql_charset = get_mysql_charset();
|
|
|
|
$step = getgpc('step');
|
|
$step = empty($step) ? 1 : $step;
|
|
|
|
if ($ecshop_version < '2.6.0') {
|
|
$step = 'halt';
|
|
}
|
|
if (!defined('UC_DBUSER') && !defined('UC_DBPW') && !defined('UC_DBNAME'))
|
|
{
|
|
$uc_config = $db->getOne("SELECT value FROM {$prefix}shop_config WHERE code='integrate_config'");
|
|
$uc_config = unserialize($uc_config);
|
|
if (!empty($uc_config['db_user']) && !empty($uc_config['db_pass']) && !empty($uc_config['db_name']))
|
|
{
|
|
define('UC_CONNECT', $uc_config['uc_connect']);
|
|
define('UC_DBHOST', $uc_config['db_host']);
|
|
define('UC_DBUSER', $uc_config['db_user']);
|
|
define('UC_DBPW', $uc_config['db_pass']);
|
|
define('UC_DBNAME', $uc_config['db_name']);
|
|
define('UC_DBCHARSET', $uc_config['db_charset']);
|
|
define('UC_DBTABLEPRE', '`' . $uc_config['db_name'] . '`.' . $uc_config['db_pre']);
|
|
define('UC_DBCONNECT', '0');
|
|
define('UC_KEY', $uc_config['uc_key']);
|
|
define('UC_API', $uc_config['uc_url']);
|
|
define('UC_CHARSET', $uc_config['uc_charset']);
|
|
define('UC_IP', $uc_config['uc_ip']);
|
|
define('UC_APPID', $uc_config['uc_id']);
|
|
define('UC_PPP', '20');
|
|
}
|
|
else
|
|
{
|
|
$step = 'halt';
|
|
}
|
|
}
|
|
|
|
ob_start();
|
|
instheader();
|
|
if ($step == 1) {
|
|
$ext_msg = '<a href="?step=start"><font size="3" color="red"><b>>> 濡傛灉鎮ㄥ凡纭??涓婇潰鐨勪娇鐢ㄨ?鏄?璇风偣杩欓噷杩涜?瀵煎叆</b></font></a><br /><br /><a href="index.php"><font size="2"><b>>> 濡傛灉鎮ㄩ渶瑕佹墽琛屽崌绾х▼搴忥紝璇风偣杩欓噷杩涜?鍗囩骇</b></font></a>';
|
|
echo <<<EOT
|
|
<h4>鏈?浆鎹㈢▼搴忓彧鑳介拡ECShop2.6.0鎴栬€呬互涓婄増鏈?▼搴忕殑鏁版嵁瀵煎叆<br /></h4>
|
|
瀵煎叆涔嬪墠<b>鍔″繀澶囦唤鏁版嵁搴撹祫鏂橖/b>锛岄伩鍏嶅?鍏ュけ璐ョ粰鎮ㄥ甫鏉ユ崯澶变笌涓嶄究<br /><br />
|
|
|
|
<p>瀵煎叆绋嬪簭浣跨敤璇存槑锛欬/p>
|
|
<ol>
|
|
<li>鍙?敮鎸佷粠UCenter鏁版嵁搴撳埌ECShop鏁版嵁搴撶殑瀵煎叆</li>
|
|
<li>鍙??鍏ヤ細鍛樼殑鐢ㄦ埛鍚嶃€侀偖绠便€佸瘑鐮侊紝杩欎簺鍩烘湰淇℃伅銆備笉浼氱牬鍧忓師鏈変細鍛樻暟鎹?/li>
|
|
</ol>
|
|
|
|
<p>鎮ㄥ綋鍓嶇▼搴忎笌鏁版嵁搴撶殑淇℃伅锛欬/p>
|
|
<ul>
|
|
<li>绋嬪簭鐗堟湰锛?ecshop_version</li>
|
|
<li>绋嬪簭缂栫爜锛?ecshop_charset</li>
|
|
<li>MySQL鐗堟湰锛?mysql_version</li>
|
|
<li>MySQL缂栫爜锛?mysql_charset</li>
|
|
</ul>
|
|
$ext_msg
|
|
EOT;
|
|
instfooter();
|
|
} elseif ($step == 'halt') {
|
|
echo <<<EOT
|
|
<p><h4>鍑洪敊浜嗭紒</h4></p>
|
|
<p>
|
|
<ol>
|
|
<li>鎮ㄥ綋鍓嶇殑绋嬪簭鐗堟湰灏忎簬2.6.0锛汓/li>
|
|
<li>鎮ㄧ殑閰嶇疆鏂囦欢涓庢暟鎹?〃涓?己灏慤Center鐨勯厤缃?俊鎭?€侟/li>
|
|
</ol>
|
|
</p>
|
|
<p><h4>璇峰厛鍗囩骇鎮ㄧ殑绋嬪簭鍐嶈繘琛屽?鍏ャ€侟/h4></p>
|
|
EOT;
|
|
instfooter();
|
|
} elseif ($step == 'start') {
|
|
$limit = getgpc('limit', 'P');
|
|
$update = getgpc('update', 'P');
|
|
$insert = getgpc('insert', 'P');
|
|
$success = getgpc('success', 'P');
|
|
$error = getgpc('error', 'P');
|
|
$item_num = 500; // 姣忔?澶勭悊1000涓?細鍛樻暟鎹
|
|
$statistics = array('update' => 0, 'insert' => 0, 'success' => 0, 'error' => 0);
|
|
if (empty($limit)) {
|
|
$limit = 0;
|
|
}
|
|
$uc_db = new cls_mysql(UC_DBHOST, UC_DBUSER, UC_DBPW, UC_DBNAME, UC_DBCHARSET, 0, 1);
|
|
$total_members = $uc_db->getOne("SELECT COUNT(*) FROM ". UC_DBTABLEPRE ."members");
|
|
$sql = "SELECT uid, username, password, email, salt FROM ". UC_DBTABLEPRE ."members ORDER BY uid ASC LIMIT $limit, $item_num";
|
|
$uc_query = $uc_db->query($sql);
|
|
while($member = $uc_db->fetch_array($uc_query)){
|
|
$user_exists = $db->getOne("SELECT COUNT(*) FROM {$prefix}users WHERE `user_name`='{$member['username']}'");
|
|
if (!$user_exists) {
|
|
$sql = "INSERT INTO {$prefix}users (`email`, `user_name`, `password`, `salt`) VALUES('{$member['email']}', '{$member['username']}', '{$member['password']}', '2{$member['salt']}')";
|
|
++$statistics['insert'];
|
|
} else {
|
|
$sql = "UPDATE {$prefix}users SET `password`='{$member['password']}', `salt`='2{$member['salt']}' WHERE `user_name`='{$member['username']}'";
|
|
++$statistics['update'];
|
|
}
|
|
$db->query($sql);
|
|
if ($db->affected_rows() > 0) {
|
|
++$statistics['success'];
|
|
} else {
|
|
++$statistics['error'];
|
|
}
|
|
}
|
|
if (($limit+$item_num) > $total_members) {
|
|
$update += $statistics['update'];
|
|
$insert += $statistics['insert'];
|
|
$success += $statistics['success'];
|
|
$error += $statistics['error'];
|
|
$message = "<p>鍏辨湁 <strong>$total_members</strong> 涓?細鍛樻暟鎹?/p><p>瀵煎叆瀹屾垚锛?/p><p><ul><li>鏇存柊鐨勭敤鎴锋暟鎹?細$update 鏉狘/li><li>鏂板?鐨勭敤鎴锋暟鎹?細$insert 鏉狘/li><li>鎴愬姛鐨勭敤鎴锋暟鎹?細$success 鏉狘/li><li>鍑洪敊鐨勭敤鎴锋暟鎹?細$error 鏉狘/li></ul></p><p><a href=\"index.php\"><b>>> 濡傛灉鎮ㄩ渶瑕佹墽琛屽崌绾х▼搴忥紝璇风偣杩欓噷杩涜?鍗囩骇</b></a></p>";
|
|
showmessage($message);
|
|
} else {
|
|
$update += $statistics['update'];
|
|
$insert += $statistics['insert'];
|
|
$success += $statistics['success'];
|
|
$error += $statistics['error'];
|
|
$total_item = $limit+$item_num;
|
|
$extra = '<input type="hidden" name="update" value="'.$update.'" /><input type="hidden" name="insert" value="'.$insert.'" /><input type="hidden" name="success" value="'.$success.'" /><input type="hidden" name="error" value="'.$error.'" /><input type="hidden" name="limit" value="'.$total_item.'" />';
|
|
$message = "<p>鍏辨湁 <strong>$total_members</strong> 涓?細鍛樻暟鎹?/p><p>褰撳墠鍦ㄥ?鍏 $limit - $total_item 鐨勪細鍛樻暟鎹?/p><p><ul><li>鏇存柊鐨勭敤鎴锋暟鎹?細$update 鏉狘/li><li>鏂板?鐨勭敤鎴锋暟鎹?細$insert 鏉狘/li><li>鎴愬姛鐨勭敤鎴锋暟鎹?細$success 鏉狘/li><li>鍑洪敊鐨勭敤鎴锋暟鎹?細$error 鏉狘/li></ul></p>";
|
|
showmessage($message, '?step=start', 'form', $extra);
|
|
}
|
|
}
|
|
ob_end_flush();
|
|
|
|
function instheader() {
|
|
global $charset, $tools_version;
|
|
|
|
echo "<html><head>".
|
|
"<meta http-equiv=\"Content-Type\" content=\"text/html; charset=$charset\">".
|
|
"<title>UCenter 浼氬憳鏁版嵁瀵煎叆宸ュ叿$tools_version</title>".
|
|
"<style type=\"text/css\">
|
|
a {
|
|
color: #3A4273;
|
|
text-decoration: none
|
|
}
|
|
|
|
a:hover {
|
|
color: #3A4273;
|
|
text-decoration: underline
|
|
}
|
|
|
|
body, table, td {
|
|
color: #3A4273;
|
|
font-family: Tahoma, Verdana, Arial;
|
|
font-size: 12px;
|
|
line-height: 20px;
|
|
scrollbar-base-color: #E3E3EA;
|
|
scrollbar-arrow-color: #5C5C8D
|
|
}
|
|
form {
|
|
margin:0;
|
|
padding:0
|
|
}
|
|
input {
|
|
color: #085878;
|
|
font-family: Tahoma, Verdana, Arial;
|
|
font-size: 12px;
|
|
background-color: #3A4273;
|
|
color: #FFFFFF;
|
|
scrollbar-base-color: #E3E3EA;
|
|
scrollbar-arrow-color: #5C5C8D
|
|
}
|
|
|
|
.install {
|
|
font-family: Arial, Verdana;
|
|
font-size: 20px;
|
|
font-weight: bold;
|
|
color: #000000
|
|
}
|
|
|
|
.message {
|
|
background: #E3E3EA;
|
|
padding: 20px;
|
|
}
|
|
|
|
.altbg1 {
|
|
background: #E3E3EA;
|
|
}
|
|
|
|
.altbg2 {
|
|
background: #EEEEF6;
|
|
}
|
|
|
|
.header td {
|
|
color: #FFFFFF;
|
|
background-color: #3A4273;
|
|
text-align: center;
|
|
}
|
|
|
|
.option td {
|
|
text-align: center;
|
|
}
|
|
|
|
.redfont {
|
|
color: #FF0000;
|
|
}
|
|
.p_indent{
|
|
text-indent:2em;
|
|
}
|
|
div.msg{
|
|
text-indent:2em;
|
|
line-height:30px;
|
|
height:30px;
|
|
}
|
|
</style>
|
|
<script type=\"text/javascript\">
|
|
function redirect(url) {
|
|
window.location=url;
|
|
}
|
|
function $(id) {
|
|
return document.getElementById(id);
|
|
}
|
|
</script>
|
|
</head>".
|
|
"<body bgcolor=\"#298296\" text=\"#000000\"><div id=\"append_parent\"></div>".
|
|
"<table width=\"95%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" bgcolor=\"#FFFFFF\" align=\"center\"><tr><td>".
|
|
"<table width=\"98%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\"><tr>".
|
|
"<td class=\"install\" height=\"30\" valign=\"bottom\"><font color=\"#FF0000\">>></font> UCenter 浼氬憳鏁版嵁瀵煎叆宸ュ叿$tools_version".
|
|
"</td></tr><tr><td><hr noshade align=\"center\" width=\"100%\" size=\"1\"></td></tr><tr><td colspan=\"2\">";
|
|
}
|
|
|
|
function instfooter() {
|
|
echo "</td></tr><tr><td><hr noshade align=\"center\" width=\"100%\" size=\"1\"></td></tr>".
|
|
"<tr><td align=\"center\">".
|
|
"<b style=\"font-size: 11px\">Powered by <a href=\"http://www.ecmoban.com\" target=\"_blank\"><span style=\"color:#FF6100\">ECShop</span>".
|
|
"</a></b> © 2005-2011 涓婃捣鍟嗘淳缃戠粶绉戞妧鏈夐檺鍏?徃銆侟br /><br />".
|
|
"</td></tr></table></td></tr></table>".
|
|
"</body></html>";
|
|
}
|
|
|
|
function showmessage($message, $url_forward = '', $msgtype = 'message', $extra = '', $delaymsec = 1000) {
|
|
//浠ヨ〃鍗曠殑褰㈠紡鏄剧ず淇℃伅
|
|
if($msgtype == 'form') {
|
|
$message = "<form method=\"post\" action=\"$url_forward\" name=\"hidden_form\">".
|
|
"<br><p class=\"p_indent\">$message</p>\n $extra</form><br>".
|
|
'<script type="text/javascript">
|
|
setTimeout("document.forms[\'hidden_form\'].submit()", '. $delaymsec .');
|
|
</script>';
|
|
} else {
|
|
if($url_forward) {
|
|
$message .= "<script>setTimeout(\"redirect('$url_forward');\", $delaymsec);</script>";
|
|
$message .= "<br><div align=\"right\">[<a href=\"$script_name\" style=\"color:red\">鍋滄?杩愯?</a>]<br><br><a href=\"$url_forward\">濡傛灉鎮ㄧ殑娴忚?鍣ㄩ暱鏃堕棿娌℃湁鑷?姩璺宠浆锛岃?鐐瑰嚮杩欓噷锛?/a></div>";
|
|
} else {
|
|
$message .= "<br /><br /><br />";
|
|
}
|
|
$message = "<br>$message$extra<br><br>";
|
|
}
|
|
|
|
echo $message;
|
|
instfooter();
|
|
exit;
|
|
}
|
|
|
|
function get_mysql_charset() {
|
|
global $db, $prefix;
|
|
$tmp_charset = '';
|
|
$query = $db->query("SHOW CREATE TABLE `{$prefix}users`", 'SILENT');
|
|
if ($query) {
|
|
$tablestruct = $db->fetch_array($query, MYSQL_NUM);
|
|
preg_match("/CHARSET=(\w+)/", $tablestruct[1], $m);
|
|
if (!empty($m)){
|
|
if (strpos($m[1], 'utf') === 0) {
|
|
$tmp_charset = str_replace('utf', 'utf-', $m[1]);
|
|
} else {
|
|
$tmp_charset = $m[1];
|
|
}
|
|
}
|
|
}
|
|
return $tmp_charset;
|
|
}
|
|
|
|
function getgpc($k, $var='G') {
|
|
switch($var) {
|
|
case 'G': $var = &$_GET; break;
|
|
case 'P': $var = &$_POST; break;
|
|
case 'C': $var = &$_COOKIE; break;
|
|
case 'R': $var = &$_REQUEST; break;
|
|
}
|
|
return isset($var[$k]) ? $var[$k] : NULL;
|
|
}
|