chamilo /
chamilo-lms
| @@ 795-802 (lines=8) @@ | ||
| 792 | $rs = Database::query($sql); |
|
| 793 | $data = array(); |
|
| 794 | $parents = array(); |
|
| 795 | if (Database::num_rows($rs) > 0) { |
|
| 796 | while ($row = Database::fetch_array($rs, 'ASSOC')) { |
|
| 797 | if ($message_id == $row['parent_id'] || in_array($row['parent_id'], $parents)) { |
|
| 798 | $parents[] = $row['id']; |
|
| 799 | $data[] = $row; |
|
| 800 | } |
|
| 801 | } |
|
| 802 | } |
|
| 803 | ||
| 804 | return $data; |
|
| 805 | } |
|
| @@ 2746-2754 (lines=9) @@ | ||
| 2743 | ||
| 2744 | $result = Database::query($sql); |
|
| 2745 | ||
| 2746 | if (Database::num_rows($result) > 0) { |
|
| 2747 | while ($result_row = Database::fetch_array($result, 'ASSOC')) { |
|
| 2748 | $result_row['status'] = 5; |
|
| 2749 | if (!in_array($result_row['real_id'], $courses)) { |
|
| 2750 | $personal_course_list[] = $result_row; |
|
| 2751 | $courses[] = $result_row['real_id']; |
|
| 2752 | } |
|
| 2753 | } |
|
| 2754 | } |
|
| 2755 | ||
| 2756 | if (api_is_allowed_to_create_course()) { |
|
| 2757 | $sql = "SELECT DISTINCT |
|
| @@ 2779-2787 (lines=9) @@ | ||
| 2776 | ORDER BY sc.position ASC"; |
|
| 2777 | $result = Database::query($sql); |
|
| 2778 | ||
| 2779 | if (Database::num_rows($result) > 0) { |
|
| 2780 | while ($result_row = Database::fetch_array($result, 'ASSOC')) { |
|
| 2781 | $result_row['status'] = 2; |
|
| 2782 | if (!in_array($result_row['real_id'], $courses)) { |
|
| 2783 | $personal_course_list[] = $result_row; |
|
| 2784 | $courses[] = $result_row['real_id']; |
|
| 2785 | } |
|
| 2786 | } |
|
| 2787 | } |
|
| 2788 | } |
|
| 2789 | ||
| 2790 | if (api_is_drh()) { |
|
| @@ 3251-3261 (lines=11) @@ | ||
| 3248 | $result = Database::query($sql); |
|
| 3249 | $num_rows = Database::num_rows($result); |
|
| 3250 | $courses = array(); |
|
| 3251 | if ($num_rows > 0) { |
|
| 3252 | if ($getCount) { |
|
| 3253 | $count = Database::fetch_array($result); |
|
| 3254 | ||
| 3255 | return intval($count[0]); |
|
| 3256 | } |
|
| 3257 | ||
| 3258 | while ($row = Database::fetch_array($result,'ASSOC')) { |
|
| 3259 | $courses[$row['real_id']] = $row; |
|
| 3260 | } |
|
| 3261 | } |
|
| 3262 | ||
| 3263 | return $courses; |
|
| 3264 | } |
|
