async Task HandleCommandAsync(SocketMessage arg)
{
var message = arg as SocketUserMessage;
if (message is null)
{
return;
}
int argPos = 0;
string curdatetime = DateTime.Now.ToString("HH:mm:ss");
//Thread sqlFunctions = new Thread(() => sqlCalls(arg));
//sqlFunctions.Start();
//Delete Messages
if (arg.Author.Username.Contains("Dyno#3861"))
{
var delmsgcount = int.Parse(_sql.GetSingleValue("SELECT msgCount FROM stats"));
_sql.Execute($"UPDATE stats SET messageCount ={delmsgcount - 1}");
}
if (message.HasCharPrefix('!', ref argPos) || message.HasMentionPrefix(_client.CurrentUser, ref argPos))
{
var context = new SocketCommandContext(_client, message);
var result = await _commands.ExecuteAsync(context, argPos, _services);
if (!result.IsSuccess)
{
await message.DeleteAsync();
await context.Channel.SendMessageAsync("Error: " + result.ErrorReason);
await Log(curdatetime + " Error " + result.ErrorReason);
}
else
{
await message.DeleteAsync();
await Log(curdatetime + " Command " + message.Content + " " + message.Author);
}
}
//Delete Messages in Stream Channel
if (arg.Channel.Name.Contains("streaming") && (arg.Author.IsBot == false))
{
await arg.DeleteAsync();
}
//React to message if it Contains SmokeyFish
if (arg.Content.ToLower().Contains("smokeyfish"))
{
IUserMessage usermsg = (IUserMessage)arg;
Emote emote = Emote.Parse("<:smokeyfish:481276964850892821>");
await usermsg.AddReactionAsync(emote);
}
}
public async Task MessageCount()
{
sql.Setup();
string userMsgCount = sql.GetSingleValue($"SELECT msgCount FROM users WHERE id = '{Context.Message.Author.Id}'");
string guildMessageCount = sql.GetSingleValue("SELECT msgCount FROM stats WHERE id = 'gves'");
await ReplyAsync("There are currently **" + (int.Parse(guildMessageCount) + 1) + "** messages in this discord!" + Environment.NewLine + Environment.NewLine + "<@" + Context.Message.Author.Id.ToString() + "> has sent **" + userMsgCount + "** messages in this discord!");
}