308
editsAd placeholder
User:Korgat: Difference between revisions
Jump to navigation
Jump to search
Devil's Fee
(Forge of the Nine) |
(Devil's Fee) |
||
| Line 348: | Line 348: | ||
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 "Devil's Fee" AND | |||
where_to_find NOT REGEXP 'Steel Watch Foundry' AND | where_to_find NOT REGEXP 'Steel Watch Foundry' AND | ||
where_to_find NOT REGEXP 'Undercity Ruins') | where_to_find NOT REGEXP 'Undercity Ruins') | ||
| Line 359: | Line 360: | ||
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 ' | where_to_find NOT REGEXP "Devil's Fee" AND | ||
where_to_find NOT REGEXP 'Steel Watch Foundry' AND | where_to_find NOT REGEXP 'Steel Watch Foundry' AND | ||
where_to_find NOT REGEXP 'Undercity Ruins') | where_to_find NOT REGEXP 'Undercity Ruins') | ||
| Line 408: | Line 409: | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Sorcerous Sundries]]")=Location, | fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Sorcerous Sundries]]")=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 "%Devil%Fee%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
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, armour_class=AC | |||
|tables=weapons; where = where_to_find like "%Devil%Fee%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Devil's Fee]]")=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 | ||