[Complete Release] BlackRogue + DB Dumps + CERTs + SMC!

[lucastx]

extract the "Abusefilter.txt" from any pk2 and put it into the serverfiles folder.

You must be registered to see links

or download this which i uploaded.

oh, was fixed with abuse, but now c8
have this error too?

 

[Ale[!]]

which client are you using?

already changed the ShardID from 214 to 64 in _ShardService at Account DB ?
already changed the content ID from the client which you are using to 22?

i'm using elitesro client.

 

[lucastx]

which client are you using?

already changed the ShardID from 214 to 64 in _ShardService at Account DB ?
already changed the content ID from the client which you are using to 22?

i'm using elitesro client.

i will try again!

 

[Bongos]

Ale! i using ur cert and server.cfg and i change Shard to 64 and ContentId to 22 but now im get C7 error liki what im getting with First Br files release so now im Out...

 

[lucastx]

Ale! i using ur cert and server.cfg and i change Shard to 64 and ContentId to 22 but now im get C7 error liki what im getting with First Br files release so now im Out...

the same error

Any know how to fix?
i get this error when i log in game
i used vsro billing but don't work

 

[TheLegend93]

2 Problems : Fk whats wrong with the Privi IP... , and i cant change the IP of the client wont work -.-

 

[ItachiSNS]

2 Problems : Fk whats wrong with the Privi IP... , and i cant change the IP of the client wont work -.-

use the xvi32 to change it...
simple as "Hello"

 

[skerdikas]

soon as i finish testing ill gonna share my cert etc if it will work

well im in game^^

looking how to change max lvl and mastery's in game server

any idea how to fix invalid char name?

 

[kralestkral]

Got mine working, how do I crack the rates? same for vsro or anything different?

 

[lucastx]

I finally fixed all, now just token timeout

 

[skerdikas]

so tell me what hell is wrong with creating new char^^

invalid char name huh

 

[kralestkral]

Well, didnt notice but I get c7 error when trying to login, any ideas?

 

[MGProjects]

when i try creat new char i got client side.. and when i log in account with char i got client side too :S

someone know how fix it?

 

[kralestkral]

Run this (Change BR_AccountTest to your account db name)
and c7 will be fixed.

Now I get the error "Invalid character name" when trying to create a char.

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

 

[skerdikas]

well anyway vsro files are way better it think

cant create char and dc when kill any mob rofl

 

[li48855784]

Good the collapse of client program, now into the character creation interface-character creation client will collapse
Should how to operate?

Sharing my configuration files for everyone can hope to help, and hope you get into the game and character creation client crash

You must be registered to see links

 

[kank52]

we need no nprotect gameserver anyone can make it ?

 

[stemale]

we need no nprotect gameserver anyone can make it ?

GameGuardMode 0

 

[Artuuro_lv]

Well.. it`s pretty easy to fix em.. c`mon artuuro are you asking my help? wtf..

When i asked yours you ignored me ..

I haven`t forgot that!

hehe, remember that i just helped everyone by sharin the stuff ^_^ so much ppl asked me to not release, even begged.. anyways c8 was the certifyuser thingie, you must add _CertifyTB_User query to your db and it'll be k ^_^

 

[Oventiful]

Cooool !!!