chamilo / chamilo-lms

                    $row2 = Database::fetch_array($res_sel2);

                    $next_next = $row2['next_item_id'];

                    // Update previous item (switch with current).

                    if ($previous != 0) {

                        $sql_upd2 = "UPDATE $tbl_lp_item SET next_item_id = $next

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

                        Database::query($sql_upd2);

                    }

                    // Update current item (switch with previous).

                    if ($id != 0) {

                        $sql_upd2 = "UPDATE $tbl_lp_item SET

                        Database::query($sql_upd2);

                    }

                    // Update current item (switch with previous).

                    if ($id != 0) {

                        $sql_upd2 = "UPDATE $tbl_lp_item SET

                                     previous_item_id = $next, next_item_id = $next_next, display_order = display_order+1

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

                        Database::query($sql_upd2);

                    }

                    // Update next item (new previous item).

                    if ($next != 0) {

                    }

                    // Update next item (new previous item).

                    if ($next != 0) {

                        $sql_upd2 = "UPDATE $tbl_lp_item SET

                                     previous_item_id = $previous, next_item_id = $id, display_order = display_order-1

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

                        Database::query($sql_upd2);

                    }

                    // Update next_next item (switch "previous" with current).

                    if ($next_next != 0) {

                    }

                    // Update next_next item (switch "previous" with current).

                    if ($next_next != 0) {

                        $sql_upd2 = "UPDATE $tbl_lp_item SET

                                     previous_item_id = $id

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

                        Database::query($sql_upd2);

                    }

                    $display = $display + 1;

                }

                break;