[Release] Legend.mu client & server source code S16 1.1

[metallica]

Well the infraestructure of the Database is insane :P, I dont wanna to imagine the amount of "gigas" on a big server (like mulgd.com)

So at this moment we have 5 databases:

MuDatabase with 82 tables
GameServerDatabase with 176 tables
MuLogDatabase with 20 tables
LoginDatabase with 16 tables
EditorDatabase with 5 tables

I created a Sheet to handle all the info and to realize what is the status of each Database, with credits on each column, please let me know if any of the contributors wanna edit and sendme a inbox.

https://docs.google.com/spreadsheets...it?usp=sharing

I have a doubt if Legend.mu use MySQL or Percona but this could be something maybe regarding performance

[mesosa]

We use MySQL.

Editor database is useless. That was some kind of editor attempt using database but we never finished it.

[Sam3000]

Well the infraestructure of the Database is insane :P, I dont wanna to imagine the amount of "gigas" on a big server (like mulgd.com)

So at this moment we have 5 databases:

MuDatabase with 82 tables
GameServerDatabase with 176 tables
MuLogDatabase with 20 tables
LoginDatabase with 16 tables
EditorDatabase with 5 tables

I created a Sheet to handle all the info and to realize what is the status of each Database, with credits on each column, please let me know if any of the contributors wanna edit and sendme a inbox.

https://docs.google.com/spreadsheets...it?usp=sharing

I have a doubt if Legend.mu use MySQL or Percona but this could be something maybe regarding performance

Done 70 tables from game db.
Updated other.
Later will upload

- - - Updated - - -

database.zip
Updates and 70-80 tables from game

- - - Updated - - -
@mesosa, i cant find scheme for mix_template in game db
It's unused?

[VadimashRS]

Bro i see mix in MixHandler.cpp


P.S.
если ты про миксы хаос машины

[ftewegw1]

If I were to work on this project, I would refactor the db architecture. Server configuration can be done in many other ways, I don't see why one would introduce such a big complexity in a project like this. Even if I had the db to begin with, that is.

[metallica]

Bro i see mix in MixHandler.cpp


P.S.
если ты про миксы хаос машины

I didn't see too, not even in MixHandler.cpp

[Mulegend]

mix_template is a obsolete table

[synth3r]

mix_template is a obsolete table

hello Javier and mesosa, thanks for your release
could you please think again about release game configurations?

[Sam Han]

Mulegend, thank you reply.

you could post the S15 to keep track of the variations and differences and of course it would also allow the community to create s15 servers.
clear as long as it doesn't affect your business and you don't use the files anymore.

[Sam3000]

Quest_mu_s16 and muun_s16 is missing in code.
Back to schemas
@synth3r we can get settings from code, i think most of the problem will be some tables...
@Mulegend thx for help, anyway if you can, share some hard to get data, other data i think we can reproduce.

PS looking for s15 or s14 data folder without customs

- - - Updated - - -

Settings in GameServer.cpp

[geverton]

@Sam3000

I don't know if this is exactly what you need,but here are the files in the Data folder.
IGCN Season 16 Part 1
Mu Devs Season 16 Part 1
And the date of the Webzen Kor archives for season 12.

https://drive.google.com/drive/folde...Fh0YZMfMED7_uW

[ScriptKid]

Goodluck everyone and thanks @mesosa for the release. Big teams like IGCN will surely take a good at this one.

Cheers!

[Sam3000]

zip deleted, check last my post
Added all schema from game db. 170 in final

But missing some tables in code:
monster_original
event_labyrinth_region
mix_template
muun_s16
quest_mu_s16
world_random_pvp

Didnt filld any data or indexes
Maybe have some typo, i dunno.
Maybe some columns need to be renamed

- - - Updated - - -

Didnt tried to run gameserver

[mesosa]

game.zip
Added all schema from game db. 170 in final

But missing some tables in code:
monster_original
event_labyrinth_region
mix_template
muun_s16
quest_mu_s16
world_random_pvp

Didnt filld any data or indexes
Maybe have some typo, i dunno.
Maybe some columns need to be renamed

- - - Updated - - -

Didnt tried to run gameserver

If you can't find those tables on source code, then it means they don't exist. Some tables were just backups or old.

[Sam3000]

If you can't find those tables on source code, then it means they don't exist. Some tables were just backups or old.

I figured it out, but anyway thx for answer

Btw, gameserver crash with empty config