Official Guide Making Ran Online Episode 7 Gunner Server

[metal666]

Execution time : 2012-02-13 13:09:00
[2012-02-13 13:09:03] ERROR : GLItemMan::LoadRandomGenData(), szNAME
[2012-02-13 13:09:03] item ran option setting file load fail : szNAME
[2012-02-13 13:09:03] ERROR : GLItemMan::LoadRandomGenData(), +15armoroption.bin
[2012-02-13 13:09:03] item ran option setting file load fail : +15armoroption.bin
[2012-02-13 13:09:03] ERROR : GLItemMan::LoadRandomGenData(), +15armoroption.bin
[2012-02-13 13:09:03] item ran option setting file load fail : +15armoroption.bin
[2012-02-13 13:09:03] ERROR : GLItemMan::LoadRandomGenData(), +15armoroption.bin
[2012-02-13 13:09:03] item ran option setting file load fail : +15armoroption.bin
[2012-02-13 13:09:03] ERROR : GLItemMan::LoadRandomGenData(), +15armoroption.bin
[2012-02-13 13:09:03] item ran option setting file load fail : +15armoroption.bin
[2012-02-13 13:09:07] ERROR : SaleInvenLoadFile(), NormalScrolls.crowsale, [5,6] À§Ä¡ Áߺ¹
[2012-02-13 13:09:07] ERROR : SaleInvenLoadFile(), NormalScrolls.crowsale, [5,6] À§Ä¡ Áߺ¹
[2012-02-13 13:09:07] ERROR : SaleInvenLoadFile(), NormalScrolls.crowsale, [5,6] À§Ä¡ Áߺ¹
[2012-02-13 13:09:07] ERROR : SaleInvenLoadFile(), NormalScrolls.crowsale, [5,6] À§Ä¡ Áߺ¹
[2012-02-13 13:09:07] ERROR : SaleInvenLoadFile(), NormalScrolls.crowsale, [5,6] À§Ä¡ Áߺ¹
[2012-02-13 13:09:07] ERROR : SaleInvenLoadFile(), NormalScrolls.crowsale, [5,6] À§Ä¡ Áߺ¹
[2012-02-13 13:09:07] ERROR : SaleInvenLoadFile(), GUNscrolls.crowsale, [2,5] À§Ä¡ Áߺ¹
[2012-02-13 13:09:10] ERROR : GLMapAxisInfo::LoadFile(), w_schoolwar_01.mmp
[2012-02-13 13:09:11] ERROR : GLMapAxisInfo::LoadFile(), w_schoolwar_01.mmp

about this problem you can add your own +15armoroption.bin

and about the failed to load map same problem. i dont know why, shibuya is fail to load

[kazuyama]

600GB? o_O i think its only 600mb

@All

EP7 is not difficult anyway, i think you need an understanding and common sense when making a Ran Server.

PS. It is only my opinion.

