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

dns360 · Mar 14, 2021

thanks

ScriptKid · Mar 14, 2021

anyone have the updated file from the source? or any public repo with updated DB?

Thanks!

michi28 · Mar 15, 2021

ScriptKid said:
anyone have the updated file from the source? or any public repo with updated DB?

Thanks!

.....

jpra110 · Mar 15, 2021

Small tool to easy understand the mu_online_game.world_template.flags column

You must be registered to see links

Sam3000 · Mar 15, 2021

jpra110 said:
Sam3000, mesosa commits some changes, and specifically MonsterManger has changed, are you using the latest commit?

I think you are missing something, the '```model' column refers to the bmd skin of the mob (or the mob itself), with the latest schema/code changes.

For example
id, name, model, ....
0, BullFigther, 3 ....
Is actually a Spider because 3 is the internal id of the bmd or something like that. Currently if I change the model for another id I get a diferent mob for the same row

Currently my monster_template > model === id for every row

update: can confirm that is only the skin, not the actual monster
Because the damage it does is the damage defined for the spider

I am not understanding if it is because of the AttackType that is missing at the moment or if there is some problem with agility, the mob hits me 30 times at the same time

Yeah, i got it yesterday, My mobs working ok, but cant find how to set 40 spiders in box...
Normal attack speed and other.
Anyway i will post db updates later and maybe working NPC

LegendaryMu · Mar 15, 2021

How to solved ?

2021-03-15_11:37:11 ERROR In mysql_stmt_prepare() id: 10, sql: "INSERT INTO quest_mu (`ID`, `Name`, `Server`, `Day`, `TemplateType1`, `Chapter`, `Category`, `Importance`, `StartType`, `StartSubType`, `LevelMin`, `LevelMax`, `RepeatCycle`, `PrecedenceQuest`, `StartItemType`, `StartItemIndex`, `CheckGens`, `Zen`, `DarkWizard`, `DarkKnight`, `FairyElf`, `MagicGladiator`, `DarkLord`, `Summoner`, `RageFighter`, `GrowLancer`, `RuneWizard`, `Slayer`, `GunCrusher`, `AddClass1`, `TemplateType2`, `ObjectiveType`, `ObjectiveMainType`, `ObjectiveMainSubType`, `TargetNumber`, `TargetMaxLevel`, `DropRate`, `GateID`, `MapID`, `X`, `Y`, `RewardExperience`, `RewardZen`, `RewardGensPoints`, `RewardItemType01`, `RewardItemIndex01`, `RewardItemCount01`, `RewardItemType02`, `RewardItemIndex02`, `RewardItemCount02`, `RewardItemType03`, `RewardItemIndex03`, `RewardItemCount03`, `RewardType`, `RewardSubType`, `RewardNumber`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"2021-03-15_11:37:11 ERROR Unknown column 'TemplateType1' in 'field list'

metallica · Mar 15, 2021

LegendaryMu said:
How to solved ?

This is because we have two "development" versions of that table, if you use the original source this is the correct dump:

EDIT: Fixed table with original Source

PHP:

DROP TABLE IF EXISTS `quest_mu`;
CREATE TABLE IF NOT EXISTS `quest_mu` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `server` smallint(5) UNSIGNED DEFAULT NULL,
  `day` tinyint(3) UNSIGNED DEFAULT NULL,
  `TemplateType1` tinyint(3) UNSIGNED DEFAULT NULL,
  `chapter` tinyint(3) UNSIGNED DEFAULT NULL,
  `category` tinyint(3) UNSIGNED DEFAULT NULL,
  `importance` tinyint(3) UNSIGNED DEFAULT NULL,
  `StartType` tinyint(3) UNSIGNED DEFAULT NULL,
  `StartSubType` smallint(5) UNSIGNED DEFAULT NULL,
  `LevelMin` smallint(5) UNSIGNED DEFAULT NULL,
  `LevelMax` smallint(5) UNSIGNED DEFAULT NULL,
  `RepeatCycle` tinyint(4) DEFAULT NULL,
  `PrecedenceQuest` smallint(6) DEFAULT NULL,
  `StartItemType` tinyint(4) DEFAULT NULL,
  `StartItemIndex` smallint(6) DEFAULT NULL,
  `CheckGens` tinyint(4) DEFAULT NULL,
  `zen` int(11) DEFAULT NULL,
  `DarkWizard` tinyint(3) UNSIGNED DEFAULT NULL,
  `DarkKnight` tinyint(3) UNSIGNED DEFAULT NULL,
  `FairyElf` tinyint(3) UNSIGNED DEFAULT NULL,
  `MagicGladiator` tinyint(3) UNSIGNED DEFAULT NULL,
  `DarkLord` tinyint(3) UNSIGNED DEFAULT NULL,
  `Summoner` tinyint(3) UNSIGNED DEFAULT NULL,
  `RageFighter` tinyint(3) UNSIGNED DEFAULT NULL,
  `GrowLancer` tinyint(3) UNSIGNED DEFAULT NULL,
  `RuneWizard` tinyint(3) UNSIGNED DEFAULT NULL,
  `Slayer` tinyint(3) UNSIGNED DEFAULT NULL,
  `GunCrusher` tinyint(3) UNSIGNED DEFAULT NULL,
  `AddClass1` tinyint(3) UNSIGNED DEFAULT NULL,
  `TemplateType2` tinyint(3) UNSIGNED DEFAULT NULL,
  `ObjectiveType` tinyint(3) UNSIGNED DEFAULT NULL,
  `ObjectiveMainType` smallint(6) DEFAULT NULL,
  `ObjectiveMainSubType` smallint(6) DEFAULT NULL,
  `TargetNumber` smallint(6) DEFAULT NULL,
  `TargetMaxLevel` smallint(6) DEFAULT NULL,
  `DropRate` smallint(6) DEFAULT NULL,
  `GateID` smallint(5) UNSIGNED DEFAULT NULL,
  `MapID` smallint(5) UNSIGNED DEFAULT NULL,
  `x` smallint(6) DEFAULT NULL,
  `y` smallint(6) DEFAULT NULL,
  `RewardExperience` int(11) DEFAULT NULL,
  `RewardZen` int(11) DEFAULT NULL,
  `RewardGensPoints` tinyint(3) UNSIGNED DEFAULT NULL,
  `RewardItemType01` tinyint(4) DEFAULT NULL,
  `RewardItemIndex01` smallint(6) DEFAULT NULL,
  `RewardItemCount01` smallint(6) DEFAULT NULL,
  `RewardItemType02` tinyint(4) DEFAULT NULL,
  `RewardItemIndex02` smallint(6) DEFAULT NULL,
  `RewardItemCount02` smallint(6) DEFAULT NULL,
  `RewardItemType03` tinyint(4) DEFAULT NULL,
  `RewardItemIndex03` smallint(6) DEFAULT NULL,
  `RewardItemCount03` smallint(6) DEFAULT NULL,
  `RewardType` smallint(6) DEFAULT NULL,
  `RewardSubType` smallint(6) DEFAULT NULL,
  `RewardNumber` smallint(6) DEFAULT NULL,
  `disabled` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

dasgrid · Mar 15, 2021

@metallica Could you share the most updated db please thank you

jpra110 · Mar 15, 2021

metallica said:
This is because we have two "development" versions of that table, if you use the original source this is the correct dump:

check the last prepareStmt

You must be registered to see links

metallica · Mar 15, 2021

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

dasgrid said:
metallica Could you share the most updated db please thank you

At this moment I'm using the version of ispyder

You must be registered to see links

jpra110 said:
check the last prepareStmt

You must be registered to see links

Thanks for let me know I made a dump from my development version instead of the original one. I edited that query

Pyke · Mar 15, 2021

Someone going another way? I wanna rewrite all to config files, if someone wanna do same, pm me and we can do together.

TuanV · Mar 15, 2021

Long time ago. SS16 Oh my god beautiful

dns360 · Mar 16, 2021

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

"move" is working now...

Just register valeus in table world_server.

Link for download:

You must be registered to see links

favgames said:
minimap table is correct?

has how to turn off the / auth system?

just set value 0 in column secured in table accounts

michi28 · Mar 16, 2021

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

dns360 said:
"move" is working now...

Just register valeus in table world_server.

Link for download:
You must be registered to see links

just set value 0 in column secured in table accounts

need add more map 0 to 30.

from maps lorencia, noria, davias, etc...

VALUES (0,0),(0,1),(0,2),(0,3),(0,4),(0,5),(0,6),(0,7),(0,8),(0,9),(0,10),(0,11),(0,12),(0,13),(0,14),(0,15),(0,16),(0,17),(0,18),(0,19),(0,20),(0,21),(0,22),(0,23),(0,24),(0,25),(0,26),(0,27),(0,28),(0,29),(0,30),(0,31),(0,32),(0,33),(0,34),(0,35),(0,36),(0,37),(0,38),(0,39),(0,40),(0,41),(0,42),(0,43),(0,44),(0,45),(0,46),(0,47),(0,48),(0,49),(0,50),(0,51),(0,52),(0,53),(0,54),(0,55),(0,56),(0,57),(0,58),(0,59),(0,60),(0,61),(0,62),(0,63),(0,64),(0,65),(0,66),(0,67),(0,68),(0,69),(0,70),(0,71),(0,72),(0,73),(0,74),(0,75),(0,76),(0,77),(0,78),(0,79),(0,80),(0,81),(0,82),(0,83),(0,84),(0,85),(0,86),(0,87),(0,88),(0,89),(0,90),(0,91),(0,92),(0,93),(0,94),(0,95),(0,96),(0,97),(0,98),(0,99),(0,100),(0,101),(0,102),(0,103),(0,104),(0,105),(0,106),(0,107),(0,108),(0,109),(0,110),(0,111),(0,112),(0,113),(0,114),(0,115),(0,116),(0,117),(0,118),(0,119),(0,120),(0,121),(0,122),(0,123),(0,124),(0,125),(0,126),(0,127),(0,128),(0,129),(0,130),(0,131),(0,132),(0,133),(0,134),(0,135),(0,136),(0,137),(0,138),(0,139),(0,140),(0,141),(0,142),(0,143),(0,144),(0,145),(0,146),(0,147),(0,148),(0,149);

