public static void category_check(string input, string hash)
{
int year = 2017;
if (year != 2017)
{
WindowsFormsApp4.Form1 form1 = new WindowsFormsApp4.Form1();
string sqlQuery = "select id,age from users";
SQLiteCommand m_sqlCmd = new SQLiteCommand();
SQLiteDataAdapter adapter = new SQLiteDataAdapter(sqlQuery, form1.m_dbConn);
SQLiteCommand command = new SQLiteCommand(sqlQuery, form1.m_dbConn);
SQLiteDataReader reader = command.ExecuteReader();
DateTime thisDay = DateTime.Today;
while (reader.Read())
{
int age = thisDay.Year - Convert.ToDateTime(reader[1]).Year;
if (age <= 13)
{
m_sqlCmd.CommandText = "UPDATE users SET category = 1 WHERE id = '" + reader[0].ToString() + "' ;";
m_sqlCmd.ExecuteNonQuery();
}
else if (age >= 14 && age <= 17)
{
m_sqlCmd.CommandText = "UPDATE users SET category = 2 WHERE id = '" + reader[0].ToString() + "' ;";
m_sqlCmd.ExecuteNonQuery();
}
else if (age >= 18 && age <= 20)
{
m_sqlCmd.CommandText = "UPDATE users SET category = 3 WHERE id = '" + reader[0].ToString() + "' ;";
m_sqlCmd.ExecuteNonQuery();
}
else if (age >= 20)
{
m_sqlCmd.CommandText = "UPDATE users SET category = 4 WHERE id = '" + reader[0].ToString() + "' ;";
m_sqlCmd.ExecuteNonQuery();
}
}
}
}
protected static void ExitGame(GameCell[,] gameField, PictureBox[,] pictureField, int i, int j, int delta, Player p, Panel MainPanel)
{
ThreadFlag = false;
var rnd = new Random();
int index = rnd.Next(1, 4);
MoveOnFreeArea(i, j, 0, delta, gameField, p);
Update(i, j, delta, 0, gameField, pictureField, new FreeArea(), p, MainPanel);
if (index == 1)
{
WindowsFormsApp1.Form1 mini = new WindowsFormsApp1.Form1();
mini.Show();
}
else if (index == 2)
{
MatchingGame.Form1 miniGame = new MatchingGame.Form1();
miniGame.Show();
}
else if (index == 3)
{
WindowsFormsApp4.Form1 codes = new WindowsFormsApp4.Form1();
codes.Show();
}
}
