308
editsMore actions
no edit summary
No edit summary |
No edit summary |
||
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;order by=type | ||
|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;order by=type | ||
|format=list | |format=list | ||
|delimiter=<br> | |delimiter=<br> | ||
}} | }} | ||
}} | }} | ||
{{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 32: | Line 26: | ||
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;order by=type | ||
|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;order by=type | ||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
<hr> | |||
{{ImageLocation|Silvanus%27_Grove_SW.png|Emerald Grove|The Emerald Grove, also known as Silvanus' Grove and Druid's Grove.<br> | |||
<hr> | |||
[[Druid Grove]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") | |||
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 "%Emerald Grove%" OR where_to_find like "%Druid Grove%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|The Risen Road.jpg|The Risen Road|'''The Risen Road''' is a long stretch of road that connects [[Elturel]] and [[Baldur's Gate]].<br> | |||
<hr> | |||
[[The Risen Road]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%The Risen Road%" | |||
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 "%The Risen Road%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
}} | |||
{{ImageLocation|Forest.jpg|Forest|Forest is a sub-area of the Wilderness. It is found west of the Emerald Grove.<br> | |||
<hr> | |||
[[Forest]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Forest%" | |||
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 "%Forest%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
[[Owlbear Nest]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Owlbear Nest%" | |||
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 "%Owlbear Nest%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |format=list | ||
|delimiter=<br> | |delimiter=<br> | ||
}} | }} | ||
}} | }} | ||
<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 protected by Arcane Cannons|tall=y}} | ||
Line 98: | Line 150: | ||
|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("[[Wilderness]]")=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("[[Wilderness]]")=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 109: | Line 161: | ||
|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("[[Wilderness]]")=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("[[Wilderness]]")=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 120: | Line 172: | ||
|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("[[Wilderness]]")=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("[[Wilderness]]")=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 "%Owlbear Nest%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Forest]]")=Act,CONCAT("[[Owlbear Nest]]")=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 "%Forest%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Forest]]")=Act,CONCAT("[[Owlbear Nest]]")=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 "%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; |