SetNotificationChannelAsync(SocketTextChannel _channel)
{
//On server has text channel.
if (Context.Guild.Channels.Contains(_channel))
{
//Execute query.
CoreModule.ExecuteQuery(Context.Guild.Id,
$"update settings set notificationChannel =" +
$" '{_channel.Name}';");
//Create and set embed object.
var embed = CoreModule.SimpleEmbed(Color.Green,
"Set notification's channel completed",
$"The **channel** {_channel.Mention}" +
$" has been **set**.");
//Reply embed.
await ReplyAsync("", false, embed.Build());
//Send notification
CoreModule.SendNotification(Context.Guild.Id,
"Notification's channel changed",
$"{Context.User.Mention} **changed** the Notification's" +
$" channel to {_channel.Mention}.");
}
}
SetNotificationsAsync(bool _boolean)
{
//On true.
if (_boolean)
{
//Execute query.
CoreModule.ExecuteQuery(Context.Guild.Id,
$"UPDATE settings SET notifications = 'On';");
//Create and set embed object.
var embed = CoreModule.SimpleEmbed(Color.Green,
"Set notifications completed",
$"The **notifications** have been set **`On`**.");
//Reply embed.
await ReplyAsync("", false, embed.Build());
//Send notification
CoreModule.SendNotification(Context.Guild.Id,
"Notification settings changed",
$"{Context.User.Mention} **changed** the Notification" +
$" settings to **`On`**.");
}
//On false.
else
{
//Send notification.
CoreModule.SendNotification(Context.Guild.Id,
"Notification settings changed",
$"{Context.User.Mention} **changed** the Notification" +
$" settings to **`Off`**.");
//Execute query.
CoreModule.ExecuteQuery(Context.Guild.Id,
$"UPDATE settings SET notifications = 'Off';");
//Create and set embed content.
var embed = CoreModule.SimpleEmbed(Color.Green,
"Set notifications completed",
$"The **notifications** have been set **`Off`**.");
//Reply embed.
await ReplyAsync("", false, embed.Build());
}
}
StartNewStatsAsync()
{
//Execute query.
CoreModule.ExecuteQuery(Context.Guild.Id, "UPDATE users SET lastXP = actualXP;");
//Create and set embed object.
var embed = CoreModule.SimpleEmbed(Color.Green,
"Start new stats completed",
"The **`new stats`** of the database is completed.");
//Send notification.
CoreModule.SendNotification(Context.Guild.Id,
"Started new server stats",
$"{Context.User.Mention} **started** new database stats.");
//Reply embed.
await ReplyAsync("", false, embed.Build());
}
SetPrefixAsync(string _prefix)
{
//Execute query.
CoreModule.ExecuteQuery(Context.Guild.Id, $"update settings set prefix = '{_prefix}';");
//Set embed content.
var embed = CoreModule.SimpleEmbed(Color.Green,
"Set prefix completed",
$"The **prefix** **`{_prefix}`** has been **set**.");
//Reply embed.
await ReplyAsync("", false, embed.Build());
//Send notification.
CoreModule.SendNotification(Context.Guild.Id,
"prefix changed",
$"{Context.User.Mention} **changed** the prefix to" +
$" **`{_prefix}`**.");
}
RenameUsernameAsync(string _username, [Remainder] SocketGuildUser _user)
{
//On user on database.
if (CoreModule.UserExistsServerDB(Context.Guild.Id, _user.Id))
{
//Execute query.
CoreModule.ExecuteQuery(Context.Guild.Id,
$"UPDATE users SET name = '{_username}'" +
$" where id = {_user.Id};");
//Set embed object
var embed = CoreModule.SimpleEmbed(Color.Green,
"Update completed",
$"The **update** of the user {_user.Mention}" +
$" is **completed**.");
//Reply embed.
await ReplyAsync("", false, embed.Build());
//Send notification.
CoreModule.SendNotification(Context.Guild.Id,
"User username updated",
$"{Context.User.Mention} **updated** the user" +
$" {_user.Mention} database username to" +
$" **`{_username}`**.");
}
//On user not on database.
else
{
//Create and set embed content.
var embed = CoreModule.SimpleEmbed(Color.Red,
"User not found",
$"{_user.Mention} doesn't exist on the database," +
$" **`update aborted`**.");
//Reply embed.
await ReplyAsync("", false, embed.Build());
}
}
DeleteAsync([Remainder] SocketGuildUser _user)
{
//On user on database.
if (CoreModule.UserExistsServerDB(Context.Guild.Id, _user.Id))
{
//Execute query.
CoreModule.ExecuteQuery(Context.Guild.Id,
$"DELETE FROM users WHERE id = {_user.Id};");
//Create and set embed object.
var embed = CoreModule.SimpleEmbed(Color.Green,
"Delete completed",
$"The **delete** of the user" +
$" {_user.Mention} is **completed**.");
//Reply embed.
await ReplyAsync("", false, embed.Build());
//Send notification.
CoreModule.SendNotification(Context.Guild.Id,
"User deleted",
$"{Context.User.Mention} **deleted** the user" +
$" {_user.Mention} from the database.");
}
//On user not on database.
else
{
//Create and set embed object.
var embed = CoreModule.SimpleEmbed(Color.Red,
"User not found",
$"{_user.Mention} doesn't exist on the database," +
$" **`delete aborted`**.");
//Reply embed.
await ReplyAsync("", false, embed.Build());
}
}
SetRoleAsync(SocketRole _role)
{
//On server has role.
if (Context.Guild.Roles.Contains(_role))
{
//Execute query.
CoreModule.ExecuteQuery(Context.Guild.Id,
$"update settings set role = '{_role.Name}';");
//Create and set embed object.
var embed = CoreModule.SimpleEmbed(Color.Green,
"Set role completed",
$"The **role** {_role.Mention} has been **set**.");
//Reply embed
await ReplyAsync("", false, embed.Build());
//Send notification.
CoreModule.SendNotification(Context.Guild.Id,
"Member role changed",
$"{Context.User.Mention} **changed** the Guild Member" +
$" **role** to {_role.Mention}.");
}
}
SignupAsync(string _username, string _region)
{
//Create and set socket guild user.
SocketGuildUser user = Context.User as SocketGuildUser;
//Create and set role.
SocketRole role = CoreModule.GetRole(Context.Guild.Id, Context);
//On socket guild user contains guild member role.
if (user.Roles.Contains(role))
{
//On user not on database.
if (!CoreModule.UserExistsServerDB(Context.Guild.Id, user.Id))
{
//Execute query.
CoreModule.ExecuteQuery(Context.Guild.Id,
"INSERT INTO users (id,name,region,actualXP,lastXP)" +
$" VALUES ({user.Id},'{_username}','{_region}',0,0);");
//Create and set embed object.
var embed = CoreModule.SimpleEmbed(Color.Green,
"Sign up completed",
$"Your **sign up** is **completed**.");
//Reply embed.
await ReplyAsync("", false, embed.Build());
//Send notification
CoreModule.SendNotification(Context.Guild.Id,
"User registered",
$"{user.Mention} **registered** to the database.");
}
//On user in database.
else
{
//Create and set embed object.
var embed = CoreModule.SimpleEmbed(Color.Red,
"User found",
"You're already on the database," +
" **`sign up aborted`**.");
//Reply embed.
await ReplyAsync("", false, embed.Build());
}
}
//On socket guild user not contains role.
else
{
//Create embed object.
EmbedBuilder embed;
//On role exist.
if (role != null)
{
//Set embed object.
embed = CoreModule.SimpleEmbed(Color.Red,
"Not a member",
$"{user.Mention} you're not allowed to use this" +
$" command, only {role.Mention} is allowed" +
$" to use it.");
}
//Otherwise role don't exist.
else
{
//Set embed object.
embed = CoreModule.SimpleEmbed(Color.Red,
"Role not set",
"The **role** to use the commands has" +
" **not been set**, please use `~setrole` to set" +
" the role, **`sign up aborted`**.");
}
//Reply embed.
await ReplyAsync("", false, embed.Build());
}
}
