phpBB Importer Ready!

UPDATE: Please make sure to read the last posts. The beginning of the thread is kinda old, so please don't think this is how it works. Read the last posts.

----------------------------------

Hello. This is my first time posting here, so I hope I make a good first impression

Anyways...I just finished my phpBB 1.4.0 Convertor Utility, allthough I don't have an actual phpBB 1.4.0 DB to test it on. All I did was use a DB with 2 forums, one topic, and one post . Anyways, if you have phpBB 1.4.0, or any other kind of phpBB (Convert it to 1.4.0, of course ), please please help me test this.

If you find an error or some way of crashing or messing up the process, please tell me what happened. Also, if you could send me a copy of the database you are using, that would be greatly appreciated. Please don't think I'll steal your PWs, because they are MD5 encoded.

Known Bugs:

• Does not make private forums private while converting

When it is converting, all the user passwords are changed to a different md5-encoded string. I plan to change this later.

I know it isn't very user friendly. Also, please don't take any part of this code without my permission. I worked really hard on it. Thanks a bunch.

Please post anything you have to say about this below.

[Nebula]

Well, I think this script is finally done!! I have completed everything I wanted to. Please download this file and run it. It also has a feature that I have disabled in this version. Let me explain.

phpBB uses the MD5 encryption algorithm to encrypt passwords. If you know this function, you know that it cannot be decrypted. The script randomly generates the user a new password, and then will email them their new password. That is disabled, just so you don't have to, just because you are testing it, and are not seriously doing this.

If you want to remove that, just surf to Line 192, and remove the comment at the beginning of the line. And remove Line 193 completely. That will let you access the mailer function. I have not tested this, and ANY HELP WITH IT WILL BE GREATLY APPRECIATED!!

Anyways, please test this. If all goes well, I will send this to the vBulletin Developers. I think it is complete. If you think it is missing something, please PLEASE tell me!! I really want this thing to be done!! Thanks all.

Well, what are you doing?? GET DOWNLOADING!!!!!

Hi,
Your work on the import of the phpBB is very nice ;-)
and i love it !

I try your last version, but i have some problems... (20 forums, 200 users, 1100 posts)
- In the table forum, all the fields replycount lastpost lastposter threadcount allowposting have the value ZERO ! and of course, i see the value 0 in my browser for all this relatives fields.
- When i want to open a topic for read posts, i can see posts, but i have a warning for every posts in a topic (Warning: unexpected error in date() in C:\InetPub\wwwroot\vbulletin-fr\upload\admin\functions.php on line 1209).
(I make all my tests of importation on a new fresh and correct install of VB 2.0.1)

I think the importation of style is not very important, because it is very difficult to have a good importation from phpBB to VB. I have skip this code and my importation is ok (style does not change). I prefere a good import of posts, PM, topics, category...

Have a nice day and sorry for my english
JY

[Nebula]

I just looked at my code, and I cannot find the problemwith the allowposting equalling 0. However, all the others should be null. Did you:

• Download the newest version? (The one right before your post is the newest one)
• Complete the final step (Including updating all the counters)?

As for the dates...that has been fixed. There was a problem with them, and it was fixed in the version above your post. It is very important to update all the counters in the order specified. You must update Users, then Threads, and then Forums, and then Rebuild the Search Index.

The reason you need to update all the counters is that none of the lastpost/lastpostuserid/etc... is inserted is because vBulletin's BBimport system feels you shouldn't. They only import the necessary data. The other code would take additional queries, and I wanted this to run as clean as possible. Also, when you finish an import, you should ALWAYS update your counters and rebuild your search index anyways, so having the script import the lastpost stuff is almost completely pointless (That's my Humble Opinion...).

Anyways...try my newest version if you haven't. If you were using the newest version that I released last night...well...hmm. I guess you should send me your phpBB database, and I'll run the script on it, and I'll see what's wrong.

Thank you for helping to test my script!!

Nice !!! all is fine (style also !!)
My mistake was that i don't rebuilt index for counter...i think that it was automatic...i am stupid
This is a great utility for all proprietary of phpBB forum.

My phpBB forum is here

Now, with your help and your scrip, i hope to switch in VB in the next week.

Thank you very much for your help and your support !

[Nebula]

Hey...No problem. Helping people is what I like to do.

I'm gonna wait for a few more people to test this, and then I'm gonna take out all the development stuff, maybe comment it, and then sent it to the vBulletin Dev Team. Hopefully, they will like it

Thanks for your support. If you have phpBB, and haven't started testing the final version, please do.

[Juan]

I have tested the latest version several times.

The import went very well, no errors. After the import, some membernames were duplicated, reports the same number of threads and posts in every forum and the dates are all wrong "Year 2036"

Posts have been assigned to membernames which are different from the people who actually posted them.

Here is the sample:

http://www.christopherleeweb.com/for...?s=&forumid=36

And the titles of the threads are different from what is being discussed.

[Nebula]

::sigh::

Well, I guess I have some more work to do.

Juan, could you please send me a copy of your phpBB database? Email it to Nebula_DJ@SoftHome.net. Anyways, I'm sorry about that. I have no clue what is wrong. Before you send me the database, could you try running the conversion one more time? And also, make sure you are running the newest version.

If the convertor still doesn't work, and you are using the newest version, send me your database. I'll find out what's wrong.

Thanks.

[Juan]

I've e-mailed you the database. I hope there is something wrong with it and not the script.

[Nebula]

Well, the dump you sent me has all the forums labled 1, 2, 3, etc...

I've looked at the results...and the dump you gave me is converting it exactly what it is being given.

Anyways, I think this is an error on your forums, and rather not mine. I don't know why the forums are labled 1, 2, and 3, and so on.

Anyways, I don't think this is a problem with my script. If you want to send me a newer dump, you can.

For everyone else, keep testing.

P.S. Juan, please let me know what you think...

[Juan]

Nebula, it could be a problem with my phpBB database as you stated. I've moved from IB, guess I need to make sure everything is bug free at phpBB before importing.

The forums are labelled 1,2, 3, 4, etc because it would be easier for me to merge the posts in the appropiate forum afterwards.