Module:Records - Revision history

Esportsamaze at 01:47, 21 May 2026

2026-05-21T01:47:14Z

Esportsamaze at 01:26, 21 May 2026

2026-05-21T01:26:47Z

← Older revision		Revision as of 06:56, 21 May 2026
Line 13:		Line 13:
	end		end

	~~-- Helper to convert MM:SS to total seconds~~
	local function parseTime(s)		local function parseTime(s)
	if not s or s == "" then return 0 end		if not s or s == "" then return 0 end
Line 45:		Line 44:
	end		end
	local whereClause = #whereParts > 0 and table.concat(whereParts, " AND ") or "1=1"		local whereClause = #whereParts > 0 and table.concat(whereParts, " AND ") or "1=1"

			-- Parse MVP Stage filter
			local mvpStages = {}
			if args.mvp_stage and args.mvp_stage ~= "" then
			for v in args.mvp_stage:gmatch("[^,]+") do
			mvpStages[v:match("^%s(.-)%s$")] = true
			end
			end

	-- Toggles		-- Toggles
Line 55:		Line 62:
	local show_mvp = args.show_mvp ~= "false" and args.show_match_mvps ~= "false"		local show_mvp = args.show_mvp ~= "false" and args.show_match_mvps ~= "false"
	local show_fragger = args.show_fragger ~= "false"		local show_fragger = args.show_fragger ~= "false"
	local show_event_mvp = args.show_event_mvp == "true" ~~-- Hidden by default, requires data~~		local show_event_mvp = args.show_event_mvp == "true"

	local teamMatch = cargo.query("MatchStats_Team", "tournament_day, team, map, total_pts, elim_pts", { where = whereClause, limit = 5000 })		local teamMatch = cargo.query("MatchStats_Team", "tournament_day, team, map, total_pts, elim_pts", { where = whereClause, limit = 5000 })
	local playerMatch = cargo.query("MatchStats_Player", "tournament_day, player, team, player_elims, damage, knockouts, survival, mvp, long_elim, rescues", { where = whereClause, limit = 5000 })
			-- ADDED `stage` TO THIS QUERY SO WE CAN FILTER FOR MVP!
			local playerMatch = cargo.query("MatchStats_Player", "tournament_day, stage, player, team, player_elims, damage, knockouts, survival, mvp, long_elim, rescues", { where = whereClause, limit = 5000 })

	local d_team = {}; local d_player = {}; local o_player = {}; local map_rec = {}; local daySet = {}		local d_team = {}; local d_player = {}; local o_player = {}; local map_rec = {}; local daySet = {}
Line 92:		Line 101:
	local res = tonumber(r.rescues) or 0		local res = tonumber(r.rescues) or 0
	local day = r.tournament_day		local day = r.tournament_day
			local stage = r.stage
	local p = r.player		local p = r.player

	g.elims = g.elims + elims; g.dmg = g.dmg + dmg; g.knocks = g.knocks + knocks; g.surv = g.surv + surv		-- Check if this specific row qualifies for the MVP calculation
			local isValidMvp = true
			if next(mvpStages) and not mvpStages[stage] then isValidMvp = false end

			if isValidMvp then
			g.elims = g.elims + elims; g.dmg = g.dmg + dmg; g.knocks = g.knocks + knocks; g.surv = g.surv + surv
			end

	if elims > rec.p_elims.v then rec.p_elims = {n=p, t=r.team, v=elims} end		if elims > rec.p_elims.v then rec.p_elims = {n=p, t=r.team, v=elims} end
Line 101:		Line 117:
	if res > rec.rescues.v then rec.rescues = {n=p, t=r.team, v=res} end		if res > rec.rescues.v then rec.rescues = {n=p, t=r.team, v=res} end

	if not o_player[p] then o_player[p] = {t=r.team, elims=0, ~~dmg~~=0, ~~knocks~~=0, ~~surv~~=0, ~~mvp~~=0} end		if not o_player[p] then o_player[p] = {t=r.team, elims=0, mvp=0, m_elims=0, m_dmg=0, m_knocks=0, m_surv=0} end

			-- Overall accumulation (for Top Fragger, etc.)
	o_player[p].elims = o_player[p].elims + elims		o_player[p].elims = o_player[p].elims + elims
	~~o_player[p].dmg = o_player[p].dmg + dmg~~
	~~o_player[p].knocks = o_player[p].knocks + knocks~~
	~~o_player[p].surv = o_player[p].surv + surv~~
	o_player[p].mvp = o_player[p].mvp + mvp		o_player[p].mvp = o_player[p].mvp + mvp

			-- MVP SPECIFIC accumulation
			if isValidMvp then
			o_player[p].m_elims = o_player[p].m_elims + elims
			o_player[p].m_dmg = o_player[p].m_dmg + dmg
			o_player[p].m_knocks = o_player[p].m_knocks + knocks
			o_player[p].m_surv = o_player[p].m_surv + surv
			end

	if day and day ~= "" then		if day and day ~= "" then
Line 127:		Line 150:
	if show_event_mvp then		if show_event_mvp then
	local score = 0		local score = 0
	if g.surv > 0 then score = score + (d.~~surv~~ / g.surv) * 0.2 end		if g.surv > 0 then score = score + (d.m_surv / g.surv) * 0.2 end
	if g.dmg > 0 then score = score + (d.~~dmg~~ / g.dmg) * 0.3 end		if g.dmg > 0 then score = score + (d.m_dmg / g.dmg) * 0.3 end
	if g.elims > 0 then score = score + (d.~~elims~~ / g.elims) * 0.4 end		if g.elims > 0 then score = score + (d.m_elims / g.elims) * 0.4 end
	if g.knocks > 0 then score = score + (d.~~knocks~~ / g.knocks) * 0.1 end		if g.knocks > 0 then score = score + (d.m_knocks / g.knocks) * 0.1 end
	local rating = score * 100 ~~-- Convert decimal to readable rating~~		local rating = score * 100
	if rating > true_mvp.v then true_mvp = {n=p, t=d.t, v=rating} end		if rating > true_mvp.v then true_mvp = {n=p, t=d.t, v=rating} end
	end		end

Esportsamaze at 01:22, 21 May 2026

2026-05-21T01:22:59Z

Show changes

Esportsamaze at 01:22, 21 May 2026

2026-05-21T01:22:25Z

← Older revision		Revision as of 06:52, 21 May 2026
Line 15:		Line 15:
	function p.main(frame)		function p.main(frame)
	local args = frame:getParent().args		local args = frame:getParent().args
			if not args.tournament and frame.args.tournament then args = frame.args end

	local tournamentName = args.tournament or mw.title.getCurrentTitle().text		local tournamentName = args.tournament or mw.title.getCurrentTitle().text
	local ~~whereClause~~ = string.format("~~tournament~~ = '%s'", sqlEscape(~~tournamentName~~))
			-- ==========================================
			-- 1. DYNAMIC FILTERING (Matches Module:Statistics)
			-- ==========================================
			local whereParts = {}
			local filters = {"tournament", "tournament_type", "stage", "group_name", "map", "match_type", "tournament_day", "date", "time", "team", "player"}

			for _, f in ipairs(filters) do
			local val = args[f] or args[f:gsub("_name", "")]
			-- Fallback to current page name for tournament if not explicitly provided
			if f == "tournament" and (not val or val == "") then val = tournamentName end

			if val and val ~= "" then
			if val:find(",") then
			local inVals = {}
			for v in val:gmatch("[^,]+") do
			table.insert(inVals, "'" .. sqlEscape(v:match("^%s(.-)%s$")) .. "'")
			end
			table.insert(whereParts, string.format("%s IN (%s)", f, table.concat(inVals, ",")))
			else
			table.insert(whereParts, string.format("%s = '%s'", f, sqlEscape(val)))
			end
			end
			end
			local whereClause = #whereParts > 0 and table.concat(whereParts, " AND ") or "1=1"

	-- TOGGLES (Default: true. Set to "false" to hide)		-- TOGGLES (Default: true. Set to "false" to hide)
