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

[metallica]

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

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:

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

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

Server Online Stability: 12hours without crash with 2 online

[dezner]

@jpra110 not work add monster crash add server code "0" instanced

[jpra110]

Some index, fk updates

uniq constraint: duplicate seetting for the same server

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

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

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

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

character fk

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]

Some index, fk updates

uniq constraint: duplicate seetting for the same server

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

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

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

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

character fk

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]

@jpra110 not work add monster crash add server code "0" instanced

try this



Some index, fk updates

uniq constraint: duplicate seetting for the same server

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

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

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

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

character fk

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

[dezner]

@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

[jpra110]

Could you share the log file ?

- - - Updated - - -

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

- - - Updated - - -


You need to update code too

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

- - - Updated - - -

Resistance order from server

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

@jpra110 not work add monster crash add server code "0" instanced

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

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

[Sam3000]

@Sam3000 monster_template column order is not correct

First row of csv file is column mapping.
Check:


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

- - - Updated - - -

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`)?

[metallica]

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

[jpra110]

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

[Sam3000]

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

OBJECT_TYPE_NONE,
OBJECT_TYPE_PLAYER,
OBJECT_TYPE_MONSTER,
OBJECT_TYPE_WORLD_ITEM,

- - - Updated - - -

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

About respawn

[jpra110]

@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

[favgames]

minimap table is correct?

has how to turn off the / auth system?

[dns360]

How change resolution?

[favgames]

Client\LauncherOption.if >> DevModeIndex:3