|
You last visited: Today at 09:18
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, 19:01
|
#16
|
elite*gold: 0
Join Date: Nov 2010
Posts: 132
Received Thanks: 9
|
Quote:
Originally Posted by Shifty*
Wrong content id'
|
how i can change media.pk2 content id. my content id 22 media.pk2 38 i need change media.pk2 content id 38 -> 22 .d
|
|
|
01/08/2012, 19:02
|
#17
|
elite*gold: 0
Join Date: Apr 2010
Posts: 1,988
Received Thanks: 1,783
|
Quote:
Originally Posted by Shifty*
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:
|
billing
Quote:
Originally Posted by kanka5252
how i can change media.pk2 content id. my content id 22 media.pk2 38 i need change media.pk2 content id 38 -> 22 .d
|
lulz.
|
|
|
01/08/2012, 19:03
|
#18
|
elite*gold: 0
Join Date: Dec 2011
Posts: 1,121
Received Thanks: 1,320
|
Quote:
Originally Posted by 18andLife
billing
lulz.
|
I know it's billing, but the db connection thing is right so is the configuration in server.cfg
|
|
|
01/08/2012, 19:11
|
#19
|
elite*gold: 0
Join Date: Oct 2010
Posts: 177
Received Thanks: 108
|
yes finished now
Uploaded with
|
|
|
01/08/2012, 19:22
|
#20
|
elite*gold: 0
Join Date: May 2010
Posts: 385
Received Thanks: 77
|
Quote:
Originally Posted by mertcoskun
yes finished now
Uploaded with
|
Bro do you use sql 2008 r2 or sql 2005 tell me please
|
|
|
01/08/2012, 19:25
|
#21
|
elite*gold: 0
Join Date: Oct 2010
Posts: 177
Received Thanks: 108
|
sql 2008 r2 man^^
|
|
|
01/08/2012, 20:08
|
#22
|
elite*gold: 0
Join Date: Jul 2011
Posts: 1,189
Received Thanks: 531
|
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
|
after i did this query my server is stuck in check any idea ?
|
|
|
01/08/2012, 20:13
|
#23
|
elite*gold: 0
Join Date: Oct 2009
Posts: 1,287
Received Thanks: 421
|
I Getting Invalid Character Name when try to make char.
And i can't log in by GM account (i add my Ip ofc)
|
|
|
01/08/2012, 20:38
|
#24
|
elite*gold: 0
Join Date: Nov 2010
Posts: 132
Received Thanks: 9
|
i getting dc al time from NPROTECT someone can without nprotect from agent server ?
|
|
|
01/08/2012, 21:45
|
#25
|
elite*gold: 0
Join Date: Dec 2011
Posts: 1,121
Received Thanks: 1,320
|
Quote:
Originally Posted by ✗EpicSoul✗
after i did this query my server is stuck in check any idea ?
|
Don't forget to turn on all of the services in SMC.
|
|
|
01/08/2012, 22:37
|
#26
|
elite*gold: 0
Join Date: Jul 2011
Posts: 1,189
Received Thanks: 531
|
Quote:
Originally Posted by Shifty*
Don't forget to turn on all of the services in SMC.
|
i have,, but if there is another way tell me please ??
|
|
|
|
|
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 09:18.
|
|