public static void AddBits(User user, int count)
{
using (DatabaseConnection conn = new DatabaseConnection()) {
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "UPDATE gadget_bitbar "
+ "SET value = value + @count "
+ "WHERE user_id = @userid";
cmd.Parameters.AddWithValue("@count", count);
cmd.Parameters.AddWithValue("@userid", user.UserId);
cmd.ExecuteNonQuery();
Logger.Log("Added " + count + " to bitbar of " + user.UserId);
}
Bitbar bitbar = BitbarManager.GetBitbar(user);
BitbarHub.UpdateSource(bitbar);
}
public static void UpdateBitbar(Bitbar bitbar)
{
using (DatabaseConnection conn = new DatabaseConnection()) {
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "UPDATE gadget_bitbar "
+ "SET value = @val, max_value = @maxval, image = @img, "
+ "target_color = @tcolor, fill_color = @fcolor "
+ "WHERE id = @id";
cmd.Parameters.AddWithValue("@val", bitbar.Value);
cmd.Parameters.AddWithValue("@maxval", bitbar.MaxValue);
cmd.Parameters.AddWithValue("@img", bitbar.Image);
cmd.Parameters.AddWithValue("@tcolor", bitbar.TargetColor);
cmd.Parameters.AddWithValue("@fcolor", bitbar.FillColor);
cmd.Parameters.AddWithValue("@id", bitbar.Id);
cmd.ExecuteNonQuery();
}
BitbarHub.UpdateSource(bitbar);
}
