8,756
edits
Water ritual/Gifts by cost: Difference between revisions
no edit summary
(Created page with "== Tinker Recipes == The Daughters of Exile and the Baruthrumites can teach tinkerable items. {{#cargo_query: tables=ArtifactData=AD, GeneralData=GD |join on = AD.Obje...") |
No edit summary |
||
| Line 1: | Line 1: | ||
== Tinker Recipes == | == Tinker Recipes == | ||
The [[Daughters of Exile]] and the [[ | The [[Daughters of Exile]] and the [[Barathrumites]] can teach tinkerable items. | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=ArtifactData=AD, GeneralData=GD | tables=ArtifactData=AD, GeneralData=GD | ||
|join on = AD.ObjectID=GD.ObjectID | |join on = AD.ObjectID=GD.ObjectID | ||
|fields=CONCAT('[[',AD._pageName,'{{!}}',GD.PlainName,']]')=Item, FLOOR(GD.Tier/3* | |fields=CONCAT('[[',AD._pageName,'{{!}}',GD.PlainName,']]')=Item, FLOOR(GD.Tier/3*50)=Reputation Cost,Categories | ||
|where=CanBuild=1 | |where=CanBuild=1 | ||
|limit = 10 | |limit = 10 | ||
| Line 11: | Line 11: | ||
{{#cargo_query: | {{#cargo_query: | ||
tables=Mods=M | tables=Mods=M | ||
|fields=_pageName=Mod, FLOOR(TinkerTierNum/3* | |fields=_pageName=Mod, FLOOR(TinkerTierNum/3*50)=Reputation Cost,Type | ||
|where=Tinkerable=1 | |where=Tinkerable=1 | ||
|limit = 10 | |limit = 10 | ||
| Line 25: | Line 25: | ||
THEN 5 | THEN 5 | ||
ELSE FLOOR(Commerce/4) | ELSE FLOOR(Commerce/4) | ||
END)=Reputation Cost | END)=Reputation Cost,Categories | ||
|where=Commerce >0 AND Tier >=0 | |where=Commerce >0 AND Tier >=0 | ||
|limit=10 | |limit=10 | ||
}} | }} | ||