ok guys i fixed the register page, lucky i'm a proffesional php programmer ^^.
but all the tables scared me a bit that's why i didn't try before...
what you have to change(don't know how to do with SQLyog) when in phpmyadmin, go to table 'accounts' then look for column 'acct' make it the primary key, and then set autoincrement on it (that was mistake 1).
Second open up /forum/reguser.php with notepad and change following code to the code that looks similar to it.
Code:
if($requirekey=="no"||$requirekey=="No") //if you do no require an activation key
{
$SQL ="INSERT into b_users (username,password,email,validated,location,AIM,ICQ,showprofile) values('$username','$password2','$email','1','$location','$aim','$icq','$showprofile')";
mysql_query($SQL) or die(mysql_error()."<br>SQL ERROR");
mysql_select_db($chardb);
$SQLwow ="INSERT into accounts (login,password,encrypted_password,gm,vip,banned,lastip,email,flags,forceLanguage,muted,banreason) values ('$username','$pass2','','','0','0','".$_SERVER['REMOTE_ADDR']."','$email','24','enGB','0','')";
mysql_query($SQLwow) or die(mysql_error()."<br>Account with that name already exist in server database, this is admin fault, please notify admin about this problem. Go back to register new account with new username.");
}
else //you require an activation key
{
$SQL ="INSERT into b_users (username,password,sig, keynode,email,location,AIM,ICQ,showprofile) values('$username','$password2','$signature','$key','$email','$location','$aim','$icq','$showprofile')";
mysql_query($SQL) or die(mysql_error());
mysql_select_db($chardb);
$SQLwow ="INSERT into accounts (login,password,encrypted_password,gm,vip,banned,lastip,email,flags,forceLanguage,muted,banreason) values ('$username','$pass2','','','0','0','".$_SERVER['REMOTE_ADDR']."','$email','24','enGB','0','')";
mysql_query($SQLwow) or die(mysql_error());
mail("$email","Your forum activation key","Paste the URL to activate your account. $boardpath/activate.php?username=$username&password=$password&keynode=$key");
}
where code is red change it to your version of wowserver.
Hope it helps someone...