Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- string connStr = $"server=sql168.main-hosting.eu;user=u192471211_myuss;database=u192471211_myuss;password=finld12;";
- MySqlConnection conn = new MySqlConnection(connStr);
- conn.Open();
- DateTime d1;
- try
- {
- string sql = $"SELECT subscribe FROM myusers WHERE hwid = '{hwid}'";
- MySqlCommand command = new MySqlCommand(sql, conn);
- string date = command.ExecuteScalar().ToString();
- var client = new TcpClient("time.nist.gov", 13);
- using (var streamReader = new StreamReader(client.GetStream()))
- {
- var response = streamReader.ReadToEnd();
- var utcDateTimeString = response.Substring(7, 17);
- d1 = DateTime.ParseExact(utcDateTimeString, "yy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture, DateTimeStyles.AssumeUniversal);
- }
- DateTime d2 = Convert.ToDateTime(date);
- TimeSpan time = d2 - d1;
- int days = time.Days;
- if (days > 0)
- {
- btnLic.Text = $"Осталось {days} дней подписки";
- btnBuyOrStart.Text = "Запустить";
- status = true;
- }
- }
- catch (Exception ex)
- {
- btnLic.Text = "Не удалось подключиться";
- }
Add Comment
Please, Sign In to add comment