<?php
/**
* DiscuzX Convert
*
* $Id: access.php 10469 2010-05-11 09:12:14Z monkey $
* English by Valery Votintsev at sources.ru
*/
$curprg = basename(__FILE__);
$table_source = $db_source->tablepre . 'access';
$table_target = $db_target->tablepre . 'forum_access';
$limit = 2000;
$nextid = 0;
$start = getgpc('start');
if (empty($start)) {
$start = 0;
$db_target->query("TRUNCATE {$table_target}");
}
$query = $db_source->query("SELECT * FROM {$table_source} LIMIT {$start}, {$limit}");
while ($row = $db_source->fetch_array($query)) {
$nextid = 1;
$row = daddslashes($row, 1);
$data = implode_field_value($row, ',', db_table_fields($db_target, $table_target));
$db_target->query("INSERT INTO {$table_target} SET {$data}");
}
if ($nextid) {
showmessage(lang('continue_convert_table') . $table_source . lang('from') . $start . lang('to') . ($start + $limit) . lang('lines'), "index.php?a={$action}&source={$source}&prg={$curprg}&start=" . ($start + $limit));
//vot
}
<?php
/**
* DiscuzX Convert
*
* $Id: trades.php 10469 2010-05-11 09:12:14Z monkey $
*/
$curprg = basename(__FILE__);
$table_source = $db_source->tablepre . 'trades';
$table_target = $db_target->tablepre . 'forum_trade';
$limit = 2000;
$nextid = 0;
$start = getgpc('start');
if ($start == 0) {
$start = 0;
$db_target->query("TRUNCATE {$table_target}");
}
$query = $db_source->query("SELECT * FROM {$table_source} LIMIT {$start}, {$limit}");
while ($data = $db_source->fetch_array($query)) {
$nextid = 1;
$data = daddslashes($data, 1);
$datalist = implode_field_value($data, ',', db_table_fields($db_target, $table_target));
$db_target->query("INSERT INTO {$table_target} SET {$datalist}");
}
if ($nextid) {
showmessage("繼續轉換數據表 " . $table_source . " {$start} 至 " . ($start + $limit) . " 行", "index.php?a={$action}&source={$source}&prg={$curprg}&start=" . ($start + $limit));
}
$db_target->query("INSERT INTO {$table_target}_field_home SET {$data}");
$db_target->query("INSERT INTO {$table_target}_log SET {$data}");
$db_target->query("INSERT INTO {$table_target}_profile SET {$data}");
$db_target->query("INSERT INTO {$table_target}_status SET {$data}");
$db_uc->query("INSERT INTO {$table_target_uc_memberfields} SET {$data}");
$row = daddslashes($row, 1);
$unset = array('regip', 'lastip', 'lastvisit', 'lastactivity', 'lastpost', 'posts', 'threads', 'digestposts', 'pageviews', 'extcredits1', 'extcredits2', 'extcredits3', 'extcredits4', 'extcredits5', 'extcredits6', 'extcredits7', 'extcredits8', 'bday', 'sigstatus', 'tpp', 'ppp', 'styleid', 'dateformat', 'timeformat', 'pmsound', 'showemail', 'newsletter', 'invisible', 'prompt', 'editormode', 'customshow', 'xspacestatus', 'customaddfeed', 'newbietaskid', 'secques', 'gender');
list($year, $month, $day) = explode('-', $row['bday']);
$row['notifysound'] = $row['pmsound'];
$update = array('status' => array('regip' => $row['regip'], 'lastip' => $row['lastip'], 'lastvisit' => $row['lastvisit'], 'lastactivity' => $row['lastactivity'], 'lastpost' => $row['lastpost'], 'buyercredit' => $row['buyercredit'], 'sellercredit' => $row['sellercredit']), 'count' => array('posts' => $row['posts'], 'threads' => $row['threads'], 'digestposts' => $row['digestposts'], 'extcredits1' => $row['extcredits1'], 'extcredits2' => $row['extcredits2'], 'extcredits3' => $row['extcredits3'], 'extcredits4' => $row['extcredits4'], 'extcredits5' => $row['extcredits5'], 'extcredits6' => $row['extcredits6'], 'extcredits7' => $row['extcredits7'], 'extcredits8' => $row['extcredits8'], 'oltime' => $row['oltime']), 'profile' => array('birthyear' => $year, 'birthmonth' => $month, 'birthday' => $day, 'gender' => $row['gender'], 'site' => $rowfield['site'], 'alipay' => $rowfield['alipay'], 'icq' => $rowfield['icq'], 'qq' => $rowfield['qq'], 'yahoo' => $rowfield['yahoo'], 'msn' => $rowfield['msn'], 'taobao' => $rowfield['taobao'], 'address' => $rowfield['location'], 'bio' => $rowfield['bio']), 'field_forum' => array('customshow' => $row['customshow'], 'customstatus' => $rowfield['customstatus'], 'medals' => $rowfield['medals'], 'sightml' => $rowfield['sightml'], 'groupterms' => $rowfield['groupterms'], 'authstr' => $rowfield['authstr']));
foreach ($unset as $k) {
unset($row[$k]);
}
foreach ($update as $table => $trow) {
$data = implode_field_value($trow, ',', db_table_fields($db_target, $table_target . '_' . $table));
$db_target->query("UPDATE {$table_target}_{$table} SET {$data} WHERE uid='{$row['uid']}'");
}
$data = implode_field_value($row, ',', db_table_fields($db_target, $table_target));
$db_target->query("INSERT INTO {$table_target} SET {$data}");
$salt = rand(100000, 999999);
$row['password'] = md5($row['password'] . $salt);
$row['salt'] = $salt;
$rows = array('uid' => $row['uid'], 'username' => $row['username'], 'password' => $row['password'], 'email' => $row['email'], 'myid' => '', 'myidkey' => '', 'regip' => $row['regip'], 'regdate' => $row['regdate'], 'lastloginip' => '', 'lastlogintime' => '', 'salt' => $row['salt'], 'secques' => $row['secques']);
$data = implode_field_value($rows, ',', db_table_fields($db_uc, $table_target_uc_member));
$db_uc->query("INSERT INTO {$table_target_uc_member} SET {$data}");
}
if ($nextid) {
showmessage("继续转换数据表 " . $table_source . " uid > {$nextid}", "index.php?a={$action}&source={$source}&prg={$curprg}&start={$nextid}");
} else {
$db_target->query("UPDATE {$table_target} SET emailstatus=1 WHERE groupid<>8");
}
<?php
/**
* DiscuzX Convert
*
* $Id: threadtypes.php 10469 2010-05-11 09:12:14Z monkey $
*/
$curprg = basename(__FILE__);
$table_source = $db_source->tablepre . 'threadtypes';
$table_target = $db_target->tablepre . 'forum_threadtype';
$limit = 100;
$nextid = 0;
$start = getgpc('start');
if ($start == 0) {
$db_target->query("TRUNCATE {$table_target}");
}
$query = $db_source->query("SELECT * FROM {$table_source} WHERE typeid>'{$start}' AND special='1' ORDER BY typeid LIMIT {$limit}");
while ($threadtype = $db_source->fetch_array($query)) {
$nextid = $threadtype['typeid'];
$threadtype = daddslashes($threadtype, 1);
$data = implode_field_value($threadtype, ',', db_table_fields($db_target, $table_target));
$db_target->query("INSERT INTO {$table_target} SET {$data}");
}
if ($nextid) {
showmessage("繼續轉換數據表 " . $table_source . " typeid > {$nextid}", "index.php?a={$action}&source={$source}&prg={$curprg}&start={$nextid}");
}
<?php
/**
* DiscuzX Convert
*
* $Id: home_comment.php 15720 2010-08-25 23:56:08Z monkey $
* English by Valery Votintsev at sources.ru
*/
$curprg = basename(__FILE__);
$table_source = $db_source->tablepre . 'comment';
$table_target = $db_target->tablepre . 'home_comment';
$limit = $setting['limit']['comment'] ? $setting['limit']['comment'] : 1000;
$nextid = 0;
$start = getgpc('start');
if ($start == 0) {
$db_target->query("TRUNCATE {$table_target}");
}
$query = $db_source->query("SELECT * FROM {$table_source} WHERE cid>'{$start}' AND (idtype='blogid' OR idtype='uid' OR idtype='picid' OR idtype='sid') ORDER BY cid LIMIT {$limit}");
while ($comment = $db_source->fetch_array($query)) {
$nextid = $comment['cid'];
$comment = daddslashes($comment, 1);
$data = implode_field_value($comment, ',', db_table_fields($db_target, $table_target));
$db_target->query("INSERT INTO {$table_target} SET {$data}");
}
if ($nextid) {
showmessage(lang('update', 'continue_convert_table') . $table_source . " cid> {$nextid}", "index.php?a={$action}&source={$source}&prg={$curprg}&start={$nextid}");
}
$data = daddslashes($data, 1);
foreach ($usergroup as $field) {
$userdata[$field] = $data[$field];
}
$data['allowsearch'] = $data['allowsearch'] ? 63 : 0;
foreach ($usergroup_field as $field) {
$userfielddata[$field] = $data[$field];
}
$userfielddata['allowpostimage'] = $userfielddata['allowpostattach'];
if ($userfielddata['raterange']) {
$raterangearray = array();
foreach (explode("\n", $userfielddata['raterange']) as $range) {
$range = explode("\t", $range);
if (count($range) == 4) {
$raterangearray[$range[0]] = implode("\t", array($range[0], 'isself' => 0, 'min' => $range[1], 'max' => $range[2], 'mrpd' => $range[3]));
}
}
if (!empty($raterangearray)) {
$userfielddata['raterange'] = implode("\n", $raterangearray);
}
}
$userdatalist = implode_field_value($userdata, ',', db_table_fields($db_target, $table_target));
$userfielddatalist = implode_field_value($userfielddata, ',', db_table_fields($db_target, $table_target_field));
$db_target->query("INSERT INTO {$table_target} SET {$userdatalist}");
$db_target->query("INSERT INTO {$table_target_field} SET {$userfielddatalist}");
}
if ($nextid) {
showmessage("继续转换数据表 " . $table_source . " groupid > {$nextid}", "index.php?a={$action}&source={$source}&prg={$curprg}&start={$nextid}");
} else {
$db_target->query("UPDATE {$table_target} SET allowvisit='2' WHERE groupid='1'");
}
$table_source = $db_source->tablepre . 'mailcron';
$table_target = $db_target->tablepre . 'common_mailcron';
$table_source_rel = $db_source->tablepre . 'mailqueue';
$table_target_rel = $db_target->tablepre . 'common_mailqueue';
$limit = 1000;
$nextid = 0;
$start = getgpc('start');
if ($start == 0) {
$db_target->query("TRUNCATE {$table_target}");
$db_target->query("TRUNCATE {$table_target_rel}");
}
$query = $db_source->query("SELECT * FROM {$table_source} WHERE cid>'{$start}' ORDER BY cid LIMIT {$limit}");
$mcids = array();
while ($rs = $db_source->fetch_array($query)) {
$mcids[] = $rs['cid'];
$nextid = $rs['cid'];
$rs = daddslashes($rs, 1);
$data = implode_field_value($rs, ',', db_table_fields($db_target, $table_target));
$db_target->query("INSERT INTO {$table_target} SET {$data}");
}
if (!empty($mcids)) {
$query = $db_source->query("SELECT * FROM {$table_source_rel} WHERE cid IN (" . dimplode($mcids) . ")");
while ($rs = $db_source->fetch_array($query)) {
$rs = daddslashes($rs, 1);
$data = implode_field_value($rs, ',', db_table_fields($db_target, $table_target_rel));
$db_target->query("INSERT INTO {$table_target_rel} SET {$data}");
}
}
if ($nextid) {
showmessage(lang('update', 'continue_convert_table') . $table_source . " mcid> {$nextid}", "index.php?a={$action}&source={$source}&prg={$curprg}&start={$nextid}");
}
/**
* DiscuzX Convert
*
* $Id: spacenews.php 15777 2010-08-26 04:00:58Z zhengqingpeng $
* English by Valery Votintsev at sources.ru
*/
$curprg = basename(__FILE__);
$table_source = $db_source->tablepre . 'spacenews';
$table_target = $db_target->tablepre . 'portal_article_content';
$limit = 1000;
$nextid = 0;
$start = getgpc('start');
if ($start == 0) {
$db_target->query("TRUNCATE {$table_target}");
}
$query = $db_source->query("SELECT * FROM {$table_source} WHERE nid>'{$start}' ORDER BY nid LIMIT {$limit}");
while ($news = $db_source->fetch_array($query)) {
$nextid = $news['nid'];
$setcontent = array();
$setcontent['cid'] = $news['nid'];
$setcontent['aid'] = $news['itemid'];
$setcontent['content'] = $news['message'];
$setcontent['pageorder'] = $news['pageorder'];
$setcontent['dateline'] = $news['dateline'];
$setcontent = daddslashes($setcontent, 1);
$data = implode_field_value($setcontent, ',', db_table_fields($db_target, $table_target));
$db_target->query("INSERT INTO {$table_target} SET {$data}");
}
if ($nextid) {
showmessage(lang('update', 'continue_convert_table') . $table_source . " nid> {$nextid}", "index.php?a={$action}&source={$source}&prg={$curprg}&start={$nextid}");
}
