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();
}
