public static bool starboardExists(this StarboardMessage message)
{
using MySqlConnection connection = MySQL.getConnection();
if (connection.State != System.Data.ConnectionState.Open)
{
connection.Open();
}
string query = $"SELECT COUNT(1) FROM Starboards WHERE MsgID={message.message.Id}";
bool result = connection.ExecuteScalar <bool>(query);
return(result);
}
public static async Task Save(this StarboardMessage message)
{
using MySqlConnection connection = MySQL.getConnection();
string query = "";
if (message.stars >= Config.StarboardMin && !message.starboardExists())
{
query = $"INSERT INTO Starboards (MsgID, ChannelID, UserID, SBMessageID) " +
$"VALUES ({message.message.Id}, {message.channel.Id}, {message.author.Id}, {message.starboardid})";
}
else
{
query = $"DELETE FROM Starboards WHERE MsgID={message.message.Id}";
}
await connection.ExecuteAsync(query);
}