قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة[ قسم متخصص فى شروحات و البرامج في عمل السيرفرات الخاصة ] [ يرجى عدم وضع الأسئلة والاستفسارات في هذا القسم ]
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
كود 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) --@Shield
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.<br><br><strong><font color="255,236,219,156">How To Use:</font></strong><br>- Use your weapon or shield that u want to upgrade it at char hands.<br>- Then use this scroll by right click on it.<br>- You will teleported automatically to town to applay changes.<br><br><strong><font color="255,236,219,156">Created by:</font></strong><br><strong><font color="255,0,255,127">iLegend</font></strong></sml2>
بكدا نكون خلصنا إضافة الاسكرول ..
الحاجات اللى المفروض تعدل عليها هى ID الاسلحة القديمة والجديدة والبلص اللى المفروض يكون عليه السلاح القديم عشان يبقا سلاح جديد وبلص السلاح الجديد .. انا عامله زيرو ..
صور من عندي ..
الموضوع مش منقول .. وياريت اللى ينقله يذكر المصدر ..
ملحوظة اخرى : الاسكرول دي بتعمل ابجريد للويبون اما يكون ممسوك فى إيد الكراكتر .. لو عايز تغيره لأول سلوت فى الانفينتوري غير سلوت الويبون والشيلد لرقم 13 زي كدا
كود PHP:
@WeaponSlot Int = 13 , -- char inventory weapon slot @ShieldSlot Int = 13 , -- char inventory shield slot
شـريـط الاهـداءات
20-02-2015, 10:04 AM
Never ForGive
.gif "111 (27)")
.gif){kind=icon}
العرض العادي
