[Guide] Official Guide Making Ran Online Episode 7 Gunner Server

[terryz1619]

Setting up an Episode 7 Version 1 RAN Gunner Server

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

Here is the video guide : Installing Microsoft SQL Server 2005 Express Edition

Spoiler:

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.

Here is the video guide : Installing SQL Server Management Studio

Spoiler:

Game Client : Download Game Client
Server Files : Download Server Files
Database : Download Database
All Editors : Download All Editors
Glogicserver : Download Glogicserver
GMCharEdit : Download GMCharEdit


Note : For the server files :

Spoiler:

Hex the server files, then search this IP : 222.222.222.222.
Then change it to your own IP

you can use this : Hex Workshop for editing the server files

Guide for Hexing : How to hex server files (hamachi)

Server screenshot (server side - tested by me) :

Spoiler:

This server files is working for me, why not you ?

Fix for some error

Spoiler:

Error 1 : Character data failed to be processed ! - Shared by Dev02

Spoiler:

Solution 1 : You need 2 PC or use Virtual Machine for single PC
Guide how to use set up virtual machine - by LatneM/

Solution 2 : If you already have 2 pc or use Virtual machine but still "Data failed to be processed" Create a new query in RanUser and Execute the script.

Spoiler:

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

Error 2 : No gunner class on character creation - shared by Essaeypride

Spoiler:

Create a new query in RanGame1 and Execute the script.

Spoiler:

USE [RanGame1]
GO
/****** Object: StoredProcedure [dbo].[sp_Extreme] Script Date: 01/30/2012 21:22:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


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

AS 
DECLARE
@error_var int, 
@rowcount_var int 

SET NOCOUNT ON

Select 9 As M, 9 As F
From
(
Select isnull(Sum(M),1) As MSum, isnull(Sum(F),1) 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 1 Then 0
Else 1
End
Else 0
End As MS
,
Case ChaClass
When 32 Then 
Case ChaDeleted
When 1 Then 0
Else 1
End
Else 0
End As FS
From ChaInfo Where UserNum=@nUserNum And (
( ChaClass=16 OR ChaClass=32 ) OR 
( ( ChaClass=1 OR ChaClass=2 OR ChaClass=4 OR ChaClass=8 OR 
ChaClass=64 OR ChaClass=128 OR ChaClass=256 OR ChaClass=512 ) AND ChaLevel>=0 ) )
) As t
) As tt

Error 3 : Vending bug. - Shared by Vision
What's this bug about? You'll be disconnected in-game when someone buy's in you when vending.

Spoiler:

Instruction: Please replace your xml's inside gui with the above file. Edit also your param.ini with "PE" as your language. Thank you.

Download File: updated gui

Error 4 : item without proper name (IN_018_042) and no icon skill icon

Spoiler:

item without proper name (IN_018_042) and no icon skill icon

screenshot :

item without proper name (IN_018_042)

Spoiler:

some gunner class skill have no icon...

Spoiler:

Solution : you need to add the item name (inside ItemStrTable.txt) and skill's icon (ran/textures/gui) MANUALLY

Error 5 : No server list on selection menu

Spoiler:

Solution : Run the Server correctly (Session-Login-Field-Agent)

Error 6 : Error on deleting character

Spoiler:

1. This is the problem of ep7 server files. we cannot delete the character.

2. The problem maybe is the database.. and the gui/xml source.. (who knows)

3. Make ur own function to delete char on cp

In Game Screenshot

Spoiler:

Credits: neomaster (neomastei2), Blazedex Development.

[SeiferXIII]

Since this is a guide,
Thread moved.

[jambrong]

Don't forget, using WAN or IP Public
if you're using LAN IP, field server and agent server will crash.......
(too bad I don't have any server to try this....)

[SkyLerZz]

nice guide

[terryz1619]

Removed

[Vision]

Very detailed guide. What's that robot costume name?

[tearhear18]

great share ,, however crash issues still exist ..

[terryz1619]

Removed

[tearhear18]

not really.... i take a look this file in olly,. then i found something bad.. 20% analyze here is i found.
it connect to something IP xx.xx.xx.xx
then remote those config/lib/plug in or i dont know exactly that file
when you run exe. it connect to hidden ip, then sounds like authentication method... this a part of copyright..
"be carefull" hehe

NOTE NOTE NOTE: I just base it on my analysis!! no worries unless someone have a proof.

[SkyLerZz]

when right click the pet card , the pet won't come out

is it bug or what ? do anybody have solution for this ?

[terryz1619]

Removed

[Eureka7]

if you will only test this in your home. (disconnect from the internet to avoid getting caught :)))) as what tearhear said. it connects to hidden ip :)

[SkyLerZz]

if you will only test this in your home. (disconnect from the internet to avoid getting caught :)))) as what tearhear said. it connects to hidden ip :)

more detailed ? sorry I am noob in english

[Eureka7]

as what the other dev said.

not really.... i take a look this file in olly,. then i found something bad.. 20% analyze here is i found.
it connect to something IP xx.xx.xx.xx
then remote those config/lib/plug in or i dont know exactly that file
when you run exe. it connect to hidden ip, then sounds like authentication method... this a part of copyright..
"be carefull" hehe

NOTE NOTE NOTE: I just base it on my analysis!! no worries unless someone have a proof.

[asero1933]

in starting session what is bind error code:10049