Create Ran Offline EP7

Subyek: Create Ran Offline EP7 Mon Mar 05, 2012 7:28 pm

SORRY INGGRIS

EP7 Gunner Server Files + RaceRan Client ( do at your own risk )

Setting up an Episode 7 Version 1 RAN Gunner Server

Create Ran Offline EP7 83973d1294078438-guide-official-guide-setting-ep6-rzran

I. Required Softwares:

1. Download and instal : [You must be registered and logged in to see this link.]
2. Download and install : [You must be registered and logged in to see this link.]

3. Download ONLY (important: wait for my
further instructions on how you install this later) Microsoft SQL
Server 2005 Express Edition. Before you download this program, you
should first check the "service pack" of your computer if it has. To
check that, go to Start> Right Click 'My Computer' > Properties
> Under the 'General' Tab, at the bottom of the 'System' column,
there you can see if your computer has a service pack and what version
it is. After knowing your service pack, you may finally download MSQL
2005 Express Edition.

For Service Pack 4 : [You must be registered and logged in to see this link.]
For Service Pack 3 : [You must be registered and logged in to see this link.]
For Service Pack 2 : [You must be registered and logged in to see this link.]
No Service Pack : [You must be registered and logged in to see this link.]

4. After downloading the MSQL 2005 Express Edition with the right Service Pack compatible with your computer. Install it

Hehe is the video guide :

[You must be registered and logged in to see this link.]

EP7 Gunner Server Files + RaceRan Client ( do at your own risk )

Setting up an Episode 7 Version 1 RAN Gunner Server

Create Ran Offline EP7 83973d1294078438-guide-official-guide-setting-ep6-rzran

I. Required Softwares:

1. Download and instal : [You must be registered and logged in to see this link.]
2. Download and install : [You must be registered and logged in to see this link.]

3. Download ONLY (important: wait for my
further instructions on how you install this later) Microsoft SQL
Server 2005 Express Edition. Before you download this program, you
should first check the "service pack" of your computer if it has. To
check that, go to Start> Right Click 'My Computer' > Properties
> Under the 'General' Tab, at the bottom of the 'System' column,
there you can see if your computer has a service pack and what version
it is. After knowing your service pack, you may finally download MSQL
2005 Express Edition.

For Service Pack 4 : [You must be registered and logged in to see this link.]
For Service Pack 3 : [You must be registered and logged in to see this link.]
For Service Pack 2 : [You must be registered and logged in to see this link.]
No Service Pack : [You must be registered and logged in to see this link.]

4. After downloading the MSQL 2005 Express Edition with the right Service Pack compatible with your computer. Install it

Hehe is the video guide :

[You must be registered and logged in to see this link.]

5. Last to download is the SQL Server Management Studio Express Service.
It's download is the same as the MSQL 2005 Express Edition that you'll
gonna match the service pack with your computer.

For Service Pack 4 : [You must be registered and logged in to see this link.]
For Service Pack 3 : [You must be registered and logged in to see this link.]
For Service Pack 2 : [You must be registered and logged in to see this link.]
No Service Pack : [You must be registered and logged in to see this link.]

6. The easiest step is installing SQL Server Management Studio Express
Service. You're gonna do nothing but hit the 'next' button till you
finish the installation.

Hehe is the video guide : [You must be registered and logged in to see this link.]

II. Server Files:
1. Download : [You must be registered and logged in to see this link.] NO PASSWORD< LEAVE IT BBLANK

Great thanks to 3rdPegasus for sharing the server files

Quote:

to change IP

change IP in cfg

and change IP in all server files

hex it search 222.222.222.222

change to you Ip

you can use this : [You must be registered and logged in to see this link.]

I've try this and its work !

ss : Create Ran Offline EP7 81440097

2. Download [You must be registered and logged in to see this link.]

Quote:

Guide using Neo Tools ( by McX )

1.In The 1st Browse Button(BROWSE The itemstable,skillstable or Any File You Want To Decryp of RR's Glogic.rcc)
2. In The 2nd browse Button Where the File SHould be Save any Destination its up To you : ))

