308
editsAd placeholder
User:Korgat: Difference between revisions
Jump to navigation
Jump to search
→Act One: Arron
(→Act One: Arron) |
|||
| Line 37: | Line 37: | ||
{{ImageLocation|Silvanus%27_Grove_SW.png|Emerald Grove|The Emerald Grove, also known as Silvanus' Grove and Druid's Grove.<br> | {{ImageLocation|Silvanus%27_Grove_SW.png|Emerald Grove|The Emerald Grove, also known as Silvanus' Grove and Druid's Grove.<br> | ||
<hr> | <hr> | ||
[[ | Sold by [[Arron]] | ||
<hr> | <hr> | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
tables=equipment; where = ( | tables=equipment; where = ( | ||
(where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | |||
where_to_find | where_to_find like "%Arron%") AND | ||
where_to_find | where_to_find NOT REGEXP "Strange Ox" | ||
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 "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | |||
where_to_find | where_to_find like "%Arron%") AND | ||
where_to_find | where_to_find NOT REGEXP "Strange Ox" | ||
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 69: | Line 69: | ||
where_to_find like "%Dammon%") AND | where_to_find like "%Dammon%") AND | ||
where_to_find NOT REGEXP "Strange Ox" | where_to_find NOT REGEXP "Strange Ox" | ||
AND rarity != "common" AND legacy IS NULL; | |||
fields=CONCAT("[[File:", image, "|25px|link=", _pageName, "]][[", _pageName,"]]")=Item;order by=type | |||
|format=list | |||
|delimiter=<br> | |||
}} | |||
<hr> | |||
[[Druid Grove]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = ( | |||
((where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | |||
where_to_find NOT REGEXP "Dammon" AND | |||
where_to_find NOT REGEXP "Arron") OR | |||
where_to_find like "%Strange Ox%") | |||
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 "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | |||
where_to_find NOT REGEXP "Dammon" AND | |||
where_to_find NOT REGEXP "Arron") OR | |||
where_to_find like "%Strange Ox%") | |||
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 | ||