×
Create a new article
Write your page title here:
We currently have 22 articles on The Grand Library of Hylia. Type your article name above or click on one of the titles below and start writing!



The Grand Library of Hylia

Module:RandomCargoRecord: Difference between revisions

No edit summary
No edit summary
Line 45: Line 45:
offset = countOffset
offset = countOffset
}
}
   
local results = cargo.query(tableName, queryFields, args)
local results = cargo.query(tableName, queryFields, args)
local getExcerpt = require('Module:Excerpt').main
     for r = 1, #results do
     for r = 1, #results do
         local result = results[r]
         local result = results[r]
         return string.format("[[%s]] {{Excerpt|%s}}", result.link, result.link)
local excerptArgs = {
[1] = result.link
}
local excerptResult = getExcerpt(excerptArgs)
         return string.format("[[%s]] $s", result.link, excerptResult)
     end
     end
end
end


return p
return p

Revision as of 07:47, 27 December 2023

Documentation for this module may be created at Module:RandomCargoRecord/doc

local p = {}
local cargo = mw.ext.cargo

function p.randomCargoRecord(frame)
    local getArgs = require('Module:Arguments').getArgs
    local args = getArgs(frame);
    local tableName = args[1]

    if tableName == nil or tableName == "" then
        hasErrors = true
        return string.format("<code>tableName</code> parameter is required")
    end

	local countFields = 'COUNT(*)=total'
	local countArgs = {
		format = 'list',
		limit = 1
	}
	local countResults = cargo.query(tableName, countFields, countArgs)
	local total = 0
	for r = 1, #countResults do
        local result = countResults[r]
		total = result.total
    end

	if total == nil or total == "" then
        return string.format("<code>total</code> could not be calculated from table %s", tableName)
    end

	local number = require('Module:Random').number
	local queryFields = 'game=game,link=link'
	local randomArgs = {
		[1] = 1,
		[2] = total
	}
	local countOffset = number(randomArgs)

	if countOffset >= 1 then
		countOffset = countOffset - 1
	end

	local args = {
		format = 'table',
		limit = 1,
		offset = countOffset
	}
    
	local results = cargo.query(tableName, queryFields, args)
	local getExcerpt = require('Module:Excerpt').main
	
    for r = 1, #results do
        local result = results[r]
		local excerptArgs = {
			[1] = result.link
		}
		local excerptResult = getExcerpt(excerptArgs)
        return string.format("[[%s]] $s", result.link, excerptResult)
    end
end

return p