Online Game (SQL)

Discussion and feedback on Construct 2

Post » Fri Feb 15, 2013 2:58 pm

Yes, you can certainly couple C2 with SQL Server, by using Construct's AJAX object to make a request to a server-side script (e.g. a .NET .ashx handler) that calls a stored procedure in the database. I've done this to create a multiplayer "simcity"-style game in a shared world, but never an MMORPG.

Whether this is a good design for your game or not really depends on the requirements of your project. SQL Server is a relational database, just like any other (Postgres, MySQL, Oracle, DB2...). It's good for storing and accessing large amounts of data (think gigabytes at the minimum), but it's not going to be as efficient as an in-memory or local storage option if you're just storing a small amount of data.

If you're going to be loading level/terrain data in discrete stages (e.g. retrieve the current location of items/characters from the database when the game first loads, or when the player enters a new area, and write back to the database only occasionally when they change) then this would work well. However, it would not be so efficient if you want to send continuous packets of data to and from the server representing each character's actions in real-time.

As others have mentioned, there are a lot of complex issues in MMORPG design, and a lot of clever workarounds required to keep the world synchronised between players. If this is your first project, I'd seriously recommend you scale down your aspirations to start with - perhaps just create a 2-player game in which the world is synchronised via a central server - and then work up to something like this. Good luck!
B
8
S
2
G
3
Posts: 83
Reputation: 2,668

Post » Fri Feb 15, 2013 3:04 pm

My game for the Ouya is kind of a multiplayer game and with AJAX, PHP, and Mysql it works great. Its the type of game which doesn't require millisecond response time, thats why in my case it works.
B
17
S
9
G
7
Posts: 249
Reputation: 6,922

Post » Sun Feb 24, 2013 5:44 pm

[Portugus]
O Construct 2 um Engine de Game 2D e com milhares de configuraes que os desenvolvedores (Tanto profissionais quanto estudantes) de games podem fazer em seus jogos com muita facilidade. Mas com tantos exporters para diversas plataformas de games, por que a Scirra ainda no fez o Plugin que constri o jogo em base de MMORPG's? Imaginem ns, desenvolvedores de games do Construct 2 fazer MMORPG em nosso familiarizado Engine. Seria muito bom se a Scirra l-se este post no frum, porque ela s tem a ganhar.

[Ingls - Google Translater]
The Construct 2 is a 2D Game Engine and thousands of configurations that developers (both professionals and students) can make games in their games very easily. But with so many Exporters for various gaming platforms, why are not logged Scirra Plugin that builds the base game in MMORPG's? Imagine us, the game developers Construct 2 do in our familiarisado MMORPG Engine. It would be great if Scirra read up this forum post, because she has everything to gain.
B
30
S
4
G
4
Posts: 31
Reputation: 4,561

Previous

Return to Construct 2 General

Who is online

Users browsing this forum: No registered users and 10 guests