Couchor at 22:10, 4 October 2023

2023-10-04T22:10:35Z

← Older revision		Revision as of 22:10, 4 October 2023
Line 51:		Line 51:
	where = "Transfers.id='" .. result._pageName .. "' AND (Transfers.leavedate IS NULL) AND (Transfers.inactivedate IS NULL) AND ((Logos.start IS NULL OR Logos.start < '" .. currentDate .. "') AND (Logos.end IS NULL OR Logos.end > '" .. currentDate .. "'))"		where = "Transfers.id='" .. result._pageName .. "' AND (Transfers.leavedate IS NULL) AND (Transfers.inactivedate IS NULL) AND ((Logos.start IS NULL OR Logos.start < '" .. currentDate .. "') AND (Logos.end IS NULL OR Logos.end > '" .. currentDate .. "'))"
	}		}

	~~-- Perform the join query~~
	local teamResults = cargo.query(tables, fields, cargoArgs)		local teamResults = cargo.query(tables, fields, cargoArgs)

	if #teamResults > 0 then		if #teamResults > 0 then
			local logoResults = teamResults[1]
			-- if no images under team
			if not teamResults[1]['Logos.logoAll'] and not teamResults[1]['Logos.logoLight'] and not teamResults[1]['Logos.logoDark'] and not teamResults[1]['Logos.iconAll'] and not teamResults[1]['Logos.iconLight'] and not teamResults[1]['Logos.iconDark'] then
			tables = "Logos, Teams"
			fields = "Logos.logoAll, Logos.logoLight, Logos.logoDark, Logos.iconAll, Logos.iconLight, Logos.iconDark"
			cargoArgs = {
			join = "Logos._pageName = Teams.org",
			where = "Teams._pageName='" .. teamResults[1]['Transfers._pageName'] .. "' AND ((Logos.start IS NULL OR Logos.start < '" .. currentDate .. "') AND (Logos.end IS NULL OR Logos.end > '" .. currentDate .. "'))"
			}
			local orgLogos = cargo.query(tables, fields, cargoArgs)

			if #orgLogos > 0 then logoResults = orgLogos[1] end
			end
	local teamName = teamResults[1]['Transfers._pageName']		local teamName = teamResults[1]['Transfers._pageName']
	local logoAll = ~~teamResults[1]~~['Logos.logoAll']		local logoAll = logoResults['Logos.logoAll']
	local logoLight = ~~teamResults[1]~~['Logos.logoLight']		local logoLight = logoResults['Logos.logoLight']
	local logoDark = ~~teamResults[1]~~['Logos.logoDark']		local logoDark = logoResults['Logos.logoDark']
	local iconAll = ~~teamResults[1]~~['Logos.iconAll']		local iconAll = logoResults['Logos.iconAll']
	local iconLight = ~~teamResults[1]~~['Logos.iconLight']		local iconLight = logoResults['Logos.iconLight']
	local iconDark = ~~teamResults[1]~~['Logos.iconDark']		local iconDark = logoResults['Logos.iconDark']

	if iconAll then		if iconAll then
Line 93:		Line 104:
	function p.createLogo(url, teamPage, class, game, size)		function p.createLogo(url, teamPage, class, game, size)
	size = size or '20px'		size = size or '20px'
			class = class and class or 'light'
	local className = class and class .. ' h-100' or 'h-100'		local className = class and class .. ' h-100' or 'h-100'
	local logoURL = url and url or 'Team_placeholder_' .. class .. '.png'		local logoURL = url and url or 'Team_placeholder_' .. class .. '.png'

Couchor: Created page with "local Flags = require('Module:Flags') local p = {} local VariablesLua = mw.ext.VariablesLua local cargo = mw.ext.cargo function p.main(frame) local game = mw.text.split(mw.title.getCurrentTitle().text, '/')[1] local tables = 'People' local fields = '_pageName, nationality, name, romanized, games, active_roles, past_roles' local cargoArgs = { where = 'games HOLDS "' .. game .. '"', orderBy = 'nationality ASC' } local results = cargo.query(tables, fields, cargoA..."

2023-09-29T11:33:37Z

Created page with "local Flags = require('Module:Flags') local p = {} local VariablesLua = mw.ext.VariablesLua local cargo = mw.ext.cargo function p.main(frame) local game = mw.text.split(mw.title.getCurrentTitle().text, '/')[1] local tables = 'People' local fields = '_pageName, nationality, name, romanized, games, active_roles, past_roles' local cargoArgs = { where = 'games HOLDS "' .. game .. '"', orderBy = 'nationality ASC' } local results = cargo.query(tables, fields, cargoA..."

New page

local Flags = require('Module:Flags')
local p = {}
local VariablesLua = mw.ext.VariablesLua
local cargo = mw.ext.cargo

