308
editsMore actions
no edit summary
No edit summary |
No edit summary |
||
| Line 252: | Line 252: | ||
}} | }} | ||
}} | }} | ||
<br> | |||
{{ImageLocation|Lower City.jpg|Lower City|The Lower City is accessed after passing through [[Wyrm's Rock Fortress]].<br> | |||
<hr> | |||
[[Lower City]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = ( | |||
where_to_find like "%Lower City%" AND | |||
where_to_find NOT REGEXP 'Lower City Sewers' AND | |||
where_to_find NOT REGEXP 'Forge of the Nine' AND | |||
where_to_find NOT REGEXP 'Stormshore Tabernacle' AND | |||
where_to_find NOT REGEXP 'Stormshore Armoury' AND | |||
where_to_find NOT REGEXP 'Sorcerous Sundries' AND | |||
where_to_find NOT REGEXP 'Wine Festival' AND | |||
where_to_find NOT REGEXP "Devil's Fee" AND | |||
where_to_find NOT REGEXP "Philgrave's Mansion" AND | |||
where_to_find NOT REGEXP 'Steel Watch Foundry' AND | |||
where_to_find NOT REGEXP 'Undercity Ruins') | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = ( | |||
where_to_find like "%Lower City%" AND | |||
where_to_find NOT REGEXP 'Lower City Sewers' AND | |||
where_to_find NOT REGEXP 'Forge of the Nine' AND | |||
where_to_find NOT REGEXP 'Stormshore Tabernacle' AND | |||
where_to_find NOT REGEXP 'Stormshore Armoury' AND | |||
where_to_find NOT REGEXP 'Sorcerous Sundries' AND | |||
where_to_find NOT REGEXP 'Wine Festival' AND | |||
where_to_find NOT REGEXP "Devil's Fee" AND | |||
where_to_find NOT REGEXP "Philgrave's Mansion" AND | |||
where_to_find NOT REGEXP 'Steel Watch Foundry' AND | |||
where_to_find NOT REGEXP 'Undercity Ruins') | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|Stormshore Armoury.jpg|Stormshore Armoury|An outdoor smithy with a glowing red hot furnace in the back corner.<br> | |||
<hr> | |||
[[Gloomy Fentonson]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Gloomy Fentonson%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Gloomy Fentonson%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
[[Fytz|Fytz The Firecracker]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Fytz%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type | |||
|tables=weapons; where = (where_to_find like "%Stormshore Armoury%" AND where_to_find like "%Fytz%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
= Equipment By Act and Region = | = Equipment By Act and Region = | ||
| Line 665: | Line 730: | ||
where_to_find NOT REGEXP 'Forge of the Nine' AND | where_to_find NOT REGEXP 'Forge of the Nine' AND | ||
where_to_find NOT REGEXP 'Stormshore Tabernacle' AND | where_to_find NOT REGEXP 'Stormshore Tabernacle' AND | ||
where_to_find NOT REGEXP 'Stormshore Armoury' AND | |||
where_to_find NOT REGEXP 'Sorcerous Sundries' AND | where_to_find NOT REGEXP 'Sorcerous Sundries' AND | ||
where_to_find NOT REGEXP 'Wine Festival' AND | where_to_find NOT REGEXP 'Wine Festival' AND | ||
where_to_find NOT REGEXP "Devil's Fee" AND | where_to_find NOT REGEXP "Devil's Fee" AND | ||
where_to_find NOT REGEXP "The Counting House" AND | |||
where_to_find NOT REGEXP "Philgrave's Mansion" AND | where_to_find NOT REGEXP "Philgrave's Mansion" AND | ||
where_to_find NOT REGEXP 'Steel Watch Foundry' AND | where_to_find NOT REGEXP 'Steel Watch Foundry' AND | ||
| Line 680: | Line 747: | ||
where_to_find NOT REGEXP 'Forge of the Nine' AND | where_to_find NOT REGEXP 'Forge of the Nine' AND | ||
where_to_find NOT REGEXP 'Stormshore Tabernacle' AND | where_to_find NOT REGEXP 'Stormshore Tabernacle' AND | ||
where_to_find NOT REGEXP 'Stormshore Armoury' AND | |||
where_to_find NOT REGEXP 'Sorcerous Sundries' AND | where_to_find NOT REGEXP 'Sorcerous Sundries' AND | ||
where_to_find NOT REGEXP 'Wine Festival' AND | where_to_find NOT REGEXP 'Wine Festival' AND | ||
where_to_find NOT REGEXP "Devil's Fee" AND | where_to_find NOT REGEXP "Devil's Fee" AND | ||
where_to_find NOT REGEXP "The Counting House" AND | |||
where_to_find NOT REGEXP "Philgrave's Mansion" AND | where_to_find NOT REGEXP "Philgrave's Mansion" AND | ||
where_to_find NOT REGEXP 'Steel Watch Foundry' AND | where_to_find NOT REGEXP 'Steel Watch Foundry' AND | ||
| Line 721: | Line 790: | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Stormshore Tabernacle]]")=Location, | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Stormshore Tabernacle]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | |||
|tables=equipment; where = where_to_find like "%Stormshore Armoury%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[Stormshore Armoury]]")=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 "%Stormshore Armoury%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[Stormshore Armoury]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||
| Line 754: | Line 834: | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Devil's Fee]]")=Location, | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Devil's Fee]]")=Location, | ||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | |||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | |||
|tables=equipment; where = where_to_find like "%The Counting House%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[The Counting House]]")=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 "%The Counting House%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Lower City]]")=Act,CONCAT("[[The Counting House]]")=Location, | |||
CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item, | ||
special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg | ||