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

**ispyder** · 12-03-21

Originally Posted by periculoso

I am having the same problem I already installed older and newer version. and now on the mysql website I realized that this is available until 5.6.Could you post the mysql link you are using?

Originally Posted by ispyder

Note:
- WampServer can be used as the MySQL server - https://sourceforge.net/projects/wam...6.exe/download
- MySQL Workbench can be used to edit the database - https://dev.mysql.com/downloads/workbench/

You can use the MySQL bundled with WampServer.

I use WampServer v3.2.3 + MySQL v5.7.31

If you use WampServer you don't have to do anything special to start MySQL; Wamp will take take of that.

How to start MySQL console from Wamp:
-

Note:
Don't forget to change the default root password:
- https://linuxize.com/post/how-to-cha...user-password/

**Sam3000** · 12-03-21

Originally Posted by Sam3000

Lol, i'm using lazy excel + import from csv.

- - - Updated - - -
@dudusiao i will do this template now :D

- - - Updated - - -

Weapons and shields done

Done 0-11 types, thinking about slot for 12 type.
I think, i need to change slot column type or set something, but not *

- - - Updated - - -

Null for now

- - - Updated - - -

item_template.zip
Update db and data to mu_online_game.item_template full from s16

ps. udpate => forgot to set name column length to 255 (was 45)
pss. haveserial and haveoption always 1 in item.txt, dropped

**dezner** · 12-03-21

Originally Posted by dezner

someone already managed to add some mob if yes they could post which tables it is necessary to feed to add

someone managed to add mob?

**jpra110** · 12-03-21

Originally Posted by ispyder

You can use the MySQL bundled with WampServer.

I use WampServer v3.2.3 + MySQL v5.7.31

If you use WampServer you don't have to do anything special to start MySQL; Wamp will take take of that.

How to start MySQL console from Wamp:
-

Note:
Don't forget to change the default root password:
- https://linuxize.com/post/how-to-cha...user-password/

Or you can download from the official source, search for 5.7.29

https://downloads.mysql.com/archives/community/

**Sam3000** · 12-03-21

You can use any mysql from 5.6 i think

- - - Updated - - -

https://mega.nz/file/pSBmiDII#qc98sU...XlNsQOco6m7Anw
item_socket_seed and item_wing_socket_option

- - - Updated - - -

https://mega.nz/file/wfYkHZBT#HD38tH...ozO7lMAjEYJjo4
item_guardian_* 4 tables

- - - Updated - - -

https://mega.nz/file/8aYUxRbK#kpN854...eJkZjFw7qdMIOY
item_harmony

**metallica** · 12-03-21

I was working on the character_base table, I copied the stats and life/mana from the actual game of Legend.mu, except from Gun that I used a MU from IGCN to take that data.

https://docs.google.com/spreadsheets...gid=1619077257

The WHITE cells are the stats that I collect from my tests on the real server of Legend.mu X50
The ORANGE cells are some doubts
The RED cells are just invented to test

I create a formula for Excel in the last column to make a insert (you need to copy & paste the row) directly on the MYSQL

For example Magic Gladiator:

PHP Code:


INSERT INTO `character_base` (`race`, `strength`, `agility`, `vitality`, `energy`, `leadership`, `life`, `mana`, `life_per_level`, `mana_per_level`, `life_per_vitality`, `mana_per_energy`, `world`, `level`, `points`, `recovery_life`, `recovery_mana`, `recovery_shield`, `recovery_stamina`, `points_levelup`, `points_levelup_plus`, `points_levelup_master`, `points_levelup_majestic`) VALUES ('3','26','26','26','26','0','110','60','1','1','3','4','1','1','100','2','2','2','2','7','1','1','1');

This at least fixed the character base with the stast and life/mana, but still not working the "ADD STAT" maybe its a matter of "packet" ?
The normal behaviuor doest work, so I enabled the commands like /addstr to the GameServer:

PHP Code:


INSERT INTO `settings` (`server_id`, `key`, `value`) VALUES ('0', 'Command.AddStat.Cost', '0'), ('0', 'Command.AddStat.Enabled', '1'), ('0', 'Command.AddStat.MinLevel', '1')

In the logs I saw the commands, but nothing happen:

