| Where to start? [message #21514] |
Thu, 02 December 2004 08:38  |
jbirch
Messages: 2
Registered: December 2004
Karma: 0
|
Junior Member |
|
|
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 14:26  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
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 14:51 |
jbirch
Messages: 2
Registered: December 2004
Karma: 0
|
Junior Member |
|
|
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
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]