|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
شـريـط الاهـداءات |
|
قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة [ قسم خاص لأسئلة واستفسارات عمل السيرفرات الخاصة ] [ يرجى الالتزام بقوانين قسم الأسئلة والاستفسارات ] |
|
إعلانات google |
|
18-05-2017, 03:56 PM
|
#3
|
|
• الانـتـسـاب » Aug 2015
|
• رقـم العـضـويـة » 124741
|
• المشـــاركـات » 534
|
• الـدولـة » marsa matroh
|
• الـهـوايـة » dance
|
• اسـم الـسـيـرفـر » Private Server
|
• الـجـنـس » Male
|
• نقـاط التقييم » 10
|
|
|
رد: proseed help
بردة البروسيد اهو
كود PHP:
IF (@Operation = 41 and @ItemRefID = '47017') 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_CRASHER_UPGRADE_SCROLLB13ACC'; -- 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].[CrasherUpgradeacc13B] 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 IF (@Operation = 41 and @ItemRefID = '47016') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLB13SET'; -- 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].[CrasherUpgradeset13B] 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 IF (@Operation = 41 and @ItemRefID = '47015') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLB13SH'; -- 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].[CrasherUpgradesh13B] 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 IF (@Operation = 41 and @ItemRefID = '47014') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLB13WE'; -- 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].[CrasherUpgradewe13B] 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 IF (@Operation = 41 and @ItemRefID = '47013') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLA13ACC'; -- 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].[CrasherUpgradeacc13A] 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 IF (@Operation = 41 and @ItemRefID = '47012') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLA13SET'; -- 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].[CrasherUpgradeset13A] 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 IF (@Operation = 41 and @ItemRefID = '47011') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLA13SH'; -- 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].[CrasherUpgradesh13A] 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 IF (@Operation = 41 and @ItemRefID = '47009') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLA13WE'; -- 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].[CrasherUpgradewe13A] 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 IF (@Operation = 41 and @ItemRefID = '47008') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLB12ACC'; -- 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].[CrasherUpgradeacc12B] 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 IF (@Operation = 41 and @ItemRefID = '47007') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLB12SET'; -- 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].[CrasherUpgradeset12B] 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 IF (@Operation = 41 and @ItemRefID = '47006') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLB12SH'; -- 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].[CrasherUpgradesh12B] 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 IF (@Operation = 41 and @ItemRefID = '47005') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLB12WE'; -- 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].[CrasherUpgradewe12B] 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 IF (@Operation = 41 and @ItemRefID = '47004') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLA12ACC'; -- 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].[CrasherUpgradeacc12A] 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 IF (@Operation = 41 and @ItemRefID = '47003') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLA12SET'; -- 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].[CrasherUpgradeset12A] 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 IF (@Operation = 41 and @ItemRefID = '47002') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLA12SH'; -- 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].[CrasherUpgradesh12A] 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 IF (@Operation = 41 and @ItemRefID = '47001') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLA12WE'; -- 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].[CrasherUpgradewe12A] 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
|
|
|
22-05-2017, 04:03 PM
|
#7
|
|
• الانـتـسـاب » Aug 2015
|
• رقـم العـضـويـة » 124741
|
• المشـــاركـات » 534
|
• الـدولـة » marsa matroh
|
• الـهـوايـة » dance
|
• اسـم الـسـيـرفـر » Private Server
|
• الـجـنـس » Male
|
• نقـاط التقييم » 10
|
|
|
رد: proseed help
جربت امسح ال end مبيشتغلش بردة عدلى علية لو سمحت y02.gif" border="0" alt="" title="Wink y02" class="inlineimg" />
|
|
|
23-05-2017, 03:13 AM
|
#9
|
|
• الانـتـسـاب » Aug 2015
|
• رقـم العـضـويـة » 124741
|
• المشـــاركـات » 534
|
• الـدولـة » marsa matroh
|
• الـهـوايـة » dance
|
• اسـم الـسـيـرفـر » Private Server
|
• الـجـنـس » Male
|
• نقـاط التقييم » 10
|
|
|
رد: proseed help
البروسيد دة عاوز احطة فى addlogitem
زابطهولى
|
|
|
23-05-2017, 04:43 PM
|
#11
|
|
• الانـتـسـاب » Aug 2015
|
• رقـم العـضـويـة » 124741
|
• المشـــاركـات » 534
|
• الـدولـة » marsa matroh
|
• الـهـوايـة » dance
|
• اسـم الـسـيـرفـر » Private Server
|
• الـجـنـس » Male
|
• نقـاط التقييم » 10
|
|
|
رد: proseed help
انا عملت Scroll خلاص واقفة على البروسيد دة بس
|
|
|
26-05-2017, 04:12 AM
|
#13
|
|
• الانـتـسـاب » Mar 2014
|
• رقـم العـضـويـة » 116941
|
• المشـــاركـات » 770
|
• الـدولـة » TanTa
|
• الـهـوايـة » SilkRoaD
|
• اسـم الـسـيـرفـر » Pavo
|
• الـجـنـس » Male
|
• نقـاط التقييم » 88
|
|
|
رد: proseed help
كود PHP:
IF (@Operation = 41 and @ItemRefID = '47017') 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_CRASHER_UPGRADE_SCROLLB13ACC'; -- 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].[CrasherUpgradeacc13B] 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 IF (@Operation = 41 and @ItemRefID = '47016') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLB13SET'; -- 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].[CrasherUpgradeset13B] 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 IF (@Operation = 41 and @ItemRefID = '47015') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLB13SH'; -- 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].[CrasherUpgradesh13B] 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 IF (@Operation = 41 and @ItemRefID = '47014') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLB13WE'; -- 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].[CrasherUpgradewe13B] 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 IF (@Operation = 41 and @ItemRefID = '47013') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLA13ACC'; -- 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].[CrasherUpgradeacc13A] 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 IF (@Operation = 41 and @ItemRefID = '47012') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLA13SET'; -- 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].[CrasherUpgradeset13A] 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 IF (@Operation = 41 and @ItemRefID = '47011') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLA13SH'; -- 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].[CrasherUpgradesh13A] 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 IF (@Operation = 41 and @ItemRefID = '47009') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLA13WE'; -- 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].[CrasherUpgradewe13A] 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 IF (@Operation = 41 and @ItemRefID = '47008') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLB12ACC'; -- 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].[CrasherUpgradeacc12B] 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 IF (@Operation = 41 and @ItemRefID = '47007') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLB12SET'; -- 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].[CrasherUpgradeset12B] 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 IF (@Operation = 41 and @ItemRefID = '47006') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLB12SH'; -- 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].[CrasherUpgradesh12B] 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 IF (@Operation = 41 and @ItemRefID = '47005') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLB12WE'; -- 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].[CrasherUpgradewe12B] 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 IF (@Operation = 41 and @ItemRefID = '47004') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLA12ACC'; -- 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].[CrasherUpgradeacc12A] 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 IF (@Operation = 41 and @ItemRefID = '47003') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLA12SET'; -- 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].[CrasherUpgradeset12A] 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 IF (@Operation = 41 and @ItemRefID = '47002') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLA12SH'; -- 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].[CrasherUpgradesh12A] 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 IF (@Operation = 41 and @ItemRefID = '47001') Begin Set @Slot = 13; -- Upgrade Slot Set @Codename = 'ITEM_CRASHER_UPGRADE_SCROLLA12WE'; -- 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].[CrasherUpgradewe12A] 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
|
|
|
يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)
|
|
ضوابط المشاركة
|
لا تستطيع إضافة مواضيع جديدة
لا تستطيع الرد على المواضيع
لا تستطيع إرفاق ملفات
لا تستطيع تعديل مشاركاتك
كود HTML معطلة
|
|
|
الساعة الآن 01:48 PM.
|