[Help Thread] Please post your questions here.

[shingod]

thank, it works now...

Anyone have telecaster 9.6 or higher?

[mortred_11]

Originally Posted by mortred_11

Hello everyone,

I’m new to this and have a few questions (using 9.5.2) . I apologize if these have already been addressed elsewhere:

1-Is there any documentation available for the SkillResource table?

2-I'm encountering an issue where buffs disappear after logging out and back in. I tried changing the state_time_type (is there a calculator for it ?), and while it worked for characters, it didn’t seem to affect pets.

3-when playing a pet class and logging in your passives are applied to the pet as you log in (which make the pet hp/mp go low) any fix or workaround?

can someone assist with this

[InkDevil]

Originally Posted by mortred_11

can someone assist with this

For your second question I'll copy what I told someone else in another thread:
To "fix" its storing, you need to use

N:game.creature_state:1

in gameserver.opt, and they will be stored/saved again.

This way it also shouldn't re-add buffs from toggles again and again after restarts.

[Bomj009]

db_monster_creature structure search 9.6

[atherounge3]

Hey everyone, it's been a while since I've been here. I can't seem to find the download center. Is it still available? Could someone share the link with me?

[アルカード]

Does anybody have somewhere backed up a 62 early files.They would be named arcadia 1.3 repack or ArcadiaRepack-1.1beta? please let me know


thanks in advance!

[atherounge3]

Originally Posted by アルカード

Does anybody have somewhere backed up a 62 early files.They would be named arcadia 1.3 repack or ArcadiaRepack-1.1beta? please let me know


thanks in advance!

I have Horizon if you need

[khshe]

Originally Posted by アルカード

Does anybody have somewhere backed up a 62 early files.They would be named arcadia 1.3 repack or ArcadiaRepack-1.1beta? please let me know


thanks in advance!

this is the 1.3 repack

[アルカード]

Originally Posted by khshe

this is the 1.3 repack

sorry i am not downloading that,arcadia shouln't be a .exe
@ please if you can remove that link

[khshe]

Originally Posted by アルカード

sorry i am not downloading that,arcadia shouln't be a .exe
@ please if you can remove that link

lol I don't understand why you were so offended by me that you even threw me out of discord, but come on. keep your arcadia 1.3 unpacked.



@ check my link again

[アルカード]

Originally Posted by khshe

lol I don't understand why you were so offended by me that you even threw me out of discord, but come on. keep your arcadia 1.3 unpacked.



@ check my link again

what u expect from me.You post a "Arcadia" that is .exe.

[armoureph830]

Hey guys, I've just created a private server of my own with 9.5.2 files. I have a few questions related to customization of my server. I'd very much like to learn how to do these things. Any pointers would be greatly appreciated.

Firstly I've wondering how I go about making certain changes to skills.
For example,

a) how do I edit the MATK or PATK % of skills?
b) how do I edit the duration of a skill and how often it ticks? (i.e. Rain of the Spirits/Touch of the Goddess)
c) how do I edit the effectiveness of skills vs a single target/multiple enemies?

Secondly, I'd like to know how to edit scripts of already made NPCs.
For Example,

a) I'd like to make changes to the Dungeon Teleporter in Horizon, where would the scripts be located in order to make those changes.

Within the Arcadia dbo.NPCResource I can see the contact script but I'm not sure where to find it.

Lastly, how do I know whether a client needs to be updated vs just making changes via the SQL database. This is something I'm very confused about. If someone could please explain this to me in detail.

[atherounge3]

Originally Posted by armoureph830

a) how do I edit the MATK or PATK % of skills?

dbo.SkillResource var1 - var20

Originally Posted by armoureph830

b) how do I edit the duration of a skill and how often it ticks? (i.e. Rain of the Spirits/Touch of the Goddess)

dbo.StateResource. State id is state_id from dbo.SkillResource (in some cases it's one from vars above

Originally Posted by armoureph830

c) how do I edit the effectiveness of skills vs a single target/multiple enemies?

var1 - var20. Check how other skills works tho

Originally Posted by armoureph830

a) I'd like to make changes to the Dungeon Teleporter in Horizon, where would the scripts be located in order to make those changes.

Within the Arcadia dbo.NPCResource I can see the contact script but I'm not sure where to find it.

GameServer directory -> Resource directory -> scripts
Here would be tons of .lua files. Check TeleportTown or TeleportField. Can't remember, since I rewrote entire warp system by myself in one file.

Originally Posted by armoureph830

Lastly, how do I know whether a client needs to be updated vs just making changes via the SQL database. This is something I'm very confused about. If someone could please explain this to me in detail.

Search for any RDB tool on this forum. It can be source-built, or glandu2's or slent wisdom's. You made a change in database - you open the tool, connect to database, pick structure (if glandu or wisdom tool) and dump the table into .rdb file. Then you put that rdb file in resource directory and run SFrame with /notenc parameter. Or has it to run without notenc (wisdom's tool called grimoire has built in hasher)

[Old Timer]

Could someone help he with this, I am trying to populate my market resource but keep getting errors.

Use Arcadia
INSERT INTO [dbo].[MarketResource]([sort_id], [name], [code], [price_ratio], [huntaholic_ratio], [arena_ratio]) VALUES
(810806,'JTSGearEnhance',1100103,1,0,0);
(810807,'JTSGearEnhance',950004,1,0,0)

I can add the items individually but there must be a way to insert in bulk

[Pesqoo]

Originally Posted by Old Timer

Could someone help he with this, I am trying to populate my market resource but keep getting errors.

Use Arcadia
INSERT INTO [dbo].[MarketResource]([sort_id], [name], [code], [price_ratio], [huntaholic_ratio], [arena_ratio]) VALUES
(810806,'JTSGearEnhance',1100103,1,0,0);
(810807,'JTSGearEnhance',950004,1,0,0)

I can add the items individually but there must be a way to insert in bulk

A simple google search, ChatGPT or even reading the error would have helped you in a few seconds.
Every row needs the full command:


INSERT INTO [dbo].[MarketResource]([sort_id], [name], [code], [price_ratio], [huntaholic_ratio], [arena_ratio]) VALUES
(810806,'JTSGearEnhance',1100103,1,0,0);
INSERT INTO [dbo].[MarketResource]([sort_id], [name], [code], [price_ratio], [huntaholic_ratio], [arena_ratio]) VALUES (810807,'JTSGearEnhance',950004,1,0,0);