[Help]Skills

Hey guys

I have a little problem with Skills. When i try to use them they aren't working...funny thing is just before i restarted the server they were working and all I did was change a couple of things in the Mobs.SData...any reason why this would happen and is there a fix?

EDIT: Nvm they just started working again...not sure what the problem was though :o

EDIT EDIT: Ok seems that spawning Kargos messes up my skills o.o...they were working I spawned Kargos (i edited him in monster.sdata) and then skills stopped working

thats a odd error.

Quote:

Originally Posted by adamkoolkid23 EDIT EDIT: Ok seems that spawning Kargos messes up my skills o.o...they were working I spawned Kargos (i edited him in monster.sdata) and then skills stopped working

It is probably due to a ' in the mobs name, or one of the skills messing up the order in database.

Kargos is probably using a skill with an ' in it and this messes up your skills, characters and mobs use the same skill data.

Its strange...i made a new patch of Skills.SData coz i added a skill in and after i patched it and logged in i spawned Kargos and everything was working ;o yet I didn't change any skills at all aha...very weird

hallo. kan mir wer sagen wie ich die ep 6.3 skills bearbeiten kan und sql script in db laufen kan. ich bekomme den sql script aber wen ich im db laufe bekomme ne menge errors brauche echt dringend hilfe danke. Bekomme dise meldung wen ich Execute mache skill sql Msg 8101, Level 16, State 1, Line 1
An explicit value for the identity column in table 'PS_GameDefs.dbo.Skills' can only be specified when a column list is used and IDENTITY_INSERT is ON.

Probier dies sollte helfen mfg

USE [PS_GameDefs]
GO

/****** Object: Table [dbo].[Skills] Script Date: 12/13/2015 12:46:51 ******/
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] [smallint] NOT NULL,
[SkillLevel] [tinyint] NOT NULL,
[SkillName] [varchar](30) 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,
[HealHP1] [smallint] NOT NULL,
[HealSP1] [smallint] NOT NULL,
[HealMP1] [smallint] NOT NULL,
[TimeHealHP2] [smallint] NOT NULL,
[TimeHealSP2] [smallint] NOT NULL,
[TimeHealMP2] [smallint] NOT NULL,
[DefenceType] [tinyint] NOT NULL,
[DefenceValue] [tinyint] NOT NULL,
[LimitHP] [tinyint] NOT NULL,
[FixRange1] [tinyint] NOT NULL,
[ChangeType] [smallint] NOT NULL,
[ChangeLevel] [smallint] NOT 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,
[test7] [smallint] NOT NULL,
[test8] [smallint] NOT NULL,
[test9] [smallint] NOT NULL,
[FixRange] [tinyint] NOT NULL,
[test11] [smallint] NOT NULL,
[test12] [smallint] NOT NULL,
[UpdateDate] [datetime] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[Skills] ADD CONSTRAINT [DF_Skills_UpdateDate] DEFAULT (getdate()) FOR [UpdateDate]
GO

danke hat sehr geholfen :)