User:Chao: Difference between revisions

Revision as of 15:18, 30 July 2021

@@ Line 1: / Line 1: @@
-<includeonly><table class="wikitable">
+{{#cargo_query:table=BBDW_Grimoires
-<tr><th>Character</th><th>Skill Icon</th><th>Ability</th><th>Description</th><th>Amount</th></tr>
+|fields=characters,count(nameen)
-{{#cargo_query:table=BBDW_Character_Status_Application
+|group by=characters
-|fields=charnameen,fxtype,fxnum,icon,nameen,namejp,fxcondition,fxdesc,fxbasecd
+|order by=count(nameen) desc
-,LPAD(SUBSTRING_INDEX(SUBSTRING_INDEX(fxdesc,'{{{1|}}} ',-1),'%',1),3,'0')=fxstatuses
+}}
-|where=fxstatuses HOLDS '{{{1|}}} '
-|order by=LPAD(SUBSTRING_INDEX(SUBSTRING_INDEX(fxdesc,'{{{1|}}} ',-1),'%',1),3,'0') asc
-|format=template
-|template=BBDW_Character_Status_Application/display
-|named args=yes
-}}</table>
-</includeonly><noinclude>
-==Search descriptions with regular expressions??==
-For example, query for rows in [[Special:CargoTables/BBDW_Character_Status_Application|BBDW Character Status Application]] where the effect description matches 'ATK Up 20%':
-* <code><nowiki>|where=fxdesc LIKE '%ATK Up 20\%%'</nowiki></code> (search for "ATK Up 20%")
-===Overdrive Extend===
-{{User:Chao|Overdrive Extend}}
-===ATK Down===
-{{User:Chao|ATK Down}}
-===DEF Down===
-{{User:Chao|DEF Down}}
-</noinclude>