Editing User:Korgat
Jump to navigation
Jump to search
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 11: | Line 11: | ||
tables=equipment; where = (where_to_find like "%Nautiloid%" AND where_to_find NOT REGEXP "Underdark") | tables=equipment; where = (where_to_find like "%Nautiloid%" AND where_to_find NOT REGEXP "Underdark") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item | ||
|tables=weapons; where = (where_to_find like "%Nautiloid%" AND where_to_find NOT REGEXP "Underdark") | |tables=weapons; where = (where_to_find like "%Nautiloid%" AND where_to_find NOT REGEXP "Underdark") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item | ||
|format=list | |format=list | ||
|delimiter=<br> | |delimiter=<br> | ||
}} | }} | ||
}} | |||
{{ImageLocation|Ravaged_Beach.jpg|Ravaged Beach|Located on the bank of the [[River Chionthar]], and dominated by the wreck of a [[nautiloid]].<br> | |||
<hr> | |||
[[Nautiloid Wreck]] | |||
<hr> | |||
<i>No notable equipment</i> | |||
}} | }} | ||
{{ImageLocation|Overgrown_Ruins.png|Overgrown Ruins|The remnants of what appears to have once been a chapel, eroded by time.<br> | {{ImageLocation|Overgrown_Ruins.png|Overgrown Ruins|The remnants of what appears to have once been a chapel, eroded by time.<br> | ||
Line 26: | Line 32: | ||
tables=equipment; where = where_to_find like "%Dank Crypt%" | tables=equipment; where = where_to_find like "%Dank Crypt%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item | ||
|tables=weapons; where = where_to_find like "%Dank Crypt%" | |tables=weapons; where = where_to_find like "%Dank Crypt%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item | fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item | ||
|format=list | |format=list | ||
|delimiter=<br> | |delimiter=<br> | ||
}} | }} | ||
}} | }} | ||
<br> | |||
{{ImageLocation|Arcane Tower.jpg|Arcane Tower|An isolated wizard tower protected by Arcane Cannons|tall=y}} | |||
{{ImageLocation|Arcane Tower.jpg|Arcane Tower|An isolated wizard tower | |||
|tall=y}} | |||
== [[Act Two]] == | == [[Act Two]] == | ||
Line 203: | Line 51: | ||
== [[Act Three]] == | == [[Act Three]] == | ||
{{ImageLocation|Open Hand Temple Front.jpg|Open Hand Temple|A temple dedicated to Ilmater, currently grieving the loss of their head priest<br> | |||
[[Open Hand Temple Cellar]]<br> | |||
[[Under Temple Cave Area]] | |||
{{ImageLocation|Open Hand Temple.jpg|Open Hand Temple|A temple dedicated to Ilmater, currently grieving the loss of their head priest | |||
[[Open Hand Temple | |||
}} | }} | ||
Line 830: | Line 98: | ||
|tables=equipment; where = (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") | |tables=equipment; where = (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Druid Grove]]")=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, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") | |tables=weapons; where = (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Druid Grove]]")=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 841: | Line 109: | ||
|tables=equipment; where = where_to_find like "%The Risen Road%" | |tables=equipment; where = where_to_find like "%The Risen Road%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[The Risen Road]]")=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, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "%The Risen Road%" | |tables=weapons; where = where_to_find like "%The Risen Road%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[The Risen Road]]")=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 852: | Line 120: | ||
|tables=equipment; where = where_to_find like "%Forest%" | |tables=equipment; where = where_to_find like "%Forest%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Forest]]")=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, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "%Forest%" | |tables=weapons; where = where_to_find like "%Forest%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Forest]]")=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 | ||
|tables=equipment; where = where_to_find like "%Blighted Village%" | |tables=equipment; where = where_to_find like "%Blighted Village%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
Line 1,094: | Line 351: | ||
tables=equipment; where = where_to_find like "%Rivington General%" | tables=equipment; where = where_to_find like "%Rivington General%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Rivington General]]")=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, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "%Rivington General%" | |tables=weapons; where = where_to_find like "%Rivington General%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Rivington General]]")=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 | ||
|tables=equipment; where = | |tables=equipment; where = where_to_find like "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Requisitioned Barn]]")=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, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = | |tables=weapons; where = where_to_find like "%Ferg Drogher%" OR where_to_find like "%Mattis%Rivington%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Requisitioned Barn]]")=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 1,116: | Line 373: | ||
|tables=equipment; where = where_to_find like "%Circus of the Last Days%" | |tables=equipment; where = where_to_find like "%Circus of the Last Days%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Circus of the Last Days]]")=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, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "%Circus of the Last Days%" | |tables=weapons; where = where_to_find like "%Circus of the Last Days%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Circus of the Last Days]]")=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 | ||
|tables=equipment; where = where_to_find like "%Angleiron's Cellar%" | |tables=equipment; where = where_to_find like "%Angleiron's Cellar%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Angleiron's Cellar]]")=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, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "%Angleiron's Cellar%" | |tables=weapons; where = where_to_find like "%Angleiron's Cellar%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Angleiron's Cellar]]")=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 1,153: | Line 399: | ||
where_to_find NOT REGEXP "Mattis" AND | where_to_find NOT REGEXP "Mattis" AND | ||
where_to_find NOT REGEXP "Circus of the Last Days" AND | where_to_find NOT REGEXP "Circus of the Last Days" AND | ||
where_to_find NOT REGEXP "Angleiron's Cellar") | where_to_find NOT REGEXP "Angleiron's Cellar") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Rivington]]")=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, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
Line 1,165: | Line 410: | ||
where_to_find NOT REGEXP "Mattis" AND | where_to_find NOT REGEXP "Mattis" AND | ||
where_to_find NOT REGEXP "Circus of the Last Days" AND | where_to_find NOT REGEXP "Circus of the Last Days" AND | ||
where_to_find NOT REGEXP "Angleiron's Cellar") | where_to_find NOT REGEXP "Angleiron's Cellar") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Rivington]]")=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 1,183: | Line 427: | ||
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 = ( | |tables=equipment; where = ( | ||
where_to_find like "%Lower City%" AND | where_to_find like "%Lower City%" AND | ||
where_to_find NOT REGEXP 'Lower City Sewers' 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 '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 '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 "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 1,215: | Line 445: | ||
where_to_find like "%Lower City%" AND | where_to_find like "%Lower City%" AND | ||
where_to_find NOT REGEXP 'Lower City Sewers' 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 '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 '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 "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 1,261: | Line 488: | ||
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, | 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 1,297: | Line 513: | ||
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 "%Devil%Fee%" | |tables=equipment; where = where_to_find like "%Devil%Fee%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
Line 1,319: | Line 524: | ||
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 "% | |tables=equipment; where = where_to_find like "%Philgrave%s Mansion%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Philgrave's Mansion]]")=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, armour_class=AC | special=Effects, where_to_find=Where To Find, type=Type, armour_class=AC | ||
|tables=weapons; where = where_to_find like "% | |tables=weapons; where = where_to_find like "%Philgrave%s Mansion%" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[ | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Philgrave's Mansion]]")=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 1,994: | Line 1,199: | ||
--> | --> | ||
[[Template:ImageLocation]] | [[Template:ImageLocation]] | ||
{{Gameplay mechanics}} | {{Gameplay mechanics}} |