inportal_upgrade_v1.1.1.php
No OneTemporary
Actions

Subscribers

None

File Metadata

	<?php

	linkCustomFields('In-Commerce', 'p', 2);

	linkCustomFields('KERNEL', 'c', 1);

	$application =& kApplication::Instance();

	$query = 'REPLACE INTO '.TABLE_PREFIX.'CategoryItems (CategoryId, ItemResourceid, Primarycat, ItemPrefix, Filename)
	SELECT
	ci.CategoryId,
	ci.ItemResourceId,
	ci.PrimaryCat,
	\'p\' AS ItemPrefix,
	i.Filename as Filename
	FROM `'.TABLE_PREFIX.'Products` as i
	LEFT JOIN '.TABLE_PREFIX.'CategoryItems as ci
	ON ci.ItemResourceId = i.ResourceId;';
	$application->Conn->Query($query);

	moveItemTemplatesToCustom('In-Commerce', 'p');

	?>