for ($j = 0; $j < db_numrows($resc); $j++) {
$resolution_id = db_result($resc, $j, 'id');
$resolution_name = addslashes(db_result($resc, $j, 'resolution_name'));
if (strlen($resolution_name) < 1) {
$resolution_name = '[empty]';
}
$efe = new ArtifactExtraFieldElement($aef);
// $efe->create($resolution_name);
if (!$efe->create($resolution_name)) {
echo 'Group: ' . $group_id . ' Could not create resolution element: ' . $resolution_name . ' ' . $efe->getErrorMessage();
db_rollback();
exit(5);
}
//echo 'Artifact Group: Group: '.$group_id;
//print_r($efe->data_array);
$efe_id = $efe->getID();
if (!$efe_id) {
echo "\nDid Not Get efe_id";
db_rollback();
exit(13);
}
$res2 = db_query("INSERT INTO artifact_extra_field_data (artifact_id,field_data,extra_field_id)\n\t\t\t\tSELECT artifact_id,{$efe_id},{$resolutionbox_id} FROM artifact \n\t\t\t\tWHERE resolution_id='{$resolution_id}' AND group_artifact_id='{$gaid}'");
if (!$res2) {
echo "Could Not Insert AEFD for resolution " . db_error();
db_rollback();
exit(14);
}
$res3 = db_query("UPDATE artifact_history SET old_value='{$resolution_name}',field_name='Resolution'\n\t\t\t\tWHERE old_value='{$resolution_id}' AND field_name='resolution_id' AND artifact_id IN \n\t\t\t\t(SELECT artifact_id FROM artifact WHERE group_artifact_id='{$gaid}')");
if (!$res3) {
echo "Could Not update history resolution " . db_error();
db_rollback();
