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;

    }

    /**

 * Returns a list of all the languages that are made available by the admin.

 * @return array

 */

function api_get_languages_to_array() {

    $tbl_language = Database::get_main_table(TABLE_MAIN_LANGUAGE);

    $sql = "SELECT * FROM $tbl_language WHERE available='1' ORDER BY original_name ASC";

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

    $languages = array();

    while ($row = Database::fetch_array($result)) {

        $languages[$row['dokeos_folder']] = $row['original_name'];

    }

    return $languages;

}

/**

 * Returns the id (the database id) of a language

* The function that retrieves all the possible settings for a certain config setting

* @author Patrick Cool <[email protected]>, Ghent University

*/

function api_get_settings_options($var) {

    $table_settings_options = Database :: get_main_table(TABLE_MAIN_SETTINGS_OPTIONS);

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

    $sql = "SELECT * FROM $table_settings_options

            WHERE variable = '$var'

            ORDER BY id";

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

    $settings_options_array = array();

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

        $settings_options_array[] = $row;

    }

    return $settings_options_array;

}

/**

 * @param array $params

    /**

     * @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