Module:Sandbox/Aurelain/ArtifactsOverview: Difference between revisions
No edit summary |
No edit summary |
||
| Line 79: | Line 79: | ||
-- fields: | -- fields: | ||
local fields = {} | local fields = {} | ||
table.insert(fields, ' | table.insert(fields, 'A.id = id'); | ||
table.insert(fields, ' | table.insert(fields, 'T.name = name'); | ||
table.insert(fields, ' | table.insert(fields, 'T.language = language'); | ||
-- where: | -- where: | ||
local where = {} | local where = {} | ||
table.insert(where, ' | table.insert(where, '(A.id NOT LIKE %_magic%_ OR A.id LIKE "%_magic_haste")') | ||
table.insert(where, '( | table.insert(where, 'T.type = "artifact"') | ||
table.insert(where, '(T.language = "en" OR T.language = "' .. lang .. '")') | |||
-- query: | -- query: | ||
return mw.ext.cargo.query('Artifact, Translation', table.concat(fields, ','), { | return mw.ext.cargo.query('Artifact=A, Translation=T', table.concat(fields, ','), { | ||
join = ' | join = 'A.id = T.target_id', | ||
where = table.concat(where, ' AND '), | where = table.concat(where, ' AND '), | ||
limit = 500 | limit = 500 | ||
| Line 185: | Line 186: | ||
local args = frame.args | local args = frame.args | ||
local lang = args.lang ~= '' and args.lang or 'en' | local lang = args.lang ~= '' and args.lang or 'en' | ||
lang = 'ja' | --lang = 'ja' | ||
-- Language | -- Language | ||
Revision as of 08:15, 29 June 2026
This module renders a giant table with all artifacts. Scroll artifacts are consolidated into 3 generic scroll artifacts (normal, enchanted and mythic). Campaign artifacts are excluded.
A hyper parameter is supported. For more information, see Module:UtilHyper/doc.
Usage
Input: {{#invoke:Sandbox/Aurelain/ArtifactsOverview|display | lang=en | hyper=Attack=Hero_Basics#Attributes}}
Output: Lua error: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '%_magic%_ OR `A`.`id` LIKE "%_magic_haste") AND `T`.`type` = "artifact" AND (...' at line 1 Function: CargoSQLQuery::run Query: SELECT `A`.`id` AS `id`,`T`.`name` AS `name`,`T`.`language` AS `language` FROM `mw4v_cargo__Artifact` `A` LEFT OUTER JOIN `mw4v_cargo__Translation` `T` ON ((`A`.`id`=`T`.`target_id`)) WHERE (`A`.`id` NOT LIKE %_magic%_ OR `A`.`id` LIKE "%_magic_haste") AND `T`.`type` = "artifact" AND (`T`.`language` = "en" OR `T`.`language` = "en") ORDER BY `A`.`id`,`T`.`name`,`T`.`language` LIMIT 500 .
-- Usage: {{#invoke:ArtifactsOverview|display | lang=en}}
local p = {}
local f = mw.ustring.format
-- Note: The right side is just a fallback, it will seldom be used.
local TRANSLATION_IDS = {
wiki_none = 'None'
}
-- 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
-- Retrieves the text for some specific ids from Cargo Translations.
------------------------------------------------------------------------------------------------------------------------
local function translateIds(ids, lang, extra)
-- Key list
local list = {}
for key, _ in pairs(ids) do
list[#list + 1] = key
end
local idListString = '"' .. table.concat(list, '", "') .. '"'
-- Cargo
local where = {}
table.insert(where, 'target_id IN (' .. idListString .. ')')
table.insert(where, 'language = "' .. lang .. '"')
if extra then
table.insert(where, extra)
end
local results = mw.ext.cargo.query('Translation', 'target_id, name', {
where = table.concat(where, ' AND '),
limit = 100
})
-- Dictionary
local dictionary = mw.clone(ids)
for key, value in pairs(dictionary) do
--dictionary[key] = value .. '[[Data:WikiTranslations/' .. lang .. '#' .. key .. '|💬]]'
dictionary[key] = value .. '🗯️'
end
for _, row in ipairs(results) do
local name = row['name']
if name and name ~= '' then
dictionary[row['target_id']] = name
end
end
return dictionary
end
-- Converts a dictionary into a linear array
------------------------------------------------------------------------------------------------------------------------
local function flatten(hub)
local list = {}
for _, entry in pairs(hub) do
list[#list + 1] = entry
end
return list
end
-- Interrogates the main Cargo table
------------------------------------------------------------------------------------------------------------------------
local function queryMain(lang)
-- fields:
local fields = {}
table.insert(fields, 'A.id = id');
table.insert(fields, 'T.name = name');
table.insert(fields, 'T.language = language');
-- where:
local where = {}
table.insert(where, '(A.id NOT LIKE %_magic%_ OR A.id LIKE "%_magic_haste")')
table.insert(where, 'T.type = "artifact"')
table.insert(where, '(T.language = "en" OR T.language = "' .. lang .. '")')
-- query:
return mw.ext.cargo.query('Artifact=A, Translation=T', table.concat(fields, ','), {
join = 'A.id = T.target_id',
where = table.concat(where, ' AND '),
limit = 500
})
end
-- Folds all Cargo results into a single dictionary:
------------------------------------------------------------------------------------------------------------------------
local function consolidate(lang, results)
local hub = {}
for _, row in ipairs(results) do
local id = row.id
local entry = hub[id]
if not entry then
entry = {}
entry.id = id or ''
hub[id] = entry
end
if row.language == lang then
entry.name = row.name or ''
end
if row.language == 'en' then
entry.nameEn = row.name or ''
end
end
return hub
end
------------------------------------------------------------------------------------------------------------------------
local function sortList(a, b)
return a.id < b.id
end
-- Boilerplate for the header cells
------------------------------------------------------------------------------------------------------------------------
local function addTh(tr, text)
return tr:tag('th'):wikitext(text)
end
-- Boilerplate for the body cells
------------------------------------------------------------------------------------------------------------------------
local function addTd(tr, content)
if type(content) == "string" then
return tr:tag('td'):wikitext(content)
else
return tr:tag('td'):node(content)
end
end
-- Boilerplate for the separator rows
------------------------------------------------------------------------------------------------------------------------
local function addSeparator(htmlTable, className, content)
htmlTable:tag('tr')
:addClass('separator')
:addClass(className)
:tag('td'):attr('data-sort-value', ''):attr('colspan', 100):wikitext(content):done()
end
------------------------------------------------------------------------------------------------------------------------
local function createHeader(htmlTable)
local tr = htmlTable:tag('tr')
addTh(tr, 'id'):attr('colspan', 2)
addTh(tr, 'nameX'):attr('colspan', 2)
end
------------------------------------------------------------------------------------------------------------------------
local function createBody(htmlTable, list)
local currentType = list[1].param1
local currentFaction = list[1].faction
for _, item in ipairs(list) do
-- separators
if item.faction ~= currentFaction then
currentFaction = item.faction
currentType = item.class_type
addSeparator(htmlTable, 'separator-large', '')
elseif item.class_type ~= currentType then
currentType = item.class_type
addSeparator(htmlTable, 'separator-tiny', '')
end
local tr = htmlTable:tag('tr'):addClass('artifact')
addTd(tr, item.id)
addTd(tr, item.nameEn)
addTd(tr, item.name)
end
end
-- M A I N
------------------------------------------------------------------------------------------------------------------------
function p.display(frame)
--do return dump(frame) end
-- Args
local args = frame.args
local lang = args.lang ~= '' and args.lang or 'en'
--lang = 'ja'
-- Language
local words = translateIds(TRANSLATION_IDS, lang)
-- Cargo
local results = queryMain(lang)
local hub = consolidate(lang, results)
local list = flatten(hub);
if #list == 0 then return words.wiki_none end
-- Various manipulations
table.sort(list, sortList)
-- Table
local htmlTable = mw.html.create('table')
htmlTable:addClass('wikitable sortable')
createHeader(htmlTable)
createBody(htmlTable, list)
-- Output
local styleTag = frame:extensionTag('templatestyles', '', { src = frame:getTitle() .. '/styles.css' })
return '<div class="artifacts-overview">' .. styleTag .. tostring(htmlTable) .. '</div>'
end
return p


