[Help Thread] Please post your questions here.

ThunderNikk · 09/02/2013, 01:38

If you are going to set a password for SA

It needs to be DES hashed in the .opt file

Easier for you I think to leave it blank like you have it, yet if you leave it blank you must be sure you have correctly set the data base "ownership" to SA and then properly blanked out the SA password according to the instructions in the guide.

I am not going to rewrite the guide here.

If you use a password use the DES hasher that is usually packaged with the server files to DES hash your SA password for the .opt files.

For a password of 123 it is going to be...

5e9dab01c5bbbbb8

In your .opt files

If SA does not own each of the databases (also explained thoroughly in the guide and I am not going to rewrite the guide here) it still would not let you log in until SA is declared the owner.

Your ports look correct, but if you did not configure your SQL installation properly for 1433 as explained in the guide then it will not work.

See the part of the guide on SQL configuration manager. Make sure you have configured the SQL port 1433 and make sure your services are running.

To summerize all of this...follow the guide.

ninex · 09/02/2013, 07:51

Quote:

Originally Posted by xyoyx

Hi all,
I want to do a server but I have a problem.
I do all Like the new tut, for installation of sql 2012, and all good.
The error is auth dB init error ...

I Know for the search Button etc ... But I have do all the other post say so ...
Ps : I have sql 2012, windows 8 64 bit and the 7.4-8.1 files ( Like the tutorial )
Maybe a problem With my .opt ?

Screen of the bug:

Spoiler

That happend to me and all i did was open mssql config stop and restart the sql server.

makerus · 09/02/2013, 15:54

hello, you can edit the file sdXwe'vmvdeHga $?

ThunderNikk · 09/02/2013, 17:40

Yes but if you are using English clients and launching with the ascii parameter it will not use that db_string.rdb it will use the db_string(ascii).rdb

It will have a hashed name of...

!PWS)3rDAd3O'`dU}deN

Check out the tools available...

foxdie3mibc · 09/03/2013, 12:30

HI,

I created a rappelz private server and now i got many questions hoping that some one would answer me please.

1-After loging in the hot keys were empty all of them how can i fix them?

2-How can i make a character with GM power of commands?

3-How can i edit the NPC,EXP %,Drop %, controlling every thing in other meaning?

4-once i loged in I saw a notice idk how it happen and the language was like "!#$%&&**(%^VDYTY^*#@@&*(HA%%$UN" what made that happen?

Thank you and please tell me every, thing i can add you on Skype if it would make it easier for you.

ThunderNikk · 09/03/2013, 14:48

1.

It was only 3 pages back in this thread, doing a little advanced searching and developer work on your own would help.

There are two solutions given for the hot key error in that thread, choose carefully. You don't need to use both of them but you will need to decide which one to work with.

2. Set the character permission in the Telecaster dbo.character table to 100

3. NPC

Exp% and Drop% you should have already seen them as they are set in the gameserver.opt you edited to get the server running. I am not a developer but I did sleep at a Holiday Inn Express last night.

4. Related to the hot key error.

Queeni · 09/03/2013, 17:01

Hallo wo kann ich einstellen das die drops schneller verschwinden?
----------------------------------
Hi where can I set the the drops disappear faster?

Habe es schon herausgefunden wer es nicht weiß das hier muss in die opt

N game.item_hold_time:1200

foxdie3mibc · 09/03/2013, 20:51

Quote:

Originally Posted by thndr

1.

It was only 3 pages back in this thread, doing a little advanced searching and developer work on your own would help.

There are two solutions given for the hot key error in that thread, choose carefully. You don't need to use both of them but you will need to decide which one to work with.

2. Set the character permission in the Telecaster dbo.character table to 100

3. NPC

Exp% and Drop% you should have already seen them as they are set in the gameserver.opt you edited to get the server running. I am not a developer but I did sleep at a Holiday Inn Express last night.

4. Related to the hot key error.

1-Worked and thank you.
2-Worked and thank you.
3-Worked and thank you.
4-Worked and thank you.

But if i may add some more questions..

1-I asked my friends to login and test the server and tell me all the issues but none of them could login the server although i was already logged in so how should i fix this?
Notice: I gaved them my launcher.bad and sframe

[[ I launched the Upload exe and still no one can connect but me..]]

2-How can i edit the dungeons/ Xmas decoration in town/ specific skill cool down(at the moment i can control all skills but i need only 1 skill)/ also i dont have MC class's and new pets(drill/ undine.. etc.) what should i do?

Thank you so much for your help..

Eldorm · 09/03/2013, 21:52

Hey ho ich hab nen kleines Problem und zwar hab ich nun alle dps immer wieder neu hergestellt aber immer wieder kommt der selbe fehler auth dp inet error kann mir da einer von euch helfen?

Jack80029 · 09/04/2013, 01:54

Guten Morgen,
Ich habe mir erst die 8.1 Standartfiles runtergeladen jedoch gingen dort
keine GM Tools nun habe ich das Arcadia Repack 1.3

Und es treten neue Probleme auf ich kann mich zwar einloggen mit
admin und admin als passwort jedoch dann drücke ich auf den Server und
es kommt die Nachricht Verbindung zum Server Unterbrochen

Ich habe einfach keine Ahnung mehr woran das liegen könnte und schreibe daher mal hier ein Beitrag eventuell weiß ja einer von euch mehr darüber

ich habe folgendes gemacht:

