Template:BTD6 mk list: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 3: | Line 3: | ||
|extra col 1=CONCAT(CASE WHEN cost = 0 THEN "Free" ELSE CONCAT("[[File:BTD6 BloonjaminsIcon.png|x20px|link=Monkey Money (BTD6)|Monkey Money]] ", FORMAT(cost, 0)) END) = Cost | |extra col 1=CONCAT(CASE WHEN cost = 0 THEN "Free" ELSE CONCAT("[[File:BTD6 BloonjaminsIcon.png|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( | |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(" | IF(btd6_mk.points_required > 0, CONCAT("[[File:BTD6_KnowledgeIcon.png|20px|link=Monkey Knowledge Point]] ", points_required, " invested<br>"), ""), | ||
IF(prerequisites__full != "", GROUP_CONCAT( | IF(prerequisites__full != "", GROUP_CONCAT(prereq._value SEPARATOR "<br>"), ""))) = Prerequisites | ||
|introduced col game name=Bloons TD 6 | |introduced col game name=Bloons TD 6 | ||
|responsive=y | |responsive=y | ||
| Line 10: | Line 10: | ||
|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}}}}}}} | |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.prerequisites__full, btd6_mk.name, btd6_mk.introduced}}} | ||
|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 | |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 | |col 1 name=Monkey Knowledge | ||
}}</includeonly><noinclude>{{/doc}}</noinclude> | }}</includeonly><noinclude>{{/doc}}</noinclude> | ||