View Single Post
  #12  
Old 04-17-2006, 08:57 PM
stonyarc stonyarc is offline
 
Join Date: Aug 2005
Location: Leuven (Belgium)
Posts: 930
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Ramsesx
Thank you stonyarc, but I used the prefix already:
VB3usertable = vb3_user
VB3sessiontable = vb3_session
url to your vb3 = http://www.mydomain.de/forum
second url = http://www.mydomain.de/forum/member.php
The database user/pw are correct.
I think you may have to change something in the php file for your setup

The table prefix is needed for some other queries to.
I'll change to mod so it will take on the prefix as a setting for all tables

quick fix for you

open mod_vbonlineusers.php

look for
PHP Code:
$my_posts mysql_query("SELECT COUNT(*) as PTOTALFOUND from post"); 
$my_threads mysql_query("SELECT COUNT(*) as TTOTALFOUND from thread"); 
$my_users mysql_query("SELECT COUNT(*) as UTOTALFOUND from user"); 
change to

PHP Code:
$my_posts mysql_query("SELECT COUNT(*) as PTOTALFOUND from vb3_post"); 
$my_threads mysql_query("SELECT COUNT(*) as TTOTALFOUND from vb3_thread"); 
$my_users mysql_query("SELECT COUNT(*) as UTOTALFOUND from $VB3_USERS_TABLE"); 
Save and upload

That should help you out till I make the update
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02040 seconds
  • Memory Usage 1,774KB
  • 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