Code:
DB COM ERROR(Thread:2, HRESULT:80040E37, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D):DB_GetCommercialStorageInfo(dbo.smp_check_purchased_item): Invalid object name 'billing.dbo.PaidItem'.
Code:
SELECT @OUT_TOTAL_ITEM_COUNT = COUNT(*) from billing.dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code <> 910000 AND rest_item_count > 0 AND valid_time > GETDATE() AND isCancel = 0 SELECT @OUT_NEW_ITEM_COUNT = COUNT(*) from billing.dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code <> 910000 AND rest_item_count > 0 AND confirmed = 0 AND valid_time > GETDATE() AND isCancel = 0
I've fixed it by just changing the values to 1 each. Here is what my dbo.smp_check_purchased_item is:
Code:
USE [Telecaster] GO /****** Object: StoredProcedure [dbo].[smp_check_purchased_item] Script Date: 6/23/2013 11:07:14 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- smp_read_purchased_item_list -- start of smp_check_purchased_item 캐쉬템 창고에 아이템 있는지 여부 검사 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 SET @OUT_PREMIUM_TICKET = 0 SET @OUT_PREMIUM_REST_TIME = 0 SET @OUT_STAMINA_REGEN_TIME = 0 SELECT @OUT_PREMIUM_TICKET = 1 --, @OUT_PREMIUM_REST_TIME = DATEDIFF( second, GETDATE(), MAX( GETDATE()+30 ) ) /*SELECT @OUT_PREMIUM_TICKET = COUNT(*), @OUT_PREMIUM_REST_TIME = DATEDIFF( second, GETDATE(), MAX( valid_time ) ) FROM billing.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 BILLING.Billing.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 = 1 SELECT @OUT_NEW_ITEM_COUNT = 1 RETURN @@ERROR