Module:Sandbox/User:Alsang/PotionList: Difference between revisions

Jump to navigation Jump to search
Browse history interactively
Content added Content deleted
(not saved progress in a while)
 
(seems to work, has input sanitation now)
Line 1: Line 1:
local p = {}
local p = {}
local param = require( 'Module:Paramtest' )



-- non dynamic module, no inputs
-- non dynamic module, no inputs
Line 8: Line 10:
'[[Category:Potions]]',
'[[Category:Potions]]',
'[[Uses facility::Standard Potion Station||Potent Potion Station]]',
'[[Uses facility::Standard Potion Station||Potent Potion Station]]',
'[[Uses item.Uses item::Brown Kelp]]', -- restrict for testing
'?Profession Level A = lvl',
'?Profession Level A = lvl',
'? #- = name',
'? #- = name',
Line 23: Line 24:
local results = mw.smw.ask(query)
local results = mw.smw.ask(query)
local results = p.calculateValues(results)
results = p.makeTableStrings(results)


-- actual output
--return p.displayTable(results)
return p.displayTable(results)
-- for testing
return '<pre>' ..mw.text.jsonEncode(results, mw.text.JSON_PRETTY).. '</pre>'
--return '<pre>' ..mw.text.jsonEncode(results, mw.text.JSON_PRETTY).. '</pre>'
end
end


-- do calculations and determine strings to go in cells
-- any values not directly returned by the query
function p.calculateValues(results)
function p.makeTableStrings(results)


-- iterate through potions
-- iterate through potions
Line 46: Line 49:
item.buy = 20
item.buy = 20
for j, reagent in ipairs(item.reagents) do
for j, reagent in ipairs(item.reagents) do
--shamelessley lifted from Module:Products
local shopPriceQuery = '[[:+]][[Sold item::' .. reagent .. ']]|?Shop buy price|mainlabel=' .. reagent
local shopPriceQuery = '[[:+]][[Sold item::' .. reagent .. ']]|?Shop buy price|mainlabel=' .. reagent
local shopPriceResult = mw.smw.ask(shopPriceQuery) or {}
local shopPriceResult = mw.smw.ask(shopPriceQuery) or {}
Line 58: Line 62:
end
end
item.profit = item.sell - item.buy
item.XP = item.brewXP + item.prepXP
item.KP = item.brewKP + item.prepKP
item.profitPerXP = item.profit / item.XP
-- sanitise data, set to 0 if its not there
-- 40 seconds to buy new supplies and travel and deposit and everything, per 12 potions
item.duration = item.prepDuration + item.brewDuration + 40/12
local lvl = item.lvl or 0
item.XPPerHour = item.XP / item.duration * 3600
local sell = item.sell or 0
item.KPPerHour = item.KP / item.duration * 3600 / 100
local brewXP = item.brewXP or 0
item.profitPerHour = item.profit / item.duration * 3600
local prepXP = item.prepXP or 0
local brewKP = item.brewKP or 0
local prepKP = item.prepKP or 0
local brewDuration = item.brewDuration or 0
local prepDuration = item.prepDuration or 0
-- direct values
item.profit = sell - item.buy
item.XP = brewXP + prepXP
item.KP = brewKP + prepKP
item.profitPerXP = math.floor(item.profit / item.XP * 100) / 100


