Module:PageNews - Revision history

Couchor at 08:01, 30 April 2024

2024-04-30T08:01:29Z

← Older revision		Revision as of 08:01, 30 April 2024
Line 12:		Line 12:
	local cargoArgs = {		local cargoArgs = {
	where = 'content LIKE "%[[' .. currentTitle .. '\|%" OR content LIKE "%[[' .. currentTitle .. ']]%" OR targets HOLDS "' .. currentTitle .. '"',		where = 'content LIKE "%[[' .. currentTitle .. '\|%" OR content LIKE "%[[' .. currentTitle .. ']]%" OR targets HOLDS "' .. currentTitle .. '"',
	orderBy = 'date'		orderBy = 'date DESC'
	}		}

Couchor at 21:20, 26 April 2024

2024-04-26T21:20:46Z

← Older revision		Revision as of 21:20, 26 April 2024
Line 11:		Line 11:
	local fields = '_pageName, category, game, date, content, targets, author'		local fields = '_pageName, category, game, date, content, targets, author'
	local cargoArgs = {		local cargoArgs = {
	where = '~~BINARY~~ content LIKE "%[[' .. currentTitle .. '\|%" OR ~~BINARY~~ content LIKE "%[[' .. currentTitle .. ']]%" OR targets HOLDS "' .. currentTitle .. '"',		where = 'content LIKE "%[[' .. currentTitle .. '\|%" OR content LIKE "%[[' .. currentTitle .. ']]%" OR targets HOLDS "' .. currentTitle .. '"',
	orderBy = 'date'		orderBy = 'date'
	}		}

Couchor at 21:20, 26 April 2024

2024-04-26T21:20:07Z

← Older revision		Revision as of 21:20, 26 April 2024
Line 11:		Line 11:
	local fields = '_pageName, category, game, date, content, targets, author'		local fields = '_pageName, category, game, date, content, targets, author'
	local cargoArgs = {		local cargoArgs = {
	where = 'BINARY content LIKE "%[[' .. currentTitle .. '%" OR targets HOLDS "' .. currentTitle .. '"',		where = 'BINARY content LIKE "%[[' .. currentTitle .. '\|%" OR BINARY content LIKE "%[[' .. currentTitle .. ']]%" OR targets HOLDS "' .. currentTitle .. '"',
	orderBy = 'date'		orderBy = 'date'
	}		}

Couchor at 20:44, 26 April 2024

2024-04-26T20:44:55Z

← Older revision		Revision as of 20:44, 26 April 2024
Line 11:		Line 11:
	local fields = '_pageName, category, game, date, content, targets, author'		local fields = '_pageName, category, game, date, content, targets, author'
	local cargoArgs = {		local cargoArgs = {
	where = 'content LIKE "%[[' .. currentTitle .. '%" OR targets HOLDS "' .. currentTitle .. '"',		where = 'BINARY content LIKE "%[[' .. currentTitle .. '%" OR targets HOLDS "' .. currentTitle .. '"',
	orderBy = 'date'		orderBy = 'date'
	}		}

Couchor at 09:14, 2 November 2023

2023-11-02T09:14:13Z

← Older revision		Revision as of 09:14, 2 November 2023
Line 5:		Line 5:

	function pageNews.main(frame)		function pageNews.main(frame)
	local currentTitle = mw.title.getCurrentTitle().text		local currentTitle = string.gsub(mw.title.getCurrentTitle().text, ' ', '_')
	local empty = true		local empty = true
	-- Check if there are any interviews for this page		-- Check if there are any interviews for this page

Couchor at 00:03, 10 October 2023

2023-10-10T00:03:14Z

← Older revision		Revision as of 00:03, 10 October 2023
Line 16:		Line 16:

	local results = cargo.query(tables, fields, cargoArgs)		local results = cargo.query(tables, fields, cargoArgs)
	~~mw.logObject(results)~~
	local container = mw.html.create():node(mw.html.create('h2'):wikitext('News'))		local container = mw.html.create():node(mw.html.create('h2'):wikitext('News'))
	if #results > 0 then		if #results > 0 then

Couchor at 20:49, 4 May 2023

2023-05-04T20:49:10Z

