You last visited: Today at 21:38
Advertisement
Blackrouge Login server Connection
Discussion on Blackrouge Login server Connection within the SRO Private Server forum part of the Silkroad Online category.
01/08/2012, 15:29
#1
elite*gold: 0
Join Date: Jul 2011
Posts: 1,189
Received Thanks: 531
Blackrouge Login server Connection
So iv been trying to get the br files working for like a day now. iv fixed all the visible errors (regions,events,procedures,schedules,etc) and still i get c7
List of things i tried
-cert what came with the release
-vsro cert
-chcert
-changing shard services
-changing locals(content id) (22,38,37)
-changing connection types(hamachi,local,sub-domain)
but still no progress and stuck at login screen.
could someone help me please ?
01/08/2012, 17:09
#2
elite*gold: 0
Join Date: Nov 2010
Posts: 132
Received Thanks: 9
help me xd
01/08/2012, 17:35
#3
elite*gold: 0
Join Date: Dec 2011
Posts: 1,121
Received Thanks: 1,320
Easy, run this querry;
note: change BR_AccountTest to your account db name.
Code:
USE [BR_AccountTest]
GO
/****** Object: StoredProcedure [dbo].[_CertifyTB_User] Script Date: 12/28/2011 18:22:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- 4. ALTER PROCEDURE _CertifyTB_User
ALTER PROCEDURE [dbo].[_CertifyTB_User]
@szUserID varchar(25),
@szPassword varchar(50)
AS
if exists (
select
''
from _Punishment with ( nolock )
where SerialNo = (
select
max( SerialNo ) from _BlockedUser with ( nolock )
where UserJID = ( SELECT JID FROM TB_User WHERE StrUserID = @szUserID ) and
Type = 99 and getdate() between timeBegin and timeEnd ) )
begin
select convert( tinyint, 3), ( select JID from TB_User where StrUserID = @szUserID ), convert( tinyint, 0), convert( tinyint, 0)
return
end
if exists (select 1 from TB_User where StrUserID=@szUserID and block=1 and expired>=GETDATE())
begin
select convert( tinyint, 3), ( select JID from TB_User where StrUserID = @szUserID ), convert( tinyint, 0), convert( tinyint, 0)
return
end
declare @nUserJID int
declare @sec_primary tinyint
declare @sec_content tinyint
set @nUserJID = 0
set @sec_primary = 0
set @sec_content = 0
-- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- ?????? ?????????? ???????? ??????
declare @ApplyType tinyint
declare @AccPlayTime int
declare @LatestUpdateTime_ToPlayTime int
set @ApplyType = 0 -- ?????? ?????????? ???????? ?????????? ???????? ???? ?????????? ???? ??????
set @AccPlayTime = 0
set @LatestUpdateTime_ToPlayTime = 0
-- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- ?????? ?????? ???? ????
-- select @nUserJID = JID, @sec_primary = sec_primary, @sec_content = sec_content from TB_User
SELECT @nUserJID = JID, @sec_primary = sec_primary, @sec_content = sec_content
, @AccPlayTime = AccPlayTime, @LatestUpdateTime_ToPlayTime = LatestUpdateTime_ToPlayTime FROM TB_User
WHERE StrUserID = @szUserID and password = @szPassword
--and AT=1
-- Edit For fatigue system
-- Please, fill value to @ApplyType ( 1 : TEEN USER , 2 : ADULT USER ) from your web database
-- ex ) @ApplyType = exec web.proc.certify
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)
--select convert( tinyint, 1), convert( int, 0), convert( tinyint, 0), convert( tinyint, 0), convert(tinyint, 0), convert(int, 0), convert(int, 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)
--select convert( tinyint, 3), @nUserJID, convert( tinyint, 0), convert( tinyint, 0), convert(tinyint, 0), convert(int, 0), convert(int, 0)
return
end
-- ?????? ?????? ???? ????
select convert(tinyint, 0), @nUserJID, @sec_primary, @sec_content
--select convert(tinyint, 0), @nUserJID, @sec_primary, @sec_content, @ApplyType, @AccPlayTime, @LatestUpdateTime_ToPlayTime
return
I'm almost able to enter ingame, but when I create a char it says invaild char name. If you know why please share
01/08/2012, 17:41
#4
elite*gold: 0
Join Date: Oct 2010
Posts: 177
Received Thanks: 108
Quote:
Originally Posted by
Shifty*
Easy, run this querry;
note: change BR_AccountTest to your account db name.
Code:
USE [BR_AccountTest]
GO
/****** Object: StoredProcedure [dbo].[_CertifyTB_User] Script Date: 12/28/2011 18:22:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- 4. ALTER PROCEDURE _CertifyTB_User
ALTER PROCEDURE [dbo].[_CertifyTB_User]
@szUserID varchar(25),
@szPassword varchar(50)
AS
if exists (
select
''
from _Punishment with ( nolock )
where SerialNo = (
select
max( SerialNo ) from _BlockedUser with ( nolock )
where UserJID = ( SELECT JID FROM TB_User WHERE StrUserID = @szUserID ) and
Type = 99 and getdate() between timeBegin and timeEnd ) )
begin
select convert( tinyint, 3), ( select JID from TB_User where StrUserID = @szUserID ), convert( tinyint, 0), convert( tinyint, 0)
return
end
if exists (select 1 from TB_User where StrUserID=@szUserID and block=1 and expired>=GETDATE())
begin
select convert( tinyint, 3), ( select JID from TB_User where StrUserID = @szUserID ), convert( tinyint, 0), convert( tinyint, 0)
return
end
declare @nUserJID int
declare @sec_primary tinyint
declare @sec_content tinyint
set @nUserJID = 0
set @sec_primary = 0
set @sec_content = 0
-- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- ?????? ?????????? ???????? ??????
declare @ApplyType tinyint
declare @AccPlayTime int
declare @LatestUpdateTime_ToPlayTime int
set @ApplyType = 0 -- ?????? ?????????? ???????? ?????????? ???????? ???? ?????????? ???? ??????
set @AccPlayTime = 0
set @LatestUpdateTime_ToPlayTime = 0
-- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- ?????? ?????? ???? ????
-- select @nUserJID = JID, @sec_primary = sec_primary, @sec_content = sec_content from TB_User
SELECT @nUserJID = JID, @sec_primary = sec_primary, @sec_content = sec_content
, @AccPlayTime = AccPlayTime, @LatestUpdateTime_ToPlayTime = LatestUpdateTime_ToPlayTime FROM TB_User
WHERE StrUserID = @szUserID and password = @szPassword
--and AT=1
-- Edit For fatigue system
-- Please, fill value to @ApplyType ( 1 : TEEN USER , 2 : ADULT USER ) from your web database
-- ex ) @ApplyType = exec web.proc.certify
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)
--select convert( tinyint, 1), convert( int, 0), convert( tinyint, 0), convert( tinyint, 0), convert(tinyint, 0), convert(int, 0), convert(int, 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)
--select convert( tinyint, 3), @nUserJID, convert( tinyint, 0), convert( tinyint, 0), convert(tinyint, 0), convert(int, 0), convert(int, 0)
return
end
-- ?????? ?????? ???? ????
select convert(tinyint, 0), @nUserJID, @sec_primary, @sec_content
--select convert(tinyint, 0), @nUserJID, @sec_primary, @sec_content, @ApplyType, @AccPlayTime, @LatestUpdateTime_ToPlayTime
return
I'm almost able to enter ingame, but when I create a char it says invaild char name. If you know why please share
use this abusefilter txt.
Attached Files
abusefilter.txt
(343.3 KB, 28 views)
01/08/2012, 17:42
#5
elite*gold: 0
Join Date: Oct 2010
Posts: 177
Received Thanks: 108
and anbody knows that when i reached upper level 7 in game,client closing.what is the problem?
01/08/2012, 17:49
#6
elite*gold: 0
Join Date: Nov 2010
Posts: 132
Received Thanks: 9
FCK
what this error pls share ur files BROO ????????
PLS BRO Share Ur Files or certt .s
01/08/2012, 17:56
#7
elite*gold: 0
Join Date: Oct 2010
Posts: 177
Received Thanks: 108
Quote:
Originally Posted by
kanka5252
FCK
what this error pls share ur files BROO ????????
PLS BRO Share Ur Files or certt .s
man use elitesro 1.037 client
here my cert files dont forget to change shardid to 22 and shardservice to 64.
Attached Files
Certification.rar
(64.4 KB, 30 views)
01/08/2012, 17:58
#8
elite*gold: 0
Join Date: Nov 2010
Posts: 132
Received Thanks: 9
MErtcoskun private msj atda ordan konusalm.
01/08/2012, 18:16
#9
elite*gold: 0
Join Date: Oct 2009
Posts: 206
Received Thanks: 69
when i try creat new char my client close anyone know why?
01/08/2012, 18:32
#10
elite*gold: 0
Join Date: May 2010
Posts: 385
Received Thanks: 77
anyone has got clean 2005 databases? i have 2008 databases.Or can anyone convert for me because i dont have sql 2008
01/08/2012, 18:39
#11
elite*gold: 0
Join Date: Nov 2010
Posts: 132
Received Thanks: 9
c8 error help pls.
Hey How Fix C8 Error ? Help me.
01/08/2012, 18:52
#12
elite*gold: 0
Join Date: Dec 2011
Posts: 1,121
Received Thanks: 1,320
Wrong content id'
01/08/2012, 18:56
#13
elite*gold: 0
Join Date: May 2010
Posts: 1,075
Received Thanks: 388
thanks
-msg2short-
01/08/2012, 18:56
#14
elite*gold: 0
Join Date: May 2010
Posts: 385
Received Thanks: 77
Quote:
Originally Posted by
Shifty*
Wrong content id'
dude can you send me clean blackrogue sql 2005 databases?I dont have sql 2008r2
01/08/2012, 19:00
#15
elite*gold: 0
Join Date: Dec 2011
Posts: 1,121
Received Thanks: 1,320
I dont have 2005 lol
btw: Anyone knows why I get instant dc when i logg on? I think its something with billingserver but not sure:
Similar Threads
Connection Lost, Failed to Login: Bad login
09/07/2011 - Minecraft - 10 Replies
Howdy,
Ich habe in letzter immer wieder das Problem dass ich mich nicht auf dem Server einloggen kann auf dem ich derzeit spiele.
Manchmal gehts, manchmal gehts wieder wenn ich ein wenig warte.
Falls es nicht geht bekomme ich die Meldung:
"
Connection Lost
Failed to login: Bad login
"
Jemand ne Ahnung woran das liegen könnte?
[HELP]Connection BTW Login And GameServer
04/04/2011 - SRO Coding Corner - 6 Replies
hello ok so like you know from my past post i fix with kevin help the packet error thank your kevin ;)
but now after i changed part of importent gameserver and full loginserver
packet i try to login the game loginserver start and i get the silkroad client to work
now when i enter id and pw nothing happan no error's in console
can somebody explain me what packet make this problem?:)
Login Error Connection to Auth (Timeout)
09/28/2010 - S4 League - 1 Replies
I tried logging into m account and each time its get stuck on Connecting
then it goes to Connection to Auth (Timeout)
Can anyone explain what this is?
[Fix Problem]TQ Binarys Problem Connection Server Account And Server Login
04/07/2009 - CO2 Private Server - 0 Replies
Hello All ,,
At Last I Found Way For Who Setup TQ Binarys 5065-5089
And Follow Soem Guide Words By Words And Have
Problem Connection Server Account And Server Login
This Problem With 50% off Members
It's In Ports 9865,9958,9960,8653
And i will lern all how to open this ports in easy guide
And Hope Help Full Guide
Here Guide With Images But Sorry if i bad in English
All times are GMT +2. The time now is 21:38 .