[Guide]How to Create 9.4 Server !

[Dark Blaze]

Originally Posted by asthos

AtFirst:
Thanks for the very fast help. I think here is a good community in work

So now this works,
as a hint:
if you want to see which statement you post in the Server press "F1".
So i can see that i type the right commands.

but if i choose the Server, i get the following Error:
"Your ID or password is incorrect. Remember: passwords are case sensitive"
Which password is here incorrect? Because i used the same steps in the tutorial.

Edit:
The Post at:didn't help me

for one try i deactivated my firewall and the problem is still alive.

In the DB it is the following entry in the dbo.account:

1 Atif ecfade2836414c54b8289c496820fe10 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

Try creating an account using my tool I posted earlier.

[asthos]

Originally Posted by Dark Blaze

Try creating an account using my tool I posted earlier.

Sorry, but creating an account by a new tool couldn't be the awnser.
Other users took also the guide and they haven't this problem

[Rappler007]

Probably a stupid question, but has anyone else the bug that Hector spawns instead of a Bloodthirsty Slaughterer (not sure if translated correctly) and a Crystal Golem, a BS and a second hector? I basically allows infinite Hector farming (if you can tank him) - how to fix that? The ETC_run_monster_skill.lua (b8cc3ff6320d2159aa5fae32d4fe7fce.lua) is really short (not even 100 rows) and the trigger function just points to a monster_skill_cast function.

[ThunderNikk]

Originally Posted by asthos

AtFirst:
Thanks for the very fast help. I think here is a good community in work

So now this works,
as a hint:
if you want to see which statement you post in the Server press "F1".
So i can see that i type the right commands.

but if i choose the Server, i get the following Error:
"Your ID or password is incorrect. Remember: passwords are case sensitive"
Which password is here incorrect? Because i used the same steps in the tutorial.

Edit:
The Post at:didn't help me

for one try i deactivated my firewall and the problem is still alive.

In the DB it is the following entry in the dbo.account:

1 Atif ecfade2836414c54b8289c496820fe10 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

So the guide states this.

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', 'ecfade2836414c54b8289c496820fe10', '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'); 


change the username and pass plz.

So if you were following the guide you should have a different user and pass in your account table.

Yet your user is the same and the password is most certainly the same.

So do you know what the password in the guide had for salt? Because if your salt in your auth .opt does not match the salt that the password was made with even if you know what the password was supposed to be with the wrong salt it is completely different.

So I would start by 1. changing the user name.

2. Read your auth.opt and find out what your salt is

3. Go to the md5 site for md5 hashing passwords and put in what your salt is and what you want for a password like the following.



Jose finds out his salt is 2011

He wants a password that is "password"

He goes to miracle salad md5 generating site and enters "2011password" into the box

He presses the generate button and makes a password that is md5 hashed with his salt and copies that into his database password column.

He now hopes people understand better how to create md5 passwords for Rappelz accounts.

[ahmsam]

i actually solved the problem by changing the ip on all the file including the launcher.. i had them at 127.0.0.1 but when i checked my local ip it was something different so please make sure you have the right ip in all files.

[ThunderNikk]

127.0.0.1 is local host and as long as everything is on the same computer it will run local host.

[asthos]

I tried to change the id's of the gameserver.opt from:

S:io.upload.ip:51.254.58.230
S:io.ip_address:103.249.70.106

to:

S:io.upload.ip:127.0.0.1
S:io.ip_address:127.0.0.1

and it works.
After i change the id i fond this hint here:

Originally Posted by ahmsam

i actually solved the problem by changing the ip on all the file including the launcher.. i had them at 127.0.0.1 but when i checked my local ip it was something different so please make sure you have the right ip in all files.

So at all the creation of a new user wasn't the problem (because i could select the server ...)

Thank you for the good cooperation and help, even if it was a little bit incomprehensible, we have nevertheless come to a goal.
All right, now I'm testing the 9.4 world

