[JocAnis]

hi guys. is it possible to anyhow make cs server connection to two seperate databases?

yesterday i was testing somethng, one plugin was sqlite (paused in plugins.ini with ';' ) and another one was enabled with mysql. But amx is loading only first module (no matter if plugin is enabled/disabled) so i could not work with mysql one, until i removed the first from plugins.ini

thanks in advance

[gabuch2]

Most plugins connect to a remote database with whatever credentials and host are defined in the sql.cfg file, however, plugins may define their own target databases so theoretically (haven't tested it), yes.

[JocAnis]

Im more interested in two databases from different hosts, guess that makes a difference

EDIT: same question for nvault and fvault, if anyone can confirm and tested you can use two different nvaults i would aprecciate

[JocAnis]

if anyone is interested, you can go with 2 sqlite databases on one server, but i tested only with:

#pragma defclasslib sqlx sqlite
#include <sqlx>

would be cool if anyone else can share similar knowledge about databases/saving methods

[HamletEagle]

Originally Posted by JocAnis EDIT: same question for nvault and fvault, if anyone can confirm and tested you can use two different nvaults i would aprecciate

Of course you can use both, why wouldn't you be able to? Is it just because they both have "vault" in their name?

[JocAnis]

i mean, two nvault or two fvault, not 1 nvault + 1 fvault, becase that will work obviously

[HamletEagle]

Still yes. Do you have only one file in your pc? Nope, you don't.

[Bugsy]

You may need to use SQL_SetAffinity() to flip between each. I've never done this personally so not 100% sure about the behavior.

Edit: Disregard, I initially thought you meant the same plugin needed to use different SQL drivers. Separate plugins should have no issue using different SQL drivers.

PHP Code:

SQL_SetAffinity( "sqlite" ); //flip to sqlite database affinity
SQL_Execute( szQuery ); //submit query to sqlite database
SQL_SetAffinity( "mysql" ); //flip back to mysql to allow querying mysql database