Module:Team
From eSportsAmaze
More actions
Documentation for this module may be created at Module:Team/doc
local p = {}
local cargo = mw.ext.cargo
local html = mw.html
local currentTitle = mw.title.getCurrentTitle()
-- ============================================================
-- HELPER: Sanitize Strings
-- ============================================================
local function clean(s)
if not s then return nil end
local cleaned = s:gsub("[\r\n]", ""):gsub("^%s*(.-)%s*$", "%1")
if cleaned == "" then return nil end
return cleaned
end
local function formatCurrency(amount)
if not amount then return "0" end
local n = tonumber(amount) or 0
local formatted = tostring(n):reverse():gsub("(%d%d%d)(%d%d%d)","%1,%2"):reverse()
return '<span class="indian-currency">₹ ' .. formatted .. '</span>'
end
local function getSocials(args)
local container = html.create('div'):addClass('fib-socials')
local hasSocials = false
local platforms = {
{arg='instagram', file='Icon_instagram.png'},
{arg='twitter', file='Icon_twitter.png'},
{arg='youtube', file='Icon_youtube.png'},
{arg='discord', file='Icon_discord.png'},
{arg='facebook', file='Icon_facebook.png'},
{arg='website', file='Icon_website.png'}
}
for _, p in ipairs(platforms) do
if args[p.arg] and args[p.arg] ~= "" then
hasSocials = true
container:wikitext('[[File:' .. p.file .. '|24px|link=' .. args[p.arg] .. '|class=social-img]]')
end
end
if hasSocials then return tostring(container) else return "" end
end
local function getInfoboxLogo(teamName, image, imageDark)
local lightFile = (image ~= "" and image) or (teamName .. '.png')
local darkFile = (imageDark ~= "" and imageDark) or (teamName .. '_dark.png')
local hasLight = mw.title.new('File:' .. lightFile).exists
local hasDark = mw.title.new('File:' .. darkFile).exists
local container = html.create('div'):addClass('fib-image')
local lSpan = container:tag('span'):addClass('logo-lightmode')
if hasLight then lSpan:wikitext('[[File:' .. lightFile .. '|220px]]') else lSpan:wikitext('[[File:Shield_team.png|180px]]') end
local dSpan = container:tag('span'):addClass('logo-darkmode')
if hasDark then dSpan:wikitext('[[File:' .. darkFile .. '|220px]]') elseif hasLight then dSpan:wikitext('[[File:' .. lightFile .. '|220px]]') else dSpan:wikitext('[[File:Shield_team_dark.png|180px]]') end
return tostring(container)
end
-- ============================================================
-- MAIN 1: TEAM INFOBOX
-- ============================================================
function p.infobox(frame)
local args = frame:getParent().args
local team = clean(args.name) or currentTitle.subpageText
local root = html.create('div'):addClass('flat-infobox')
root:tag('div'):addClass('fib-header'):tag('div'):addClass('fib-title'):wikitext(team)
root:wikitext(getInfoboxLogo(team, clean(args.image), clean(args.image_dark)))
local earnings = "0"
if cargo and cargo.query then
local results = cargo.query("PrizeMoney", "SUM(prize)=total", { where = "team = '" .. team:gsub("'", "\\'") .. "' AND (player='' OR player IS NULL)" })
if results and #results > 0 and results[1].total then earnings = results[1].total end
end
local rankVal = "Unranked"
if cargo and cargo.query then
local rResults = cargo.query("Krafton_Rankings", "rank", { where = "name = '" .. team:gsub("'", "\\'") .. "' AND type='Team'", limit = 1 })
if rResults and #rResults > 0 then rankVal = "#" .. rResults[1].rank end
end
local statusColor = "#333"
local statusText = clean(args.status) or "Active"
if args.status then
local s = args.status:lower()
if s == "active" then statusColor = "#16a34a" elseif s == "inactive" or s == "disbanded" then statusColor = "#dc2626" end
end
local grid1 = root:tag('div'):addClass('fib-grid')
grid1:tag('div'):addClass('fib-cell'):tag('div'):addClass('fib-label-sm'):wikitext('Status'):done():tag('div'):addClass('fib-value-sm'):css('color', statusColor):wikitext(statusText):done()
grid1:tag('div'):addClass('fib-cell'):tag('div'):addClass('fib-label-sm'):wikitext('Krafton Rank'):done():tag('div'):addClass('fib-value-sm'):wikitext(rankVal):done()
local grid2 = root:tag('div'):addClass('fib-grid')
grid2:tag('div'):addClass('fib-cell'):tag('div'):addClass('fib-label-sm'):wikitext('Country'):done():tag('div'):addClass('fib-value-sm'):wikitext(clean(args.country) or 'TBD'):done()
grid2:tag('div'):addClass('fib-cell'):tag('div'):addClass('fib-label-sm'):wikitext('Tag'):done():tag('div'):addClass('fib-value-sm'):wikitext(clean(args.short_code) or '-'):done()
if earnings and tonumber(earnings) and tonumber(earnings) > 0 then
root:tag('div'):addClass('fib-prize'):tag('div'):addClass('fib-label-sm'):wikitext('Total Earnings'):done():tag('div'):addClass('fib-prize-val'):wikitext(formatCurrency(earnings)):done()
end
local list = root:tag('div'):addClass('fib-list')
local function addRow(label, value)
if value and value ~= "" then list:tag('div'):addClass('fib-row'):tag('div'):addClass('fib-label'):wikitext(label):done():tag('div'):addClass('fib-data'):wikitext(value):done() end
end
addRow('Full Name', clean(args.other_team))
if args.sponsors then addRow('Sponsors', args.sponsors:gsub(",", "<br>")) end
root:wikitext(getSocials(args))
return tostring(root)
end
-- ============================================================
-- MAIN 2: HYBRID ROSTER (SORTED BY NAME)
-- ============================================================
function p.roster(frame)
local args = frame:getParent().args
local team = clean(args.team) or currentTitle.subpageText
-- 1. Fetch Database Players (SORTED BY ID)
local dbPlayers = {}
if cargo and cargo.query then
local tables = "Players"
local fields = "id, real_name, role, nationality, image, _pageName"
local where = "current_team = '" .. team:gsub("'", "\\'") .. "' AND status='Active'"
local results = cargo.query(tables, fields, { where = where, orderBy = "id ASC" })
for _, row in ipairs(results) do
dbPlayers[row.id] = {
id = row.id,
name = row.real_name,
role = row.role,
flag = clean(row.nationality),
image = clean(row.image),
link = row._pageName,
source = "auto"
}
end
end
-- 2. Process Manual Inputs
local finalRoster = {}
-- Add DB players
for _, pData in pairs(dbPlayers) do
table.insert(finalRoster, pData)
end
-- Check manual args
for i = 1, 10 do
local mid = clean(args['player' .. i])
if mid and mid ~= "" then
if not dbPlayers[mid] then
table.insert(finalRoster, {
id = mid,
name = clean(args['name' .. i]) or "",
role = clean(args['role' .. i]) or "Player",
flag = clean(args['flag' .. i]) or "India",
image = "",
link = mid,
source = "manual"
})
end
end
end
-- 3. Sort Final Roster by ID (Name) Alphabetically
table.sort(finalRoster, function(a, b)
return (a.id or ""):lower() < (b.id or ""):lower()
end)
-- 4. Render
local grid = html.create('div'):addClass('hero-roster-grid')
for _, player in ipairs(finalRoster) do
local card = grid:tag('div'):addClass('hero-player-card')
-- Header (Image Area)
local header = card:tag('div'):addClass('hero-card-image')
if player.image and player.image ~= "" then
header:wikitext('[[File:' .. player.image .. '|link=' .. player.link .. ']]')
else
header:wikitext('[[File:Player_Placeholder.png|link=' .. player.link .. ']]')
end
-- Info Body
local body = card:tag('div'):addClass('hero-card-body')
-- Role Pill
local roleColor = "#64748b" -- Gray Default
local r = (player.role or ""):lower()
if r:find("igl") then roleColor = "#eab308" -- Gold
elseif r:find("fragger") or r:find("entry") or r:find("assault") then roleColor = "#ef4444" -- Red
elseif r:find("support") or r:find("medic") then roleColor = "#22c55e" -- Green
elseif r:find("sniper") then roleColor = "#3b82f6" -- Blue
elseif r:find("coach") then roleColor = "#a855f7" -- Purple
end
body:tag('div'):addClass('hero-role-pill')
:css('background-color', roleColor)
:wikitext(player.role or "Player")
-- ID and Name
body:tag('div'):addClass('hero-player-id'):wikitext('[[' .. player.link .. '|' .. player.id .. ']]')
if player.name and player.name ~= "" then
body:tag('div'):addClass('hero-player-name'):wikitext(player.name)
end
-- Flag
if player.flag then
local safeFlag = player.flag:gsub(" ", "_")
local flagFile = "Flag_" .. safeFlag .. ".png"
body:tag('div'):addClass('hero-player-flag'):wikitext('[[File:' .. flagFile .. '|link=]] ' .. player.flag)
end
end
return tostring(grid)
end
-- ============================================================
-- MAIN 3: FORMER PLAYERS LIST (DIRECT JOIN FIX)
-- ============================================================
function p.formerPlayers(frame)
local args = frame:getParent().args
local team = clean(args.team) or currentTitle.subpageText
-- 1. Use Full Table Names (Safest Method)
local tables = "Player_Former_Teams, Players"
-- 2. Select Fields explicitly
-- We want the ID from Players table (Short ID)
local fields = "Players._pageName, Players.id=short_id, Players.real_name=Name, Player_Former_Teams.role=role, Player_Former_Teams.join_date=join_date, Player_Former_Teams.leave_date=leave_date, Player_Former_Teams.player_id=full_page"
-- 3. Query with Explicit Join
local queryArgs = {
joinOn = "Player_Former_Teams.player_id = Players._pageName",
where = "Player_Former_Teams.team = '" .. team:gsub("'", "\\'") .. "' AND Player_Former_Teams.leave_date != ''",
orderBy = "Player_Former_Teams.leave_date DESC"
}
local results = cargo.query(tables, fields, queryArgs)
if not results or #results == 0 then
return '<div style="font-style:italic; color:#64748b; padding:10px;">No former players recorded.</div>'
end
local tbl = html.create('table'):addClass('wikitable flat-table sortable'):css('width','100%')
local h = tbl:tag('tr')
h:tag('th'):wikitext('ID'); h:tag('th'):wikitext('Name'); h:tag('th'):wikitext('Role'); h:tag('th'):wikitext('Join Date'); h:tag('th'):wikitext('Leave Date')
for _, row in ipairs(results) do
local tr = tbl:tag('tr')
-- Logic: If we found a match in Players table, use that short ID.
-- If not (maybe player page deleted), fallback to the page name string.
local displayID = row.short_id
if not displayID or displayID == "" then
-- Strip path if fallback needed: "BGMI/Players/Jonathan" -> "Jonathan"
displayID = (row.full_page or ""):gsub("^.*/", "")
end
local linkTarget = row.full_page or row.short_id
tr:tag('td'):css('font-weight','bold'):wikitext('[[' .. linkTarget .. '|' .. displayID .. ']]')
tr:tag('td'):wikitext(row.Name or "-")
tr:tag('td'):wikitext(row.role or "-")
tr:tag('td'):wikitext(row.join_date or "?")
tr:tag('td'):wikitext(row.leave_date or "?")
end
return tostring(tbl)
end
-- ============================================================
-- MAIN 4: HISTORY (Preserved)
-- ============================================================
function p.history(frame)
local args = frame:getParent().args
local team = clean(args.team) or mw.title.getCurrentTitle().subpageText
local results = cargo.query("StageStandings", "tournament, stage, totalpts, matchesplayed, wwcd, elimpts, lastmatchrank, result", {
where = "team = '" .. team:gsub("'", "\\'") .. "'",
orderBy = "tournament DESC",
limit = 50
})
local root = html.create('div')
root:wikitext('== Tournament Statistics ==')
if #results > 0 then
local tbl = root:tag('table'):addClass('modern-history-table')
local thead = tbl:tag('thead'):tag('tr')
thead:tag('th'):wikitext('Tournament'); thead:tag('th'):wikitext('Stage'); thead:tag('th'):wikitext('Rank')
thead:tag('th'):wikitext('MP'); thead:tag('th'):wikitext('WWCD'); thead:tag('th'):wikitext('Elims'); thead:tag('th'):wikitext('Pts')
for _, row in ipairs(results) do
local tr = tbl:tag('tr')
local res = (row.result or ""):lower()
if res == "q" or res == "qualified" then tr:css('background-color', '#E9FFF0')
elseif res == "e" or res == "eliminated" then tr:css('background-color', '#FFE9E9') end
tr:tag('td'):css('font-weight','bold'):wikitext('[[' .. row.tournament .. ']]')
tr:tag('td'):wikitext(row.stage)
tr:tag('td'):css('font-weight','bold'):css('text-align','center'):wikitext('#' .. (row.lastmatchrank or '?'))
tr:tag('td'):css('text-align','center'):wikitext(row.matchesplayed)
tr:tag('td'):css('text-align','center'):wikitext(row.wwcd)
tr:tag('td'):css('text-align','center'):wikitext(row.elimpts)
tr:tag('td'):css('text-align','center'):css('font-weight','800'):wikitext(row.totalpts)
end
else root:wikitext("''No tournament data found for this team.''") end
return tostring(root)
end
return p