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

Reply
 
Thread Tools Display Modes
  #1  
Old 12-04-2014, 10:41 AM
vincenzoaglio vincenzoaglio is offline
 
Join Date: Aug 2014
Location: Naples
Posts: 1
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Checking password in MD5

I apologize I posted incorrectly in vbulletin 3 while my version and 4
I ask a moderator to close the same discussion mistakenly posted in section 3 vbulettin

Hello all I hope to explain better my problem.
I'm doing convenient application in Android, with a db on my server where it is housed even vbulettin. I need to introduce the user and password. This request is made by a query sent to the server, where is a php file called login.php which returns the fields in the query, or user, pwd, salt and so far all is well. I read something about how vbulettin translates the password in MD5 and I read this statement:
$ hash = MD5 (MD5 ($ password) + $ salt)
Having said that php does not understand anything but I interpret this statement as follows:
Take the password, turn it into MD5 sum the contents of the "salt" and request a new transformation in MD5.
Unfortunately, everything I do I can not get the same value stored in the password field of vbulettin. Perhaps it would be done directly in php, but unfortunately they are not in the capacity to do so than to send a query and return the required fields as per the following code

PHP Code:
<?php
no null string is only 
for security
$databasehost  
=  ""
$databasename  =  ""
$databaseusername  ""
$databasepassword  =  "";

$con mysql_connect($databasehost,$databaseusername,$databasepassword) or die(mysql_error());
mysql_select_db($databasename) or die(mysql_error());
mysql_query("SET CHARACTER SET utf8");
$query file_get_contents("php://input");
$sth mysql_query($query);

if (
mysql_errno()) {
    
header("HTTP/1.1 500 Internal Server Error");
    echo 
$query.'\n';
    echo 
mysql_error();
}
else
{
    
$rows = array();
    while(
$r mysql_fetch_assoc($sth)) {
        
$rows[] = $r;
    }
    print 
json_encode($rows);
}
?>
the query is this

Code:
Dim myquery As String="SELECT salt FROM user WHERE username ='Enzo'"
It would be appropriate to carry out this conversion directly in php, or send the user field and the password field and return true or false if the conditions are right
Who helps me to do such a thing ???
Sorry for the English, but use the google translator
Reply With Quote
  #2  
Old 12-04-2014, 10:49 AM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I don't know which programming language you are using, but in php it is this:
Code:
$hash = MD5 (MD5 ($password) . $salt);
where the '.' is string concatenation. Maybe you're working in a language that uses '+' for string concatenation? Then that should be OK.
Reply With Quote
  #3  
Old 12-04-2014, 11:04 AM
kh99 kh99 is offline
 
Join Date: Aug 2009
Location: Maine
Posts: 13,185
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Maybe this will help: http://stackoverflow.com/questions/4...d5-the-php-way
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 11:28 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05727 seconds
  • Memory Usage 2,189KB
  • 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
  • (2)bbcode_code
  • (1)bbcode_php
  • (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