Simple Online Account Creation

My first submission to the Asset Store is live
http://u3d.as/content/my-bad-studios/simple-online-accounts-kit/1QP

Simply put, the SOA kit is a drag and drop solution for creating user accounts online and storing their data online and allowing people to update their data, well, online.

Now developers who find themselves asking: "How can I create online accounts?"
or to the inevitable "How can I create a login for my MMO?"
...now there is a definitive answer:

"Make sure your web server supports PHP and MySQL and then follow these 5 steps:
- Setup your database tables,
- configure the settings.php file,
- drop all the php files onto your website,
- give my prefabs your website URL and
- drop the prefab into your scene!
Done!"

No two games will be the same and thus their requirements will be different. Same with the web site's look and feel. What this attempts to do is give you a working setup that you can either use right out of the box, or have a working setup that you need only modify to fit your own, custom, needs.

Here is the details of what it does:
1. It allows you to create a new account and store your info online. I validate that usernames are unique upon creation.
2. After the account is created I send out a validation email giving people the chance to activate or delete the account, offering you peace of mind that they provided you with a real and valid email address. An account can be validated or deleted only once. After that a message is displayed that the account is not awaiting validation any more.
3. Users get a log in screen where they can enter their username and password. Once they supply these and hit submit, they will either
- receive a message saying that the account is still inactive pending validation,
- receive a message saying that the username/ password combo is not valid
- get a message saying the account is suspended
(I don't actually suspend accounts in this, but should you decide to suspend an account,
the system is setup to show such a message)
- alternatively, if everything is okay, it calls a function that you can customise as you see fit and then deletes the prefab from the scene.

4. I also has a second prefab that you can use to update personal details. In this version I chose to NOT allow the modification of username or password but that is easily added if you want to. Before personal details can be changed, another login is required to validate the identity of the person trying to modify personal details.

5. I also include a website version of the same system so users can manage their accounts in-game or online.

So yeah, this is what it already does, now you can just go and add whatever else you need .
Enjoy.

 

Okay. Promised screenshots added.

Some additional notes:
The fields you saw in the account registration is setup by using a custom class[] I created. Each entry allows you to specify from a drop down list wether that field is supposed to be:
- An email (in which case it tries to verify authentic email address),
- a required field (so it gives an error message if the field is left blank),
- a validation field (and then compares the value with another field you specify and gives an error if they do not match)
- a requiredEmail (see above two points) or
- a normal text field

You also get to specify:
- The label for each field and if it is a required field I automatically write it in red with the "(*)" appended,
- what field in the database table it should update
- what character to use for the password character (if any) and
- the maximum length this value can hold.

So to collect info from people you simply decide upon the size of the input area and complete the array. Display and processing is handled by the scripts.

Regarding the validation emails:
In settings.php I have a set of variables for you to configure including:
- your game name for branding purposes
- your website url so I can brand the emails with your URL also
- contact person to contact in case of any questions or concerns
- contact email address that people can contact you on
- subject line for the validation email

So you just configure this with your details and have yourself a customized validation email
That is just about all I can think of at the moment. Feedback welcome

 

Have got this and it works wonderfully. Well it did once I got a little tech assistance and beat up my hosting service to set up what should have been set up in the first place

I can now get people to log in and setup an account with email validation and then use an exclusive and reserved account for playing the game.

It's also well commented code so that it's easy to mod and extend if you want to.. in my case, extended already to set up a new player char table for the server to bring a default player into the game when connected.

Nice work Mr Dude

Regards

Graham

 

looks good but your link has this:
'Unity 3.2 Required'
The asset store says Unity 3.3.0 is needed and I cant be bothered to upgrade as the upgrade doesn't benefit me.
Can you tell me if it will only work on 3.3 and if so why, I might upgrade if it uses a feature only available in 3.3

Thanks.

 

Hi there

This is compatible with anything from 2.6+. I know there is supposed to be a setting where I can say what version of Unity is required but for the life of me I simply can't find that setting...!

Ig anyone knows where I can set this value, I would be much obliged!

