[PHP]vBulletin to Trinity Registration Bridge problem..

[FrozenGod]

Hey Guys,
i have found this module to bridge my vBulletin registration with my CoreDB and its really making an account and all is pretty ggod till the moment i'am going to login with the new account and then i get an error about bad information..
Here's the script: [I guess its SHA problem...]

//change this for your mangos/trinity servers info
mysql_connect("IP","root","pass");

$sha_pass_hash = sha1(mysql_real_escape_string(strtoupper($vbulletin->userinfo['username'])) . ":" . mysql_real_escape_string(strtoupper($vbulletin->GPC['password'])));

//change database if needed. default: mangos_realmd
mysql_query("INSERT INTO realmd.account(username,sha_pass_hash, email, expansion) VALUES('".$vbulletin->GPC['username']."', '$sha_pass_hash' ,'".$vbulletin->GPC['email']."',2)");

Thanks

[Kiev]

Could you show us the error atleast? Thanks.

[FrozenGod]

Could you show us the error atleast? Thanks.

i mean the in-game error,
there is nothing to show you should know how is the "Incrrect Information" error looks like, [The Standart WoW error]
there is no errors on the mysql query...

[Kiev]

It seems like its encrypting both the username and password.

You will need to login with the SHA1 password i presume.

[FrozenGod]

It seems like its encrypting both the username and password.

You will need to login with the SHA1 password i presume.

You mean i will need to login with "888e20cf87082ea6d66e68c6c3be446bd14aaad1" as password? no way lol...

no way that there is no possible way to make this work, why? cause i found this module on another forum and i saw a people there that made it working..

anyway thanks for your help mate, any other help will be great!

[Le Froid]

It seems like its encrypting both the username and password.

You will need to login with the SHA1 password i presume.

The password is a sha hash of the username:[filler]password
My old website used

$sha_password = SHA1($username.':'.$password);

$username/$password's values are pretty obvious

It looks like you posted the registration script, what is the logon code?

[davidknag]

wrong section

put it in programming

[Kiev]

He's requesting it for when he logs into game, as it returns a error.

[FrozenGod]

Solved,
i have added extra line to my vBulletin config and woala its working!

[Kiev]

Awesome ! PM Me if you need extra help.