[转载]phpBB2Discuz 转换程序

原帖子
http://bbs.guoxue.com/viewthread ... p;extra=page%3D1###

phpBB2Discuz 转换程序

phpbb2.*升级到Discuz! 5.5.0
//
我们原来的国学论坛功能太少了,现在升级到Discuz! 5.5.0,效果还不错,基本上所有的信息全保留了!!
共享一下这次国学论坛转换所用的代码，个人认为和官方论坛上的提供的程序功能差不多 ，这个程序可以支持异机器之间的转换，不要求数据库在同一台机器上，
所有带有_s的变量表示数据源，带有_t后缀的变量表示目标数据，本程序暂不提供版主转换功能！
和官方提供的程序相比，本程序可多转换myposts和mythreads表,自动处理quote,[em]等标记
源论坛附件会被自动重命名和拷贝到相应的文件夹中。
呵呵，本人不提供程序正确的担保哦，如果丢失信息了，我也没法子！


主要函数：
//////////////////
convertForums();  //必须先运行这个转换
convertMsg($limit);
convertUser($limit); //如果出现错误，可修改username 为 binary 属性
convertAttachment($limit);
convertPosts($limit);
convertTopics($limit);
/////////////////

1. 
   
2. 
   
3. 
   
4. 
   
5. <?php
   
6. /*
   
7. src=http://bbs.guoxue.com
   
8. Author=zhanjun，gxbd
   
9. version=1.0
   
10. Date=2007-05-31
    
11. */
    
12. 
    
13. set_time_limit(0);
    
14. 
    
15. echo "phpbb2.*升级到Discuz! 5.5.0\n";
    
16. 
    
17. 
    
18. //////////////////////
    
19. $cat_count=14;  //大分类数量 ，为零的话由程序自动判断
    
20. $attpath="/var/www/html/bbs/files/"; //附件所在位置
    
21. $debug=0; //==0 正式转换 ==1 测试
    
22. $len=3000; //测试数据条数
    
23. $adminid=2; //管理员UID
    
24. $charset='GBK'; //字符集
    
25. 
    
26. 
    
27. //数据源 GBK编码 phpbb2.2.*
    
28. $host_s='localhost';
    
29. $dbuser_s='root'  ;
    
30. $dbpasswd_s='';
    
31. $mydb_s='bbs';
    
32. $prefix_s='phpbb_';
    
33. $link_s=mysql_pconnect($host_s,$dbuser_s,$dbpasswd_s) or die("Could not connect  ".mysql_error($link_s)."connect s err\n");
    
34. mysql_query("SET NAMES '".$charset."'",$link_s);
    
35. ////////////////////
    
36. 
    
37. ////////////////////////
    
38. //目标数据 Discuz! 5.5.0
    
39. $host_t='0.0.0.0';
    
40. $dbuser_t='root'  ;
    
41. $dbpasswd_t='';
    
42. $prefix_t='bbs_';
    
43. $link_t=mysql_pconnect($host_t,$dbuser_t,$dbpasswd_t,3306) or die("Could not connect  ".mysql_error($link_t)."connect t err\n");
    
44. mysql_query("SET NAMES '".$charset."'",$link_t);
    
45. 
    
46. $mydb_s='bbs';
    
47. $mydb_t='bbs';
    
48. mysql_select_db($mydb_s,$link_s) or die("Could not select s database");;
    
49. mysql_select_db($mydb_t,$link_t) or die("Could not select t database");;
    
50. 
    
51. ////////////////////////
    
52. if($debug==0)
    
53. {
    
54. $limit="";
    
55. echo "正式转换模式  \n";
    
56. }
    
57. else
    
58. {
    
59. $limit=" LIMIT 0,$len";
    
60. echo $limit ."  测试模式\n" ;
    
61. }
    
62. 
    
63. /////////////////////////
    
64. /////////用户表转换函数
    
