8,756
edits
Trading: Difference between revisions
→Liquids: query needed to be updated because i edited commerce storage and also the weight matters now
(npcs have infinite water for selling (i have never tested the other way, so i specified selling only for now)) |
(→Liquids: query needed to be updated because i edited commerce storage and also the weight matters now) |
||
| Line 134: | Line 134: | ||
Water is not the only liquid that can be traded; unlike drams, they cannot be automatically poured. Liquids other than fresh water must be sold with the container as added value, so the actual profit is '''(Drams * 1D Value) + (Sold Container Profit - Replacement Container Cost)'''. For example, 64D of honey always sells for $128 ($2/D), but to sell it you first need to put it in a $3 {{favilink|Canteen}} which gets you a total of $131; if canteens sell for $3 then they cost $8.574 to buy with base stats, so the final profit is $122. | Water is not the only liquid that can be traded; unlike drams, they cannot be automatically poured. Liquids other than fresh water must be sold with the container as added value, so the actual profit is '''(Drams * 1D Value) + (Sold Container Profit - Replacement Container Cost)'''. For example, 64D of honey always sells for $128 ($2/D), but to sell it you first need to put it in a $3 {{favilink|Canteen}} which gets you a total of $131; if canteens sell for $3 then they cost $8.574 to buy with base stats, so the final profit is $122. | ||
Note that this table simply provides the minimum value for a container of the appropriate size, as factors like player trading stats cannot be accounted for. Liquids such as {{favilink|Asphalt}} and {{favilink|Putrescence}} | Note that this table simply provides the minimum value for a container of the appropriate size, as factors like player trading stats cannot be accounted for. Liquids with a trading value of $0 are not listed such as {{favilink|Asphalt}} and {{favilink|Putrescence}}. Liquids also have varying weights, so their value per pound will depend. | ||
{{#cargo_query:tables=Liquids=L, GeneralData=GD | {{#cargo_query:tables=Liquids=L, GeneralData=GD | ||
|join on = L.JoinKey = GD.JoinKey | |join on = L.JoinKey = GD.JoinKey | ||
| fields = CONCAT("{{favilink {{!}}",L._pageName, "}}")=Liquid, CONCAT( | | fields =CONCAT("{{favilink {{!}}",L._pageName, "}}")=Liquid, CONCAT(Commerce, '{{drams}}/', Weight, '{{pounds}}')=Value over Weight, CONCAT(Commerce/Weight)=Value<br/>($/Pound), | ||
CONCAT(4 * Commerce)= 4D, | |||
CONCAT(4 * Commerce) = | CONCAT(16 * Commerce) = 16D, | ||
CONCAT( | CONCAT(32 * Commerce) = 32D, | ||
CONCAT( | CONCAT(64 * Commerce) = 64D | ||
| where = L._pageNamespace = 0 AND Commerce > 0 AND L._pageName <> "Water" | | where = L._pageNamespace = 0 AND Commerce > 0 AND L._pageName <> "Water" | ||
| order by = Commerce ASC | | order by = Commerce ASC | ||