On [login to view URL] we have a web based MTGO tournament program called Gatherling. We use this program to keep track of our tournaments and to enforce the rules for deck creation in different formats.
The program uses a card database to check the validity of a player's deck for each format. One of the problems we are having is getting cards in the database. Currently we are manually entering the cards. We would like to add a feature to the Gatherling software that we could use to load the cards into the database from the Wizards of the Coast Gatherer database in an automated way.
We want to load cards a "set" at a time from the Gatherer database which is located:
[login to view URL]
If you go to the above link you will see on the right hand side an option to filter card sets. And there is a list of card sets available. If you click a set (such as Dark Ascension), select sort order: rarity, and finally select output format: text spoiler, and then hit search it will bring up a complete list of all the cards in the set in order from Common, Uncommon, Rare, and Mythic Rare along with all the text we would like to import into Gatherling.
If you do the same search again, but this time select visual spoiler, it will bring up a list of all the card images for each card. Those two searches will provide us with all the data we would like to import (or have an option to import).
What we would like you to create is:
On our Gatherling Admin CP page I would like to add a card import link. It will link to a program that you write (in php hopefully) that will allow us to import complete card sets of our choice from Gatherer. When you click the link it will open another page that will allow you to set options for what exactly you would like to import. (So we want this program to run seamlessly in a browser from our Gatherling program)
A list of the options are:
Card Set Name: In it's simple form this would be a text box that will allow you to enter the name of a card set we would like to import. The cadilac version would scan our database for the card sets we currently have installed and then compare that to what is available in Gatherer, and then create a drop down list of available card sets to download. Maybe one option would be to import all missing sets.
Release Date: Would be the date that the card set was released. We can add this date manually if it can't be taken from information in Gatherer. (I do not see anywhere that information is listed in the Gatherer database.)
Type: This is the type of card set. The available choices should be in a drop box. The current options in our database for this are core, block, extra.
And then the next series would be simple check boxes that allow us to set which parts of the data we want to import. Since this software is used in multiple websites who don't all have the same import needs. We want people to be able to customize what they are importing. The choices to import are:
Cost, Type, Power/Toughness, Rules Text, Card Pic.
Rarity: This option is the import level of the cards in order. It would be a drop-down menu with options: Common, Uncommon, Rare, Mythic. If someone selects Common, then only Commons are imported. If someone selects Uncommon, then both Common and Uncommons are imported, if someone selects Rare then all Commons, Uncommons, and Rares are imported. And finally if someone selects Mythic. Then ALL cards are imported from the set.
Once the user selects his import choices They are imported as:
Name: Just enter the text from the spoiler as it appears.
Cost: Just enter the text from the spoiler as it appears. (ex: U or 2W)
Type: Just import the text from the spoiler as it appears. (ex. Creature - Human Druid)
Power: This field does not currently exist in our database so would need created. Should be a numeric value equal to the A part of the (A/B) format.
Toughness: This field does not currently exist in our database and needs created. Should
Hello,
10+ years exp full time freelancer here, can deliver a quality & professional work in the timeframe posted. Please contact me via PM for any question, Thanks.