public async Task Search([Remainder] string name)
{
var root = RequestHandler.GetAmiibo(name);
foreach (var amiibo in root.amiibo)
{
Discord.EmbedBuilder builder = Builders.BaseBuilder("", "", Color.DarkMagenta,
new EmbedAuthorBuilder().WithName("AmiiboAPI's Results").WithUrl("http://www.amiiboapi.com"), null);
builder.AddInlineField("General Information",
"**Name: **" + amiibo.Name + "\n" +
"**Amiibo Series: **" + amiibo.Series + "\n" +
"**Game Series: **" + amiibo.GameSeries);
builder.AddInlineField("Releases",
"**NA:** " + Convert.ToDateTime(amiibo.Releases.na).ToLongDateString() + "\n" +
"**EU: **" + Convert.ToDateTime(amiibo.Releases.eu).ToLongDateString() + "\n" +
"**JP: **" + Convert.ToDateTime(amiibo.Releases.jp).ToLongDateString() + "\n" +
"**AU: **" + Convert.ToDateTime(amiibo.Releases.au).ToLongDateString());
try
{
builder.WithImageUrl(amiibo.ImageURL);
}
catch { }
await ReplyAsync("", embed : builder.Build());
}
}
public async Task rate(string link = null)
{
DateTime czas = time.AddSeconds(10);
if (link == null)
{
link = Context.Message.Attachments.FirstOrDefault().Url;
}
var builder = new Discord.EmbedBuilder();
builder.WithTitle("Ocena");
builder.AddInlineField("Autor: " + Context.Message.Author.Username, "Obrazek:");
builder.WithImageUrl(link);
builder.WithColor(Color.DarkGreen);
dbase.chkserver(Context.Guild);
string query = "SELECT * FROM `servery` WHERE `nid`='" + Context.Guild.Id.ToString() + "'";
MySqlCommand cmd = new MySqlCommand(query, dbase.connect);
var msg = await((ISocketMessageChannel)Context.Guild.GetChannel(ulong.Parse(dbase.Read(cmd).Rows[0][3].ToString()))).SendMessageAsync("", false, builder);
await msg.AddReactionAsync(Context.Guild.Emotes.First(e => e.Name == "redbean"));
string format = "yyyy-MM-dd HH:mm:ss";
query = "INSERT INTO `timery` (`id`, `user`, `type`, `time`, `text`, `Server`) VALUES (NULL, '" + Context.Message.Author.Id + "', 'rate', '" + czas.ToString(format) + "', '" + msg.Id + "', '" + dbase.Chkserver(Context.Guild.Id.ToString()) + "')";
cmd = new MySqlCommand(query, dbase.connect);
dbase.timer(cmd, "rate", czas, (IGuildUser)Context.Message.Author, Context.Guild.Id.ToString(), msg.Id.ToString());
Console.WriteLine(time + "\tRozpoczeto glosowanie obrazka uzytkownika " + Context.Message.Author.Username + ".");
}
public async Task Wadme()
{
IGuildUser user = (IGuildUser)Context.Message.Author;
if (user.GuildPermissions.Administrator)
{
var builder = new Discord.EmbedBuilder();
builder.WithImageUrl("https://cdn.discordapp.com/attachments/349728648443592714/489137824008765462/akumucatshake.gif");
await Context.Channel.SendMessageAsync("", false, builder);
}
}
public async Task UserAvatarAsync(string mention = null)
{
IUser user;
if (mention == null)
{
user = Context.User;
}
else
{
user = Context.Guild.GetUser(MentionUtils.ParseUser(mention));
}
var b = new Discord.EmbedBuilder();
b.WithTitle(user.Username + "'s Avatar");
b.WithImageUrl(user.GetAvatarUrl());
await Context.Channel.SendMessageAsync("", false, b.Build());
//await Context.Channel.SendMessageAsync(user.Username);
}
private async void memes(SocketMessage s)
{
try
{
var msg = s as SocketUserMessage;
var context = new SocketCommandContext(_client, msg);
db dbase = new db();
string meme = msg.Content.Remove(0, 1);
string[] memen = meme.Split(' ');
string query;
if (msg.Channel.Name.Contains("lewd"))
{
query = "SELECT m.text FROM memy as m INNER JOIN `servery` as s ON m.Server = s.id WHERE m.name=@name AND s.nid='" + context.Guild.Id.ToString() + "'";
}
else
{
query = "SELECT m.text FROM memy as m INNER JOIN `servery` as s ON m.Server = s.id WHERE m.name=@name AND s.nid='" + context.Guild.Id.ToString() + "' AND m.sfw='sfw'";
}
MySqlCommand cmd = new MySqlCommand(query, dbase.connect);
cmd.Parameters.AddWithValue("@name", memen[0]);
if (dbase.HasRows(cmd))
{
DataTable mem = dbase.Read(cmd);
if (mem.Rows[0][0].ToString().Contains("https://") || mem.Rows[0][0].ToString().Contains("http://"))
{
var builder = new Discord.EmbedBuilder();
builder.WithImageUrl(mem.Rows[0][0].ToString());
await s.Channel.SendMessageAsync("", false, builder);
}
else
{
await s.Channel.SendMessageAsync(mem.Rows[0][0].ToString());
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
}
