diff options
| -rw-r--r-- | mtg-pdf.php | 8 |
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'] ?? ''; |