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.
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.
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
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 **** 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.
[Help] Error inserting data into skills table (shstudio 7.5.5) 09/13/2019 - Shaiya Private Server - 3 Replies Hello all, I have been away from this for some time now and am CERTAINLY rusty.. however I haven't had this particular error before. This is really more of an SQL error than a shaiya problem but this being a typical scenario for many of you I thought I'd ask here. In MSSQL Server 2012 I was syncing up my database to my client files, generating the .sql files from Castor's new version of shStudio (v7.5.5) most went fine... as normal.. but running the query for PS_GameDefs.dbo.Skills and it is...
Episode One - Game Server.exe Error 01/23/2015 - Last Chaos Private Server - 18 Replies Hello All,
I've recently tried getting Episode one back up to its original glory - I know a lot of people don't like it.
I have sourced some episode one files, But i seem to be getting an error out of the gameserver.exe (See picture attached)
If anyone has any gameserver.exe for episode one that works i would be very great full and once its all together i will re-distribute...
I am looking to put WASD in to episode one, And also have a few new animations in there. Big project ideas...
Inserting 06/17/2011 - Rappelz - 4 Replies Hey,
I'm abit stuck with inserting items, i tried adding items, but the Server command guide doesn't help me too much, because i dont know how to set it out properly.
For example, The field saying FLAG "#insert_item(ID, VALUE, ENCHANT, LVL, FLAG, "char_name")" could someone write it out for me please? Any help would be appriciated.
Regards Aaron
EPISODE III NEW SKILLS ALL CLASSES 05/15/2008 - Archlord - 30 Replies EP3 NEW SKILLS
Archlord Database
thats it, not by me, credits go to Schimitar.
Episode 5 Swashbuckler Armor/Weapon ~ Sets & Vidz of All skills/buffs 12/19/2007 - Archlord - 0 Replies Some day the elf will come be on the english version ^^ till then.. a little birdy said NHN didn't have all their directories secure :P
30'ish short Avi Vidz of all skills and buffs & screenshotted/clipped images of some of the unique sets (Ones I liked :P), and a couple others. I got tired of copy-paste-cropping =/
Images here now, upping the vid-clips 4x 9.4 meg 1x 7.5meg (5total files - spanned archive)
& yes I know a lot have been out on Youtube etc... I got these last month, just...
Episode 6.3 Skills Error Inserting DB Sql
