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

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 !!) :D :D :D
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 !
:p :p

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.

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.

::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.

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

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...

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.

Well...check it out. I'm glad it isn't something wrong with my script. Not that I'm happy that it is your problem...just...you know ;)

Also, you guys, keep testing. I really need feedback.

Well, since nobody is replying to this, I guess I'm just gonna send this to Jelsoft. If anyone finds any problems with it, please contact me immediately.

I have email notification enabled, so just reply here. Thanks.

Hi Nebula ;)
Some remarks before you send your actual release:
- When you import style, add "phpBB_" for example before the name of the phpBB style, because phpBB and VB have the same name "default" for the default style, and after import we have 2 default style and it is difficult to know who is the phpBB an VB style;
- I have choose to conserve the password of the phpBB user: when i make importation, i put the old (phpBB) psw in the VB user base. In VB, i have change the lines where the psw is checked with the same method than phpBB (md5 function); for the Email psw, i must send a random psw, but it is not ready for this moment. With this modification, i can switch from phpBB to VB in 1 or 2 hours max, without any disagrement for users: it is transparent !
- I am not sure at 100% that your script is ok (i hope that it is ok!), but i have some problems like Juan, but for my test of importation, i work on a not very clean base of phpBB...(i have just a difference of 1 between posts and posts_text tables. And the result of the importation give me some stranges mixtes with bad name for posters and also, more strange, i have found privates messages in publics posts... and i am not sure that is only due to the fact that i use a not clean phpBB base... I am writing a litle script for import my real phpBB base from the web to my personnal server without changes or omissions. When this step will be finish, i will say: YES your script is OK or NO...somethings is wrong. That is the raison why i said nothing since some days, i wait to be sure before speaking...
That all for today, and your work is very nice !

I send you more informations when i have
(If you want my real clean base, it is 1,2Mo size...i can post it)
Bye :)

Well Juan...you have some good ideas.

• On the Styles, that is a very good idea. I'll go add it now.
• Hmm, your Password idea is interesting. I'll go make it an option.
• When you say my script isn't quite ready to be released, please tell me more of what you mean. Also, please send me a copy of your not very clean database. I want to see what's wrong with this. Also, is it really my convertor's fault if you have a bad database ;) As for PMs showing up in posts, that's just plain whacked. I really want to find out about that. Also, what do you mean by:
  Quote:

  I am writing a litle script for import my real phpBB base from the web to my personnal server without changes or omissions.

Anyways, please let me know ASAP. I really want to get this thing done...my vBulletin license expires 1 month from now, and I want to get it renewed by hopefully completing this script (JelSoft might give me a new license because I made this for them ;)).

Thanks. Please send me your not clean database in the email. My email address is: Nebula_DJ@SoftHome.net. Talk to you later.

----- The following recipients were processed by MTA adansonia.wanadoo.fr...

Nebula_DJ@SoftHome.net; Action: Failed; Status: 5.1.7 (bad sender's mailbox address syntax)

---- Message SMTP Diagnostic: 553 IP address 193.252.19.224 is an open mail relay or part of a multistage open relay - See http://www.orbl.org

Well...I have no clue whatsoever what that means, but I got the email all right :p

I'll let you know how it goes...

Hey. I would have posted this way sooner then this, but for some reason, I couldn't access vBulletin.com at all. Just last night, all I could access just the main page.

Anyways, here's the new verison. It includes style prefixes, and an option to insert the MD5 encrypted password, or generate a new one. Also, if you choose not to generate a new password for the users, it will not attempt to mail the users their new passwords. Those are the things I need tested.

Well, please get testing. Also, jyr, please tell me more of what you mean. As for a database that has one more entry in posts then in posts_text, I tested that, and found that it just omits the last post. And for private messages showing up as public posts, that would have to be a problem with the database, or vBulletin, but not the convertor script. It's literally impossible for it to take a PM, and put it in a public post. Anyways, correct me if I'm wrong.

I really need some help testing this script you guys. I don't want to send a bad version to JelSoft...

Come on you guys. I've got lots of testers in the past. The only person that is testing this is myself (I think). I'm the only one posting here. If nobody posts in one day, I'll send it to JelSoft.

Oh yea, I made some little changes, so please, please, please test this. This will be sent tomorrow if nobody replies.

I have testing your preceding release (not the last just above) and i send you by email my results.

This a copy a my mail:
I don't knows if you have receive my email (no answer and sending error...) and if you have make some important change on the problem of the mixte between posts/posters/topics but if you have not, you can't send this release to Jelsoft...
I can't test your last release today, but tomorow it is ok. I think that is't a big bug, and if you fix it, all is perfect ! :D :D
I post my test result on your last release tomorow evening.
Have a nice day ;)

Here's yet another update.

Thanks for letting me know about the post username problem. I feel really stupid about this one. The script was using the users's old userID. It's changed so now it uses the new ones.

A List of what I've fixed/added in this release (Not much):

