|
• الانـتـسـاب » Mar 2013
|
• رقـم العـضـويـة » 110603
|
• المشـــاركـات » 352
|
• الـدولـة » Hurghada
|
• الـهـوايـة » DeveloP AnyThing
|
• اسـم الـسـيـرفـر » Private Server
|
• الـجـنـس » Male
|
• نقـاط التقييم » 14
|
|
|
رد: Scroll CH&EU change Weapon & Set
اقتباس:
المشاركة الأصلية كتبت بواسطة 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
شكرا
|