[Guide]How To Make Your Own Server (EP3)

[ianotida]

[Guide]How To Make Your Own Server (EP3 & EP4)

=====================================================
RAN Server Setup Guide - Updated : July 10, 2008
EP3 & EP4 Version
=====================================================

Required Programs :

SQL 2005 Express
Install .NET Framework 2.0 (dotnetfx.exe)

You must be registered to see links

Install MSSQL 2005 Express Edition

You must be registered to see links

Install MSSQL Management Studio Express

You must be registered to see links

Server Files :

EP3 Server Files

AVAILABLE DATABASE VERSIONS

SQL Script Database for using SQL Express 2005

You must be registered to see links

- updated

SQL Script Database for using SQL Server 2000

You must be registered to see links

- updated


RAN Server Files [4MB]

You must be registered to see links

RAN Tools and Editors[4MB]

You must be registered to see links

RAN Patch Client [2MB]

You must be registered to see links

Patch for English Glogic,Quest and NPCtalk [1MB]

You must be registered to see links

Chose client to Download (Use as your own client and data files on server side ) [600MB or greater ]

You must be registered to see links

You must be registered to see links

You must be registered to see links

You must be registered to see links

EP4 Server Files

AVAILABLE DATABASE VERSIONS

SQL Script Database for using SQL Express 2005

You must be registered to see links

RAN Server Files [14MB]

You must be registered to see links

RAN Client Patch[2MB]

You must be registered to see links

Chose client to Download (Use as your own client and data files on server side ) [600MB or greater ]

You must be registered to see links

You must be registered to see links

1st Database Guide

Creating New Database

For SQL Express 2005
1. on SQL Server Script Open your RanGame1.sql, SQL Management Studio
will open automatically.
2. Press Connect..
3. then Press Execute[!], wait until analyzing is complete.
4. Refresh on database.
5. Same on RanLog.sql, RanShop.sql and RanUser.sql

For SQL Server 2000
1. On Enterprise manager , Open Query Analyzer.
2. Open RanGame1.sql
3. then Press Execute[!] or Play button, wait until analyzing is complete
4. Same on RanLog.sql, RanShop.sql and RanUser.sql

OR

Restoring Backup Database
1. Open MSSQL Management Studio 2005
2. Login using Windows Authentication
3. Right click Database, Select New Database
4. Create New Database from this name's RanShop, RanLog, RanUser
5. Create New Datavase for RanGame1 and
Set Logical name RanGame1P_Data, RanGame1_log and
Click Add and Set it to RanGame1S_Data , click OK

6. Right click RanGame1, Select Task > Restore > Database
7. Chose From Device , Click Button , Click Add , add the rangame1.bak
8. Check rangame1 then go to Options
9. In Restore Options check the Overwrite existing database
10. click OK
11. Repeat #6, Same on RanUser, RanShop and RanLog

2nd ODBC Settings

This is an Automatic Registry Setup for your ODBC. you do not need to configure it manually.
Just chose your SQL version, Download it and press right click then Press Merge.

for Users using SQL 2005 Express - updated

You must be registered to see links

for Users using SQL 2000 -updated

You must be registered to see links

3rd How to configure RAN Server Files?

1. Open CFG folder inside your ran server (example: D:\ranserver\cfg\)
2. Open agent.ini, session.ini, field0.ini and login.ini in notepad.
3. Change 127.0.0.1 to your IP Address (example: 192.168.0.1 - LAN IP)
or Change 127.0.0.1 if you have to play offline
4. Do it the same procedure to field, login, and session.
5. You have now your RAN server config success.

Note: odbc_user and odbc_pass can also be empty if it is Windows Authentication

4th How to configure DATA folder of your RAN Server?

1. Go to Data folder of your client. (Usually it is in C:\Program files\RANOnline\data\)
2. Copy this following folder from your client to server data folder

Animation
Editor
Effect
Glogic
Gui
Map
Object
Piece
Skeleton
Skin
SkinObject

(this folders are found in your client data folder)

3. Double check your settings.
4. You are now ready to run the ran server.

5th How to run RAN Server?

1. Session Server
2. Login Server
3. Field Server(s)
4. Agent Server

