chamilo /
chamilo-lms
| @@ 1592-1601 (lines=10) @@ | ||
| 1589 | $sql = "SELECT value FROM $table |
|
| 1590 | WHERE c_id = {$course_info['real_id']} AND variable = '$setting_name'"; |
|
| 1591 | $res = Database::query($sql); |
|
| 1592 | if (Database::num_rows($res) > 0) { |
|
| 1593 | $row = Database::fetch_array($res); |
|
| 1594 | if ($setting_name === 'email_alert_manager_on_new_quiz') { |
|
| 1595 | if (!is_null($row['value'])) { |
|
| 1596 | $result = explode(',', $row['value']); |
|
| 1597 | $row['value'] = $result; |
|
| 1598 | } |
|
| 1599 | } |
|
| 1600 | return $row['value']; |
|
| 1601 | } |
|
| 1602 | } |
|
| 1603 | return -1; |
|
| 1604 | } |
|
| @@ 855-862 (lines=8) @@ | ||
| 852 | $rs = Database::query($sql); |
|
| 853 | $data = array(); |
|
| 854 | $parents = array(); |
|
| 855 | if (Database::num_rows($rs) > 0) { |
|
| 856 | while ($row = Database::fetch_array($rs, 'ASSOC')) { |
|
| 857 | if ($message_id == $row['parent_id'] || in_array($row['parent_id'], $parents)) { |
|
| 858 | $parents[] = $row['id']; |
|
| 859 | $data[] = $row; |
|
| 860 | } |
|
| 861 | } |
|
| 862 | } |
|
| 863 | ||
| 864 | return $data; |
|
| 865 | } |
|
| @@ 3121-3129 (lines=9) @@ | ||
| 3118 | $courses = array(); |
|
| 3119 | ||
| 3120 | $result = Database::query($sql); |
|
| 3121 | if (Database::num_rows($result) > 0) { |
|
| 3122 | while ($result_row = Database::fetch_array($result, 'ASSOC')) { |
|
| 3123 | $result_row['status'] = 5; |
|
| 3124 | if (!in_array($result_row['real_id'], $courses)) { |
|
| 3125 | $personal_course_list[] = $result_row; |
|
| 3126 | $courses[] = $result_row['real_id']; |
|
| 3127 | } |
|
| 3128 | } |
|
| 3129 | } |
|
| 3130 | ||
| 3131 | if (api_is_allowed_to_create_course()) { |
|
| 3132 | $sql = "SELECT DISTINCT |
|
| @@ 3155-3163 (lines=9) @@ | ||
| 3152 | ORDER BY sc.position ASC"; |
|
| 3153 | $result = Database::query($sql); |
|
| 3154 | ||
| 3155 | if (Database::num_rows($result) > 0) { |
|
| 3156 | while ($result_row = Database::fetch_array($result, 'ASSOC')) { |
|
| 3157 | $result_row['status'] = 2; |
|
| 3158 | if (!in_array($result_row['real_id'], $courses)) { |
|
| 3159 | $personal_course_list[] = $result_row; |
|
| 3160 | $courses[] = $result_row['real_id']; |
|
| 3161 | } |
|
| 3162 | } |
|
| 3163 | } |
|
| 3164 | } |
|
| 3165 | ||
| 3166 | if (api_is_drh()) { |
|
