Writing an importer

[MarkB]

Hi,

I am in need of an XMB -> vB importer urgently (ie, by the weekend!). I've already managed to import users by hacking the wwwthreads importer, but it won't go beyond that to also import threads and posts (attachments and buddy/pm's aren't important).

So, I've decided to try and figure it out myself - but can anyone provide some pointers? The XMB post table is laid out as so:

CREATE TABLE xmb_posts (
fid smallint(6) NOT NULL default '0',
tid smallint(6) NOT NULL default '0',
pid smallint(8) NOT NULL auto_increment,
author varchar(40) NOT NULL default '',
message text NOT NULL,
subject varchar(100) NOT NULL default '',
dateline bigint(30) NOT NULL default '0',
icon varchar(50) default NULL,
usesig varchar(15) NOT NULL default '',
useip varchar(40) NOT NULL default '',
bbcodeoff varchar(15) NOT NULL default '',
smileyoff varchar(15) NOT NULL default '',
PRIMARY KEY (pid)
) TYPE=MyISAM;

Threads as so:

CREATE TABLE xmb_threads (
tid smallint(6) NOT NULL auto_increment,
fid smallint(6) NOT NULL default '0',
subject varchar(100) NOT NULL default '',
icon varchar(75) NOT NULL default '',
lastpost varchar(30) NOT NULL default '',
views int(100) NOT NULL default '0',
replies int(100) NOT NULL default '0',
author varchar(40) NOT NULL default '',
closed varchar(15) NOT NULL default '',
topped smallint(6) NOT NULL default '0',
pollopts text NOT NULL,
PRIMARY KEY (tid)
) TYPE=MyISAM;

Any help would be greatly appreciated :stupid:

[Webdork]

Did you get this working? I would also like to upgrade / convert from XMB to VBB.