private async Task OnMessageReceivedAsync(SocketMessage message)
{
var log = new LiteDiscordMessage(message);
using (var db = new LogDatabase())
{
await db.Messages.AddAsync(log);
await db.SaveChangesAsync();
}
}
public static async Task LogAsync(this SocketCommandContext context, long ms)
{
using (var db = new LogDatabase())
{
var msg = await db.GetMessageAsync(context.Message.Id);
var log = new LiteDiscordCommand(msg.Id, context.Message.Id, ms);
await db.Commands.AddAsync(log);
await db.SaveChangesAsync();
}
}
public static Task LoadSqliteModulesAsync(this CommandService service)
{
using (var db = new TagDatabase())
db.Database.EnsureCreated();
using (var db = new LogDatabase())
db.Database.EnsureCreated();
using (var db = new ConfigDatabase())
db.Database.EnsureCreated();
return(service.AddModulesAsync(typeof(LiteEntity <>).GetTypeInfo().Assembly));
}
private async Task OnReactionsClearedAsync(ulong id, Optional <SocketUserMessage> msg)
{
using (var db = new LogDatabase())
{
var logs = db.Reactions.Where(x => x.MessageId == msg.Value.Id);
foreach (var log in logs)
{
log.DeletedAt = DateTime.UtcNow;
}
db.UpdateRange(logs);
await db.SaveChangesAsync();
}
}
private async Task OnReactionRemovedAsync(ulong id, Optional <SocketUserMessage> msg, SocketReaction reaction)
{
using (var db = new LogDatabase())
{
var log = await db.Reactions.FirstOrDefaultAsync(x
=> x.MessageId == reaction.MessageId &&
x.AuthorId == reaction.UserId &&
x.EmojiId == reaction.Emoji.Id &&
x.EmojiName == reaction.Emoji.Name);
log.DeletedAt = DateTime.UtcNow;
db.Update(log);
await db.SaveChangesAsync();
}
}
private async Task OnReactionsClearedAsync(Cacheable <IUserMessage, ulong> message, ISocketMessageChannel channel)
{
using (var db = new LogDatabase())
{
var logs = db.Reactions.Where(x => x.MessageId == message.Id);
foreach (var log in logs)
{
log.DeletedAt = DateTime.UtcNow;
}
db.UpdateRange(logs);
await db.SaveChangesAsync();
}
}
private async Task OnReactionAddedAsync(ulong id, Optional <SocketUserMessage> msg, SocketReaction reaction)
{
var log = new LiteDiscordReaction(reaction);
using (var db = new LogDatabase())
{
var message = await db.Messages.FirstOrDefaultAsync(x => x.MessageId == reaction.MessageId);
if (message != null)
{
log.LogMessageId = message.Id;
}
await db.Reactions.AddAsync(log);
await db.SaveChangesAsync();
}
}
private async Task OnReactionAddedAsync(Cacheable <IUserMessage, ulong> message, ISocketMessageChannel channel, SocketReaction reaction)
{
var log = new LiteDiscordReaction(reaction);
using (var db = new LogDatabase())
{
var msg = await db.Messages.FirstOrDefaultAsync(x => x.MessageId == reaction.MessageId);
if (msg != null)
{
log.LogMessageId = msg.Id;
}
await db.Reactions.AddAsync(log);
await db.SaveChangesAsync();
}
}
