#dbic

Remaining cards of the “Witchcraft”- Archetype revealed

Monsters:

DBIC-JP015 Witchcraft Pittore Level 3 WATER Spellcaster Effect Monster ATK 1000 DEF 1500 You can only use each effect of this card’s name once per turn. (1) During either Main Phase (Quick Effect): You can Tribute this card, then discard 1 Spell Card from your hand; Special Summon 1 “Witchcraft” monster from your Deck, except “Witchcraft Pitture”. (2) You can banish this card from your GY; draw 1 card, then send 1 “Witchcraft” card from your hand to the GY, or, if you do not have any in your hand, banish your entire hand.

Note: This card’s name seems to be Italian, or at least based on, the Italian word for Painter.

DBIC-JP017 Witchcraft Edel Level 5 LIGHT Spellcaster Effect Monster ATK 2000 DEF 2300 You can only use each effect of this card’s name once per turn. (1) (Quick Effect): You can discard 1 Spell Card; Special Summon 1 “Witchcraft” monster from your hand, except “Witchcraft Edel”. (2) You can Tribute this card, then target 1 Spellcaster monster in your GY, except “Witchcraft Edel”; Special Summon that monster.

Note: This card’s name seems to be German for “High Class”/”High Grade”/”Noble”

DBIC-JP018 Witchcraft Heine/Haine Level 7 DARK Spellcaster Effect Monster ATK 2400 DEF 1000 You can only use the 2nd effect of this card’s name once per turn. (1) Other Spellcaster monsters you control cannot be targeted by your opponent’s effects. (2) (Quick Effect): You can discard 1 Spell from your hand, then target 1 face-up card your opponent controls; destroy that card.

Note: This card’s name seems to be German for “Home”.                                Note 2: “Haine” seems to be Romanian for “clothing”, which is probably closer to her tailor look.

Spells:

DBIC-JP020 Witchcraft Creation Normal Spell Card You can only use one effect of this card’s name per turn, and only once that turn. (1) Add 1 “Witchcraft” monster from your Deck to your hand. (2) During your End Phase, if you control a “Witchcraft” monster while this card in the GY: You can add this card to your hand.

DBIC-JP021 Witchcraft Sabotage Normal Spell Card You can only use one effect of this card’s name per turn, and only once that turn. (1) Target 1 “Witchcraft” monster in your GY; Special Summon that monster. (2) During your End Phase, if you control a “Witchcraft” monster while this card in the GY: You can add this card to your hand.

--

DBIC-JP022 Witchcraft Collaboration Normal Spell Card You can only use one effect of this card’s name per turn, and only once that turn. (1) Target 1 “Witchcraft” monster you control; during this turn, that monster can attack twice during each Battle Phase, also if that monster attacks, your opponent cannot activate Spells or Traps until the end of the Damage Step. (2) During your End Phase, if you control a “Witchcraft” monster while this card in the GY: You can add this card to your hand.

DBIC-JP023 Witchcraft Draping Quick-Play Spell Card You can only use one effect of this card’s name per turn, and only once that turn. (1) Target Spell/Traps your opponent controls, up to the number of “Witchcraft” monsters you control; return those card(s) to the hand. (2) During your End Phase, if you control a “Witchcraft” monster while this card in the GY: You can add this card to your hand.

2.--

DBIC-JP024 Witchcraft Bystreet Continuous Spell Card You can use the 2nd or 3rd effect of this card’s name once per turn, and only one of them that turn. (1) Each turn, the first time each of your “Witchcraft” monsters would be destroyed by battle or effects, they are not destroyed. (2) If you would discard from the hand to activate the effect of a “Witchcraft” monster you control, you can send this card to the GY instead. (3) During your End Phase, if you control a “Witchcraft” monster while this card in the GY: You can place this card in your Spell & Trap Zone face-up.

