Module:Sandbox/Aurelain/SpellInfobox - Revision history

76561198048502585 at 07:30, 3 August 2026

2026-08-03T07:30:50Z

← Older revision		Revision as of 07:30, 3 August 2026
Line 28:		Line 28:
	------------------------------------------------------------------------------------------------------------------------		------------------------------------------------------------------------------------------------------------------------
	local function findMasterfulSpecializationText(spellNameEn, lang)		local function findMasterfulSpecializationText(spellNameEn, lang)
	--spellNameEn = mw.ustring.gsub(spellNameEn, "[’']", "%")		spellNameEn = mw.ustring.gsub(spellNameEn, "[’']", "%")
	local table = UtilQuery.run([[		local table = UtilQuery.run([[
	tables =		tables =

76561198048502585 at 07:30, 3 August 2026

2026-08-03T07:30:42Z

← Older revision		Revision as of 07:30, 3 August 2026
Line 28:		Line 28:
	------------------------------------------------------------------------------------------------------------------------		------------------------------------------------------------------------------------------------------------------------
	local function findMasterfulSpecializationText(spellNameEn, lang)		local function findMasterfulSpecializationText(spellNameEn, lang)
	spellNameEn = mw.ustring.gsub(spellNameEn, "[’']", "%")		--spellNameEn = mw.ustring.gsub(spellNameEn, "[’']", "%")
	local table = UtilQuery.run([[		local table = UtilQuery.run([[
	tables =		tables =

76561198048502585 at 07:30, 3 August 2026

2026-08-03T07:30:31Z

← Older revision		Revision as of 07:30, 3 August 2026
Line 28:		Line 28:
	------------------------------------------------------------------------------------------------------------------------		------------------------------------------------------------------------------------------------------------------------
	local function findMasterfulSpecializationText(spellNameEn, lang)		local function findMasterfulSpecializationText(spellNameEn, lang)
			spellNameEn = mw.ustring.gsub(spellNameEn, "[’']", "%")
	local table = UtilQuery.run([[		local table = UtilQuery.run([[
	tables =		tables =

76561198048502585 at 07:23, 3 August 2026

2026-08-03T07:23:01Z

← Older revision		Revision as of 07:23, 3 August 2026
Line 27:		Line 27:

	------------------------------------------------------------------------------------------------------------------------		------------------------------------------------------------------------------------------------------------------------
	local function findMasterfulSpecializationText(spellNameEn)		local function findMasterfulSpecializationText(spellNameEn, lang)
	local table = UtilQuery.run([[		local table = UtilQuery.run([[
	tables =		tables =
	Translation = T		Translation = E,
			Translation = F
			\| join on =
			E.target_id = F.target_id
	\| where =		\| where =
	T.description LIKE '%%starts with the “Masterful %s” spell%%'		E.description LIKE '%%starts with the “Masterful %s” spell%%'
	AND T.language = 'en'		AND E.language = 'en'
	AND T.~~type~~ = '~~hero_specialization~~'		AND F.language = '%s'
	\| fields =		\| fields =
	T.description = description		F.description = description
	\| limit =		\| limit =
	1		1
	]], spellNameEn)		]], spellNameEn, lang)
	return (table[1] or { description = '' }).description		return (table[1] or { description = '' }).description
	end		end
Line 46:		Line 49:
	function p.getMasterfulText(frame)		function p.getMasterfulText(frame)
	local spellId = frame.args.id		local spellId = frame.args.id
			local lang = frame.args.lang
	local spellNameEn = getSpellEnglishName(spellId)		local spellNameEn = getSpellEnglishName(spellId)
	local text = findMasterfulSpecializationText(spellNameEn)		local text = findMasterfulSpecializationText(spellNameEn, lang)
	local secondSentence = mw.ustring.match(text, "[.,。]%s*([^.。]+[.。])") or ''		local secondSentence = mw.ustring.match(text, "[.,。]%s*([^.。]+[.。])") or ''
	return secondSentence		return secondSentence

76561198048502585 at 07:17, 3 August 2026

2026-08-03T07:17:21Z

← Older revision		Revision as of 07:17, 3 August 2026
Line 40:		Line 40:
	1		1
	]], spellNameEn)		]], spellNameEn)
	~~--return dump(table)~~
	return (table[1] or { description = '' }).description		return (table[1] or { description = '' }).description
	end		end
Line 49:		Line 48:
	local spellNameEn = getSpellEnglishName(spellId)		local spellNameEn = getSpellEnglishName(spellId)
	local text = findMasterfulSpecializationText(spellNameEn)		local text = findMasterfulSpecializationText(spellNameEn)
	return ~~text~~		local secondSentence = mw.ustring.match(text, "[.,。]%s*([^.。]+[.。])") or ''
			return secondSentence
	end		end

	return p		return p

76561198048502585 at 07:16, 3 August 2026

2026-08-03T07:16:10Z

← Older revision		Revision as of 07:16, 3 August 2026
Line 32:		Line 32:
	Translation = T		Translation = T
	\| where =		\| where =
	T.description LIKE '%%starts with the %%'		T.description LIKE '%%starts with the “Masterful %s” spell%%'
	AND T.language = 'en'		AND T.language = 'en'
	AND T.type = 'hero_specialization'		AND T.type = 'hero_specialization'
Line 40:		Line 40:
	1		1
	]], spellNameEn)		]], spellNameEn)
	return dump(table)		--return dump(table)
	--return (table[1] or { description = '' }).description		return (table[1] or { description = '' }).description
	end		end

76561198048502585 at 07:15, 3 August 2026

2026-08-03T07:15:30Z

← Older revision		Revision as of 07:15, 3 August 2026
Line 32:		Line 32:
	Translation = T		Translation = T
	\| where =		\| where =
	T.description LIKE '%%starts with the %%"		T.description LIKE '%%starts with the %%'
	AND T.language = 'en'		AND T.language = 'en'
	AND T.type = 'hero_specialization'		AND T.type = 'hero_specialization'

76561198048502585 at 07:15, 3 August 2026

2026-08-03T07:15:10Z

← Older revision		Revision as of 07:15, 3 August 2026
Line 40:		Line 40:
	1		1
	]], spellNameEn)		]], spellNameEn)
	return (table[1] or { description = '' }).description		return dump(table)
			--return (table[1] or { description = '' }).description
	end		end

76561198048502585 at 07:14, 3 August 2026

2026-08-03T07:14:43Z

← Older revision		Revision as of 07:14, 3 August 2026
Line 32:		Line 32:
	Translation = T		Translation = T
	\| where =		\| where =
	T.description LIKE '%%starts with the ~~%% %s~~%%"		T.description LIKE '%%starts with the %%"
	AND T.language = 'en'		AND T.language = 'en'
	AND T.type = 'hero_specialization'		AND T.type = 'hero_specialization'

76561198048502585 at 07:11, 3 August 2026

2026-08-03T07:11:56Z

← Older revision		Revision as of 07:11, 3 August 2026
Line 32:		Line 32:
	Translation = T		Translation = T
	\| where =		\| where =
	T.description LIKE '%%starts with the ~~“Masterful~~ %~~s” spell~~%%"		T.description LIKE '%%starts with the %% %s%%"
	AND T.language = 'en'		AND T.language = 'en'
	AND T.type = 'hero_specialization'		AND T.type = 'hero_specialization'