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:
Problem with LPH Query was following:
However this Fix didnt help me with the problem. I can still not upgrade some skills at all.
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
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