Questions tagged [sql]

Structured Query Language. A programming language designed for managing databases.

Structured Query Language. A programming language designed for managing databases.

48 questions
31
votes
5 answers

How does mmorpg store data?

I want to use sql database in my server.exe. lets say 1000 users online. And players will change their data when they play. And server need to save these updates. But how ? i think there two way: 1) server will save in ram at run time and sometime…
Emre Kaya
  • 555
  • 1
  • 5
  • 13
7
votes
3 answers

Actually utilizing relational databases for entity systems

Recently I was researching several entity systems and obviously I came across T=Machine's fantastic articles on the subject. In Part 5 of the series the author uses a relational schema to explain how an entity system is built and works. Since…
Marc Müller
  • 1,007
  • 11
  • 17
7
votes
1 answer

MySQL - Storing Character Inventory

What is the best way of storing the character's inventory (consisting of each item having a value for type and quantity). The only methods I can think of is to use the "text" type of field then parse the value from that whenever the inventory is…
jSherz
  • 235
  • 2
  • 5
6
votes
3 answers

Mismatch of Entity System and Savegames

There is a theoretical mismatch of the entity system and the savegame system, which is think is common, but I haven't found resources about that. Therefore I will explain both systems first, as short as possible. I would really appreciate any…
danijar
  • 5,771
  • 10
  • 44
  • 65
5
votes
1 answer

Strategy/City Builder browser game - technical details

I actually have multiple questions into one. Hopefully someone can hit all of them. I wanted to give a try at a massively multiplayer web based game. Basically, the game would have similarities to Evony, or Eve Online (a much scaled down version).…
saccharine
  • 153
  • 4
4
votes
3 answers

Labeling Areas on a map

I've been wondering how you would go about labeling an area on a 2D tile map. What I'd like to do is associate tiles with an area i.e Forest Area, Desert Area, etc. Keep in mind this is an idea, so far I've been thinking that one way to go about…
Norm
  • 141
  • 4
4
votes
3 answers

Using SQL for a Realtime Multiplayer Game Server's Working Data (Fast Enough?)

The game I'm working on currently has a Client in Flash AS3, and a Server in C# (multithreaded). Currently I use mySQL to handle logins (Raw access: no middleman for accessing the database) which seems to be extremely quick. My question is would…
Adrian Seeley
  • 739
  • 8
  • 12
3
votes
1 answer

Conversation tree and question locking/unlocking

I have been having issues with managing a conversation tree. I am using PAWN as a scripting language (I have no other options, unfortunately) and I use MySQL databases to store user and game data. My current issue is storing game conversation trees…
user49277
  • 31
  • 1
3
votes
2 answers

Alternatives to storing all my entities in an SQL database

I've been trying to build my entity system based on pure SQL data storage as explained in this post series . The idea is that every entity or component is stored in an SQL table. I created my framework to manage that, only to realize that many SQL…
nialna2
  • 930
  • 1
  • 9
  • 19
2
votes
0 answers

Battle Engine for Text based browser game

I am starting to code a browser game, I have a rudimentary chat set up, and would like to start creating the battle engine, I have a general idea of how I want it to play out, but I don't know where I should do the calculations, SQL Server ASP.NET I…
Malachi
  • 125
  • 6
2
votes
2 answers

Best practice to implement persistent data when using Tiled TMX map files?

A friend of mine and I are always talking about our current progress in learning game development. Recently, saving the game (data persistence) came up, and when I summarized how I tackled that for my project, he thought I should post a question…
Mike DePeel
  • 53
  • 4
2
votes
2 answers

Unlimited inventory system?

I am working on a small game, I need to add an unlimited inventory to the game but I am not sure how to do it. I have an inventory system with a specific amount of slots, here it is: <?xml version="1.0"?> <player> <username> XXX </username>…
Melon
  • 31
  • 3
2
votes
2 answers

Convenience of mySQL over xml

Currently I use XML to store specific information to correctly load a few things such as a list of specfied characters, scenes and music, Once more I use JAXB in combination with standard compression/decompression(ZIP) functionality to store a list…
kdgwill
  • 133
  • 6
2
votes
2 answers

How should I store a Game Database on Android?

I'm looking at creating a game for Android and while I have most of the ins and outs worked out, the one thing I'm struggling with is how to store data for the game. Ultimately, the game will be based off of a lot of pre-defined data and statistics…
LiamGu
  • 123
  • 1
  • 5
2
votes
1 answer

Android native database organization

I am developing an Android native game, but I have problems with Data Storage. For a better comprehension think it like as i am developing Clash of Clans, but with Native Andorid. Now imagine I have to store all datas for Buildings, moneys, troups,…
Pier Giorgio Misley
  • 165
  • 3
1
2 3 4