public async Task DisableCommand(ulong guildID, string cmdName)
{
SQLProcessor sql = new SQLProcessor(DatabaseConnection.connection);
if (CommandDisabled(cmdName))
{
return;
}
await sql.ExecuteQueryAsync($"INSERT INTO blacklistedcommands (guildID, command) VALUES ({guildID}, '{cmdName}')");
}
private async Task UpdateGuildPrefix(ulong guildId, string newPrefix)
{
SQLProcessor sql = new SQLProcessor(DatabaseConnection.connection);
await sql.ExecuteQueryAsync($"UPDATE guildprefix SET prefix='{newPrefix}' WHERE guildID={guildId}");
}
private async Task InsertGuildPrefix(ulong guildId, string newPrefix)
{
SQLProcessor sql = new SQLProcessor(DatabaseConnection.connection);
await sql.ExecuteQueryAsync($"INSERT INTO guildprefix (guildID, prefix) VALUES ({guildId}, '{newPrefix}')");
}
public async Task EnableCommand(ulong guildID, string cmdName)
{
SQLProcessor sql = new SQLProcessor(DatabaseConnection.connection);
await sql.ExecuteQueryAsync($"DELETE FROM blacklistedcommands WHERE guildID={guildID} and command='{cmdName}'");
}