Questions tagged [mysql]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
31 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
2answers
87 views

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
vote
1answer
39 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
3answers
616 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 ...
-1
votes
1answer
690 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 ...
0
votes
1answer
192 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 ...
2
votes
1answer
92 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....
0
votes
1answer
77 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 ...
0
votes
1answer
108 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? ...
1
vote
0answers
172 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
vote
1answer
531 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 : ...
2
votes
2answers
419 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 ...
1
vote
0answers
53 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 ...
0
votes
1answer
162 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). ...
-1
votes
3answers
2k 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 ...
0
votes
0answers
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 ...
0
votes
2answers
1k 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 ...
0
votes
3answers
1k 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 ...
0
votes
3answers
724 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
3answers
363 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 ...
3
votes
1answer
1k 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 ...
0
votes
1answer
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://...
0
votes
1answer
876 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 ...
0
votes
1answer
310 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. ...
2
votes
2answers
1k 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 ...
2
votes
2answers
872 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 ...
2
votes
1answer
834 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 ...
3
votes
3answers
4k 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. ...
0
votes
1answer
491 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 : ...
2
votes
2answers
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 ...
1
vote
1answer
600 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 ...
-1
votes
1answer
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 ...