Template:BTDB2 hero reward list by id: Difference between revisions
No edit summary |
mNo edit summary |
||
| Line 4: | Line 4: | ||
|join on=btdb2_cosmetic_items.category=btdb2_cosmetic_categories.name | |join on=btdb2_cosmetic_items.category=btdb2_cosmetic_categories.name | ||
CONCAT("[[File:", btdb2_cosmetic_items.image, "|50x50px]]") = Icon, | |fields=CONCAT("[[File:", btdb2_cosmetic_items.image, "|50x50px]]") = Icon, | ||
CONCAT(btdb2_cosmetic_items.name, "<br>", btdb2_cosmetic_items.description) = Name / description, | CONCAT(btdb2_cosmetic_items.name, "<br>", btdb2_cosmetic_items.description) = Name / description, | ||
CONCAT("[[File:",btdb2_cosmetic_categories.icon,"|20x20px|link=", btdb2_cosmetic_categories._pageName, "]][[",btdb2_cosmetic_categories._pageName, "|", category, "]]") = Category, | CONCAT("[[File:",btdb2_cosmetic_categories.icon,"|20x20px|link=", btdb2_cosmetic_categories._pageName, "]][[",btdb2_cosmetic_categories._pageName, "|", category, "]]") = Category, | ||