chamilo / chamilo-lms

     * @param string $event_type

     * @return array|bool

     */

    public static function get_events_by_user_and_type($user_id, $event_type)

    {

        $TABLETRACK_DEFAULT = Database::get_main_table(TABLE_STATISTIC_TRACK_E_DEFAULT);

        $user_id = intval($user_id);

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

        $sql = "SELECT * FROM $TABLETRACK_DEFAULT

                WHERE default_value_type = 'user_id' AND

                      default_value = $user_id AND

                      default_event_type = '$event_type'

                ORDER BY default_date ";

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

        if ($result) {

            return Database::store_result($result, 'ASSOC');

        }

        return false;

    }

    /**

     * Save the new message for one event and for one language

     * @param    int     Link/Resource ID

     * @return   bool    false on error, true on success

     */

    public static function get_resource_from_course_gradebook($link_id)

    {

        if (empty($link_id)) {

            return false;

        }

        // TODO find the corresponding category (the first one for this course, ordered by ID)

        $l = Database::get_main_table(TABLE_MAIN_GRADEBOOK_LINK);

        $sql = "SELECT * FROM $l WHERE id = " . (int) $link_id;

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

        $row = array();

        if (Database::num_rows($res) > 0) {

            $row = Database::fetch_array($res, 'ASSOC');

        }

        return $row;

    }

    /**

     * Return the course id

 * @param   string  language name (the corresponding name of the language-folder in the filesystem)

 * @return  int     id of the language

 */

function api_get_language_id($language)

{

    $tbl_language = Database::get_main_table(TABLE_MAIN_LANGUAGE);

    if (empty($language)) {

        return null;

    }

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

    $sql = "SELECT id FROM $tbl_language

            WHERE dokeos_folder = '$language' LIMIT 1";

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

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

    return $row['id'];

}

/**

 * Gets language of the requested type for the current user. Types are :

     * @return int User id

     * @assert ('0','---') === 0

     */

    public static function get_user_id_from_original_id($original_user_id_value, $original_user_id_name)

    {

        $t_uf = Database::get_main_table(TABLE_EXTRA_FIELD);

        $t_ufv = Database::get_main_table(TABLE_EXTRA_FIELD_VALUES);

        $extraFieldType = EntityExtraField::USER_FIELD_TYPE;

        $sql = "SELECT item_id as user_id

                FROM $t_uf uf

                INNER JOIN $t_ufv ufv

                ON ufv.field_id=uf.id

                WHERE

                    variable='$original_user_id_name' AND

                    value='$original_user_id_value' AND

                    extra_field_type = $extraFieldType

                ";

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

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

        if ($row) {

            return $row->user_id;

        } else {

            return 0;

        }

    }

    /**

     * Check if a username is available