Module:SubSkillsTable: Difference between revisions

From Heroes of Might and Magic: Olden Era Official Wiki
No edit summary
No edit summary
Line 1: Line 1:
local p = {}
local p = {}


local function getTrans(target_id, type, lang, field, variant)
-- Version améliorée de getTrans avec valeur par défaut
local function getTrans(target_id, type, lang, field, variant, default)
     local query_where = string.format("target_id = '%s' AND type = '%s' AND language = '%s'", target_id, type, lang)
     local query_where = string.format("target_id = '%s' AND type = '%s' AND language = '%s'", target_id, type, lang)
     if variant then
     if variant then
Line 11: Line 12:
         limit = 1
         limit = 1
     })
     })
     return (res and #res > 0) and res[1][field] or ""
      
    local val = (res and #res > 0) and res[1][field] or ""
    return (val ~= "") and val or (default or "")
end
end


Line 17: Line 20:
     local skill_id = frame.args["id"] or frame.args[1]
     local skill_id = frame.args["id"] or frame.args[1]
     if not skill_id then return "ID requis" end
     if not skill_id then return "ID requis" end
   
     local lang = frame.args.language or "en"
     local lang = frame.args.language or "en"
      
      
     -- 1. Récupération des en-têtes dynamiques avec valeur par défaut
     -- Récupération des en-têtes
local header_skill = getTrans("wiki_skills", "wiki", lang, "name")
    local hSkill = getTrans("wiki_skills", "wiki", lang, "name", nil, "Compétence")
if header_skill == "" then header_skill = "Skills" end
    local hSub = getTrans("wiki_sub_skills", "wiki", lang, "name", nil, "Sous-compétence")
 
local header_subskill = getTrans("wiki_sub_skills", "wiki", lang, "name")
if header_subskill == "" then header_subskill = "Subskills" end
      
      
    -- 2. Récupération des niveaux
     local levels = mw.ext.cargo.query("SkillLevel", "level, icon, offered_sub_skills", {
     local levels = mw.ext.cargo.query("SkillLevel", "level, icon, offered_sub_skills", {
         where = string.format("skill_id = '%s'", skill_id),
         where = string.format("skill_id = '%s'", skill_id),
         orderBy = "level ASC"
         orderBy = "level ASC"
     })
     })
   
    if not levels or #levels == 0 then return "Aucun niveau trouvé." end
      
      
     local html = {'{| class="wikitable" style="width:100%"'}
     local html = {'{| class="wikitable" style="width:100%"'}
    -- Utilisation des variables d'en-tête ici
     table.insert(html, '! colspan=2 | ' .. hSkill .. ' !! colspan=6 | ' .. hSub)
     table.insert(html, '! colspan=2 | ' .. header_skill .. ' !! colspan=6 | ' .. header_subskill)


     for _, lvl in ipairs(levels) do
     for _, lvl in ipairs(levels) do
         local trans_name = getTrans(skill_id, "skill_level", lang, "name", lvl.level)
         local name = getTrans(skill_id, "skill_level", lang, "name", lvl.level)
         local trans_desc = getTrans(skill_id, "skill_level", lang, "description", lvl.level)
         local desc = getTrans(skill_id, "skill_level", lang, "description", lvl.level)
        local icon = (lvl.icon and lvl.icon ~= "") and lvl.icon or "Placeholder"
          
          
         local icon_name = (lvl.icon and lvl.icon ~= "") and lvl.icon or "Placeholder"
         table.insert(html, '|- style="vertical-align:top;"')
        table.insert(html, '| style="text-align:right; border-right:0px;" | [[File:' .. icon .. '.png|70px]]')
        table.insert(html, '| style="border-right:0px; width:250px;" | \'\'\'' .. name .. '\'\'\' <br /><small>' .. desc .. '</small>')
          
          
         table.insert(html, '|- style="vertical-align:top;"')
         -- Boucle sur les sous-compétences
        table.insert(html, '| style="text-align:right; border-right:0px;" | [[File:' .. icon_name .. '.png|70px]]')
        if lvl.offered_sub_skills then
        table.insert(html, '| style="border-left:0px;" | \'\'\'' .. trans_name .. '\'\'\' <br /><span style="color: #DDD;">' .. trans_desc .. '</span>')
            for sub_id in string.gmatch(lvl.offered_sub_skills, "([^,]+)") do
                -- Placeholder pour le moment
                local sub_name = "Sub: " .. sub_id
                local sub_desc = "Description placeholder pour " .. sub_id
                local sub_icon = "SubSkill_Icon_Placeholder"
               
                table.insert(html, '| style="text-align:center; width:120px;" | [[File:' .. sub_icon .. '.png|40px]]<br />\'\'\'' .. sub_name .. '\'\'\'<br /><small>' .. sub_desc .. '</small>')
            end
        end
        table.insert(html, '|}')
     end
     end
      
      

Revision as of 09:51, 6 June 2026

Documentation for this module may be created at Module:SubSkillsTable/doc

local p = {}

-- Version améliorée de getTrans avec valeur par défaut
local function getTrans(target_id, type, lang, field, variant, default)
    local query_where = string.format("target_id = '%s' AND type = '%s' AND language = '%s'", target_id, type, lang)
    if variant then
        query_where = query_where .. string.format(" AND variant = '%s'", variant)
    end
    
    local res = mw.ext.cargo.query("Translation", field, {
        where = query_where,
        limit = 1
    })
    
    local val = (res and #res > 0) and res[1][field] or ""
    return (val ~= "") and val or (default or "")
end

function p.display(frame)
    local skill_id = frame.args["id"] or frame.args[1]
    if not skill_id then return "ID requis" end
    local lang = frame.args.language or "en"
    
    -- Récupération des en-têtes
    local hSkill = getTrans("wiki_skills", "wiki", lang, "name", nil, "Compétence")
    local hSub = getTrans("wiki_sub_skills", "wiki", lang, "name", nil, "Sous-compétence")
    
    local levels = mw.ext.cargo.query("SkillLevel", "level, icon, offered_sub_skills", {
        where = string.format("skill_id = '%s'", skill_id),
        orderBy = "level ASC"
    })
    
    local html = {'{| class="wikitable" style="width:100%"'}
    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)
        local icon = (lvl.icon and lvl.icon ~= "") and lvl.icon or "Placeholder"
        
        table.insert(html, '|- style="vertical-align:top;"')
        table.insert(html, '| style="text-align:right; border-right:0px;" | [[File:' .. icon .. '.png|70px]]')
        table.insert(html, '| style="border-right:0px; width:250px;" | \'\'\'' .. name .. '\'\'\' <br /><small>' .. desc .. '</small>')
        
        -- Boucle sur les sous-compétences
        if lvl.offered_sub_skills then
            for sub_id in string.gmatch(lvl.offered_sub_skills, "([^,]+)") do
                -- Placeholder pour le moment
                local sub_name = "Sub: " .. sub_id
                local sub_desc = "Description placeholder pour " .. sub_id
                local sub_icon = "SubSkill_Icon_Placeholder"
                
                table.insert(html, '| style="text-align:center; width:120px;" | [[File:' .. sub_icon .. '.png|40px]]<br />\'\'\'' .. sub_name .. '\'\'\'<br /><small>' .. sub_desc .. '</small>')
            end
        end
        table.insert(html, '|}')
    end
    
    table.insert(html, "|}")
    return table.concat(html, "\n")
end

return p