Alternatively, just contact me directly to make alternate arrangements. Thanks for pointing this out to me, though

 

Does it work for iphone or android??

 

Most certainly.

It interfaces with the database via the included php scripts that sit on your web server. All you have todo is provide it with data and let it take care of the rest. Same with retrieving data. Tell it you want the data and then wait for it to send it to you.

All the work is being done on the web server All the devices has to do is collect the data from the user and send it over to there. As such, any device that can use the GUI can use this.

With regards to extra fields in your tables, this is setup to use a predefined set of info. If you want to add to it, just open the PHP files and just add them in, swop them with the ones already in there that you don't want or just delete the ones you don't want... When you see the scripts you will understand why this is called the SIMPLE online accounts kit

Then just adapt your GUI code to collect your custom info and you are done.

 

I have purchased a few things lately on my quest of learning and I have to say this is very worth the money. Easy to setup and understand and also MrDude is very helpful. Only problem was my own noobness to mysql but was over come easily with MrDude's help. Took a very short time to setup and add to my existing game. Thank you MrDude.

 

I have been reading of people turning away from the asset store thanks to the "no more PayPal" thing so I updated the website to now include a direct buy option also. PayPal, WebMoney, cash, cheque.... the list goes on Feel free to check it out

Ta

p.s. The also voids the "Unity 3.3 required" problem mentioned above.

 

Hi all

I have submitted an update to the Asset Store.

There are two changes in the new version:
1. Pragma support
The kit now uses the pragma strict and a few changes were made to it to comply therewith. Functionally exactly the same, but if you want to add to the kit, considering how very poorly Unity 3.4 handles JS that does NOT use the pragma strict, it might just be safer for you to use this version instead.

2. Table creation
Step 1 in my 5 steps to getting online user accounts was "Create your tables". No more. I now include an SQL command for you to copy and paste into your SQL manager to create some tables for you to start with. Thus, you now have a WORKING setup that you can go modify to your heart's content, instead of having to create it yourself, first.

Edit: I just had a look and I noticed the new kit is now available in the asset store. I also noticed my ranking and thought I'd say thank you to all of you who purchased the kit

 

Looks very helpful, if I ever need online account creation I know where to get it!

 

Noob Question :

I noticed there are 2of each of these: (UpdateAccount.php updateacct.php) and ( NewAccount.php newacct.php )

I was just wondering why for learning purposes.

It seems like adding data for stats like Strength, Dexterity would be fairly straight Forward. It would be cool to have a script that has a timer to update mySql at regular intervals.

 

You will notice I say in the description that I also include a version of this kit to use on your website, well these duplicates are for the website version of the kit.

Basically, Unity handles the graphics via OnGUI() so for that I do the work on the server end and only return an error code to Unity to then display if necessary. The website version actually prints out HTML code so you can do all of this via your web browser. Gives your customers the option of maintaining their accounts even if they are just skiving 5 minutes at work or whatever... It's just a free little bonus. You are free to delete them if you don't need them

As far as the timed updates is concerned, well that would be as simple as:

Code (csharp):

1.  
2. function Start()
3. {
4. Init();
5. }
6.  
7. function Init()
8. {
9. InvokeRepeating("updateStats",1,5);
10. }
11.  
12. function updateStats()
13. {
14. //send the data to save...
15. }
16.  

I actually created a piece of code recently that has timers that count down/ count up to certain limits and upon reaching said limit sends an update to the php file. If the update was successful then the class goes on it's merry way. If something went wrong (like the person having multiple windows open and trying to cheat the timer), it would return the true values and update the local timers to what the server says t should be. Kind of like an authoritative thing. It is a tad more tricky than the basics that put the SIMPLE in the Simple Online Accounts Kit, but if you have need of it just send me a PM and I'll see if I can help you out

 

Thanks I sent you a PM

 

Yeah. Got it. Busy typing you that increeeeeeeeeeeeeeeeedibly long email...
Init code, GUI stuff, custom classes and PHP code...
Almost done...

 

