chamilo /
chamilo-lms
| @@ 3240-3250 (lines=11) @@ | ||
| 3237 | $result = Database::query($sql); |
|
| 3238 | $num_rows = Database::num_rows($result); |
|
| 3239 | $courses = array(); |
|
| 3240 | if ($num_rows > 0) { |
|
| 3241 | if ($getCount) { |
|
| 3242 | $count = Database::fetch_array($result); |
|
| 3243 | ||
| 3244 | return intval($count[0]); |
|
| 3245 | } |
|
| 3246 | ||
| 3247 | while ($row = Database::fetch_array($result,'ASSOC')) { |
|
| 3248 | $courses[$row['real_id']] = $row; |
|
| 3249 | } |
|
| 3250 | } |
|
| 3251 | ||
| 3252 | return $courses; |
|
| 3253 | } |
|
| @@ 2732-2740 (lines=9) @@ | ||
| 2729 | ||
| 2730 | $result = Database::query($sql); |
|
| 2731 | ||
| 2732 | if (Database::num_rows($result) > 0) { |
|
| 2733 | while ($result_row = Database::fetch_array($result, 'ASSOC')) { |
|
| 2734 | $result_row['status'] = 5; |
|
| 2735 | if (!in_array($result_row['real_id'], $courses)) { |
|
| 2736 | $personal_course_list[] = $result_row; |
|
| 2737 | $courses[] = $result_row['real_id']; |
|
| 2738 | } |
|
| 2739 | } |
|
| 2740 | } |
|
| 2741 | ||
| 2742 | if (api_is_allowed_to_create_course()) { |
|
| 2743 | $sql = "SELECT DISTINCT |
|
| @@ 2763-2771 (lines=9) @@ | ||
| 2760 | ORDER BY sc.position ASC"; |
|
| 2761 | $result = Database::query($sql); |
|
| 2762 | ||
| 2763 | if (Database::num_rows($result) > 0) { |
|
| 2764 | while ($result_row = Database::fetch_array($result, 'ASSOC')) { |
|
| 2765 | $result_row['status'] = 2; |
|
| 2766 | if (!in_array($result_row['real_id'], $courses)) { |
|
| 2767 | $personal_course_list[] = $result_row; |
|
| 2768 | $courses[] = $result_row['real_id']; |
|
| 2769 | } |
|
| 2770 | } |
|
| 2771 | } |
|
| 2772 | } |
|
| 2773 | ||
| 2774 | if (api_is_drh()) { |
|
| @@ 788-795 (lines=8) @@ | ||
| 785 | $rs = Database::query($sql); |
|
| 786 | $data = array(); |
|
| 787 | $parents = array(); |
|
| 788 | if (Database::num_rows($rs) > 0) { |
|
| 789 | while ($row = Database::fetch_array($rs, 'ASSOC')) { |
|
| 790 | if ($message_id == $row['parent_id'] || in_array($row['parent_id'], $parents)) { |
|
| 791 | $parents[] = $row['id']; |
|
| 792 | $data[] = $row; |
|
| 793 | } |
|
| 794 | } |
|
| 795 | } |
|
| 796 | ||
| 797 | return $data; |
|
| 798 | } |
|
