Template:CardInfobox - Revision history

Teltura: Fixing sites showing "none" as a linked side

2024-06-28T03:22:51Z

Fixing sites showing "none" as a linked side

← Older revision		Revision as of 03:22, 28 June 2024
Line 56:		Line 56:
	C.CardType,		C.CardType,
	CONCAT('[[Image:Culture_', C.Culture, '.svg{{!}}x20px{{!}}text-bottom{{!}}link=', C.Culture, '_Culture{{!}}class=whitebg]] \'\'\'[[', C.Culture, '_Culture{{!}}', C.Culture, ']]\'\'\'')=Culture,		CONCAT('[[Image:Culture_', C.Culture, '.svg{{!}}x20px{{!}}text-bottom{{!}}link=', C.Culture, '_Culture{{!}}class=whitebg]] \'\'\'[[', C.Culture, '_Culture{{!}}', C.Culture, ']]\'\'\'')=Culture,
	CONCAT('[[', IF(C.Side='Freeps', 'Free Peoples', C.Side), ']]')=Side,		IF(C.Side='None', C.Side, CONCAT('[[', IF(C.Side='Freeps', 'Free Peoples', C.Side), ']]'))=Side,
	CT.SubtypeClass, CR.Subtypes,		CT.SubtypeClass, CR.Subtypes,
	CR.TwilightCost,		CR.TwilightCost,

2022-07-01T15:04:16Z

← Older revision		Revision as of 15:04, 1 July 2022
Line 29:		Line 29:
	TRIM('Title'), CR.Title,		TRIM('Title'), CR.Title,
	TRIM('Subtitle'), IFNULL(CR.Subtitle,' '),		TRIM('Subtitle'), IFNULL(CR.Subtitle,' '),
	TRIM('Unique'), CR.IsUnique,		TRIM('Unique'), IF(CR.IsUnique = 1, 'Yes', 'No'),
	TRIM('Collectible'), IF(IFNULL(CR.IsPhysical, C.IsPhysical) = 1, 'Yes', 'No'),		TRIM('Collectible'), IF(IFNULL(CR.IsPhysical, C.IsPhysical) = 1, 'Yes', 'No'),
	TRIM('Notes'), IFNULL(C.Notes,' '),		TRIM('Notes'), IFNULL(C.Notes,' '),

2022-07-01T15:03:31Z

adding uniqueness to the card infobox

← Older revision		Revision as of 15:03, 1 July 2022
Line 29:		Line 29:
	TRIM('Title'), CR.Title,		TRIM('Title'), CR.Title,
	TRIM('Subtitle'), IFNULL(CR.Subtitle,' '),		TRIM('Subtitle'), IFNULL(CR.Subtitle,' '),
			TRIM('Unique'), CR.IsUnique,
	TRIM('Collectible'), IF(IFNULL(CR.IsPhysical, C.IsPhysical) = 1, 'Yes', 'No'),		TRIM('Collectible'), IF(IFNULL(CR.IsPhysical, C.IsPhysical) = 1, 'Yes', 'No'),
	TRIM('Notes'), IFNULL(C.Notes,' '),		TRIM('Notes'), IFNULL(C.Notes,' '),

2021-11-16T19:30:53Z

← Older revision		Revision as of 19:30, 16 November 2021
Line 29:		Line 29:
	TRIM('Title'), CR.Title,		TRIM('Title'), CR.Title,
	TRIM('Subtitle'), IFNULL(CR.Subtitle,' '),		TRIM('Subtitle'), IFNULL(CR.Subtitle,' '),
	TRIM('Collectible'), ~~CONCAT~~(~~'"',~~ IFNULL(CR.IsPhysical, C.IsPhysical), '~~", "', IFNULL(C.IsPhysical, 'NONE~~'), '~~", "~~'~~, C.ID~~),		TRIM('Collectible'), IF(IFNULL(CR.IsPhysical, C.IsPhysical) = 1, 'Yes', 'No'),
	TRIM('Notes'), IFNULL(C.Notes,' '),		TRIM('Notes'), IFNULL(C.Notes,' '),
	TRIM('[[Set]]'), CONCAT(CS.ID, ' - [[', CS.Name, ']]'),		TRIM('[[Set]]'), CONCAT(CS.ID, ' - [[', CS.Name, ']]'),

2021-11-16T19:29:56Z

← Older revision		Revision as of 19:29, 16 November 2021
Line 29:		Line 29:
	TRIM('Title'), CR.Title,		TRIM('Title'), CR.Title,
	TRIM('Subtitle'), IFNULL(CR.Subtitle,' '),		TRIM('Subtitle'), IFNULL(CR.Subtitle,' '),
	TRIM('Collectible'), CONCAT('"', IFNULL(CR.IsPhysical, ~~'NONE'~~), '", "', IFNULL(C.IsPhysical, 'NONE'), '", "', C.ID),		TRIM('Collectible'), CONCAT('"', IFNULL(CR.IsPhysical, C.IsPhysical), '", "', IFNULL(C.IsPhysical, 'NONE'), '", "', C.ID),
	TRIM('Notes'), IFNULL(C.Notes,' '),		TRIM('Notes'), IFNULL(C.Notes,' '),
	TRIM('[[Set]]'), CONCAT(CS.ID, ' - [[', CS.Name, ']]'),		TRIM('[[Set]]'), CONCAT(CS.ID, ' - [[', CS.Name, ']]'),

