HELP !!! Some problems with GambleBox

[kryst4l]

I try add Gamble Item is Avatar Item Bounty like FXP Gunz. Buy > Open and RelogChar but it not work. And again i try change Avatar bounty to Cash item it not work too. Can someone help me with this problems. Very THANKS!!!
I try change spChangeGambleItemToRewardNormalItem. But still nothing happened
with this :

USE [GunzDB]
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
--ALTER PROC [dbo].[spChangeGambleItemToRewardNormalItem]
CREATE PROC dbo.spChangeGambleItemToRewardNormalItem
@Cid INT
, @CIID INT
, @GiiD INT
, @GRIID INT
, @rewardItemID INT
, @rewardRentPeriod INT


AS BEGIN

SET NOCOUNT ON;

DECLARE @rentHourPeriod INT;
DECLARE @GambleItemCount INT;

-----------------------------------------------------------------------------

SELECT @rentHourPeriod = ISNULL(RentHourPeriod, 0)
FROM GambleRewardItem gri(NOLOCK)
WHERE GRIID = @GRIID
AND GIID = @GiiD
AND (ItemIDMale = @rewardItemID OR ItemIDFemale = @rewardItemID)

IF (0 = @@ROWCOUNT) BEGIN
SELECT -1 AS 'Ret'
RETURN
END

SELECT @GambleItemCount = ISNULL(Cnt, 1)
FROM CharacterItem(NOLOCK)
WHERE CIID = @CIID;

-----------------------------------------------------------------------------

DECLARE @NowDate DATETIME;
SET @NowDate = GETDATE();

-----------------------------------------------------------------------------

BEGIN TRAN -----------

----------------------------------------------------------------------------------------

IF( @GambleItemCount > 1 ) BEGIN

UPDATE CharacterItem
SET Cnt = Cnt - 1
WHERE CID = @Cid
AND CIID = @CIID

IF (0 <> @@ERROR) OR (0 = @@ROWCOUNT) BEGIN
ROLLBACK TRAN
SELECT -2 AS 'Ret'
RETURN
END

END
ELSE BEGIN

UPDATE CharacterItem
SET CID = NULL
WHERE CID = @Cid
AND CIID = @CIID

IF (0 <> @@ERROR) OR (0 = @@ROWCOUNT) BEGIN
ROLLBACK TRAN
SELECT -3 AS 'Ret'
RETURN
END

END

---------------------------------------------------------------------------------------

INSERT CharacterItem(CID, ItemID, RegDate, RentDate, RentHourPeriod, Cnt)
VALUES @Cid, @rewardItemID, @NowDate, @NowDate, @rentHourPeriod, 1)

DECLARE @OrderCIID INT;
SET @OrderCIID = @@IDENTITY;

IF (0 <> @@ERROR) BEGIN
ROLLBACK TRAN
SELECT -4 AS 'Ret'
RETURN
END


INSERT dbo.ItemChangeLog_CharacterItem(ChangeType, ChangeDate, CID, CIID, ItemID, [Count])
VALUES (202, @NowDate, @Cid, @CIID, @GiiD, 1);

IF (0 <> @@ERROR) BEGIN
ROLLBACK TRAN
SELECT -5 AS 'Ret'
RETURN
END

INSERT dbo.ItemChangeLog_CharacterItem(ChangeType, ChangeDate, CID, CIID, ItemID, [Count])
VALUES (102, @NowDate, @Cid, @OrderCIID, @rewardItemID, 1);

IF (0 <> @@ERROR) BEGIN
ROLLBACK TRAN
SELECT -6 AS 'Ret'
RETURN
END

INSERT INTO LogDB..GambleLog(CID, GIID, RewardItemID, RegDate)
VALUES @Cid, @GiiD, @rewardItemID, @NowDate);

IF (0 <> @@ERROR) BEGIN
ROLLBACK TRAN
SELECT -7 AS 'Ret'
RETURN
END