Jump to content
  • 0
Sign in to follow this  
llbranco

[help] 1 login for more than 1 DB

Question

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

 

Edited by llbranco

Share this post


Link to post
Share on other sites

3 answers to this question

Recommended Posts

  • 0

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.

Share this post


Link to post
Share on other sites
  • 0

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.

Share this post


Link to post
Share on other sites
  • 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)

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.