Printable View
Quote:
Originally Posted by periculoso
You can use the MySQL bundled with WampServer.Quote:
Originally Posted by ispyder
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:
- Attachment 169346
Note:
Don't forget to change the default root password:
- https://linuxize.com/post/how-to-cha...user-password/
Done 0-11 types, thinking about slot for 12 type.Quote:
Originally Posted by Sam3000
I think, i need to change slot column type or set something, but not *
- - - Updated - - -
Null for now
- - - Updated - - -
Attachment 169347
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
someone managed to add mob?Quote:
Originally Posted by dezner
Or you can download from the official source, search for 5.7.29Quote:
Originally Posted by ispyder
https://downloads.mysql.com/archives/community/
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
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:
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" ?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');
The normal behaviuor doest work, so I enabled the commands like /addstr to the GameServer:
In the logs I saw the commands, but nothing happen: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')
So..still in progress.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
Character_base done already, but i didnt find information about recoveryQuote:
Originally Posted by metallica
someone managed to understand how this script_name value works
https://image.prntscr.com/image/o_qB...XhJlSTHtuA.png
something like:Quote:
Originally Posted by dezner
explicit BloodCastleDoorScript(): ScriptAI("blood_castle_door_ai") { }
explicit EvomonPortalScript(): ScriptAI("evomon_portal_ai") { }
explicit FereaMonster(): ScriptAI("ferea_monster_ai") { }
look into the source
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;
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):
Expanded inventory working with this setting: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')
Event inventory working with this setting:PHP Code:INSERT INTO `settings` (`server_id`, `key`, `value`) VALUES ('0', 'Character.MaxExpandedInventory', '3')
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', 'EventInventory.Enabled', '1')
Bugs/missing config:PHP Code:INSERT INTO `settings` (`server_id`, `key`, `value`) VALUES ('0', 'GameServer.FullInventoryToGremoryCase', '1')
- Trade it's not possible to finish
- You cannot add points
- You cannot add points using /addstr comands etc
Check muoneline.co.kr with korea proxy. Your values not correct.Quote:
Originally Posted by oleg35
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 :D:
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.Quote:
Originally Posted by Sam3000
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"
I'm still investigating both issuesCode: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
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
https://i.ibb.co/Wg8MXvY/mob1.pngCode: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());
.......
https://i.ibb.co/ss2qkkZ/mob2.png
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
monster_template dataCode: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;
- - - Updated - - -
- - - Updated - - -
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 tableQuote:
Originally Posted by metallica
@jpra110 yeah, add stats is working now, thx.
- - - Updated - - -
You need to update code tooQuote:
I have also changed the table schema so that some properties are supported, such as resitence_ * from TINYINT (3) to SMALLINT (3)
- - - Updated - - -Code:for ( uint8 i = 0; i < Element::MAX; i++ )
{
add_monster->SetResistance(i, fields[loop++].GetUInt8());
}
Resistance order from server
- - - Updated - - -Code:namespace Element
{
enum
{
ICE,
POISON,
LIGHTNING,
FIRE,
EARTH,
WIND,
WATER,
MAX
};
}
Lol i missed this :DQuote:
int32 loop = 1;
- - - Updated - - -
@jpra110 use mudev_s16 data folder, with some regex (simply in notepad++) you can easlity make csv and importQuote:
Originally Posted by ispyder
- - - 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 - - -Quote:
void Player::GiveSingleExperience(Monster * mMonster, int32 damage)
AttackType is useless too, cant find any lines in code about it.
Found:
- - - Updated - - -Quote:
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();
}
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)