1) Ports Freigeschaltet
2) Benutzer sa in SQL 2012 das Passwort entfernt
3) Benutzer sa rechte gegeben für die Datenbanken damit es geht
4) Die Consolen Auth und Herlock sagen jeweils ok
5) Firewall sind alle Ports freigeschaltet
6) den Launcher aussem Arcadia Repack benutzt
7) Root Server neu gestartet
8) der Port 1433 ist freigeschaltet
9) Sframe und Launcher zur Ausnahme hinzugefügt.

Ich habe eigentlich so gut wie alles versucht doch jedes mal nachem
einloggen und Server klicken kommt Verbindung zum Server Unterbrochen,

Root Server Console

Einloggen:

Eingeloggt Perfekt:

Error:

Lieben Gruß Jack

Serarisha · 09/04/2013, 01:54

Hi Guys,

my old problem is solved. But i got a new one. Used the search function and google. I make my server like the one post here at forums. First was all fine, but some npcs and stuff didnt talk after there was a german letter, like ae, ue or oe (in german its ä,ü,ö), they just stop talking. so the we used the arcadia 1.3 repack for using admintools and stuff but now we have the problem that we all get a disconnect after we log in. its like, we try to choose a server an get the message "you have been disconnected from server!" we, like 4-5 persons, are living on diff places so it cant be a problem with the internet. all ports and stuff are free on the firewall.

thanks for help and sry for my english. didnt use it that much.

____________________

Hallo Leute,

ich habe ein Problem mit meinem Server. Ich habe ihn auf gesetzt wie hier im Forum beschrieben, habe auch schon google und und die SuFu benutzt. Also, wir können uns zwar einloggen, aber fliegen bei der Serverauswahl.
Vorher war alles tuti, bis auf das die NPCs und alles nach einem umlaut aufgehört haben zu sprechen, etc. Jetzt haben wir, damit sie normal weiter "sprechen" und das wir unsere Tools benutzen können, arcadia 1.3 repatck drauf getan. Wir können uns zwar einloggen und er erkennt auch jeden Account den wir in der db erstellen, nur fliegen wir, wie schon gesagt, bei der Auswahl des Servers. Alle erforderlichen Ports sind freigegeben.

Danke schon mal für die Hilfe!

Nada92 · 09/04/2013, 01:57

Hello everyone

Here i have an SQL file to Remove (Return, Forced Regen and Forced Mana Scrolls) from drops.

I've queried the attached SQL file into my Database and the arrows were successfully affected But, the drops still exist and dropping.

SQL file is down there you can check it and obviously you can share it also.

Thank you people

ThunderNikk · 09/04/2013, 04:14

Quote:

Originally Posted by Serarisha

Hi Guys,

my old problem is solved. But i got a new one. Used the search function and google. I make my server like the one post here at forums. First was all fine, but some npcs and stuff didnt talk after there was a german letter, like ae, ue or oe (in german its ä,ü,ö), they just stop talking. so the we used the arcadia 1.3 repack for using admintools and stuff but now we have the problem that we all get a disconnect after we log in. its like, we try to choose a server an get the message "you have been disconnected from server!" we, like 4-5 persons, are living on diff places so it cant be a problem with the internet. all ports and stuff are free on the firewall.

thanks for help and sry for my english. didnt use it that much.

The client probably does not match the server files. This is common when the wrong sframe is used with the wrong server files.

@Nada92

There was a syntax error in your script that made any thing after return scroll not able to execute.

I am surprrised you did not notice by counting the number of rows affected.

I have fixed it for you...

Code:

 --------- [GM]Nada92 ---------

/* Return Scroll */
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 603001 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 603001 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 603001 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 603001 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 603001 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 603001 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 603001 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 603001 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 603001 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 603001 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 603001 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 603001 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 603001 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 603001 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 603001 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 603001 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 603001 


/* Forced Regen Scroll */
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 601100207 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_01 = 601100207 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_02 = 601100207 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_03 = 601100207 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_04 = 601100207 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_05 = 601100207 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_06 = 601100207 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_07 = 601100207 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_08 = 601100207 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_09 = 601100207 

/* Forced Mana Scroll */
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 601100208 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_01 = 601100208 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_02 = 601100208 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_03 = 601100208 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_04 = 601100208 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_05 = 601100208 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_06 = 601100208 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_07 = 601100208 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_08 = 601100208 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_09 = 601100208 

/* Forced Recovery Scroll */
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 601100209 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_01 = 601100209 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_02 = 601100209 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_03 = 601100209 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_04 = 601100209 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_05 = 601100209 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_06 = 601100209 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_07 = 601100209 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_08 = 601100209 
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_09 = 601100209

Serarisha · 09/04/2013, 06:06

Quote:

Originally Posted by thndr

The client probably does not match the server files. This is common when the wrong sframe is used with the wrong server files.

So, how we could fix that thing with npc text else? I dont know how or where to find these npc text script.
And its not only the npcs only. When you drop something and there is a ae, oe, or ue in the word, like the german word for cube, the text after this letter is gone. Could you, or someone else help me pls?

Reguards

ninex · 09/04/2013, 08:30

1st.)
Greetings and Salutations ... A big THANK YOU to everyone that has helped me get this far ...

2nd.)I now want to dive into editing my .lua's. I have Luaedit-2010 I can open them up but the "green" writing looks to be encrypted and i cant read it

Spoiler

. I know im missing a step someplace can anyone tell me where?? O and I did look at "Resourcing for Dummies" but it did not give any info on working with the lua files.
3rd.)
The server im running is "[RELEASE] FULL FILE SERVER 8.1 ~" What client and Sframe should i be using? I tried using Official client with SFrame_ep8 but would not load. the only way i can connect and play on my server is if i use "Rappelz Tournament" client and sframe and the looters wont work on that one for me but i can connect .. ...Any help here would be awesome.. thanks guys