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 08-09-2004, 11:38 PM
DrScion DrScion is offline
 
Join Date: Mar 2004
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Password integration

This is for verification of member status only and is not being used to integrate with VB, but simply to allow login to another part of the site based on their username and password.

Ive searched on google.com and here and learned that the password pattern is:

PHP Code:
md5(md5('plain txt pwd' salt)) 
Ive attempted to use this in numerous fasions, yet still wont match up with the password in the database, this coding is as follows,

PHP Code:
mysql_select_db($database_connect$connect);
$query_get_user sprintf("SELECT * FROM vb_user WHERE username='%s'"$HTTP_POST_VARS['username']);
$get_user mysql_query($query_get_user$connect) or die(mysql_error());
$row_get_user mysql_fetch_assoc($get_user);
$totalRows_get_user mysql_num_rows($get_user);

$password md5(md5($HTTP_POST_VARS['password'] . $row_get_user['salt']));

mysql_select_db($database_connect$connect);
$query_get_password sprintf("SELECT * FROM vb_user WHERE password='%s'"$password);
$get_password mysql_query($query_get_password$connect) or die(mysql_error());
$row_get_password mysql_fetch_assoc($get_password);
$totalRows_get_password mysql_num_rows($get_password);

if(
$totalRows_get_password == 0) {
die(
'Password Error');

Can someone help please?
Reply With Quote
  #2  
Old 08-09-2004, 11:50 PM
DrScion DrScion is offline
 
Join Date: Mar 2004
Posts: 6
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

My apologies, I miread one of the post I searched.

I have fixed my problem, and I will post the correct code for future reference...

PHP Code:
mysql_select_db($database_connect$connect); 
$query_get_user sprintf("SELECT * FROM vb_user WHERE username='%s'"$HTTP_POST_VARS['username']); 
$get_user mysql_query($query_get_user$connect) or die(mysql_error()); 
$row_get_user mysql_fetch_assoc($get_user); 
$totalRows_get_user mysql_num_rows($get_user); 

$password md5(md5($HTTP_POST_VARS['password'])  $row_get_user['salt']); 

mysql_select_db($database_connect$connect); 
$query_get_password sprintf("SELECT * FROM vb_user WHERE password='%s'"$password); 
$get_password mysql_query($query_get_password$connect) or die(mysql_error()); 
$row_get_password mysql_fetch_assoc($get_password); 
$totalRows_get_password mysql_num_rows($get_password); 

if(
$totalRows_get_password == 0) { 
die(
'Password Error'); 

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 12:33 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.09092 seconds
  • Memory Usage 2,181KB
  • Queries Executed 11 (?)
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
  • (3)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (2)post_thanks_box
  • (2)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit_info
  • (2)postbit
  • (2)postbit_onlinestatus
  • (2)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_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