function p.main(frame)
local game = mw.text.split(mw.title.getCurrentTitle().text, '/')[1]
local tables = 'People'
local fields = '_pageName, nationality, name, romanized, games, active_roles, past_roles'
local cargoArgs = {
where = 'games HOLDS "' .. game .. '"',
orderBy = 'nationality ASC'
}
local results = cargo.query(tables, fields, cargoArgs)

local container = mw.html.create('div')
if #results > 0 then
local nat = mw.text.split(results[1].nationality, ',')[1]

local tableContainer = mw.html.create('table'):addClass('players__table')
local flagRow = mw.html.create('tr'):node(mw.html.create('th'):attr('colspan', 4):node(mw.html.create('div'):addClass('players__header'):node(Flags.icon(nat)):node(mw.html.create('div'):wikitext(Flags.CountryName(nat)))))

local headerRow = mw.html.create('tr'):addClass('tc'):node(mw.html.create('th'):wikitext('ID')):node(mw.html.create('th'):wikitext('Name')):node(mw.html.create('th'):wikitext('Role')):node(mw.html.create('th'):wikitext('Team'))
tableContainer:node(flagRow):node(headerRow)

for i = 1, #results do
local result = results[i]
local playerNat = mw.text.split(result.nationality, ',')[1]
if playerNat ~= nat then
local clone = mw.clone(tableContainer)
container:node(clone)
nat = playerNat
tableContainer = mw.html.create('table'):addClass('players__table')
flagRow = mw.html.create('tr'):node(mw.html.create('th'):attr('colspan', 4):node(mw.html.create('div'):addClass('players__header'):node(Flags.icon(nat)):node(mw.html.create('div'):wikitext(Flags.CountryName(nat)))))
headerRow = mw.html.create('tr'):addClass('tc'):node(mw.html.create('th'):wikitext('ID')):node(mw.html.create('th'):wikitext('Name')):node(mw.html.create('th'):wikitext('Role')):node(mw.html.create('th'):wikitext('Team'))
tableContainer:node(flagRow):node(headerRow)
end
local flag = Flags.icon(playerNat)

local id = mw.html.create('td'):wikitext('[[' .. result._pageName .. ']]')
local name = mw.html.create('td'):wikitext(result.romanized or result.name)
local role = mw.html.create('td'):wikitext(result.active_roles)
local team = mw.html.create('td')

local currentDate = os.date('%Y-%m-%d')

tables = "Transfers, Logos"
fields = "Transfers._pageName, Logos.logoAll, Logos.logoLight, Logos.logoDark, Logos.iconAll, Logos.iconLight, Logos.iconDark"
cargoArgs = {
join = "Transfers._pageName = Logos._pageName",
where = "Transfers.id='" .. result._pageName .. "' AND (Transfers.leavedate IS NULL) AND (Transfers.inactivedate IS NULL) AND ((Logos.start IS NULL OR Logos.start < '" .. currentDate .. "') AND (Logos.end IS NULL OR Logos.end > '" .. currentDate .. "'))"
}

-- Perform the join query
local teamResults = cargo.query(tables, fields, cargoArgs)

if #teamResults > 0 then
local teamName = teamResults[1]['Transfers._pageName']
local logoAll = teamResults[1]['Logos.logoAll']
local logoLight = teamResults[1]['Logos.logoLight']
local logoDark = teamResults[1]['Logos.logoDark']
local iconAll = teamResults[1]['Logos.iconAll']
local iconLight = teamResults[1]['Logos.iconLight']
local iconDark = teamResults[1]['Logos.iconDark']

if iconAll then
team:node(p.createLogo(iconAll, teamName, nil, game, size))
elseif iconLight and iconDark then
team:node(mw.html.create('div'):node(p.createLogo(iconLight, teamName, 'light', game, size)):node(p.createLogo(iconDark, teamName, 'dark', game, size)))
elseif logoAll then
team:node(p.createLogo(logoAll, teamName, nil, game, size))
elseif logoLight and logoDark then
team:node(mw.html.create('div'):node(p.createLogo(logoLight, teamName, 'light', game, size)):node(p.createLogo(logoDark, teamName, 'dark', game, size)))
else
local logo = iconLight or iconDark or logoLight or logoDark
team:node(p.createLogo(logo, teamName, nil, game, size))
end
else
team:wikitext('None')
end

local playerRow = mw.html.create('tr'):node(id):node(name):node(role):node(team)

tableContainer:node(playerRow)
end
container:node(tableContainer)
end

return container
end

function p.createLogo(url, teamPage, class, game, size)
size = size or '20px'
local className = class and class .. ' h-100' or 'h-100'
local logoURL = url and url or 'Team_placeholder_' .. class .. '.png'
local logoContainer = mw.html.create('div'):addClass(className)
local logo = mw.html.create('div')
:addClass('team-list-logo')
:node('[[File:' .. logoURL .. '|' .. size .. '|link=' .. teamPage .. '|' .. string.gsub(teamPage, game .. '/', '') .. ']]')

logoContainer:node(logo)
return logoContainer
end

return p

Module:Game/People - Revision history

Couchor at 22:10, 4 October 2023