Weapons Upgrade Scroll

[H A W A R Y]

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

[UnStoppable!]

شرح فيشخ

[MR.KaBO]

nice

[GM]KEmo]]

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

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]]

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

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]

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

[MR.KaBO]

تسلم

[code_x]

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

[hodamoseba]

عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]


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

[hodamoseba]

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

[elfr3on2010]

تسلم ايدك

[midoali690]

تسلم إيدك

[Xandish]

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