Weapons Upgrade Scroll [الأرشيف] - الموقع العربي الاول للعبة Silkroad Online

مشاهدة النسخة كاملة : Weapons Upgrade Scroll

Dev. iLegend

20-02-2015, 10:04 AM

http://www2.0zz0.com/2012/10/22/15/311256858.gif

http://www2.0zz0.com/2012/10/22/16/593531309.png

http://im45.gulfup.com/wsCcCQ.png

Weapons Upgrade Scroll

الاسكرول دي عبارة عن ريترن سكرول بترجعك المدينة وبتعملك Upgrade for weapon and shield اللى معاك

فى حالة واحد بس لما يكونوا بالبلص اللى انت تحدده من الـ Procedure ، ويكونوا نوع السلاح اللى تحدده برضه ..

انا عاملها تيست والـ Procedure شغال تمام ..

[ مثال ]
لما يروح ويلاقي الكراكتر السلاح او الشيلد اللى ماسكاه فى اديها Egy A +7 يحوله لسلاح Egy B +0

من نفس النوع يعني لو كان Staff or Blade or Bow or Dagger .. etc يتحول لنفس النوع بدجري اعلى

على حسب منتا تحدد .. الشرح مكتوب على كل خطوة فى الـ Procedure دا غير اني قولتلك دلوقتي طريقة عمله ..

ملحوظة : لما تيجي تعدل على Old or New items دخل مكان الارقام ID الايتم اللى هتجيبه من الكيوري دا

Select ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where CodeName128 Like 'Item Code Name'

نبدأ بقا بإضافة الاسكرول ..

Database Side

dbo._RefObjCommon

1 42161 ITEM_MALL_WEAPON_UPGRADE_SCROLL ????? (????) xxx SN_ITEM_MALL_WEAPON_UPGRADE_SCROLL SN_ITEM_MALL_WEAPON_UPGRADE_SCROLL_TT_DESC 0 0 3 3 3 1 180000 3 0 0 1 1 0 0 1 0 0 1 0 0 0 0 0 0 0 -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\archemy_skillstone_wind.ddj xxx xxx 21635

dbo._RefObjItem

21635 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

SRO_VT_SHARDLOG > Programmability > Stored Procedures > dbo._AddLogItem

IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 42161) -- RefObjCommon ID
Begin
Execute [SRO_VT_SHARDLOG].[dbo].[_UpgradeSystem] @CharID
End
End

Execute this Procedure by Log DB name

USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_UpgradeSystem] Script Date: 02/20/2015 08:35:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[_UpgradeSystem]
@CharID Int
As

-- Declare expression.
Declare @CreaterName Varchar(60) = 'iLegend' , -- Creater Name
@WeaponSlot Int = 6 , -- char inventory weapon slot
@ShieldSlot Int = 7 , -- char inventory shield slot
@ReqOptLevel Int = 7 , -- Change old item requiared plus for upgrade.
@NewOptLevel Int = 0 , -- Change new item plus after upgrade
-- Set Old and New Weapons RefObjCommon ID below
-- Use This Query to get each item ID by Codename128
-- Select ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where CodeName128 Like 'Item Code Name'