← Older revision		Revision as of 20:49, 4 May 2023
Line 8:		Line 8:
	local empty = true		local empty = true
	-- Check if there are any interviews for this page		-- Check if there are any interviews for this page
	local tables = '~~Test~~'		local tables = 'News'
	local fields = '_pageName, category, game, date, content, targets, author'		local fields = '_pageName, category, game, date, content, targets, author'
	local cargoArgs = {		local cargoArgs = {

Couchor at 20:48, 4 May 2023

2023-05-04T20:48:27Z

← Older revision		Revision as of 20:48, 4 May 2023
Line 8:		Line 8:
	local empty = true		local empty = true
	-- Check if there are any interviews for this page		-- Check if there are any interviews for this page
	local tables = '~~News~~'		local tables = 'Test'
	local fields = '~~date~~, ~~title~~, ~~type~~, ~~author~~, ~~lang~~, ~~source~~, ~~trans_lang, translator, event, note, targets~~'		local fields = '_pageName, category, game, date, content, targets, author'
	local cargoArgs = {		local cargoArgs = {
	where = 'targets HOLDS "' .. currentTitle .. '~~" AND type="interview~~"',		where = 'content LIKE "%[[' .. currentTitle .. '%" OR targets HOLDS "' .. currentTitle .. '"',
	orderBy = 'date'		orderBy = 'date'
	}		}

	local results = cargo.query(tables, fields, cargoArgs)		local results = cargo.query(tables, fields, cargoArgs)
			mw.logObject(results)
	local container = mw.html.create()		local container = mw.html.create():node(mw.html.create('h2'):wikitext('News'))
	if #results > 0 then		if #results > 0 then
	~~container:node(mw.html.create('h2'):wikitext('Interviews'))~~
	empty = false		empty = false
	local ul = mw.html.create('ul')		local ul = mw.html.create('ul')
Line 39:		Line 38:

	function pageNews.object(result)		function pageNews.object(result)
	local object = {}		local object = {
	~~object.~~date = result.date		date = result.date,
	~~object.lang~~ = result.~~lang~~		_pageName = result._pageName,
	~~object.url~~ = result.~~url~~		category = result.category,
	~~object.author~~ = result.~~author~~		game = result.game,
	~~object.source~~ = result.~~source~~		content = result.content,
	~~object.event~~ = result.~~event~~		author = result.author
	~~object.trans_lang = result.trans_lang~~		}
	~~object.translator = result.translator~~
	~~object.event = result.event~~
	return object		return object
	end		end

	return pageNews		return pageNews

Couchor at 05:26, 11 October 2022

2022-10-11T05:26:45Z

← Older revision		Revision as of 05:26, 11 October 2022
Line 14:		Line 14:
	orderBy = 'date'		orderBy = 'date'
	}		}

	~~local returnString = ''~~
	local results = cargo.query(tables, fields, cargoArgs)		local results = cargo.query(tables, fields, cargoArgs)
	~~-- local container = mw.html.create('div')~~
	local container = mw.html.create()		local container = mw.html.create()
	if #results > 0 then		if #results > 0 then
	container:node(mw.html.create('h2'):wikitext('Interviews'))		container:node(mw.html.create('h2'):wikitext('Interviews'))
	~~-- returnString = returnString .. tostring(mw.html.create('h2'):wikitext('Interviews'))~~
	empty = false		empty = false
	local ul = mw.html.create('ul')		local ul = mw.html.create('ul')
	~~-- local interviews = mw.html.create('div'):node(ul)~~
	~~-- local interviews = mw.html.create('ul')~~

	for r = 1, #results do		for r = 1, #results do
	ul:node(mw.html.create('li'):node(News.main(pageNews.object(results[r]))))		ul:node(mw.html.create('li'):node(News.main(pageNews.object(results[r]))))
	end		end
	~~-- mw.log('itnervisdsdad')~~
	~~-- mw.log(ul)~~
	~~-- mw.logObject(ul)~~
	~~-- returnString = returnString .. tostring(ul)~~
	container:node(ul)		container:node(ul)
	end		end
Line 40:		Line 33:
	return '<span class="d-none"></span>'		return '<span class="d-none"></span>'
	else		else
	~~mw.log('stringggggg')~~
	~~mw.log(returnString)~~
	return container		return container
	~~-- return returnString~~
	end		end

Couchor at 05:25, 11 October 2022

2022-10-11T05:25:51Z

← Older revision		Revision as of 05:25, 11 October 2022
Line 20:		Line 20:
	local container = mw.html.create()		local container = mw.html.create()
	if #results > 0 then		if #results > 0 then
	container:node(mw.html.create('h2~~'):addClass('mw-collapsible~~'):wikitext('Interviews'))		container:node(mw.html.create('h2'):wikitext('Interviews'))
	-- returnString = returnString .. tostring(mw.html.create('h2'):wikitext('Interviews'))		-- returnString = returnString .. tostring(mw.html.create('h2'):wikitext('Interviews'))
	empty = false		empty = false