chamilo / chamilo-lms

                        }

                    }

                    foreach ($parent_item_ids as $new_item_id => $parent_item_old_id) {

                        $parent_new_id = 0;

                        if ($parent_item_old_id != 0) {

                            $parent_new_id = $new_item_ids[$parent_item_old_id];

                        }

                        $sql = "UPDATE ".$table_item." SET parent_item_id = '".$parent_new_id."'

                                WHERE c_id = " . $this->destination_course_id." AND id = '".$new_item_id."'";

                        Database::query($sql);

                    }

                    foreach ($previous_item_ids as $new_item_id => $previous_item_old_id) {

                        $previous_new_id = 0;

                        if ($previous_item_old_id != 0) {

                                WHERE c_id = " . $this->destination_course_id." AND id = '".$new_item_id."'";

                        Database::query($sql);

                    }

                    foreach ($previous_item_ids as $new_item_id => $previous_item_old_id) {

                        $previous_new_id = 0;

                        if ($previous_item_old_id != 0) {

                            $previous_new_id = $new_item_ids[$previous_item_old_id];

                        }

                        $sql = "UPDATE ".$table_item." SET previous_item_id = '".$previous_new_id."'

                                WHERE  c_id = " . $this->destination_course_id." AND id = '".$new_item_id."'";

                        Database::query($sql);

                    }

                    foreach ($next_item_ids as $new_item_id => $next_item_old_id) {

                        $next_new_id = 0;

                        Database::query($sql);

                    }

                    foreach ($next_item_ids as $new_item_id => $next_item_old_id) {

                        $next_new_id = 0;

                        if ($next_item_old_id != 0) {

                            $next_new_id = $new_item_ids[$next_item_old_id];

                        }

                        $sql = "UPDATE ".$table_item." SET next_item_id = '".$next_new_id."'

                                WHERE c_id = " . $this->destination_course_id." AND id = '".$new_item_id."'";

                        Database::query($sql);

                    }

                    foreach ($prerequisite_ids as $new_item_id => $prerequisite_old_id) {

                        $prerequisite_new_id = 0;

                        Database::query($sql);

                    }

                    foreach ($prerequisite_ids as $new_item_id => $prerequisite_old_id) {

                        $prerequisite_new_id = 0;

                        if ($prerequisite_old_id != 0) {

                            $prerequisite_new_id = $new_item_ids[$prerequisite_old_id];

                        }

                        $sql = "UPDATE ".$table_item." SET prerequisite = '".$prerequisite_new_id."'

                                WHERE c_id = " . $this->destination_course_id." AND id = '".$new_item_id."'";

                        Database::query($sql);

                    }

                    $this->course->resources[RESOURCE_LEARNPATH][$id]->destination_id = $new_lp_id;

                }

            }