Unity + SQL Databases Player Management Leaderboards + More!
Take your games to the next level with this course!! Connect your Unity project with a backend database! There is so much that you can do with the information that you will learn from this course. You can track players scores, allow users to sign in and sign out, build a leaderboard of players and connect them from around the world!
Topic Covered:
-
Unity
-
Unity Networking / Webrequests
-
Unity Database
-
Unity Player Management
-
SQL Database
-
Unity UI Work
-
Unity Leaderboards
-
PHP Scripting Basics
-
LAMP Cloud Server Set Up
-
Database Security
-
Password Security
-
Working with JSON
-
AND SO MUCH MORE!!
So come along for the ride and take your Unity projects to a whole new level!!!
–Austin Patkos (eJPT, CCP, SAA, BCCe) has taught over 7,000 students on Udemy. He is passionate not only about tech but about teaching tech too. Knowing that remembering information isn’t enough, you have to have a deeper understanding to be able to retain all of the information. He teaches in a manner that is sure to help you develop your skills and take you to the next level as a developer. He teaches a careful balance of giving enough information but also taking time to practice it too. Austin has developed these courses to teach people just like how to become better developers.
SQL Database Basics
-
1
Introduction and About this CourseA quick introduction about this course and what's it all about.
-
2
Meet Your Instructor / My Teaching Methodolgy
Just a quick video about who I am and my teaching methodology.
-
3
Is this Course Right for You? More Course Details
A quick video making sure this video can fit your needs and solve your problems.
-
4
Course Overview, Sections and 'Flow' of each section.
A overview of the individual sections with the individual flow so that we can understand what each thing does within our project.
-
5
Quick Note About Video Speed
Feel free to change the video speed for a better course experience!
PHP Scripting Basics
-
6
Overview of SQL
A brief overview of this section and SQL.
-
7
Installing MAMP
Throughout this course we will be using a tool called MAMP. In this video we discuss what this software does and how to install it.
-
8
phpMyAdmin Overview/ Database and Table Set Up
In this video we discuss a basic overview of phpMyAdmim. A tool that we're going to use a bunch through out this course. We will also be setting up our database and table that we will need for this course.
-
9
Changing Table Structure If Needed
A brief video showing how you could change the table set up if need be.
-
10
Inserting Information Into Our Table
In this video we discuss how to insert data and create players using SQL with our table.
-
11
Reading/Selecting Information from Our Table
In this video I will show you how to select different pieces of information from our database, necessary for the coming videos.
-
12
Updating Information In Our Table
For this video you will learn how to update users within our table.
-
13
Deleting Information From Our Table
Final Video from this section. Brief overview of deleting users from our table. Enjoy!
Unity Web Requests / Unity Networking Basics
-
14
Overview of PHP + Visual Studio Code Installation
In this video we install Visual Studio Code and go over the basics of PHP.
-
15
Echo Statements and Variables with PHP
In this video we talk about some basic echo commands and variables with PHP.
-
16
If Statements with PHP
For this video we will build a simple program that gives us a message based on the day of the week and if it is the weekend. This will all be done with PHP.
-
17
Getting Info Back From Our Database with PHP
For this video, we're going to go through a quick demo showing how you could get info back from your database. In later videos we will go more in depth this is just an over view.
Unity CRUDs / User Management
-
18
Basic Unity Networking Get Requests
In this video we will be covering basic Unity Web Request with a basic Get request with Unity. We will utilize one of the scripts we built in the last section.
-
19
Basic Unity Post Requests
In this video you will see how to use a Post request with Unity. We will also discuss forms and how to accept information with PHP.
Unity Leaderboard
-
20
Basic Project set up + Create User Part 1 (UI Element Set Up)
For this video, will will set up our Create User UI elements that we will be using in following videos.
-
21
Create User Part 2 (Front End Scripting Work)
In this video we will be working through front end scripting to give feedback to the user for our Create User scene.
-
22
Create User Part 3 (Networking Requests)
In this video we will continuing our Create Player functionality for our game. We will be building our networking request along with fixing up some more UI.
-
23
Create user Part 4 (Server Side Scripting)
In this video we will make our script for our sever to accept our post request sent from Unity.
-
24
Create Player Part 5 (Server Error Handling)
In this video we will handle the error codes that we set up with our server script in the previous videos.
-
25
Create Player Part 6(Basic Sanitization and Filtering of User Input)
In this video we briefly discuss input sanitization and making sure that bad code isn't used when creating a player.
-
26
Create Player Part 7 (App Security with Connecting To Our Server (App Password))
In this video we set up an app password to make sure requests are only being sent from our app.
-
27
Create Player Part 8 (Hashing User Passwords)
In this video we will discuss hashing user passwords so that they are not stored in plain text.
-
28
Login Player Part 1 (UI Set Up)
In this video we set up the basic UI of our Login User scene.
-
29
Login Player Part 2 (UI Scripting)
In this video we set up some basic scripting for the UI of our login player scene.
-
30
Login Player Part 3 (Player Prefab + Current Player Script)
In this video we will be making a set up for once a player logs in. This info will hold the necessary player information.
-
31
Login Player Part 4 (Network Requests Set Up)
In this video we will be setting up our networking requests with Unity to login in our player.
-
32
Login Player Part 5 (Server Script)
In this video we set up our server script so that our players can log in.
-
33
Login Player Part 6 (Handling Server Response Codes)
In this video we will be handling the response codes from our server script based on if the players credentials were correct or not.
-
34
Login Player Part 7 (Assigning Player Info in Scene)
In this video we will work with the information coming back form our server and assign the player info in scene. In addition we will set up our player menu.
-
35
Login Player Part 8 (Signing Out Player)
In this video we will allow our player to sign out and handle all the game objects properly.
-
36
Assigning Player Info In Scene
In this video we will be assigning player info in scene.
-
37
Updating Player Score Part 1 (Front End Scripting)
In this video we will build the front end scripting for updating the players score.
-
38
Updating Player Score Part 2 (Server Scripting)
In this video we will be finishing up the updating player functionality to our game.
-
39
Update Player Result Error Talk
A quick video discussing one method in the last video.
Cloud Deployment ** BONUS **
-
40
Leaderboard UI Set Up Part 1
In this scene will be begin setting up our UI for our leaderboard.
-
41
Leaderboard UI Set Up Explanation
Just a quick video explaining what we did last video.
-
42
Leaderboard UI Set Up Part 2 (Prefab Set Up)
In this video we continue setting up our leaderboard UI.
-
43
Leaderboard Front End Scripting
In this video we will start writing out scripts for our leaderboard scene.
-
44
Leaderboard Server Scripting
In this video we will set up our server script to pull all the info back for the leaderboards.
-
45
SimpleJSON Script -
46
Using Simple JSON
In the last video we get information back form our database in the form of JSON. In this video we are going to parse through JSON in our Unity project and continue working on our leaderboard.
-
47
Sorting Players By High Score
In this video we are going to sort our incoming players by the high score.
-
48
Giving Players Rankings In Our Leaderboards
In this video we will give each player on the leaderboard a ranking so we can easily see what rank each player has.
-
49
Search Function Part 1
In this video we will begin the process of adding the search functionality to our Unity project.
-
50
Search Function Part 2
In this video we will continue adding our search functionality to our project. This video will mainly be front end scripting work and building the networking request.
-
51
Search Function Part 3
In this video we will be setting up our server script for the search function along with hooking it up to the front end Unity project.
-
52
Search Function Part 4
In this video the search function will be finally completed. Information coming back form our server and then it populated in scene.
-
53
Testing our App!
We did a lot in this section, now it's time to test it!!
Conclusion + Bonus!
-
54
Intro to Cloud Deployment
Intro video so that we can better understand cloud deployment and what exactly we'll be doing in this section.
-
55
Launching EC2 Server
In this video we will be launching our very first server!
-
56
Configuring our Server with a LAMP stack + phpMyAdmin
In this video we will be configuring our server with all the necessary software packages to set up our database and server!
-
57
Setting Up Our Table in Database
In this video we will be setting up our table and database in our Cloud Server.
-
58
File Transfer to Server with WinSCP
In this video we will be transferring files from our desktop to our server. This is necessary for the scripts we set up earlier.
-
59
Script Fixing for server.
In this video we will be fixing our scripts so that they function on our server.
-
60
Setting Up SSL with our Cloud Server
In this video we are going to set up a HTTPS connection to our database to make sure all traffic is encrypted.
-
61
Fixing Unity Scripts to send information to our cloud server
In this video we will fix our Unity web requests to send information to our cloud server instead of our local server.
-
62
Final Testing For our App and Cloud Database/Server!
In this video this is our final testing for our app and our cloud database/server!
