[HELP]dbo.Skills

[balongskie123]

i have a problem with dbo.skills Some mobs are not attacking me and i see its because i dont have level 100 skill in my dbo.skills. stinka database has dbo.skills. But how could i get it and move it to my database. can someone please help me

im using 2012 sql server

[arjulie]

Insert a NPCSKILLS.SQL to your database this will be fix

[balongskie123]

Originally Posted by arjulie

Insert a NPCSKILLS.SQL to your database this will be fix

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



dbo.Skills design

 Spoiler

USE [PS_GameDefs]
GO

/****** Object: Table [dbo].[Skills] Script Date: 6/1/2018 12:45:22 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Skills](
[RowID] [int] IDENTITY(1,1) NOT NULL,
[SkillID] [int] NOT NULL,
[SkillLevel] [tinyint] NOT NULL,
[SkillName] [varchar](300) NOT NULL,
[Country] [tinyint] NOT NULL,
[Attackfighter] [tinyint] NOT NULL,
[Defensefighter] [tinyint] NOT NULL,
[Patrolrogue] [tinyint] NOT NULL,
[Shootrogue] [tinyint] NOT NULL,
[Attackmage] [tinyint] NOT NULL,
[Defensemage] [tinyint] NOT NULL,
[PrevSkillID] [smallint] NOT NULL,
[ReqLevel] [smallint] NOT NULL,
[Grow] [tinyint] NOT NULL,
[SkillPoint] [tinyint] NOT NULL,
[TypeShow] [tinyint] NOT NULL,
[TypeAttack] [tinyint] NOT NULL,
[TypeEffect] [tinyint] NOT NULL,
[TypeDetail] [smallint] NOT NULL,
[NeedWeapon1] [tinyint] NOT NULL,
[NeedWeapon2] [tinyint] NOT NULL,
[NeedWeapon3] [tinyint] NOT NULL,
[NeedWeapon4] [tinyint] NOT NULL,
[NeedWeapon5] [tinyint] NOT NULL,
[NeedWeapon6] [tinyint] NOT NULL,
[NeedWeapon7] [tinyint] NOT NULL,
[NeedWeapon8] [tinyint] NOT NULL,
[NeedWeapon9] [tinyint] NOT NULL,
[NeedWeapon10] [tinyint] NOT NULL,
[NeedWeapon11] [tinyint] NOT NULL,
[NeedWeapon12] [tinyint] NOT NULL,
[NeedWeapon13] [tinyint] NOT NULL,
[NeedWeapon14] [tinyint] NOT NULL,
[NeedWeapon15] [tinyint] NOT NULL,
[Shield] [tinyint] NOT NULL,
[SP] [smallint] NOT NULL,
[MP] [smallint] NOT NULL,
[ReadyTime] [tinyint] NOT NULL,
[ResetTime] [smallint] NOT NULL,
[AttackRange] [tinyint] NOT NULL,
[StateType] [tinyint] NOT NULL,
[AttrType] [tinyint] NOT NULL,
[Disable] [smallint] NOT NULL,
[SuccessType] [tinyint] NOT NULL,
[SuccessValue] [tinyint] NOT NULL,
[TargetType] [tinyint] NOT NULL,
[ApplyRange] [tinyint] NOT NULL,
[MultiAttack] [tinyint] NOT NULL,
[KeepTime] [smallint] NOT NULL,
[Weapon1] [tinyint] NOT NULL,
[Weapon2] [tinyint] NOT NULL,
[Weaponvalue] [tinyint] NOT NULL,
[Bag] [tinyint] NOT NULL,
[Arrow] [smallint] NOT NULL,
[DamageType] [tinyint] NOT NULL,
[DamageHP] [smallint] NOT NULL,
[DamageSP] [smallint] NOT NULL,
[DamageMP] [smallint] NOT NULL,
[TimeDamageType] [tinyint] NOT NULL,
[TimeDamageHP] [smallint] NOT NULL,
[TimeDamageSP] [smallint] NOT NULL,
[TimeDamageMP] [smallint] NOT NULL,
[AddDamageHP] [smallint] NOT NULL,
[AddDamageSP] [smallint] NOT NULL,
[AddDamageMP] [smallint] NOT NULL,
[AbilityType1] [tinyint] NULL,
[AbilityValue1] [smallint] NULL,
[AbilityType2] [tinyint] NULL,
[AbilityValue2] [smallint] NULL,
[AbilityType3] [tinyint] NULL,
[AbilityValue3] [smallint] NULL,
[AbilityType4] [tinyint] NULL,
[AbilityValue5] [smallint] NULL,
[AbilityType6] [tinyint] NULL,
[AbilityValue6] [smallint] NULL,
[AbilityType7] [tinyint] NULL,
[AbilityValue7] [smallint] NULL,
[AbilityType8] [tinyint] NULL,
[AbilityValue8] [smallint] NULL,
[AbilityType9] [tinyint] NULL,
[AbilityValue9] [smallint] NULL,
[AbilityType10] [tinyint] NULL,
[AbilityValue10] [smallint] NULL,
[HealHP] [smallint] NOT NULL,
[HealSP] [smallint] NOT NULL,
[HealMP] [smallint] NOT NULL,
[TimeHealHP] [smallint] NOT NULL,
[TimeHealSP] [smallint] NOT NULL,
[TimeHealMP] [smallint] NOT NULL,
[DefenceType] [tinyint] NOT NULL,
[DefenceValue] [tinyint] NOT NULL,
[LimitHP] [tinyint] NOT NULL,
[FixRange] [tinyint] NOT NULL,
[ChangeType] [smallint] NOT NULL,
[ChangeLevel] [smallint] NOT NULL,
[UpdateDate] [datetime] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

[momocruz]

Extract your client and create NPCskill.SQL

[balongskie123]

Originally Posted by momocruz

Extract your client and create NPCskill.SQL

I change the format from ep5 to ep 6 and it works. thanks