![[RELEASE] FIX for Bank teller DC problem](https://www.elitepvpers.com/forum/iconimages/shaiya-pserver-guides-releases/release-fix-bank-teller-dc-problem_ltr.gif){kind=small}
[RELEASE] FIX for Bank teller DC problem
what needs to be done run these few quarys to alter ( fix ) the procs errors.
not shure if this first quary has any signifacants to the dc ishue but i edited it also so i included it for just incase.
PHP Code:
USE [PS_Billing]
GO
/****** Object: StoredProcedure [dbo].[usp_Insert_AuctionProduct_User_E] Script Date: 01/31/2012 22:16:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Proc [dbo].[usp_Insert_AuctionProduct_User_E]
@UserUID int,
@ProductCode varchar(20),
@SecurityCode varchar(16)
--@UserUID => 유저개정키
--@ProductCode => Item Code(GoodCode)
--@SecurityCode => Passphrase
-- RETURN
-- 0 => Success.
-- -1 => Security code error.
-- -2 => 은행슬롯 꽉참.
-- -3 => Add items in error.
-- -4 => Item code does not exist.
-- -5 => INSERT Error (DB error)
--WITH ENCRYPTION
AS
SET NOCOUNT ON
DECLARE @SlotCnt int
DECLARE @SlotMax int
DECLARE @SlotUse int
DECLARE @I int
DECLARE @J int
DECLARE @StrItemID varchar(20)
DECLARE @StrItemCount varchar(20)
DECLARE @Query nvarchar(1000)
DECLARE @ItemID int
DECLARE @ItemCount tinyint
DECLARE @Ret int
DECLARE @OrderNumber int
DECLARE @VerifyCode bigint
SET @Ret = 0
SET @SlotMax = 240
SET @OrderNumber = 9999
SET @VerifyCode = 9999
BEGIN TRANSACTION
CREATE TABLE #SlotList( SlotNum int NOT NULL )
INSERT INTO #SlotList SELECT Slot FROM Users_Product WHERE UserUID=@UserUID ORDER BY Slot
SET @SlotCnt = ( SELECT ISNULL(COUNT(*),0) FROM #SlotList )
IF( @SlotCnt >= @SlotMax )
BEGIN
-- Item has exceeded number (bank slots kkwakcham)
SET @Ret = -2
GOTO ERROR_RETURN
END
SET @I = 1
WHILE( @I <= 24 )
BEGIN
SET @StrItemID = 'ItemID' + CAST( @I AS varchar(5) )
SET @StrItemCount = 'ItemCount' + CAST( @I AS varchar(5) )
SET @Query = 'SELECT @ItemID='+@StrItemID+', @ItemCount='+@StrItemCount+' FROM AuctionProductList WHERE ProductCode='''+@ProductCode+''''
EXEC sp_executesql @Query, N'@ItemID int OUTPUT, @ItemCount tinyint OUTPUT', @ItemID OUTPUT, @ItemCount OUTPUT
IF( (@ItemID IS NOT NULL) AND (@ItemCount IS NOT NULL) AND (@ItemID <> 0) )
BEGIN
SET @J = 0
WHILE( @J < @SlotMax )
BEGIN
SET @SlotUse = ( SELECT ISNULL(COUNT(*),0) FROM #SlotList WHERE SlotNum=@J )
IF( @SlotUse = 0 )
BEGIN
INSERT INTO Users_Product(UserUID,Slot,ItemID,ItemCount,ProductCode,OrderNumber,VerifyCode,BuyDate) VALUES(@UserUID,@J,@ItemID,@ItemCount,@ProductCode,@OrderNumber,@VerifyCode,GETDATE())
IF( @@ERROR = 0 )
BEGIN
INSERT INTO #SlotList(SlotNum) VALUES(@J)
BREAK
END
ELSE
BEGIN
-- Insert error
SET @Ret = -5
GOTO ERROR_RETURN
END
END
SET @J = @J + 1
END
IF( @J >= @SlotMax )
BEGIN
-- Lack of slots (not add the item)
SET @Ret = -3
GOTO ERROR_RETURN
END
END
ELSE IF( @I = 1 )
BEGIN
-- Product table data error (the product code does not exist)
SET @Ret = -4
GOTO ERROR_RETURN
END
SET @I = @I + 1
END
ERROR_RETURN:
DROP TABLE #SlotList
IF( @@ERROR = 0 AND @Ret = 0 )
BEGIN
COMMIT TRAN
RETURN 0
END
ELSE
BEGIN
ROLLBACK TRAN
RETURN @Ret
END
SET NOCOUNT OFF
PHP Code:
USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Save_Char_Product_Item_E] Script Date: 01/31/2012 22:23:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER Proc [dbo].[usp_Save_Char_Product_Item_E]
@ServerID tinyint,
@UserUID int,
@BankSlot tinyint,
@CharID int,
@ItemUID bigint,
@Bag tinyint,
@Slot tinyint,
@ItemID int,
@Type tinyint,
@TypeID tinyint,
@Quality smallint, --int
@Gem1 tinyint,
@Gem2 tinyint,
@Gem3 tinyint,
@Gem4 tinyint,
@Gem5 tinyint,
@Gem6 tinyint,
@Craftname varchar(20) = '',
@Count tinyint,
@Maketime datetime,
@Maketype varchar(1) --char(1)
AS
--SET NOCOUNT ON
SET XACT_ABORT ON
DECLARE @ProductCode varchar(20)
DECLARE @OrderNumber int
DECLARE @VerifyCode bigint
DECLARE @BuyDate datetime
IF(@Quality >= 5000)
BEGIN
SET @Quality=0
END
BEGIN DISTRIBUTED TRANSACTION
-- Add inventory
INSERT INTO CharItems(CharID,Bag,Slot,ItemID,Type,TypeID,ItemUID,Quality,Gem1,Gem2,Gem3,Gem4,
Gem5,Gem6,CraftName,[Count],Maketime,Maketype)
VALUES(@CharID,@Bag,@Slot,@ItemID,@Type,@TypeID,@ItemUID,@Quality,@Gem1,@Gem2,@Gem3,@Gem4,
@Gem5,@Gem6,@Craftname,@Count,@Maketime,@Maketype)
-- Logging receipt of goods
SELECT @ProductCode=ProductCode,@OrderNumber=OrderNumber,@VerifyCode=VerifyCode,@BuyDate=BuyDate
FROM PS_Billing.dbo.Users_Product
WHERE UserUID=@UserUID AND Slot=@BankSlot
INSERT INTO ProductLog(ServerID,UserUID,CharID,ItemID,ItemUID,Quality,ItemCount,ProductCode,OrderNumber,VerifyCode,BuyDate,ReceiveDate)
VALUES(@ServerID,@UserUID,@CharID,@ItemID,@ItemUID,@Quality,@Count,@ProductCode,@OrderNumber,@VerifyCode,@BuyDate,@Maketime)
-- Deleting the bank storage
DELETE FROM PS_Billing.dbo.Users_Product WHERE UserUID=@UserUID AND Slot=@BankSlot
IF( @@ERROR=0 AND @@ROWCOUNT=1)
BEGIN
COMMIT TRAN
RETURN 1
END
ELSE
BEGIN
ROLLBACK TRAN
RETURN -1
END
SET XACT_ABORT OFF
--SET NOCOUNT OFF
![[DEV]xXDASHXx is offline](images/elitepvpers/statusicon/user_offline.gif){kind=small}
