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

[feldon23]

Freddie,

Thanks for everything getting me switched over from EZBoard. I can't believe I waited so long to switch to vBulletin. It is everything I wanted and now with a few customizations like DarkReaper's script here, it's as if we were always here and the memory of EZBoard is fading fast.

At first, I thought $80 was a bit much, now I realize it is a steal for what vBulletin does.

Without going crazy, I've already started customizing pages. I did find a bug that I hope a future version will fix, and something hard-coded that bugged me.

The topic list will only display the topic smiley $thread[info] that was selected the first time the post was made. Changing the smiley (or adding one) after the fact won't put it in the topic list.

And that brings me to the 2nd point. I changed the icons and realized that the forumdisplay.php code has 15x15 pixel icons hard-coded.

Off-topic, but how do I put the "users currently viewing the board" panel on the thread list? I tried using the token and I tried copying the code from the token. Neither worked.

[Joshua Clinard]

I added the sript to register.php, and it does not work. Is this compatible with 2.2.1? If so, haw can I get it to work?

Please Help!

[DarkReaper]

What do you mean it doesn't work? Could you please be more specific?

[Joshua Clinard]

It just does not link there posts to their profile. I had several users sign up with the same name, and then I could go look through the forums, and find old posts, and they would not be linked. Even after updating the post information. But, after using the ezconvert script, it would work. Please help. I don't want to have to do this manually for my 300+ users!

[Joshua Clinard]

Can ANYONE please help me install this? If you need my server info, I will PM it to you!

[Joshua Clinard]

Help! I can't open my board until I get this installed! I would be most appreciative if someone would help me.

Link old ezboard member posts to their new accounts

I modified the register.php file, and tested it, but it did not work.

Is this script compatible with 2.2.1? If not, can it be updated? I really need this hack for my board. I would be willing to pay someone to get this working. If someone is willing to help, I will e-mail them the ftp info as neccesarry.

[Admin]

Weird, seems the code in the first post doesn't work. I could've sworn it was differenet.

Anyway, Joshua, in register.php find this:

  $userid=$DB_site->insert_id();

and right after it add this 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'");

This is the exact code we use on this board, so it has to work.

[Joshua Clinard]

Thank You a thousand times over!! I can't thank you enough FireFly! How much do I owe ya?

This is an awesome hack!

[Admin]

No problem Joshua.

(you should've e-mailed me earlier, eh? )

[Joshua Clinard]

Sure should have! I have another question related to this. The ezconvert script has been working for the times that I want to change somone's username. Except for one. I need to change Ginny 2002 to Valerie, and it did not work. Is there a way to go through the tables and chang the username, then I can just run the convert script to add the profile info?