Monkey Knowledge (BTD6): Difference between revisions

Line 61:

==List of Monkey Knowledge==

{{generic cargo query

|~~table~~=btd6_mk

|tables=btd6_mk, btd6_mk__prerequisites

|extra col 1=category=Category

|extra col 1=btd6_mk.category=Category

|extra col 2=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=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 3=IF(points_required = 0 AND (prerequisites__full IS NULL OR prerequisites__full = ""), "—", CONCAT(

|extra col 3=IF(btd6_mk.points_required = 0 AND (btd6_mk.prerequisites__full IS NULL OR btd6_mk.prerequisites__full = ""), "—", CONCAT(

IF(points_required > 0, CONCAT("[[File:BTD6_KnowledgeIcon.png|20px|link=Monkey Knowledge Point]]", points_required, " invested"), ""),

IF(btd6_mk.points_required > 0, CONCAT("*[[File:BTD6_KnowledgeIcon.png|20px|link=Monkey Knowledge Point]] ", points_required, " invested\n"), ""),

IF~~(points_required > 0 AND NOT~~(prerequisites__full ~~IS NULL OR prerequisites__full~~ = ""), ~~CONCAT~~(", "~~, prerequisites__full~~), ~~prerequisites__full~~)

IF(prerequisites__full != "", GROUP_CONCAT("*", btd6_mk__prerequisites._value SEPARATOR "\n"), ""))) = Prerequisites

)) = Prerequisites

|col align left=y

|order by=(CASE category WHEN "Primary" THEN 0 WHEN "Military" THEN 1 WHEN "Magic" THEN 2 WHEN "Support" THEN 3 WHEN "Heroes" THEN 4 WHEN "Powers" THEN 5 END), IF(Prerequisites = "—", 0, 1), points_required, cost, name, introduced

|order by=(CASE btd6_mk.category WHEN "Primary" THEN 0 WHEN "Military" THEN 1 WHEN "Magic" THEN 2 WHEN "Support" THEN 3 WHEN "Heroes" THEN 4 WHEN "Powers" THEN 5 END), IF(Prerequisites = "—", 0, 1), 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.category, btd6_mk.cost, btd6_mk.points_required, btd6_mk.introduced, btd6_mk.prerequisites__full

|join on =btd6_mk._ID = btd6_mk__prerequisites._RowID

|limit =200

|where=NOT unused

@@ Line 61: / Line 61: @@
 ==List of Monkey Knowledge==
 {{generic cargo query
-|table=btd6_mk
+|tables=btd6_mk, btd6_mk__prerequisites
-|extra col 1=category=Category
+|extra col 1=btd6_mk.category=Category
-|extra col 2=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=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 3=IF(points_required = 0 AND (prerequisites__full IS NULL OR prerequisites__full = ""), "—", CONCAT(
+|extra col 3=IF(btd6_mk.points_required = 0 AND (btd6_mk.prerequisites__full IS NULL OR btd6_mk.prerequisites__full = ""), "—", CONCAT(
-IF(points_required > 0, CONCAT("[[File:BTD6_KnowledgeIcon.png|20px|link=Monkey Knowledge Point]]", points_required, " invested"), ""),
+IF(btd6_mk.points_required > 0, CONCAT("*[[File:BTD6_KnowledgeIcon.png|20px|link=Monkey Knowledge Point]] ", points_required, " invested\n"), ""),
-IF(points_required > 0 AND NOT(prerequisites__full IS NULL OR prerequisites__full = ""), CONCAT(", ", prerequisites__full), prerequisites__full)
+IF(prerequisites__full != "", GROUP_CONCAT("*", btd6_mk__prerequisites._value SEPARATOR "\n"), ""))) = Prerequisites
-)) = Prerequisites
+|col align left=y
-|order by=(CASE category WHEN "Primary" THEN 0 WHEN "Military" THEN 1 WHEN "Magic" THEN 2 WHEN "Support" THEN 3 WHEN "Heroes" THEN 4 WHEN "Powers" THEN 5 END), IF(Prerequisites = "—", 0, 1), points_required, cost, name, introduced
+|order by=(CASE btd6_mk.category WHEN "Primary" THEN 0 WHEN "Military" THEN 1 WHEN "Magic" THEN 2 WHEN "Support" THEN 3 WHEN "Heroes" THEN 4 WHEN "Powers" THEN 5 END), IF(Prerequisites = "—", 0, 1), 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.category, btd6_mk.cost, btd6_mk.points_required, btd6_mk.introduced, btd6_mk.prerequisites__full
+|join on =btd6_mk._ID = btd6_mk__prerequisites._RowID
 |limit   =200
 |where=NOT unused