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

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

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

 * @param int       Access URL

 * @return boolean  False on failure, true on success

 */

function api_delete_category_settings_by_subkey($subkey, $access_url_id = 1) {

    if (empty($subkey)) { return false; }

    $t_cs = Database::get_main_table(TABLE_MAIN_SETTINGS_CURRENT);

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

    $access_url_id = intval($access_url_id);

    $sql = "DELETE FROM $t_cs WHERE subkey = '$subkey' AND access_url = $access_url_id";

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

    return $r;

}

/**

 * Sets a platform configuration setting to a given value

    /**

     * @param int $id

     */

    public static function deleteCategory($id)

    {

        $id = intval($id);

        $table = Database::get_main_table(TABLE_TICKET_TICKET);

        $sql = "UPDATE $table SET category_id = NULL WHERE category_id = $id";

        Database::query($sql);

        $table = Database::get_main_table(TABLE_TICKET_CATEGORY);

        $sql = "DELETE FROM $table WHERE id = $id";

        Database::query($sql);

    }

    /**

     * @param int $categoryId