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

[ispyder]

There are already multiple and completely different paths for this.

I think there should be a decision going forward if the following commits are needed or not:
- (1) Updated Monster Manager & Added base monster databases - https://github.com/DimensionGamers/L...c95377ac1f2d96
- (2) Teleport & Gates - https://github.com/DimensionGamers/L...de08649a83a41c
- These commits stand in the way of good diffs and hard to track all the different patches

And if some main (or all) settings should be moved to config files: .ini, .xml:

Source + Boost + Files + DB -> Link: https://drive.google.com/file/d/1npz...5zLBUj2Fk/view

Client Source , use vs2013 same boost: https://drive.google.com/file/d/13yt...fhbvoqqNz/view

(I prefer config files. They're easier to track and update than using the database)

Otherwise it will hard to keep all future changes in sync...

Even if everyone goes it's own path with this, at least these simple decisions must be made to have at least the "main" dev pack similar to be able to apply patches and use the same database and main settings.

Edit:

DB updated up to post #258:
- http://forum.ragezone.com/f197/release-legend-mu-client-server-1195391/index18.html#post9071931
- download link: https://www.mediafire.com/file/wv4wh...2-v14.rar/file

- Use the following script to import the multiple-files of the database:
- download link: https://www.mediafire.com/file/101yd...es_v2.rar/file

- GameServer recompiled:
- use original boost::asio::io_service and NOT boost::asio::io_context

- Without commits:
-- (1) Updated Monster Manager & Added base monster databases - https://github.com/DimensionGamers/L...c95377ac1f2d96

-- (2) Teleport & Gates - https://github.com/DimensionGamers/Lgd-Server/commit/793e6e44b008032a8288d822ddde08649a83a41c

-- Includes all other commits from DimensionGamers/Lgd-Server github

- download link: https://www.mediafire.com/file/hbxawc0ckw6les2/GameServer-compiled-2021.03.17-18.53-v2.rar/file


- MuClientTools updated until commit:
- Add OZP - 0e37e8cd9b364df5b5474687e6994137141eaecc
- download link: https://www.mediafire.com/file/xftss...ls-v2.rar/file

[jpra110]

I humbly prefer to stick with config as it is by default, although mysql adds a layer of complexity, and some users will have to read about mysql it also offers many benefits over plain txt, xml or whatever.

Also, if someone decide to go in that direction the source must be updated to handle extraordinary cases such as duplicate ids, etc. (data integrity)

I'm not a fan of mysql but thank goodness it's not mssql either! On the other hand, this configuration offers certain characteristics and it is good to consider them, such as tables with descriptive names, exact columns numbers with exact TYPES and descriptive name, others
(The only really important thing here is the type haha) . The era of 1 invalid typo and the server crash ends at least in the not so distant future when all pk, fk, indexes, etc. are correctly defined.

There are some users who are doing a monumental job in this regard.

[Sam3000]

I humbly prefer to stick with config as it is by default, although mysql adds a layer of complexity, and some users will have to read about mysql it also offers many benefits over plain txt, xml or whatever.

Also, if someone decide to go in that direction the source must be updated to handle extraordinary cases such as duplicate ids, etc. (data integrity)

I'm not a fan of mysql but thank goodness it's not mssql either! On the other hand, this configuration offers certain characteristics and it is good to consider them, such as tables with descriptive names, exact columns numbers with exact TYPES and descriptive name, others
(The only really important thing here is the type haha) . The era of 1 invalid typo and the server crash ends at least in the not so distant future when all pk, fk, indexes, etc. are correctly defined.

There are some users who are doing a monumental job in this regard.

I think mysql better than ini or txt files.
With files you cant fix or change large amount of data. Or change data with conditions or simply reorder columns.
And you still want to output some server data to web.
By having mysql you can easily make web control panel to rule all server data.
With keys db will have consistency, better than files.

ps. hate mssql, 10 years ago (or more) it was so painfull to use.

- - - Updated - - -

I think, i will move EventData to db too, later

- - - Updated - - -

Btw, some tables:
formula_data.sql https://cdn.discordapp.com/attachmen...rmula_data.sql

skill_tree https://cdn.discordapp.com/attachmen...skill_tree.sql
skill_tree from mudev folder, igcn have newest version, will make second dump later

skill_template https://cdn.discordapp.com/attachmen...skill_data.csv
Have some problems with it, dont know it working or not

monster and monster_template https://cdn.discordapp.com/attachmen...57820/mobs.sql
Same, testing

[Sam3000]

I think that last days we progress alot, some guys are working on spots, another on skills, others in NPC/items, anothers trying to start to begining from 0 zero that is also good too!

Personally I'm happy because I could have running vs2013 and now I can compile the source, that for me is a great step for debugging

So I know that is not easy the DB, and I know that are plenty of good coders and developers that was working for years and prefer having all on config files because dont wanna to start from 0, I strongly understand their "frustation" but in another hand if we are going to that direction (at least at this moment) we need to rework all the files, I think that this could be a MOD in a near future when we have a 99% server running and working with all features....anyway if some of you wanna to go with that direction is ok too!, the reason of the Discord is talk also each other to explore all the Alternatives.

Also we need a web. we need maybe some tools etc....there is a lot of work to do xD

Maybe, someday, someone will release client sources :D
Anyway, this step was needed

- - - Updated - - -

Btw, it's good that peoples share their db data

[zipelagt]

editor of the item.bmd Season 15 file to share with me the editor of season 16 does not open it

[VadimashRS]

wz add more column in item bmd and need other editor for bmd files

[metallica]

Original databases UPDATE from mesosa (Thanks!)

Until he update the original repository I just uploaded on my personal one

Buff Template =>https://github.com/huesoamz/Lgd-Serv...f_template.sql

character_base
character_bonus
character_experience_bonus
character_experience_table
character_formula
character_helper
character_item
character_max_level_reward
character_skill
character_specialization
character_stat_fruit

https://github.com/huesoamz/Lgd-Server/blob/main/Databases/Game/game_characters.sql

Admin Command:
for Invisilibity press .cmd 0 (ON/OFF)
for Attack press .cmd 1 (ON/OFF)
for been Attacked press .cmd 2 (ON/OFF)
for allow WHISPER .cmd 3 (ON/OFF)

FULL ADMIN_FLAG => 4194303 (remember set authority=2)

[cinus]

Original databases UPDATE from mesosa (Thanks!)

Until he update the original repository I just on my personal one

Buff Template =>https://github.com/huesoamz/Lgd-Serv...f_template.sql

character_base
character_bonus
character_experience_bonus
character_experience_table
character_formula
character_helper
character_item
character_max_level_reward
character_skill
character_specialization
character_stat_fruit

https://github.com/huesoamz/Lgd-Server/blob/main/Databases/Game/game_characters.sql

Admin Command:
for Invisilibity press .cmd 0 (ON/OFF)
for Attack press .cmd 1 (ON/OFF)
for been Attacked press .cmd 2 (ON/OFF)
for allow WHISPER .cmd 3 (ON/OFF)

FULL ADMIN_FLAG => 4194303 (remember set authority=2)

Thx for update .
I have a question why characters no make any dmg ? only mobs can attack us ?
Thx

[metallica]

Thx for update .
I have a question why characters no make any dmg ? only mobs can attack us ?
Thx

Try to change in settings for all races, for example Character.SMDamageModPVE =>100

[JoniverPH]

Nice release. I'm going back to muonline

[phgkhh]

For this, we must use MySQL instead of Microsoft SQL?

[ispyder]

For this, we must use MySQL instead of Microsoft SQL?

Yes, MySQL should be used.

[metallica]

For this, we must use MySQL instead of Microsoft SQL?

You need at least 5.7.XX (5.7.29, 5.7.31 or 5.7.33) version

Dont uset lower versions

[Sam3000]

You need 5.7.XX (5.7.29, 5.7.31 or 5.7.33) version

Dont uset lower or higher.

Why no higher? High have compbaility, but lower nope.

[rooankesley]

Why no higher? High have compbaility, but lower nope.

exactly, i use last version of community and works perfect to me.