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 ?

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

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

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 !! :D
I post my result tomorow evening, i feel that it is good now !!!
See you tomorow :cool:

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

Hi Ced,
I had make the update of counter in the good order (Users, then Threads, and then Forums), and the problem can't comes from this point.
If you say that all is correct for you, i dont understand where the corruption come from in my importation ???
I check more for a mistake in my configuration and i post when i have found something...
Nebula, forget my last post, the mixing problem is in my database or in my brain...sorry !

Well...I'm somewhat confused ced. Is the problem my script or your database? It sounded like it was the scripts problem, but then I thought you said it was your database's problem. I'm confused. Just let me know if it is my script's problem, or your databases problem. Also, if it is a problem with my script, please send me a copy of your phpBB database, or a link to your phpMyAdmin so I can get it that way. Also, I DO compare the original phpBB and the imported vBulletin side-by-side.

I'm at my grandparents house, so I can't really make an update, as I don't really have any FTP clients or anything, and they don't want me to clutter up their computer.

Be home hopefully tonight or tomorrow night!

Hi Nebula,
CED have a good result with your script and me, JYR i have some mixte...we are 2 differents posters with 2 differents result ! :D lol

Hi !

first thanks Nebula for enabeling me to go to vBulletin from my old phpBB :)

I used to make it with one of the first versions of your script.
After some "Find & Replace" on the similies stuff in vi ;) I came accross the difficulty of all links + bbcode stuff...

So I've made a little script of mine to do this using a modified html2bb (found in admin/bbimport.php)

Here the modified I've used to get all these nasty <! BBCodes ... and other into nice vB style codes

Hope this can help some of you.

Now I've a clean forum :)

Hmm...that's really good. I was actually thinking of making something like that, just because that function doesn't work well with phpBB code. Thanks a bunch!

Actually, I think I'm gonna make my own code for this, just because that uses a lot of str_replaces. I was thinking about just removing everything in the posts between (< !--)s. Anyways, thanks tho...that has a bunch of good ideas in there. I will base many of my ideas on it.

Thank you bunches tho!!

:) Glad you like it

The smilies part (beginning of the file) is not correct for phpBB as these guys stored a href to images directely

But someting like :

might do the job pretty well :)

I converted my phpBB forum fine, but i have a minor problem...
No email has been sent to users :-\
I removed the comment in the converter just before
echo "<p>Users imported sucessfully.</p>";
$action = "mailusers";
$action = "forums";

How can i mass email their passwords to my members?

Another minor problem:
How to remove all useless slash in posts in phpmyadmin ?
like: it\'s me

Hmm...as to the mass mail not working...if you look at the 2 lines:

You'll notice that the $action = "forums"; is rewriting the $action variable so that it will no longer mail the users, but go to the forums. So remove the $action = "forums"; line. Also, please do not run this version. It is not complete. Do not use it for your final import. The final version you will obtain from JelSoft (hopefully ;)).

As to the \'slash\' problems...I do not know what is wrong with that. I'll look into it, but I am not sure what you are talking about.

Also, expect a new release very soon that has much improved HTML2BB decoding.

Why don't you edit the first post so it always has the latest version? This would make things much easier for everyone.

Neb, GREAT script. It all worked except for this detail.
I'm not an advanced programmer, but I would suspect that this can be fixed by another string replace ?

Basically, it's leaving the slash escape character in the new posts.

Any help would be GREATLY appreciated.

Thanks for an awesome script!

JC

I'll get on it right now. Expect a new release as soon as I restore all my phpBBconv stuff (I had to re-format my computer (too much surfing to strange sites sometimes gets you viruses)).

Here's a new release everyone! If I do say so myself, it has a GREAT new feature. It is a HTML2BB function modified so that it works 100% with phpBB 1.4.0. I've tested it myself, and so you shouldn't see any phpBB BBCode left over. It should be all converted into vBCode (hopefully).

Also, I have not been able to reproduce the error with the \'s. I am thinking it may be something with your database. If you have this error, send me ONE of these:

• Your Database
• A Link to phpMyAdmin that has access to the phpBB Database and the vBulletin Database

Please don't post them to the forums here, rather email me.

