Structured Query Language. A programming language designed for managing databases.
0
votes
2answers
59 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
160 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
334 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
504 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
226 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
249 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
91 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
429 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
63 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
139 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
228 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
305 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
390 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 ...
5
votes
1answer
425 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 ...
0
votes
1answer
192 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, ...
