chamilo /
chamilo-lms
| @@ 2013-2019 (lines=7) @@ | ||
| 2010 | if ((int) $default_certificate == (int) $default_certificate_id) { |
|
| 2011 | $tbl_category = Database :: get_main_table(TABLE_MAIN_GRADEBOOK_CATEGORY); |
|
| 2012 | $session_id = api_get_session_id(); |
|
| 2013 | if ($session_id == 0 || is_null($session_id)) { |
|
| 2014 | $sql_session = 'AND (session_id=' . intval($session_id) . ' OR isnull(session_id)) '; |
|
| 2015 | } elseif ($session_id > 0) { |
|
| 2016 | $sql_session = 'AND session_id=' . intval($session_id); |
|
| 2017 | } else { |
|
| 2018 | $sql_session = ''; |
|
| 2019 | } |
|
| 2020 | ||
| 2021 | $sql = 'UPDATE ' . $tbl_category . ' SET document_id=null |
|
| 2022 | WHERE |
|
| @@ 4669-4675 (lines=7) @@ | ||
| 4666 | ||
| 4667 | $session_id = api_get_session_id(); |
|
| 4668 | $user_id = intval($user_id); |
|
| 4669 | if ($session_id == 0 || is_null($session_id)) { |
|
| 4670 | $sql_session = 'AND (session_id='.intval($session_id).' OR isnull(session_id)) '; |
|
| 4671 | } elseif ($session_id > 0) { |
|
| 4672 | $sql_session = 'AND session_id='.intval($session_id); |
|
| 4673 | } else { |
|
| 4674 | $sql_session = ''; |
|
| 4675 | } |
|
| 4676 | $sql = "SELECT tc.path_certificate,tc.cat_id,tgc.course_code,tgc.name |
|
| 4677 | FROM $table_certificate tc, $table_gradebook_category tgc |
|
| 4678 | WHERE tgc.id = tc.cat_id AND tc.user_id = $user_id |
|
