private static void ShopCheck()
{
DataTable playerboard = MyDataBaseConnection.GetTable("SELECT * FROM Shop;");
while (CheckingUser <= AllUsers)
{
try
{
if (Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT isDoubleCoinsBonusActive FROM Shop WHERE id = {CheckingUser};")) == null)
{
MyDataBaseConnection.ExecuteQueryWithoutAnswer($"UPDATE Shop SET isDoubleCoinsBonusActive = {0} WHERE id = '" + CheckingUser + "';");
}
}
catch (Exception ex)
{
MyDataBaseConnection.ExecuteQueryWithoutAnswer($"UPDATE Shop SET isDoubleCoinsBonusActive = {0} WHERE id = '" + CheckingUser + "';");
}
CheckingUser++;
}
if (CheckingUser > AllUsers)
{
CheckingUser = 1;
}
}
IEnumerator FalseForTimer()
{
Handheld.Vibrate();
maytimerrun = false;
isdied = true;
gameoverfortimeleft.SetActive(false);
timeleftpanel.SetActive(true);
Instantiate(effect, effectpoint_timeleft.position, Quaternion.identity);
yield return(new WaitForSeconds(1.5f));
timeleftpanel.SetActive(false);
if (isrecord == true)
{
record_panel_after.SetActive(true);
}
if (Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT isRevivalBonusActive FROM Shop WHERE id = {CurrentUser};")) == 1)
{
revival_bonus_panel.SetActive(true);
}
else
{
gameoverfortimeleft.SetActive(true);
}
}
IEnumerator FalseForTimer()
{
isDieByTime = true;
Handheld.Vibrate();
maytimerrun = false;
isdied = true;
gameoverfortimeleft.SetActive(false);
timeleftpanel.SetActive(true);
Instantiate(effect, effectpoint_timeleft.position, Quaternion.identity);
yield return(new WaitForSeconds(1.5f));
timeleftpanel.SetActive(false);
if (Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT isRevivalBonusActive FROM Shop WHERE id = {CurrentUser};")) == 1)
{
revival_bonus_panel.SetActive(true);
}
else
{
gameoverfortimeleft.SetActive(true);
}
now_number_task--;
now_task_aftertimeexit.text = now_number_task.ToString();
max_tasks_aftertimeexit.text = limit_tasks.ToString();
}
public static int Balance() //Дает возможность узнать баланс игрока
{
DataTable playerboard = MyDataBaseConnection.GetTable("SELECT * FROM Shop;");
coins = Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT Coins FROM Shop WHERE id = {CurrentUser};"));
return(coins); //Возвращает требуемый баланс монет
}
public void CheckForPlusDoubleBonusTask() //Если куплен бонус Удвоение монет, то идет прибавление завершенных заданий
{
if (Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT isDoubleCoinsBonusActive FROM Shop WHERE id = {CurrentUser};")) == 1)
{
int doubleBonusFinishTasks = PlayerPrefs.GetInt("DoubleBonusFinishTasks");
doubleBonusFinishTasks++;
PlayerPrefs.SetInt("DoubleBonusFinishTasks", doubleBonusFinishTasks);
}
}
public void CheckForPlusDoubleBonusTask()
{
if (Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT isDoubleCoinsBonusActive FROM Shop WHERE id = {CurrentUser};")) == 1)
{
int doubleBonusFinishTasks = PlayerPrefs.GetInt("DoubleBonusFinishTasks");
doubleBonusFinishTasks++;
PlayerPrefs.SetInt("DoubleBonusFinishTasks", doubleBonusFinishTasks);
}
}
public void PlusCountLevelsFinished()
{
DataTable playerboard = MyDataBaseConnection.GetTable("SELECT * FROM PlayerStats;");
int countLevelFinished = Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT LevelsFinished FROM PlayerStats WHERE id = {CurrentUser};"));
countLevelFinished++;
MyDataBaseConnection.ExecuteQueryWithoutAnswer($"UPDATE PlayerStats SET LevelsFinished = {countLevelFinished} WHERE id = {CurrentUser};");
}
public void SyncPlayerStats()
{
DataTable playerboard = MyDataBaseConnection.GetTable("SELECT * FROM PlayerStats;");
nickname = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT NamePlayer FROM PlayerStats WHERE id = {CurrentUser};");
years_old = Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT YearsOld FROM PlayerStats WHERE id = {CurrentUser};"));
is_man_or_women = Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT IsMenOrWomen FROM PlayerStats WHERE id = {CurrentUser};"));
_class = Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT Class FROM PlayerStats WHERE id = {CurrentUser};"));
levels_finished = Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT LevelsFinished FROM PlayerStats WHERE id = {CurrentUser};"));
all_plays_count = Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT AllPlaysCount FROM PlayerStats WHERE id = {CurrentUser};"));
score_easy_infinity_mode = Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT ScoreEasyInfinityMode FROM PlayerStats WHERE id = {CurrentUser};"));
score_middle_infinity_mode = Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT ScoreMiddleInfinityMode FROM PlayerStats WHERE id = {CurrentUser};"));
score_high_infinity_mode = Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT ScoreHighInfinityMode FROM PlayerStats WHERE id = {CurrentUser};"));
challenges_finished = Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT ChallengesFinished FROM PlayerStats WHERE id = {CurrentUser};"));
NamePlayerExit.text = nickname;
AllPlaysCountExit.text = all_plays_count.ToString();
YearsOldExit.text = "Возраст: " + years_old.ToString();
ClassExit.text = "Класс: " + _class.ToString();
LevelsFinishedExit.text = levels_finished.ToString();
ScoreEasyInfinityModeExit.text = score_easy_infinity_mode.ToString();
ScoreMiddleInfinityModeExit.text = score_middle_infinity_mode.ToString();
ScoreHighInfinityModeExit.text = score_high_infinity_mode.ToString();
ChallengeFinishedExit.text = challenges_finished.ToString();
if (years_old == 0)
{
YearsOldExitObject.SetActive(false);
}
if (_class == 0)
{
ClassExitObject.SetActive(false);
}
if (is_man_or_women == 0)
{
GenderExitObject.SetActive(false);
}
else if (is_man_or_women == 1)
{
GenderExit.text = "Пол: Мужской";
}
else if (is_man_or_women == 2)
{
GenderExit.text = "Пол: Женский";
}
}
private void Start()
{
DataTable playerboard = MyDataBaseConnection.GetTable("SELECT * FROM PlayerStats");
Application.targetFrameRate = PlayerPrefs.GetInt("FPS");
CurrentUser = PlayerPrefs.GetInt("CurrentUser");
int all_plays_count = Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT AllPlaysCount FROM PlayerStats WHERE id = '" + CurrentUser + "';"));
all_plays_count++;
MyDataBaseConnection.ExecuteQueryWithoutAnswer($"UPDATE PlayerStats SET AllPlaysCount = '" + all_plays_count + "' WHERE id = '" + CurrentUser + "';");
ChooseDifferentMode();
}
IEnumerator FinishingChallenge()
{
DataTable playerboard = MyDataBaseConnection.GetTable("SELECT * FROM IsLevelsFinished;");
Reward.Coins(30);
maytimerrun = false;
int isChallengeFinished;
if (TaskModes.isBulletChallengeMode == true)
{
isChallengeFinished = Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT BulletChallenge FROM IsLevelsFinished WHERE stroka = {CurrentUser};"));
if (isChallengeFinished == 0)
{
MyDataBaseConnection.ExecuteQueryWithoutAnswer($"UPDATE IsLevelsFinished SET BulletChallenge = {1} WHERE stroka = {CurrentUser};");
PlusCountChallengesFinished();
}
}
if (TaskModes.isPodvoxChallengeMode == true)
{
isChallengeFinished = Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT PodvoxChallenge FROM IsLevelsFinished WHERE stroka = {CurrentUser};"));
if (isChallengeFinished == 0)
{
MyDataBaseConnection.ExecuteQueryWithoutAnswer($"UPDATE IsLevelsFinished SET PodvoxChallenge = {1} WHERE stroka = {CurrentUser};");
PlusCountChallengesFinished();
}
}
if (TaskModes.isMeshalkaChallengeMode == true)
{
isChallengeFinished = Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT MeshalkaChallenge FROM IsLevelsFinished WHERE stroka = {CurrentUser};"));
if (isChallengeFinished == 0)
{
MyDataBaseConnection.ExecuteQueryWithoutAnswer($"UPDATE IsLevelsFinished SET MeshalkaChallenge = {1} WHERE stroka = {CurrentUser};");
PlusCountChallengesFinished();
}
}
finish_panel.SetActive(true);
yield return(new WaitForSeconds(0.3f));
Instantiate(effect, effect_medal_point.position, Quaternion.identity);
}
public static void Level10()
{
isTaskString = false;
DataTable playerboard = MyDataBaseConnection.GetTable("SELECT * FROM DiskriminantTasks");
choose_type_question = UnityEngine.Random.Range(1, 21);
choose_right_answer = UnityEngine.Random.Range(1, 4);
task = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT Task FROM DiskriminantTasks WHERE Number = {choose_type_question};");
question_text = "Найдите дискриминант " + task;
right_answer = Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT RightAnswer FROM DiskriminantTasks WHERE Number = {choose_type_question};"));
choose_fake_answer1 = Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT FakeAnswer1 FROM DiskriminantTasks WHERE Number = {choose_type_question};"));
choose_fake_answer2 = Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT FakeAnswer2 FROM DiskriminantTasks WHERE Number = {choose_type_question};"));
}
public static void SpecialPodvoxTasks()
{
isTaskString = true;
DataTable playerboard = MyDataBaseConnection.GetTable("SELECT * FROM PodvoxTasks");
choose_type_question = UnityEngine.Random.Range(1, 10);
choose_right_answer = UnityEngine.Random.Range(1, 4);
task = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT Task FROM PodvoxTasks WHERE number = {choose_type_question};");
question_text = task;
right_answer_string = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT RightAnswer FROM PodvoxTasks WHERE number = {choose_type_question};");
choose_fake_answer1_string = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT FakeAnswer1 FROM PodvoxTasks WHERE number = {choose_type_question};");
choose_fake_answer2_string = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT FakeAnswer2 FROM PodvoxTasks WHERE number = {choose_type_question};");
}
public static void Level7()
{
isTaskString = false;
DataTable playerboard = MyDataBaseConnection.GetTable("SELECT * FROM ProchentTasks");
choose_type_question = UnityEngine.Random.Range(1, 11);
choose_right_answer = UnityEngine.Random.Range(1, 4);
prochent = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT Prochent FROM ProchentTasks WHERE Number = {choose_type_question};");
chislo = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT Chislo FROM ProchentTasks WHERE Number = {choose_type_question};");
question_text = "Найдите " + prochent + "% от " + chislo;
right_answer = Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT RightAnswer FROM ProchentTasks WHERE Number = {choose_type_question};"));
choose_fake_answer1 = Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT FakeAnswer1 FROM ProchentTasks WHERE Number = {choose_type_question};"));
choose_fake_answer2 = Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT FakeAnswer2 FROM ProchentTasks WHERE Number = {choose_type_question};"));
}
IEnumerator False()
{
isDieByTime = false;
Handheld.Vibrate();
maytimerrun = false;
isdied = true;
gameover.SetActive(false);
aftergameover.SetActive(true);
if (LevelsDataBase.isTaskString == true)
{
right_answer_after_gameover.text = LevelsDataBase.right_answer_string;
}
else
{
right_answer_after_gameover.text = LevelsDataBase.right_answer.ToString();
}
Instantiate(effect, effectpoint_gameover.position, Quaternion.identity);
yield return(new WaitForSeconds(2.5f));
aftergameover.SetActive(false);
if (Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT isRevivalBonusActive FROM Shop WHERE id = {CurrentUser};")) == 1)
{
revival_bonus_panel.SetActive(true); //Если есть бонус возрождения, откроется окошко с предложением использовать его
}
else
{
gameover.SetActive(true);
}
if (now_number_task > 1)
{
now_number_task--;
}
now_task_aftergameover.text = now_number_task.ToString();
max_tasks_aftergameover.text = limit_tasks.ToString();
}
public void UpdateShop()
{
if (PlayerPrefs.GetInt("CheckedUSS") != 1) //Выход из метода и новая попытка через корутин при не выполненной проверки USS
{
StartCoroutine(UpdateShopEnableSystem());
return;
}
DataTable playerboard = MyDataBaseConnection.GetTable("SELECT * FROM Shop;");
coins = ShopManager.Balance();
isRevivalBonusActive = Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT isRevivalBonusActive FROM Shop WHERE id = {CurrentUser};"));
isDoubleBonusActive = Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT isDoubleCoinsBonusActive FROM Shop WHERE id = {CurrentUser};"));
CoinsExit.text = coins.ToString();
CostOfRevivalBonusText.text = CostOfRevivalBonus.ToString();
CostOfDoubleBonusText.text = CostOfDoubleBonus.ToString();
CheckForFinishDoubleBonusTasks();
CheckCanUserBuyBonuses();
}
IEnumerator Right()
{
DataTable playerboard = MyDataBaseConnection.GetTable("SELECT * FROM PlayerStats;");
StartCoroutine(RestartTimer());
score++;
PlayerPrefs.SetInt("score", score);
if (TaskModes.isEasyMode == true)
{
Reward.Coins(2);
MaxScore = Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT ScoreEasyInfinityMode FROM PlayerStats WHERE id = {CurrentUser};"));
}
if (TaskModes.isMiddleMode == true)
{
Reward.Coins(5);
MaxScore = Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT ScoreMiddleInfinityMode FROM PlayerStats WHERE id = {CurrentUser};"));
}
if (TaskModes.isHighMode == true)
{
Reward.Coins(10);
MaxScore = Convert.ToInt32(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT ScoreHighInfinityMode FROM PlayerStats WHERE id = {CurrentUser};"));
}
if (score > MaxScore) //Проверка, заработал ли игрок больше опыта, чем его прошлый рекорд
{
if (TaskModes.isEasyMode == true)
{
MyDataBaseConnection.ExecuteQueryWithoutAnswer($"UPDATE PlayerStats SET ScoreEasyInfinityMode = {score} WHERE id = '" + CurrentUser + "';");
}
if (TaskModes.isMiddleMode == true)
{
MyDataBaseConnection.ExecuteQueryWithoutAnswer($"UPDATE PlayerStats SET ScoreMiddleInfinityMode = {score} WHERE id = '" + CurrentUser + "';");
}
if (TaskModes.isHighMode == true)
{
MyDataBaseConnection.ExecuteQueryWithoutAnswer($"UPDATE PlayerStats SET ScoreHighInfinityMode = {score} WHERE id = '" + CurrentUser + "';");
}
if ((TaskModes.isBulletChallengeMode == false || TaskModes.isPodvoxChallengeMode == false) && isRecordShowed == false)
{
record_panel.SetActive(true);
isrecord = true;
isRecordShowed = true;
}
}
rightpanel.SetActive(true);
answer_panel1.SetActive(false);
answer_panel2.SetActive(false);
answer_panel3.SetActive(false);
Instantiate(effect, effectpoint.position, Quaternion.identity);
CheckForPlusDoubleBonusTask(); //Если куплен бонус Удвоение монет, то идет прибавление завершенных заданий
yield return(new WaitForSeconds(1f));
rightpanel.SetActive(false);
if (score > limit_score && (TaskModes.isBulletChallengeMode == true || TaskModes.isPodvoxChallengeMode == true))
{
StartCoroutine(FinishingChallenge());
}
else
{
answer_panel1.SetActive(true);
answer_panel2.SetActive(true);
answer_panel3.SetActive(true);
ChooseDifferentMode();
}
}
IEnumerator Right()
{
StartCoroutine(RestartTimer());
rightpanel.SetActive(true);
answer_panel1.SetActive(false);
answer_panel2.SetActive(false);
answer_panel3.SetActive(false);
CheckForPlusDoubleBonusTask(); //Если куплен бонус Удвоение монет, то идет прибавление завершенных заданий
Instantiate(effect, effectpoint.position, Quaternion.identity);
yield return(new WaitForSeconds(1f));
rightpanel.SetActive(false);
if (now_number_task < limit_tasks)
{
now_task.text = now_number_task.ToString();
answer_panel1.SetActive(true);
answer_panel2.SetActive(true);
answer_panel3.SetActive(true);
ChooseLevelTaskGenerate();
}
else
{
DataTable playerboard = MyDataBaseConnection.GetTable("SELECT * FROM IsLevelsFinished;");
int isLevelFinished;
if (Levels.level_now == 1)
{
Reward.Coins(10);
isLevelFinished = Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT OneLevel FROM IsLevelsFinished WHERE stroka = {CurrentUser};"));
if (isLevelFinished == 0)
{
MyDataBaseConnection.ExecuteQueryWithoutAnswer($"UPDATE IsLevelsFinished SET OneLevel = {1} WHERE stroka = {CurrentUser};");
PlusCountLevelsFinished();
}
}
if (Levels.level_now == 2)
{
Reward.Coins(20);
isLevelFinished = Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT TwoLevel FROM IsLevelsFinished WHERE stroka = {CurrentUser};"));
if (isLevelFinished == 0)
{
MyDataBaseConnection.ExecuteQueryWithoutAnswer($"UPDATE IsLevelsFinished SET TwoLevel = {1} WHERE stroka = {CurrentUser};");
PlusCountLevelsFinished();
}
}
if (Levels.level_now == 3)
{
Reward.Coins(25);
isLevelFinished = Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT ThreeLevel FROM IsLevelsFinished WHERE stroka = {CurrentUser};"));
if (isLevelFinished == 0)
{
MyDataBaseConnection.ExecuteQueryWithoutAnswer($"UPDATE IsLevelsFinished SET ThreeLevel = {1} WHERE stroka = {CurrentUser};");
PlusCountLevelsFinished();
}
}
if (Levels.level_now == 4)
{
Reward.Coins(30);
isLevelFinished = Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT FourLevel FROM IsLevelsFinished WHERE stroka = {CurrentUser};"));
if (isLevelFinished == 0)
{
MyDataBaseConnection.ExecuteQueryWithoutAnswer($"UPDATE IsLevelsFinished SET FourLevel = {1} WHERE stroka = {CurrentUser};");
PlusCountLevelsFinished();
}
}
if (Levels.level_now == 5)
{
Reward.Coins(35);
isLevelFinished = Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT FiveLevel FROM IsLevelsFinished WHERE stroka = {CurrentUser};"));
if (isLevelFinished == 0)
{
MyDataBaseConnection.ExecuteQueryWithoutAnswer($"UPDATE IsLevelsFinished SET FiveLevel = {1} WHERE stroka = {CurrentUser};");
PlusCountLevelsFinished();
}
}
if (Levels.level_now == 6)
{
Reward.Coins(40);
isLevelFinished = Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT SixLevel FROM IsLevelsFinished WHERE stroka = {CurrentUser};"));
if (isLevelFinished == 0)
{
MyDataBaseConnection.ExecuteQueryWithoutAnswer($"UPDATE IsLevelsFinished SET SixLevel = {1} WHERE stroka = {CurrentUser};");
PlusCountLevelsFinished();
}
}
if (Levels.level_now == 7)
{
Reward.Coins(50);
isLevelFinished = Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT SevenLevel FROM IsLevelsFinished WHERE stroka = {CurrentUser};"));
if (isLevelFinished == 0)
{
MyDataBaseConnection.ExecuteQueryWithoutAnswer($"UPDATE IsLevelsFinished SET SevenLevel = {1} WHERE stroka = {CurrentUser};");
PlusCountLevelsFinished();
}
}
if (Levels.level_now == 8)
{
Reward.Coins(60);
isLevelFinished = Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT EightLevel FROM IsLevelsFinished WHERE stroka = {CurrentUser};"));
if (isLevelFinished == 0)
{
MyDataBaseConnection.ExecuteQueryWithoutAnswer($"UPDATE IsLevelsFinished SET EightLevel = {1} WHERE stroka = {CurrentUser};");
PlusCountLevelsFinished();
}
}
if (Levels.level_now == 9)
{
Reward.Coins(70);
isLevelFinished = Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT NineLevel FROM IsLevelsFinished WHERE stroka = {CurrentUser};"));
if (isLevelFinished == 0)
{
MyDataBaseConnection.ExecuteQueryWithoutAnswer($"UPDATE IsLevelsFinished SET NineLevel = {1} WHERE stroka = {CurrentUser};");
PlusCountLevelsFinished();
}
}
if (Levels.level_now == 10)
{
Reward.Coins(80);
isLevelFinished = Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT TenLevel FROM IsLevelsFinished WHERE stroka = {CurrentUser};"));
if (isLevelFinished == 0)
{
MyDataBaseConnection.ExecuteQueryWithoutAnswer($"UPDATE IsLevelsFinished SET TenLevel = {1} WHERE stroka = {CurrentUser};");
PlusCountLevelsFinished();
}
}
if (Levels.level_now == 11)
{
Reward.Coins(90);
isLevelFinished = Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT ElevenLevel FROM IsLevelsFinished WHERE stroka = {CurrentUser};"));
if (isLevelFinished == 0)
{
MyDataBaseConnection.ExecuteQueryWithoutAnswer($"UPDATE IsLevelsFinished SET ElevenLevel = {1} WHERE stroka = {CurrentUser};");
PlusCountLevelsFinished();
}
}
if (Levels.level_now == 12)
{
Reward.Coins(100);
isLevelFinished = Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT TwelveLevel FROM IsLevelsFinished WHERE stroka = {CurrentUser};"));
if (isLevelFinished == 0)
{
MyDataBaseConnection.ExecuteQueryWithoutAnswer($"UPDATE IsLevelsFinished SET TwelveLevel = {1} WHERE stroka = {CurrentUser};");
PlusCountLevelsFinished();
}
}
ShowReceivedCoins.text = "+" + Reward.GlobalRewardCoins.ToString();
ShowBalance.text = (ShopManager.Balance()).ToString();
maytimerrun = false;
finishpanel.SetActive(true);
yield return(new WaitForSeconds(0.3f));
Instantiate(effect, effect_medal_point.position, Quaternion.identity);
}
}
public void RoleUpdate()
{
DataTable playerboard = MyDataBaseConnection.GetTable("SELECT * FROM ZvaniesTable;");
if (levels_finished < 3 || score_easy_infinity_mode < 5)
{
Zvanie = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT Zvanies FROM ZvaniesTable WHERE number = {1};");
Color c1 = new Color(55, 255, 12, 255);
zvanie.color = c1;
}
if (levels_finished >= 3 && score_easy_infinity_mode >= 5)
{
Zvanie = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT Zvanies FROM ZvaniesTable WHERE number = {2};");
RanksIcons[0].SetActive(true);
ShadowRanks[0].SetActive(false);
Color c2 = new Color(12, 255, 234, 255);
zvanie.color = c2;
}
if (levels_finished >= 5 && score_middle_infinity_mode >= 4 && score_easy_infinity_mode >= 10)
{
Zvanie = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT Zvanies FROM ZvaniesTable WHERE number = {3};");
RanksIcons[1].SetActive(true);
ShadowRanks[1].SetActive(false);
Color c3 = new Color(125, 102, 241, 255);
zvanie.color = c3;
}
if (levels_finished >= 6 && score_middle_infinity_mode >= 10 && score_easy_infinity_mode >= 10)
{
Zvanie = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT Zvanies FROM ZvaniesTable WHERE number = {4};");
RanksIcons[2].SetActive(true);
ShadowRanks[2].SetActive(false);
Color c4 = new Color(252, 14, 235, 255);
zvanie.color = c4;
}
if (levels_finished >= 9 && score_high_infinity_mode >= 4 && score_middle_infinity_mode >= 15 && score_easy_infinity_mode >= 10)
{
Zvanie = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT Zvanies FROM ZvaniesTable WHERE number = {5};");
RanksIcons[3].SetActive(true);
ShadowRanks[3].SetActive(false);
Color c5 = new Color(255, 38, 47, 255);
zvanie.color = c5;
}
if (levels_finished == 12 && score_high_infinity_mode >= 8 && score_middle_infinity_mode >= 15 && score_easy_infinity_mode >= 10)
{
Zvanie = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT Zvanies FROM ZvaniesTable WHERE number = {6};");
RanksIcons[4].SetActive(true);
ShadowRanks[4].SetActive(false);
Color c6 = new Color(255, 222, 43, 255);
zvanie.color = c6;
}
zvanie.text = Zvanie;
}
public void SyncLevelsFinished()
{
DataTable playerboard = MyDataBaseConnection.GetTable("SELECT * FROM IsLevelsFinished;");
if (Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT OneLevel FROM IsLevelsFinished WHERE stroka = {CurrentUser};")) == 1)
{
LevelsFinishedIcons[0].SetActive(true);
}
if (Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT TwoLevel FROM IsLevelsFinished WHERE stroka = {CurrentUser};")) == 1)
{
LevelsFinishedIcons[1].SetActive(true);
}
if (Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT ThreeLevel FROM IsLevelsFinished WHERE stroka = {CurrentUser};")) == 1)
{
LevelsFinishedIcons[2].SetActive(true);
}
if (Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT FourLevel FROM IsLevelsFinished WHERE stroka = {CurrentUser};")) == 1)
{
LevelsFinishedIcons[3].SetActive(true);
}
if (Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT FiveLevel FROM IsLevelsFinished WHERE stroka = {CurrentUser};")) == 1)
{
LevelsFinishedIcons[4].SetActive(true);
}
if (Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT SixLevel FROM IsLevelsFinished WHERE stroka = {CurrentUser};")) == 1)
{
LevelsFinishedIcons[5].SetActive(true);
}
if (Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT SevenLevel FROM IsLevelsFinished WHERE stroka = {CurrentUser};")) == 1)
{
LevelsFinishedIcons[6].SetActive(true);
}
if (Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT EightLevel FROM IsLevelsFinished WHERE stroka = {CurrentUser};")) == 1)
{
LevelsFinishedIcons[7].SetActive(true);
}
if (Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT NineLevel FROM IsLevelsFinished WHERE stroka = {CurrentUser};")) == 1)
{
LevelsFinishedIcons[8].SetActive(true);
}
if (Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT TenLevel FROM IsLevelsFinished WHERE stroka = {CurrentUser};")) == 1)
{
LevelsFinishedIcons[9].SetActive(true);
}
if (Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT ElevenLevel FROM IsLevelsFinished WHERE stroka = {CurrentUser};")) == 1)
{
LevelsFinishedIcons[10].SetActive(true);
}
if (Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT TwelveLevel FROM IsLevelsFinished WHERE stroka = {CurrentUser};")) == 1)
{
LevelsFinishedIcons[11].SetActive(true);
}
if (Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT BulletChallenge FROM IsLevelsFinished WHERE stroka = {CurrentUser};")) == 1)
{
BulletChallengeFinishedIcon.SetActive(true);
}
if (Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT PodvoxChallenge FROM IsLevelsFinished WHERE stroka = {CurrentUser};")) == 1)
{
PodvoxChallengeFinishedIcon.SetActive(true);
}
if (Convert.ToInt16(MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT MeshalkaChallenge FROM IsLevelsFinished WHERE stroka = {CurrentUser};")) == 1)
{
MeshalkaChallengeFinishedIcon.SetActive(true);
}
}
public void AllUsersUpdate()
{
CurrentUser = PlayerPrefs.GetInt("CurrentUser");
AllUsers.text = (PlayerPrefs.GetInt("AllUsers")).ToString();
CountOfAllUsers = PlayerPrefs.GetInt("AllUsers");
if (CountOfAllUsers == 0)
{
UsersButtons[0].SetActive(false);
UsersButtons[1].SetActive(false);
UsersButtons[2].SetActive(false);
UsersButtons[3].SetActive(false);
UsersButtons[4].SetActive(false);
PlayerPrefs.SetInt("first_start", 0);
StartCoroutine(LoadLevel("Menu"));
}
if (CountOfAllUsers == 1)
{
NewUserButton.SetActive(true);
User1NameExit.text = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT NamePlayer FROM PlayerStats WHERE id = {1};");
UsersButtons[0].SetActive(true);
UsersButtons[1].SetActive(false);
UsersButtons[2].SetActive(false);
UsersButtons[3].SetActive(false);
UsersButtons[4].SetActive(false);
}
if (CountOfAllUsers == 2)
{
NewUserButton.SetActive(true);
User1NameExit.text = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT NamePlayer FROM PlayerStats WHERE id = {1};");
User2NameExit.text = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT NamePlayer FROM PlayerStats WHERE id = {2};");
UsersButtons[0].SetActive(true);
UsersButtons[1].SetActive(true);
UsersButtons[2].SetActive(false);
UsersButtons[3].SetActive(false);
UsersButtons[4].SetActive(false);
}
if (CountOfAllUsers == 3)
{
NewUserButton.SetActive(true);
User1NameExit.text = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT NamePlayer FROM PlayerStats WHERE id = {1};");
User2NameExit.text = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT NamePlayer FROM PlayerStats WHERE id = {2};");
User3NameExit.text = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT NamePlayer FROM PlayerStats WHERE id = {3};");
UsersButtons[0].SetActive(true);
UsersButtons[1].SetActive(true);
UsersButtons[2].SetActive(true);
UsersButtons[3].SetActive(false);
UsersButtons[4].SetActive(false);
}
if (CountOfAllUsers == 4)
{
NewUserButton.SetActive(true);
User1NameExit.text = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT NamePlayer FROM PlayerStats WHERE id = {1};");
User2NameExit.text = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT NamePlayer FROM PlayerStats WHERE id = {2};");
User3NameExit.text = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT NamePlayer FROM PlayerStats WHERE id = {3};");
User4NameExit.text = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT NamePlayer FROM PlayerStats WHERE id = {4};");
UsersButtons[0].SetActive(true);
UsersButtons[1].SetActive(true);
UsersButtons[2].SetActive(true);
UsersButtons[3].SetActive(true);
UsersButtons[4].SetActive(false);
}
if (CountOfAllUsers == 5)
{
NewUserButton.SetActive(false);
User1NameExit.text = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT NamePlayer FROM PlayerStats WHERE id = {1};");
User2NameExit.text = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT NamePlayer FROM PlayerStats WHERE id = {2};");
User3NameExit.text = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT NamePlayer FROM PlayerStats WHERE id = {3};");
User4NameExit.text = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT NamePlayer FROM PlayerStats WHERE id = {4};");
User5NameExit.text = MyDataBaseConnection.ExecuteQueryWithAnswer($"SELECT NamePlayer FROM PlayerStats WHERE id = {5};");
UsersButtons[0].SetActive(true);
UsersButtons[1].SetActive(true);
UsersButtons[2].SetActive(true);
UsersButtons[3].SetActive(true);
UsersButtons[4].SetActive(true);
}
}
