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

Sam3000 · Mar 11, 2021

Ok, so... Main.exe or something dont like 127.0.0.1. It working with local ip.

ps. got auto crash when waiting on server select...

Ale[!] said:
Now, i need help with gameserver, it closes right after it open
I changed server code in db and gameserver config, i cant even see logs to know what's wrong

Because of this code...

Code:

void GameServer::LoadCommonSettings()
{
    sLog->outInfo(LOG_DEFAULT, "Loading Common Settings...");
    uint32 oldMSTime = getMSTime();

    sMain->Load();

        this->SetMaxConnectionsPerIP(sMain->GetInt32("Network.MaxConnectionPerIP", 0));

    std::string temp_client_version = sMain->GetString("GameServer.Version", "");
    char temp_client_version_buff[8];    
    memset(temp_client_version_buff, 0, 8);
    memcpy(temp_client_version_buff, temp_client_version.c_str(), temp_client_version.size() > 8 ? 8 : temp_client_version.size());

    Tokens tokens(temp_client_version_buff, '.');

    this->SetGameServerVersion(0, tokens[0][0]);
    this->SetGameServerVersion(1, tokens[1][0]);
    this->SetGameServerVersion(2, tokens[1][1]);
    this->SetGameServerVersion(3, tokens[2][0]);
    this->SetGameServerVersion(4, tokens[2][1]);

sMain->GetString("GameServer.Version", "") - we want here setting GameServer.Version and second argument is default value if we dont get anything from db

Ok, so in gameserver.conf we have GameServer.Code = 0.
Then in void MainApplication::Load() we load default settings for all servers

QueryResult result1 = GameServerDatabase.Query("SELECT `key`, `value` FROM settings WHERE server_id = -1");

and than settings for current server

QueryResult result2 = GameServerDatabase.PQuery("SELECT `key`, `value` FROM settings WHERE server_id = '%u'", sGameServer->GetServerCode());

Ok, it's working, w8 a couple minutes i will upload all i have

My repo

You must be registered to see links

With my current db, files and other.
Account in database user 123456

@Mulegend btw, can you give us any item_bag value? Or server by himself can make example?

2021-03-11_11:46:14 ERROR [ CHARACTER SELECT ] [SRV 0 -- 1501 - IP: 192.168.1.60 - MAC: B4:2E:99:C75:A3 - Account: 1-user - Character: 1-test] has wrong world 0.

Oh ok... thinking
So, it's about character_base table

wermanhme1990 · Mar 11, 2021

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

Sam3000 said:
My repo
You must be registered to see links

With my current db, files and other.
Account in database user 123456

thank you for share, i can't run file main_test.exe in link here:

You must be registered to see links

because windows defender of windows 10 delete main_test.exe, please fix it.

You must be registered to see links

thank you.

Sam3000 · Mar 11, 2021

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

wermanhme1990 said:
thank you for share, i can't run file main_test.exe in link here:

You must be registered to see links

because windows defender of windows 10 delete main_test.exe, please fix it.

You must be registered to see links

thank you.

I cant fix it, coz it packed with themida. Just add to excludes.
Anyway, if this main have any virus, i cant fix that nether, coz i dont have sources of main. Just main.dll

DB is empty, only schema, so it's not very good worknig server.
You cant download it, run it and play for fun for now.

Current progress:
I can login,
I can create character,
Can't enter world

PS. if you changing anything in game db you need to restart gameserver, coz it cached data on start

@Mulegend, help me please a little.
I added character_base for DK, but server everytime says [ CHARACTER SELECT ] %s has wrong world %d
What i missing?

Ok, i found that i need to input data in game.world_template and game.gate_template

dudusiao · Mar 11, 2021

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

you need to add world (map) entry into world_template table. For Lorencia (default map for DK):

Code:

INSERT INTO `mu_online_game`.`world_template` (`entry`, `display_entry`, `state`, `file`, `name`, `spawn_gate`, `experience`, `zen_rate`, `flags`) VALUES ('0', '0', '0', 'terrain1.att', 'Lorencia', '17', '1', '1', '0');

Also, there is a bug in world_area_attribute table (wrong name of column, causes GS crash on startup after adding world). Run this query:

Code:

ALTER TABLE `mu_online_game`.`world_area_attribute` CHANGE COLUMN `world` `world_id` SMALLINT UNSIGNED NOT NULL ;

You must be registered to see links

Sam3000 · Mar 11, 2021

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

dudusiao said:
Also, there is a bug in world_area_attribute table (wrong name of column, causes GS crash on startup after adding world). Run this query:

Code:

ALTER TABLE `mu_online_game`.`world_area_attribute` CHANGE COLUMN `world` `world_id` SMALLINT UNSIGNED NOT NULL ;

I know about this bugs. Need to fix some more db schemas in future.
dudusiao did you add something in gate_template?

Mulegend · Mar 11, 2021

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

Sam3000 said:
PS. if you changing anything in game db you need to restart gameserver, coz it cached data on start

You must be registered to see links

Reload data:

Code:

INSERT INTO `50x_mu_character`.`server_signal` 
( `server`, `signal`, `data_1`, `data_2`, `data_3` )
VALUES
	( 0, 5, 1, 0, 0 );

dudusiao · Mar 11, 2021

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

Sam3000 said:
I know about this bugs. Need to fix some more db schemas in future.
@dudusiao did you add something in gate_template?

You must be registered to see links

Sam3000 · Mar 11, 2021

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

Mulegend said:
You must be registered to see links

Reload data:

Code:

INSERT INTO `50x_mu_character`.`server_signal` ( `server`, `signal`, `data_1`, `data_2`, `data_3` ) VALUES ( 0, 5, 1, 0, 0 );

Thx for data

dudusiao said:
You must be registered to see links

Yeah, thx.
Do you have full world_template?

ispyder · Mar 11, 2021

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

Sam3000 said:
Current progress:
I can login,
I can create character,
Can't enter world

With what you uploaded I can see the Create Character screen, but nothing happens when I try to create it.

I only get an empty screen after I try to create the character.

Any ideas on what could be missing?

Used account:
user / 123456

Database:
-View attachment DB-exported-2021.03.11-15.01-v3.rar

Sam3000 · Mar 11, 2021

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

ispyder said:
With what you uploaded I can see the Create Character screen, but nothing happens when I try to create it.

I only get an empty screen after I try to create the character.

Any ideas on what could be missing?

View attachment 169330 View attachment 169331

Used account:
user / 123456

Database:
-View attachment 169332

Into mu_online_game.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"
1;50;50;50;50;0;500;500;15.0;15.0;15.0;15.0;1;1;50;15.0;15.0;15.0;15.0;15;15;15;15

I know that this is wrong values

Current progress:
Can login
Can create character
Can enter world
Cant move
Chat working

Looking...
@dudusiao your character can move?

2021-03-11_15:58:48 INFO [ SERVER MOVE REQUEST ] [SRV 0 -- 1500 - IP: 192.168.1.60 - MAC: B4:2E:99:C75:A3 - Account: 1-user - Character: 1-test] --- Server: 65535 [1 - 0/0]
2021-03-11_15:58:48 INFO [ SERVER MOVE ERROR 2 ] [SRV 0 -- 1500 - IP: 192.168.1.60 - MAC: B4:2E:99:C75:A3 - Account: 1-user - Character: 1-test] --- Server: 65535 [1 - 0/0]

ispyder · Mar 11, 2021

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

Sam3000 said:
Into mu_online_game.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"
1;50;50;50;50;0;500;500;15.0;15.0;15.0;15.0;1;1;50;15.0;15.0;15.0;15.0;15;15;15;15

I know that this is wrong values

Updated. Same issue, no character is created after I press OK

I also have these errors in the GameServer log:

Loading Gate...
Wrong Gate Loaded :2 - World: 1
Wrong Gate Loaded :3 - World: 1
Wrong Gate Loaded :5 - World: 1
Wrong Gate Loaded :6 - World: 1

I found some errors in the Database log for: LoginServer

2021-03-11_15:17:57 INFO DatabasePool 'database_login' opened successfully. 3 total connections running.
2021-03-11_15:18:25 ERROR SQL(p): INSERT INTO accounts_security (account_id, account, ip, mac, disk_serial) VALUES (1, 'user', '192.168.1.150', 'MAC_HERE', 1458217639)
[ERROR]: [1062] Duplicate entry '1' for key 'PRIMARY'
2021-03-11_15:18:25 WARN Transaction aborted. 3 queries not executed.

Click to expand...

And in the Database log for ServerLink:

2021-03-11_15:17:57 INFO DatabasePool 'database_characters' opened successfully. 3 total connections running.
2021-03-11_15:18:32 ERROR SQL(p): INSERT INTO character_info (account_id, race, name, strength, agility, vitality, energy, leadership, life, mana, points, level, world, world_x, world_y, slot) VALUES (1, 16, 'bhregerger', 50, 50, 50, 50, 0, 500, 500, 50, 1, 1, 130, 130, 0)
[ERROR]: [1364] Field 'guid' doesn't have a default value
2021-03-11_15:18:32 ERROR Unhandled MySQL errno 1364. Unexpected behaviour possible.
2021-03-11_15:18:32 WARN Transaction aborted. 1 queries not executed.

I'll look later at the errors

Sam3000 · Mar 11, 2021

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

ispyder said:
Updated. Same issue, no character is created after I press OK

View attachment 169333 View attachment 169334

Alter table characters.character_info, set to guid AUTO_INCREMENT flag. Forgot about it
Alter table login.accounts_security, remove primary key

ispyder said:
I also have these errors in the GameServer log:

It coz you dont have world_template for each world.
From code

if ( !sWorldMgr->IsWorld(add_gate->world) )
{
sLog->outError(LOG_DEFAULT, "Wrong Gate Loaded :%u - World: %u", add_gate->id, add_gate->world);
delete add_gate;
continue;
}

dudusiao · Mar 11, 2021

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

Sam3000 said:
Do you have full world_template?

nope, i'm working on it

Sam3000 said:
@dudusiao your character can move?

yes

Sam3000 · Mar 11, 2021

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

dudusiao said:
yes

How?
Mine cant

metallica · Mar 11, 2021

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

Sam3000 said:
What version of VS you have installed? I didnt wanted to bother with console error when compiling boost 1.55 with vs2019, after i was getting errors with server. So i used newest version.

It's seems that 1.55 boost doesnt know about my vs2019 or newest version from 2013 year and cant get proper tool set

So you can find some workarounds:
1) use mingw compiler
2) change end-of-line symbol
3) use some other hacks in .bat
4) try boost 1.54
That i found when googling

