[Tiny Release] NpcSkill.sql

03/28/2013 23:32 nubness#1
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:
Code:
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 !
05/30/2015 10:02 kalib.32#2
good release! thanks lot!
06/01/2018 13:03 balongskie123#3
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
06/03/2018 02:29 momocruz#4
Quote:
Originally Posted by balongskie123 View Post
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