• BUG FIX: userIDs in posts
• NEW: Redirect code in some steps (used so you do not have to scroll down to the bottom of the page, it loads a new one with the step on it)

I was talking to JohnM about this. He said something about numeric arrays, and threads in the wrong forum. I am talking to him about this now, so I'll get it worked out.

Anyways, There isn't much to test in this version, only one thing was changed (the bug listed above). Test this new version, but there isn't much new stuff to test.

JYR, I did get your email, but I have been quite busy planning for my family's vacation in 6 days.

Send me any suggestions/problems right here. Thanks. Keep testing too.

Hi Nebula ;)
Your last release posted today is near perfect !!
All posts have a good name for the messsage now :cool:

But i found 2 big bug :(
- In the main page of VB of my imported phpBB, where i can see all the forums and categorys, the number in the column posts and threads have the same value in every forum (raw). The number of threads is OK, and of course, the number of posts is NOT OK. And the value of the Last Post is always set to Never...
See my exemple: - When i open a forum, the names and numbers of threads is OK, but the Thread Starter name is NOT OK. If i open a thread, i read the contents of an another thread...with the good poster name. I saw the VB table Thread, and i observe than between title and postusername you have an offset of 1 again...see the begining of the table thread for my exemple:
In reality (in phpBB forum), we have:
The line 1 is OK;
The line 2 is not posted by Root, but by neodidier...
The line 3 is not posted by neodidier, but by upag38...
And so on...


Some litle bug not very criticals:
- I have in my phpBB an Administrator access only forum, and when i make importation, everybody can access to this forum...
- In privates messages, i see my receives messages, it is OK, but in sending message, i have always the value 0...and it is not the true;
- Categories are not imported at all...
- An suggestion: Add in your 1st line of your code the number for the release like this:Well, I hope that my post can help you to produce the final version of phpBB_Import, you are so near to the true :D :D :D
Very good work :cool: :cool: :cool:
JYR

Hey. Thanks much for all your help JYR. I will work on this tomorrow. I'll fix just about everything here, because I see what's wrong. I'll give a new version tomorrow.

TTYL!

Well...here's what I think:

• The problem with the thread and post counters being the same on the main page is not a bug. Did you remember to update counters?? ;) That's the only thing I can think of.
• Thread Starter Name: FIXED! Thanks, I can't believe I missed that :P
• Admin forums - I'm working on it. I've been pulling my hair out for the last hour. If anyone looks into my code and sees anything wrong with this part, please tell me. That way, I won't go completely bald ;)
• Private Messages - I don't really know what you are talking about :(
• Categories - They aren't supposed to be imported. It gets way too confusing doing that. Maybe I'll work on it once everything else is done ;)
• phpBBconv Version Identifier - Might confuse some users. If I do use that, I'll move it away from the phpBB Version number, or make it clear that this number means nothing to phpBB ;)

Oh well...Reply back as soon as you can. Thanks!

:p
It isn't that hard to do categories... put them in as forums, store the new forumid in an array, and use that to find the parentID.

Geez...you make it sound easy.

If you want to know the real reason, I want to finish everything important. Then I'll work on the lesser features. :-P

Hello,

I really would like to try your hack, but is there a way to connect to phpBB database with same username as databasename ?
I tried to change all $iuser to $idbname but that doesnt works ;-\

Between, many thanx for that addon Nebula, i was just waiting something like that to buy vbulletin ;-)

First of all ced...it isn't really a hack. I just put it in this forum, because I wasn't sure where to put it.

Also, I'm not sure what you mean about usernames and databases. Currently, the phpBB Database and the vBulletin database must belong to the same username. Otherwise, it doesn't work. I may change this later, but it would probably go slower...so just put them with the same username ;)

Well, i have 2 tables on same server....

I would like to convert phpBB from table2 (username for table2 is table2) to table1 where i installed vbulletin (with username table1)....

Then when i launch the converter, i receive an error message that say i cannot connect tables2 with username table 1 ;-)

uhm...yea. That's the problem. The username needs to work for both. Otherwise...it won't work.

Hi Nebula and Ced,
Nebula:
I want to say that in my phpBB forum, I have send and receive a lot of privates messages. And after the import in VB, i see only my receive message with a certainly good number of mes, but the number of sending mes is zero and of course i can't see my sending messages :(

Ced:
I have the same problem, because with free servers you have "always" only one database. If you want to import from phpBB to VB with only one db, you stop the phpBB forum, you rename the table ACCESS and SESSION with anything like *OLD, and you can start a new installation of VB (admin/install.php) with fresh tables and after, run the importation from phpBB.

That all ;)

Geez...I feel really bad saying this, but I still don't understand what the problem is with the Private Messages. Try and make it the best english you can. I just can't make out any of what you are saying. I'm American, and speak english. I don't really know any other languages other then some french.

Again, I feel really bad (and embarrised) that I cannot read your bug report. If anyone can give me a hand, it would be greatly appreciated.

