Problem EP5 Skill Level 3+ FIX

Quote:

Originally Posted by TeddyBear94

original

this should have given u an error while executing

fixed one

Code:

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

Code:

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