Module:Event story chapters

Documentation for this module may be created at Module:Event story chapters/doc

local getArgs      = require('Module:Arguments').getArgs
local QueryBuilder = require('Module:QueryBuilder')
local cicon        = require('Module:Character icon')._main

local p = {}

function p.main(frame)
	local args = getArgs(frame)
	
	local eventId = args['event id']
	
	local qb = QueryBuilder.new()
	qb
		:setTables('event_story_chapters')
		:setFields([[
			image,
			chapter,
			_pageName,
			english,
			characters
		]])
		:addWhere('event_id', '=', event_id)

	local results = qb:query()
	
	local root = mw.html.create('table')
		:addClass('wikitable')
	
	for _,row in ipairs(results) do
		root:tag('tr')
			:tag('td')
				:wikitext(row.image)
				:done()
			:tag('td')
				:wikitext(row.chapter)
				:wikitext(row._pageName)
				:wikitext(row.english)
				:done()
			:tag('td')
				:wikitext(row.characters)
				:done()
	end
	
	return tostring(root)
end

return p