65. function convertUser($limit=" LIMIT 0,30 "){
    
66. global $prefix_t,$prefix_s,$link_s,$link_t,$adminid;
    
67. mysql_query("TRUNCATE TABLE `".$prefix_t."members` ",$link_t);
    
68. mysql_query("TRUNCATE TABLE `".$prefix_t."memberspaces` ",$link_t);
    
69. mysql_query("TRUNCATE TABLE `".$prefix_t."memberfields` ",$link_t);
    
70. $sql_s ="select *  from ".$prefix_s."users order by user_id  $limit";
    
71. 
    
72. 
    
73. //echo $sql_s."\n";
    
74. $result_s=mysql_query($sql_s,$link_s) or print(mysql_error($link_s)."\n".$sql_s."\n");
    
75. while($r_s=mysql_fetch_array($result_s)){
    
76. 
    
77.      $_username=$r_s['username'];
    
78. 
    
79.      if (empty($_username) || htmlspecialchars($_username) != $_username || (strlen($_username)>=15)) {
    
80.             echo "非法用户名:uid = ".$r_s['user_id'] ." username = $_username 不能被转换!!\r\n";
    
81.             //continue;
    
82.               }
    
83. 
    
84.     if ($r_s['user_avatar_type'] == 2){
    
85.             $avatar = $r_s['user_avatar'];
    
86. 
    
87.         } else if ($r_s['user_avatar_type'] == 1 || $r_s['user_avatar_type'] == 3){
    
88.             $avatar = 'customavatars/'.$r_s['user_avatar'];
    
89. 
    
90.         }
    
91. 
    
92. 
    
93.           //等级转换
    
94.          if ($r_s['user_rank']>=1)
    
95.            {
    
96.            $groupid=11+$r_s['user_rank'];
    
97.            if ($groupid>=15) $groupid=15;
    
98.            //15==论坛元老 14==高级
    
99.            }
    
100.           else
     
101.           {
     
102. 
     
103.             if ($r_s['user_posts'] >=10)
     
104.                 $groupid=11; //注册用户
     
105.              else
     
106.                 $groupid=10;
     
107. 
     
108.             if ($r_s['user_posts'] >=100)
     
109.                 $groupid=13; //高级用户
     
110. 
     
111.           }
     
112. 
     
113.              $isadmin=0;
     
114. 
     
115.           if ($r_s['user_id']==$adminid)
     
116.               {
     
117.                   $groupid=1; //
     
118.                 $isadmin=1;
     
119.                }
     
120. 
     
121.           $sigstatus=$r_s['user_sig'] ? 1 : 0;
     
122. 
     
123. 
     
124.           $sql_t="INSERT INTO `".$prefix_t."members` (`uid`, `username`, `password`, `secques`, `gender`, `adminid`, `groupid`, `groupexpiry`, `extgroupids`, `regip`, `regdate`, `lastip`, `lastvisit`, `lastactivity`, `lastpost`, `posts`, `digestposts`, `oltime`, `pageviews`, `credits`, `extcredits1`, `extcredits2`, `extcredits3`, `extcredits4`, `extcredits5`, `extcredits6`, `extcredits7`, `extcredits8`, `email`, `bday`, `sigstatus`, `tpp`, `ppp`, `styleid`, `dateformat`, `timeformat`, `pmsound`, `showemail`, `newsletter`, `invisible`, `timeoffset`, `newpm`, `accessmasks`, `editormode`, `customshow`, `xspacestatus`) VALUES (".$r_s['user_id'].", '".addslashes(trim($r_s['username']))."', '".$r_s['user_password']."', '', 0, ".$isadmin.", ".$groupid.", 0, '', '', ".$r_s['user_regdate'].", '', ".$r_s['user_lastvisit'].", ".$r_s['user_session_time'].", 0, ".$r_s['user_posts'].", 0, 0, 0, ".$r_s['user_posts'].", ".$r_s['user_posts'].", 0, 0, 0, 0, 0, 0, 0, '".$r_s['user_email']."','0000-00-00', ".$sigstatus.", 0, 0, 0, '', 0, 1, 1, 1, 0, '9999', 0, 0, 2, 26, 0);";
     
125.           //echo $sql_t."\n";
     
126. 
     
127.           if (!$result_t=mysql_query($sql_t,$link_t) )
     
128.           {
     
129.           //echo $sql_t."\n";
     
130.           continue; //去除重复错误
     
131.           }
     
132. 
     
133. 
     
134.           mysql_free_result($result_t);
     
135.           $sql_t="INSERT INTO `".$prefix_t."memberspaces` (`uid`,`style`, `description`, `layout`, `side`) VALUES (".$r_s['user_id'].", 'default', '', '[userinfo][calendar][myreplies][myfavforums]    [myblogs][mythreads]    ', 1)";
     
136.           //echo $sql_t."\n";
     
137.           $result_t=mysql_query($sql_t,$link_t) or print(mysql_error($link_t)."\n".$sql_t."\n");
     
138.           mysql_free_result($result_t);
     
139.           $sql_t="INSERT INTO `".$prefix_t."memberfields` (`uid`, `nickname`, `site`, `alipay`, `icq`, `qq`, `yahoo`, `msn`, `taobao`, `location`, `customstatus`, `medals`, `avatar`, `avatarwidth`, `avatarheight`, `bio`, `sightml`, `ignorepm`, `groupterms`, `authstr`, `spacename`) VALUES (".$r_s['user_id'].", '', '', '', '".addslashes($r_s['user_icq'])."', '', '".addslashes($r_s['user_yim'])."', '".addslashes($r_s['user_msnm'])."', '', '', '', '', '".$avatar."', 83, 92, '', '".addslashes(parsesign ( convertbbcode( $r_s['user_sig'] ) ) )."', '', '', '', '')";
     
140.           $result_t=mysql_query($sql_t,$link_t) or print(mysql_error($link_t)."\n".$sql_t."\n");
     
141.           mysql_free_result($result_t);
     
142. 
     
143. 
     
144.             }
     
145. 
     
146.          echo "用户表转换完成,共转换记录".mysql_num_rows($result_s)."条\n";
     
147.          mysql_free_result($result_s);
     
148. 
     
149. 
     
150. }
     
