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

Page 15 of 45 FirstFirst ... 5789101112131415161718192021222325 ... LastLast
Results 211 to 225 of 668
  1. #211
    Member ispyder is offline
    MemberRank
    Aug 2015 Join Date
    76Posts

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

    Quote Originally Posted by periculoso View Post
    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?
    Quote Originally Posted by ispyder View Post
    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:
    - wamp-how-to-mysql.jpeg

    Note:
    Don't forget to change the default root password:
    - https://linuxize.com/post/how-to-cha...user-password/
    Last edited by ispyder; 12-03-21 at 02:44 PM.

  2. #212
    Proficient Member Sam3000 is offline
    MemberRank
    Oct 2007 Join Date
    MoscowLocation
    188Posts

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

    Quote Originally Posted by Sam3000 View Post
    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
    Last edited by Sam3000; 12-03-21 at 04:22 PM.

  3. #213
    Account Upgraded | Title Enabled! dezner is offline
    MemberRank
    Aug 2006 Join Date
    BrasilLocation
    241Posts

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

    Quote Originally Posted by dezner View Post
    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?

  4. #214
    Apprentice jpra110 is offline
    MemberRank
    Nov 2012 Join Date
    18Posts

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

    Quote Originally Posted by ispyder View Post
    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:
    - wamp-how-to-mysql.jpeg

    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/
    Last edited by jpra110; 12-03-21 at 04:44 PM.

  5. #215
    Proficient Member Sam3000 is offline
    MemberRank
    Oct 2007 Join Date
    MoscowLocation
    188Posts

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

    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

  6. #216
    Account Upgraded | Title Enabled! metallica is offline
    MemberRank
    Feb 2004 Join Date
    Tandil, ArgentiLocation
    404Posts

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

    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 IP192.168.0.105 MACC4:6E:1F:21:DD:65 Account3-testdk Character21-runitaUsed Command: /addstr 10 
    So..still in progress.

  7. #217
    Proficient Member Sam3000 is offline
    MemberRank
    Oct 2007 Join Date
    MoscowLocation
    188Posts

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

    Quote Originally Posted by metallica View Post
    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 IP192.168.0.105 MACC4:6E:1F:21:DD:65 Account3-testdk Character21-runitaUsed Command: /addstr 10 
    So..still in progress.
    Character_base done already, but i didnt find information about recovery

  8. #218
    Account Upgraded | Title Enabled! dezner is offline
    MemberRank
    Aug 2006 Join Date
    BrasilLocation
    241Posts

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

    someone managed to understand how this script_name value works

  9. #219
    Member Donatas Soltys is offline
    MemberRank
    Feb 2013 Join Date
    69Posts

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

    Quote Originally Posted by dezner View Post
    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

  10. #220
    Elite Member O_o oleg35 is offline
    MemberRank
    Jan 2007 Join Date
    nvm i'm RussianLocation
    403Posts

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

    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`  (  `raceint(10UNSIGNED NOT NULL,  `strengthint(10UNSIGNED NULL DEFAULT NULL,  `agilityint(10UNSIGNED NULL DEFAULT NULL,  `vitalityint(10UNSIGNED NULL DEFAULT NULL,  `energyint(10UNSIGNED NULL DEFAULT NULL,  `leadershipint(10UNSIGNED NULL DEFAULT NULL,  `lifeint(11NULL DEFAULT NULL,  `manaint(11NULL DEFAULT NULL,  `life_per_levelfloat NULL DEFAULT NULL,  `mana_per_levelfloat NULL DEFAULT NULL,  `life_per_vitalityfloat NULL DEFAULT NULL,  `mana_per_energyfloat NULL DEFAULT NULL,  `worldsmallint(5UNSIGNED NULL DEFAULT NULL,  `levelsmallint(6NULL DEFAULT NULL,  `pointsint(11NULL DEFAULT NULL,  `recovery_lifefloat NULL DEFAULT NULL,  `recovery_manafloat NULL DEFAULT NULL,  `recovery_shieldfloat NULL DEFAULT NULL,  `recovery_staminafloat NULL DEFAULT NULL,  `points_levelupint(10UNSIGNED NULL DEFAULT NULL,  `points_levelup_plusint(10UNSIGNED NULL DEFAULT NULL,  `points_levelup_masterint(10UNSIGNED NULL DEFAULT NULL,  `points_levelup_majesticint(10UNSIGNED NULL DEFAULT NULL,  PRIMARY KEY (`race`) USING BTREEENGINE InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci ROW_FORMAT DYNAMIC;-- ------------------------------ Records of character_base-- ----------------------------INSERT INTO `character_baseVALUES (01818153006060121201501106099215151);INSERT INTO `character_baseVALUES (12820251001102020.531015011020100255151);INSERT INTO `character_baseVALUES (222252015080301121.50150803099205151);INSERT INTO `character_baseVALUES (3262626160110601122015011060127237171);INSERT INTO `character_baseVALUES (4262020152525901.5121.50150259023407171);INSERT INTO `character_baseVALUES (5212118230704011.521.701507040102185151);INSERT INTO `character_baseVALUES (6322725200100401.3121.3015010040125377171);INSERT INTO `character_baseVALUES (7303025240110402111015011040102215151);INSERT INTO `character_baseVALUES (8131814400110402111015011040102215151);INSERT INTO `character_baseVALUES (9283015100110402111015011040102215151);INSERT INTO `character_baseVALUES (10201820250110402111015011040102215151);SET FOREIGN_KEY_CHECKS 1

  11. #221
    Account Upgraded | Title Enabled! metallica is offline
    MemberRank
    Feb 2004 Join Date
    Tandil, ArgentiLocation
    404Posts

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

    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:

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

  12. #222
    Proficient Member Sam3000 is offline
    MemberRank
    Oct 2007 Join Date
    MoscowLocation
    188Posts

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

    Quote Originally Posted by oleg35 View Post
    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`  (  `raceint(10UNSIGNED NOT NULL,  `strengthint(10UNSIGNED NULL DEFAULT NULL,  `agilityint(10UNSIGNED NULL DEFAULT NULL,  `vitalityint(10UNSIGNED NULL DEFAULT NULL,  `energyint(10UNSIGNED NULL DEFAULT NULL,  `leadershipint(10UNSIGNED NULL DEFAULT NULL,  `lifeint(11NULL DEFAULT NULL,  `manaint(11NULL DEFAULT NULL,  `life_per_levelfloat NULL DEFAULT NULL,  `mana_per_levelfloat NULL DEFAULT NULL,  `life_per_vitalityfloat NULL DEFAULT NULL,  `mana_per_energyfloat NULL DEFAULT NULL,  `worldsmallint(5UNSIGNED NULL DEFAULT NULL,  `levelsmallint(6NULL DEFAULT NULL,  `pointsint(11NULL DEFAULT NULL,  `recovery_lifefloat NULL DEFAULT NULL,  `recovery_manafloat NULL DEFAULT NULL,  `recovery_shieldfloat NULL DEFAULT NULL,  `recovery_staminafloat NULL DEFAULT NULL,  `points_levelupint(10UNSIGNED NULL DEFAULT NULL,  `points_levelup_plusint(10UNSIGNED NULL DEFAULT NULL,  `points_levelup_masterint(10UNSIGNED NULL DEFAULT NULL,  `points_levelup_majesticint(10UNSIGNED NULL DEFAULT NULL,  PRIMARY KEY (`race`) USING BTREEENGINE InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci ROW_FORMAT DYNAMIC;-- ------------------------------ Records of character_base-- ----------------------------INSERT INTO `character_baseVALUES (01818153006060121201501106099215151);INSERT INTO `character_baseVALUES (12820251001102020.531015011020100255151);INSERT INTO `character_baseVALUES (222252015080301121.50150803099205151);INSERT INTO `character_baseVALUES (3262626160110601122015011060127237171);INSERT INTO `character_baseVALUES (4262020152525901.5121.50150259023407171);INSERT INTO `character_baseVALUES (5212118230704011.521.701507040102185151);INSERT INTO `character_baseVALUES (6322725200100401.3121.3015010040125377171);INSERT INTO `character_baseVALUES (7303025240110402111015011040102215151);INSERT INTO `character_baseVALUES (8131814400110402111015011040102215151);INSERT INTO `character_baseVALUES (9283015100110402111015011040102215151);INSERT INTO `character_baseVALUES (10201820250110402111015011040102215151);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

  13. #223
    Account Upgraded | Title Enabled! metallica is offline
    MemberRank
    Feb 2004 Join Date
    Tandil, ArgentiLocation
    404Posts

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

    Quote Originally Posted by Sam3000 View Post
    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

  14. #224
    Apprentice jpra110 is offline
    MemberRank
    Nov 2012 Join Date
    18Posts

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

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

    Quote Originally Posted by metallica View Post
    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:

    1. Trade it's not possible to finish
    2. You cannot add points
    3. 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
    Last edited by jpra110; 13-03-21 at 04:48 AM.

  15. #225
    Proficient Member Sam3000 is offline
    MemberRank
    Oct 2007 Join Date
    MoscowLocation
    188Posts

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

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

    Quote Originally Posted by ispyder View Post
    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)
    Last edited by Sam3000; 13-03-21 at 11:28 AM.



Advertisement