DBIC-JP024 Witchcraft Scroll Continuous Spell Card You can use the 2nd or 3rd effect of this card’s name once per turn, and only one of them that turn. (1) Once per turn, when a Spellcaster monster you control destroys a monster by battle: You can draw 1 card. (2) If you would discard from the hand to activate the effect of a “Witchcraft” monster, you can send this card to the GY instead. (3) During your End Phase, if you control a “Witchcraft” monster while this card in the GY: You can place this card in your Spell & Trap Zone face-up.

3.--

DBIC-JP026 Witchcraft Masterpiece Normal Trap Card You can only use each effect of this card’s name once per turn. (1) If you control a “Witchcraft” monster: Target 1 Spell in either GY; add 1 card with the same name as that card from your Deck to your hand. (2) You can banish this card and any number of Spells from your GY; Special Summon from your Deck 1 “Witchcraft” monster with a Level equal to the number of Spells banished. This effect cannot be activated during the turn this card is sent to the GY.

coming out in Deck Build Pack: Infinity Chasers on February 23, 2019 in OCG

DBIC-JP001 Mugen Kidou Harvester (Infinitrack Harvester) Level 2 EARTH Machine Effect Monster ATK 0 DEF 2100 You can only use each effect of this card’s name once per turn. (1) If this card is Normal or Special Summoned: Add 1 “Infinitrack” monster from your Deck to your hand, except “Infinitrack Harvester”. (2) You can target 1 Machine monster you control, except this card; until the end of the turn, the Levels of this card and that target become the total of their combined original Levels.

DBIC-JP002 Mugen Kidou Rock Anchor (Infinitrack Rock Anchor) Level 4 EARTH Machine Effect Monster ATK 1800 DEF 500 You can only use each effect of this card’s name once per turn. (1) If this card is Normal or Special Summoned: You can Special Summon 1 EARTH Machine monster from your hand in Defense Position, except “Infinitrack Rock Anchor”. (2) You can target 1 Machine monster you control, except this card; until the end of the turn, the Levels of this card and that monster become equal to the total combined Levels of those 2 cards.

DBIC-JP003 Mugen Kidou Cancer Crane (Infinitrack Cancer Crane) Level 5 EARTH Machine Effect Monster ATK 2100 DEF 500 You can only use each effect of this card’s name once per turn. (1) You can Tribute 1 EARTH Machine monster you control; Special Summon this card from your hand in Defense Position. (2) You can banish 1 Machine monster from your GY; add 1 “Outrigger Expand” from your Deck to your hand.

.—-

DBIC-JP004 Mugen Kidou Drag Shovel (Infinitrack Drag Shovel) Level 5 EARTH Machine Effect Monster ATK 1500 DEF 2100 You can only use each effect of this card’s name once per turn. (1) You can Tribute 1 EARTH Machine you control; Special Summon this card from your hand in Defense Position. (2) You can banish 1 Machine monster from your GY; add 1 “Spin Turn” from your Deck to your hand.

DBIC-JP005 Mugen Kidou Trencher (Infinitrack Trencher) Level 5 EARTH Machine Effect Monster ATK 500 DEF 2400 You can only use each effect of this card’s name once per turn. (1) You can Tribute 1 EARTH Machine you control; Special Summon this card from your hand in Defense Position. (2) You can banish this card from your GY, then target 1 Level 5 or lower “Infinitrack” monster in your GY, except “Infinitrack Trencher”; Special Summon that monster in Defese Position.

DBIC-JP006 Mugen Kidou Scraper (Infinitrack Roadheader) Level 5 EARTH Machine Effect Monster ATK 2200 DEF 500 You can only use each effect of this card’s name once per turn. (1) You can Tribute 1 EARTH Machine you control; Special Summon this card from your hand in Defense Position. (2) You can banish this card from your GY, then target 5 EARTH Machine monsters in your GY; shuffle those monster into the Deck, then draw 2 cards.

2.—–

