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 = '';

        }