What is easy? I've made this 4 days but can not be anything ", if you are kind please share me RAN SERVER DATA, :'( give me link

[jhom125]

If you want to test the client,

extract this file to raceran client,

you can try :

Login ID : terryz
Password : terryz1619

thx to everybody who shared this files,

saan pa po pde Download yan ??

[nhacphiyen]

Please help me this error, thank you

[jhom125]

can you help me ! how to find USER NAME and password this server _AgentServer , _FieldServer , _LoginServer , _SessionServer plsss HELP ME ! about this !



Uploaded with ImageShack.us[/IMG]



Uploaded with ImageShack.us[/IMG]





[IMG]<script src='http://img831.imageshack.us/shareable/?i=ran2sb.jpg&p=tl' type='text/javascript'></script><noscript></noscript>[/IMG]

[starstrokers]

just click enter. don`t put or type anything...

[mervin15]

is this md5 or not?

[starstrokers]

files aremd5 but gmc is normal...

[mervin15]

DB:{call log_serverstate(0,250,0,0)}
DB:42000, NativeError:2812, [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'log_serverstate'.
DB:{call log_serverstate(0,250,0,0)}
DB:42000, NativeError:2812, [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'log_serverstate'.
DB:{call log_serverstate(0,250,0,0)}
DB:42000, NativeError:2812, [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'log_serverstate'.
DB:{call log_serverstate(0,250,0,0)}
DB:42000, NativeError:2812, [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'log_serverstate'.
DB:{call log_serverstate(0,250,0,0)}
DB:42000, NativeError:2812, [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'log_serverstate'.
DB:{call log_serverstate(0,250,0,0)}
DB:42000, NativeError:2812, [Microsoft][SQL Native Client][SQL Server]Could not find stored


how to fix dis?

[Kawikaan]

Can you kindly post the Complete New items in this client sir? such as the Items in Gunner and in other classes.. thank you

[hayes]

can you help me my IP 192.168.15.3

When im creating a character it always says "name not available" how to fix it


tnx

[nhacphiyen]

Please ask if RanCP fits Ran Gunner version, I can not buy itemshop run rancp whether notice has been successful, please help me thanks

[asakid01]

i run the session and login server smoothly

but when i run the field server it closes automatically after i click start :(

any solution?

[nazmie01]

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[user_verify]
@userId char(25),
@userPass char(25),
@userIp char(25),
@SvrGrpNum int,
@SvrNum int,
@dummy1 int,
@dummy2 int,
@nReturn int OUTPUT
AS
DECLARE @nAvailable int,
@nUserNum int,
@nState int,
-- Declare variables used in error checking.
@error_var int,
@rowcount_var int,
@nBlock int,
@BlockDate datetime

SET NOCOUNT ON

SET @nReturn = 0
SET @nUserNum = 0

SELECT @nUserNum=UserInfo.UserNum,
@nState=UserInfo.UserLoginState,
@nBlock=UserInfo.UserBlock,
@BlockDate=UserInfo.UserBlockDate
FROM UserInfo
WHERE UserID = @userId AND UserPass = @userPass AND UserAvailable = 1 <<<<<<<<<<<<

-----------------------------------------------------------------
-- ID / PWD ??... <<<<<<<<<<
IF @nUserNum = 0
BEGIN
-- ID / PWD ??? ?? ??????? <<<<<<<<<<<
SET @nReturn = 0
RETURN @nReturn
END
ELSE
BEGIN
-- ID / PWD ?? <<<<<<<<<<<<<<
SET @nReturn = 1
-- 5 ????, ?? ???? ?? <<<<<<<<<
IF @nState = 1
BEGIN
SET @nReturn = 5
RETURN @nReturn
END
END

IF (SELECT COUNT(*) FROM BlockAddress WITH (NOLOCK) WHERE BlockAddress = @userIp) > 0 <<<<<<<<<<

BEGIN
UPDATE UserInfo
SET UserBlock = 1
WHERE UserNum = @nUserNum

SET @nReturn = 6
SET @nBlock = 1
SET @BlockDate = '11/21/2090 5:25:02 PM'

END

-----------------------------------------------------------------
-- IP Address ?? <<<<<<<<<<<
IF (SELECT COUNT(*) FROM IPInfo WITH (NOLOCK) WHERE ipAddress = @userIp) > 0
-- IP ?? ?? <<<<<<<<<<<<
BEGIN
SELECT @nAvailable = useAvailable
FROM IPInfo
WHERE ipAddress = @userIp

IF @nAvailable = 1
BEGIN
SET @nReturn = 2 -- ID/PWD ? ????, IP ? ???? <<<<<<<<<
END
ELSE
BEGIN
SET @nReturn = 4 -- ID/PWD ? ????, IP ? ????? ?? <<<<<<<<<
END
END
ELSE
-- IP ?? ??
BEGIN
SET @nReturn = 3 -- ID/PWD ? ????, IP ??? ?? <<<<<<<<<
END

-----------------------------------------------------------------
-- Block ?? ??
IF (@nBlock = 1)
BEGIN
IF (@BlockDate > GetDate())
BEGIN
SET @nReturn = 6
END
ELSE
BEGIN
UPDATE UserInfo
SET UserBlock=0
WHERE UserNum = @nUserNum

SET @nReturn = 2
END
END

-----------------------------------------------------------------
-- ??? ???? ?? <<<<<<<<<
IF (@nReturn = 1) OR (@nReturn = 2) OR (@nReturn = 3)
BEGIN
-- ???, ??? ????? ?? <<<<<<<<<<
UPDATE UserInfo
SET UserLoginState=1, LastLoginDate=getdate(), SGNum=@SvrGrpNum, SvrNum=@SvrNum
WHERE UserNum = @nUserNum

-- ???? ???
INSERT INTO LogLogin (UserNum, UserID, LogInOut, LogIpAddress)
VALUES (@nUserNum, @userId, 1, @userIp)

-- ?? ????
UPDATE StatLogin
SET LCount = LCount+1
WHERE LYear=Year(GetDate()) AND LMonth=Month(GetDate()) AND LDay=Day(GetDate()) AND LHour=DatePart(hour, GetDate())

SELECT @error_var = @@ERROR, @rowcount_var = @@ROWCOUNT
IF @error_var <> 0 OR @rowcount_var = 0
BEGIN
INSERT INTO StatLogin (LYEAR)
VALUES (YEAR(GetDate()))
END
END

SET NOCOUNT OFF

RETURN @nReturn



Terry How to edit this part ???
Teach me pls. . .

see the this arrow (<<<<)

ALTER PROCEDURE [dbo].[user_verify]
@userId char(25),
@userPass char(25),
@userIp char(25),
@SvrGrpNum int,
@SvrNum int,
@proPass varchar(6), -- Ran dynamic password
@proNum varchar(2), -- Ran dynamic password random number
@nReturn int OUTPUT

AS
DECLARE
@nAvailable int,
@nUserNum int,
@nState int,
-- Declare variables used in error checking.
@error_var int,
@rowcount_var int,
@nBlock int,
@BlockDate datetime,
@EndDate datetime,
@StrSql nvarchar(100)

SET NOCOUNT ON

SET @nReturn = 0
SET @nUserNum = 0

SELECT @nUserNum=UserInfo.UserNum,
@nState=UserInfo.UserLoginState,
@nBlock=UserInfo.UserBlock,
@BlockDate=UserInfo.UserBlockDate

FROM UserInfo
WHERE UserID = @userId AND UserPass = @userPass AND UserAvailable = 1


-----------------------------------------------------------------
-- ID / PWD check... <<<<<<<<<<
IF @nUserNum = 0
BEGIN
SET @nReturn = 0
RETURN @nReturn
END
ELSE
BEGIN
SET @nReturn = 1
IF @nState = 1
BEGIN
SET @nReturn = 5
RETURN @nReturn
END
END


IF (SELECT COUNT(*) FROM BlockAddress WITH (NOLOCK) WHERE BlockAddress = @userIp) > 0

BEGIN
declare @params as nvarchar(100)
SET @StrSQL = 'SELECT @ordercnt=count(userid) FROM Randpass WHERE userid='''+@userId+''' AND pwd'+@proNum + '='''+@proPass + ''''
SET @params = '@ordercnt as int OUTPUT' -- OUTPUT ???? ?? <<<<<<<<<

exec sp_executesql @StrSQL, @params, @ordercnt = @rowcount_var OUTPUT

SELECT @error_var = @@ERROR
IF @error_var = 0 AND @rowcount_var = 1
BEGIN
SET @nReturn = 1 -- Dynamic password correct
END
ELSE
BEGIN
SET @nReturn = 7 -- Dynamic password error
RETURN @nReturn
END
END


-----------------------------------------------------------------
-- IP Address ?? <<<<<<<
IF (SELECT COUNT(*) FROM IPInfo WITH (NOLOCK) WHERE ipAddress = @userIp) > 0
-- IP ?? ?? <<<<<<<
BEGIN
SELECT @nAvailable = useAvailable
FROM IPInfo
WHERE ipAddress = @userIp <<<<<

IF @nAvailable = 1
BEGIN
SET @nReturn = 2 -- ID/PWD ? ????, IP ? ???? <<<<<<<<<<
END
ELSE
BEGIN
SET @nReturn = 4 -- ID/PWD ? ????, IP ? ????? ?? <<<<<<<<<<<
END
END
ELSE
-- IP ?? ?? <<<<<<<<
BEGIN
SET @nReturn = 3 -- ID/PWD ? ????, IP ??? ?? <<<<<<<<<<
END

-----------------------------------------------------------------
-- Block ?? ?? <<<<<<<<<<
IF (@nBlock = 1)
BEGIN
IF (@BlockDate > GetDate())
BEGIN
SET @nReturn = 6
END
ELSE
BEGIN
UPDATE UserInfo
SET UserBlock=0
WHERE UserNum = @nUserNum

SET @nReturn = 2
END
END

-----------------------------------------------------------------
-- ??? ???? ?? <<<<<<<<<<<
IF (@nReturn = 1) OR (@nReturn = 2) OR (@nReturn = 3)
BEGIN
-- ???, ??? ????? ?? <<<<<<<<<
UPDATE UserInfo
SET UserLoginState=1, LastLoginDate=getdate(), SGNum=@SvrGrpNum, SvrNum=@SvrNum
WHERE UserNum = @nUserNum

-- ???? ??? <<<<<<<<<<
INSERT INTO LogLogin (UserNum, UserID, LogInOut, LogIpAddress)
VALUES (@nUserNum, @userId, 1, @userIp)

-- ?? ???? <<<<<<<<
UPDATE StatLogin
SET LCount = LCount+1
WHERE LYear=Year(GetDate()) AND LMonth=Month(GetDate()) AND LDay=Day(GetDate()) AND LHour=DatePart(hour, GetDate())

SELECT @error_var = @@ERROR, @rowcount_var = @@ROWCOUNT
IF @error_var <> 0 OR @rowcount_var = 0
BEGIN
INSERT INTO StatLogin (LYEAR)
VALUES (YEAR(GetDate()))
END
END

SET NOCOUNT OFF

RETURN @nReturn

teach me how to fill the ??? <<< i don't know

and how to fill the ID/PWD @My id ? or what and like this @ my id or like that?

[flyhigh1]

When I activated my skills in GMC its all added, and save, but when i log in game, all my skills were not activated, help me on this bug pls...