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

learn more… | top users | synonyms

0
votes
0answers
9 views

Interacting with custom SQLite in UE4

How can I interact with my own SQLite databases in Unreal Engine 4? Can it be done via blueprint and C++ or would it have to be purely C++?
1
vote
1answer
142 views

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 ...
2
votes
1answer
38 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 ...
0
votes
1answer
267 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 ...
1
vote
4answers
103 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 ...
3
votes
2answers
432 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
370 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
285 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
147 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 ...
5
votes
3answers
198 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
942 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
2answers
1k 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
277 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
339 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
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: ...
2
votes
2answers
1k 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
76 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
167 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
323 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
434 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
552 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
734 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
235 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
2k 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
602 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 ...
-2
votes
1answer
643 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
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 ...
5
votes
1answer
848 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 ...