Spirited

Gonna copy what I said on epvp here, but this seems Interesting - looks like you've done quite a lot of work on your own here. Sorry to hear your server has been struggling with player retention, but hopefully you get some of that back by advertising. Honestly, looks like you have a lot of potential. I hope you continue to work on this. On the topic of AI, I'm actually really happy to see that you haven't leaned super heavily into it. Like, your website descriptions are genuine and not generated, and the same with all your patch notes. That's really refreshing to see. I'm personally not for generative AI as a replacement for talent, but maybe you can consider hiring voice acting for key lines / phrases from super cheap actors in the future? I know a few very talented friends who could possibly do voice acting for a super low cost. Anyways, gripes on AI aside, good luck with your server.

The message is called MsgFuse. I can't remember if it appears in the Soul project or not, but I've seen some private servers repurpose it. Like in Apex Conquer where you could dump a ton of meteors into that interface through scrolls or loose items, and have it run through them all to attempt to socket an item also included in the interface.

I'm currently working on the replacement wiki, which I know is taking a while, but I'll be sure to add more documentation about that message. You should be able to do the same thing on the client side. An input XORed twice by the same number results in the original input again.

Oof, yeah. That would be great to have. Unfortunately, I don't have that either.

I'm going to go off the assumptions that I heard previously about the patch, but I'm interested about when they added potency. I'll try to start up a client soon and verify your findings. If someone else can verify that before me, then I'll go and fix it up. I might not be able to get to it this week since I'll be traveling.

You can always put something in, and then we can have a conversation about the changes on the pull request.

Good job on getting things up and running. For documentation, I'm actually actively working on a new wiki that's easier to contribute to using mdbook and GitHub. But that's going to take some more time to complete. Your best resource right now is going to be other questions made in the past on epvp and other server projects. You might, yeah. For things like NPC spawns. It'll depend on how you want to implement NPCs, but you may decide to script dialogs in Lua or another language. And you're welcome to contribute back to Comet if you choose to using pull requests. Yup! There's an article on my website that talks a bit more about that as well. That'd be great! You're always welcome to put in a pull request to fix up the readme in the repo, as well.

You're right. If you're using a private IP address, then you don't need to worry about port forwarding. So if your firewall is set up correctly and you're still not getting the first message from the client, then I'd say it's probably a client configuration issue? Or maybe your anti-virus has another firewall that's preventing the ports from being exposed? And yeah, the "Account Server has connected" is expected. That's the game server and account server establishing a connection to each other for authorization sharing. Where did you download the client, and how are you starting it? You're running patch 4294, right? So you could try running without the custom loader with just the modified server.dat file. You'd run conquer.exe with the command-line argument "blacknull". For example, "conquer.exe blacknull" in a command prompt.

Hey Tim. Is the IPv4 address you're using a local IP address (something like 192.168.1.x) or a public IP address? If it's public and you're going through your ISP, then you'll need to configure port forwarding on your router. Make sure that the realm name in the MySQL database also matches the server name in the server.dat file. Let me know if you have any follow up problems / questions. Good luck!

Well, this conversation may be better on the thread for the server project: But generally, you'll be using Qt Creator. It looks like the source uses MySQL as well, so you'll need to install that. MariaDB is a good drop-in replacement for MySQL and easy to install. MySQL Workbench is a good tool for viewing what's in the database and importing databases.

I don't have a solution you can download. CptSky is really the main person behind this section. I didn't even know this game existed before him. But yeah, you can host a server just fine with this, but you'll need to program the features and NPC dialogs, etc. If you don't have experience doing that, then it's not too late to learn... but this is a very advanced first project. You don't need to bypass login, to my understanding. You just have to insert the records into the database. But again, this may be a difficult first project. Learning how to set up a Conquer Online private server may be a bit easier.

Hm... CptSky's server isn't going to be an out-of-box solution. It's going to need quite a huge amount of work, to my understanding. I'd love to see what you come up with, though. A registration website would be a good addition... but my guess is that you can create an account through the database for now. It's based on his COPSv7 source, so you can look that up for Conquer Online and probably get some more detailed setup instructions. Best of luck!

I'm not aware of any reverse engineering work that's been done with this game. You might be able to find tooling in Conquer Online that works, if you're lucky, but it's not a guarantee. You might have to start reverse engineering the client if you want a private server for this game. I'm not sure what changes were made to the cryptography, either... but that's at least detourable.

You should be able to start belief.exe from command line using the command-line argument "blacknull". So you can run "belief.exe blacknull" in a command-line terminal, or you can create a shortcut to the executable and add "blacknull" to the target. Blacknull was the name of a developer for the shell TQ used for that game, and it bypasses the play.exe requirement.

Oh! That's neat, if you have any old clients you wanna upload / share, then I can help mirror them. Just let me know.

I'll let Konichu talk about their design, but I can speak to Comet at least. In an ideal setup, there'd be some way of service discovery. So like, whether the RPC is through a REST API or just StreamJsonRpc over TCP (like it is in the original Comet project), there'd be an endpoint you can hit to discover running services. Consul is a really good method for doing that. There're other clever ways of transferring auth to the game server, like through the database. As long as you keep TTLs in mind for the auth token you generate and keep up the record. Adding a distributed cache like Redis would also be good for token TTL.

I have no problem with MySQL Workbench importing the backup. Same goes for using MariaDB instead of MySQL as a drop-in replacement. I recommend trying MySQL Workbench and see where that gets you. If you don't know how to import something with MySQL Workbench, then there're plenty of guides online on how to use it. I really recommend just searching for it. And if you get stuck still, post where you get stuck so others can help. Good luck!

I'd try using the official MySQL Workbench tool. https://dev.mysql.com/downloads/workbench/

I personally really like 4294. It's a super clean client.

Well, getting an error isn't the expected result... do you mind posting the error? 'Cause if you run into an error in one server and don't know how to solve it, then you're likely gonna run into it on another server. I follow his instructions to the letter, make sure everything has admin privileges, all the good stuff to make sure it can run, and i get this: Query Nov_16_Backup start [ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation [ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `DeleteCharacter`(IN _uid INT unsigned) BEGIN DELETE FROM characters WHERE UID=_uid; DELETE FROM items WHERE Owner=_uid; DELETE FROM nobility WHERE UID=_uid; DELETE FROM proficiencies WHERE owner=_uid; DELETE FROM skills WHERE owner=_uid; DELETE FROM associates WHERE UID=_uid; DELETE FROM associates WHERE AssociateID=_uid; DELETE FROM guildattr WHERE guild_id=(SELECT id from guild where leader_id=_uid); DELETE FROM guildattr WHERE id=_uid; DELETE FROM guild WHERE leader_id=_uid; DELETE FROM tasks WHERE owner=_uid; END [ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation [ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `DeleteGuildAttr`(IN guildId INT unsigned) BEGIN DELETE FROM guildattr WHERE guild_id=guildId; END [ERR] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '!=guildRank LIMIT 1; END' at line 3 [ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `DeleteUserGuildAttr`(IN userId INT unsigned, IN guildId INT unsigned, IN guildRank SMALLINT unsigned) BEGIN DELETE FROM guildattr WHERE id=userId AND guild_id=guildId AND rank!=guildRank LIMIT 1; END [ERR] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Rank, u.Level AS Level, g.donate_silver AS Donation FROM guildattr AS g LEFT JOI' at line 3 [ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `GetGuildMemberList`(IN guildId INT unsigned) BEGIN SELECT u.Name AS Name, g.rank AS Rank, u.Level AS Level, g.donate_silver AS Donation FROM guildattr AS g LEFT JOIN characters AS u ON u.UID=g.id WHERE g.guild_id=guildId && u.UID IS NOT NULL ORDER BY g.rank DESC, u.Level DESC, u.Name; END [ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation [ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `GetLastItemUID`() SELECT * FROM items ORDER BY UniqueID DESC LIMIT 1 ; [ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation [ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `GetNobilityRank`(IN donationvalue BIGINT unsigned) BEGIN SELECT COUNT(*) FROM nobility WHERE Donation>donationvalue; END [ERR] 1227 - Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation [ERR] CREATE DEFINER=`root`@`localhost` PROCEDURE `NobilityPages`() BEGIN SELECT * FROM nobility ORDER BY Donation DESC LIMIT 50; END [sql] Finished with error I scrolled through 100-some odd pages and didn't see anyone with the same error. Not sure if this helps, but the original thread says to uncheck an option called "Run multiple queries in each execution". If that doesn't help, then can you tell us what tool you're using to import the database?

Comet is a skeleton source. It doesn't do a whole lot. This forum in general still needs tutorials made for the existing sources out there, but that's slowly being worked on in GitHub. For now, I'd recommend trying Redux (it has a guide with lots of answered questions already). Would you happen to know of anywhere else? I tried following his guide and all i get is errors when executing the SQL in navicat. Well, getting an error isn't the expected result... do you mind posting the error? 'Cause if you run into an error in one server and don't know how to solve it, then you're likely gonna run into it on another server.

Comet is a skeleton source. It doesn't do a whole lot. This forum in general still needs tutorials made for the existing sources out there, but that's slowly being worked on in GitHub. For now, I'd recommend trying Redux (it has a guide with lots of answered questions already).

I'd be a little shocked if World Conquer used a 32-bit library, but you could try and replace the OpenSSL library it references with v1.x 64-bit, precompiled binaries: https://kb.firedaemon.com/support/solutions/articles/4000121705. Should be libeay32.dll.

Awesome! And no worries, enjoy messing around with that source.

Oh, I'm not familiar with that loader. This is the one we use here: Though, it doesn't have a workaround for flash built into it. If that loader also doesn't work, then I'd check the realms table and make sure the server name is correct there. It looks like you're using Storm, so that's what I'd expect to see in the realms table.