help

[hodamoseba]

عاوز اشيل الoptlevel من البروسيد دة يعنى يعدل علية من غير بلص
IF (@Operation = 41 and @ItemRefID = 'Scroll CommonID')
Begin
Declare @NewItemID Int , @ID64 Int, @Slot Int, @ReqPlus Int, @NewPlus Int, @Name Varchar(100), @Codename Varchar(128), @Msg Varchar(128);
Set @Slot = 13; -- Upgrade Slot
Set @ReqPlus = 8; -- Required Optlevel
Set @NewPlus = 0; -- New Item OptLevel
Set @Codename = 'ITEM_MALL_UPGRADE_SCROLL_ALL_SLOT_13'; -- Upgrade Scroll CodeName128
Set @Msg = 'Target item cannot be upgraded, scroll has returned to your inventory.'; -- Private Message for fail upgrading process
Set @Name = (Select Charname16 From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID);
Select @NewItemID = U.NewRefItemID , @ID64 = I.ID64 From [dbo].[ItemsUpgrade] U Inner Join [SRO_VT_SHARD].[dbo].[_Items] I
ON U.OldRefItemID = I.RefItemID Inner Join [SRO_VT_SHARD].[dbo].[_Inventory] V ON I.ID64 = V.ItemID Where V.CharID = @CharID
and V.Slot = @Slot and I.OptLevel = @ReqPlus;
IF (@NewItemID Is Not Null)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @NewItemID , OptLevel = @NewPlus Where ID64 = @ID64;
End ELSE Begin
-- Vsro Multi Tool Table
Insert Into [iLegendBot].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values ('1','Private',@Name,@Msg,Getdate());
Exec [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @Name,@Codename,1,0;
End
End

[™ EgY_KhaN ™]

من غير اوامر + سواء اولد او نيو اهي جرب ولو فيها ايرور ابعت لاني مجربتهاش الصراحه

IF (@Operation = 41 and @ItemRefID = 'Scroll CommonID')
Begin
Declare @NewItemID Int , @ID64 Int, @Slot Int, @ReqPlus Int, @NewPlus Int, @Name Varchar(100), @Codename Varchar(128), @Msg Varchar(128);
Set @Slot = 13; -- Upgrade Slot
Set @Codename = 'ITEM_MALL_UPGRADE_SCROLL_ALL_SLOT_13'; -- Upgrade Scroll CodeName128
Set @Msg = 'Target item cannot be upgraded, scroll has returned to your inventory.'; -- Private Message for fail upgrading process
Set @Name = (Select Charname16 From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID);
Select @NewItemID = U.NewRefItemID , @ID64 = I.ID64 From [dbo].[ItemsUpgrade] U Inner Join [SRO_VT_SHARD].[dbo].[_Items] I
ON U.OldRefItemID = I.RefItemID Inner Join [SRO_VT_SHARD].[dbo].[_Inventory] V ON I.ID64 = V.ItemID Where V.CharID = @CharID
and V.Slot = @Slot;
IF (@NewItemID Is Not Null)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @NewItemID Where ID64 = @ID64;
End ELSE Begin
-- Vsro Multi Tool Table
Insert Into [iLegendBot].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values ('1','Private',@Name,@Msg,Getdate());
Exec [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @Name,@Codename,1,0;
End
End

[hodamoseba]

بما انك رديت بسرعة عاوز اعدل على lv البروسيد دة عاوزة من 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

[™ EgY_KhaN ™]

بما انك رديت بسرعة عاوز اعدل على lv البروسيد دة عاوزة من 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

دول 110 مش 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=125,MaxLevel=125,Strength+=(125-@MLevel),Intellect+=(125-@MLevel),RemainStatPoint+=((125-@MLevel)*3) WHERE CharID=@CharID
UPDATE SRO_VT_SHARD.dbo._Char Set HwanLevel = '1' ---Made By #Xan
END
END

[hodamoseba]

مشتغلش

[™ EgY_KhaN ™]

مشتغلش

أنهي فيهم ؟!!

[Dev.Klito]

بما انك رديت بسرعة عاوز اعدل على lv البروسيد دة عاوزة من 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

يا ريت توضح يعنى قول انت عايز السكرول تشتغل من لفل كام و تطلع للفل كام

[hodamoseba]

الاولى اشتغل تمام التانية عاوز من لفل 120 ل 125 وشكرا

[Dev.Klito]

الاولى اشتغل تمام التانية عاوز من لفل 120 ل 125 وشكرا


اتفضل دى كدا الناس اللى ممكن تستخدمها من لفل 120 لــ 124 و يتطلع للفل 125

التحميل في المرفقات

[hodamoseba]

## شكرا يا رجالة

[Mahmoud Rashwan]

##