151. /////////////////////////
     
152. /////////短消息表转换函数
     
153. function convertMsg($limit=" LIMIT 0,30 "){
     
154. 
     
155. 
     
156. 
     
157. global $prefix_t,$prefix_s,$link_s,$link_t;
     
158. 
     
159. mysql_query("TRUNCATE TABLE `".$prefix_t."pms` ",$link_t);
     
160. 
     
161. //order by s.privmsgs_from_userid
     
162. 
     
163. $sql_s ="select s.*,t.*, u.username  from ".$prefix_s."privmsgs as s ,".$prefix_s."privmsgs_text  as t ,".$prefix_s."users as u where  (t.privmsgs_text_id=s.privmsgs_id) and (u.user_id=s.privmsgs_from_userid)  $limit";
     
164. 
     
165. //echo $sql_s."\n";
     
166. 
     
167. $result_s=mysql_query($sql_s,$link_s) or print(mysql_error($link_s)."-s\n");
     
168. 
     
169. while($r_s=mysql_fetch_array($result_s)){
     
170. 
     
171.   $box=$r_s['privmsgs_type'];
     
172. 
     
173.   if ($box=='0')
     
174.    $boxtype='inbox';
     
175.   else
     
176.    $boxtype='outbox';
     
177. 
     
178.   $sql_t="INSERT INTO `".$prefix_t."pms` (`pmid`, `msgfrom`, `msgfromid`, `msgtoid`, `folder`, `new`, `subject`, `dateline`, `message`, `delstatus`) VALUES (".$r_s['privmsgs_id'].", '".addslashes($r_s[username])."', ".$r_s['privmsgs_from_userid'].", ".$r_s['privmsgs_to_userid'].", '".$boxtype."', 0, '".addslashes($r_s['privmsgs_subject'])."', ".$r_s['privmsgs_date'].", '".addslashes(trim(convertbbcode($r_s['privmsgs_text'])) )."', 0)";
     
179. 
     
180.   //echo $sql_t."\n";
     
181. 
     
182.   $result_t=mysql_query($sql_t,$link_t) or print(mysql_error($link_t)."\n".$sql_t."\n");
     
183.   mysql_free_result($result_t);
     
184.              }
     
185. 
     
186.   echo "短消息转换完成,共转换记录".mysql_num_rows($result_s)."条\n";
     
187.   mysql_free_result($result_s);
     
188. }
     
189. 
     
190. //新旧版面对应关系 +$cat_count;
     
191. 
     
