Link old ezboard member posts to their new accounts

[DarkReaper]

Thanks to Stallion and FireFly for their input on this

Part I:

In register.php, Find this:

$DB_site->query("INSERT INTO userfield $userfieldsnames VALUES ($userid$userfields)"); 

AFTER it, add this:

$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

[Joshua Clinard]

Is there anyway you can update this script so that you can type the old and new usernames in a form and press an update button, instead of having to upload the script 100 times?

I would be SO greatful if someone could do this. It would totally ROCK!

[Martz]

Nice addition Darkreaper

[Chen]

Save this file as whatever you want .php and upload to your admin folder:

<?
/******************************************************************************
*		ezboard import member converter
*		By Jason "DarkReaper" Rodzik
*		Special Thanks to Firefly and Stallion
*
*		[url]http://www.unrealtournament.org/forums[/url]
*
*
*		Support for this hack at:
*		[url]http://vbulletin.com/forum/showthread.php?s=&threadid=31443[/url]
*******************************************************************************/


error_reporting(7);
require("./global.php");
$thisscript=substr($PHP_SELF, 0, strlen($PHP_SELF)-4);

cpheader();

if ($HTTP_POST_VARS['action']=="update") {
	if (isset($oldusername) and isset($newusername)) {
		$getuserid=$DB_site->query_first("SELECT userid FROM user WHERE username='$newusername'");
		$userid=$getuserid[userid];

		// get hold of his posts and update threads
		$DB_site->query("UPDATE post SET userid='$userid',username='$newusername' WHERE username='".addslashes(htmlspecialchars($oldusername))."'");
		$DB_site->query("UPDATE thread SET postuserid='$userid',postusername='$newusername' WHERE postusername='".addslashes(htmlspecialchars($oldusername))."'");
		$DB_site->query("UPDATE thread SET lastposter='$newusername' WHERE lastposter='".addslashes(htmlspecialchars($oldusername))."'");
		$DB_site->query("UPDATE forum SET lastposter='$newusername' WHERE lastposter='".addslashes(htmlspecialchars($oldusername))."'");

		// Update post counts
		$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'");
		echo "Fixing user with ID of $userid and posts are $totalposts[posts]\n\nYou should now update your member titles.";
	} else {
		echo "Please enter new and old usernames.";
	}
}

doformheader("$thisscript","update");
maketableheader("Update user stuff");
makeinputcode("His new username","newusername","$newusername");
makeinputcode("His old username","oldusername","$oldusername");
doformfooter("Update!");

cpfooter();

?>

Just added some fancy code, includes a form now so you can just enter two usernames and click update.

[Freddie Bingham]

I'll see if I can't put something in the CP that will help with this or just reinstating a user who you deleted. There is already an option to rebuild post counts in the next version.

[DarkReaper]

Thanks FireFly, I updated the attachment

freddie: Great!

[Joshua Clinard]

For some reason, if the old and new usernames are not the same, it will not work. I tried this with a few of my users, and instead of the usual message it said

Fixing user with ID and posts are 8900 You should now update your member titles.

There was No user ID, and I think the 8900 is the number of total posts on the board. Anyway, I hope this doesn't mess anything up. It's not a big, deal, I don't have to have it, but I was just letting people know that it doesn't work...The rest of it works great though...

On the other hand thier are a few users on my board that changed usernames...

[DarkReaper]

It works fine for me when they're different. If it didn't, I wouldn't have released it

What version of vBulletin are you running? Are you sure that you're inputting the EXACT nicknames correctly? And that you're putting the old username and new username in the correct box?

What are some of the old/new usernames that are giving you problems?

[Joshua Clinard]

I am running the most cuurent version. 2.0.3. The usernames I tried were hooky27 to Alex....Eson to Emerson...

I just tired it again and got thepotterconnection to Wizard Girl to work...

Don't know why...I am confused. Thanks for the help though.

well it said it worked..but I don't think it did...the posts don't show up in the search for username...I think I messed it up...now not even the posts she has posted since vbulletin show up....

Is there anyway to fix this...

[DarkReaper]

Try rebuilding your search index. That *should* fix it.