قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة[ قسم متخصص فى شروحات و البرامج في عمل السيرفرات الخاصة ] [ يرجى عدم وضع الأسئلة والاستفسارات في هذا القسم ]
السلام عليكم
Scroll CH&EU change Weapon & Set to any weapon or Set
النهاردة انا عامل موضوع جديد ممكن يفيد ناس كتير المهم
سكرول ده بيبدل اي سلاح صيني او اوربي لسلاح تاني حسب السكرول يعني كل سلاح بسكرول و نفس الكلام مع اللبس و لازم الاعب يكون ماسك السلاح في سكرول السلاح و نفس الكلام مع set
ملاحظة الصيني بيبدل صيني و نفس الكلام مع الاروبي بنفس + و stats
ندخل علي المهم
Database lines
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)
Create 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)
Create Procedure
كود 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 Execute [SRO_VT_SHARDLOG].[dbo].[_ChangeSystemRobe] @CharID END
1 SN_ITEM_CHANGE_WPN_CH_SWORD Scroll Change any Wpeapon CH D14 To CH Sword 1 SN_ITEM_CHANGE_WPN_CH_BLADE Scroll Change any Wpeapon CH D14 To CH Blade 1 SN_ITEM_CHANGE_WPN_CH_SPEAR Scroll Change any Wpeapon CH D14 To CH Spear 1 SN_ITEM_CHANGE_WPN_CH_GLAIVE Scroll Change any Wpeapon CH D14 To CH Glaive 1 SN_ITEM_CHANGE_WPN_CH_BOW Scroll Change any Wpeapon CH D14 To CH Bow 1 SN_ITEM_CHANGE_SET_CH_ARMOR Scroll Change any Set CH D14 To CH Armor Set 1 SN_ITEM_CHANGE_SET_CH_PRO Scroll Change any Set CH D14 To CH Protector Set 1 SN_ITEM_CHANGE_SET_CH_GRAMENT Scroll Change any Set CH D14 To CH Garment Set 1 SN_ITEM_CHANGE_WPN_EU_DAGGER Scroll Change any Wpeapon EU D14 To EU Dagger 1 SN_ITEM_CHANGE_WPN_EU_XBOW Scroll Change any Wpeapon EU D14 To EU CrossBow 1 SN_ITEM_CHANGE_WPN_EU_AXE Scroll Change any Wpeapon EU D14 To EU Axe 1 SN_ITEM_CHANGE_WPN_EU_SWORD Scroll Change any Wpeapon EU D14 To EU One Hand Sword 1 SN_ITEM_CHANGE_WPN_EU_TSWORD Scroll Change any Wpeapon EU D14 To EU Two Hand Sword 1 SN_ITEM_CHANGE_WPN_EU_TSTAFF Scroll Change any Wpeapon EU D14 To EU Two Hand Staff 1 SN_ITEM_CHANGE_WPN_EU_STAFF Scroll Change any Wpeapon EU D14 To EU Claric Rod 1 SN_ITEM_CHANGE_WPN_EU_DSTAFF Scroll Change any Wpeapon EU D14 To EU Warlock Rod 1 SN_ITEM_CHANGE_WPN_EU_HARP Scroll Change any Wpeapon EU D14 To EU Harp 1 SN_ITEM_CHANGE_SET_EU_HA Scroll Change any Set EU D14 To EU H.A Set 1 SN_ITEM_CHANGE_SET_EU_LA Scroll Change any Set EU D14 To EU L.A Set 1 SN_ITEM_CHANGE_SET_EU_ROBE Scroll Change any Set EU D14 To EU Robe Set 1 SN_ITEM_CHANGE_WPN_CH_Sword_TT_DESC To use this Scroll make Sure your Wpeapon in Your Hand 1 SN_ITEM_CHANGE_WPN_CH_BLADE_TT_DESC To use this Scroll make Sure your Wpeapon in Your Hand 1 SN_ITEM_CHANGE_WPN_CH_SPEAR_TT_DESC To use this Scroll make Sure your Wpeapon in Your Hand 1 SN_ITEM_CHANGE_WPN_CH_GLAIVE_TT_DESC To use this Scroll make Sure your Wpeapon in Your Hand 1 SN_ITEM_CHANGE_WPN_CH_BOW_TT_DESC To use this Scroll make Sure your Wpeapon in Your Hand 1 SN_ITEM_CHANGE_SET_CH_ARMOR_TT_DESC To use this Scroll make Sure you Wear your Set 1 SN_ITEM_CHANGE_SET_CH_PRO_TT_DESC To use this Scroll make Sure you Wear your Set 1 SN_ITEM_CHANGE_SET_CH_GRAMENT_TT_DESC To use this Scroll make Sure you Wear your Set 1 SN_ITEM_CHANGE_WPN_EU_DAGGER_TT_DESC To use this Scroll make Sure your Wpeapon in Your Hand 1 SN_ITEM_CHANGE_WPN_EU_XBOW_TT_DESC To use this Scroll make Sure your Wpeapon in Your Hand 1 SN_ITEM_CHANGE_WPN_EU_AXE_TT_DESC To use this Scroll make Sure your Wpeapon in Your Hand 1 SN_ITEM_CHANGE_WPN_EU_SWORD_TT_DESC To use this Scroll make Sure your Wpeapon in Your Hand 1 SN_ITEM_CHANGE_WPN_EU_TSWORD_TT_DESC To use this Scroll make Sure your Wpeapon in Your Hand 1 SN_ITEM_CHANGE_WPN_EU_TSTAFF_TT_DESC To use this Scroll make Sure your Wpeapon in Your Hand 1 SN_ITEM_CHANGE_WPN_EU_STAFF_TT_DESC To use this Scroll make Sure your Wpeapon in Your Hand 1 SN_ITEM_CHANGE_WPN_EU_DSTAFF_TT_DESC To use this Scroll make Sure your Wpeapon in Your Hand 1 SN_ITEM_CHANGE_WPN_EU_HARP_TT_DESC To use this Scroll make Sure your Wpeapon in Your Hand 1 SN_ITEM_CHANGE_SET_EU_HA_TT_DESC To use this Scroll make Sure you Wear your Set 1 SN_ITEM_CHANGE_SET_EU_LA_TT_DESC To use this Scroll make Sure you Wear your Set 1 SN_ITEM_CHANGE_SET_EU_ROBE_TT_DESC To use this Scroll make Sure you Wear your Set
[YOUTUBE]1v4DEccAtVw[/YOUTUBE]
التعديل الأخير تم بواسطة HLP ; 29-12-2015 الساعة 12:27 PM
اعتقد تبقي كدا . عملتها علي السريع كدا علي ما اجرب.
Create Procedure
كود:
USE [SRO_VT_SYSTEMS]
GO
/****** Object: StoredProcedure [dbo].[_ChangeSex] Script Date: 12/28/2015 11:41:58 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[_ChangeSex]
@CharID Int
As
Declare @CreaterName Varchar(MAX) = 'HLP' , -- Creater Name
@Operation Int ,
@ItemRefID Int
--- 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
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)
END
IF (@Operation = 41)and(@ItemRefID = 42105) --Ch Set Garment Or Armor change TO Set Protector
Begin
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)
END
IF (@Operation = 41)and(@ItemRefID = 42106) --Ch Set Protector Or Armor change TO Set Garment
Begin
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 = '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='39831',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='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)
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
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)
END
IF (@Operation = 41)and(@ItemRefID = 42117) --EU Set Robe Or H.A change TO Set L.A
Begin
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)
END
IF (@Operation = 41)and(@ItemRefID = 42118) --EU Set L.A Or H.A change TO Set Robe
Begin
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 = '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='40860',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='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)
END
AddLogItem
كود:
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
التعديل الأخير تم بواسطة Hamza FiGo ; 28-12-2015 الساعة 02:59 PM
المشاركة الأصلية كتبت بواسطة Hamza FiGo
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
اعتقد تبقي كدا . عملتها علي السريع كدا علي ما اجرب.
Create Procedure
كود:
USE [SRO_VT_SYSTEMS]
GO
/****** Object: StoredProcedure [dbo].[_ChangeSex] Script Date: 12/28/2015 11:41:58 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[_ChangeSex]
@CharID Int
As
Declare @CreaterName Varchar(MAX) = 'HLP' , -- Creater Name
@Operation Int ,
@ItemRefID Int
--- 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
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)
END
IF (@Operation = 41)and(@ItemRefID = 42105) --Ch Set Garment Or Armor change TO Set Protector
Begin
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)
END
IF (@Operation = 41)and(@ItemRefID = 42106) --Ch Set Protector Or Armor change TO Set Garment
Begin
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 = '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='39831',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='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)
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
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)
END
IF (@Operation = 41)and(@ItemRefID = 42117) --EU Set Robe Or H.A change TO Set L.A
Begin
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)
END
IF (@Operation = 41)and(@ItemRefID = 42118) --EU Set L.A Or H.A change TO Set Robe
Begin
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 = '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='40860',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='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)
END
AddLogItem
كود:
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = 70024) -- RefObjCommon ID
Begin
Execute [SRO_VT_SYSTEM].[dbo].[_ChangeSex] @CharID
End
End
تمام كويس بس برسيدور ده مش شغال و انا عملت برسيدور تاني اهو
Create Procedure
كود 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)
Create 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)
Create Procedure
كود 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 Execute [SRO_VT_SHARDLOG].[dbo].[_ChangeSystemRobe] @CharID END
وانا شغال علي system جديد لو اشتغل كويس يكون حاجة جديدة علي vsro
شكرا
التعديل الأخير تم بواسطة HLP ; 29-12-2015 الساعة 01:04 PM