Help Error gameserver

[Kundalini]

Hi I post an image with my error


gameserver give me this error when i log my char in the game...
someone can help my?

[ismokedrow]

One might think to open the SMP check_purchased_item and then one might even go further to look for dbo.Billing which is reference several times in that smp. But what's this it asks for dbo.billing.paiditem. Woah, if one would look in the structure of Telecaster one might notice that dbo.PaidItem or dbo.Billing.PaidItem does not exist. Hmn, one may then create such a table in theory and it would work..

or...

There's this really crazy option, you could just use the newer databases from the 7.3 Game Server thread which already contain this fix. But that would just be insane wouldn't it?

[Kundalini]

Originally Posted by ismokedrow

There's this really crazy option, you could just use the newer databases from the 7.3 Game Server thread which already contain this fix. But that would just be insane wouldn't it?

To start thanks so much for reply.. then can u link me the topic when is this newer databases? so that I can try thanks again

*EDIT
Another error now.... Why ?_?

[q8wars]

ALTER PROCEDURE [dbo].[smp_check_purchased_item]
@IN_ACCOUNT_ID			INT,
@IN_CHARACTER_ID		INT,
@OUT_TOTAL_ITEM_COUNT	INT		OUTPUT,
@OUT_NEW_ITEM_COUNT		INT		OUTPUT,
@OUT_PREMIUM_TICKET		INT		OUTPUT,
@OUT_PREMIUM_REST_TIME	INT		OUTPUT,
@OUT_STAMINA_REGEN_TIME	INT		OUTPUT

 
AS
SET NOCOUNT ON
SELECT 1

this will not fix the problem ^^ but u will not got any error

[ismokedrow]

I will not tell you how to use the following, if you can't grasp it then honestly you should stop trying. Just copy, paste and execute. In order:

FIRST: - SMP

 Spoiler

USE [Arcadia]
GO
/****** Object:  StoredProcedure [dbo].[smp_check_purchased_item]    Script Date: 04/14/2012 07:26:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- smp_read_purchased_item_list

-- start of smp_check_purchased_item   캐쉬템 창고에 아이템 있는지 여부 검사
CREATE PROCEDURE [dbo].[smp_check_purchased_item]
@IN_ACCOUNT_ID			INT,
@IN_CHARACTER_ID		INT,
@OUT_TOTAL_ITEM_COUNT	INT		OUTPUT,
@OUT_NEW_ITEM_COUNT		INT		OUTPUT,
@OUT_PREMIUM_TICKET		INT		OUTPUT,
@OUT_PREMIUM_REST_TIME	INT		OUTPUT,
@OUT_STAMINA_REGEN_TIME	INT		OUTPUT

 
AS
SET NOCOUNT ON

SET @OUT_PREMIUM_TICKET  = 0
SET @OUT_PREMIUM_REST_TIME = 0
SET @OUT_STAMINA_REGEN_TIME = 0

SELECT @OUT_PREMIUM_TICKET = COUNT(*), @OUT_PREMIUM_REST_TIME = DATEDIFF( second, GETDATE(), MAX( valid_time ) ) FROM dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code = 910000 AND valid_time > GETDATE() AND isCancel = 0

IF @OUT_PREMIUM_TICKET < 1
BEGIN
	SET @OUT_PREMIUM_REST_TIME = 0

	DECLARE @LOGOUT_TIME		DATETIME
	SET @LOGOUT_TIME = GETDATE()

	SELECT @LOGOUT_TIME = logout_time FROM Character WITH (NOLOCK) WHERE account_id = @IN_ACCOUNT_ID AND sid = @IN_CHARACTER_ID
	SELECT @OUT_STAMINA_REGEN_TIME = DATEDIFF( minute, @LOGOUT_TIME, MAX( valid_time ) ) FROM dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code = 910000 AND valid_time > @LOGOUT_TIME AND isCancel = 0

	IF @OUT_STAMINA_REGEN_TIME < 1 OR @OUT_STAMINA_REGEN_TIME IS NULL
	BEGIN
		SET @OUT_STAMINA_REGEN_TIME = 0
	END


	--DECLARE @NO_LV INT
	--DECLARE @NO_Total_JP INT
	--SELECT @NO_LV = MAX(lv), @NO_Total_JP = MAX(total_jp) from character WITH(NOLOCK) WHERE account_id = @IN_ACCOUNT_ID AND Name not like '@%'

	--IF  @NO_LV < 30 AND @NO_Total_JP < 100000
	--BEGIN
	--SET @OUT_PREMIUM_TICKET  = 1
	--SET @OUT_PREMIUM_REST_TIME = 3600 * 5
	--END

END

--IF  @OUT_PREMIUM_REST_TIME < 3600 * 5
--BEGIN
	
	--DECLARE @LV INT
	--DECLARE @Total_JP INT
	--SELECT @LV = MAX(lv), @Total_JP = MAX(total_jp) from character WITH(NOLOCK) WHERE account_id = @IN_ACCOUNT_ID AND Name not like '@%'

	--IF  @LV < 30 AND @Total_JP < 100000
	--BEGIN
	--SET @OUT_PREMIUM_TICKET  = 1
	--SET @OUT_PREMIUM_REST_TIME = 3600 * 5
	--END
--END

SELECT @OUT_TOTAL_ITEM_COUNT = COUNT(*) from dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND rest_item_count > 0 AND item_code <> 910000 AND isCancel = 0
SELECT @OUT_NEW_ITEM_COUNT   = COUNT(*) from dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND rest_item_count > 0 AND item_code <> 910000 AND confirmed = 0 AND isCancel = 0

RETURN @@ERROR

SECOND: - PaidItem

 Spoiler

USE [Arcadia]
GO

/****** Object:  Table [dbo].[PaidItem]    Script Date: 04/14/2012 07:29:35 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[PaidItem](
	[sid] [int] IDENTITY(1,1) NOT NULL,
	[account_id] [int] NULL,
	[avatar_id] [int] NULL,
	[avatar_name] [varchar](61) NULL,
	[item_code] [int] NULL,
	[item_count] [int] NULL,
	[rest_item_count] [int] NULL,
	[bought_time] [datetime] NULL,
	[valid_time] [datetime] NULL,
	[server_name] [varchar](30) NULL,
	[taken_avatar_id] [int] NULL,
	[taken_avatar_name] [varchar](61) NULL,
	[taken_server_name] [varchar](30) NULL,
	[taken_time] [datetime] NULL,
	[taken_account_id] [int] NULL,
	[confirmed] [int] NULL,
	[confirmed_time] [date] NULL,
	[isCancel] [int] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

Good luck. I will not be providing any further assistance with this matter.

[msmithnova]

Put both of these in. Executed successfully. Also put N log.working:0 in gameserver.opt and did the compress thing. Still get the dbo.smp_check_purchase_item problem, the cannot connect to server: try again later and the skill bars not saving when T game.cash_usable_server:1 to make npcs work.

Figured it out. Thanks.