help probasha

[hodamoseba]

عاوز اعدل على دة يبقى من 120 ل 125

IF (@Operation = 41 and @ItemRefID = 69678 /*id el scroll hena*/) ---- Madde By #Xan
    BEGIN
        DECLARE @MLevel INT = (SELECT MaxLevel FROM SRO_VT_SHARD.._Char WHERE CharID=@CharID)
            IF (@MLevel between 40 and 108)
                BEGIN
                    DECLARE @CharName varchar(Max) = (SELECT CharName16 FROM SRO_VT_SHARD.._Char WHERE CharID=@CharID)
                    UPDATE SRO_VT_SHARD.dbo._Char Set CurLevel=110,MaxLevel=110,Strength+=(110-@MLevel),Intellect+=(110-@MLevel),RemainStatPoint+=((110-@MLevel)*3) WHERE CharID=@CharID
                    UPDATE SRO_VT_SHARD.dbo._Char Set HwanLevel = '1' ---Made By #Xan
                END
    END

 

[Dev.Ri3o]

رد: help probasha

ال Procedure ده اولا مش ل 120 ده معمول ل 110 بس هو معموله Limit لل lvl معين ... او حاجة هتشيل كل 110 وتحط 125
و

  IF (@MLevel between 40 and 108)

هتشيلها او تخليها

  IF (@MLevel between0 and 125)

​