Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 06-22-2006, 04:01 AM
jacks0_0 jacks0_0 is offline
 
Join Date: Jun 2003
Posts: 22
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Problem with the database (MD5 HASH)...please help...

I'm trying to integrate my system with vbulletin. In my file "signup.php" I had put this code:
Quote:
$pass=md5(md5($_POST['password'].$salt));
$confirm=md5(md5($_POST['confirmpass'].$salt));
and then
Quote:
$insertuser=mysql_query("insert into ".$tbfix."user (userid,fullname,username,password,email, permission,sex) values ('','$fullname','$username','$pass','$email','1',' $sex')") or die(mysql_error());
?>
And this is my code in my _function.php: (for login):
Quote:
$sql=mysql_query("select permission,password,salt from ".$tbfix."user where userid='$cookieid'") or die(mysql_error());
$row=mysql_fetch_array($sql);
$salt=$row[salt];
$password=MD5(MD5($row[password].$salt));
it's working well when I register new member at my system (Vbulletin can read password and my system too) but when I register new member at vbulletin, only the vbb can read the password.

I have tried to figure out, and then I reg another member at my system, the password in the database is the same with the previous user and $salt has no effect :|

Please help me to solve this problem and tell me the easiest way to integrate a system with vbb ^ ^ thank you so much
Reply With Quote
  #2  
Old 06-22-2006, 04:03 AM
Adrian Schneider's Avatar
Adrian Schneider Adrian Schneider is offline
 
Join Date: Jul 2004
Posts: 2,528
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I'm pretty sure it is md5(md5(password) . salt)...
Reply With Quote
  #3  
Old 06-22-2006, 04:28 AM
jacks0_0 jacks0_0 is offline
 
Join Date: Jun 2003
Posts: 22
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I have edited it into:
Quote:
$pass=md5(md5($_POST['password']).$salt);
$confirm=md5(md5($_POST['confirmpass']).$salt);
and
$sql=mysql_query("select permission,password,salt from ".$tbfix."user where userid='$cookieid'") or die(mysql_error());
$row=mysql_fetch_array($sql);
$salt=$row[salt];
$password=MD5(MD5($row[password].$salt)); [/QUOTE]
but it still doesn't work, I think the problem must be $salt varibale because Id didn't declare anything...
Can you provide me the code or show me the way to do it ^ ^ thank you so much

I think the problem would be the $salt variable... but I don't know how to declare it and combine it into my system's password...

I have converted my system's password into double md5 (I guess) and the vbulletin can read it without $salt...

Please tell me how to combine $salt and password thank you so much
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:29 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03522 seconds
  • Memory Usage 2,180KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (4)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete