[Guide]How to Create 9.5.2 Server !

[thefear511]

sorry, there's no video this time. Gotta use brain.exe

lets start by saying the game looks pretty af

links :

 Spoiler

>>>****<<<

https://www.mediafire.com/file/dyq78oukidv678w/the_fu..king_final_sloution%21.rar/file

Create account script

 Spoiler

PHP Code:

 INSERT INTO [Auth].[dbo].[Account] ([account_id], [account], [password], [email], [password2], [block], [IP_user], [last_login_server_idx], [Admin], [point], [datePassword], [pk_], [creationDate_], [updateDate_], [creatorId_], [updatorId_], [portId_], [type_], [accessDate_]) VALUES ('3', 'Atif', '0742211052808e00c262f1c287addb98', 'atif@localhost', 'mohcen213', '0', '127.0.0.1', '1', '1', '0', '2017-10-20', '1', '2017-10-20 18:56:17.000', '2017-10-20 18:56:21.000', '2017-10-20 18:56:30.000', '2017-10-20 18:56:33.000', 'rappelz', 'rappelz', '0'); 


user: atif pass : atif

How?:

 Spoiler

simply the auth included with the files doesn't work, my conclusion is that it's trying to connect to an IP that is embbed in the app itself. I've tried all ways to work around it but it still doesn't do its job so it has been replaced by 9.4 auth along with its database.

herlock is working fine.

client: the client from official will give you disconnection the moment you pick the server, idk why maybe cuz their sframe detects something.
so instead I used revo's 9.5 English client.

DIY:

 Spoiler

Guide:

1-start by restoring all the databases in the folder , the telecaster.sql is an executable query that will make a 10gb database.you can get the original .bak one from the original topic but its 400 mgbs, however the .sql one needs to be tweaked before executing.
change the path of the hardware to your choosing C or D etc.

2-go to All .opts files change the hashed password to yours and also don't forget to change the databases names to work ex.



**important** S:db.auth.name:Auth94 This means your auth database in sql must be the same name as this one or change this one to be the same as the one you have in your sql**


3- change the "MSSQL12.FEAR010" to your sql "instance" name its located in "X:\Program Files\Microsoft SQL Server\MSSQL12.XX" where xx is the instance name.


4-after that restart your services for extra safety and run the files by this order (its not important all u need is auth&herlock but better safe than sorry)
Log>ChatLog>Upload>Patch>Auth>Herlock.

5-then do the commands inside auth "start_service" "set game.open_external 1".
6-you are ready, grab the revolution client i provided and my .bat launcher and then log into your account, have fun.

@
thx Revo.

Common errors

 Spoiler

*when I run launcher.bat nothing happens.
-get Rappelzcmdlauncher.exe from any other client

*when I write my id and pass nothing happens.
-make a new database called "Revosite" and make a table inside it called "maintenance" with 2 columns first is called "live" type = int.
2nd column is called "account_id" also type = int.

save the table and put new data inside column live "1" and data inside column account_id "0".

or simply run this query it will do everything automatically

 Spoiler

PHP Code:

CREATE DATABASE [RevoSite]
GO
USE [RevoSite]
CREATE TABLE [maintenance] ([live] int, [account_id] int)
INSERT INTO [dbo].[maintenance] VALUES (1, 0) 


please feel free to discuss anything related to the topic
and any questions about the process or issues.
#added client 9.5.2 and a pdf file guide.

[ThunderNikk]

Your media fire link is abbreviated.

[thefear511]

Originally Posted by ThunderNikk

Your media fire link is abbreviated.

i know i made 2 links one inserted with the text and one in a html code in case some browsers don't support it.

[introcorp]

thanks for tuto it was great
have a little problem i do everything but when i put start_service have text:
Game client acceptor initialise ... failed
adding game client acceptor to IOCP ... failed
can someone help please

[mlejnek2]

NULL


NVM found what i was looking for and tyvm again for the help as always

[thefear511]

Originally Posted by introcorp

