Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

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

Joined
Nov 2, 2012
Messages
18
Reaction score
9
Small tool to easy understand the mu_online_game.world_template.flags column



mesosa - [Release] Legend.mu client & server source code S16 1.1 - RaGEZONE Forums
 
Junior Spellweaver
Joined
Oct 4, 2007
Messages
173
Reaction score
74
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

mesosa - [Release] Legend.mu client & server source code S16 1.1 - RaGEZONE Forums

mesosa - [Release] Legend.mu client & server source code S16 1.1 - RaGEZONE Forums


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
 
Initiate Mage
Joined
Mar 27, 2018
Messages
9
Reaction score
0
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'
 
Skilled Illusionist
Joined
Feb 13, 2004
Messages
351
Reaction score
54
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;
 
Last edited:
Skilled Illusionist
Joined
Feb 13, 2004
Messages
351
Reaction score
54
Re: [Release] Legend.mu client & server source code S16 1.1

metallica Could you share the most updated db please thank you

At this moment I'm using the version of ispyder



check the last prepareStmt


Thanks for let me know I made a dump from my development version instead of the original one. I edited that query
 
Last edited by a moderator:
Initiate Mage
Joined
Sep 14, 2007
Messages
86
Reaction score
85
Someone going another way? I wanna rewrite all to config files, if someone wanna do same, pm me and we can do together.
 
Initiate Mage
Joined
Jun 21, 2009
Messages
5
Reaction score
0
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:



minimap table is correct?

has how to turn off the / auth system?

just set value 0 in column secured in table accounts
 
Elite Diviner
Joined
Sep 9, 2014
Messages
469
Reaction score
497
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:





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

mfP1j9l - [Release] Legend.mu client & server source code S16 1.1 - RaGEZONE Forums

ktxzK6q - [Release] Legend.mu client & server source code S16 1.1 - RaGEZONE Forums
 

Attachments

You must be registered for see attachments list
Initiate Mage
Joined
Jun 21, 2009
Messages
5
Reaction score
0
Re: [Release] Legend.mu client & server source code S16 1.1

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

mfP1j9l - [Release] Legend.mu client & server source code S16 1.1 - RaGEZONE Forums

ktxzK6q - [Release] Legend.mu client & server source code S16 1.1 - RaGEZONE Forums

year, my bad haha
 

Attachments

You must be registered for see attachments list
Initiate Mage
Joined
Aug 23, 2015
Messages
77
Reaction score
46
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 -
- (2) Teleport & Gates -
- 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:

Client Source , use vs2013 same boost:

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

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

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

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

-- (2) Teleport & Gates -
-- Includes all other commits from DimensionGamers/Lgd-Server github

- download link:
- MuClientTools updated until commit:
- Add OZP - 0e37e8cd9b364df5b5474687e6994137141eaecc
- download link:
 
Last edited:
Joined
Nov 2, 2012
Messages
18
Reaction score
9
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.
 
Junior Spellweaver
Joined
Oct 4, 2007
Messages
173
Reaction score
74
Re: [Release] Legend.mu client & server source code S16 1.1

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

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

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

monster and monster_template
Same, testing
 
Last edited:
Junior Spellweaver
Joined
Oct 4, 2007
Messages
173
Reaction score
74
Re: [Release] Legend.mu client & server source code S16 1.1

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



Btw, it's good that peoples share their db data
 
Last edited by a moderator:
Back
Top