User:Korgat: Difference between revisions
Jump to navigation
Jump to search
| Line 417: | Line 417: | ||
}} | }} | ||
{{ImageLocation|Lower City Sewers North.jpg|Lower City Sewers|Entrances include manhole covers in the city streets, and inside specific buildings.<br> | {{ImageLocation|Lower City Sewers North.jpg|Lower City Sewers|Entrances include manhole covers in the city streets, and inside specific buildings.<br> | ||
<hr> | |||
Sold by [[Severn]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Severn%" | |||
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 "%Severn%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
Sold by [[Sticky Dondo]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Sticky Dondo%" | |||
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 "%Sticky Dondo%" | |||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
Sold by [[Voiceless Penitent Bareki]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = where_to_find like "%Bareki%" | |||
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 "%Bareki%" | |||
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> | ||
[[Lower City Sewers]] | [[Lower City Sewers]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "%Lower City Sewers%" | tables=equipment; where = ( | ||
where_to_find like "%Lower City Sewers%" AND | |||
where_to_find NOT REGEXP "Severn" AND | |||
where_to_find NOT REGEXP "Sticky Dondo" AND | |||
where_to_find NOT REGEXP "Bareki") | |||
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 "%Lower City Sewers%" | |tables=weapons; where = ( | ||
where_to_find like "%Lower City Sewers%" AND | |||
where_to_find NOT REGEXP "Severn" AND | |||
where_to_find NOT REGEXP "Sticky Dondo" AND | |||
where_to_find NOT REGEXP "Bareki") | |||
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 434: | Line 481: | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = where_to_find like "%Undercity Ruins%" | tables=equipment; where = ( | ||
where_to_find like "%Undercity Ruins%" AND | |||
where_to_find NOT REGEXP "Severn" AND | |||
where_to_find NOT REGEXP "Sticky Dondo" AND | |||
where_to_find NOT REGEXP "Bareki") | |||
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 "%Undercity Ruins%" | |tables=weapons; where = ( | ||
where_to_find like "%Undercity Ruins%" AND | |||
where_to_find NOT REGEXP "Severn" AND | |||
where_to_find NOT REGEXP "Sticky Dondo" AND | |||
where_to_find NOT REGEXP "Bareki") | |||
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 | ||