192. function convertForums($limit=" LIMIT 0,30 "){
     
193. 
     
194. global $prefix_t,$prefix_s,$link_s,$link_t,$cat_count;
     
195. 
     
196. 
     
197. mysql_query("TRUNCATE TABLE `".$prefix_t."forums` ",$link_t);
     
198. mysql_query("TRUNCATE TABLE `".$prefix_t."forumfields` ",$link_t);
     
199. $sql_s ="SELECT * FROM `".$prefix_s."categories` ORDER BY `cat_id` ASC " ;
     
200. 
     
201. //echo $sql_s."\n";
     
202. 
     
203. $result_s=mysql_query($sql_s,$link_s) or print(mysql_error($link_s)."\n".$sql_s."\n");
     
204. 
     
205. while($r_s=mysql_fetch_array($result_s)){
     
206. 
     
207.           //大分类转换
     
208. 
     
209.           $sql_t="INSERT INTO `".$prefix_t."forums` (`fid`, `fup`, `type`, `name`, `status`, `displayorder`, `styleid`, `threads`, `posts`, `todayposts`, `lastpost`, `allowsmilies`, `allowhtml`, `allowbbcode`, `allowimgcode`, `allowanonymous`, `allowshare`, `allowpostspecial`, `allowspecialonly`, `alloweditrules`, `recyclebin`, `modnewposts`, `jammer`, `disablewatermark`, `inheritedmod`, `autoclose`, `forumcolumns`, `threadcaches`, `allowpaytoauthor`, `alloweditpost`, `simple`) VALUES (".$r_s['cat_id'].", 0, 'group', '".$r_s['cat_title']."', 1, ".$r_s['cat_order'].", 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0)";
     
210.           //echo $sql_t."\n";
     
211.           $result_t=mysql_query($sql_t,$link_t) or print(mysql_error($link_t)."\n".$sql_t."\n");
     
212. 
     
213.           $sql_t="INSERT INTO `".$prefix_t."forumfields` VALUES (".$r_s['cat_id'].", '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '')";
     
214. 
     
215.           $result_t=mysql_query($sql_t,$link_t) or print(mysql_error($link_t)."\n".$sql_t."\n");
     
216. 
     
217. 
     
218.              }
     
219. 
     
220.         if ($cat_count=='')
     
221.           $cat_count=mysql_num_rows($result_s);
     
222. 
     
223.          echo "大分类表转换完成,共转换记录".$cat_count."条\n";
     
224. 
     
225. 
     
226. 
     
227. $sql_s ="SELECT * FROM `".$prefix_s."forums` ORDER BY `forum_id` ASC" ;
     
228. 
     
229. //echo $sql_s."\n";
     
230. 
     
231. $result_s=mysql_query($sql_s,$link_s) or print(mysql_error($link_s)."\n".$sql_s."\n");
     
232. 
     
233. while($r_s=mysql_fetch_array($result_s)){
     
234. 
     
235.      $fname=strlen($r_s['forum_name']) < 50 ? $r_s['forum_name'] : cutstr(htmlspecialchars(trim(@strip_tags($r_s['forum_name']))),50);
     
236.           $fid=$r_s['forum_id']+$cat_count;
     
237.           $gid=$r_s['cat_id'];
     
238.           //子分类转换
     
239.           $sql_t="INSERT INTO `".$prefix_t."forums` (`fid`, `fup`, `type`, `name`, `status`, `displayorder`, `styleid`, `threads`, `posts`, `todayposts`, `lastpost`, `allowsmilies`, `allowhtml`, `allowbbcode`, `allowimgcode`, `allowanonymous`, `allowshare`, `allowpostspecial`, `allowspecialonly`, `alloweditrules`, `recyclebin`, `modnewposts`, `jammer`, `disablewatermark`, `inheritedmod`, `autoclose`, `forumcolumns`, `threadcaches`, `allowpaytoauthor`, `alloweditpost`, `simple`) VALUES (".$fid.", ".$gid.", 'forum', '".$fname."', 1, ".$r_s['forum_order'].", 0, ".$r_s['forum_topics'].", ".$r_s['forum_posts'].", 0, '', 1, 0, 1, 1, 0, 1, 15, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0)";
     
240.           //echo $sql_t."\n";
     
241.           $result_t=mysql_query($sql_t,$link_t) or print(mysql_error($link_t)."\n".$sql_t."\n");
     
242.           mysql_free_result($result_t);
     
243.           $sql_t="INSERT INTO `".$prefix_t."forumfields` VALUES (".$fid.", '".addslashes($r_s['forum_desc'])."', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '')";
     
244.           $result_t=mysql_query($sql_t,$link_t) or print(mysql_error($link_t)."\n".$sql_t."\n");
     
245. 
     
246.           mysql_free_result($result_t);
     
247. 
     
248.              }
     
249. 
     
250.          echo "子分类表转换完成,共转换记录".mysql_num_rows($result_s)."条\n";
     
251.          mysql_free_result($result_s);
     
252. 
     
253. }
     
254. ////////////////////////
     