PHP Code:


2021-03-12_15:58:21 INFO [ COMMAND ] [SRV 0 -- 1500 - IP: 192.168.0.105 - MAC: C4:6E:1F:21:DD:65 - Account: 3-testdk - Character: 21-runita] Used Command: /addstr 10

So..still in progress.

**Sam3000** · 12-03-21

Originally Posted by metallica

I was working on the character_base table, I copied the stats and life/mana from the actual game of Legend.mu, except from Gun that I used a MU from IGCN to take that data.

https://docs.google.com/spreadsheets...gid=1619077257

The WHITE cells are the stats that I collect from my tests on the real server of Legend.mu X50
The ORANGE cells are some doubts
The RED cells are just invented to test

I create a formula for Excel in the last column to make a insert (you need to copy & paste the row) directly on the MYSQL

For example Magic Gladiator:

PHP Code:


INSERT INTO `character_base` (`race`, `strength`, `agility`, `vitality`, `energy`, `leadership`, `life`, `mana`, `life_per_level`, `mana_per_level`, `life_per_vitality`, `mana_per_energy`, `world`, `level`, `points`, `recovery_life`, `recovery_mana`, `recovery_shield`, `recovery_stamina`, `points_levelup`, `points_levelup_plus`, `points_levelup_master`, `points_levelup_majestic`) VALUES ('3','26','26','26','26','0','110','60','1','1','3','4','1','1','100','2','2','2','2','7','1','1','1');

This at least fixed the character base with the stast and life/mana, but still not working the "ADD STAT" maybe its a matter of "packet" ?
The normal behaviuor doest work, so I enabled the commands like /addstr to the GameServer:

PHP Code:


INSERT INTO `settings` (`server_id`, `key`, `value`) VALUES ('0', 'Command.AddStat.Cost', '0'), ('0', 'Command.AddStat.Enabled', '1'), ('0', 'Command.AddStat.MinLevel', '1')

In the logs I saw the commands, but nothing happen:

PHP Code:


2021-03-12_15:58:21 INFO [ COMMAND ] [SRV 0 -- 1500 - IP: 192.168.0.105 - MAC: C4:6E:1F:21:DD:65 - Account: 3-testdk - Character: 21-runita] Used Command: /addstr 10

So..still in progress.

Character_base done already, but i didnt find information about recovery

**dezner** · 12-03-21

someone managed to understand how this script_name value works

**Donatas Soltys** · 12-03-21

Originally Posted by dezner

someone managed to understand how this script_name value works

something like:

explicit BloodCastleDoorScript(): ScriptAI("blood_castle_door_ai") { }
explicit EvomonPortalScript(): ScriptAI("evomon_portal_ai") { }
explicit FereaMonster(): ScriptAI("ferea_monster_ai") { }

look into the source

**oleg35** · 12-03-21

take it who need... Character_base

PHP Code:


