Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Official Guide Making Ran Online Episode 7 Gunner Server

Status
Not open for further replies.
Junior Spellweaver
Joined
Sep 29, 2010
Messages
139
Reaction score
46
Setting up an Episode 7 Version 1 RAN Gunner Server

terryz1619 - Official Guide Making Ran Online Episode 7 Gunner Server - RaGEZONE Forums



1. Download and instal :
2. Download and install :

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

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


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

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


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


Note : For the server files :

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

you can use this : for editing the server files

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

Server screenshot (server side - tested by me) :
This server files is working for me, why not you ? :laugh:
terryz1619 - Official Guide Making Ran Online Episode 7 Gunner Server - RaGEZONE Forums

Fix for some error

Error 1 : Character data failed to be processed ! - Shared by Dev02
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.

Code:
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
Create a new query in RanGame1 and Execute the script.

Code:
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.
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:

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

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

screenshot :

item without proper name (IN_018_042)
terryz1619 - Official Guide Making Ran Online Episode 7 Gunner Server - RaGEZONE Forums

some gunner class skill have no icon...
terryz1619 - Official Guide Making Ran Online Episode 7 Gunner Server - RaGEZONE Forums

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

terryz1619 - Official Guide Making Ran Online Episode 7 Gunner Server - RaGEZONE Forums


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

Error 6 : Error on deleting character

terryz1619 - Official Guide Making Ran Online Episode 7 Gunner Server - RaGEZONE Forums


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) :laugh:

3. Make ur own function to delete char on cp

In Game Screenshot

terryz1619 - Official Guide Making Ran Online Episode 7 Gunner Server - RaGEZONE Forums


terryz1619 - Official Guide Making Ran Online Episode 7 Gunner Server - RaGEZONE Forums


terryz1619 - Official Guide Making Ran Online Episode 7 Gunner Server - RaGEZONE Forums


terryz1619 - Official Guide Making Ran Online Episode 7 Gunner Server - RaGEZONE Forums


terryz1619 - Official Guide Making Ran Online Episode 7 Gunner Server - RaGEZONE Forums


Credits: neomaster (neomastei2), Blazedex Development.
 
Last edited:
Junior Spellweaver
Joined
Nov 7, 2006
Messages
104
Reaction score
46
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....) :(::(::(::(:
 
QT is better than VS
Joined
Jul 29, 2009
Messages
908
Reaction score
389
great share ,, however crash issues still exist ..
 
QT is better than VS
Joined
Jul 29, 2009
Messages
908
Reaction score
389
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.
 
Initiate Mage
Joined
Jan 7, 2012
Messages
77
Reaction score
0
when right click the pet card , the pet won't come out

is it bug or what ? do anybody have solution for this ?
 
Initiate Mage
Joined
Jan 7, 2012
Messages
77
Reaction score
0
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
 
Joined
Oct 29, 2008
Messages
952
Reaction score
92
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.
 
Custom Title Activated
Member
Joined
Mar 24, 2011
Messages
1,632
Reaction score
145
in starting session what is bind error code:10049
 
Joined
Oct 29, 2008
Messages
952
Reaction score
92
edit your ip in cfg + hex the server files (search the ip then edit it) search for 222 it will displaythe current ip in the servers files (as what jumong shared)

EDIT: i cant find any gunner items/stores ingame. you need to use gmcharedit to put gunner items :) haha
 
Experienced Elementalist
Joined
Mar 25, 2006
Messages
218
Reaction score
19
Where do exactly I need to put the glogicserver? I put it in data folder but when I ran the fieldserver its say period.ini not found. Is it case sensitive?
 
Custom Title Activated
Member
Joined
Mar 24, 2011
Messages
1,632
Reaction score
145
when i starting my launcher non auto patch it gets bugtrap y?
 
Status
Not open for further replies.
Back
Top