Hero Reward: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 6: | Line 6: | ||
|where =btdb2_cosmetic_sources.name LIKE '% Hero Rewards' | |where =btdb2_cosmetic_sources.name LIKE '% Hero Rewards' | ||
|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 = Hero Rewards, | btdb2_cosmetic_sources.name = Hero Rewards, | ||
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, | ||