||11-03-2009 07:07 PM
Question | There is a way to make merged login config.php?? (MSSQL+MySQL)
Like i asked in the title, there is a way to make 1 config thad will connect to both MySQL and MSSQL2000??
// ****** DATABASE TYPE ******
// This is the type of the database server on which your vBulletin database will be located.
// Valid options are mysql and mysqli, for slave support add _slave. Try to use mysqli if you are using PHP 5 and MySQL 4.1+
// for slave options just append _slave to your preferred database type.
$config['Database']['dbtype'] = 'mysql';
// ****** DATABASE NAME ******
// This is the name of the database where your vBulletin will be located.
// This must be created by your webhost.
$config['Database']['dbname'] = 'dbname';
// ****** TABLE PREFIX ******
// Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = 'main';
// ****** TECHNICAL EMAIL ADDRESS ******
// If any database errors occur, they will be emailed to the address specified here.
// Leave this blank to not send any emails when there is a database error.
$config['Database']['technicalemail'] = 'email';
// ****** FORCE EMPTY SQL MODE ******
// New versions of MySQL (4.1+) have introduced some behaviors that are
// incompatible with vBulletin. Setting this value to "true" disables those
// behaviors. You only need to modify this value if vBulletin recommends it.
$config['Database']['force_sql_mode'] = false;
// ****** MASTER DATABASE SERVER NAME AND PORT ******
// This is the hostname or IP address and port of the database server.
// If you are unsure of what to put here, leave the default values.
$config['MasterServer']['servername'] = 'localhost';
$config['MasterServer']['port'] = 3306;
// ****** MASTER DATABASE USERNAME & PASSWORD ******
// This is the username and password you use to access MySQL.
// These must be obtained through your webhost.
$config['MasterServer']['username'] = 'usename';
$config['MasterServer']['password'] = 'pass';
// ****** MASTER DATABASE PERSISTENT CONNECTIONS ******
// This option allows you to turn persistent connections to MySQL on or off.
// The difference in performance is negligible for all but the largest boards.
// If you are unsure what this should be, leave it off. (0 = off; 1 = on)
$config['MasterServer']['usepconnect'] = 0;
Merge it with thad one:
// MSSQL Database Info
$mssql = array(
'host' => "localhost",
'user' => "sa",
'pass' => "server"
I want thad there will be a page thad able to read from vBulletin's tables and write into MSSQL tables on my dedi server.
I am more familiar with MySQL than MSSQL but I have dabbled in several databases in PHP. So what I do know is that you can connect to multiple MySQL databases by using the link_identifier parameter in the mysql_query() function and it appears that mssql_query() has a link_identifier parameter as well.
Now the technique that vBulliten is using is a bit more complex and so here I will just give a simplified example
$location = 'localhost';
$database = 'mydb';
$username = 'userid';
$password = 'userpass';
$open_db = mysql_connect($location, $username, $password);
if (!$open_db) die ('Could not connect MySQL');
mysql_select_db($database, $open_db) or die ('Could not open database');
$qry = "
$results = mysql_query($qry, $open_db) or die(mysql_error());
In the above example note the use of "$open_db" variable in the mysql_query function.
|All times are GMT. The time now is 11:56 PM.
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0