chamilo / chamilo-lms

     * @param int $glossary_id

     * @return string The glossary description

     */

    public static function get_glossary_term_by_glossary_id ($glossary_id)

    {

        $glossary_table  = Database::get_course_table(TABLE_GLOSSARY);

        $course_id = api_get_course_int_id();

        $sql = "SELECT description FROM $glossary_table

                WHERE c_id = $course_id  AND glossary_id =".intval($glossary_id);

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

        if (Database::num_rows($rs) > 0) {

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

            return $row['description'];

        } else {

            return '';

        }

    }

    /**

     * Get glossary term by glossary id

     * @param int $relation_type

     * @return int parent_group_id or false

     * */

    public static function get_parent_group($group_id, $relation_type = 1)

    {

        $table = Database :: get_main_table(TABLE_MAIN_GROUP_REL_GROUP);

        $group_id = intval($group_id);

        $sql = "SELECT group_id FROM $table WHERE subgroup_id = $group_id";

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

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

            return 0;

        } else {

            $arr = Database::fetch_assoc($res);

            return $arr['group_id'];

        }

    }

    /**

     * Get the subgroups ID from a group.

	 * @param int $language language id

	 * @return array all the info of a Term and condition

	 */

	public static function get_last_condition_version($language)

    {

		$legal_conditions_table = Database::get_main_table(TABLE_MAIN_LEGAL);

		$language= Database::escape_string($language);

		$sql = "SELECT version FROM $legal_conditions_table

		        WHERE language_id = '".$language."'

		        ORDER BY legal_id DESC LIMIT 1 ";

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

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

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

			return $row['version'];

		} else {

			return 0;

		}

	}

	/**

	 * Gets the data of a Term and condition by language

	 * 

	 * @param string Package id

	 */

	public static function findByPackageId($package_id) {

		$table = Database::get_main_table(ChamiloPens::TABLE_NAME);

		$sql_query = "SELECT * FROM $table WHERE package_id = '".$package_id."';";

		$results = Database::query($sql_query);

		$number = Database::num_rows($results);

		if($number == 1) {

			$obj = Database::fetch_assoc($results);

			return new ChamiloPens($obj);

		} else {

			return null;

		}

	}

	/**

	 * Returns an array of all the objects of the DB

     * Get platform language ID

     * @return     int     The platform language ID

     */

    public static function get_platform_language_id()

    {

        $name = api_get_setting('platformLanguage');

        $tbl_admin_languages = Database :: get_main_table(TABLE_MAIN_LANGUAGE);

        $sql = "SELECT id FROM " . $tbl_admin_languages . " WHERE english_name ='$name'";

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

        if (Database::num_rows($res) < 1) {

            return false;

        }

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

        return $row['id'];

    }

    /**

     * Get parent language path (or null if no parent)

     * @param   string  $isocode The language isocode (en, es, fr, zh-TW, etc)

     * @return  mixed  English name of the matching language, or false if no active language could be found

     */

    public static function getLanguageFromIsocode($isocode)

    {

        $isocode = Database::escape_string($isocode);

        $adminLanguagesTable = Database :: get_main_table(TABLE_MAIN_LANGUAGE);

        // select language - if case several languages match, get the last (more recent) one

        $sql = "SELECT english_name

                FROM " . $adminLanguagesTable . "

                WHERE

                    isocode ='$isocode' AND

                    available = 1

                ORDER BY id

                DESC LIMIT 1";

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

        if (Database::num_rows($res) < 1) {

            return false;

        }

        $row = Database::fetch_assoc($res);

        return $row['english_name'];

    }

    /**

     * Get best language in browser preferences