Sacred well: Difference between revisions

Jump to navigation Jump to search
98 bytes added ,  16:14, 7 October 2021
m
Update to use new Cargo table
(Updated by egocarib with game version 2.0.201.114 using QBE v1.0rc2)
m (Update to use new Cargo table)
Line 29: Line 29:
To gain the achivement [[Donation Level: Kasaphescence]], the player must donate an item worth at least 200 reputation. This means that the item donated must be at least 2000 [[commerce]]. Below is a list of all possible items that can meet this requirement.
To gain the achivement [[Donation Level: Kasaphescence]], the player must donate an item worth at least 200 reputation. This means that the item donated must be at least 2000 [[commerce]]. Below is a list of all possible items that can meet this requirement.


{{#cargo_query:table=GeneralData,ItemsTable|join on=GeneralData._pageName=ItemsTable._pageName|fields=GeneralData._pageName=Page|where=GeneralData.Commerce>=2000 AND GeneralData._pageNamespace='0' AND Bits <> ''|format=ul}}
{{#cargo_query:
| tables  = GeneralData=GD,ArtifactData=AD
| join on = GD.JoinKey=AD.JoinKey
| fields = CONCAT('{{(}}favilink id{{!}}',GD.ObjectID,'{{)}}')=Page
| where   = GD.Commerce>=2000 AND GD._pageNamespace='0' AND AD.Bits <> ''
| format = ul
}}


The type of [[mods]] that the item has also affects this. As an example, since [[jewel-encrusted]] multiplies the base [[commerce]] value by 5, a jewel-encrusted artifact with a base commerce of at least 400 will also grant this achievement.
The type of [[mods]] that the item has also affects this. As an example, since [[jewel-encrusted]] multiplies the base [[commerce]] value by 5, a jewel-encrusted artifact with a base commerce of at least 400 will also grant this achievement.


===List of mods by their value multiplier===
===List of mods by their value multiplier===
{{#cargo_query:table=Mods|fields=_pageName=Mod,Value=Multiplier|where=_pageNamespace='0'|order by=Multiplier DESC}}
{{#cargo_query:
| table=Mods
| fields=CONCAT('[[',_pageName,'{{!}}',DisplayName,']]')=Mod,
          Value=Multiplier
| where=_pageNamespace='0'
| order by=Multiplier DESC
}}

Navigation menu