chamilo / chamilo-lms

        $sql = "SELECT * FROM $lp_item 

                WHERE c_id = ".$course_id." AND parent_item_id = $id";

        $res = Database::query($sql);

        while ($row = Database::fetch_array($res)) {

            $num += $this->delete_children_items($row['id']);

            $sql = "DELETE FROM $lp_item 

                    WHERE c_id = ".$course_id." AND id = ".$row['id'];

            Database::query($sql);

            $num++;

        }

        return $num;

    }

        // of versions < 1.8.4).

        if ($num > 0) {

            $i = 1;

            while ($row = Database::fetch_array($res)) {

                if ($row['display_order'] != $i) {

                    // If we find a gap in the order, we need to fix it.

                    $sql = "UPDATE $lp_table SET display_order = $i

                            WHERE c_id = ".$course_id." AND id = ".$row['id'];

                    Database::query($sql);

                }

                $i++;

            }

        }

        return true;

    }