---> Old weapon ID's ---> New weapons ID's
@Old_CH_SWORD_ID Int = 25611 , @New_CH_SWORD_ID Int = 25669 , --@New Chinese Sword
@Old_CH_BLADE_ID Int = 25612 , @New_CH_BLADE_ID Int = 25670 , --@Chinese Blade
@Old_CH_SPEAR_ID Int = 25613 , @New_CH_SPEAR_ID Int = 25671 , --@Chinese Spear
@Old_CH_TBLADE_ID Int = 25614 , @New_CH_TBLADE_ID Int = 25672 , --@Chinese Glaive
@Old_CH_BOW_ID Int = 25615 , @New_CH_BOW_ID Int = 25673 , --@Chinese Bow
@Old_CH_SHIELD_ID Int = 25616 , @New_CH_SHIELD_ID Int = 25674 , --@Chinese Shield
@Old_EU_DAGGER_ID Int = 25623 , @New_EU_DAGGER_ID Int = 25681 , --@European Dagger
@Old_EU_XBOW_ID Int = 25624 , @New_EU_XBOW_ID Int = 25682 , --@European CrossBow
@Old_EU_AXE_ID Int = 25622 , @New_EU_AXE_ID Int = 25680 , --@European Axe
@Old_EU_SWORD_ID Int = 25620 , @New_EU_SWORD_ID Int = 25678 , --@European One Hand Sword
@Old_EU_TSWORD_ID Int = 25621 , @New_EU_TSWORD_ID Int = 25679 , --@European Two Hand Sword
@Old_EU_TSTAFF_ID Int = 25625 , @New_EU_TSTAFF_ID Int = 25683 , --@European Two Hand Staff
@Old_EU_STAFF_ID Int = 25627 , @New_EU_STAFF_ID Int = 25685 , --@European Claric Rod
@Old_EU_DSTAFF_ID Int = 25626 , @New_EU_DSTAFF_ID Int = 25684 , --@European Warlock Rod
@Old_EU_HARP_ID Int = 25628 , @New_EU_HARP_ID Int = 25686 , --@European Harp
@Old_EU_SHIELD_ID Int = 25629 , @New_EU_SHIELD_ID Int = 25687 --@European Shield

--------------------------------------------------------------------------------------------
-- Start Upgrade system :

-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_SWORD_ID and (OptLevel >= @ReqOptLevel) --@Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_BLADE_ID and (OptLevel >= @ReqOptLevel) --@Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_SPEAR_ID and (OptLevel >= @ReqOptLevel) --@Spear
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_TBLADE_ID and (OptLevel >= @ReqOptLevel) --@T-Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_BOW_ID and (OptLevel >= @ReqOptLevel) --@Bow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @ShieldSlot and ItemID> 0) and RefItemID = @Old_CH_SHIELD_ID and (OptLevel >= @ReqOptLevel) --@Shield
-- EU Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DAGGER_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_DAGGER_ID and (OptLevel >= @ReqOptLevel) --@Dagger
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_XBOW_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_XBOW_ID and (OptLevel >= @ReqOptLevel) --@Crossbow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_AXE_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_AXE_ID and (OptLevel >= @ReqOptLevel) --@Axe
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SWORD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_SWORD_ID and (OptLevel >= @ReqOptLevel) --@OneHand Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSWORD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_TSWORD_ID and (OptLevel >= @ReqOptLevel) --@T-Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSTAFF_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_TSTAFF_ID and (OptLevel >= @ReqOptLevel) --@T-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_STAFF_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_STAFF_ID and (OptLevel >= @ReqOptLevel) --@Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DSTAFF_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_DSTAFF_ID and (OptLevel >= @ReqOptLevel) --@Dark-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_HARP_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_HARP_ID and (OptLevel >= @ReqOptLevel) --@Harp
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SHIELD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @ShieldSlot and ItemID> 0) and RefItemID = @Old_EU_SHIELD_ID and (OptLevel >= @ReqOptLevel) --@Shield

Media Side

itemdata_xxxx.txt

1 42161 ITEM_MALL_WEAPON_UPGRADE_SCROLL ????? (????) xxx SN_ITEM_MALL_WEAPON_UPGRADE_SCROLL SN_ITEM_MALL_WEAPON_UPGRADE_SCROLL_TT_DESC 0 0 3 3 3 1 180000 3 0 0 1 1 0 0 1 0 0 1 0 0 0 0 0 0 0 -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\archemy_skillstone_wind.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

textdata_object.txt

1 SN_ITEM_MALL_WEAPON_UPGRADE_SCROLL Weapons Upgrade Scroll
1 SN_ITEM_MALL_WEAPON_UPGRADE_SCROLL_TT_DESC <sml2>Use this scroll for upgrade your weapon or shield. How To Use: - Use your weapon or shield that u want to upgrade it at char hands. - Then use this scroll by right click on it. - You will teleported automatically to town to applay changes. Created by: iLegend</sml2>

