Help 2 Different Sw In 1 Db

[delamis]

Hi,

 

I just want to learn. How can i make 2 different server in one db?

For example;

Sw 1 : 150x no customs, different drop rates, etc etc

Sw 2: 150000x 5 custom sets, etc etc.

Thnx.

 

Edit: I'm using L2jFrozen (interlude) atm. but it is changin with projects? i think there is only one way to doin it, thats why i didnt wrote project :)

Edited October 2, 2015 by delamis

[Solomun]

Feel free to let us know your client/project you use...:P

[delamis]

Feel free to let us know your client/project you use... :P

Sorry, edited :)

[*real*savormix]

Just create two differently named schemas and adjust the jdbc url(s) in config files.

Or are you asking for something else?

[DrenepiaWorld]

you can "Copy" you gameserver folder and rename it to gameserver2 for example, and you can set the one server as you want and the other one with different features but the login will be the same.

but you will need 2 databases in order to avoid problems.

[*real*savormix]

but you will need 2 databases in order to avoid problems.

No. Just no.

 

Most people around here use MySQL, which only supports a single hardcoded DB (check information_schema*).

Even 'CREATE DATABASE' is implemented as an alias to 'CREATE SCHEMA'. In MySQL, no database is ever created in addition to the hardcoded one.

 

 

* - SQL92 specifies that 'table_catalog' contains the database name for the table:

SELECT table_catalog, table_name FROM information_schema.tables

Edited October 3, 2015 by _dev_

[DrenepiaWorld]

No. Just no.

 

Most people around here use MySQL, which only supports a single hardcoded DB (check information_schema*).

Even 'CREATE DATABASE' is implemented as an alias to 'CREATE SCHEMA'. In MySQL, no database is ever created in addition to the hardcoded one.

 

 

* - SQL92 specifies that 'table_catalog' contains the database name for the table:

SELECT table_catalog, table_name FROM information_schema.tables

i never did this, but i remember in the past (2k12) one friend of me did the same with packs (but i'm not sure about the db)