| قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة [ قسم متخصص فى شروحات و البرامج في عمل السيرفرات الخاصة ] [ يرجى عدم وضع الأسئلة والاستفسارات في هذا القسم ] |
 |
|
|
أدوات الموضوع | انواع عرض الموضوع |
|
|
28-12-2015, 01:37 PM
|
#1 | ||||||||||
  
|
السلام عليكم Scroll CH&EU change Weapon & Set to any weapon or Set النهاردة انا عامل موضوع جديد ممكن يفيد ناس كتير المهم سكرول ده بيبدل اي سلاح صيني او اوربي لسلاح تاني حسب السكرول يعني كل سلاح بسكرول و نفس الكلام مع اللبس و لازم الاعب يكون ماسك السلاح في سكرول السلاح و نفس الكلام مع set ملاحظة الصيني بيبدل صيني و نفس الكلام مع الاروبي بنفس + و stats ندخل علي المهم Database lines _RefObjCommon كود PHP:
كود PHP:
Create Procedure كود PHP:
كود PHP:
Create Procedure كود PHP:
_AddLogItem كود PHP:
Media Lines itemdata_45000 كود PHP:
كود PHP:
|
||||||||||
|
التعديل الأخير تم بواسطة HLP ; 29-12-2015 الساعة 12:27 PM
|
| إعلانات google |
|
|
|
28-12-2015, 02:02 PM
|
#2 | ||||||||||
  
|
موضوع رائع كالعادة تسلم ايدك. ودا اكيد هنزله عندي في السيرفر بعد اذنك  لانه هيفيدني انا كا جي ام تمت الاضافة لتجميلعه اسكرولات 2015 |
||||||||||
|
|
|
28-12-2015, 02:25 PM
|
#3 | ||||||||||
  
|
تسلم موضوع جميل وانشالله هجربو |
||||||||||
|
|
|
28-12-2015, 02:27 PM
|
#4 | ||||||||||
|
عندي فكرة بسيطة الاسكرول كبيرة ولو اتحطت في اللوج هتعمل لاج. فا من الاحسن تعملها بروسيدر لوحدها علشان نخفف الحمل علي اللوج وتعرف الناس يغيرو IDs الايتمز فين ويعملو اية علشان هيكون صعب علي الناس شوية |
||||||||||
|
|
|
28-12-2015, 02:38 PM
|
#5 | |||||||||||||
|
اقتباس:
اقتباس:
اقتباس:
|
|||||||||||||
|
|
|
28-12-2015, 02:49 PM
|
#6 | ||||||||||
|
اعتقد تبقي كدا . عملتها علي السريع كدا علي ما اجرب. 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
كود:
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
|
|
28-12-2015, 04:05 PM
|
#7 | |||||||||||
|
اقتباس:
Create Procedure كود PHP:
كود PHP:
Create Procedure كود PHP:
_AddLogItem كود PHP:
وانا شغال علي system جديد لو اشتغل كويس يكون حاجة جديدة علي vsro شكرا |
|||||||||||
|
التعديل الأخير تم بواسطة HLP ; 29-12-2015 الساعة 01:04 PM
|
|
29-12-2015, 10:54 AM
|
#8 | ||||||||||
  
|
تمام ! :] |
||||||||||
|
|
|
29-12-2015, 12:49 PM
|
#9 | |||||||||||||||||
|
اقتباس:
اقتباس:
اقتباس:
اقتباس:
اقتباس:
اقتباس:
اقتباس:
شكرا يا رجاله |
|||||||||||||||||
|
|
|
28-12-2015, 05:16 PM
|
#10 | ||||||||||
  
|
شغل عالي استمر |
||||||||||
|
|
|
28-12-2015, 07:25 PM
|
#11 | ||||||||||
 
|
تسلم ايدك |
||||||||||
|
|
|
28-12-2015, 08:29 PM
|
#12 | ||||||||||
 
|
الله ينور .... جامد و فكره جديده |
||||||||||
|
|
|
28-12-2015, 10:20 PM
|
#13 | ||||||||||
|
بصراحه موضوع جميل فكرت اعملو اكتر من مرة و كنت بكسل تسلم الايادى |
||||||||||
|
|
|
29-12-2015, 12:34 AM
|
#14 | ||||||||||
 
|
فكرة كويسة انا هحطها في الجيم عندي شكرا |
||||||||||
|
|
|
29-12-2015, 03:15 AM
|
#15 | ||||||||||
|
Keep up  |
||||||||||
|
|
|
| يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
|
|
المواضيع المتشابهه
|
||||
| الموضوع | كاتب الموضوع | المنتدى | الردود | آخر مشاركة |
| Change Weapon Scroll #HB | HB# | قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة | 1 | 28-09-2018 04:09 PM |
| New Scroll : Change Style Weapon | Mazika Yasser | قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة | 16 | 11-12-2016 04:08 PM |
| مشكله فى Scroll Change Weapon | Blizzard | قسم المواضيع المكررة و المخالفة | 5 | 12-10-2016 04:36 PM |
| Change Weapon D10 To D11 | gcbhardy | قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة | 9 | 21-04-2016 12:47 PM |
| no change weapon | mndo0o0 | قسم الاستفسارات ومشاكل وحلول ال PHBOT | 7 | 06-08-2015 01:13 PM |
.gif){kind=icon}
العرض المتطور
