User:Korgat: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 502: | Line 502: | ||
}} | }} | ||
{{ImageLocation|Sorcerous Sundries.jpg|Sorcerous Sundries|A large magical marketplace, and home to the wizard [[Lorroakan]]<br> | {{ImageLocation|Sorcerous Sundries.jpg|Sorcerous Sundries|A large magical marketplace, and home to the wizard [[Lorroakan]]<br> | ||
<hr> | |||
Sold by [[Lorroakan's Projection]] (or [[Rolan]]): | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = ( | |||
where_to_find like "%Sorcerous Sundries%" AND | |||
where_to_find like "%Sold%" AND | |||
where_to_find like "%Lorroakan's Projection%") | |||
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 "%Sorcerous Sundries%" AND | |||
where_to_find like "%Sold%" AND | |||
where_to_find like "%Lorroakan's Projection%") | |||
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> | ||
[[Sorcerous Sundries]] | [[Sorcerous Sundries]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "%Sorcerous Sundries%" | tables=equipment; where = ( | ||
where_to_find like "%Sorcerous Sundries%" AND | |||
where_to_find NOT REGEXP "Sold") | |||
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 "%Sorcerous Sundries%" | |tables=weapons; where = ( | ||
where_to_find like "%Sorcerous Sundries%" AND | |||
where_to_find NOT REGEXP "Sold") | |||
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 | ||