255. function convertTopics($limit=" LIMIT 0,30 "){
     
256. 
     
257. echo "topic表转换\n";
     
258. global $prefix_t,$prefix_s,$link_s,$link_t,$cat_count;
     
259. 
     
260. mysql_query("TRUNCATE TABLE `".$prefix_t."threads`  ",$link_t)  or print(mysql_error($link_t))."\n";
     
261. mysql_query("TRUNCATE TABLE `".$prefix_t."mythreads` ",$link_t)  or print(mysql_error($link_t))."\n";
     
262. 
     
263. $sql_s ="SELECT t.*,u.username  FROM ".$prefix_s."topics as t ,  ".$prefix_s."users AS u  where u.user_id=t.topic_poster $limit";
     
264. 
     
265. // echo $sql_s."\n";
     
266. 
     
267. 
     
268. $result_s=mysql_query($sql_s,$link_s) or print(mysql_error($link_s)."\n".$sql_s."\n");
     
269. 
     
270. while($r_s=mysql_fetch_array($result_s)){
     
271. 
     
272.           //threads 转换
     
273.   $fid= $r_s['forum_id']+$cat_count;
     
274. 
     
275.   if($r_s['topic_first_post_id']==$r_s['topic_last_post_id'])
     
276.    {
     
277.    $lastposter=addslashes($r_s['username']);
     
278.    }
     
279.   else
     
280.     {
     
281.     $lastposter=htmlspecialchars(getusername($r_s['topic_last_post_id']));
     
282.     }
     
283. 
     
284. 
     
285.   $isgood=$r_s['topic_good'] ? 1 : 0;//精华帖子，如果没有装相应的mod，可以不管这个
     
286. 
     
287. 
     
288. 
     
289.   $sql_t="INSERT INTO `".$prefix_t."mythreads` (`uid`, `tid`, `dateline`) VALUES (".$r_s['topic_poster'].", ".$r_s['topic_id'].", ".$r_s['topic_time'].")";
     
290.   $result_t=mysql_query($sql_t,$link_t) or print(mysql_error($link_t)."\n".$sql_t."\n");
     
291.   mysql_free_result($result_t);
     
292.   //echo $sql_t."\n";
     
293. 
     
294. 
     
295.   $sql_t="INSERT INTO `".$prefix_t."threads` VALUES (".$r_s['topic_id'].", ".$fid.", 0, 0, 0, 0, '".addslashes($r_s['username'])."', ".$r_s['topic_poster'].", '".addslashes(strip_tags($r_s['topic_title']))."', ".$r_s['topic_time'].", ".$r_s['topic_time'].", '".$lastposter."', ".$r_s['topic_views'].", ".$r_s['topic_replies'].", ".$r_s['topic_type'].", 0, ".$isgood.", 0, 0, 0, ".$r_s['topic_attachment'].", 0, 0, ".($r_s['isok']-1).", 0, 0)";
     
296.   $result_t=mysql_query($sql_t,$link_t) or print(mysql_error($link_t)."\n".$sql_t."\n");
     
297.   mysql_free_result($result_t);
     
298. 
     
299.      }
     
300. 
     
301.   echo "topic表转换完成,共转换记录".mysql_num_rows($result_s)."条\n";
     
302.   mysql_free_result($result_s);
     
303. 
     
304.   }
     
305. 
     
306. ///////////////////////
     
307. 
     
308. function convertPosts($limit=" LIMIT 0,30 "){
     
309. 
     
310.   echo "posts表转换\n";
     
311. 
     
312. global $prefix_t,$prefix_s,$link_s,$link_t,$cat_count;
     
313. 
     
314. mysql_query("TRUNCATE TABLE `".$prefix_t."posts`  ",$link_t) or print(mysql_error($link_t))."\n";
     
315. mysql_query("TRUNCATE TABLE `".$prefix_t."myposts` ",$link_t) or print(mysql_error($link_t))."\n";
     
316. 
     
317. $sql_s="SELECT p.*,t.post_subject, t.post_text, u.username FROM ".$prefix_s."posts AS p, ".$prefix_s."posts_text AS t, ".$prefix_s."users AS u WHERE ( p.`post_id` = t.post_id ) AND ( p.poster_id = u.user_id)
     
318.   order by t.post_id  $limit ";
     
319. 
     
320. //echo $sql_s."\n";
     
321. 
     
322. 
     
323. $result_s=mysql_query($sql_s,$link_s) or print(mysql_error($link_s)."\n".$sql_s."\n");
     
324. 
     
325. while($r_s=mysql_fetch_array($result_s)){
     
326. 
     
327.   //posts转换
     
328.   $fid= $r_s['forum_id']+$cat_count;
     
329. 
     
330.   $ip=decode_ip($r_s['poster_ip']);
     
331. 
     
332.   $sql_t="INSERT INTO `".$prefix_t."posts` (`pid`, `fid`, `tid`, `first`, `author`, `authorid`, `subject`, `dateline`, `message`, `useip`, `invisible`, `anonymous`, `usesig`, `htmlon`, `bbcodeoff`, `smileyoff`, `parseurloff`, `attachment`, `rate`, `ratetimes`) VALUES (".$r_s['post_id'].", ".$fid.", ".$r_s['topic_id'].", 0, '".addslashes($r_s['username'])."',".$r_s['poster_id'].",'".addslashes($r_s['post_subject'])."', ".$r_s['post_time'].", '".addslashes(convertbbcode($r_s['post_text']))."', '".$ip."', 0, 0, 0, 0, 0, 0, 0, ".$r_s['post_attachment'].", 0, 0)";
     
333. 
     
334.   //echo $sql_t."\n";
     
335. 
     
336.   $result_t=mysql_query($sql_t,$link_t) or print(mysql_error($link_t)."\n".$sql_t."\n");
     
337. 
     
338.   mysql_free_result($result_t);
     
339. 
     
340. 
     
341. 
     
342.   $sql_t="INSERT INTO `".$prefix_t."myposts` (`uid`, `tid`, `pid`, `position`, `dateline`) VALUES (".$r_s['poster_id'].", ".$r_s['topic_id'].", ".$r_s['post_id'].", 2, ".$r_s['post_time'].")";
     
343. 
     
344. if (!$result_t=mysql_query($sql_t,$link_t) )
     
345.           {
     
346.           //echo $sql_t."\n";
     
347.            //仅第一个回复写入mypost
     
348.           continue;
     
349.           }
     
350. 
     
351.   //print(mysql_error($link_t)."\n".$sql_t."\n");
     
352. 
     
353.   mysql_free_result($result_t);
     
354. 
     
355.   // echo $sql_t."\n";
     
356. 
     
357. 
     
358. 
     
359.     }
     
360. 
     
361.   echo "posts表转换完成,共转换记录".mysql_num_rows($result_s)."条\n";
     
362.   mysql_free_result($result_s);
     
363. 
     
364. 
     
365. 
     
366.   /////////////////////////////
     
367. 
     
368. 
     
369. 
     
370. 
     
371. 
     
372. }
     
