[Release] Devil Upgrade System S4a

[X_Shadow]

النهاردة جايبلك system كدة مش معمول فى Servers كتير بس قولت يمكن يعجبكوا و افيدكوا..


الـ System ده عبارة عن انك لما ترفع devil A + معين كدة انت تكون محددو.. هتضرب السكرول اللى هديك ال lines بتاعتها و هتعملك teleport وحدها و يجيلك Devil S +0 .. ياريت الSystem يعجلكوا

DB Side
1- Scroll..
_RefObjCommon
1 41887 ITEM_SRO4WORLD_UPGRADE_SCROLL ????? (????) xxx SN_ITEM_SRO4WORLD_UPGRADE_SCROLL SN_ITEM_SRO4WORLD_UPGRADE_SCROLL_TT_DESC 0 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 0 0 0 0 0 1 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx itemetcdrop_mall_scroll.bsr itemetcmall_indulgence.ddj xxx xxx 21402

_RefObjItem
21402 1 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0

Media Side
Itemdata_45000.txt 1 41887 ITEM_SRO4WORLD_UPGRADE_SCROLL ????? (????) xxx SN_ITEM_SRO4WORLD_UPGRADE_SCROLL SN_ITEM_SRO4WORLD_UPGRADE_SCROLL_TT_DESC 0 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 0 0 0 0 0 1 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\mall_indulgence.ddj xxx xxx 1 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0

و حط ده فى _AddLogItem فى SRO_VT_SHARDLOG
IF (@Operation = 41)
BEGIN
IF (@ItemRefID = 70023)
BEGIN
declare @RefCharID int
DECLARE @OldItemCodeName varchar(128)
DECLARE @SS varchar(128)
DECLARE @OldItemPlus int
DECLARE @NewItemPlus int
DECLARE @NewItemCodeName varchar(128)
Declare @RefMail INT = (Select ItemID From SRO_VT_SHARD.dbo._Inventory Where CharID=@CharID AND Slot ='13')
Declare @RefMailID INT = (Select RefItemID From SRO_VT_SHARD.dbo._Items Where ID64 = @RefMail)
select @OldItemCodeName = CodeName128 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @RefMailID
if(@OldItemCodeName = 'ITEM_MALL_AVATAR_M_NASRUN' or @OldItemCodeName = 'ITEM_MALL_AVATAR_M_NASRUN_BLUE' or @OldItemCodeName = 'ITEM_MALL_AVATAR_M_NASRUN_YELLOW')
begin
set @NewItemCodeName = 'ITEM_MALL_AVATAR_M_NASRUN_UNIQUE'
end
if(@OldItemCodeName = 'ITEM_MALL_AVATAR_W_NASRUN' or @OldItemCodeName = 'ITEM_MALL_AVATAR_W_NASRUN_BLUE' or @OldItemCodeName = 'ITEM_MALL_AVATAR_W_NASRUN_YELLOW')
begin
set @NewItemCodeName = 'ITEM_MALL_AVATAR_W_NASRUN_UNIQUE'
end
declare @CharName16 varchar(64)
set @OldItemPlus = 7
set @NewItemPlus = 0
DECLARE @ReplaceID int
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.dbo._Inventory as inv inner join SRO_VT_SHARD.dbo._Items as itm on inv.ItemID = itm.ID64 inner join SRO_VT_SHARD.dbo._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @OldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName16 =CharName16 from SRO_VT_SHARD.dbo._Char where CharID=@CharID
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName16,@NewItemCodeName,1,@NewItemPlus
end
end
END


الفيديو شكرااا للباشا Hamza Figo

qDoX_VEYThs



كلمة شكرااا تكفينى :helmetsmiley: يارب يكون عجبكم

[Mr Z!dane]

#Approved
اظبط اكوادك و هات صور من الجيم
عشان نقدر نقيم الموضوع

[Hamza FiGo]

تسلم ايدك. بس محتاج تنسيق . منتظرين التنسيق :lulu13:

[Hamza FiGo]

مش المفروض البروسيدر تبقي كدا ؟ انت مش حاطط ID الاسكرول فيها



IF ((@Operation = 41 ) AND (@ItemRefID = 41887))
BEGIN
IF (@ItemRefID = Scroll ID FROM _RefObjCommon)
BEGIN
declare @RefCharID int
DECLARE @OldItemCodeName varchar(128)
DECLARE @SS varchar(128)
DECLARE @OldItemPlus int
DECLARE @NewItemCodeName varchar(128)
Declare @RefMail INT = (Select ItemID From SRO_VT_SHARD.dbo._Inventory Where CharID=@CharID AND Slot ='13')
Declare @RefMailID INT = (Select RefItemID From SRO_VT_SHARD.dbo._Items Where ID64 = @RefMail)
select @OldItemCodeName = CodeName128 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @RefMailID
if(@OldItemCodeName = 'ITEM_MALL_AVATAR_M_NASRUN' or @OldItemCodeName = 'ITEM_MALL_AVATAR_M_NASRUN_BLUE' or @OldItemCodeName = 'ITEM_MALL_AVATAR_M_NASRUN_YELLOW')
begin
set @NewItemCodeName = 'ITEM_MALL_AVATAR_M_NASRUN_UNIQUE'
end
if(@OldItemCodeName = 'ITEM_MALL_AVATAR_W_NASRUN' or @OldItemCodeName = 'ITEM_MALL_AVATAR_W_NASRUN_BLUE' or @OldItemCodeName = 'ITEM_MALL_AVATAR_W_NASRUN_YELLOW')
begin
set @NewItemCodeName = 'ITEM_MALL_AVATAR_W_NASRUN_UNIQUE'
end
declare @CharName16 varchar(64)
set @OldItemPlus =OLD Devil Plus
set @NewItemPlus = 0
DECLARE @ReplaceID int
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.dbo._Inventory as inv inner join SRO_VT_SHARD.dbo._Items as itm on inv.ItemID = itm.ID64 inner join SRO_VT_SHARD.dbo._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @OldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName16 =CharName16 from SRO_VT_SHARD.dbo._Char where CharID=@CharID
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName16,@NewItemCodeName,1,@NewItemPlus
end
end
END

[Mr Z!dane]

ما هو كاتب يا حمزة
IF (@ItemRefID = Scroll ID FROM _RefObjCommon
انك تسيب ال ID في المكان ده

[Hamza FiGo]

ما هو كاتب يا حمزة

انك تسيب ال ID في المكان ده

اها مختش بالي منها سوري :wub:

[X_Shadow]

تم التنسيق والحمدالله كله كدا تمام :111 (27): ارجو التقيم

[Aeron]

فين ال credits?
انا اللى منزل ده برضو فى منتدى تانى
عالأقل قول منقول او ادى Credits -.-

[Hamza FiGo]

فين ال credits?
انا اللى منزل ده برضو فى منتدى تانى
عالأقل قول منقول او ادى Credits -.-

لو دا صحيح ياريت تكتب منقول

[Hamza FiGo]

تعديل بسيط علي البروسيدر

IF (@Operation = 41)
BEGIN
IF (@ItemRefID = 70023)
BEGIN
declare @RefCharID int
DECLARE @OldItemCodeName varchar(128)
DECLARE @SS varchar(128)
DECLARE @OldItemPlus int
DECLARE @NewItemPlus int
DECLARE @NewItemCodeName varchar(128)
Declare @RefMail INT = (Select ItemID From SRO_VT_SHARD.dbo._Inventory Where CharID=@CharID AND Slot ='13')
Declare @RefMailID INT = (Select RefItemID From SRO_VT_SHARD.dbo._Items Where ID64 = @RefMail)
select @OldItemCodeName = CodeName128 from SRO_VT_SHARD.dbo._RefObjCommon where ID = @RefMailID
if(@OldItemCodeName = 'ITEM_MALL_AVATAR_M_NASRUN' or @OldItemCodeName = 'ITEM_MALL_AVATAR_M_NASRUN_BLUE' or @OldItemCodeName = 'ITEM_MALL_AVATAR_M_NASRUN_YELLOW')
begin
set @NewItemCodeName = 'ITEM_MALL_AVATAR_M_NASRUN_UNIQUE'
end
if(@OldItemCodeName = 'ITEM_MALL_AVATAR_W_NASRUN' or @OldItemCodeName = 'ITEM_MALL_AVATAR_W_NASRUN_BLUE' or @OldItemCodeName = 'ITEM_MALL_AVATAR_W_NASRUN_YELLOW')
begin
set @NewItemCodeName = 'ITEM_MALL_AVATAR_W_NASRUN_UNIQUE'
end
declare @CharName16 varchar(64)
set @OldItemPlus = 7
set @NewItemPlus = 0
DECLARE @ReplaceID int
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.dbo._Inventory as inv inner join SRO_VT_SHARD.dbo._Items as itm on inv.ItemID = itm.ID64 inner join SRO_VT_SHARD.dbo._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @OldItemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName16 =CharName16 from SRO_VT_SHARD.dbo._Char where CharID=@CharID
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName16,@NewItemCodeName,1,@NewItemPlus
end
end
END

[Dev. iLegend]

حاول تختصر الكلام فى الـ Procedure

IF @Operation = 41 and @ItemRefID = 70023 -- Devil A Male & Female Upgrade coded by [iLegend]
Begin
Declare @ReqOptLevel INT = '5' -- just change required old devil optlevel for upgrading process.
Update dbo._Items Set RefItemID='24411',OptLevel='0',CreaterName='iLegen d'
Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_InventoryForAvatar] Where CharID = @CharID and Slot = '4' and ItemID>0) and RefItemID in (24405,24409,24407) and (OptLevel >= @ReqOptLevel) -- Male
Update dbo._Items Set RefItemID='24412',OptLevel='0',CreaterName='iLegen d'
Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_InventoryForAvatar] Where CharID = @CharID and Slot = '4' and ItemID>0) and RefItemID in (24406,24410,24408) and (OptLevel >= @ReqOptLevel) -- Female
End

