help BlackRogue Server files

How To Fix C7 error

Server Files : BlackRogue

Client : Elite Sro

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
here fix 7c c8 c9``

c7 Fix But now C8 :D
SMC
[Only registered and activated users can see links. Click Here To Register...]
Client
[Only registered and activated users can see links. Click Here To Register...]

show me in screenshot farmmanager

Quote:

Originally Posted by Dr.Abdelfattah show me in screenshot farmmanager

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

show me ur server.cfg and the srnodelink.ini , also what config u made in database ?

Server.cfg

Quote:

//////////////////////////////////////////////////////////////////////////////////////////// GlobalManager { Certification "5.41.66.249", 32000 Certification_IP_Bind "5.41.66.249" LoginFailureTolerance 3 IBUVFailureTolerance 3 LoginFailureBlockTimeMin 10 IBUVFailureBlockTimeMin 10 AutomatedPunisher "AutomatedPunisher" LoginPunishmentGuide "Blocked for 10 minutes due to incorrect password entered 3 times" LoginPunishmentDescription "Blocked for 10 minutes due to incorrect password entered 3 times" IBUVPunishmentGuide "Blocked for 10 minutes due to incorrect code entered 3 times" IBUVPunishmentDescription "Blocked for 10 minutes due to incorrect code entered 3 times" } GatewayServer { LastFullVersion_SR_Client 26 Certification "5.41.66.249", 15880 Certification_IP_Bind "5.41.66.249" IBUVQueueReserveCount 20000 IBUVQueuePrepareRatio 0.05 IBUVFailureIPTolerance 0 IBUVStringSize 1 IBUVCharacterSet "1234567890" } DownloadServer { Certification "5.41.66.249", 15880 } FarmManager { Certification "5.41.66.249", 15880 } AgentServer { Certification "5.41.66.249", 15882 } MachineManager { Certification "5.41.66.249", 15880 } SR_GameServer { Certification "5.41.66.249", 15882 Certification_IP_Bind "5.41.66.249" GiantMonster_SpawnRatio 1000 DropItemRatio 990 DropGoldAmountCoef 990 LOCALE LOCALE_THAILAND // for Helper mark SET_FEE_RATE "0,5,5,5" SELL_FEE_RATE "0,10,10,10" } SR_ShardManager { Certification "5.41.66.249", 15882 Certification_IP_Bind "5.41.66.249" BILLING_SERVER_URL "http://5.41.66.249:8080/" CREST_FTP_URL "" ExpRatio 1000 ExpRatioParty 1000 ExtraExpRatio 0.1 ChristmasEvent2007 0 SERVER_EVENT_SYSTEM ON LOCALE LOCALE_THAILAND FlagEvent 1 FlagEvent 1 HourForMeterRateLevelFirst 22 HourForMeterRateLevelSecond 23 BattleArenaRandom 1 ArenaMatchOccupy 1 ArenaMatchFlag 1 ArenaMatchPoint 1 }

srNodeLink

Quote:

[global] count=11 [entry0] id=1227 child_node_id=697 parent_node_id=1 p_label=0 u1=0 u2=0 u3=0 u4=0 u5=0 [entry1] id=1228 child_node_id=698 parent_node_id=697 p_label=0 u1=0 u2=0 u3=0 u4=0 u5=0 [entry2] id=1229 child_node_id=699 parent_node_id=697 p_label=0 u1=0 u2=0 u3=0 u4=0 u5=0 [entry3] id=1230 child_node_id=700 parent_node_id=697 p_label=0 u1=0 u2=0 u3=0 u4=0 u5=0 [entry4] id=1234 child_node_id=704 parent_node_id=697 p_label=1 u1=0 u2=0 u3=0 u4=0 u5=0 [entry5] id=1235 child_node_id=705 parent_node_id=704 p_label=0 u1=0 u2=0 u3=0 u4=0 u5=0 [entry6] id=1237 child_node_id=707 parent_node_id=704 p_label=1 u1=0 u2=0 u3=0 u4=0 u5=0 [entry7] id=1239 child_node_id=713 parent_node_id=704 p_label=0 u1=0 u2=0 u3=0 u4=0 u5=0 [entry8] id=1241 child_node_id=707 parent_node_id=713 p_label=1 u1=0 u2=0 u3=0 u4=0 u5=0 [entry9] id=1245 child_node_id=707 parent_node_id=705 p_label=1 u1=0 u2=0 u3=0 u4=0 u5=0 [entry10] id=1256 child_node_id=713 parent_node_id=705 p_label=0 u1=0 u2=0 u3=0 u4=0 u5=0

C8 C7 Fix Problem : Cert :)

But New Problem :) İmage

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

Right click > Unregister suspected user ?

Quote:

Originally Posted by Ninja_Stylez Right click > Unregister suspected user ?

Dont Work :(

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

uppp

Do u have privilleged ip to ur gm acc?

nProtect is Called from another Division (22)

nProtect is Called from another Division (22) ++

nProtect is Called from another Division (22)
please help