chamilo /
chamilo-lms
| @@ 126-133 (lines=8) @@ | ||
| 123 | // this is an identified user => show the general announcements AND his personal announcements |
|
| 124 | if ($user_id) { |
|
| 125 | ||
| 126 | if ((api_get_course_setting('allow_user_edit_announcement') && !api_is_anonymous())) { |
|
| 127 | $cond_user_id = " AND ( |
|
| 128 | ip.lastedit_user_id = '".api_get_user_id()."' OR |
|
| 129 | ( ip.to_user_id='".$user_id."' OR ip.to_group_id='0' OR ip.to_group_id IS NULL) |
|
| 130 | ) "; |
|
| 131 | } else { |
|
| 132 | $cond_user_id = " AND ( ip.to_user_id='".$user_id."' OR ip.to_group_id='0' OR ip.to_group_id IS NULL) "; |
|
| 133 | } |
|
| 134 | ||
| 135 | $sql = "SELECT |
|
| 136 | announcement.*, ip.visibility, ip.to_group_id, ip.insert_user_id |
|
| @@ 1780-1787 (lines=8) @@ | ||
| 1777 | // the user is not member of any group |
|
| 1778 | // this is an identified user => show the general announcements AND his personal announcements |
|
| 1779 | if ($userId) { |
|
| 1780 | if ((api_get_course_setting('allow_user_edit_announcement') && !api_is_anonymous())) { |
|
| 1781 | $cond_user_id = " AND ( |
|
| 1782 | ip.lastedit_user_id = '".$userId."' OR |
|
| 1783 | ( ip.to_user_id='".$userId."' OR ip.to_group_id='0' OR ip.to_group_id IS NULL) |
|
| 1784 | ) "; |
|
| 1785 | } else { |
|
| 1786 | $cond_user_id = " AND ( ip.to_user_id='".$userId."' OR ip.to_group_id='0' OR ip.to_group_id IS NULL) "; |
|
| 1787 | } |
|
| 1788 | $sql = "SELECT announcement.*, ip.visibility, ip.to_group_id, ip.insert_user_id |
|
| 1789 | FROM $tbl_announcement announcement |
|
| 1790 | INNER JOIN $tbl_item_property ip |
|
