| ™Ozoo-Eboda™ |
25-06-2017 03:38 AM |
رد: عايز حل في المشكله دي
اقتباس:
المشاركة الأصلية كتبت بواسطة F77
(المشاركة 5321753)
يا باشا كله تمام والسكرول بتنزل من الكونصول
بس هي المشكله مش بتغير حاجه
وبالنسبه لل اي دي انا غيرته من السكرول ومن البروسيدر
|
اتفضل..
كود PHP:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_ChangeSystemH.A] Script Date: 12/29/2015 09:36:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create PROCEDURE [dbo].[_ChangeSystemH.A]
@CharID Int
As
--- CH & Eu H.A Set
Update SRO_VT_SHARD.._Items Set RefItemID='39495',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852)
Update SRO_VT_SHARD.._Items Set RefItemID='39516',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852)
Update SRO_VT_SHARD.._Items Set RefItemID='39537',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852)
Update SRO_VT_SHARD.._Items Set RefItemID='39558',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852)
Update SRO_VT_SHARD.._Items Set RefItemID='39579',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852)
Update SRO_VT_SHARD.._Items Set RefItemID='39600',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39747,39768,39789,39810,39831,39852)
Update SRO_VT_SHARD.._Items Set RefItemID='39873',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230)
Update SRO_VT_SHARD.._Items Set RefItemID='39894',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230)
Update SRO_VT_SHARD.._Items Set RefItemID='39915',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230)
Update SRO_VT_SHARD.._Items Set RefItemID='39936',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230)
Update SRO_VT_SHARD.._Items Set RefItemID='39957',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230)
Update SRO_VT_SHARD.._Items Set RefItemID='39978',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (39999,40020,40041,40062,40083,40104,40125,40146,40167,40188,40209,40230)
Update SRO_VT_SHARD.._Items Set RefItemID='40524',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755)
Update SRO_VT_SHARD.._Items Set RefItemID='40545',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755)
Update SRO_VT_SHARD.._Items Set RefItemID='40566',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755)
Update SRO_VT_SHARD.._Items Set RefItemID='40587',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755)
Update SRO_VT_SHARD.._Items Set RefItemID='40608',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755)
Update SRO_VT_SHARD.._Items Set RefItemID='40629',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (40776,40797,40818,40839,40860,40881,40650,40671,40692,40713,40734,40755)
Update SRO_VT_SHARD.._Items Set RefItemID='40902',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133)
Update SRO_VT_SHARD.._Items Set RefItemID='40923',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133)
Update SRO_VT_SHARD.._Items Set RefItemID='40944',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133)
Update SRO_VT_SHARD.._Items Set RefItemID='40965',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133)
Update SRO_VT_SHARD.._Items Set RefItemID='40986',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133)
Update SRO_VT_SHARD.._Items Set RefItemID='41007',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (41154,41175,41196,41217,41238,41259,41028,41049,41070,41091,41112,41133)
...
Creat procedure
كود PHP:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_ChangeSystemL.A] Script Date: 12/29/2015 09:37:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create PROCEDURE [dbo].[_ChangeSystemL.A]
@CharID Int
As
--- CH & Eu L.A Set
Update SRO_VT_SHARD.._Items Set RefItemID='39621',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852)
Update SRO_VT_SHARD.._Items Set RefItemID='39642',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852)
Update SRO_VT_SHARD.._Items Set RefItemID='39663',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852)
Update SRO_VT_SHARD.._Items Set RefItemID='39684',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852)
Update SRO_VT_SHARD.._Items Set RefItemID='39705',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852)
Update SRO_VT_SHARD.._Items Set RefItemID='39726',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (39495,39516,39537,39558,39579,39600,39747,39768,39789,39810,39831,39852)
Update SRO_VT_SHARD.._Items Set RefItemID='39999',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978)
Update SRO_VT_SHARD.._Items Set RefItemID='40020',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978)
Update SRO_VT_SHARD.._Items Set RefItemID='40041',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978)
Update SRO_VT_SHARD.._Items Set RefItemID='40062',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978)
Update SRO_VT_SHARD.._Items Set RefItemID='40083',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978)
Update SRO_VT_SHARD.._Items Set RefItemID='40104',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (40125,40146,40167,40188,40209,40230,39873,39894,39915,39936,39957,39978)
Update SRO_VT_SHARD.._Items Set RefItemID='40650',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881)
Update SRO_VT_SHARD.._Items Set RefItemID='40671',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881)
Update SRO_VT_SHARD.._Items Set RefItemID='40692',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881)
Update SRO_VT_SHARD.._Items Set RefItemID='40713',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881)
Update SRO_VT_SHARD.._Items Set RefItemID='40734',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881)
Update SRO_VT_SHARD.._Items Set RefItemID='40755',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (40524,40545,40566,40587,40608,40629,40776,40797,40818,40839,40860,40881)
Update SRO_VT_SHARD.._Items Set RefItemID='41028',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259)
Update SRO_VT_SHARD.._Items Set RefItemID='41049',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259)
Update SRO_VT_SHARD.._Items Set RefItemID='41070',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259)
Update SRO_VT_SHARD.._Items Set RefItemID='41091',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259)
Update SRO_VT_SHARD.._Items Set RefItemID='41112',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259)
Update SRO_VT_SHARD.._Items Set RefItemID='41133',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (40902,40923,40944,40965,40986,41007,41154,41175,41196,41217,41238,41259)
..
كود PHP:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_ChangeSystemRobe] Script Date: 12/29/2015 09:37:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create PROCEDURE [dbo].[_ChangeSystemRobe]
@CharID Int
As
--- CH & Eu Robe Set
Update SRO_VT_SHARD.._Items Set RefItemID='39747',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
Update SRO_VT_SHARD.._Items Set RefItemID='39768',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
Update SRO_VT_SHARD.._Items Set RefItemID='39789',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
Update SRO_VT_SHARD.._Items Set RefItemID='39810',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
Update SRO_VT_SHARD.._Items Set RefItemID='39831',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
Update SRO_VT_SHARD.._Items Set RefItemID='39852',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (39621,39642,39663,39684,39705,39726,39495,39516,39537,39558,39579,39600)
Update SRO_VT_SHARD.._Items Set RefItemID='40125',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104)
Update SRO_VT_SHARD.._Items Set RefItemID='40146',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104)
Update SRO_VT_SHARD.._Items Set RefItemID='40167',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104)
Update SRO_VT_SHARD.._Items Set RefItemID='40188',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104)
Update SRO_VT_SHARD.._Items Set RefItemID='40209',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104)
Update SRO_VT_SHARD.._Items Set RefItemID='40230',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (39873,39894,39915,39936,39957,39978,39999,40020,40041,40062,40083,40104)
Update SRO_VT_SHARD.._Items Set RefItemID='40776',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
Update SRO_VT_SHARD.._Items Set RefItemID='40797',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
Update SRO_VT_SHARD.._Items Set RefItemID='40818',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
Update SRO_VT_SHARD.._Items Set RefItemID='40839',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
Update SRO_VT_SHARD.._Items Set RefItemID='40860',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
Update SRO_VT_SHARD.._Items Set RefItemID='40881',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (40650,40671,40692,40713,40734,40755,40524,40545,40566,40587,40608,40629)
Update SRO_VT_SHARD.._Items Set RefItemID='41154',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '0' and ItemID > 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007)
Update SRO_VT_SHARD.._Items Set RefItemID='41175',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '2' and ItemID > 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007)
Update SRO_VT_SHARD.._Items Set RefItemID='41196',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '1' and ItemID > 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007)
Update SRO_VT_SHARD.._Items Set RefItemID='41217',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '4' and ItemID > 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007)
Update SRO_VT_SHARD.._Items Set RefItemID='41238',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '3' and ItemID > 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007)
Update SRO_VT_SHARD.._Items Set RefItemID='41259',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '5' and ItemID > 0) and RefItemID in (41028,41049,41070,41091,41112,41133,40902,40923,40944,40965,40986,41007)
..
AddLogItem
كود PHP:
--- CH Weapon and Set Change
IF (@Operation = 41)and(@ItemRefID = 42099) --Ch Weapon change TO Sword
Begin
Update SRO_VT_SHARD.._Items Set RefItemID='39369',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (39390,39411,39432,39453)
END
IF (@Operation = 41)and(@ItemRefID = 42100) --Ch Weapon change TO Blade
Begin
Update SRO_VT_SHARD.._Items Set RefItemID='39390',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (39369,39411,39432,39453)
END
IF (@Operation = 41)and(@ItemRefID = 42101) --Ch Weapon change TO Spear
BEGIN
Update SRO_VT_SHARD.._Items Set RefItemID='39411',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (39369,39390,39432,39453)
END
IF (@Operation = 41)and(@ItemRefID = 42102) --Ch Weapon change TO Glaive
BEGIN
Update SRO_VT_SHARD.._Items Set RefItemID='39432',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (39369,39390,39411,39453)
END
IF (@Operation = 41)and(@ItemRefID = 42103) --Ch Weapon change TO Bow
BEGIN
Update SRO_VT_SHARD.._Items Set RefItemID='39453',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (39369,39390,39411,39432)
END
IF (@Operation = 41)and(@ItemRefID = 42104) --Ch Set Garment Or Protector change TO Set Armor
Begin
Execute [SRO_VT_SHARDLOG].[dbo].[_ChangeSystemH.A] @CharID
END
IF (@Operation = 41)and(@ItemRefID = 42105) --Ch Set Garment Or Armor change TO Set Protector
Begin
Execute [SRO_VT_SHARDLOG].[dbo].[_ChangeSystemL.A] @CharID
END
IF (@Operation = 41)and(@ItemRefID = 42106) --Ch Set Protector Or Armor change TO Set Garment
Begin
Execute [SRO_VT_SHARDLOG].[dbo].[_ChangeSystemRobe] @CharID
END
--- EU Weapon and Set Change
IF (@Operation = 41)and(@ItemRefID = 42107) --EU Weapon change TO Dagger
Begin
Update SRO_VT_SHARD.._Items Set RefItemID='40314',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40335,40356,40377,40398,40419,40440,40461,40482)
END
IF (@Operation = 41)and(@ItemRefID = 42108) --EU Weapon change TO CrossBow
Begin
Update SRO_VT_SHARD.._Items Set RefItemID='40398',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40314,40335,40356,40377,40419,40440,40461,40482)
END
IF (@Operation = 41)and(@ItemRefID = 42109) --EU Weapon change TO Axe
Begin
Update SRO_VT_SHARD.._Items Set RefItemID='40377',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40314,40335,40356,40398,40419,40440,40461,40482)
END
IF (@Operation = 41)and(@ItemRefID = 42110) --EU Weapon change TO One Hand Sword
Begin
Update SRO_VT_SHARD.._Items Set RefItemID='40335',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40314,40356,40377,40398,40419,40440,40461,40482)
END
IF (@Operation = 41)and(@ItemRefID = 42111) --EU Weapon change TO Two Hand Sword
Begin
Update SRO_VT_SHARD.._Items Set RefItemID='40356',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40314,40335,40377,40398,40419,40440,40461,40482)
END
IF (@Operation = 41)and(@ItemRefID = 42112) --EU Weapon change TO Two Hand Staff
Begin
Update SRO_VT_SHARD.._Items Set RefItemID='40440',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40314,40335,40356,40377,40398,40419,40461,40482)
END
IF (@Operation = 41)and(@ItemRefID = 42113) --EU Weapon change TO Claric Rod
Begin
Update SRO_VT_SHARD.._Items Set RefItemID='40482',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40314,40335,40356,40377,40398,40419,40440,40461)
END
IF (@Operation = 41)and(@ItemRefID = 42114) --EU Weapon change TO Warlock Rod
Begin
Update SRO_VT_SHARD.._Items Set RefItemID='40419',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40314,40335,40356,40377,40398,40440,40461,40482)
END
IF (@Operation = 41)and(@ItemRefID = 42115) --EU Weapon change TO Harp
Begin
Update SRO_VT_SHARD.._Items Set RefItemID='40461',CreaterName='HLP' Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = @CharID and Slot = '6' and ItemID > 0) and RefItemID in (40314,40335,40356,40377,40398,40419,40440,40482)
END
IF (@Operation = 41)and(@ItemRefID = 42116) --EU Set Robe Or L.A change TO Set H.A
Begin
Execute [SRO_VT_SHARDLOG].[dbo].[_ChangeSystemH.A] @CharID
END
IF (@Operation = 41)and(@ItemRefID = 42117) --EU Set Robe Or H.A change TO Set L.A
Begin
Execute [SRO_VT_SHARDLOG].[dbo].[_ChangeSystemL.A] @CharID
END
IF (@Operation = 41)and(@ItemRefID = 42118) --EU Set L.A Or H.A change TO Set Robe
Begin
|
