@@ 3949-3963 (lines=15) @@ | ||
3946 | $num = Database :: num_rows($res); |
|
3947 | // First check the order is correct, globally (might be wrong because |
|
3948 | // of versions < 1.8.4) |
|
3949 | if ($num > 0) { |
|
3950 | $i = 1; |
|
3951 | while ($row = Database :: fetch_array($res)) { |
|
3952 | if ($row['display_order'] != $i) { // If we find a gap in the order, we need to fix it. |
|
3953 | $need_fix = true; |
|
3954 | $sql_u = "UPDATE $lp_table SET display_order = $i |
|
3955 | WHERE c_id = ".$course_id." AND id = " . $row['id']; |
|
3956 | Database::query($sql_u); |
|
3957 | } |
|
3958 | $row['display_order'] = $i; |
|
3959 | $lps[$row['id']] = $row; |
|
3960 | $lp_order[$i] = $row['id']; |
|
3961 | $i++; |
|
3962 | } |
|
3963 | } |
|
3964 | if ($num > 1) { // If there's only one element, no need to sort. |
|
3965 | $order = $lps[$lp_id]['display_order']; |
|
3966 | if ($order > 1) { // If it's the first element, no need to move up. |
|
@@ 3998-4013 (lines=16) @@ | ||
3995 | $max = 0; |
|
3996 | // First check the order is correct, globally (might be wrong because |
|
3997 | // of versions < 1.8.4). |
|
3998 | if ($num > 0) { |
|
3999 | $i = 1; |
|
4000 | while ($row = Database :: fetch_array($res)) { |
|
4001 | $max = $i; |
|
4002 | if ($row['display_order'] != $i) { // If we find a gap in the order, we need to fix it. |
|
4003 | $need_fix = true; |
|
4004 | $sql_u = "UPDATE $lp_table SET display_order = $i |
|
4005 | WHERE c_id = ".$course_id." AND id = " . $row['id']; |
|
4006 | Database::query($sql_u); |
|
4007 | } |
|
4008 | $row['display_order'] = $i; |
|
4009 | $lps[$row['id']] = $row; |
|
4010 | $lp_order[$i] = $row['id']; |
|
4011 | $i++; |
|
4012 | } |
|
4013 | } |
|
4014 | if ($num > 1) { // If there's only one element, no need to sort. |
|
4015 | $order = $lps[$lp_id]['display_order']; |
|
4016 | if ($order < $max) { // If it's the first element, no need to move up. |