Module:Sponsored teams

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

local cargo = mw.ext.cargo

local Sponsored = {}

function Sponsored.get(frame)
	local container = mw.html.create('div')
		:addClass('sponsored')
	local currentTitle = mw.title.getCurrentTitle().text
	-- Look up Cargo table teams with current page as sponsor
	local tables = 'Sponsors, Teams'
	local fields = 'Sponsors._pageName'

	local cargoArgs = {
		join = 'Sponsors._pageName=Teams._pageName, Sponsors._pageName=Teams.org',
		where = 'Sponsors.id= "' ..currentTitle .. '" OR Teams.org="' .. currentTitle .. '"',
		limit=10,
		orderBy='Sponsors.start'
	}
	local results = cargo.query(tables, fields, cargoArgs)
	
	if #results > 0 then
		local ul = mw.html.create('ul')
		for r = 1, #results do
			mw.log(results[r])
			mw.logObject(results[r])
	        local result = results[r]
	        local li = mw.html.create('li')
	        	:wikitext('[[' .. result._pageName .. ']]')
	        ul:node(li)
	    end
	else 
		return nil
	end
	
	
	return container:node(ul)
end

return Sponsored