Template:Item/Card: Difference between revisions

From A3! Wiki
Newer edit →
Created page with "<includeonly>{{#ifeq: {{{4|}}} | y |{{#cargo_query:tables=Cards,CardFiles|join on=Cards.number = CardFiles.number|fields=CONCAT('File:', CardFiles.icon2, "|link=", CONCAT('C..."
 
Fimbulvetr (talk | contribs)
Contributor, administrator, Bureaucrats, Administrators
8,130 edits
No edit summary
Line 1: Line 1:
<includeonly>{{#ifeq: {{{4|}}} | y |{{#cargo_query:tables=Cards,CardFiles|join on=Cards.number = CardFiles.number|fields=CONCAT('[[File:', CardFiles.icon2, "|link=", CONCAT('Cards/', Cards.character, '/', Cards.cardname), '|33px]] ', CONCAT(Cards.rarity, ' [[', Cards.character, ']]'))|where=Cards.cardname = "{{{1}}}" AND Cards.character LIKE "{{{2|}}}%" AND Cards.attribute LIKE "{{{3|}}}%"|format=list|default=}}|{{#cargo_query:tables=Cards,CardFiles|join on=Cards.number = CardFiles.number|fields=CONCAT('[[File:', CardFiles.icon1, "|link=", CONCAT('Cards/', Cards.character, '/', Cards.cardname), '|33px]] ', CONCAT(Cards.rarity, ' [[', Cards.character, ']]'))|where=Cards.cardname = "{{{1}}}" AND Cards.character LIKE "{{{2|}}}%" AND Cards.attribute LIKE "{{{3|}}}%"|format=list|default=}}}}</includeonly><noinclude>
<includeonly>{{#ifeq: {{{4|}}} | y |{{#cargo_query:tables=Cards,CardFiles|join on=Cards.number = CardFiles.number|fields=CONCAT('[[File:', CardFiles.icon2, "|link=", CONCAT('Cards/', Cards.chara, '/', Cards.cardname), '|33px]] ', CONCAT(Cards.rarity, ' [[', Cards.chara, ']]'))|where=Cards.cardname = "{{{1}}}" AND Cards.chara LIKE "{{{2|}}}%" AND Cards.attribute LIKE "{{{3|}}}%"|format=list|default=}}|{{#cargo_query:tables=Cards,CardFiles|join on=Cards.number = CardFiles.number|fields=CONCAT('[[File:', CardFiles.icon1, "|link=", CONCAT('Cards/', Cards.chara, '/', Cards.cardname), '|33px]] ', CONCAT(Cards.rarity, ' [[', Cards.chara, ']]'))|where=Cards.cardname = "{{{1}}}" AND Cards.chara LIKE "{{{2|}}}%" AND Cards.attribute LIKE "{{{3|}}}%"|format=list|default=}}}}</includeonly><noinclude>
<pre>
<pre>
{{Item/Card
{{Item/Card
Line 8: Line 8:
}}
}}


{{#cargo_query:tables=Cards,CardFiles|join on=Cards.number = CardFiles.number|fields=CONCAT('[[File:', CardFiles.icon1, "|link=", CONCAT('Cards/', Cards.character, '/', Cards.cardname), '|33px]] ', CONCAT(Cards.rarity, ' [[', Cards.character, ']]'))|where=Cards.cardname = "{{{1}}}" AND Cards.character LIKE "{{{2|}}}%"|format=list}}
{{#cargo_query:tables=Cards,CardFiles|join on=Cards.number = CardFiles.number|fields=CONCAT('[[File:', CardFiles.icon1, "|link=", CONCAT('Cards/', Cards.chara, '/', Cards.cardname), '|33px]] ', CONCAT(Cards.rarity, ' [[', Cards.chara, ']]'))|where=Cards.cardname = "{{{1}}}" AND Cards.chara LIKE "{{{2|}}}%"|format=list}}
</pre>
</pre>


Revision as of 13:45, 6 February 2018

{{Item/Card
| (exact card name)
| (optional chara name - can be just first name)
| (optional attribute - Co/Ac/Sr)
| (optional y = is prebloomed)
}}

{{#cargo_query:tables=Cards,CardFiles|join on=Cards.number = CardFiles.number|fields=CONCAT('[[File:', CardFiles.icon1, "|link=", CONCAT('Cards/', Cards.chara, '/', Cards.cardname), '|33px]] ', CONCAT(Cards.rarity, ' [[', Cards.chara, ']]'))|where=Cards.cardname = "{{{1}}}" AND Cards.chara LIKE "{{{2|}}}%"|format=list}}

Creates an inline card icon + rarity + character tag. Coach cards should use Template:Item instead.

Error: Table CardFiles not found.

is a good card.

Error: Table CardFiles not found.

is a bad card.

Retrieved from "https://yaycupcake.com/a3/index.php?title=Template:Item/Card&oldid=21020"