LeaderBoard

using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using UnityEngine.Networking;
using UnityEngine.UI;

public class LeaderBoard : MonoBehaviour
{

    public Text mack;
    public Text nam;
    public Text flynn;
    public Text oodger;
    public Text mitch;
    public Text parer;

    public Text firstText;
    public Text secondText;
    public Text thirdText;


    // Update is called once per frame
    void Update()
    {

        mack.text = "Mackillop:" + DBManager.mackScore;
        nam.text = "Namatjira:" + DBManager.namaScore;
        flynn.text = "Flynn:" + DBManager.flynnScore;
        oodger.text = "Oodgeroo:" + DBManager.oodgerScore;
        mitch.text = "Mitchell:" + DBManager.mitchScore;
        parer.text = "Parer:" + DBManager.parerScore;

        firstText.text = "1st: " + DBManager.firstName + " " + DBManager.firstScore + " (" + DBManager.firstHouse + ")";
        secondText.text = "2nd: " + DBManager.secondName + " " + DBManager.secondScore + " (" + DBManager.secondHouse + ")";
        thirdText.text = "3rd: " + DBManager.thirdName + " " + DBManager.thirdScore + " (" + DBManager.thirdHouse + ")";

        StartCoroutine(HouseScores());
    }

    IEnumerator HouseScores()
    {
        WWWForm form = new WWWForm();
        mack.text = "Mackillop: " + DBManager.mackScore;
        nam.text = "Namatjira: " + DBManager.namaScore;
        flynn.text = "Flynn: " + DBManager.flynnScore;
        oodger.text = "Oodgeroo: " + DBManager.oodgerScore;
        mitch.text = "Mitchell: " + DBManager.mitchScore;
        parer.text = "Parer: " + DBManager.parerScore;
        UnityWebRequest www = UnityWebRequest.Post("http://localhost/sqlconnect/leaderboard.php", form);
        yield return www.SendWebRequest();

        if (www.downloadHandler.text.Split('\t')[0] == "0")
        {
            DBManager.mackScore = int.Parse(www.downloadHandler.text.Split('\t')[1]);
            DBManager.namaScore = int.Parse(www.downloadHandler.text.Split('\t')[2]);
            DBManager.flynnScore = int.Parse(www.downloadHandler.text.Split('\t')[3]);
            DBManager.oodgerScore = int.Parse(www.downloadHandler.text.Split('\t')[4]);
            DBManager.mitchScore = int.Parse(www.downloadHandler.text.Split('\t')[5]);
            DBManager.parerScore = int.Parse(www.downloadHandler.text.Split('\t')[6]);

            DBManager.firstName = www.downloadHandler.text.Split('\t')[7];
            DBManager.firstScore = int.Parse(www.downloadHandler.text.Split('\t')[8]);
            DBManager.firstHouse = www.downloadHandler.text.Split('\t')[9];
            DBManager.secondName = www.downloadHandler.text.Split('\t')[10];
            DBManager.secondScore = int.Parse(www.downloadHandler.text.Split('\t')[11]);
            DBManager.secondHouse = www.downloadHandler.text.Split('\t')[12];
            DBManager.thirdName = www.downloadHandler.text.Split('\t')[13];
            DBManager.thirdScore = int.Parse(www.downloadHandler.text.Split('\t')[14]);
            DBManager.thirdHouse = www.downloadHandler.text.Split('\t')[15];


        }

        else
        {
            Debug.Log("Score Retrieval Failed. Error #" + www.downloadHandler.text);
        }
    }

}