FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Converters » Creating importer for Cyboards
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Creating importer for Cyboards [message #5539] Sat, 07 September 2002 20:16 Go to next message
Fishtails is currently offline  Fishtails   United States
Messages: 4
Registered: September 2002
Karma: 0
Junior Member
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 20:19 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
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
One more question. [message #5545 is a reply to message #5539] Sun, 08 September 2002 11:57 Go to previous messageGo to next message
Fishtails is currently offline  Fishtails   United States
Messages: 4
Registered: September 2002
Karma: 0
Junior Member
Great idea, thanks! I'll check out the phorum conversion script. As a matter of fact, when I converted my WebBBS over to cyboards I used a webbbs to phorum converter which I modified for my purposes.

Thanks again. Razz
Re: Creating importer for Cyboards [message #5578 is a reply to message #5539] Tue, 10 September 2002 00:47 Go to previous messageGo to next message
Fishtails is currently offline  Fishtails   United States
Messages: 4
Registered: September 2002
Karma: 0
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. Rolling Eyes 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.

Re: Creating importer for Cyboards [message #5580 is a reply to message #5578] Tue, 10 September 2002 02:22 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Send me the MySQL table defenitions from your existing forum and if possible show me a URL so I could see how the data gets displayed via a private message and I'll give you a quote.

FUDforum Core Developer
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: can not post :(
Next Topic: WBB 1.1.1 to FUD Forum
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 07 15:23:16 GMT 2024

Total time taken to generate the page: 0.03112 seconds