DBIC-JP008 Mugen Kidou Colossal Mountain (Infinitrack Colossal Mountain) Rank 7 EARTH Machine Xyz Effect Monster ATK 2100 DEF 3100 Materials: 2 Level 7 monsters You can only use the 1st and 3rd effects of this card’s name once per turn. (1) You can detach 1 material from this card; this card gains 1000 ATK. (2) When this card destroys an opponent’s monster by battle: You can attach that monster to this card as material. (3) If this card is in your GY: You can Tribute 1 Machine Link Monster; Special Summon this card in Defense Position.

DBIC-JP009 Mugen Kidou Earthshaker (Infinitrack Earthshaker) Rank 9 EARTH Machine Xyz Effect Monster ATK 3100 DEF 2100 Materials: 2 Level 9 monsters You can only use the 1st and 3rd effects of this card’s name once per turn. (1) You can detach any number of material from this card, then target an equal number of cards on the field; destroy those targets. (2) When this card destroys an opponent’s monster by battle: You can attach that monster to this card as material. (3) If this card is in your GY: You can Tribute 1 Machine Link Monster; Special Summon this card in Defense Position.

3.—–

DBIC-JP011 Mugen Kidou Yousai Megaton Gale (Infinitrack Fortress Megaton Gale) Link 3 EARTH Machine Link Effect Monster ATK 4000 Links: Bottom Left, Bottom Right, Right Materials: 3 Xyz Monsters You can only use the 2nd effect of this card’s name once per turn. (1) This card is unaffected by the effects of monsters, except Xyz monsters, and cannot be destroyed by battle, except by Xyz monsters. (2) Target 1 Xyz monster in your GY and 1 card your opponent controls; Special Summon the first target and place the second target under that monster as material, but halve any damage inflicted to your opponent for the remainder of this turn.

DBIC-JP012 Outrigger Expand Continuous Spell Card (1) Machine Xyz Monsters you control cannot be targeted by an opponent’s card effect. (2) Once per turn: You can target 1 “Infinitrack” Xyz Monster you control; Special Summon from your Extra Deck 1 Machine Xyz Monster that is 2 Ranks higher than that monster you control by using it as the Xyz Material. (This Special Summon is treated as an Xyz Summon, also transfer the materials to the Summoned monster.) You cannot Special Summon monsters, except EARTH Machine monsters, for the rest of the turn after you activated this effect.

Coming out in Deck Build Pack: Infinity Chasers on March 21, 2019 in TCG

A total of 12 cards are in the Archetype (10 on this and +2 on a previous post) 

More cards from Evil Eye in VJump revealed

DBIC-JP028 Jyagan no Shito Medusa (OCG: Medusa, Deathsciple of the Evil Eye/TCG: Medusa, Watcher of the Evil Eye) Level 4 DARK Fiend Effect Monster ATK 1400 DEF 1600 You can only use the 2nd effect of this card’s name once per turn. (1) When this card is Normal Summoned: You can target 1 “Evil Eye” card in your GY, except “Medusa, Watcher of the Evil Eye”; add that card to your hand. (2) If this card is equipped with “Evil Eye of Selene” (Quick Effect): You can target 1 monster in your opponent’s GY; banish that monster. (3) Once per turn, during the next Standby Phase after this card’s 2nd effect was activated: Banish 1 card in your GY.

DBIC-JP030 Jyagan no Kenzoku Bajilius (Bajilius, Retainer of the Evil Eye) Level 3 DARK Fiend Effect Monster ATK 400 DEF 2000 You can only Special Summon a card with this card’s name with its 1st effect once per turn. You can only activate the 2nd effect of this card’s name once per turn. (1) If you control an “Evil Eye” monster, you can Special Summon this card (from the hand). (2) During your Main Phase: You can send 1 “Evil Eye” Spell/Trap from your Deck to the GY.