373. 
     
374. 
     
375. 
     
376. 
     
377. ///////////////////////
     
378. //附件转换
     
379. function convertAttachment($limit=" LIMIT 0,30 "){
     
380.   echo "附件表转换\n";
     
381. global $prefix_t,$prefix_s,$link_s,$link_t,$cat_count,$attpath,$debug;
     
382. 
     
383. mysql_query("TRUNCATE TABLE `".$prefix_t."attachments` ",$link_t);
     
384. 
     
385. $sql_s ="SELECT s.*,t.*, p.topic_id FROM `".$prefix_s."attachments` as s,".$prefix_s."attachments_desc as t ,".$prefix_s."posts as p where (s.attach_id=t.attach_id ) and (s.post_id=p.post_id) ORDER BY s.attach_id ASC $limit" ;
     
386. 
     
387. echo $sql_s."\n";
     
388. 
     
389. $result_s=mysql_query($sql_s,$link_s) or print(mysql_error($link_s)."\n".$sql_s."\n");
     
390. 
     
391. while($r_s=mysql_fetch_array($result_s)){
     
392. 
     
393.           //大分类转换
     
394. 
     
395. 
     
396.           $topic_id=$r_s['topic_id'];
     
397.           $year=date("y",$r_s['filetime']);
     
398.           $month=date("m",$r_s['filetime']);
     
399.           $dir="month_".$year.$month;
     
400.           $attname=$dir."/".MD5($r_s['physical_filename']).".".$r_s['extension'];
     
401. 
     
402.           //批量修改附件名称和位置
     
403. 
     
404.           if ( !is_dir($dir))  {
     
405. 
     
406.             mkdir($dir);
     
407. 
     
408.           }
     
409. 
     
410.           $cmd="cp ".$attpath.$r_s['physical_filename']." ".$attname;
     
411. 
     
412.           $isimage    =    in_array($r_s['mimetype'], array('image/pjpeg', 'image/gif', 'image/bmp', 'image/png')) ? 1 : 0;
     
413. 
     
414.           if ($debug==0) system($cmd);
     
415. 
     
416.           $sql_t="INSERT INTO `".$prefix_t."attachments` (`aid`, `tid`, `pid`, `dateline`, `readperm`, `price`, `filename`, `description`, `filetype`, `filesize`, `attachment`, `downloads`, `isimage`, `uid`, `thumb`, `remote`) VALUES ('', ".$topic_id.", ".$r_s['post_id'].", ".$r_s['filetime'].", 0, 0, '".addslashes($r_s['real_filename'])."', '".addslashes($r_s['comment'])."', '".$r_s['mimetype']."', ".$r_s['filesize'].", '".$attname."', ".$r_s['download_count'].", ".$isimage.", ".$r_s['user_id_1'].", 0, 0)";
     
417. 
     
418.           $result_t=mysql_query($sql_t,$link_t) or die(mysql_error($link_t)."\n".$sql_t."\n");
     
419. 
     
420.          }
     
421. 
     
422.          echo "附件表转换完成,共转换记录".mysql_num_rows($result_s)."条\n";
     
423.          mysql_free_result($result_s);
     
424. }
     
425. 
     
426. 
     
427. 
     
428. 
     
429. function cutstr($string, $length) {
     
430.     $wordscut = '';
     
431.     if(strlen($string) > $length) {
     
432.         for($i = 0; $i < $length - 3; $i++) {
     
433.             if(ord($string[$i]) > 127) {
     
434.                 $wordscut .= $string[$i].$string[$i + 1];
     
435.                 $i++;
     
436.             } else {
     
437.                 $wordscut .= $string[$i];
     
438.             }
     
439.         }
     
440.         return $wordscut;
     
441.     }
     
442.     return $string;
     
443. }
     
