| Re: Creating importer for Cyboards [message #5578 is a reply to message #5539] |
Tue, 10 September 2002 00:47   |
 |
Fishtails
Messages: 4
Registered: September 2002
Karma:
|
Junior Member |
|
|
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`)
) TYPE=MyISAM;
# --------------------------------------------------------
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.
`locked`
`sticky`
`email_replies`
`hide_email`
`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.
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]