Little help about offline vend after i try'd to place the pet i got this sql errors
CQuery-LogFile_20201002
error_20201002
i already check the stored procedure but the file that the errors looking for was there. heres the stored procedures
uspShopCloseLog
uspVendorNpcLogInsert
Willing to pay for it just private message me
CQuery-LogFile_20201002
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'.
//================================================== ================================================== ============
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
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
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
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]
@[Only registered and activated users can see links. Click Here To Register...]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
@[Only registered and activated users can see links. Click Here To Register...]Time
,@iidPlayer
,@iszItem
,@iszPet
,@iszExt
,@iszPiercing)
SET NOCOUNT OFF
GO
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]
@[Only registered and activated users can see links. Click Here To Register...]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
@[Only registered and activated users can see links. Click Here To Register...]Time
,@iidPlayer
,@iszItem
,@iszPet
,@iszExt
,@iszPiercing)
SET NOCOUNT OFF
GO
uspVendorNpcLogInsert
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,
@[Only registered and activated users can see links. Click Here To Register...]ing int,
@[Only registered and activated users can see links. Click Here To Register...] float,
@[Only registered and activated users can see links. Click Here To Register...]pName varchar(64),
@iszItem varchar(MAX),
@iszPet varchar(MAX),
@iszExt varchar(MAX),
@iszPiercing varchar(MAX),
@iszIndex varchar(MAX),
@[Only registered and activated users can see links. Click Here To Register...]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
@[Only registered and activated users can see links. Click Here To Register...]ing
@[Only registered and activated users can see links. Click Here To Register...]
@[Only registered and activated users can see links. Click Here To Register...]pName
,@iszItem
,@iszPet
,@iszExt
,@iszPiercing
,@iszIndex
@[Only registered and activated users can see links. Click Here To Register...]bjIndex
,@idwItemID)
SELECT idVendor
FROM [dbo].[tblVendorNPCLog]
WHERE idPlayer = @iidPlayer
ORDER BY idVendor DESC
SET NOCOUNT OFF
GO
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,
@[Only registered and activated users can see links. Click Here To Register...]ing int,
@[Only registered and activated users can see links. Click Here To Register...] float,
@[Only registered and activated users can see links. Click Here To Register...]pName varchar(64),
@iszItem varchar(MAX),
@iszPet varchar(MAX),
@iszExt varchar(MAX),
@iszPiercing varchar(MAX),
@iszIndex varchar(MAX),
@[Only registered and activated users can see links. Click Here To Register...]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
@[Only registered and activated users can see links. Click Here To Register...]ing
@[Only registered and activated users can see links. Click Here To Register...]
@[Only registered and activated users can see links. Click Here To Register...]pName
,@iszItem
,@iszPet
,@iszExt
,@iszPiercing
,@iszIndex
@[Only registered and activated users can see links. Click Here To Register...]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