444. 
     
445. 
     
446. function convertbbcode($message) {
     
447.     $searcharray1 = array(
     
448.         '<i>',
     
449.         '</i>',
     
450.         '[REPLY]',
     
451.         '[/REPLY]',
     
452.         '</align>',
     
453.         '<BR>'
     
454.     );
     
455. 
     
456.     $replacearray1 = array(
     
457.         '[i]',
     
458.         '[/i]',
     
459.         '[hide]',
     
460.         '[/hide]',
     
461.         '[align]',
     
462.         '\n',
     
463. 
     
464.     );
     
465. 
     
466.     $searcharray2 = array(
     
467.         "/(\[[^\]]*?)(\:\w+)?]/is",
     
468.         "/\<P align=([^\[\<]+?)\>/is"
     
469.     );
     
470. 
     
471.     $replacearray2 = array(
     
472.         "\\1]",
     
473.         "[align=\\1]"
     
474.     );
     
475. 
     
476.       $message=preg_replace("/\[quote.*?\]/","[quote]",$message);
     
477.       $message=preg_replace("/\[em.*?\]/",":)",$message);
     
478. 
     
479.     return preg_replace($searcharray2, $replacearray2, str_replace($searcharray1, $replacearray1, $message));
     
480. }
     
481. 
     
482. function decode_ip($int_ip) {
     
483.     $hexipbang = explode('.', chunk_split($int_ip, 2, '.'));
     
484.     return hexdec($hexipbang[0]). '.' . hexdec($hexipbang[1]) . '.' . hexdec($hexipbang[2]) . '.' . hexdec($hexipbang[3]);
     
485. }
     
486. 
     
487. function pid2uid($uid) {
     
488.     return $uid ? @mysql_result(mysql_query("SELECT poster_id FROM `".$prefix_s."posts` WHERE post_id='$uid' LIMIT 1"), 0) : 0;
     
489. 
     
490.     die($uid);
     
491. 
     
492. }
     
493. 
     
494. function pid2tid($uid) {
     
495.     return $uid ? @mysql_result(mysql_query("SELECT topic_id FROM `".$prefix_s."posts` WHERE post_id='$uid' LIMIT 1"), 0) : 0;
     
496. 
     
497. }
     
498. function getusername($uid) {
     
499.     $uid= pid2uid($uid);
     
500.     return $uid ? @mysql_result(mysql_query("SELECT username FROM  `".$prefix_s."users` WHERE user_id='$uid' LIMIT 1"), 0) : 0;
     
501. }
     
502. 
     
503. 
     
504. ///下面这些功能函数直接修改至discuzz!网上的一个程序
     
505. 
     
