|
You last visited: Today at 02:20
Advertisement
Episode 6.3 Skills Error Inserting DB Sql
Discussion on Episode 6.3 Skills Error Inserting DB Sql within the Shaiya PServer Development forum part of the Shaiya Private Server category.
12/12/2015, 00:12
|
#1
|
elite*gold: 0 
Join Date: May 2013
Posts: 518
Received Thanks: 806
|
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 -
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.
|
|
|
|
12/12/2015, 11:46
|
#2
|
elite*gold: 0
Join Date: Jul 2012
Posts: 38
Received Thanks: 7
|
kkkkkkkkkkkkkkk
kkkkk seriosly?
Open skill.sdata sh Studio 7.5 , click Tool and Episode 5 Format Max Lv 9 Skills <
|
|
|
|
|
12/12/2015, 14:18
|
#3
|
elite*gold: 260
Join Date: Sep 2011
Posts: 487
Received Thanks: 360
|
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
|
|
|
|
|
12/12/2015, 14:43
|
#4
|
elite*gold: 0
Join Date: May 2013
Posts: 518
Received Thanks: 806
|
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.
|
|
|
|
|
12/12/2015, 20:53
|
#5
|
elite*gold: 0
Join Date: Jul 2009
Posts: 380
Received Thanks: 86
|
LOL realy Twilight With your Experties you should of see this in the error log **** you crack me up
|
|
|
|
|
12/13/2015, 11:11
|
#6
|
elite*gold: 0
Join Date: Jul 2011
Posts: 68
Received Thanks: 120
|
|
|
|
|
|
12/13/2015, 21:08
|
#7
|
elite*gold: 0
Join Date: May 2013
Posts: 518
Received Thanks: 806
|
Quote:
Originally Posted by Big_
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.
|
|
|
|
 |
Similar Threads
|
[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...
|
All times are GMT +1. The time now is 02:21.
|
|
