The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
![]()
I'm writing a plugin that will access both the vBulletin db and a different database on the same server. I've gotten it working with the second db by using the standard mysql functions, but I'm trying to clean it up so that it uses only the vBulletin db functions. My question is, can I do this in my plugin to change my selected DB and then change back to the vbulletin db:
Code:
//select the alternate db $this->dbobject->select_db($wp_db_name); //create the table if necessarry $query="CREATE TABLE IF NOT EXISTS `".$wp_table_prefix."vbulletin_mappings` (`wp_post_id` INT NOT NULL ,`vb_thread_id` INT NOT NULL) CHARACTER SET = latin1;"; $this->dbobject->query_write($query); //add some stuff to the new table.... //imagine that there's some kind of insert query here //then switch back to the original vb db $this->dbobject->select_db($vb_db_name); //add the rest of my vb sql stuff here Bueller? |
#2
|
|||
|
|||
![]()
I'm honestly not 100%, but I believe the second parameter allows you to specify the database resource. Again, i'm not positive on this.
|
#3
|
|||
|
|||
![]()
If the mySQL login that vBulletin uses to access the forum database also has access to your second database, you can access both using the same connection. All you need to do is add the database name explicitly before the table.
For instance: [SQL]SELECT table1.* FROM myotherdb.table1 table1[/SQL] |
#4
|
||||
|
||||
![]()
Thanks for the info. I've been scouring this forum all day and have found info that almost answers my question, but not quite. I finally overcame my laziness and print_r'd the $vbulletin object and figured out my problem. Here's the answer:
The $vbulletin->config array contains all the relevant vars you need to make your standard vBulletin connection, which you need if you want to switch back to the vBulletin db after you switch to a different db: Code:
$vbulletin->config['MasterServer']['servername'] $vbulletin->config['MasterServer']['port'] $vbulletin->config['MasterServer']['username'] $vbulletin->config['MasterServer']['password'] $vbulletin->config['Database']['dbname'] So to switch databases in my plugin, I basically did this: Code:
global $vbulletin; //get the config options for the plugin or use the vBulletin db info as default $wp_db_host = ($vbulletin->options['wp_db_host']?$vbulletin->options['wp_db_host']:$vbulletin->config['MasterServer']['servername']); $wp_db_username = ($vbulletin->options['wp_db_username']?$vbulletin->options['wp_db_username']:$vbulletin->config['MasterServer']['username']); $wp_db_password = ($vbulletin->options['wp_db_password']?$vbulletin->options['wp_db_password']:$vbulletin->config['MasterServer']['password']); $wp_db_name = ($vbulletin->options['wp_db_name']?$vbulletin->options['wp_db_name']:$vbulletin->config['Database']['dbname']); $wp_table_prefix = ($vbulletin->options['wp_table_prefix']?$vbulletin->options['wp_table_prefix']:""); $wp_db_port = ($vbulletin->options['wp_db_port']?$vbulletin->options['wp_db_port']:$vbulletin->config['MasterServer']['port']); //here we connect to our secondary database... // Connecting to the wordpress db if it's on a different server if($wp_db_host != $vbulletin->config['MasterServer']['servername']){ $this->dbobject->connect($wp_db_name,$wp_db_host,$wp_db_port,$wp_db_username,$wp_db_password,false); } //else just select the wordpress db if it has a different name from the current db. elseif($vbulletin->config['Database']['dbname'] != $wp_db_name){ $this->dbobject->select_db($wp_db_name); } Code:
//reconnect to the vBulletin DB if it's on a different server if($wp_db_host != $vbulletin->config['MasterServer']['servername']){ $this->dbobject->connect( $vbulletin->config['Database']['dbname'], $vbulletin->config['MasterServer']['servername'], $vbulletin->config['MasterServer']['port'], $vbulletin->config['MasterServer']['username'], $vbulletin->config['MasterServer']['password'], $vbulletin->config['MasterServer']['usepconnect'], $vbulletin->config['SlaveServer']['servername'], $vbulletin->config['SlaveServer']['port'], $vbulletin->config['SlaveServer']['username'], $vbulletin->config['SlaveServer']['password'], $vbulletin->config['SlaveServer']['usepconnect'], $vbulletin->config['Mysqli']['ini_file'] ); } //else reselect the wordpress db elseif($vbulletin->config['Database']['dbname'] != $wp_db_name){ $this->dbobject->select_db($vbulletin->config['Database']['dbname']); } Thanks again to the previous posters for their suggestions. I didn't end up needing them, but they are appreciated nonetheless. |
![]() |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|