Ad placeholder

User:Korgat: Difference between revisions

Jump to navigation Jump to search
Philgrave's Mansion
(Wine Festival)
(Philgrave's Mansion)
Line 350: Line 350:
               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 '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 364: Line 365:
               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 '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 434: Line 436:
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Devil's Fee]]")=Location,
   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, damage=Dmg
|tables=equipment; where = where_to_find like "%Philgrave%s Mansion%"
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Philgrave's Mansion]]")=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 "%Philgrave%s Mansion%"
    AND rarity != "common" AND legacy IS NULL;
  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
308
edits

Navigation menu