The Mana World Forums

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.)

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)

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.

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.

First off, tmwserv is now manaserv, please use that repository in the future. eAthena is completely separate.

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.

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


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

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.

He very likely found this graphic on wiki.themanaworld.org
http://wiki.themanaworld.org/index.php/ ... oposal.png

lol
check the link.....

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


isnt that manaserv?

That graphic is very old, and out of date.

...like everything in our doc directories

Crush wrote:...like everything in our doc directories

example.mana is fully up to date.

Ha... It really looks very funny...













(^_^)

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

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.