chamilo / chamilo-lms

 * @return array    An array with the current isocodes

 *

 * */

function api_get_platform_isocodes()

{

    $iso_code = array();

    $sql_result = Database::query("SELECT isocode FROM ".Database::get_main_table(TABLE_MAIN_LANGUAGE)." ORDER BY isocode ");

    if (Database::num_rows($sql_result)) {

        while ($row = Database::fetch_array($sql_result)) {;

            $iso_code[] = trim($row['isocode']);

        }

    }

    return $iso_code;

}

/**

 * Gets text direction according to the given language.

     *

     * @return int

     */

    public static function url_id_exist($url)

    {

        if (empty($url)) {

            return false;

        }

        $table = Database :: get_main_table(TABLE_MAIN_ACCESS_URL);

        $sql = "SELECT id FROM $table WHERE id = ".intval($url)."";

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

        $num = Database::num_rows($res);

        return $num;

    }

    /**

     * This function get the quantity of URLs

     * @param int $urlId

     * @return boolean true if success

     * */

    public static function relationUrlUsergroupExist($userGroupId, $urlId)

    {

        $table = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USERGROUP);

        $sql= "SELECT usergroup_id FROM $table

               WHERE access_url_id = ".intval($urlId)." AND

                     usergroup_id = ".intval($userGroupId);

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

        $num = Database::num_rows($result);

        return $num;

    }

    /**

    * Checks the relationship between an URL and a Session (return the num_rows)

     * @param int $urlId

     * @return boolean true if success

     * */

    public static function relationUrlCourseCategoryExist($categoryCourseId, $urlId)

    {

        $table = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE_CATEGORY);

        $sql= "SELECT course_category_id FROM $table

               WHERE access_url_id = ".intval($urlId)." AND

                     course_category_id = ".intval($categoryCourseId);

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

        $num = Database::num_rows($result);

        return $num;

    }

    /**

     * @param int $userGroupId

    return json_encode($results);

}

function storage_get_all_users() {

    $sql = "select user_id, username, firstname, lastname

        from ".Database::get_main_table(TABLE_MAIN_USER)."

        order by user_id asc";

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

    $results = array();

    while ($row = Database::fetch_assoc($res)) {

        $results[] = $row;

    }

    return json_encode($results);

}