I was using vs2019 comunity edition...I unnistall it, what version of VS is needed? I could download vs2013 update5 but x86...not x64

Sam3000 · Mar 11, 2021

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

metallica said:
I was using vs2019 comunity edition...I unnistall it, what version of VS is needed? I could download vs2013 update5 but x86...not x64

I'm using VS2019 commuunity eidition

Donatas Soltys · Mar 11, 2021

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

Sam3000 said:
How?
Mine cant

Everything works, just one problem with gameserver:

2021-03-11_16:12:10 INFO ========================================================2021-03-11_16:12:10 INFO ========================================================2021-03-11_16:12:10 INFO >>>>>>>>>>>>>>>>>>>>> GAME SERVER <<<<<<<<<<<<<<<<<<<<<<2021-03-11_16:12:10 INFO ========================================================2021-03-11_16:12:10 INFO ========================================================2021-03-11_16:12:10 INFO Process priority class set to HIGH2021-03-11_16:12:10 INFO Starting DB...2021-03-11_16:12:10 ERROR Cannot connect to MuLog database 127.0.0.1;3306;root;123456;mu_online_log

I'm using files from your repo

dudusiao · Mar 11, 2021

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

Sam3000 said:
How?
Mine cant

i didn't do anything, i created character and can move.

Donatas Soltys · Mar 11, 2021

