Structured Query Language. A programming language designed for managing databases.
0
votes
0answers
42 views
Part of games entirely based on MySQL [closed]
I was thinking if in your opinion there would be any problem creating entire parts of a game with MySQL, that means without using any kind of internal multidimensional variables to store the data.
I ...
0
votes
2answers
126 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
168 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
394 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
581 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
230 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
262 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
493 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
142 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
241 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
319 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
417 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
502 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
200 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, ...
-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 ...
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 ...
0
votes
1answer
446 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 ...
-3
votes
1answer
535 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, ...
2
votes
3answers
1k 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 ...
3
votes
1answer
500 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 ...
