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 07-15-2011, 02:35 PM
ravenswood1000 ravenswood1000 is offline
 
Join Date: Oct 2002
Posts: 10
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Using vb database for login on separate domain

Hi. I've been looking around but can't seem to find an easy answer. All I want to do is be able to is authenticate a user and password against the vbulletin user (4.1.4) database on a domain that is separate from the forums (hence not shared cookies) and go from there.

Don't need anything fancy. I just want to be able to have them authenticate that they are a forum user on the forum domain.

I'm sorry if I missed an article, but could someone point something like this out or demonstrate how it might be done?

Thanks in advance.

--------------- Added [DATE]1310747479[/DATE] at [TIME]1310747479[/TIME] ---------------

I found this, but it does not work.

Code:
<form action="index.php?p=login" method="post" enctype="multipart/form-data">

Username: <input type="text" name="user" />       
 Password: <input type="password" name="pass" />        
 <input type="submit" value="Login" />    
 </form>
 <?php    
 if ( $_GET['p'] == 'login' ) {      
     $host = "localhost";  
     $user = "username";  
     $pass = "password";  
     $$db = "forums";  
     $con = mysql_connect($server, $username, $password);  
     mysql_select_db($database);          
     // MD5 the form password        
     $md5Pass = MD5(MD5(pass.salt));                 
     // Get user details from MySQL Table  
     print "$md5Pass<br>";     
     $Query = mysql_query( " SELECT * FROM user WHERE username = '$_POST[user]' " );        
     $result = mysql_fetch_array( $Query );                
     // Check that the form password matches the one in the database        
     if ( $md5Pass == $result['password'] ) {            
         echo 'User logged in';        
     } else {
          echo 'Wrong Password, please try again';       
     }            
 }
?>
Can anyone be of assistance?
Reply With Quote
  #2  
Old 07-15-2011, 08:51 PM
LifesGreatestGift's Avatar
LifesGreatestGift LifesGreatestGift is offline
 
Join Date: Jul 2009
Location: Louisville, KY USA
Posts: 885
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

are you trying to only show a pages content if they are a logged in user?
Use PHP

Here is an example
PHP Code:
<html>
<body>
<?php
$curdir 
getcwd ();
chdir('/path/to/your/account/public_html/');
require_once(
'/path/to/your/account/public_html/global.php');
chdir ($curdir);

if (
$vbulletin->userinfo['userid']!=0) {
echo 
"<p>Welcome <b>";
echo 
$vbulletin->userinfo['username'];
echo 
"</b></p>";
?>
<p>CONTENT TO SHOW WHEN LOGGED IN</p>
<?php
} else {
?>
<p>Please <a href="./path/to/forum/register.php">register</a> or login to view this content.</p>
<?php

}

?>
</body>
</html>
yourfile.php

the domains would have to be on the same server though.
Reply With Quote
  #3  
Old 07-15-2011, 10:20 PM
ravenswood1000 ravenswood1000 is offline
 
Join Date: Oct 2002
Posts: 10
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi thanks for replying. I tried what you suggested, making the changes to the forum path and it didn't work. I think anything I work on has a ghost in it.

Actually, what I was hoping for was a way to validate against the vbulletin user database. Create a login form on a different domain (on the same machine) then validate it with the database using the username and password, and going from there.

Maybe I have something set wrong?

Thanks again for replying.
Reply With Quote
  #4  
Old 07-18-2011, 05:35 PM
bigtime bigtime is offline
 
Join Date: Jun 2002
Location: Houston, Texas
Posts: 171
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi,

I made a few changes but didn't test it. Give it a try...

PHP Code:
<form action="index.php?p=login" method="post" enctype="multipart/form-data">
  Username:
  <input type="text" name="user" />
  Password:
  <input type="password" name="pass" />
  <input type="submit" value="Login" />
</form>
<?php    
 
if ( $_GET['p'] == 'login' ) {      
     
$host "localhost";  
     
$user "username";  
     
$pass "password";  
     
$db "forums";  
     
$con mysql_connect($server$username$password);  
     
mysql_select_db($database);          

     
// Get user details from MySQL Table  
     
$Query mysql_query" SELECT * FROM user WHERE username ='" mysql_real_escape_string($_POST['user']) . "',
 " 
);        
     
$result mysql_fetch_array$Query );    
     
          
// MD5 the form password        
     
$md5Pass md5(md5($pass).$result['salt']); 
                 
     
// Check that the form password matches the one in the database        
     
if ( $md5Pass == $result['password'] ) {            
         echo 
'User logged in';        
     } else {
          echo 
'Wrong Password, please try again';       
     }            
 }
?>
Change user, pass and db.

Hope that helps.

Tim
www.SuppYo.com
Reply With Quote
  #5  
Old 07-18-2011, 07:16 PM
ravenswood1000 ravenswood1000 is offline
 
Join Date: Oct 2002
Posts: 10
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thank you very very much. I've seen code just like that in a lot of places and most of them have that middle parens off so it doesn't work but this one works. Thanks again!
Reply With Quote
  #6  
Old 07-18-2011, 07:25 PM
bigtime bigtime is offline
 
Join Date: Jun 2002
Location: Houston, Texas
Posts: 171
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You're welcome!
Tim
www.SuppYo.com - Daily Deals
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:49 PM.


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.04142 seconds
  • Memory Usage 2,225KB
  • 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
  • (1)bbcode_code
  • (2)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)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