There are a few changes I've thought off, I'd like the average deck price to be similar to a preconstructed deck and the number of cards by rarity in the format to be proportional to the number of cards by rarity in a set which is approximately 101 commons, 60 uncommons, 53 rares, and 15 mythic rares.
(f:legacy ((usd<=0.20 r:common) or (usd<=0.25 r:uncommon) or (usd<=0.5 (r:rare or r:mythic)))) = 13750
(f:legacy ((eur<=0.20 r:common) or (eur<=0.25 r:uncommon) or (eur<=0.5 (r:rare or r:mythic))) ((tix<=0.05 r:common) or (tix<=0.1 r:uncommon) or (tix<=0.2 r:rare) or (tix<=0.4 r:mythic))) = 12430
Instead of working with a database work with the json from mtgjson that way I don't have to worry about downloading all the database every time a new set comes out which is the thing that last the most.
Update prices only every two set releases because I don't like how much standard rotates now.
I've added the option to search by rarity I need to add search by type, contained words, etc.
It seems Magic Card Market has an api here to see the price for all the magic cards in CSV. Maybe I can get the prices from there instead of scraping the website. I have to see how to import the price from the CSV to the database.
I can't figure out how to do the advanced search yet. It get's too complicated as I add search features. I would need an example of an advanced search to see how to structure the code so it doesn't get out of hand.
I also saw two cards I really liked and I would like to do a deck around them: Phantom Centaur and Centaur Glade. With some mana ramp and Ferocity it would make a nice synergy. Here's a deck idea although I don't like the fogs.
The only thing that has to be done is add a new field when saving the database with the image url from wizards and then show that image in the web when hoving over the name. I'll do it as soon as I have some time. Also I'm planning to add the possibility to search in multiple languages and show the card images in the language in which the search was performed or if that's too difficult just have an option to select in which language should the images be displayed. The images from different languages can be gotten at magiccards.info.
Heirloom is a format that bases its card legality on the Legacy format and on the price of the cards at the 'day of rotation'. The list of legal cards is static, which means all cards stay legal or illegal until next 'rotation', that is approximately 2-3 weeks after each regular set release.
The legality range is as follows:
Mythic: up to 0.50
Rare: up to 0.40
Uncommon: up to 0.25
Common: up to 0.13
Heirloom is commonly an mtgo format. But since the price difference is too great I want to promote the format for paper magic with a different legality list. Here is a more detailed explanation of the format.
The highlights of the format:
It makes the game more accessible with an average deck price of $20.
After you take away the best magic cards you're left with a lot more cards that are pretty good, and now playable.
When compared to Pauper it feels more like normal magic.
I've uploaded the web because it's already working pretty well but know I've seen that 000webhosting doesn't support python so I'll have to rewrite the code for php or look for another host. I consider this version 1.0 even if I haven't uploaded it yet.
I've added:
Cache downloaded webs to make things quicker while testing.
I have fixed the price checking for double sided cards.
I'm not really concerned with the banning list changing every month because the format is not going to be so popular. It's just a casual format that keeps the game more balanced between friends that would other way invest a very different amount of money in their cards. It also keeps the Rare and Uncommon cards so the format is more like normal magic than pauper.
I've changed the gathererScraper to get this information from the card: name, rarity, cmc, color, multiverseid, text, artist, mkm_value, format, expansion.
TODO list
Cache downloaded webs to make things quicker while testing.
I have to fix double sided cards.
Cards without cmc are giving problems.
I have to get the hole text because right now I only get some.
I have to get: id, flavor, tcg_value, mtgo_trader_value, cost, type
Sorry I didn't explained the format correctly. The Heirloom format has legal cards based on card price. All cards that are common and $0.05 or cheaper are legal, uncommon $0.10, Rare $0.20, Mythic $1.00 As long as one version is cheap enough that makes it legal (Promo and premade deck cards are evaluated based on their original highest rarity from a legal set). Legality of cards shifts at the beginning of each month to last for one month.
With those prices average deck price would be around $5. So having a single price limit for all cards as am doing it right now, card price limit would be $5/37 ~= $0.14. But I've considered an average deck price of $15 which gives a price limit of $15/37 ~= $0.4. I would like opinions about which should be the price limit. And if it's better to have one for each rarity or a single one for all of them?
Can you give me some reference to look for an extensive mysql query system for php (some open source web with advanced search maybe). I want to do something like magiccards.info where you can select color, card type, subtype etc.
I would need help selecting an API which allows trend price checking.
Hello, I'm doing a website like this one and I would need some help. I'm going to do it simpler at first so it's easier to program. The format will have legacy cards under 0.3 as legal. So the maximum deck price would be around 10.
The first thing that has to be done is a database saving all the legal cards. For that I have done a python script that loops through the gatherer pages. Once I have the cardName I go to a different website and scrape it again for the price. If the card already exists the price is updated. This script should be run at the beginning of each month to update the legal cards for the format. That can be done with a cronjob in the server.
Next I've thought about doing the web in php and queriying the database for single cards, multiple cards in a copy paste way and in a file browsing way for .txt files. I haven't got into this yet.
Any help is appreciated. I would like suggestions as to how accelerate the updating of the prices as right now it would take around 8 hours to update the 17k cards that are in legacy. This only has to be done once a month but still I think it could be improved.
(f:legacy ((usd<=0.20 r:common) or (usd<=0.25 r:uncommon) or (usd<=0.5 (r:rare or r:mythic)))) = 13750
(f:legacy ((eur<=0.20 r:common) or (eur<=0.25 r:uncommon) or (eur<=0.5 (r:rare or r:mythic))) ((tix<=0.05 r:common) or (tix<=0.1 r:uncommon) or (tix<=0.2 r:rare) or (tix<=0.4 r:mythic))) = 12430
Instead of working with a database work with the json from mtgjson that way I don't have to worry about downloading all the database every time a new set comes out which is the thing that last the most.
Update prices only every two set releases because I don't like how much standard rotates now.
I've added the option to search by rarity I need to add search by type, contained words, etc.
I also saw two cards I really liked and I would like to do a deck around them: Phantom Centaur and Centaur Glade. With some mana ramp and Ferocity it would make a nice synergy. Here's a deck idea although I don't like the fogs.
I would like to see some deck ideas.
4 Bloodline Shaman
4 Elvish Mystic
4 Elvish Vanguard
4 Elvish Visionary
4 Llanowar Elves
4 Sylvan Messenger
4 Taunting Elf
4 Timberwatch Elf
4 Voice of the Woods
20 Forest
Sorceries
4 Lead the Stampede
4 Gaea's Blessing
4 Nullmage Shepherd
3 Reclamation Sage
4 Tormod's Crypt
4 Herald of Anafenza
4 Precinct Captain
Others
4 Gather the Townsfolk
4 Intangible Virtue
4 Midnight Haunting
4 Path of Bravery
4 Raise the Alarm
4 Triplicate Spirits
24 Plains
4 Karma
4 Sanctimony
1 Storm Crow
Lands
7 Island
6 Plains
4 Sejiri Refuge
4 Tranquil Cove
4 Urza's Factory
Instant
4 Aetherspouts
1 Blue Sun's Zenith
4 Compulsive Research
4 Devouring Light
4 Dismiss
4 Dissolve
4 Mana Leak
1 White Sun's Zenith
3 Jace's Ingenuity
4 End Hostilities
Artifact
1 Elixir of Immortality
4 Karma
4 Last Breath
4 Sanctimony
Heirloom is a format that bases its card legality on the Legacy format and on the price of the cards at the 'day of rotation'. The list of legal cards is static, which means all cards stay legal or illegal until next 'rotation', that is approximately 2-3 weeks after each regular set release.
The legality range is as follows:
Mythic: up to 0.50
Rare: up to 0.40
Uncommon: up to 0.25
Common: up to 0.13
Heirloom is commonly an mtgo format. But since the price difference is too great I want to promote the format for paper magic with a different legality list. Here is a more detailed explanation of the format.
The highlights of the format:
I've added:
TODO list:
I've changed the gathererScraper to get this information from the card: name, rarity, cmc, color, multiverseid, text, artist, mkm_value, format, expansion.
TODO list
With those prices average deck price would be around $5. So having a single price limit for all cards as am doing it right now, card price limit would be $5/37 ~= $0.14. But I've considered an average deck price of $15 which gives a price limit of $15/37 ~= $0.4. I would like opinions about which should be the price limit. And if it's better to have one for each rarity or a single one for all of them?
Can you give me some reference to look for an extensive mysql query system for php (some open source web with advanced search maybe). I want to do something like magiccards.info where you can select color, card type, subtype etc.
I would need help selecting an API which allows trend price checking.
Hello, I'm doing a website like this one and I would need some help. I'm going to do it simpler at first so it's easier to program. The format will have legacy cards under 0.3 as legal. So the maximum deck price would be around 10.
The first thing that has to be done is a database saving all the legal cards. For that I have done a python script that loops through the gatherer pages. Once I have the cardName I go to a different website and scrape it again for the price. If the card already exists the price is updated. This script should be run at the beginning of each month to update the legal cards for the format. That can be done with a cronjob in the server.
Next I've thought about doing the web in php and queriying the database for single cards, multiple cards in a copy paste way and in a file browsing way for .txt files. I haven't got into this yet.
Any help is appreciated. I would like suggestions as to how accelerate the updating of the prices as right now it would take around 8 hours to update the 17k cards that are in legacy. This only has to be done once a month but still I think it could be improved.
The Heirloom format is described here:
MTG Heirloom Legality Checker