|
You last visited: Today at 14:57
Advertisement
[FIX] Cannot Connect To Server
Discussion on [FIX] Cannot Connect To Server within the Rappelz Private Server forum part of the Rappelz category.
07/24/2012, 16:43
|
#1
|
elite*gold: 0
Join Date: Oct 2010
Posts: 2,555
Received Thanks: 2,458
|
[FIX] Cannot Connect To Server
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
Code:
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
|
|
|
07/24/2012, 17:30
|
#2
|
elite*gold: 1
Join Date: Nov 2011
Posts: 651
Received Thanks: 104
|
Glad to see you helping people again
|
|
|
07/25/2012, 01:51
|
#3
|
elite*gold: 0
Join Date: Mar 2012
Posts: 201
Received Thanks: 23
|
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
Code:
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
|
|
|
07/25/2012, 02:39
|
#4
|
elite*gold: 0
Join Date: Nov 2011
Posts: 136
Received Thanks: 62
|
-_-
|
|
|
07/26/2012, 13:20
|
#5
|
elite*gold: 0
Join Date: Jul 2012
Posts: 64
Received Thanks: 2
|
i use this fix^^ don't work^^
the problem:
Any ideas with fix this problem?
|
|
|
07/26/2012, 19:49
|
#6
|
elite*gold: 0
Join Date: Sep 2011
Posts: 219
Received Thanks: 74
|
Check your GameServer port
|
|
|
07/26/2012, 20:01
|
#7
|
elite*gold: 0
Join Date: Jul 2012
Posts: 64
Received Thanks: 2
|
GS port? where i can check it?
4418 - not GS port?
may be it 4500?
|
|
|
07/26/2012, 20:21
|
#8
|
elite*gold: 0
Join Date: Sep 2011
Posts: 219
Received Thanks: 74
|
In your Gameserver.opt the Gameserver port is write.
S io.port:XXXX
|
|
|
07/26/2012, 22:38
|
#9
|
elite*gold: 0
Join Date: Jul 2012
Posts: 64
Received Thanks: 2
|
io.port:4418
this port already open^^
|
|
|
07/27/2012, 05:17
|
#10
|
elite*gold: 0
Join Date: Mar 2012
Posts: 201
Received Thanks: 23
|
7880 perfect
|
|
|
07/31/2012, 21:49
|
#11
|
elite*gold: 0
Join Date: Jul 2012
Posts: 3
Received Thanks: 0
|
Quote:
Originally Posted by Vake24
i use this fix^^ don't work^^
the problem:
Any ideas with fix this problem?
|
Вот идиотская школота. Ну если ты трешь имя сервера на скринах то три везде дурень!
|
|
|
08/01/2012, 22:09
|
#12
|
elite*gold: 0
Join Date: Jul 2012
Posts: 64
Received Thanks: 2
|
ахах) не в затирании дело ))))
мне както поф на это я просто так затер)
|
|
|
|
Similar Threads
|
Minecraft Hamachi Server Failed to connect to the server Connection refused connect
01/26/2012 - Minecraft - 1 Replies
Hallo zusammen,
Wir haben einen Hamachi Server, den wir für den Multiplayer Mode von Minecraft verwenden. Bis jetzt ging alles einwandfrei, doch seit heute geht nix mehr. Der Ersteller vom Hamachi Server ist zwar online, doch wenn ich in den Server in Minecraft reingehe, kommt die Fehlermeldung:
Failed to connect to the server
Connection refused: connect
Was geht da schief?
Danke im Voraus.
MfG kugelmanno
|
Minecraft Server Problem: Failed to connect to the server Connection timed out
11/27/2011 - Minecraft - 4 Replies
Hallo Leute vom elitepvpers Forum,
ich habe mal wieder ein Problem mit meinem Hamachi Minecraft Server.
Ich bin in Minecraft im Multiplayer Mode auf 'Add server' gegangen, dann habe ich unter server name von Hamachi meinen Client Name eingetragen und unter Server Address habe ich meine Hamachi Server Adresse eingegeben.
Doch wenn ich nun in den Server hineingehen will, kommt die Fehlermeldung 'Failed to connect to the server Connection timed out'.
Meine Internetverbindung ist gut.
Was...
|
All times are GMT +2. The time now is 14:57.
|
|