Lunes, Pebrero 6, 2012

How to create EP7 Server Gunner Class

Setting up an Episode 7 Version 1 RAN Gunner Server


I. Required Softwares:

1. Download and instal : Windows Installer 3.1
2. Download and install : .NET Framework 4

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 : Download
For Service Pack 3 : Download
For Service Pack 2 : Download
No Service Pack : Download

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

Hehe is the video guide :

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 : Download
For Service Pack 3 : Download
For Service Pack 2 : Download
No Service Pack : Download

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 :

II. Server Files:
1. Download : Gunner Server Files 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 : Hex Workshop
I've try this and its work !

ss :




2. Download Neo Tools.rar
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 : EP7 Database ( 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 : Glogicserver ( this glogicserver compatible with raceran client, so no error about open period.ini )

Client 
:raceran.com/downloads/RaceRAN.FULL.v2.1.exe
other mirror :
uploaded by dmc0105 : Download

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

some ss :

















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,

DO THIS BY YOUR OWN RISK !

 Simple Hexing Method - Hamachi Server
To those people saying that hamachi is not gonna work on ep6 or ep7 servers. I can say your wrong. It really works.

This is what to do.

Step 1: Install Hamachi on your computer.
Step 2: Edit Server Files by Hexing, Edit cfg by notepad.
Step 3: Run the Server.

Note: Make sure your Hamachi give you 10digit number as your IP, if not uninstall/reinstall until you get 10 digits.

just look at my screen shots. Thank You Ragezone!
Attached Thumbnails
hamachi2.jpg   hamachi3.jpg  
Ipinaskil ni sa

3 komento:

Mag-subscribe sa: I-post ang Mga Komento (Atom)