T-Points Shop

hi I added the npc t-points usually
not to buy most of the items
tava aki searching the forum and found this query

#############################################################

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


#############################################################
I run it and this error appears

Msg 2010, Level 16, State 1, Procedure TPoint_InsertPointShopLog, Line 38
Cannot perform alter on 'dbo.TPoint_InsertPointShopLog' because it is an incompatible object type.


could someone help me?

SOMEONE COULD HELP ME RUN THIS Procedure?
SO THAT IS MISSING

I restored the db again and add this procedure once a difference
instead of ALTER PROCEDURE [dbo]. [TPoint_InsertPointShopLog]
I put CREATE PROCEDURE [dbo]. [TPoint_InsertPointShopLog]
RAN MORE CORRECTLY AND EVEN SO I'M NOT GETTING TO BUY ITEMS SHOP T-POINT
I ALSO DID THAT THAT SPOKE Hefajstos
http://forum.ragezone.com/f460/guide...10/index7.html # post7571663

I am missing something?
PLEASE SOMEONE HELP
THANK YOU FOR YOUR ATTENTION

........................

someone for the love of god help me
to hitting me here to make this work I am most unsuccessful

have u edit event.scp in serverside?

so that

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

Explain me again, what happens to u?
U cant buy items? or u dont have any items?

I'm not getting to buy items
the message appears: Failed to buy item

U have done everything like on this screenshot?
http://forum.ragezone.com/attachment...0&d=1371066181

Hi Dens666
I did it oh yes
I'm posting my db: EventData / NetCafeBilling
http://www.4shared.com/rar/skBdbwExce/DBRG.html
if possible u could take a look, maybe I'm missing some detail
thanks for listening

................

Hi, im finish this, sent my database to compare and modify your db, to active.

all events working.


https://mega.co.nz/#!f94BHIbY!G9WE0F..._TIONMPzAzjweY

hi noexp
you are Brazilian?

I tested aki face with his eventdata netcafebillinge and still does not work the shop point t WHAT else could be missing?

................

im from brasil.

Post your logs,

and prints of your npc

hi friend
sorry but do not know how to pick up logs
Could tell me how I fasso this?

https://imageshack.com/i/kp386d75j