chamilo / chamilo-lms

 * @return array    An array with the current isocodes

 *

 * */

function api_get_platform_isocodes()

{

    $iso_code = array();

    $sql = "SELECT isocode 

            FROM ".Database::get_main_table(TABLE_MAIN_LANGUAGE)." 

            ORDER BY isocode ";

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

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

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

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

        }

    }

    return $iso_code;

}

     *

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

    }

    /**

     * @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 boolean true if success

     * */

    public static function delete_url_rel_usergroup($userGroupId, $urlId)

    {

        $table = Database :: get_main_table(TABLE_MAIN_ACCESS_URL_REL_USERGROUP);

        $sql= "DELETE FROM $table

               WHERE usergroup_id = '".intval($userGroupId)."' AND

                     access_url_id = ".intval($urlId);

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

        return $result;

    }

    /**

     * Deletes an url and $userGroup relationship

    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);

}

     * Get the extra terms (tags) that identify this item

     * @return mixed

     */

    public function get_terms()

    {

        $lp_item = Database::get_course_table(TABLE_LP_ITEM);

        $course_id = api_get_course_int_id();

        $sql = "SELECT * FROM $lp_item

                WHERE

                    c_id = $course_id AND

                    id='" . intval($this->db_id) . "'";

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

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

        return $row['terms'];

    }

    /**

     * Returns the item's title

     * Get the document id of the directory certificate

     * @return int The document id of the directory certificate

     */

    public static function get_document_id_of_directory_certificate()

    {

        $tbl_document = Database::get_course_table(TABLE_DOCUMENT);

        $course_id = api_get_course_int_id();

        $sql = "SELECT id FROM $tbl_document 

                WHERE c_id = $course_id AND path='/certificates' ";

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

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

        return $row['id'];

    }

    /**

    * @param int announcement id

    * @return array array of group id

    **/

    public static function get_announcement_groups($announcement_id)

    {

        $tbl_announcement_group = Database :: get_main_table(TABLE_MAIN_SYSTEM_ANNOUNCEMENTS_GROUPS);

        $tbl_group = Database :: get_main_table(TABLE_USERGROUP);

        //first delete all group associations for this announcement

        $sql = "SELECT

                    g.id as group_id,

                    g.name as group_name

                FROM $tbl_group g , $tbl_announcement_group ag

                WHERE

                    announcement_id =".intval($announcement_id)." AND

                    ag.group_id = g.id";

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

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

        return $groups;

    }

	/**

 * @param int The tool id

 * @return array

 */

function api_get_tool_information_by_name($name) {

    $t_tool = Database::get_course_table(TABLE_TOOL_LIST);

    $course_id = api_get_course_int_id();

    $sql = "SELECT * FROM $t_tool

            WHERE c_id = $course_id  AND name = '".Database::escape_string($name)."' ";

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

    return Database::fetch_array($rs, 'ASSOC');

}

/**

 * Function used to protect a "global" admin script.