مطلوب Reset Stats Scroll

[testmis]

السلام عليكم و رحمة الله وبركاتة
مطلوب Reset Stats Scroll علشان النقط بتاعة ال STR و ال INT


شكرا.

[Hero]

ال Procedure " AddTimedJob "

if(@JobID = '45001')
begin
declare @Strength int
declare @Intellect int
declare @MaxLevel int
declare @RemainStatPoint int
select @MaxLevel = MaxLevel from _Char where CharID = @CharID
set @RemainStatPoint = (@MaxLevel*3)-3
set @MaxLevel = @MaxLevel+19
UPDATE _Char SET Strength=@MaxLevel, Intellect=@MaxLevel, RemainStatPoint=@RemainStatPoint WHERE CharID=@CharID
return -3
end
خد سطور اى scroll
وغير اسمها و ال ID بتعها

[testmis]

ال Procedure " AddTimedJob "

if(@JobID = '45001')
begin
declare @Strength int
declare @Intellect int
declare @MaxLevel int
declare @RemainStatPoint int
select @MaxLevel = MaxLevel from _Char where CharID = @CharID
set @RemainStatPoint = (@MaxLevel*3)-3
set @MaxLevel = @MaxLevel+19
UPDATE _Char SET Strength=@MaxLevel, Intellect=@MaxLevel, RemainStatPoint=@RemainStatPoint WHERE CharID=@CharID
return -3
end
خد سطور اى scroll
وغير اسمها و ال ID بتعها

متشكر جدا للرد بس هل ينفع اخليها منغير DC ? تبقا Auto Teleport

الاسكرول بترجعنى المدينة بس مفيش اى حاجة بتحصل مع العلم انى رابط رقم ال AddTimedJob برقم ال RefObjCommon

if(@JobID = '41800')
begin
declare @Strength int
declare @Intellect int
declare @MaxLevel int
declare @RemainStatPoint int
select @MaxLevel = MaxLevel from _Char where CharID = @CharID
set @RemainStatPoint = (@MaxLevel*3)-3
set @MaxLevel = @MaxLevel+19
UPDATE _Char SET Strength=@MaxLevel, Intellect=@MaxLevel, RemainStatPoint=@RemainStatPoint WHERE CharID=@CharID
return -3
end

[Hero]

اربطه ب الرقم ال Skill بتاعه مش ال ID اللى ف ال common

[testmis]

اربطه ب الرقم ال Skill بتاعه مش ال ID اللى ف ال common

جارى التجربة و هرجع بالنتيجة ان شاء الله

[Dev.Ri3o]

حطا ده ف ال _AddLogItem اللى فى ال SRO_VT_SHARDLOG وحط ID ال RefObjCommon وشيل اللى اللى فى ال _TimedJob

IF (@Operation = 41 AND @ItemRefID = 46894) -- RefObjCommon ID
Begin
Select @MaxLevel = MaxLevel From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID
Set @RemainStatPoInt = (@MaxLevel*3)-3
Set @MaxLevel = @MaxLevel +19
Update [SRO_VT_SHARD].[dbo].[_Char] Set Strength = @MaxLevel , Intellect = @MaxLevel , RemainStatPoInt = @RemainStatPoInt Where CharID = @CharID
End

[testmis]

حطا ده ف ال _AddLogItem اللى فى ال SRO_VT_SHARDLOG وحط ID ال RefObjCommon وشيل اللى اللى فى ال _TimedJob

IF (@Operation = 41 AND @ItemRefID = 46894) -- RefObjCommon ID
Begin
Select @MaxLevel = MaxLevel From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID
Set @RemainStatPoInt = (@MaxLevel*3)-3
Set @MaxLevel = @MaxLevel +19
Update [SRO_VT_SHARD].[dbo].[_Char] Set Strength = @MaxLevel , Intellect = @MaxLevel , RemainStatPoInt = @RemainStatPoInt Where CharID = @CharID
End



متشكر جدا و جارى التجربة
دة البيحضل بعد ما بدوس Execute
http://a.up-00.com/2018/03/15215736623391.png (http://www.up-00.com/)

[Hero]

اتفضل التعديل
IF (@Operation = 41 AND @ItemRefID = 46894) -- RefObjCommon ID
Begin
declare @Strength int
declare @Intellect int
declare @MaxLevel int
declare @RemainStatPoint int
Select @MaxLevel = MaxLevel From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID
Set @RemainStatPoInt = (@MaxLevel*3)-3
Set @MaxLevel = @MaxLevel +19
Update [SRO_VT_SHARD].[dbo].[_Char] Set Strength = @MaxLevel , Intellect = @MaxLevel , RemainStatPoInt = @RemainStatPoInt Where CharID = @CharID
End

[testmis]

اتفضل التعديل
IF (@Operation = 41 AND @ItemRefID = 46894) -- RefObjCommon ID
Begin
declare @Strength int
declare @Intellect int
declare @MaxLevel int
declare @RemainStatPoint int
Select @MaxLevel = MaxLevel From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID
Set @RemainStatPoInt = (@MaxLevel*3)-3
Set @MaxLevel = @MaxLevel +19
Update [SRO_VT_SHARD].[dbo].[_Char] Set Strength = @MaxLevel , Intellect = @MaxLevel , RemainStatPoInt = @RemainStatPoInt Where CharID = @CharID
End

متشكر للرد و جارى التجربة

[testmis]

نفعت الحمد لله ثم شكرا جدا لحضرتكو بجد

[testmis]

## يغلق

[Hero]

##