dns360 · Mar 16, 2021

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

michi28 said:
need add more map 0 to 30.

from maps lorencia, noria, davias, etc...

VALUES (0,0),(0,1),(0,2),(0,3),(0,4),(0,5),(0,6),(0,7),(0,8),(0,9),(0,10),(0,11),(0,12),(0,13),(0,14),(0,15),(0,16),(0,17),(0,18),(0,19),(0,20),(0,21),(0,22),(0,23),(0,24),(0,25),(0,26),(0,27),(0,28),(0,29),(0,30),(0,31),(0,32),(0,33),(0,34),(0,35),(0,36),(0,37),(0,38),(0,39),(0,40),(0,41),(0,42),(0,43),(0,44),(0,45),(0,46),(0,47),(0,48),(0,49),(0,50),(0,51),(0,52),(0,53),(0,54),(0,55),(0,56),(0,57),(0,58),(0,59),(0,60),(0,61),(0,62),(0,63),(0,64),(0,65),(0,66),(0,67),(0,68),(0,69),(0,70),(0,71),(0,72),(0,73),(0,74),(0,75),(0,76),(0,77),(0,78),(0,79),(0,80),(0,81),(0,82),(0,83),(0,84),(0,85),(0,86),(0,87),(0,88),(0,89),(0,90),(0,91),(0,92),(0,93),(0,94),(0,95),(0,96),(0,97),(0,98),(0,99),(0,100),(0,101),(0,102),(0,103),(0,104),(0,105),(0,106),(0,107),(0,108),(0,109),(0,110),(0,111),(0,112),(0,113),(0,114),(0,115),(0,116),(0,117),(0,118),(0,119),(0,120),(0,121),(0,122),(0,123),(0,124),(0,125),(0,126),(0,127),(0,128),(0,129),(0,130),(0,131),(0,132),(0,133),(0,134),(0,135),(0,136),(0,137),(0,138),(0,139),(0,140),(0,141),(0,142),(0,143),(0,144),(0,145),(0,146),(0,147),(0,148),(0,149);

year, my bad haha

ispyder · Mar 16, 2021

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 -

You must be registered to see links

- (2) Teleport & Gates -

You must be registered to see links

- 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:

michi28 said:
Source + Boost + Files + DB -> Link:
You must be registered to see links

Client Source , use vs2013 same boost:
You must be registered to see links

(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:

You must be registered to see links

- Use the following script to import the multiple-files of the database:
- download link:

You must be registered to see links

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

- Without commits:
-- (1) Updated Monster Manager & Added base monster databases -

You must be registered to see links

-- (2) Teleport & Gates -

You must be registered to see links

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

- download link:

You must be registered to see links

- MuClientTools updated until commit:
- Add OZP - 0e37e8cd9b364df5b5474687e6994137141eaecc
- download link:

You must be registered to see links

jpra110 · Mar 16, 2021

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 · Mar 17, 2021

Re: [Release] Legend.mu client &amp; server source code S16 1.1

jpra110 said:
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.

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

Btw, some tables:
formula_data.sql

You must be registered to see links

skill_tree

You must be registered to see links

skill_tree from mudev folder, igcn have newest version, will make second dump later

skill_template

You must be registered to see links

Have some problems with it, dont know it working or not

monster and monster_template

You must be registered to see links

Same, testing

Sam3000 · Mar 17, 2021

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

metallica said:
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
Anyway, this step was needed

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

zipelagt · Mar 18, 2021

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

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

Newbie Spellweaver

Am i?

Elite Diviner

Newbie Spellweaver

Junior Spellweaver

Newbie Spellweaver

Skilled Illusionist

Newbie Spellweaver

Newbie Spellweaver

Skilled Illusionist

Newbie Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Elite Diviner

Attachments

Newbie Spellweaver

Attachments

Newbie Spellweaver

Newbie Spellweaver

Junior Spellweaver

Junior Spellweaver

Newbie Spellweaver