80,735
edits
(Module:Luacard2) |
(Module:Luacard2) |
||
Line 314: | Line 314: | ||
where="(Pages like '%•"..cardname.."•%' OR (pages IS null AND Cards like '%•"..cardname.."•%')) AND Type!='Twin'", | where="(Pages like '%•"..cardname.."•%' OR (pages IS null AND Cards like '%•"..cardname.."•%')) AND Type!='Twin'", | ||
orderBy='Text ASC' | orderBy='Text ASC' | ||
}) | |||
end | |||
function relatedflavorquery(cardname) | |||
return cargo_results( | |||
'CardData', | |||
'Name, FlavorText', | |||
{ | |||
where="CardData.FlavorText LIKE '%"..cardname.."%'", | |||
orderBy='CardData.Name ASC' | |||
}) | }) | ||
end | end | ||
Line 360: | Line 370: | ||
-- we use cardname_e and just show english related | -- we use cardname_e and just show english related | ||
local related_set = relatedquery(vars.cardname_e) | local related_set = relatedquery(vars.cardname_e) | ||
local related_flavor_set = relatedflavorquery(vars.cardname_e) | |||
local twin_set = twinquery(vars.cardname_e) | local twin_set = twinquery(vars.cardname_e) | ||
mw.logObject(twin_set) | mw.logObject(twin_set) | ||
Line 371: | Line 382: | ||
}) | }) | ||
end) | end) | ||
if #related_flavor_set > 0 then | |||
local flavor_card_names = "" | |||
for i=1, #related_flavor_set do | |||
flavor_card_names = flavor_card_names .. "•"..related_flavor_set[i]["Name"].."•" | |||
end | |||
append(related_set, { | |||
Pages = "•"..vars.cardname_e.."•", | |||
Text = "this card is featured in the flavor text of the following cards:", | |||
Cards = flavor_card_names | |||
}) | |||
end | |||
map(related_set, function(item) | map(related_set, function(item) | ||
item['Text'] = item['Text']:gsub('this card', "'''"..vars.cardname_e.."'''") | item['Text'] = item['Text']:gsub('this card', "'''"..vars.cardname_e.."'''") |