Module:QueryBelleSummary

Description

Retrieve a Belle's ingame Summary text. Only necessary because of a conflict between ConfirmEdit/QuestyCaptcha and Cargo that resulted in Cargo-stored text containing double quotes turning into the HTML escaped version when retrieved like the below.

To Use

This code was written for the NewBellePage template but if needed elsewhere, copy and paste the following.

{{#invoke:QueryBelleSummary|main|belle={{#replace:{{PAGENAME}}|'|\'}}}}

If not using the name of the page, swap PAGENAME with the Belle's name. The "replace" code is needed to handle names that contain single quotes which would otherwise cause database errors if not properly escaped prior to being queried for.

On NewBellePage, the text is also italicized.

---

local p = {}
local cargo = mw.ext.cargo

function p.Main( frame )
    local tables = 'MISC_BelleMoreInfo'
    local fields = 'MISC_BelleMoreInfo.TXT_Summary'

    local args = {
        where = 'FK_Belle = "{{#replace:{{PAGENAME}}|'|\'}}"',
		default ='Description not defined',
		limit = 1
    }
    local results = cargo.query( tables, fields, args )
    for r = 1, #results do
        local result = results[r]
        if result == nil then
        	print('Empty Cargo...')
    	else 
        	print(result.TXT_Summary)
    	end
    end
end

return p