ok there is a too long loading screen ...
it seems Rappelz won't let me test myself
does anybody had the same symptoms?

[ThunderNikk]

Test with the sframe that came with the release or the one that was released here yesterday to fix durability issues...



Thanks to Ghost

[asthos]

OK Thanks 4 all hints and the very fast awnsers.

Now it works all fine.
Now i can test my server

[アルカード]

@ can we make this sticky thread?��

[thefear511]

Originally Posted by アルカード

@ can we make this sticky thread?��

would be nice since most related issues to creating servers has been answered here, instead of digging up the help thread ^^ and it also contains a demonstration video.

[ThunderNikk]

Originally Posted by アルカード

@ can we make this sticky thread?��

If there was a German translation in the OP I could, but I am not sure if it is necessary since the original guide with the German translation has links to both the 9.1 guide and this guide. It is also linked in LamiaCore's collection thread.

[アルカード]

Originally Posted by ThunderNikk

If there was a German translation in the OP I could, but I am not sure if it is necessary since the original guide with the German translation has links to both the 9.1 guide and this guide. It is also linked in LamiaCore's collection thread.

Mayve lamia or somebody could traslate it to german since before my comment this thread was on 2nd page

[ThunderNikk]

Most of the original guide is in spoilers so the link to the newer guides is not really that hard to find...



Yet even on the second page it is still linked in the sticky guides...so if they are not looking at those???...

[InkDevil]

Originally Posted by アルカード

Mayve lamia or somebody could traslate it to german since before my comment this thread was on 2nd page

Hallo Elitepvpler,
heute möchte ich mein Wissen mit euch teilen und habe eine Anleitung vom Entfernen bisheriger SQL-Versionen bishin zum Betreten eures Servers erstellt.

Anforderungen:

• ein funktionstüchtiges Hirn und zwei Augen
• ein 64-bit Betriebssystem
• Windows 7 oder neuer [die 2012er SQL-Express-Version ist auch ok]
• 4 GB ram
• 30 GB Festplattenspeicher

Schritt 1: Entfernen aller SQL-Dateien
"Gehe sicher, dass du auch alle Dateien sowie Ordner vom PC entfernst!"

 Spoiler

Schritt 1.1: Löschen (Fortgeschritten - WICHTIG!!)

 Spoiler

1. Deinstalliere alle SQL-Server Komponenten - du kannst hierfür die Systemsteuerung benutzen -> Programme und Features

2. Eine Sicherung eurer Registry machen.(--Falls du Scheiße baust und es wieder rückgängig machen willst--)

3. Lösche die folgenden Ordner via regedit:


--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

--HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer

4. Gehe zu HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Curr entVersion\Uninstall und lösche alle Unterschlüssel in Verbindung mit SQL Server.
(-- falls es nicht "SQL" im namen hat, überspringe es --)
5. Gehe zu HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es und lösche alle Schlüssel in Verbindung zu SQL Server.
(-- falls es nicht "SQL" im namen hat, überspringe es --)
C:\Program Files\Microsoft SQL Server and subfolders.

Schritt 2:Neue Installation von SQL

 Spoiler

Du kannst WinRar benutzen um die Dateien aus der .iso zu extrahieren







Hier kannst du eine benannte oder unbenannte Instanz auswählen, wie du möchtest :P

(--Vergiss nicht den aktuelle Nutzer hinzuzufügen, falls dieser nicht aufgelistet ist!--)




Ich hab 123456 benutzt, und niemals einen Fehler bekommen - also schlage ich euch das für einen lokalen Server vor :P
(--Vergiss nicht den aktuelle Nutzer hinzuzufügen, falls dieser nicht aufgelistet ist!--)






Für den Download, siehe unten im >>>Download<<<-Bereich.

Schritt 3: SQL Konfiguration

 Spoiler

Wechsle den TCP dynamic port zu 1433 .
Stelle sicher, dass alle protokolle freigeschaltet sind.
Nun gehe sicher alle Dienste neu zu starten

