T-Point stored procedure!

VizesLufi · Jun 2, 2013

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 :/

toast2250 · Jun 3, 2013

I think that this procedure does not exist.

There is stuff missing for the ingame Tpoint selling currency.
If I'm guessing correctly, there were no such working features on the official at that time.

y0cata · Jun 3, 2013

try to create empty procedure called "TPoint_InsertPointShopLog" and test what happens. There is a lot of missing things in the db's they are probably from ep6,7 and they guy who released them added some ep8 tables and procedures but there is sill missing and bugged tings in the db's.

toast2250 · Jun 11, 2013

Empty procedure,

Code:

[Fri Jun  7 2013 09:54:52.469567 3013217168]: [##ERROR##] User(2), Event(2), Type(1) : OnIPCNPCAction fail
[Fri Jun  7 2013 09:54:52.469626 3013217168]: [##ERROR##] DB ERROR(MSG)      : [FreeTDS][SQL Server]Procedure TPoint_InsertPointShopLog has no parameters and arguments were supplied.
[Fri Jun  7 2013 09:54:52.469642 3013217168]: [##ERROR##] DB ERROR(CODE)     : 8146
[Fri Jun  7 2013 09:54:52.469656 3013217168]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Fri Jun  7 2013 09:54:52.469669 3013217168]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Fri Jun  7 2013 09:54:52.469683 3013217168]: [##ERROR##] DB ERROR(STM_TEXT) : {call dbo.TPoint_InsertPointShopLog(?          , ?          , ?          , ?          , ?          )}
[Fri Jun  7 2013 09:54:52.476448 3013217168]: Database Connect success!

I then tried,

Code:

USE [NetcafeBilling]
GO
/****** Object:  StoredProcedure [dbo].[TPoint_InsertPointShopLog]    Script Date: 06/11/2013 16:06:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Name
-- Create date: 
-- Description:	
-- =============================================
ALTER PROC [dbo].[TPoint_InsertPointShopLog] 
@UserNum int, 
@ItemIdx int, 
@ItemOption int, 
@ItemDuration int, 
@Point int
as

insert into PointShopLog
(UserNum, ItemIdx, ItemOption, ItemDuration, Point)
values
(@UserNum, @ItemIdx, @ItemOption, @ItemDuration, @Point)

Then after I get,

Code:

[Fri Jun  7 2013 09:58:56.343915 3023707024]: [##ERROR##] User(2), Event(2), Type(1) : OnIPCNPCAction fail
[Fri Jun  7 2013 09:58:56.343955 3023707024]: [##ERROR##] DB ERROR(MSG)      : [FreeTDS][SQL Server]Invalid cursor state
[Fri Jun  7 2013 09:58:56.343963 3023707024]: [##ERROR##] DB ERROR(CODE)     : 0
[Fri Jun  7 2013 09:58:56.343970 3023707024]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Fri Jun  7 2013 09:58:56.343977 3023707024]: [##ERROR##] DB ERROR(SQLSTATE) : 24000
[Fri Jun  7 2013 09:58:56.343984 3023707024]: [##ERROR##] DB ERROR(STM_TEXT) : {call dbo.TPoint_InsertPointShopLog(?          , ?          , ?          , ?          , ?          )}
[Fri Jun  7 2013 09:58:56.349149 3023707024]: Database Connect success!

Im not good at this at all,..

:

y0cata · Jun 11, 2013

i think the server send to SP 3 parameters and SP need to return 5 parameters to the server. if i have time i will try to make working SP.

PwrDex · Jun 12, 2013

Code:

SELECT TOP 1000 [PointIdx]
      ,[PointType]
      ,[PointItemCD]
      ,[PointChargeCD]
      ,[Point]
      ,[UserNum]
      ,[RegDate]
      ,[RegDateTime]
      ,[ItemIdx]
      ,[ItemOption]
      ,[ItemDuration]
  FROM [NetCafeBilling].[dbo].[PointShopLog]

This give an error because [PointItemCD] and [PointChargeCD] time not setted. This values (in EU T-Shop..) equal with each item has limited to buy! Here need set the dates and i think so will work...

toast2250 · Jun 12, 2013

I gues that the PointShopLog fills correctly now except for the Point Type/itemCD/ChargeCD.

Code:

USE [NetcafeBilling]
GO
/****** Object:  StoredProcedure [dbo].[TPoint_InsertPointShopLog]    Script Date: 06/11/2013 16:06:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        Name
-- Create date: 
-- Description:   
-- =============================================
ALTER PROC [dbo].[TPoint_InsertPointShopLog] 
@ItemIdx int,
@ItemOption int, 
@ItemDuration int, 
@Point int, 
@UserNum int
as

insert into PointShopLog
(ItemIdx, ItemOption, ItemDuration, Point, UserNum)
values
(@ItemIdx, @ItemOption, @ItemDuration, @Point, @UserNum)

Code:

PointIdx	PointType	PointItemCD	PointChargeCD	Point	UserNum	RegDate	RegDateTime	ItemIdx	ItemOption	ItemDuration
1	NULL	NULL	NULL	4	2	20130612	2013-06-12 15:04:21.210	8	33	3

User: 2 PointPrice: 4
Item ID: 8 - MP Potion (Lv. 3) option 33 duration 3

It still gives the, Invalid cursor state.

Adding more then 5 rows gives,

Code:

[Fri Jun  7 2013 14:13:40.566463 3033537424]: [##ERROR##] User(2), Event(2), Type(1) : OnIPCNPCAction fail
[Fri Jun  7 2013 14:13:40.566477 3033537424]: [##ERROR##] DB ERROR(MSG)      : [FreeTDS][SQL Server]Procedure or function 'TPoint_InsertPointShopLog' expects parameter '@PointType', which was not supplied.
[Fri Jun  7 2013 14:13:40.566485 3033537424]: [##ERROR##] DB ERROR(CODE)     : 201
[Fri Jun  7 2013 14:13:40.566492 3033537424]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Fri Jun  7 2013 14:13:40.566499 3033537424]: [##ERROR##] DB ERROR(SQLSTATE) : 42000
[Fri Jun  7 2013 14:13:40.566505 3033537424]: [##ERROR##] DB ERROR(STM_TEXT) : {call dbo.TPoint_InsertPointShopLog(?          , ?          , ?          , ?          , ?          )}
[Fri Jun  7 2013 14:13:40.573996 3033537424]: Database Connect success!

magraopb · Jun 12, 2013

what log level you are using, because here don't show any error like your

toast2250 · Jun 12, 2013

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

and EventType 5 in cabal_ems_event_table.
pcbang log lvl3.

magraopb · Jun 12, 2013

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

and EventType 5 in cabal_ems_event_table.
pcbang log lvl3.

-after that, i can't click on NPC, when click not happens.
-if don't insert NPC into Event.scp i can click him

toast2250 · Jun 12, 2013

Then try adding the selling item to Yul NPC.

I read on google that Invalid cursor state means that it cant retrieve something properly from the DB.

magraopb · Jun 12, 2013

toast2250 said:
Then try adding the selling item to Yul NPC.

I read on google that Invalid cursor state means that it cant retrieve something properly from the DB.

My NPC YUL already Works fine, i have said about T-Point

EDIT:
Event.scp

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

if EventType in cabal_ems_event_table = 5 ( when NPC is clicked, nothing happens)
if EventType in cabal_ems_event_table = 2 ( when NPC is clicked, i can see popup normal, but nothing is registred)

with this two methodes, my logs are clean, no errors

toast2250 · Jun 12, 2013

When you have manually set up the event serial, gui type, npc and Tpoint price for the chosen Item you will notice it wont work because of missing procedures in particular and maybe some other stuff.

You can sell Tpoint price based items at any NPC, if you get it to work that is.

Errors are good, for once I would love to have more of them for better understanding.

:

Maybe some one else will be interested and the posted above will be of some help in a way.

magraopb · Jun 12, 2013

can you show me what tables you change to it pre-work?
i'll trying to do procedure works

toast2250 · Jun 12, 2013

Sure,
http://forum.ragezone.com/attachments/f451/132330d1371066181-t-point-stored-procedure-tpoi6.jpg

magraopb · Jun 12, 2013

Thanks dude, i'll try tonight, because for now i'm going to college, i'll be back here to do feedback about my progress

magraopb · Jun 16, 2013

like i said before, here my progress logs.

@toast,
My EventData - cabal_ems_event_table, have not a column called [Option] like you do in your, but works normally.
my TPoint is '0'.
i'll try to do some modifications now

1256 - is my TPoint Event

My procedure according Table

USE [NetcafeBilling]
GO
/****** Object: StoredProcedure [dbo].[TPoint_InsertPointShopLog] Script Date: 06/11/2013 16:06:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: Name
-- Create date:
-- Description:
-- =============================================
ALTER PROC [dbo].[TPoint_InsertPointShopLog]
@Point int,
@UserNum int,
@ItemIdx int,
@ItemOption int,
@ItemDuration int
as

insert into PointShopLog
(Point, UserNum, ItemIdx, ItemOption, ItemDuration)
values
(@UserNum, @ItemIdx, @ItemOption, @ItemDuration, @Point)

EventMgrSvr

[Sun Jun 16 2013 16:25:24.808794 3086760848]: Event(1256) Start.
[Sun Jun 16 2013 16:25:24.808870 3086760848]: Event(1255) Start.
[Sun Jun 16 2013 16:25:24.808892 3086760848]: Event(1254) Start.

PCBangDBAgent

[Sun Jun 16 2013 16:27:14.628156 3023006608]: Database Connect success!
[Sun Jun 16 2013 16:27:15.253715 3023006608]: [##ERROR##] User(1), Event(1256), Type(1) : OnIPCNPCAction fail
[Sun Jun 16 2013 16:27:15.253763 3023006608]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]Invalid cursor state
[Sun Jun 16 2013 16:27:15.253776 3023006608]: [##ERROR##] DB ERROR(CODE) : 0
[Sun Jun 16 2013 16:27:15.253789 3023006608]: [##ERROR##] DB ERROR(VAR_INFO) :
[Sun Jun 16 2013 16:27:15.253802 3023006608]: [##ERROR##] DB ERROR(SQLSTATE) : 24000
[Sun Jun 16 2013 16:27:15.253818 3023006608]: [##ERROR##] DB ERROR(STM_TEXT) : {call dbo.TPoint_InsertPointShopLog(? , ? , ? , ? , ? )}

WorldSvr_01_01

[Sun Jun 16 2013 16:27:15.262615 2818517904]: [##ERROR##] pITSRequest->result is raised in OnITCEMSNPCAction() (Proc/EMS.cpp:368

i dont got any errors with this command, just null Dates

DeXtR said:
Code:

SELECT TOP 1000 [PointIdx] ,[PointType] ,[PointItemCD] ,[PointChargeCD] ,[Point] ,[UserNum] ,[RegDate] ,[RegDateTime] ,[ItemIdx] ,[ItemOption] ,[ItemDuration] FROM [NetCafeBilling].[dbo].[PointShopLog]

This give an error because [PointItemCD] and [PointChargeCD] time not setted. This values (in EU T-Shop..) equal with each item has limited to buy! Here need set the dates and i think so will work...

points - T-Point stored procedure! - RaGEZONE Forums

youyou · Jun 22, 2013

Did someone successful?

I created a procedure. It may be imperfect, but it seems to be working.
If you do not yet succeeded, then I will post later.

magraopb · Jun 22, 2013

i don't finish yet, i'm trying... just some success, if you want to share your progress will be good.
my progress be like toast, but with original DB, haven't a column called [Option]

youyou · Jun 22, 2013

TPoint_InsertPointShopLog

Code:

USE [NetcafeBilling]
GO
/****** Object:  StoredProcedure [dbo].[TPoint_InsertPointShopLog]    Script Date: 06/21/2013 22:21:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        Name
-- Create date: 
-- Description:   
-- =============================================
ALTER 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

Cabal - T-Point stored procedure! - RaGEZONE Forums

Welcome!

T-Point stored procedure!

Newbie Spellweaver

RaGEZONER

Junior Spellweaver

RaGEZONER

Junior Spellweaver

PwrGames

RaGEZONER

Mythic Archon

RaGEZONER

Mythic Archon

RaGEZONER

Mythic Archon

RaGEZONER

Attachments

Mythic Archon

RaGEZONER

Attachments

Mythic Archon

Mythic Archon

Attachments

Newbie Spellweaver

Mythic Archon

Newbie Spellweaver

Attachments

About Us

Online statistics

Forum statistics

RaGEZONE Sponsor