jamuraa
commented
12 years ago There's an argument for converted cost being in the database because it is non-trivial to calculate it, especially for big sets of cards. Colors are definitely easy to calculate from the mana cost though.
I'm not sure about having all of these, rather than using a service which would provide them. It seems like there should be a API out there that we can use.
Michael Janssen --- Jamuraa --- jamuraa@base0.net
On Fri, Feb 17, 2012 at 12:50 PM, Dabil reply@reply.github.com wrote:
Need to add fields to contain all of the card data. In this way the database can be used to replace the deckbox functions that show the card pic in a little pop-up box when you hover over the card name. Also will be able to develop a deck editor on the site. That way it makes it easy for people to build decks for alt formats and other crazy formats we may want to run.
Thinking the new structure should be:
name: varchar(40) // name of card cardset: varchar(40) // card set card is from type: varchar(40) // type of card: Instant, Sorcery, Land, Creature, etc. pow/Tgh: varchar(40) // Power and toughness of creatures cost: varchar(40) // Mana cost of card. rarity:varchar(40) // lists rarity of cards common, uncommon, rare, mythic. rules:varchar(200) // Contains card text. ex. T: Draw a card and discard a card. flavor: varchar(200) // Contains flavor text of card ID:bigint(20) unsigned // Card ID: image:varchar(40) // Card Image file name, card images should be in a directory inside of Gatherling
Do away with fields:
isw, isr, isg, isu, isb, isp, convertedcost: all these fields can be calculated from the cost field.
Reply to this email directly or view it on GitHub: https://github.com/jamuraa/gatherling/issues/41
Dabil
Need to add fields to contain all of the card data. In this way the database can be used to replace the deckbox functions that show the card pic in a little pop-up box when you hover over the card name. Also will be able to develop a deck editor on the site. That way it makes it easy for people to build decks for alt formats and other crazy formats we may want to run.
Thinking the new structure should be:
name: varchar(40) // name of card cardset: varchar(40) // card set card is from type: varchar(40) // type of card: Instant, Sorcery, Land, Creature, etc. pow/Tgh: varchar(40) // Power and toughness of creatures
cost: varchar(40) // Mana cost of card. rarity:varchar(40) // lists rarity of cards common, uncommon, rare, mythic. rules:varchar(200) // Contains card text. ex. T: Draw a card and discard a card. flavor: varchar(200) // Contains flavor text of card ID:bigint(20) unsigned // Card ID: image:varchar(40) // Card Image file name, card images should be in a directory inside of Gatherling
Do away with fields:
isw, isr, isg, isu, isb, isp, convertedcost: all these fields can be calculated from the cost field.