Module:BaseListTable - Revision history

Max: Adds roman numeral support

2025-06-24T14:41:40Z

Adds roman numeral support

← Older revision		Revision as of 14:41, 24 June 2025
Line 1:		Line 1:
	local p = {}		local p = {}
	local cargo = mw.ext.cargo		local cargo = mw.ext.cargo

			local function romanToInt(roman)
			local map = {I=1, V=5, X=10, L=50, C=100, D=500, M=1000}
			local total = 0
			local prev = 0
			for i = #roman, 1, -1 do
			local curr = map[roman:sub(i, i):upper()] or 0
			if curr < prev then
			total = total - curr
			else
			total = total + curr
			end
			prev = curr
			end
			return total
			end

			local function extractSeasonNumber(seasonStr)
			if not seasonStr then return 0 end
			local suffix = seasonStr:match("Season%s+(.+)")
			if not suffix then return 0 end

			local num = tonumber(suffix)
			if num then
			return num
			else
			return romanToInt(suffix)
			end
			end

	function p.Main(frame)		function p.Main(frame)
Line 6:		Line 35:
	local fields = 'season,basename,owner,basetype,location,dateestablished'		local fields = 'season,basename,owner,basetype,location,dateestablished'
	local args = {		local args = {
	~~orderBy = 'season ASC, basename ASC',~~		limit = 1000
	limit = ~~100 -- Optional; remove or increase if needed~~
	}		}

	local results = cargo.query(tables, fields, args)		local results = cargo.query(tables, fields, args)

			table.sort(results, function(a, b)
			local sa = extractSeasonNumber(a.season)
			local sb = extractSeasonNumber(b.season)
			if sa ~= sb then
			return sa > sb -- Descending order
			end
			return (a.basename or '') < (b.basename or '')
			end)

	local out = {}		local out = {}
Line 17:		Line 54:

	for _, row in ipairs(results) do		for _, row in ipairs(results) do
	local season = ''		local season = row.season or ''
	if row.season ~~then~~
	~~season = row.season:sub(3, -3)~~
	~~end~~

	if row.basename ~= '$1' and row.basename ~= 'Creeper Cove' then		if row.basename ~= '$1' and row.basename ~= 'Creeper Cove' then
	table.insert(out, '\|-')		table.insert(out, '\|-')
	table.insert(out, string.format('\| %s \|\| [[%s]] \|\| %s \|\| %s \|\| %s \|\| %s',		table.insert(out, string.format('\| %s \|\| [[%s]] \|\| %s \|\| %s \|\| %s \|\| %s',
	season ~~or ''~~,		season,
	row.basename or '',		row.basename or '',
	row.owner or '',		row.owner or '',
	row.basetype or '',		row.basetype or '',
	row.location or '',		row.location or '',
	row.dateestablished or ''		row.dateestablished or ''
	))		))
	end		end
	end		end

Noah: used links in the wrong place

2025-06-24T14:09:50Z

used links in the wrong place

← Older revision		Revision as of 14:09, 24 June 2025
Line 22:		Line 22:
	end		end

	if row.basename ~= '[[$1]]' and row.basename ~= '[[Creeper Cove]]' then		if row.basename ~= '$1' and row.basename ~= 'Creeper Cove' then
	table.insert(out, '\|-')		table.insert(out, '\|-')
	table.insert(out, string.format('\| %s \|\| [[%s]] \|\| %s \|\| %s \|\| %s \|\| %s',		table.insert(out, string.format('\| %s \|\| [[%s]] \|\| %s \|\| %s \|\| %s \|\| %s',

Noah: used wrong boolean operator

2025-06-24T14:08:37Z

used wrong boolean operator

← Older revision		Revision as of 14:08, 24 June 2025
Line 22:		Line 22:
	end		end

	if row.basename == '[[$1]]' or row.basename == '[[Creeper Cove]]' then		if row.basename ~= '[[$1]]' and row.basename ~= '[[Creeper Cove]]' then
	table.insert(out, '\|-')		table.insert(out, '\|-')
	table.insert(out, string.format('\| %s \|\| [[%s]] \|\| %s \|\| %s \|\| %s \|\| %s',		table.insert(out, string.format('\| %s \|\| [[%s]] \|\| %s \|\| %s \|\| %s \|\| %s',

Noah: excluded example data

2025-06-24T14:07:12Z

excluded example data

← Older revision		Revision as of 14:07, 24 June 2025
Line 22:		Line 22:
	end		end

			if row.basename == '[[$1]]' or row.basename == '[[Creeper Cove]]' then
	table.insert(out, '\|-')		table.insert(out, '\|-')
	table.insert(out, string.format('\| %s \|\| [[%s]] \|\| %s \|\| %s \|\| %s \|\| %s',		table.insert(out, string.format('\| %s \|\| [[%s]] \|\| %s \|\| %s \|\| %s \|\| %s',
Line 31:		Line 32:
	row.dateestablished or ''		row.dateestablished or ''
	))		))
			end
	end		end

Noah: fixed again

2025-06-24T14:03:12Z

fixed again

← Older revision		Revision as of 14:03, 24 June 2025
Line 17:		Line 17:

	for _, row in ipairs(results) do		for _, row in ipairs(results) do
			local season = ''
	if row.season then		if row.season then
	~~local~~ season = row.season:sub(3, -3)		season = row.season:sub(3, -3)
	end		end

Noah: fixed error on page

2025-06-24T14:02:35Z

fixed error on page

← Older revision		Revision as of 14:02, 24 June 2025
Line 17:		Line 17:

	for _, row in ipairs(results) do		for _, row in ipairs(results) do
	local season = row.season:sub(3, -3)		if row.season then
			local season = row.season:sub(3, -3)
			end

	table.insert(out, '\|-')		table.insert(out, '\|-')
	table.insert(out, string.format('\| %s \|\| [[%s]] \|\| %s \|\| %s \|\| %s \|\| %s',		table.insert(out, string.format('\| %s \|\| [[%s]] \|\| %s \|\| %s \|\| %s \|\| %s',

Noah: base name links

2025-06-24T13:07:22Z

base name links

← Older revision		Revision as of 13:07, 24 June 2025
Line 17:		Line 17:

	for _, row in ipairs(results) do		for _, row in ipairs(results) do
			local season = row.season:sub(3, -3)
	table.insert(out, '\|-')		table.insert(out, '\|-')
	table.insert(out, string.format('\| %s \|\| %s \|\| %s \|\| %s \|\| %s \|\| %s',		table.insert(out, string.format('\| %s \|\| [[%s]] \|\| %s \|\| %s \|\| %s \|\| %s',
	~~row.~~season or '',		season or '',
	row.basename or '',		row.basename or '',
	row.owner or '',		row.owner or '',

Noah: created base list module

2025-06-24T12:49:35Z

created base list module

New page

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

function p.Main(frame)
local tables = 'base_data'
local fields = 'season,basename,owner,basetype,location,dateestablished'
local args = {
orderBy = 'season ASC, basename ASC',
limit = 100 -- Optional; remove or increase if needed
}

local results = cargo.query(tables, fields, args)

local out = {}
table.insert(out, '{| class="wikitable sortable plainlinks"')
table.insert(out, '! Season !! Base !! Owner !! Type !! Location !! Established')

for _, row in ipairs(results) do
table.insert(out, '|-')
table.insert(out, string.format('| %s || %s || %s || %s || %s || %s',
row.season or '',
row.basename or '',
row.owner or '',
row.basetype or '',
row.location or '',
row.dateestablished or ''
))
end

table.insert(out, '|}')
return table.concat(out, '\n')
end

return p