thanks for tuto it was great
have a little problem i do everything but when i put start_service have text:
Game client acceptor initialise ... failed
adding game client acceptor to IOCP ... failed
can someone help please

check your IP settings.

[introcorp]

i check it's the same as yours 127.0.0.1 i put my opt
S:app.name:Auth
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:201507080
S:io.ip_address:127.0.0.1
S:db.auth._password:
S:db.auth.account:sa
S db.auth.port:1433
S:db.auth.md5_key:2011
S:db.auth.name:Auth
S:db.auth.server:127.0.0.1
N:io.auth.port:9881
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:400
S:log.ip:127.0.0.1
N:billing.allow_login_without_billing:0
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:0
N:billing.user_keep_alive_interval:60000
N:billing.user_keep_alive_timeout:3000

[ThunderNikk]

Both the auth server and game server are running when you put the commands in auth console and get the error?

[introcorp]

Yes both are running when i have the error

[ThunderNikk]

Whats you game server opt look like?

[brad777]

can you put the Auth.bak u used bro
i'm having the same prblm
Game client acceptor initialise ... failed
adding game client acceptor to IOCP ... failed

[thefear511]

Originally Posted by brad777

can you put the Auth.bak u used bro
i'm having the same prblm
Game client acceptor initialise ... failed
adding game client acceptor to IOCP ... failed

I can't open ur eyes more than this.

[rogy676]

U can use Auth 9.4 +

[introcorp]

my gameserver look like this

S:app.name:RevolutionGS
N:auth.server_idx:1
S:auth.server_name:RevolutionOfficial
#S:auth.server_name:Under maintenance
S:db.c.name:Arcadia
S:db.c._password:
S:db.c.account:sa
S:db.c.server:127.0.0.1
S:db.user._password:
S:db.user.account:sa
S:db.user.name:Telecaster
S:db.user.server:127.0.0.1
N:game.AdultServer:0
S:game.allowed_special_char:@.
S:console._password:
F:game.ally_pcbang_bonus_rate:0.1
F:game.ally_pcbang_chaos_bonus_rate:0.1
N:game.cash_usable_server:1
F:game.chaos_drop_rate:1.000000
#N:game.ela_count:40
F:game.exp_rate:30
F:game.gold_drop_rate:49
F:game.mod:0.200000
F:game.item_drop_rate:32
N:game.local_flag:8192
N:io.use_message_statistics:0
N:game.pcbang_bonus_server:0
F:game.premium_pcbang_bonus_rate:1.000000
F:game.premium_pcbang_chaos_bonus_rate:0.100000
N:game.max_level:200
N:game.PKServer:1
F:game.pvp_damage_rate_for_player:0.01
F:game.pvp_damage_rate_for_summon:0.035
N:game.use_auto_trap:0
N:game.use_auto_jail:0
N:game.use_delete_security:0
N:game.use_guild_donation_point:0
N:game.use_play_point:0
N:game.use_security:0
N:CodePage:1256
N:game.ServiceServer:1
S:game.guild_icon_base_url:
S:game.helpdesk_url:
S:game.newbiehelp_asura_url:
S:game.newbiehelp_deva_url:
S:game.newbiehelp_gaia_url:
S:game.resource:Resource
S:game.server_screenshot_url:
N:game.update.version:17
S:game.url_list:guild.url|
N:game.version:20180117

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
S:io.ip_address:127.0.0.1
#S:io.ip_address:54.38.164.109
N:io.port:34391
T:game.enhance_fail_type:2
S:io.user_count_ip_mask:127.0.0.1
S:log.ip:127.0.0.1
S:log.working:1
S:io.upload.ip:127.0.0.1
S:io.upload.port:4617
S:upload.server_name:RevolutionUpload
N:game.disable_trade:0
N:game.disable_booth:0
N:db.user.thread:4
N:console.port:44452
T:game.min_global_chat_usable_level:80
S:console.allow_ip:127.0.0.1
N:game.PKPenaltyLevel:10
N:game.use_account_authority_db:1
N:game.use_time_based_event_db:0
N:game.term_for_time_based_event_db:0
N:game.use_time_based_event_script:0
N:game.term_for_time_based_event_script:0
N:game.item_expert_cube :1
N:game.item_expert_grade:0
N:game.gold_drop_base:5000
F:game.gold_drop_percent:0.75
N:game.min_speed:1
N:game.amplify_level:0
N:game.amplify_hp:0
N:game.exception_arabic:0
N:game.exception_921:0
F:game.card_drop_rate:1.0
N:game.enhance_chance:1
N:game.enhance_chance_min:1
N:game.enhance_chance_max:10
N:game.enhance_destroy_level:8
F:game.quest_bonus_rate:4.0
N:game.quest_bonus_level:130.0
N:game.HardcoreServer:0
N:game.check_area:0
F:game.party_exp_rate_0:25
F:game.party_exp_rate_1:25
F:game.party_exp_rate_2:27
F:game.party_exp_rate_3:29
F:game.party_exp_rate_4:29
F:game.party_exp_rate_5:30
F:game.party_exp_rate_6:30
N:game.party_exp_penalty_level:5
N:game.summon_exp_penalty_level:10
F:game.killed_drop:0.03
I:game.crime_state:1
I:game.crime_party:1
F:game.killed_exp_percentage:1.0
F:game.kill_immoral_percentage:1.0
F:game.monster_regen_boss:5
F:game.monster_regen:5
N:game.max_characters_per_account:8
T:game.log.working:1
T:log.chat.working:1
N:game.ignore_client_binary:0
N:game.security_solution_type:0

