如何将dvbbs的短消息导入到discuz

由于官方提供的程序不可用，或者报错导致中止，
所以我现在是自己用asp.net写程序，将数据转移到discuz的数据库中。

用户数据和主题数据都转换好了，用户之间的短消息数据转换有点麻烦。
谁对官方3.1的程序比较熟悉，要如何将数据写到数据库？
我自己不懂php

用官方的程序转换一下DV短消息这步到DZ就可以了

1. 
   
2.     public void SaveMessage(string FromUserName,int FromUID, int ToUID, string Title,string Message, DateTime sendtime) {
   
3.         Title = Data.Filter(Title);
   
4.         Message = Data.Filter(Message);
   
5.         FromUserName = Data.Filter(FromUserName);
   
6.         string value = ToUID.ToString()+"_"+FromUID.ToString();
   
7.         long basetime=Discuz.MyMath.GetPhpTime(sendtime);
   
8.         string LastMessage="a:3:{s:12:"lastauthorid";s:1:""+FromUID.ToString()+"";s:10:"lastauthor";s:15:""+FromUserName+"";s:11:"lastsummary";s:"+(Title.Length+10).ToString()+":""+Message+"";}";
   
9.         int Plid=0;
   
10. 
    
11.         Data.MySqlDataVisit mysql=new Data.MySqlDataVisit("Discuz");
    
12.         if (Plid == 0)
    
13.         {
    
14.             mysql.Sql = "INSERT INTO pre_ucenter_pm_lists(authorid, pmtype, subject, members, min_max, dateline, lastmessage) VALUES('" + FromUID.ToString() + "', '1', '" + Title + "', 2, '" + value + "', '" + basetime + "', '" + LastMessage + "')";
    
15.             mysql.Execute();
    
16. 
    
17.             mysql.Sql = "Select max(Plid) from pre_ucenter_pm_lists";
    
18.             Plid = mysql.SelectFirstInt();
    
19. 
    
20.             mysql.Sql = "INSERT INTO pre_ucenter_pm_indexes(plid) VALUES('" + Plid.ToString() + "')";
    
21.             mysql.Execute();
    
22. 
    
23.             mysql.Sql = "Select max(Pmid) from pre_ucenter_pm_indexes";
    
24.             int Pmid = mysql.SelectFirstInt();
    
25. 
    
26.             mysql.Sql = "INSERT INTO " + getposttablename(Plid) + "(pmid, plid, authorid, message, dateline, delstatus) VALUES('" + Pmid.ToString() + "', '" + Plid.ToString() + "', '" + FromUID.ToString() + "', '" + Message + "', '" + basetime.ToString() + "', 0)";
    
27.             mysql.Execute();
    
28.             mysql.Sql = "INSERT INTO pre_ucenter_pm_members(plid, uid, isnew, pmnum, lastupdate, lastdateline) VALUES('" + Plid.ToString() + "', '" + ToUID.ToString() + "', '1', '1', '0', '" + basetime.ToString() + "')";
    
29.             mysql.Execute();
    
30.             mysql.Sql = "INSERT INTO pre_ucenter_pm_members(plid, uid, isnew, pmnum, lastupdate, lastdateline) VALUES('" + Plid.ToString() + "', '" + FromUID.ToString() + "', '0', '1', '" + basetime.ToString() + "', '" + basetime.ToString() + "')";
    
31.             mysql.Execute();
    
32.         }
    
33.         else
    
34.         {
    
35.             mysql.Sql = "INSERT INTO pre_ucenter_pm_indexes(plid) VALUES('" + Plid.ToString() + "')";
    
36.             mysql.Execute();
    
37.             mysql.Sql = "Select max(Pmid) from pre_ucenter_pm_indexes";
    
38.             int Pmid = mysql.SelectFirstInt();
    
39.             mysql.Sql = "INSERT INTO pre_ucenter_"+getposttablename(Plid)+"(pmid, plid, authorid, message, dateline, delstatus) VALUES('" + Pmid.ToString() + "', '" + Plid.ToString() + "', '" + FromUID.ToString() + "', '" + Message + "', '" + basetime.ToString() + "', 0)";
    
40.                         mysql.Execute();               
    
41.             mysql.Sql = "INSERT INTO pre_ucenter_pm_members(plid, uid, isnew, pmnum, lastupdate, lastdateline) VALUES('" + Plid.ToString() + "', '"+ToUID.ToString()+"', '1', '1', '0', '" + basetime.ToString() + "')";
    
42.                         mysql.Execute();
    
43.             if(!mysql.IsHaveErrorPrivate) {
    
44.                             mysql.Sql = "UPDATE pre_ucenter_pm_members SET isnew=1, pmnum=pmnum+1, lastdateline='" + basetime.ToString() + "' WHERE plid='" + Plid.ToString() + "' AND uid='"+ToUID.ToString()+"'";
    
45.                             mysql.Execute();
    
46.             }
    
47.                         mysql.Sql = "INSERT INTO pre_ucenter_pm_members(plid, uid, isnew, pmnum, lastupdate, lastdateline) VALUES('" + Plid.ToString() + "', '" + FromUID.ToString() + "', '0', '1', '" + basetime.ToString() + "', '" + basetime.ToString() + "')";
    
48.                         mysql.Execute();               
    
49.             if(!!mysql.IsHaveErrorPrivate) {
    
50.                                 mysql.Sql = "UPDATE pre_ucenter_pm_members SET isnew=0, pmnum=pmnum+1, lastupdate='" + basetime.ToString() + "', lastdateline='" + basetime.ToString() + "' WHERE plid='" + Plid.ToString() + "' AND uid='" + FromUID.ToString() + "'";
    
51.                 mysql.Execute();               
    
52.             }
    
53. 
    
54.                         mysql.Sql = "UPDATE pre_ucenter_pm_lists SET lastmessage='"+LastMessage+"' WHERE plid='" + Plid.ToString() + "'";
    
55.             mysql.Execute();               
    
56.         }
    
57.     }
    
58. 
    
59.     public string getposttablename(int id)
    
60.     {
    
61.         string str = id.ToString();
    
62.         string tableid = str.Substring(str.Length-1, 1);
    
63.         return "pre_ucenter_pm_messages_" + tableid;
    
64.     }

复制代码

自己动手转换了一下
可以看到别人给自己发的消息了，但是别人发给我的消息看不到
我估计是：

1. string LastMessage="a:3:{s:12:"lastauthorid";s:1:""+FromUID.ToString()+"";s:10:"lastauthor";s:15:""+FromUserName+"";s:11:"lastsummary";s:"+(Title.Length+10).ToString()+":""+Message+"";}";

复制代码

这里模拟

1. $lastmessage = array('lastauthorid' => $fromuid, 'lastauthor' => $fromusername, 'lastsummary' => $lastsummary);

复制代码

出错了

dvbbs可以转化的