[FIX] Cannot Connect To Server

[ismokedrow]

This is a very simple fix, I will not answer any questions. If you can't use it, ask a friend:

1) Open SSMS
2) Click "New Query"
3) Copy the below spoilers contents

 Spoiler

USE [Arcadia]
GO
/****** Object:  StoredProcedure [dbo].[smp_check_purchased_item]    Script Date: 7/24/2012 9:40:19 AM ******/
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()

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

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

RETURN @@ERROR

4) Edit USE [Arcadia] accordingly
5) Execute Query


Enjoy

[Tofrum]

Glad to see you helping people again

[AngelOwns]

Msg 156, Level 15, State 1, Procedure smp_check_purchased_item, Line 48
Incorrect syntax near the keyword 'WHERE'.
Msg 102, Level 15, State 1, Procedure smp_check_purchased_item, Line 64
Incorrect syntax near 'account_id'.
Msg 102, Level 15, State 1, Procedure smp_check_purchased_item, Line 78
Incorrect syntax near '@@ERROR'.

i try this and works

 Spoiler

USE Arcadia
GO
/****** Object:  StoredProcedure [dbo].[smp_check_purchased_item]    Script Date: 7/24/2012 

9:40:19 AM ******/
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()

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

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

RETURN @@ERROR

[5405045]

-_-

[Vake24]

i use this fix^^ don't work^^
the problem:


Any ideas with fix this problem?

[Audric123]

Check your GameServer port

[Vake24]

GS port? where i can check it?
4418 - not GS port?
may be it 4500?

[Audric123]

In your Gameserver.opt the Gameserver port is write.

S io.port:XXXX

[Vake24]

io.port:4418
this port already open^^

[AngelOwns]

7880 perfect

[nanoakaoao]

Originally Posted by Vake24

i use this fix^^ don't work^^
the problem:


Any ideas with fix this problem?

Вот идиотская школота. Ну если ты трешь имя сервера на скринах то три везде дурень!

[Vake24]

ахах) не в затирании дело ))))
мне както поф на это я просто так затер)