The Arcive of vBulletin Modifications Site.

ravenswood1000 · #1 07-15-2011, 01:35 PM

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?

LifesGreatestGift · #2 07-15-2011, 07:51 PM

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.

ravenswood1000 · #3 07-15-2011, 09:20 PM

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.

bigtime · #4 07-18-2011, 04:35 PM

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

ravenswood1000 · #5 07-18-2011, 06:16 PM

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!

bigtime · #6 07-18-2011, 06:25 PM

You're welcome!

Tim
www.SuppYo.com - Daily Deals

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06490 seconds Memory Usage 4,706KB 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 (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/functions_amr.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
Messages: