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

learn more… | top users | synonyms

5
votes
3answers
266 views

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 ...
5
votes
1answer
671 views

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 ...
5
votes
1answer
727 views

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 ...
5
votes
3answers
761 views

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 ...
5
votes
3answers
196 views

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 ...
3
votes
2answers
330 views

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 ...
2
votes
2answers
264 views

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 ...
2
votes
3answers
2k views

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 ...
2
votes
2answers
338 views

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 ...
2
votes
2answers
923 views

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 ...
2
votes
1answer
30 views

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 ...
1
vote
4answers
87 views

Save “Explored Area” to SQL Database

For a strategy game, the area "already explored" has to be saved to a DB, so that the player can (upon resuming his game) see where he has already been. The game will be a mmo-game, so i have to ...
1
vote
1answer
411 views

SQL Database using Adobe Air

How do you create an SQL database (I believe it's tinySQL/SQLite) using Adobe Air? I have searched around, and all sites give code, and then explains to wrap it within an xml document, for example ...
1
vote
3answers
1k views

MySQL Recursive Query (kind of) help to determine tech tree prerequisites

I'm trying to figure out how to do what I can only call a recursive query (my knowledge of MySQL is extremely limited). The game I'm designing has a tech tree with items to research that will grant ...
1
vote
1answer
321 views

Multiplayer (Database, Users,etc) for game

I'm am looking to add multiplayer into my game (2D Platformer in XNA C#) My worlds are quite large (Up to 30 Million tiles max, Average 20 million maybe. 2000x10000). You could say the game is quite ...
0
votes
1answer
554 views

SQl, noSQL, and Doctrine with Symfony 2.0

I've had the idea of creating a webgame for a while now, and as it becomes more and more accurate i started playing around with Symfony 2.0. First question : it seems that it is recommanded to use ...
0
votes
1answer
104 views

Saving and retrieving high-score data in XNA 4.0 [closed]

I made a game in XNA 4.0 and now I need to save the points in a database or in a file (or in something else). My goal is to store and retrieve the highest score if I choose that option in the main ...
0
votes
2answers
145 views

multi user web game with scheduled processing?

I have an idea for a game which I am in the process of designing, but I am struggling to establish if the way I plan to implement it is possible. The game is a text based sports management ...
0
votes
2answers
906 views

Integrating SQLite to Cocos2d-x at Xcode

I have downloaded SQLite C/C++ interface to work with Cocos2d-x. Created a database by Firefox SQLite plugin. Then tried the following code // sqlite implementation sqlite3 *db; ...
0
votes
1answer
75 views

Build / Destroy function design & security checks

I'm working on a browser based strategy game. For the moment I'm working on the build/destroy functions and I have a couple of questions about this. The main question is do you have advice on how I ...
0
votes
2answers
310 views

Game resources storing

I'm working on a browser-based RTS, and we are targeting 10k+ users with multiple towns per user. I have the following table townresources in which I store every resource value for every town ID: ...
0
votes
1answer
227 views

Need Feedback for PHP & MySQL Saving Game Progress

My team is planning to create a simulation game using Javascript, CodeIgniter and MySQL for the backend. It will be mostly click based, ie: There will be buttons for activities like Eat, Play, Study, ...
0
votes
0answers
38 views

GPU-Accelerated SQL Databases; CoGaDB and Others [closed]

While researching ways to enhance an overloaded game server's backend I came across this concept. It seems as though it could, combined with pikkoserver, increase concurrency. SQL Requests ...
-1
votes
1answer
164 views

Calculate Costs for Buildings

I have the following arrays: [costs] => Array ( [0] => Array ( [value] => 600 [name] => Wood ) [1] => Array ( [value] => 200 [name] => Stone ...
-2
votes
2answers
527 views

Multiplayer game over internet

How to construct my multilayer mode for my Delphi game? For LAN I use UDP server/client. But for internet I think UDP is useless. I have in mind something like: The host create SQL database and ...
-2
votes
1answer
1k views

Browser Game Database structure

users id username password email userlevel characters id userid level strength exp max_exp map id x y This is what I have so far. I want to be able to implement and put different NPC's on my map ...
-2
votes
1answer
618 views

Database for increased scalability in a mmorpg? [closed]

I am planning a simple MMORPG, but even though it's a small, open source project, I'd like to have the best quality database. Which would be the best database software to use? Examples: SQL - MySQL, ...
-3
votes
1answer
94 views

Why would selecting a lot of rows crash my game? [closed]

I have a databse that contains: id , playlistname , playlistnum and I want to get alll the rows where playlistname = "CoolPlaylist" and I want to parse them 1 by 1, so I thought of doing this: ...