/* Navicat Premium Data Transfer Source Server         : localhost Source Server Type    : MySQL Source Server Version : 50729 Source Host           : localhost:3306 Source Schema         : mu_online_game Target Server Type    : MySQL Target Server Version : 50729 File Encoding         : 65001 Date: 12/03/2021 23:01:13*/SET NAMES utf8mb4;SET FOREIGN_KEY_CHECKS = 0;-- ------------------------------ Table structure for character_base-- ----------------------------DROP TABLE IF EXISTS `character_base`;CREATE TABLE `character_base`  (  `race` int(10) UNSIGNED NOT NULL,  `strength` int(10) UNSIGNED NULL DEFAULT NULL,  `agility` int(10) UNSIGNED NULL DEFAULT NULL,  `vitality` int(10) UNSIGNED NULL DEFAULT NULL,  `energy` int(10) UNSIGNED NULL DEFAULT NULL,  `leadership` int(10) UNSIGNED NULL DEFAULT NULL,  `life` int(11) NULL DEFAULT NULL,  `mana` int(11) NULL DEFAULT NULL,  `life_per_level` float NULL DEFAULT NULL,  `mana_per_level` float NULL DEFAULT NULL,  `life_per_vitality` float NULL DEFAULT NULL,  `mana_per_energy` float NULL DEFAULT NULL,  `world` smallint(5) UNSIGNED NULL DEFAULT NULL,  `level` smallint(6) NULL DEFAULT NULL,  `points` int(11) NULL DEFAULT NULL,  `recovery_life` float NULL DEFAULT NULL,  `recovery_mana` float NULL DEFAULT NULL,  `recovery_shield` float NULL DEFAULT NULL,  `recovery_stamina` float NULL DEFAULT NULL,  `points_levelup` int(10) UNSIGNED NULL DEFAULT NULL,  `points_levelup_plus` int(10) UNSIGNED NULL DEFAULT NULL,  `points_levelup_master` int(10) UNSIGNED NULL DEFAULT NULL,  `points_levelup_majestic` int(10) UNSIGNED NULL DEFAULT NULL,  PRIMARY KEY (`race`) USING BTREE) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;-- ------------------------------ Records of character_base-- ----------------------------INSERT INTO `character_base` VALUES (0, 18, 18, 15, 30, 0, 60, 60, 1, 2, 1, 2, 0, 1, 50, 110, 60, 99, 21, 5, 1, 5, 1);INSERT INTO `character_base` VALUES (1, 28, 20, 25, 10, 0, 110, 20, 2, 0.5, 3, 1, 0, 1, 50, 110, 20, 100, 25, 5, 1, 5, 1);INSERT INTO `character_base` VALUES (2, 22, 25, 20, 15, 0, 80, 30, 1, 1, 2, 1.5, 0, 1, 50, 80, 30, 99, 20, 5, 1, 5, 1);INSERT INTO `character_base` VALUES (3, 26, 26, 26, 16, 0, 110, 60, 1, 1, 2, 2, 0, 1, 50, 110, 60, 127, 23, 7, 1, 7, 1);INSERT INTO `character_base` VALUES (4, 26, 20, 20, 15, 25, 25, 90, 1.5, 1, 2, 1.5, 0, 1, 50, 25, 90, 23, 40, 7, 1, 7, 1);INSERT INTO `character_base` VALUES (5, 21, 21, 18, 23, 0, 70, 40, 1, 1.5, 2, 1.7, 0, 1, 50, 70, 40, 102, 18, 5, 1, 5, 1);INSERT INTO `character_base` VALUES (6, 32, 27, 25, 20, 0, 100, 40, 1.3, 1, 2, 1.3, 0, 1, 50, 100, 40, 125, 37, 7, 1, 7, 1);INSERT INTO `character_base` VALUES (7, 30, 30, 25, 24, 0, 110, 40, 2, 1, 1, 1, 0, 1, 50, 110, 40, 102, 21, 5, 1, 5, 1);INSERT INTO `character_base` VALUES (8, 13, 18, 14, 40, 0, 110, 40, 2, 1, 1, 1, 0, 1, 50, 110, 40, 102, 21, 5, 1, 5, 1);INSERT INTO `character_base` VALUES (9, 28, 30, 15, 10, 0, 110, 40, 2, 1, 1, 1, 0, 1, 50, 110, 40, 102, 21, 5, 1, 5, 1);INSERT INTO `character_base` VALUES (10, 20, 18, 20, 25, 0, 110, 40, 2, 1, 1, 1, 0, 1, 50, 110, 40, 102, 21, 5, 1, 5, 1);SET FOREIGN_KEY_CHECKS = 1;

**metallica** · 12-03-21

Still working with the trade...if well is "working" the UI appear, you cannot ended the trade because is a like by default this is the message:
Your trade has been canceled because your inventory is full

POST SYSTEM is working if you enabled on the settings (minlvl=10, zenCost=10):

Code:

INSERT INTO `settings` (`server_id`, `key`, `value`) VALUES ('0', 'Command.Post.MinLevel', '10'), ('0', 'Command.Post.Head', '$name: [POST][$server]: $message'), ('0', 'Command.Post.Enabled', '1'), ('0', 'Command.Post.Delay', '1'), ('0', 'Command.Post.Cost', '10')

Expanded inventory working with this setting:

PHP Code:


INSERT INTO `settings` (`server_id`, `key`, `value`) VALUES ('0', 'Character.MaxExpandedInventory', '3')

Event inventory working with this setting:

PHP Code:


INSERT INTO `settings` (`server_id`, `key`, `value`) VALUES ('0', 'EventInventory.Enabled', '1')

Also this server files contain a interesting config that I remember when I played Legend.mu that is when inventory is Full, the items going to the Gremory Case:

PHP Code:


INSERT INTO `settings` (`server_id`, `key`, `value`) VALUES ('0', 'GameServer.FullInventoryToGremoryCase', '1')

Bugs/missing config:

Trade it's not possible to finish
You cannot add points
You cannot add points using /addstr comands etc

**Sam3000** · 13-03-21

Originally Posted by oleg35

take it who need... Character_base

PHP Code:


/* Navicat Premium Data Transfer Source Server         : localhost Source Server Type    : MySQL Source Server Version : 50729 Source Host           : localhost:3306 Source Schema         : mu_online_game Target Server Type    : MySQL Target Server Version : 50729 File Encoding         : 65001 Date: 12/03/2021 23:01:13*/SET NAMES utf8mb4;SET FOREIGN_KEY_CHECKS = 0;-- ------------------------------ Table structure for character_base-- ----------------------------DROP TABLE IF EXISTS `character_base`;CREATE TABLE `character_base`  (  `race` int(10) UNSIGNED NOT NULL,  `strength` int(10) UNSIGNED NULL DEFAULT NULL,  `agility` int(10) UNSIGNED NULL DEFAULT NULL,  `vitality` int(10) UNSIGNED NULL DEFAULT NULL,  `energy` int(10) UNSIGNED NULL DEFAULT NULL,  `leadership` int(10) UNSIGNED NULL DEFAULT NULL,  `life` int(11) NULL DEFAULT NULL,  `mana` int(11) NULL DEFAULT NULL,  `life_per_level` float NULL DEFAULT NULL,  `mana_per_level` float NULL DEFAULT NULL,  `life_per_vitality` float NULL DEFAULT NULL,  `mana_per_energy` float NULL DEFAULT NULL,  `world` smallint(5) UNSIGNED NULL DEFAULT NULL,  `level` smallint(6) NULL DEFAULT NULL,  `points` int(11) NULL DEFAULT NULL,  `recovery_life` float NULL DEFAULT NULL,  `recovery_mana` float NULL DEFAULT NULL,  `recovery_shield` float NULL DEFAULT NULL,  `recovery_stamina` float NULL DEFAULT NULL,  `points_levelup` int(10) UNSIGNED NULL DEFAULT NULL,  `points_levelup_plus` int(10) UNSIGNED NULL DEFAULT NULL,  `points_levelup_master` int(10) UNSIGNED NULL DEFAULT NULL,  `points_levelup_majestic` int(10) UNSIGNED NULL DEFAULT NULL,  PRIMARY KEY (`race`) USING BTREE) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;-- ------------------------------ Records of character_base-- ----------------------------INSERT INTO `character_base` VALUES (0, 18, 18, 15, 30, 0, 60, 60, 1, 2, 1, 2, 0, 1, 50, 110, 60, 99, 21, 5, 1, 5, 1);INSERT INTO `character_base` VALUES (1, 28, 20, 25, 10, 0, 110, 20, 2, 0.5, 3, 1, 0, 1, 50, 110, 20, 100, 25, 5, 1, 5, 1);INSERT INTO `character_base` VALUES (2, 22, 25, 20, 15, 0, 80, 30, 1, 1, 2, 1.5, 0, 1, 50, 80, 30, 99, 20, 5, 1, 5, 1);INSERT INTO `character_base` VALUES (3, 26, 26, 26, 16, 0, 110, 60, 1, 1, 2, 2, 0, 1, 50, 110, 60, 127, 23, 7, 1, 7, 1);INSERT INTO `character_base` VALUES (4, 26, 20, 20, 15, 25, 25, 90, 1.5, 1, 2, 1.5, 0, 1, 50, 25, 90, 23, 40, 7, 1, 7, 1);INSERT INTO `character_base` VALUES (5, 21, 21, 18, 23, 0, 70, 40, 1, 1.5, 2, 1.7, 0, 1, 50, 70, 40, 102, 18, 5, 1, 5, 1);INSERT INTO `character_base` VALUES (6, 32, 27, 25, 20, 0, 100, 40, 1.3, 1, 2, 1.3, 0, 1, 50, 100, 40, 125, 37, 7, 1, 7, 1);INSERT INTO `character_base` VALUES (7, 30, 30, 25, 24, 0, 110, 40, 2, 1, 1, 1, 0, 1, 50, 110, 40, 102, 21, 5, 1, 5, 1);INSERT INTO `character_base` VALUES (8, 13, 18, 14, 40, 0, 110, 40, 2, 1, 1, 1, 0, 1, 50, 110, 40, 102, 21, 5, 1, 5, 1);INSERT INTO `character_base` VALUES (9, 28, 30, 15, 10, 0, 110, 40, 2, 1, 1, 1, 0, 1, 50, 110, 40, 102, 21, 5, 1, 5, 1);INSERT INTO `character_base` VALUES (10, 20, 18, 20, 25, 0, 110, 40, 2, 1, 1, 1, 0, 1, 50, 110, 40, 102, 21, 5, 1, 5, 1);SET FOREIGN_KEY_CHECKS = 1;

