Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
  #1  
Old 12-15-2005, 11:50 AM
Vizionz Vizionz is offline
 
Join Date: Jul 2003
Location: Chicago
Posts: 524
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Two Mysql databases. Please help coders

okay i almost have my radio station completely built just need to do one last script and this is the one causing the most problem..

Code:
function connectdbase() {
    $db = mysql_connect("localhost", "user", "pass");
    mysql_select_db("database",$db);
  }  
 
that right there connets to the script.. (radio Script)
 
<?
chdir('/httpdocs/Forum'); 
require_once('./global.php');
 ?>
that above  calls the global.php from the forum  
which loads the info from the database that the forum runs on 
which is seperate then the database the radio part uses
 
now normally this would work fine but 
in the script when it goes to call
 
connectdbase(); which is the radio script database )
Its not  its giving me
 
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /httpdocs/info.php on line 130
 
line 130  $data=mysql_fetch_object($result);


 
        
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /httpdocs/info.php on line 215
 
Line 215 $ldata=mysql_fetch_object($lresult);
 
so i am taking it that somewhere in that its getting confused and not using the database its suppose too. there both on local host and there both set up and running and it should work  but somewhere i am thinking i am missing something that will kill the first call to the forum database after it grabs the theme and then calls the new database. so it isnt still using the vbulletin database  Ya understand what i am saying
Now without the Call to grab the vbulletin theme the script works fine gets everything it needs. but once i put the call to vbulletin the script dont work. and this is because somewhere its getting confused on where the info is.

Is there anyway to either call the vbulletin theme besides global or a way to Kill the database connection to vbulletin once it grabs the theme so the script then will run while it already launched the theme
Reply With Quote
  #2  
Old 12-15-2005, 12:48 PM
Andrew's Avatar
Andrew Andrew is offline
 
Join Date: Nov 2004
Location: Pennsylvania
Posts: 441
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Try changing $db to something more specific like $radiodb. It could be that global.php is also using $db, and when it connects to the vB database it overwrites the values you originally stored in it.
Reply With Quote
  #3  
Old 12-16-2005, 10:48 AM
Vizionz Vizionz is offline
 
Join Date: Jul 2003
Location: Chicago
Posts: 524
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

tried that no luck
Reply With Quote
Reply

Thread Tools
Display Modes

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 02:32 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05533 seconds
  • Memory Usage 2,172KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete