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();