Unity + SQL Databases Player Management Leaderboards + More!

A brief overview of this section and SQL.

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.

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.

A brief video showing how you could change the table set up if need be.

In this video we discuss how to insert data and create players using SQL with our table.

In this video I will show you how to select different pieces of information from our database, necessary for the coming videos.

For this video you will learn how to update users within our table.

Final Video from this section. Brief overview of deleting users from our table. Enjoy!

In this video we install Visual Studio Code and go over the basics of PHP.

In this video we talk about some basic echo commands and variables 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.

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.

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.

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.

For this video, will will set up our Create User UI elements that we will be using in following videos.

In this video we will be working through front end scripting to give feedback to the user for our Create User scene.

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.

In this video we will make our script for our sever to accept our post request sent from Unity.

In this video we will handle the error codes that we set up with our server script in the previous videos.

In this video we briefly discuss input sanitization and making sure that bad code isn't used when creating a player.

In this video we set up an app password to make sure requests are only being sent from our app.

In this video we will discuss hashing user passwords so that they are not stored in plain text.

In this video we set up the basic UI of our Login User scene.

In this video we set up some basic scripting for the UI of our login player scene.

In this video we will be making a set up for once a player logs in. This info will hold the necessary player information.

In this video we will be setting up our networking requests with Unity to login in our player.

In this video we set up our server script so that our players can log in.

In this video we will be handling the response codes from our server script based on if the players credentials were correct or not.

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.

In this video we will allow our player to sign out and handle all the game objects properly.

In this video we will be assigning player info in scene.

In this video we will build the front end scripting for updating the players score.

In this video we will be finishing up the updating player functionality to our game.

A quick video discussing one method in the last video.

In this scene will be begin setting up our UI for our leaderboard.

Just a quick video explaining what we did last video.

In this video we continue setting up our leaderboard UI.

In this video we will start writing out scripts for our leaderboard scene.

In this video we will set up our server script to pull all the info back for the leaderboards.

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.

In this video we are going to sort our incoming players by the high score.

In this video we will give each player on the leaderboard a ranking so we can easily see what rank each player has.

In this video we will begin the process of adding the search functionality to our Unity project.

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.

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.

In this video the search function will be finally completed. Information coming back form our server and then it populated in scene.

We did a lot in this section, now it's time to test it!!

Intro video so that we can better understand cloud deployment and what exactly we'll be doing in this section.

In this video we will be launching our very first server!

In this video we will be configuring our server with all the necessary software packages to set up our database and server!

In this video we will be setting up our table and database in our Cloud Server.

In this video we will be transferring files from our desktop to our server. This is necessary for the scripts we set up earlier.

In this video we will be fixing our scripts so that they function on our server.

In this video we are going to set up a HTTPS connection to our database to make sure all traffic is encrypted.

In this video we will fix our Unity web requests to send information to our cloud server instead of our local server.

In this video this is our final testing for our app and our cloud database/server!