[HOW-TO] Setup 9.1

S:app.name:Game001
T:auth.server_idx:1
S:auth.server_name:TEST
S:db.c.account:sa
S:db.c.name:Arcadia
S:db.c.server:127.0.0.1
S:db.user.account:sa
S:db.user.server:127.0.0.1
S:db.user.name:Telecaster
N:io.port:4514
S:io.auth.ip:127.0.0.1
S:io.ip_address:127.0.0.1
S:log.chat.ip:127.0.0.1
S:log.ip:127.0.0.1
T:log.chat.working:1
T:log.working:0
F:game.exp_rate:30
F:game.ally_pcbang_bonus_rate:0.1
F:game.ally_pcbang_chaos_bonus_rate:0.1
T:game.update.version:24
F:game.gold_drop_rate:50
F:game.item_drop_rate:20
T:game.max_level:180
T:game.PKServer:1
T:game.AdultServer:0
T:game.cash_usable_server:1
N:game.local_flag:8192
T:game.min_global_chat_usable_level:80
T:game.use_auto_trap:0
T:game.use_auto_jail:0
N:CodePage:1256
T:game.ServiceServer:0
N:console.port:65528
S:console.allow_ip:127.0.0.1
S:console._password:
S:io.upload.ip:127.0.0.1
S:io.upload.port:4616
S:game.guild_icon_base_url:[Only registered and activated users can see links. Click Here To Register...]
S:game.url_list:guild.url|[Only registered and activated users can see links. Click Here To Register...]

S:game.server_screenshot_url:[Only registered and activated users can see links. Click Here To Register...]
S:game.helpdesk_url:Help page 1
S:game.newbiehelp_asura_url:Asura
S:game.newbiehelp_deva_url:Deva
S:game.newbiehelp_gaia_url:Gaia
S:game.local_setting_list:log.ip|log.chat.ip|io.au th.ip|io.ip_address|db.c.server|db.user.server|N game.periodical_npc_adjustment
T:game.disable_trade:0
T:game.disable_booth:0
T:game.enhance_fail_type:2
T:game.monster_pathfinding:1
T:game.monster_wandering:1
T:game.no_collision_check:0
T:game.no_skill_cooltime:0
N:game.item_hold_time:2500
T:db.user.thread:4

S db.auth.server:127.0.0.1
S db.auth.name:Auth
S db.auth.account:sa
S db.auth._password:
S app.name:Auth Server
S log.ip:127.0.0.1
S db.auth.port:1433
S io.auth.port:8841
N db.auth.use_webauth:0
N db.auth.use_md5:1
N db.auth.debug_md5:1
N db.auth.md5_key:2011

RappelzCmdLauncher.exe sframe.exe /auth_ip:127.0.0.1 /use_nprotect:0 /help_url_w:611 /help_url_h:625 /locale:ASCII /country:ME /use_nprotect:0 /cash /commercial_shop /layout_dir:6 /layout_auto:0 /cash_url_w:800 /cash_url_h:631

S:app.name:AuthServer
S:auth.allowed_special_char:@.
N:auth.check_adult_server:0
N:auth.max_client_per_ip:9999
N:auth.max_daily_client_per_ip:9999999
N:auth.user_rate_mod:20
N:auth.version:200701120
S:db.auth.account:sa
S:db.auth.md5_key:2011
S:db.auth.name:Auth
S:db.auth.server:127.0.0.1
N:io.auth.port:8841
S:db.billing.account:sa
S:db.billing.name:BILLING
S:db.billing.server:127.0.0.1
N:db.auth.use_md5:1
N:db.auth.use_md5_for_security_no:1
N:game.user_limit_server_001:500
S:log.ip:127.0.0.1
N:billing.allow_login_without_billing:1
N:billing.check_server_keep_alive_timeout:0
N:billing.server_keep_alive_interval:6000
N:billing.server_keep_alive_timeout:3000
N:billing.use:1
N:billing.user_keep_alive_interval:60000
N:billing.user_keep_alive_timeout:3000
N:console.port:1995
S:console.allow_ip:127.0.0.1
S:console.ip:127.0.0.1
S:console._password:

#Write trace log messages to file and show only info log messages on console
core.log.level:trace
core.log.consolelevel:info

#Enable traffic dump, will be in traffic_log folder (default off)
#trafficdump.enable:true

#The password is in plain text if you have one
auth.db.password:
auth.db.salt:2011
#You can make auth.dbo.Accounts.[password] by visiting:
# md5 Hash Generator (KEY+PASSWORD = hashed password)[No spaces between KEY and PASSWORD]
# Copy the resulting md5 into the password field of your account entry


#Where clients will connect (this is default values)
auth.clients.ip:127.0.0.1
auth.clients.port:58422
auth.clients.des_key:

#Where the gameserver will connect (this is default values)
auth.gameserver.ip:127.0.0.1
auth.gameserver.port:4502

#Upload configuration, use "upload" directory for guild icons
upload.dir=upload
upload.clients.ip=127.0.0.1
upload.clients.port=32214
#Use port 5000 for the guild icon mini webserver (the listen ip is also upload.clients.ip)
upload.clients.webport:5000

#Where the gameserver will connect (this is default values)
upload.gameserver.ip:127.0.0.1
upload.gameserver.port:4616

#Only for SQL Server: speed up selects with NOLOCK
sql.db_account.query:SELECT * FROM Accounts WITH(NOLOCK) WHERE login_name = ? AND password = ?;

