Skill and Item issues EP5

Ever since I have started using and EP5 server, I have had one issue that remained constant.

Certain skills such as, Absoption Aura, fail to work.
Exp Removal Pills, Prevent of Item Drop, and a few others also fail to work.

As far as the skills are concerned, you can obtain them. You can use them. But the effect does not show. Furthermore, some levels of skill can not be used at the stated level requirement, but rather at a later level. Even when the req level in both the database and the .sdata match.

As per the items, these items end up giving the message of 'Cannot Use Due to Item Limitation'.

So far, I have compared my server files to that of OS to try and match data incase there was a flaw. I've tried reverting data back to match that of EP4 in case it was still trying to read it as such. I've changed the database. I've changed ithe .sdata, and I've tried with changing both.

No matter what setup or configuration I attempt, it ends in the same error.

Now I have run out of idea and data to manipulate to try and get these things working. Does anyone have any straight forward information on:

A) Have we gotten these things to work at all, or am I wasting my time comparing data?

B) How have you managed to resolve these issues?

Thank you in advance for anyone offering any helpful information.

I'm not sure about those skills... I've had to use my own workaround to "fix" them. Like Absorption Aura gives defense/resist equal to the amount of absorp it'd give. Not much, but something for now.


As for the items, that's in PS_GameDefs.dbo.Items under the AttackTime,Range,Special fields.. I think.

When I first started dev'ing for our server, EXP Removal Pills didn't work. I fixed them by changing Range to 273, AttackTime to 1 (2 for the large one), and Special to 50.

From what I could tell... Range = SkillID, AttackTime = SkillLevel

Be sure to note down what they are currently... just in case.

eh, its more the same that I've already tried. But in the mean time, I've give it another look over. this is driving me mad. easy fixes. yet they seem determined to piss me off lol

I got the exp removal pill to work, all I had to do was match item.SData and DB. I am pretty sure the same applies to the other items.I'll try to get the config I used for it.

I had some similar problems.
When trying to buy from item mall, I just got "No item located at that spot". The simple fix was to decrypt item.sdata and import it to the db. Now I have the same problem as you with the skill. The required level does not match the level the skill really require. The recharge time is also going to fast. I was thinking about doing the same for the skill. Import skill.sdata to the db - but I cant find a way to decrypt it. I use "Shaiya data edit 01c", but it requires a decrypted skill.sdata. I have tried decrypting it with the "Shaiya Data File Tool v105", but without luck. Any suggestions?

In LPH's "Shaiya Data File Tool v105", under file menu there is an option for decrypt/encrypt

Wow! I did that like 5 times yesterday, but when I did it now, it worked! Thanks I guess:P

I did take our server down for maint while trying to import the csv file, using alot of different csv to sql apps and webpages. Everyone just gave me some errors. I remember when importing the cash.sdata csv, the "shCashShop" gave me a sql query too. Do someone have a app that turns _Skill.SData_ into a csv?
Thanks in advance!

Use ZeroSignal's tool, play around with it cause it has everything u need.

I haven't played around with it much, but I figured asking might save me some time...

How would you go about removing the restriction on the exp removal pill so that you could use it outside of the borderlands?

OR

How would you go about making a totally brand new item that removes a player's exp?

Any ideas? I'm going to look into it more, but maybe someone else could lead me in the right direction.