UBB 6.x to YabbSE??

[Bjorn]

Hi!

I've been searching the forums, but have not yet found an answer for this.. I'd really like to check out the YaBBSE, but I'd really like to be able to transfer my members and posts also... Anyone??

[Jeff Lewis]

I've got a member converter but no posts converter.

[groundup]

if jeff would only send it to me i would try something for it.  I dont have ubb so if someone could work work with me on it that would be great

[Bjorn]

It'd be great if you guys would make this converter, I'd really appreciate it! Unfortunately, I don't have any scripting experience, so I really don't know if I'd be any help..  

[Bjorn]

I have taken a quick look on the files in use by the forum. I hope this description of the structure can be at any help along the way:

The member files are placed in a separate directory, usually called Members. The file names are as follow:
00000034.cgi, which corresponds to the member number.

The structure within the members files are as follow:

login          //1: user (login) name
password       //2: Password
[email protected]   //3: Registered emaila ddress
http://homepage.com   //4: Homepage
AdminWrite&      //5: Board rights (adminm=admin, write=write, read=read, write&1,2=write permissions in forums 1 and 2, where forum 1 and to are forums with posting restrictions)
Occupation   //6: Occupation
Hometown         //7: City
143         //8: Number of posts
Administrator      //9: Status (administrator, moderator, member, junior member, unregistered)
Interests   //10: Interests
06-09-2001      //11: Date of registration (mmddyyyy)
yes         //12: Show email address in profile
signature      //13: Signature
ICQ ID         //14: ICQ
yes         //15: Allow admins and moderators to send you emails?
Display name      //16: Display name
Custom         //17: Custom field
         //18: Custom Field
         //19:
         //20:
http://picture.com   //21: Picture address
45         //22: Show topics from the last xx days

Display name|^|00000001|^|02-04-2002      //24: Profile last modified by:Display name|^|Member number|^|Date (mmddyyyy)
yes         //25: Lock this profile? (administrator toggle)
yes         //26: Show user ranking

yes         //28: Allow private messages
yes         //29: Email notification on private messages
yes         //30: Ability to send private messages (administrator toggle)
20020327|1|000042|000051|213.187.175.99      //31: Last post date|Forum number|Thread number|post number|IP-address

19800131|yes      //33: Date of birth (yyyymmdd) | Allow users to see birth date? (in case no date given: "Wasnt a valid date: a, a, a"
123.123.12.123      //34: Registered IP-address
0         //35:?

The /Members/pm_buddy/ contains information about buddies, which are users to show up in your list of recipients for quick selection when sending private messages. The filenames are identical to /Members/, e.g. 00000001.cgi. The structure within the files are as follow:

%pm_buddy = (
   '00000002' => 'Display name user 2',
   '00000003' => 'Display name user 3',
   '00000034' => 'Display name user 4'
);

1;

You also have /Members/pm_ignore/ which follows the same structure.

