Module:PadUtils - Revision history

GlifterPad at 21:02, 22 August 2025

2025-08-22T21:02:54Z

@@ Line 36: / Line 36: @@
      end
      return base .. "/" .. target
 end
@@ Line 292: / Line 267: @@
 end
 return p

GlifterPad at 21:01, 22 August 2025

2025-08-22T21:01:49Z

Show changes

GlifterPad at 06:24, 22 August 2025

2025-08-22T06:24:20Z

← Older revision		Revision as of 06:24, 22 August 2025
Line 230:		Line 230:
	end		end

	-- Group drop locations by Dungeon (dungeon ~~header is~~ plain text; floors ~~are links~~)		-- Group drop locations by Dungeon (with header, dungeon name plain text, floors linked)
	-- Usage: {{#invoke:PadUtils\|dropLocationsGrouped\|item=Dragon Seed}}		-- Usage: {{#invoke:PadUtils\|dropLocationsGrouped\|item=Dragon Seed}}
	function p.dropLocationsGrouped(frame)		function p.dropLocationsGrouped(frame)
	local item = mw.text.trim(frame.args.item or mw.title.getCurrentTitle().text or "")		local item = mw.text.trim(frame.args.item or mw.title.getCurrentTitle().text or "")
	if item == "" then return "~~None~~" end		if item == "" then return "=== Dungeon Drop ===\nNone" end

	~~-- strip any [[...]] if they slipped into Cargo fields~~
	local function stripLinks(s)		local function stripLinks(s)
	s = mw.text.trim(s or "")		s = mw.text.trim(s or "")
Line 243:		Line 242:
	end		end

	-- query ~~Cargo~~: ~~Drops is a List field → use HOLDS "value"~~		-- Cargo query: find all floors that drop the item
	local rows = mw.ext.cargo.query(		local rows = mw.ext.cargo.query(
	'dungeon_floors',		'dungeon_floors',
Line 253:		Line 252:
	}		}
	)		)
	~~if not rows or #rows == 0 then return "None" end~~

	-- ~~normalize/group~~ by dungeon ~~(handle underscores/spaces + stray links)~~		-- If no results, just show header + "None"
	local groups = {}		if not rows or #rows == 0 then
	~~local order =~~ {}		return "=== Dungeon Drop ===\nNone"
			end

			-- Group results by dungeon
			local groups, order = {}, {}
	for _, r in ipairs(rows) do		for _, r in ipairs(rows) do
	local rawDungeon = stripLinks(r.Dungeon)		local rawDungeon = stripLinks(r.Dungeon)
	local t = mw.title.new(rawDungeon)		local t = mw.title.new(rawDungeon)
	local label = t and t.text or (rawDungeon:gsub("_", " "))		local label = t and t.text or (rawDungeon:gsub("_", " "))
	local key = label ~~-- stable grouping key~~		local key = label

	if not groups[key] then		if not groups[key] then
Line 271:		Line 273:
	end		end

	table.sort(order) ~~-- sort dungeons A→Z~~		-- Sort groups + floors alphabetically
	for _, k in ipairs(order) do table.sort(groups[k].floors) end ~~-- sort floors A→Z~~		table.sort(order)
			for _, k in ipairs(order) do table.sort(groups[k].floors) end

	-- ~~build wikitext~~: dungeon as plain ~~line, floors as bullets~~		-- Build output: header → dungeon plain text → bullet list of floor links
	local out = {}		local out = { "=== Dungeon Drop ===" }
	for i, k in ipairs(order) do		for i, k in ipairs(order) do
	local g = groups[k]		local g = groups[k]
Line 283:		Line 286:
	table.insert(out, '* [[' .. target .. '\|' .. fname .. ']]')		table.insert(out, '* [[' .. target .. '\|' .. fname .. ']]')
	end		end
	if i < #order then table.insert(out, '') end -- ~~blank line~~ between groups~~, not after last~~		if i < #order then table.insert(out, '') end -- spacing between groups
	end		end

GlifterPad at 06:21, 22 August 2025

2025-08-22T06:21:08Z

@@ Line 228: / Line 228: @@
      return table.concat(out, '\n')
 end
 return p

GlifterPad at 06:18, 22 August 2025

2025-08-22T06:18:16Z

← Older revision		Revision as of 06:18, 22 August 2025
Line 195:		Line 195:
	-- List all dungeon floors that drop a given item.		-- List all dungeon floors that drop a given item.
	-- Usage on the item page:		-- Usage on the item page:
	-- {~~{#invoke:PadUtils\|dropLocations\|item~~=~~Dragon Seed}}~~		local p = {}
			local cargo = mw.ext.cargo

	function p.dropLocations(frame)		function p.dropLocations(frame)
	local item = ~~mw.text.trim(~~frame.args.item ~~or mw.title.getCurrentTitle().text or "")~~		local item = frame.args.item
	if item ~~== "" then return "None" end~~		if not item or item == '' then return '' end

	~~local function stripLinks(s)~~
	~~s = mw.text.trim(s~~ or ~~"")~~
	~~local inner = s:match("^%[%[(.*)%]%]$")~~
	~~return mw.text.trim(inner or s)~~
	~~end~~

	~~-- Cargo expects HOLDS "value" (double quotes) for List fields.~~
	~~-- We also include a LIKE fallback in case any rows were stored oddly.~~
	~~local itemEsc~~ = ~~item:gsub('"', '""') -- escape double quotes~~
	~~local where~~ = ~~string.format(~~
	'~~(Drops HOLDS "%s") OR (Drops LIKE "%%%s%%")~~',
	~~itemEsc, item:gsub(~~'%%'~~, '%%%%'):gsub('"','""')~~
	)

	local ~~rows~~ = ~~mw.ext.~~cargo.query(		local results = cargo.query(
	'dungeon_floors',		'dungeon_floors',
	'Dungeon, Name',		'Dungeon, Name',
	{ where = ~~where~~, orderBy = 'Dungeon, Name', limit = 5000 }		{
			where = string.format('Drops HOLDS "%s"', item),
			orderBy = 'Dungeon, Name',
			limit = 5000
			}
	)		)

	~~if not rows or #rows == 0 then~~
	~~return "None"~~
	~~end~~

	local out = {}		local out = {}
	for _, r in ipairs(~~rows~~) do		for _, row in ipairs(results) do
	local dungeon = ~~stripLinks(r~~.Dungeon)		local dungeon = row.Dungeon or ''
	local ~~floor~~ = ~~stripLinks(r~~.Name)		local name = row.Name or ''

	~~-- Normalize to a proper internal title for linking~~
	~~local dungeonTitle = mw.title.new(dungeon)~~
	~~local dungeonLink = (dungeonTitle and dungeonTitle.prefixedText)~~ or ~~dungeon~~

	~~local targetTitle = mw.title.new~~(~~dungeonLink .. '/' .. floor~~)		-- Strip any existing brackets in Dungeon (like [[Thursday Dungeon]])
	~~local linkTarget~~ = (~~targetTitle and targetTitle.prefixedText~~) or (~~dungeonLink ..~~ '/' ~~.. floor~~)		dungeon = dungeon:gsub('%[%[', ''):gsub('%]%]', '')

	table.insert(out, '* [[~~' .. linkTarget .. '~~\|~~' .. floor .. '~~]]')		-- Link directly to Dungeon/Floor
			table.insert(out, string.format(
			'* [[%s/%s\|%s]]',
			dungeon, name, name
			))
	end		end

	return ~~frame:preprocess(~~table.concat(out, '\n'))		return table.concat(out, '\n')
	end		end

	return p		return p

GlifterPad at 06:05, 22 August 2025

2025-08-22T06:05:30Z

← Older revision		Revision as of 06:05, 22 August 2025
Line 197:		Line 197:
	-- {{#invoke:PadUtils\|dropLocations\|item=Dragon Seed}}		-- {{#invoke:PadUtils\|dropLocations\|item=Dragon Seed}}
	function p.dropLocations(frame)		function p.dropLocations(frame)
	local item = mw.text.trim(frame.args.item or "")		local item = mw.text.trim(frame.args.item or mw.title.getCurrentTitle().text or "")
	if item == "" then return "None" end		if item == "" then return "None" end

GlifterPad at 06:02, 22 August 2025

2025-08-22T06:02:01Z

← Older revision		Revision as of 06:02, 22 August 2025
Line 194:		Line 194:

	-- List all dungeon floors that drop a given item.		-- List all dungeon floors that drop a given item.
	-- Usage (on an item page): {{#invoke:PadUtils\|dropLocations\|item=Dragon Seed}}		-- Usage on the item page:
			-- {{#invoke:PadUtils\|dropLocations\|item=Dragon Seed}}
	function p.dropLocations(frame)		function p.dropLocations(frame)
	local item = mw.text.trim(frame.args.item or "")		local item = mw.text.trim(frame.args.item or "")
	if item == "" then return "~~''(no item given)''~~" end		if item == "" then return "None" end

	~~-- Helper: strip [[...]] and trim~~
	local function stripLinks(s)		local function stripLinks(s)
	s = mw.text.trim(s or "")		s = mw.text.trim(s or "")
Line 206:		Line 206:
	end		end

	-- ~~Query~~ Cargo~~. Prefer~~ HOLDS (~~works on~~ List fields); include LIKE ~~as a~~ fallback		-- Cargo expects HOLDS "value" (double quotes) for List fields.
	local itemEsc = item:gsub("'", "''")		-- We also include a LIKE fallback in case any rows were stored oddly.
	local where = string.format("Drops HOLDS '%s' OR Drops LIKE '%%%s%%'", itemEsc, ~~itemEsc~~)		local itemEsc = item:gsub('"', '""') -- escape double quotes
			local where = string.format(
			'(Drops HOLDS "%s") OR (Drops LIKE "%%%s%%")',
			itemEsc, item:gsub('%%', '%%%%'):gsub('"','""')
			)

	local rows = mw.ext.cargo.query(		local rows = mw.ext.cargo.query(
Line 220:		Line 224:
	end		end

	~~-- Build a simple bullet list: [[Dungeon/Name\|Name]] (label = floor name)~~
	local out = {}		local out = {}
	for _, r in ipairs(rows) do		for _, r in ipairs(rows) do
	local dungeon = stripLinks(r.Dungeon) ~~-- normalize against stray [[...]]~~		local dungeon = stripLinks(r.Dungeon)
	~~dungeon = (mw.title.new(dungeon) and mw.title.new(dungeon).prefixedText) or dungeon~~
	local floor = stripLinks(r.Name)		local floor = stripLinks(r.Name)

	local ~~target~~ = ~~dungeon~~ .. ~~'/'~~ .~~. floor~~		-- Normalize to a proper internal title for linking
	local t = mw.title.new(~~target~~)		local dungeonTitle = mw.title.new(dungeon)
	local linkTarget = (t and t.prefixedText) or ~~target~~		local dungeonLink = (dungeonTitle and dungeonTitle.prefixedText) or dungeon

			local targetTitle = mw.title.new(dungeonLink .. '/' .. floor)
			local linkTarget = (targetTitle and targetTitle.prefixedText) or (dungeonLink .. '/' .. floor)

	table.insert(out, '* [[' .. linkTarget .. '\|' .. floor .. ']]')		table.insert(out, '* [[' .. linkTarget .. '\|' .. floor .. ']]')
	end		end

	~~-- Render as wikitext (bullets + links)~~
	return frame:preprocess(table.concat(out, '\n'))		return frame:preprocess(table.concat(out, '\n'))
	end		end

	return p		return p

GlifterPad at 05:59, 22 August 2025

2025-08-22T05:59:33Z

← Older revision		Revision as of 05:59, 22 August 2025
Line 193:		Line 193:
	end		end

			-- List all dungeon floors that drop a given item.
			-- Usage (on an item page): {{#invoke:PadUtils\|dropLocations\|item=Dragon Seed}}
			function p.dropLocations(frame)
			local item = mw.text.trim(frame.args.item or "")
			if item == "" then return "''(no item given)''" end

			-- Helper: strip [[...]] and trim
			local function stripLinks(s)
			s = mw.text.trim(s or "")
			local inner = s:match("^%[%[(.*)%]%]$")
			return mw.text.trim(inner or s)
			end

			-- Query Cargo. Prefer HOLDS (works on List fields); include LIKE as a fallback
			local itemEsc = item:gsub("'", "''")
			local where = string.format("Drops HOLDS '%s' OR Drops LIKE '%%%s%%'", itemEsc, itemEsc)

			local rows = mw.ext.cargo.query(
			'dungeon_floors',
			'Dungeon, Name',
			{ where = where, orderBy = 'Dungeon, Name', limit = 5000 }
			)

			if not rows or #rows == 0 then
			return "None"
			end

			-- Build a simple bullet list: [[Dungeon/Name\|Name]] (label = floor name)
			local out = {}
			for _, r in ipairs(rows) do
			local dungeon = stripLinks(r.Dungeon) -- normalize against stray [[...]]
			dungeon = (mw.title.new(dungeon) and mw.title.new(dungeon).prefixedText) or dungeon
			local floor = stripLinks(r.Name)

			local target = dungeon .. '/' .. floor
			local t = mw.title.new(target)
			local linkTarget = (t and t.prefixedText) or target

			table.insert(out, '* [[' .. linkTarget .. '\|' .. floor .. ']]')
			end

			-- Render as wikitext (bullets + links)
			return frame:preprocess(table.concat(out, '\n'))
			end

	return p		return p

GlifterPad at 05:42, 22 August 2025

2025-08-22T05:42:51Z

← Older revision		Revision as of 05:42, 22 August 2025
Line 94:		Line 94:
	end		end

	~~-- Query Cargo~~
	local rows = mw.ext.cargo.query(		local rows = mw.ext.cargo.query(
	'dungeon_floors',		'dungeon_floors',
Line 104:		Line 103:
	end		end

	-- ~~helper:~~ strip [[...]] ~~if present, then trim~~		-- strip [[...]] helper
	local function stripLinks(s)		local function stripLinks(s)
	s = mw.text.trim(s or "")		s = mw.text.trim(s or "")
Line 111:		Line 110:
	end		end

	local ~~out~~, ~~current~~ = {}, ~~nil~~		-- normalize a dungeon to a stable key + link target + display
			local function normalizeDungeon(raw)
			local s = stripLinks(raw)
			-- try to build a proper Title; this normalizes spaces/underscores
			local t = mw.title.new(s)
			if t then
			return t.prefixedText, t.prefixedText, t.text -- key, link target, display text
			else
			-- fallback: treat underscores/spaces as equivalent
			local display = (s:gsub("_", " "))
			return display, s, display
			end
			end

			-- group floors by normalized dungeon key
			local groups, order = {}, {}
	for _, r in ipairs(rows) do		for _, r in ipairs(rows) do
	local ~~dungeon~~ = ~~stripLinks~~(r.Dungeon)		local key, linkTarget, display = normalizeDungeon(r.Dungeon)
	~~local floor~~ = stripLinks(r.Name)		if not groups[key] then
			groups[key] = { link = linkTarget, label = display, floors = {} }
			table.insert(order, key)
			end
			table.insert(groups[key].floors, stripLinks(r.Name))
			end

	~~-- New dungeon header line~~ (as a ~~wiki link~~)		table.sort(order, function(a, b) return groups[a].label < groups[b].label end)
	if dungeon ~~~= current then~~		-- sort floors alphabetically within each dungeon
	~~if current then~~ table.~~insert~~(~~out, ""~~) end -- ~~blank~~ line ~~between~~ groups		for _, k in ipairs(order) do table.sort(groups[k].floors) end
	table.insert(out, string.format('[[%s\|%s]]', ~~dungeon~~, ~~dungeon~~))
	~~current~~ = ~~dungeon~~		-- build wikitext: dungeon as link on its own line, floors as bullets
			local out = {}
			for _, k in ipairs(order) do
			local g = groups[k]
			table.insert(out, string.format('[[%s\|%s]]', g.link, g.label))
			for _, fname in ipairs(g.floors) do
			local target = g.link .. '/' .. fname
			table.insert(out, '* [[' .. target .. '\|' .. fname .. ']]')
	end		end
			table.insert(out, "") -- blank line between dungeons
	~~-- Bullet line with floor link: [[Dungeon/Floor\|Floor]]~~
	~~local target = dungeon .. '/' .. floor~~
	table.insert(out, ~~'* [[' .. target .. '\|' .. floor .. ']]'~~)
	end		end

	~~-- Parse as wikitext so the links/bullets render~~
	return frame:preprocess(table.concat(out, "\n"))		return frame:preprocess(table.concat(out, "\n"))
	end		end

GlifterPad at 05:40, 22 August 2025

2025-08-22T05:40:33Z

← Older revision		Revision as of 05:40, 22 August 2025
Line 88:		Line 88:
	-- (repeats for each dungeon)		-- (repeats for each dungeon)
	function p.dungeonIndex(frame)		function p.dungeonIndex(frame)
	local args = frame.args		local args = frame.args
	local where = nil		local where = nil
	if args.type and args.type ~= "" then		if args.type and args.type ~= "" then
	where = string.format("Type = '%s'", tostring(args.type):gsub("'", "''"))		where = string.format("Type = '%s'", tostring(args.type):gsub("'", "''"))
	end		end

	-- ~~Pull rows, sorted by Dungeon then Name~~		-- Query Cargo
	local rows = mw.ext.cargo.query(		local rows = mw.ext.cargo.query(
	'dungeon_floors',		'dungeon_floors',
Line 104:		Line 104:
	end		end

	~~local root = mw~~.~~html~~.~~create('div') -- container~~		-- helper: strip [[...]] if present, then trim
	~~local currentDungeon = nil~~		local function stripLinks(s)
	~~local ulForDungeon = nil~~		s = mw.text.trim(s or "")
			local inner = s:match("^%[%[(.*)%]%]$")
	local function ~~urlFor~~(~~titleText~~)		return mw.text.trim(inner or s)
	~~local t~~ = mw.~~title~~.~~new~~(~~titleText~~)
	~~return t and t~~:~~localUrl~~() ~~or (~~"~~/wiki/" ..~~ mw.~~uri~~.~~encode~~(~~titleText)~~)
	end		end

			local out, current = {}, nil
	for _, r in ipairs(rows) do		for _, r in ipairs(rows) do
	~~-- New~~ dungeon ~~group?~~		local dungeon = stripLinks(r.Dungeon)
	if r.Dungeon ~~~= currentDungeon then~~		local floor = stripLinks(r.Name)
	~~currentDungeon~~ = r.~~Dungeon~~
	-- ~~Dungeon~~ header ~~link~~		-- New dungeon header line (as a wiki link)
	~~root:tag~~('a')		if dungeon ~= current then
	~~:attr('href', urlFor(currentDungeon))~~		if current then table.insert(out, "") end -- blank line between groups
	~~:wikitext(currentDungeon)~~		table.insert(out, string.format('[[%s\|%s]]', dungeon, dungeon))
	~~:done~~()		current = dungeon
	-- ~~Start a <ul> for its floors~~
	~~ulForDungeon = root:tag~~('ul')
	end		end

	-- ~~Floor item~~ link: Dungeon/Floor		-- Bullet line with floor link: [[Dungeon/Floor\|Floor]]
	local target = ~~currentDungeon~~ .. "/~~" .~~. r.~~Name~~		local target = dungeon .. '/' .. floor
	~~ulForDungeon:tag~~('li')		table.insert(out, '* [[' .. target .. '\|' .. floor .. ']]')
	~~:tag(~~'a')
	~~:attr(~~'~~href~~'~~, urlFor(target))~~
	~~:wikitext(r.Name)~~
	~~:done()~~
	~~:done(~~)
	end		end

	return ~~tostring~~(~~root~~)		-- Parse as wikitext so the links/bullets render
			return frame:preprocess(table.concat(out, "\n"))
	end		end