HT Cesta

This would be an unprecedented milestone for the repository and the community.

solve here https://github.com/opentibiabr/canary/pull/2855

Console errors: ``` [2025-21-02 04:01:05.256] [error] Query: INSERT INTO `house_lists` (`house_id` , `listid` , `list`, `version`, `world_id`) VALUES (2658,257,'Xistos\nGalopera\nGuto\n',1740128465256130,
),(2660,257,'Galopera\nXistos\nGuto\n',1740128465256130,
),(2941,256,'Gamboa\nMalucoo\n', [2025-21-02 04:01:05.256] [error] MySQL error [1064]: You have an error in...

I managed to solve the ranking problem here: ``` std::string Game::generateHighscoreQuery( const std::string &categoryName, const std::string &worldName, uint32_t page, uint8_t entriesPerPage, uint32_t vocation, uint32_t playerGUID /*= 0*/ ) { uint32_t...

When there are 2 worlds linked, the players_online table is reset periodically and does not list the players from the second world, it only lists the first.

I managed to solve this one about the houses ``` bool IOMapSerialize::SaveHouseInfoGuard() { Database &db = Database::getInstance(); auto currentWorld = g_game().worlds().getCurrentWorld(); const auto worldId = static_cast(currentWorld->id); std::ostringstream query; DBInsert houseUpdate("INSERT...

> SQL queries from Highscores, houses and players online fixed. When you have a world with 10 players and another with 0, according to your update, periodically the 0 will...

Also, in the server_initialization.lua file you need to add: ``` local worldId = configManager.getNumber(configKeys.WORLD_ID) db.query("DELETE FROM `players_online` WHERE `world_id` = " .. worldId) ```

This PR can be merged, I have been testing it for a long time.

> With the change in the status port, the otservlist no longer finds the server. Is there a solution? Instead of 97173 you just use 7173, 7174...