TalkPHP - View Single Post - Question | There is a way to make merged login config.php?? (MSSQL+MySQL)

FrozenGod · 11-03-2009, 07:07 PM

Like i asked in the title, there is a way to make 1 config thad will connect to both MySQL and MSSQL2000??
Like:

PHP Code:


			
    //    ****** 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:

PHP Code:


			
// 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.

Thanks,
David.

11-03-2009, 07:07 PM	#1 (permalink)
FrozenGod The Visitor Join Date: Nov 2009 Posts: 3 Thanks: 0	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?? Like: PHP Code: // **** 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: PHP Code: `// 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. Thanks, David.