Database Control (Free) [Released]

Introduction:

Database Control (Free) is a quick and easy solution for an online user account database in your game. Create a database and use it for usernames, passwords and another text variable for an unlimited number of accounts in your game or app. Everything can be done inside the Unity Editor with no need for a server or PHP scripts. We have taken care of that for you. One-click setup. All you need is Unity (v4.6.0 or later).





It includes the ability to register, login, and get or set player data (only one data variable is supported and it has to be a string).


Asset Store Page



Setup Tutorial Video:

Features:

- Login, Register, Set and Get Data support (data string works up to a few million characters)
- One-click setup with our Editor Window
- Supports unity free and pro (unity 4.6 onwards)
- Supports unlimited number of user accounts
- Should work on all platforms (only tested on Windows, Webplayer, WebGL and Android)
- Can be used in any kind of game to store data. All the player needs is an internet connection.
- Includes C# and Js support
- Includes C# and Js demo scenes with example code
- PDF containing code examples for both C# and Js
- IT IS FREE! (and will remain free)

(The previous version did not work in China. This has been fixed in v1.1)


Cost:

The package will remain free forever.


Demos:

Database Control (Free) includes a C# and UnityScript version of the same demo scene. We have uploaded some builds for you to try:
WebGL
WebPlayer
Windows
Mac
Linux
Android




Limitations:

- Only one database per project
- Cannot view database contents
- Limited to Register, Login, Get Data and Set Data
- Doesn’t include any encryption or ssl. Data is not completely secure.
- Source code not included.


Database Control Pro:

If you want more features and to remove the limitations above, try Database Control Pro. You can visually script your own server-side code or use the included demos. You can create as many databases as you like and view and edit their entire contents in the Unity Editor. It is also much more secure. The majority of our time will be spent on bug fixing and adding new features to this asset, however we still provide support to Database Control (Free) if required.


Please post any questions you have bellow or send us an email at:
solution_studios@outlook.com

 

I wouldn't normally post on these forums but I felt I had to, as this wasn't getting much attention.
I have been looking for something like this for a while.
And signed up as a beta tester and ... its PERFECT.
When they say 'it takes minutes to set up', it actually does.

Really impressed. Thank you so much guys.
Keep up the good work.

(haven't had any problems yet )

 

@the_genius

Thanks for the feedback.
If you do have any problems, please let us know.

 

Quick Setup Video added.

 

Beta v0.4 complete and released to current beta testers.

Latest features/fixes:
- Now supports WebGL platform.
- Includes complete C# demo scene as well as the Js demo scene.
- Fixed importing data.txt bug.

We will try to get a WebGL demo online in the next few days (it will use the same database as the Unity Web Player demo).

Other things to do:
- Fix as many bugs (and hopefully warnings in the console) as we can
- Update/Improve PDF documentation
- Further optimisation of server-side code
- Backup our server-side code properly
- Create Asset Store key images etc.
- Submit to Asset Store Team and wait for release!

If all goes well, it should be ready within 2-3 weeks from now.

But, we still need more beta testers! If you are interested please send an email to: solution_studios@outlook.com

 

We have just managed to get our WebGL demo online.

It is a first for us, but it seems to be working fine.

 

Beta testing has now ended.

 

Just submitted to the Asset Store team. It is currently 'Pending Review'.

 

Annoyingly it was declined today, which causes further delays.

The Asset Store Team said it was due to errors in the console with the demo scenes. We should have made it clearer the demo scenes aren't meant to work out of the box and a database needs to be setup first.

Anyway, we have fixed the errors and a message in the console should appear instead saying 'A database needs to be setup.' and have resubmitted the package.
(That probably won't make sense if you haven't already got the package.)

Hopefully it will be accepted this time!

Edit: By the way, registering an account to use Database Control (Free) is no longer needed, it is all done automatically (and is much quicker).
Also, seeing as we have finished the final version, contact us if you want to have a copy. You don't have to wait for it to be published on the Asset Store if you need it now.

 

The package has been released on the Unity Asset Store. (available here)
However, the version currently on the store (v1.0.0) is not working. We have resubmitted the package with v1.0.1 which works and is pending review by the Asset Store Team.

If you want to download the package, please check back here soon. We may release a working version for downloading through our website if it takes a long time to get updated on the asset store.

Edit: Version on the Asset Store is now working

 

Links to demos updated.

 

what is the limit of string characters for the text variable?
It seems I am getting permanent connection time outs whenever the string reaches couple hundreds of characters. It would be really nice if you made the limitations of this free version more clear. Size limits and data flow limits etc...

 

@yc960 - We have done some tests on the character limit of the requests (not using unity) and there weren't any problems with requests up to and just over 2000 characters. We assume unity doesn't have any character limits on http requests to a few hundred characters, so we would guess the limit is around 2000 characters. We are not sure why it was so much further bellow this so we shall look into it.

To be honest, we didn't think about character limits much. We will do some more testing and I have an idea on how we can increase the limit a bit, but can't promise anything yet. We will post our results here over the next few days.

 

As a quick update on our character limit tests, we have a working system transferring strings of huge numbers of characters to our server using unity. We have just managed to successfully send and recieve a string of over 124,000 characters using it and we believe it can do much more than this.

We can confirm we will be implementing this system into Database Control (Free) v1.0.2.

At the moment, we plan on Database Control (Free) supporting a high-enough-to-be-called-unlimited number of characters. However, if users do abuse this by repeatedly uploading insanley large strings then we will have to add limits.

But on a more positive note, you can look forward to this new feature soon.

 

We have just updated our setup video for the latest version of the package:

 

Updated the WebGL Demo. It now uses Database Control (Free) v1.0.2 which will be released on the Asset Store soon.
Try it here.

EDIT:
Also, updated the WIndows, Mac and Linux demos.

 

Database Control (Free) v1.0.2 has now been released. You can now set and get data strings which are a few million characters long!

Download it on the Asset Store here.

We will probably not update the package for a while now, but we are still happy to answer any questions and would appreciate your feedback.

 

We are currently working on a new asset 'Database Control Pro'. It is so much more secure and flexible than 'Database Control (Free)'.

Take a look here.

Edit: Database Control Pro has now been released and is available on the Asset Store here.

 

We have fixed a major bug today.

If any of you were having a problem creating a database using the Database Control (Free) Editor Window with errors appearing in the console, the problem should no longer occur.

The bug was server-side so the fix will work for the current version of Database Control (Free) without needing to download a new version from the Asset Store.

 

I just found a nice tutorial video using Database Control (Free). They use the C# demo scene as a base and expand on it. They go on to edit the demo scene's code to make it fit their game.

It is part of a series called 'Making a Multiplayer FPS in Unity'.

 

Database Control (Free) has reached over 1000 Asset Store Downloads
(1021 at this exact point in time)

To celebrate we will start working on an update soon (v1.1). We will completely reprogram the code within Unity (from scratch) to make the Setup Editor Window easier to use. We are also considering adding another window to make intergrating the login/register UI into your game easier.
All user interfaces will be improved and will look much nicer. They will also be in-theme with Database Control Pro.

The features will stay the same in this update, but we are considering transferring it over to a different server system. This would make requests much quicker and limits much higher. We are not sure how much it would cost us to do this so we might have to abandon the idea after some testing.

As this is such a big update, it will not be compatible with the current version of Database Control (Free). If you want to upgrade, all database contents will be lost and you will have to remove the old version from your project before you import the new version. Also, there may be significant code changes.

More information coming soon ...

 

As pointed out to us by a Unity user interested in Database Control Pro, neither DCP or DCF currently work in China. This was an issue we weren't previously aware of and we are now working to find a solution to it.

 

We are currently working on a quick fix for the current version of Database Control (Free) so it works with Unity 5.5. It should be done in the next few days.

Edit: We have submitted it to the Asset Store. It should be live in the next 5 to 10 working days.

Edit 2: Database Control (Free) v1.0.3 is now available on the Unity Asset Store.
Take a look here.

 

We are now working on the next version of Database Control (Free) which is v1.1. Everything will be completely rewritten from scratch. Here is our current progress on the new editor window.

 

I've recently gotten this asset and i am lovin it. I love how you guys are still on top of this and continue to update it. Though i do have a question. Where can i find the data in the database, is it in a file?? I would like to delete (unused)accounts individually or change passwords. It has just been an inconvenience miss-typing usernames/passwords and not being able to do anything about it. Thanks for the great asset. *Thumbs Up*

 

@Tyranosaw - Thanks! We are glad you like it. The database is stored on a server online, it is not contained in any files. This means you are limited to the Register, Login, GetData, SetData, and empty database methods used in the demo scenes and editor window. Unfortunately, you cannot view all the contents of the database to delete specific accounts or change passwords. If you would like a system which does this, you might have to purchase Database Control Pro. Sorry for the inconvenience.

 

We have just finished Database Control (Free) v1.1 for Unity 5.5 and Unity 4.6. Now we need to get it working in 5.0 and 5.3. After that we will release a demo and create a new setup tutorial video then release on the Asset Store!

(And version 1.1 should work in China. This was a issue for many people and we have managed to fix it!)


Edit: It's working in 5.0 and 5.3 now. We will put the demos online very soon.

 

DCF v1.1 Demos:

Here are the links to the demos for the new version of DCF which will be released soon:

WebGL
Webplayer
Windows
Mac
Linux
Android

 

We will be submitting the update to the Asset Store today or tomorrow. So it should be released within the next week.

In the meantime, here is the new Setup Tutorial video:

 

Database Control (Free) v1.1 has been released!

It is available on the Asset Store here.

 

Awesome stuff, thank you
I am thinking about using with Photon, does it possible ?

 

@arnesso - Thank you for the feedback! We haven't specifically tested it or tried integrating it with Photon, but we believe it should work without any problems. Each player should be able to access their own account. But, if you want to share data from Database Control (Free) (e.g. usernames) with other players then you will have to add this to your photon code. We don't have much experience with Photon, but if you have any issues we are happy to help.

 

The latest version of Database Control (Free), version 1.1, fully supports Unity 5.6. No update required.

 

Database Control Pro 15% Off

Database Control Pro is currently part of the Madness Sale and is 15% off. That makes it just $29.75.
The sale lasts until the end of April so make sure you buy it before then!

Asset Store Page

Unity Forum

 

There is currently a bug in Database Control (Free) causing issues in WebGL and Webplayer. We know what the problem is and will submit a fix to the Asset Store soon.

Edit: We have submitted version 1.1.1 to the Asset Store Team this morning, hopefully it will be on the Asset Store within the next week. This version includes the fix along with SSL and full Unity 2017.1 support.

 

We've just uploaded the demos for Database Control (Free) version 1.1.1
The online demos should be working correctly on all Webplayer and WebGL supported browsers.

Here are the links:
WebGL
WebPlayer

 

Database Control (Free) v1.1.1 Released

It is available on the Asset Store here

 

We have been asked how to use Database Control (Free) over multiple scenes without the user having to re-enter their login details. Just in case there are more people out their with the same question we have made a tutorial video to show you:

You can download the final project from here. The project was made in Unity 5.5 and we haven't checked it in other versions of Unity. Also, you still need to create a database using the Editor Window before you can use this project. And don't press play from within the Demo Menu or InGameExample scenes. It will only work if you press play in the InitGame scene as the other scenes rely on the GameObject it creates storing the player's login details.

 

Hi, is there any action for playmaker?

 

@ksam2

No. We haven't used playmaker ourselves so don't support it.

However, the only coding you need to do with the asset is call 4 methods when required (Login, Register, GetData and SetData). This is explained better in the included documentation. So you can use playmaker with the asset providing there is a way to call these methods using it. Also, if you want to use the demo scene you might want to convert the demo scene code to use playmaker. But, the asset is free so there is no harm in spending a few hours trying to get it working if you have the time.

 

Hello guys
I have a problem with DCF
after updating to the latest version on DCF, it returns an error upon setting up new database:
Unsupported encoding 'utf-8,text/html': Encoding name 'utf-8,text/html' not supported

please help me

 

@ehsanwowacc - We haven't been able to reproduce the problem, but i've sent you an email with steps to try.

 

This one looks very good and easy to use, very good job. I want to know: is the connection "peer to peer" or "dedicated server"? thank you

 

@deudeua - "peer to peer" and "dedicated server" are different types of systems for networking a game. This means allowing two people to play against each other in a scene. Database Control (Free) is not a networking system. It simply allows players to have online accounts on which the game's data (e.g. levels unlocked, coins collected, ... etc) can be stored and retrieved.

These online accounts are stored on our databases so in a sense it is a "dedicated server". If it was more like "peer to peer" then a player wouldn't be sending their password to our database to login but to another player's computer. This would be a big security risk and is rare for people to use with in game account systems.

 

Hey there, recently I have been working on a game made by YT channel called Brackeys.
So basically, he had an older version of Data base control .
In the newer version maybe they have changed some functions thus I don't know how to deal with this error (NullReferenceException: Object reference not set to an instance of an object
UserAccountManager+<sendGetDataRequest)c__Iterator1.MoveNext () (at Assets/Scripts/UserAccountManager.cs:106).

 

Hey,

I'm using your database to let the players create a user account and log in.
Since recently, the window for the Database Control (Free) module has stopped working.
I don't know the reasoning for this, but it brings up 3 errors when I try to run it.

Here is a link to the error messages I receive: https://imgur.com/a/BwhEOAo
It seems to be the DLL file that the error is sourced.
I am running Unity version 2018.1.3f1, but have tried it on 2018.1.2f1, with the same results

It would be great if there was a resolution to this problem as my game depends entirely on this plugin

Thanks

 

@MightyMate

The code to use the 4 methods used by Database Control (Free) has changed slightly between the older and newer versions and this is causing the problem.

For example the code for logging a user into their account (in C#) used to look like this:

Code (CSharp):

1.  
2. IEnumerator Login(string username, string password) {
3.     IEnumerator e = DC.Login(username, password);
4.     while(e.MoveNext()) {
5.         yield return e.Current;
6.     }
7.     WWW returned = e.Current as WWW;
8.     if (returned.text == “Success”) {
9.         //Account Created Successfully
10.         //Do Stuff
11.     }
12.     if (returned.text == “incorrectUser”) {
13.         //Username not found in database
14.         //Do Stuff
15.     }
16.     if (returned.text == “incorrectPass”) {
17.         //Username found but password incorrect
18.         //Do Stuff
19.     }
20.     if (returned.text == “ContainsUnsupportedSymbol”) {
21.         //One of the parameters contained a “-“ symbol
22.         //Do Stuff
23.     }
24.     if (returned.text == “Error”) {
25.         //Should not login as another error occurred
26.         //Do Stuff
27.     }
28. }
29.  

And in the latest version it has to be done like this:

Code (CSharp):

1.  
2. IEnumerator Login(string username, string password) {
3.     IEnumerator e = DCF.Login(username, password);
4.     while(e.MoveNext()) {
5.         yield return e.Current;
6.     }
7.     string returned = e.Current as string;
8.     if (returned == “Success”) {
9.         //Account Created Successfully
10.         //Do Stuff
11.     }
12.     if (returned == “UserError”) {
13.         //Username not found in database
14.         //Do Stuff
15.     }
16.     if (returned == “PassError”) {
17.         //Username found but password incorrect
18.         //Do Stuff
19.     }
20.     if (returned == “Error”) {
21.         //Should not login as another error occurred
22.         //Do Stuff
23.     }
24. }
25.  

If you make these changes to the code from the tutorial series it should work. You can see the code required for all 4 methods (Login/Register/GetData/SetData) in the pdf documentation included.

If you have any problems you can send us an email: solution_studios@outlook.com
We can also send you a .unitypackage of the demo scene from the older versions of Database Control (Free) which has been updated to work in the newer versions if it helps.

 

@pippin_mole
The most likely cause for this problem is that you have moved the Database Control (Free) files around in your project. There should be two folders at the following paths:
Assets/Database Control Free
Assets/Editor Default Resources/Database Control Free

If you move the folders back to these locations it should work fine.

If this doesn’t solve the problem please let us know by email: solution_studios@outlook.com

 

Dear SolutionStudios,

Odd question, but how do you make money from your free version of the Database Control? Are there adverts for our clients, or do you harvest metadata to sell, or is it just an advert for us to use the Pro paid version?

I just wasn't clear what the economic trade between us and you is in the case of the free version!

~Greg

 

Hi Greg,

We don't make any money from it. There are no adverts. There is no selling of your data, we don't even look at your data.

It was never meant to be an advert for Database Control Pro because we released Database Control (Free), for free, before we came up with the idea of Database Control Pro. But, you are welcome to purchase Database Control Pro if you wish to support us.

Database Control (Free) costs us almost nothing to maintain and helps out a lot of people.We'll keep it free and working for as long as possible, hopefully indefinitely!

I hope that answers your question,

Solution Studios