chamilo / chamilo-lms

     *

     * @return array All information about sub-language

     */

    public static function getAllLanguages($onlyActive = false)

    {

        $table = Database :: get_main_table(TABLE_MAIN_LANGUAGE);

        $sql = 'SELECT * FROM ' . $table;

        if ($onlyActive) {

            $sql .= ' WHERE available = 1';

        }

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

        $all_languages = [];

        while ($row = Database::fetch_array($rs, 'ASSOC')) {

            $all_languages[$row['dokeos_folder']] = $row;

        }

        return $all_languages;

    }

    /**

    /**

     * @return array

     */

    public static function getOfficialCodeGrouped()

    {

        $user = Database::get_main_table(TABLE_MAIN_USER);

        $sql = "SELECT DISTINCT official_code

                FROM $user

                GROUP BY official_code";

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

        $values = Database::store_result($result, 'ASSOC');

        $result = array();

        foreach ($values as $value) {

            $result[$value['official_code']] = $value['official_code'];

        }

        return $result;

    }

    /**

     * @param string $officialCode