[MANUAL] lin_UpdateUserItem with attrs MSSQL

Тема в разделе "Установка и настройка (Setup and configuration)", создана пользователем root, 29 сен 2014.

  1. root

    root Administrator Команда форума Administrator Moderator Developers Team

    Регистрация:
    23 авг 2014
    Сообщения:
    253
    Симпатии:
    56
    Баллы:
    11
    Код:
    USE [lin2world]GO
    /****** Object:  StoredProcedure [dbo].[lin_UpdateUserItem]    Script Date: 06/19/2010 14:07:53 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    
    
    ALTER PROCEDURE [dbo].[lin_UpdateUserItem]
    (
    @char_id	INT,
    @item_type	INT,
    @amount	INT,
    @enchant	INT,
    @eroded	INT,
    @bless		INT,
    @ident		INT,
    @wished	INT,
    @warehouse	INT,
    @item_id		INT,
    @attack_attr_type	TINYINT,
    @attack_attr_value	INT,
    @def_attr_fire	INT,
    @def_attr_water	INT,
    @def_attr_wind	INT,
    @def_attr_earth	INT,
    @def_attr_holy	INT,
    @def_attr_unholy	INT
    )
    AS
    SET NOCOUNT ON
    
    
    UPDATE user_item  set [email protected]_id, [email protected]_type, [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]_attr_type, [email protected]_attr_value, [email protected]_attr_fire, [email protected]_attr_water, [email protected]_attr_wind, [email protected]_attr_earth, [email protected]_attr_holy, [email protected]_attr_unholy WHERE [email protected]_id