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
63 views
cost of Adding Social Feature to your game such Creating guilds/guild chat [closed]
I'm making a f2p game in unity C#. The game currently has no social features.
I would like to have players to have their own accounts and also a guild tab. This tab is where they can create a guild ...
-1
votes
1answer
123 views
Should I use a SQLite for this game? [closed]
I'm planning a board+trading card game. It's exactly the same game as Hero Academy, but with trading cards, and customisable decks. I'm in the Software Design phase, and I'm thinking about using ...
-1
votes
1answer
99 views
Server Based High Scores
I'm currently using the following MySQL example to make a server side high score table: Unity Server Side high score
The above example allows me to create a top 5 player high score table that sorts ...
0
votes
1answer
73 views
Suggestion on Database Design [closed]
I am developing an MMOG (not specifically RPG), in this MMOG there are several mini games which the user can play. Users can earn gold from this each of this mini game (depending on their score).
...
7
votes
4answers
419 views
Is there a way to make a dynamic world such as a MMORPG horizontally scalable?
Imagine a open-world of 500+ players with data changing as fast as 20 updates/player/second. Last time I worked in a similar MMORPG, it used SQL, so obvioulsy it couldn't query the DB all the time. ...
0
votes
1answer
79 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
71 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 ...
2
votes
2answers
148 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
70 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
252 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 ...
2
votes
5answers
405 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
76 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
201 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
104 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
506 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
215 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
295 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
144 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
259 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
109 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
290 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
188 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
246 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
235 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
270 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
122 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
406 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
207 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
166 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
191 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
316 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
122 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
165 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
303 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
108 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
1k 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
419 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
253 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 ...
1
vote
3answers
685 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
205 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
189 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
363 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 ...
3
votes
2answers
356 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
197 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
944 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
462 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 ...