DBIC-JP033 Jyagan Ryouisa -Pareidolia- (Pareidolia, Domain of the Evil Eye) Field Spell Card You can only activate a card with this card’s name once per turn. (1) When this card is activated: You can add 1 “Evil Eye” monster from your Deck to your hand. (2) Once per turn, while you control “Evil Eye of Selene” in a Spell/Trap Zone, when an “Evil Eye” monster you control is attacked, during damage calculation: You can activate this effect; damage you take from this battle is also inflicted to your opponent. (3) If this card in a Field Zone is destroyed by an effect: You can target 1 “Evil Eye” monster in your GY; add that monster to your hand.

--_2

DBIC-JP034 Kanki no Jyagan (Forbidden Awakening of the Evil Eye) Normal Spell Card You can only activate a card with this card’s name once per turn. (1) Special Summon 1 “Evil Eye” monster from your hand or GY. If “Evil Eye of Selene” is in your Spell & Trap Zone, you can Special Summon 1 “Evil Eye” monster from your Deck instead.

DBIC-JP035 Sanka no Jyagan (Curse of the Evil Eye) Quick-Play Spell Card You can only activate a card with this card’s name once per turn. (1) If you control an “Evil Eye” monster: You can target 1 Spell/Trap Card your opponent controls; destroy that card. If “Evil Eye of Selene” is in your Spell & Trap Zone, the card destroyed by this effect is banished instead of being sent to the GY.

DBIC-JP036 Seikan no Jyagan (Watchful Rule of the Evil Eye) Continuous Spell Card You can only activate a card with this card’s name once per turn. (1) You can also banish 1 “Evil Eye” card from your GY to activate this card; if you do so, draw 1 card. (2) Once per turn, when an “Evil Eye” monster equipped with “Evil Eye of Selene” attacks, during damage calculation: You can activate this effect; banish that opponent’s monster. (3) If this card in a Spell & Trap Zone is destroyed by an effect: You can target up to 3 of your banished “Evil Eye” cards; return those cards to the GY.

--_3

DBIC-JP037 Tosetsu no Jyagan (Jealous Disruption of the Evil Eye) Normal Trap Card You can only activate a card with this card’s name once per turn. (1) If you control an “Evil Eye” monster: You can target 1 monster on the field; return that monster to the hand. If “Evil Eye of Selene” is in your Spell & Trap Zone, you can target 2 monsters with this card’s effect.

DBIC-JP038 Shihai no Jyagan (Death Control of the Evil Eye) Continuous Trap Card You can only activate a card with this card’s name once per turn. (1) When your opponent Special Summons a monster in Attack Position, if you control an “Evil Eye” monster with higher ATK than that monster: You can target that monster to activate this card; take control of that monster. If you control “Evil Eye of Selene” in your Spell & Trap Zone, it’s also treated as an “Evil Eye” monster. When that monster leaves the field, destroy this card.

DBIC-JP039 Danzai no Jyagan (Sentence of the Evil Eye) Counter Trap Card You can only activate a card with this card’s name once per turn. (1) When a Spell/Trap is activated while you control an “Evil Eye” monster: Negate that activation, and if you do, destroy that card. If you control “Evil Eye of Selene” in your Spell & Trap Zone, this card’s activation and effect cannot be negated.

With obvious Evil Eye of Selene interactions                                                        If you missed the other 3 Evil Eye cards click here                                               

Witchcraft Poterie Earth Spellcaster / Effect LV2 0/2000 You can only use this card name’s (1) and (2) effects once per turn each. (1) During the Main Phase (Quick Effect): You can Tribute this card, then discard 1 Spell; Special Summon 1 “Witchcraft” monster from your Deck, except “Witchcraft Poterie”. (2) If you have no cards in your hand: You can banish this card from your GY, then target 1 “Witchcraft” card in your GY; add that card to your hand.

Witchcraft Theme in Infinty Chasers revealed

DBIC-JP007 Mugen Kidou Riverstorm (Infinite Ignition Riverstorm) Rank 5 EARTH Machine Xyz Effect Monster ATK 2500 DEF 500 Materials: 2 Level 5 monsters You can only use the 1st and 3rd effects of this card’s name each once per turn. (1) You can detach 1 Xyz Material from this card; either add 1 EARTH Machine monster from your Deck to your hand, or send 1 EARTH Machine monster from your Deck to the GY. (2) When this card destroys an opponent’s monster by battle: You can attach that monster to this card as Xyz Material. (3) If this card is in the GY: You can Tribute 1 Machine Link Monster; Special Summon this card in Defense Position.

