308
editsAd placeholder
User:Korgat: Difference between revisions
Jump to navigation
Jump to search
no edit summary
No edit summary |
No edit summary |
||
Line 257: | Line 257: | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
|tables=equipment; where = where_to_find like "%Rivington%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Rivington]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | |||
|tables=weapons; where = where_to_find like "%Rivington%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Rivington]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | |||
|format=dynamic table | |format=dynamic table | ||
Line 282: | Line 293: | ||
See [[Permanent Bonuses]] or [[Permanent bonus table]] for a complete list of bonuses. | See [[Permanent Bonuses]] or [[Permanent bonus table]] for a complete list of bonuses. | ||
{| class="wikitable mw-collapsible | {| class="wikitable mw-collapsible" style="margin-left: auto; margin-right: auto; border: none;" | ||
! style="width: 100%;" | High Utility Permanent Bonuses | ! style="width: 100%;" | High Utility Permanent Bonuses | ||
|- | |- | ||
Line 741: | Line 752: | ||
}} | }} | ||
}} | }} | ||
=== [[Rings]] === | === [[Rings]] === | ||
{{SpoilerBox|act=2|custom=[[Rings]].| | {{SpoilerBox|act=2|custom=[[Rings]].| | ||
Line 805: | Line 815: | ||
| order by = rarity_order | | order by = rarity_order | ||
| where = type = "Gloves" AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL | | where = type = "Gloves" AND rarity != "common" AND where_to_find like "%Act Three%" AND legacy IS NULL | ||
| format = table | |||
}} | |||
}} | |||
=== [[Weapons]] === | |||
{{SpoilerBox|act=3|custom=[[Weapons]].| | |||
{{#cargo_query: tables = weapons | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = type | |||
| where = | |||
rarity != "common" | |||
AND legacy IS NULL | |||
AND ( | |||
where_to_find like "%Rivington%" | |||
) | |||
| format = table | | format = table | ||
}} | }} | ||
}} | }} | ||
=== [[Shields]] === | |||
{{SpoilerBox|act=3|custom=[[Shields]].| | |||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| where = | |||
type = "Shields" | |||
AND rarity != "common" | |||
AND legacy IS NULL | |||
AND ( | |||
where_to_find like "%Rivington%" | |||
) | |||
| format = table | |||
}} | |||
}} | |||
=== [[Amulets]] === | |||
{{SpoilerBox|act=3|custom=[[Amulets]].| | |||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| where = | |||
type = "Amulets" | |||
AND rarity != "common" | |||
AND legacy IS NULL | |||
AND ( | |||
where_to_find like "%Rivington%" | |||
) | |||
| format = table | |||
}} | |||
}} | |||
=== [[Rings]] === | |||
{{SpoilerBox|act=3|custom=[[Rings]].| | |||
{{#cargo_query: tables = equipment | |||
| fields = CONCAT("[[File:", image, "|50px|link=", _pageName, "]]<br>[[", _pageName,"]]")=Item, special=Effects, where_to_find=Location | |||
| order by = rarity_order | |||
| where = | |||
type = "Rings" | |||
AND rarity != "common" | |||
AND legacy IS NULL | |||
AND ( | |||
where_to_find like "%Rivington%" | |||
) | |||
| format = table | |||
}} | |||
}} | |||
}} | }} |