Module:RelatedNews

2026-10-05T14:33:32Z

Maintenance script: Related news snippet: stop splitting the article text after the words that are shown

local getArgs = require('Module:Arguments').getArgs
local cargo = mw.ext.cargo

local p = {}

local function sanitizeForSQL(input)
if not input then return '' end
-- Remove control characters
input = mw.ustring.gsub(input, '[%z\1-\31\127]', '')
-- Remove U+2060 (word joiner) and U+200B (zero-width space)
input = mw.ustring.gsub(input, '[\226\129\160\226\128\139]', '')
-- Correct way: double the quotes (SQL standard)
input = mw.ustring.gsub(input, '"', '""')
return input
end

function p.main(frame)
local args = getArgs(frame)

local relatedTagsNews = getRelatedTagNews(args.tags, mw.title.getCurrentTitle().text)

local newsItemContainer = mw.html.create('div'):addClass('related__news')

local iconHtml = '[[File:News-icon.png|30px|alt=Related News Icon]]'
local iconElement = mw.html.create('h3'):addClass('news-icon'):wikitext(iconHtml .. '<span style="margin-left: 10px;">Related news</span>')

local titleContainer = mw.html.create('div'):addClass('related__news__title-container'):attr('style', 'display: flex; align-items: center;')
titleContainer:node(iconElement)

local viewAllElement = mw.html.create('span')
:addClass('related__news__view-all')
:attr('id', 'view-all-button')
:wikitext('[[News|View All]]')

titleContainer:node(viewAllElement)

local container = mw.html.create('div'):addClass('related__news__container'):node(titleContainer):node(newsItemContainer)

if #relatedTagsNews > 0 then
for i = 1, #relatedTagsNews do
addArticleToContainer(relatedTagsNews[i], newsItemContainer)
end
end