بكدا نكون خلصنا إضافة الاسكرول ..

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

صور من عندي ..

http://www2.0zz0.com/2015/02/20/09/671749876.jpg

http://www2.0zz0.com/2015/02/20/09/980379790.jpg

الموضوع مش منقول .. وياريت اللى ينقله يذكر المصدر ..

# iLegend #

Mr Z!dane

20-02-2015, 02:41 PM

Approved#
:111 (27):

Hamza FiGo

20-02-2015, 02:49 PM

طب مش تقول فكرة مين ياض ^^

علي العموم واحد . . تسلم ايدك .. البروسيدر اللي معايا كدة تقريبا مش وحشة بردة

Dev. iLegend

20-02-2015, 02:49 PM

Approved#
:111 (27):

Thanks Zizo <3

:cheerful_h4h:

Dangers SrO

20-02-2015, 02:51 PM

nice Jop
بس يا همزا دي فكرتك :] :brucelee:

Dev. iLegend

20-02-2015, 02:53 PM

طب مش تقول فكرة مين ياض ^^

علي العموم واحد . . تسلم ايدك .. البروسيدر اللي معايا كدة تقريبا مش وحشة بردة

يا جدعااااان دي فكرة حمزة فيجوو

:respect:

انا كنت عاملها عندي بس بكل الايتم حتي السيت والاكسسوري

Dev. iLegend

20-02-2015, 02:57 PM

ملحوظة : لازم تعمل Execute للبروسيدور دا dbo._UpgradeSystem الاول قبل متضيف سطور اللي موجودة فى الـ dbo._AddLogItem

Hamza FiGo

20-02-2015, 02:57 PM

يا جدعااااان دي فكرة حمزة فيجوو

:respect:

انا كنت عاملها عندي بس بكل الايتم حتي السيت والاكسسوري

هههههه ماشي يا نجم. قولي بقا كان الغلط من اية . كان من عندي في الاضافة مثلا ولا كان فية غلطة في البروسيدر ؟

pop2009

20-02-2015, 02:57 PM

استمر :111 (27):

Dangers SrO

20-02-2015, 02:58 PM

تم :mf_boobies:

Dev. iLegend

20-02-2015, 02:59 PM

nice Jop
بس يا همزا دي فكرتك :] :brucelee:

شكراً على مرورك

همزاا مين :rofl:

Dev. iLegend

20-02-2015, 03:01 PM

استمر :111 (27):

ديماً بإذن الله شكرا ليك .

هههههه ماشي يا نجم. قولي بقا كان الغلط من اية . كان من عندي في الاضافة مثلا ولا كان فية غلطة في البروسيدر ؟

مكانش فيه غلط !
انت كنت بتكتب تقريباً CodeName128 بتاع الايتم مش الـ ID

Dev. iLegend

20-02-2015, 03:07 PM

ملحوظة اخرى : الاسكرول دي بتعمل ابجريد للويبون اما يكون ممسوك فى إيد الكراكتر .. لو عايز تغيره لأول سلوت فى الانفينتوري غير سلوت الويبون والشيلد لرقم 13 زي كدا

@WeaponSlot Int = 13 , -- char inventory weapon slot
@ShieldSlot Int = 13 , -- char inventory shield slot

Hamza FiGo

20-02-2015, 04:21 PM

ديماً بإذن الله شكرا ليك .

مكانش فيه غلط !
انت كنت بتكتب تقريباً CodeName128 بتاع الايتم مش الـ ID

لا الغلط اني مكنتش بمسك الويبون كنت بحطة في الصفحة . الواحد سعات بيستغبي كدا ويحس انة مبيعرفش يقرا حتي :rocket:

Jaffa

20-02-2015, 04:49 PM

نجم مصر

Hamza FiGo

20-02-2015, 04:50 PM

Worked 100%

:cool:

Dev. iLegend

20-02-2015, 06:15 PM

نجم مصر

شكراً يا برنجي إنشاء الله منتظر افكار جديدة منكوا
:59:

Worked 100%

:cool:

يعني تمام مش هلاقي حد يقوللي انت منزل موضوع مش شغال راجع موضوعك والكلام اللي ملوش لازمة دا
:jump::jump::jump::jump::jump:

Hamza FiGo

20-02-2015, 07:18 PM

يعني تمام مش هلاقي حد يقوللي انت منزل موضوع مش شغال راجع موضوعك والكلام اللي ملوش لازمة دا
:jump::jump::jump::jump::jump:

[/B][/FONT][/COLOR]

كاتب الكلمة دي علشان لو حد قال مش شغالة تبقي من عنده :wave:

MarOz

20-02-2015, 07:32 PM

شكرا علي جهودك

Jaffa

20-02-2015, 08:56 PM

يعني تمام مش هلاقي حد يقوللي انت منزل موضوع مش شغال راجع موضوعك والكلام اللي ملوش لازمة دا
هو انت يا عالمى بتنزل حاجة بايظة ده انت مالك الاسكرول و البروسيدور

Jaffa

20-02-2015, 09:07 PM

طب مش تقول فكرة مين ياض ^^

علي العموم واحد . . تسلم ايدك .. البروسيدر اللي معايا كدة تقريبا مش وحشة بردة

فكرة مين ياض :] ده انا اللى عامل الموضوع الاول ^^
بس كلنا واحد تسلم ايدك يا صحبى انت حبيبى :D

Jaffa

20-02-2015, 09:33 PM

بص انا مش هتكلم الصور اللى هتتكلم
1-
http://www12.0zz0.com/2015/02/20/21/106886821.png
2-
http://www12.0zz0.com/2015/02/20/21/584705753.png
3-
http://www12.0zz0.com/2015/02/20/21/998642114.png
4-
http://www11.0zz0.com/2015/02/20/21/349823105.png

Jaffa

20-02-2015, 09:33 PM

مش شغال للاسف

Jaffa

20-02-2015, 09:36 PM

ولا حتى Devil Upgrade شغالة

Dev. iLegend

21-02-2015, 02:59 PM

كاتب الكلمة دي علشان لو حد قال مش شغالة تبقي من عنده :wave:

تسلم يا حمزة بيه :winner_third_h4h:

شكرا علي جهودك

الشكر لله يا برنس وتسلم على مرورك

فكرة مين ياض :] ده انا اللى عامل الموضوع الاول ^^
بس كلنا واحد تسلم ايدك يا صحبى انت حبيبى :D

هو الصراحة انا عامل نظام الابجريد دا من زمااان :triggerhappysmiley:

بص انا مش هتكلم الصور اللى هتتكلم
1-
http://www12.0zz0.com/2015/02/20/21/106886821.png
2-
http://www12.0zz0.com/2015/02/20/21/584705753.png
3-
http://www12.0zz0.com/2015/02/20/21/998642114.png
4-
http://www11.0zz0.com/2015/02/20/21/349823105.png

مش شغال للاسف

ولا حتى Devil Upgrade شغالة

بالنسبة ليك يا Jaffa معلش انا برضه مش هتكلم هسيب الاقتباسات اللي تتكلم ..

ملحوظة اخرى : الاسكرول دي بتعمل ابجريد للويبون اما يكون ممسوك فى إيد الكراكتر .. لو عايز تغيره لأول سلوت فى الانفينتوري غير سلوت الويبون والشيلد لرقم 13 زي كدا

@WeaponSlot Int = 13 , -- char inventory weapon slot
@ShieldSlot Int = 13 , -- char inventory shield slot

حاول تختصر الكلام فى الـ 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:

Jaffa

23-02-2015, 03:40 PM

شغال 100%

ViP_BedoZ

23-02-2015, 03:55 PM

الله ينور شغل فاخر على الأخر:icon5:

Hamza FiGo

23-02-2015, 04:57 PM

شغال 100%

اخيرا حاجة اشتغلت عندك

:bounce:

Dev. iLegend

23-02-2015, 10:01 PM

الله ينور شغل فاخر على الأخر:icon5:

تسلم يا برنس وشكرا على مرورك

Jaffa

23-02-2015, 10:25 PM

اخيرا حاجة اشتغلت عندك

هو مكنش قايل ان لازم اكون لابس السلاح انا شفت كدة فى الردود و هو قايل
و Devil Upgrade شغالة الحمد لله

H A W A R Y

03-04-2015, 09:05 PM

كلام مية المية

UnStoppable!

05-04-2015, 10:50 AM

شرح فيشخ

MR.KaBO

20-06-2015, 04:12 PM

:cheerful_h4h: nice

GM]KEmo]

16-01-2016, 07:19 PM

سؤال هو الصق الكود ده فيييييينن ؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟؟

Execute this Procedure by Log DB name

[/COLOR][/COLOR][/COLOR][/COLOR][/SIZE][/FONT][PHP]USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_UpgradeSystem] Script Date: 02/20/2015 08:35:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[_UpgradeSystem]
@CharID Int
As

-- Declare expression.
Declare @CreaterName Varchar(60) = 'iLegend' , -- Creater Name
@WeaponSlot Int = 6 , -- char inventory weapon slot
@ShieldSlot Int = 7 , -- char inventory shield slot
@ReqOptLevel Int = 7 , -- Change old item requiared plus for upgrade.
@NewOptLevel Int = 0 , -- Change new item plus after upgrade
-- Set Old and New Weapons RefObjCommon ID below
-- Use This Query to get each item ID by Codename128
-- Select ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where CodeName128 Like 'Item Code Name'

---> Old weapon ID's ---> New weapons ID's
@Old_CH_SWORD_ID Int = 25611 , @New_CH_SWORD_ID Int = 25669 , --@New Chinese Sword
@Old_CH_BLADE_ID Int = 25612 , @New_CH_BLADE_ID Int = 25670 , --@Chinese Blade
@Old_CH_SPEAR_ID Int = 25613 , @New_CH_SPEAR_ID Int = 25671 , --@Chinese Spear
@Old_CH_TBLADE_ID Int = 25614 , @New_CH_TBLADE_ID Int = 25672 , --@Chinese Glaive
@Old_CH_BOW_ID Int = 25615 , @New_CH_BOW_ID Int = 25673 , --@Chinese Bow
@Old_CH_SHIELD_ID Int = 25616 , @New_CH_SHIELD_ID Int = 25674 , --@Chinese Shield
@Old_EU_DAGGER_ID Int = 25623 , @New_EU_DAGGER_ID Int = 25681 , --@European Dagger
@Old_EU_XBOW_ID Int = 25624 , @New_EU_XBOW_ID Int = 25682 , --@European CrossBow
@Old_EU_AXE_ID Int = 25622 , @New_EU_AXE_ID Int = 25680 , --@European Axe
@Old_EU_SWORD_ID Int = 25620 , @New_EU_SWORD_ID Int = 25678 , --@European One Hand Sword
@Old_EU_TSWORD_ID Int = 25621 , @New_EU_TSWORD_ID Int = 25679 , --@European Two Hand Sword
@Old_EU_TSTAFF_ID Int = 25625 , @New_EU_TSTAFF_ID Int = 25683 , --@European Two Hand Staff
@Old_EU_STAFF_ID Int = 25627 , @New_EU_STAFF_ID Int = 25685 , --@European Claric Rod
@Old_EU_DSTAFF_ID Int = 25626 , @New_EU_DSTAFF_ID Int = 25684 , --@European Warlock Rod
@Old_EU_HARP_ID Int = 25628 , @New_EU_HARP_ID Int = 25686 , --@European Harp
@Old_EU_SHIELD_ID Int = 25629 , @New_EU_SHIELD_ID Int = 25687 --@European Shield

--------------------------------------------------------------------------------------------
-- Start Upgrade system :

