[mkilty]

Hi,

First thanks for the above script.

Running: vb 2.03 and Post-Nuke 7.03 (Rogue)

After following the above I went and try adding a new member. I went throught the registration and it worked great until I open the activation e-mail. Where it wanted me to click to activate my new account it came back with the standard vb error page.

The error that MySql generated was this:
============
Database error in vBulletin: Invalid SQL: SELECT activationid FROM useractivation WHERE userid='5197' AND type=0
mysql error:
mysql error number
Date: Saturday 26th of January 2002 09:14:33 PM
Script: /forums/register.php?a=act&u=5197&i=1012079601
============
I took a look at the nuke_user file and it had been populated with all my vb users except the latest one as a previous post talked about.

Also Table 'vbullet.useractivation' doesn't exist. Is this new for the latest version of vb? What would be the equivelent for 2.03vb.

Can I substitute the mysql call in register.php with the 2.03 vb version if different?
==========
$user=$DB_site->query_first("SELECT activationid FROM useractivation WHERE userid='$userinfo[userid]' AND type=0");
==========

Any idea's ???????

Thanks,

Michael