if #relatedTagsNews < 5 then
local relatedCatNews = getRelatedCatNews(args.categories, mw.title.getCurrentTitle().text, relatedTagsNews, 5 - #relatedTagsNews)
for i = 1, #relatedCatNews do
addArticleToContainer(relatedCatNews[i], newsItemContainer)
end
end

return container
end

function addArticleToContainer(result, container)
local image = result.image or 'News placeholder.png'
local link = result._pageName
local category = result.category and mw.text.split(result.category, ',')[1] or 'Uncategorized'

local categoryClassMap = {
['News'] = 'news-category-news',
['Transfer Market'] = 'news-category-transfer',
['Drama'] = 'news-category-drama',
['Business'] = 'news-category-business',
['Sponsorships'] = 'news-category-sponsorships'
}

local categoryClass = categoryClassMap[category] or 'default-category-class'

local date = result.date and formatDate(result.date) or 'Unknown date'

local title = mw.html.create('div')
:addClass('news-title-twogpedia')
:wikitext('[[' .. result._pageName .. '|' .. mw.ext.displaytitle.get(result._pageName) .. ']]')

local metaContainer = mw.html.create('div'):addClass('news-meta-container')
local categoryElement = mw.html.create('p'):addClass('news-meta news-category-meta ' .. categoryClass):wikitext(category)
local dateElement = mw.html.create('p'):addClass('news-meta news-date'):wikitext(date)

metaContainer:node(categoryElement):node(dateElement)

local contentSnippet = getContentSnippet(result.content)
local contentElement = mw.html.create('p'):addClass('news-content'):wikitext(contentSnippet)

local imageHtml = '[[File:' .. image .. '|link=' .. link .. '|800px|class=news-image|alt=News Image]]'

local imageContainer = mw.html.create('div'):addClass('news-image-container'):wikitext(imageHtml)

local newsItem = mw.html.create('div')
:addClass('related__article')
:node(imageContainer)
:node(title)
:node(contentElement)
:node(metaContainer)

container:node(newsItem)
end

function getContentSnippet(content)
if not content or content == '' then
return ''
end

local plain = mw.ustring.gsub(content, '<[^>]+>', '')

plain = mw.ustring.gsub(plain, "'''", '')
plain = mw.ustring.gsub(plain, "''", '')
plain = mw.ustring.gsub(plain, '^%s+', '')
plain = mw.ustring.gsub(plain, '%s+$', '')

local maxWords = 20
local snippetWords = {}
local hasMore = false
for word in mw.text.gsplit(plain, '%s+') do
if #snippetWords == maxWords then
hasMore = true
break
end
table.insert(snippetWords, word)
end

local snippet = table.concat(snippetWords, ' ')
if hasMore then
snippet = snippet .. '...'
end

return snippet
end

function formatDate(dateStr)
local year, month, day = dateStr:match("(%d+)%-(%d+)%-(%d+)")
local time = os.time({year = year, month = month, day = day})
return os.date("%b %d, %Y", time)
end

function getRelatedTagNews(tags, pageName)
if not tags then return {} end

pageName = sanitizeForSQL(pageName)

local whereStr = '_pageName != "' .. pageName .. '" AND ('
local tagsSplit = mw.text.split(tags, ',')
for i = 1, #tagsSplit do
if i > 1 then whereStr = whereStr .. ' OR ' end
whereStr = whereStr .. 'tags HOLDS "' .. sanitizeForSQL(mw.text.trim(tagsSplit[i])) .. '"'
end
whereStr = whereStr .. ')'

local tables = 'News'
local fields = '_pageName, date, tags, image, category, content'
local cargoArgs = {
where = whereStr,
orderBy = 'date DESC',
limit = 5
}
local results = cargo.query(tables, fields, cargoArgs)
return results
end

function getRelatedCatNews(categories, pageName, tagNews, missingAmount)
if not categories then return {} end

pageName = sanitizeForSQL(pageName)

local whereStr = ''

if #tagNews > 0 then
for i = 1, #tagNews do
whereStr = whereStr .. '_pageName != "' .. sanitizeForSQL(tagNews[i]._pageName) .. '" AND '
end
end

whereStr = whereStr .. '_pageName != "' .. pageName .. '" AND ('
local catSplit = mw.text.split(categories, ',')
for i = 1, #catSplit do
if i > 1 then whereStr = whereStr .. ' OR ' end
whereStr = whereStr .. 'category HOLDS "' .. sanitizeForSQL(mw.text.trim(catSplit[i])) .. '"'
end
whereStr = whereStr .. ')'

local tables = 'News'
local fields = '_pageName, date, tags, image, category, content'
local cargoArgs = {
where = whereStr,
orderBy = 'date DESC',
limit = missingAmount
}
local results = cargo.query(tables, fields, cargoArgs)
return results
end

return p

Template:News

2026-10-02T15:30:50Z

Maintenance script: Add the Scrapedia Media Archive slot at the end of the news-left column

<templatestyles src="NewsArticle.css" />
<noinclude>
{{#cargo_declare:_table=News
|image=File
|image_alt=String
|tags=List (,) of String
|targets=List (,) of Page
|date=Datetime
|author = Page
|category= List (,) of String (hierarchy; allowed values=
*Transfer Market
*Drama
*Business
**Companies
**Hires
**Investments
**Mergers and Acquisitions
**Sponsorships
*More
)
|game=List (,) of String (hierarchy; allowed values=
*Age of Empires
*Apex Legends
*Brawl Stars
*Call of Duty
*Counter Strike
*Dota 2
*FIFA
*Fortnite
*Hearthstone
*League of Legends
*Mobile Legends
*NBA 2K
*Overwatch
*PUBG
*PUBG Mobile
*Rainbow Six
*Rocket League
*Smash
*Starcraft II
*Valorant
*Warcraft III
*World of Warcraft
*Wild Rift
)
|content=Text}}
</noinclude>

<includeonly>

{{DISPLAYTITLE: {{{seo_title|}}} }}

{{#if: {{{stub|}}} | {{Stub|type=News|comment={{{stub}}} }} }}

{{#cargo_store:_table=News
|image={{{image|}}}
|image_alt={{{alt|{{{seo_title|}}}}}}
|tags={{{tags|}}}
|targets={{{target|}}}
|date={{{date|}}}
|author={{{author|}}}
|category={{{category|}}}
|game={{{game|}}}
|content={{{content|}}}
}}

{{#seo:
|title={{{seo_title|}}}
|description={{#invoke:TruncDesc|generate|content={{{content|}}}|seo_description={{{seo_description|}}}}}
|keywords={{{seo_keywords|}}}
|image={{{image|}}}
|image_alt={{{alt|}}}
|tags={{{tags|}}}
|targets={{{target|}}}
|date={{{date|}}}
|sources={{{sources|}}}
|author={{{author|}}}
|category={{{category|}}}
|game={{{game|}}}
|content={{{content|}}}
}}

{{NewsNav}}
<div class="news__grid">
<div class="news-left">

<div class="news-image-container-twogpedia">
{{#if: {{{image|}}} | <div class="news-image-twogpedia">[[File:{{{image|}}}|800x600px|alt={{{alt|{{{seo_title|}}}}}}|link=]]</div> }}
</div>

<div id="first-title-twogpedia" class="firstHeading mw-first-heading">{{{seo_title}}}</div>

<div class="news-meta-container">
<p class="news-meta" style="display: inline-flex; flex-wrap: wrap; margin: var(--space-xs) 0 0 10px; font-size: 0.8125rem; gap: var(--space-xs); letter-spacing: 0;">
{{#arraymap: {{{category|}}}|,|x|<span class="news-category-meta">x</span>|\s }}
</p>
<p class="news-meta news-date">{{#time: d F Y H:i | {{{date|}}} }}</p>
</div>

<div class="news-meta-content-twogpedia">
{{{content|}}}
</div>

<div style="clear: both;"></div>

<div class="last-container-news-twogpedia" id="first-container-news-twogpedia">
<div class="left-last-container-news-twogpedia">
<div class="tag-container">{{#if: {{{tags|}}} | '''Tags:''' {{#arraymap: {{{tags|}}}|,|x|<span class="tag-links">[{{SERVER}}/Tag?name={{urlencode: x}} x]</span>|\s }} }}</div>
</div>
<div class="right-last-container-news-twogpedia">
{{#invoke:SocialShare|generateShareLinks}}
</div>
</div>

<div class="last-container-news-twogpedia">
<div class="left-last-container-news-twogpedia">
{{#if: {{{sources|}}} |
<b>Sources:</b> <div class="icon-container-sources">{{#arraymap: {{{sources|}}}|,|x|x| \s }} </div>
}}
</div>
<div class="right-last-container-news-twogpedia" id="last-container-news-mistake-twogpedia">
<span class="icon-container-news-twogpedia">
[[Special:ReportMistake|Report mistake]] [[File:Report-mistake-icon.png|30px|link=Special:ReportMistake]]
</span>
<span class="icon-container-news-twogpedia">
[[Form:News|Submit news]] [[File:Submit-news-icon.png|30px|link=Form:News]]
</span>
</div>
</div>
<div class="scrapedia-archive-slot"></div>
</div>

<div class="related__news__container">
{{RelatedNews|tags={{{tags|}}} |categories={{{category|}}} }}
</div>
</div>

[[Category:News]]
</includeonly>

TwogPedia - User contributions [en]

Module:RelatedNews

Template:News