mana DB specs (?)

Content and general development discussion, including maps, quests, and server code from the development team.
Post Reply
User avatar
iceslice
Novice
Novice
Posts: 266
Joined: Mon Nov 16, 2009 9:39 pm
Location: MilkyWay

mana DB specs (?)

Post by iceslice » Tue Apr 13, 2010 10:39 pm

Some points to the current specs available from manaserv's git repository.....

There's a one-to-many relation between tmw_characters & tmw_guild_members table. So, a character can join multiple parties/guilds and vice versa ?
And since all the chars of an account have same gender, couldnt "gender" attribute/field be placed in "tmw_accounts" table rather than "tmw_characters" table ? (to reduce redundancy)

Well, the name "tmw_inventories" seems misleading. One-to-many relation telling that a char will have multiple inventories which is not. Instead have multiple items or slots. So "tmw_inventories" could rather be "tmw_charitems" or "tmw_charslots".

And where's table for storage, bank ? how's that implemented?

(Assuming the attached DataBase specification is applicable for both mana & tmw since table names do hold "tmw". And would be grateful if someone clarifies manaserv's feature intention.)
Attachments
database_specification_.png
DB specs
database_specification_.png (80.29 KiB) Viewed 1308 times
Lets Chase MDGs...

ManaPortable (Vanilla Mana + ManaPlus) -- run 'em portably

http://manaportable.1sourceplus.com
http://manamac.1sourceplus.com
Game Server >> jadu.1sourceplus.org , jadu.1sourceplus.com

User avatar
Bertram
Knight
Knight
Posts: 1026
Joined: Tue Sep 07, 2004 3:55 pm
Location: France

Re: mana DB specs (?)

Post by Bertram » Tue Apr 13, 2010 10:49 pm

Hi,
And since all the chars of an account have same gender, couldnt "gender" attribute/field be placed in "tmw_accounts" table rather than "tmw_characters" table ? (to reduce redundancy)
:arrow: What ?!? That's false!! Each character in an account can have its own gender (I just tested it) and I can't see why it shouldn't be that way.

About the rest, you should maybe also ask bjorn or exceptionFault about it.

Regards.
User avatar
enchilado
Warrior
Warrior
Posts: 972
Joined: Fri Mar 06, 2009 2:21 am
Location: evermore a GUY

Re: mana DB specs (?)

Post by enchilado » Tue Apr 13, 2010 11:32 pm

iceslice wrote:And since all the chars of an account have same gender, couldnt "gender" attribute/field be placed in "tmw_accounts" table rather than "tmw_characters" table ? (to reduce redundancy)
All chars of an eAthena account must have the same gender.
Bertram wrote: What ?!? That's false!! Each character in an account can have its own gender (I just tested it) and I can't see why it shouldn't be that way.
Seems it's not so on manaserv.
User avatar
Jaxad0127
TMW Adviser
TMW Adviser
Posts: 4209
Joined: Thu Nov 01, 2007 6:35 pm
Location: Internet

Re: mana DB specs (?)

Post by Jaxad0127 » Wed Apr 14, 2010 5:36 am

First off, tmwserv is now manaserv, please use that repository in the future. eAthena is completely separate.
Image
User avatar
Crush
TMW Adviser
TMW Adviser
Posts: 8046
Joined: Thu Aug 25, 2005 5:08 pm
Location: Germany

Re: mana DB specs (?)

Post by Crush » Wed Apr 14, 2010 9:26 am

There's a one-to-many relation between tmw_characters & tmw_guild_members table. So, a character can join multiple parties/guilds and vice versa ?

Yes. On Manaserv you can be in multiple guilds at the same time. How this will affect guild wars has not been determined yet, but I think we will force people to choose one side and abandon the other when two guilds they are member of declare war on each other.

Being in multiple parties is supressed on the application layer, afaik.

Well, the name "tmw_inventories" seems misleading. One-to-many relation telling that a char will have multiple inventories which is not.

A character can indeed have multiple inventories. The inventory on the character and the item storage are already two. I could also imagine other persistent item containers which work like an inventory and aren't related to any character. Guild storages or other shared storages, for example.

But this is also still under construction.
  • former Manasource Programmer
  • former TMW Pixel artist
  • NOT a game master

Please do not send me any inquiries regarding player accounts on TMW.


You might have heard a certain rumor about me. This rumor is completely false. You might also have heard the other rumor about me. This rumor is 100% accurate.
User avatar
iceslice
Novice
Novice
Posts: 266
Joined: Mon Nov 16, 2009 9:39 pm
Location: MilkyWay

Re: mana DB specs (?)

Post by iceslice » Thu Apr 15, 2010 12:32 am

Thanks, making sense but storage mechanism still confusing to me =/


edit: I got the specification from manaserv. neither from tmwserv nor original eA
Lets Chase MDGs...

ManaPortable (Vanilla Mana + ManaPlus) -- run 'em portably

http://manaportable.1sourceplus.com
http://manamac.1sourceplus.com
Game Server >> jadu.1sourceplus.org , jadu.1sourceplus.com

User avatar
Jaxad0127
TMW Adviser
TMW Adviser
Posts: 4209
Joined: Thu Nov 01, 2007 6:35 pm
Location: Internet

Re: mana DB specs (?)

Post by Jaxad0127 » Thu Apr 15, 2010 5:55 am

iceslice wrote:Thanks, making sense but storage mechanism still confusing to me =/


edit: I got the specification from manaserv. neither from tmwserv nor original eA
Then where are you getting tables prefixed with "tmw"? My local repository only has "mana" prefixes. There have been changes since the prefixes were updated, so it would help if you used the latest.
Image
User avatar
Crush
TMW Adviser
TMW Adviser
Posts: 8046
Joined: Thu Aug 25, 2005 5:08 pm
Location: Germany

Re: mana DB specs (?)

Post by Crush » Thu Apr 15, 2010 8:01 am

He very likely found this graphic on wiki.themanaworld.org
http://wiki.themanaworld.org/index.php/ ... oposal.png
  • former Manasource Programmer
  • former TMW Pixel artist
  • NOT a game master

Please do not send me any inquiries regarding player accounts on TMW.


You might have heard a certain rumor about me. This rumor is completely false. You might also have heard the other rumor about me. This rumor is 100% accurate.
User avatar
iceslice
Novice
Novice
Posts: 266
Joined: Mon Nov 16, 2009 9:39 pm
Location: MilkyWay

Re: mana DB specs (?)

Post by iceslice » Thu Apr 15, 2010 8:32 am

lol
check the link.....

http://gitorious.com/mana/manaserv/blob ... cation.png


isnt that manaserv?
Lets Chase MDGs...

ManaPortable (Vanilla Mana + ManaPlus) -- run 'em portably

http://manaportable.1sourceplus.com
http://manamac.1sourceplus.com
Game Server >> jadu.1sourceplus.org , jadu.1sourceplus.com

User avatar
Jaxad0127
TMW Adviser
TMW Adviser
Posts: 4209
Joined: Thu Nov 01, 2007 6:35 pm
Location: Internet

Re: mana DB specs (?)

Post by Jaxad0127 » Thu Apr 15, 2010 3:02 pm

That graphic is very old, and out of date.
Image
User avatar
Crush
TMW Adviser
TMW Adviser
Posts: 8046
Joined: Thu Aug 25, 2005 5:08 pm
Location: Germany

Re: mana DB specs (?)

Post by Crush » Thu Apr 15, 2010 7:21 pm

...like everything in our doc directories ;)
  • former Manasource Programmer
  • former TMW Pixel artist
  • NOT a game master