Also, no offense to you JYR of course.

Ok, sorry for my poor english...:(

I try again to explain the problem of privates messages:
In my phpBB forum, i have sent and received a lot of privates messages, mais be 50 sent, and 20 received.
When i import my phpBB forum whith your script in a new and empty VB forum, i see in my control panel that i have 20 privates messages in my INBOX folder, this is ok. But in my folder SENT ITEMS, i have no messges, it is empty: the script has lose all my previous sending privates messages. I hope this explanation is more clear than the previous...

Now, I always update all counters when i make an importation, and i have always the same number of post and thread on the main page. I think you can fix something in your code. You have my phpBB database, it is simple to try it and look if you have the same result like me on this point.
Have a nice day ;)

I will get working on the private messages thing. It will take twice as much queries, but I'll do it. I'll make it an option ;)

as for the counters...gah. I'll look into this.

I'm going on vacation for 4 days...leaving tomorrow morning...so you may not have an update for some time...

I'll try and get it out 2nite

::goes off to work on phpBBconv::

Yes ! Your converter is awsum Nebula !!!

There are just few things i don't understand on 'finalize process'. That's why prolly i did some ****s finalizing the process and the result is:

On my phpBB board, i had in a category 11949 posts for 478 topics. After the conversion, i see the correct number of total post just before 'Welcome our newest member...' but in the forum description, i have 435 posts for 435 thereads....
Can you explain me ?

Btw, good vacations, you need 'em mate ;-)

I noticed an horrible bug ;-\

Many of the threads, not all, are totally screwed up !

I noticed some of the topics are going in the good forum category. But sometimes, i have posts from other topics inside :(

Also the search feature is ****ed up.... i have half of good results and half of them have nothing to do with my query....


P.S: i'm using phpBB 1.2.1 upgraded with upgrade_14.php

gah...

I really need that vacation (leaving tomorrow (YAY!! ;))). You won't be getting an update now. The SentPM thing is fixed (There's an option that lets you convert the sent PMs or not, if you chose to, the amount of queries and entries will double). It works, and I'm not sure why I didn't do that sooner. I completely forgot. :D

The counters thing I'm still looking into. The only thing I could see wrong is that you didn't follow the right order of which you need to update counters. Did you update users, then threads, and then forums, and then (optionally) rebuild the search index?

Ced: As for this new found horrible bug, please send me your complete phpBB database. My email address is: Nebula_DJ@SoftHome.net.

Anyways, this is Nebula signing off for about 4 days, or until Wednesday, which ever comes first (or last) ;)

Bye guys. I'm leaving in 20 minutes. Post all the bugs you can find here. If you test it, and it works fine, tell me that too. I'll be back on Tuesday. Again, the SentPM thing is complete, and I'm still looking into the counters problem. All I can think is that you did not update them in the right order. Make sure you update users, then threads, and then forums, not users, forums, threads like it's organized in the update counters page.

I really need this vacation ;) Anyways, I'll talk to you guys later. I look forward to at least 1 new post on Tuesday.

Your email doesn't seems to work Nebula ;\

I sent you a PM ! :-)

Good vacations

I'm about to convert a phpBB to vB. I've read the entire thread and downloaded the zip from the first post.

But just a few questions:
Does this thing import stuff from a phpBB database into a vB database? Or does it convert the phpBB database?

And what is the correct procedure? It isn't clear to me what needs to be done to convert and how...

YAY!! After a great vacation at Macinac Island (spelling??), I am totally ready to get working again.

Pingu: You didn't read the top part of first post (or am I wrong??). It says to read the last posts. The first post was the first release. The more recent ones are much farther along, and much easier to use, and do so much more. Please download the most recent version (by looking at the most recent posts). As for importing or converting, I'm not sure what the difference is (:P). But, since vBulletin calls it import, and all the vBulletin functions use the word import, then I'll say it imports ;) As for installation instructions, I think I should do that right now:

INSTALLATION INSTRUCTIONS:
[list=1][*]Download the most recent version of the script by checking the newest posts in this thread.[*]Unzip the .ZIP file, and upload 'bbimport_phpbb.php' to your vBulletin Importer directory (If your board's url is http://www.yourhost.com/vBulletin/index.php, then your board's importer directory is http://www.yourhost.com/vBulletin/importers).[*]Log into the vBulletin control panel.[*]In The 'Import & Maintenance' list, choose 'BB Import Systems'.[*]Select the phpBB importer list item, and click 'Begin Import'.[*]The script will guide you through the next steps.[*]After the script is done, you must to update counters in the order it gave you (Update Users, then Threads, and then Forums, NOT Users, then Forums, and then Threads).[*]Your phpBB was successfully imported into vBulletin! Enjoy![/list=1]

Hope that's correct.

Anyways, I must get back to unpacking our car. As soon as I'm done, I will go look at all the bug reports you sent me :P

Hope for a new script version soon!