summaryrefslogtreecommitdiff
path: root/mtg-pdf.php
diff options
context:
space:
mode:
Diffstat (limited to 'mtg-pdf.php')
-rw-r--r--mtg-pdf.php8
1 files changed, 4 insertions, 4 deletions
diff --git a/mtg-pdf.php b/mtg-pdf.php
index 068c91e..55b8112 100644
--- a/mtg-pdf.php
+++ b/mtg-pdf.php
@@ -41,10 +41,10 @@ foreach ($cards as $card) {
SELECT cardIdentifiers.scryfallId, cards.layout
FROM cardIdentifiers
JOIN cards ON cardIdentifiers.uuid=cards.uuid
- WHERE (cards.name=:name OR cards.faceName=:name) AND cards.setCode=:setCode AND cards.number=:number
+ WHERE cards.setCode=:setCode AND cards.number=:number
SQL;
$statement = $db->prepare($query);
- $statement->execute(['name' => $card['name'], 'setCode' => $card['set'], 'number' => $card['number']]);
+ $statement->execute(['setCode' => $card['set'], 'number' => $card['number']]);
$result = $statement->fetch();
$id = $result['scryfallId'] ?? '';
@@ -53,10 +53,10 @@ foreach ($cards as $card) {
SELECT tokenIdentifiers.scryfallId, tokens.layout
FROM tokenIdentifiers
JOIN tokens ON tokenIdentifiers.uuid=tokens.uuid
- WHERE (tokens.name=:name OR tokens.faceName=:name) AND tokens.setCode=:setCode AND tokens.number=:number
+ WHERE tokens.setCode=:setCode AND tokens.number=:number
SQL;
$statement = $db->prepare($query);
- $statement->execute(['name' => $card['name'], 'setCode' => $card['set'], 'number' => $card['number']]);
+ $statement->execute(['setCode' => $card['set'], 'number' => $card['number']]);
$result = $statement->fetch();
$id = $result['scryfallId'] ?? '';