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); } }