chamilo / chamilo-lms

                $sql = "SELECT thematic_id FROM $table_tool

                        WHERE c_id = $course_id AND id = $ref";

                $rs_thematic  = Database::query($sql);

                if (Database::num_rows($rs_thematic)) {

                    $row_thematic = Database::fetch_array($rs_thematic);

                    $thematic_id = $row_thematic['thematic_id'];

                    $sql = "SELECT session.id, session.name, user.username

                            FROM $tbl_thematic t, $table_session session, $table_user user

                            WHERE

                              t.c_id = $course_id AND

                              t.session_id = session.id AND

                              session.id_coach = user.user_id AND

                              t.id = $thematic_id";

                    $recorset = Database::query($sql);

                }

            } else {

                $sql = "SELECT session.id, session.name, user.username

                          FROM $table_tool tool, $table_session session, $table_user user

        if ($id != 0 && is_array($extra_info)) {

            $item_title = stripslashes($extra_info['title']);

        } elseif (is_numeric($extra_info)) {

            $sql = "SELECT thread_title as title FROM $tbl_forum

                    WHERE c_id = $course_id AND thread_id = ".$extra_info;

            $result = Database::query($sql);

            $row = Database::fetch_array($result);

            $item_title = $row['title'];

            $item_description = '';

        } else {

            $item_title = '';

            $item_description = '';

        }

        if ($id != 0 && is_array($extra_info)) {

            $item_title = stripslashes($extra_info['title']);

            $item_description = stripslashes($extra_info['description']);

        } elseif (is_numeric($extra_info)) {

            $extra_info = intval($extra_info);

            $sql = "SELECT title, description

                    FROM $tbl_publication

                    WHERE c_id = $course_id AND id = ".$extra_info;

            $result = Database::query($sql);

            $row = Database::fetch_array($result);

            $item_title = $row['title'];

        } else {

            $item_title = get_lang('Student_publication');

        }