Software designed to store massive amounts of data in a queryable form. The data is typically organized to model relevant aspects in a way that supports processes requiring this information.
0
votes
1answer
52 views
How to setup Authentication Database and Game Database?
I'm playing around with creating a game in C# using the XNA Framework. I've decided to use technologies that I'm pretty much familiar with and create things from scratch. There are probably frameworks ...
2
votes
2answers
55 views
web based quizz game database design, how do I store results? [closed]
I'm building a very basic quizz type of php/mysql/ajax game.
At this stage I'm thinking about the DB design, and specifically how to score results, I've two options in my mind. But cannot decide ...
-5
votes
0answers
84 views
Multi-player Online Role Playing Game [closed]
"I want to the database structure for the following case."
Users or players of the game are have an id, an email address and a password. Users are allowed to change their email. Users are either ...
2
votes
2answers
131 views
Integer vs String for “type” data in data-driven games
I've been developing a few mobile games, in which those games fetch their data from a server-database.
I'm used to storing "type" values as an integer identifier, and an enum in the client to ...
2
votes
2answers
62 views
Centralized User database for multiple Systems
I was wondering, how do large companies handle user accounts and allow different applications to access them.
One example that comes to mind is Riot, their game League of Legends has a global user ...
0
votes
3answers
210 views
Is there any public in-game data mining/knowledge discovery repository?
I'm taking an Introduction to Data Mining course at the university and we have to work on a final project.
As you may already know, it's difficult to collect this kind of data manually (specially ...
1
vote
5answers
384 views
Saving data in games?
I'm soon going to make a game for the iPhone as a school project.
My idea was to make a TLOZ remake, with Tiled Maps.
However, I'm not quite sure how save the data.
In TLOZ you have a lot of ...
1
vote
0answers
71 views
What is the right way to use a QStateMachine for a text adventure game?
I have seen a couple topics about this already but they were a bit vague for me so I decided to make this. I'm working on a little adventure game just for fun in Qt, its basically just text on the ...
0
votes
3answers
160 views
Persistent Data for Multiplayer, Browser-Based Games
What is generally used to store persistent data in online games - browser games/facebook apps, in particular?
I have used MySQL in web development before - but I've read that it's not very scalable, ...
1
vote
1answer
102 views
How to model / where to store relational data between classes
I'm trying to figure out the best design here, and I can see multiple approaches, but none that seems "right."
There are three relevant classes here: Base, TradingPost, and Resource. Each Base has a ...
3
votes
2answers
407 views
Use a SQL Database for a Desktop Game
Developing a Game Engine
I am planning a computer game and its engine. There will be a 3 dimensional world with first person view and it will be single player for now. The programming language is C++ ...
2
votes
3answers
205 views
How to store and update data table on client side (iOS MMO)
Currently I'm developing an iOS MMO game with cocos2d-x. The game depends on many data tables (Excel file) given by the designers. These tables contain data like how much gold/crystal will be cost ...
2
votes
2answers
251 views
Game Database Connectivity Java
I'm developing a simple multi-player puzzle game in Java. Both players should be able to view the same game board on his own computer. Then, when one player makes an action in the game (ex. drags an ...
2
votes
0answers
113 views
ECS, databases, XML and serialization
My entity/component/system engine is coming along quite nicely; I have two very different apps working on the same executable. (One 2-d scroller, one 3D Asteroids-type game).
In the interest of ...
3
votes
2answers
231 views
C++ Database vs Reading Files
Ive been programing a C++ game/server for the past year. I have been using MYSQL for character logins, items, monsters, etc, etc. (im on windows). My question is, what are some of the databases that ...
0
votes
2answers
100 views
Algorithm for querying linearly through a non-linear list of questions
For a multiplayers trivia game, I need to supply my users with a new quizz in a desired subject (Science, Maths, Litt. and such) at the start of every game.
I've generated about 5K quizzes for each ...
1
vote
2answers
273 views
Passive skills and items
I'm making a small text browser RPG game using PHP, MySQL and Java Script (and jQuery). All the items are saved in the MySQL database.
Every now and then a character have to make a skill roll (Talk, ...
0
votes
1answer
180 views
What database engine to use? [closed]
What database engine would be appropriate for an online multiplayer card game(with many different cards) done in Flash?
MyISAM seems to be the one because of full-text search and good read speeds, ...
1
vote
1answer
237 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 ...
1
vote
3answers
218 views
Best practice for saving items?
In a game that I'm working on, any player has (at max) 460 items within their inventory. Each item has simple attributes, such as owner and quantity, but equips have different attributes, such as ...
4
votes
2answers
250 views
game multiplayer service development
I'm currently working on a multiplayer game. I've looked at a number of multiplayer services(player.io, playphone, gamespy, and others) but nothing really hits the mark. They are missing features, ...
7
votes
1answer
105 views
Multilingual data bases for most common words and phrases used in games
Games tend to have easy to understand instructions/menus/tutorials and so on, so I was wondering whether...
Are there multilingual data bases, built-in with the most common phrases used in games?
...
2
votes
2answers
342 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 ...
1
vote
1answer
204 views
How can I keep track of a battle log on a web game?
Recently I started working on a Web turn-based PvP RPG game. Now I'm working on the battle system but I encountered some issues:
How can I keep track of everything that happens in the battle? It ...
-1
votes
1answer
163 views
How to define 648 units, with 22 different values in Java
A friend and I are currently looking at developing a game, with similarities to a certain trademarked francise.
To define the units in the game, we've created an abstract class which denotes the 44 ...
-1
votes
1answer
173 views
multiplayer tic-tac toe checking if other player is in game or not
I am developing a multiplayer tic tac toe game. The issue I'm facing at the moment is knowing whether the other player is in the game or not. Each player is running their own session, and should a ...
2
votes
2answers
291 views
jMonkey Quest Database
I am building a game in jMonkey (Java) and I have so far only used default quest text. But now I need to start populating a lot of quests with text. My design requires A LOT of quests texts.
What is ...
1
vote
2answers
116 views
Implementing an existing (but out of print) game electronically
One of my favorite games is the old Avalon Hill class, PanzerBlitz.
I would like to implement it electronically, and have a couple questions related to that:
Would I be in legal trouble if I do ...
-4
votes
1answer
154 views
Database structure for level packs, levels and level information
I have a game which shall consist of several level packs (and also be extended by additional level packs). Each level pack should contain some levels. Each level will have its own level information.
...
1
vote
1answer
286 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 ...
0
votes
2answers
99 views
Storing Player Location/Data in an Online Game
I know this question has been asked and answered in some threads, but I'd like a more beginner dumbed down explanation.
So player information, specifically direction and position, need to be updated ...
2
votes
1answer
891 views
How do I implement a score database in Android?
I making a 2D game for Android using OpenGL-ES technology. It is a space shooting game where the player shoots enemy ships.
I want to keep a track of score for the amount of enemy ships destroyed ...
5
votes
1answer
384 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
2answers
1k views
(XNA) What's a Good Database Program for a Turn-Based RPG?
I'll begin by saying that I feel my level of expertise matters here, and so I have about a year worth of experience as a programmer in the C# language and most of the .NET framework as a whole, but ...
1
vote
1answer
224 views
Implementing an online database
I'd like to get into online games programming. I thought that as a start i'd be a good idea to implement an online database that would store the progress and score for a game i have made, i'll ...
0
votes
3answers
651 views
How do RPG store and retrieve maps?
I'm making a very basic online RPG (2d, and instead sprites I use characters, like a roguelike) and I still haven't figured out how to store and retrieve maps. Until now I used a text file that's ...
3
votes
2answers
202 views
Real time data retrieval - database vs file system
I'm planning to develop a game in which I want to draw 3d models in real time using some given x,y,z coordinates. The coordinates will be given at an average of 30 coordinates per second. Drawing will ...
1
vote
2answers
1k views
NoSQL (CouchDB) database design for MMORPGs
Are there any pratical examples of database implementation for an MMORPG in CouchDB? Even a detailed thesis? I've looked but found very little on practical examples and not even find any good UML ...
0
votes
1answer
166 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, ...
0
votes
4answers
333 views
Is there an in memory data store that is feasible for real time, non-networked games?
I would like to know if anyone has recommendations or experience with using an in memory data store for a real time, non-networked game. This is not necessarily for loading levels or saving data, but ...
2
votes
2answers
315 views
How should one design an analytics system for an online multiplayer game?
For my simple MMO, the MySQL database stores things like user experience, user level, user coins, health points, etc.
We wanna have an analytics system that can show me trends through daily ...
4
votes
1answer
188 views
Using heavyweight ORM implementation for light based games
I'm just about to engulf myself in an MVC-based/Component architecture in C#, using MySQL's connector/Net for the data storage, and probably some NHibernate/FluentNHibernate Object-relational-mapping ...
-2
votes
1answer
889 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
436 views
Is my technique for client-side character movement in an MMORPG reasonable?
I started an MMORPG game, and I can already make a character move around the map and see other characters. But I have doubts about my architecture.
I have a loop which, every x milliseconds, request ...
10
votes
4answers
1k views
How should I track players' real-time positions in an MMO?
How do you keep track of the positions of the players in a MMORPG? I read that you can use either a database or you can store the coordinates in files. I tried using a database but it was slow. How ...
4
votes
2answers
456 views
How do I store Items in MySQL?
I'm working to my first game containing items (built a small one before, strategy type but not very complicated). I was thinking something like this for the db design since it will be almost the same ...
0
votes
1answer
406 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
472 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
2answers
398 views
Crafting recipes: storage and quering
Consider following situation. In a game you can perform crafting: i.e. create new items from existing ones (like in Minecraft). I have following game entities (simplified):
item: atomic part;
...
