Guest User

Untitled

a guest
Dec 8th, 2018
205
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.12 KB | None | 0 0
  1. string connStr = $"server=sql168.main-hosting.eu;user=u192471211_myuss;database=u192471211_myuss;password=finld12;";
  2. MySqlConnection conn = new MySqlConnection(connStr);
  3. conn.Open();
  4.  
  5. DateTime d1;
  6. try
  7. {
  8. string sql = $"SELECT subscribe FROM myusers WHERE hwid = '{hwid}'";
  9. MySqlCommand command = new MySqlCommand(sql, conn);
  10. string date = command.ExecuteScalar().ToString();
  11.  
  12. var client = new TcpClient("time.nist.gov", 13);
  13. using (var streamReader = new StreamReader(client.GetStream()))
  14. {
  15. var response = streamReader.ReadToEnd();
  16. var utcDateTimeString = response.Substring(7, 17);
  17. d1 = DateTime.ParseExact(utcDateTimeString, "yy-MM-dd HH:mm:ss", CultureInfo.InvariantCulture, DateTimeStyles.AssumeUniversal);
  18. }
  19.  
  20. DateTime d2 = Convert.ToDateTime(date);
  21. TimeSpan time = d2 - d1;
  22.  
  23. int days = time.Days;
  24.  
  25. if (days > 0)
  26. {
  27. btnLic.Text = $"Осталось {days} дней подписки";
  28. btnBuyOrStart.Text = "Запустить";
  29. status = true;
  30. }
  31. }
  32. catch (Exception ex)
  33. {
  34. btnLic.Text = "Не удалось подключиться";
  35. }
Add Comment
Please, Sign In to add comment