public override async Task OnCommand(CommandArguments command) { BlogPost post; await using (var db = await Database.GetConnectionAsync()) { post = (await db.QueryAsync <BlogPost>("SELECT `ID`, `Slug`, `Title` FROM `Blog` WHERE `IsHidden` = 0 ORDER BY `Time` DESC LIMIT 1")).SingleOrDefault(); } if (post.ID == 0) { command.Reply("No blog post found."); return; } command.Reply( command.Message.Length > 0 ? "Blog post:{0} {1}{2} -{3} {4}" : "Latest blog post:{0} {1}{2} -{3} {4}", Colors.BLUE, post.Title, Colors.NORMAL, Colors.DARKBLUE, SteamDB.GetBlogUrl(post.Slug.Length > 0 ? post.Slug : post.ID.ToString()) ); }