<?php
	$application =& kApplication::Instance();

	if ($application->ConfigValue('InstallFinished') === false) {
		$fields_hash = Array (
			'VariableName'	=>	'InstallFinished',
			'VariableValue'	=>	1,
		);
		$application->Conn->doInsert($fields_hash, TABLE_PREFIX.'ConfigurationValues');
	}

	if ($application->TableFound(TABLE_PREFIX.'Orders')) {
		$sql = 'SELECT OrderId
				FROM '.TABLE_PREFIX.'Orders
				WHERE (Status = '.ORDER_STATUS_INCOMPLETE.') AND (OrderDate < '.strtotime('-1 day').')';
		$order_ids = $application->Conn->GetCol($sql);

		if ($order_ids) {
			$sql = 'DELETE FROM '.TABLE_PREFIX.'Orders
					WHERE OrderId IN ('.implode(',', $order_ids).')';
			$application->Conn->Query($sql);

			$sql = 'DELETE FROM '.TABLE_PREFIX.'OrderItems
					WHERE OrderId IN ('.implode(',', $order_ids).')';
			$application->Conn->Query($sql);
		}
	}
?>