Ad placeholder

User:Korgat: Difference between revisions

Jump to navigation Jump to search
Line 159: Line 159:
{{ImageLocation|Rivington General.jpg|Rivington General|The general store in [[Rivington]], run by a Dragonborn [[Exxvikyap]].<br>
{{ImageLocation|Rivington General.jpg|Rivington General|The general store in [[Rivington]], run by a Dragonborn [[Exxvikyap]].<br>
<hr>
<hr>
[[Rivington General]]
Sold by [[Exxvikyap]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (
tables=equipment; where = (
     where_to_find like "%Rivington General%" AND  
     where_to_find like "%Rivington General%" AND  
     where_to_find NOT REGEXP "Purchased" AND  
     where_to_find like "%Exxvikyap%" AND  
     where_to_find NOT REGEXP "Sold" AND
     (where_to_find like "%Purchased%" OR where_to_find like "%Sold%" OR where_to_find like "%bought%"))
    where_to_find NOT REGEXP "bought")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (
|tables=weapons; where = (
     where_to_find like "%Rivington General%" AND  
     where_to_find like "%Rivington General%" AND  
     where_to_find NOT REGEXP "Purchased" AND  
     where_to_find like "%Exxvikyap%" AND  
     where_to_find NOT REGEXP "Sold" AND
     (where_to_find like "%Purchased%" OR where_to_find like "%Sold%" OR where_to_find like "%bought%"))
    where_to_find NOT REGEXP "bought")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
Line 180: Line 178:
}}
}}
<hr>
<hr>
Sold by [[Exxvikyap]]
[[Rivington General]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (
tables=equipment; where = (
     where_to_find like "%Rivington General%" AND  
     where_to_find like "%Rivington General%" AND  
     where_to_find like "%Exxvikyap%" AND  
     where_to_find NOT REGEXP "Purchased" AND  
     (where_to_find like "%Purchased%" OR where_to_find like "%Sold%" OR where_to_find like "%bought%"))
     where_to_find NOT REGEXP "Sold" AND
    where_to_find NOT REGEXP "bought")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (
|tables=weapons; where = (
     where_to_find like "%Rivington General%" AND  
     where_to_find like "%Rivington General%" AND  
     where_to_find like "%Exxvikyap%" AND  
     where_to_find NOT REGEXP "Purchased" AND  
     (where_to_find like "%Purchased%" OR where_to_find like "%Sold%" OR where_to_find like "%bought%"))
     where_to_find NOT REGEXP "Sold" AND
    where_to_find NOT REGEXP "bought")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
Line 228: Line 228:
}}
}}
{{ImageLocation|Circus of the Last Days.jpg|Circus of the Last Days|An extraplanar circus which moves from plane to plane, "thrilling all" who stop by.<br>
{{ImageLocation|Circus of the Last Days.jpg|Circus of the Last Days|An extraplanar circus which moves from plane to plane, "thrilling all" who stop by.<br>
<hr>
Sold by [[Popper]]
<hr>
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Circus of the Last Days%" AND where_to_find like "%Popper%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Circus of the Last Days%" AND where_to_find like "%Popper%")
    AND rarity != "common" AND legacy IS NULL;
  fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
|format=list
|delimiter=<br>
}}
<hr>
<hr>
[[Circus of the Last Days]]
[[Circus of the Last Days]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = where_to_find like "%Circus of the Last Days%"
tables=equipment; where = (where_to_find like "%Circus of the Last Days%" AND where_to_find NOT REGEXP "Popper")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = where_to_find like "%Circus of the Last Days%"
|tables=weapons; where = (where_to_find like "%Circus of the Last Days%" AND where_to_find NOT REGEXP "Popper")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
Line 275: Line 288:
{{ImageLocation|Wyrm's Crossing Side.jpg|Wyrm's Crossing|Sits between [[Rivington]] and the [[Wyrm's Rock Fortress]], and must be crossed to enter the [[Lower City|City]].<br>
{{ImageLocation|Wyrm's Crossing Side.jpg|Wyrm's Crossing|Sits between [[Rivington]] and the [[Wyrm's Rock Fortress]], and must be crossed to enter the [[Lower City|City]].<br>
<hr>
<hr>
[[Wyrm's Crossing]]
Sold by [[Entharl Danthelon]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find NOT REGEXP "Entharl Danthelon")
tables=equipment; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find like "%Entharl Danthelon%")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find NOT REGEXP "Entharl Danthelon")
|tables=weapons; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find like "%Entharl Danthelon%")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
Line 288: Line 301:
}}
}}
<hr>
<hr>
Sold by [[Entharl Danthelon]]
[[Wyrm's Crossing]]
<hr>
<hr>
{{#cargo_compound_query:
{{#cargo_compound_query:
tables=equipment; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find like "%Entharl Danthelon%")
tables=equipment; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find NOT REGEXP "Entharl Danthelon")
     AND rarity != "common" AND legacy IS NULL;  
     AND rarity != "common" AND legacy IS NULL;  
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[",_pageName,"]]")=Item;order by=type
|tables=weapons; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find like "%Entharl Danthelon%")
|tables=weapons; where = (where_to_find like "%Wyrm's Crossing%" AND where_to_find NOT REGEXP "Entharl Danthelon")
     AND rarity != "common" AND legacy IS NULL;
     AND rarity != "common" AND legacy IS NULL;
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
   fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type
Line 302: Line 315:
}}
}}
{{ImageLocation|Wyrm's Rock Fortress.jpg|Wyrm's Rock Fortress|Connected to the south by [[Wyrm's Crossing]], and the north by the [[Lower City]].<br>
{{ImageLocation|Wyrm's Rock Fortress.jpg|Wyrm's Rock Fortress|Connected to the south by [[Wyrm's Crossing]], and the north by the [[Lower City]].<br>
<hr>
Sold by [[Arkleia Oloril]]
<hr>
<i>No special equipment</i>
<hr>
<hr>
[[Wyrm's Rock Fortress]]
[[Wyrm's Rock Fortress]]
308
edits

Navigation menu