private void Client_OnUserJoined(object sender, TwitchLib.Events.Client.OnUserJoinedArgs e) { int id, points; using (SQLiteConnection db = new SQLiteConnection(ConnectionString)) { db.Open(); using (SQLiteCommand dbCommand = new SQLiteCommand($"SELECT id FROM `users` WHERE `username`='{e.Username}'", db)) { id = Convert.ToInt16(dbCommand.ExecuteScalar()); } using (SQLiteCommand dbCommand = new SQLiteCommand($"SELECT points FROM `users` WHERE `username`='{e.Username}'", db)) { points = Convert.ToInt16(dbCommand.ExecuteScalar()); } if (id == 0) { using (SQLiteCommand dbCommand = new SQLiteCommand($"INSERT INTO `users`(username,points) VALUES ('{e.Username}',0)", db)) { dbCommand.ExecuteNonQuery(); } points = 0; } } User tmpUser = new User(e.Username, points); mg_users.BeginInvoke((MethodInvoker) delegate() { if (!Users.Any(u => u.Username == tmpUser.Username)) { Users.Add(tmpUser); } }); /*User t = Users.Single(us => us.Username == tmpUser.Username); * t.ran += TmpUser_ran; * t.Start();*/ }
private void Client_OnUserJoined(object sender, TwitchLib.Events.Client.OnUserJoinedArgs e) { Client.SendMessage($"Welcome @{e.Username} to the stream!"); Viewers.Add(e.Username); UpdateViewersText(); }