Add flavor text for all buttons

[AdmiralJota]

Before #1174, there was apparently no way to put flavor text for buttons into the DB. Now that there is a way (for values of "now" equal to "after that pull request has been merged"), we need to add it for all buttons that need it.

Is there any way we can set things up so that a non-programmer can do this without having to write bunches of SQL?

[yawetag]

Would it need "bunches of SQL" or a CSV made through [enter your spreadsheet software here]? If a list of the BM could be generated to load into the CSV, it would only take someone working through [spreadsheet software] to type them.

With that, is there a list of the flavor text? If so, it wouldn't be too difficult to use [spreadsheet software] to merge the two lists. With both lists, I could work on it.

As for long-term, though, it would be beneficial for an admin-level user to have the ability to add/edit/remove flavor text through the website.

Andrew Senger asenger@gmail.com

On Sun, Aug 10, 2014 at 1:30 AM, AdmiralJota notifications@github.com wrote:

Before #1174 https://github.com/buttonmen-dev/buttonmen/pull/1174, there was apparently no way to put flavor text for buttons into the DB. Now that there is a way (for values of "now" equal to "after that pull request has been merged"), we need to add it for all buttons that need it.

Is there any way we can set things up so that a non-programmer can do this without having to write bunches of SQL?

— Reply to this email directly or view it on GitHub https://github.com/buttonmen-dev/buttonmen/issues/1176.

[yawetag]

In case it wasn't found before, I did find a site with a lot of flavor text (select Grid+Rules on Viewstyle):

http://www.randomdice.com/games/buttonmen/roster.asp

Andrew Senger asenger@gmail.com

On Sun, Aug 10, 2014 at 1:35 AM, Andrew Senger asenger@gmail.com wrote:

Would it need "bunches of SQL" or a CSV made through [enter your spreadsheet software here]? If a list of the BM could be generated to load into the CSV, it would only take someone working through [spreadsheet software] to type them.

With that, is there a list of the flavor text? If so, it wouldn't be too difficult to use [spreadsheet software] to merge the two lists. With both lists, I could work on it.

As for long-term, though, it would be beneficial for an admin-level user to have the ability to add/edit/remove flavor text through the website.

Andrew Senger asenger@gmail.com

On Sun, Aug 10, 2014 at 1:30 AM, AdmiralJota notifications@github.com wrote:

Before #1174 https://github.com/buttonmen-dev/buttonmen/pull/1174, there was apparently no way to put flavor text for buttons into the DB. Now that there is a way (for values of "now" equal to "after that pull request has been merged"), we need to add it for all buttons that need it.

Is there any way we can set things up so that a non-programmer can do this without having to write bunches of SQL?

— Reply to this email directly or view it on GitHub https://github.com/buttonmen-dev/buttonmen/issues/1176.

[AdmiralJota]

Ultimately we'll need the SQL, but I've talked with the other devs, and it looks like we're happy with the idea of converting the CSV to SQL afterward. I'll try to put up a CSV file of all the button and set names later today for anyone who wants to help work on it.

Also, it's possible that there might be some flavor text available on archive.org's Wayback Machine as well, but I haven't checked yet.

[yawetag]

I'll be on vacation in Arlington, TX, through Saturday, but I'll be glad to take on this.

Andrew Senger asenger@gmail.com

On Mon, Aug 11, 2014 at 12:32 PM, AdmiralJota notifications@github.com wrote:

Ultimately we'll need the SQL, but I've talked with the other devs, and it looks like we're happy with the idea of converting the CSV to SQL afterward. I'll try to put up a CSV file of all the button and set names later today for anyone who wants to help work on it.

Also, it's possible that there might be some flavor text available on archive.org's Wayback Machine as well, but I haven't checked yet.

— Reply to this email directly or view it on GitHub https://github.com/buttonmen-dev/buttonmen/issues/1176#issuecomment-51812860 .

[AdmiralJota]

https://www.dropbox.com/s/aaj4t5txuxyla2u/buttons.csv

Thanks!

[blackshadowshade]

My question here is whether we would rather deal with this like we deal with button images, and just store the descriptions in flat files named appropriately in a subdirectory.

[AdmiralJota]

Is there any advantage to doing that rather than just storing the text in the database?

[blackshadowshade]