506. function parsesign($sign) {
     
507. 
     
508.     $searcharray = array(
     
509.         '[/color]', '[/size]', '[/font]', '[/align]', '[b]', '[/b]',
     
510.         '[i]', '[/i]', '[u]', '[/u]', '[list]', '[list=1]', '[list=a]',
     
511.         '[list=A]', '[*]', '[/list]', '[indent]', '[/indent]'
     
512.     );
     
513. 
     
514.     $replacearray = array(
     
515.         '</font>', '</font>', '</font>', '</p>', '<b>', '</b>', '<i>',
     
516.         '</i>', '<u>', '</u>', '<ul>', '<ol type=1>', '<ol type=a>',
     
517.         '<ol type=A>', '<li>', '</ul></ol>', '<blockquote>', '</blockquote>'
     
518.     );
     
519. 
     
520.     $pregfind = array(
     
521.         "/\[url\]\s*(www.|https?:\/\/|ftp:\/\/|gopher:\/\/|news:\/\/|telnet:\/\/|rtsp:\/\/|mms:\/\/|callto:\/\/|ed2k:\/\/){1}([^\["']+?)\s*\[\/url\]/ie",
     
522.         "/\[url=www.([^\["']+?)\](.+?)\[\/url\]/is",
     
523.         "/\[url=(https?|ftp|gopher|news|telnet|rtsp|mms|callto|ed2k){1}:\/\/([^\["']+?)\](.+?)\[\/url\]/is",
     
524.         "/\[email\]\s*([a-z0-9\-_.+]+)@([a-z0-9\-_]+[.][a-z0-9\-_.]+)\s*\[\/email\]/i",
     
525.         "/\[email=([a-z0-9\-_.+]+)@([a-z0-9\-_]+[.][a-z0-9\-_.]+)\](.+?)\[\/email\]/is",
     
526.         "/\[color=([^\[\<]+?)\]/i",
     
527.         "/\[size=([^\[\<]+?)\]/i",
     
528.         "/\[font=([^\[\<]+?)\]/i",
     
529.         "/\[align=([^\[\<]+?)\]/i",
     
530.         "/\s*\[quote\][\n\r]*(.+?)[\n\r]*\[\/quote\]\s*/is",
     
531.         "/\s*\[code\](.+?)\[\/code\]\s*/ies",
     
532.         "/\[img\]\s*([^\[\<\r\n]+?)\s*\[\/img\]/ies",
     
533.         "/\[img=(\d{1,3})[x|\,](\d{1,3})\]\s*([^\[\<\r\n]+?)\s*\[\/img\]/ies"
     
534.     );
     
535.     $pregreplace = array(
     
536.         "cuturl('\\1\\2')",
     
537.         "<a href="http://www.\\1" target="_blank">\\2</a>",
     
538.         "<a href="\\1://\\2" target="_blank">\\3</a>",
     
539.         "<a href="mailto:\\1@\\2">\\1@\\2</a>",
     
540.         "<a href="mailto:\\1@\\2">\\3</a>",
     
541.         "<font color="\\1">",
     
542.         "<font size="\\1">",
     
543.         "<font face="\\1">",
     
544.         "<p align="\\1">",
     
545.         "<div class="altbg2" style="margin: 2em; margin-top: 3px; padding: 10px; border: ".INNERBORDERWIDTH."px solid ".BORDERCOLOR."; word-break: break-all">\\1</div>",
     
546.         "<div class="altbg2" style="margin: 2em; margin-top: 3px; clear: both; padding: 10px; padding-top: 5px; border: ".INNERBORDERWIDTH."px solid ".BORDERCOLOR."; word-break: break-all">\\1</div>",
     
547.         "bbcodeurl('\\1', '<img src="%s" border="0" onload="if(this.width>screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.alt=\'Click here to open new window\\nCTRL+Mouse wheel to zoom in/out\';}" onmouseover="if(this.width>screen.width*0.7) {this.resized=true; this.width=screen.width*0.7; this.style.cursor=\'hand\'; this.alt=\'Click here to open new window\\nCTRL+Mouse wheel to zoom in/out\';}" onclick="if(!this.resized) {return true;} else {window.open(\'%s\');}" onmousewheel="return imgzoom(this);" alt="" />')",
     
548.         "bbcodeurl('\\3', '<img width="\\1" height="\\2" src="%s" border="0" alt="" />')"
     
549.     );
     
550. 
     
551.     return daddslashes(str_replace($searcharray, $replacearray, preg_replace($pregfind, $pregreplace, stripslashes($sign))));
     
552. }
     
553. 
     
554. function bbcodeurl($url, $tags) {
     
555.     if(!preg_match("/<.+?>/s", $url)) {
     
556.         if(!in_array(strtolower(substr($url, 0, 6)), array('http:/', 'ftp://', 'rtsp:/', 'mms://'))) {
     
557.             $url = 'http://'.$url;
     
558.         }
     
559.         return str_replace(array('submit', 'logging.php'), array('', ''), sprintf($tags, $url, addslashes($url)));
     
560.     } else {
     
561.         return '&nbsp;'.$url;
     
562.     }
     
563. }
     
564. 
     
565. function cuturl($url) {
     
566.     $length = 65;
     
567.     $urllink = "<a href="".(substr(strtolower($url), 0, 4) == 'www.' ? "http://$url" : $url).'" target="_blank">';
     
568.     if(strlen($url) > $length) {
     
569.         $url = substr($url, 0, intval($length * 0.5)).' ... '.substr($url, - intval($length * 0.3));
     
570.     }
     
571.     $urllink .= $url.'</a>';
     
572.     return $urllink;
     
573. }
     
574. 
     
575. function daddslashes($string) {
     
576.     if(is_array($string)) {
     
577.         foreach($string as $key => $val) {
     
578.             $string[$key] = daddslashes($val);
     
579.         }
     
580.     } else {
     
581.         $string = addslashes($string);
     
582.     }
     
583.     return $string;
     
584. }
     
585. 
     
586. convertForums();  //必须先运行这个转换
     
587. convertMsg($limit);
     
588. convertUser($limit); //如果出现错误，可修改username 为 binary 属性
     
589. convertAttachment($limit);
     
590. convertPosts($limit);
     
591. convertTopics($limit);
     
592. 
     
593. mysql_close($link_s);
     
594. mysql_close($link_t);
     
595. 
     
596. echo "ok\n";
     
597. 
     
598. ?>
     
599. 
     

复制代码

谢谢。。。。。。。。。。。。