Questions tagged [mysql]
The mysql tag has no summary.
40 questions
1
vote
0
answers
47
views
Database or arrays
Generally for an RPG, would you say a DB like SQL server and MYSQL is over kill? RDB seems really convenient to pull and call from an inventory item for example, yet I see arguments that it is too ...
- 11
0
votes
1
answer
970
views
proper items db design mysql
I'm working on a game using MySQL as the db. I'm struggling a bit on the database design, this is the part I'm struggling with:
So basically exp_ups, mystery_boxes and weapons are entities in the ...
- 101
0
votes
1
answer
86
views
What aspects do I need to consider when designing save-data of equipment reference in MySQL for online game?
Currently I have several things to save in MySQL for an online game. For simplicity let's say there are heroes, weapons and armors, where heroes can equip weapons and/or armors.
Now I am facing three ...
- 153
0
votes
1
answer
1k
views
How many database servers does an online game need to handle around 100000 users per day?
I don't need an exact number but I want to know roughly how many MySQL servers do I need to rent if I were to develop an online RPG game that has roughly 100000 users per day (assuming on average 1 ...
- 153
0
votes
1
answer
109
views
Java application chokes - when using MySQL
If I use localhost - XAMPP, my application runs without problems.
Once I try to use real MySQL databases: db4free.net, freedb.tech.
Applications begins to choke and freezing, resulting it is nearly ...
1
vote
1
answer
83
views
I need to improve my ring shop. help with array, loop & query PHP [closed]
I have an array setup which consists of 25 rings, names, stats, prices. Right now in its current form, I have a form setup with 25 radio buttons with a value of 1-25 on them, and I'm using If ...
- 11
0
votes
0
answers
226
views
Proper way to handle timers at scale
At scale for multi-users, what is the proper way to implement timer updates?
I'm making a game where Users have buildings to upgrade which involve timers (Yes I know there are plenty of questions ...
- 1
1
vote
6
answers
825
views
How to deal with players having too much money (or any large numbers)?
I'm working on a browser MMORPG in PHP and MySQL and today got a bug report about int32 overflow, due to the player having too much money. When I was designing the core system, I completely forgot ...
- 146
0
votes
1
answer
312
views
Timed Events in a Unity WebGL game with a PHP / MySQL Server
I want to make an online WebGL game with Unity with button based interaction.
So far I have my login and registration system, with some tables in MySQL to deal with that kind of stuff.
Next I need ...
0
votes
2
answers
230
views
Race condition implementing World Boss System in Web Browser MMO using PHP
I am trying to create a world boss system using PHP. But I am having a problem with how to account for all the damage while updating the health of the boss in real-time.
The current damage process is ...
- 1
1
vote
1
answer
141
views
SQL Server Question: How to go about using a collection of cards
So basically I'm new to SQL Servers and for that matter generally to Server Logic and Server behavior. (Used to only work on single player games) OK, so my questions is as followed. Lets take ...
1
vote
3
answers
2k
views
MySQL for MMO-Development... What do i have to consider ?
Im currently developing an little mmo.
Its pretty basic, players can walk around... gather some resources... build some simple buildings and craft things.
Before i began to develop i read a lot about ...
- 517
0
votes
1
answer
1k
views
Retrieve multiple images from MySql database via Unity C#
We could say that we are beginners, We can consult and show our data (text) from Mysql but the images don´t show in Unity. Need some help! We hace tried almost everything! We can someone help us.
in ...
- 1
0
votes
1
answer
1k
views
Best way to store items with statistics in an mysql database?
Im currently working on an multiplayer game. Therefore using MySql for my game to store different data ( For example players, resources and so on ).
Lately i implemented items, players receive them ...
- 517
2
votes
1
answer
238
views
Feasible to do all game logic on PHP server?
For the turn-based browser Flash RPG I'm working on, I'm keeping all player stats in a MySQL database, with PHP as the go-between, for the sake of persistence and to prevent cheating by memory editing....
- 137