I was addressing the non-programmer part of the initial query. I can imagine a non-programmer submitting files directly to the repository, instead of contributing SQL or running a CSV through a conversion script.

[cgolubi1]

I think the flavor text should end up in the database. I'd argue (and have argued on IRC) that people are being way too worried about what will in the end be a very very easy text processing job. At any rate, i definitely don't think we should switch to a design that will be more inefficient and require coding to handle another special case, just to avoid what i believe will be a very very easy text processing job.

Once we have descriptions in any consistent format, it will be easy to get them into SQL. Let's not stress about this, is my opinion.

[yawetag]

Here's a link to the CSV of flavor text from the site I listed earlier. I'll work on more later.

https://drive.google.com/file/d/0B6hzYDeQdxPsWTJNNTR0SHIxWXM/edit?usp=sharing

Andrew Senger asenger@gmail.com

On Thu, Aug 14, 2014 at 7:36 AM, cgolubi1 notifications@github.com wrote:

I think the flavor text should end up in the database. I'd argue (and have argued on IRC) that people are being way too worried about what will in the end be a very very easy text processing job. At any rate, i definitely don't think we should switch to a design that will be more inefficient and require coding to handle another special case, just to avoid what i believe will be a very very easy text processing job.

Once we have descriptions in any consistent format, it will be really easy to get them into SQL. Let's not stress about this, is my opinion.

— Reply to this email directly or view it on GitHub https://github.com/buttonmen-dev/buttonmen/issues/1176#issuecomment-52177491 .

[yawetag]

Meant to say that the CSV I posted was only the buttons I got flavor text for. The non-flavor are stored in a different CSV, which I'll use to work on when I continue the work.

Andrew Senger asenger@gmail.com

On Thu, Aug 14, 2014 at 10:22 AM, Andrew Senger asenger@gmail.com wrote:

Here's a link to the CSV of flavor text from the site I listed earlier. I'll work on more later.

https://drive.google.com/file/d/0B6hzYDeQdxPsWTJNNTR0SHIxWXM/edit?usp=sharing

Andrew Senger asenger@gmail.com

On Thu, Aug 14, 2014 at 7:36 AM, cgolubi1 notifications@github.com wrote:

I think the flavor text should end up in the database. I'd argue (and have argued on IRC) that people are being way too worried about what will in the end be a very very easy text processing job. At any rate, i definitely don't think we should switch to a design that will be more inefficient and require coding to handle another special case, just to avoid what i believe will be a very very easy text processing job.

Once we have descriptions in any consistent format, it will be really easy to get them into SQL. Let's not stress about this, is my opinion.

— Reply to this email directly or view it on GitHub https://github.com/buttonmen-dev/buttonmen/issues/1176#issuecomment-52177491 .

[AdmiralJota]

Thanks!

[ericeslinger]

I could write some sql to put the flavor text in- would you want a separate flavor text update file, or for me to change the data.button.sql file?

[cgolubi1]

Thanks for offering!

The way we normally do this is you make the identical change in two places:

• in data.button.sql for new site loads (e.g. test sites)
• in an updates file whose name begins with the ticket number, so in this case that would be something like: deploy/database/updates/1176_flavor_text.sql, which is intended to be applied to existing installs (like the dev and prod sites).

The two approaches should result in the same output database format/contents (one of the tests i do on pulls with database changes is to verify this).

[ericeslinger]

Yep, I'm working on this. The main goal first is getting my dev environment set up again, I let it get stale.

On Sun, Mar 1, 2015 at 3:26 PM James Ong notifications@github.com wrote:

Assigned #1176 https://github.com/buttonmen-dev/buttonmen/issues/1176 to @ericeslinger https://github.com/ericeslinger.

— Reply to this email directly or view it on GitHub https://github.com/buttonmen-dev/buttonmen/issues/1176#event-244055995.

[ManvilleFog]

My assumption was always that the flavor text for each button would have it's own text file within its own directory in the src/ui directory. I don't think flavor text should be included within the database itself. For one thing - keeping it out of the database removes any potential problems from dealing with special characters.

I would start, perhaps, by creating a src/ui/text/flavor directory, and place within a file called avis.txt containing:

Avis is an expert chainsaw dueler and ice sculptor, and she likes to beat people up.

[cgolubi1]

