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

Home » FUDforum Development » Converters » Where to start?
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Where to start? [message #21514] Thu, 02 December 2004 03:38 Go to next message
jbirch is currently offline  jbirch   Canada
Messages: 2
Registered: December 2004
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Hi,

I have a really old version of Phorum running (when I say really old, I mean like version 1.5 or 1.6). It has a super-simple single table database structure.

CREATE TABLE bnf_discussions (
   id int(11) NOT NULL auto_increment,
   name varchar(30),
   email varchar(100),
   topic varchar(50),
   body blob,
   host varchar(50),
   thread int(11) DEFAULT '0' NOT NULL,
   datestamp datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   parent int(11) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id),
   KEY datestamp (datestamp),
   KEY thread (thread)
);


Id is internal unique identifier
Name is user's name
Email is user's email
Topic is post title
Body is content of post
Host is contents of the http REMOTE_HOST header
Thread is equal to the Id of the first post in a given thread
Datestamp is time post was written to DB
Parent is Id of previous post in thread

I have four of these forums, each with its own table (identical structure).

Is there a good fit for this situation from the existing converters; a good starting point for me? I want to import my historical data into individual Fud forums and then turn off new posts and replies to these imported forums.

Thanks,
Jason
Re: Where to start? [message #21520 is a reply to message #21514] Thu, 02 December 2004 09:26 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
add to buddy list
ignore all messages by this user
Since you have phorum, the best starting point would be the existing phorum conversion script that you'd need to tune for your special needs.

FUDforum Core Developer
Re: Where to start? [message #21525 is a reply to message #21520] Thu, 02 December 2004 09:51 Go to previous message
jbirch is currently offline  jbirch   Canada
Messages: 2
Registered: December 2004
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I initially had a quick look a the existing Phorum conversion script, but it doesn't appear to be a close match to my needs as it imported the forum settings from a Phorum setup file that I did not have in my version.

The structure of the version of Phorum that I have is considerably different than the version that the existing conversion script targets. Phorum was totally re-rewitten between 1.x and 3.x (they skipped 2.x) and there is little resemblance between the two as far as the forum configuration file, table structure, etc.

I'll take another look at the script though; maybe I can strip out what I need.

Thanks,
Jason
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Netbula Anyboard - anyone played with it?
Next Topic: Yahoo Groups -> mbox -> maillist.php -> missing posts
Goto Forum:
  

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

Current Time: Fri Oct 20 17:47:32 EDT 2017

Total time taken to generate the page: 0.00664 seconds