Please do not send me any inquiries regarding player accounts on TMW.


You might have heard a certain rumor about me. This rumor is completely false. You might also have heard the other rumor about me. This rumor is 100% accurate.
User avatar
Jaxad0127
TMW Adviser
TMW Adviser
Posts: 4209
Joined: Thu Nov 01, 2007 6:35 pm
Location: Internet

Re: mana DB specs (?)

Post by Jaxad0127 » Thu Apr 15, 2010 8:42 pm

Crush wrote:...like everything in our doc directories ;)
example.mana is fully up to date. ;-) :-P
Image
User avatar
Dark_Mag
Novice
Novice
Posts: 347
Joined: Fri Dec 18, 2009 9:14 pm
Contact:

Re: mana DB specs (?)

Post by Dark_Mag » Sun Apr 18, 2010 2:33 am

Ha... It really looks very funny... :lol:













(^_^)
Image
Image
User avatar
iceslice
Novice
Novice
Posts: 266
Joined: Mon Nov 16, 2009 9:39 pm
Location: MilkyWay

Re: mana DB specs (?)

Post by iceslice » Sun Apr 18, 2010 11:29 am

anyone knows if our existing accounts/characters with items will be lost on switching to the new manaserv from tmwserv?
Lets Chase MDGs...

ManaPortable (Vanilla Mana + ManaPlus) -- run 'em portably

http://manaportable.1sourceplus.com
http://manamac.1sourceplus.com
Game Server >> jadu.1sourceplus.org , jadu.1sourceplus.com

User avatar
Crush
TMW Adviser
TMW Adviser
Posts: 8046
Joined: Thu Aug 25, 2005 5:08 pm
Location: Germany

Re: mana DB specs (?)

Post by Crush » Sun Apr 18, 2010 12:00 pm

The game systems are fundamentally different. There is just no way to convert characters or items from the eAthena system to the Manaserv system.

Besides it would not really be fun. The first Manaserv content release will have content for levels 1-20. You wouldn't find anything meaningful to do with an 80+ character anyway.
  • former Manasource Programmer
  • former TMW Pixel artist
  • NOT a game master

Please do not send me any inquiries regarding player accounts on TMW.


You might have heard a certain rumor about me. This rumor is completely false. You might also have heard the other rumor about me. This rumor is 100% accurate.
Post Reply