[thefear511]

Originally Posted by introcorp

my gameserver look like this

S:app.name:RevolutionGS
N:auth.server_idx:1
S:auth.server_name:RevolutionOfficial
#S:auth.server_name:Under maintenance
S:db.c.name:Arcadia
S:db.c._password:
S:db.c.account:sa
S:db.c.server:127.0.0.1
S:db.user._password:
S:db.user.account:sa
S:db.user.name:Telecaster
S:db.user.server:127.0.0.1
N:game.AdultServer:0
S:game.allowed_special_char:@.
S:console._password:
F:game.ally_pcbang_bonus_rate:0.1
F:game.ally_pcbang_chaos_bonus_rate:0.1
N:game.cash_usable_server:1
F:game.chaos_drop_rate:1.000000
#N:game.ela_count:40
F:game.exp_rate:30
F:game.gold_drop_rate:49
F:game.mod:0.200000
F:game.item_drop_rate:32
N:game.local_flag:8192
N:io.use_message_statistics:0
N:game.pcbang_bonus_server:0
F:game.premium_pcbang_bonus_rate:1.000000
F:game.premium_pcbang_chaos_bonus_rate:0.100000
N:game.max_level:200
N:game.PKServer:1
F:game.pvp_damage_rate_for_player:0.01
F:game.pvp_damage_rate_for_summon:0.035
N:game.use_auto_trap:0
N:game.use_auto_jail:0
N:game.use_delete_security:0
N:game.use_guild_donation_point:0
N:game.use_play_point:0
N:game.use_security:0
N:CodePage:1256
N:game.ServiceServer:1
S:game.guild_icon_base_url:
S:game.helpdesk_url:
S:game.newbiehelp_asura_url:
S:game.newbiehelp_deva_url:
S:game.newbiehelp_gaia_url:
S:game.resource:Resource
S:game.server_screenshot_url:
N:game.update.version:17
S:game.url_list:guild.url|
N:game.version:20180117

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
S:io.ip_address:127.0.0.1
#S:io.ip_address:54.38.164.109
N:io.port:34391
T:game.enhance_fail_type:2
S:io.user_count_ip_mask:127.0.0.1
S:log.ip:127.0.0.1
S:log.working:1
S:io.upload.ip:127.0.0.1
S:io.upload.port:4617
S:upload.server_name:RevolutionUpload
N:game.disable_trade:0
N:game.disable_booth:0
N:db.user.thread:4
N:console.port:44452
T:game.min_global_chat_usable_level:80
S:console.allow_ip:127.0.0.1
N:game.PKPenaltyLevel:10
N:game.use_account_authority_db:1
N:game.use_time_based_event_db:0
N:game.term_for_time_based_event_db:0
N:game.use_time_based_event_script:0
N:game.term_for_time_based_event_script:0
N:game.item_expert_cube :1
N:game.item_expert_grade:0
N:game.gold_drop_base:5000
F:game.gold_drop_percent:0.75
N:game.min_speed:1
N:game.amplify_level:0
N:game.amplify_hp:0
N:game.exception_arabic:0
N:game.exception_921:0
F:game.card_drop_rate:1.0
N:game.enhance_chance:1
N:game.enhance_chance_min:1
N:game.enhance_chance_max:10
N:game.enhance_destroy_level:8
F:game.quest_bonus_rate:4.0
N:game.quest_bonus_level:130.0
N:game.HardcoreServer:0
N:game.check_area:0
F:game.party_exp_rate_0:25
F:game.party_exp_rate_1:25
F:game.party_exp_rate_2:27
F:game.party_exp_rate_3:29
F:game.party_exp_rate_4:29
F:game.party_exp_rate_5:30
F:game.party_exp_rate_6:30
N:game.party_exp_penalty_level:5
N:game.summon_exp_penalty_level:10
F:game.killed_drop:0.03
I:game.crime_state:1
I:game.crime_party:1
F:game.killed_exp_percentage:1.0
F:game.kill_immoral_percentage:1.0
F:game.monster_regen_boss:5
F:game.monster_regen:5
N:game.max_characters_per_account:8
T:game.log.working:1
T:log.chat.working:1
N:game.ignore_client_binary:0
N:game.security_solution_type:0

