User:Korgat: Difference between revisions
Jump to navigation
Jump to search
(→Act One: Arron) |
(→Act One: Auntie Ethel and Volo) |
||
| Line 68: | Line 68: | ||
(where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | (where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | ||
where_to_find like "%Dammon%") AND | where_to_find like "%Dammon%") AND | ||
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> | |||
Sold by [[Auntie Ethel]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = ( | |||
(where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | |||
where_to_find like "%Auntie Ethel%") AND | |||
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 | |||
|tables=weapons; where = ( | |||
(where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | |||
where_to_find like "%Auntie Ethel%") AND | |||
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> | |||
Sold by [[Volo]] | |||
<hr> | |||
{{#cargo_compound_query: | |||
tables=equipment; where = ( | |||
(where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | |||
where_to_find like "%Volo%") AND | |||
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 | |||
|tables=weapons; where = ( | |||
(where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | |||
where_to_find like "%Volo%") AND | |||
where_to_find NOT REGEXP "Strange Ox" | where_to_find NOT REGEXP "Strange Ox" | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
| Line 81: | Line 119: | ||
((where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | ((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 "Dammon" AND | ||
where_to_find NOT REGEXP "Arron") OR | where_to_find NOT REGEXP "Arron" AND | ||
where_to_find NOT REGEXP "Auntie Ethel" AND | |||
where_to_find NOT REGEXP "Volo") OR | |||
where_to_find like "%Strange Ox%") | where_to_find like "%Strange Ox%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||
| Line 88: | Line 128: | ||
((where_to_find like "%Emerald Grove%" OR where_to_find like "%Druid Grove%") AND | ((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 "Dammon" AND | ||
where_to_find NOT REGEXP "Arron") OR | where_to_find NOT REGEXP "Arron" AND | ||
where_to_find NOT REGEXP "Auntie Ethel" AND | |||
where_to_find NOT REGEXP "Volo") OR | |||
where_to_find like "%Strange Ox%") | where_to_find like "%Strange Ox%") | ||
AND rarity != "common" AND legacy IS NULL; | AND rarity != "common" AND legacy IS NULL; | ||