i'm currently working on an online store. i am selling cards from the
magic the gathering game. there are 64 sets of these cards and its
taking me forever to make that sql files for database upload. i was
wondering if there is someway to upload the text file and pull
sections of a line from the text file and create the sql files.
the text file looks like this:
Card Name: Auratouched Mage
Cost: 5W
Type: Creature Human Wizard
Pow/Tgh: 3/3
Rules Text: When Auratouched Mage comes into play, search your
library for an Aura card that could enchant it. If
Auratouched Mage is still in play, attach that Aura
to it. Otherwise, reveal the Aura card and put it into
your hand. Then shuffle your library.
Set/Rarity: Ravnica: City of Guilds uncommon
im needing to get the card name, and rules text and insert them into this:
INSERT INTO products VALUES (1, 0, 'single', 'card87952.jpg',
'0.0000', '2008-01-12 13:13:50', NULL, NULL, '0.00', 1,0,0,0);
INSERT INTO products_description VALUES (1, 1, 'Auratouched Mage',
'When Auratouched Mage comes into play, search your library for an
Aura card that could enchant it. If Auratouched Mage is still in play,
attach that Aura to it. Otherwise, reveal the Aura card and put it
into your hand. Then shuffle your library.', '', 0);
INSERT INTO products_description VALUES (1, 2, '','','',0);
INSERT INTO products_description VALUES (1, 3, '','','',0);
INSERT INTO products_to_categories VALUES (1, 2);
with card87952 being the cards name.
anyone got any ideas that could help me out?