-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_SWORD_ID and (OptLevel >= @ReqOptLevel) --@Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_BLADE_ID and (OptLevel >= @ReqOptLevel) --@Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_SPEAR_ID and (OptLevel >= @ReqOptLevel) --@Spear
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_TBLADE_ID and (OptLevel >= @ReqOptLevel) --@T-Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_BOW_ID and (OptLevel >= @ReqOptLevel) --@Bow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @ShieldSlot and ItemID> 0) and RefItemID = @Old_CH_SHIELD_ID and (OptLevel >= @ReqOptLevel) --@Shield
-- EU Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DAGGER_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_DAGGER_ID and (OptLevel >= @ReqOptLevel) --@Dagger
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_XBOW_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_XBOW_ID and (OptLevel >= @ReqOptLevel) --@Crossbow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_AXE_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_AXE_ID and (OptLevel >= @ReqOptLevel) --@Axe
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SWORD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_SWORD_ID and (OptLevel >= @ReqOptLevel) --@OneHand Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSWORD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_TSWORD_ID and (OptLevel >= @ReqOptLevel) --@T-Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSTAFF_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_TSTAFF_ID and (OptLevel >= @ReqOptLevel) --@T-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_STAFF_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_STAFF_ID and (OptLevel >= @ReqOptLevel) --@Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DSTAFF_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_DSTAFF_ID and (OptLevel >= @ReqOptLevel) --@Dark-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_HARP_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_HARP_ID and (OptLevel >= @ReqOptLevel) --@Harp
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SHIELD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @ShieldSlot and ItemID> 0) and RefItemID = @Old_EU_SHIELD_ID and (OptLevel >= @ReqOptLevel) --

GM]KEmo]

16-01-2016, 07:23 PM

سؤال مهم هو الصق الكود ده فيييين ؟؟؟؟؟

Execute this Procedure by Log DB name

[/COLOR][/COLOR][/COLOR][/COLOR][/SIZE][/FONT]USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_UpgradeSystem] Script Date: 02/20/2015 08:35:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[_UpgradeSystem]
@CharID Int
As

-- Declare expression.
Declare @CreaterName Varchar(60) = 'iLegend' , -- Creater Name
@WeaponSlot Int = 6 , -- char inventory weapon slot
@ShieldSlot Int = 7 , -- char inventory shield slot
@ReqOptLevel Int = 7 , -- Change old item requiared plus for upgrade.
@NewOptLevel Int = 0 , -- Change new item plus after upgrade
-- Set Old and New Weapons RefObjCommon ID below
-- Use This Query to get each item ID by Codename128
-- Select ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where CodeName128 Like 'Item Code Name'

---> Old weapon ID's ---> New weapons ID's
@Old_CH_SWORD_ID Int = 25611 , @New_CH_SWORD_ID Int = 25669 , --@New Chinese Sword
@Old_CH_BLADE_ID Int = 25612 , @New_CH_BLADE_ID Int = 25670 , --@Chinese Blade
@Old_CH_SPEAR_ID Int = 25613 , @New_CH_SPEAR_ID Int = 25671 , --@Chinese Spear
@Old_CH_TBLADE_ID Int = 25614 , @New_CH_TBLADE_ID Int = 25672 , --@Chinese Glaive
@Old_CH_BOW_ID Int = 25615 , @New_CH_BOW_ID Int = 25673 , --@Chinese Bow
@Old_CH_SHIELD_ID Int = 25616 , @New_CH_SHIELD_ID Int = 25674 , --@Chinese Shield
@Old_EU_DAGGER_ID Int = 25623 , @New_EU_DAGGER_ID Int = 25681 , --@European Dagger
@Old_EU_XBOW_ID Int = 25624 , @New_EU_XBOW_ID Int = 25682 , --@European CrossBow
@Old_EU_AXE_ID Int = 25622 , @New_EU_AXE_ID Int = 25680 , --@European Axe
@Old_EU_SWORD_ID Int = 25620 , @New_EU_SWORD_ID Int = 25678 , --@European One Hand Sword
@Old_EU_TSWORD_ID Int = 25621 , @New_EU_TSWORD_ID Int = 25679 , --@European Two Hand Sword
@Old_EU_TSTAFF_ID Int = 25625 , @New_EU_TSTAFF_ID Int = 25683 , --@European Two Hand Staff
@Old_EU_STAFF_ID Int = 25627 , @New_EU_STAFF_ID Int = 25685 , --@European Claric Rod
@Old_EU_DSTAFF_ID Int = 25626 , @New_EU_DSTAFF_ID Int = 25684 , --@European Warlock Rod
@Old_EU_HARP_ID Int = 25628 , @New_EU_HARP_ID Int = 25686 , --@European Harp
@Old_EU_SHIELD_ID Int = 25629 , @New_EU_SHIELD_ID Int = 25687 --@European Shield

