把step_11.php换成以下内容就行:- <?php
- //pre_forum_threadclass
- if($start <= 1) {
- truncatetable('forum_threadclass');
- validid('boardid', 'board');
- }
- $query = $db['source']->query("SELECT boardid, board_setting FROM {$source_tablepre}board WHERE boardid BETWEEN $start AND $end");
- while($dvforum = $db['source']->fetch_assoc($query)) {
- $dvforum = daddslashes($dvforum);
- $fid = $dvforum['boardid'];
- $ftemp = explode(',', $dvforum['board_setting']);
- $ftmp = $ftemp[48];
- $tmp = explode('$$', $ftmp);
- $typearray = array();
- $types = array();
- foreach($tmp AS $k => $v) {
- if(!empty($v)) {
- $typearray[$k + 1] = $v;
- }
- }
- if(count($typearray)) {
- //mccad add
- $db['discuz']->query("UPDATE {$discuz_tablepre}forum_thread SET typeid=typeid + 10000 WHERE fid='$fid'");
- foreach($typearray AS $typeid => $typename) {
- $typename = trim($typename);
- if($typename) {
- //mccad add "AND fid=$fid"
- $threadtypeid = $db['discuz']->result($db['discuz']->query("SELECT typeid FROM {$discuz_tablepre}forum_threadclass WHERE name='$typename' AND fid=$fid LIMIT 1"), 0);
- if(!$threadtypeid) {
- //pre_forum_threadclass
- $typearray['types'][] = $typename;
- $typearray['icon'][] = '';
- //$typeid = '';
- //$fid = '';
- $name = $typename;
- $displayorder = 0;
- $icon = '';
- $field1 = array('fid','name','displayorder','icon');
- $query1 = getinsertsql("{$discuz_tablepre}forum_threadclass", $field1);
- if($db['discuz']->query($query1)){
- $threadtypeid = $db['discuz']->insert_id();
- $convertedrows ++;
- } else {
- reportlog("添加主题分类出错 name = $name ,SQL 语句如下 :<br><textarea rows="3" style="width: 100%;">".$query1."</textarea>");
- }
- $totalrows ++;
- }
- $types[$threadtypeid] = $typename;
- $query2 = "UPDATE {$discuz_tablepre}forum_thread SET typeid='$threadtypeid' WHERE fid='$fid' AND typeid= 10000 + '$typeid'";
- if(!$db['discuz']->query($query2)){
- reportlog("添加主题出错 typeid = $threadtypeid ,SQL 语句如下 :<br><textarea rows="3" style="width: 100%;">".$query2."</textarea>");
- }
- }
- }
-
- $typearray['required'] = 1;
- $typearray['listable'] = 1;
- $typearray['prefix'] = 1;
- $threadtypes = serialize($typearray);
- $query3 = "UPDATE {$discuz_tablepre}forum_forumfield SET threadtypes='$threadtypes' WHERE fid='$fid'";
- if($db['discuz']->query($query3)) {
- reportlog("添加版块主题分类出错 fid = $fid ,SQL 语句如下 :<br><textarea rows="3" style="width: 100%;">".$query3."</textarea>");
- }
- }
- $converted = 1;
- }
- ?>
复制代码 |