x

Search in
Sort by:

Question Status:

Search help

  • Simple searches use one or more words. Separate the words with spaces (cat dog) to search cat,dog or both. Separate the words with plus signs (cat +dog) to search for items that may contain cat but must contain dog.
  • You can further refine your search on the search results page, where you can search by keywords, author, topic. These can be combined with each other. Examples
    • cat dog --matches anything with cat,dog or both
    • cat +dog --searches for cat +dog where dog is a mandatory term
    • cat -dog -- searches for cat excluding any result containing dog
    • [cats] —will restrict your search to results with topic named "cats"
    • [cats] [dogs] —will restrict your search to results with both topics, "cats", and "dogs"

2019 Guide To UE4 & SQL Database?

Hello,

I have read (exhaustively) everything on the forums about plugins and 3rd party providers for multiplayer data storage. Also I have watched just about everything out there on youtube as well. I have come to the conclusion that there is no up to date guide on how to setup communication between client (remote player) and central online database that stores info specific to that player. My goal is to have a player log in and it to load that player's stored health value, level value, and other important info and then save it intermittently to the database while playing.

I started using GameSparks because I thought it was going to be a not-so-painful way to setup authentication and this form of client to server to database communication. I was able to set up authentication easily because they have documentation on how to do that. However, they have almost 0 support to help me get these custom scripts set up and running. I have tried for a few weeks to store a single float to the database and have not been able to accomplish it.

I have also checked out Rama's save plugin. And while this might work if I figure out how to use it, it would only store data on the server machine. So if I had multiple servers the player would have a different account basically for each server, starting over every time. For this reason, I need a more permanent and available database all servers could use.

If anyone has a system that is working for them to save multiplayer data please enlighten me. I would love to chat on discord or any other means of communication. I'd be willing to shell out a good amount of $ to get a knowledgeable person to help me out with this. I have spent 13 months on my game and it works great so far. I have been testing it with my friends and everything is replicated properly, except next time they play none of their progress was stored.

Much love UE4 community,

Dalton

Product Version: UE 4.21
Tags:
more ▼

asked Jan 18 '19 at 10:45 PM in Blueprint Scripting

avatar image

DK Buzzin
11 3 6

avatar image frezer748 Mar 17 '19 at 03:32 PM

I am also interested in this!

best regards

avatar image DK Buzzin Mar 17 '19 at 06:42 PM

Frezer748, What I am doing for the time being is using a custom system I have designed completely in blueprints to store players data on the server. I am using the built in "save to slot" feature in UE4. Basically, the player enters their username and password in, upon pressing login, the blueprint checks to see if there is a save slot that exists for the username+password, if so, it loads that players save and logs them in. if not, it prompts the player to try different credentials or create a new account. Creating a new account initializes a new save slot with default stats.

I will probably replace this system because I want to player to be able to load their characters save in not matter what server they are playing on, but I would need a professional to help me set up an SQL system.

(comments are locked)
10|2000 characters needed characters left
Viewable by all users

2 answers: sort voted first

You will either need to write SQL support in C++ as UE4 don't support any database except of this:

https://github.com/EpicGames/UnrealEngine/tree/b70f31f6645d764bcb55829228918a6e3b571e0b/Engine/Source/Runtime/SQLiteSupport

...or get a plugin that does that from marketplace. Considering you ready to throw some money at people for it, 2nd option is considerable option

more ▼

answered Mar 17 '19 at 11:53 PM

avatar image

Shadowriver
36.7k 932 171 1111

avatar image DK Buzzin Mar 18 '19 at 01:58 AM

Shadow, I have looked into the plugins on the marketplace and none seem easy to learn more about or set up. If there was a clearly popular choice with very clear documentation or video instructions on how to get a system set up I would by it. For now though, they only show off some nodes that would accomplish SQL communication, but setting up a system from start to finish is not as simple as "plug and play".

avatar image DK Buzzin Mar 18 '19 at 01:59 AM

I've setup gaming servers before, and my game in its current state has been able to get people from other countries all to connect to a single server. But SQL... that stuff is beyond me. Past my pay grade as a dev.

(comments are locked)
10|2000 characters needed characters left
Viewable by all users
more ▼

answered Jun 05 '19 at 01:59 AM

avatar image

wukakuki
213 11 16 23

(comments are locked)
10|2000 characters needed characters left
Viewable by all users
Your answer
toggle preview:

Up to 5 attachments (including images) can be used with a maximum of 5.2 MB each and 5.2 MB total.

Follow this question

Once you sign in you will be able to subscribe for any updates here

Answers to this question