Is this hardcoded to use your GUIStyles, or just using a GUISkin I could disable?

 

I figured the general look of the thing would be largely a matter of personal taste so I created a GUISkin for the prefabs. I figured you could just create your own skin and drag that into the appropriate field and have your own custom look.

Here is a screenshot of how I seth it up...

 

Everything seems to be working now except its not send out the email for activation. Also should I manually add the Account Update Prefab? I noticed there is not really an option to resend the verification email if there is an issue.

 

grfxman, what do you mean "manually add the Account Update Prefab"?

The way it is setup to work is that when you want to create a new account or let someone login, you just instantiate the prefab. Alternatively, just place it in the scene at startup. To update personal details just do the same with the Account Update Prefab. For instance, you could have a button in your scene labelled "Update account" and when the player clicks on that you can either just instantiate the prefab or you can load a new scene with the prefab already in place. I think the former choice makes the most logistical sense... I am thus not entirely sure what your question is...

 

My main question is why is it not sending the Activation email?

But I was just noticing there is not an option to resend the email if it fails for some reason.

 

I'm using a Windows server and the email is a different domain from where the PHP files are stored. I'm not sure if either of these things are an issue.

 

Yeah it's been 5 hours of messing with this and it's definitely not sending emails from a windows server. I've updated everything and still nothing.

 

Did you get my PM? Like I said, the code that's been working just fine for months on end, without me changing a single letter suddenly stopped working. I was at a loss until I finally found 31 mail in my spam folder on gmail. Gmail thought it sam, moved it to the spam folder and it never reached my home so it looked like it wasn't working.

Did you look in your spam folder to see if it contains anything?
I mean, if it works for me and it works for everyone else then the code has to work... I'm not sure if the mail() command requires a specific php plugin but I know I've never had to install it so I would assume it ones standard...

Try this. I sent you that link yesterday that explains how the mail function works, right? So right after the explanation there are some examples. The first one is the most basic. so use copy and paste that into a new file and all it directly from your localhost and see if you get a mail. This is a very simple way of seeing wether your system is configured properly.

Here, try this:

Code (csharp):

1.  
2. <?php
3.     $message  = "<font color=red>Hallo world</font>";
4.     $email    = 'myEmail@address.com';
5.     $subject  = "account creation validation";
6.     $headers  = 'MIME-Version: 1.0' . "\r\n";
7.     $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
8.     $headers .= "From: doesnt@matter.com" . "\r\n";
9.  
10.     $b = mail($email, $subject, $message, $headers );
11.     echo "$email<br> $subject<br> $message<br> $headers<br>$b";
12. ?>
13.  

Save this as mailTest.php and run. Afterwards, go check your spam folder

 

Thanks for all the help. After a whole night of dealing with Server Prontos Tech support they still couldn't get it working so I just moved it to a Non Windows Server and it worked like a Charm. I knew your code was good, I just assumed the Windows server would have issues, which it did. Bums me out cause I actually prefer that over Linux.

But thanks again and I hope you like what I did with your Kit. You can check it out here: ROGUE

 

@Greg Mort
I just noticed your review and you said you never got a reply to your email. I must apologize for that. The domain I used for emails was recently moved to another host's name servers and that host has been down for 30% of this month and the rest of the time email going through them got blocked as they were blacklisted for spamming. As such, i have been having tons of mail related issues and it seems I must have missed your mail... In future, please use support@mybadstudios.com andy will be sure to get your mail

So to anyone who had any questions recently and didn't get a reply, please feel free to ask away again.

Greg, sorry about that, mate. I promise I wasn't blowing you off or anything

 

Great Package!

I picked this up because I wanted to learn how to use databases and for $25 it was the best deal out there. Its about as simple to setup and run as I think could be possible.

This product won't work out of the box, but only because it requires you to setup things on your webserver first. I used a 1-click MySQL installer and PhpMyAdmin to setup the database on my website so it was pretty easy.

If you are a PHP and SQL noob like me, I'd highly recommend making your tables exactly as specified in the manual when creating your first database. The included PHP scripts will work with those values and there are enough ways to go wrong without tinkering, so just get the default settings working first!

