public async Task TimeAsync()
{
if (!(await Access("time")))
{
return;
}
SLog logger = new SLog("Time", Context);
try
{
TimeSpan current_time = DateTime.Now.TimeOfDay;
EmbedBuilder builder = new EmbedBuilder();
builder.WithTitle("Time").WithDescription($"Время на сервере: {current_time.Hours}:{current_time.Minutes}:{current_time.Seconds}")
.WithAuthor(Context.User.Username, Context.User.GetAvatarUrl())
.WithThumbnailUrl("https://media.discordapp.net/attachments/462236317926031370/464149984934100992/time.png?width=473&height=473")
.WithFooter(Context.Guild.Name, Context.Guild.IconUrl)
.WithColor(ConstVariables.InfoColor);
await Context.Channel.SendMessageAsync("", embed : builder.Build());
}
catch (Exception e)
{
await ReplyAsync("Ошибка во время выполнения! Обратитесь к админестратору!");
logger._exception = e;
}
logger.PrintLog();
}
public async Task PingAsync()
{
if (!(await Access("ping")))
{
return;
}
SLog logger = new SLog("RoleInfo 1", Context);
try
{
var sw = Stopwatch.StartNew();
var msg = await Context.Channel.SendMessageAsync("😝").ConfigureAwait(false);
sw.Stop();
await msg.DeleteAsync();
await Context.Channel.SendMessageAsync($"{Context.User.Mention}, пинг составляет: {(int)sw.Elapsed.TotalMilliseconds}ms").ConfigureAwait(false);
}
catch (Exception e)
{
await ReplyAsync("Ошибка во время выполнения! Обратитесь к админестратору!");
logger._exception = e;
}
logger.PrintLog();
}
public async Task SayMessAsync([Remainder] string mess)
{
if (!(await Access("say")))
{
return;
}
SLog logger = new SLog("Say", Context);
try
{
EmbedBuilder builder = new EmbedBuilder();
builder.WithAuthor(Context.User.Username, Context.User.GetAvatarUrl())
.WithFooter(Context.Guild.Name, Context.Guild.IconUrl)
.WithDescription(mess)
.WithColor(ConstVariables.UserColor);
await Context.Channel.SendMessageAsync("", embed : builder.Build());
logger._addcondition = $" is message '{mess}'";
}
catch (Exception e)
{
await ReplyAsync("Ошибка во время выполнения! Обратитесь к админестратору!");
logger._exception = e;
}
logger.PrintLog();
}
public async Task ReportAsync(string command, [Remainder] string text)
{
if (!(await Access("report")))
{
return;
}
SLog logger = new SLog("Report", Context);
try
{
string UMention = Context.User.Username + "#" + Context.User.Discriminator;
string report = $"Пользователь: {UMention}\r\nКоманда: {command}\r\nСообщение: {text}";
await ConstVariables.CServer[Context.Guild.Id].GetGuild().GetUser(ConstVariables.DateBase.OwnerID).SendMessageAsync(report);
await ReplyAsync($"{Context.User.Mention}, спасибо за ваш отчет! Ваше сообщение очень важно для нас))");
}
catch (Exception e)
{
await ReplyAsync("Ошибка во время выполнения! Обратитесь к админестратору!");
logger._exception = e;
}
logger.PrintLog();
}
public async Task HelloAsyng(SocketUser user = null)
{
if (!(await Access("hello")))
{
return;
}
SLog logger = new SLog("Hello", Context);
try
{
TimeSpan current_time = DateTime.Now.TimeOfDay;
int h = current_time.Hours;
string good = "";
if (user != null)
{
good = $"{user.Mention}, ";
}
else
{
good = $"{Context.Message.Author.Mention}, ";
}
if (h < 6)
{
good += "Доброй ночи!";
}
else if (h < 12)
{
good += "Доброе утро!";
}
else if (h < 18)
{
good += "Добрый день!";
}
else if (h < 20)
{
good += "Добрый вечер!";
}
else if (h < 24)
{
good += "Доброй ночи!";
}
await Context.Channel.SendMessageAsync(good);
}
catch (Exception e)
{
await ReplyAsync("Ошибка во время выполнения! Обратитесь к админестратору!");
logger._exception = e;
}
logger.PrintLog();
}
public async Task UserInfoAsync(IGuildUser user = null)
{
if (!(await Access("userinfo")))
{
return;
}
SLog logger = new SLog("UserInfo", Context);
try
{
IGuildUser User = user ?? Context.User as IGuildUser;
EmbedBuilder builder = new EmbedBuilder();
builder.AddField("Имя пользователя", User.Username + "#" + User.Discriminator, true);
if (User.Activity != null)
{
builder.AddField("Activity", User.Activity.Name, true);
}
builder.AddField("Дата создания", $"{User.CreatedAt:dd.MM.yyyy HH:mm}", true)
.AddField("Дата присоединения", User.JoinedAt?.ToString("dd.MM.yyyy HH:mm"), true)
.AddField("Кол-во ролей", User.RoleIds.Count - 1, true)
.WithColor(ConstVariables.InfoColor);
string avatar = User.GetAvatarUrl();
if (Uri.IsWellFormedUriString(avatar, UriKind.Absolute))
{
builder.WithThumbnailUrl(avatar);
}
string role = "";
int i = 1;
foreach (var key in User.RoleIds)
{
if (!Context.Guild.GetRole(key).IsEveryone)
{
role += $"{i++}: **{Context.Guild.GetRole(key).Name}** ({Context.Guild.GetRole(key).CreatedAt:dd.MM.yyyy HH:mm})\r\n";
}
}
builder.AddField("Роли", role);
await Context.Channel.SendMessageAsync("", embed : builder.Build());
}
catch (Exception e)
{
await ReplyAsync("Ошибка во время выполнения! Обратитесь к админестратору!");
logger._exception = e;
}
logger.PrintLog();
}
public async Task PerevorotAsync()
{
SLog logger = new SLog("Perevorot", Context);
try
{
if ((Context.User.Id == 252459542057713665) || (Context.User.Id == ConstVariables.DateBase.OwnerID))//Костя
{
if (ConstVariables.Perevorot && Context.User.Id != ConstVariables.DateBase.OwnerID)
{
await ReplyAndDeleteAsync("Этой командой можно пользоваться только один раз в день!", timeout : TimeSpan.FromSeconds(5));
return;
}
if (Context.User.Id != ConstVariables.DateBase.OwnerID)
{
ConstVariables.Perevorot = true;
}
DateTimeOffset time = Context.Message.CreatedAt;
Random ran = new Random();
int year = time.Year;
int month = ran.Next(1, 12);
int day = ran.Next(1, 31);
time = time.AddDays(day).AddMonths(month);
await Context.Channel.SendMessageAsync($"{Context.User.Mention}, переворот назначен на {time.Day}.{time.Month}.{time.Year}");
}
else
{
try
{
await Context.Message.DeleteAsync();
}
catch (Exception e)
{
ConstVariables.Logger.Error("Ошибка доступа:" + e.Message);
}
await ReplyAndDeleteAsync("Тихо! Об этом никто не должен знать!", timeout : TimeSpan.FromSeconds(5));
}
}
catch (Exception e)
{
await ReplyAsync("Ошибка во время выполнения! Обратитесь к админестратору!");
logger._exception = e;
}
logger.PrintLog();
}
public async Task SearchAsync([Remainder] string video)
{
if (!(await Access("search")))
{
return;
}
SLog logger = new SLog("search", Context);
try
{
ConstVariables.CDiscord guild = Module.ConstVariables.CServer[Context.Guild.Id];
EmbedBuilder builder = new EmbedBuilder();
builder.WithFooter(Context.Guild.Name, Context.Guild.IconUrl)
.WithThumbnailUrl("https://media.discordapp.net/attachments/462236317926031370/473478987126013952/yt_logo_rgb_dark.png");
var youtubeService = new YouTubeService(new BaseClientService.Initializer()
{
ApiKey = "AIzaSyDIuH33zi6aod6jSHm31V1VIVKYIIGxvEo",
ApplicationName = this.GetType().ToString()
});
var SearchVideo = youtubeService.Search.List("snippet");
SearchVideo.Q = video;
SearchVideo.Type = "video";
SearchVideo.ChannelId = "UCScLnRAwAT2qyNcvaFSFvYA";
SearchVideo.MaxResults = 5;
var SearchResult = await SearchVideo.ExecuteAsync();
int i = 1;
string strock = "";
foreach (var Search in SearchResult.Items)
{
strock += $"{i++}: {Search.Snippet.Title}\r\nurl:https://www.youtube.com/video/" + Search.Id.VideoId + "\r\n";
}
builder.AddField("YouTube video search", strock)
.WithColor(ConstVariables.InfoColor);
await Context.Channel.SendMessageAsync("", embed : builder.Build());
logger._addcondition = $" is Content '{video}'";
}
catch (Exception e)
{
await ReplyAsync("Ошибка во время выполнения! Обратитесь к админестратору!");
logger._exception = e;
}
logger.PrintLog();
}
public async Task DebugAsync()
{
SLog logger = new SLog("Debug", Context);
ConstVariables.CServer[Context.Guild.Id].Debug = !ConstVariables.CServer[Context.Guild.Id].Debug;
await ReplyAsync($"Режим дебага: {ConstVariables.CServer[Context.Guild.Id].Debug}");
logger._addcondition = $" is result '{(ConstVariables.CServer[Context.Guild.Id].Debug ? "on" : "off")}'";
logger.PrintLog();
}
public async Task ServerInfoAsync()
{
if (!await Access("serverinfo"))
{
return;
}
SLog logger = new SLog("ServerInfo", Context);
try
{
SocketGuild Guild = Context.Guild;
IGuildUser ownerName = Guild.GetUser(Guild.OwnerId);
DateTime createdAt = new DateTime(2015, 1, 1, 0, 0, 0, 0, DateTimeKind.Utc).AddMilliseconds(Guild.Id >> 22);
string GuildName = Guild.Name;
int TextChan = Guild.TextChannels.Count;
int VoiseChan = Guild.VoiceChannels.Count;
ulong GuildId = Guild.Id;
EmbedBuilder builder = new EmbedBuilder();
builder.AddField("Имя", GuildName, true)
.AddField("Id", GuildId, true)
.AddField("Создатель", ownerName, true)
.AddField("Дата создания", createdAt, true)
.AddField("Члены", Guild.MemberCount, true)
.AddField("Кол-во ролей", Guild.Roles.Count, true)
.AddField("Кол-во текстовых каналов", TextChan, true)
.AddField("Кол-во голосовых каналов", VoiseChan, true)
.WithColor(ConstVariables.InfoColor);
if (Uri.IsWellFormedUriString(Guild.IconUrl, UriKind.Absolute))
{
builder.WithThumbnailUrl(Guild.IconUrl);
}
await Context.Channel.SendMessageAsync("", embed : builder.Build());
}
catch (Exception e)
{
await ReplyAsync("Ошибка во время выполнения! Обратитесь к админестратору!");
logger._exception = e;
}
logger.PrintLog();
}
public async Task DeleteUSersListAsync(IUser User)
{
if (!(await Access("banlistdelete")))
{
return;
}
SLog logger = new SLog("BanListDelete", Context);
string SqlExpression = "sp_DeletUsersBan";
SqlParameter GuildIdParam = new SqlParameter
{
ParameterName = "@GuildId",
DbType = System.Data.DbType.Int64,
Value = Context.Guild.Id
};
SqlParameter BanedIdParam = new SqlParameter
{
ParameterName = "@BanedId",
DbType = System.Data.DbType.Int64,
Value = User.Id
};
using (SqlConnection conect = new SqlConnection(ConstVariables.DateBase.ConnectionStringKey))
{
try
{
conect.Open();
SqlCommand command = new SqlCommand(SqlExpression, conect)
{
CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(GuildIdParam);
command.Parameters.Add(BanedIdParam);
int number = command.ExecuteNonQuery();
await ReplyAsync($"Удалено записей: {number}");
logger._addcondition = $"is userdelete '{User.Username}#{User.Discriminator}'";
}
catch (Exception e)
{
await ReplyAsync("Ошибка вставки! Обратитесь к администратору!");
logger._exception = e;
}
logger.PrintLog();
}
}
private async Task HandleCommandAsync(SocketMessage arg)
{
SocketUserMessage Messeg = arg as SocketUserMessage;
if (Messeg is null || Messeg.Author.IsBot)
{
return;
}
int argPos = 0;
SocketCommandContext contex = new SocketCommandContext(_Client, Messeg);
SLog logger = new SLog(contex);
IResult result = null;
if (Messeg.HasStringPrefix("sh!", ref argPos) || Messeg.HasStringPrefix("Sh!", ref argPos))
{
result = await _Command.ExecuteAsync(contex, argPos, _UserService);
}
if (result == null)
{
return;
}
if (!result.IsSuccess)
{
switch (result.Error.Value)
{
case CommandError.BadArgCount: { logger.SetParam("BadArgCount", result.ErrorReason); contex.Channel.SendMessageAsync($"{contex.User.Mention}, неверные параметры команды").GetAwaiter(); break; }
case CommandError.UnknownCommand: { logger.SetParam("UnknownCommand", result.ErrorReason); contex.Channel.SendMessageAsync($"{contex.User.Mention}, неизвестная команда").GetAwaiter(); Help(contex); break; }
case CommandError.ObjectNotFound: { logger.SetParam("ObjectNotFound", result.ErrorReason); break; }
case CommandError.ParseFailed: { logger.SetParam("ParseFailed", result.ErrorReason); break; }
case CommandError.MultipleMatches: { logger.SetParam("MultipleMatches", result.ErrorReason); break; }
case CommandError.UnmetPrecondition: { logger.SetParam("UnmetPrecondition", result.ErrorReason); contex.Channel.SendMessageAsync(result.ErrorReason).GetAwaiter(); break; }
case CommandError.Exception: { logger.SetParam("Exception", result.ErrorReason); break; }
case CommandError.Unsuccessful: { logger.SetParam("Unsuccessful", result.ErrorReason); break; }
default: { logger.SetParam("Default", result.ErrorReason); break; }
}
logger.PrintLog();
}
}
public async Task WarnAsync(SocketUser user, [Remainder] string coment = "----")
{
if (!(await Access("warn")))
{
return;
}
SLog logger = new SLog("Warn", Context);
try
{
EmbedBuilder builder = new EmbedBuilder();
if (user.Id == DiscordAPI._Client.CurrentUser.Id)
{
builder.WithTitle("Ошибка!").WithDescription("нельзя жаловатся на бота!")
.WithFooter(Context.Guild.Name, Context.Guild.IconUrl)
.WithColor(ConstVariables.InfoColor);
await ReplyAsync("", embed : builder.Build());
return;
}
if (user.Id == Context.User.Id)
{
builder.WithAuthor(Context.User.Username, Context.User.GetAvatarUrl())
.WithDescription("Нельзя жаловаться на себя!")
.WithFooter(Context.Guild.Name, Context.Guild.IconUrl)
.WithColor(ConstVariables.InfoColor);
await ReplyAsync("", embed : builder.Build());
return;
}
builder.WithTitle("Жалоба!").WithColor(ConstVariables.UserColor)
.WithDescription($"Пользователь {Context.User.Mention} пожаловался на {user.Mention}!")
.AddField("Коментарий", coment)
.WithFooter(Context.Guild.Name, Context.Guild.IconUrl);
await Context.Channel.SendMessageAsync("", embed : builder.Build());
}
catch (Exception e)
{
await ReplyAsync("Ошибка во время выполнения! Обратитесь к админестратору!");
logger._exception = e;
}
logger.PrintLog();
}
public async Task RoleInfoAsync(SocketRole Role)
{
if (!(await Access("roleinfo")))
{
return;
}
SLog logger = new SLog("RoleInfo 2", Context);
try
{
EmbedBuilder builder = new EmbedBuilder();
string strock = "";
int i = 1;
foreach (var userr in Role.Members)
{
strock += $"{i++}: {userr.Username}#{userr.Discriminator}\r\n";
}
builder.WithTitle($"Информация о роле для {Context.User.Username}")
.WithAuthor(Role.Name)
.AddField("Кол-во пользователей с ролью", i - 1, true)
.AddField("Администратор?", Role.Permissions.Administrator, true)
.AddField("Цвет роли", $"{Role.Color}", true)
.AddField("Дата создания", $"{Role.CreatedAt.Day}.{Role.CreatedAt.Month}.{Role.CreatedAt.Year} {Role.CreatedAt.Hour + Role.CreatedAt.Offset.Hours}:{Role.CreatedAt.Minute}:{Role.CreatedAt.Second}.{Role.CreatedAt.Millisecond}", true)
.AddField("Пользователи", strock == "" ? "Пользователей нет" : strock)
.WithFooter(Context.Guild.Name, Context.Guild.IconUrl)
.WithColor(ConstVariables.UserColor);
await Context.Channel.SendMessageAsync("", embed : builder.Build());
}
catch (Exception e)
{
await ReplyAsync("Ошибка во время выполнения! Обратитесь к админестратору!");
logger._exception = e;
}
logger.PrintLog();
}
public async Task FlowControlAsync(int name = 0)
{
SLog logger = new SLog("FlowControl", Context);
switch (name)
{
case 0:
{
await ReplyAsync($"Статус функции: {ConstVariables.ControlFlow}");
break;
}
case 1:
{
ConstVariables.ControlFlow = true;
await ReplyAsync($"Установлен на true");
break;
}
case 2:
{
ConstVariables.ControlFlow = false;
await ReplyAsync($"Установлен на false");
break;
}
default:
{
await ReplyAsync($"не установленно значение");
break;
}
}
logger.PrintLog();
}
public async Task ThrowACoinAsync(int count = 1)
{
if (!(await Access("coin")))
{
return;
}
SLog logger = new SLog("Coin", Context);
try
{
Random ran = new Random();
if ((count <= 0) || (count > 100))
{
count = ran.Next(0, 101);
}
EmbedBuilder builder = new EmbedBuilder();
int ResultArray = 0;
for (int i = 0; i < count; i++)
{
ResultArray += ran.Next(0, 2);//[0;2)
}
builder.WithTitle("Результаты броска монеты")
.WithDescription($"Орел: {ResultArray}\r\nРешка: {count - ResultArray}");
await ReplyAsync("", embed : builder.Build());
}
catch (Exception e)
{
await ReplyAsync("Ошибка во время выполнения! Обратитесь к админестратору!");
logger._exception = e;
}
logger.PrintLog();
}
public async Task StatusAsync()
{
if (!(await Access("status")))
{
return;
}
SLog logger = new SLog("Status", Context);
string SqlRequestRole = $"SELECT [RoleId] FROM [Role] WHERE [GuildId] = {Context.Guild.Id}";
string SqlRequestChannel = $"SELECT [ChannelId] FROM [Channel] WHERE [GuildId] = {Context.Guild.Id}";
ConstVariables.CDiscord guild = ConstVariables.CServer[Context.Guild.Id];
EmbedBuilder builder = new EmbedBuilder();
string role = "";
string channel = "";
builder.WithTitle("the status of the bot")
.WithFooter(Context.Guild.Name, Context.Guild.IconUrl)
.WithAuthor(Context.User.Username, Context.User.GetAvatarUrl())
.AddField("Guild", Context.Guild.Name, true)
.AddField("Resurs", guild.CountRes + "/" + guild.Restruction, true)
.WithColor(ConstVariables.AdminColor);
int i = 1;
try
{
using (SqlConnection connect = new SqlConnection(ConstVariables.DateBase.ConnectionStringKey))
{
connect.Open();
SqlCommand command = new SqlCommand(SqlRequestRole, connect);
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
role += $"{i++}: **{Context.Guild.GetRole((ulong)reader.GetInt64(0)).Name}**\r\n";
}
}
else
{
throw new Exception($"Ошибка в чтении ролей сервера: {Context.Guild.Id}");
}
}
i = 1;
command.CommandText = SqlRequestChannel;
using (SqlDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
channel += $"{i++}: **{Context.Guild.GetChannel((ulong)reader.GetInt64(0)).Name}**\r\n";
}
}
else
{
throw new Exception($"Ошибка в чтении каналов сервера: {Context.Guild.Id}");
}
}
}
builder.AddField("Roles", role, true)
.AddField("Channels", channel, true)
.AddField("Версия бота", Base.Resource.VersionBot, true)
.AddField("Defaul channel", Context.Guild.GetTextChannel(guild.DefaultChannelId).Mention, true)
.AddField("Default channel for news", Context.Guild.GetTextChannel(guild.DefaultChannelNewsId).Mention, true)
.AddField("Guild Id", guild.GuildId, true);
await Context.Channel.SendMessageAsync("", false, builder.Build());
}
catch (Exception e)
{
await ReplyAsync("Ошибка чтения! Обратитесь к администратору!");
logger._exception = e;
}
logger.PrintLog();
}
public async Task TriggerAddAsync(string trigger1, string trigger2, bool allserver = false)
{
if (!(await Access("addtrigger")))
{
return;
}
SLog logger = new SLog("AddTrigger", Context);
string SqlExpression = "sp_AddTrigger";
SqlParameter GuildIdParam = new SqlParameter
{
ParameterName = "@GuildID",
DbType = System.Data.DbType.Int64,
Value = Context.Guild.Id
};
if (Context.User.Id == ConstVariables.DateBase.OwnerID && allserver)
{
GuildIdParam.Value = 0;
}
SqlParameter TextRes = new SqlParameter
{
ParameterName = "@TextRec",
DbType = System.Data.DbType.String,
Value = trigger1.ToLower()
};
SqlParameter TextOtv = new SqlParameter
{
ParameterName = "@TextOtv",
DbType = System.Data.DbType.String,
Value = trigger2
};
using (SqlConnection conect = new SqlConnection(ConstVariables.DateBase.ConnectionStringKey))
{
try
{
conect.Open();
SqlCommand command = new SqlCommand(SqlExpression, conect)
{
CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(GuildIdParam);
command.Parameters.Add(TextOtv);
command.Parameters.Add(TextRes);
int number = command.ExecuteNonQuery();
await ReplyAsync((number == 0 ? $"{Context.User.Mention}, возникла ошибка при добавлении!" : "добавлена новая запись!"));
}
catch (Exception e)
{
await ReplyAsync("Ошибка вставки! Обратитесь к администратору!");
logger._exception = e;
}
logger.PrintLog();
}
}
public async Task UpdateTriggerAsync(int id, string reupdate)
{
if (!(await Access("updatetrigger")))
{
return;
}
SLog logger = new SLog("UpdateTrigger", Context);
string SqlExpression = "sp_UpdateTrigger";
SqlParameter GuildIdParam = new SqlParameter
{
ParameterName = "@GuildID",
DbType = System.Data.DbType.Int64,
Value = Context.Guild.Id
};
SqlParameter IdTrigger = new SqlParameter
{
ParameterName = "@ID",
DbType = System.Data.DbType.Int32,
Value = id
};
SqlParameter ReUpdate = new SqlParameter
{
ParameterName = "@UpTrigger",
DbType = System.Data.DbType.String,
Value = reupdate
};
using (SqlConnection conect = new SqlConnection(ConstVariables.DateBase.ConnectionStringKey))
{
try
{
conect.Open();
using (SqlCommand command = new SqlCommand(SqlExpression, conect)
{
CommandType = System.Data.CommandType.StoredProcedure
})
{
command.Parameters.Add(GuildIdParam);
command.Parameters.Add(IdTrigger);
command.Parameters.Add(ReUpdate);
int result = await command.ExecuteNonQueryAsync();
if (result == 0)
{
await ReplyAsync("Не обновлен не одн триггер!");
}
else
{
await ReplyAsync("Обновлен 1 триггер.");
}
}
}
catch (Exception e)
{
await ReplyAsync("Ошибка чтения! Обратитесь к администратору!");
logger._exception = e;
}
logger.PrintLog();
}
}
public async Task NewsAsync([Remainder] string mess)
{
if (!(await Access("news")))
{
return;
}
SLog logger = new SLog("News", Context);
string URL = "Base/news26052017.jpg";
bool islocalfile = true;
if (mess.IndexOf("image:") == 0)
{
mess = mess.Remove(0, 6);
int tchk = mess.IndexOf(';');
URL = mess.Substring(0, tchk);
mess = mess.Remove(0, tchk + 2);
islocalfile = false;
}
var result = await Context.Channel.SendMessageAsync("Начата рассылка!\n Ждите, если это сообщение не пропадет, то напишите Sayary.");
var serv = ConstVariables.CServer[Context.Guild.Id];
foreach (var server in ConstVariables.CServer)
{
if (server.Value.DefaultChannelNewsId == 0)
{
continue;
}
try
{
ConstVariables.CDiscord guild = server.Value;
if (ConstVariables.ThisTest)
{
if (server.Value.GuildId != 435485527156981770)
{
continue;
}
if (islocalfile)
{
await guild.GetDefaultNewsChannel().SendFileAsync(URL, " ");
}
else
{
await guild.GetDefaultNewsChannel().SendMessageAsync(URL);
}
await guild.GetDefaultNewsChannel().SendMessageAsync(mess);
await guild.GetDefaultNewsChannel().SendMessageAsync("Автор: " + Context.User.Mention);
break;
}
else if (Context.User.Id == ConstVariables.DateBase.OwnerID)
{
if (islocalfile)
{
await guild.GetDefaultNewsChannel().SendFileAsync(URL, " ");
}
else
{
await guild.GetDefaultNewsChannel().SendMessageAsync(URL);
}
await guild.GetDefaultNewsChannel().SendMessageAsync(mess);
await guild.GetDefaultNewsChannel().SendMessageAsync("Автор: " + Context.User.Mention);
}
else if (Context.Guild.Id == server.Value.GuildId)
{
if (islocalfile)
{
await guild.GetDefaultNewsChannel().SendFileAsync("Base/LegioNews2.png", " ");
}
else
{
await guild.GetDefaultNewsChannel().SendMessageAsync(URL);
}
await guild.GetDefaultNewsChannel().SendMessageAsync(mess);
await guild.GetDefaultNewsChannel().SendMessageAsync("Автор: " + Context.User.Mention);
break;
}
}
catch (Exception e)
{
logger._exception = e;
}
}
try
{
await Context.Message.DeleteAsync();
await result.DeleteAsync();
}
catch
{
Console.WriteLine("Ошибка доступа!");
}
logger.PrintLog();
}
public async Task SelectTriggerDefaultAsync()
{
SLog logger = new SLog("SelectTriggerDefault", Context);
string SqlExpression = "sp_SelectTriggers";
string answer = ConstVariables.NCR;
int count = 1;
SqlParameter GuildIdParam = new SqlParameter
{
ParameterName = "@GuildID",
DbType = System.Data.DbType.Int64,
Value = 0
};
using (SqlConnection conect = new SqlConnection(ConstVariables.DateBase.ConnectionStringKey))
{
try
{
conect.Open();
using (SqlCommand command = new SqlCommand(SqlExpression, conect)
{
CommandType = System.Data.CommandType.StoredProcedure
})
{
command.Parameters.Add(GuildIdParam);
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
answer = "";
while (reader.Read())
{
int id = reader.GetInt32(0);
string textsec = reader.GetString(1);
string textanswer = reader.GetString(2);
string text = $"{count++}) **id trigger**: {id}\r\n{CountInterval(count)}**text search**: '{textsec}'\r\n{CountInterval(count)}**text anwser**: '{textanswer}'\r\n";
if (answer.Length + text.Length >= 2000)
{
await ReplyAsync(answer);
answer = text;
}
else
{
answer += text;
}
}
reader.Close();
await ReplyAsync(answer);
}
else
{
await ReplyAsync("триггеров не найдено!");
}
}
}
catch (Exception e)
{
await ReplyAsync("Ошибка чтения! Обратитесь к администратору!");
logger._exception = e;
}
logger.PrintLog();
}
}
public async Task AllNewsAsync([Remainder] string mess)
{
SLog logger = new SLog("AllNews", Context);
string URL = ConstVariables.Patch + "Base/news26052017.jpg";
bool islocalfile = true;
if (mess.IndexOf("image:") == 0)
{
mess = mess.Remove(0, 6);
int tchk = mess.IndexOf(';');
URL = mess.Substring(0, tchk);
mess = mess.Remove(0, tchk + 2);
islocalfile = false;
}
var result = await Context.Channel.SendMessageAsync("Sayary, жди. Начата рассылка");
foreach (var server in ConstVariables.CServer)
{
if (server.Value.DefaultChannelNewsId == 0)
{
continue;
}
try
{
ConstVariables.CDiscord guild = server.Value;
if (ConstVariables.ThisTest)
{
if (server.Value.GuildId != 435485527156981770)
{
continue;
}
if (islocalfile)
{
await guild.GetDefaultNewsChannel().SendFileAsync(URL, " ");
}
else
{
await guild.GetDefaultNewsChannel().SendMessageAsync(URL);
}
await guild.GetDefaultNewsChannel().SendMessageAsync(mess);
await guild.GetDefaultNewsChannel().SendMessageAsync("Автор: " + Context.User.Mention);
break;
}
else
{
if (islocalfile)
{
await guild.GetDefaultNewsChannel().SendFileAsync(URL, " ");
}
else
{
await guild.GetDefaultNewsChannel().SendMessageAsync(URL);
}
await guild.GetDefaultNewsChannel().SendMessageAsync(mess);
await guild.GetDefaultNewsChannel().SendMessageAsync("Автор: " + Context.User.Mention);
}
}
catch (Exception e)
{
logger._exception = e;
}
}
try
{
await Context.Message.DeleteAsync();
await result.DeleteAsync();
}
catch (Exception e)
{
logger._exception = e;
}
logger.PrintLog();
}
public async Task BanListAsync(IUser User = null)
{
if (!(await Access("banlist")))
{
return;
}
SLog logger = new SLog("BanList", Context);
string SqlExpression = "sp_SelectBanList";
string TextRequest = "";
EmbedBuilder builder = new EmbedBuilder();
if (User != null)
{
SqlExpression = "sp_SelectBanListAnd";
}
builder.WithTitle($"Бан лист{(User != null ? "(Выборка)" : "")}");
using (SqlConnection conect = new SqlConnection(ConstVariables.DateBase.ConnectionStringKey))
{
try
{
conect.Open();
using (SqlCommand command = new SqlCommand(SqlExpression, conect)
{
CommandType = System.Data.CommandType.StoredProcedure
})
{
if (User != null)
{
SqlParameter BannedParam = new SqlParameter()
{
ParameterName = "@BannedId",
DbType = System.Data.DbType.Int64,
Value = User
};
command.Parameters.Add(BannedParam);
}
SqlParameter GuildIdParam = new SqlParameter()
{
ParameterName = "@GuildId",
DbType = System.Data.DbType.Int64,
Value = Context.Guild.Id
};
command.Parameters.Add(GuildIdParam);
SqlDataReader reader = await command.ExecuteReaderAsync();
if (reader.HasRows)
{
while (reader.Read())
{
ulong BannedId = (ulong)reader.GetInt64(0);
ulong AdminId = (ulong)reader.GetInt64(1);
string Comment = reader.GetString(2);
DateTime Date = reader.GetDateTime(3);
var banned = Context.Guild.GetUser(BannedId);
var admin = Context.Guild.GetUser(AdminId);
TextRequest += $"**Пользователь:** {(banned == null ? "----" : banned.Mention)}\r\n**Администратор:** {(admin == null ? "----" : admin.Mention)}\r\nЗаметка: {Comment}\r\nДата: {Date}\r\n";
}
builder.WithDescription(TextRequest)
.WithFooter(Context.Guild.Name, Context.Guild.IconUrl)
.WithColor(ConstVariables.UserColor);
await ReplyAsync("", embed : builder.Build());
}
else
{
await ReplyAsync("Данных в базе не обнаружено!");
}
logger._addcondition = $"is user '{Context.User.Username}#{Context.User.Discriminator}'";
}
}
catch (Exception e)
{
await ReplyAsync("Произошла ошибка! Обратитесь к администратору.");
logger._exception = e;
}
logger.PrintLog();
}
}
public async Task HelpAsync()
{
if (!(await Access("help")))
{
return;
}
SLog logger = new SLog("Help", Context);
try
{
SocketGuildUser user = Context.Guild.GetUser(Context.User.Id);
ConstVariables.CDiscord guild = ConstVariables.CServer[Context.Guild.Id];
EmbedBuilder builder = new EmbedBuilder();
bool IsRole = false;
foreach (var role in user.Roles)
{
if (guild.EntryRole(role.Id))
{
IsRole = true;
break;
}
}
string TitlList = "Префикс команд для бота 'sh!' или 'Sh!'";
builder.AddField("Параметры", "[] - обязательно \r\n<> - не обязательно")
.WithTitle(TitlList)
.AddField("Group: Default", Module.ConstVariables.UTHelp, true)
.WithColor(Color.Orange)
.WithFooter(Context.Guild.Name, Context.Guild.IconUrl);
if (IsRole)
{
builder.AddField("Group: Admin", Module.ConstVariables.ATHelp, true);
}
if (Context.User.Id == ConstVariables.DateBase.OwnerID)
{
string own = $"1: allnews\r\n";
own += $"2: debug\r\n";
own += $"3: selecttriggerdefault";
builder.AddField("Group: Owner", own, true);
}
logger._addcondition = $" is IsRole {IsRole}";
await Context.Channel.SendMessageAsync($"{Context.Message.Author.Mention},", false, builder.Build());
}
catch (Exception e)
{
await ReplyAsync("Ошибка во время выполнения! Обратитесь к админестратору!");
logger._exception = e;
}
logger.PrintLog();
}
public async Task InfoRoleAsync([Remainder] string message)
{
if (!(await Access("roleinfo")))
{
return;
}
SLog logger = new SLog("RoleInfo 1", Context);
try
{
bool FoundARole = false;
ulong roleId = 0;
foreach (var rol in Context.Guild.Roles)
{
if (rol.Name == message)
{
roleId = rol.Id;
FoundARole = true;
}
}
if (!FoundARole)
{
await ReplyAndDeleteAsync("Роль не найдена", timeout : TimeSpan.FromSeconds(5));
return;
}
SocketRole Role = Context.Guild.GetRole(roleId);
EmbedBuilder builder = new EmbedBuilder();
string strock = "";
int i = 1;
foreach (var userr in Role.Members)
{
strock += $"{i++}: {userr.Username}#{userr.Discriminator}({userr.Nickname})\r\n";
}
if (strock == "")
{
strock = "Пользователей нет";
}
builder.WithTitle($"Информация о роле для {Context.User.Username}")
.WithAuthor(Role.Name)
.AddField("Кол-во пользователей с ролью", i - 1, true)
.AddField("Цвет роли", $"{Role.Color}", true)
.AddField("Администратор?", Role.Permissions.Administrator, true)
.AddField("Дата создания", $"{Role.CreatedAt.Day}.{Role.CreatedAt.Month}.{Role.CreatedAt.Year} {Role.CreatedAt.Hour + Role.CreatedAt.Offset.Hours}:{Role.CreatedAt.Minute}:{Role.CreatedAt.Second}.{Role.CreatedAt.Millisecond}", true)
.AddField("Пользователи", strock)
.WithFooter(Context.Guild.Name, Context.Guild.IconUrl)
.WithColor(ConstVariables.UserColor);
await Context.Channel.SendMessageAsync("", embed : builder.Build());
}
catch (Exception e)
{
await ReplyAsync("Ошибка во время выполнения! Обратитесь к админестратору!");
logger._exception = e;
}
logger.PrintLog();
}
public async Task RoleIhfoAsync()
{
if (!(await Access("roleinfo")))
{
return;
}
SLog logger = new SLog("RoleInfo 0", Context);
EmbedBuilder builder = new EmbedBuilder();
int CountRole = 0;
foreach (var key in Context.Guild.Roles)
{
if (CountRole < key.Position)
{
CountRole = key.Position;
}
}
string roleinfo = "";
Dictionary <int, SocketRole> InfoRole = new Dictionary <int, SocketRole>();
if (ConstVariables.CServer[Context.Guild.Id].Debug || ConstVariables.ThisTest)
{
Console.WriteLine($"Полный список ролей сервера");
Console.WriteLine($"{CountRole}"); /*для отладки*/
}
try
{
if (ConstVariables.CServer[Context.Guild.Id].Debug || ConstVariables.ThisTest)
{
Console.WriteLine($"Загрузка ролей в базу данных по их номнерам");
}
foreach (var role in Context.Guild.Roles)
{
if (role.Id != Context.Guild.EveryoneRole.Id)
{
try
{
InfoRole.Add(role.Position - 1, role);
if (ConstVariables.CServer[Context.Guild.Id].Debug || ConstVariables.ThisTest)
{
Console.WriteLine($"{role.Name}, {role.Position}"); /*для отладки*/
}
}
catch (Exception e)
{
if (ConstVariables.CServer[Context.Guild.Id].Debug || ConstVariables.ThisTest)
{
Console.WriteLine($"{role.Name} {role.Position}({role.Position - 1}): {e.Message}");/*для отладки*/
}
ConstVariables.Logger.Error($"{role.Name} {role.Position}({role.Position - 1}): {e.Message}");
}
}
}
for (int i = CountRole; i > 0; i--)
{
try
{
if (!InfoRole.ContainsKey(i - 1))
{
continue;
}
if (InfoRole[i - 1] == null)
{
continue;
}
roleinfo += $"{CountRole - i + 1}: **{InfoRole[i - 1].Name}** ({InfoRole[i - 1].CreatedAt:dd.MM.yyyy HH:mm})\r\n";
}
catch (Exception e)
{
if (ConstVariables.CServer[Context.Guild.Id].Debug || ConstVariables.ThisTest)
{
Console.WriteLine($"{CountRole}, {i}: {e.Message}");/*для отладки*/
}
ConstVariables.Logger.Error($"{CountRole}, {i}: {e.Message}");
}
}
builder.WithTitle($"Количество ролей на сервере: {CountRole}")
.WithDescription(roleinfo)
.WithFooter(Context.Guild.Name, Context.Guild.IconUrl)
.WithColor(ConstVariables.UserColor);
await Context.Channel.SendMessageAsync("", embed : builder.Build());
}
catch (Exception e)
{
await ReplyAsync("Ошибка во время выполнения! Обратитесь к админестратору!");
logger._exception = e;
}
logger.PrintLog();
}
public async Task BanListAsync(IUser User, [Remainder] string comment = null)
{
if (!(await Access("banlistadd")))
{
return;
}
SLog logger = new SLog("BanListAdd", Context);
EmbedBuilder builder = new EmbedBuilder();
string SqlExpression = "sp_InsertUsersBan";
if (Context.User.Id == User.Id)
{
await ReplyAndDeleteAsync("Банить самого себя нельзя! Но я очень хочу на это посмотреть!", timeout : TimeSpan.FromSeconds(5));
return;
}
if (User.IsBot)
{
switch (Context.Guild.Id)
{
//[Legion Sharon'a]
case 423154703354822668:
{
await ReplyAndDeleteAsync($"Ботов банить нельзя! Но если вы удалите Nadeko, то я буду не против", timeout : TimeSpan.FromSeconds(5));
return;
}
default:
{
await ReplyAndDeleteAsync($"Ботов банить нельзя!", timeout : TimeSpan.FromSeconds(5));
return;
}
}
}
builder.WithTitle("Лист бана")
.WithDescription("Добавлен новый пользователь")
.AddField("Пользователь", User.Mention, true)
.AddField("Администратор", Context.User.Mention, true)
.WithColor(ConstVariables.AdminColor);
if (comment != null)
{
builder.AddField("Заметка", comment);
}
else
{
comment = "Отсутствует";
}
SqlParameter GuildParam = new SqlParameter
{
ParameterName = "@GuildId",
DbType = System.Data.DbType.Int64,
Value = Context.Guild.Id
};
SqlParameter BanedParam = new SqlParameter
{
ParameterName = "@BanedId",
DbType = System.Data.DbType.Int64,
Value = User.Id
};
SqlParameter AdminParam = new SqlParameter
{
ParameterName = "@AdminId",
DbType = System.Data.DbType.Int64,
Value = Context.User.Id
};
SqlParameter CommentParam = new SqlParameter
{
ParameterName = "@Comment",
DbType = System.Data.DbType.String,
Value = comment
};
using (SqlConnection conect = new SqlConnection(ConstVariables.DateBase.ConnectionStringKey))
{
try
{
conect.Open();
SqlCommand command = new SqlCommand(SqlExpression, conect)
{
CommandType = System.Data.CommandType.StoredProcedure
};
command.Parameters.Add(GuildParam);
command.Parameters.Add(BanedParam);
command.Parameters.Add(AdminParam);
command.Parameters.Add(CommentParam);
int number = command.ExecuteNonQuery();
await ReplyAsync("", embed : builder.Build());
logger._addcondition = $"is UserBanned '{User.Username}#{User.Discriminator}'";
}
catch (Exception e)
{
await ReplyAsync("Ошибка вставки! Обратитесь к администратору!");
logger._exception = e;
}
logger.PrintLog();
}
}
