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]

Okie. Here's the most current release. Also, I will be pruning all the older versions for two reasons (I don't want to make vBulletin's database too big, and I don't want people downloading a bad version). Anyways, this adds one feature, and no bug fixes.

The added feature is the addition of the option to import sent PMs also. Also, you may be wondering why the counters bug (the one about thread and post counts being the same). I have looked over this for at least an hour, and have came to the conclusion that this is not a bug. I have been able to recreate the bug by following the last instructions wrong. The threads and posts counters appear the same when you update in this order: users,forums,threads. They appear right when updated in this order: users,threads,forums. I will explain why:

When you update user data, that basicially updates when the user last posted and stuff like that. When you update threads, it counts all the posts inside each thread and the lastposter, and updates the thread. When you import forums, it reads only the thread data. It does NOT read any post data. When a thread is imported, it's replycount is set to 0. It is done so because it saves many queries. When you update users,forums,threads, then the forums look at the replycounts in the thread table, and think that all that's in that forum is single-post threads. Then, when you update threads, all the 0s in the replycounts are changed to their proper number, so it appears to be a bug. But it is not. It is a failure to read the directions...

That is the conclusion I came to. If you don't understand that paragraph before this one, that's okay. It's just technical stuff.

Anyways, test this version. Ced, try updating counters in the right order. It is confusing, because vBulletin has it ordered the wrong way. Maybe I'll submit a bug report

Send me all your feedback.

Also, ced, if this problem persists, I will need you to send me your database. I have a cable modem, so that is no problem. Don't worry about size. I don't care if it is 100MB...just send it

Hello,

I tried again in the order you said and all is fine on the main page now

The problem begins when i try to enter in forums... Threads inside forums seems to be posted in random categories :-\
Also threads topics doesn't point with good content.... :-(

I really would like to send you my database but your email doesn' works at all, i keep getting that error: Nebula_DJ@SoftHome.net; Action: Failed; Status: 5.1.7 (bad sender's mailbox address syntax)
Do you check your PMs ?

[Nebula]

Well...This version I think is perfect. I think it's finally done.

This version fixes the big nasty bug where posts were in the wrong topics. It also adds smiley import support.

If this one has no bugs, then I will change the cosmetics of it, and then send it in.

Test it now! Thanks.

Seems PERFECT ! Congratulations for your good work !

Is the last version able to send new passwords ?

Also, i was wondering what's better, to keep MD5 encrypted password by hacking the board or send new passwords ??

[JohnM]

I'd send new passwords. Just works better with forgot password and such.

[Nebula]

It does send passwords. I have just commented it out, because otherwise you wouldn't be able to test it without sending the users their passwords

Glad to hear everything is OK.

This latest version worked great for me as well. Just some minor cosmetic stuff to clean up. Thanks for a great script!

Hi Nebula !
I am just come back from litles holidays, and i see that you are on the work again !
I try your last release tomorow, and i hope that all is allright !!
I post my result tomorow evening, i feel that it is good now !!!
See you tomorow

Hi Nebula,
Bad news with your last release of the 08/15:
- Now, on the main page, the number of threads is ok, and the number of posts is not ok (98 for 66 or 147 for 76...) on all forums;
- In forums, the name of the thread is ok, but thread starter, replys and last poster are not ok. Only the number of reply is ok;
- In a topic, the number of reply is not ok;

In fact, it seems that there is an offset between topics and/or threads, because when i open a topic, i see the post for an another one and the number of answers that i can read is corresponding to the bad number that i see when i am in the page of forums.

The mixte is difficult for me to explain in english...so for see the problem, make like me with my data base (that you have) :
- open 2 windows with one in phpBB and the other with the VB importation;
- for every fields like topics, threads, replys,...you compare the VB with the ref in phpBB;

I am sorry to say this to you, but if you don't use this method, i think you can never solve all this problem of mixing...
I don't know how you check your new release, but if you check with 5 posters and 10 posts, it is working fine ! the problem is perhaps with bigger database, so take a real forum like mine for your script validation.

You are so near of the true, take your time, and make the final release perfect !
So, have a nice week-end

I tried the last realease of Nebula and it seems real perfect for me ! My board isn't that small, i have 10 forums and 40000+ posts !

I had the same problem as you and that thing Nebula said solve many problems:
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).


The proof i'm really happy of that script is i bought my license and i'm planning to convert my board in the next days