Originally Posted by Sam3000
Hello sam, do i use the normal mysql for the database? or sql server? Thanks!
Hello sam, do i use the normal mysql for the database? or sql server? Thanks!
Mysql ofcourse, this server doesnt work with sql server from ms
could someone help me, I have already changed the keys 1 and 2 synchronized with server and client, settings table also inserted data from the main version and serial what am I missing, I can't list the server.
Code:CSServer Ready Network Thread Starting [ SERVER CONNECT ] Connecting Server - Test / 123 ProtocolCore: C1,04,F4,06, Reading Server List... Added Server 123 [Test] Port: 55509 IP: 192.168.1.100 Display: 0 AccountAllowed: 0 Disabled: 1 >> Loaded 1 servers
Serverlist.bmd from client need to be fixed, read topic
yes I already applied and even then I get disconnected when I reach the server selection screen
Ok...so there is no way to get connected with 127.0.0.1 so we need to update the IP and compile...sadly in my case I cannot do that because I cannot compile the source...but i wanna to contribute fixing db or some test so there is a way to someone could create TWO mains.dll with this range of ip for example:
192.168.0.105
192.168.1.105
Just to have the two ranges for ppl like me that cannot compile or ppl that doesnt have the knowledgement to do that
Compiled Client Main for IPs:
- 192.168.0.105
- 192.168.0.106
- 192.168.1.105
- 192.168.1.106
- Main.dll - Release.rar
Compiled GameServer (for the keys below) + Database and Main.exe + Main.dll for the IPs above:
- https://www.mediafire.com/folder/o9b...line-season-16
The GameServer has the boost::asio::io_service replaced by boost::asio::io_context and has the MySQL library updated to version 5.7.31
Test account from the database:
Version and Serial:user : user
pass : 123456
auth_code : 12digitsphra
Keys (copied from the GameServer)static const char ClientVersion[8] = "1.07.17";
static const char ClientSerial[17] = "jw45af7xf4wxj198";
Let me know if those DLLs are working for you.static const uint8 key_1[MAX_KEY_1] = { 0x75, 0x99, 0x5C, 0xBA, 0x44, 0x2C, 0x87, 0x66 };
static const uint8 key_2[MAX_KEY_2] = { 0xF3, 0xB3, 0x64, 0x36, 0xBE, 0xF6, 0x52, 0x01 };
static const uint8 key_final[MAX_KEY_1][MAX_KEY_2] =
{
0x22, 0x8F, 0x3B, 0x0A, 0x8E, 0x6A, 0x51, 0x32,
0xBA, 0xCC, 0xAA, 0xBF, 0xFB, 0x54, 0x24, 0x47,
0x00, 0xA1, 0x21, 0x02, 0x02, 0x21, 0xAB, 0x9F,
0xFE, 0x3A, 0xB0, 0x86, 0xBA, 0xAF, 0x34, 0x55,
0xCB, 0x63, 0x8D, 0xEA, 0x56, 0xE8, 0x51, 0x29,
0x7D, 0x2B, 0x5F, 0xC3, 0xB1, 0xE9, 0x8A, 0xFB,
0xBC, 0x89, 0x9F, 0xB2, 0xE7, 0x23, 0xA8, 0x3A,
0x6D, 0xFF, 0x5C, 0x58, 0x8B, 0x25, 0xAF, 0x62
};
###
Edit:
Moved the IP to an external file - config-dev.ini:
- post #193 - http://forum.ragezone.com/f197/relea...ml#post9071023
Last edited by ispyder; 12-03-21 at 12:34 AM.
Work
Thanks so much for share the dlls.
I could enter the first time with your account and character,
I move on Lorencia,
I go to the helper I change the "loot"
I saved
I quit from the game
...and after that I cannot login anymore, is like the server get stuck on the login
Maybe something wrong got written to the database.
Try to re-create the database.
Yes, maybe I need to open the logs of the MySQL to see what is wrong. I re uploaded all the database and now I have two clients online working.
WHISPER working
TRADE doesnt work, with a lvl 6 to a lvl1 the response is "Trade is disabled" the UI dont appear
EDIT 1:
After change on seetings table to enable the trade on the server
Trade is not allowed on this map...so maybe is there another config by MAP (searching)PHP Code:INSERT INTO `settings` (`server_id`, `key`, `value`) VALUES ('0', 'GameServer.LogDB.Trade', '1'), ('0', 'Trade.Enabled', '1'), ('0', 'Trade.MaxZen', '999999999')
EDIT 2:
enum WorldFlags
{
WORLD_FLAG_NONE = 0,
WORLD_FLAG_BATTLE_ZONE = 1 << 0,
WORLD_FLAG_ALLOW_EXCHANGE = 1 << 1,
WORLD_FLAG_ALLOW_OFFLINE_TRADE = 1 << 2,
WORLD_FLAG_ALLOW_DUEL = 1 << 3,
WORLD_FLAG_ALLOW_PARTY = 1 << 4,
WORLD_FLAG_ALLOW_KALIMA_GATE = 1 << 5,
WORLD_FLAG_ALLOW_TALISMAN_MOVE = 1 << 6,
WORLD_FLAG_DISABLE_CASH_SHOP = 1 << 7,
WORLD_FLAG_NO_LEVEL_CHECK = 1 << 8,
//WORLD_FLAG_ALLOW_PK_HOSTIL = 1 << 9,
//WORLD_FLAG_ALLOW_PK_PENALTY = 1 << 10,
WORLD_FLAG_NO_FRUSTRUM = 1 << 11,
WORLD_FLAG_ALLOW_SUMMON = 1 << 12,
WORLD_FLAG_ALLOW_GUILD_COMMAND = 1 << 13,
WORLD_FLAG_ALLOW_HELPER = 1 << 14,
WORLD_FLAG_ALLOW_ENTER_CHAOS_CASTLE = 1 << 15,
WORLD_FLAG_ALLOW_SUMMON_MONSTER = 1 << 16,
WORLD_FLAG_ALLOW_AUTO_PET_CHANGE = 1 << 17,
WORLD_FLAG_ALLOW_PARTY_MOVE = 1 << 18,
WORLD_FLAG_ALLOW_PK_TIME = 1 << 19,
WORLD_FLAG_ALLOW_PK_MONSTER_KILL = 1 << 20,
WORLD_FLAG_ALLOW_PK_HELPER_KILL = 1 << 21,
WORLD_FLAG_ALLOW_GUILD_WAR = 1 << 22,
WORLD_FLAG_ALLOW_WRONG_LOCATION_CHECK = 1 << 23,
WORLD_FLAG_ALLOW_OFFLINE_ATTACK = 1 << 24,
WORLD_FLAG_ALLOW_SUMMON_SCROLL = 1 << 26,
WORLD_FLAG_NO_LIMIT_PK = 1 << 27,
};
So this Allow to "Lorencia" to have trade:
Now, TRADE is WORKING :DPHP Code:UPDATE `world_template` SET `flags` = '2' WHERE `world_template`.`entry` = 0
Last edited by metallica; 11-03-21 at 10:10 PM.
@dudusiao thx, its working now :D
Database updates. Was wrong character_base and world_template, messed up with testing
https://github.com/samik3k/mu_online.../main/Database
Last edited by Sam3000; 12-03-21 at 12:05 AM.
I made a patch for Main.dll to be able to update the following settings without recompiling the source code for every change:
This is the patch to apply on the Client sources (v2):Code:[MainInfo] IpAddress = 192.168.1.150 IpAddressPort = 44405 ClientVersion = 1.07.17 ClientSerial = jw45af7xf4wxj198 ScreenShotPath = ScreenShots\Screen(%02d_%02d-%02d-%02d)-%04d.jpg
- patch-move-settings-to-config-file-v2.txt
Compiled config file and DLL (v2):
- Main.dll-with-config.ini-file-v2.rar
What the patch does:
Latest Database:- check if config-dev.ini is present in the main.exe directory
- if it exists load the settings from the file
- if it doesn't exist create a config-dev.ini file with some default values
- note: no error check is made on the content of this file!
- DB-exported-2021.03.12-12.13-v8.rar
Test accounts from the database:
Edit: Added patch version 2user : user AND user2
pass : 123456
auth_code : 12digitsphra
Last edited by ispyder; 12-03-21 at 11:22 AM.
Table data mu_online_game.character_base
Cant find recovery stats and every char in lorencia, coz didnt ready world_template
"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"
"0";"18";"18";"15";"30";"0";"60";"60";"1";"2";"2";"2";"0";"1";"0";"15";"15";"15";"15";"5";"6";"6";"6"
"1";"28";"20";"25";"10";"0";"110";"20";"2";"0.5";"3";"1.5";"0";"1";"0";"15";"15";"15";"15";"5";"6";"6";"6"
"2";"22";"25";"20";"15";"0";"80";"30";"1";"1.5";"2";"1.5";"0";"1";"0";"15";"15";"15";"15";"5";"6";"6";"6"
"3";"26";"26";"26";"26";"0";"110";"60";"1";"1";"2";"2";"0";"1";"0";"15";"15";"15";"15";"7";"7";"7";"7"
"4";"26";"20";"20";"15";"25";"90";"40";"1";"1";"2";"1.5";"0";"1";"0";"15";"15";"15";"15";"7";"7";"7";"7"
"5";"21";"21";"18";"23";"0";"70";"40";"1";"1.5";"2";"1.7";"0";"1";"0";"15";"15";"15";"15";"5";"6";"6";"6"
"6";"32";"27";"25";"20";"0";"100";"40";"1.3";"1";"1";"1.3";"0";"1";"0";"15";"15";"15";"15";"7";"7";"7";"7"
"7";"30";"30";"25";"24";"0";"110";"40";"2";"1";"2";"1";"0";"1";"0";"15";"15";"15";"15";"7";"7";"7";"7"
"8";"13";"18";"14";"40";"0";"60";"60";"1.2";"1.8";"2";"1.5";"0";"1";"0";"15";"15";"15";"15";"5";"6";"6";"6"
"9";"28";"30";"15";"10";"0";"130";"10";"1.5";"1";"3";"1";"0";"1";"0";"15";"15";"15";"15";"5";"6";"6";"6"
"10";"20";"18";"20";"25";"0";"100";"80";"1.5";"1.5";"2";"2";"0";"1";"0";"15";"15";"15";"15";"5";"6";"6";"6"
After work around yesterday I made inside the game, just read the other post. Here https://ibb.co/hgTwnv8
It is great other are exploring such as trade, I did experience delete character is actually not working (Visually) but after you exit and login back it's working.
Now let's add those monsters and so on in the DB table. :D
Reply With Quote