Monkey Prestige: Difference between revisions
No edit summary |
Pymonkibot (talk | contribs) m Text replacement - "[[Bloons TD Battles 2 v" to "[[Update history:Bloons TD Battles 2/Version " |
||
| (One intermediate revision by one other user not shown) | |||
| Line 56: | Line 56: | ||
|fields=CONCAT("[[File:", item.image, "|x20px|", item.name, "]]") = Icon, | |fields=CONCAT("[[File:", item.image, "|x20px|", item.name, "]]") = Icon, | ||
CONCAT(item.name) = Name, <!-- the concat is a hack to get around apostrophes being parsed weirdly --> | CONCAT(item.name) = Name, <!-- the concat is a hack to get around apostrophes being parsed weirdly --> | ||
GROUP_CONCAT(source.name SEPARATOR ', ') = | GROUP_CONCAT(source.name SEPARATOR ', ') = Unlock method, | ||
CONCAT(CASE WHEN item.introduced IS NULL THEN "Launch" ELSE CONCAT("[[Bloons TD Battles 2 | CONCAT(CASE WHEN item.introduced IS NULL THEN "Launch" ELSE CONCAT("[[Update history:Bloons TD Battles 2/Version ", item.introduced, "|Version ", item.introduced, "]]") END) = Introduced | ||
|join on =item.id = source.item, item.category = category.name | |join on =item.id = source.item, item.category = category.name | ||
| Line 69: | Line 69: | ||
|fields=CONCAT("<span style='position:absolute;z-index:0'>[[File:BTDB2 rainbow bg.jpg|x20px]]</span><span style='position:relative;z-index:1'>[[File:", item.image, "|x20px|", item.name, "]]</span>") = Icon, | |fields=CONCAT("<span style='position:absolute;z-index:0'>[[File:BTDB2 rainbow bg.jpg|x20px]]</span><span style='position:relative;z-index:1'>[[File:", item.image, "|x20px|", item.name, "]]</span>") = Icon, | ||
CONCAT(item.name) = Name, <!-- the concat is a hack to get around apostrophes being parsed weirdly --> | CONCAT(item.name) = Name, <!-- the concat is a hack to get around apostrophes being parsed weirdly --> | ||
GROUP_CONCAT(source.name SEPARATOR ', ') = | GROUP_CONCAT(source.name SEPARATOR ', ') = Unlock method, | ||
CONCAT(CASE WHEN item.introduced IS NULL THEN "Launch" ELSE CONCAT("[[Bloons TD Battles 2 | CONCAT(CASE WHEN item.introduced IS NULL THEN "Launch" ELSE CONCAT("[[Update history:Bloons TD Battles 2/Version ", item.introduced, "|Version ", item.introduced, "]]") END) = Introduced | ||
|join on =item.id = source.item, item.category = category.name | |join on =item.id = source.item, item.category = category.name | ||
| Line 356: | Line 356: | ||
|fields=CONCAT("[[File:", item.image, "|x20px|", item.name, "]]") = Icon, | |fields=CONCAT("[[File:", item.image, "|x20px|", item.name, "]]") = Icon, | ||
CONCAT(item.name) = Name, <!-- the concat is a hack to get around apostrophes being parsed weirdly --> | CONCAT(item.name) = Name, <!-- the concat is a hack to get around apostrophes being parsed weirdly --> | ||
GROUP_CONCAT(source.name SEPARATOR ', ') = | GROUP_CONCAT(source.name SEPARATOR ', ') = Unlock method, | ||
CONCAT(CASE WHEN item.introduced IS NULL THEN "Launch" ELSE CONCAT("[[Bloons TD Battles 2 | CONCAT(CASE WHEN item.introduced IS NULL THEN "Launch" ELSE CONCAT("[[Update history:Bloons TD Battles 2/Version ", item.introduced, "|Version ", item.introduced, "]]") END) = Introduced | ||
|join on =item.id = source.item, item.category = category.name | |join on =item.id = source.item, item.category = category.name | ||