Check muoneline.co.kr with korea proxy. Your values not correct.
Btw, where you get recovery life, mana, stamina and sd?

points_levelup - basic points
points_levelup_plus - after marlon
points_levelup_master - same as after marlon
points_levelup_majestic - same
If i remember right

PS. i think we need to add comment column to settings :D

- - - Updated - - -

@metallica about character_base, i took stats from muonline.co.kr

If you add in character_base some points, create character, try to add to str some, you cant, i dunno why.
Didnt found problem. Tomorrow will loook
Check database errors

- - - Updated - - -

Anyway, was looking in mudev_s16 data folder, some files can add into db, but some need to think.

- - - Updated - - -

I will be working tomorrow with item_* tables. Maybe monster. I will try to finish them tomorrow

**metallica** · 13-03-21

Originally Posted by Sam3000

Check muoneline.co.kr with korea proxy. Your values not correct.
Btw, where you get recovery life, mana, stamina and sd?

points_levelup - basic points
points_levelup_plus - after marlon
points_levelup_master - same as after marlon
points_levelup_majestic - same
If i remember right

PS. i think we need to add comment column to settings :D

- - - Updated - - -

@metallica about character_base, i took stats from muonline.co.kr

If you add in character_base some points, create character, try to add to str some, you cant, i dunno why.
Didnt found problem. Tomorrow will loook
Check database errors

- - - Updated - - -

Anyway, was looking in mudev_s16 data folder, some files can add into db, but some need to think.

- - - Updated - - -

I will be working tomorrow with item_* tables. Maybe monster. I will try to finish them tomorrow

Its ok if you took stat from KR, Legend.mu always emulate all the packets with Korean Server, that is why I used Legend.mu in my test because it's still open.
Regarding addstr atm i dont have any errors, maybe could be a packet issue because we are not using the same main that Legend.mu, that maybe is why I'm stuck into trade too, I search into the code and the logs show me that the trade was "ok"

Code:

2021-03-12_21:39:04 INFO TradeRequest() [admin][Trolaza] Requested [testdk][GunPo]
2021-03-12_21:39:06 INFO TradeRequestAnswer() [SRV 0 -- 1500 - IP: 192.168.0.105 - MAC: C4:6E:1F:21:DD:65 - Account: 3-testdk - Character: 19-GunPo] Accepted [SRV 0 -- 1501 - IP: 192.168.0.105 - MAC: C4:6E:1F:21:DD:65 - Account: 4-admin - Character: 23-Trolaza]
2021-03-12_21:39:13 INFO TradeZen() [admin][Trolaza] -- [testdk][GunPo] -> Add Zen 1500 from 999953

I'm still investigating both issues

**jpra110** · 13-03-21

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.

Without this fix world var get populated with x1 value

Game > DbInfo > MonsterMgr.ccp L: 717

Code:

