chamilo /
chamilo-lms
| @@ 786-793 (lines=8) @@ | ||
| 783 | $rs = Database::query($sql); |
|
| 784 | $data = array(); |
|
| 785 | $parents = array(); |
|
| 786 | if (Database::num_rows($rs) > 0) { |
|
| 787 | while ($row = Database::fetch_array($rs, 'ASSOC')) { |
|
| 788 | if ($message_id == $row['parent_id'] || in_array($row['parent_id'], $parents)) { |
|
| 789 | $parents[] = $row['id']; |
|
| 790 | $data[] = $row; |
|
| 791 | } |
|
| 792 | } |
|
| 793 | } |
|
| 794 | ||
| 795 | return $data; |
|
| 796 | } |
|
| @@ 1581-1590 (lines=10) @@ | ||
| 1578 | $sql = "SELECT value FROM $table |
|
| 1579 | WHERE c_id = {$course_info['real_id']} AND variable = '$setting_name'"; |
|
| 1580 | $res = Database::query($sql); |
|
| 1581 | if (Database::num_rows($res) > 0) { |
|
| 1582 | $row = Database::fetch_array($res); |
|
| 1583 | if ($setting_name === 'email_alert_manager_on_new_quiz') { |
|
| 1584 | if (!is_null($row['value'])) { |
|
| 1585 | $result = explode(',', $row['value']); |
|
| 1586 | $row['value'] = $result; |
|
| 1587 | } |
|
| 1588 | } |
|
| 1589 | return $row['value']; |
|
| 1590 | } |
|
| 1591 | } |
|
| 1592 | return -1; |
|
| 1593 | } |
|
| @@ 3105-3113 (lines=9) @@ | ||
| 3102 | $courses = array(); |
|
| 3103 | ||
| 3104 | $result = Database::query($sql); |
|
| 3105 | if (Database::num_rows($result) > 0) { |
|
| 3106 | while ($result_row = Database::fetch_array($result, 'ASSOC')) { |
|
| 3107 | $result_row['status'] = 5; |
|
| 3108 | if (!in_array($result_row['real_id'], $courses)) { |
|
| 3109 | $personal_course_list[] = $result_row; |
|
| 3110 | $courses[] = $result_row['real_id']; |
|
| 3111 | } |
|
| 3112 | } |
|
| 3113 | } |
|
| 3114 | ||
| 3115 | if (api_is_allowed_to_create_course()) { |
|
| 3116 | $sql = "SELECT DISTINCT |
|
| @@ 3139-3147 (lines=9) @@ | ||
| 3136 | ORDER BY sc.position ASC"; |
|
| 3137 | $result = Database::query($sql); |
|
| 3138 | ||
| 3139 | if (Database::num_rows($result) > 0) { |
|
| 3140 | while ($result_row = Database::fetch_array($result, 'ASSOC')) { |
|
| 3141 | $result_row['status'] = 2; |
|
| 3142 | if (!in_array($result_row['real_id'], $courses)) { |
|
| 3143 | $personal_course_list[] = $result_row; |
|
| 3144 | $courses[] = $result_row['real_id']; |
|
| 3145 | } |
|
| 3146 | } |
|
| 3147 | } |
|
| 3148 | } |
|
| 3149 | ||
| 3150 | if (api_is_drh()) { |
|
