Magic Album - Database Errors, Missed Cards and Pictures

[Goblin Hero]

Can you work with MS Access databases?

[chreschi]

I do have MS Access 2010, yet if I can work with it remains to be seen... It's been some years
Anyhow, I'm willing to try if you can provide a template.
Cheers
-Chris

[Goblin Hero]

Attached is a sample MS Access Database. Your should create new records in the "Objects" table. If it will be needed to create records in the other tables - please note this separately.
I need all fields filled! Partially filled records will be rejected. It means you have to have a real card or good scan/picture with all the elements readable.
Object - object type (1 - card, 2 - token, 3 - plane or vanguard)
CardID - corresponding ID from Oracle or Tokens or Nontraditional table
SetId - corresponding ID from Sets table
LangId - corresponding ID from Lang table
Version - object version
CopyrID - corresponding ID from Copyright table
SetIcon - card icon
Comment - commentary, must be filled for all promo cards
BorderColor - (B)lack, (W)hite, (S)ilver
If you have questions - ask them here.

[chreschi]

All is going well so far - except for one thing: there are some promo icons that I cannot fill in because I don't know the code or it is probably a new one. For example: New "Dengeki Maoh" Comic promo cards with the "additional" symbol (besides the normal expansion symbol), as this one for example: http://www.cardgamesmarket.com/ressources_1f3601e6/images_0eb46de1/jeux_5b6c9d0c/mtg/produits/cartes/promo/dengekiMaoh/comicsBook/grand/1.png. One is from SOM, the other from M12, btw, each one with the additional symbol to the normal expansion symbol.
Or cases in which the promo symbol replaces the expansion symbol because its new artwork, e.g.. the IDW comic promo symbol as seen on this card: http://client-cdn.crystalcommerce.com/photo/ccghouse/file/ec6c4adab88f25a50a05150595b6e640/large/ComicPromoCard.jpg
Finally, what's the code for Judge Gift Cards nowadays (with the stars): Also FSTAR?

If you want to fill this in yourself, no problem, i just thought I'd ask.

Best regards
Chris

[chreschi]

Btw: same questions as above apply to the new pre- and release promos, Game Day promos etc.

[Goblin Hero]

Look into Graphics/Sets folder. Set icons are stored in this folder. MA will try to open the file with the name from "SetIcon" field. Some icons may me missed - I will look into it myself.

[Goblin Hero]

What additional symbol do you mean? The one on the art? Ignore it.
I don't have IDW icon - need a 1200dpi card scan or high res picture to vectorize. Can you help?

[chreschi]

Here's the datafile. I've just added the new entries in the "Objects" table, as you told me to - starting from 11852 to 11879. Please note the following things:
1. I've added a new entry in the "Tokens" Table as well (#111, Angel//Demon Token from the Avacyn Restored prerelease Helvault event).
2. I've left the "Icon" field for IDW promo cards empty, as there is no icon coded yet. These are entries 11852-11855.
3. I've coded the "Object" field for entries 11864-11868 as type "3" (plane or vanguard) as they are Oversized. Please correct if necessary.
4. I've coded cards that have both foiled AND nonfoil versions in the field "Foil" as "Y" - hope that's right.

Finally, I've added a scan of one of the IDW cards. I've only got a crappy scanner but I hope this helps anyway.

Best regards
Chris / chreschi

[Goblin Hero]

Awesome work. Will be added. Ticket is closed, but if you want to contribute more promos - reopen this ticket.
P.S. Code for oversized is 5:

Code: Select all

#define OBJTYPE_CARD   1
#define OBJTYPE_TOKEN  2
#define OBJTYPE_NTR    3
#define OBJTYPE_INSERT 4
#define OBJTYPE_OVERSZ 5