Module:Monthly Birthdays - Revision history

Snep at 01:03, 1 March 2026

2026-03-01T01:03:59Z

← Older revision		Revision as of 01:03, 1 March 2026
Line 8:		Line 8:
	local query = {		local query = {
	where = "Characters.type = 'horsegirl' AND Characters.birthday IS NOT null AND SUBSTRING(Characters.birthday, 6, 2) = '" .. escaped .. "'",		where = "Characters.type = 'horsegirl' AND Characters.birthday IS NOT null AND SUBSTRING(Characters.birthday, 6, 2) = '" .. escaped .. "'",
	orderBy = "SUBSTRING(Characters.birthday, 6, 5) ASC"		orderBy = "SUBSTRING(Characters.birthday, 6, 5) ASC",
			groupBy = "_pageName"
	}		}
	local fields = { 'name_en', 'birthday', 'color_main', 'color_sub', 'icon' }		local fields = { 'name_en', 'birthday', 'color_main', 'color_sub', 'icon' }

Snep at 02:00, 25 February 2026

2026-02-25T02:00:43Z

← Older revision		Revision as of 02:00, 25 February 2026
Line 10:		Line 10:
	orderBy = "SUBSTRING(Characters.birthday, 6, 5) ASC"		orderBy = "SUBSTRING(Characters.birthday, 6, 5) ASC"
	}		}
	local fields = { 'name_en', 'birthday', 'color_main', 'color_sub' }		local fields = { 'name_en', 'birthday', 'color_main', 'color_sub', 'icon' }
	local events = cargo.query('Characters',		local events = cargo.query('Characters',
	table.concat(fields, ','), query)		table.concat(fields, ','), query)
Line 27:		Line 27:
	day = day,		day = day,
	main = ev.color_main,		main = ev.color_main,
	sub = ev.color_sub		sub = ev.color_sub,
			icon = ev.icon
	}		}
	} .. '\n'		} .. '\n'

Kanade at 16:34, 3 October 2024

2024-10-03T16:34:11Z

← Older revision		Revision as of 16:34, 3 October 2024
Line 26:		Line 26:
	month = month,		month = month,
	day = day,		day = day,
	~~color_main~~ = ev.color_main,		main = ev.color_main,
	~~color_sub~~ = ev.color_sub		sub = ev.color_sub
	}		}
	} .. '\n'		} .. '\n'

Kanade: Created page with "local p = {} local cargo = mw.ext.cargo function p.birthdays(frame) local month = mw.text.decode(frame.args[1]) if not month then return end local escaped = string.gsub(month, "'", "\\'") local query = { where = "Characters.type = 'horsegirl' AND Characters.birthday IS NOT null AND SUBSTRING(Characters.birthday, 6, 2) = '" .. escaped .. "'", orderBy = "SUBSTRING(Characters.birthday, 6, 5) ASC" } local fields = { 'name_en', 'birthday', 'color_main', 'color_sub'..."

2024-10-03T16:32:46Z

Created page with "local p = {} local cargo = mw.ext.cargo function p.birthdays(frame) local month = mw.text.decode(frame.args[1]) if not month then return end local escaped = string.gsub(month, "'", "\\'") local query = { where = "Characters.type = 'horsegirl' AND Characters.birthday IS NOT null AND SUBSTRING(Characters.birthday, 6, 2) = '" .. escaped .. "'", orderBy = "SUBSTRING(Characters.birthday, 6, 5) ASC" } local fields = { 'name_en', 'birthday', 'color_main', 'color_sub'..."

New page

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

function p.birthdays(frame)
local month = mw.text.decode(frame.args[1])
if not month then return end
local escaped = string.gsub(month, "'", "\\'")
local query = {
where = "Characters.type = 'horsegirl' AND Characters.birthday IS NOT null AND SUBSTRING(Characters.birthday, 6, 2) = '" .. escaped .. "'",
orderBy = "SUBSTRING(Characters.birthday, 6, 5) ASC"
}
local fields = { 'name_en', 'birthday', 'color_main', 'color_sub' }
local events = cargo.query('Characters',
table.concat(fields, ','), query)

local text = ''
for _, ev in ipairs(events) do
local birthday = ev.birthday
if birthday then
local month = string.sub(birthday, 6, 7)
local day = string.sub(birthday, 9, 10)
text = text .. frame:expandTemplate {
title = 'Birthday Icon',
args = {
name = ev.name_en,
month = month,
day = day,
color_main = ev.color_main,
color_sub = ev.color_sub
}
} .. '\n'
end
end
return text
end

return p