private async Task PreCommandHandle(SocketMessage s)
{
//DataAccess Db = new DataAccess();
var msg = s as SocketUserMessage;
//if (msg == null) return;
//var context = new SocketCommandContext(_client, msg);
//UserAccountModel model = new UserAccountModel();
//model = Db.GetUser(context.User.Id);
//// Mute check
//if ((model.IsMuted == 1 && context.User.IsBot == false) || (model.IsMuted == 1 && context.Guild.OwnerId != context.User.Id))
//{
// if (msg.Content.StartsWith("!Appeal mute") || msg.Content.StartsWith("!Appeal Mute") || msg.Content.StartsWith("!appeal mute") || msg.Content.StartsWith("!appeal Mute"))
// {
// await HandleCommandAsync(msg);
// await Task.Delay(1);
// //var newMsg = msg.Content.TrimStart((char)12);
// //await Appeal((SocketGuildUser)context.User, newMsg, context.Guild);
// }
// await context.Message.DeleteAsync();
// return;
//}
//if (context.User.IsBot) return;
DataAccess Db = new DataAccess();
var msg = s as SocketUserMessage;
if (msg == null)
{
return;
}
var context = new SocketCommandContext(_client, msg);
UserAccountModel model = new UserAccountModel();
model = Db.GetUser(context.User.Id);
// Mute check
if (model.IsMuted == 1 && context.User.IsBot == false)
{
if (useraccount.IsMuted)
{
if (msg.Content.StartsWith("!Appeal mute") || msg.Content.StartsWith("!Appeal Mute") || msg.Content.StartsWith("!appeal mute") || msg.Content.StartsWith("!appeal Mute"))
{
await HandleCommandAsync(msg);
await Task.Delay(1);
//var newMsg = msg.Content.TrimStart((char)12);
//await Appeal((SocketGuildUser)context.User, newMsg, context.Guild);
}
await context.Message.DeleteAsync();
return;
}
}
if (context.User.IsBot)
{
return;
}
await HandleCommandAsync(msg);
}
public UserAccountModel GetUser(ulong userId)
{
string idString = userId.ToString();
using (IDbConnection connection = new SQLiteConnection(DataBaseHandler.CnnVal(nameS)))
{
var t = Global.Client.GetGuild(Config.bot.guildID).GetUser(userId);
UserAccountModel model = new UserAccountModel();
//select * from UserAcc where @IdString
var users = connection.Query($"SELECT * from UserAcc where Id = " + t.Id + ";");
var UsersL = users.ToList();
foreach (var p in UsersL)
{
//Console.WriteLine($" Id: {p.Id} \n Warnings: {p.NumberOfWarnings} \n Is Muted: {p.IsMuted}");
model.Id = (ulong)p.Id;
model.NumberOfWarnings = (byte)p.NumberOfWarnings;
model.IsMuted = (byte)p.IsMuted;
return(model);
}
return(model);
}
}
public void UpdateUserWarning(ulong userId, byte warningAdd)
{
var idString = Converter.ConvertToString(userId);
using (IDbConnection connection = new SQLiteConnection(DataBaseHandler.CnnVal(nameS)))
{
UserAccountModel model = new UserAccountModel();
connection.Open();
var users = connection.Query($"SELECT * from UserAcc where Id = " + userId + ";");
var UsersL = users.ToList();
foreach (var p in UsersL)
{
Console.WriteLine($" Id: {p.Id} \n Warnings: {p.NumberOfWarnings} \n Is Muted: {p.IsMuted}");
model.Id = (ulong)p.Id;
model.NumberOfWarnings = (byte)p.NumberOfWarnings;
model.IsMuted = (byte)p.IsMuted;
connection.Execute($"update UserAcc set NumberOfWarnings = {warningAdd + model.NumberOfWarnings} WHERE Id = {userId};");
}
connection.Close();
}
}