User:Korgat: Difference between revisions

User:Korgat (edit)

Revision as of 03:12, 14 February 2024

910 bytes added , 14 February

Lower City Sewers

Korgat

308

edits

@@ Line 344: / Line 344: @@
 |tables=equipment; where = (
                where_to_find like "%Lower City%" AND
+              where_to_find NOT REGEXP 'Lower City Sewers' AND
+              where_to_find NOT REGEXP 'Stormshore Tabernacle' AND
+              where_to_find NOT REGEXP 'Sorcerous Sundries' AND
                where_to_find NOT REGEXP 'Steel Watch Foundry' AND
-              where_to_find NOT REGEXP 'Sorcerous Sundries' AND
                where_to_find NOT REGEXP 'Undercity Ruins')
      AND rarity != "common" AND legacy IS NULL;
@@ Line 353: / Line 355: @@
 |tables=weapons; where = (
                where_to_find like "%Lower City%" AND
+              where_to_find NOT REGEXP 'Lower City Sewers' AND
                where_to_find NOT REGEXP 'Stormshore Tabernacle' AND
                where_to_find NOT REGEXP 'Sorcerous Sundries' AND
@@ Line 362: / Line 365: @@
      special=Effects, where_to_find=Where To Find, type=Type, damage=Dmg
+|tables=equipment; where = where_to_find like "%Lower City Sewers%"
+    AND rarity != "common" AND legacy IS NULL;
+  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City Sewers]]")=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 "%Lower City Sewers%"
+    AND rarity != "common" AND legacy IS NULL;
+  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Lower City Sewers]]")=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 "%Stormshore Tabernacle%"
      AND rarity != "common" AND legacy IS NULL;