Module:Tournament - Revision history

Esportsamaze at 10:15, 14 March 2026

2026-03-14T10:15:44Z

← Older revision		Revision as of 15:45, 14 March 2026
Line 15:		Line 15:
	-- ============================================================		-- ============================================================

			-- Indian Format (1,00,000)
	local function formatINR(amount)		local function formatINR(amount)
	if not amount then return "0" end		if not amount then return "0" end
	local n = tostring(math.floor(tonumber(amount) or 0))		local n = tostring(math.floor(tonumber(amount) or 0))
			if #n <= 3 then return n end
	local last3 = n:sub(-3)		local last3 = n:sub(-3)
	local rest = n:sub(1, -4)		local rest = n:sub(1, -4)
	local formattedRest = rest:reverse():gsub("(%d%d)", "%1,"):reverse()		-- Indian format: group remaining digits in pairs (from right)
	~~if formattedRest ~=~~ "" ~~then last3 =~~ "," ~~.. last3 end~~		local formattedRest = rest:reverse():gsub("(%d%d)", "%1,"):reverse():gsub("^,", "")
	return formattedRest .. last3		return formattedRest .. "," .. last3
	end		end


	local function formatStd(amount)		local function formatStd(amount)

Esportsamaze at 19:29, 4 March 2026

2026-03-04T19:29:30Z

← Older revision		Revision as of 00:59, 5 March 2026
Line 3:		Line 3:
	local cargo = mw.ext.cargo		local cargo = mw.ext.cargo
	local lang = mw.getContentLanguage()		local lang = mw.getContentLanguage()

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

	-- ============================================================		-- ============================================================
Line 141:		Line 148:

	local prevQuery = cargo.query('Tournaments', '_pageName, series_season', {		local prevQuery = cargo.query('Tournaments', '_pageName, series_season', {
	where = string.format('series = "%s" AND series_value < %s', currentSeries, currentValue),		where = string.format("series = '%s' AND series_value < %s", sqlEscape(currentSeries), tonumber(currentValue) or 0),
	orderBy = 'series_value DESC', limit = 1		orderBy = 'series_value DESC', limit = 1
	})		})
Line 152:		Line 159:

	local nextQuery = cargo.query('Tournaments', '_pageName, series_season', {		local nextQuery = cargo.query('Tournaments', '_pageName, series_season', {
	where = string.format('series = "%s" AND series_value > %s', currentSeries, currentValue),		where = string.format("series = '%s' AND series_value > %s", sqlEscape(currentSeries), tonumber(currentValue) or 0),
	orderBy = 'series_value ASC', limit = 1		orderBy = 'series_value ASC', limit = 1
	})		})

Esportsamaze at 19:04, 2 March 2026

2026-03-02T19:04:22Z

← Older revision		Revision as of 00:34, 3 March 2026
Line 36:		Line 36:
	-- Clean the amount string (remove commas if passed by accident)		-- Clean the amount string (remove commas if passed by accident)
	-- FIX: Extra parens around gsub to discard the 'count' return value		-- FIX: Extra parens around gsub to discard the 'count' return value
			-- Fix (match Module:PrizePool's pattern):
	if type(amount) == "string" then		if type(amount) == "string" then
	val = tonumber((amount:gsub(",", ""))) or 0		val = tonumber((amount:gsub(",", ""))) or 0
			else
			val = tonumber(amount) or 0
	end		end


	if symbol == "₹" or symbol == "INR" or symbol == "Rs" then		if symbol == "₹" or symbol == "INR" or symbol == "Rs" then

Esportsamaze at 20:30, 14 February 2026

2026-02-14T20:30:48Z

← Older revision		Revision as of 02:00, 15 February 2026
Line 35:		Line 35:

	-- Clean the amount string (remove commas if passed by accident)		-- Clean the amount string (remove commas if passed by accident)
			-- FIX: Extra parens around gsub to discard the 'count' return value
	if type(amount) == "string" then		if type(amount) == "string" then
	val = tonumber(amount:gsub(",", "")) or 0		val = tonumber((amount:gsub(",", ""))) or 0
	end		end

Esportsamaze at 20:22, 14 February 2026

2026-02-14T20:22:41Z

Show changes

Esportsamaze at 18:53, 12 February 2026

2026-02-12T18:53:43Z

← Older revision		Revision as of 00:23, 13 February 2026
Line 435:		Line 435:

	-- 1. PAGINATION SETUP		-- 1. PAGINATION SETUP
	~~-- Get offset from URL (defaults to 0 if missing)~~
	local offset = tonumber(args.offset) or 0		local offset = tonumber(args.offset) or 0
	local limit = 50 -- Show 50 tournaments per page		local limit = 50 -- Show 50 tournaments per page

	-- 2. BUILD QUERY		-- 2. BUILD QUERY
			-- Default to "BGMI" if no game is specified in the invoke
			local targetGame = args.game or "BGMI"

			-- Start with the basic date check
	local whereClause = "start_date IS NOT NULL"		local whereClause = "start_date IS NOT NULL"

			-- Append the game filter (allow passing "All" to show everything if needed later)
			if targetGame ~= "All" then
			whereClause = whereClause .. string.format(' AND game="%s"', targetGame)
			end

	-- 3. RUN CARGO QUERY		-- 3. RUN CARGO QUERY
	~~-- We select the exact fields required by your p.listRow function~~
	local results = cargo.query(		local results = cargo.query(
	'Tournaments',		'Tournaments',
Line 463:		Line 470:
	return '<div style="padding:40px; text-align:center; color:#64748b;">No more tournaments found.<br><br><b>[[' .. tostring(mw.uri.fullUrl(mw.title.getCurrentTitle().text)) .. '\|Back to Start]]</b></div>'		return '<div style="padding:40px; text-align:center; color:#64748b;">No more tournaments found.<br><br><b>[[' .. tostring(mw.uri.fullUrl(mw.title.getCurrentTitle().text)) .. '\|Back to Start]]</b></div>'
	else		else
	return '<div style="padding:40px; text-align:center; color:#64748b;">No tournaments found in database.</div>'		return '<div style="padding:40px; text-align:center; color:#64748b;">No ' .. targetGame .. ' tournaments found in database.</div>'
	end		end
	end		end

	-- 5. RENDER ROWS ~~(Using your Main 3 logic)~~		-- 5. RENDER ROWS
	for _, row in ipairs(results) do		for _, row in ipairs(results) do
	~~-- We structure the data exactly how p.listRow expects it~~
	local rowArgs = {		local rowArgs = {
	Page = row._pageName,		Page = row._pageName,
Line 481:		Line 487:
	image_dark = row.image_dark		image_dark = row.image_dark
	}		}
	~~-- Call your existing function~~
	container:wikitext(p.listRow({ args = rowArgs }))		container:wikitext(p.listRow({ args = rowArgs }))
	end		end
Line 488:		Line 493:
	local navDiv = container:tag('div'):addClass('pagination-controls')		local navDiv = container:tag('div'):addClass('pagination-controls')

	~~-- "Previous" Button (Hide if on first page)~~
	if offset > 0 then		if offset > 0 then
	local prevOffset = math.max(0, offset - limit)		local prevOffset = math.max(0, offset - limit)
Line 496:		Line 500:
	end		end

	~~-- "Next" Button (Hide if we have fewer results than the limit)~~
	if #results == limit then		if #results == limit then
	local nextOffset = offset + limit		local nextOffset = offset + limit

Esportsamaze at 03:47, 28 January 2026

2026-01-28T03:47:36Z

← Older revision		Revision as of 09:17, 28 January 2026
Line 354:		Line 354:
	local name = getCleanTitle(page)		local name = getCleanTitle(page)

	~~-- 1. Data Setup~~
	local startDate = args.start_date or args.date or args.startdate or ""		local startDate = args.start_date or args.date or args.startdate or ""
	local endDate = args.end_date or args.enddate or ""		local endDate = args.end_date or args.enddate or ""
Line 367:		Line 366:
	end		end

	-- 2. CREATE ROW ~~with Dynamic Tier Class~~		-- CREATE ROW: Removed inline background styles to allow CSS variables to work
	local row = html.create('div'):addClass('tourney-row')		local row = html.create('div'):addClass('tourney-row')

	if tier ~= "" then		if tier ~= "" then
	~~-- We add 'row-tier-s', 'row-tier-a' etc. to avoid conflict with the Pill colors~~
	row:addClass('row-' .. getTierClass(tier))		row:addClass('row-' .. getTierClass(tier))
	end		end

	-- 3. Date Box		-- Date Box
	row:tag('div'):addClass('tr-date'):wikitext(formatDateRange(startDate, endDate))		row:tag('div'):addClass('tr-date'):wikitext(formatDateRange(startDate, endDate))

	-- 4. Logo		-- Logo
	row:tag('div'):addClass('tr-event-logo-col'):wikitext(getTourneyLogo(image, imageDark))		row:tag('div'):addClass('tr-event-logo-col'):wikitext(getTourneyLogo(image, imageDark))

	-- 5. Info		-- Info
	local info = row:tag('div'):addClass('tr-info')		local info = row:tag('div'):addClass('tr-info')
	local nameRow = info:tag('div'):addClass('tr-name-row')		local nameRow = info:tag('div'):addClass('tr-name-row')
Line 393:		Line 391:
	if args.organizer then info:tag('div'):addClass('tr-org'):wikitext(args.organizer) end		if args.organizer then info:tag('div'):addClass('tr-org'):wikitext(args.organizer) end

	-- 6. Winner		-- Winner
	local winDiv = row:tag('div'):addClass('tr-winner mobile-hide')		local winDiv = row:tag('div'):addClass('tr-winner mobile-hide')
	if winner and winner ~= "" then winDiv:wikitext("🏆 " .. winner)		if winner and winner ~= "" then
	else winDiv:tag('span'):~~addClass~~('~~dim-text~~'):wikitext('-') end		winDiv:wikitext("🏆 " .. winner)
			else
			winDiv:tag('span'):css('opacity', '0.3'):wikitext('-')
			end

	-- 7. Prize		-- Prize
	local prizeDiv = row:tag('div'):addClass('tr-prize')		local prizeDiv = row:tag('div'):addClass('tr-prize')
	prizeDiv:wikitext(formatCurrency(prize))		prizeDiv:wikitext(formatCurrency(prize))

Esportsamaze at 00:52, 28 January 2026

2026-01-28T00:52:56Z

← Older revision		Revision as of 06:22, 28 January 2026
Line 428:		Line 428:

	-- ============================================================		-- ============================================================
	-- MAIN 5: ~~MAIN~~ QUERY (~~Fix: Receives tier from Page~~)		-- MAIN 5: PAGINATED QUERY (Connects to listRow)
	-- ============================================================		-- ============================================================
	function p.mainQuery(frame)		function p.mainQuery(frame)
	~~-- 1. Get arguments from the page call~~
	local args = frame.args		local args = frame.args
	local ~~tier~~ = args.~~tier~~ or ""
			-- 1. PAGINATION SETUP
	-- 2. ~~Build Where Clause~~		-- Get offset from URL (defaults to 0 if missing)
			local offset = tonumber(args.offset) or 0
			local limit = 50 -- Show 50 tournaments per page

			-- 2. BUILD QUERY
	local whereClause = "start_date IS NOT NULL"		local whereClause = "start_date IS NOT NULL"

	-- ~~Only add tier filter if it is NOT empty and NOT just "%"~~		-- 3. RUN CARGO QUERY
	~~if tier ~= "" and tier ~= "%" then~~		-- We select the exact fields required by your p.listRow function
	-- ~~Escape quotes to be safe (basic SQL safety)~~		local results = cargo.query(
	local ~~safeTier~~ = ~~tier:gsub~~('"', '')		'Tournaments',
	~~whereClause~~ = whereClause ~~.. ' AND tier~~=~~"' .. safeTier ..~~ '"'		'_pageName, start_date, end_date, tier, prize_pool, winner, organizer, image, image_dark',
	~~end~~		{
			where = whereClause,
			orderBy = 'start_date DESC',
			limit = limit,
			offset = offset
			}
			)

	-- 3. ~~Run Cargo Query~~		-- 4. CONTAINER & EMPTY STATE
	local ~~results~~ = ~~cargo~~.~~query~~('~~Tournaments~~', '~~_pageName, start_date, end_date, tier, prize_pool, winner, organizer, image, image_dark', {~~		local container = html.create('div'):addClass('tournament-list-wrapper')
	~~where = whereClause,~~
	~~orderBy = 'start_date DESC~~',
	~~limit = 50~~
	})

	~~-- 4. Check for No Results~~
	if not results or #results == 0 then		if not results or #results == 0 then
	return '<div ~~class="tourney-row"~~ style="~~justify~~-~~content~~:center~~; padding:20px~~; color:#64748b~~; font-weight:bold~~;">No tournaments found ~~for~~ ' .. (~~tier or "this category"~~) .. '.</div>'		if offset > 0 then
			-- User went too far, give a link back to start
			return '<div style="padding:40px; text-align:center; color:#64748b;">No more tournaments found.<br><br><b>[[' .. tostring(mw.uri.fullUrl(mw.title.getCurrentTitle().text)) .. '\|Back to Start]]</b></div>'
			else
			return '<div style="padding:40px; text-align:center; color:#64748b;">No tournaments found in database.</div>'
			end
	end		end

	~~-- 5. Build Output HTML~~
	~~local container = html.create('div'):addClass('tournament-list-wrapper')~~

			-- 5. RENDER ROWS (Using your Main 3 logic)
	for _, row in ipairs(results) do		for _, row in ipairs(results) do
	local ~~rowFrame = { args~~ = {		-- We structure the data exactly how p.listRow expects it
			local rowArgs = {
	Page = row._pageName,		Page = row._pageName,
	start_date = row.start_date,		start_date = row.start_date,
Line 471:		Line 479:
	image = row.image,		image = row.image,
	image_dark = row.image_dark		image_dark = row.image_dark
	}}		}
	container:wikitext(p.listRow(~~rowFrame~~))		-- Call your existing function
			container:wikitext(p.listRow({ args = rowArgs }))
			end

			-- 6. ADD PAGINATION BUTTONS
			local navDiv = container:tag('div'):addClass('pagination-controls')

			-- "Previous" Button (Hide if on first page)
			if offset > 0 then
			local prevOffset = math.max(0, offset - limit)
			local prevUrl = mw.uri.fullUrl(mw.title.getCurrentTitle().text, {offset=prevOffset})
			navDiv:tag('span'):addClass('page-btn')
			:wikitext('[' .. tostring(prevUrl) .. ' « Newer Events]')
			end

			-- "Next" Button (Hide if we have fewer results than the limit)
			if #results == limit then
			local nextOffset = offset + limit
			local nextUrl = mw.uri.fullUrl(mw.title.getCurrentTitle().text, {offset=nextOffset})
			navDiv:tag('span'):addClass('page-btn')
			:wikitext('[' .. tostring(nextUrl) .. ' Older Events »]')
	end		end

	return tostring(container)		return tostring(container)
	end		end


	return p		return p

Esportsamaze at 00:31, 28 January 2026

2026-01-28T00:31:44Z

← Older revision		Revision as of 06:01, 28 January 2026
Line 428:		Line 428:

	-- ============================================================		-- ============================================================
	-- MAIN 5: MAIN QUERY (~~Handles URL Filters & Logic in Lua~~)		-- MAIN 5: MAIN QUERY (Fix: Receives tier from Page)
	-- ============================================================		-- ============================================================
	function p.mainQuery(frame)		function p.mainQuery(frame)
	-- 1. ~~Read URL Parameter directly (Bypasses Template confusion)~~		-- 1. Get arguments from the page call
	local tier = ~~frame:callParserFunction('#urlget', '~~tier')		local args = frame.args
			local tier = args.tier or ""

	-- 2. Build Where Clause		-- 2. Build Where Clause
	local whereClause = "start_date IS NOT NULL"		local whereClause = "start_date IS NOT NULL"

	-- Only add tier filter if it ~~exists and~~ is ~~not~~ empty		-- Only add tier filter if it is NOT empty and NOT just "%"
	if tier and tier ~= "" then		if tier ~= "" and tier ~= "%" then
	-- ~~We use pure string concatenation~~ to ~~avoid~~ SQL ~~injection risks with # characters~~		-- Escape quotes to be safe (basic SQL safety)
	whereClause = whereClause .. ' AND tier="' .. ~~tier~~ .. '"'		local safeTier = tier:gsub('"', '')
			whereClause = whereClause .. ' AND tier="' .. safeTier .. '"'
	end		end

Line 459:		Line 461:

	for _, row in ipairs(results) do		for _, row in ipairs(results) do
	~~-- Prepare arguments for the listRow function~~		local rowFrame = { args = {
	local ~~rowArgs~~ = {
	Page = row._pageName,		Page = row._pageName,
	start_date = row.start_date,		start_date = row.start_date,
Line 470:		Line 471:
	image = row.image,		image = row.image,
	image_dark = row.image_dark		image_dark = row.image_dark
	}		}}
	~~-- Reuse the existing listRow logic~~
	~~local rowFrame = { args = rowArgs~~ }
	container:wikitext(p.listRow(rowFrame))		container:wikitext(p.listRow(rowFrame))
	end		end

Esportsamaze at 00:29, 28 January 2026

2026-01-28T00:29:41Z

@@ Line 426: / Line 426: @@
      return tostring(row)
 end
 return p