T-Point stored procedure!

done , working now*xD

Quote:

---

Originally Posted by youyou

TPoint_InsertPointShopLog

---

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

Ontopic,
Thank you so much youyou,:thumbup:
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:

Code:

---

cabal_tool_SetTPoint
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

cabal_tool_GetTPoint
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. :D:

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...ml#post7571663

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

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

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

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

Edit :

cabal_ems_event_item_table

last column , texture itemidx :P

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.

all items are red if haven't requirements

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

If someone could help me thank you too

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

If someone could help me thank you too

fix..

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

look for world setting

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