#!/usr/bin/env php
<?php

$script_mode = TRUE;
require '/absolute/path/to/racktables/wwwroot/inc/init.php';
define ('MY_OBJTID', 12);
define ('MY_ATTRID', 2);
define ('SYSTEM_CID', 39);
define ('CUSTOM_CID', 10001);
$dbxlink->beginTransaction();

$result = usePreparedSelectBlade
(
	'SELECT dict_key, dict_value FROM Dictionary WHERE chapter_id = ?',
	array (CUSTOM_CID)
);
$custom = $result->fetchAll (PDO::FETCH_ASSOC);
unset ($result);

foreach ($custom as $row)
{
	usePreparedInsertBlade
	(
		'Dictionary',
		array ('chapter_id' => SYSTEM_CID, 'dict_value' => $row['dict_value'])
	);
	$new_id = lastInsertID();
	usePreparedUpdateBlade
	(
		'AttributeValue',
		array ('uint_value' => $new_id),
		array
		(
			'object_tid' => MY_OBJTID,
			'attr_id' => MY_ATTRID,
			'uint_value' => $row['dict_key'],
		)
	);
	usePreparedDeleteBlade ('Dictionary', array ('dict_key' => $row['dict_key']));
}

usePreparedUpdateBlade
(
	'AttributeMap',
	array ('chapter_id' => SYSTEM_CID),
	array
	(
		'objtype_id' => MY_OBJTID,
		'attr_id' => MY_ATTRID,
		'chapter_id' => CUSTOM_CID,
	)
);
usePreparedDeleteBlade ('Chapter', array ('id' => CUSTOM_CID));

$dbxlink->commit();