DK ACE V21 Testing Files

[Bebe*]

Little help about offline vend after i try'd to place the pet i got this sql errors

CQuery-LogFile_20201002

 Spoiler

2020/10/02 15:45:53
query:uspShopCloseLog '1601624753', '0000001', '3,21,0,0,,1,0,7200000,0,0,0,-1665507005,0,0,0,0,0,-1/$', '$', '0,0,0,0/$', '$'
SQLSTATE:42000 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'uspShopCloseLog'.
//================================================== ================================================== ============
2020/10/02 15:45:56
query:uspVendorNpcLogInsert '0000001', 1, 1, 6960.18, 100.00, 3232.80, 0.00, 1601883956, 1.00, 'Vend Test 1', '0,21,0,0,,1,0,7200000,0,0,0,-1665507005,0,0,0,0,0,-1/$', '$', '0,0,0,0,1,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/$', '$', '0/1/2/3/4/5/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/$', '0/1/2/3/4/5/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/$', 224899
SQLSTATE:42000 error:[Microsoft][SQL Server Native Client 11.0][SQL Server]Could not find stored procedure 'uspVendorNpcLogInsert'.
//================================================== ================================================== ============

error_20201002

 Spoiler

2020/10/ 2 15:45:53 CDbManager::ShopCloseLog[Line:1360] Failed, Query: uspShopCloseLog '1601624753', '0000001', '3,21,0,0,,1,0,7200000,0,0,0,-1665507005,0,0,0,0,0,-1/$', '$', '0,0,0,0/$', '$'

2020/10/ 2 15:45:56 CDbManager::VendNpcInsertLog[Line:1284] Failed, Query: uspVendorNpcLogInsert '0000001', 1, 1, 6960.18, 100.00, 3232.80, 0.00, 1601883956, 1.00, 'Vend Test 1', '0,21,0,0,,1,0,7200000,0,0,0,-1665507005,0,0,0,0,0,-1/$', '$', '0,0,0,0,1,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/0,0,0,0,0,923883336,923949116/$', '$', '0/1/2/3/4/5/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/$', '0/1/2/3/4/5/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/$', 224899

i already check the stored procedure but the file that the errors looking for was there. heres the stored procedures

uspShopCloseLog

 Spoiler

USE [CHARACTER_01_DBF]
GO

/****** Object: StoredProcedure [dbo].[uspShopCloseLog] Script Date: 10/2/2020 3:52:38 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO





CREATE PROCEDURE [dbo].[uspShopCloseLog]
@Time int,
@iidPlayer char(7),
@iszItem varchar(MAX),
@iszPet varchar(MAX),
@iszExt varchar(MAX),
@iszPiercing varchar(MAX)
AS
SET NOCOUNT ON

INSERT INTO [dbo].[tblShopCloseLog]
([tmTime]
,[idPlayer]
,[szItem]
,[szPet]
,[szExt]
,[szPiercing])
VALUES
@Time
,@iidPlayer
,@iszItem
,@iszPet
,@iszExt
,@iszPiercing)
SET NOCOUNT OFF







GO

uspVendorNpcLogInsert

 Spoiler

USE [CHARACTER_01_DBF]
GO

/****** Object: StoredProcedure [dbo].[uspVendorNpcLogInsert] Script Date: 10/2/2020 3:54:23 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO





CREATE PROCEDURE [dbo].[uspVendorNpcLogInsert]
@iidPlayer char(7),
@iidWorld int,
@iidChannel int,
@iPosX float,
@iPosY float,
@iPosZ float,
@iAngle float,
@ing int,
@ float,
@pName varchar(64),
@iszItem varchar(MAX),
@iszPet varchar(MAX),
@iszExt varchar(MAX),
@iszPiercing varchar(MAX),
@iszIndex varchar(MAX),
@bjIndex varchar(MAX),
@idwItemID int
AS
SET NOCOUNT ON

INSERT INTO [dbo].[tblVendorNPCLog]
([idPlayer]
,[idWorld]
,[idChannel]
,[fPosX]
,[fPosY]
,[fPosZ]
,[fAngle]
,[nRemaining]
,[fScale]
,[szShopName]
,[szItem]
,[szPet]
,[szExt]
,[szPiercing]
,[szIndex]
,[szObjIndex]
,[dwItemID])
VALUES
(@iidPlayer
,@iidWorld
,@iidChannel
,@iPosX
,@iPosY
,@iPosZ
,@iAngle
@ing
@
@pName
,@iszItem
,@iszPet
,@iszExt
,@iszPiercing
,@iszIndex
@bjIndex
,@idwItemID)

SELECT idVendor
FROM [dbo].[tblVendorNPCLog]
WHERE idPlayer = @iidPlayer
ORDER BY idVendor DESC

SET NOCOUNT OFF







GO

Willing to pay for it just private message me