36 lines
953 B
Transact-SQL
36 lines
953 B
Transact-SQL
CREATE PROCEDURE [dbo].[up_guild_storage_extension]
|
|
(
|
|
@guild_id [uniqueidentifier]
|
|
,@character_id [uniqueidentifier]
|
|
,@slot_count INT
|
|
,@cost_money INT
|
|
,@page_count TINYINT
|
|
,@level INT
|
|
)
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
|
|
declare @my_money int
|
|
|
|
BEGIN
|
|
-- 비용 제거해야함
|
|
SELECT @my_money = [gold] FROM [dbo].[tbl_Guild_Storage_info] with (READUNCOMMITTED) where [guild_id] = @guild_id
|
|
|
|
-- 돈 삭제 및 길드 설정
|
|
if (@my_money - @cost_money) > 0
|
|
begin
|
|
UPDATE [dbo].[tbl_Guild_Storage_info] SET [gold] = (@my_money - @cost_money) WHERE [guild_id] = @guild_id
|
|
end
|
|
else
|
|
begin
|
|
UPDATE [dbo].[tbl_Guild_Storage_info] SET [gold] = 0 WHERE [guild_id] = @guild_id
|
|
end
|
|
|
|
UPDATE tbl_Guild_Storage_Info SET [page_count] = @page_count
|
|
,[slot_count] = @slot_count
|
|
,[level] = @level
|
|
WHERE [guild_id] = @guild_id
|
|
END
|
|
|
|
RETURN
|