Search Unity

  1. Unity 2019.1 is now released.
    Dismiss Notice

Database Control (Free) [Released]

Discussion in 'Works In Progress' started by SolutionStudios, Jun 18, 2015.

  1. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102



    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
     
    Last edited: Feb 1, 2017
  2. the_genius

    the_genius

    Joined:
    Mar 24, 2014
    Posts:
    7
    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 :))
     
  3. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    @the_genius

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

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    Quick Setup Video added.
     
  5. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    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
     
    Last edited: Jul 17, 2015
  6. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    We have just managed to get our WebGL demo online.

    It is a first for us, but it seems to be working fine.
     
    Last edited: Dec 8, 2015
  7. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    Beta testing has now ended.
     
  8. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    Just submitted to the Asset Store team. It is currently 'Pending Review'.
     
  9. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    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.
     
    Last edited: Jul 31, 2015
  10. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    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
     
    Last edited: Nov 14, 2015
  11. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    Links to demos updated.
     
  12. yc960

    yc960

    Joined:
    Apr 30, 2015
    Posts:
    228
    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...
     
  13. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    @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.
     
  14. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    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.
     
  15. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    We have just updated our setup video for the latest version of the package:


     
  16. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    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.
     
    Last edited: Dec 9, 2015
  17. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    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.
     
  18. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    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.
     
    Last edited: Sep 18, 2016
  19. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    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.
     
  20. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    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'.

     
  21. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    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 ...
     
  22. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    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.
     
  23. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    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.
     
    Last edited: Dec 20, 2016
  24. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
  25. Tyranosaw

    Tyranosaw

    Joined:
    Jan 20, 2016
    Posts:
    2
    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*
     
  26. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    @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.
     
  27. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    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.
     
    Last edited: Jan 15, 2017
  28. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
  29. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    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:

     
  30. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    Database Control (Free) v1.1 has been released!

    It is available on the Asset Store here.
     
  31. arnesso

    arnesso

    Joined:
    Mar 3, 2015
    Posts:
    93
    Awesome stuff, thank you :)
    I am thinking about using with Photon, does it possible ?
     
  32. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    @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.
     
    arnesso likes this.
  33. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    The latest version of Database Control (Free), version 1.1, fully supports Unity 5.6. No update required.
     
  34. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    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
     
  35. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    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.
     
    Last edited: Aug 3, 2017
  36. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    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
     
  37. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    Database Control (Free) v1.1.1 Released

    It is available on the Asset Store here
     
  38. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    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.
     
  39. ksam2

    ksam2

    Joined:
    Apr 28, 2012
    Posts:
    990
    Hi, is there any action for playmaker?
     
  40. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    @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.
     
  41. ehsanwowacc

    ehsanwowacc

    Joined:
    Oct 31, 2017
    Posts:
    1
    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
     
  42. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    @ehsanwowacc - We haven't been able to reproduce the problem, but i've sent you an email with steps to try.
     
  43. deudeua

    deudeua

    Joined:
    Mar 28, 2017
    Posts:
    1
    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
     
  44. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    @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.
     
  45. MightyMate

    MightyMate

    Joined:
    May 20, 2018
    Posts:
    4
    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).
     
  46. pippin_mole

    pippin_mole

    Joined:
    May 26, 2015
    Posts:
    2
    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
     
  47. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    @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.
     
    AdrellaDev likes this.
  48. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    @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
     
  49. GregoryFenn

    GregoryFenn

    Joined:
    Feb 13, 2018
    Posts:
    24
    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
     
  50. SolutionStudios

    SolutionStudios

    Joined:
    Aug 1, 2014
    Posts:
    102
    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
     
    GregoryFenn likes this.