chamilo /
chamilo-lms
| @@ 3758-3766 (lines=9) @@ | ||
| 3755 | $row2 = Database::fetch_array($res_sel2); |
|
| 3756 | $previous_previous = $row2['previous_item_id']; |
|
| 3757 | // Update previous_previous item (switch "next" with current). |
|
| 3758 | if ($previous_previous != 0) { |
|
| 3759 | $sql_upd2 = "UPDATE $tbl_lp_item SET |
|
| 3760 | next_item_id = $id |
|
| 3761 | WHERE c_id = ".$course_id." AND id = $previous_previous"; |
|
| 3762 | if ($this->debug > 2) { |
|
| 3763 | error_log($sql_upd2, 0); |
|
| 3764 | } |
|
| 3765 | Database::query($sql_upd2); |
|
| 3766 | } |
|
| 3767 | // Update previous item (switch with current). |
|
| 3768 | if ($previous != 0) { |
|
| 3769 | $sql_upd2 = "UPDATE $tbl_lp_item SET |
|
| @@ 3768-3778 (lines=11) @@ | ||
| 3765 | Database::query($sql_upd2); |
|
| 3766 | } |
|
| 3767 | // Update previous item (switch with current). |
|
| 3768 | if ($previous != 0) { |
|
| 3769 | $sql_upd2 = "UPDATE $tbl_lp_item SET |
|
| 3770 | next_item_id = $next, |
|
| 3771 | previous_item_id = $id, |
|
| 3772 | display_order = display_order +1 |
|
| 3773 | WHERE c_id = ".$course_id." AND id = $previous"; |
|
| 3774 | if ($this->debug > 2) { |
|
| 3775 | error_log($sql_upd2, 0); |
|
| 3776 | } |
|
| 3777 | Database::query($sql_upd2); |
|
| 3778 | } |
|
| 3779 | ||
| 3780 | // Update current item (switch with previous). |
|
| 3781 | if ($id != 0) { |
|
| @@ 3781-3791 (lines=11) @@ | ||
| 3778 | } |
|
| 3779 | ||
| 3780 | // Update current item (switch with previous). |
|
| 3781 | if ($id != 0) { |
|
| 3782 | $sql_upd2 = "UPDATE $tbl_lp_item SET |
|
| 3783 | next_item_id = $previous, |
|
| 3784 | previous_item_id = $previous_previous, |
|
| 3785 | display_order = display_order-1 |
|
| 3786 | WHERE c_id = ".$course_id." AND id = $id"; |
|
| 3787 | if ($this->debug > 2) { |
|
| 3788 | error_log($sql_upd2, 0); |
|
| 3789 | } |
|
| 3790 | Database::query($sql_upd2); |
|
| 3791 | } |
|
| 3792 | // Update next item (new previous item). |
|
| 3793 | if ($next != 0) { |
|
| 3794 | $sql_upd2 = "UPDATE $tbl_lp_item SET previous_item_id = $previous |
|
| @@ 3793-3800 (lines=8) @@ | ||
| 3790 | Database::query($sql_upd2); |
|
| 3791 | } |
|
| 3792 | // Update next item (new previous item). |
|
| 3793 | if ($next != 0) { |
|
| 3794 | $sql_upd2 = "UPDATE $tbl_lp_item SET previous_item_id = $previous |
|
| 3795 | WHERE c_id = ".$course_id." AND id = $next"; |
|
| 3796 | if ($this->debug > 2) { |
|
| 3797 | error_log($sql_upd2, 0); |
|
| 3798 | } |
|
| 3799 | Database::query($sql_upd2); |
|
| 3800 | } |
|
| 3801 | $display = $display - 1; |
|
| 3802 | } |
|
| 3803 | break; |
|
