[T3MEDIA]

Originally Posted by Splatt_XP

Here's how I finally got it to work. I had conflicting database statements so I just read the database right from the index.php file.

I placed this near the top of my index.php file:

PHP Code:

<?
$userid   = $HTTP_COOKIE_VARS['bbuserid'];
$password = $HTTP_COOKIE_VARS['bbpassword'];
$vbhost   = "localhost";
$vbuser   = "your_db_username";
$vbpass   = "your_db_password";
$vbname   = "your_db_name";
$vb=mysql_connect("$vbhost","$vbuser","$vbpass");
mysql_select_db($vbname,$vb) or die ("Forum Database Connectivity Error");

$vbsql=mysql_query("select * from user where userid = '$userid'");
$vbinfo=@mysql_fetch_array($vbsql);

$username=$vbinfo[username];
?>

Then, where I wanted the logon box, I placed the following:

PHP Code:

<?
if ($username) {
    print "<font class=title><b>Welcome back $username!&nbsp;&nbsp;</b></font>";
} else { 
?>
<!-- login form -->
<script type="text/javascript" src="forum/clientscript/vbulletin_global.js"></script>
<script type="text/javascript" src="forum/clientscript/vbulletin_menu.js"></script>
<form action="http://www.yourdomain.com/forum/login.php" method="post" onsubmit="md5hash(vb_login_password,vb_login_md5password)">
<script type="text/javascript" src="forum/clientscript/vbulletin_md5.js"></script>
<table cellpadding="0" cellspacing="3" border="0">
  <tr>
    <td class="title">User Name</td>
    <td><input type="text" class="button" name="vb_login_username" id="navbar_username" size="10" accesskey="u" tabindex="1" value="User Name" onfocus="if (this.value == 'User Name') this.value = '';" /></td>
    <td class="title" colspan="2" nowrap="nowrap"><label for="cb_cookieuser_navbar"><input type="checkbox" name="cookieuser" value="1" tabindex="3" id="cb_cookieuser_navbar" accesskey="c" checked="checked" />Remember Me?</label></td>
  </tr>
  <tr>
    <td class="title">Password</td>
    <td><input type="password" class="button" name="vb_login_password" size="10" accesskey="p" tabindex="2" /></td>
    <td><input type="submit" class="button" value="Log in" tabindex="4" accesskey="s" /></td>
  </tr>
</table>
<input type="hidden" name="s" value="" />
<input type="hidden" name="do" value="login" />
<input type="hidden" name="forceredirect" value="0" />            
<input type="hidden" name="vb_login_md5password" />
</form>
<!-- / login form -->

Of course you'll have to change the database info, classes, form action and paths to reflect your set up, but at least this got me working.

umm is that safe putting that info in your index.php?