Problem with skill workaround.

01/14/2013 23:18 Prideness#1
Hello all of you,

Yesterday I was planning on doing the known skill "work around", and I've used (I believe it was) Bane's edited PS_GameDefs for it, I've edited the Skill.SData file, when it was needed, to fit with the database, except for some, but the small changes I did myself are also edited in the table. (Only two things that I've done was backpack/interpretation upgrade set to max level on level 1 instead of level 1/2/3 on level 13/14/15)

I've saved the Skill.SData and updated my client(I did not run the query I've got after saving from ShStudio, 'cause I've heared that that causes the team buffs to stop working("Wrong Target" message). My updater did took and implement the update, and if I open my data.sah after the update and extract Skill.SData it is exactly as I edited it. But it don't actually show up in-game, neither does the extra statusses take effect, and I'm still getting "Unaivable Skill" after they reached level 3.

Does anyone has/had a familiar thing with it, 'cause I've used search engine but it seems to work for everyone else.

Before you guys say "Download LPHs Skill fix, it's still on E*PvP" I've done and tried that, but the query had alot of errors and after all the fix only made me DC after upgrading a skill, that's why I tried the workaround. (Ain't saying it's a bad release though, 'cause it does obviously work for others.)

Any help or idea's would be highly appreciated :D! Thanks in advance!
01/14/2013 23:32 nubness#2
There's 2 queries in LPH's Ep5 Skill Fix archive. One of them, which is the stored procedure, doesn't run because you need to add
Code:
USE PS_GameDefs;
in the first line.
After that the skill fix works, but you need to remember that you need to inject the memory with the Skill.CEA file after every restart and it has to happen within 1 minute after your game process goes to > .
01/17/2013 10:07 yukolo#3
mysql code I have given you only have to do is strike and the problem will be eliminated Skillid'' places ''SkillID'' would be to change the error, otherwise you're going to get.

Quote:
USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[usp_Save_Char_ApplySkill_Add_E2] Script Date: 12/02/2012 20:17:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO





ALTER Proc [dbo].[usp_Save_Char_ApplySkill_Add_E2]

@CharID int,
@SkillID smallint,
@SkillLevel tinyint,
@LeftResetTime int

AS

SET NOCOUNT ON

INSERT INTO CharApplySkills(CharID,Skillid,SkillLevel,LeftRese tTime) VALUES(@CharID,@Skillid,@SkillLevel,@LeftResetTime )

IF(@@ERROR = 0)
BEGIN
RETURN 1
END
ELSE
BEGIN
RETURN -1
END

SET NOCOUNT OFF