| محمد منتصر |
24-12-2022 06:59 PM |
New Devil Scroll Switch Gander With Return Scroll
Switch Devil Gander Scroll الأسكرول قديم وموجود كتير بس أعتقد كلها مشاكل .
البرسيدور ده هتحطه علي أي سكرول عندك وعيش بقي أولاً لازم الديفل يكون موجود في أول خانة Slot 13 عشان يشتغل معاك تمام . طيب لو حد نسي وضرب الأسكرول والديفل مش موجود في اول خانة أيه هيحصل ؟
اللي هيحصل أن السيستم هيبعتله سكرول تانية غيرها ويقوله أن الديفل مش موجود سهلة وبكده مش هتضيع عليه الأسكرول بتاعته :) طبعا الرساله هتجيلك في السيستم بس عشان تظهر للبلاير محتاج أي فلتر أو برنامج بقي Notice عشان يبعتله المسدج دي
نييجي للشغل بقي أول حاجة هتعمل الكويري ده عندك
كود PHP:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: Table [dbo].[LOG_MSG] Script Date: 24/12/2022 05:45:11 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[T0P_LOG](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Service] [int] NOT NULL,
[Type] [varchar](50) NOT NULL,
[Target] [varchar](60) NULL,
[Message] [varchar](max) NULL,
[RefMobID] [varchar](10) NULL,
[RefItemID] [varchar](10) NULL,
[Amount] [varchar](4) NULL,
[OptLvl] [varchar](3) NULL,
[RegionID] [varchar](50) NULL,
[PosX] [varchar](50) NULL,
[PosY] [varchar](50) NULL,
[PosZ] [varchar](50) NULL,
[WorldID] [varchar](50) NULL,
[Date] [varchar](100) NOT NULL,
PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
تاني حاجة هتفتح AddLogItem وهتضيف البرسيدور ده جواه
كود PHP:
IF (@Operation = 41) and(@ItemRefID = 444777)
Begin
Begin
Declare @CodenameScroll Varchar(128), @Msg1 Varchar(128),@NameChar Varchar(100),@NewItemID39 Int ,@refItemID int;
Declare @InvID INT = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0)
Declare @RefItemID31 INT = (Select RefItemID From [SRO_VT_SHARD].[dbo].[_Items] Where ID64 = @InvID)
Set @CodenameScroll = 'ITEM_T0P_SCROLL_6'; -- Gander Scroll CodeName128
Set @Msg1 = 'Ops its Failed But Scroll Has returned inside ur inventory Again Do not Worry !!'; -- Private Message for fail upgrading process
Set @NameChar = (Select Charname16 From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID);
SET @refItemID = (SELECT RefItemID From [SRO_VT_SHARD].[dbo].[_Items] Where ID64 = ( Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0 ));
IF @RefItemID in (24414,24972,24974,24976,24978,24406,24408,24410,24412,93196) -- IF found your Devil is Male
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24413' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24414 --@Devil B Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24971' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24972 --@Devil A Red Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24973' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24974 --@Devil A Yellow Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24975' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24976 --@Devil A Blue Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24977' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24978 --@Devil S Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24405' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24406 --@Devil A Red Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24407' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24408 --@Devil A Yellow Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24409' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24410 --@Devil A Blue Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24411' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24412 --@Devil S Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='93195' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 93196 --@Hard Avatar
End
ELSE IF @RefItemID in (24413,24971,24973,24975,24977,24405,24407,24409,24411,93195) -- IF found your Devil is Female
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24414' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24413 --@Devil B Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24972' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24971 --@Devil A Red Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24974' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24973 --@Devil A Yellow Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24976' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24975 --@Devil A Blue Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24978' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24977 --@Devil S Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24406' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24405 --@Devil A Red Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24408' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24407 --@Devil A Yellow Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24410' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24409 --@Devil A Blue Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24412' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24411 --@Devil S Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='93196' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 93195 --@Hard Avatar
End ELSE
Begin
Insert Into [SRO_VT_SHARDLOG].[dbo].[T0P_LOG] (Service,Type,Target,Message,Date) Values ('1','Private',@NameChar,@Msg1,Getdate());
Exec [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @NameChar,@CodenameScroll,1,0;
End
End
End
هتشيل الItemRefID وتحط الid بتاع الاسكرول بتاعتك مكانه وبس كده مبروك عليك الأسكرول الجديد او ممكن تضيف الأسكرول دي
ItemData_xxxxx
كود PHP:
1 444777 ITEM_MALL_T0P_SYSTEM_DEVIL_SWITCHER ???? ???? ??? (???) xxx SN_ITEM_MALL_T0P_SYSTEM_DEVIL_SWITCHER SN_ITEM_MALL_T0P_SYSTEM_DEVIL_SWITCHERS_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 0 3 1 0 0 129 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr top\silk_box2.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0
textdata_object
كود PHP:
1 SN_ITEM_MALL_T0P_SYSTEM_DEVIL_SWITCHER Devil Switcher Scroll
Database----
refobjcomen
كود PHP:
1 444777 ITEM_MALL_T0P_SYSTEM_DEVIL_SWITCHER ???? ???? ??? (???) xxx SN_ITEM_MALL_T0P_SYSTEM_DEVIL_SWITCHER SN_ITEM_MALL_T0P_SYSTEM_DEVIL_SWITCHERS_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 0 3 1 0 0 129 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr top\silk_box2.ddj xxx xxx 999000
RefObjItem
كود PHP:
999000 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
|
