public async Task Roles(string nameOrSpecies) { // If a role with this name exists, that's what we'll prioritize (users can use the genus + species overload if they need to). // If no such role exists, check for a species with this name instead. Role role = await BotUtils.GetRoleFromDb(nameOrSpecies); if (role is null) { // No such role exists, so check if a species exists with the given name instead. Species[] matching_species = await BotUtils.GetSpeciesFromDb("", nameOrSpecies); if (matching_species.Count() == 1) { // If only one species was returned, show the roles assigned to that species. await Roles(matching_species[0]); } else if (matching_species.Count() > 1) { // If multiple species were returned, provide a list of matching species for the user to choose from. await BotUtils.ReplyValidateSpeciesAsync(Context, matching_species); } if (matching_species.Count() > 0) { return; } } // If we got here, the role is eiher not null, or it is null, but no species with the given name exists. // In this case, proceed to validate the role, and display its information if possible. if (!await BotUtils.ReplyAsync_ValidateRole(Context, role)) { return; } // List all extant species with this role. List <Species> species_list = new List <Species>(await BotUtils.GetSpeciesFromDbByRole(role)); species_list.RemoveAll(x => x.IsExtinct); species_list.Sort((lhs, rhs) => lhs.ShortName.CompareTo(rhs.ShortName)); Bot.PaginatedMessageBuilder embed = new Bot.PaginatedMessageBuilder(EmbedUtils.SpeciesListToEmbedPages(species_list, fieldName: string.Format("Extant species with this role ({0}):", species_list.Count()))); embed.SetTitle(string.Format("Role: {0}", StringUtils.ToTitleCase(role.name))); embed.SetDescription(role.GetDescriptionOrDefault()); await Bot.DiscordUtils.SendMessageAsync(Context, embed.Build()); }
private async Task <Bot.PaginatedMessageBuilder> _buildGenerationEmbedAsync(Generation generation) { Bot.PaginatedMessageBuilder embed = await RecentCommands.BuildRecentEventsEmbedAsync(generation.StartTimestamp, generation.EndTimestamp); TimeAmount time_amount_since = new TimeAmount(DateUtils.GetCurrentTimestamp() - generation.EndTimestamp, TimeUnits.Seconds); embed.SetTitle(string.Format("{0} ({1})", generation.Name, generation.EndTimestamp == DateUtils.GetMaxTimestamp() ? "Current" : time_amount_since.Reduce().ToString() + " ago")); return(embed); }
private async Task _displaySpeciesAddedBy(string username, string thumbnailUrl, List <Species> speciesList) { if (speciesList.Count() <= 0) { await BotUtils.ReplyAsync_Info(Context, string.Format("**{0}** has not submitted any species yet.", username)); } else { Bot.PaginatedMessageBuilder embed = new Bot.PaginatedMessageBuilder(EmbedUtils.SpeciesListToEmbedPages(speciesList, fieldName: string.Format("Species owned by {0} ({1})", username, speciesList.Count()))); embed.SetThumbnailUrl(thumbnailUrl); await Bot.DiscordUtils.SendMessageAsync(Context, embed.Build()); } }
public async Task Extinct() { List <Species> sp_list = new List <Species>(); using (SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM Species WHERE id IN (SELECT species_id FROM Extinctions);")) using (DataTable rows = await Database.GetRowsAsync(cmd)) foreach (DataRow row in rows.Rows) { sp_list.Add(await SpeciesUtils.SpeciesFromDataRow(row)); } sp_list.Sort((lhs, rhs) => lhs.ShortName.CompareTo(rhs.ShortName)); Bot.PaginatedMessageBuilder embed = new Bot.PaginatedMessageBuilder(); embed.AddPages(EmbedUtils.SpeciesListToEmbedPages(sp_list, fieldName: string.Format("Extinct species ({0})", sp_list.Count()), flags: EmbedPagesFlag.None)); await Bot.DiscordUtils.SendMessageAsync(Context, embed.Build(), "There are currently no extinct species."); }
public async Task GetZoneType(string arg0) { // If the given argument is a zone type, display information for that type. // If the given argument is a zone name, display information for the type corresponding to that zone. ZoneType type = await ZoneUtils.GetZoneTypeAsync(arg0); if (!ZoneUtils.ZoneTypeIsValid(type)) { // If no zone type exists with this name, attempt to get the type of the zone with this name. Zone zone = await ZoneUtils.GetZoneAsync(arg0); if (zone != null) { type = await ZoneUtils.GetZoneTypeAsync(zone.ZoneTypeId); } } if (ZoneUtils.ZoneTypeIsValid(type)) { // We got a valid zone type, so show information about the zone type. Zone[] zones = await ZoneUtils.GetZonesAsync(type); Bot.PaginatedMessageBuilder embed = new Bot.PaginatedMessageBuilder { Title = string.Format("{0} {1} Zones ({2})", type.Icon, type.Name, zones.Count()), Description = type.Description + "\n\n", Color = Bot.DiscordUtils.ConvertColor(type.Color) }; await BotUtils.ZonesToEmbedPagesAsync(embed, zones, showIcon : false); embed.AddPageNumbers(); await Bot.DiscordUtils.SendMessageAsync(Context, embed.Build()); } else { await BotUtils.ReplyAsync_Error(Context, "No such zone type exists."); } }
public async Task Zone(string arg0 = "") { ZoneType zone_type = await ZoneUtils.GetZoneTypeAsync(arg0); if (string.IsNullOrEmpty(arg0) || ZoneUtils.ZoneTypeIsValid(zone_type)) { // Display all zones, or, if the user passed in a valid zone type, all zones of that type. Zone[] zones = await ZoneUtils.GetZonesAsync(zone_type); if (zones.Count() > 0) { // We need to make sure that even if the "short" description is actually long, we can show n zones per page. Bot.PaginatedMessageBuilder embed = new Bot.PaginatedMessageBuilder { Title = StringUtils.ToTitleCase(string.Format("{0} zones ({1})", string.IsNullOrEmpty(arg0) ? "All" : arg0, zones.Count())), Description = string.Format("For detailed zone information, use `{0}zone <zone>` (e.g. `{0}zone {1}`).\n\n", OurFoodChainBot.Instance.Config.Prefix, zones[0].ShortName.Contains(" ") ? string.Format("\"{0}\"", zones[0].ShortName.ToLower()) : zones[0].ShortName.ToLower()) }; // Build paginated message. await BotUtils.ZonesToEmbedPagesAsync(embed, zones); embed.AddPageNumbers(); if (ZoneUtils.ZoneTypeIsValid(zone_type)) { embed.SetColor(Bot.DiscordUtils.ConvertColor(zone_type.Color)); } await Bot.DiscordUtils.SendMessageAsync(Context, embed.Build()); } else { await BotUtils.ReplyAsync_Info(Context, "No zones have been added yet."); } return; } else { Zone zone = await ZoneUtils.GetZoneAsync(arg0); if (await BotUtils.ReplyValidateZoneAsync(Context, zone)) { List <Embed> pages = new List <Embed>(); ZoneType type = await ZoneUtils.GetZoneTypeAsync(zone.ZoneTypeId) ?? new ZoneType(); string title = string.Format("{0} {1}", type.Icon, zone.FullName); string description = zone.GetDescriptionOrDefault(); Color color = Bot.DiscordUtils.ConvertColor(type.Color); // Get all species living in this zone. List <Species> species_list = new List <Species>(await BotUtils.GetSpeciesFromDbByZone(zone)); species_list.Sort((lhs, rhs) => lhs.ShortName.CompareTo(rhs.ShortName)); // Starting building a paginated message. // The message will have a paginated species list, and a toggle button to display the species sorted by role. List <EmbedBuilder> embed_pages = EmbedUtils.SpeciesListToEmbedPages(species_list, fieldName: (string.Format("Extant species in this zone ({0}):", species_list.Count()))); Bot.PaginatedMessageBuilder paginated = new Bot.PaginatedMessageBuilder(embed_pages); if (embed_pages.Count() <= 0) { embed_pages.Add(new EmbedBuilder()); } // Add title, decription, etc., to all pages. paginated.SetTitle(title); paginated.SetDescription(description); paginated.SetThumbnailUrl(zone.Pics); paginated.SetColor(color); // This page will have species organized by role. // Only bother with the role page if species actually exist in this zone. if (species_list.Count() > 0) { EmbedBuilder role_page = new EmbedBuilder(); role_page.WithTitle(title); role_page.WithDescription(description); //role_page.WithThumbnailUrl(zone.pics); role_page.WithColor(color); Dictionary <string, List <Species> > roles_map = new Dictionary <string, List <Species> >(); foreach (Species sp in species_list) { Role[] roles_list = await SpeciesUtils.GetRolesAsync(sp); if (roles_list.Count() <= 0) { if (!roles_map.ContainsKey("no role")) { roles_map["no role"] = new List <Species>(); } roles_map["no role"].Add(sp); continue; } foreach (Role role in roles_list) { if (!roles_map.ContainsKey(role.name)) { roles_map[role.name] = new List <Species>(); } roles_map[role.name].Add(sp); } } // Sort the list of species belonging to each role. foreach (List <Species> i in roles_map.Values) { i.Sort((lhs, rhs) => lhs.ShortName.CompareTo(rhs.ShortName)); } // Create a sorted list of keys so that the roles are in order. List <string> sorted_keys = new List <string>(roles_map.Keys); sorted_keys.Sort(); foreach (string i in sorted_keys) { StringBuilder lines = new StringBuilder(); foreach (Species j in roles_map[i]) { lines.AppendLine(j.ShortName); } role_page.AddField(string.Format("{0}s ({1})", StringUtils.ToTitleCase(i), roles_map[i].Count()), lines.ToString(), inline: true); } // Add the page to the builder. paginated.AddReaction("🇷"); paginated.SetCallback(async(args) => { if (args.Reaction != "🇷") { return; } args.PaginatedMessage.PaginationEnabled = !args.ReactionAdded; if (args.ReactionAdded) { await args.DiscordMessage.ModifyAsync(msg => msg.Embed = role_page.Build()); } else { await args.DiscordMessage.ModifyAsync(msg => msg.Embed = args.PaginatedMessage.Pages[args.PaginatedMessage.PageIndex]); } }); } await Bot.DiscordUtils.SendMessageAsync(Context, paginated.Build()); } } }
private async Task _showGenerationAsync(ICommandContext context, Generation generation) { Bot.PaginatedMessageBuilder embed = await _buildGenerationEmbedAsync(generation); await Bot.DiscordUtils.SendMessageAsync(context, embed.Build()); }
public static async Task ShowSpeciesInfoAsync(ICommandContext context, Species species) { if (await BotUtils.ReplyValidateSpeciesAsync(context, species)) { EmbedBuilder embed = new EmbedBuilder(); StringBuilder descriptionBuilder = new StringBuilder(); string embed_title = species.FullName; Color embed_color = Color.Blue; CommonName[] common_names = await SpeciesUtils.GetCommonNamesAsync(species); if (common_names.Count() > 0) { embed_title += string.Format(" ({0})", string.Join(", ", (object[])common_names)); } // Show generation only if generations are enabled. if (OurFoodChainBot.Instance.Config.GenerationsEnabled) { Generation gen = await GenerationUtils.GetGenerationByTimestampAsync(species.Timestamp); embed.AddField("Gen", gen is null ? "???" : gen.Number.ToString(), inline: true); } embed.AddField("Owner", await SpeciesUtils.GetOwnerOrDefaultAsync(species, context), inline: true); SpeciesZone[] zone_list = await SpeciesUtils.GetZonesAsync(species); if (zone_list.Count() > 0) { embed_color = Bot.DiscordUtils.ConvertColor((await ZoneUtils.GetZoneTypeAsync(zone_list .GroupBy(x => x.Zone.ZoneTypeId) .OrderBy(x => x.Count()) .Last() .Key)).Color); } string zones_value = new SpeciesZoneCollection(zone_list).ToString(SpeciesZoneCollectionToStringOptions.Default, Bot.DiscordUtils.MaxFieldLength); embed.AddField("Zone(s)", string.IsNullOrEmpty(zones_value) ? "None" : zones_value, inline: true); // Check if the species is extinct. using (SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM Extinctions WHERE species_id=$species_id;")) { cmd.Parameters.AddWithValue("$species_id", species.Id); DataRow row = await Database.GetRowAsync(cmd); if (!(row is null)) { embed_title = "[EXTINCT] " + embed_title; embed_color = Color.Red; string reason = row.Field <string>("reason"); long timestamp = (long)row.Field <decimal>("timestamp"); if (!string.IsNullOrEmpty(reason)) { descriptionBuilder.AppendLine(string.Format("**Extinct ({0}):** _{1}_\n", await BotUtils.TimestampToDateStringAsync(timestamp), reason)); } } } descriptionBuilder.Append(species.GetDescriptionOrDefault()); embed.WithTitle(embed_title); embed.WithThumbnailUrl(species.Picture); embed.WithColor(embed_color); if (!string.IsNullOrEmpty(OurFoodChainBot.Instance.Config.WikiUrlFormat)) { // Discord automatically encodes certain characters in URIs, which doesn't allow us to update the config via Discord when we have "{0}" in the URL. // Replace this with the proper string before attempting to call string.Format. string format = OurFoodChainBot.Instance.Config.WikiUrlFormat.Replace("%7B0%7D", "{0}"); embed.WithUrl(string.Format(format, Uri.EscapeUriString(GetWikiPageTitleForSpecies(species, common_names)))); } if (embed.Length + descriptionBuilder.Length > DiscordUtils.MaxEmbedLength) { // If the description puts us over the character limit, we'll paginate. int pageLength = DiscordUtils.MaxEmbedLength - embed.Length; List <EmbedBuilder> pages = new List <EmbedBuilder>(); foreach (string pageText in new StringPaginator(descriptionBuilder.ToString()) { MaxPageLength = pageLength }) { EmbedBuilder page = new EmbedBuilder(); page.WithTitle(embed.Title); page.WithThumbnailUrl(embed.ThumbnailUrl); page.WithFields(embed.Fields); page.WithDescription(pageText); pages.Add(page); } PaginatedMessageBuilder builder = new Bot.PaginatedMessageBuilder(pages); builder.AddPageNumbers(); builder.SetColor(embed_color); await DiscordUtils.SendMessageAsync(context, builder.Build()); } else { embed.WithDescription(descriptionBuilder.ToString()); await context.Channel.SendMessageAsync("", false, embed.Build()); } } }
public static async Task <Bot.PaginatedMessageBuilder> BuildRecentEventsEmbedAsync(long startTimestamp, long endTimestamp, TimeUnits timeUnit = 0) { // Get all species created within the given timespan. List <Species> new_species = new List <Species>(); TimeAmount time_amount = new TimeAmount(endTimestamp - startTimestamp, TimeUnits.Seconds); if (timeUnit != 0) { time_amount = time_amount.ConvertTo(timeUnit); } else { time_amount = time_amount.Reduce(); } using (SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM Species WHERE timestamp >= $start_ts AND timestamp < $end_ts")) { cmd.Parameters.AddWithValue("$start_ts", startTimestamp); cmd.Parameters.AddWithValue("$end_ts", endTimestamp); using (DataTable table = await Database.GetRowsAsync(cmd)) foreach (DataRow row in table.Rows) { new_species.Add(await SpeciesUtils.SpeciesFromDataRow(row)); } } new_species.Sort(); // Get all extinctions that occurred recently. List <Species> extinct_species = new List <Species>(); using (SQLiteCommand cmd = new SQLiteCommand("SELECT * FROM Extinctions WHERE timestamp >= $start_ts AND timestamp < $end_ts")) { cmd.Parameters.AddWithValue("$start_ts", startTimestamp); cmd.Parameters.AddWithValue("$end_ts", endTimestamp); using (DataTable table = await Database.GetRowsAsync(cmd)) foreach (DataRow row in table.Rows) { extinct_species.Add(await BotUtils.GetSpeciesFromDb(row.Field <long>("species_id"))); } } extinct_species.Sort(); // Build embed. Bot.PaginatedMessageBuilder embed = new Bot.PaginatedMessageBuilder(); List <EmbedBuilder> pages = new List <EmbedBuilder>(); List <string> field_lines = new List <string>(); if (new_species.Count() > 0) { foreach (Species sp in new_species) { field_lines.Add(sp.FullName); } EmbedUtils.AddLongFieldToEmbedPages(pages, field_lines, fieldName: string.Format("New species ({0})", new_species.Count())); field_lines.Clear(); } if (extinct_species.Count() > 0) { foreach (Species sp in extinct_species) { field_lines.Add(sp.FullName); } EmbedUtils.AddLongFieldToEmbedPages(pages, field_lines, fieldName: string.Format("Extinctions ({0})", extinct_species.Count())); field_lines.Clear(); } embed.AddPages(pages); embed.SetTitle(string.Format("Recent events ({0})", time_amount.ToString())); embed.SetFooter(string.Empty); // remove page numbers added automatically embed.AddPageNumbers(); if (embed.FieldCount <= 0) { embed.SetDescription("No events"); } return(embed); }
public static async Task ShowRecentEventsAsync(ICommandContext context, long startTimestamp, long endTimestamp, TimeUnits timeUnit = 0) { Bot.PaginatedMessageBuilder embed = await BuildRecentEventsEmbedAsync(startTimestamp, endTimestamp, timeUnit); await Bot.DiscordUtils.SendMessageAsync(context, embed.Build()); }