Forum :: Lounge :: Database sharing

I think realms having separate characters would basically defeat the purpose of sharing a database

Not really because they would use the same username and password yet all server pubs ect can be different

---
I am an alien and not crazy!

goddamn pubs

Wait let me think about this....

Without a custom server how would you go about only getting the characters to that one server and not global? To share the database the only way I can think of is all servers using the same maps and pubs andthey distribute an independent application so that you can choose a server using that database.

The other problem will be knowing what servers use your database so that they choose the correct one.

It's a good idea but the best way to my opinion will be a custom relay server and even that may not work.

Try drawing a graph on how the servers and clients will work with the database and this way you'll find out if it's possible.

I shall work on a graph tomorrow as I'm off to bed now.

Night all and good luck with this as it's the most secure way of account privacy.

Edit: Here is a quick put together. I cant see any way of doing it without a custom server so hope this helps you.

---
I am an alien and not crazy!

I will do what I can to dryhump this idea into possibility land.

 Yep. found a problem already. Can login to two servers at once. doesnt seem too awful, but that could get sticky.

I was yup half the night with a notepad and pen and fell asleep with the dam pen in my hand.

I came up with nothing. I was lying there pointing fingers into the air and saying Client to Server, Server to Database. What about a relay. All sorts of shit was going on in my mind and yet still everything led back to needing a custom client and server so we know what server we wish to play on with the accounts but different characters, maps and pubs.

---
I am an alien and not crazy!

I haven't thought this though much, but would a system like this work?

Instead of storing all the information on one central database, the character info is still stored on a local database.It doesn't enable you to  have universal characters (I don'tthink that would be a good idea anyway, and it's imposable because of differing pub files) , but It would stop your user name and password being stolenby untrusted servers. 

edit: Unfortunately I still can't figure out how all this would work with the current client. The only way would to be have a custom launcher application, that changed the config to the selectedserver, and the ingame login is bypassed (like in MEOW)

Then the master server would just need to send the computer IP along with the username so when the player connects the server knows which username the computer is currently associated with.

Also, to prevent hacking, the password should only be able to be changed using the custom launcher.

I hope that's all understandable. As I said before I haven't thought through this properly so there are probably a lot of problems with it, but it's a start.

Yea it would work but only if we have a custom Client and Server. You must be able to choose what server you wish to play from the Client no matter what. No custom client no way this can work :(

---
I am an alien and not crazy!

I just edited my post above to show how It would work with a launcher, it's not Ideal but it might work.

It's a long shot to see if that is possible. With that way you'd still need a custom Server for people to use :P

---
I am an alien and not crazy!

i have seen what you guys are talking about, and i am doing something like this at home. it be nice to have  a globle eo, just based on maps and game play. i run 4 eoservers from one data base.   all on a differant computer, doing something like this. theproblemi have found is dupeng of items and gold for one. i can log on two differant servers with the same account info from my data base,  on server "a" i drop 1 k gold on the ground, i go to the screen with  on server "b" and save. i then go back to server "a" and relog i now have 1k gold in myinv and 1k gold on the ground. i repeated this a few times and had 20k realy fast.

#1 i figured i would have to code in something in the server and add a colom into the database like 1=loged in and 0=not loged in, to keep the same account from being loged in at the same time.

#2 part A .... the main thing i would see from a few servers useng the same database would be the honor system. we would have to hard code the exp rate and the database user and password into the server to start. and then theres the pub files!!!. you are going to getthe lil kiddy's who would jack off thestats, on weps, and exp on npc's or what ever.

part B ... you think it be possible to add or have the server read item stats and npc stats from the database just like it does for player stats and even completed quests. and so on. but it might be possible to access pubs over the net, from a central location. but eventhenyou got the fact lil kids be doing the 30 sheep on a map, instant respawning. to cheat stats and exp..would def need globle admins, and truster server hosts.

i think it could be a nice project for a globle server system for a few select servers, going to differant servers for differant items,crafting ing, quests, and alot of other stuff.

and as for a custom client, a central connecting place that redirects "kinda like no-ip" that redirects the connection ip , but is based on the database relm saved on disconnection to what its saved to like the quest state,, based on what relm you click to go to from the server, but disconnection has to be done to do server swops, but seem alot simpler to just simple typr the new ip, or a lancher. to differant relm. 

---
Think Outside The Box.

..............Skids in my Undies........
...............Cut And Paste............

Make them only allowed to be logged into one server at a time.

---
Andrewbob - I would be on the fucking copter of rofls

Programmer, Web Developer, and Graphics Designer

im thinking if you  take the logged in check out  of the servers had it check the database if you were logged in or not. like logged in will be 1 or 0 and when you disconnect it has to set to 0

Couldn't you just make a program that you would run before the EO client. It would ask them what server you want to play on then change the ip configuration and start the client. (like EOLAUNCH). 

---
Love you too.

Or could you just make a website that players could register their accounts with their passwords, and then when the play logs into a server, and if the data for the account isn't there, have it look for it in the website data. But if the account data is already there, you don't have to have the server look it up..

---
Create your own destiny, don't let someone else do it for you.