81 lines
2.0 KiB
C#
81 lines
2.0 KiB
C#
using MySql.Data.MySqlClient;
|
|
using TMPro;
|
|
using UnityEngine;
|
|
|
|
public class GameFinish : MonoBehaviour
|
|
{
|
|
|
|
public TMP_Text Teks_Score, Teks_TotalScore;
|
|
public Level1SkorUploader uploader;
|
|
|
|
private string conn;
|
|
private MySqlConnection koneksi;
|
|
|
|
//public void Start()
|
|
//{
|
|
// if (Data.DataScore >= PlayerPrefs.GetInt("score"))
|
|
// {
|
|
// PlayerPrefs.SetInt("score", Data.DataScore);
|
|
// }
|
|
|
|
// Teks_Score.text = Data.DataScore.ToString();
|
|
// Teks_TotalScore.text = PlayerPrefs.GetInt("score").ToString();
|
|
|
|
// uploader?.SimpanSkorLevel1();
|
|
//}
|
|
|
|
void Start()
|
|
{
|
|
conn = "Server=127.0.0.1; Database=game; User=root; Password=;";
|
|
koneksi = new MySqlConnection(conn);
|
|
|
|
int skorTerakhir = Data.DataScore;
|
|
Teks_Score.text = skorTerakhir.ToString();
|
|
|
|
uploader?.SimpanSkorLevel1();
|
|
|
|
AmbilHighScoreDariDatabase();
|
|
}
|
|
|
|
void AmbilHighScoreDariDatabase()
|
|
{
|
|
if (GlobalUser.Instance == null)
|
|
{
|
|
Debug.LogWarning("GlobalUser tidak ditemukan!");
|
|
return;
|
|
}
|
|
|
|
int userId = GlobalUser.Instance.userId;
|
|
|
|
try
|
|
{
|
|
koneksi.Open();
|
|
string sql = "SELECT level1 FROM high_score WHERE id_score = @user_id";
|
|
MySqlCommand cmd = new MySqlCommand(sql, koneksi);
|
|
cmd.Parameters.AddWithValue("@user_id", userId);
|
|
|
|
MySqlDataReader reader = cmd.ExecuteReader();
|
|
|
|
if (reader.Read())
|
|
{
|
|
int highScore = reader.GetInt32("level1");
|
|
Teks_TotalScore.text = highScore.ToString();
|
|
}
|
|
else
|
|
{
|
|
Teks_TotalScore.text = "0";
|
|
Debug.LogWarning("Data high score tidak ditemukan untuk user ID: " + userId);
|
|
}
|
|
|
|
reader.Close();
|
|
koneksi.Close();
|
|
}
|
|
catch (MySqlException ex)
|
|
{
|
|
Debug.LogError("Gagal mengambil high score: " + ex.Message);
|
|
}
|
|
}
|
|
|
|
|
|
}
|