chamilo / chamilo-lms

     * 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

    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;

}

/**

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

}

/**

 * @deprecated use api_trunc_str() instead.