Module:Transfers

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

local getArgs = require('Module:Arguments').getArgs
local cargo = mw.ext.cargo

local Transfers = {}

function Transfers.main(frame)
	local args = getArgs(frame)
	local parent = mw.html.create('div')
	if args.game ~= nil then
		local tables = 'Transfers'
		local fields = '_pageName, id, joindate, leavedate, inactivedate, newteam, flag'
		local cargoArgs = {
			where = '_pageName LIKE "' .. args.game .. '%"',
			orderBy = 'joindate DESC, leavedate DESC'
		}
		local results = cargo.query(tables, fields, cargoArgs)
		mw.logObject(results)
		if #results > 0 then
			for r = 1, #results do
				local result = results[r]
				local transfer = mw.html.create('div')
					:wikitext('[[' .. result.id .. ']]')
					
				parent:node(transfer)
			end
		end
	else 
		
	end
	return parent
end

return Transfers