神泣单机教程 - N级以下可获得BUFF状态的语句

下面的状态是 低于10级可以免费获取这些状态，如果是高于10级，则在状态时间到期后 小退不能获取技能
如果你要设定XX级后这个状态不会在获取，那就按下面的方式设定，具体设置如下：
CharID,224,1,604800
角色ID，224是技能ID，1是技能等级，604800是这个BUFF的时间

--上线获得装备耐用锤
IF((SELECT COUNT(*) FROM [CharApplySkills] WHERE [CharID] = @CharID AND [SkillID] = 224 AND [SkillLevel] = 1) = 0) AND ((SELECT Level FROM Chars WHERE CharID = @CharID) > 10)
Begin
INSERT INTO [PS_GameData].[dbo].[CharApplySkills]([CharID],[SkillID],[SkillLevel],[LeftResetTime]) VALUES (@CharID,224,1,604800)
END

--上线获得背包防爆
IF((SELECT COUNT(*) FROM [CharApplySkills] WHERE [CharID] = @CharID AND [SkillID] = 226 AND [SkillLevel] = 1) = 0) AND ((SELECT Level FROM Chars WHERE CharID = @CharID) > 10)
Begin
INSERT INTO [PS_GameData].[dbo].[CharApplySkills]([CharID],[SkillID],[SkillLevel],[LeftResetTime]) VALUES (@CharID,226,1,604800)
END

--上线获得伊泰安护符
IF((SELECT COUNT(*) FROM [CharApplySkills] WHERE [CharID] = @CharID AND [SkillID] = 233 AND [SkillLevel] = 1) = 0) AND ((SELECT Level FROM Chars WHERE CharID = @CharID) > 10)
Begin
INSERT INTO [PS_GameData].[dbo].[CharApplySkills]([CharID],[SkillID],[SkillLevel],[LeftResetTime]) VALUES (@CharID,233,1,259200)
END

--上线获得12小时经验石
IF((SELECT Count(*) FROM [Chars] WHERE [Level] <= 10 AND [CharID] = @CharID) > 0) AND ((SELECT COUNT(*) FROM [CharApplySkills] WHERE [CharID] = @CharID AND [SkillID] = 251 AND [SkillLevel] = 1) = 0)
Begin
INSERT INTO [PS_GameData].[dbo].[CharApplySkills]([CharID],[SkillID],[SkillLevel],[LeftResetTime]) VALUES (@CharID,251,1,43200)
END

--上线获得7天复活
IF ((SELECT COUNT(*) FROM [Chars] WHERE [Grow] = 3 AND [CharID] = @CharID) > 0) AND ((SELECT COUNT(*) FROM [CharApplySkills] WHERE [CharID] = @CharID AND [SkillID] = 286 AND [SkillLevel] = 1) = 0)
BEGIN
IF (SELECT Level FROM Chars WHERE CharID = @CharID) < 10
INSERT INTO [PS_GameData].[dbo].[CharApplySkills]([CharID],[SkillID],[SkillLevel],[LeftResetTime]) VALUES (@CharID,286,1,604800)
END