-- 40 seconds to buy new supplies and travel and deposit and everything, per 12 potions
local batchSize = 12
local downtime = 40
item.duration = prepDuration + brewDuration + downtime/batchSize
item.potionPerHour = 1 / item.duration * 3600
-- properties per hour
item.XPPerHour = math.floor(item.XP * item.potionPerHour)
item.KPPerHour = math.floor(item.KP * item.potionPerHour) / 100
item.profitPerHour = math.floor(item.profit * item.potionPerHour)
-- currency strings for table
if param.has_content(item.buy) then
item.buyString = '|| {{Currency cell|' .. item.buy .. '}}'
else
item.buyString = '|| colspan="10" | Unknown'
end
if param.has_content(item.sell) then
item.sellString = '|| {{Currency cell|' .. item.sell .. '}}'
else
item.sellString = '|| colspan="10" | Unknown'
end
if param.has_content(item.buy) and param.has_content(item.sell) then
item.profitString = '|| {{Currency cell|' .. item.profit .. '}}'
else
item.profitString = '|| colspan="10" | Unknown'
end
if param.has_content(item.buy) and param.has_content(item.sell) and param.has_content(item.brewXP) and param.has_content(item.prepXP) then
item.profitPerXPString = '|| {{Currency cell|' .. item.profitPerXP .. '}}'
else
item.profitPerXPString = '|| colspan="10" | Unknown'
end
if param.has_content(item.buy) and param.has_content(item.sell) and param.has_content(item.brewDuration) and param.has_content(item.prepDuration) then
item.profitPerHourString = '|| {{Currency cell|' .. item.profitPerHour .. '}}'
else
item.profitPerHourString = '|| colspan="10" | Unknown'
end
-- KP/KP strings
if param.has_content(item.brewXP) and param.has_content(item.prepXP) then
item.XPString = '|| {{formatnum:' .. item.XP .. '}}'
else
item.XPString = '|| Unknown'
end
if param.has_content(item.brewKP) and param.has_content(item.prepKP) then
item.KPString = '|| {{formatnum:' .. item.KP .. '}}%'
else
item.KPString = '|| Unknown'
end
if param.has_content(item.brewXP) and param.has_content(item.prepXP) and param.has_content(item.brewDuration) and param.has_content(item.prepDuration) then
item.XPPerHourString = '|| {{formatnum:' .. item.XPPerHour .. '}}'
else
item.XPPerHourString = '|| Unknown'
end
if param.has_content(item.brewKP) and param.has_content(item.prepKP) and param.has_content(item.prepDuration) then
item.KPPerHourString = '|| {{formatnum:' .. item.KPPerHour .. '}}'
else
item.KPPerHourString = '|| Unknown'
end
end
end


Line 76: Line 154:
-- make the table
-- make the table
function p.displayTable(results)
function p.displayTable(results)
local currency = require('Module:Currency').parse
local out = {}
local out = {}
table.insert(out, 'Potions per hour assumes 40 seconds resupply between each batch of 12 potions.')
table.insert(out, '{| class="wikitable sortable"')
table.insert(out, '{| class="wikitable sortable"')
Line 87: Line 165:
table.insert(headerRow, '!! colspan="10" | Buy Value')
table.insert(headerRow, '!! colspan="10" | Buy Value')
table.insert(headerRow, '!! colspan="10" | Sell Value')
table.insert(headerRow, '!! colspan="10" | Sell Value')
table.insert(headerRow, '!! colspan="10" | Profit Value')
table.insert(headerRow, '!! colspan="10" | Profit')
table.insert(headerRow, '!! XP')
table.insert(headerRow, '!! XP')
table.insert(headerRow, '!! KP')
table.insert(headerRow, '!! KP')
Line 95: Line 173:
table.insert(headerRow, '!! colspan="10" | Profit/hr')
table.insert(headerRow, '!! colspan="10" | Profit/hr')
table.insert(out, table.concat(headerRow, ' '))
table.insert(out, table.concat(headerRow, ' '))
table.insert(headerRow, '|-')
for i,item in ipairs(results) do
table.insert(out, '|-')
local itemRow = {}
table.insert(itemRow, '| [[File:Alchemist small icon.png|15px]] ' .. item.lvl )
table.insert(itemRow, '|| {{plink|' .. item.name .. '}}')
table.insert(itemRow, '||')
for j, reagent in ipairs(item.reagents) do
table.insert(itemRow, '{{plink|' .. reagent .. '}}<br>')
end
table.insert(itemRow, item.buyString )
table.insert(itemRow, item.sellString )
table.insert(itemRow, item.profitString )
table.insert(itemRow, item.XPString )
table.insert(itemRow, item.KPString )
table.insert(itemRow, item.profitPerXPString )
table.insert(itemRow, item.XPPerHourString )
table.insert(itemRow, item.KPPerHourString )
table.insert(itemRow, item.profitPerHourString )
table.insert(out, table.concat(itemRow, ' '))
end
table.insert(out, '|}')
table.insert(out, '|}')
Retrieved from ‘https://brightershoreswiki.org/w/Module:Sandbox/User:Alsang/PotionList’