next »

[PsYc0TiC]

I am getting another server together and was wanting to have my multiple B3's access a single database rather than one db per B3.

I think it is as simple as setting the db in theb3.xml but I don't know how that would properly seperate stats for a site like gametracker.

Can someone help me with this?

Thank you in advance

[Miramar]

the solution is already posted here in this forum...

if you cant find it... here is a little hint: check my postings... 

[PsYc0TiC]

tried that but your postings revealed nothing as far as the information I am seeking. Your posts consist of information related to CODx and Echelon.

The information I had previously found related ONLY to Urbanterror said that it cannot be done due to each server assigning different clientid's doesn't make since since if you have all servers linked to one db then no matter what server a player would connect to after the first time, it would or should recognize that there is already a clientid and welcome them.

However I was really wanting to know what needed to be done to allow the database to keep stats per server seperated so gametracker could keep track and Ecshelon when I am ever able to get it working

If you do have a post that explains that... would you please link it for me?

[Miramar]

it doesnt matter which game it is you set it up for...
the function principle is the same...

but if you already know that the urt server is assigning DIFFERENT uids for the same player on different servers this would not work in one single database...

but you can try it on your own... i have posted step-by-step guides already which explain the multiple-b3-on-one-single-db method...

if you dont need xlrstats/chatlogs etc you can set it up much easier...
install the first server... get your superadmin level (!iamgod)
then start the next b3 serverinstance just connecting to the same db...
and see if you are recognized on the 2nd server as superadmin too

if yes: everything ok... project successfull
if not: just forget about it and make a 2nd full db variant for the 2nd server

[PsYc0TiC]

... i have posted step-by-step guides already which explain the multiple-b3-on-one-single-db method...

link please?

[MordyT]

Sorry to interrupt here, but since you wouldn't carry from one server to another (meaning you would have to re-register on each server, due to the URT assigns GUIDs), what would be the point of using one database? Unles you are limited to one DB?

I can tell you the database access will be slower if you have multiple dbs running since they are all writing at the same time.

If you want I can give you step by step, but I am not sure you want this. Let me know...

[Garreth]

I had the same issue about month ago. We were migrating and starting second server, so I did some research and case study to determine if one-database solution would work.
Unfortunately single database would make more mess, than good things. Every server assings different GUIDs (they are created according to the server IP), so every client playing on both servers would be duplicated in the database. Finally, echelon and xlrstats would be messed up terribly.

Better solution is to create separate databases. Slightly more work needs to be done, but all in all it's much easier. Then you can have echelon taking care of multiple servers (like here: http://img7.imageshack.us/img7/4276/obraz16x.jpg ), and you can have separate xlrstats for both servers.