Failed to purchase an item.

[Blanozos]

I add Event Gril Yul and TPoint Shop in game and wen i try to buy somthing from them ghiv me failed to purchase an item.


LogError in Wolrd
[##ERROR##] 'CheckPacketValidation' fail (Game/EMS/EventNPCManager.cpp:58)
[##ERROR##] pITSRequest->result is raised in OnITCEMSNPCAction() (Proc/EMS.cpp:368)

Event .scp
[NpcPos] Flags WorldIdx Index PosX PosY Type IsRangeCheck
1 0 3 49 195 56 8 1
0 0 1 10 11 25 8 0


Someone can help me with this problem .
THX.

 

[golddragooon]

Well you do not have right stored procedure for it that is reason why

 

[Blanozos]

wath stored procedure i need i dont know wath is missing . in logo sey only

[##ERROR##] 'CheckPacketValidation' fail (Game/EMS/EventNPCManager.cpp:58)
[##ERROR##] pITSRequest->result is raised in OnITCEMSNPCAction() (Proc/EMS.cpp:368)

i try with onther eventDB and same problem fail to buy some one help me plyz .

 

[golddragooon]

It is about Netcafe Billing and its t-point stored procedure

run this query and it will work

USE [NetcafeBilling]
GO

/****** Object: StoredProcedure [dbo].[TPoint_InsertPointShopLog] Script Date: 10/02/2016 09:16:36 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


-- =============================================
-- Author: Name
-- Create date:
-- Description:
-- =============================================
CREATE PROCEDURE [dbo].[TPoint_InsertPointShopLog]
@ItemIdx int,
@ItemOption int,
@ItemDuration int,
@PointPrice int,
@UserNum int
AS
BEGIN

SET NOCOUNT ON
DECLARE @TPoint INT
DECLARE @Result INT
SET @Result = 0

SELECT @TPoint = TPoint
FROM Point
WHERE UserNum = @UserNum

IF @TPoint >= @PointPrice
BEGIN

INSERT INTO PointShopLog
(ItemIdx, ItemOption, ItemDuration, Point, UserNum)
VALUES
(@ItemIdx, @ItemOption, @ItemDuration, -@PointPrice, @UserNum)

SET @result = 1 /* 1 = Success, 0 = Fail */

END

SET NOCOUNT OFF

SELECT @Result

END

GO

 

[Blanozos]

thx but still noth work same tpshop and Gril Yul . i dont know wath to do .. i try evrething :|

maybe trying another db?

 

[Blanozos]

I tried three different database and still have this problem.

can someone help me? THX

 

[Blanozos]

I tried three different database and still have this problem.

can someone help me? THX

can someone plyz give me a db that work.
Stil same problem .:thumbdown::