Template:BCS power list: Difference between revisions

mNo edit summary
mNo edit summary
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<includeonly>{{generic cargo list
<includeonly>{{generic cargo list
|table=bcs_powers=power, bcs_powers__exclusive=exclusive
|table=bcs_powers=power, bcs_powers__exclusive=exclusive
|image field=power.image|pagename field=power._pageName|name field=power.name|description field=power.description
|image field=power.image|link field=power._pageName|name field=power.name|description field=power.description
|col 1 name=Art
|col 1 name=Card
|extra col 1=COALESCE(power.class, "—") = Class
|extra col 1=COALESCE(power.class, "—") = Class
|extra col 2=COALESCE(power.rarity, "—") = Rarity
|extra col 2=COALESCE(power.rarity, "—") = Rarity
Line 14: Line 14:
|responsive=y
|responsive=y
|limit={{{limit|}}}
|limit={{{limit|}}}
|where=NOT power.unused {{#if:{{{keyword 1|{{{keyword|}}}}}}|AND (power.keywords HOLDS "{{{keyword 1|{{{keyword|}}}}}}" OR power.keywords HOLDS "{{{keyword 2|-}}}")}} {{#if:{{{bloontonium|}}}AND power.bloontonium = 1}} {{#if:{{{include|}}}| {{#if:{{{exclude others|}}}|AND|OR}} {{#invoke:cargo name list|main|power.name|{{{include|x}}}}}}}
|where=NOT power.unused {{#if:{{{keyword 1|{{{keyword|}}}}}}|AND (power.keywords HOLDS "{{{keyword 1|{{{keyword|}}}}}}" OR power.keywords HOLDS "{{{keyword 2|-}}}")}} {{#if:{{{bloontonium|}}}|AND power.bloontonium}} {{#if:{{{include|}}}| {{#if:{{{exclude others|}}}|AND|OR}} {{#invoke:cargo name list|main|power.name|{{{include|x}}}}}}}
|join on=power._ID = exclusive._rowID
|join on=power._ID = exclusive._rowID
|group by=power._pageName, power.name, power.image, power.description, power._ID, power.class, power.rarity, power.pack, power.bloontonium, power.cost, power.charges, power.introduced
|group by=power._pageName, power.name, power.image, power.description, power._ID, power.class, power.rarity, power.pack, power.bloontonium, power.cost, power.charges, power.introduced
}}</includeonly><noinclude>{{/doc}}</noinclude>
}}</includeonly><noinclude>{{/doc}}</noinclude>