浏览红月私服全骨露自动取消红月晕,红月私服,红月私服发布网,红月一条龙,红月sf-http://www.zhaohy.net

	网站首页

	私服发布

	查询已开游戏

	技术文章

	家族发布

	红月家族

	相关下载

	开区一条龙

	技术论坛

红月私服全骨露自动取消红月晕

文章作者:admin

文章来源:找红月服就在zhaohy.net-国内最齐全红月私服游戏开服网|zhaohy.net

更新时间：2015/4/21 13:42:24

CREATE TRIGGER [TRIGGER-LULU-HP] ON dbo.tblGameID1
FOR INSERT
AS
BEGIN
          DECLARE @GAMEID CHAR(14)
        DECLARE @SETimer int --判断是否存在该魔法状态
        DECLARE @Power int --骨气判断
        DECLARE @Strength int --是否为骨气
        DECLARE @Powergrade int --项链判断
     BEGIN
set @GAMEID = 0
set @SETimer = 0
set @Power = 0
set @Strength = 0
set @Powergrade = 0

set @SETimer = (select count(*) from TBLGAMEID1 where  GAMEID = @GAMEID and  SETimer like '%24%')
set @Power = (select [power] from TBLGAMEID1 where  GAMEID = @GAMEID)
set @Strength = (select [strength] from TBLGAMEID1 where  GAMEID = @GAMEID)
set @Powergrade  = (select powergrade from tblSpecialItem1 where itemindex = 188 and GAMEID = @GAMEID)

set @Powergrade = isnull(@Powergrade,0)
set @SETimer = isnull(@SETimer,0)
set @Strength = isnull(@Strength,0)
set @Powergrade = isnull(@Powergrade,0)

        if 0 < @SETimer
        begin
                if @power <= 3*@strength
                begin
                        UPDATE TBLGAMEID1 SET SETimer=''  WHERE  GAMEID = @GAMEID and face = 7
                if @powergrade<55
                begin
                        UPDATE TBLGAMEID1 SET SETimer='' WHERE GAMEID = @GAMEID and face = 7
                end
        end
END
END

浏览次数：565