LPH Skill Fix (Error)

[Dotzie]

Hello guys, I hade some problems with the skills on my server so i decided to try to use a Skill Fix.

The problem i have is some skills cant be upgraded to lv1.... Says (level isent high enought)

Im running EP5 DB, with EP 5 OS CLient (Edited with EP6) Items.

Current error with LPH's Skill fix ->

Skill.SQL works without problem. I started with that one then moved on to Skill Update.SQL and got following Error:

Msg 208, Level 16, State 6, Procedure usp_Read_SkillMaxID_R, Line 2
Invalid object name 'dbo.usp_Read_SkillMaxID_R'.

I made sure Server was running (Without commands Wroten).

This is how the Update Fix looks like:

PHP Code:

set ANSI_NULLS ON
set QUOTED_IDENTIFIER OFF
GO

ALTER Proc [dbo].[usp_Read_SkillMaxID_R]
AS

WAITFOR DELAY '00:01';

SELECT MAX(SkillID)
FROM Skills
WHERE SkillLevel < 100 


Problem with LPH Query was following:

PHP Code:

Use PS_GameDefs <------- Forgot to add the Path to where it exist
set ANSI_NULLS ON
set QUOTED_IDENTIFIER OFF
GO

ALTER Proc [dbo].[usp_Read_SkillMaxID_R]
AS

WAITFOR DELAY '00:01';

SELECT MAX(SkillID)
FROM Skills
WHERE SkillLevel < 100 


However this Fix didnt help me with the problem. I can still not upgrade some skills at all.

[RaamKiller]

Heya Dotzie,

Did you still have this issue ?

If yes, just open (click modify): PS_GameDefs => Programmability => Stored Procedures => dbo.usp_Read_SkillMaxID_R.

You will see this :

 Spoiler

PHP Code:

set ANSI_NULLS ON
set QUOTED_IDENTIFIER OFF
GO

ALTER Proc [dbo].[usp_Read_SkillMaxID_R]
AS

SELECT MAX(SkillID)
FROM Skills
WHERE SkillLevel < 100 


Just add : WAITFOR DELAY '00:001'; between "AS" and "SELECT MAX(SkillID) like this :

 Spoiler

PHP Code:

set ANSI_NULLS ON
set QUOTED_IDENTIFIER OFF
GO

ALTER Proc [dbo].[usp_Read_SkillMaxID_R]
AS

WAITFOR DELAY '00:01';

SELECT MAX(SkillID)
FROM Skills
WHERE SkillLevel < 100 


Click Execute, and your done !

Hope this will help.