Discuz X2帖子数据导入程序

dly · 发表于 2012-11-8 20:33:54

<?php
error_reporting(0);
define('UC_CLIENT_VERSION', '1.6.0');
define('UC_CLIENT_RELEASE', '20110501');
define('API_DELETEUSER', 1);
define('API_RENAMEUSER', 1);
define('API_GETTAG', 1);
define('API_SYNLOGIN', 1);
define('API_SYNLOGOUT', 1);
define('API_UPDATEPW', 1);
define('API_UPDATEBADWORDS', 1);
define('API_UPDATEHOSTS', 1);
define('API_UPDATEAPPS', 1);
define('API_UPDATECLIENT', 1);
define('API_UPDATECREDIT', 1);
define('API_GETCREDIT', 1);
define('API_GETCREDITSETTINGS', 1);
define('API_UPDATECREDITSETTINGS', 1);
define('API_ADDFEED', 1);
define('API_RETURN_SUCCEED', '1');
define('API_RETURN_FAILED', '-1');
define('API_RETURN_FORBIDDEN', '1');
@define('IN_DISCUZ', true);
@define('IN_API', true);
@define('CURSCRIPT', 'api');
define('DISCUZ_ROOT', dirname(dirname(__FILE__)).'/');
require_once DISCUZ_ROOT.'./config/config_global.php';
require_once DISCUZ_ROOT.'./config/config_ucenter.php';
require_once DISCUZ_ROOT.'./source/function/function_core.php';
require_once DISCUZ_ROOT.'./source/class/class_core.php';
$discuz = & discuz_core::instance();
$discuz->init();
$_adb = 'a';
$_a_thread = 'pre_forum_thread';
$_a_fid = '77';
$_bdb = 'b';
$_b_thread = 'pre_forum_thread';
$_b_fid = '47';
$_tids='';
$_tarr='';
//----------------------------------------------
$tid_max[tid]=34;
$pid_max[pid]=54;
$aid_max[aid]=27;
$sql = "SELECT * FROM $_a_thread WHERE fid = '$_a_fid' and displayorder>=0 and tid>0 order by tid asc LIMIT 0 , 1000 ";
$r = DB::query($sql);
while($t = DB::fetch($r)){
$tid = $t[tid];
$t['fid'] = $_b_fid;
$t[tid]+=$tid_max[tid];
$_tarr[] = $t;
$sql_p =" SELECT * FROM pre_forum_post WHERE tid = $tid and invisible >=0 ";
$r_p = DB::query($sql_p);
while($t_p = DB::fetch($r_p)){
$pid = $t_p[pid];
$t_p[pid]+=$pid_max[pid];
$t_p['fid'] = $_b_fid;
$t_p[tid] = $t[tid];
unset($t_p['hidepost']);
unset($t_p['wnmessagepost']);
unset($t_p['bonused']);
$_parr[] = $t_p;
$sql_a = "SELECT * FROM pre_forum_attachment WHERE pid=$pid";
$r_a = DB::query($sql_a);
while($t_a = DB::fetch($r_a)){
$aid = $t_a[aid];
$tableids = $t_a[tableid];
$t_a[aid]+=$aid_max[aid];
$t_a[tid] = $t[tid];
$t_a[pid] = $t_p[pid];
$tableid = substr($t[tid],-1,1);
$t_a[tableid] = $tableid;
$_aarr[] = $t_a;
$sql_as = "SELECT * FROM pre_forum_attachment_$tableids WHERE aid=$aid";
$t_as = DB::fetch_first($sql_as);
$t_as[aid]+=$aid_max[aid];
$t_as[tid] = $t[tid];
$t_as[pid] = $t_p[pid];
$_asarr[$tableid][] = $t_as;
}
}
}
foreach($_tarr as $key => $value)
{
$sql = "INSERT INTO `$_bdb`.pre_forum_thread set" ;
foreach( $value as $k => $v)
{
$sql .= "`$k`='".addslashes($v)."',";
}
$sql=substr($sql,0,-1);
DB::query($sql);
echo $value[tid]-$tid_max[tid].'
';
}
foreach($_parr as $key=>$value){
$sql = "INSERT INTO `$_bdb`.pre_forum_post set" ;
foreach($value as $k=>$v){
$sql .= "`$k`='".addslashes($v)."',";
}
$sql =substr($sql,0,-1);
DB::query($sql);
}
foreach($_aarr as $key=>$value){
$sql = "INSERT INTO `$_bdb`.pre_forum_attachment set" ;
foreach($value as $k=>$v){
$sql .= "`$k`='".addslashes($v)."',";
}
$sql =substr($sql,0,-1);
DB::query($sql);
}
foreach($_asarr as $key=>$value){
foreach($_asarr[$key] as $k_as=>$v_as){
$sql = "INSERT INTO `$_bdb`.pre_forum_attachment_$key set" ;
foreach($v_as as $k=>$v){
$sql .= "`$k`='".addslashes($v)."',";
}
$sql =substr($sql,0,-1);
DB::query($sql);
}
}
echo $tid_max[tid].'插入完毕
';
?>

复制代码

[二次开发] Discuz X2帖子数据导入程序

相关帖子