[HOW-TO]Setup Newest Release + Ports + Guild Icon

[Rappelz-Zesua]

This helped a lot of people and has been nulled so I am un-nuling it!

Warnings!

 Spoiler

1) 7.4 v2 aKa the Latest Release requires a v2 Sframe and 7.4 client!
- Download Sframe for v2
2) Failure to follow this guide in it's entirety will result in complications!
3) This guide will not support adding any 8.1 Content!
4) This guide will not support any release but the one linked within the tutorial! -- Credits to GamePortal
5) This guide does not support Local Hosts/Hamachi or Personal Computer Hosts!

You have been warned!

1) Download AND install

Instructions + Screenshots:

 Spoiler

Figures 1-9

 Spoiler

- Select the 64-Bit version [Figure 1]
- Execute the SQL Server Installer [Figure 2]
- Locate the SQL folder created by the Installer and launch Setup.exe [Figure 3]
- Click Next on the Firewall Warning it isn't important [Figure 4]
- Select "Perform a New Installation" [Figure 5]
- Select "Feature Installation" [Figure 6]
- Check all boxes checked [Figure 7]
- During installation make sure to do a "NAMED INSTANCE" [Figure 8]
- During installation make sure to set MIXED AUTHENTICATION and set a PASSWORD and USER [Figure 9]

Figure 1

 Spoiler

Figure 2

 Spoiler

Figure 3

 Spoiler

Figure 4

 Spoiler

Figure 5

 Spoiler

Figure 6

 Spoiler

Figure 7

 Spoiler

Figure 8

 Spoiler

Figure 9

 Spoiler

2) Open SQL Server Configuration Manager
Example:

 Spoiler

Instructions + Screenshots

 Spoiler

Figures 1 & 2

 Spoiler

Figure 1

 Spoiler

Figure 2

 Spoiler

- In the config manager click the + beside SQL Server Network Configuration [Figure 1]
- Double click Protocols for "YOUR_SERVER_NAME" [Figure 1]
- You will see Shared Memory, Named Pipes, TCP/IP make sure all are "Enabled" [Figure 1]
- Right click TCP/IP and click properties [Figure 2]
- Click the second tab and scroll to the bottom, change the dynamic port to 1433 [Figure 2]

3) Open Windows Advanced Firewall
Examples:

 Spoiler

Instructions

 Spoiler

- Click "Inbound Rules" click "New Rule" and open Port 1433 for TCP and name it "Database" [Example 1 + 2]

Example 1:

 Spoiler

Example 2:

 Spoiler