2021-11-16T19:28:37Z

← Older revision		Revision as of 19:28, 16 November 2021
Line 29:		Line 29:
	TRIM('Title'), CR.Title,		TRIM('Title'), CR.Title,
	TRIM('Subtitle'), IFNULL(CR.Subtitle,' '),		TRIM('Subtitle'), IFNULL(CR.Subtitle,' '),
	TRIM('Collectible'), CONCAT('"', CR.IsPhysical, '", "', C.IsPhysical, '", "', C.ID),		TRIM('Collectible'), CONCAT('"', IFNULL(CR.IsPhysical, 'NONE'), '", "', IFNULL(C.IsPhysical, 'NONE'), '", "', C.ID),
	TRIM('Notes'), IFNULL(C.Notes,' '),		TRIM('Notes'), IFNULL(C.Notes,' '),
	TRIM('[[Set]]'), CONCAT(CS.ID, ' - [[', CS.Name, ']]'),		TRIM('[[Set]]'), CONCAT(CS.ID, ' - [[', CS.Name, ']]'),

2021-11-16T19:27:39Z

← Older revision		Revision as of 19:27, 16 November 2021
Line 29:		Line 29:
	TRIM('Title'), CR.Title,		TRIM('Title'), CR.Title,
	TRIM('Subtitle'), IFNULL(CR.Subtitle,' '),		TRIM('Subtitle'), IFNULL(CR.Subtitle,' '),
	TRIM('Collectible'), CONCAT('"', CR.IsPhysical, '", "', C.IsPhysical, '"'),		TRIM('Collectible'), CONCAT('"', CR.IsPhysical, '", "', C.IsPhysical, '", "', C.ID),
	TRIM('Notes'), IFNULL(C.Notes,' '),		TRIM('Notes'), IFNULL(C.Notes,' '),
	TRIM('[[Set]]'), CONCAT(CS.ID, ' - [[', CS.Name, ']]'),		TRIM('[[Set]]'), CONCAT(CS.ID, ' - [[', CS.Name, ']]'),

2021-11-16T19:26:44Z

← Older revision		Revision as of 19:26, 16 November 2021
Line 29:		Line 29:
	TRIM('Title'), CR.Title,		TRIM('Title'), CR.Title,
	TRIM('Subtitle'), IFNULL(CR.Subtitle,' '),		TRIM('Subtitle'), IFNULL(CR.Subtitle,' '),
	TRIM('Collectible'), CONCAT('`', CR.IsPhysical, '`, `', C.IsPhysical, '`'),		TRIM('Collectible'), CONCAT('"', CR.IsPhysical, '", "', C.IsPhysical, '"'),
	TRIM('Notes'), IFNULL(C.Notes,' '),		TRIM('Notes'), IFNULL(C.Notes,' '),
	TRIM('[[Set]]'), CONCAT(CS.ID, ' - [[', CS.Name, ']]'),		TRIM('[[Set]]'), CONCAT(CS.ID, ' - [[', CS.Name, ']]'),

2021-11-16T19:25:37Z

← Older revision		Revision as of 19:25, 16 November 2021
Line 29:		Line 29:
	TRIM('Title'), CR.Title,		TRIM('Title'), CR.Title,
	TRIM('Subtitle'), IFNULL(CR.Subtitle,' '),		TRIM('Subtitle'), IFNULL(CR.Subtitle,' '),
	TRIM('Collectible'), ~~IF(IFNULL~~(CR.IsPhysical,C.IsPhysical~~) = 1, 'Yes'~~, 'No'),		TRIM('Collectible'), CONCAT('`', CR.IsPhysical, '`, `', C.IsPhysical, '`'),
	TRIM('Notes'), IFNULL(C.Notes,' '),		TRIM('Notes'), IFNULL(C.Notes,' '),
	TRIM('[[Set]]'), CONCAT(CS.ID, ' - [[', CS.Name, ']]'),		TRIM('[[Set]]'), CONCAT(CS.ID, ' - [[', CS.Name, ']]'),

2021-11-16T19:19:37Z

← Older revision		Revision as of 19:19, 16 November 2021
Line 29:		Line 29:
	TRIM('Title'), CR.Title,		TRIM('Title'), CR.Title,
	TRIM('Subtitle'), IFNULL(CR.Subtitle,' '),		TRIM('Subtitle'), IFNULL(CR.Subtitle,' '),
	TRIM('Collectible'), IF(C.IsPhysical = 1, 'Yes', 'No'),		TRIM('Collectible'), IF(IFNULL(CR.IsPhysical,C.IsPhysical) = 1, 'Yes', 'No'),
	TRIM('Notes'), IFNULL(C.Notes,' '),		TRIM('Notes'), IFNULL(C.Notes,' '),
	TRIM('[[Set]]'), CONCAT(CS.ID, ' - [[', CS.Name, ']]'),		TRIM('[[Set]]'), CONCAT(CS.ID, ' - [[', CS.Name, ']]'),