Blackrouge Login server Connection

Page 2 of 2

01/08/2012 18:01 kanka5252#16

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 18:02 18andLife#17

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:
[Only registered and activated users can see links. Click Here To Register...]

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 18:03 Shifty*#18

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 18:11 mertcoskun#19

yes finished now;)

[Only registered and activated users can see links. Click Here To Register...]

Uploaded with [Only registered and activated users can see links. Click Here To Register...]

01/08/2012 18:22 twins45#20

Quote:

Originally Posted by mertcoskun

yes finished now;)

[Only registered and activated users can see links. Click Here To Register...]

Uploaded with [Only registered and activated users can see links. Click Here To Register...]

Bro do you use sql 2008 r2 or sql 2005 tell me please :)

01/08/2012 18:25 mertcoskun#21

sql 2008 r2 man^^

01/08/2012 19:08 ✗EpicSoul✗#22

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 19:13 xBongosx#23

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 19:38 kanka5252#24

i getting dc al time from NPROTECT someone can without nprotect from agent server ?

01/08/2012 20:45 Shifty*#25

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 21:37 ✗EpicSoul✗#26

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

Page 2 of 2