3. 3rd Click The Decryp Button To Decryp The FIle
4. 4th step: Open Reeditor4.exe and browse The Itemstable,Skillstable or The File You Want To Decryp..(WALLA ITS DECYPTED : ))

How To Encryp The FIles Again
1. 1st Browse The itemstable,SKillstable or The File You Want TO Encryp
of RR's Glogic.rcc(DECRYPTED ALREADY) Using The Cryptic Tool.Exe.

Click The Encryp Button To Re Encryp The File Again : ))

Its That SImple!!

TAKE NOTE THERE SOME FUNCTIONS ALSO SO YOU CAN SEE
.rcc,.bin,.wld,.x,textures,packtest,item.isf And Etc .... Explore Other
Function You Can Do It So You Can Learn Also By Your Selve'S

3. Download : [You must be registered and logged in to see this link.] ( by raminspo )

To avoid error on database, execute this ( thnx to dev02 for the script )

FIX FOR ERROR

Quote:

"DB:Exec sp_UserAttendLog 6108
DB:42000, NativeError:2812, [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'sp_UserAttendLog'.
ERROR:Read Attend list failed"

= "EXECUTE THIS ON DATABASE"

Quote:

USE [RanGame1]
GO
/****** Object: StoredProcedure [dbo].[sp_UserAttendLog ] Script Date: 07/17/2011 07:41:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[sp_UserAttendLog ]
@nUserNum int

AS
DECLARE
@error_var int,
@rowcount_var int

SET NOCOUNT ON
Select (MSum-MS) As M, (FSum-FS) As F
From
(
Select isnull(Sum(M),0) As MSum, isnull(Sum(F),0) As FSum, isnull(Sum(MS),0) As MS, isnull(Sum(FS),0) As FS
From
(
Select ChaClass
,
Case ChaClass
When 1 Then 1
When 2 Then 1
When 256 Then 1
When 512 Then 1
Else 0
End As M
,
Case ChaClass
When 4 Then 1
When 8 Then 1
When 64 Then 1
When 128 Then 1
Else 0
End As F
,
Case ChaClass
When 16 Then
Case ChaDeleted
When 4 Then 0
Else 1
End
Else 0
End As MS
,
Case ChaClass
When 32 Then
Case ChaDeleted
When 4 Then 0
Else 1
End
Else 0
End As FS
From ChaInfo
) As t
) As tt
GO

SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO

ERROR ON LOG IN

EXECUTE THIS ON DATABASE

Quote:

USE [RanUser]
GO
/****** Object: StoredProcedure [dbo].[user_verify] Script Date: 07/17/2011 09:58:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

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

4. How to make it work

follow essaeypride guide :

Quote:

Add this to your dbo.Chainfo

ChaCP,SumMain,SumSub

I dont know if what data type try ..

ChaCP - Bigint - Null
SumMain - int - Null
SumSub - int - Null

Try try try :)

5. Download : [You must be registered and logged in to see this link.] ( this glogicserver compatible with raceran client, so no error about open period.ini )

Client :

other mirror :

uploaded by dmc0105 : [You must be registered and logged in to see this link.]

people who already make it work : jemce025, Seifer13, zentrixph, ( sorry if forgot to put the others ) need rush posting this

some ss :

Create Ran Offline EP7 3-1

Create Ran Offline EP7 95987d1326940665-share-gunner-server-files-ran20120119-1025-000

Create Ran Offline EP7 95988d1326940665-share-gunner-server-files-ran20120119-1026-000

Create Ran Offline EP7 95989d1326940665-share-gunner-server-files-ran20120119-1036-000

Create Ran Offline EP7 95991d1326942574-share-gunner-server-files-3

If you want to test the client,

extract [You must be registered and logged in to see this link.] to raceran client,

you can try :

Login ID : terryz
Password : terryz1619

thx to everybody who shared this files,

DO THIS BY YOUR OWN RISK !

LEAVING RZ AWHILE..GOT TO CONTINUE WORKING...

SORRY FOR MY BAD ENGLISH Create Ran Offline EP7 Tongue_smilie