
12-22-2004, 09:30 AM
|
|
|
Join Date: Dec 2004
Posts: 944
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Quote:
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! </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?
|