DBIC-JP016 Witchcraft Schmitta Level 4 FIRE Spellcaster Effect Monster ATK 1800 DEF 600 You can only use the 1st and 2nd effect of this card’s name each once per turn. (1) During either player’s Main Phase: You can Tribute this card, then discard 1 Spell card from your hand; Special Summon 1 “Witchcraft” monster from your Deck, except “Witchcraft” Schmitta. (2) You can banish this card from your GY; send 1 “Witchcraft” card from your Deck to the GY, except “Witchcraft Schmitta”.

20CP-JPC09 Mugen Kidou Goliath (Infinite Ignition Goliath) Link 1 EARTH Machine Link Effect Monster ATK 1000 Link: Bottom Right 1 “Infinite Ignition” monster, except a Link Monster. You can only use the 1st effect of this card’s name once per turn. (1) If this card is sent from the field to the GY, you can target 1 Xyz Monster you control; attach this card to that monster as Xyz Material. (2) While this card is attached as material, an Xyz monster whose original Type is Machine gains the following effect. • This card cannot be destroyed by effects.

DBIC-JP027 Jagan no Shito Sariel (Cursed Eye Deathsciple Sariel) Level 4 DARK Fiend Effect Monster ATK 1600 DEF 1400 You can use the (2)nd effect with this card’s name only once per turn. (1) If this card is Normal Summoned: You can add 1 “Cursed Eye” card from your Deck to your hand, except “Cursed Eye Deathsciple Sariel”. (2) While “Cursed Eye of Selene” is equipped to this card (Quick Effect): You can target 1 Special Summoned monster your opponent controls; destroy that monster. (3) During the next Standby Phase after this card’s (2)nd effect is activated: Destroy 1 card you control.

DBIC-JP031 Jagan-no-Oh Zarakiel (Cursed Eye King Zerachiel) Link 3 DARK Fiend Link Effect Monster ATK 2600 Link Arrows: Top-Center, Bottom-Left, Bottom-Right Link Materials: 2+ “Cursed Eye” monsters You can use the (2)nd effect with this card’s name only once per turn. (1) If this card was Link Summoned using a monster(s) with 2600 or more ATK as material, this card can make a second attack during each Battle Phase. (2) While “Cursed Eye of Selene” is equipped to this card (Quick Effect): You can target 1 card your opponent controls; destroy it. (3) During the next Standby Phase after this card’s (2)nd effect is activated: Negate the effects of 1 Effect Monster this card points to.

During the second week of February, I ran my (approximately) annual public Perl training courses in association with FlossUK. Things were organised slightly differently this year. Previously we’ve run two two-day “general purpose” courses – one on Intermediate Perl and one on Advanced Perl. This year we ran four courses, each of which were on a more specific technology. There were one-day courses…

This is a simplistic method for dumping the query a DBIC result set will execute.

It’s simplisitc in that it doesn’t care about quoting values, or dealing with ? that happens to not be placeholders. But whatevs.

Put this in your base ResultSet class for the schema:

=head2 as_sql() : $sql Return $sql string with the query and its parameters. =cut sub as_sql { my $self = shift; my $query = $self->as_query; my ($sql, @args) = @$$query; my @arg_values = map { "'$_->[1]'" } @args; my $match_rex = qr/ \?([ ,])/ms; while ($sql =~ $match_rex && @arg_values) { my $value = shift @arg_values; $sql =~ s/$match_rex/ $value$1/ms; } @arg_values and warn( "as_sql for ($query) didn't make a use of all query args", ); return $sql; }

In your app:

my $book_rs = $schema->resultset("Book")->search( ... ); warn "SQL is:\n" . $book_rs->as_sql . "\n";