if ( result )
	{
		do
		{
			Field* fields = result->Fetch();

			monster * add_monster = new monster;
			int32 loop = 1;

			add_monster->SetGUID(fields[loop++].GetUInt16());
			add_monster->SetID(fields[loop++].GetUInt16());
			add_monster->SetType(fields[loop++].GetUInt8());
			add_monster->SetName(fields[loop++].GetCString());
			add_monster->SetWorld(fields[loop++].GetUInt16());
			add_monster->SetX1(fields[loop++].GetInt16());
			add_monster->SetY1(fields[loop++].GetInt16());
			add_monster->SetX2(fields[loop++].GetInt16());
			add_monster->SetY2(fields[loop++].GetInt16());
			add_monster->SetDirection(fields[loop++].GetInt8());
			add_monster->SetSpawnDelay(fields[loop++].GetUInt32());
			add_monster->SetSpawnDistance(fields[loop++].GetUInt8());
			add_monster->SetRespawnTimeMin(fields[loop++].GetUInt32());
			add_monster->SetRespawnTimeMax(fields[loop++].GetUInt32());
			add_monster->SetRespawnID(fields[loop++].GetUInt32());
			add_monster->SetMoveDistance(fields[loop++].GetUInt8());
			add_monster->SetNpcFunction(fields[loop++].GetString());
			add_monster->SetItemBag(fields[loop++].GetString());
			add_monster->SetScriptName(fields[loop++].GetString());
			add_monster->SetElementalAttribute(fields[loop++].GetUInt8());
.......

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

- - - Updated - - -

I managed to populate the monster_template table (with simple node script) using MonsterList.xml from igcn 16. but some properties are missing or can't find where to retrieve them. if anyone has experience with this file please share.

I have also changed the table schema so that some properties are supported, such as resitence_ * from TINYINT (3) to SMALLINT (3)

monster script (with some change can be used to import items/others)

updated monster_template schema

Code:

CREATE TABLE `monster_template` (
  `id` smallint(5) unsigned NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `model` smallint(5) unsigned DEFAULT NULL,
  `size` float DEFAULT NULL,
  `type` tinyint(4) unsigned DEFAULT NULL,
  `min_level` smallint(5) unsigned DEFAULT NULL,
  `max_level` smallint(5) unsigned DEFAULT NULL,
  `life` int(11) DEFAULT NULL,
  `mana` int(11) DEFAULT NULL,
  `shield` int(11) DEFAULT NULL,
  `stamina` int(11) DEFAULT NULL,
  `attack_min_damage` int(11) DEFAULT NULL,
  `attack_max_damage` int(11) DEFAULT NULL,
  `magic_min_damage` int(11) DEFAULT NULL,
  `magic_max_damage` int(11) DEFAULT NULL,
  `critical_damage_rate` int(11) DEFAULT NULL,
  `critical_damage_add` int(11) DEFAULT NULL,
  `excellent_damage_rate` int(11) DEFAULT NULL,
  `excellent_damage_add` int(11) DEFAULT NULL,
  `attack_success` int(11) DEFAULT NULL,
  `defense` int(11) DEFAULT NULL,
  `defense_magic` int(11) DEFAULT NULL,
  `defense_success` int(11) DEFAULT NULL,
  `move_range` int(10) unsigned DEFAULT NULL,
  `move_speed` int(10) unsigned DEFAULT NULL,
  `attack_range` int(10) unsigned DEFAULT NULL,
  `attack_speed` int(11) DEFAULT NULL,
  `view_range` int(10) unsigned DEFAULT NULL,
  `resistance_1` smallint(3) unsigned DEFAULT NULL,
  `resistance_2` smallint(3) unsigned DEFAULT NULL,
  `resistance_3` smallint(3) unsigned DEFAULT NULL,
  `resistance_4` smallint(3) unsigned DEFAULT NULL,
  `resistance_5` smallint(3) unsigned DEFAULT NULL,
  `resistance_6` smallint(3) unsigned DEFAULT NULL,
  `resistance_7` smallint(3) unsigned DEFAULT NULL,
  `respawn_time_min` int(10) unsigned DEFAULT NULL,
  `respawn_time_max` int(10) unsigned DEFAULT NULL,
  `item_rate` int(11) DEFAULT NULL,
  `zen_rate` int(11) DEFAULT NULL,
  `item_max_level` int(11) DEFAULT NULL,
  `life_regen_power` float DEFAULT NULL,
  `life_regen_time` int(10) unsigned DEFAULT NULL,
  `mana_regen_power` float DEFAULT NULL,
  `mana_regen_time` int(10) unsigned DEFAULT NULL,
  `shield_regen_power` float DEFAULT NULL,
  `shiled_regen_time` int(10) unsigned DEFAULT NULL,
  `stamina_regen_power` float DEFAULT NULL,
  `stamina_regen_time` int(10) unsigned DEFAULT NULL,
  `faction` tinyint(3) unsigned DEFAULT NULL,
  `faction_level` tinyint(3) unsigned DEFAULT NULL,
  `script_name` varchar(255) DEFAULT NULL,
  `elemental_attribute` tinyint(3) unsigned DEFAULT NULL,
  `elemental_pattern` int(11) DEFAULT NULL,
  `elemental_defense` int(11) DEFAULT NULL,
  `elemental_damage_min` int(11) DEFAULT NULL,
  `elemental_damage_max` int(11) DEFAULT NULL,
  `elemental_attack_rate` int(11) DEFAULT NULL,
  `elemental_defense_rate` int(11) DEFAULT NULL,
  `radiance_immune` tinyint(3) unsigned DEFAULT NULL,
  `debuff_resistance` int(11) DEFAULT NULL,
  `debuff_defense` int(11) DEFAULT NULL,
  `critical_damage_resistance` tinyint(3) unsigned DEFAULT NULL,
  `excellent_damage_resistance` tinyint(3) unsigned DEFAULT NULL,
  `damage_absorb` tinyint(3) unsigned DEFAULT NULL,
  `elite` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

monster_template data

- - - Updated - - -

- - - Updated - - -

Originally Posted by metallica

Still working with the trade...if well is "working" the UI appear, you cannot ended the trade because is a like by default this is the message:
Your trade has been canceled because your inventory is full

POST SYSTEM is working if you enabled on the settings (minlvl=10, zenCost=10):

Code:

INSERT INTO `settings` (`server_id`, `key`, `value`) VALUES ('0', 'Command.Post.MinLevel', '10'), ('0', 'Command.Post.Head', '$name: [POST][$server]: $message'), ('0', 'Command.Post.Enabled', '1'), ('0', 'Command.Post.Delay', '1'), ('0', 'Command.Post.Cost', '10')

Expanded inventory working with this setting:

PHP Code:


INSERT INTO `settings` (`server_id`, `key`, `value`) VALUES ('0', 'Character.MaxExpandedInventory', '3')

Event inventory working with this setting:

PHP Code:


INSERT INTO `settings` (`server_id`, `key`, `value`) VALUES ('0', 'EventInventory.Enabled', '1')

Also this server files contain a interesting config that I remember when I played Legend.mu that is when inventory is Full, the items going to the Gremory Case:

PHP Code:


INSERT INTO `settings` (`server_id`, `key`, `value`) VALUES ('0', 'GameServer.FullInventoryToGremoryCase', '1')

Bugs/missing config:

Trade it's not possible to finish
You cannot add points
You cannot add points using /addstr comands etc

Sam for adding points you need to set a default max value to Character.MaxAgility, Character.MaxEnergy, Character.MaxLeadership, Character.MaxStrength, Character.MaxVitality greater than 0 in settings table

**Sam3000** · 13-03-21

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

- - - Updated - - -

I have also changed the table schema so that some properties are supported, such as resitence_ * from TINYINT (3) to SMALLINT (3)

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

int32 loop = 1;

Lol i missed this :D

- - - Updated - - -

Originally Posted by ispyder

Re-Uploaded here:
- https://app.mediafire.com/o9bz72e4zp3cj

Files:
- Data_MuDev_S16_1.zip
- Data_Webzen_S12_1.zip

@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

void Player::GiveSingleExperience(Monster * mMonster, int32 damage)

- - - Updated - - -

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

if ( Random(4) && this->SpecialMagicAttack() )
{
this->SetNextActionTime(this->GetIntData(UNIT_INT_MAGIC_SPEED));
}
else if ( Random(3) && this->MagicAttack() )
{
this->SetNextActionTime(this->GetIntData(UNIT_INT_MAGIC_SPEED));
}
else
{
this->NormalAttack();
}

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

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

Thread Tools

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Advertisement

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

Thread Tools

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Advertisement

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

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

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

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

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

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

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