Within the Members/pm_info/ there are two tiles, pm_counter.cgi (which contains only the number 1), and pm_last_number.cgi (which contains another number, probably the total pm's at the board, e.g. 52).

The /Members/pm_topics/ contains directories names from A to Z. Within each of these subdirectories there are files named by a number and a .cgi extension, e.g. 00000046.cgi. This number is probably the corresponding number of the private message. The structure within the file is as follow:

%pm_topic_data = (
   'subject' => 'Teller',
   'to' => '00000002',
   'from' => '00000001',
   'replies' => 4,
   'close' => '',
   'deleted_00000001' => 1,
   'read' => 'yes',
   'read_00000001' => 'no',
   'read_00000002' => 'yes'
);
%pm_date = (
   '0' => '03-16-2002',
   1 => '03-17-2002',
   2 => '03-17-2002',
   3 => '03-17-2002',
   4 => '03-17-2002'
);
%pm_time = (
   '0' => '07:50 PM',
   1 => '06:46 PM',
   2 => '06:53 PM',
   3 => '11:03 PM',
   4 => '11:19 PM'
);
%pm_post = (
   '0' => 'Message from sender1 to receiver2',
   1 => 'Reply from receiver2 to sender1',
   2 => 'Reply from sender1 to receiver2',
   3 => 'Reply from receiver2 to sender1',
   4 => 'Reply from sender1 to receiver2'
);
%pm_to = (
   '0' => '00000002',
   1 => '00000001',
   2 => '00000002',
   3 => '00000001',
   4 => '00000002'
);
%pm_from = (
   '0' => '00000001',
   1 => '00000002',
   2 => '00000001',
   3 => '00000002',
   4 => '00000001'
);
%pm_icon = (
   '0' => 1,
   1 => 1,
   2 => 1,
   3 => 1,
   4 => 1
);
%pm_signature = (
   '0' => 'yes',
   1 => 'yes',
   2 => 'yes',
   3 => undef,
   4 => 'yes'
);

1;

The directory /Members/pm_users/ contains files named equal to the ones in the Members directory. They contains information on what PM's to show up in the user's inbox/outbox:

%pm_user_index = (
"J-00000045" => "2452350.2003",
"C-00000047" => "2452350.2048",
"K-00000048" => "2452351.2131",
"C-00000049" => "2452353.1417",
"S-00000050" => "2452356.1811",
"K-00000052" => "2452363.1151",
);
%pm_user_index_sent = (
"H-00000033" => "2452337.1754",
"B-00000051" => "2452363.0942",
"Q-00000026" => "2452310.2107",
);
1;

(pm_user_index_sent=outbox)

The /Members/user_posts/ directory have files named euqlly to the ones in /Members, These files contains information about which posts the user has been posting:

20020228|1|000034|000022|123.123.123.123
20020228|1|000034|000023|123.123.123.123
20020301|1|000039|000002|123.123.123.123

(date|forum number|thread number|post number|ip address).

/Members/user_raters/ contains information about how each user has rated others. File names are equal to /Members. Structure within files as follow:

%user = (
   '00000002' => 5,
   '00000003' => 5,
   '00000005' => 5,
   '00000024' => 5,
   '00000034' => 5
);

1;

/Members/user_ratings/ contains files which holds information on what ratings each user has gotten. File names are equal to /Members/. Structure:

%votes = (
"0" => "1",
"1" => "0",
"2" => "0",
"3" => "0",
"4" => "0",
"total" => "4",
"5" => "3",
);

%totals = (
"0" => "5",
"1" => "0",
"2" => "0",
"3" => "0",
"4" => "0",
"total" => "17",
"5" => "12",
);

%avg = (
"0" => "5",
"1" => "N/A",
"2" => "N/A",
"3" => "N/A",
"4" => "N/A",
"total" => "4.25",
"5" => "4.00",
);

%weighted_avg = (
"0" => "0.75",
"1" => "0.25",
"2" => "0.40",
"3" => "0.60",
"4" => "1.25",
"total" => "4.65",
"5" => "1.40",
);
1;

This user has gotten four votes, three votes at five points and one vote at 0 points.

Now, within the /Members/-directory I have not mentioned the following subdirectories: pm_sent and user_groups. This is simply because I don't know anything about these directories..

I'll be right back with a structure on the postings..

[Bjorn]

The postings are stored in subdirectories within the noncgi-directory. These subdirectories are named Forum1, Forum2, etc., e.g. /noncgi/Forum1/.

The file structure are as follow:
Several different files, a whole bunch is named sometning like xxxxxx.cgi, where x is a number. E.g.: 000003.cgi. The number is equal to the thread number it holds information about. The structure of these files are quoted below. Note: There are places in this quote where I've had to replace my explanation with question marks. That's simply because I can't figure out what the content represent.

A||||1||johndoe||How are we doing today??||||5||||Mr. John||00000001 //This is the subject line.
Z||000000||bok2||11-05-2001||07:36 AM||[email protected]||The post itself||123.123.123.123||reg||5||Mr. John||00000001||yes //This is the first posting in the thread.
Z||000001||sarahlewis||11-05-2001||07:21 PM||[email protected]||The post itself||123.456.789.012||reg||1||Mrs. Sarah Lewis||00000002|| // This is the first reply in the thread.


Structure:
A||||replies||(topic starter) Member login name||Topic subject||||??||||(Topic starter) Member display name||(Topic starter) Member number
Z||post number||member login name||date (mm-dd-yyyy)||time||email||text...||IP-address||reg or unreg||??||member dsplay name||member number||??

If the user is unregistered, then the member login name and member display name will be replaced by &ltusername&gt
where username is the name given by the unregistered user.

The forum_thread_data_0000.cgi stores information on how to display the forum threads in thread view. It contains the following:

Structure:

$forum_thread_data{"1"}->{"0000"} = {
'Thread number' => [q~A~, q~~, q~Topic starter login name~, q~Topic subject~,
      q~?~, q~replies~, q~Topic started date~, q~topic started time~,
      q~2452349.1023~, q~topic starter display name~, q~topic starter member number~, q~Last reply user login name~,
      q~last reply date~, q~Last reply timeM~, q~2452362.1637~, q~Las reply user display name~,
      q~last reply member number~, q~1~, q~~, ],


Example:

   '42' => [q~A~, q~~, q~johndoe~, q~My subject line~,
      q~8~, q~52~, q~11-30-2001~, q~12:00 PM~,
      q~2452349.1023~, q~Mr. John~, q~00000026~, q~Eva~,
      q~12-30-2001~, q~10:15 AM~, q~2452362.1637~, q~Eva Noname~,
      q~00000034~, q~1~, q~~, ],
   
};
1;

Time format: 12:00 PM
Date format: mm-dd-yyyy
If the topic is started by, or if the last post is by an unregistered member, the login and display name are replased by &ltusername&gt
where username is the name given by the unregistered user.

The  lastnumber.file contains information about the forum to be displayed on the forum front page. It contains the following:

000043            //Last topic number
40            //Total topics
679            //Total posts
Subject            //Last active topic subject
Member display name      //Last posting member
1            //Forum number
000042            //Last active topic number

lasttime.file contains the following information:

03-28-2002
04:37 PM

forum_1.threads contains the following:

%forum_topics = (
   '000010' => '2452225.1300',
   '000020' => '2452215.1646',
   '000011' => '2452119.0141',
   '000021' => '2452241.1616',
   '000003' => '2452136.2258',
   '000030' => '2452285.1816',
   '000022' => '2452221.2301',
   '000004' => '2452070.2318',
   '000040' => '2452342.2123',
   '000013' => '2452202.2131',
   '000031' => '2452277.1713',
   '000023' => '2452291.1732',
   '000005' => '2452063.0059',
   '000041' => '2452347.2105',
   '000014' => '2452213.2233',
   '000032' => '2452282.0808',
   '000024' => '2452219.1921',
   '000006' => '2452125.1533',
   '000042' => '2452362.1637',
   '000015' => '2452177.1554',
   '000033' => '2452291.1712',
   '000025' => '2452313.0207',
   '000007' => '2452131.0215',
   '000043' => '2452361.2340',
   '000016' => '2452199.1917',
   '000034' => '2452336.1805',
   '000026' => '2452296.2150',
   '000008' => '2452217.1826',
   '000017' => '2452241.1705',
   '000035' => '2452297.2243',
   '000027' => '2452237.1018',
   '000009' => '2452124.0125',
   '000018' => '2452199.1133',
   '000036' => '2452313.1156',
   '000028' => '2452247.1411',
   '000019' => '2452199.1048',
   '000037' => '2452330.1433',
   '000029' => '2452313.0034',
   '000038' => '2452330.2356',
   '000039' => '2452354.2242'
);

1;

I'm not quite sure what this really is. It seems that the number before => is the corresponding thread number. The values after the period on the right seem to be time stamps in european format. I have, however, no clue what the numbers inbetween are. Unix time maybe?

OK. I've been quoting quite a bit of data structure here. This is taken from the new UBB 6.2, which I'm not interested in using because of the high registration and subscription fees. I hope this is enough to get you guys going on the converter bit. I'd do it myself if I was a well trained programmer, but as for now I'm only a beginner.

Cheers!

[Bjorn]

Anybody working on this?

[jmet]

Im running the latest version of UBB classic 6.x and have installed yabbse.

I would like to convert my users and posts over to yabbse so if I can in anyway help you guys out like giving access to my files etc. please let me know.

[Gunslinger]

Well, its easy. Go there
http://www.yabbforum.com/community/?board=y1mod;action=display;num=1024255075;start=0

Ive wrote a perl script wich converts members and threads from ubb 6x to yabb. You need to install yabb, convert all you want and after it install yabbSE and use its own converter from yabb2yabbse.

[jmet]

Forigve me because im new to this.

I have allready installed YabbSE and its all up and running.

Say I install yabb in another folder as a seperate forum then convert all my UBB info over..

THEN could i bring it all over to my allready installed yabbSE from yabb?

[Gunslinger]

Say I install yabb in another folder as a seperate forum then convert all my UBB info over..

THEN could i bring it all over to my allready installed yabbSE from yabb?

Yes, but you have to convert it to clear forum (in other case you must manually edit files in Boards folder with subjects and total threads number) and threads numbers must be different and the only way to control it is the manual view after converting (because numbers are random).