Wayback Machinekoobas.hobune.stream
May JUN Jul
Previous capture 13 Next capture
2021 2022 2023
1 capture
13 Jun 22 - 13 Jun 22
sparklines
Close Help
  • Products
  • Solutions
  • Made with Unity
  • Learning
  • Support & Services
  • Community
  • Asset Store
  • Get Unity

UNITY ACCOUNT

You need a Unity Account to shop in the Online and Asset Stores, participate in the Unity Community and manage your license portfolio. Login Create account
  • Blog
  • Forums
  • Answers
  • Evangelists
  • User Groups
  • Beta Program
  • Advisory Panel

Navigation

  • Home
  • Products
  • Solutions
  • Made with Unity
  • Learning
  • Support & Services
  • Community
    • Blog
    • Forums
    • Answers
    • Evangelists
    • User Groups
    • Beta Program
    • Advisory Panel

Unity account

You need a Unity Account to shop in the Online and Asset Stores, participate in the Unity Community and manage your license portfolio. Login Create account

Language

  • Chinese
  • Spanish
  • Japanese
  • Korean
  • Portuguese
  • Ask a question
  • Spaces
    • Default
    • Help Room
    • META
    • Moderators
    • Topics
    • Questions
    • Users
    • Badges
  • Home /
avatar image
0
Question by IWannaTaco · Jan 26, 2015 at 12:38 PM · javascriptmysqlphp

Register help

So i'm working with unity and mySQL database and Php. I need it to insert data into the database from this code. It works with connecting to database and all, checks if fields are empty and the check if it(email/username) already exists works. But when it is available it doesn't work.

For obvious reason is censored all the import stuff like connection names and such using

Php code here

 <?
 // CONNECTIONS =========================================================
 $host = "localhost"; //put your host here
 $user = "*******"; //in general is root
 $password = "******"; //use your password here
 $dbname = "*****"; //your database
 mysql_connect($host, $user, $password) or die("Cant connect into database1");
 mysql_select_db($dbname)or die("Cant connect into database");
 // =============================================================================
 $unityHash = $_POST["myform_hash"];
 $phpHash = "********"; 
  
 $nick = $_POST["myform_nick"];
 $pass = md5($_POST["myform_pass"]); // md5 hashes the password
 $email = $_POST["myform_email"];
  
 if(!$nick || !$pass || !$email)
 {
     echo "Login, password, or email cant be empty.";
 }
 else
 {
     if ($unityHash != $phpHash)
     {
         echo "HASH code is different from your game, you infidel.";
     }
     else
     {
         $checkuser = mysql_query("SELECT name FROM scores WHERE name='$nick'");
         $username_exist = mysql_num_rows($checkuser);
         $checkemail = mysql_query("SELECT email FROM scores WHERE email='$email'");
         $email_exist = mysql_num_rows($checkemail);
         if($username_exist > 0)
         {
               echo "Sorry but the username you specified has already been taken.  Please pick another one.";
               unset($nick);
               exit();
         }
         if($email_exist > 0)
         {
             echo "Sorry but the email is already in use. Please use another one.";
             unset($email);
                 exit();
         }
         if($username_exist = 0 && $email_exist = 0) // This is the part that doesn't work...
         {
             $query = "INSERT INTO scores (id, name, password, email, balance, level, xp, wins, loses) VALUES (NULL, '$nick', '$pass', '$email', '0', '0', '0', '0', '0');";
             echo "You have successfully Registered";
            
         }
        
     }
 }
 mysql_close();
 ?>

and this is the Javascript code inside unity.

 #pragma strict
 private var formNick = ""; //this is the field where the player will put the name to login
 private var formPassword = ""; //this is his password
 private var formEmail = ""; //this is his email
 var formText = ""; //this field is where the messages sent by PHP script will be in
  
 var URL = "http://*********.com/*******.php";
 var hash = "*********"; 
  
 private var textrect = Rect (10, 150, 500, 100); //just make a GUI object rectangle
  
 function OnGUI() {
     GUI.Label( Rect (10, 10, 80, 20), "Your Email:" ); //text with your nick
     GUI.Label( Rect (10, 30, 80, 20), "Your Name:" );
     GUI.Label( Rect (10, 50, 80, 20), "Your Pass:" );
  
     formEmail = GUI.TextField ( Rect (90, 10, 100, 20), formEmail ); //here you will insert the new value to variable formNick
     formNick = GUI.TextField ( Rect (90, 30, 100, 20), formNick ); //same as above, but for password
      formPassword = GUI.TextField ( Rect (90, 50, 100, 20), formPassword );
  
     if ( GUI.Button ( Rect (10, 90, 100, 20) , "Register" ) ){ //just a button
         Register();
     }
     if ( GUI.Button ( Rect (110, 90, 100, 20) , "Back" ) )
     {
         Application.LoadLevel("Menu_Login");
     }
     GUI.TextArea( textrect, formText );
 }
  
 function Register() {
     var form = new WWWForm(); //here you create a new form connection
     form.AddField( "myform_hash", hash ); //add your hash code to the field myform_hash for php
     form.AddField( "myform_nick", formNick );
     form.AddField( "myform_pass", formPassword );
     form.AddField( "myform_email", formEmail );
     var w = WWW(URL, form);
     yield w; 
     if (w.error != null) {
         print(w.error); //if there is an error, tell us
     } else {
         print("Test ok");
         formText = w.data; 
         w.Dispose(); //clear our form in game
     }
 }
  

Comment
Add comment
10 |3000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

0 Replies

· Add your reply
  • Sort: 

Your answer

Hint: You can notify a user about this post by typing @username

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this Question

Answers Answers and Comments

2 People are following this question.

avatar image avatar image

Related Questions

Sending values from Unity to PhP to SQL. 1 Answer

Javascript with php 1 Answer

HOW Unity store game saves? Are mySQL a valid option to store such data? How about javascript framework or php? 0 Answers

Unity PHP login always returning true 3 Answers

How do i search a mysql database in unity 5 1 Answer


Enterprise
Social Q&A

Social
Subscribe on YouTube social-youtube Follow on LinkedIn social-linkedin Follow on Twitter social-twitter Follow on Facebook social-facebook Follow on Instagram social-instagram

Footer

  • Purchase
    • Products
    • Subscription
    • Asset Store
    • Unity Gear
    • Resellers
  • Education
    • Students
    • Educators
    • Certification
    • Learn
    • Center of Excellence
  • Download
    • Unity
    • Beta Program
  • Unity Labs
    • Labs
    • Publications
  • Resources
    • Learn platform
    • Community
    • Documentation
    • Unity QA
    • FAQ
    • Services Status
    • Connect
  • About Unity
    • About Us
    • Blog
    • Events
    • Careers
    • Contact
    • Press
    • Partners
    • Affiliates
    • Security
Copyright © 2020 Unity Technologies
  • Legal
  • Privacy Policy
  • Cookies
  • Do Not Sell My Personal Information
  • Cookies Settings
"Unity", Unity logos, and other Unity trademarks are trademarks or registered trademarks of Unity Technologies or its affiliates in the U.S. and elsewhere (more info here). Other names or brands are trademarks of their respective owners.
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Default
  • Help Room
  • META
  • Moderators
  • Explore
  • Topics
  • Questions
  • Users
  • Badges