How come gameserver immediately closes after opening it. And it's working fine for you guys

metallica · Mar 11, 2021

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

myheart said:
use this client:
You must be registered to see links

and change IpAddress in Offset.h from the mesosa source

But that client dont use Main.dll how you "hook" that main.dll from the source of mesosa to main.exe?

Donatas Soltys said:
Everything works, just one problem with gameserver:

2021-03-11_16:12:10 INFO ========================================================2021-03-11_16:12:10 INFO ========================================================2021-03-11_16:12:10 INFO >>>>>>>>>>>>>>>>>>>>> GAME SERVER <<<<<<<<<<<<<<<<<<<<<<2021-03-11_16:12:10 INFO ========================================================2021-03-11_16:12:10 INFO ========================================================2021-03-11_16:12:10 INFO Process priority class set to HIGH2021-03-11_16:12:10 INFO Starting DB...2021-03-11_16:12:10 ERROR Cannot connect to MuLog database 127.0.0.1;3306;root;123456;mu_online_log

I'm using files from your repo

Check if exist this database: mu_online_log

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

Junior Spellweaver

Attachments

Newbie Spellweaver

Junior Spellweaver

Newbie Spellweaver

Junior Spellweaver

Skilled Illusionist

Newbie Spellweaver

Junior Spellweaver

Newbie Spellweaver

Attachments

Junior Spellweaver

Newbie Spellweaver

Attachments

Junior Spellweaver

Newbie Spellweaver

Junior Spellweaver

Skilled Illusionist

Junior Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Newbie Spellweaver

Skilled Illusionist