I'm strongly in favor of putting flavor text in the database. It's structured data (i.e. the flavor text is a structured part of the data about the button). :>) It can't have anything in it that's harder to encode than the chat text we already encode. And there's already a field for it in the database.

Let's not reengineer this one from scratch, folks.

[blackshadowshade]

So, I've just done a query on those buttons in the database for which we still have no flavour text. I've added the list at the end of this post. I figure that someone almost certainly has flavour text for some of these.

Tagging @yawetag in case you have any more time for this.

Zeppo Eiko Wu Lan Carson (promo) Gordo Me am ORK! MAX(p) Apples Green Apple Abe Caine Amara Wintersword Beatnik Turtle Captain Bingo Oni Spite Super Germ Delt Reggie Rold Delt Rage Reggie Rage Rold Rage Billy Shakespeare Drew's Truck Igor(p) Mike Young Kitty Cat Seven Sylvia Branham Social Class Bar Mitzvah Boy Judah Maccabee Bunnies Lab Rat Sydney Angora Nickie Sonia Tamiya Tess Giant Echo Bruno Pappy Synthia The GM The Effster The Fictitious Alan Clark Buck Cass Z-Don Crysis Golo Micro Kolat Ninja Little Sven Socrates Nightmare cheerleader dumb blonde meathead tennis star 1337 h4Xx0r game master emo boy goth chick Tenchi Kagato Ayeka Ryoko Mihoshi Soja's Guardians Kiyone Ryo-Ohki Washu Dr. Clay Sasami Zero Howling Wolf White Tiger Frankie Lola Sly Wildcard Black Jack Craps Shamrock Pai Gow Crypto Crab Crane Dragon Lion Mantis Naga Phoenix Ronin Scorpion Unicorn Mirumoto Kakita Patience Dirgo Flaire Nerni Yeti Daisy Jingjing Mau Spencer Talus Count Repugsive Poly Adam Spam Bush Gore Cthulhu Tsusuko Dracha Ogi Fingle Ngozi Ginzu Gratch Assailer Harbinger Changeling Maya Zeno Phil Dixie Growf Jorgi The James Beast Gripen George Violette Elsie Kasper Montague Neville Thaddeus Buckley FuzzFace John Kovalic Pikathulhu Ulthar Caine Cammy Neko Sailor Man Xylene Chairman Kaga Iron Chef Chinese Iron Chef French Iron Chef Italian Iron Chef Japanese Anger Envy Gluttony Greed Lust Pride Sloth Audrey Cheathem Flint Lizzie Monty Brown Octavia Spooky Death Famine Pestilence War CynCyn Loren Lorrie Maskin Randy Tony BabyBM Bull Butthead Button of Loathing Craptacualr Crosswords Da Pimp Darth Maul Eeyore Evil Robot Luke Ferretboy Holiday Horde O Ninjas Jose Loki Marilyn Monroe Miser Qui-Gon Jinn Skomp The Tick Thor Tilili Trogdor Tyler Durden Count Dracula Dr. Jekyll Frankenstein's Monster Invisible Man Wolfman ABCGi albertel Alljazzedup80 amica Anders antherem anthony Anti-Llama Anvil Aysez barswanian bigevildan Binder birdman BlackOmega bluebec bobby 5150 Bodie bonefish Boot2daHead bowler190 braincraft BrashTech BugRoger CactusJack Caligari Calmon Cassandra CestWhat chase Conspyre Coyote Cristofore Darrin Darthcliff dexx Discordia dmm DocBlue Downen Durak666 dwelsh echopapa ElihuRoot eon Famous Fanaka66 fendrin fernworthy Finngall flesh99 fnord fog Foxlady fxdirect gbrume ghost walker gman97216 GoldenOtter GorgorBey grayhawk GreatWolf grend GripTiger Grivan Grym Gryphon gslamm hairlesswonder hansolav haruspex Heath Heather Hooloovoo Hrodgar icarus ifni IIconfused inundator itachi Jasyeman jeffboyardy Jennie Jenniegirl jgenzano Jordan Jota jrbrown78 juelki kaddar Kaeriol KaijuGamer kaufman kestrel kleric Kurosuke lackey LadyJ Limax Linnea llippen5 luke ii lunatic maga malarson mgatten mlvanbie mneme moekon Moodster moussambani MrWhite Mushu myxozoa nelde NeoVid Nihlathak Noeh NoopMan Notorious Oaktree opedog Pain perlmunkee pgolo Pjack Polonius professorbooty randomlife Raupe RavenBlack relsqui roujin27 Rumbles Sabathia SailorMur sanny santiago SC(The Deuce) schwa seeker Shadowkeeper skapheles Skeeve slamkrypare smallfrogge Snuff spindisc Squiddhartha Stick stoooooooo SyberCat Tasslehoff B TheFool TheMachine Torch Totoro trifecta Trouble Tweedledum TwistedRich TYFTFB UncleMilo Urbanmyth vhoodoo Vysion weirdbal wembley-fraggle Weylan wranklepig wtrollkin Yagharek yakboy zaph Zegota Zomulgustar Zophiel Zotmeister Brie Domino Echo(Fightball) Georgia Gordo(Fightball) Mel Pavel Rocq Skinny Tex Pepper Zal The Japanese Beetle(u) The Flying Squirrel(u) Joe McCarthy Kremlina Max Factor The Frenchman Firebreather Monkeys Ringmaster Stumbling Clowns Space Kubla Pirate Kubla Carrow Nara Perf Glorion The Assassin Wren Ed Ein Faye Jet Spike Vicious Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia(US) Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Virginia Vermont Washington West Virginia Wisconsin Wyoming Arashi Michie Johnny Renee Danny Danielle Scott Macky Magistra Horace Kainar Inez Paris Gideon Spider Painter Regina Damian Rico Seiji Yamaichi Tommy Ace Poison Irene Fuyuko Montgomery Jean-Paul Montague(u) Chantal Largo Ping Piro Darkly Cute Dom Erika Chaka Strotzie Fuma Vox Killer Christmas Tree Magical Witch Critical Miss Phantom Zero Pinball Wizard The Gratch Steve The Fog G Dead Guy Twenty-One Them Bones Shamrock II Lady Luck Pai Gow II Magician

