Problem EP5 Skill Level 3+ FIX

[DeviL125]

Originally Posted by TeddyBear94

original

 Spoiler

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

this should have given u an error while executing


fixed one

use PS_GameData
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

Just in case someone is following this for the fix... Teddy used the wrong DB by mistake. Use PS_GameDefs

use PS_GameDefs
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