[help] 1 login for more than 1 DB

[llbranco 0]

Hi

i will try to explane my doubt

 

i've my "RO-Renewal server" and my forum 'PHPB3'

but i want to serve more games like 'ragnarok old times', 'flyff', 'wow' and probably 'the mana world'

but each game has your own SQL DB and phpbb too

it give me more than 4 registers for each player

 

i know for RO and 'mana world' (maybe) i can make it as sub-server using the same login db and same login server (maybe with same grf and hexed too)

 

how about the other games?
 

can i make a new DB and a new CP to "merge/integrate/generalize" the register?

how to do that? someone can give me one light here, please?

 

i don't know exactly the terms to search 'bout that on search engines

 

 

http://rathena.org/board/topic/86858-help-1-login-for-more-than-1-db/

http://herc.ws/board/topic/2139-help-1-login-for-more-than-1-db/

Edited August 29, 2013 by llbranco

[Mumbles 193]

You can just point your servers to read from the same login database and columns; I don't know anything about private FlyFF, WoW, or Mana World(?) servers, but if they can read plain text or MD5 hashes and be configured to read from specific tables and columns, it should work fine.

[jaBote 438]

I'd keep each database separately, to be honest. What I'd do is making a generalized registration form which asks every necessary thing for all the servers (and maybe select which games they want to play?), then launch the needed queries to each accounting tables in their respective database. This way it'll reduce multiple registration problems.

[llbranco 0]

The Mana World

 - Description -

 

 

The Mana World (TMW) is a serious effort to create an innovative free and open source MMORPG. TMW uses 2D graphics and aims to create a large and diverse interactive world. It is licensed under the GPL, making sure this game can't ever run away from you.

 

The project includes the development of both a client and a server, as well as the development of an online world. At the moment we're making alpha releases of the client, while our server is in early development. The eAthena free software Ragnarok Online server is used until our own server has matured enough to replace it. Once ready, we'll be making releases of our server too so anybody will be free to set up their own server and start building their own online world.

 

 

All the other games can read MD5

and they table login looks similar

 

so, if i make all emulators to read Ragnarok DB

using the same login table,it should works?

if i make a NEW DB, for example "register"

 

on this DB has login table

on this table has all terms needed for all games and phpbb
ID, login, email, sex, last login, pin, real name ...

can i make this table to write this on the other tables or synchronize? how?

 

(sorry for my bad English)