chamilo / chamilo-lms

     *

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

}

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

}

/**

 * Gets text direction according to the given language.

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

     * @param int $catId Category parent ID

     * @return array Array of Category objects

     */

    public function getCategories($catId)

    {

        $tblGradeCategories = Database :: get_main_table(TABLE_MAIN_GRADEBOOK_CATEGORY);

        $sql = 'SELECT * FROM '.$tblGradeCategories.'

                WHERE parent_id = '.intval($catId);

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

        $allcats = Category::create_category_objects_from_sql_result($result);

        return $allcats;

    }

    /**

     * Gets the type for the current object