Questions tagged [sql]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
24 views

Separate data tables for different item types?

I have two types of items in my game, consumables, and equipment. For my database, should I store them in two different tables, or all in one big items table?
22
votes
5answers
10k views

How does mmorpg store data?

I want to use sql database in my server.exe. lets say 1000 users online. And players will change their data when they play. And server need to save these updates. But how ? i think there two way: ...
1
vote
0answers
48 views

How can I give to player points with ajax but secured? [duplicate]

I have a virtual world game that I developed with jQuery, AJAX and PHP. Virutal World like club penguin. Now, I want to add a game into the virtual world - like bubbles or whatever. The main problem ...
0
votes
2answers
498 views

How to Structure my Database for a HTML turn-based strategy game?

I'm making simple HTML socket game that I want to record over time. It's a "risk" type game where individual tiles can be conquered, and the team with the most tiles is winning. As of right now, I'...
1
vote
1answer
417 views

Game data structure in node.js

I am building a simple turn-based game in node.js using sockets.io. My web experience with node.js has typically involved saving everything to a relational database. I set this up for my game. I am ...
0
votes
1answer
107 views

Online Tower Defense : Problem in protecting user's data [closed]

Sorry about the question heading I am creating an online tower defense game with SQL Server 2008 as my database. SQL user used to send data to server is restricted to only execute existing ...
2
votes
1answer
243 views

Android native database organization

I am developing an Android native game, but I have problems with Data Storage. For a better comprehension think it like as i am developing Clash of Clans, but with Native Andorid. Now imagine I have ...
1
vote
1answer
2k views

Database for a diablo 2 like item system?

Diablo 2 has a very sophisticated item system and I want to create something similar. But I am having a hard time getting the architecture right. In Diablo 2 most different kind of gear has different ...
0
votes
1answer
116 views

SQLite Query from unknown table based on known column value single query

I'm working on a database to back up my online TCG. It's currently SQLite, but I'm going to transition it to a MySQL database later. Currently, I have three distinct types of cards with their own ...
0
votes
1answer
268 views

ASP.NET Browser game Timers

I am developing a simple browser game, using ASP.NET, C# and SQL Server 2012. I need to implement build time of some unit or building. One way would be storing finish date to database and just fetch ...
2
votes
0answers
492 views

Battle Engine for Text based browser game [closed]

I am starting to code a browser game, I have a rudimentary chat set up, and would like to start creating the battle engine, I have a general idea of how I want it to play out, but I don't know where I ...
2
votes
2answers
1k 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 ...
3
votes
1answer
208 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
2k 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
278 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
2k 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
626 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: ...
6
votes
3answers
689 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
191 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
230 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
3k 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
2k 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 ...
2
votes
2answers
309 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 compression/...
1
vote
1answer
577 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
98 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 ...
2
votes
2answers
4k 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
88 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
183 views

Calculate Costs for Buildings

I have the following arrays: ...
0
votes
2answers
451 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 ...
1
vote
1answer
673 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
994 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
1k 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 ...
1
vote
1answer
307 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
2k 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 ...
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
964 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 ...
-1
votes
1answer
822 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, ...
4
votes
3answers
6k 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 ...
7
votes
1answer
3k 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 ...