<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
	<id>https://wiki.runerealm.org/index.php?action=history&amp;feed=atom&amp;title=Module%3AMusicTable</id>
	<title>Module:MusicTable - Revision history</title>
	<link rel="self" type="application/atom+xml" href="https://wiki.runerealm.org/index.php?action=history&amp;feed=atom&amp;title=Module%3AMusicTable"/>
	<link rel="alternate" type="text/html" href="https://wiki.runerealm.org/index.php?title=Module:MusicTable&amp;action=history"/>
	<updated>2026-05-01T23:29:39Z</updated>
	<subtitle>Revision history for this page on the wiki</subtitle>
	<generator>MediaWiki 1.41.1</generator>
	<entry>
		<id>https://wiki.runerealm.org/index.php?title=Module:MusicTable&amp;diff=34068&amp;oldid=prev</id>
		<title>Alex: Created page with &quot;local p = {}  local contains = require(&#039;Module:Array&#039;).contains local pagesWithCats = require(&#039;Module:PageListTools&#039;).pageswithcats local paramTest = require(&#039;Module:Paramtest&#039;) local yesNo = require(&#039;Module:Yesno&#039;)  local html = mw.html local ask = mw.smw.ask local log = mw.log  function buildRow(trackData, hints, members) 	local exclusivity = trackData.exclusive and &#039;\&#039;\&#039;\&#039;&#039; or &#039;&#039; 	local event = trackData.event and &#039;\&#039;\&#039;&#039;or &#039;&#039; 	local trackLink, _ = string.gsub(trackDat...&quot;</title>
		<link rel="alternate" type="text/html" href="https://wiki.runerealm.org/index.php?title=Module:MusicTable&amp;diff=34068&amp;oldid=prev"/>
		<updated>2024-10-15T21:21:55Z</updated>

		<summary type="html">&lt;p&gt;Created page with &amp;quot;local p = {}  local contains = require(&amp;#039;Module:Array&amp;#039;).contains local pagesWithCats = require(&amp;#039;Module:PageListTools&amp;#039;).pageswithcats local paramTest = require(&amp;#039;Module:Paramtest&amp;#039;) local yesNo = require(&amp;#039;Module:Yesno&amp;#039;)  local html = mw.html local ask = mw.smw.ask local log = mw.log  function buildRow(trackData, hints, members) 	local exclusivity = trackData.exclusive and &amp;#039;\&amp;#039;\&amp;#039;\&amp;#039;&amp;#039; or &amp;#039;&amp;#039; 	local event = trackData.event and &amp;#039;\&amp;#039;\&amp;#039;&amp;#039;or &amp;#039;&amp;#039; 	local trackLink, _ = string.gsub(trackDat...&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;New page&lt;/b&gt;&lt;/p&gt;&lt;div&gt;local p = {}&lt;br /&gt;
&lt;br /&gt;
local contains = require(&amp;#039;Module:Array&amp;#039;).contains&lt;br /&gt;
local pagesWithCats = require(&amp;#039;Module:PageListTools&amp;#039;).pageswithcats&lt;br /&gt;
local paramTest = require(&amp;#039;Module:Paramtest&amp;#039;)&lt;br /&gt;
local yesNo = require(&amp;#039;Module:Yesno&amp;#039;)&lt;br /&gt;
&lt;br /&gt;
local html = mw.html&lt;br /&gt;
local ask = mw.smw.ask&lt;br /&gt;
local log = mw.log&lt;br /&gt;
&lt;br /&gt;
function buildRow(trackData, hints, members)&lt;br /&gt;
	local exclusivity = trackData.exclusive and &amp;#039;\&amp;#039;\&amp;#039;\&amp;#039;&amp;#039; or &amp;#039;&amp;#039;&lt;br /&gt;
	local event = trackData.event and &amp;#039;\&amp;#039;\&amp;#039;&amp;#039;or &amp;#039;&amp;#039;&lt;br /&gt;
	local trackLink, _ = string.gsub(trackData.file, &amp;#039;%|[^%]]+%]&amp;#039;, &amp;#039;|Play track]&amp;#039;) -- Replace visual override on link&lt;br /&gt;
	local row = html.create(&amp;#039;tr&amp;#039;):attr({ [&amp;#039;id&amp;#039;] = removeStringArticles(trackData.name), [&amp;#039;data-music-track-name&amp;#039;] = trackData.name })&lt;br /&gt;
&lt;br /&gt;
	row:tag(&amp;#039;td&amp;#039;):wikitext(event .. exclusivity .. &amp;#039;[[&amp;#039; .. trackData.name .. &amp;#039;]]&amp;#039; .. exclusivity .. event):done()&lt;br /&gt;
	if(hints) then&lt;br /&gt;
		row:tag(&amp;#039;td&amp;#039;):wikitext(trackData.hint):done()&lt;br /&gt;
	end&lt;br /&gt;
	if(members == nil)then&lt;br /&gt;
		row:tag(&amp;#039;td&amp;#039;):wikitext(yesNo(trackData.members) and &amp;#039;[[File:Member icon.png|link=|Members]]&amp;#039; or &amp;#039;[[File:Free-to-play icon.png|link=|Free-to-play]]&amp;#039;):done()&lt;br /&gt;
	end&lt;br /&gt;
	row:tag(&amp;#039;td&amp;#039;):wikitext(trackData.duration):done()&lt;br /&gt;
		:tag(&amp;#039;td&amp;#039;):wikitext(trackLink):done()&lt;br /&gt;
		&lt;br /&gt;
	return row&lt;br /&gt;
end&lt;br /&gt;
&lt;br /&gt;
function createHeader(hints, members)&lt;br /&gt;
	local tabl = html.create(&amp;#039;table&amp;#039;):addClass(&amp;#039;wikitable sortable lighttable embed-audio-links qc-active music-tracks sticky-header&amp;#039;)&lt;br /&gt;
	local row = tabl:tag(&amp;#039;tr&amp;#039;)&lt;br /&gt;
	row:tag(&amp;#039;th&amp;#039;):wikitext(&amp;#039;Name&amp;#039;):done()&lt;br /&gt;
	if(hints) then&lt;br /&gt;
		row:tag(&amp;#039;th&amp;#039;):wikitext(&amp;#039;Unlock hint&amp;#039;):done()&lt;br /&gt;
	end&lt;br /&gt;
	if(members == nil) then&lt;br /&gt;
		if(hints) then&lt;br /&gt;
			tabl:addClass(&amp;#039; align-center-3&amp;#039;)&lt;br /&gt;
		else&lt;br /&gt;
			tabl:addClass(&amp;#039; align-center-2&amp;#039;)&lt;br /&gt;
		end&lt;br /&gt;
		row:tag(&amp;#039;th&amp;#039;):wikitext(&amp;#039;Members&amp;#039;):done()&lt;br /&gt;
	end&lt;br /&gt;
	row:tag(&amp;#039;th&amp;#039;):wikitext(&amp;#039;Duration&amp;#039;):done()&lt;br /&gt;
		:tag(&amp;#039;th&amp;#039;):addClass(&amp;#039;unsortable&amp;#039;):wikitext(&amp;#039;Music track&amp;#039;):done()&lt;br /&gt;
	return tabl&lt;br /&gt;
end&lt;br /&gt;
&lt;br /&gt;
function addCategoryToData(data, cat, key)&lt;br /&gt;
	local pagesWithCat = pagesWithCats({ cat })&lt;br /&gt;
	&lt;br /&gt;
	for _, page in ipairs(data) do&lt;br /&gt;
		if(contains(pagesWithCat, page[1])) then&lt;br /&gt;
			page[key] = true&lt;br /&gt;
		else&lt;br /&gt;
			page[key] = false&lt;br /&gt;
		end&lt;br /&gt;
	end&lt;br /&gt;
	&lt;br /&gt;
	return data&lt;br /&gt;
end&lt;br /&gt;
&lt;br /&gt;
-- Removes leading articles for sort function&lt;br /&gt;
-- Sorts alphabetically after stripping any `A `, `An `, or `The ` and appending it to the end&lt;br /&gt;
-- Also removies &amp;quot;illegal&amp;quot; characters&lt;br /&gt;
function removeStringArticles(str)&lt;br /&gt;
	if(string.find(str, &amp;#039;^A &amp;#039;)) then&lt;br /&gt;
		str = string.sub(str, 3)&lt;br /&gt;
		str = str .. &amp;#039;, A&amp;#039;&lt;br /&gt;
	elseif(string.find(str, &amp;#039;^The &amp;#039;)) then&lt;br /&gt;
		str = string.sub(str, 5)&lt;br /&gt;
		str = str .. &amp;#039;, The&amp;#039;&lt;br /&gt;
	elseif(string.find(str, &amp;#039;^An &amp;#039;)) then&lt;br /&gt;
		str = string.sub(str, 4)&lt;br /&gt;
		str = str .. &amp;#039;, An&amp;#039;&lt;br /&gt;
	end&lt;br /&gt;
	string.gsub(str, &amp;#039;!&amp;#039;, &amp;#039;&amp;#039;)&lt;br /&gt;
	string.gsub(str, &amp;#039;\&amp;#039;&amp;#039;, &amp;#039;&amp;#039;)&lt;br /&gt;
	return str&lt;br /&gt;
end&lt;br /&gt;
&lt;br /&gt;
function tableConcat(mainTable, newTable)&lt;br /&gt;
    for i = 1, #newTable, 1 do&lt;br /&gt;
    	mainTable[#mainTable+1] = newTable[i]&lt;br /&gt;
    end&lt;br /&gt;
    return mainTable&lt;br /&gt;
end&lt;br /&gt;
&lt;br /&gt;
function filterData(data)&lt;br /&gt;
	local pagesToExclude = pagesWithCats({ &amp;#039;[[Category:Unlisted music tracks]]&amp;#039; })&lt;br /&gt;
	&lt;br /&gt;
	local retData = {}&lt;br /&gt;
	for _, page in ipairs(data) do&lt;br /&gt;
		if(not contains(pagesToExclude, page[1])) then&lt;br /&gt;
			table.insert(retData, page)&lt;br /&gt;
		end&lt;br /&gt;
	end&lt;br /&gt;
	&lt;br /&gt;
	return retData&lt;br /&gt;
end&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
function loadData(limit, batchSize, hints, members)&lt;br /&gt;
	local allData = {}&lt;br /&gt;
	&lt;br /&gt;
	local query = {&lt;br /&gt;
		&amp;#039;[[Category:Music tracks]]&amp;#039; .. (members ~= nil and &amp;#039;[[Is members only::&amp;#039; .. members .. &amp;#039;]]&amp;#039; or &amp;#039;&amp;#039;),&lt;br /&gt;
		&amp;#039;?=#-&amp;#039;,&lt;br /&gt;
		&amp;#039;?Music track title=name&amp;#039;,&lt;br /&gt;
		(hints and &amp;#039;?Unlock hint=hint&amp;#039; or &amp;#039;&amp;#039;),&lt;br /&gt;
		(members == nil and &amp;#039;?Is members only=members&amp;#039; or &amp;#039;&amp;#039;),&lt;br /&gt;
		&amp;#039;?Music duration=duration&amp;#039;,&lt;br /&gt;
		&amp;#039;?Music track=file&amp;#039;,&lt;br /&gt;
	}&lt;br /&gt;
	query.limit = batchSize&lt;br /&gt;
	query.offset = 0&lt;br /&gt;
	&lt;br /&gt;
	for i = 0, limit, batchSize do&lt;br /&gt;
		query.limit = batchSize&lt;br /&gt;
		query.offset = i&lt;br /&gt;
		&lt;br /&gt;
		local t1 = os.clock()&lt;br /&gt;
		local smwData = ask(query)&lt;br /&gt;
		local t2 = os.clock()&lt;br /&gt;
		if(smwData == nil) then break end&lt;br /&gt;
		log(string.format(&amp;#039;SMW: entries %d, time elapsed: %.3f ms.&amp;#039;, #smwData, (t2 - t1) * 1000))&lt;br /&gt;
		smwData = filterData(smwData)&lt;br /&gt;
		tableConcat(allData, smwData)&lt;br /&gt;
	end&lt;br /&gt;
	&lt;br /&gt;
	assert(allData ~= nil and #allData &amp;gt; 0, &amp;#039;SMW query failed&amp;#039;)&lt;br /&gt;
	&lt;br /&gt;
	table.sort(allData, function(a, b) return removeStringArticles(a[1]) &amp;lt; removeStringArticles(b[1]) end)&lt;br /&gt;
	&lt;br /&gt;
	return allData&lt;br /&gt;
end&lt;br /&gt;
&lt;br /&gt;
function p._main(args)&lt;br /&gt;
	local limit = paramTest.default_to(tonumber(args.limit), 5000) -- Acting as a real limiter&lt;br /&gt;
	local batchSize = paramTest.default_to(tonumber(args.batchsize), 250) -- 250 is slightly faster than 100 here&lt;br /&gt;
&lt;br /&gt;
	local hints = yesNo(args.hints) or false&lt;br /&gt;
	local members = paramTest.default_to(args.members, nil)&lt;br /&gt;
&lt;br /&gt;
	local data = loadData(limit, batchSize, hints, members)&lt;br /&gt;
	data = addCategoryToData(data, &amp;#039;[[Category:Old School-exclusive music]]&amp;#039;, &amp;#039;exclusive&amp;#039;)&lt;br /&gt;
	data = addCategoryToData(data, &amp;#039;[[Category:Event music]]&amp;#039;, &amp;#039;event&amp;#039;)&lt;br /&gt;
	&lt;br /&gt;
	local ret = createHeader(hints, members)&lt;br /&gt;
	for _, trackPage in ipairs(data) do&lt;br /&gt;
		ret:node(buildRow(trackPage, hints, members))&lt;br /&gt;
	end&lt;br /&gt;
	&lt;br /&gt;
	return ret&lt;br /&gt;
end&lt;br /&gt;
&lt;br /&gt;
--[[DEBUG&lt;br /&gt;
p._main({})&lt;br /&gt;
p._main({[&amp;#039;hints&amp;#039;] = &amp;#039;Yes&amp;#039;, [&amp;#039;members&amp;#039;] = &amp;#039;No&amp;#039;})&lt;br /&gt;
]]&lt;br /&gt;
&lt;br /&gt;
function p.main(frame)&lt;br /&gt;
	local args = frame:getParent().args&lt;br /&gt;
	return p._main(args)&lt;br /&gt;
end&lt;br /&gt;
&lt;br /&gt;
return p&lt;/div&gt;</summary>
		<author><name>Alex</name></author>
	</entry>
</feed>