--------------------------------------------------------------------------------------------
-- Start Upgrade system :

-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_SWORD_ID and (OptLevel >= @ReqOptLevel) --@Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_BLADE_ID and (OptLevel >= @ReqOptLevel) --@Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_SPEAR_ID and (OptLevel >= @ReqOptLevel) --@Spear
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_TBLADE_ID and (OptLevel >= @ReqOptLevel) --@T-Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_CH_BOW_ID and (OptLevel >= @ReqOptLevel) --@Bow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @ShieldSlot and ItemID> 0) and RefItemID = @Old_CH_SHIELD_ID and (OptLevel >= @ReqOptLevel) --@Shield
-- EU Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DAGGER_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_DAGGER_ID and (OptLevel >= @ReqOptLevel) --@Dagger
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_XBOW_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_XBOW_ID and (OptLevel >= @ReqOptLevel) --@Crossbow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_AXE_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_AXE_ID and (OptLevel >= @ReqOptLevel) --@Axe
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SWORD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_SWORD_ID and (OptLevel >= @ReqOptLevel) --@OneHand Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSWORD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_TSWORD_ID and (OptLevel >= @ReqOptLevel) --@T-Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSTAFF_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_TSTAFF_ID and (OptLevel >= @ReqOptLevel) --@T-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_STAFF_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_STAFF_ID and (OptLevel >= @ReqOptLevel) --@Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DSTAFF_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_DSTAFF_ID and (OptLevel >= @ReqOptLevel) --@Dark-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_HARP_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @WeaponSlot and ItemID> 0) and RefItemID = @Old_EU_HARP_ID and (OptLevel >= @ReqOptLevel) --@Harp
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SHIELD_ID , OptLevel = @NewOptLevel , CreaterName = @CreaterName Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @ShieldSlot and ItemID> 0) and RefItemID = @Old_EU_SHIELD_ID and (OptLevel >= @ReqOptLevel) --@Shield[FONT=Arabic Typesetting][SIZE=6][COLOR=Red][COLOR=Blue][COLOR=DarkOrchid][COLOR=Red]

Dev.Ri3o

16-01-2016, 11:44 PM

طب لو عايز اعمل ال Procedure على كل ال+++ يعنى لو هو Egy A +5 يبقى Egy B+5 و لو Egy A+3 يبقى Egy B +3 بردو

MR.KaBO

17-01-2016, 12:47 AM

تسلم

code_x

09-07-2016, 10:01 AM

تسلم ايدك معلش رادد متاخر :rofl: بس عايز اعرف هو لما السلاح ال power بيتغير ل fight
شكل السلاح بيتغير و ال icon بتتغير ولا لا علشان في الصور متغيرتش!!

hodamoseba

18-08-2016, 06:57 PM

http://store1.up-00.com/2016-08/1471535606661.pnghttp://store1.up-00.com/2016-08/1471535606661.png

اية الغلط اللى انا مش عارفو :bond:

hodamoseba

18-08-2016, 06:58 PM

فين يا جماعم الرد :rip_1::rip_1::rip_1::rip_1::rip_1::rip_1:

elfr3on2010

24-11-2016, 10:45 AM

تسلم ايدك

midoali690

02-06-2018, 02:35 AM

تسلم إيدك

Xandish

10-10-2018, 07:21 PM

طب انا كل حاجة عملتها بالظبط .. مش شغال :/