Schritt 4: Datenbanken wiederherstellen

 Spoiler

Nun da dein SQL und die protokolle eingestellt sind, fahre fort und starte das SQL Server 2014 Management Studio ,








Vergiss nicht den pfad und den namen abzuändern!


Falls deine Telecaster [Telecaster94] heißt, ändere sie zu [Telecaster], damit du meine .opt-Dateien nutzen kannst wenn du willst.

Schritt 5: Den Rappelz-Server starten

 Spoiler

Du musst du die .opt-Dateien und luas einstellen.
Lösche alle .ela-Dateien im Script-Ordner und füge die .lua-Dateien ein.




Zu startende Anwendungen:
LogServer.exe --->Der Log-Server, diesr muss zuerst gestartet werden.
ChatLog.exe --->Chat Log Server.
PrincessAuroraServer.exe--> Folgende befehle musst du nach dem Starten ohne Klammern eingeben damit die Spieler einloggen können: (start_service)(set game.open_external 1)
ServerLauncher64.exe ---> Wenn du möchtest, dass dein Server automatisch wieder hochfährt, gebe hier folgenden Befehl ohne Klammern ein: (start_auto_launch)
UploadServer.exe--> Upload server.(nicht benötigt, falls du keine Gildenicons hochladen willst.)
CaptainHerlockServer.exe-->Game server.

Schritt 6: Den Rappelz-Client starten/startfähig machen(auf Seiten des Clients, versteht sich)

 Spoiler

Relativ einfach, alles was du brauchst, sind Client und Launcher sowie die dlls, die hier mit angehängt sind,und die sframe aus dem Ordner der Serverfiles.

Downloads:

 Spoiler

(-DANKE AN @-)
(--thx to Royal & revolution--)
(just execute it in sql) (--thx to me--)

(--thx to me--)
(--me--)
(--me--)
(thx to @ --)

.opt-Inhalte ( falls du's nicht runterladen möchtest)
gameserver.opt

 Spoiler

PHP Code:

S:app.name:RevolutionGS
N:auth.server_idx:1
S:auth.server_name:RevolutionOfficial
S:db.c.name:Arcadia
S:db.c._password:45560000030029e3d02907fe185509ba2cd329d62d2d2d2b02b5082d
S:db.c.account:sa
S:db.c.server:127.0.0.1
S:db.user._password:45560000030029e3d02907fe185509ba2cd329d62d2d2d2b02b5082d
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:@.
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:0.6
F:game.exp_rate:40
F:game.gold_drop_rate:40
F:game.item_drop_rate:25
N:game.local_flag:8192
N:game.max_level:190
N:game.PKServer:1
F:game.premium_pcbang_bonus_rate:1
F:game.premium_pcbang_chaos_bonus_rate:0.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|51.254.58.230|guild_icon_upload.port|4615
N:game.version:201507080
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:127.0.0.1
N:io.port:49999
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.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:50
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:40
F:game.party_exp_rate_1:40
F:game.party_exp_rate_2:41
F:game.party_exp_rate_3:41
F:game.party_exp_rate_4:42
F:game.party_exp_rate_5:42
F:game.party_exp_rate_6:43
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 


authserver.opt

 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:127.0.0.1
S:db.auth._password:45560000030029e3d02907fe185509ba2cd329d62d2d2d2b02b5082d
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: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 


Script zum Erstellen eines Accounts (-- danke an @--)

 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', 'ecfade2836414c54b8289c496820fe10', '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'); 


Bitte deinen usernamen sowie dein gehashtes Passwort eintragen.

Das Telecaster-Script umfasst zu viele Zeilen um es hier reinzuschreiben... einfach runterladen.



Video tutorial [added]

Das ist alles, hoffe ich.
Ich werde den Thread weiterhin updaten wenn es was neues gibt, und wünsche euch viel Glück!
@

Ich übernehme keine Verantwortung für den Inhalt dieses Guides! xD
//
I do not take responsibility for the content of this guide! xD