chamilo /
chamilo-lms
| @@ 3829-3837 (lines=9) @@ | ||
| 3826 | $row2 = Database :: fetch_array($res_sel2); |
|
| 3827 | $previous_previous = $row2['previous_item_id']; |
|
| 3828 | // Update previous_previous item (switch "next" with current). |
|
| 3829 | if ($previous_previous != 0) { |
|
| 3830 | $sql_upd2 = "UPDATE $tbl_lp_item SET |
|
| 3831 | next_item_id = $id |
|
| 3832 | WHERE c_id = ".$course_id." AND id = $previous_previous"; |
|
| 3833 | if ($this->debug > 2) { |
|
| 3834 | error_log($sql_upd2, 0); |
|
| 3835 | } |
|
| 3836 | Database::query($sql_upd2); |
|
| 3837 | } |
|
| 3838 | // Update previous item (switch with current). |
|
| 3839 | if ($previous != 0) { |
|
| 3840 | $sql_upd2 = "UPDATE $tbl_lp_item SET |
|
| @@ 3839-3849 (lines=11) @@ | ||
| 3836 | Database::query($sql_upd2); |
|
| 3837 | } |
|
| 3838 | // Update previous item (switch with current). |
|
| 3839 | if ($previous != 0) { |
|
| 3840 | $sql_upd2 = "UPDATE $tbl_lp_item SET |
|
| 3841 | next_item_id = $next, |
|
| 3842 | previous_item_id = $id, |
|
| 3843 | display_order = display_order +1 |
|
| 3844 | WHERE c_id = ".$course_id." AND id = $previous"; |
|
| 3845 | if ($this->debug > 2) { |
|
| 3846 | error_log($sql_upd2, 0); |
|
| 3847 | } |
|
| 3848 | Database::query($sql_upd2); |
|
| 3849 | } |
|
| 3850 | ||
| 3851 | // Update current item (switch with previous). |
|
| 3852 | if ($id != 0) { |
|
| @@ 3852-3862 (lines=11) @@ | ||
| 3849 | } |
|
| 3850 | ||
| 3851 | // Update current item (switch with previous). |
|
| 3852 | if ($id != 0) { |
|
| 3853 | $sql_upd2 = "UPDATE $tbl_lp_item SET |
|
| 3854 | next_item_id = $previous, |
|
| 3855 | previous_item_id = $previous_previous, |
|
| 3856 | display_order = display_order-1 |
|
| 3857 | WHERE c_id = ".$course_id." AND id = $id"; |
|
| 3858 | if ($this->debug > 2) { |
|
| 3859 | error_log($sql_upd2, 0); |
|
| 3860 | } |
|
| 3861 | Database::query($sql_upd2); |
|
| 3862 | } |
|
| 3863 | // Update next item (new previous item). |
|
| 3864 | if ($next != 0) { |
|
| 3865 | $sql_upd2 = "UPDATE $tbl_lp_item SET previous_item_id = $previous |
|
| @@ 3864-3871 (lines=8) @@ | ||
| 3861 | Database::query($sql_upd2); |
|
| 3862 | } |
|
| 3863 | // Update next item (new previous item). |
|
| 3864 | if ($next != 0) { |
|
| 3865 | $sql_upd2 = "UPDATE $tbl_lp_item SET previous_item_id = $previous |
|
| 3866 | WHERE c_id = ".$course_id." AND id = $next"; |
|
| 3867 | if ($this->debug > 2) { |
|
| 3868 | error_log($sql_upd2, 0); |
|
| 3869 | } |
|
| 3870 | Database::query($sql_upd2); |
|
| 3871 | } |
|
| 3872 | $display = $display -1; |
|
| 3873 | } |
|
| 3874 | break; |
|
