vb.org Archive - Using vb database for login on separate domain

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)

- - Using vb database for login on separate domain (https://vborg.vbsupport.ru/showthread.php?t=266885)

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?

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.

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.

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

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!

You're welcome! :)
Tim
www.SuppYo.com - Daily Deals

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01072 seconds Memory Usage 1,743KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: