Monkey Mastery: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| (One intermediate revision by one other user not shown) | |||
| Line 8: | Line 8: | ||
|where =btdb2_cosmetic_sources.name LIKE '% Mastery' | |where =btdb2_cosmetic_sources.name LIKE '% Mastery' | ||
|fields=CONCAT("[[File:", btdb2_cosmetic_items.image, "|50x50px|", btdb2_cosmetic_items.name, "]]") = Icon, | |fields=CONCAT("[[File:", btdb2_cosmetic_items.image, "|50x50px|", btdb2_cosmetic_items.name, "]]") = Icon, | ||
CONCAT(btdb2_cosmetic_items.name, '<br> | CONCAT("'''", btdb2_cosmetic_items.name, "'''<br>", btdb2_cosmetic_items.description) = Text, | ||
btdb2_cosmetic_sources.name = Mastery, | btdb2_cosmetic_sources.name = Mastery, | ||
CONCAT("[[File:", btdb2_cosmetic_categories.icon, "|x20px|", btdb2_cosmetic_categories.name, "|link=", btdb2_cosmetic_categories._pageName, "]][[", btdb2_cosmetic_categories._pageName, "|", btdb2_cosmetic_categories.name, "]]") = Category, | CONCAT("[[File:", btdb2_cosmetic_categories.icon, "|x20px|", btdb2_cosmetic_categories.name, "|link=", btdb2_cosmetic_categories._pageName, "]][[", btdb2_cosmetic_categories._pageName, "|", btdb2_cosmetic_categories.name, "]]") = Category, | ||
| Line 15: | Line 15: | ||
|join on =btdb2_cosmetic_items.id = btdb2_cosmetic_sources.item, btdb2_cosmetic_items.category = btdb2_cosmetic_categories.name | |join on =btdb2_cosmetic_items.id = btdb2_cosmetic_sources.item, btdb2_cosmetic_items.category = btdb2_cosmetic_categories.name | ||
|order by=btdb2_cosmetic_sources.name | |order by=btdb2_cosmetic_sources.name | ||
|limit= | |limit=300 | ||
}} | }} | ||
==Navigation== | ==Navigation== | ||
{{BTDB2 customization nav}} | {{BTDB2 customization nav}} | ||
[[Category:Bloons TD Battles 2]] | |||