PHP Warning: Undefined array key "rating" in ..../includes/class_postbit.php(368) : eval()'d code on line 68
Validating a username and password from external pages - vb.org Archive
Go Back   vb.org Archive > vBulletin Article Depository > Read An Article > vBulletin Tips & Tricks
Reload this Page Validating a username and password from external pages
Register FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Validating a username and password from external pages
sknight
Join Date: Nov 2008
Posts: 4

 

Show Printable Version Email this Page Subscription
sknight sknight is offline 01-24-2011, 10:00 PM
Seems like rocket science to get the proper informatiion but here is some code I whipped up this afternoon.

I needed a way for users of my site to log into my main site using their forum username and password and I thought this would help others trying to do the same.

PHP Code:
<?
$server=ENTER VBULLETIN SERVER IP HERE;
$databaseusername=ENTER VBULLETIN DATABASE USERNAME HERE;
$databasepassword=ENTER VBULLETIN DATABASE PASSWORD HERE;
$databasename=ENTER VBULLETIN DATABASE NAME HERE
$chandle =mysql_connect ($server, $databaseusername", $databasepassword);
if (!mysql_select_db($datababasename, $chandle)) die("can't select database");
$username=mysql_real_escape_string($_REQUEST['username']);
$password=mysql_real_escape_string($_REQUEST['password']);
$pass=false;
$passworderr="please enter a password";
$usernameerr="please enter a username";
if (($username<>"") && ($password<>""))
    {
    $sql="SELECT username,password,salt FROM `user` WHERE username='".$username."' LIMIT 0 , 1";
    $sresult = mysql_query($sql);
    if (!$sresult) die ("bad sql in username lookup ".$sql." ".mysql_error());
    $row=mysql_fetch_array($sresult);
    if (mysql_affected_rows()==1)
        {
        if (md5(md5($password) . $row['salt']) == $row['password'])
            $pass=true;
        else
            $passworderr="<b>invalid password</b>";
        }
    else
        $usernameerr="<b>username not found</b>";
    }

if ($pass==true)
    {?>
    Thank you for logging in
<?     }
else
    {?>
    <form type="post">
    <table>
        <tr>
        <td align=right><? echo $usernameerr ?></td>
        <td><input type=text name=username value="<?echo $username ?>" width=20></td>
        </tr>
        <td>
        <tr>
        <td align=right><? echo $passworderr ?></td>
        <td><input type=password name=password value="<?echo $password ?>" width=20>
        <input type=submit value="log in">
        </td>
        </tr>
    </table>
<?    }?>
Reply With Quote
  #2  
Old 01-30-2011, 06:31 PM
tom001 tom001 is offline
 
Join Date: Aug 2009
Posts: 42
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
What do you do with this?

We need to know.
Reply With Quote
  #3  
Old 03-01-2011, 01:52 PM
Fuhrmann Fuhrmann is offline
 
Join Date: May 2010
Posts: 76
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Nice one, thanks!!
Reply With Quote
  #4  
Old 04-03-2011, 05:59 PM
Gursimran Gursimran is offline
 
Join Date: Jun 2008
Posts: 41
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I have wordpress installed in the root. I don't show its login box to my users, neither ask them to register in wordpress. I wonder if I can use this integration in wordpress pages?
Reply With Quote
  #5  
Old 07-18-2011, 03:52 PM
bigtime bigtime is offline
 
Join Date: Jun 2002
Location: Houston, Texas
Posts: 171
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Thanks for the code. There's a typo.

$row['password])

Should be:

PHP Code:
$row['password'])
Thanks,

Tim
www.SuppYo.com
Reply With Quote
Reply

« Previous Thread | Next Thread »

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:21 AM.

Contact Us - Archive - Privacy Statement - Top

Powered by vBulletin® Version 3.9.0
Copyright ©2000 - 2017, vBulletin Solutions Inc.