[blackshadowshade]

Some of these were sent over by Skeeve, see #2548.

[TheOrgg]

Is it possible to get a list like that above, but current?

I know Bruno, Las Vegas, MegaTokyo, and L5R (whoof!) flavor texts were found, possibly others.

[blackshadowshade]

Updated list as of today:

Zeppo Eiko Wu Lan Carson (promo) Gordo Me am ORK! MAX (promo) Apples Green Apple Abe Caine Amara Wintersword Beatnik Turtle Captain Bingo Oni Spite Super Germ Delt Reggie Rold Delt Rage Reggie Rage Rold Rage Billy Shakespeare Drew's Truck Igor (promo) Mike Young Kitty Cat Seven Sylvia Branham Social Class Bar Mitzvah Boy Judah Maccabee Bunnies Lab Rat Sydney Angora Nickie Sonia Tamiya Tess Giant Echo Bruno Pappy Synthia The GM The Effster The Fictitious Alan Clark Buck Cass Z-Don Crysis Golo Micro Kolat Ninja Little Sven Socrates Nightmare cheerleader dumb blonde meathead tennis star 1337 h4Xx0r game master emo boy goth chick Howling Wolf White Tiger Mirumoto Kakita Patience Daisy Jingjing Mau Spencer Talus Count Repugsive Poly Adam Spam Bush Gore Cthulhu Tsusuko Dracha Ogi Fingle Ngozi Assailer Harbinger Changeling Maya Zeno Phil Dixie Growf Jorgi The James Beast Gripen George Violette Elsie Kasper Montague Neville Thaddeus Buckley FuzzFace John Kovalic Pikathulhu Ulthar Chairman Kaga Iron Chef Chinese Iron Chef French Iron Chef Italian Iron Chef Japanese Audrey Cheathem Flint Lizzie Monty Brown Octavia Spooky Pestilence War BabyBM Bull Butthead Button of Loathing Craptacualr Crosswords Da Pimp Darth Maul Eeyore Evil Robot Luke Ferretboy Holiday Horde O Ninjas Jose Loki Marilyn Monroe Miser Qui-Gon Jinn Skomp The Tick Thor Tilili Trogdor Tyler Durden Count Dracula Dr. Jekyll Frankenstein's Monster Invisible Man Wolfman ABCGi Alljazzedup80 amica Anders antherem anthony Anti-Llama Aysez barswanian bigevildan Binder birdman BlackOmega bluebec bobby 5150 Bodie bonefish Boot2daHead bowler190 braincraft BrashTech BugRoger CactusJack Caligari Calmon Cassandra CestWhat chase Conspyre Coyote Cristofore Darrin Darthcliff dexx Discordia dmm DocBlue Downen Durak666 dwelsh echopapa ElihuRoot eon Famous Fanaka66 fendrin fernworthy Finngall flesh99 fog Foxlady gbrume ghost walker gman97216 GoldenOtter GorgorBey grayhawk GreatWolf grend Grivan Grym Gryphon gslamm hairlesswonder hansolav haruspex Heath Heather Hooloovoo Hrodgar icarus ifni IIconfused inundator itachi Jasyeman jeffboyardy Jennie Jenniegirl jgenzano Jordan Jota jrbrown78 juelki kaddar Kaeriol KaijuGamer kaufman kleric Kurosuke lackey LadyJ Limax Linnea llippen5 luke ii lunatic maga malarson mgatten mlvanbie mneme moekon Moodster moussambani MrWhite Mushu nelde NeoVid Nihlathak Noeh Notorious Oaktree opedog Pain perlmunkee pgolo Polonius professorbooty randomlife Raupe RavenBlack relsqui roujin27 Rumbles Sabathia SailorMur sanny SC (The Deuce) schwa seeker Shadowkeeper skapheles slamkrypare smallfrogge Snuff spindisc Squiddhartha Stick stoooooooo SyberCat Tasslehoff B TheFool TheMachine Torch Totoro trifecta Trouble Tweedledum TwistedRich TYFTFB UncleMilo Urbanmyth vhoodoo weirdbal wembley-fraggle Weylan wranklepig wtrollkin Yagharek yakboy Zegota Zomulgustar Zophiel Zotmeister Brie Domino Echo (Fightball) Georgia Gordo (Fightball) Mel Pavel Rocq Skinny Tex Pepper Zal The Japanese Beetle (unofficial) The Flying Squirrel (unofficial) Joe McCarthy Kremlina Max Factor The Frenchman Firebreather Monkeys Ringmaster Stumbling Clowns Space Kubla Pirate Kubla Ed Ein Faye Jet Spike Vicious Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia (US) Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Virginia Vermont Washington West Virginia Wisconsin Wyoming Arashi Michie Johnny Renee Danny Danielle Scott Macky Magistra Horace Kainar Inez Paris Gideon Spider Painter Regina Damian Rico Seiji Yamaichi Tommy Ace Poison Irene Fuyuko Montgomery Jean-Paul Montague (Blademasters) Chantal Largo Ping Piro Darkly Cute Dom Erika Chaka Strotzie Fuma Vox Killer Christmas Tree Magical Witch Critical Miss Phantom Zero Pinball Wizard The Grotch Steve The Fog G Dead Guy Twenty-One Them Bones Shamrock II Lady Luck Pai Gow II Magician Mutton Ben Jolene