2017-05-29 14:50:25 Info DbConnectionPool0: Checking connection to "driver=SQL Server;Server=127.0.0.1,1433;Database=Auth;UID=sa; PWD=;"
2017-05-29 14:50:25 Info ODBC: SQLDriverConnect: additional info:
2017-05-29 14:50:25 Info ODBC: 01000:1:5701:[Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'Auth'.
2017-05-29 14:50:25 Info ODBC: 01000:2:5703:[Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english.
2017-05-29 14:50:25 Info DbConnectionPool0: Connection ok
2017-05-29 14:50:25 Info ServersManager0: Starting server auth.clients on 0.0.0.0:4500
2017-05-29 14:50:25 Info ServersManager0: Starting server auth.billing on 127.0.0.1:4503
2017-05-29 14:50:25 Info ServersManager0: Starting server auth.gameserver on 127.0.0.1:4502
2017-05-29 14:50:25 Info ServersManager0: Starting server upload.gameserver on 127.0.0.1:4616
2017-05-29 14:50:25 Info ServersManager0: Starting server upload.clients on 0.0.0.0:4617
2017-05-29 14:50:25 Info ServersManager0: Starting server upload.iconserver on 0.0.0.0:80
2017-05-29 14:50:25 Info ServersManager0: Starting server admin.telnet on 127.0.0.1:4501

#Database configuration
auth.db.server:127.0.0.1
auth.db.port:1433
auth.db.name:auth
auth.db.account:sa

auth.clients.maxpublicserveridx:10

#Server Index Offset Column Name
sql.db_account.column.serveridxoffset:server_list_ mask

#include config in common.opt
%include:common.opt

#Write trace log messages to file and show only info log messages on console
core.log.level:trace
core.log.consolelevel:info

#Enable traffic dump, will be in traffic_log folder (default off)
#trafficdump.enable:true

#The password is in plain text if you have one
auth.db.password:chomp.crestless.chip.unsaved.bobb le.blaspheme
auth.db.salt:5dd23
#You can make auth.dbo.Accounts.[password] by visiting:
# [Only registered and activated users can see links. Click Here To Register...] (KEY+PASSWORD = hashed password)[No spaces between KEY and PASSWORD]
# Copy the resulting md5 into the password field of your account entry


#Where clients will connect (this is default values)
auth.clients.ip:127.0.0.1
auth.clients.port:58422
auth.clients.des_key:MERONG

#Where the gameserver will connect (this is default values)
auth.gameserver.ip:127.0.0.1
auth.gameserver.port:4502

#Upload configuration, use "upload" directory for guild icons
upload.dir=upload
upload.clients.ip=0.0.0.0
upload.clients.port=32214
#Use port 5000 for the guild icon mini webserver (the listen ip is also upload.clients.ip)
upload.clients.webport:5000

#Where the gameserver will connect (this is default values)
upload.gameserver.ip:127.0.0.1
upload.gameserver.port:4616

#Only for SQL Server: speed up selects with NOLOCK
sql.db_account.query:SELECT * FROM Accounts WITH(NOLOCK) WHERE login_name = ? AND password = ?;

S:app.name:Rappelzz
T:auth.server_idx:1
S:auth.server_name:Rappelzz
S:db.c.server:127.0.0.1
S:db.c.name:arcadia
S:db.c.account:sa
S:db.c._password:4556000003005c1beb41f504a57f614be 3f0d311a185be8e99c098ae22e207f17e16c0d982b348d2cff 0e9a397359992534fd575e6ef87d217444a6e6e6e4119134b6 e
S:db.user.server:127.0.0.1
S:db.user.name:telecaster
S:db.user.account:sa
S:db.user._password:4556000003005d34b394c8c354f03c a2ba2804abd9494862c20b45e22877812617e3ef1d295d8f67 761092b74727e5ca11c57dab53c5e68b70913bc3a291d7cbcb cbfd1e865bcb
N:io.port:15574
S:io.auth.ip:127.0.0.1
S:io.ip_address:127.0.0.1
S:log.chat.ip:127.0.0.1
S:log.ip:127.0.0.1
T:log.chat.working:0
T:log.working:0
T:log.disable:1
S:game.mem_usage_info_save_interval:9999999
F:game.base_ethereal_durability_consumption_on_dam age:.30
F:game.base_ethereal_durability_consumption_on_ski ll_attack:.40
F:game.base_ethereal_durability_consumption_on_nor mal_attack:.10
F:game.pvp_damage_rate_for_summon:.12
F:game.pvp_damage_rate_for_player:.08
S game.exp_rate:8
S game.item_drop_rate:7
S game.gold_drop_rate:10
S game.chaos_drop_rate:5
T game.apply_stamina_bonus_in_premium_pcb:0
F game.premium_pcbang_bonus_rate:.30
F game.premium_pcbang_chaos_bonus_rate:.30
F game.premium_pcbang_gold_bonus_drop_rate:.30
F game.premium_pcbang_item_bonus_drop_rate:.30
F game.premium_pcbang_chaos_bonus_drop_rate:.30
F game.ally_pcbang_bonus_rate:.30
S game.ally_pcbang_chaos_bonus_rate:.30
T:game.update.version:24
T:game.max_level:180
T:game.PKServer:0
T:game.AdultServer:0
T:game.cash_usable_server:1
S:game.local_flag:4
T:game.min_global_chat_usable_level:10
T:game.use_auto_trap:0
T:game.use_auto_jail:0
T:game.ServiceServer:0
N:console.port:44554
S:console.allow_ip:127.0.0.1
S:console._password:REPLACE.ME.WITH.PYROK.TOOL.GEN ERATED.PASSWORD
S:io.upload.ip:127.0.0.1
S:io.upload.port:4616
S:game.guild_icon_base_url:[Only registered and activated users can see links. Click Here To Register...]
S:game.url_list:guild.url|[Only registered and activated users can see links. Click Here To Register...]

S:game.server_screenshot_url:[Only registered and activated users can see links. Click Here To Register...]
S:game.helpdesk_url:[Only registered and activated users can see links. Click Here To Register...]
S:game.newbiehelp_asura_url:[Only registered and activated users can see links. Click Here To Register...]
S:game.newbiehelp_deva_url:[Only registered and activated users can see links. Click Here To Register...]
S:game.newbiehelp_gaia_url:[Only registered and activated users can see links. Click Here To Register...]
S:game.local_setting_list:log.ip|log.chat.ip|io.au th.ip|io.ip_address|db.c.server|db.user.server|N game.periodical_npc_adjustment
T:game.disable_trade:0
T:game.disable_booth:0
S:game.enhance_fail_type:2
T:game.monster_pathfinding:1
T:game.monster_wandering:1
T:game.no_collision_check:0
T:game.no_skill_cooltime:0
N:game.item_hold_time:2500
T:db.user.thread:4