Questions tagged [mysql]
The mysql tag has no usage guidance.
40 questions
1
vote
0
answers
32
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
829
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 ...
0
votes
1
answer
48
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
84
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
65
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
181
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
642
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 ...
- 144
0
votes
1
answer
273
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
184
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
107
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
200
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
0
votes
1
answer
110
views
Better way than url-encoded query stings to pass data from PHP to Flash?
For the turn-based browser Flash RPG I'm working on, I'm using url-encoded query stings to pass data from PHP to Flash. Basically, Flash posts a request to PHP, then PHP pulls some data from a MySQL ...
- 137
0
votes
1
answer
120
views
How to store the updated score in mysql databse from android?
I want to store the updated score in mysql database. So, what i do for that?
...
user109752
1
vote
2
answers
418
views
How come serverless functions are so much more expensive than a VPS hosting my PHP API?
I'm working on an online turn-based game. I will have a server, but it will be used strictly for storing match data and relaying it to the match's participants (or spectators). For simplicity, no game ...
- 1,763
1
vote
1
answer
2k
views
How to program an experience-based levelup system where experience carries over to the next level?
I'm new into programming, and i've tried to do a system of level up. Here it is :
...
- 11
4
votes
2
answers
2k
views
Storing quests for an online RPG in a MySQL database
I'm creating an online RPG game and I've been looking around for a way to save players' progressions in quests in MySQL. I've been looking at Pim Jager's answer answer for a while and I've come to the ...
- 109
1
vote
0
answers
66
views
Best way to connect and save data in an online Android game [closed]
I'm new here, I'm in need of a help as it would be the most ideal way to proceed with my project.
The project is very simple, a basic online rpg for android in specific (in the future can be migrated ...
- 11
0
votes
1
answer
215
views
MMO server use mysql offline?
Im going to write an MMO server for a game, however in my last attempt to do this I used mysql with xampp-server and the game-server was getting the data offline tru mysql(xampp server was offline).
...
- 157
-1
votes
3
answers
4k
views
How do I make a highscore database for Unity?
I have been looking around, but I haven't found the perfect answer, yet.
I want to to send scores from Unity to a database, without a username, and display the high scores in the highscore menu. How ...
- 11
0
votes
0
answers
2k
views
Save and retrieve image from database in unity
I have done a sample to insert and retrieve data from MySQL in unity.Now I need to insert and retrieve image from MYSQL in unity. The images are files selected by the user from their filesystem.
Can ...
- 807
0
votes
2
answers
3k
views
Should clients in an online game access the database directly or through a game server?
first im total noob about c# and mysql. Just trying to find which way is better. i believe your answers prevents me from losing plenty of time.
Online game(not more than 50 users at pre-alpha. Not ...
- 9
0
votes
3
answers
2k
views
Database works on unity editor,but not on android device
I am working on database connectivity in unity.When I run my project I am able to access my database(retrieving and inserting data into database).But the problem is that when I take the android out ...
- 807
0
votes
3
answers
1k
views
How do I keep a PHP server running forever?
I'm making a web game RTS, it's mostly create units, manage resources, attack with army, and level up factories. I have created the basics of the game using Javascript, PHP, and MySQL databases. I use ...
-4
votes
3
answers
478
views
Should I create an MMORTS game with server side coding? [closed]
I have gone through many articles on the internet and got to a final conclusion that their is almost no way to protect the game (it can be hacked or its code can be extracted from its APK) and should ...
- 483
3
votes
1
answer
2k
views
Libgdx Networking (http requests) - Login [duplicate]
I am new to Networking and Databases,
but im trying to learn MySQL and HTTP Requests to create a
user Login for a game.
My goal is to let users create accounts and login to them etc (for Highscores ...
user72229
0
votes
1
answer
2k
views
Mysql database reading and writing [closed]
In my Libgdx application I would like to be able to connect to a mysql server securely and read and write data from it without other users injecting, or changing information. I've found this: http://...
- 135
0
votes
1
answer
1k
views
What is the correct way to authenticate a player with password from Unity to a php api server?
So, I have a game in Unity for mobiles that gives you the possibility to sign-up with username, email and password to unlock extra features.
The datas are sent, through a POST request, to a PHP+MYSQL ...
- 326
0
votes
1
answer
364
views
Collectible Card Game Card Text To Code Association
I am making a collectible card game using a command pattern for using card abilities and creating a class for each card text ability. The game is setup to work with an authoritative server structure. ...
- 165
2
votes
2
answers
2k
views
RPG: store dialog
I'm creating a single player web RPG. I was originally storing NPC dialog in a JS object. I could cycle through lengthy dialog in an array as I wanted. I can also store objects with K:V pairs.
That ...
- 1,055
2
votes
2
answers
1k
views
In MySQL, how would I model moves that Pokemon can learn?
I'm making a Pokemon MMO Game with Unity + SmartFoxServer/MySQL. At the moment I'm creating the base structure for the database.
If you are not familiar with Pokemon Games, every Pokemon can learn ...
- 230
3
votes
1
answer
2k
views
When to read/write to database with a game server
My question is fairly simple but maybe hard to answer. I'm currently building my own game server and I've done to login server now. So, on to the actual game server. I have a question for this server ...
- 371
3
votes
3
answers
7k
views
Why should I not use MySQL for a browser based game?
I keep reading on here that I shouldn't use MySQL for game development/play on the Internet, a browser game. I understand MySQL wasn't made necessarily for that and for big relational needs. Ok. ...
- 271
0
votes
1
answer
528
views
Structure examples for web-based chat for web-based game [closed]
What would be the best tools to use to create a web based chat/messaging system ?
for client we have :
Browser (any JS solution - preferably without using flash like in jsocket)
for server we have :
...
- 181
2
votes
2
answers
2k
views
how to implement pvp(text based rpg in php/mySQL)
I'm creating a text based rpg in php/mySQL and I've come up to a dead end in regards implementing the pvp aspect of the game. First off is this even possible in php/mysql? If so, how would I go about ...
- 121
1
vote
1
answer
622
views
How to handle a player's level and its consequent privileges?
I'm building a game similar to Mafia Wars where a player can do tasks for his gang and gain experience and thus advancing his level.
The game is built using PHP and a Mysql database.
In the game I ...
- 139
-1
votes
1
answer
1k
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 ...
- 1,011