ImportShopSkills <- act7

[PhysicMind]

Why does it give an error? Which packets are at fault? Even when i looked into the problem nothing works.

[IceTrailer]

Please mind sharing your error message.
We can't help fix an error you don't describe.

[DasBalken]

Some new packets from A7 have | in their strings.
obivously converting that to short doesn't work.
that alone isnt enough tho to fix the complete parse for it as the value itself isn't used in the database which leads to a FOREIGN KEY ERROR when inserting.

Had the same issue and that's all I was able to gather with my limited knowledge

Edit: More like have - Ignoring these cases was the only fix I found so far but that doesn't include shopskills for a7 (Which I think includes the tattoos, so that might be relevant)
-> interested in a fix

[fantasy942]

Well, if u know wich packet on the import have the "|" the solution is pretty much easy...

Add a simple packet.Replace("|", " ").ToIn~~~

[DasBalken]

No thats not all, as I already mentioned.
First of all, the new value is too big for a Int16, so casting from short zu long would be fine for that part. But as I said, the database doesn't know such a high value because there is no Skill with the SkillVNum 986011
So as the ShopSkillId in the ShopSkill Table is connected to the Primary Key of the Skill Table, adding a value that doesn't exist in the Skill Table wont work.
Best bet would be to actually find out what that value stands for and where to add.
(The string the parser doesn't like is as follows: "9860|1|1" )