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

@jpra110 lol I was setting that MAX but only the Strengh just for test, I didnt realize that never work if you dont add that settings for ALL stats..now is working, thanks

Fixed adding points :

PHP Code:

---

INSERT INTO `settings` (`server_id`, `key`, `value`) VALUES ('0', 'Character.MaxAgility', '10000'), ('0', 'Character.MaxEnergy', '10000'), ('0', 'Character.MaxLeadership', '10000'), ('0', 'Character.MaxStrength', '10000'), ('0', 'Character.MaxVitality', '10000') 


---

Level settings:

PHP Code:

---

INSERT INTO `settings` (`server_id`, `key`, `value`) VALUES ('0', 'Character.MaxLevelMajestic', '400'), ('0', 'Character.MaxLevelMaster', '400'), ('0', 'Character.MaxLevelNormal', '400') 


---

Fixed trade (at least with zen, I couldnt test with items yet):

PHP Code:

---

INSERT INTO `settings` (`server_id`, `key`, `value`) VALUES ('0', 'Character.MaxZen', '1999999999') 


---

Server Online Stability: 12hours without crash with 2 online

@jpra110 not work add monster crash add server code "0" instanced
https://image.prntscr.com/image/0cjy...aVD6WBr3-w.png

Some index, fk updates

uniq constraint: duplicate seetting for the same server

Code:

---

ALTER TABLE `mu_online_game`.`settings`
ADD UNIQUE INDEX `uniq_setting_server` (`key` ASC, `server_id` ASC);
;

---

Code:

---

