View attachment 169301
Added all schema from game db. 170 in final
But missing some tables in code:
monster_original
event_labyrinth_region
mix_template
muun_s16
quest_mu_s16
world_random_pvp
Didnt filld any data or indexes
Maybe have some typo, i dunno.
Maybe some columns need to be renamed
Didnt tried to run gameserver
I figured it out, but anyway thx for answerIf you can't find those tables on source code, then it means they don't exist. Some tables were just backups or old.
I have some scripts for S13. You can try it. If it doesn’t work for the S16, maybe need to fix a bit.Share script please, because other bmd tools no decrypt above season 15 1-3
diff --git "a/Game/QuestMgr.cpp" "b/Game/QuestMgr.cpp"
index 63018fa..4f8f288 100644
--- "a/Game/QuestMgr.cpp"
+++ "b/Game/QuestMgr.cpp"
@@ -415,7 +415,7 @@ void CQuestMgr::LoadQuestMU()
uint32 count = 0;
- QueryResult result = GameServerDatabase.Query("SELECT * FROM quest_mu AS i WHERE i.Disabled = 0");
+ QueryResult result = GameServerDatabase.Query("SELECT * FROM quest_mu AS i WHERE i.disabled = 0");
if (result)
{
Common/GameServerDatabase.cpp | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/Common/GameServerDatabase.cpp b/Common/GameServerDatabase.cpp
index a59357d..9323a5c 100644
--- a/Common/GameServerDatabase.cpp
+++ b/Common/GameServerDatabase.cpp
@@ -31,6 +31,6 @@ void GameServerDatabaseConnection::DoPrepareStatements()
PrepareStatement(QUERY_SRVCFG_MONSTER_ADD, "INSERT IGNORE INTO monster (server, guid, id, world, x1, y1, x2, y2, direction, spawn_distance, move_distance) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
PrepareStatement(QUERY_SRVCFG_MONSTER_MAX_GUID, "SELECT MAX(i.guid) FROM monster i where i.server = ?", CONNECTION_SYNCH);
- PrepareStatement(QUERY_GAME_INSERT_QUEST, "INSERT INTO quest_mu (`ID`, `Name`, `Server`, `Day`, `TemplateType1`, `Chapter`, `Category`, `Importance`, `StartType`, `StartSubType`, `LevelMin`, `LevelMax`, `RepeatCycle`, `PrecedenceQuest`, `StartItemType`, `StartItemIndex`, `CheckGens`, `Zen`, `DarkWizard`, `DarkKnight`, `FairyElf`, `MagicGladiator`, `DarkLord`, `Summoner`, `RageFighter`, `GrowLancer`, `RuneWizard`, `Slayer`, `GunCrusher`, `AddClass1`, `TemplateType2`, `ObjectiveType`, `ObjectiveMainType`, `ObjectiveMainSubType`, `TargetNumber`, `TargetMaxLevel`, `DropRate`, `GateID`, `MapID`, `X`, `Y`, `RewardExperience`, `RewardZen`, `RewardGensPoints`, `RewardItemType01`, `RewardItemIndex01`, `RewardItemCount01`, `RewardItemType02`, `RewardItemIndex02`, `RewardItemCount02`, `RewardItemType03`, `RewardItemIndex03`, `RewardItemCount03`, `RewardType`, `RewardSubType`, `RewardNumber`) "
+ PrepareStatement(QUERY_GAME_INSERT_QUEST, "INSERT INTO quest_mu (id, name, server, day, template_type_1, chapter, category, importance, start_type, start_sub_type, level_min, level_max, repeat_cycle, precedence_quest, start_item_type, start_item_index, check_gens, zen, required_class_dark_wizard, required_class_dark_knight, required_class_fairy_elf, required_class_magic_gladiator, required_class_dark_lord, required_class_summoner, required_class_rage_fighter, required_class_grow_lancer, required_class_rune_wizard, required_class_slayer, required_class_gun_crusher, add_class, template_type_2, objective_type, objective_main_type, objective_main_sub_type, target_number, target_max_level, drop_rate, gate_id, map_id, x, y, reward_experience, reward_zen, reward_gens_points, reward_item_type_1, reward_item_index_1, reward_item_count_1, reward_item_type_2, reward_item_index_2, reward_item_count_2, reward_item_type_3, reward_item_index_3, reward_item_count_3, reward_type, reward_sub_type, reward_number)"
"VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC);
-}
\ No newline at end of file
+}
Default settings table data: View attachment 169304
I have some changes in code, changed Disabled to disabled in query to quest_mu
Code:diff --git "a/Game/QuestMgr.cpp" "b/Game/QuestMgr.cpp" index 63018fa..4f8f288 100644 --- "a/Game/QuestMgr.cpp" +++ "b/Game/QuestMgr.cpp" @@ -415,7 +415,7 @@ void CQuestMgr::LoadQuestMU() uint32 count = 0; - QueryResult result = GameServerDatabase.Query("SELECT * FROM quest_mu AS i WHERE i.Disabled = 0"); + QueryResult result = GameServerDatabase.Query("SELECT * FROM quest_mu AS i WHERE i.disabled = 0"); if (result) {
And renamed columns in QUERY_GAME_INSERT_QUEST to my scheme
Code:Common/GameServerDatabase.cpp | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Common/GameServerDatabase.cpp b/Common/GameServerDatabase.cpp index a59357d..9323a5c 100644 --- a/Common/GameServerDatabase.cpp +++ b/Common/GameServerDatabase.cpp @@ -31,6 +31,6 @@ void GameServerDatabaseConnection::DoPrepareStatements() PrepareStatement(QUERY_SRVCFG_MONSTER_ADD, "INSERT IGNORE INTO monster (server, guid, id, world, x1, y1, x2, y2, direction, spawn_distance, move_distance) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC); PrepareStatement(QUERY_SRVCFG_MONSTER_MAX_GUID, "SELECT MAX(i.guid) FROM monster i where i.server = ?", CONNECTION_SYNCH); - PrepareStatement(QUERY_GAME_INSERT_QUEST, "INSERT INTO quest_mu (`ID`, `Name`, `Server`, `Day`, `TemplateType1`, `Chapter`, `Category`, `Importance`, `StartType`, `StartSubType`, `LevelMin`, `LevelMax`, `RepeatCycle`, `PrecedenceQuest`, `StartItemType`, `StartItemIndex`, `CheckGens`, `Zen`, `DarkWizard`, `DarkKnight`, `FairyElf`, `MagicGladiator`, `DarkLord`, `Summoner`, `RageFighter`, `GrowLancer`, `RuneWizard`, `Slayer`, `GunCrusher`, `AddClass1`, `TemplateType2`, `ObjectiveType`, `ObjectiveMainType`, `ObjectiveMainSubType`, `TargetNumber`, `TargetMaxLevel`, `DropRate`, `GateID`, `MapID`, `X`, `Y`, `RewardExperience`, `RewardZen`, `RewardGensPoints`, `RewardItemType01`, `RewardItemIndex01`, `RewardItemCount01`, `RewardItemType02`, `RewardItemIndex02`, `RewardItemCount02`, `RewardItemType03`, `RewardItemIndex03`, `RewardItemCount03`, `RewardType`, `RewardSubType`, `RewardNumber`) " + PrepareStatement(QUERY_GAME_INSERT_QUEST, "INSERT INTO quest_mu (id, name, server, day, template_type_1, chapter, category, importance, start_type, start_sub_type, level_min, level_max, repeat_cycle, precedence_quest, start_item_type, start_item_index, check_gens, zen, required_class_dark_wizard, required_class_dark_knight, required_class_fairy_elf, required_class_magic_gladiator, required_class_dark_lord, required_class_summoner, required_class_rage_fighter, required_class_grow_lancer, required_class_rune_wizard, required_class_slayer, required_class_gun_crusher, add_class, template_type_2, objective_type, objective_main_type, objective_main_sub_type, target_number, target_max_level, drop_rate, gate_id, map_id, x, y, reward_experience, reward_zen, reward_gens_points, reward_item_type_1, reward_item_index_1, reward_item_count_1, reward_item_type_2, reward_item_index_2, reward_item_count_2, reward_item_type_3, reward_item_index_3, reward_item_count_3, reward_type, reward_sub_type, reward_number)" "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)", CONNECTION_ASYNC); -} \ No newline at end of file +}
Updated game db to run server without crash (was having some error):
View attachment 169305
Ok, i have working server
I have some scripts for S13. You can try it. If it doesn’t work for the S16, maybe need to fix a bit.
Quit Mu for a while long, the release is really awesome, but really have no time play with it
gj mulegend
You must be registered to see links
Yeah, in my login db was server code 123, didnt know it auto_increment or not. Now i know.Officials database released by Mesosa:
You must be registered to see links
You must be registered to see links
You must be registered to see links
You must be registered to see links
Using the original names in the tables of quest_mu.sql I dont have any errors with Database but...GameServer still crashing
2021-03-09_15:55:45 ERROR Can't find Server Code 0 info.
Any clue?
View attachment 169308
I think that is related to gameserver.conf
GameServer.Code = 0
GameServer.ServerType = 0
----
enum ServerType
{
SERVER_TYPE_NORMAL,
SERVER_TYPE_CASTLE_SIEGE,
SERVER_TYPE_EVENT,
SERVER_TYPE_ARKA_WAR,
SERVER_TYPE_MAX
};
-----
ServerType=0=SERVER_TYPE_NORMAL right? I dunno C++ but I think that the first position of a "enum" =0
So the problem will be with the GameServer.Code what are the options? 0 is ok?
EDIT 2: The Code needed is on the Login database (123)
ServerUP , now...how can modify a main to point to 127.0.0.1? I'm not ASM coder
Boost version and error?I'm stuck on Boost Library, cant install b2
Thx, IP i can change in any HEXeditor or need to make some more actions?since Webzen switched to use themida, some people can't hooking dll. so i leave hooked main 1.19.46 here:
You must be registered to see links
I believe that using the main.dll from the memosa source. by my tests so it wasThx, IP i can change in any HEXeditor or need to make some more actions?
since Webzen switched to use themida, some people can't hooking dll. so i leave hooked main 1.19.46 here:
You must be registered to see links
Heh, i need to update some columns, anyway it's need to be updated after i try to migrate data folder into db...Officials database released by Mesosa:
You must be registered to see links
You must be registered to see links
You must be registered to see links
You must be registered to see links
Thx, IP i can change in any HEXeditor or need to make some more actions?I believe that using the main.dll from the memosa source. by my tests so it was
Boost version and error?
Just try bootstart.bat, then simply run b2.exe. It worked for me on win10 x64