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