Skip to content

Instantly share code, notes, and snippets.

View CloudyWater's full-sized avatar

Thomas Hyman CloudyWater

View GitHub Profile
@CloudyWater
CloudyWater / Starfield.shader
Created February 23, 2018 03:31
Conversion of ShaderToy to Unity Shader
Shader "Starfield"
{
Properties
{
_iMouse ("iMouse", Vector) = (0,0,0,0)
_Iterations ("Iterations", int) = 17
_Formuparam ("Formuparam", float) = .53
_Steps ("Steps", int) = 20
_StepSize ("StepSize", float) = .1
_Zoom ("Zoom", float) = .8
@CloudyWater
CloudyWater / UpdateDatabseConnection.cs
Created January 31, 2017 00:40
Update to the PostLoginAccount() function
IEnumerator PostLoginAccount (string username, string password)
{
string postUrl = GET_USER_URL + "username=" + WWW.EscapeURL (username) + "&password=" +
WWW.EscapeURL(Crypto.Encrypt(password));
WWW hsPost = new WWW (postUrl);
yield return hsPost;
if (hsPost.error != null)
<?php
$dsn = 'mysql:host=localhost;dbname=dbname';
$username = 'username';
$password = 'password';
$userlogin = $_GET['username'];
$passwordAttempt = $_GET['password'];
try
{
@CloudyWater
CloudyWater / NewAddUser.php
Created January 31, 2017 00:23
AddUser.php using PDO
<?php
$dsn = 'mysql:host=localhost;dbname=dbname';
$username = 'username';
$password = 'password';
$hashOptions = [
'cost' => 10,
];
$email = $_GET['email'];
$userlogin = $_GET['username'];
@CloudyWater
CloudyWater / DatabaseConnectionAddition.cs
Created January 29, 2017 20:40
Added the following code to DatabaseConnection.cs
private const string GET_USER_URL = "http://localhost/GetUser.php?";
public void LogInAccount (string username, string password)
{
StartCoroutine (PostLoginAccount (username, password));
}
IEnumerator PostLoginAccount (string username, string password)
{
string postUrl = GET_USER_URL + "username=" + WWW.EscapeURL (username);
@CloudyWater
CloudyWater / MainMenuManagerAddition.cs
Created January 29, 2017 20:38
Function to add to MainMenuManager
public void LogInAccount ()
{
if (UsernameInput.text != "" && PasswordInput.text != "")
{
Connection.LogInAccount (UsernameInput.text, PasswordInput.text);
}
}
@CloudyWater
CloudyWater / GetUser.php
Created January 29, 2017 20:28
Our script to get user data
<?php
$db = mysql_connect('localhost', 'username', 'password') or die ('Could not connect: ' . mysql_error());
mysql_select_db('databasename') or die ('Could not select database');
$username = mysql_real_escape_string($_GET['username'], $db);
$query = "SELECT * FROM users WHERE username='$username';";
$result = mysql_query($query) or die ('Query failed: ' . mysql_error());
$row = mysql_fetch_assoc($result);
@CloudyWater
CloudyWater / DatabaseConnection.cs
Created January 29, 2017 19:35
the DatabaseConnection class
using System.Data;
using System.Data.SqlClient;
using System.Security.Cryptography;
using System.Text;
using System.Collections;
using System.Collections.Generic;
using UnityEngine;
public class DatabaseConnection : MonoBehaviour
{
@CloudyWater
CloudyWater / MainMenuManager.cs
Created January 29, 2017 19:29
Manages our Account Creation menu
using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using UnityEngine.UI;
[RequireComponent (typeof (DatabaseConnection))]
public class MainMenuManager : MonoBehaviour
{
public InputField UsernameInput, PasswordInput, CreateUsernameInput, CreateEmailInput, CreatePassword, CreateVerifyPassword;
@CloudyWater
CloudyWater / AddUser.php
Last active January 29, 2017 19:12
Adds a user to our database
<?php
$db = mysql_connect('localhost', 'username', 'password') or die ('Could not connect: ' . mysql_error());
mysql_select_db('databasename') or die ('Could not select database');
$email = mysql_real_escape_string($_GET['email'], $db);
$username = mysql_real_escape_string($_GET['username'], $db);
$password = mysql_real_escape_string($_GET['password'], $db);
$hash = $_GET['hash'];
$secretKey = 'secretkey';