Link old ezboard member posts to their new accounts

Thanks to Stallion and FireFly for their input on this

Part I:

In register.php, Find this:

PHP Code:

$userid=$DB_site->insert_id(); 


AFTER it, add this:

PHP Code:

  // get hold of his posts and update threads
  $DB_site->query("UPDATE post SET userid='$userid' WHERE username='".addslashes(htmlspecialchars($username))."' AND visible<>0");
  $DB_site->query("UPDATE thread SET postuserid='$userid' WHERE postusername='".addslashes(htmlspecialchars($username))."' AND visible<>0");
  $totalposts=$DB_site->query_first("SELECT COUNT(postid) AS posts FROM post WHERE userid='$userid'");
  $DB_site->query("UPDATE user SET posts='$totalposts[posts]' WHERE userid='$userid'"); 


From now on, when a user registers with the same username they posted with on ezboard, their old posts will be linked to their new member account.

If people have already registered, or if they want a new nickname, you can use the attached script I made. Just edit $newusername and $oldusername and upload to your /admin directory, then run it(be sure to rename it to .php instead of .php.text ).

Yea, I know it doesn't have fancy menus or anything, but I didn't think it was worth the time and effort to do that...so sue me, or do it better, I'd appreciate the latter more

Updated - 10/27/01: Added FireFly's menu code. Thanks

[Admin]

E-mail me with phpMyAdmin access and I'll fix it for you.

[MarkB]

Very cool (altho I'm just using the script Firefly posted, linked from my Admin CP) -- I have a couple of hosted forums that were ezboard imports, and my users are chuffed to be able to get their postcounts back

[DarkReaper]

Thanks Firefly...and sorry guys, but I don't have much time for my site itself anymore, let alone yours

[DannyITR]

I will be requesting an import from ezboard very soon.

I plan to use the code you provided in register.php.
I have a question: I found the line in the file but to I insert this hack directly after the semicolon or after the little 0s that appear after every semicolon?

Can you explain in a little more detail what you mean by linking? Does this mean once the import is complete, any user who registers under the same name as one that has an imported post will be given that post count?

What about the second file that was provided in this thread? Something about just typing in two user names? I made this file as well but can someone tell me what it does in english?

Thanks guys

[DarkReaper]

Linking means associating all the posts under that username with their account. You'll notice that if its not linked in, it'll just show a name, and mark them as guest. This makes it so it actually counts as a post made by them.

The second file is for linking in users who have already registered, or who registered with a different name, into their old posts.

[Tannerman]

Hello. Recently had Jellsoft perform the "ezboard to vBulletin" import, and that came out great (yep, another vB customer running from the evils of inferior products - don't even get me started on my experiences with UBB6). I'm interested in getting this hack installed to so users are tied to posts (I've got a very small group of users who posts I transferred... about 10 users total). I've been trying to follow this thread as it was recommended to me on the vB forums, but with the revisions and modifications discussed, I'm a little lost.

I was wondering if someone could install this hack for me correctly (DarkReaper, FireFly?). I'd be more than happy to provide access to the server, etc. If not, I suppose I could try modifying this somehow... albeit, I'm a newbie, and really don't want to mess this thing up

One other question I had regarding this hack. If I understand it correctly, it needs to be installed before any users register with the same usernames, in order for the posts to be tied to the user. Am I correct in this assumption?

Regarding this, when I installed vBulletin, I created a username for myself that is the admin name that I'd like to use throughout the board (and had previously used on my ezboard), however, I'm assuming that my old posts cannot be tied to this username (even though they are the same names) because I needed to register after installing this hack (Follow that?). Is there any way to retroactively tie my posts to my username even though I'm already a registered user?

Please feel free to PM or e-mail me for clarification if I'm just blowing air here Thanks for reading, and have a great day.

- Steve

[Greystang302]

I imported from UBB 6.2 to vB 2.2.6, and for some reason the import didn't merge my admin account. I had two identical accounts! The one imported from UBB remained dormant. Deleted the old admin account, which marked all of those posts as 'Guest', then uploaded Firefly's script, ran it, and it worked like a champ!

Thanks!

[TheEDIGuy]

I just wanted to say "Thanks" for a great and highly useful hack. We moved a very large BB from ezBoard to vBulletin, and our users are extremely happy to have their old posts re-linked with their new names.

John

[Tailfeathers]

I have a question about this hack:
When it links new usernames to old posts by those usernames, does it also update post count and registration date (from first post), or not?

Thanks for this wonderful hack! When I convert, I will definitely be using it.

[007]

THANK YOU THANK YOU THANK YOU!!!!!!! If I would have known this hack existed I would have been 100% hyped for my purchase of vB before buying it. I was still pretty excited about it, but now THIS completes every wish I had for it. THANK YOU!

*Clicks Install*

Works like a charm!