chamilo / chamilo-lms

     *

     * @return string the comment

     */

    public static function get_comments($exe_id, $question_id)

    {

        $table_track_attempt = Database::get_main_table(TABLE_STATISTIC_TRACK_E_ATTEMPT);

        $sql = "SELECT teacher_comment FROM ".$table_track_attempt."

                WHERE

                    exe_id='".Database::escape_string($exe_id)."' AND

                    question_id = '".Database::escape_string($question_id)."'

                ORDER by question_id";

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

        $comm = Database::result($sqlres, 0, "teacher_comment");

        return $comm;

    }

    /**

     * @param int $exe_id

     * @param    string  Children language path

     * @return   string  Parent language path or null

     */

    public static function get_parent_language_path($language_path)

    {

        $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);

        $sql = "SELECT dokeos_folder

                FROM " . $tbl_admin_languages . "

                WHERE id = (

                    SELECT parent_id FROM " . $tbl_admin_languages . "

                    WHERE dokeos_folder = '" . Database::escape_string($language_path) . "'

                )

                ";

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

        if (Database::num_rows($result) == 0) {

            return null;

        }

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

        return $row['dokeos_folder'];

    }

    /**

     * Get language matching isocode