View Single Post
  #90  
Old 12-22-2004, 09:30 AM
T3MEDIA T3MEDIA is offline
 
Join Date: Dec 2004
Posts: 944
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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!&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?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01344 seconds
  • Memory Usage 1,790KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/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_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete