Module:Sandbox/Aurelain/UnitInfobox - Revision history

76561198048502585 at 08:48, 20 July 2026

2026-07-20T08:48:23Z

← Older revision		Revision as of 08:48, 20 July 2026
Line 83:		Line 83:
	------------------------------------------------------------------------------------------------------------------------		------------------------------------------------------------------------------------------------------------------------
	function p.findGrowth(frame)		function p.findGrowth(frame)
	~~-- TODO: Read this value from MapObject, once we have it in Cargo.~~
	local unitId = frame.args.id		local unitId = frame.args.id
	local baseId = getBaseId(unitId)		local baseId = getBaseId(unitId)
	local table = runQuery([[		local table = runQuery([[
	tables =		tables =
	~~Building~~ = B		MapObject = M
	\| where =		\| where =
	B.units_hire_sid = "%s"		M.units_hire_sid = '%s'
	\| fields =		\| fields =
	B.units_weekly = units_weekly		M.units_weekly = units_weekly
	\| limit =		\| limit =
	1		1
	]], baseId);		]], baseId);
	local growth = (table[1] or { units_weekly = '' }).units_weekly		local growth = (table[1] or { units_weekly = '' }).units_weekly
			return growth;
	~~if growth ~= '' then~~
	return growth
	~~end~~

	~~return ''~~;
	end		end

76561198048502585 at 11:56, 19 July 2026

2026-07-19T11:56:00Z

← Older revision		Revision as of 11:56, 19 July 2026
Line 188:		Line 188:
	local unitId = frame.args.id		local unitId = frame.args.id
	local nameEn = getEnglishBaseUnitName(unitId)		local nameEn = getEnglishBaseUnitName(unitId)
			local nameEnWithSmartApostrophe = nameEn:gsub("'", '’')
	local table = runQuery([[		local table = runQuery([[
	tables =		tables =
Line 194:		Line 195:
	T.type = 'hero_specialization'		T.type = 'hero_specialization'
	AND T.language = 'en'		AND T.language = 'en'
	AND T.description LIKE "%s growth in your cities increases by%%"		AND (T.description LIKE "%s growth in your cities increases by%%" OR
			T.description LIKE "%s growth in your cities increases by%%")
	\| fields =		\| fields =
	T.target_id = target_id		T.target_id = target_id
	\| limit =		\| limit =
	1		1
	]], nameEn);		]], nameEn, nameEnWithSmartApostrophe);
	local specialist = (table[1] or {target_id = ''}).target_id		local specialist = (table[1] or {target_id = ''}).target_id
	specialist = specialist:gsub('_specialization', '')		specialist = specialist:gsub('_specialization', '')

76561198048502585 at 11:53, 19 July 2026

2026-07-19T11:53:24Z

← Older revision		Revision as of 11:53, 19 July 2026
Line 70:		Line 70:
	U.id = T.target_id		U.id = T.target_id
	\| where =		\| where =
	U.id = '%s'		U.id = "%s"
	AND T.language = 'en'		AND T.language = 'en'
	AND T.type = 'unit'		AND T.type = 'unit'
Line 194:		Line 194:
	T.type = 'hero_specialization'		T.type = 'hero_specialization'
	AND T.language = 'en'		AND T.language = 'en'
	AND T.description LIKE '%s growth in your cities increases by%%'		AND T.description LIKE "%s growth in your cities increases by%%"
	\| fields =		\| fields =
	T.target_id = target_id		T.target_id = target_id

76561198048502585 at 11:52, 19 July 2026

2026-07-19T11:52:26Z

← Older revision		Revision as of 11:52, 19 July 2026
Line 49:		Line 49:
	end		end
	end		end
	return mw.ext.cargo.query(tables, fields, options)		local success, result = pcall(function()
			return mw.ext.cargo.query(tables, fields, options)
			end)
			return success and result or {}
	end		end

76561198048502585 at 11:47, 19 July 2026

2026-07-19T11:47:16Z

← Older revision		Revision as of 11:47, 19 July 2026
Line 191:		Line 191:
	T.type = 'hero_specialization'		T.type = 'hero_specialization'
	AND T.language = 'en'		AND T.language = 'en'
	AND T.description LIKE "%s growth in your cities increases by%%"		AND T.description LIKE '%s growth in your cities increases by%%'
	\| fields =		\| fields =
	T.target_id = target_id		T.target_id = target_id

76561198048502585 at 11:46, 19 July 2026

2026-07-19T11:46:22Z

← Older revision		Revision as of 11:46, 19 July 2026
Line 67:		Line 67:
	U.id = T.target_id		U.id = T.target_id
	\| where =		\| where =
	U.id = "%s"		U.id = '%s'
	AND T.language = 'en'		AND T.language = 'en'
	AND T.type = 'unit'		AND T.type = 'unit'

76561198048502585 at 11:33, 19 July 2026

2026-07-19T11:33:00Z

← Older revision		Revision as of 11:33, 19 July 2026
Line 185:		Line 185:
	local unitId = frame.args.id		local unitId = frame.args.id
	local nameEn = getEnglishBaseUnitName(unitId)		local nameEn = getEnglishBaseUnitName(unitId)
	~~do return nameEn end~~
	local table = runQuery([[		local table = runQuery([[
	tables =		tables =

76561198048502585 at 11:32, 19 July 2026

2026-07-19T11:32:46Z

← Older revision		Revision as of 11:32, 19 July 2026
Line 67:		Line 67:
	U.id = T.target_id		U.id = T.target_id
	\| where =		\| where =
	U.id = '%s'		U.id = "%s"
	AND T.language = 'en'		AND T.language = 'en'
	AND T.type = 'unit'		AND T.type = 'unit'
Line 87:		Line 87:
	Building = B		Building = B
	\| where =		\| where =
	B.units_hire_sid = '%s'		B.units_hire_sid = "%s"
	\| fields =		\| fields =
	B.units_weekly = units_weekly		B.units_weekly = units_weekly
Line 114:		Line 114:
	B.id = E.target_id		B.id = E.target_id
	\| where =		\| where =
	B.units_hire_sid = '%s'		B.units_hire_sid = "%s"
	AND T.language = '%s'		AND T.language = "%s"
	AND E.language = 'en'		AND E.language = 'en'
	\| fields =		\| fields =
Line 152:		Line 152:
	E.type = 'map_object'		E.type = 'map_object'
	AND E.language = 'en'		AND E.language = 'en'
	AND E.description LIKE '%s %s%%'		AND E.description LIKE "%s %s%%"
	AND T.type = 'map_object'		AND T.type = 'map_object'
	AND T.language = '%s'		AND T.language = "%s"
	\| fields =		\| fields =
	E.name = name_en,		E.name = name_en,
Line 192:		Line 192:
	T.type = 'hero_specialization'		T.type = 'hero_specialization'
	AND T.language = 'en'		AND T.language = 'en'
	AND T.description LIKE '%s growth in your cities increases by%%'		AND T.description LIKE "%s growth in your cities increases by%%"
	\| fields =		\| fields =
	T.target_id = target_id		T.target_id = target_id

76561198048502585 at 11:31, 19 July 2026

2026-07-19T11:31:31Z

← Older revision		Revision as of 11:31, 19 July 2026
Line 185:		Line 185:
	local unitId = frame.args.id		local unitId = frame.args.id
	local nameEn = getEnglishBaseUnitName(unitId)		local nameEn = getEnglishBaseUnitName(unitId)
			do return nameEn end
	local table = runQuery([[		local table = runQuery([[
	tables =		tables =

76561198048502585: Created page with "-- This module is intended as a supporting muscle for the UnitInfobox template. local p = {} -- Displays a variable ------------------------------------------------------------------------------------------------------------------------ local function dump(target) return '

' .. mw.dumpObject(target) .. '

' end -- Spawns a safe robotic url from an English name, fit for adding it before the visible name -------------------------------------------------------..."

2026-07-19T11:29:23Z

Created page with "-- This module is intended as a supporting muscle for the UnitInfobox template. local p = {} -- Displays a variable ------------------------------------------------------------------------------------------------------------------------ local function dump(target) return '<pre>' .. mw.dumpObject(target) .. '</pre>' end -- Spawns a safe robotic url from an English name, fit for adding it before the visible name -------------------------------------------------------..."

New page

-- This module is intended as a supporting muscle for the UnitInfobox template.
local p = {}

-- Displays a variable
------------------------------------------------------------------------------------------------------------------------
local function dump(target)
return '<pre>' .. mw.dumpObject(target) .. '</pre>'
end

-- Spawns a safe robotic url from an English name, fit for adding it before the visible name
------------------------------------------------------------------------------------------------------------------------
local function getUrl(nameEn, lang)
if not nameEn then
return ''
end
local url = nameEn
if lang ~= 'en' then
url = url .. '/' .. lang
end
return url
end

-- Parses and runs a Cargo query from wiki-like syntax
------------------------------------------------------------------------------------------------------------------------
local function runQuery(query, ...)
query = string.gsub(query, "%-%-.-\n", "") -- remove "comments"
query = select('#', ...) > 0 and mw.ustring.format(query, ...) or query
query = mw.text.trim(query)
local tables = ''
local fields = ''
local options = {}
for part in query:gmatch('[^|]+') do
local key, val = part:match('^%s*([^=]+)%s*=%s*(.-)%s*$')
if key and val then
key = mw.text.trim(key):lower()
val = mw.text.trim(val)
val = val:gsub('%s', ' ')
if key == 'tables' then
tables = val
elseif key == 'fields' then
fields = val
elseif key == 'limit' then
options[key] = tonumber(val) or val
elseif key == 'join on' then
options['join'] = val
else
options[key] = val
end
end
end
return mw.ext.cargo.query(tables, fields, options)
end

------------------------------------------------------------------------------------------------------------------------
local function getBaseId(unitId)
return unitId:gsub('_alt$', ''):gsub('_upg$', '')
end

------------------------------------------------------------------------------------------------------------------------
local function getEnglishBaseUnitName(unitId)
local baseId = getBaseId(unitId)
local table = runQuery([[
tables =
Unit = U,
Translation = T
| join on =
U.id = T.target_id
| where =
U.id = '%s'
AND T.language = 'en'
AND T.type = 'unit'
| fields =
T.name = name
| limit =
1
]], baseId);
return (table[1] or {name = ''}).name
end

------------------------------------------------------------------------------------------------------------------------
function p.findGrowth(frame)
-- TODO: Read this value from MapObject, once we have it in Cargo.
local unitId = frame.args.id
local baseId = getBaseId(unitId)
local table = runQuery([[
tables =
Building = B
| where =
B.units_hire_sid = '%s'
| fields =
B.units_weekly = units_weekly
| limit =
1
]], baseId);
local growth = (table[1] or { units_weekly = '' }).units_weekly

if growth ~= '' then
return growth
end

return '';
end

------------------------------------------------------------------------------------------------------------------------
local function findTownBuilding(unitId, lang)
local baseId = getBaseId(unitId)
local table = runQuery([[
tables =
Building = B,
Translation = T,
Translation = E,
| join on =
B.id = T.target_id,
B.id = E.target_id
| where =
B.units_hire_sid = '%s'
AND T.language = '%s'
AND E.language = 'en'
| fields =
T.name = name,
E.name = name_en
| limit =
2
]], baseId, lang);
if #table ~= 2 then
return nil
end
local level = unitId == baseId and 1 or 2
return {
name_en = table[1].name_en, -- we need the English name of the base!
name = table[level].name
}
end

------------------------------------------------------------------------------------------------------------------------
local function findExternalDwelling(unitId, lang, isBank)
local nameEn = getEnglishBaseUnitName(unitId)
nameEn = nameEn:gsub('man$', 'men') -- fix 'Swordmen' and 'Crossbowmen'
nameEn = nameEn:gsub(' of', 's of') -- fix 'Sentinels of Glory'
nameEn = nameEn:gsub('Waurms', 'Waurmos')

-- Note: Currently (2026-07-16), the banks are not present in Cargo
local prefix = isBank == 1 and 'Defeat its guard to obtain' or 'You can recruit'

local table = runQuery([[
tables =
Translation = E,
Translation = T,
| join on =
E.target_id = T.target_id
| where =
E.type = 'map_object'
AND E.language = 'en'
AND E.description LIKE '%s %s%%'
AND T.type = 'map_object'
AND T.language = '%s'
| fields =
E.name = name_en,
T.name = name
| limit =
1
]], prefix, nameEn, lang);
if #table ~= 1 then
return nil
end
return table[1]
end

------------------------------------------------------------------------------------------------------------------------
function p.findDwelling(frame)
local unitId = frame.args.id
local lang = frame.args.lang
local names = findTownBuilding(unitId, lang)
if not names then
names = findExternalDwelling(unitId, lang, 0)
end
if not names then
return ''
end
return '[[' .. getUrl(names.name_en, lang) .. '|' .. names.name .. ']]'
end

------------------------------------------------------------------------------------------------------------------------
function p.findSpecialistId(frame)
local unitId = frame.args.id
local nameEn = getEnglishBaseUnitName(unitId)
local table = runQuery([[
tables =
Translation = T
| where =
T.type = 'hero_specialization'
AND T.language = 'en'
AND T.description LIKE '%s growth in your cities increases by%%'
| fields =
T.target_id = target_id
| limit =
1
]], nameEn);
local specialist = (table[1] or {target_id = ''}).target_id
specialist = specialist:gsub('_specialization', '')
return specialist
end

------------------------------------------------------------------------------------------------------------------------
function p.findBank(frame)
return ''
end

------------------------------------------------------------------------------------------------------------------------
function p.simplifyName(frame)
return (mw.ustring.gsub(frame.args.name, "[^%a]", ""))
end

return p