User:Korgat: Difference between revisions

User:Korgat (edit)

Revision as of 03:44, 14 February 2024

866 bytes added , 14 February

Rivington General

Korgat

308

edits

@@ Line 320: / Line 320: @@
-tables=equipment; where = where_to_find like "%Rivington%"
+tables=equipment; where = where_to_find like "%Rivington General%"
+    AND rarity != "common" AND legacy IS NULL;
+  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Rivington General]]")=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 "%Rivington General%"
+    AND rarity != "common" AND legacy IS NULL;
+  fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Rivington General]]")=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 "%Rivington%" AND
+              where_to_find NOT REGEXP 'Rivington General')
      AND rarity != "common" AND legacy IS NULL;
    fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Rivington]]")=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 "%Rivington%"
+|tables=weapons; where = (
+              where_to_find like "%Rivington%" AND
+              where_to_find NOT REGEXP 'Rivington General')
      AND rarity != "common" AND legacy IS NULL;
    fields=CONCAT("[[Act Three]]")=Act,CONCAT("[[Rivington]]")=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 "%Wyrm's Crossing%"
      AND rarity != "common" AND legacy IS NULL;