Line 29:		Line 55:

	-- ==========================================		-- ==========================================
	-- 1. DATA FETCHING (Single Pass)		-- 2. DATA FETCHING (Single Pass)
	-- ==========================================		-- ==========================================
	local teamMatch = cargo.query("MatchStats_Team", "tournament_day, team, map, total_pts, elim_pts", { where = whereClause, limit = 5000 })		local teamMatch = cargo.query("MatchStats_Team", "tournament_day, team, map, total_pts, elim_pts", { where = whereClause, limit = 5000 })
Line 96:		Line 122:

	-- ==========================================		-- ==========================================
	-- 2. DETERMINE WINNERS		-- 3. DETERMINE WINNERS
	-- ==========================================		-- ==========================================
	local top_fragger = {n="-", t="-", v=-1}		local top_fragger = {n="-", t="-", v=-1}
Line 125:		Line 151:

	-- ==========================================		-- ==========================================
	-- 3. BUILD UI		-- 4. BUILD UI
	-- ==========================================		-- ==========================================
	if rec.t_pts.v == -1 then return "" end		if rec.t_pts.v == -1 then return "" end
Line 211:		Line 237:
	end		end

	~~-- If there are columns to show, add the grid and apply the dynamic column class~~
	if colCount > 0 then		if colCount > 0 then
	grid:addClass('cols-' .. colCount)		grid:addClass('cols-' .. colCount)

Esportsamaze at 01:20, 21 May 2026

2026-05-21T01:20:24Z

Show changes

Esportsamaze at 01:19, 21 May 2026

2026-05-21T01:19:23Z

Show changes

Esportsamaze: Created page with "local p = {} local cargo = mw.ext.cargo local html = mw.html local function sqlEscape(s) if not s then return "" end return s:gsub("\\", "\\\\"):gsub("'", "\\'") end local function getNum(s) if not s then return 0 end return tonumber(s:match("%d+")) or 0 end function p.main(frame) local args = frame:getParent().args local tournamentName = args.tournament or mw.title.getCurrentTitle().text local whereClause = string.format("tournament = '%s'..."

2026-05-21T01:18:09Z

Created page with "local p = {} local cargo = mw.ext.cargo local html = mw.html local function sqlEscape(s) if not s then return "" end return s:gsub("\\", "\\\\"):gsub("'", "\\'") end local function getNum(s) if not s then return 0 end return tonumber(s:match("%d+")) or 0 end function p.main(frame) local args = frame:getParent().args local tournamentName = args.tournament or mw.title.getCurrentTitle().text local whereClause = string.format("tournament = '%s'..."

New page

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

local function sqlEscape(s)
if not s then return "" end
return s:gsub("\\", "\\\\"):gsub("'", "\\'")
end

local function getNum(s)
if not s then return 0 end
return tonumber(s:match("%d+")) or 0
end

function p.main(frame)
local args = frame:getParent().args
local tournamentName = args.tournament or mw.title.getCurrentTitle().text
local whereClause = string.format("tournament = '%s'", sqlEscape(tournamentName))

-- ==========================================
-- 1. DAILY RECORDS (Grouped by Day & Team)
-- ==========================================
local dayStats = cargo.query("MatchStats_Team",
"tournament_day, team, SUM(total_pts)=day_total, SUM(elim_pts)=day_elims",
{ where = whereClause, groupBy = "tournament_day, team", limit = 5000 }
)

local days = {}
local dayList = {}

if dayStats and #dayStats > 0 then
for _, r in ipairs(dayStats) do
local day = r.tournament_day
if day and day ~= "" then
if not days[day] then
days[day] = { pts = {team="-", val=-1}, elims = {team="-", val=-1} }
table.insert(dayList, day)
end

local pts = tonumber(r.day_total) or 0
local elims = tonumber(r.day_elims) or 0

if pts > days[day].pts.val then days[day].pts = {team=r.team, val=pts} end
if elims > days[day].elims.val then days[day].elims = {team=r.team, val=elims} end
end
end
end

-- Sort days intelligently (Day 1, Day 2 ... Day 10)
table.sort(dayList, function(a, b) return getNum(a) < getNum(b) end)

-- ==========================================
-- 2. OVERALL MATCH RECORDS
-- ==========================================
local teamMatch = cargo.query("MatchStats_Team", "team, total_pts, elim_pts", { where = whereClause, limit = 5000 })
local playerMatch = cargo.query("MatchStats_Player", "player, team, player_elims, damage", { where = whereClause, limit = 5000 })

local rec = {
t_pts = {name="-", val=-1},
t_elims = {name="-", val=-1},
p_elims = {name="-", team="-", val=-1},
p_dmg = {name="-", team="-", val=-1}
}

if teamMatch then
for _, r in ipairs(teamMatch) do
local pts = tonumber(r.total_pts) or 0
local elims = tonumber(r.elim_pts) or 0
if pts > rec.t_pts.val then rec.t_pts = {name=r.team, val=pts} end
if elims > rec.t_elims.val then rec.t_elims = {name=r.team, val=elims} end
end
end

if playerMatch then
for _, r in ipairs(playerMatch) do
local elims = tonumber(r.player_elims) or 0
local dmg = tonumber(r.damage) or 0
if elims > rec.p_elims.val then rec.p_elims = {name=r.player, team=r.team, val=elims} end
if dmg > rec.p_dmg.val then rec.p_dmg = {name=r.player, team=r.team, val=dmg} end
end
end

-- ==========================================
-- 3. BUILD UI
-- ==========================================
if #dayList == 0 and rec.t_pts.val == -1 then
return "" -- No data yet
end

local root = html.create('div'):addClass('rec-wrapper')
root:tag('div'):addClass('rec-header'):wikitext('🏆 Tournament Records')

local grid = root:tag('div'):addClass('rec-grid')

-- LEFT COLUMN: Overall Single Match Records
local colLeft = grid:tag('div'):addClass('rec-col')
colLeft:tag('div'):addClass('rec-col-title'):wikitext('Single Match Highs')

local function addRecord(parent, icon, title, name, subname, val, suffix)
if val == -1 then return end
local box = parent:tag('div'):addClass('rec-box')
box:tag('div'):addClass('rec-icon'):wikitext(icon)
local info = box:tag('div'):addClass('rec-info')
info:tag('div'):addClass('rec-title'):wikitext(title)

local nameStr = "'''[[" .. name .. "]]'''"
if subname and subname ~= "-" then nameStr = nameStr .. " (" .. subname .. ")" end
info:tag('div'):addClass('rec-name'):wikitext(nameStr)

box:tag('div'):addClass('rec-val'):wikitext(val .. '' .. suffix .. '')
end

addRecord(colLeft, '🔥', 'Highest Team Points', rec.t_pts.name, nil, rec.t_pts.val, 'pts')
addRecord(colLeft, '⚔️', 'Highest Team Elims', rec.t_elims.name, nil, rec.t_elims.val, 'elims')
addRecord(colLeft, '💀', 'Highest Player Elims', rec.p_elims.name, rec.p_elims.team, rec.p_elims.val, 'elims')
if rec.p_dmg.val > 0 then
addRecord(colLeft, '💥', 'Highest Player Damage', rec.p_dmg.name, rec.p_dmg.team, math.floor(rec.p_dmg.val), 'dmg')
end

-- RIGHT COLUMN: Daily Leaders
local colRight = grid:tag('div'):addClass('rec-col')
colRight:tag('div'):addClass('rec-col-title'):wikitext('Daily Leaders')

local dayListContainer = colRight:tag('div'):addClass('rec-day-list')

for _, day in ipairs(dayList) do
local d = days[day]
local dayRow = dayListContainer:tag('div'):addClass('rec-day-row')
dayRow:tag('div'):addClass('rec-day-name'):wikitext(day)

local dStats = dayRow:tag('div'):addClass('rec-day-stats')
dStats:tag('div'):wikitext("🏅 '''Pts:''' [[" .. d.pts.team .. "]] (" .. d.pts.val .. ")")
dStats:tag('div'):wikitext("🔫 '''Elims:''' [[" .. d.elims.team .. "]] (" .. d.elims.val .. ")")
end

return tostring(root)
end

return p