[Tiny Release] NpcSkill.sql

[nubness]

Hello everyone,
Sometimes it just so happens that the dbo.Skills table gets messed up, and we can even lose skills. The good part about most skills is that you can easily get a query from the Skill.SData created by Shaiya Studio.
In the beginning of the Skill.sql generated by Shaiya Studio you can see:

DELETE FROM [PS_GameDefs].[dbo].[Skills] WHERE SkillLevel<100;

Some of you may not understand why the query would remove any skill with a level lower than 100, and some of you may also not know what the skills with SkillLevel = 100 stand for.
The dbo.Skills contains information about skills not only from Skill.SData, but also from NpcSkill.SData. Exactly, the skills with SkillLevel = 100 are the ones from the NpcSkill.SData, which are the skills used by monsters.

If you've read carefully the explanation above, you surely understood everything I wanted you to understand.

Why I explained this ? There surely are people who knew these stuff, but those who didn't, they would have probably added a reply asking me why I made such a useless release.

Enjoy !

[kalib.32]

good release! thanks lot!

[balongskie123]

Msg 213, Level 16, State 1, Line 1
Column name or number of supplied values does not match table definition

sorry for bumping old threads

[momocruz]

Originally Posted by balongskie123

Msg 213, Level 16, State 1, Line 1
Column name or number of supplied values does not match table definition

sorry for bumping old threads

you have answer on your question lol