|Creating importer for Cyboards [message #5539]
||Sat, 07 September 2002 16:16
I have a database with 5000+ messages. I am going to write a conversion script to Fudforum, but I need some information.|
A little history: The original database came from a WebBBS flat file database which I converted over to Cyboards, http://gold-sonata.com, with mySql backend.
I need to know what associations are needed in order to populate a fudforum database with my message database. There is no membership db, however, I do not want the posters to show up as anonymous coward or guest, so is it possible to populate the fud users table with the posters name, and if so what tables and associations would there be.
This is just a start, and if any more information is needed to answer the questions let me know.
This is a very nice forum, and I have been modifying my Cyboards script trying to get it to something like this, but I'm just a hacker and don't have as much time as I would like to. Tree views are an absolute must for my users. I plan on creating some hacks for different views (like what I have in cyboards) other than the two available.
Thanks for any help.
|Re: Creating importer for Cyboards [message #5540 is a reply to message #5539]
||Sat, 07 September 2002 16:19
To create a FUDforum user account you need to insert 3 pieces of information into the users table, for the rest default values will be assumed.|
The 3 fields that are a must are: login,alias,email.
For a 'quide' you can analyze existing conversion scripts, in particular Phorum conversion script that has the capability to make users from anonymous/unregistered posters.
FUDforum Core Developer
|Re: Creating importer for Cyboards [message #5578 is a reply to message #5539]
||Mon, 09 September 2002 20:47
Seems I may have jumped in over my head. After inspecting closer I learned that the mesage body is stored in a file rather than the database. All of my data is stored within my database. The following is the data structure:|
# Table structure for table 'board_data'
CREATE TABLE `board_data` (
`id` int(10) unsigned NOT NULL auto_increment,
`board` int(10) unsigned NOT NULL default '0',
`thread` int(10) unsigned NOT NULL default '0',
`parent` int(10) unsigned NOT NULL default '0',
`author` varchar(64) NOT NULL default '',
`email` varchar(64) NOT NULL default '',
`subject` varchar(128) NOT NULL default '',
`body` text NOT NULL,
`datestamp` timestamp(14) NOT NULL,
`ip` varchar(16) NOT NULL default '',
`host` varchar(255) NOT NULL default '',
`vipflag` varchar(255) NOT NULL default '',
`link` varchar(128) NOT NULL default '',
`linkname` varchar(128) NOT NULL default '',
`image` varchar(128) NOT NULL default '',
`locked` tinyint(4) NOT NULL default '0',
`sticky` tinyint(4) NOT NULL default '0',
`email_replies` tinyint(4) NOT NULL default '0',
`hide_email` tinyint(4) NOT NULL default '0',
`counter` mediumint(8 ) unsigned default '0',
PRIMARY KEY (`id`),
KEY `board` (`board`,`thread`,`parent`)
Following is the relationships for threads;
`id` auto_increment, Each post is assigned a uniques numeric id
`thread` determines which thread each post belongs to.
`parent` if the message is a thread starter, then the default is 0, otherwise it points to the 'id' to determine it's parent.
So, comparing the two databases; (Cyboards on left, FUDforum on right)
`id` = 'id'
`board` = I couldn't figure this one out. I've only got one board at the moment anyway.
`thread` = 'thread_id'
`parent` = 'reply_to'
`author` = 'poster_id' except these are actual user names which need to be added to the users
`email` = has to be added to the user database
`subject` = 'subject'
`body` = I'm lost here
`datestamp` timestamp(14) = 'post_stamp'
`ip` = 'ip_address'
`host` = 'host_name'
`vipflag` not a factor and does not need to be included
`link` and `linkname` as well as `image` are actually part of the subject body and show up at the bottom of the message.
The following are really not that much of a factor other than the counter which is the number of times a post was read.
`counter` where does this go?
Thing is, I was planning on just using my trusty phpmyadmin to do it all manually, then I discovered the body was not kept in the database.
I looked over the phorum2fudforum script and got lost. I can hack out bits and pieces of code with handy dandy php book, but deciphering takes me a looong time.
Perhaps it would be easier for me to ask you if you could look this over and send me an estimate of your charge to create a conversion script? I'm a member of Paypal if you use them.
Thanks for any help.