try these opts and tell me if it works
game server

 Spoiler

PHP Code:

S:app.name:RevolutionGS
N:auth.server_idx:1
S:auth.server_name:RevolutionOfficial
#S:auth.server_name:Under maintenance
S:db.c.name:Arcadia95
S:db.c._password:45560000030029e3d02907fe185509ba2cd329d62d2d2d2b02b5082d
S:db.c.account:sa
S:db.c.server:25.6.90.203
S:db.user._password:45560000030029e3d02907fe185509ba2cd329d62d2d2d2b02b5082d
S:db.user.account:sa
S:db.user.name:Telecaster95
S:db.user.server:25.6.90.203
N:game.AdultServer:0
S:game.allowed_special_char:@.
S:console._password:45560000030029e3d02907fe185509ba2cd329d62d2d2d2b02b5082d
F:game.ally_pcbang_bonus_rate:0.1
F:game.ally_pcbang_chaos_bonus_rate:0.1
N:game.cash_usable_server:1
F:game.chaos_drop_rate:1.000000
#N:game.ela_count:40
F:game.exp_rate:30
F:game.gold_drop_rate:49
F:game.mod:0.200000
F:game.item_drop_rate:32
N:game.local_flag:8192
N:io.use_message_statistics:0
N:game.pcbang_bonus_server:0
F:game.premium_pcbang_bonus_rate:1.000000
F:game.premium_pcbang_chaos_bonus_rate:0.100000
N:game.max_level:200
N:game.PKServer:1
F:game.pvp_damage_rate_for_player:0.01
F:game.pvp_damage_rate_for_summon:0.035
N:game.use_auto_trap:0
N:game.use_auto_jail:0
N:game.use_delete_security:0
N:game.use_guild_donation_point:0
N:game.use_play_point:0
N:game.use_security:0
N:CodePage:1256
N:game.ServiceServer:1
S:game.guild_icon_base_url:http://guilds.rappelz.ae/gicons/
S:game.helpdesk_url:http://help.gamepower7.com/help/help-page/help-page.html
S:game.newbiehelp_asura_url:http://help.gamepower7.com/help/info_asura.html
S:game.newbiehelp_deva_url:http://help.gamepower7.com/help/info_deva.html
S:game.newbiehelp_gaia_url:http://help.gamepower7.com/help/info_gaia.html
S:game.resource:Resource
S:game.server_screenshot_url:https://room.rappelz.ae/Launcher/AR/server.html
N:game.update.version:17
S:game.url_list:guild.url|http://guilds.rappelz.ae/gicons/|guild_test_download.url|gicons/|web_download|guilds.rappelz.ae|web_download_port|0|shop.url|http://room.rappelz.ae/shop.html|ghelp_url|http://help.gamepower7.com/help/help-page/help-page.html|guild_icon_upload.ip|25.6.90.203|guild_icon_upload.port|4615
N:game.version:20180117

