question about the skill effect? need help, tks.

04/09/2022 16:32 ouboman#1
Dear ,

I have already searched the whole forum, but have not found any info about it.

My question is few of my skills are bugged such as the Berserker's Rage , it does not have the effect as -%hp per 3 secounds, same with other jobs too, I've checked the database as below , see attachment,

the abttype is 70 abtvalue 10 are correct as they are gathered,converted from os skill.sdata from shstudio 0803 version, so it is clean and has not modified , I figured out that the 70 vaule controls the -%hp thing, 16 controls the attack speed, 4 controls the str as well, the 16 and 4 are working nice, but the problem is the 70 does not working, so I dont know where is the causing, I have been thinking that it is the problem in Ps_gane or database procedure stuffs, but I dont have a way to fix it, can please anyone help me to overcome it ? Any help would be highly apprecited. :):):confused::confused::confused:


PS: I am using EP6-6.4 files.
04/11/2022 13:17 Elemental Shock#2
Most of EP6 new skill effects, such as Arcane Protector, Rage skills , etc.. have never worked with the EP6 files.
Almost no server have managed to fix those skills, so don't worry about that and just disable them.
Anyway, there is not a lot of reasons to use them...

The only 'EP6' skills that works, are those with classic skills effects (Such as 'Vital' skills, any skill type up to 5.4).
04/12/2022 20:14 ouboman#3
Quote:
Originally Posted by Elemental Shock View Post
Most of EP6 new skill effects, such as Arcane Protector, Rage skills , etc.. have never worked with the EP6 files.
Almost no server have managed to fix those skills, so don't worry about that and just disable them.
Anyway, there is not a lot of reasons to use them...

The only 'EP6' skills that works, are those with classic skills effects (Such as 'Vital' skills, any skill type up to 5.4).
Thanks so mcuh for your reply, yeah I was trying to manage to fix them as same as the OS one but failed, maybe I just use other classic-old abilitytype like lower the whole hp range of a player instead of the -%hp type 70, also keeps the attack speed and STR.


BTW Bro, I got another issue that those abilitytype and abilityvalue have not effect after abilitytype 3,abilityvaule 3 in skill table, EP6 gets like 10 abilities yeah ? I tried to put stander vaule in abilitytype4 and abilityvaule4 ,
but they do not have any effect, I dont really understand what is going on,
maybe it is the problem in PS_game again ? I have checked the procedure in GameDefs such as usp_Read_Skills_R,
Quote:
ALTER Proc [dbo].[usp_Read_Skills_R]
/* Created by [Only registered and activated users can see links. Click Here To Register...], 2004-08-11
스킬 테이블 읽어오기 */
AS
SELECT SkillID, SkillLevel, SkillName, Country, Attackfighter, Defensefighter, Patrolrogue, Shootrogue, Attackmage, Defensemage,
PrevSkillID, ReqLevel, Grow, SkillPoint, TypeShow, TypeAttack, TypeEffect, TypeDetail,
NeedWeapon1, NeedWeapon2, NeedWeapon3, NeedWeapon4, NeedWeapon5, NeedWeapon6, NeedWeapon7, NeedWeapon8,
NeedWeapon9, NeedWeapon10, NeedWeapon11, NeedWeapon12, NeedWeapon13, NeedWeapon14, NeedWeapon15,
Shield, SP, MP, ReadyTime, ResetTime, AttackRange, StateType, AttrType, Disable,
SuccessType, SuccessValue, TargetType, ApplyRange, MultiAttack, KeepTime,
Weapon1, Weapon2, Weaponvalue, Bag, Arrow,
DamageType, DamageHP, DamageSP, DamageMP, TimeDamageType, TimeDamageHP, TimeDamageSP, TimeDamageMP,
AddDamageHP, AddDamageSP, AddDamageMP, AbilityType1, AbilityValue1, AbilityType2, AbilityValue2, AbilityType3, AbilityValue3, HealHP, HealSP, HealMP, TimeHealHP, TimeHealSP, TimeHealMP,
DefenceType, DefenceValue, LimitHP, FixRange, ChangeType, ChangeLevel
FROM Skills
WHERE SkillLevel < 100
ORDER BY SkillID ASC, SkillLevel ASC

it does not have those 4-10 ability stuffs here, I also have compared this place with other server databases, the result are kinda same, they dont have 4-10 also,

this is my skills table structure
Quote:
CREATE TABLE [dbo].[Skills] (
[RowID] int NOT NULL IDENTITY(1,1) ,
[SkillID] int NOT NULL ,
[SkillLevel] tinyint NOT NULL ,
[SkillName] varchar(300) COLLATE Chinese_PRC_CI_AS 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 ,
[AbilityValue4] smallint NULL ,
[AbilityType5] 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

DBCC CHECKIDENT(N'[dbo].[Skills]', RESEED, 9517)
GO

CREATE INDEX [_WA_Sys_SkillLevel_15DA3E5D] ON [dbo].[Skills]
([SkillLevel] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_SkillID_48CFD27E] ON [dbo].[Skills]
([SkillID] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_RowID_48CFD27E] ON [dbo].[Skills]
([RowID] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_SkillName_48CFD27E] ON [dbo].[Skills]
([SkillName] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_Country_48CFD27E] ON [dbo].[Skills]
([Country] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_Attackfighter_48CFD27E] ON [dbo].[Skills]
([Attackfighter] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_Defensefighter_48CFD27E] ON [dbo].[Skills]
([Defensefighter] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_Patrolrogue_48CFD27E] ON [dbo].[Skills]
([Patrolrogue] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_Shootrogue_48CFD27E] ON [dbo].[Skills]
([Shootrogue] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_Attackmage_48CFD27E] ON [dbo].[Skills]
([Attackmage] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_Defensemage_48CFD27E] ON [dbo].[Skills]
([Defensemage] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_PrevSkillID_48CFD27E] ON [dbo].[Skills]
([PrevSkillID] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_ReqLevel_48CFD27E] ON [dbo].[Skills]
([ReqLevel] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_Grow_48CFD27E] ON [dbo].[Skills]
([Grow] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_SkillPoint_48CFD27E] ON [dbo].[Skills]
([SkillPoint] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_TypeShow_48CFD27E] ON [dbo].[Skills]
([TypeShow] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_TypeAttack_48CFD27E] ON [dbo].[Skills]
([TypeAttack] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_TypeEffect_48CFD27E] ON [dbo].[Skills]
([TypeEffect] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_TypeDetail_48CFD27E] ON [dbo].[Skills]
([TypeDetail] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_NeedWeapon1_48CFD27E] ON [dbo].[Skills]
([NeedWeapon1] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_NeedWeapon2_48CFD27E] ON [dbo].[Skills]
([NeedWeapon2] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_NeedWeapon3_48CFD27E] ON [dbo].[Skills]
([NeedWeapon3] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_NeedWeapon4_48CFD27E] ON [dbo].[Skills]
([NeedWeapon4] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_NeedWeapon5_48CFD27E] ON [dbo].[Skills]
([NeedWeapon5] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_NeedWeapon6_48CFD27E] ON [dbo].[Skills]
([NeedWeapon6] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_NeedWeapon7_48CFD27E] ON [dbo].[Skills]
([NeedWeapon7] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_NeedWeapon8_48CFD27E] ON [dbo].[Skills]
([NeedWeapon8] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_NeedWeapon9_48CFD27E] ON [dbo].[Skills]
([NeedWeapon9] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_NeedWeapon10_48CFD27E] ON [dbo].[Skills]
([NeedWeapon10] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_NeedWeapon11_48CFD27E] ON [dbo].[Skills]
([NeedWeapon11] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_NeedWeapon12_48CFD27E] ON [dbo].[Skills]
([NeedWeapon12] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_NeedWeapon13_48CFD27E] ON [dbo].[Skills]
([NeedWeapon13] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_NeedWeapon14_48CFD27E] ON [dbo].[Skills]
([NeedWeapon14] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_NeedWeapon15_48CFD27E] ON [dbo].[Skills]
([NeedWeapon15] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_Shield_48CFD27E] ON [dbo].[Skills]
([Shield] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_SP_48CFD27E] ON [dbo].[Skills]
([SP] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_MP_48CFD27E] ON [dbo].[Skills]
([MP] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_ReadyTime_48CFD27E] ON [dbo].[Skills]
([ReadyTime] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_ResetTime_48CFD27E] ON [dbo].[Skills]
([ResetTime] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_AttackRange_48CFD27E] ON [dbo].[Skills]
([AttackRange] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_StateType_48CFD27E] ON [dbo].[Skills]
([StateType] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_AttrType_48CFD27E] ON [dbo].[Skills]
([AttrType] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_Disable_48CFD27E] ON [dbo].[Skills]
([Disable] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_SuccessType_48CFD27E] ON [dbo].[Skills]
([SuccessType] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_SuccessValue_48CFD27E] ON [dbo].[Skills]
([SuccessValue] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_TargetType_48CFD27E] ON [dbo].[Skills]
([TargetType] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_ApplyRange_48CFD27E] ON [dbo].[Skills]
([ApplyRange] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_MultiAttack_48CFD27E] ON [dbo].[Skills]
([MultiAttack] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_KeepTime_48CFD27E] ON [dbo].[Skills]
([KeepTime] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_Weapon1_48CFD27E] ON [dbo].[Skills]
([Weapon1] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_Weapon2_48CFD27E] ON [dbo].[Skills]
([Weapon2] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_Weaponvalue_48CFD27E] ON [dbo].[Skills]
([Weaponvalue] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_Bag_48CFD27E] ON [dbo].[Skills]
([Bag] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_Arrow_48CFD27E] ON [dbo].[Skills]
([Arrow] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_DamageType_48CFD27E] ON [dbo].[Skills]
([DamageType] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_DamageHP_48CFD27E] ON [dbo].[Skills]
([DamageHP] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_DamageSP_48CFD27E] ON [dbo].[Skills]
([DamageSP] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_DamageMP_48CFD27E] ON [dbo].[Skills]
([DamageMP] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_TimeDamageType_48CFD27E] ON [dbo].[Skills]
([TimeDamageType] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_TimeDamageHP_48CFD27E] ON [dbo].[Skills]
([TimeDamageHP] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_TimeDamageSP_48CFD27E] ON [dbo].[Skills]
([TimeDamageSP] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_TimeDamageMP_48CFD27E] ON [dbo].[Skills]
([TimeDamageMP] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_AddDamageHP_48CFD27E] ON [dbo].[Skills]
([AddDamageHP] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_AddDamageSP_48CFD27E] ON [dbo].[Skills]
([AddDamageSP] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_AddDamageMP_48CFD27E] ON [dbo].[Skills]
([AddDamageMP] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_AbilityType1_48CFD27E] ON [dbo].[Skills]
([AbilityType1] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_AbilityValue1_48CFD27E] ON [dbo].[Skills]
([AbilityValue1] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_AbilityType2_48CFD27E] ON [dbo].[Skills]
([AbilityType2] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_AbilityValue2_48CFD27E] ON [dbo].[Skills]
([AbilityValue2] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_AbilityType3_48CFD27E] ON [dbo].[Skills]
([AbilityType3] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_AbilityValue3_48CFD27E] ON [dbo].[Skills]
([AbilityValue3] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_AbilityType4_48CFD27E] ON [dbo].[Skills]
([AbilityType4] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_AbilityValue5_48CFD27E] ON [dbo].[Skills]
([AbilityValue5] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_AbilityType6_48CFD27E] ON [dbo].[Skills]
([AbilityType6] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_AbilityValue6_48CFD27E] ON [dbo].[Skills]
([AbilityValue6] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_AbilityType7_48CFD27E] ON [dbo].[Skills]
([AbilityType7] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_AbilityValue7_48CFD27E] ON [dbo].[Skills]
([AbilityValue7] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_AbilityType8_48CFD27E] ON [dbo].[Skills]
([AbilityType8] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_AbilityValue8_48CFD27E] ON [dbo].[Skills]
([AbilityValue8] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_AbilityType9_48CFD27E] ON [dbo].[Skills]
([AbilityType9] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_AbilityValue9_48CFD27E] ON [dbo].[Skills]
([AbilityValue9] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_AbilityType10_48CFD27E] ON [dbo].[Skills]
([AbilityType10] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_AbilityValue10_48CFD27E] ON [dbo].[Skills]
([AbilityValue10] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_HealHP_48CFD27E] ON [dbo].[Skills]
([HealHP] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_HealSP_48CFD27E] ON [dbo].[Skills]
([HealSP] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_HealMP_48CFD27E] ON [dbo].[Skills]
([HealMP] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_TimeHealHP_48CFD27E] ON [dbo].[Skills]
([TimeHealHP] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_TimeHealSP_48CFD27E] ON [dbo].[Skills]
([TimeHealSP] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_TimeHealMP_48CFD27E] ON [dbo].[Skills]
([TimeHealMP] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_DefenceType_48CFD27E] ON [dbo].[Skills]
([DefenceType] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_DefenceValue_48CFD27E] ON [dbo].[Skills]
([DefenceValue] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_LimitHP_48CFD27E] ON [dbo].[Skills]
([LimitHP] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_FixRange_48CFD27E] ON [dbo].[Skills]
([FixRange] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_ChangeType_48CFD27E] ON [dbo].[Skills]
([ChangeType] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_ChangeLevel_48CFD27E] ON [dbo].[Skills]
([ChangeLevel] ASC)
ON [PRIMARY]
GO

CREATE INDEX [_WA_Sys_UpdateDate_48CFD27E] ON [dbo].[Skills]
([UpdateDate] ASC)
ON [PRIMARY]
GO
maybe it is not because it is the problem here ? I also tried to add abt4 and abtvaule4 after 3 in procedure carefully here , but the ps_game could not start , I have also tired to look for other procedures in database, but kinda none of them is relate to abilitytype, hmm, so I am stuck for this issue here, 1-3 types are ok but more types can be done with more adjustment though.

Any comment would be highly appreciated, Thanks.