If you need to modify the system, the author is very helpful with support! Very good for beginners to SQL and PHP and it has taught me more for $25 than I ever expected when I bought it.

 

Hi, just have a few questions about this asset. It looks brilliant and like exactly what I need.

I am building my website with a CMS which has built in features for handling user account creation. As far as I know a MySQL table is created where all the user information (username password etc) is stored. What I would like to do is have users create an account on the website (ie not in the game), and then when they go to play the game have users login using this system. This would mean that this system would need to check the specific user table in the database and verify the username and password, can it do this?

Secondly, are there any security issues with this system concerning accessing the database directly from a Unity build? For example, how does this system prevent hackers from accessing the same user information that this system does?

And lastly, since my website is not up on a server yet but still being tested locally using WAMP, would I be able to test this asset locally on a WAMP setup or would the website need to be on an actual server first?

 

I'm afraid this kit won't work for your needs, sorry

 

Do you mean user account details aren't saved in the database on the server, they're saved via Unity player prefs or something?

 

I mean the whole thing was made to behave differently to what you want. It was meant to be a functional product but built to be easy to read/understand/learn from and expand upon. It is not the be-all and end-all of login systems.

Security is an issue that some companies spend millions of $ on per year. This kit doesn't even attempt to make itself the most secure system it can possibly be. If your website is hackable, then so is this kit. If your website is safe then so is this. That simple... There is some security built into this but nothing extensive.

As for the actual functioning of it, it saves details in specific files and does certain operations based on weather the records actually exist or not and if it des then only does it do something else. Plus it makes use of a status field that your CMS is not likely to have plus CMS usually work on nicenames and IDs to validate users etc while I work on the unqueness of the email address and username fields...

Completely different systems mine and CMS systems. This is like saying "I want a means of transportation to work so I bought a motorcycle. I see you have a bycicle for sale. Will your bycicle be compatible with my motorcycle?"

Both do a similar job but both do it very differently so although you can make the two compatible by strapping the handle bars and seat to the motorbike, the end result will be messy, be a lot of work and you won't be left with much of my kit when you are done... Meaning you will have wasted your money to only retain 5% of what you bought...

You would be much better served to learn PHP and integrat your app directly with your CMS via PHP, rather than starting with my kit as a foot stool. I would appreciate the sale, of course, but I don't think you will find much value in my kit other than teaching you how to interface between Unity -> php -> your CMS...

 

Sure, I understand that I would need to modify this asset to make it work for my purposes. At the most basic level I was interested in whether I could learn from this how to check/verify data in a MySQL table from a Unity application. For example, when the user types a username and hits a login button, the Unity application would check the typed username against those in the table on the server, verifying it exists and is therefore valid.

I have created a server based high score system (like the one on the Unify Wiki) however this only reads and displays table data. So naturally this is the next step for me. It seems that this asset does not do this though, so I appreciate your honesty. I'll keep looking

 

Hold on for a second there... if you are only interested in learning THAT, then this kit is ideal for your purposes... what I was trying to say is that it does not offer an easy route into finding the various API calls you will need to interface with your CMS and dealing with it's encryption details etc etc etc.

I created a kit that works with Wordpress and it took me ages to figure it out. If you are hoping this kit will offer you an easy road into THAT, then no, sorry, this is not for you. If you just want to learn how to interface between Unity and your CMS then yeah, this can be very beneficial to you.

Tell you what, before you splash out on this or continue to search all over the place, contact me via my website so I can have your email address. From that I can assist you directly and help you determine if this is what you are looking for.

 

Email sent

 

I sent you a reply by email. Did you get it?

 

I wonder if I might adapt this asset to my needs. In addition to an online account that users would log in while running the webplayer, I'd also like to save the length of time they played the game and what their final score was. I don't need a high score system, but I will want the user to be able to see their length of time and final score in their user profile.

Is that kit available somewhere I can buy / download it?

 

Hi bigkahuna

