Structured Query Language. A programming language designed for managing databases.
2
votes
2answers
213 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 ...
5
votes
3answers
222 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 ...
0
votes
2answers
140 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 ...
4
votes
3answers
174 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 ...
5
votes
3answers
460 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 ...
0
votes
1answer
629 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;
...
2
votes
2answers
240 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 ...
1
vote
1answer
286 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 ...
-3
votes
1answer
92 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:
...
2
votes
2answers
582 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 ...
0
votes
1answer
64 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 ...
-1
votes
1answer
146 views
Calculate Costs for Buildings
I have the following arrays:
[costs] => Array (
[0] => Array (
[value] => 600
[name] => Wood
)
[1] => Array (
[value] => 200
[name] => Stone
...
0
votes
2answers
259 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:
...
1
vote
1answer
346 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 ...
-2
votes
2answers
433 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 ...