S:game.local_setting_list:log.ip|log.chat.ip|io.auth.ip|io.ip_address|db.c.server|db.user.server|N game.periodical_npc_adjustment
S:io.ip_address:25.6.90.203
#S:io.ip_address:54.38.164.109
N:io.port:34391
T:game.enhance_fail_type:2
S:io.user_count_ip_mask:25.6.90.203
S:log.ip:25.6.90.203
S:log.working:1
S:io.upload.ip:25.6.90.203
S:io.upload.port:4617
S:upload.server_name:RevolutionUpload
N:game.disable_trade:0
N:game.disable_booth:0
N:db.user.thread:4
N:console.port:44452
T:game.min_global_chat_usable_level:80
S:console.allow_ip:25.6.90.203
N:game.PKPenaltyLevel:10
N:game.use_account_authority_db:1
N:game.use_time_based_event_db:0
N:game.term_for_time_based_event_db:0
N:game.use_time_based_event_script:0
N:game.term_for_time_based_event_script:0
N:game.item_expert_cube :1
N:game.item_expert_grade:0
N:game.gold_drop_base:5000
F:game.gold_drop_percent:0.75
N:game.min_speed:1
N:game.amplify_level:0
N:game.amplify_hp:0
N:game.exception_arabic:0
N:game.exception_921:0
F:game.card_drop_rate:1.0
N:game.enhance_chance:1
N:game.enhance_chance_min:1
N:game.enhance_chance_max:10
N:game.enhance_destroy_level:8
F:game.quest_bonus_rate:4.0
N:game.quest_bonus_level:130.0
N:game.HardcoreServer:0
N:game.check_area:0
F:game.party_exp_rate_0:25
F:game.party_exp_rate_1:25
F:game.party_exp_rate_2:27
F:game.party_exp_rate_3:29
F:game.party_exp_rate_4:29
F:game.party_exp_rate_5:30
F:game.party_exp_rate_6:30
N:game.party_exp_penalty_level:5
N:game.summon_exp_penalty_level:10
F:game.killed_drop:0.03
I:game.crime_state:1
I:game.crime_party:1
F:game.killed_exp_percentage:1.0
F:game.kill_immoral_percentage:1.0
F:game.monster_regen_boss:5
F:game.monster_regen:5
N:game.max_characters_per_account:8
T:game.log.working:1
T:log.chat.working:1
N:game.ignore_client_binary:0
N:game.security_solution_type:0 


auth

 Spoiler

PHP Code:

S:app.name:Auth
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:201507080
S:io.ip_address:25.6.90.203
S:db.auth._password:45560000030029e3d02907fe185509ba2cd329d62d2d2d2b02b5082d
S:db.auth.account:sa
S:db.auth.md5_key:2011
S:db.auth.name:Auth94
S:db.auth.server:25.6.90.203
N:io.auth.port:9881
S:db.billing.account:sa
S:db.billing.name:BILLING
S:db.billing.server:25.6.90.203
N:db.auth.use_md5:1
N:db.auth.use_md5_for_security_no:1
N:game.user_limit_server_001:400
S:log.ip:25.6.90.203
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