proseed help [الأرشيف] - الموقع العربي الاول للعبة Silkroad Online

مشاهدة النسخة كاملة : proseed help

hodamoseba

18-05-2017, 04:51 AM

كنان شغال مش عارف مالو
https://up.harajgulf.com/imagef-1495072272313610-png.html

MORJANA

18-05-2017, 12:00 PM

أمسح البروسيدر و أعمل Save و أقفل الـ SQL و أفتحه تاني و حط البروسيدر و سيف و جرب كده
أهم حاجة و أنت بتدوس F5 ما تبقاش عامل Select على حاجة بالماوس
يعني دوس في أي مكان فاضي جمب البروسيدر
:111 (23):

hodamoseba

18-05-2017, 03:56 PM

بردة البروسيد اهو 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

hodamoseba

19-05-2017, 08:05 PM

:111 (7)::111 (7)::111 (7):

hodamoseba

22-05-2017, 01:06 AM

Up كل يومين

Dev.Ri3o

22-05-2017, 01:31 PM

يبقوكل InCorrect جنب END شوف انت حاطط END زيادة او فى قوس قبلهعا انت مش ضايفو

hodamoseba

22-05-2017, 04:03 PM

جربت امسح ال end مبيشتغلش بردة عدلى علية لو سمحت:winksmiley02:

Dev.Ri3o

22-05-2017, 05:48 PM

انت عايز تعمل ايه بالظبط ؟

hodamoseba

23-05-2017, 03:13 AM

البروسيد دة عاوز احطة فى addlogitem

زابطهولى

Dev.Ri3o

23-05-2017, 03:56 PM

انا قصدى عاوز تعمل scroll ايه

hodamoseba

23-05-2017, 04:43 PM

انا عملت Scroll خلاص واقفة على البروسيد دة بس

Dev.Ri3o

25-05-2017, 07:55 PM

انا عملت Scroll خلاص واقفة على البروسيد دة بس

ماشى قولى عايز تعمل scroll واعملك ال Procedure بتاعها

elbattawy1st

26-05-2017, 04:12 AM

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

hodamoseba

26-05-2017, 05:08 AM

انتا راجل جدع اقسم بللة بحبكم :harhar:

hodamoseba

26-05-2017, 05:08 AM