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: 16 Nov 2009, 21:39
Location: MilkyWay

mana DB specs (?)

Post by iceslice » 13 Apr 2010, 22:39

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 1403 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: 07 Sep 2004, 15:55
Location: France

Re: mana DB specs (?)

Post by Bertram » 13 Apr 2010, 22:49

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: 06 Mar 2009, 02:21
Location: evermore a GUY

Re: mana DB specs (?)

Post by enchilado » 13 Apr 2010, 23:32

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: 01 Nov 2007, 18:35
Location: Internet

Re: mana DB specs (?)

Post by Jaxad0127 » 14 Apr 2010, 05:36

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: 25 Aug 2005, 17:08
Location: Germany

Re: mana DB specs (?)

Post by Crush » 14 Apr 2010, 09:26

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: 16 Nov 2009, 21:39
Location: MilkyWay

Re: mana DB specs (?)

Post by iceslice » 15 Apr 2010, 00:32

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: 01 Nov 2007, 18:35
Location: Internet

Re: mana DB specs (?)

Post by Jaxad0127 » 15 Apr 2010, 05:55

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: 25 Aug 2005, 17:08
Location: Germany

Re: mana DB specs (?)

Post by Crush » 15 Apr 2010, 08:01

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: 16 Nov 2009, 21:39
Location: MilkyWay

Re: mana DB specs (?)

Post by iceslice » 15 Apr 2010, 08:32

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: 01 Nov 2007, 18:35
Location: Internet

Re: mana DB specs (?)

Post by Jaxad0127 » 15 Apr 2010, 15:02

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

Re: mana DB specs (?)

Post by Crush » 15 Apr 2010, 19:21

...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: 01 Nov 2007, 18:35
Location: Internet

Re: mana DB specs (?)

Post by Jaxad0127 » 15 Apr 2010, 20:42

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: 18 Dec 2009, 21:14
Contact:

Re: mana DB specs (?)

Post by Dark_Mag » 18 Apr 2010, 02:33

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













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

Re: mana DB specs (?)

Post by iceslice » 18 Apr 2010, 11:29

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: 25 Aug 2005, 17:08
Location: Germany

Re: mana DB specs (?)

Post by Crush » 18 Apr 2010, 12:00

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