chamilo /
chamilo-lms
| @@ 3017-3025 (lines=9) @@ | ||
| 3014 | $courses = array(); |
|
| 3015 | ||
| 3016 | $result = Database::query($sql); |
|
| 3017 | if (Database::num_rows($result) > 0) { |
|
| 3018 | while ($result_row = Database::fetch_array($result, 'ASSOC')) { |
|
| 3019 | $result_row['status'] = 5; |
|
| 3020 | if (!in_array($result_row['real_id'], $courses)) { |
|
| 3021 | $personal_course_list[] = $result_row; |
|
| 3022 | $courses[] = $result_row['real_id']; |
|
| 3023 | } |
|
| 3024 | } |
|
| 3025 | } |
|
| 3026 | ||
| 3027 | if (api_is_allowed_to_create_course()) { |
|
| 3028 | $sql = "SELECT DISTINCT |
|
| @@ 3050-3058 (lines=9) @@ | ||
| 3047 | ORDER BY sc.position ASC"; |
|
| 3048 | $result = Database::query($sql); |
|
| 3049 | ||
| 3050 | if (Database::num_rows($result) > 0) { |
|
| 3051 | while ($result_row = Database::fetch_array($result, 'ASSOC')) { |
|
| 3052 | $result_row['status'] = 2; |
|
| 3053 | if (!in_array($result_row['real_id'], $courses)) { |
|
| 3054 | $personal_course_list[] = $result_row; |
|
| 3055 | $courses[] = $result_row['real_id']; |
|
| 3056 | } |
|
| 3057 | } |
|
| 3058 | } |
|
| 3059 | } |
|
| 3060 | ||
| 3061 | if (api_is_drh()) { |
|
| @@ 794-801 (lines=8) @@ | ||
| 791 | $rs = Database::query($sql); |
|
| 792 | $data = array(); |
|
| 793 | $parents = array(); |
|
| 794 | if (Database::num_rows($rs) > 0) { |
|
| 795 | while ($row = Database::fetch_array($rs, 'ASSOC')) { |
|
| 796 | if ($message_id == $row['parent_id'] || in_array($row['parent_id'], $parents)) { |
|
| 797 | $parents[] = $row['id']; |
|
| 798 | $data[] = $row; |
|
| 799 | } |
|
| 800 | } |
|
| 801 | } |
|
| 802 | ||
| 803 | return $data; |
|
| 804 | } |
|
