-
Member
Could you help This is the Error: Failed to connect to Server(c8).
I need Help, have a new Error, cant connect.
This is the Error: Failed to connect to Server(c8).
On my Firewall i open tcp port 15779 and 15780.
First Try:
Gateway : [GatewaySvr] Official IP Detected, Official IP Pass the 'In Service' Check (MY IP)
I think i cant start from the PC where the Server is, but could someone tell me why ? and maybe a solution is there :)
Second Try :
changed my IP with the IP of Hamachi, but the Game still say me, Failed to connect to Server(c8) o.O
i dont know what to do :P
with my Hamachi IP my Gateway Server says :
[GatewaySvr] Official IP Detected, Official IP Pass the 'In Service' Check (25.160.195.205)
Hmm, 1 Step out of Controll
It would be great if someone help me.
Update : I changed in the SRO_CLIENT the Content ID to 22, but in my Database the Module ncontent is 47... now change to 22 in the database and the GatewayServer give me this Error :
Query Error!!! Query Result : -1, Query : exec _CertifyTB_User 'myID','myPW'
HMM, Somethink wrong or -.- :P
Unstable ServerCondition(3)
And now its not (c8)error, now its (c7)error :P
UPDATE!!! ERROR FOUND :)
HERE IS THE CODE :) ONLY UPDATE DATABASE
USE [SILK_BILLMAN]
GO
/****** Object: StoredProcedure [dbo].[_CertifyTB_User] Script Date: 01/01/2014 18:04:24 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[_CertifyTB_User]
@szUserID varchar(25),
@szPassword varchar(50)
AS
declare @NuserJID int
declare @sec_primary tinyint
declare @sec_content tinyint
set @NuserJID = 0
set @sec_primary = 0
set @sec_content = 0
select @NuserJID = JID, @sec_primary = sec_primary, @sec_content = sec_content from TB_User
where StrUserID = @szUserID and password = @szPassword
if( @NuserJID = 0 or @NuserJID is null or @@error <> 0 or @@rowcount = 0)
begin
select convert( tinyint, 1), convert( int, 0), convert( tinyint, 0), convert( tinyint, 0)
return
end
if( exists( select Type from _BlockedUser where UserJID = @NuserJID and Type = 1 and getdate() between timeBegin and timeEnd))
begin
select convert( tinyint, 3), @NuserJID, convert( tinyint, 0), convert( tinyint, 0)
return
end
select convert(tinyint, 0), @NuserJID, @sec_primary, @sec_content
return
Last edited by Shakugan; 09-07-15 at 07:45 AM.
-