17 lines
413 B
Transact-SQL
17 lines
413 B
Transact-SQL
CREATE PROCEDURE [dbo].[up_upate_item_binds]
|
|
@character_id [uniqueidentifier],
|
|
@item_id [uniqueidentifier],
|
|
@binds int
|
|
AS
|
|
BEGIN
|
|
SET NOCOUNT ON;
|
|
|
|
if @binds = 0
|
|
begin
|
|
update N_InventoryItem set ReconNum = ReconNum -1
|
|
where character_id = @character_id and item_uid = @item_id
|
|
end
|
|
update N_InventoryItem set ReconState = @binds
|
|
where character_id = @character_id and item_uid = @item_id
|
|
return 0
|
|
END
|