User:YBamY/sandbox/4: Difference between revisions

Content added Content deleted

VisualWikitext

Inline

Revision as of 05:05, 18 October 2021

4☆ Cards

Error: No field named "thumbnail" found for any of the specified database tables.

3☆ Cards

Error: No field named "thumbnail" found for any of the specified database tables.

2☆ Cards

Error: No field named "thumbnail" found for any of the specified database tables.

1☆ Cards

Error: No field named "thumbnail" found for any of the specified database tables.

@@ Line 1: / Line 1: @@
-==Cards Without Romaji==
+==4☆ Cards==
 {{#cargo_query:
 tables=Cards
+|fields=thumbnail, CONCAT("[[",_pageName,"|",card_name,"]]")=card, card_name=card name, _pageName
-|fields=_pageName
-|where=Cards.skill_name_romaji = '' AND Cards.romaji = '' AND Cards.card_id > '0'
+|where=Cards.rarity = '4' AND Cards.card_id > '0'
 |order by=Cards.card_id ASC
-|format=ul
+|format=gallery
+|mode=nolines
+|show bytes=0
+|show dimensions=0
+|show filename=0
+|link field=_pageName
+|limit=500
+}}
+==3☆ Cards==
+{{#cargo_query:
+tables=Cards
+|fields=thumbnail, CONCAT("[[",_pageName,"|",card_name,"]]")=card, card_name=card name, _pageName
+|where=Cards.rarity = '3' AND Cards.card_id > '0'
+|order by=Cards.card_id ASC
+|format=gallery
+|mode=nolines
+|show bytes=0
+|show dimensions=0
+|show filename=0
+|link field=_pageName
+|limit=500
+}}
+==2☆ Cards==
+{{#cargo_query:
+tables=Cards
+|fields=thumbnail, CONCAT("[[",_pageName,"|",card_name,"]]")=card, card_name=card name, _pageName
+|where=Cards.rarity = '2' AND Cards.card_id > '0'
+|order by=Cards.card_id ASC
+|format=gallery
+|mode=nolines
+|show bytes=0
+|show dimensions=0
+|show filename=0
+|link field=_pageName
+|limit=500
+}}
+==1☆ Cards==
+{{#cargo_query:
+tables=Cards
+|fields=thumbnail, CONCAT("[[",_pageName,"|",card_name,"]]")=card, card_name=card name, _pageName
+|where=Cards.rarity = '1' AND Cards.card_id > '0'
+|order by=Cards.card_id ASC
+|format=gallery
+|mode=nolines
+|show bytes=0
+|show dimensions=0
+|show filename=0
+|link field=_pageName
+|limit=500
 }}