Module:ShopListTable - Revision history

Noah: updated shop type

2025-06-24T14:56:19Z

updated shop type

← Older revision		Revision as of 14:56, 24 June 2025
Line 28:		Line 28:
	row.shopname or '',		row.shopname or '',
	row.shopowner or '',		row.shopowner or '',
	row.~~basetype~~ or '',		row.shoptype or '',
	row.location or '',		row.location or '',
	row.dateopened or ''		row.dateopened or ''

Noah: fixed query

2025-06-24T14:51:20Z

fixed query

← Older revision		Revision as of 14:51, 24 June 2025
Line 6:		Line 6:
	local fields = 'season,shopname,shopowner,shoptype,location,dateopened'		local fields = 'season,shopname,shopowner,shoptype,location,dateopened'
	local args = {		local args = {
	orderBy = 'season ASC, ~~basename~~ ASC',		orderBy = 'season ASC, shopname ASC',
	limit = 100 -- Optional; remove or increase if needed		limit = 100 -- Optional; remove or increase if needed
	}		}

Noah: fixed dateestablished being used instead of dateopened

2025-06-24T14:50:49Z

fixed dateestablished being used instead of dateopened

← Older revision		Revision as of 14:50, 24 June 2025
Line 4:		Line 4:
	function p.Main(frame)		function p.Main(frame)
	local tables = 'shop_data'		local tables = 'shop_data'
	local fields = 'season,shopname,shopowner,shoptype,location,~~dateestablished~~'		local fields = 'season,shopname,shopowner,shoptype,location,dateopened'
	local args = {		local args = {
	orderBy = 'season ASC, basename ASC',		orderBy = 'season ASC, basename ASC',
Line 30:		Line 30:
	row.basetype or '',		row.basetype or '',
	row.location or '',		row.location or '',
	row.~~dateestablished~~ or ''		row.dateopened or ''
	))		))
	end		end

Noah: fixed using owner instead of shopowner

2025-06-24T14:49:55Z

fixed using owner instead of shopowner

← Older revision		Revision as of 14:49, 24 June 2025
Line 4:		Line 4:
	function p.Main(frame)		function p.Main(frame)
	local tables = 'shop_data'		local tables = 'shop_data'
	local fields = 'season,shopname,~~owner~~,shoptype,location,dateestablished'		local fields = 'season,shopname,shopowner,shoptype,location,dateestablished'
	local args = {		local args = {
	orderBy = 'season ASC, basename ASC',		orderBy = 'season ASC, basename ASC',
Line 22:		Line 22:
	end		end

	if row.~~basename~~ ~= '$1' and row.~~basename~~ ~= 'Diamond Emporium' then		if row.shopname ~= '$1' and row.shopname ~= 'Diamond Emporium' 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 or '',
	row.shopname or '',		row.shopname or '',
	row.~~owner~~ or '',		row.shopowner or '',
	row.basetype or '',		row.basetype or '',
	row.location or '',		row.location or '',

Noah: fixed shop list table

2025-06-24T14:48:52Z

fixed shop list table

← Older revision		Revision as of 14:48, 24 June 2025
Line 3:		Line 3:

	function p.Main(frame)		function p.Main(frame)
	local tables = '~~base_data~~'		local tables = 'shop_data'
	local fields = 'season,~~basename~~,owner,~~basetype~~,location,dateestablished'		local fields = 'season,shopname,owner,shoptype,location,dateestablished'
	local args = {		local args = {
	orderBy = 'season ASC, basename ASC',		orderBy = 'season ASC, basename ASC',
Line 14:		Line 14:
	local out = {}		local out = {}
	table.insert(out, '{\| class="wikitable sortable plainlinks"')		table.insert(out, '{\| class="wikitable sortable plainlinks"')
	table.insert(out, '! Season !! ~~Base~~ !! Owner !! Type !! Location !! Established')		table.insert(out, '! Season !! Shop !! Owner !! Type !! Location !! Established')

	for _, row in ipairs(results) do		for _, row in ipairs(results) do
Line 22:		Line 22:
	end		end

	if row.basename ~= '$1' and row.basename ~= '~~Creeper Cove~~' then		if row.basename ~= '$1' and row.basename ~= 'Diamond Emporium' 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 or '',
	row.~~basename~~ or '',		row.shopname or '',
	row.owner or '',		row.owner or '',
	row.basetype or '',		row.basetype or '',

Dex: Created page with "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 !! Locat..."

2025-06-24T14:33:40Z

Created page with "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 !! Locat..."

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
local season = ''
if row.season then
season = row.season:sub(3, -3)
end

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

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

return p