vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Two Mysql databases. Please help coders (https://vborg.vbsupport.ru/showthread.php?t=103007)

Vizionz 12-15-2005 11:50 AM
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

Andrew 12-15-2005 12:48 PM
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.

Vizionz 12-16-2005 10:48 AM
tried that no luck :(


All times are GMT. The time now is 08:44 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02067 seconds
  • Memory Usage 1,711KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete