عاوز اشيل الoptlevel من البروسيد دة يعنى يعدل علية من غير بلص
كود PHP:
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
من غير اوامر + سواء اولد او نيو اهي جرب ولو فيها ايرور ابعت لاني مجربتهاش الصراحه
كود PHP:
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
بما انك رديت بسرعة عاوز اعدل على lv البروسيد دة عاوزة من 120 ل 125
ويرت تقولى ازاى
كود PHP:
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
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
بما انك رديت بسرعة عاوز اعدل على lv البروسيد دة عاوزة من 120 ل 125
ويرت تقولى ازاى
كود PHP:
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
كود PHP:
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
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
بما انك رديت بسرعة عاوز اعدل على lv البروسيد دة عاوزة من 120 ل 125
ويرت تقولى ازاى
كود PHP:
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
يا ريت توضح يعنى قول انت عايز السكرول تشتغل من لفل كام و تطلع للفل كام