User:Korgat: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 4: | Line 4: | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "%Nautiloid Wreck%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Nautiloid Wreck]]")=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 "%Nautiloid Wreck%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Nautiloid Wreck]]")=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 "%Ruined Battlefield%" | |tables=equipment; where = where_to_find like "%Ravaged Beach%" | ||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Ravaged Beach]]")=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 "%Ravaged Beach%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Ravaged Beach]]")=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 "%Overgrown Ruins%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Overgrown Ruins]]")=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 "%Overgrown Ruins%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Overgrown Ruins]]")=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 "%Emerald Grove%" OR where_to_find like "%Druid Grove%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Druid Grove]]")=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 "%Emerald Grove%" OR where_to_find like "%Druid Grove%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Druid Grove]]")=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 Risen Road%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[The Risen Road]]")=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 Risen Road%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[The Risen Road]]")=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 "%Forest%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Forest]]")=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("[[Act One]]")=Act,CONCAT("[[Forest]]")=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%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Blighted Village]]")=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 "%Blighted Village%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Blighted Village]]")=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 "%Sunlit Wetlands%" OR where_to_find like "%Putrid Bog%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Sunlit Wetlands]]")=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 "%Sunlit Wetlands%" OR where_to_find like "%Putrid Bog%") | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Sunlit Wetlands]]")=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 "%Goblin Camp%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Goblin Camp]]")=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 "%Goblin Camp%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Goblin Camp]]")=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 "%Waukeen's Rest%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Waukeen's Rest]]")=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 "%Waukeen's Rest%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Waukeen's Rest]]")=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 "%Mountain Pass%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Mountain Pass]]")=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 "%Mountain Pass%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Mountain Pass]]")=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 "%Underdark%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Underdark]]")=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 "%Underdark%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Underdark]]")=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 "%Grymforge%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Grymforge]]")=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 "%Grymforge%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Grymforge]]")=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 "%Rosymorn Monastery%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Rosymorn Monastery]]")=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 "%Rosymorn Monastery%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act One]]")=Act,CONCAT("[[Rosymorn Monastery]]")=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 "%Ruined Battlefield%" | |||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Ruined Battlefield]]")=Location, | fields=CONCAT("[[Act Two]]")=Act,CONCAT("[[Ruined Battlefield]]")=Location, | ||