神泣单机教程 - 上线状态限制修改及说明

正常情况下，进入游戏可以给角色附加BUFF效果，比如送复活，送背包防爆，送太阳等等，但是我们要限制他达到多少级后不再赠送，或者赠送后死亡后是否要继续获得该药水，那就需要再数据库中进行修改了。
数据库具体位置：PS_GameData.usp_Read_Chars_Detail2_R

下面状态是 低于10级可以免费获取这些状态，如果是高于10级，则在状态时间到期后 小退不能获取技能

--上线获得装备耐用锤
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