Thanks a bunch. This version also has some optimizations to it where I turned "s into 's because of something I read in a PHP book. If you use echo "Lala!";, it checks if it has any variables or special stuff in there, where as if you do echo "Lala!";, it does not check for anything. So that should speed it up remotely.

Please test this version. We are very near FINAL!

Regarding that las comment,you're talking about string interpolation right? Where stuff inside double quotes is checked for varaibles and while stuff inside single quotes is not. Anyways, the speed increase for that is extremely minimal but I guess you need to pull out every ounce of speed possible :)

qasic

Well...if that's what it's called then...yes. And also, I do want to get every ounce of speed out of this, because otherwise the script may timeout, and leave you with a semi-corrupt database. And...if the database is corrupted, that's not good. And besides, if it's a millisecond faster, nobody will notice, or care.

Well...as of this post...0 people have downloaded the newest version...that's not good...get testing, this is a quite important release.

I'm waiting on the verdict for the slash thing :)

I know your script works cause if it worked on my UBB->phpBB->vB then it HAS to work for everyone else :)

Besides, 900 users and 28,000 posts takes awhile to convert :)

JC

Since some people are waiting to see what is up with the slash thing, I have no clue what's causing it. I need people to run the most recent version, and test that. Please use that script to generate a vBulletin database, and then tell me if you are affected, and if you are, send me a link to your vBulletin database (using phpMyAdmin), or an actual copy of the converted vBulletin database.

Also, I am working on a version that fixes some problems (not bugs) in the new html2vBCode routine. If any BBCode is not being converted, I know. Just focus on the slashes please. Thank you.

This script is almost done. Please don't let me loose all my testers.

Thanks Neb, I'll run it again right now and should have something to you shortly......

JC

I think I might have figured out the slash problem.

If you look in the DB, some ' characters are escaped with one slash while others are escaped with 3.

I'm gonna remove the extras with a find/replace and try it.....

JC

Nope, this one locked up on a post.......did not get to test my slash theory.

What now?

JC

Hello All. Hopefully, this version fixes the problem with the slash thing. Please test it, and let me know how it works out.

Also, some phpBB BBCode decoding problems have been fixed. It should now decode < img> tags and Edit Messages. Also, I am having trouble with the smilies being turned into their respective symbols, and < font> tags being decoded. I am currently working on it. Please do not tell me those don't work, because I know ;)

If you have any ideas on how to help out on fixing the smilies code or the font code, please let me know ASAP. My school begins this coming Monday (8-27-2001). After that, I will not be able to work on this very much, and I am working very hard on it. I need all your help. Thanks!

I converted about a week ago and apart from some slashes and broken smiley links everything has been running smoothly.

Thanks Nebula!

Try running the version released just above your post. That way, the slashes will be removed (hopefully). The smilies are currently being worked on.

Tell me how it goes.

Hi Nebula,

Thanx to your work, my board is now on vBulletin since one week now, and like jpetrovs, it runs just fine !!!

Can you isolate your code for the slash thing problem, because my database is way too huge to do it on all post manually ;-)

Many thanx,

I think this version may be perfect!! Please download it and test it. Smilies work. All BBCode is decoded. If this version isn't perfect, I give up (not really...but you know what I mean ;)).

I'll be away tomorrow, so I won't be around. Let me know what happens!

If this version is fine, then this will be the final version! Don't stop testing now, you've come so far ;)

Turned out that this isn't a bug fix, but rather a compatibility issue caused with the [ code ] tags, and the [ quote ] tags. This version also gives you the option of mailing users. If you do not want to, when you get to that step...just enter 0 for the number of cycles.

Hope this one is final!!

Is anyone gonna give me feedback?

Remember, this coming Monday (8-27-2001), or 3 days, I return to school. So, that means that unless I have an unusually low amount of homework, I will not be able to work on this at all. Please help me now so I may get it finished.

Neb, it works great. However the mail users function breaks in the SQL.

Weird, I pasted the SQL into phpMyAdmin, and it works.....just not in the context of the script.

JC

hrm...I was afraid of that, no official testing and all...I'll go check it out.

Here's a teeny weenie bug fix. It fixes a problem with a SQL Query Error. What happened was there was an invalid variable name in the LIMIT clause. It's fixed now, and is ready for testing again ;)

Please don't stop testing now. I really need your help.