EP3 Game Commands for GM

Events:
/eventexp_begin [1-9999999%]
/eventexp_end
/eventitem_begin [1-9999999%]
/eventitem_end
/eventmoney_begin [1-9999999%]
/eventmoney_end

Fun:
/bighead [on/off] = All Online Characters in Bighead
/bighand [on/off] = All Online Characters in Big Hands(same as weapons too)

Characters Managements:
/kickuser [CharID] = allows to disconnect user
/charinfo_ci [CharID] = Shows the character information by character ID
/charinfo_cn [CharName] = Shows the character information by character name

Move Commands:
/move2char [CharName] = Move to Online Character
/m2c [CharID]
/move2gate [0-99] = Move to available map gate
/m2g [0-99]
/move2pos [##,##,X,Y] = Move to a coordinate
/m2p [##,##,X,Y]

Other Commands:
/fps_limit [on/off]
/freepk [on/off]
/visible [on/off]
/itemhold
/visible [on/off] = character visibility
/month [1-12] = Set Month in number
/time [1-24] = Set Time in 24 hour clock
/weather [clear/snow/begin/spore/leave]
/dsp
/?

EP4 Game Commands for GM

Events:
/eventexp_begin [1-9999999%]
/eventexp_end
/eventitem_begin [1-9999999%]
/eventitem_end
/eventmoney_begin [1-9999999%]
/eventmoney_end
/event_ex_begin [speed/aspeed/attack]
/event_ex_end [speed/aspeed/attack]

Fun:
/bighead [on / off] = All Online Characters in Bighead
/bighand [on / off] = All Online Characters in Big Hands(same as weapons too)

Characters Managements:
/kickuser [CharID] = allows to disconnect user
/charinfo_ci [CharID] = Shows the character information by character ID
/charinfo_cn [CharName] = Shows the character information by character name
/chatblock_ci [CharID, minute] = block character in minutes by character ID
/chatblock_cn [CharName, minute] = block character in minutes by character name
/chatblock_ua [uaccount, minute] = block character in minutes by user acount
/genchar_ci [charID]
/genchar_cn [CharName]

Move commands:
/move2char_cn [CharName] = Move to Online Character
/move2char_ci [CharName] = Move to Online Character
/m2c_ci [CharID]
/m2c_cn [Charname]
/move2gate [0-99] = Move to available map gate
/m2g [0-99]
/move2pos [##,##,X,Y] = Move to a coordinate
/m2p [##,##,X,Y]

Note: maps code (#) can be found on maps.list or maps.ini

Other Commands:
/server [delay/level1/level2/force/shutdown]
/weather [clear/snow/begin/spore/leave]
/freepk_on
/freepk_off
/warning_msg [on/off]
/profile [on/off]
/pk_mode [on/off]
/visible [on/off] = character visibility
/month [1-12] = Set Month in number
/time [1-24] = Set Time in 24 hour clock
/itemhold
/mob_del_ex
/mob_del
/mob_gen_ex
/mob_gen
/where_npc
/dsp
/for
/whois
/? = Emote Icons

Summoning Mobs:

/mob_gen 62,2,14,14

the 62,2 is the mobID that can be found on CrowStrTable.txt
while the 14,14 is the coordinates that can be seen on
top of screen compass

Loading & Unloading Event Maps in Game

/lev_new [filename.Lev] = Load Event Map
/lev_del = UnLoad Event Map

Lev files can be found inside the level.rcc file
you can open the file using winrar program

GM Character Edit Settings (GMCharEdit.exe)

Open up your SQL Manager, go to the RanUser database.
Now, Open ServerGroup table. Fill in this Column

SGNum : 0
SGName : IaNz Server ( you can put any name u want )
OdbcName : RanGame1
OdbcUserID : sa
OdbcPassword : 1234
OdbcLogName : RanLog
OdbcLogUserID : sa
OdbcLogPassword : 1234

When done, Open ServerInfo table in the RanUser database.
put these values.

For Windows Authentication user and pass is not needed.

SGNum : 0
SvrNum : 0
SvrType : 4

Now, run the GMCharEdit. If this is your first time running it
you'll see 4 fields to input information.

First field : RanUser
Second field : sa
Third field : 1234
Fourth field : 1234

For Windows Authentication user and pass is not needed.

Creating an account
set UserType = 32 on UserInfo table for GM
and UserType = 1 for Users Only

on Ep4 database, you notice that the password is code instead of word
thats the new changes on Ep4 database
you must convert your password to a code known as MD5 Hash
ex:

Password | MD5 Hash Code

123456 = E10ADC3949BA59ABBE5
test = 098F6BCD4621D373CAD
ianz = 0948D2350A28EEB4B3B
pdf = BCD1B68617759B1DFCF

Trigger Codes (Optional)
--------------------------------------------

Here's the Trigger Code for Starting Character Level,Stats,Skill Points,Money and etc...

HERE ARE THE STEPS...

1. Open/Login you SQL Server Management Studio
2. Expand the Databases
3. Right click the RanGame1
4. Select New Queries
5. Put this code

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- ======================================================
-- Author: IaNz
-- Create date: --,--,--
-- Description: Starting Character Level,Skill and Stat Points
-- Dex,Pow,Int,Vit,Stm and Money
-- Note : If you have existing trigger replace CREATE TRIGGER
-- to ALTER TRIGGER
-- ======================================================
CREATE TRIGGER [dbo].[NewChar_Level] ON [dbo].[ChaInfo]
after update
as
BEGIN

Update [ChaInfo] set [ChaInfo].ChaLevel=100
From Inserted
Where Inserted.ChaLevel = 1 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum

Update [ChaInfo] set [ChaInfo].ChaSkillPoint=1500
From Inserted
Where Inserted.ChaSkillPoint = 0 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum

Update [ChaInfo] set [ChaInfo].ChaStRemain=1500
From Inserted
Where Inserted.ChaStRemain = 3 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum

Update [ChaInfo] set [ChaInfo].ChaMoney=1000000
From Inserted
Where Inserted.ChaMoney = 0 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum

END

EXTRA TOOLS FOR EDITING

DOWNLOAD :

You must be registered to see links

Inside :
Hex Editor , RANFE, DOS Decryptor & Encryptor




Launcher 2.5

Updated : Preloaded Page while website still loading
Fix : Bug on Start when Game.exe is not found
Added : Update button. to link on your updating program, Default "update.exe"

You must be registered to see links

 

[jpetrucci]

ei, i used the Phoenix ran fuLL cLient but its not working.. pLus, when i open the FieLd server, a pop message teLLs me "need new version exe".. what does it mean? i think its not working with Phoenix ran.. I reALLy need to DL an EP3 fuLL cLient, aLL of the Links here in RZ are aLL DEAD!!..iv searched the whoLe forum but they're aLL dead.. PLease i need mirrors.. thanks.. (the session server and the Login server is working for me but the fieLd server and agent server it says "need new version exe")

 

[ASAJIMAE]

did you searched? i dont think so.
_
i posted an ep4 clients links and ep3 clients links.
__
search it or click my siggy (it has ep4 and ep3 client links) (all working)
____
IN YOUR PROBLEM
http://forum.ragezone.com/f444/help-error-need-new-version-exe-file-441082/

or search the forum

 

[jpetrucci]

hi.. how wiLL I know the GM ID and password in GMCharEdit.exe? I'm aLmost done..

 

[ASAJIMAE]

create your gm account via SQL
++
put 32 in the Acc. Type < 32 is for GM and 1 is for USER

 

[jpetrucci]

create your gm account via SQL
++
put 32 in the Acc. Type < 32 is for GM and 1 is for USER

okay, i aLready did that. But i still can't Log in. Do I have to enter a username and password on the UserInfo tabLe?

 

[lermadazo]

Guys p2long nmn i cant connect to the server
pag nireinstall ko wala nmn nklagay na
user pass
tpos pag sa express n
hinahanap ung user and pass
d ako mka connect ...

 

[killer_atom]

Do the Guide again and you will succeed just post your question in this thread and rage zone people will help you.

 

[deuxmach]

Sir need help i can log in and play the game but the problem is i cant enter the school or market it just stuck. I try to recon and try again pero ganun parin.. i have 1 field server and set map.ini and map.list to 0 both glogic.rcc and level.rcc still i cant enter.T_T

e2 din po ung info sa agent server:

Service Provider:IANZ SERVER
CreateIoCompletionPort OK
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
User DB Open OK
Game DB Open OK
Log DB Open OK
Shop DB Open OK
Database Thread Create OK
Log Database Thread Create OK
User Database Thread Create OK
--------------- System Information -------------------
Microsoft Windows XP
Pentium 4 processor 1610 Mhz
1 System Processor Detected
------------------------------------------------------
2 Worker Thread
1 st Worker Thread Create OK
2 st Worker Thread Create OK
[IaNz Server] Start
PK MODE : 1
[IaNz Server] Start Succeeded
[IaNz Server] ---------------
Server Update Thread Create OK
WSASocket OK
Bind OK
192.168.254.1:5502
Server Accept Thread Create OK
(Client ID:99) (192.168.254.1:5003)
Session Server Connection OK
SessionSndSvrInfo 192.168.254.1 CH:1
(Client ID:0) (192.168.254.1:5103)
INFO:Field Server CH(0) NUM(0) ID(0) Connection OK
ERROR:FieldConnect CH:0 SERVER:1
ERROR:FieldConnect CH:0 SERVER:2
ERROR:FieldConnect CH:0 SERVER:3
ERROR:FieldConnect CH:0 SERVER:4
ERROR:FieldConnect CH:0 SERVER:5
ERROR:FieldConnect CH:0 SERVER:6
ERROR:FieldConnect CH:0 SERVER:7
ERROR:FieldConnect CH:0 SERVER:8
ERROR:FieldConnect CH:0 SERVER:9
=======================================================
Server Start OK
=======================================================

 

[tampalasan]

can i ask you ianz????
im trying to make a ran private server ep3 but im a newbie on this stuff,my problem is that i cant download the 4 links you have for ep3 clients....so i dont have a client to use....cud give me sum options can I use the ep4 client instead ????or should I start with ep3 client????
and pls will u giv me a much much easier guide 2 mke a private ran server....coz im rily having a hard tym understanding sum of the details of your guide.
as I said i am a newbie so i rily nid ur help....
tnx.....

 

[ASAJIMAE]

@jpetrucci - put USER NAME & User ID must be same and PASS & PASS2 should be same or not and put 32 in the acc. type-

then if you will login in the gmcharedit (put USERNAME and PASS)

 

[ASAJIMAE]

tampalasan - go here *all links are working* http://forum.ragezone.com/f248/share-ran-online-ep3-clients-w-mirrors-487928/

 

[tampalasan]

tnx a lot....
i hope it can help me .....

 

[tampalasan]

ASAJIMAE....
I olredy tryd to moke a server but I think its not working can i mke a new one and just overwrite it to d first one i made???

 

[ASAJIMAE]

you can do TRIAL AND ERROR all of us here try that technique.

 

[tampalasan]

ok but i think u know more bout this stuff than me any tips that cud be rily helpful???
coz that wud do alot......
tnx anyway....
^^, i apreciate it....

 

[ASAJIMAE]

im not experienced hehe. im newbie too but i read FAQS and stickies. now i have my own server
_
you just need to understand the guides here and follow it.
_
and i takes time to make server

 

[tampalasan]

ok but can i ask u for help incase i rliy cant uderstand some of d guides???

 

[ASAJIMAE]

okey

 

[nortonPC]

sir how can i fixed this?


Service Provider:CHINA
CreateIoCompletionPort OK
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK
ERROR:SQLConnect Failed
ERROR:User db open failed
== Please wait until server stop
Stop IOCP
Stop Message Queue
Stop DataBase
Stop CFG
=======================================================
Server Stop OK
=======================================================
INFO:SQL_ATTR_CONNECTION_POOLING OK
INFO:SQLAllocHandle OK



i use sql 2005... i already merge the registry of 2005... but still cant start session...







i also tried SQL 2000 session,login,field and agent succesfully start.. but i cant connect to the server...

it says "system error caused log in fail" i used md5 password but still cant connect.

 

[ASAJIMAE]

setup your sql files and ODBC