[PHP]vBulletin to Trinity Registration Bridge problem.. menu

User Tag List

Results 1 to 10 of 10
  1. #1
    FrozenGod's Avatar Corporal
    Reputation
    1
    Join Date
    Feb 2010
    Posts
    26
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    [PHP]vBulletin to Trinity Registration Bridge problem..

    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...]

    Code:
    //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

    [PHP]vBulletin to Trinity Registration Bridge problem..
  2. #2
    Kiev's Avatar Contributor
    Reputation
    288
    Join Date
    Nov 2007
    Posts
    1,819
    Thanks G/R
    0/4
    Trade Feedback
    3 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Could you show us the error atleast? Thanks.




  3. #3
    FrozenGod's Avatar Corporal
    Reputation
    1
    Join Date
    Feb 2010
    Posts
    26
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Kiev View Post
    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...

  4. #4
    Kiev's Avatar Contributor
    Reputation
    288
    Join Date
    Nov 2007
    Posts
    1,819
    Thanks G/R
    0/4
    Trade Feedback
    3 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It seems like its encrypting both the username and password.

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




  5. #5
    FrozenGod's Avatar Corporal
    Reputation
    1
    Join Date
    Feb 2010
    Posts
    26
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Kiev View Post
    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!

  6. #6
    Le Froid's Avatar Contributor
    Reputation
    172
    Join Date
    Mar 2007
    Posts
    1,327
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally Posted by Kiev View Post
    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
    Code:
    $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?

  7. #7
    davidknag's Avatar Active Member
    Reputation
    49
    Join Date
    Nov 2009
    Posts
    201
    Thanks G/R
    0/1
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    wrong section

    put it in programming

  8. #8
    Kiev's Avatar Contributor
    Reputation
    288
    Join Date
    Nov 2007
    Posts
    1,819
    Thanks G/R
    0/4
    Trade Feedback
    3 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    He's requesting it for when he logs into game, as it returns a error.




  9. #9
    FrozenGod's Avatar Corporal
    Reputation
    1
    Join Date
    Feb 2010
    Posts
    26
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Solved,
    i have added extra line to my vBulletin config and woala its working!

  10. #10
    Kiev's Avatar Contributor
    Reputation
    288
    Join Date
    Nov 2007
    Posts
    1,819
    Thanks G/R
    0/4
    Trade Feedback
    3 (100%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Awesome ! PM Me if you need extra help.




Similar Threads

  1. .php problems
    By Etaile in forum Community Chat
    Replies: 6
    Last Post: 07-31-2010, 07:03 PM
  2. Registration Page Problem
    By zoid8806 in forum WoW EMU Questions & Requests
    Replies: 0
    Last Post: 08-06-2008, 12:44 PM
  3. [Help]Registration PAge problems
    By yrref in forum World of Warcraft Emulator Servers
    Replies: 2
    Last Post: 06-12-2008, 10:59 AM
  4. PHP Problem - Help needed
    By Falgern in forum Programming
    Replies: 3
    Last Post: 05-21-2008, 04:02 AM
  5. Registration page problem
    By staskax in forum World of Warcraft Emulator Servers
    Replies: 3
    Last Post: 02-13-2008, 08:51 AM
All times are GMT -5. The time now is 04:31 PM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search