forked from DiamondNether90/discord-bot
104 lines
9.6 KiB
Python
104 lines
9.6 KiB
Python
import sqlite3
|
||
|
||
cards = [
|
||
("Blank", "When this card is discarded (not destroyed), add Antimatter to 1 joker **(Persistent)**", "Joker", "Base Game"),
|
||
("Blueprint", "If the card immediately below this card is a joker, copy all of its effects", "Joker", "Base Game"),
|
||
("Chaos the Clown", "Allows the shop to be shuffled and redrawn 1 additional time (before making your selection)", "Joker", "Base Game"),
|
||
("Cloud Nine", "If your played hand contains a 9, draw a card from the shop deck (must have room)", "Joker", "Base Game"),
|
||
("DNA", "If your played hand has exactly 1 card, add a red seal to your played card (after scoring)", "Joker", "Base Game"),
|
||
("Encrypt", "Apply the effects of lagging to yourself", "Joker", "Base Game"),
|
||
("Four Fingers", "Flushes and straights can be made with 4 cards", "Joker", "Base Game"),
|
||
("Ghost", "When another player uses a spectral card, take it instead of destroying it (must have room)", "Joker", "Base Game"),
|
||
("Half Joker", "Increase the rank of played Poker hand by 3 if it contains 3 or less cards", "Joker", "Base Game"),
|
||
("Juggler", "+1 hand size", "Joker", "Base Game"),
|
||
("Madness", "At the start of every playing round, destroy a random joker in play (cannot select Eternal jokers)", "Joker", "Base Game"),
|
||
("Mime", "When another player discards playing cards, force 1 random discarded card to be kept in their hand", "Joker", "Base Game"),
|
||
("Oops! All Sixes", "When some of your card(s) are randomly selected, instead choose which card(s) are selected", "Joker", "Base Game"),
|
||
("Perkeo", "Add a red seal to a random consumable at the start of every round (cannot select a consumable with a red seal)", "Joker", "Base Game"),
|
||
("Recycle", "At the start of every playing round, shuffle and draw 1 card from the discarded shop cards (must have room)", "Joker", "Base Game"),
|
||
("Riff Raff", "At the start of every playing round, draw the top most joker from the shop deck, then shuffle the shop deck (must have room)", "Joker", "Base Game"),
|
||
("Shortcut", "Allows straights to be made with gaps of 1 rank (e.g. 10 8 6 5 3)", "Joker", "Base Game"),
|
||
("Sixth Sense", "If your played hand contains a 6, destroy a 6 from your played hand and draw the most recently discarded consumable (must have room)", "Joker", "Base Game"),
|
||
("Smeared Joker", "Hearts & Diamonds; Spades & Clubs are considered the same suit", "Joker", "Base Game"),
|
||
("Stuntman", "Increase the rank of played Poker hand by 3; -2 hand size", "Joker", "Base Game"),
|
||
("Thief", "At the end of every playing round, you may steal 1 playing card from another player’s played hand and add it to your deck", "Joker", "Base Game"),
|
||
("Wormhole", "All other player’s planet cards have no effect", "Joker", "Base Game"),
|
||
("Mercury", "Increase the rank of Pair by 3", "Planet", "Base Game"),
|
||
("Venus", "Increase the rank of Three of a Kind by 3", "Planet", "Base Game"),
|
||
("Earth", "Increase the rank of Full House by 2", "Planet", "Base Game"),
|
||
("Mars", "Increase the rank of Four of a Kind by 2", "Planet", "Base Game"),
|
||
("Jupiter", "Increase the rank of Flush by 2", "Planet", "Base Game"),
|
||
("Saturn", "Increase the rank of Straight by 2", "Planet", "Base Game"),
|
||
("Uranus", "Increase the rank of Two Pair by 3", "Planet", "Base Game"),
|
||
("Neptune", "Increase the rank of Straight Flush by 2 (Includes Royal Flush)", "Planet", "Base Game"),
|
||
("Pluto", "Increase the rank of High Card by 4", "Planet", "Base Game"),
|
||
("Abandoned", "Destroy another player’s played cards (they still score for this round)", "Tarot", "Base Game"),
|
||
("Death", "Convert 1 card in your hand into another card in your hand; destroy the converted card after this hand", "Tarot", "Base Game"),
|
||
("Erratic", "Swap your hand with another player’s hand at the start of a playing round; keep the swapped cards after this round", "Tarot", "Base Game"),
|
||
("Fool", "Copy the effects of the last used consumable", "Tarot", "Base Game"),
|
||
("Hanged Man", "Destroy up to 3 cards from your hand; do not draw new cards until your next discard", "Tarot", "Base Game"),
|
||
("Jimbo", "Add a Joker playing card to your deck, then shuffle your deck", "Tarot", "Base Game"),
|
||
("Judgement", "Swap 1 random joker owned by you with 1 random joker owned by a random other player", "Tarot", "Base Game"),
|
||
("Lovers", "Convert 2 cards into any suit for this hand", "Tarot", "Base Game"),
|
||
("Moon", "Convert up to 3 cards into clubs for this hand", "Tarot", "Base Game"),
|
||
("Star", "Convert up to 3 cards into diamonds for this hand", "Tarot", "Base Game"),
|
||
("Strength", "Increase the rank of up to 3 cards by 1 for this hand (Aces become Twos)", "Tarot", "Base Game"),
|
||
("Sun", "Convert up to 3 cards into hearts for this hand", "Tarot", "Base Game"),
|
||
("The Wheel", "Shuffle your hand into your deck, then draw a new hand", "Tarot", "Base Game"),
|
||
("Tower", "Convert 1 card into a stone card for this hand", "Tarot", "Base Game"),
|
||
("World", "Convert up to 3 cards into spades for this hand", "Tarot", "Base Game"),
|
||
("Ankh", "Add a red seal to a random joker, destroy all other jokers", "Spectral", "Base Game"),
|
||
("Cryptid", "Create 2 copies of 1 held card for this hand", "Spectral", "Base Game"),
|
||
("Deja Vu", "Add a red seal to 1 held playing card", "Spectral", "Base Game"),
|
||
("Ectoplasm", "Destroy a random joker not owned by you; -1 hand size permanently after use", "Spectral", "Base Game"),
|
||
("Mr. Bones", "+1 Life; -1 hand size permanently after use", "Spectral", "Base Game"),
|
||
("Trance", "Increase the rank of this Poker hand by 2", "Spectral", "Base Game"),
|
||
("Antimatter", "This card and the card it is attached to does not take up a joker/consumable slot", None, "Base Game"),
|
||
|
||
("Brainstorm", "Copy the effects of the top-most joker of any player", "Joker", "Eternal Destruction"),
|
||
("Burnt Joker", "Increase the rank of played Poker hand by 3 if your played Poker hand was discarded prior this round", "Joker", "Eternal Destruction"),
|
||
("Grave Digger", "Allows 1 discarded card to be used in your played hand", "Joker", "Eternal Destruction"),
|
||
("Idol", "Increase the rank of played Poker hand by 2 for each card played by other players that was also played by you", "Joker", "Eternal Destruction"),
|
||
("Invisible Joker", "When this card is discarded (not destroyed), add a red seal to a random joker **(Persistent)**", "Joker", "Eternal Destruction"),
|
||
("Joker Stencil", "Increase the rank of played Poker hand by 1 for each unused joker/consumable slot (includes this card)", "Joker", "Eternal Destruction"),
|
||
("Observatory", "Increase the rank of played Poker hand by 2 if you also have its respective planet card", "Joker", "Eternal Destruction"),
|
||
("Overstock", "Allows the shop to be shuffled and redrawn once (before making your selection) for each shop card discarded in this shop round", "Joker", "Eternal Destruction"),
|
||
("Persistence", "All shop cards held by all players become persistent", "Joker", "Eternal Destruction"),
|
||
("Splash", "All played cards are always ordered from highest to lowest rank when scoring", "Joker", "Eternal Destruction"),
|
||
("Wasteful", "+1 discard", "Joker", "Eternal Destruction"),
|
||
("Planet X", "Increase the rank of Five of a Kind by 2", "Planet", "Eternal Destruction"),
|
||
("Ceres", "Increase the rank of Flush House by 2", "Planet", "Eternal Destruction"),
|
||
("Chariot", "Increase the rank of played Poker hand by 1 for every 2 cards remaining in your hand (max. +4)", "Tarot", "Eternal Destruction"),
|
||
("High Priestess", "Draw the next Planet card from the shop deck (must have room)", "Tarot", "Eternal Destruction"),
|
||
("Refresh", "Remove all seals from 1 player’s jokers (can select yourself)", "Tarot", "Eternal Destruction"),
|
||
("Temperance", "Shuffle your shop cards into the shop deck (excluding jokers with an eternal seal), then draw cards equal to the amount removed (or until there is no room)", "Tarot", "Eternal Destruction"),
|
||
("The Emperor", "Draw the next Tarot card from the shop deck (must have room)", "Tarot", "Eternal Destruction"),
|
||
("Everlasting", "Add an eternal seal to any joker held by any player", "Spectral", "Eternal Destruction"),
|
||
("Hesitation", "Stop a random consumable held by any player from being used until the next shop", "Spectral", "Eternal Destruction"),
|
||
("Immolate", "Destroy all playing cards in your hand, then immediately draw a new hand", "Spectral", "Eternal Destruction"),
|
||
("Incantation", "Destroy up to 4 cards from your hand, then draw 4 more", "Spectral", "Eternal Destruction"),
|
||
("Ouija", "Shuffle your hand and discards back into your deck, then draw a new hand. All cards drawn have the rank of the first drawn card for this hand; -1 hand size permanently after use", "Spectral", "Eternal Destruction"),
|
||
("Talisman", "Allows 2 cards to be taken from this shop", "Spectral", "Eternal Destruction"),
|
||
("Unleash", "Shuffle all destroyed cards into the shop deck", "Spectral", "Eternal Destruction"),
|
||
("Wraith", "Draw the next 3 joker cards from the shop deck, then choose 1 (must have room); do not choose a card from the next shop.", "Spectral", "Eternal Destruction"),
|
||
]
|
||
|
||
with sqlite3.connect("cards.db") as conn:
|
||
cur = conn.cursor()
|
||
|
||
cur.execute("DROP TABLE IF EXISTS cards")
|
||
|
||
cur.execute("""
|
||
CREATE TABLE IF NOT EXISTS cards (
|
||
id INTEGER PRIMARY KEY,
|
||
name TEXT UNIQUE NOT NULL,
|
||
description TEXT,
|
||
type TEXT,
|
||
dlc_name TEXT
|
||
)
|
||
""")
|
||
|
||
for card in cards:
|
||
cur.execute("INSERT INTO cards (name, description, type, dlc_name) VALUES (?, ?, ?, ?)", card)
|
||
|
||
conn.commit() |