ملحوظة : الـ Procedure دا بيعمل ابجريد لاي ديفل A ان كان M او F
ولازم يكون الكراكتر لابسة الديفل ويكون بالـ + اللى تحدده بدل '5'

:icon7:

[Hamza FiGo]

تم التجربة وشغالة تمام . عندي عملتها علي DevilA+7 زي الفيديو دا

qDoX_VEYThs

[™MaR™]

تمام تسلم ايدك يا معلم

[Aeron]

حاول تختصر الكلام فى الـ Procedure

IF @Operation = 41 and @ItemRefID = 70023 -- Devil A Male & Female Upgrade coded by [iLegend]
Begin
Declare @ReqOptLevel INT = '5' -- just change required old devil optlevel for upgrading process.
Update dbo._Items Set RefItemID='24411',OptLevel='0',CreaterName='iLegen d'
Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_InventoryForAvatar] Where CharID = @CharID and Slot = '4' and ItemID>0) and RefItemID in (24405,24409,24407) and (OptLevel >= @ReqOptLevel) -- Male
Update dbo._Items Set RefItemID='24412',OptLevel='0',CreaterName='iLegen d'
Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_InventoryForAvatar] Where CharID = @CharID and Slot = '4' and ItemID>0) and RefItemID in (24406,24410,24408) and (OptLevel >= @ReqOptLevel) -- Female
End

ملحوظة : الـ Procedure دا بيعمل ابجريد لاي ديفل A ان كان M او F
ولازم يكون الكراكتر لابسة الديفل ويكون بالـ + اللى تحدده بدل '5'

:icon7:



طريقة تانية:
If @operation = 41 and @ItemRefID = 'Scroll id from objcommon'
begin
declare @PLUS INT = '9' /* YOUR REQUIRED PLUS TO UPGRADE DEVIL*/
declare @OldSpiritCode varchar(max)
declare @NewSpiritCode varchar(max)
declare @ItemID = (select id from SRO_VT_SHARD.._refobjcommon where codename128 like @OldSpiritCode)
declare @Item64 = (SELECT top 1 ID64 FROM SRO_VT_SHARD.._ITEMS itm
inner join sro_VT_Shard.._inventory inv
on itm.id64 = inv.itemid
where inv.charid = @charid and itm.refitemid = @ItemID and inv.slot >= 13 and itm.optlevel >= @PLUS)
select @oldSpiritCode = codename128 from sro_VT_SHARd.._refobjcommon
if @oldSpiritCode = 'DEVIL_CODENAME128'
begin
set @NewSpiritCode = 'NEWDEVIL_CODENAME128'
end

update sro_vt_shard.._items set refitemid = @ItemID,optlevel = 0 where id64 like @item64
end


ياريت محدش يقول منقول.

[Hamza FiGo]

الناس الضليغة دي طالب منهم طلب بسيط ^^

سكرول Weapon upgrade

14D+12 B Rare >>> 15D A Rare

^^

[Dev. iLegend]

انت تأمر يا باشا

[Dangers SrO]

nice
Very Good

[Hamza FiGo]

كمان تعديل بسيط في itemdata_xxxxx عدل مسار الايكونات علشان بتجيب كراش . يعني يبقي كدا

1 41887 ITEM_SRO4WORLD_UPGRADE_SCROLL ????? (????) xxx SN_ITEM_SRO4WORLD_UPGRADE_SCROLL SN_ITEM_SRO4WORLD_UPGRADE_SCROLL_TT_DESC 0 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 0 0 0 0 0 1 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\mall_indulgence.ddj xxx xxx 1 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0

[Jaffa]

Rebobjitem بايظ يا فندم

[Jaffa]

و كمان انا مظبط المسافات

[X_Shadow]

شكراا لباشا :mf_leprachaun: Hamza Figo :mf_leprachaun: ساعدنى كتير فى الموضوع دا

[Hamza FiGo]

Rebobjitem بايظ يا فندم


مش بايظ ياباشا فية بس سافة زيادة مش اكتر. اتفضل. هتغير الـ ID بس

60021 1 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? 1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0

[Hamza FiGo]

شكراا لباشا :mf_leprachaun: Hamza Figo :mf_leprachaun: ساعدنى كتير فى الموضوع دا


انت تامر ياباشا ^^

[Hamza FiGo]

تقييمي ممتاز علشان فكرة البروسيدر دي ممكن تعمل منها اي حاجة . انا عملت منها افكار كتير ^^

[X_Shadow]

احنا تحت امرك ياباشا حمزة انت تامر يابرنس :111 (2):

[Jaffa]

ولا اى بروسيدور شغال

[Hamza FiGo]

ولا اى بروسيدور شغال

باشا الفيديو قدام حضرتك دا اكبر دليل انه شغال

حضرتك مش عارف تضيفها. يبقي راجع لو سمحت علي كل حاجة

[Jaffa]

طب سؤال ده ولا ال Lacnao عامله ؟