T-Point stored procedure!

[VizesLufi]

Hello guys iam looking for this stored procedure if you can help me pls do it :!


[##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Could not find stored procedure 'dbo.TPoint_InsertPointShopLog'.

Thanks :/

 

[magraopb]

Great youyou, working..

my feedback:
now i'm able to buy items from NPC, but after certain time, i can't to buy more, i don't know why yet, i'll try tomorrow, now i'm going to sleep.. i'm so tired

See my World log

Spoiler

[Sat Jun 22 2013 03:41:01.422359 2818399120]: [##ERROR##] pITSRequest->result is raised in OnITCEMSNPCAction() (Proc/EMS.cpp:368)

 

[Spik3man]

still dosen't work , i got these errors

[Sat Jun 22 2013 09:55:59.860862 2818481040]: [##ERROR##] 'CheckPacketValidation' fail (Game/EMS/EventNPCManager.cpp:58)
[Sat Jun 22 2013 09:55:59.861168 2818481040]: [##ERROR##] pITSRequest->result is raised in OnITCEMSNPCAction() (Proc/EMS.cpp:368)
[Sat Jun 22 2013 09:56:01.523446 2818481040]: [##ERROR##] 'CheckPacketValidation' fail (Game/EMS/EventNPCManager.cpp:58)
[Sat Jun 22 2013 09:56:01.523685 2818481040]: [##ERROR##] pITSRequest->result is raised in OnITCEMSNPCAction() (Proc/EMS.cpp:368)
[Sat Jun 22 2013 09:56:01.885815 2818481040]: [##ERROR##] 'CheckPacketValidation' fail (Game/EMS/EventNPCManager.cpp:58)
[Sat Jun 22 2013 09:56:01.885967 2818481040]: [##ERROR##] pITSRequest->result is raised in OnITCEMSNPCAction() (Proc/EMS.cpp:368)
[Sat Jun 22 2013 09:56:02.239427 2818481040]: [##ERROR##] 'CheckPacketValidation' fail (Game/EMS/EventNPCManager.cpp:58)
[Sat Jun 22 2013 09:56:02.239650 2818481040]: [##ERROR##] pITSRequest->result is raised in OnITCEMSNPCAction() (Proc/EMS.cpp:368)
[Sat Jun 22 2013 09:56:03.125253 2818481040]: [##ERROR##] 'CheckPacketValidation' fail (Game/EMS/EventNPCManager.cpp:58)
[Sat Jun 22 2013 09:56:03.125405 2818481040]: [##ERROR##] pITSRequest->result is raised in OnITCEMSNPCAction() (Proc/EMS.cpp:368)
[Sat Jun 22 2013 09:56:03.472471 2818481040]: [##ERROR##] 'CheckPacketValidation' fail (Game/EMS/EventNPCManager.cpp:58)
[Sat Jun 22 2013 09:56:03.472679 2818481040]: [##ERROR##] pITSRequest->result is raised in OnITCEMSNPCAction() (Proc/EMS.cpp:368)
[Sat Jun 22 2013 09:56:04.480204 2818481040]: [##ERROR##] 'CheckPacketValidation' fail (Game/EMS/EventNPCManager.cpp:58)
[Sat Jun 22 2013 09:56:04.480351 2818481040]: [##ERROR##] pITSRequest->result is raised in OnITCEMSNPCAction() (Proc/EMS.cpp:368)
[Sat Jun 22 2013 09:56:06.864675 2818481040]: [##ERROR##] 'CheckPacketValidation' fail (Game/EMS/EventNPCManager.cpp:58)
[Sat Jun 22 2013 09:56:06.864840 2818481040]: [##ERROR##] pITSRequest->result is raised in OnITCEMSNPCAction() (Proc/EMS.cpp:368)
[Sat Jun 22 2013 09:56:07.029159 2818481040]: [##ERROR##] 'CheckPacketValidation' fail (Game/EMS/EventNPCManager.cpp:58)
[Sat Jun 22 2013 09:56:07.029310 2818481040]: [##ERROR##] pITSRequest->result is raised in OnITCEMSNPCAction() (Proc/EMS.cpp:368)

 

[youyou]

I do　not have the error :*:
hmm

 

[Spik3man]

could you upload ur database ?

 

[allocen]

could you upload ur database ?

It does work, you should try harder.

 

[Spik3man]

done , working now*xD

 

[x30unlimited]

TPoint_InsertPointShopLog

congrats on postin' it, took a while for some1 else to figure it out rebuild it a few weeks ago myself

 

[toast2250]

Ontopic,
Thank you so much youyou,
I have spammed buy and it works perfectly fine with no error at all.
All of the currencies can now be exchanged ingame instead of using a web shop.

I will include it in the future DB repack and give full credits to you and others that helped contributing!

Web ideas,
I have got stuck with TPoint stored procedure and since I had no more ideas, yesterday morning I went on to successfully converting the chumpy web shop to TPoint by using 2 new stored procedures converted from the existing ones.

Spoiler

[B]cabal_tool_SetTPoint[/B]
USE [NetcafeBilling]
GO
/****** Object:  StoredProcedure [dbo].[cabal_tool_SetWarehouseAlz]    Script Date: 06/21/2013 09:10:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cabal_tool_SetWarehouseAlz]
( @UserNum int, @TPoint int, @encrypted bigint) 
AS
	BEGIN
		UPDATE Point
		SET TPoint = @TPoint
		WHERE UserNum = @UserNum
	END

[B]cabal_tool_GetTPoint[/B]
USE [NetcafeBilling]
GO
/****** Object:  StoredProcedure [dbo].[cabal_sp_GetNetCafeTPoint]    Script Date: 06/21/2013 11:55:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cabal_sp_GetNetCafeTPoint] 
( @usernum int )
AS
BEGIN	
	DECLARE @RESULT INT SET @RESULT = 0
	SELECT @Result = TPoint FROM Point WHERE USERNUM = @UserNum
	SELECT @RESULT
END

Now I will reconvert them once again since the TPoint is ingame, maybe to exchange Honour points or AXP, any gainable points can be used. :

I also plan to include the chumpy web shop, change pass and rank in the repack.

Event option column,
The event function was restored by hefajstos, option is used for NPC being clickable/unclickable,.. also maybe something else.
http://forum.ragezone.com/f460/guide-event-system-works-915010/index7.html#post7571663

 

[magraopb]

Hi all,
now, i got this error, in my test server all works fine about T-Point, but when i do a backup from test server and restore this on my real server, got this error

Spoiler

[Fri Jun 28 2013 03:55:19.641290 2818010000]: [##ERROR##] 'CheckPacketValidation' fail (Game/EMS/EventNPCManager.cpp:58)
[Fri Jun 28 2013 03:55:19.641702 2818010000]: [##ERROR##] pITSRequest->result is raised in OnITCEMSNPCAction() (Proc/EMS.cpp:368)

obs:
File Servers between servers are same

 

[Spik3man]

Did u put the missing line into event.scp xD. Thats the cause of the error

 

[magraopb]

Ohh sh... yes!!
i forgot to add the NPC line into event.scp. omg -.-'

Thanks Miha!

Other question:
is normal show the item without model 3D?
and red slot if i don't have the requeriments to buy?

my items just showed if i have enough t-points to buy it

 

[Spik3man]

there are 2 tables for items , in one of them you will find visual id , there you go

Edit :

cabal_ems_event_item_table

last column , texture itemidx

 

[toast2250]

The red slot if you don't have enough TPoints or requirement not meet is normal I think.

What kind of model 3D problem do you have?
The Item displays normally here if the requirements are meet, armor for example.

 

[magraopb]

all items are red if haven't requirements

 

[CarvalhoMonster]

Here is giving fault to buy the item please somebody help me...

If someone could help me thank you too

 

[CarvalhoMonster]

Here is giving fault to buy the item please somebody help me...

If someone could help me thank you too

 

[ChaosWI]

Hey guys , I added the T-points in BloodyIce successfully , but how do characters gain t points through playing and what is the rate for it and where can i edit these info ?

FYI i only managed to add it manually to the dbo.Point

 

[RGaming]

look for world setting

[TPoint]
Use=TRUE
MaxPoint=5000
BasisPoint=2
UpdateSpan=300
UseTPointOnlyBeadPlusUser=0
BeadPlusPoint=1
AllowNetcafePoint=0