Storage and equipment bug

[mgdmgd]

Hey guys
when i send item to equip it sends and all cool
but when i move it to storage it doesn't move it say in equipment but if i relog items get removed
and when i send it to storage , storage doesn't get it , it still empty
i edited the sql

please help me asap

 

[LightRaven]

1- SQL Management.
2- New query.

3- Paste it:

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO


-- 내 캐릭터 캐쉬아이템을 창고에 넣기 ---------
ALTER PROC [dbo].[spBringBackAccountItem]
@AID int,
@CID int,
@CIID int
AS
SET NOCOUNT ON

DECLARE @ItemID int
DECLARE @RentDate DATETIME
DECLARE @RentHourPeriod SMALLINT
DECLARE @Cnt SMALLINT

DECLARE @HeadCIID int
DECLARE @ChestCIID int
DECLARE @HandsCIID int
DECLARE @LegsCIID int
DECLARE @FeetCIID int
DECLARE @FingerLCIID int
DECLARE @FingerRCIID int
DECLARE @MeleeCIID int
DECLARE @PrimaryCIID int
DECLARE @SecondaryCIID int
DECLARE @Custom1CIID int
DECLARE @Custom2CIID int

DECLARE @DEIIDCount int

SELECT
@HeadCIID=head_slot, @ChestCIID=chest_slot, @HandsCIID=hands_slot,
@LegsCIID=legs_slot, @FeetCIID=feet_slot, @FingerLCIID=fingerl_slot, @FingerRCIID=fingerr_slot,
@MeleeCIID=melee_slot, @PrimaryCIID=primary_slot, @SecondaryCIID=secondary_slot,
@Custom1CIID=custom1_slot, @Custom2CIID=custom2_slot
FROM Character(nolock) WHERE cid=@CID AND aid=@AID

SELECT @ItemID=ItemID, @RentDate=RentDate, @RentHourPeriod=RentHourPeriod, @Cnt=Cnt
FROM CharacterItem WHERE CIID=@CIID AND CID=@CID

SELECT @DEIIDCount=COUNT(*) FROM Item(nolock) WHERE ItemID=@ItemID

IF ((@ItemID IS NOT NULL) AND (@DEIIDCount = 1) AND
(@HeadCIID IS NULL OR @HeadCIID != @CIID) AND
(@ChestCIID IS NULL OR @ChestCIID != @CIID) AND
(@HandsCIID IS NULL OR @HandsCIID != @CIID) AND
(@LegsCIID IS NULL OR @LegsCIID != @CIID) AND
(@FeetCIID IS NULL OR @FeetCIID != @CIID) AND
(@FingerLCIID IS NULL OR @FingerLCIID != @CIID) AND
(@FingerRCIID IS NULL OR @FingerRCIID != @CIID) AND
(@MeleeCIID IS NULL OR @MeleeCIID != @CIID) AND
(@PrimaryCIID IS NULL OR @PrimaryCIID != @CIID) AND
(@SecondaryCIID IS NULL OR @SecondaryCIID != @CIID) AND
(@Custom1CIID IS NULL OR @Custom1CIID != @CIID) AND
(@Custom2CIID IS NULL OR @Custom2CIID != @CIID))
BEGIN
BEGIN TRAN -------------
UPDATE CharacterItem SET CID=NULL WHERE CIID=@CIID AND CID=@CID
IF 0 = @@ROWCOUNT BEGIN
ROLLBACK TRAN
RETURN
END

INSERT INTO AccountItem (AID, ItemID, RentDate, RentHourPeriod, Cnt)
VALUES (@AID, @ItemID, @RentDate, @RentHourPeriod, @Cnt)
IF 0 <> @@ERROR BEGIN
ROLLBACK TRAN
RETURN
END
COMMIT TRAN -----------
END

4- Execute.
5- Try again.

Credits: s00rk (query)

 

[mgdmgd]

Now if i move it doesn't move but if i relog the item stay in equipment doesn't get removed
but still can't send to storage or move any item to storage