308
editsAd placeholder
User:Korgat: Difference between revisions
Jump to navigation
Jump to search
Requisitioned Barn
(Ferg Drogher) |
(Requisitioned Barn) |
||
| Line 331: | Line 331: | ||
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 "%Ferg Drogher%" | |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("[[Act Three]]")=Act,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 = where_to_find like "%Ferg Drogher%" | |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("[[Act Three]]")=Act,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 357: | Line 357: | ||
where_to_find NOT REGEXP "Rivington General" AND | where_to_find NOT REGEXP "Rivington General" AND | ||
where_to_find NOT REGEXP "Ferg Drogher" AND | where_to_find NOT REGEXP "Ferg Drogher" AND | ||
where_to_find NOT REGEXP "Mattis" 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; | ||
| Line 366: | Line 367: | ||
where_to_find NOT REGEXP "Rivington General" AND | where_to_find NOT REGEXP "Rivington General" AND | ||
where_to_find NOT REGEXP "Ferg Drogher" AND | where_to_find NOT REGEXP "Ferg Drogher" AND | ||
where_to_find NOT REGEXP "Mattis" 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; | ||