as long as you do the maths on your end to determine duration and score and only want to store/retrieve these two values then yeah, definitely. This can be added in literally minutes

 

how do you add the database table to parse?

 

Sorry, i'm afraid I don't understand the question. Could you explain, please?

In order to create the database, first log i to your website account and find something called phpmyadmin. Sometimes it is on a sub page after you clicked on MYSQL. Most sites require you create the database first before they let you access it with phpmyadmin but all of them should offer you a means of creating the database from within your accounts page somewhere.

Once you have your database and you've logged into it in phpmyadmin, simply click on the tab called SQL and paste the table configuration i provided you within the kit. Then select go or continue or accept or whatever your screen says. Done. Your online database is setup

Now you open up settings.php and you enter the database name, the url your webhost provided you fort he database and , of course, your username and password. Once you have done this, upload all the files to your website. If you dont already have one, make sure to place crossdomain.xml in your website's root (see Unoty documenastion for more info on crossdomain.xml) and now you are completely setup.

All that's left to do now is to select the prefabs and give them the full url to where you placed the files. Apart from that, there is nothing else left to do.. You are now up and running.

I hope this answers your question

 

I cant figure out how to do this with parse.com

 

Oh, one thing that some customers have struggled wit in past... Something to be aware of...

Many, many web hosts do not allow you to access your database from anywhere other than from their sites. As such, while you are testing your kit offline/ locally, if you configure the settings.php to use your online database, it will most likely give you a bunch of errors and nit work at all.

You have to do one of two things:
1. Create a database in your computer and setup settings.php to access the database via localhost. Then, when you are ready to deploy your title, THEN create yoir online database and set your settings.php to those details.

2. Alternatively, and much less work if you ask me, is to create your database online, configure your scripts to use those details, upload everything to your web space and simply use that while you are testing locally. So create the database immediately and start using it immediately, instead of doing everything twice and worrying about double configurations

 

I don't think this system can be used with parse.com, I'm sorry to say. If you look at the kit's description on the Asset Store:

Parse.com seems to pride themselves on having a system where they don't give you access to PHP. They have their own data management system, requires that you do custom code in JS and take great pride in the fact that you run serverless... None of this is good news for this kit...

You will have to follow my above instructions and setup the kit on your own web space, let users log in from there, then do whatever else it is you want to do on parse.com but the login system and their system is going to be completely separate from each other.

Again, I don't know/own/use them so I am not an expert on their services. Perhaps I am wrong and they DO allow you to run custom php and access your database directly. If so, great, but you will have to confirm that with them and find out from them how you would go about doing so.

Sorry I can't be of more help to you with this...
Good luck, though.

 

ok i found a free hosting one that i have set up

 

now i have this error. It shows up whenever I type in my user name and passwors and try to login

FormatException: Input string was not in the correct format
System.Int32.Parse (System.String s) (at /Users/builduser/buildslave/monoAndRuntimeClassLibs/build/mcs/class/corlib/System/Int32.cs:629)
UnityScript.Lang.UnityBuiltins.parseInt (System.String value)
AccountCode+$DoLoginVerification$37+$.MoveNext () (at Assets/crRPGSystem/_Scripts/AccountCode.js:72)

 

and does this work with Mobile?

 

what free site did you use?

 

I dont remember. I am away from home at the moment. Just google free hosting with php support or something like that. I dont remember what I searched for sure.

 

And would this keep the person logged in? Like if I made a built in chat room, they wouldnt have to relogin

 

nevermind. this didn't work with mobile. so i had to build something myself. maybe in the future i will be able to use this so it doesn't go to waste

 

If you look at the code you will see there is absolutely nothing in there that will prevent it working with mobiles. If it's not working on your mobile device then you are just doing something wrong somewhere. I can't imagine what, though, as there is nothing tricky about this kit at all..

If you can run it from your desktop then all you do is change the platform and hit build again and it will work on any other platform...

In what way did this "didn't work" ?

 

It wouldn't connect to my database. My guess is because i don't have Android Pro or IOS Pro