ALTER TABLE `mu_online_game`.`monster`
ADD CONSTRAINT `server_fk`
  FOREIGN KEY (`server`)
  REFERENCES `mu_online_login`.`server_list` (`server`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION,
ADD CONSTRAINT `monster_template_fk`
  FOREIGN KEY (`id`)
  REFERENCES `mu_online_game`.`monster_template` (`id`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION,
ADD CONSTRAINT `world_fk`
  FOREIGN KEY (`world`)
  REFERENCES `mu_online_game`.`world_template` (`entry`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION

---

uniq constraint: duplicate world for the same server, and world fks

Code:

---

ALTER TABLE `mu_online_login`.`world_server`
ADD INDEX `server_fk_idx` (`server` ASC),
ADD INDEX `world_fk_idx` (`world` ASC),
ADD UNIQUE INDEX `server_unique_world` (`world` ASC, `server` ASC);
;
ALTER TABLE `mu_online_login`.`world_server`
ADD CONSTRAINT `server_fk`
  FOREIGN KEY (`server`)
  REFERENCES `mu_online_login`.`server_list` (`server`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION,
ADD CONSTRAINT `world_fk`
  FOREIGN KEY (`world`)
  REFERENCES `mu_online_game`.`world_template` (`entry`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;

---

uniq constraint: duplicate character name

Code:

---

ALTER TABLE `mu_online_login`.`accounts`
ADD UNIQUE INDEX `unique` (`account` ASC);

---

character fk

Code:

---

ALTER TABLE `mu_online_characters`.`character_info`
ADD INDEX `account_fk_idx` (`account_id` ASC),
ADD UNIQUE INDEX `unique_name` (`name` ASC),
ADD INDEX `world_fk_idx` (`world` ASC);
;
ALTER TABLE `mu_online_characters`.`character_info`
ADD CONSTRAINT `account_fk`
  FOREIGN KEY (`account_id`)
  REFERENCES `mu_online_login`.`accounts` (`guid`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION,
ADD CONSTRAINT `world_fk`
  FOREIGN KEY (`world`)
  REFERENCES `mu_online_game`.`world_template` (`entry`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;

---

working on
mu_online_game.monster.respawn_id fk reference ??
monster.type ===> monster soul data ===> table monster_soul_converter

Some index, fk updates

uniq constraint: duplicate seetting for the same server

Code:

---

ALTER TABLE `mu_online_game`.`settings`
ADD UNIQUE INDEX `uniq_setting_server` (`key` ASC, `server_id` ASC);
;

---

Code:

---

ALTER TABLE `mu_online_game`.`monster`
ADD CONSTRAINT `server_fk`
  FOREIGN KEY (`server`)
  REFERENCES `mu_online_login`.`server_list` (`server`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION,
ADD CONSTRAINT `monster_template_fk`
  FOREIGN KEY (`id`)
  REFERENCES `mu_online_game`.`monster_template` (`id`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION,
ADD CONSTRAINT `world_fk`
  FOREIGN KEY (`world`)
  REFERENCES `mu_online_game`.`world_template` (`entry`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION

---

uniq constraint: duplicate world for the same server, and world fks

Code:

---

ALTER TABLE `mu_online_login`.`world_server`
ADD INDEX `server_fk_idx` (`server` ASC),
ADD INDEX `world_fk_idx` (`world` ASC),
ADD UNIQUE INDEX `server_unique_world` (`world` ASC, `server` ASC);
;
ALTER TABLE `mu_online_login`.`world_server`
ADD CONSTRAINT `server_fk`
  FOREIGN KEY (`server`)
  REFERENCES `mu_online_login`.`server_list` (`server`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION,
ADD CONSTRAINT `world_fk`
  FOREIGN KEY (`world`)
  REFERENCES `mu_online_game`.`world_template` (`entry`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;

---

uniq constraint: duplicate character name

Code:

---

ALTER TABLE `mu_online_login`.`accounts`
ADD UNIQUE INDEX `unique` (`account` ASC);

---

character fk

Code:

---

ALTER TABLE `mu_online_characters`.`character_info`
ADD INDEX `account_fk_idx` (`account_id` ASC),
ADD UNIQUE INDEX `unique_name` (`name` ASC),
ADD INDEX `world_fk_idx` (`world` ASC);
;
ALTER TABLE `mu_online_characters`.`character_info`
ADD CONSTRAINT `account_fk`
  FOREIGN KEY (`account_id`)
  REFERENCES `mu_online_login`.`accounts` (`guid`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION,
ADD CONSTRAINT `world_fk`
  FOREIGN KEY (`world`)
  REFERENCES `mu_online_game`.`world_template` (`entry`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;

---

working on
mu_online_game.monster.respawn_id fk reference ??
monster.type ===> monster soul data ===> table monster_soul_converter

Quote:

---

Originally Posted by dezner

@jpra110 not work add monster crash add server code "0" instanced
https://image.prntscr.com/image/0cjy...aVD6WBr3-w.png

---

try this

https://i.ibb.co/X4Lw3nt/monster.png

Some index, fk updates

uniq constraint: duplicate seetting for the same server

Code:

---

ALTER TABLE `mu_online_game`.`settings`
ADD UNIQUE INDEX `uniq_setting_server` (`key` ASC, `server_id` ASC);
;

---

Code:

---

ALTER TABLE `mu_online_game`.`monster`
ADD CONSTRAINT `server_fk`
  FOREIGN KEY (`server`)
  REFERENCES `mu_online_login`.`server_list` (`server`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION,
ADD CONSTRAINT `monster_template_fk`
  FOREIGN KEY (`id`)
  REFERENCES `mu_online_game`.`monster_template` (`id`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION,
ADD CONSTRAINT `world_fk`
  FOREIGN KEY (`world`)
  REFERENCES `mu_online_game`.`world_template` (`entry`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION

---

uniq constraint: duplicate world for the same server, and world fks

Code:

---

ALTER TABLE `mu_online_login`.`world_server`
ADD INDEX `server_fk_idx` (`server` ASC),
ADD INDEX `world_fk_idx` (`world` ASC),
ADD UNIQUE INDEX `server_unique_world` (`world` ASC, `server` ASC);
;
ALTER TABLE `mu_online_login`.`world_server`
ADD CONSTRAINT `server_fk`
  FOREIGN KEY (`server`)
  REFERENCES `mu_online_login`.`server_list` (`server`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION,
ADD CONSTRAINT `world_fk`
  FOREIGN KEY (`world`)
  REFERENCES `mu_online_game`.`world_template` (`entry`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;

---

uniq constraint: duplicate character name

Code:

---

ALTER TABLE `mu_online_login`.`accounts`
ADD UNIQUE INDEX `unique` (`account` ASC);

---

character fk

Code:

---

ALTER TABLE `mu_online_characters`.`character_info`
ADD INDEX `account_fk_idx` (`account_id` ASC),
ADD UNIQUE INDEX `unique_name` (`name` ASC),
ADD INDEX `world_fk_idx` (`world` ASC);
;
ALTER TABLE `mu_online_characters`.`character_info`
ADD CONSTRAINT `account_fk`
  FOREIGN KEY (`account_id`)
  REFERENCES `mu_online_login`.`accounts` (`guid`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION,
ADD CONSTRAINT `world_fk`
  FOREIGN KEY (`world`)
  REFERENCES `mu_online_game`.`world_template` (`entry`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;

---

working on
mu_online_game.monster.respawn_id fk reference ??
monster.type ===> monster soul data ===> table monster_soul_converter

@jpra110 I will wait for someone to try to reproduce to check if they have the same error, my memo with its changes I keep getting crash

Could you share the log file ?

- - - Updated - - -

Quote:

---

Originally Posted by Sam3000

@jpra110 yeah, add stats is working now, thx.

- - - Updated - - -


You need to update code too

Code:

---

  for ( uint8 i = 0; i < Element::MAX; i++ )
  {
    add_monster->SetResistance(i, fields[loop++].GetUInt8());
  }

---

- - - Updated - - -

Resistance order from server

Code:

---

namespace Element
{
  enum
  {
    ICE,
    POISON,
    LIGHTNING,
    FIRE,
    EARTH,
    WIND,
    WATER,
    MAX
  };
}

---

- - - Updated - - -


Lol i missed this :D

- - - Updated - - -

@jpra110 use mudev_s16 data folder, with some regex (simply in notepad++) you can easlity make csv and import

- - - Updated - - -

I will do it now

- - - Updated - - -

https://mega.nz/file/BOxiECoB#Edn9uI...4PMoZNGvneA62c
But i dont know where to put Level column (now is min_level), AttackType and MonsterExpLevel, RegenTime and Attribute too
Other columns i think is ok.
Skill column need to move in monster_skill

- - - Updated - - -

About resistance, checked mudev_s16 folder max value is 255, so it's ok to be tinyint unsigned

- - - Updated - - -

ps. guys i dont using update to MonsterManager from MuLegend. Dont want for now

- - - Updated - - -

Ok, so MonsterExpLevel is useless i think. Check source


- - - Updated - - -

AttackType is useless too, cant find any lines in code about it.
Found:


- - - Updated - - -

Maybe Attribute is life, mana, sd or stamina? And RegenTime it's time?

- - - Updated - - -

My current db https://github.com/samik3k/mu_online.../main/Database (with updates my and from topic)

- - - Updated - - -

https://mega.nz/file/ZeQAQZzS#Pnycs9...u8QA-4q6FiWyjU monster_ai tables without monster_ai_data (from mudev, they have differenet ai)

---

@Sam3000 monster_template column order is not correct

- - - Updated - - -

Quote:

---

Originally Posted by dezner

@jpra110 not work add monster crash add server code "0" instanced
https://image.prntscr.com/image/0cjy...aVD6WBr3-w.png

---

I just realized, server is the first column not the last as metion here

Quote:

---

Originally Posted by jpra110

A column is missing in mu_online_game.monster, look at the cycle start index, it starts at index 1, so a column is missing at index 0 in the monster table. I am currently looking for the name of the current column. Fixed this, the mob spawn correctly.



edit:
found, the first column is 'server' instead of the last one. from https://github.com/DimensionGamers/L...me/monster.sql

---

Quote:

---

Originally Posted by jpra110

@Sam3000 monster_template column order is not correct

---

First row of csv file is column mapping.
Check:
Attachment 169351

Btw, check my monster_soul_*, but i didnt done reward, dunnno about data.
https://github.com/samik3k/mu_online...fa984c54e04894

- - - Updated - - -

Quote:

---

Originally Posted by jpra110

I just realized, server is the first column not the last as metion here

---

I added this fixes to my db.
Thx for constraints. Wanter to fill data and after add unique keys and other stuff

- - - Updated - - -

ps. why you want to use unique key for settings if you have already PRIMARY KEY (`server_id`,`key`)?

New tables with DATA! from Original Source, thanks!!! @mesosa

https://github.com/DimensionGamers/L...a84d3ae81fbfb4

item_template.sql
shop_items.sql
shop_template.sql
iworld_ai_path.sql
world_area_attribute.sql
world_area_restriction.sql
world_template.sql

There are minor changes on the source too https://github.com/DimensionGamers/L...r/commits/main maybe need to be compiled again

Quote:

---

Originally Posted by Sam3000

ps. why you want to use unique key for settings if you have already PRIMARY KEY (`server_id`,`key`)?

---

Whoops i miss this, my bad

Quote:

---

Originally Posted by jpra110

Whoops i miss this, my bad

---

Do you know where to put AttackType, Attribute and RegenTime from monsters.txt (mudev_s16)?

- - - Updated - - -

My monster_template
https://mega.nz/file/YXY2WTTQ#dBeoxy...czTE1gq6Bno1QM
Skipped AttackType and RegenTime
Added exp column

- - - Updated - - -

Testing monster spawn, looking where i can set monster quantity

- - - Updated - - -

mu_online_game.monster.type

Quote:

---

OBJECT_TYPE_NONE,
OBJECT_TYPE_PLAYER,
OBJECT_TYPE_MONSTER,
OBJECT_TYPE_WORLD_ITEM,

---

- - - Updated - - -

Quote:

---

this->SetRespawnLocation((data->GetX1() == data->GetX2() && data->GetY1() == data->GetY2()) ? MONSTER_RESPAWN_NORMAL: MONSTER_RESPAWN_ZONE);

---

About respawn

@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

https://i.ibb.co/0s4Y0mw/legend.png
https://i.ibb.co/kS76Y2Q/legend.png

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

minimap table is correct?

has how to turn off the / auth system?

How change resolution?

Client\LauncherOption.if >> DevModeIndex:3