[Help Thread] Please post your questions here.

[Sandro1029]

Originally Posted by Old Timer

Sorry if this has been asked and answered before, wind pixies, forest pixies and ethereal pixies on my little server are named incorrectly in the field,
Names being Saint Soul, Dim Fantasy and Petit Blue Fairy.
If someone could tell me where I need to go change the names
Thanks

They have name id (code). Search for them in your string table (dbo.StringResource)

[Wan199]

hello
i have set up my server but when i try to log in i get a wrong ID or password message
the password is hashed properly idk what to do

[ThunderNikk]

Well this is what I answered in the other thread you posted in...

Originally Posted by ThunderNikk

Did you md5 hash your password with your md5 key?

so it is keypassword like

If key is 2011 and password is going to be password then you hash

2011password

[ilyaslord36]

i fllow all steps but i have a problem to enter the portal field of hidden dungon open succesfully but cannot enter to the dungon it's
say : This skill cannot be used on this target

[Sandro1029]

Originally Posted by ilyaslord36

i fllow all steps but i have a problem to enter the portal field of hidden dungon open succesfully but cannot enter to the dungon it's
say : This skill cannot be used on this target

Check if this prop existing in your database or resource/newmap folder (map prop file)

And if everything seems ok, check for prop flags

[ilyaslord36]

Originally Posted by Sandro1029

Check if this prop existing in your database or resource/newmap folder (map prop file)

And if everything seems ok, check for prop flags

What is the number Prop flags by default
Is evrytime value : 0 or etch prop with a number of flag his own

[CHlNAMAN]

What is the correct Photoshop DDS plugin profile to save the files? This is my output -

Solved: use BC2 profile, but it's easier just to download Paint.NET

[Sandro1029]

Originally Posted by ilyaslord36

What is the number Prop flags by default
Is evrytime value : 0 or etch prop with a number of flag his own

Quest ID for prop

[ilyaslord36]

I need help to Increase the number of monsters in this function inside monster_respawn.lua
Exemple :
Monster ID = {181001, 181001, 0, 0}
Destiny = { 1.5, 1.5, 1.5, 0.1, 0.1, 1.5 }
Interval = { 3000, 1500, 1500, 3000, 2000, 1000 }

[ThunderNikk]

Density is the number of monsters in the area

[CHlNAMAN]

At this point you should really look into learning lua.

[ilyaslord36]

Plz any one help me

[ilyaslord36]

Plz i need help in mixresource i d'ont know how to create a item combine
When i mix ID 1100111 count : 20 + ID 2014064 count : 1 =
ID 2014053

[Sandro1029]

Originally Posted by ilyaslord36

Plz i need help in mixresource i d'ont know how to create a item combine
When i mix ID 1100111 count : 20 + ID 2014064 count : 1 =
ID 2014053

Bro, I especially made a for that....

 Spoiler

