Episode 6.3 Skills Error Inserting DB Sql

I used shstudios, tried to save the skill.sdata episode 6.3 data from shaiya phoenix client, there is a few errors when i was trying to insert it to the sql data. I will get the error logs. post it here in a few. since i know there are already servers that are using episode 6.3 skills. would love the help from anyone that knows how to fix it.

Error Listed Below -

kkkkk seriosly?

Open skill.sdata sh Studio 7.5 , click Tool and Episode 5 Format Max Lv 9 Skills <

Problem is because your skills have max [AbilityType3] [AbilityValue3]
But in ep 6 skills is max 10

Quote:

Originally Posted by SnickQ Problem is because your skills have max [AbilityType3] [AbilityValue3] But in ep 6 skills is max 10 Code: USE [PS_GameDefs] GO /****** Object: Table [dbo].[Skills] Script Date: 2015-12-12 14:16:15 ******/ DROP TABLE [dbo].[Skills] GO /****** Object: Table [dbo].[Skills] Script Date: 2015-12-12 14:16:15 ******/ 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

Yeah it is fixed with the option, haven't had time to notice all the different things lately with work and all, so the main reason i was asking for help.

LOL realy Twilight With your Experties you should of see this in the error log fuck you crack me up

try this

Quote:

Originally Posted by Big_ LOL realy Twilight With your Experties you should of see this in the error log fuck you crack me up

Lets see for one i never touch the database, i usually code in c++ for the development i do. Knowing it's been two years getting back into it, since i haven't done shaiya development for so long.