It is currently 07 Jul 2021, 22:07
   
Text Size

Magic Album - Database Errors, Missed Cards and Pictures

New Promos AND offer to hack in Different Oversized Cards (fix completed)

 

I have some more promo cards to add. While I could do this the same way as last time, I would like to enter some Oversized Promo Cards into the database as well. But I need to know if there are already some existing codes for them:
1. Box-topper cards (I'd suggest to give them a new code / abbreviation, if they do not exist yet)
2. Oversized MPR cards (as in Bug tracker #104, added by you). There, we could use the MPR abbreviation and add the Oversized Flag, what do you think?
Best regards
chreschi

Comments

Posted by chreschi » 29 Aug 2012, 07:47

Well, my spare time / vacation is up, so I won't have time to do this at the moment. Still, an answer would be appreciated (if anything, close the ticket, pls).
Regards
-chreschi

Posted by ohforf » 03 Mar 2013, 01:00

It can take a while but I can add database entries for these cards if you haven't already Goblin Hero.

I just have a couple of questions first:

1 - Should MPR OVS be grouped as a special set or will they be part of their respective sets? I can maybe use the comments field to tell them apart (see here).

2 - This one is possibly too nitpicky but what's the best syntax for inputting multi-paragraph text in the Text and Text(Oracle) fields of the database? i.e. how does MA distinguish between single sentences and paragraphs.

Cheers,
Ohforf
Last edited by ohforf on 09 Mar 2013, 23:26, edited 2 times in total.
Reason: MPR set already exists in the database

Posted by ohforf » 09 Mar 2013, 23:29

Added MPR OVS in its proper ticket.

Let me know if the format is okay and I will start doing the Box-topper cards.


Cheers,
Ohforf

Posted by Goblin Hero » 12 Mar 2013, 07:50

Please, use the attached template. You can write multiline text in Excel too. Just press Alt+Enter when you edit the cell.
Attachments
ObjectPart.xls
(17 KiB) Downloaded 155 times

Posted by ohforf » 13 Mar 2013, 02:01

Thanks for the template!
I almost finished adding the cards.

I just have a few questions before I can give you the data:

1 - For the 8ED box toppers (standard and promos) the backs are all different and represent the card's original set. So I am using the set's name for the back.
However, for the 9ED ones, the backs have the card's name and are numbered (more info here).
What should I put as their name?

2 - The 8ED promos come from different places: conventions and championships. So I put them as Convention, Grand Prix and Champs promos.
Is that okay or should I put them together with the other 8ED ovs cards?

3 - What are the CopyrIDs for "™ & © 1993-2003 Wizards of the Coast, Inc." and "™ & © 1993-2005 Wizards of the Coast, Inc."?

Ohforf

Posted by Goblin Hero » 13 Mar 2013, 05:34

1. Whatever you want. I'll think about it and fix if needed.
2. Another thing to think of. May be it's better to create a special set for all box toppers?
3. 8 and 10.

Posted by ohforf » 14 Mar 2013, 00:05

Here's the complete box topper info for 8th and 9th editions. Each is in a different sheet.

For the regular ones, I gave the SetID of their edition. The promos have different IDs.
I think it makes sense for the promos to be given their special set, but that's just my two cents on the issue :)

I named the backs of the 9th edition as "Back X", where X is their special collector's number (also in the CollNum field). Not very appealing I know...maybe you'll come up with a better name.

Let me know if anything is missing/wrong.


Cheers,
Ohforf
Attachments
box_toppers.xls
(55 KiB) Downloaded 124 times

Posted by Goblin Hero » 19 Mar 2013, 16:53

TY, added!

Ticket details

  • Ticket ID: 251
  • Project: Magic Album
  • Status: Fix completed
  • Component: (unknown)
  • Project version: (unknown)
  • Priority: Normal
  • Severity: Normal
  • Assigned to: Goblin Hero
  • Reported by: chreschi
  • Reporter's tickets: List all tickets
  • Reported on: 14 Jul 2012, 22:13
  • Last visited by Goblin Hero » 29 Jul 2014, 05:55.
 

Login Form