Hi again!

Game world server connection issues should be fixed!

There should be no more issues when trying to enter game world, but still some issues may happen if your ping is too high (fixing that high ping issues require also client side changes, so I will work on auto updater first and will fix that in patch later on).

Issue related with entering game world wasn't even related with my server side code, at least not directly. Actually issue happened, because of DNS cache. When IP address of realm server was changed, shard server still tried to connect to old address, so connection always failed. Because shard servers couldn't connect with realm, players also couldn't enter world, sice realm server perceived all world shards as offline.

Anyway, I hope that this issue should be finally fixed now. I added some code to clear DNS cache before trying to re-connect, so address should be now refreshed and re-connection should succeed (before in such case it always failed). I also removed usage of prepared statements from my SQL lib, because they doesn't work after DB re-connection (also due to some cache issues, but in this case I tried different ways and I can't find how to fix them, so I just replaced them with standard statements).

I hope that now server should be a lot more stable and reliable and you can try entering whenever you want without worry about that annoying stuck on "entering game world..." message.

If this solution will work and I won't find any other critical issues meanwhile I am going to focus on auto updater now, so I can push patches directly to clients. That will allow me more freely fix or update client side code, so I can add more content or features, but that will probably take a bit longer than fixing server connection issues.

See you soon, when I will be ready with my auto updater for client :3