كود 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