Printable View
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.
Well you do not have right stored procedure for it that is reason why
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 .
It is about Netcafe Billing and its t-point stored procedure
run this query and it will work
Quote:
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
thx but still noth work same tpshop and Gril Yul . i dont know wath to do .. i try evrething :|
maybe trying another db?
I tried three different database and still have this problem.
can someone help me? THX
Quote:
Originally Posted by Blanozos
can someone plyz give me a db that work.
Stil same problem .:thumbdown::(: