chamilo /
chamilo-lms
| @@ 3782-3790 (lines=9) @@ | ||
| 3779 | $row2 = Database::fetch_array($res_sel2); |
|
| 3780 | $previous_previous = $row2['previous_item_id']; |
|
| 3781 | // Update previous_previous item (switch "next" with current). |
|
| 3782 | if ($previous_previous != 0) { |
|
| 3783 | $sql_upd2 = "UPDATE $tbl_lp_item SET |
|
| 3784 | next_item_id = $id |
|
| 3785 | WHERE c_id = ".$course_id." AND id = $previous_previous"; |
|
| 3786 | if ($this->debug > 2) { |
|
| 3787 | error_log($sql_upd2, 0); |
|
| 3788 | } |
|
| 3789 | Database::query($sql_upd2); |
|
| 3790 | } |
|
| 3791 | // Update previous item (switch with current). |
|
| 3792 | if ($previous != 0) { |
|
| 3793 | $sql_upd2 = "UPDATE $tbl_lp_item SET |
|
| @@ 3792-3802 (lines=11) @@ | ||
| 3789 | Database::query($sql_upd2); |
|
| 3790 | } |
|
| 3791 | // Update previous item (switch with current). |
|
| 3792 | if ($previous != 0) { |
|
| 3793 | $sql_upd2 = "UPDATE $tbl_lp_item SET |
|
| 3794 | next_item_id = $next, |
|
| 3795 | previous_item_id = $id, |
|
| 3796 | display_order = display_order +1 |
|
| 3797 | WHERE c_id = ".$course_id." AND id = $previous"; |
|
| 3798 | if ($this->debug > 2) { |
|
| 3799 | error_log($sql_upd2, 0); |
|
| 3800 | } |
|
| 3801 | Database::query($sql_upd2); |
|
| 3802 | } |
|
| 3803 | ||
| 3804 | // Update current item (switch with previous). |
|
| 3805 | if ($id != 0) { |
|
| @@ 3805-3815 (lines=11) @@ | ||
| 3802 | } |
|
| 3803 | ||
| 3804 | // Update current item (switch with previous). |
|
| 3805 | if ($id != 0) { |
|
| 3806 | $sql_upd2 = "UPDATE $tbl_lp_item SET |
|
| 3807 | next_item_id = $previous, |
|
| 3808 | previous_item_id = $previous_previous, |
|
| 3809 | display_order = display_order-1 |
|
| 3810 | WHERE c_id = ".$course_id." AND id = $id"; |
|
| 3811 | if ($this->debug > 2) { |
|
| 3812 | error_log($sql_upd2, 0); |
|
| 3813 | } |
|
| 3814 | Database::query($sql_upd2); |
|
| 3815 | } |
|
| 3816 | // Update next item (new previous item). |
|
| 3817 | if ($next != 0) { |
|
| 3818 | $sql_upd2 = "UPDATE $tbl_lp_item SET previous_item_id = $previous |
|
| @@ 3817-3824 (lines=8) @@ | ||
| 3814 | Database::query($sql_upd2); |
|
| 3815 | } |
|
| 3816 | // Update next item (new previous item). |
|
| 3817 | if ($next != 0) { |
|
| 3818 | $sql_upd2 = "UPDATE $tbl_lp_item SET previous_item_id = $previous |
|
| 3819 | WHERE c_id = ".$course_id." AND id = $next"; |
|
| 3820 | if ($this->debug > 2) { |
|
| 3821 | error_log($sql_upd2, 0); |
|
| 3822 | } |
|
| 3823 | Database::query($sql_upd2); |
|
| 3824 | } |
|
| 3825 | $display = $display - 1; |
|
| 3826 | } |
|
| 3827 | break; |
|
