chamilo /
chamilo-lms
| @@ 40-50 (lines=11) @@ | ||
| 37 | (lang='$user_selected_language' OR lang IS NULL) AND |
|
| 38 | (('$now' BETWEEN date_start AND date_end) OR date_end='0000-00-00') "; |
|
| 39 | ||
| 40 | switch ($visible) { |
|
| 41 | case self::VISIBLE_GUEST: |
|
| 42 | $sql .= " AND visible_guest = 1 "; |
|
| 43 | break; |
|
| 44 | case self::VISIBLE_STUDENT: |
|
| 45 | $sql .= " AND visible_student = 1 "; |
|
| 46 | break; |
|
| 47 | case self::VISIBLE_TEACHER: |
|
| 48 | $sql .= " AND visible_teacher = 1 "; |
|
| 49 | break; |
|
| 50 | } |
|
| 51 | ||
| 52 | if (count($groups) > 0) { |
|
| 53 | $sql .= " OR id IN ( |
|
| @@ 131-141 (lines=11) @@ | ||
| 128 | (lang = '$user_selected_language' OR lang IS NULL) AND |
|
| 129 | ( '$now' >= date_start AND '$now' <= date_end) "; |
|
| 130 | ||
| 131 | switch ($visible) { |
|
| 132 | case self::VISIBLE_GUEST: |
|
| 133 | $sql .= " AND visible_guest = 1 "; |
|
| 134 | break; |
|
| 135 | case self::VISIBLE_STUDENT: |
|
| 136 | $sql .= " AND visible_student = 1 "; |
|
| 137 | break; |
|
| 138 | case self::VISIBLE_TEACHER: |
|
| 139 | $sql .= " AND visible_teacher = 1 "; |
|
| 140 | break; |
|
| 141 | } |
|
| 142 | ||
| 143 | if (count($groups) > 0) { |
|
| 144 | $sql .= " OR id IN ( |
|
| @@ 771-781 (lines=11) @@ | ||
| 768 | (lang = '$user_selected_language' OR lang = '') AND |
|
| 769 | ('$now' >= date_start AND '$now' <= date_end) "; |
|
| 770 | ||
| 771 | switch ($visible) { |
|
| 772 | case self::VISIBLE_GUEST: |
|
| 773 | $sql .= " AND visible_guest = 1 "; |
|
| 774 | break; |
|
| 775 | case self::VISIBLE_STUDENT: |
|
| 776 | $sql .= " AND visible_student = 1 "; |
|
| 777 | break; |
|
| 778 | case self::VISIBLE_TEACHER: |
|
| 779 | $sql .= " AND visible_teacher = 1 "; |
|
| 780 | break; |
|
| 781 | } |
|
| 782 | ||
| 783 | if (isset($id) && !empty($id)) { |
|
| 784 | $id = intval($id); |
|