4) Download and Extract this release (post #6) to your Desktop or Documents folder

Instructions

 Spoiler

- Located "DB or Database Backup" folder inside extracted files
- Relocate the DB backups to the root of your main hard-drive e.g. C:\
- Open Sql Server Management Studio
- Login with windows Authentication make sure it says (local)\your_server_name
- Right click Databases on the left hand tree, click "Restore Database"
- Restore all three databases in this fashion
- Double click "Security" on the left hand tree and then right click "Logins" and click "New Login"
- Set the desired name and click "Sql Authentication" bubble and type in a Mixed Cased Alphanumeric password e.g. THISisMYpassWORD265221 (Use DES Generator to create DES version -- will be used for gs/as opt)
- Uncheck Password Expiration
- Create a unique name and password for each database in this fashion
- After all three names have been created then right click the arcadia database and click properties
- Click "Files" on the left hand tree and in the box title "Owner" to the right click the "..."
- Now browse for the username that is relevant to the database and select it as the owner

Navigate to your extracted server files and open the following three files AuthServer.opt/GameServer.opt/UploadServer.opt and open RappelzCompress.exe
** I personally use both Intype and Notepad++ **
- Bring AuthServer.opt to focus
- Copy the spoiler information and complete the required fields
Note: It would be wise to use a completely MD5 Key, which can also be alphanumeric!
Note: S db.auth._password: this field expects a DES hash!


Auth Server

 Spoiler

S db.auth.server:127.0.0.1
S db.auth.name:auth_server_name
S db.auth.account:auth_account_name
S db.auth._password:auth_DES_password
S app.name:auth_app_designation
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:5412

Game Server

 Spoiler

S app.name:game001
S auth.server_idx:1
S auth.server_name:server_name

S db.user.work_total:nbr
S db.user.work_pending:nbr
S db.user.work_active:nbr
S db.user.thread_active:nbr
S db.user.thread_total:nbr

S console.port:4515
S console._password:telnet_DES_password

S db.game.ip:127.0.0.1

S db.c.name:arcadia_database_name
S db.c.server:127.0.0.1
S db.c.account:arcadia_account_name
S db.c._password:arcadia_DES_password

S db.user.name:telecaster_database_name
S db.user.server:127.0.0.1
S db.user.account:telecaster_account_name
S db.user._password:telecaster_DES_password

S io.auth.ip:your_external_ip
S io.ip_address:your_external_ip
S io.port:4504

S game.server_screenshot_url:url_of_your_screen_selection_html

S io.upload.port:4617
S io.upload.ip:your_website/external_ip
S game.guild_icon_base_url:http://your_website/external_ip/icons/
S game.url_list:guild_icon_upload.ip|your_website/external_ip|guild_icon_upload.port|4615

S game.use_auto_jail:0
S game.pvp_damage_rate_for_summon:.03
S game.pvp_damage_rate_for_player:.03
S game.use_storage_security:0
S game.check_storage_security_always:0
S game.use_delete_security:0
S game.mem_usage_info_save_interval:6000
S game.base_ethereal_durability_consumption:.35
S game.play_point_accumulate_term:6000
S game.play_point_accumulate_amount:10
S game.premium_pcbang_play_point_bonus_rate:2.5
S game.exp_rate:10
S game.item_drop_rate:12
S game.gold_drop_rate:12
S game.chaos_drop_rate:12
S game.party_drop_rate:2.5
S game.party_exp_rate:1.25
S game.apply_stamina_bonus_in_premium_pcb:.50
S game.premium_pcbang_bonus_rate:1.25
S game.premium_pcbang_chaos_bonus_rate:2
S game.premium_pcbang_gold_bonus_drop_rate:2.5
S game.premium_pcbang_item_bonus_drop_rate:2.5
S game.premium_pcbang_chaos_bonus_drop_rate:2.5
S game.ally_pcbang_bonus_rate:1.75
S game.ally_pcbang_chaos_bonus_rate:1.75

T game.pcbang_bonus_server:1
T game.use_play_point:0
T game.use_guild_donation_point:1
T game.use_login_logout_debug:1
T game.max_level:180
T game.use_auto_trap:0
T game.cash_usable_server:1
T game.no_collision_check:0
T game.no_skill_cooltime:0
T game.disable_huntaholic:0
S game.disable_huntaholic_timer:0
S game.huntaholic_timer:1
T game.disable_dungeon_raid_siege:0
N game.UseHackShield:0
N game.UseGameGuard:0
N game.skip_loading_attribute:1
N game.logout_timer:1
S log.disable:1
S log.working:0
S game.AdultServer:0
S game.PKServer:0
S game.disable_pk_on:0
S game.auction_process_request_min_interval:100
S game.auction_search_request_min_interval:100
S game.force_unregister_account_on_kick_fail:1
S game.min_global_chat_usable_level:20
S game.item_hold_time:11000


S memory.player_heap_size:1000
T game.max_storage_item_count:1000
T set_user_limit:50

Upload Server:

 Spoiler

S working_dir:C:\Users\Administrator\Documents\site\guild\icons\
S io.port:4615
S io.addr:0.0.0.0
S io.game_server.port:4617
S io.game_server.addr:0.0.0.0
S game.console.ip:your_external_ip

- When done editing all three files, save each and then open the folder of your server files and drag each file atop of RappelzCompress.exe (DO NOT CLICK OK UNTIL LAST FILE IS DROPPED ON COMPRESSOR)


Return to Windows Firewall and click "New Rule" Create rules for the following ports:
- 8841 (This is the only port your auth server will accept connections on) TCP
- 4504 (This is the only port your game server will accept connections on) TCP
- 4615 (Upload -- Guild Icon Port) TCP
- 4617 (Upload -- Guild Icon Port) TCP

At this point you should be done, I will be providing you with the Start.BAT arguments (which can be used in launchers) that enable guild icons

NOTE: This guide only supports the use of the ports included by default, change at your own risk!

 Spoiler

@ECHO OFF
START SFRAME /auth_ip:your_external_ip /auth_port:8841 /locale:ASCII /country:US /commercial_shop /cash /help_url_w:620 /help_url_h:633 /ghelp_url:"http://your_website/extenal_ip/help/" /guild.url:"http:/your_website/external_ip/icons/" /web_download:"your_website/external_ip" /guild_download.url:"/icons/" /rend

I will not provide any further support for anything mentioned in this tut, if you have a correction to make to my tut feel free to pm me. I also did not make this originally Original creator is ismokedrow

[Pyrochina]

There's already a guide stickied

[Azreil]

the link for that particular sframe is non working ...and could someone kindly share a link to an appropriate 7.4 client please...it would be heartily appreciated. (My search only yielded a 7.4 Dutch client.) Thank you kindly.

[Firastormei]

You can use server files and a normal 8.1 client.

[Azreil]

Originally Posted by Firastormei

You can use server files and a normal 8.1 client.

Thank you for the reply....I have tried these files and find them...interesting, but I haven't the know-how to debug them. (I have ACRE and notepad ++...but I lack the knowledge of actually knowing where to look within the files and knowing exactly what to do to fix all the empty strings and invisible npcs.)
Ive some 7.4 files that are almost complete replica of standard ....but I've suffered a loss of a HD which contained my client 7.4.

So....again...thank you very much for the speedy reply....and I greatly appreciate the links to 8.1....but I really am needing a 7.4 client.
So, if anyone still has a 7.4 client....may I humbly request a link to that please?

Thank you guys so much for any consideration.