User:Korgat: Difference between revisions

User:Korgat (edit)

Revision as of 03:05, 14 February 2024

903 bytes added , 14 February

Lower City split

Korgat

308

edits

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