Module:MapObjectsData: Difference between revisions

From Heroes of Might and Magic: Olden Era Official Wiki
No edit summary
m 76561198256426587 moved page Module:BuildingsData to Module:MapObjectsData
 
(31 intermediate revisions by the same user not shown)
Line 1: Line 1:
local p = {}
local p = {}


-- 1. Fonction utilitaire pour récupérer des traductions (Translation)
-- Fonction utilitaire pour interroger Cargo
local function getTrans(target_id, type, lang, field, variant, default)
local function queryCargo(table, fields, where)
    local query_where = string.format("target_id = '%s' AND type = '%s' AND language = '%s'", target_id, type, lang)
     local res = mw.ext.cargo.query(table, fields, { where = where, limit = 1 })
    if variant then query_where = query_where .. string.format(" AND variant = '%s'", variant) end
     return (res and #res > 0) and res[1] or nil
   
     local res = mw.ext.cargo.query("Translation", field, { where = query_where, limit = 1 })
     local result = (res and #res > 0) and res[1][field] or ""
   
    return (result ~= "") and result or (default or "")
end
end


-- 2. Création de la carte des liens (Nom -> ID)
-- Fonction pour chercher l'ID (par ID ou nom anglais)
local function getSkillLinkMap(lang)
local function resolveId(input)
     local skillIdsRes = mw.ext.cargo.query('Skill', 'id', { where = "variant = 'production'" })
    if not input then return nil end
    local validIds = {}
     local checkId = queryCargo("MapObject", "id", "id = '" .. input .. "'")
    for _, row in ipairs(skillIdsRes) do table.insert(validIds, "'" .. row.id .. "'") end
     if checkId then return input end
     local idList = table.concat(validIds, ",")
     local res = mw.ext.cargo.query("Translation", "target_id", {
 
         where = "type = 'map_object' AND language = 'en' AND name = '" .. input .. "'",
     local enNames = mw.ext.cargo.query('Translation', 'target_id, name', {
        limit = 1
         where = "type = 'skill' AND language = 'en' AND target_id IN (" .. idList .. ")"
     })
     })
     local idToEnName = {}
     return (res and #res > 0) and res[1].target_id or nil
    for _, row in ipairs(enNames) do idToEnName[row.target_id] = row.name end
end


     local localNames = mw.ext.cargo.query('Translation', 'target_id, name', {
-- Fonction utilitaire pour nettoyer le nom de la page
         where = "type = 'skill' AND language = '" .. lang .. "' AND target_id IN (" .. idList .. ")"
local function getObjId(pagename)
     local cleanName = mw.text.trim(mw.ustring.gsub(mw.ustring.gsub(pagename, "/.*", ""), "%s*%([^%)]*%)", ""))
    local res = mw.ext.cargo.query("Translation", "target_id", {
         where = "type = 'map_object' AND language = 'en' AND name = '" .. cleanName .. "'",
        limit = 1
     })
     })
      
     return (res and #res > 0) and res[1].target_id or nil
    local map = {}
    for _, row in ipairs(localNames) do
        local enName = idToEnName[row.target_id]
        if enName then
            map[row.name] = enName
        end
    end
    return map
end
end


-- Fonction utilitaire pour échapper les caractères spéciaux
function p.get(frame)
local function escapePattern(str)
    local args = frame.args
     return str:gsub("([%^%$%(%)%%%.%[%]%*%+%-%?])", "%%%1")
    local pagename = mw.title.getCurrentTitle().text
end
     local rawId = args["id"] or args[1]
 
    local id = resolveId(rawId) or getObjId(pagename)
-- 3. Remplacement des noms de skills par des liens wiki
    local lang = args["language"] or mw.ustring.match(pagename, "/([a-z_]+)$") or "en"
local function linkSkillsInText(text, lang, linkMap)
    -- On récupère le champ, et si c'est "faction", on le transforme en "fraction" pour la suite
     if not text or text == "" then return "" end
     local field = args["field"] or args[2]
    local queryField = (field == "faction") and "fraction" or field
      
      
     local sortedNames = {}
     if not id then return "Erreur : ID introuvable." end
    for name, id in pairs(linkMap) do table.insert(sortedNames, name) end
    table.sort(sortedNames, function(a, b) return #a > #b end)
      
      
     for _, name in ipairs(sortedNames) do
     -- 1. Cas : Nom et Description
        local englishName = linkMap[name]
    if queryField == "name" or queryField == "description" then
       
         local res = queryCargo("Translation", queryField, string.format("target_id='%s' AND type='map_object' AND language='%s'", id, lang))
        -- Si la langue est 'en', on ne met pas le suffixe /en
        return res and res[queryField] or ""
        local target = (lang == "en") and englishName or (englishName .. "/" .. lang)
       
        -- On construit le lien : [[NomAnglais|NomTraduit]] ou [[NomAnglais/lang|NomTraduit]]
         local replacement = "[[" .. target .. "|" .. name .. "]]"
       
        local pattern = escapePattern(name)
        text = mw.ustring.gsub(text, pattern, replacement)
     end
     end
    return text
end
-- 4. Fonction pour récupérer les infos d'un SubSkill
local function getSubSkillInfo(sub_id, lang, linkMap)
    local sub_def = mw.ext.cargo.query("SubSkill", "icon", { where = string.format("id = '%s'", sub_id), limit = 1 })
    local icon = (sub_def and #sub_def > 0) and sub_def[1].icon or "Placeholder"
    local name = getTrans(sub_id, "sub_skill", lang, "name")
    local desc = getTrans(sub_id, "sub_skill", lang, "description")
      
      
     desc = linkSkillsInText(desc, lang, linkMap)
     -- 2. Cas : Narration
    return { name = name, desc = desc, icon = icon }
     if queryField == "narrative" then
end
        local res = queryCargo("Translation", "description", string.format("target_id='%s' AND type='map_object_narrative' AND language='%s'", id, lang))
 
        return res and res.description or ""
-- 5. Fonction principale d'affichage
    end
function p.display(frame)
     local args = frame.args
    local skill_id = args["id"] or args[1]
    local lang = args["language"] or "en"
      
      
     -- DÉTECTION AUTOMATIQUE SI ID MANQUANT
     -- 3. Cas : Traduction spéciale pour Faction (si field était "faction")
     if not skill_id then
     if field == "faction" then
         local pagename = mw.title.getCurrentTitle().text
         local data = queryCargo("MapObject", "fraction", "id='" .. id .. "'")
        local baseName = mw.ustring.gsub(pagename, "/.*", "")
         if not data then return "" end
          
         local res = queryCargo("Translation", "name", string.format("target_id='%s' AND type='faction' AND language='%s'", data.fraction, lang))
         local res = mw.ext.cargo.query("Translation", "target_id", {
         return res and res.name or data.fraction
            where = "type = 'skill' AND language = 'en' AND name = '" .. baseName .. "'",
            limit = 1
        })
          
        if res and #res > 0 then
            skill_id = res[1].target_id
        end
     end
     end
      
      
     if not skill_id then return "ID requis (indiquez |id=... ou nommez correctement votre page)" end
     -- 4. Cas : Données techniques (on utilise queryField qui est soit le field normal, soit "fraction")
   
     local tech_fields = "category,goods_value,ai_value,custom_guard_value,view_radius,guard_units,fraction,tier,resource_name,resource_value,source_path"
    local linkMap = getSkillLinkMap(lang)
     if string.find(tech_fields, queryField) then
    local hSkill = getTrans("wiki_skills", "wiki", lang, "name", nil, "Skills")
         local res = queryCargo("MapObject", queryField, "id='" .. id .. "'")
     local hSub = getTrans("wiki_sub_skills", "wiki", lang, "name", nil, "Subskills")
         return res and res[queryField] or ""
   
    local levels = mw.ext.cargo.query("SkillLevel", "level, icon, offered_sub_skills", {
        where = string.format("skill_id = '%s'", skill_id),
        orderBy = "level ASC"
    })
   
     if not levels or #levels == 0 then return "Aucun niveau trouvé pour cet ID : " .. skill_id end
   
    local html = {'{| class="wikitable" style="width:100%; border-collapse:collapse;"'}
    table.insert(html, '! colspan=2 | ' .. hSkill .. ' !! colspan=6 | ' .. hSub)
 
    for _, lvl in ipairs(levels) do
         local name = getTrans(skill_id, "skill_level", lang, "name", lvl.level)
        local desc = getTrans(skill_id, "skill_level", lang, "description", lvl.level)
        desc = linkSkillsInText(desc, lang, linkMap)
       
        local icon = (lvl.icon and lvl.icon ~= "") and lvl.icon or "Placeholder"
       
        table.insert(html, '|- style="vertical-align:top;"')
        table.insert(html, '| style="width:70px; border-right:0px;" | [[File:' .. icon .. '.png|70px]]')
        table.insert(html, '| style="border-left:0px; width:200px;" | \'\'\'' .. name .. '\'\'\' <br /><br />' .. desc .. '')
       
        local subs = {}
        if lvl.offered_sub_skills then
            for s in string.gmatch(lvl.offered_sub_skills, "([^,]+)") do table.insert(subs, s) end
         end
       
        for i = 1, 3 do
            if subs[i] then
                local info = getSubSkillInfo(subs[i], lang, linkMap)
                table.insert(html, '| style="width:30px; border-right:0px; padding-left:10px;" | [[File:' .. info.icon .. '.png|30px]]')
                table.insert(html, '| style="width:180px; border-left:0px;" | \'\'\'' .. info.name .. '\'\'\'<br /><br />' .. info.desc .. '')
            else
                table.insert(html, '| colspan=2 style="border-left:1px solid #ccc;" | &nbsp;')
            end
        end
     end
     end
      
      
    table.insert(html, "|}")
     return "Erreur : Champ '" .. field .. "' invalide."
     return table.concat(html, "\n")
end
 
function p.debugMap(frame)
    local lang = frame.args["language"] or "en"
    local linkMap = getSkillLinkMap(lang)
   
    local output = {"=== Contenu de la LinkMap (" .. lang .. ") ==="}
    for name, id in pairs(linkMap) do
        table.insert(output, "* " .. name .. " -> " .. id)
    end
    return table.concat(output, "\n")
end
end


return p
return p

Latest revision as of 15:16, 13 June 2026


Description

The BuildingsData module provides a centralized interface to retrieve adventure map object data from the MapObject Cargo table and their localized strings from the Translation Cargo table.

It is designed to be "page-aware," meaning it can automatically identify the correct object ID and language based on the current page title (e.g., handling subpages and language suffixes).

Syntax

{{#invoke:BuildingsData|get|id=|field=|language=}}

Parameters

  • id (optional): The unique object ID (e.g., barracks_unfrozen_6) or english building name (e.g., Bloated Mansion). If omitted, the module attempts to detect it from the current page title.
  • field (required): The specific data field to retrieve.
  • language (optional): The language code (e.g., fr, de). If omitted, the module attempts to detect it from the page title suffix (e.g., /fr).

Available Fields

Localization (from Translation table)

  • name, description (using type map_object)
  • narrative (using type map_object_narrative)

Technical (from MapObject table)

  • category, goods_value, ai_value, custom_guard_value, view_radius, guard_units, fraction, tier, resource_name, resource_value, source_path

Examples

Automatic Mode

If you are currently viewing the page Bloated Mansion/fr, the module automatically identifies the object and the language:

{{#invoke:BuildingsData|get|field=name}}
  • Result: Manoir boursouflé
{{#invoke:BuildingsData|get|field=narrative}}
  • Result: À moitié immergé dans les émanations abyssales, ce manoir vibre de vie.

Manual Mode

To fetch specific data regardless of the current page:

{{#invoke:BuildingsData|get|id=barracks_unfrozen_6|field=tier}}
  • Result: 6

Technical Notes

  • ID Detection: The module cleans the page title by removing subpages (text after /) and parenthetical text to match the entity name in the database.
  • Fallback: If a name request returns no data, the system relies on the object's category field for identification.

local p = {}

-- Fonction utilitaire pour interroger Cargo
local function queryCargo(table, fields, where)
    local res = mw.ext.cargo.query(table, fields, { where = where, limit = 1 })
    return (res and #res > 0) and res[1] or nil
end

-- Fonction pour chercher l'ID (par ID ou nom anglais)
local function resolveId(input)
    if not input then return nil end
    local checkId = queryCargo("MapObject", "id", "id = '" .. input .. "'")
    if checkId then return input end
    local res = mw.ext.cargo.query("Translation", "target_id", {
        where = "type = 'map_object' AND language = 'en' AND name = '" .. input .. "'",
        limit = 1
    })
    return (res and #res > 0) and res[1].target_id or nil
end

-- Fonction utilitaire pour nettoyer le nom de la page
local function getObjId(pagename)
    local cleanName = mw.text.trim(mw.ustring.gsub(mw.ustring.gsub(pagename, "/.*", ""), "%s*%([^%)]*%)", ""))
    local res = mw.ext.cargo.query("Translation", "target_id", {
        where = "type = 'map_object' AND language = 'en' AND name = '" .. cleanName .. "'",
        limit = 1
    })
    return (res and #res > 0) and res[1].target_id or nil
end

function p.get(frame)
    local args = frame.args
    local pagename = mw.title.getCurrentTitle().text
    local rawId = args["id"] or args[1]
    local id = resolveId(rawId) or getObjId(pagename)
    local lang = args["language"] or mw.ustring.match(pagename, "/([a-z_]+)$") or "en"
    -- On récupère le champ, et si c'est "faction", on le transforme en "fraction" pour la suite
    local field = args["field"] or args[2]
    local queryField = (field == "faction") and "fraction" or field
    
    if not id then return "Erreur : ID introuvable." end
    
    -- 1. Cas : Nom et Description
    if queryField == "name" or queryField == "description" then
        local res = queryCargo("Translation", queryField, string.format("target_id='%s' AND type='map_object' AND language='%s'", id, lang))
        return res and res[queryField] or ""
    end
    
    -- 2. Cas : Narration
    if queryField == "narrative" then
        local res = queryCargo("Translation", "description", string.format("target_id='%s' AND type='map_object_narrative' AND language='%s'", id, lang))
        return res and res.description or ""
    end
    
    -- 3. Cas : Traduction spéciale pour Faction (si field était "faction")
    if field == "faction" then
        local data = queryCargo("MapObject", "fraction", "id='" .. id .. "'")
        if not data then return "" end
        local res = queryCargo("Translation", "name", string.format("target_id='%s' AND type='faction' AND language='%s'", data.fraction, lang))
        return res and res.name or data.fraction
    end
    
    -- 4. Cas : Données techniques (on utilise queryField qui est soit le field normal, soit "fraction")
    local tech_fields = "category,goods_value,ai_value,custom_guard_value,view_radius,guard_units,fraction,tier,resource_name,resource_value,source_path"
    if string.find(tech_fields, queryField) then
        local res = queryCargo("MapObject", queryField, "id='" .. id .. "'")
        return res and res[queryField] or ""
    end
    
    return "Erreur : Champ '" .. field .. "' invalide."
end

return p