GamersRoost

Use same character table on many maps

29 posts in this topic

I would like to add the ability for my players to have their character data available on multiple servers.

I have a Cherno server for instance, and some players like to switch to my Lingo server and have the same gear/poptabs/respect.

 

Anyone doing this?

P.s. - I have thought about the players getting loot or gear / poptabs on one server then logging on the other for easy play. I'm not sure with my player base currently that would be an issue (Average 9).

 

Thanks!

Share this post


Link to post
Share on other sites

you can make a second server use the same DB, but this includes everything including bases and vehicles and then they spawn on odd positions. i think a sql query run every so often could do what you want, but im a sql noob =D

Share this post


Link to post
Share on other sites
Advertisement

its easy to do, you have to move player, clan to its own DB and then edit the exile.ini for extdb2

2 people like this

Share this post


Link to post
Share on other sites

Posted (edited)

make 2 exile databases, drop the character table from your secondary database. Configure your secondary server to connect to the primary database when it needs to do any character related things using the exile custom code block in the mission file.

 

 

or, better yet (easier expansion for more servers in your 'hive') make 3 exile db's, drop the character table from the primary and secondary dbs; drop everything except the character in the tertiary db. configure both servers to use the the same mission file that has been modified using the exile custom code block to connect to the tertiary db for character related operations. (actually now that I think about it, most of this code you will want in your own custom @exile_server so as to not share your tertiary db password in plaintext inside the mission file)

 

There are also ways to do it right from sql and not have to edit the mission files at all, but that is above my experience, I just know it's possible. (and you might run into issues of writing data when using just sql)

Edited by wasti
1 person likes this

Share this post


Link to post
Share on other sites

Thanks guys.

I will check on the primary key relationship and see what "Required" to get that 3rd central dump going. I may just dump out the character data to a central store on "last logoff time". Ill see what i can figure out.

 

Thanks again guys!

[RESOLVED]

Share this post


Link to post
Share on other sites

You wouldn't want it to take positions though. People would be spawning in some odd places :D

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.