Template:BTD6 mk list: Difference between revisions
Created page with "<includeonly>{{generic cargo list |table=btd6_mk, btd6_mk__prerequisites=prereq |extra col 1=CONCAT(CASE WHEN cost = 0 THEN "Free" ELSE CONCAT("x20px|link=Monkey Money (BTD6)|Monkey Money ", FORMAT(cost, 0)) END) = Cost |extra col 2=IF(btd6_mk.points_required = 0 AND (btd6_mk.prerequisites__full IS NULL OR btd6_mk.prerequisites__full = ""), "—", CONCAT( IF(btd6_mk.points_required > 0, CONCAT("*File:BTD6_KnowledgeIcon.png|20px|link=Mo..." |
mNo edit summary |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 9: | Line 9: | ||
|limit={{{limit|}}} | |limit={{{limit|}}} | ||
|where=NOT unused {{#if:{{{category|}}}|AND btd6_mk.category = "{{{category|}}}"}} {{#if:{{{include|}}}| {{#if:{{{exclude | |where=NOT unused {{#if:{{{category|}}}|AND btd6_mk.category = "{{{category|}}}"}} {{#if:{{{introduced|}}}|AND btd6_mk.introduced = "{{{introduced|}}}"}} {{#if:{{{include|}}}| {{#if:{{{exclude others|}}}|AND|OR}} {{#invoke:cargo name list|main|btd6_mk.name|{{{include|x}}}}}}} | ||
|order by={{{order by|btd6_mk.points_required, btd6_mk.cost, btd6_mk.name, btd6_mk.introduced}}} | |order by={{{order by|btd6_mk.points_required, btd6_mk.cost, btd6_mk.name, btd6_mk.introduced}}} | ||
|group by=btd6_mk._pageName, btd6_mk.name, btd6_mk.image, btd6_mk.description, btd6_mk.cost, btd6_mk.points_required, btd6_mk.introduced, btd6_mk.prerequisites__full | |group by=btd6_mk._pageName, btd6_mk.name, btd6_mk.image, btd6_mk.description, btd6_mk.category, btd6_mk.cost, btd6_mk.points_required, btd6_mk.introduced, btd6_mk.prerequisites__full | ||
|join on =btd6_mk._ID = prereq._RowID | |join on =btd6_mk._ID = prereq._RowID | ||
|col 1 name=Monkey Knowledge | |||
}}</includeonly><noinclude>{{/doc}}</noinclude> | }}</includeonly><noinclude>{{/doc}}</noinclude> | ||