[TheOrgg]

Bruno's, straight from the designer: https://buttonmen.fandom.com/wiki/Bruno

Megatokyo's: https://github.com/buttonmen-dev/buttonmen/issues/2659

Blademasters 1: https://buttonmen.fandom.com/wiki/Blademasters_Trilogy

Order of Dolls: https://buttonmen.fandom.com/wiki/Order_of_Dolls

Demicon: https://github.com/buttonmen-dev/buttonmen/issues/2779

Cheese Weasel's: "The Cheese Weasel is a clever and cunning rodent, bent on quiet world domination. He likes cheese (duh!), any opportunity for eating cheese, stealing cheese...and beating people up if they attempt to come between him and his cheese."

I'll ask Jeff Boyardee again about the flavor text for ChiCrew. He said there was some, but it looks like I never heard back from him about it.

The rest I haven't discovered the flavor text for, though I'm sure the rest of the Horsemen probably had it.

[TheOrgg]

Got into touch with MrWhite. His flavor text is "Anything you get wrong could kill you. Anything you forget could kill you. When in doubt, assume anything can kill you."

Chatted with Polonius. His text is "Polonius is a chocolate-loving bass player from the far north. He likes sunlight, KelticAngel, and Beating People Up."

[blackshadowshade]

2838 should add all the remaining flavour texts mentioned in this issue.