Rf 2.2.3.2 Server Set Up

PC Requirements :
Use Windows OS x64bit
4GB RAM
MSSQL 2008 EXPRESS x64bit

1. Install MSSQL 20005 or 2008

2. Create 3 RF DataBase:
Right Click on Databases > New Databases > then enter the
RF Database Name. Do that for 3 RF Database Name.

* BILLING
* RF_User
* RF_World

3. Restore the 3 RF DataBase:
Right Click on Databases > Task > Restore > Databases >
in ((General)) select ((From device)): then select the ((....)) > ((Add))
to browse to where you extract your RF Server folder and select the
.bak file to restore your RF Database. Once you find the .bak files click
OK > OK. Bring you back to ((General)) check mark [x]Restore. Next select
((Options)) check mark [x]Overwrite the existing database (WITH REPLACE).
Under Restore the database files as: Restore As select
C:\Program Files\Microsoft SQL Server\MSSQL10_50.RFONLINE\MSSQL\DATA and
input your RF Database DIR:

Note: DO NOT RESTORE TO THE MSSQL DEFAULT DIR IT WILL NOT WORK!!!!
RESTORE THE 3 RF DataBase to a different DIR: (ex: c:\RFDB)

(ex: this is my BILLING C:\RFDB\BILLING.mdf & C:\RFDB\BILLING.ldf)

then select > OK . Repeat that for 3 RF Database Name.

* BILLING.bak
* RF_User.bak
* RF_World.bak

4. Create a RF User name/password and give User Mapping all access except
the DENY check box.

Select ((Security)) > ((Logins)) Right click Logins > select ((New Logins))
input your desire login name (ex: rf)

Note: WRITE DOWN THE USER NAME YOU GONNA NEED IT LATER FOR CONFIGURING YOUR
RF INI'S FILES.

Next Select ((SQL Server authentication)) enter desire password and confirm
password. (ex: rfadmin)

Note: WRITE DOWN THE USER PASSWORD YOU GONNA NEED IT LATER FOR CONFIGURING YOUR
RF INI'S FILES.

Next UNCHECK: []Enforce password policy

Next select ((User Mapping)) > Under ((User mapped to this login:))
put a [x] to the 3 RF Database. ex: [x]BILLING, [x]RF_User, [x]RF_World)
under ((Database role membership for: (name for rf database) check mark all selection,
EXCEPT db_denydatareader, and db_denydatawriter.

Repeat that for 3 RF Database Name.

5. !!!!! THIS NEXT STEP IS VERY IMPORTANT IF YOU MESSED UP YOU WILL GET ((AccountDB Failed!!))
EVERYTIME YOU RUN AccountServerSD!!!!!!!!!!!!!

RF_User ONLY!!!!
================
Create a RF User name/password and give User Mapping all access except
the DENY check box.

Select ((Security)) > ((Logins)) Right click Logins > select ((New Logins)) and
input for user name: rfrusaccount password: #rf%rusaccount to (( RF_User ))ONLY!!!!

Next Select ((SQL Server authentication)) enter password and confirm
password.

Next select ((User Mapping)) > Under ((User mapped to this login:)) put a
[x] to the RF Database. (ex: [x]RF_User)

under ((Database role membership for: RF_User check mark all selection,
EXCEPT for db_denydatareader, and db_denydatawriter.

RF_World ONLY!!!!
=================
Select ((Security)) > ((Logins)) Right click Logins > select ((New Logins)) and
input for user name: rfrusworld password: #rf%rusworld to (( RF_World ))ONLY!!!!

Next Select ((SQL Server authentication)) enter password and confirm
password.

Next select ((User Mapping)) > Under ((User mapped to this login:)) put a
[x] to the RF Database. (ex: [x]RF_World)

under ((Database role membership for: RF_World check mark all selection,
EXCEPT for db_denydatareader, and db_denydatawriter.

Note: Please re-check your newly created user and make sure all the check mark under
(( Database role membership for: (name of rf database) )) is mark with [x]
EXCEPT for db_denydatareader, and db_denydatawriter.
for some strange reason the []db_owner was not mark i have no idea ^^

Note: These are hardcoded into the AccountServer and ZoneServer respectively and
they change with country code; if a different country is used (not RU),
use ODBC trace and AnjSql Profiler to determine the user, then hex search
user in AccountServerSD.exe to find user & pass).

6. ODBC SETTINGS:
==================
click on START > Controll Panel > Administrative Tools > select ((Data Sources (ODBC) ))
it will open up ODBC Data source Administrator under User DSN click ((Add..)) > Select
Select SQL Server Native Client 10.0 and click Finish.

Next input the RF Database name: (1 at a time NOT ALL 3) ^^
* BILLING
* RF_User
* RF_World

put in description if you want ^^

Server: ( put in your MSSQL Server Name ( ex: mine was MIKEY-PC\RFONLINE ) click Next

chose : With SQL Server authentication using a login ID and Password entered by the user

Login ID: (see step 4 for user name) password: (see step 4 for password) click next

check mark: [x]change the default database to: (name of the Rf Database)
(ex: BILLING) click next, click Finish, click ((Test Data Source)) to make sure
TESTS COMPLETED SUCCESSFULLY! if it do not work you did something wrong in your MSSQL Server ^^

Repeat that for 3 RF Database Name.

after you are done close ODBC ^^

7. RF INI's Files Editing:
========================
Create a folder name: HBK & History in your server folder:
(ex: F:\RF v2.2.3.2 Server\HBK) (ex: F:\RF v2.2.3.2 Server\History)

open up F:\RF v2.2.3.2 Server\Account and Login\RF_Bin\Initialize and edit all the INI files

==================
AccountSystem.ini:
==================
[Database]
AccountDB_Machine = 127.0.0.1 <<< change to your WANIP or LANIP
AccountDB_Name = RF_User

[System]
NationCode = RU

[DB_INFO]
IP = 127.0.0.1 <<< change to your WANIP or LANIP
Port = 1433 <<< if you have change your MSSQL Port (ex: 61433)
DBName = BILLING
Acc = sa <<< change to your MSSQL username see step 4
PW = mnbe5824 <<< change to your MSSQL password see step 4

[Service]
MaxAccountNum = 1337

[World]
WorldSet_Num =1
ServiceSet_Num = 0

Name0 = RF_LEET <<< change to your desire Server Name ^^
Address0 = 127.0.0.1 <<< change to your WANIP or LANIP
DBName0 = RF_World
Type0 = 0
===========end of file==================

=================
BillingSystem.ini
=================
[System]
ZoneAddress = 127.0.0.1 <<< change to your WANIP or LANIP
NationCode = RU

[BILLING]
SERVER_NAME = BILLING
IP = 127.0.0.1 <<< change to your WANIP or LANIP
PORT = 1433 <<< if you have change your MSSQL Port (ex: 61433)
CP_ID = 1
GROUP_NUM = 1
SERVER_NUM = 1
GAME_ID = 1
===========end of file==================

====================
Login_Filter_Dev.ini
====================
[IPAddress]
FilterNum = 0

Filter0 = 192.168.1.10
FilterRange0 = 255

[ID]
FilterNum = 1
Filter0 = !karasss <<< change to your GM User Account (ex: !rfadmin)
===========end of file==================

===============
LoginSystem.ini
===============
[Account]
AccountAddress = 127.0.0.1 <<< change to your WANIP or LANIP

[System]
NationCode = RU

[CHECK ADDRESS]
CHECK = TRUE

[LOG]
AUTH_LOG = TRUE

[World]
Lim World Num = 1
DB Push Job = 0

[BILLING]
Check = FALSE
BillingCode = 78

[MOTP]
Service = FALSE
HostName = Let.Tom.Ru
HostIP = ÂÀØ IP
URLPath = /MOTPValidation/ValidationServlet
Port = 12380

[IP Address Filter]
FilterNum = 0

Filter0 = 192.168.0.10 <<< change to your WANIP or LANIP
FilterRange0 = 255
[UserCountDisplyLimit]
Limit0 = 500
Limit1 = 1200
Limit2 = 2700

[BILL_RU]
DBName = BILLING
DBIP = 127.0.0.1 <<< change to your WANIP or LANIP
DBAccount = sa <<< change to your MSSQL username see step 4
DBPassword = mnbe5824 <<< change to your MSSQL password see step 4
DBPort = 1433 <<< if you have change your MSSQL Port (ex: 61433)
===========end of file==================

open up F:\RF v2.2.3.2 Server\Account and Login\RF_Bin\ and edit all the INI files

=========
rfacc.ini
=========
[Options]
DBSTR = Driver={SQL Server Native Client 10.0};Server="your mssql server name";Database=BILLING;Uid=rf;Pwd=rfpass; <<< change to your MSSQL username/password see step 4
ErrDBSTR =
LogLevel = 2
===========end of file==================

open up F:\RF v2.2.3.2 Server\ZoneServer\WorldInfo

=============
WorldInfo.ini
=============
[System]
WorldName = RF_LEET <<< change to your desire Server Name ^^

ServerType = 0 <<< change from 1 to 0 otherwise you can NOT connect client to server

BillingCode = 32
BillOper = 0
FreeServer = 1

HBKPath = C:\Work\HBK <<< change to (ex: F:\RF v2.2.3.2 Server\HBK)
HistoryPath = C:\Work\History <<< change to (ex: F:\RF v2.2.3.2 Server\History)

NationCode = RU

[ServerMode]
BuyCashItemByGold = true
ReleaseType = Internal
ExcuteService = true

[Rule]
CrystalHPMultiple = 1.0
CrystalHPMultiple_1 = 5.0
CrystalHPMultiple_2 = 8.0
CrystalHPMultiple_3 = 11.0

[GUILD CREATE EVENT]
Enable = FALSE
START_DATE = 20090119
END_DATE = 20090120
===========end of file==================

open up F:\RF v2.2.3.2 Server\Account and Login\RF_Bin\ and copy/replace rfacc.ini to
F:\RF v2.2.3.2 Server\ZoneServer\RF_Bin

open up F:\RF v2.2.3.2 Server\ZoneServer\RF_Bin\Initialize and edit the WorldSystem.ini

===============
WorldSystem.ini
===============
[System]
AccountAddress = 127.0.0.1 <<< change to your WANIP or LANIP
LimUserNum = 1337

[MainThread]
SleepTerm = 15
SleepValue = 10
SleepIgnore = 1
[Messenger]
Use = TRUE

[RankJob]
JobHour = 23
JobMin = 40

[Rule]
AttackSpareDelay = 200

[Economy]
Default_MgrVal =1000
Default_TaxVal =33
;Default_OreVal =10000
Default_OreVal =3500
2010/10/20_MgrVal = 2000
2010/10/20_TaxVal = 66

[HolySystem]
KeeperCreateMap = resources
KeeperCreateDummy = dk0001
KeeperActiveDummy = hskactdum
KeeperCenterDummy = dk0001
KeeperMonsterCode = 04903

StoneNum = 3

StoneCreateMap0 = resources
StoneCreateDummy0 = dh001
StoneMonsterCode0 = 04B01
StoneMasterRace0 = 0

StoneCreateMap1 = resources
StoneCreateDummy1 = dh002
StoneMonsterCode1 = 04B02
StoneMasterRace1 = 1

StoneCreateMap2 = resources
StoneCreateDummy2 = dh003
StoneMonsterCode2 = 04B03
StoneMasterRace2 = 2
QuestInit=0

[Schedule]
ScheduleInit=0

[Formula]
StdDefPoint=3
RcvDefPoint=10

[Buddha Event]
Enable = FALSE
GiveItem = irpre01
ExchangeItem = irpre01

[CLASS REFINE EVENT]
ENABLE = FALSE
START_DATE = 20101010
END_DATE = 20110101
LIMIT_COUNT = 3

[PcBang Favor]
USE = FALSE

[Time Limit]
Use = FALSE

CNT = 3
Time_0 = 0
Time_1 = 300
Time_2 = 500

Percent_0 = 1.0
Percent_1 = 0.5
Percent_2 = 0.0

LogoutTerm = 10
NotifyTerm = 2

[VersionCheck]
Ver_CheckKey = Êëþ÷ ïðèâÿçêè êëèåíòà. <<< rem out this line for rf version check
<<< ;Ver_CheckKey = Êëþ÷ ïðèâÿçêè êëèåíòà.
===========end of file==================

open up F:\RF v2.2.3.2 Server\ZoneServer\RF_Bin\fireguard edit the ini files

======
fg.ini
======
[Game Server]
Server Name = RF_LEET <<< change to your desire Server Name ^^

[FireGuard Server]
Server IP = ÂÀØ IP
Server PORT = 15444

[Detect Info]
Time Interval = 180000
===========end of file==================

========
fgrs.ini
========
[Game Server]
Game Name = rfonline_levelup
Server Name = RF_LEET <<< change to your desire Server Name ^^
Port = 15445

[FireGuard Server]
Server URL =
Server Port = 80

[Detect Info]
Time Interval = 5000

[FireGuard Use]
Use = no <<< change from NO to FALSE
===========end of file==================

To change Server Rate open up ServerRate.ini in the zoneserver > RF_Bin > Initialize
it pretty self explainatory.. ^^

Note: word of caution if u set ItemRootRate = 8.5 above 10 it will crash your
server all the time ^^ well it crash all the time on my pc so i not sure
pc spec. 8gb ram, intel dual core 9600

8. Add (normal) user test:test to RF_User.rfaccount MSSQL Query:

INSERT INTO RF_USER.dbo.tbl_rfaccount (Id,Password,accounttype,email,birthdate) VALUES ((CONVERT (binary(16),'test')),(CONVERT (binary(24),'test')),'1','test@mailinator.com','01/01/1980')

copy that string to your MSSQL Query and execute it

Add a GM account MSSQL Query:

USE RF_User Insert Into tbl_StaffAccount (ID,PW,Grade,Depart,RealName,SubGrade,Birthday,ComClass) Values (Convert(binary,'!teste'),convert(binary,'teste'),'2','none','teste','4','01/01/1991','GM')

copy that string to your MSSQL Query and execute it

Add the GM information to Login_Filter_Dev.ini.

(EX:
[ID]
FilterNum = 1
Filter0 = !karasss <<< change to your GM User Account (ex: !rfadmin)

==============================
then load up :

accountserversd.exe
billingserver.exe
loginserver.exe remember to in /open
zonserver64bit.exe

Nb : Can Use EQG Client For Up 
 
Sumber : http://forum.ragezone.com