INSERT INTO [dbo].[MixResource]([id], [mix_type], [mix_value_01], [mix_value_02], [mix_value_03], [mix_value_04], [mix_value_05], [mix_value_06], [sub_material_count], [main_type_01], [main_value_01], [main_type_02], [main_value_02], [main_type_03], [main_value_03], [main_type_04], [main_value_04], [main_type_05], [main_value_05], [sub01_type_01], [sub01_value_01], [sub01_type_02], [sub01_value_02], [sub01_type_03], [sub01_value_03], [sub01_type_04], [sub01_value_04], [sub01_type_05], [sub01_value_05], [sub02_type_01], [sub02_value_01], [sub02_type_02], [sub02_value_02], [sub02_type_03], [sub02_value_03], [sub02_type_04], [sub02_value_04], [sub02_type_05], [sub02_value_05], [sub03_type_01], [sub03_value_01], [sub03_type_02], [sub03_value_02], [sub03_type_03], [sub03_value_03], [sub03_type_04], [sub03_value_04], [sub03_type_05], [sub03_value_05], [sub04_type_01], [sub04_value_01], [sub04_type_02], [sub04_value_02], [sub04_type_03], [sub04_value_03], [sub04_type_04], [sub04_value_04], [sub04_type_05], [sub04_value_05], [sub05_type_01], [sub05_value_01], [sub05_type_02], [sub05_value_02], [sub05_type_03], [sub05_value_03], [sub05_type_04], [sub05_value_04], [sub05_type_05], [sub05_value_05], [sub06_type_01], [sub06_value_01], [sub06_type_02], [sub06_value_02], [sub06_type_03], [sub06_value_03], [sub06_type_04], [sub06_value_04], [sub06_type_05], [sub06_value_05], [sub07_type_01], [sub07_value_01], [sub07_type_02], [sub07_value_02], [sub07_type_03], [sub07_value_03], [sub07_type_04], [sub07_value_04], [sub07_type_05], [sub07_value_05], [sub08_type_01], [sub08_value_01], [sub08_type_02], [sub08_value_02], [sub08_type_03], [sub08_value_03], [sub08_type_04], [sub08_value_04], [sub08_type_05], [sub08_value_05], [sub09_type_01], [sub09_value_01], [sub09_type_02], [sub09_value_02], [sub09_type_03], [sub09_value_03], [sub09_type_04], [sub09_value_04], [sub09_type_05], [sub09_value_05]) VALUES (1234567890, 601, 2014053, 1, 100, 1, 1, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, 2014064, 10, 1, 0, 0, 0, 0, 0, 0, 3, 1100111, 10, 20, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

1234567890 - ID
601 - MIX CREATE ITEM
2014053 - Result item ID
100 - % of success
1 - Count min / Count max
2 - Count of materials needed

3 - Check for ID
2014064 - ID
10 - Check for count
1 - Count

3 - Check for ID
1100111 - ID
10 - Check for count
20 - Count

[Marschall83]

Regarding with questions to fix my 6.2 server I have some following questions.

I fixed two things

• mixed Beltskills: by loading the db_skill(ascii).rdb from the client into the database (now an angel/wd gives vit/int when equipped in belt etc.)
• No skill cooldown: this was just an entry in the GameServer.opt (T game.no_skill_cooltime:1)

At the moment there are just two things I have to fix for my 6.2 server happiness .

• swap unicorns and nightmares for the old mobs, because my client can`t display them (and I think they don`t fit into rappelz ). exter16 suggested in "lua search for monster ids and replace to switch them to pixies". How can I do a lua search and where I have to replace the monster ids (in database and/or in rdb file for client)?
• Changing the drops: re-add scrolls/potions (I don`t know why they don`t drop) and remove the new soulstones (+crit. power, move speed etc.).

In order to solve this points I would try to load the db_monster(ascii).rdb and db_dropgroup.rdb into the database.
There is just a little problem: I don`t have the 6.2 structure-lua-files for this tables. Is there an easy way to get/create a structure.lua from the rdb-file or maybe from the database?

To load the db_skill(ascii).rdb into the database (as I mentioned above) and get the structure.lua I had to debug the import process in Grimoire_v4614 (thanks iSmokeDrow, Glandu2, xXExiledXx and all involved) and watch where it crashes (and write column after column in an own structure.lua). It worked but it felt wrong .

EDIT:
I think changing the drops (removing newer soulstones and re-add the scrolls/potions) would be easier when I just replace the IDs from the newer soulstones with the IDs from the scrolls (return, res) and potions (blue/red, quick/wind). Is this a possible way?

General question:
For my understanding of the interaction of the client and the database I have a basic (but maybe no easy) question.
Why has the client a packed rdb file for some corresponding tables in the database (e.g. db_monster(ascii) --> dbo.MonsterResource)?
Ok, I understand why the client has to know the scheme/columns of the table. But why needs the client the rows/data also?

Any help, hints and suggestions are welcome.
Thanks in advance.