| Jayden |
09-10-2016 10:26 AM |
Release] Full Blue Scrolls]
http://o55.imgup.net/151f126a.png
طبعا ناس كتير جدا كانت بتسأل عن ال Scrolls دى او ال Full Blue عمتا
عشان كده قررت اجبهلكم انهارده
مش عارف الموضوع ده موجود قبل كده ولا لا او بنفس ال Performance ولا لا بس عمتا حبيت اساعد وان شاء الله يعجبكم
نخش فى المفيد
الأول هنعمل Execute لكام حاجة كده
كود PHP:
USE SRO_VT_SHARDLOG
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_JayFB](
[service] [int] NOT NULL,
[ID] [int] NOT NULL,
[CodeName128] [varchar](129) NOT NULL,
[TypeID1] [tinyint] NOT NULL,
[TypeID2] [tinyint] NOT NULL,
[TypeID3] [tinyint] NOT NULL,
[TypeID4] [tinyint] NOT NULL,
[ReqLevel1] [tinyint] NOT NULL,
[Gender] [tinyint] NULL,
[P1] [bigint] NULL,
[P2] [bigint] NULL,
[P3] [bigint] NULL,
[P4] [bigint] NULL,
[P5] [bigint] NULL,
[P6] [bigint] NULL,
[P7] [bigint] NULL,
[P8] [bigint] NULL,
[P9] [bigint] NULL,
[MagParamNum] [tinyint] NULL,
[Va] [bigint] NULL,
[Race] [bit] NULL,
[IDENTITY] [int] IDENTITY(1,1) NOT NULL,
CONSTRAINT [PK__JayFB] 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]
GO
SET ANSI_PADDING OFF
GO
كود PHP:
USE SRO_VT_SHARDLOG
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[_JayFbScroll]
@CharID int,
@ItemRefID int,
@Operation tinyint
AS
DECLARE @ItemSlot Int
SELECT @ItemSlot =
CASE WHEN @ItemRefID = '47046' Then '6' -- Weapon
WHEN @ItemRefID = '47047' Then '7' -- Shield
WHEN @ItemRefID = '47050' Then '0' -- Hat
WHEN @ItemRefID = '47048' Then '1' -- Chest
WHEN @ItemRefID = '47051' Then '2' -- Shoulder
WHEN @ItemRefID = '47052' Then '3' -- Hand
WHEN @ItemRefID = '47049' Then '4' -- Legs
WHEN @ItemRefID = '47053' Then '5' -- Boots
WHEN @ItemRefID = '47054' Then '11'-- Ring_L
WHEN @ItemRefID = '47055' Then '12'-- Ring_R
WHEN @ItemRefID = '47056' Then '9' -- Earring
WHEN @ItemRefID = '47057' Then '10'-- Necklace
ELSE 0 END
DECLARE @ItemID_L Int = (SELECT ItemID FROM SRO_VT_SHARD.dbo._Inventory WITH(NOLOCK) where CharID = @CharID and Slot = @ItemSlot)
--
, @Paramnum int
, @Param1 bigint
, @Param2 bigint
, @Param3 bigint
, @Param4 bigint
, @Param5 bigint
, @Param6 bigint
, @Param7 bigint
, @Param8 bigint
, @Param9 bigint
SELECT @Paramnum = MagParamNum
,@Param1 = P1
,@Param2 = P2
,@Param3 = P3
,@Param4 = P4
,@Param5 = P5
,@Param6 = P6
,@Param7 = P7
,@Param8 = P8
,@Param9 = P9 FROM [_JayFB] WITH(NOLOCK) WHERE ID IN
(SELECT RefItemID FROM SRO_VT_SHARD.dbo._Items where ID64 =@ItemID_L)
DECLARE @AmountIM_1 bigint
,@AmountIM_2 bigint
,@AmountIM_3 bigint
,@AmountIM_4 bigint
,@AmountIM_5 bigint
,@AmountIM_6 bigint
,@AmountIM_7 bigint
,@AmountIM_8 bigint
,@AmountIM_9 bigint
SELECT @AmountIM_1 = MagParam1
,@AmountIM_2 = MagParam2
,@AmountIM_3 = MagParam3
,@AmountIM_4 = MagParam4
,@AmountIM_5 = MagParam5
,@AmountIM_6 = MagParam6
,@AmountIM_7 = MagParam7
,@AmountIM_8 = MagParam8
,@AmountIM_9 = MagParam9 FROM SRO_VT_SHARD.dbo._Items WITH(NOLOCK) where ID64 = @ItemID_L
IF @Operation = '16' and @ItemRefID BETWEEN '47046' AND '47057'
BEGIN
UPDATE SRO_VT_SHARD.dbo._Items
SET MagParamNum = @Paramnum
,MagParam1 = @Param1
,MagParam2 = @Param2
,MagParam3 = @Param3
,MagParam4 = @Param4
,MagParam5 = @Param5
,MagParam6 = @Param6
,MagParam7 = @Param7
,MagParam8 = @Param8
,MagParam9 = @Param9 Where ID64 = @ItemID_L
END
وتضيف دى فى AddLogItem_
كود PHP:
IF @Operation = 16 and @RefItemID between 47046 and 47057
BEGIN EXEC SRO_VT_SHARDLOG.dbo._JayFbScroll @CharID, @ItemRefID, @Operation END
دلوقتى نركز هنا شوية ..
دلوقتى هنفتح ال Table اللى لسه عاملنها دى وتشوف انت السيرفر بتاعك Degree كام فلنفترض انك Degree 10 فهتحط ال Lines دى فيها
كود PHP:
1 98 ITEM_CH_SWORD_10_A 3 1 6 2 90 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 99 ITEM_CH_SWORD_10_B 3 1 6 2 94 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 100 ITEM_CH_SWORD_10_C 3 1 6 2 98 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 134 ITEM_CH_BLADE_10_A 3 1 6 3 90 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 135 ITEM_CH_BLADE_10_B 3 1 6 3 94 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 136 ITEM_CH_BLADE_10_C 3 1 6 3 98 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 170 ITEM_CH_SPEAR_10_A 3 1 6 4 90 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 171 ITEM_CH_SPEAR_10_B 3 1 6 4 94 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 172 ITEM_CH_SPEAR_10_C 3 1 6 4 98 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 206 ITEM_CH_TBLADE_10_A 3 1 6 5 90 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 207 ITEM_CH_TBLADE_10_B 3 1 6 5 94 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 208 ITEM_CH_TBLADE_10_C 3 1 6 5 98 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 242 ITEM_CH_BOW_10_A 3 1 6 6 90 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 243 ITEM_CH_BOW_10_B 3 1 6 6 94 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 244 ITEM_CH_BOW_10_C 3 1 6 6 98 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 278 ITEM_CH_SHIELD_10_A 3 1 4 1 90 0 687194767449 429496729725 25769803853 25769803985 25769803847 25769803979 0 0 0 6 0 NULL
1 279 ITEM_CH_SHIELD_10_B 3 1 4 1 94 0 687194767449 429496729725 25769803853 25769803985 25769803847 25769803979 0 0 0 6 0 NULL
1 280 ITEM_CH_SHIELD_10_C 3 1 4 1 98 0 687194767449 429496729725 25769803853 25769803985 25769803847 25769803979 0 0 0 6 0 NULL
1 314 ITEM_CH_M_HEAVY_10_HA_A 3 1 3 1 91 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 315 ITEM_CH_M_HEAVY_10_HA_B 3 1 3 1 95 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 316 ITEM_CH_M_HEAVY_10_HA_C 3 1 3 1 99 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 350 ITEM_CH_M_HEAVY_10_CA_A 3 1 3 1 91 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 351 ITEM_CH_M_HEAVY_10_CA_B 3 1 3 1 95 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 352 ITEM_CH_M_HEAVY_10_CA_C 3 1 3 1 99 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 386 ITEM_CH_M_HEAVY_10_SA_A 3 1 3 2 90 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 387 ITEM_CH_M_HEAVY_10_SA_B 3 1 3 2 94 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 388 ITEM_CH_M_HEAVY_10_SA_C 3 1 3 2 98 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 422 ITEM_CH_M_HEAVY_10_BA_A 3 1 3 3 92 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 423 ITEM_CH_M_HEAVY_10_BA_B 3 1 3 3 96 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 424 ITEM_CH_M_HEAVY_10_BA_C 3 1 3 3 100 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 458 ITEM_CH_M_HEAVY_10_LA_A 3 1 3 4 92 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 459 ITEM_CH_M_HEAVY_10_LA_B 3 1 3 4 96 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 460 ITEM_CH_M_HEAVY_10_LA_C 3 1 3 4 100 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 494 ITEM_CH_M_HEAVY_10_AA_A 3 1 3 5 90 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 495 ITEM_CH_M_HEAVY_10_AA_B 3 1 3 5 94 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 496 ITEM_CH_M_HEAVY_10_AA_C 3 1 3 5 98 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 530 ITEM_CH_M_HEAVY_10_FA_A 3 1 3 6 91 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 531 ITEM_CH_M_HEAVY_10_FA_B 3 1 3 6 95 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 532 ITEM_CH_M_HEAVY_10_FA_C 3 1 3 6 99 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 566 ITEM_CH_M_LIGHT_10_HA_A 3 1 2 1 91 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 567 ITEM_CH_M_LIGHT_10_HA_B 3 1 2 1 95 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 568 ITEM_CH_M_LIGHT_10_HA_C 3 1 2 1 99 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 602 ITEM_CH_M_LIGHT_10_CA_A 3 1 2 1 91 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 603 ITEM_CH_M_LIGHT_10_CA_B 3 1 2 1 95 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 604 ITEM_CH_M_LIGHT_10_CA_C 3 1 2 1 99 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 638 ITEM_CH_M_LIGHT_10_SA_A 3 1 2 2 90 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 639 ITEM_CH_M_LIGHT_10_SA_B 3 1 2 2 94 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 640 ITEM_CH_M_LIGHT_10_SA_C 3 1 2 2 98 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 674 ITEM_CH_M_LIGHT_10_BA_A 3 1 2 3 92 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 675 ITEM_CH_M_LIGHT_10_BA_B 3 1 2 3 96 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 676 ITEM_CH_M_LIGHT_10_BA_C 3 1 2 3 100 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 710 ITEM_CH_M_LIGHT_10_LA_A 3 1 2 4 92 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 711 ITEM_CH_M_LIGHT_10_LA_B 3 1 2 4 96 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 712 ITEM_CH_M_LIGHT_10_LA_C 3 1 2 4 100 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 746 ITEM_CH_M_LIGHT_10_AA_A 3 1 2 5 90 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 747 ITEM_CH_M_LIGHT_10_AA_B 3 1 2 5 94 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 748 ITEM_CH_M_LIGHT_10_AA_C 3 1 2 5 98 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 782 ITEM_CH_M_LIGHT_10_FA_A 3 1 2 6 91 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 783 ITEM_CH_M_LIGHT_10_FA_B 3 1 2 6 95 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 784 ITEM_CH_M_LIGHT_10_FA_C 3 1 2 6 99 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 818 ITEM_CH_M_CLOTHES_10_HA_A 3 1 1 1 91 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 819 ITEM_CH_M_CLOTHES_10_HA_B 3 1 1 1 95 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 820 ITEM_CH_M_CLOTHES_10_HA_C 3 1 1 1 99 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 854 ITEM_CH_M_CLOTHES_10_CA_A 3 1 1 1 91 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 855 ITEM_CH_M_CLOTHES_10_CA_B 3 1 1 1 95 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 856 ITEM_CH_M_CLOTHES_10_CA_C 3 1 1 1 99 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 890 ITEM_CH_M_CLOTHES_10_SA_A 3 1 1 2 90 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 891 ITEM_CH_M_CLOTHES_10_SA_B 3 1 1 2 94 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 892 ITEM_CH_M_CLOTHES_10_SA_C 3 1 1 2 98 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 926 ITEM_CH_M_CLOTHES_10_BA_A 3 1 1 3 92 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 927 ITEM_CH_M_CLOTHES_10_BA_B 3 1 1 3 96 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 928 ITEM_CH_M_CLOTHES_10_BA_C 3 1 1 3 100 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 962 ITEM_CH_M_CLOTHES_10_LA_A 3 1 1 4 92 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 963 ITEM_CH_M_CLOTHES_10_LA_B 3 1 1 4 96 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 964 ITEM_CH_M_CLOTHES_10_LA_C 3 1 1 4 100 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 998 ITEM_CH_M_CLOTHES_10_AA_A 3 1 1 5 90 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 999 ITEM_CH_M_CLOTHES_10_AA_B 3 1 1 5 94 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1000 ITEM_CH_M_CLOTHES_10_AA_C 3 1 1 5 98 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1034 ITEM_CH_M_CLOTHES_10_FA_A 3 1 1 6 91 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1035 ITEM_CH_M_CLOTHES_10_FA_B 3 1 1 6 95 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1036 ITEM_CH_M_CLOTHES_10_FA_C 3 1 1 6 99 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1070 ITEM_CH_W_HEAVY_10_HA_A 3 1 3 1 91 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1071 ITEM_CH_W_HEAVY_10_HA_B 3 1 3 1 95 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1072 ITEM_CH_W_HEAVY_10_HA_C 3 1 3 1 99 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1106 ITEM_CH_W_HEAVY_10_CA_A 3 1 3 1 91 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1107 ITEM_CH_W_HEAVY_10_CA_B 3 1 3 1 95 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1108 ITEM_CH_W_HEAVY_10_CA_C 3 1 3 1 99 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1142 ITEM_CH_W_HEAVY_10_SA_A 3 1 3 2 90 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1143 ITEM_CH_W_HEAVY_10_SA_B 3 1 3 2 94 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1144 ITEM_CH_W_HEAVY_10_SA_C 3 1 3 2 98 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1178 ITEM_CH_W_HEAVY_10_BA_A 3 1 3 3 92 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1179 ITEM_CH_W_HEAVY_10_BA_B 3 1 3 3 96 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1180 ITEM_CH_W_HEAVY_10_BA_C 3 1 3 3 100 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1214 ITEM_CH_W_HEAVY_10_LA_A 3 1 3 4 92 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1215 ITEM_CH_W_HEAVY_10_LA_B 3 1 3 4 96 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1216 ITEM_CH_W_HEAVY_10_LA_C 3 1 3 4 100 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1250 ITEM_CH_W_HEAVY_10_AA_A 3 1 3 5 90 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1251 ITEM_CH_W_HEAVY_10_AA_B 3 1 3 5 94 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1252 ITEM_CH_W_HEAVY_10_AA_C 3 1 3 5 98 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1286 ITEM_CH_W_HEAVY_10_FA_A 3 1 3 6 91 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1287 ITEM_CH_W_HEAVY_10_FA_B 3 1 3 6 95 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1288 ITEM_CH_W_HEAVY_10_FA_C 3 1 3 6 99 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1322 ITEM_CH_W_LIGHT_10_HA_A 3 1 2 1 91 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1323 ITEM_CH_W_LIGHT_10_HA_B 3 1 2 1 95 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1324 ITEM_CH_W_LIGHT_10_HA_C 3 1 2 1 99 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1358 ITEM_CH_W_LIGHT_10_CA_A 3 1 2 1 91 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1359 ITEM_CH_W_LIGHT_10_CA_B 3 1 2 1 95 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1360 ITEM_CH_W_LIGHT_10_CA_C 3 1 2 1 99 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1394 ITEM_CH_W_LIGHT_10_SA_A 3 1 2 2 90 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1395 ITEM_CH_W_LIGHT_10_SA_B 3 1 2 2 94 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1396 ITEM_CH_W_LIGHT_10_SA_C 3 1 2 2 98 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1430 ITEM_CH_W_LIGHT_10_BA_A 3 1 2 3 92 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1431 ITEM_CH_W_LIGHT_10_BA_B 3 1 2 3 96 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1432 ITEM_CH_W_LIGHT_10_BA_C 3 1 2 3 100 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1466 ITEM_CH_W_LIGHT_10_LA_A 3 1 2 4 92 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1467 ITEM_CH_W_LIGHT_10_LA_B 3 1 2 4 96 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1468 ITEM_CH_W_LIGHT_10_LA_C 3 1 2 4 100 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1502 ITEM_CH_W_LIGHT_10_AA_A 3 1 2 5 90 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1503 ITEM_CH_W_LIGHT_10_AA_B 3 1 2 5 94 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1504 ITEM_CH_W_LIGHT_10_AA_C 3 1 2 5 98 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1538 ITEM_CH_W_LIGHT_10_FA_A 3 1 2 6 91 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1539 ITEM_CH_W_LIGHT_10_FA_B 3 1 2 6 95 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1540 ITEM_CH_W_LIGHT_10_FA_C 3 1 2 6 99 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1574 ITEM_CH_W_CLOTHES_10_HA_A 3 1 1 1 91 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1575 ITEM_CH_W_CLOTHES_10_HA_B 3 1 1 1 95 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1576 ITEM_CH_W_CLOTHES_10_HA_C 3 1 1 1 99 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1610 ITEM_CH_W_CLOTHES_10_CA_A 3 1 1 1 91 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1611 ITEM_CH_W_CLOTHES_10_CA_B 3 1 1 1 95 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1612 ITEM_CH_W_CLOTHES_10_CA_C 3 1 1 1 99 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1646 ITEM_CH_W_CLOTHES_10_SA_A 3 1 1 2 90 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1647 ITEM_CH_W_CLOTHES_10_SA_B 3 1 1 2 94 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1648 ITEM_CH_W_CLOTHES_10_SA_C 3 1 1 2 98 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1682 ITEM_CH_W_CLOTHES_10_BA_A 3 1 1 3 92 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1683 ITEM_CH_W_CLOTHES_10_BA_B 3 1 1 3 96 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1684 ITEM_CH_W_CLOTHES_10_BA_C 3 1 1 3 100 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1718 ITEM_CH_W_CLOTHES_10_LA_A 3 1 1 4 92 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1719 ITEM_CH_W_CLOTHES_10_LA_B 3 1 1 4 96 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1720 ITEM_CH_W_CLOTHES_10_LA_C 3 1 1 4 100 2 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 NULL
1 1754 ITEM_CH_W_CLOTHES_10_AA_A 3 1 1 5 90 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1755 ITEM_CH_W_CLOTHES_10_AA_B 3 1 1 5 94 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1756 ITEM_CH_W_CLOTHES_10_AA_C 3 1 1 5 98 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1790 ITEM_CH_W_CLOTHES_10_FA_A 3 1 1 6 91 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1791 ITEM_CH_W_CLOTHES_10_FA_B 3 1 1 6 95 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1792 ITEM_CH_W_CLOTHES_10_FA_C 3 1 1 6 99 2 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 NULL
1 1826 ITEM_CH_RING_10_A 3 1 5 3 90 0 25769803853 25769803847 85899346099 85899346093 85899346087 85899346105 85899346111 0 0 7 0 NULL
1 1827 ITEM_CH_RING_10_B 3 1 5 3 94 0 25769803853 25769803847 85899346099 85899346093 85899346087 85899346105 85899346111 0 0 7 0 NULL
1 1828 ITEM_CH_RING_10_C 3 1 5 3 98 0 25769803853 25769803847 85899346099 85899346093 85899346087 85899346105 85899346111 0 0 7 0 NULL
1 1862 ITEM_CH_EARRING_10_A 3 1 5 1 91 0 25769803853 25769803847 85899346099 85899346093 85899346087 85899346105 85899346111 0 0 7 0 NULL
1 1863 ITEM_CH_EARRING_10_B 3 1 5 1 95 0 25769803853 25769803847 85899346099 85899346093 85899346087 85899346105 85899346111 0 0 7 0 NULL
1 1864 ITEM_CH_EARRING_10_C 3 1 5 1 99 0 25769803853 25769803847 85899346099 85899346093 85899346087 85899346105 85899346111 0 0 7 0 NULL
1 1898 ITEM_CH_NECKLACE_10_A 3 1 5 2 92 0 25769803853 25769803847 85899346099 85899346093 85899346087 85899346105 85899346111 0 0 7 0 NULL
1 1899 ITEM_CH_NECKLACE_10_B 3 1 5 2 96 0 25769803853 25769803847 85899346099 85899346093 85899346087 85899346105 85899346111 0 0 7 0 NULL
1 1900 ITEM_CH_NECKLACE_10_C 3 1 5 2 100 0 25769803853 25769803847 85899346099 85899346093 85899346087 85899346105 85899346111 0 0 7 0 NULL
1 4041 ITEM_CH_SWORD_10_A_RARE 3 1 6 2 90 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 4042 ITEM_CH_SWORD_10_B_RARE 3 1 6 2 90 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 4043 ITEM_CH_SWORD_10_C_RARE 3 1 6 2 90 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 4077 ITEM_CH_BLADE_10_A_RARE 3 1 6 3 90 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 4078 ITEM_CH_BLADE_10_B_RARE 3 1 6 3 90 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 4079 ITEM_CH_BLADE_10_C_RARE 3 1 6 3 90 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 4113 ITEM_CH_SPEAR_10_A_RARE 3 1 6 4 90 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 4114 ITEM_CH_SPEAR_10_B_RARE 3 1 6 4 90 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 4115 ITEM_CH_SPEAR_10_C_RARE 3 1 6 4 90 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 4149 ITEM_CH_TBLADE_10_A_RARE 3 1 6 5 90 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 4150 ITEM_CH_TBLADE_10_B_RARE 3 1 6 5 90 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 4151 ITEM_CH_TBLADE_10_C_RARE 3 1 6 5 90 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 4185 ITEM_CH_BOW_10_A_RARE 3 1 6 6 90 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 4186 ITEM_CH_BOW_10_B_RARE 3 1 6 6 90 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 4187 ITEM_CH_BOW_10_C_RARE 3 1 6 6 90 0 687194767449 257698037861 429496729713 25769803853 25769803847 25769803985 25769803979 0 0 7 0 NULL
1 4221 ITEM_CH_SHIELD_10_A_RARE 3 1 4 1 90 0 687194767449 429496729725 25769803853 25769803985 25769803847 25769803979 0 0 0 6 0 NULL
1 4222 ITEM_CH_SHIELD_10_B_RARE 3 1 4 1 90 0 687194767449 429496729725 25769803853 25769803985 25769803847 25769803979 0 0 0 6 0 NULL
1 4223 ITEM_CH_SHIELD_10_C_RARE 3 1 4 1 90 0 687194767449 429496729725 25769803853 25769803985 25769803847 25769803979 0 0 0 6 0 NULL
1 4257 ITEM_CH_M_HEAVY_10_HA_A_RARE 3 1 3 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4258 ITEM_CH_M_HEAVY_10_HA_B_RARE 3 1 3 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4259 ITEM_CH_M_HEAVY_10_HA_C_RARE 3 1 3 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4293 ITEM_CH_M_HEAVY_10_CA_A_RARE 3 1 3 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4294 ITEM_CH_M_HEAVY_10_CA_B_RARE 3 1 3 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4295 ITEM_CH_M_HEAVY_10_CA_C_RARE 3 1 3 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4329 ITEM_CH_M_HEAVY_10_SA_A_RARE 3 1 3 2 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 4330 ITEM_CH_M_HEAVY_10_SA_B_RARE 3 1 3 2 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 4331 ITEM_CH_M_HEAVY_10_SA_C_RARE 3 1 3 2 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 4365 ITEM_CH_M_HEAVY_10_BA_A_RARE 3 1 3 3 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4366 ITEM_CH_M_HEAVY_10_BA_B_RARE 3 1 3 3 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4367 ITEM_CH_M_HEAVY_10_BA_C_RARE 3 1 3 3 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4401 ITEM_CH_M_HEAVY_10_LA_A_RARE 3 1 3 4 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4402 ITEM_CH_M_HEAVY_10_LA_B_RARE 3 1 3 4 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4403 ITEM_CH_M_HEAVY_10_LA_C_RARE 3 1 3 4 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4437 ITEM_CH_M_HEAVY_10_AA_A_RARE 3 1 3 5 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 4438 ITEM_CH_M_HEAVY_10_AA_B_RARE 3 1 3 5 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 4439 ITEM_CH_M_HEAVY_10_AA_C_RARE 3 1 3 5 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 4473 ITEM_CH_M_HEAVY_10_FA_A_RARE 3 1 3 6 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 4474 ITEM_CH_M_HEAVY_10_FA_B_RARE 3 1 3 6 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 4475 ITEM_CH_M_HEAVY_10_FA_C_RARE 3 1 3 6 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 4509 ITEM_CH_M_LIGHT_10_HA_A_RARE 3 1 2 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4510 ITEM_CH_M_LIGHT_10_HA_B_RARE 3 1 2 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4511 ITEM_CH_M_LIGHT_10_HA_C_RARE 3 1 2 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4545 ITEM_CH_M_LIGHT_10_CA_A_RARE 3 1 2 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4546 ITEM_CH_M_LIGHT_10_CA_B_RARE 3 1 2 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4547 ITEM_CH_M_LIGHT_10_CA_C_RARE 3 1 2 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4581 ITEM_CH_M_LIGHT_10_SA_A_RARE 3 1 2 2 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 4582 ITEM_CH_M_LIGHT_10_SA_B_RARE 3 1 2 2 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 4583 ITEM_CH_M_LIGHT_10_SA_C_RARE 3 1 2 2 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 4617 ITEM_CH_M_LIGHT_10_BA_A_RARE 3 1 2 3 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4618 ITEM_CH_M_LIGHT_10_BA_B_RARE 3 1 2 3 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4619 ITEM_CH_M_LIGHT_10_BA_C_RARE 3 1 2 3 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4653 ITEM_CH_M_LIGHT_10_LA_A_RARE 3 1 2 4 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4654 ITEM_CH_M_LIGHT_10_LA_B_RARE 3 1 2 4 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4655 ITEM_CH_M_LIGHT_10_LA_C_RARE 3 1 2 4 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4689 ITEM_CH_M_LIGHT_10_AA_A_RARE 3 1 2 5 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 4690 ITEM_CH_M_LIGHT_10_AA_B_RARE 3 1 2 5 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 4691 ITEM_CH_M_LIGHT_10_AA_C_RARE 3 1 2 5 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 4725 ITEM_CH_M_LIGHT_10_FA_A_RARE 3 1 2 6 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 4726 ITEM_CH_M_LIGHT_10_FA_B_RARE 3 1 2 6 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 4727 ITEM_CH_M_LIGHT_10_FA_C_RARE 3 1 2 6 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 4761 ITEM_CH_M_CLOTHES_10_HA_A_RARE 3 1 1 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4762 ITEM_CH_M_CLOTHES_10_HA_B_RARE 3 1 1 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4763 ITEM_CH_M_CLOTHES_10_HA_C_RARE 3 1 1 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4797 ITEM_CH_M_CLOTHES_10_CA_A_RARE 3 1 1 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4798 ITEM_CH_M_CLOTHES_10_CA_B_RARE 3 1 1 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4799 ITEM_CH_M_CLOTHES_10_CA_C_RARE 3 1 1 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4833 ITEM_CH_M_CLOTHES_10_SA_A_RARE 3 1 1 2 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 4834 ITEM_CH_M_CLOTHES_10_SA_B_RARE 3 1 1 2 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 4835 ITEM_CH_M_CLOTHES_10_SA_C_RARE 3 1 1 2 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 4869 ITEM_CH_M_CLOTHES_10_BA_A_RARE 3 1 1 3 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4870 ITEM_CH_M_CLOTHES_10_BA_B_RARE 3 1 1 3 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4871 ITEM_CH_M_CLOTHES_10_BA_C_RARE 3 1 1 3 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4905 ITEM_CH_M_CLOTHES_10_LA_A_RARE 3 1 1 4 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4906 ITEM_CH_M_CLOTHES_10_LA_B_RARE 3 1 1 4 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4907 ITEM_CH_M_CLOTHES_10_LA_C_RARE 3 1 1 4 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 4941 ITEM_CH_M_CLOTHES_10_AA_A_RARE 3 1 1 5 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 4942 ITEM_CH_M_CLOTHES_10_AA_B_RARE 3 1 1 5 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 4943 ITEM_CH_M_CLOTHES_10_AA_C_RARE 3 1 1 5 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 4977 ITEM_CH_M_CLOTHES_10_FA_A_RARE 3 1 1 6 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 4978 ITEM_CH_M_CLOTHES_10_FA_B_RARE 3 1 1 6 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 4979 ITEM_CH_M_CLOTHES_10_FA_C_RARE 3 1 1 6 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5013 ITEM_CH_W_HEAVY_10_HA_A_RARE 3 1 3 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5014 ITEM_CH_W_HEAVY_10_HA_B_RARE 3 1 3 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5015 ITEM_CH_W_HEAVY_10_HA_C_RARE 3 1 3 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5049 ITEM_CH_W_HEAVY_10_CA_A_RARE 3 1 3 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5050 ITEM_CH_W_HEAVY_10_CA_B_RARE 3 1 3 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5051 ITEM_CH_W_HEAVY_10_CA_C_RARE 3 1 3 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5085 ITEM_CH_W_HEAVY_10_SA_A_RARE 3 1 3 2 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5086 ITEM_CH_W_HEAVY_10_SA_B_RARE 3 1 3 2 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5087 ITEM_CH_W_HEAVY_10_SA_C_RARE 3 1 3 2 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5121 ITEM_CH_W_HEAVY_10_BA_A_RARE 3 1 3 3 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5122 ITEM_CH_W_HEAVY_10_BA_B_RARE 3 1 3 3 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5123 ITEM_CH_W_HEAVY_10_BA_C_RARE 3 1 3 3 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5157 ITEM_CH_W_HEAVY_10_LA_A_RARE 3 1 3 4 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5158 ITEM_CH_W_HEAVY_10_LA_B_RARE 3 1 3 4 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5159 ITEM_CH_W_HEAVY_10_LA_C_RARE 3 1 3 4 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5193 ITEM_CH_W_HEAVY_10_AA_A_RARE 3 1 3 5 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5194 ITEM_CH_W_HEAVY_10_AA_B_RARE 3 1 3 5 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5195 ITEM_CH_W_HEAVY_10_AA_C_RARE 3 1 3 5 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5229 ITEM_CH_W_HEAVY_10_FA_A_RARE 3 1 3 6 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5230 ITEM_CH_W_HEAVY_10_FA_B_RARE 3 1 3 6 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5231 ITEM_CH_W_HEAVY_10_FA_C_RARE 3 1 3 6 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5265 ITEM_CH_W_LIGHT_10_HA_A_RARE 3 1 2 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5266 ITEM_CH_W_LIGHT_10_HA_B_RARE 3 1 2 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5267 ITEM_CH_W_LIGHT_10_HA_C_RARE 3 1 2 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5301 ITEM_CH_W_LIGHT_10_CA_A_RARE 3 1 2 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5302 ITEM_CH_W_LIGHT_10_CA_B_RARE 3 1 2 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5303 ITEM_CH_W_LIGHT_10_CA_C_RARE 3 1 2 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5337 ITEM_CH_W_LIGHT_10_SA_A_RARE 3 1 2 2 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5338 ITEM_CH_W_LIGHT_10_SA_B_RARE 3 1 2 2 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5339 ITEM_CH_W_LIGHT_10_SA_C_RARE 3 1 2 2 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5373 ITEM_CH_W_LIGHT_10_BA_A_RARE 3 1 2 3 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5374 ITEM_CH_W_LIGHT_10_BA_B_RARE 3 1 2 3 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5375 ITEM_CH_W_LIGHT_10_BA_C_RARE 3 1 2 3 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5409 ITEM_CH_W_LIGHT_10_LA_A_RARE 3 1 2 4 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5410 ITEM_CH_W_LIGHT_10_LA_B_RARE 3 1 2 4 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5411 ITEM_CH_W_LIGHT_10_LA_C_RARE 3 1 2 4 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5445 ITEM_CH_W_LIGHT_10_AA_A_RARE 3 1 2 5 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5446 ITEM_CH_W_LIGHT_10_AA_B_RARE 3 1 2 5 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5447 ITEM_CH_W_LIGHT_10_AA_C_RARE 3 1 2 5 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5481 ITEM_CH_W_LIGHT_10_FA_A_RARE 3 1 2 6 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5482 ITEM_CH_W_LIGHT_10_FA_B_RARE 3 1 2 6 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5483 ITEM_CH_W_LIGHT_10_FA_C_RARE 3 1 2 6 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5517 ITEM_CH_W_CLOTHES_10_HA_A_RARE 3 1 1 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5518 ITEM_CH_W_CLOTHES_10_HA_B_RARE 3 1 1 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5519 ITEM_CH_W_CLOTHES_10_HA_C_RARE 3 1 1 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5553 ITEM_CH_W_CLOTHES_10_CA_A_RARE 3 1 1 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5554 ITEM_CH_W_CLOTHES_10_CA_B_RARE 3 1 1 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5555 ITEM_CH_W_CLOTHES_10_CA_C_RARE 3 1 1 1 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5589 ITEM_CH_W_CLOTHES_10_SA_A_RARE 3 1 1 2 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5590 ITEM_CH_W_CLOTHES_10_SA_B_RARE 3 1 1 2 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5591 ITEM_CH_W_CLOTHES_10_SA_C_RARE 3 1 1 2 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5625 ITEM_CH_W_CLOTHES_10_BA_A_RARE 3 1 1 3 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5626 ITEM_CH_W_CLOTHES_10_BA_B_RARE 3 1 1 3 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5627 ITEM_CH_W_CLOTHES_10_BA_C_RARE 3 1 1 3 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5661 ITEM_CH_W_CLOTHES_10_LA_A_RARE 3 1 1 4 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5662 ITEM_CH_W_CLOTHES_10_LA_B_RARE 3 1 1 4 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5663 ITEM_CH_W_CLOTHES_10_LA_C_RARE 3 1 1 4 0 1 687194767449 257698037897 3650722201749 25769803853 25769803985 3650722201761 25769803847 25769803979 0 8 0 0
1 5697 ITEM_CH_W_CLOTHES_10_AA_A_RARE 3 1 1 5 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5698 ITEM_CH_W_CLOTHES_10_AA_B_RARE 3 1 1 5 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5699 ITEM_CH_W_CLOTHES_10_AA_C_RARE 3 1 1 5 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5733 ITEM_CH_W_CLOTHES_10_FA_A_RARE 3 1 1 6 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5734 ITEM_CH_W_CLOTHES_10_FA_B_RARE 3 1 1 6 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5735 ITEM_CH_W_CLOTHES_10_FA_C_RARE 3 1 1 6 0 1 687194767449 257698037897 25769803853 25769803985 25769803979 25769803847 0 0 0 6 0 0
1 5769 ITEM_CH_RING_10_A_RARE 3 1 5 3 90 0 25769803853 25769803847 85899346099 85899346093 85899346087 85899346105 85899346111 0 0 7 0 NULL
1 5770 ITEM_CH_RING_10_B_RARE 3 1 5 3 90 0 25769803853 25769803847 85899346099 85899346093 85899346087 85899346105 85899346111 0 0 7 0 NULL
1 5771 ITEM_CH_RING_10_C_RARE 3 1 5 3 90 0 25769803853 25769803847 85899346099 85899346093 85899346087 85899346105 85899346111 0 0 7 0 NULL
1 5805 ITEM_CH_EARRING_10_A_RARE 3 1 5 1 91 0 25769803853 25769803847 85899346099 85899346093 85899346087 85899346105 85899346111 0 0 7 0 NULL
1 5806 ITEM_CH_EARRING_10_B_RARE 3 1 5 1 91 0 25769803853 25769803847 85899346099 85899346093 85899346087 85899346105 85899346111 0 0 7 0 NULL
1 5807 ITEM_CH_EARRING_10_C_RARE 3 1 5 1 91 0 25769803853 25769803847 85899346099 85899346093 85899346087 85899346105 85899346111 0 0 7 0 NULL
1 5841 ITEM_CH_NECKLACE_10_A_RARE 3 1 5 2 92 0 25769803853 25769803847 85899346099 85899346093 85899346087 85899346105 85899346111 0 0 7 0 NULL
1 5842 ITEM_CH_NECKLACE_10_B_RARE 3 1 5 2 92 0 25769803853 25769803847 85899346099 85899346093 85899346087 85899346105 85899346111 0 0 7 0 NULL
1 5843 ITEM_CH_NECKLACE_10_C_RARE 3 1 5 2 92 0 25769803853 25769803847 85899346099 85899346093 85899346087 85899346105 85899346111 0 0 7 0 NULL
طيب واحد هييجى يقولى انا Degree تانى وبتاع عادى استخدم نفس ال Lines بس غير ال _10_ لرقم الديجرى بتاعك .. ايه !! وانا هعد اعمل كل السطور دى ؟! .. لا يا عم اتفضل ال Query دى هتخلص الدنيا
كل اللى عليك تكتب رقم الديجرى بتاعك بس
كود PHP:
USE SRO_VT_SHARDLOG
DECLARE @DEG varchar(max) ='WRITE YOUR DEGREE NUMBER HERE'
--------------------------------------------------------
Update _JayFB SET Codename128 = REPLACE (Codename128,'_10_','_'+@DEG+'_')
خلاص كده ؟
.. انت مستعجل ليه يا عم ^^ فاضل حاجة واحده كمان
ال ID بتاع كل Item لازم يكون زى ال ID اللى فى RefObjCommon_ وكمان ال Level بتاعهم
ماحنا بقينا فى ديجرى تانى بقى صحصح معايا كده
إيه !! طب وبعدين انا همسك سطر سطر ولا ايه ده عبورنا اسهل من كده !!
لا يا عم انا ساعدتك وكتبتلك Query لذيذة كده اعملها Execute مش اكتر وهى هتقوم بالواجب
كود PHP:
USE SRO_VT_SHARDLOG
DECLARE @Codename varchar(max),
@ReqLevel1 int,
@rows int = 0 ,
@ID int
DECLARE @RowsCount int = (SELECT COUNT(Codename128) From _JayFB)
while (@rows < @RowsCount)
begin
set @Codename = (select Codename128 from _JayFB where [identity] = @rows)
set @ReqLevel1 = (select ReqLevel1 from SRO_VT_SHARD.._refobjcommon where CodeName128 = @codename)
set @ID = (select ID from SRO_VT_SHARD.._refobjcommon where CodeName128 = @codename)
update _JayFB set ReqLevel1 = @ReqLevel1 , id = @ID where Codename128 = @codename
set @rows+=1
end
ملحوظة : ال Lines دى CH بس
كده احنا ظبطنا الدنيا عشان ال Scrolls .. هى فين بقى ال Scrolls ^^
اهى يا عمنا
RefObjCommon_
كود PHP:
1 47046 ITEM_ETC_JAY_FB_WEAPON ????? xxx SN_ITEM_ETC_JAY_FB_WEAPON SN_ITEM_ETC_JAY_FB_WEAPON_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 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 item\etc\fb_remover.ddj xxx xxx 113985
1 47047 ITEM_ETC_JAY_FB_SHIELD ????? xxx SN_IITEM_ETC_JAY_FB_SHIELD SN_IITEM_ETC_JAY_FB_SHIELD_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 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 item\etc\fb_remover.ddj xxx xxx 113986
1 47050 ITEM_ETC_JAY_FB_HAT ????? xxx SN_ITEM_ETC_JAY_FB_HAT SN_ITEM_ETC_JAY_FB_HAT_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 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 item\etc\fb_remover.ddj xxx xxx 113987
1 47048 ITEM_ETC_JAY_FB_CHEST ????? xxx SN_ITEM_ETC_JAY_FB_CHEST SN_ITEM_ETC_JAY_FB_CHEST_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 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 item\etc\fb_remover.ddj xxx xxx 113988
1 47051 ITEM_ETC_JAY_FB_SHOULDER ????? xxx SN_ITEM_ETC_JAY_FB_SHOULDER SN_ITEM_ETC_JAY_FB_SHOULDER_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 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 item\etc\fb_remover.ddj xxx xxx 113989
1 47052 ITEM_ETC_JAY_FB_HAND ????? xxx SN_ITEM_ETC_JAY_FB_HAND SN_ITEM_ETC_JAY_FB_HAND_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 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 item\etc\fb_remover.ddj xxx xxx 113990
1 47049 ITEM_ETC_JAY_FB_LEGS ????? xxx SN_ITEM_ETC_JAY_FB_LEGS SN_ITEM_ETC_JAY_FB_LEGS_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 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 item\etc\fb_remover.ddj xxx xxx 113991
1 47053 ITEM_ETC_JAY_FB_BOOTS ????? xxx SN_ITEM_ETC_JAY_FB_BOOTS SN_ITEM_ETC_JAY_FB_BOOTS_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 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 item\etc\fb_remover.ddj xxx xxx 113992
1 47054 ITEM_ETC_JAY_FB_RING_L ????? xxx SN_ITEM_ETC_JAY_FB_RING_L SN_ITEM_ETC_JAY_FB_RING_L_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 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 item\etc\fb_remover.ddj xxx xxx 113993
1 47055 ITEM_ETC_JAY_FB_RING_R ????? xxx SN_ITEM_ETC_JAY_FB_RING_R SN_ITEM_ETC_JAY_FB_RING_R_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 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 item\etc\fb_remover.ddj xxx xxx 113994
1 47056 ITEM_ETC_JAY_FB_EARRING ????? xxx SN_ITEM_ETC_JAY_FB_EARRING SN_ITEM_ETC_JAY_FB_EARRING_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 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 item\etc\fb_remover.ddj xxx xxx 113995
1 47057 ITEM_ETC_JAY_FB_NECKLACE ????? xxx SN_ITEM_ETC_JAY_FB_NECKLACE SN_SN_ITEM_ETC_JAY_FB_NECKLACE_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 255 0 1 0 0 1 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 item\etc\fb_remover.ddj xxx xxx 113996
RefObjItem_
كود PHP:
113985 1 2 0 0 1 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 1 ???? 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
113986 1 2 0 0 1 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 1 ???? 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
113987 1 2 0 0 1 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 1 ???? 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
113988 1 2 0 0 1 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 1 ???? 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
113989 1 2 0 0 1 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 1 ???? 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
113990 1 2 0 0 1 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 1 ???? 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
113991 1 2 0 0 1 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 1 ???? 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
113992 1 2 0 0 1 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 1 ???? 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
113993 1 2 0 0 1 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 1 ???? 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
113994 1 2 0 0 1 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 1 ???? 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
113995 1 2 0 0 1 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 1 ???? 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
113996 1 2 0 0 1 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 1 ???? 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
بعد كده اعمل Execute لى دى
كود PHP:
USE [SRO_VT_SHARD]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE procedure [dbo].[_GetMediaLines]
@Type SMALLINT,
@CodeName VARCHAR(30)
AS
IF(@Type=1)
BEGIN
SELECT
_RefObjCommon.Service,_RefObjCommon.ID,_RefObjCommon.CodeName128,_RefObjCommon.ObjName128,_RefObjCommon.OrgObjCodeName128,_RefObjCommon.NameStrID128,_RefObjCommon.DescStrID128,_RefObjCommon.CashItem,_RefObjCommon.Bionic,_RefObjCommon.TypeID1,_RefObjCommon.TypeID2,_RefObjCommon.TypeID3,_RefObjCommon.TypeID4,_RefObjCommon.DecayTime,_RefObjCommon.Country,_RefObjCommon.Rarity,_RefObjCommon.CanTrade,_RefObjCommon.CanSell,_RefObjCommon.CanBuy,_RefObjCommon.CanBorrow,_RefObjCommon.CanDrop,_RefObjCommon.CanPick,_RefObjCommon.CanRepair,_RefObjCommon.CanRevive,_RefObjCommon.CanUse,_RefObjCommon.CanThrow,_RefObjCommon.Price,_RefObjCommon.CostRepair,_RefObjCommon.CostRevive,_RefObjCommon.CostBorrow,_RefObjCommon.KeepingFee,_RefObjCommon.SellPrice,_RefObjCommon.ReqLevelType1,_RefObjCommon.ReqLevel1,_RefObjCommon.ReqLevelType2,_RefObjCommon.ReqLevel2,_RefObjCommon.ReqLevelType3,_RefObjCommon.ReqLevel3,_RefObjCommon.ReqLevelType4,_RefObjCommon.ReqLevel4,_RefObjCommon.MaxContain,_RefObjCommon.RegionID,_RefObjCommon.Dir,_RefObjCommon.OffsetX,_RefObjCommon.OffsetY,_RefObjCommon.OffsetZ,_RefObjCommon.Speed1,_RefObjCommon.Speed2,_RefObjCommon.Scale,_RefObjCommon.BCHeight,_RefObjCommon.BCRadius,_RefObjCommon.EventID,_RefObjCommon.AssocFileObj128,_RefObjCommon.AssocFileDrop128,_RefObjCommon.AssocFileIcon128,_RefObjCommon.AssocFile1_128,_RefObjCommon.AssocFile2_128,
_RefObjItem.MaxStack,_RefObjItem.ReqGender,_RefObjItem.ReqStr,_RefObjItem.ReqInt,_RefObjItem.ItemClass,_RefObjItem.SetID,_RefObjItem.Dur_L,_RefObjItem.Dur_U,_RefObjItem.PD_L,_RefObjItem.PD_U,_RefObjItem.PDInc,_RefObjItem.ER_L,_RefObjItem.ER_U,_RefObjItem.ERInc,_RefObjItem.PAR_L,_RefObjItem.PAR_U,_RefObjItem.PARInc,_RefObjItem.BR_L,_RefObjItem.BR_U,_RefObjItem.MD_L,_RefObjItem.MD_U,_RefObjItem.MDInc,_RefObjItem.MAR_L,_RefObjItem.MAR_U,_RefObjItem.MARInc,_RefObjItem.PDStr_L,_RefObjItem.PDStr_U,_RefObjItem.MDInt_L,_RefObjItem.MDInt_U,_RefObjItem.Quivered,_RefObjItem.Ammo1_TID4,_RefObjItem.Ammo2_TID4,_RefObjItem.Ammo3_TID4,_RefObjItem.Ammo4_TID4,_RefObjItem.Ammo5_TID4,_RefObjItem.SpeedClass,_RefObjItem.TwoHanded,_RefObjItem.Range,_RefObjItem.PAttackMin_L,_RefObjItem.PAttackMin_U,_RefObjItem.PAttackMax_L,_RefObjItem.PAttackMax_U,_RefObjItem.PAttackInc,_RefObjItem.MAttackMin_L,_RefObjItem.MAttackMin_U,_RefObjItem.MAttackMax_L,_RefObjItem.MAttackMax_U,_RefObjItem.MAttackInc,_RefObjItem.PAStrMin_L,_RefObjItem.PAStrMin_U,_RefObjItem.PAStrMax_L,_RefObjItem.PAStrMax_U,_RefObjItem.MAInt_Min_L,_RefObjItem.MAInt_Min_U,_RefObjItem.MAInt_Max_L,_RefObjItem.MAInt_Max_U,_RefObjItem.HR_L,_RefObjItem.HR_U,_RefObjItem.HRInc,_RefObjItem.CHR_L,_RefObjItem.CHR_U,_RefObjItem.Param1,_RefObjItem.Desc1_128,_RefObjItem.Param2,_RefObjItem.Desc2_128,_RefObjItem.Param3,_RefObjItem.Desc3_128,_RefObjItem.Param4,_RefObjItem.Desc4_128,_RefObjItem.Param5,_RefObjItem.Desc5_128,_RefObjItem.Param6,_RefObjItem.Desc6_128,_RefObjItem.Param7,_RefObjItem.Desc7_128,_RefObjItem.Param8,_RefObjItem.Desc8_128,_RefObjItem.Param9,_RefObjItem.Desc9_128,_RefObjItem.Param10,_RefObjItem.Desc10_128,_RefObjItem.Param11,_RefObjItem.Desc11_128,_RefObjItem.Param12,_RefObjItem.Desc12_128,_RefObjItem.Param13,_RefObjItem.Desc13_128,_RefObjItem.Param14,_RefObjItem.Desc14_128,_RefObjItem.Param15,_RefObjItem.Desc15_128,_RefObjItem.Param16,_RefObjItem.Desc16_128,_RefObjItem.Param17,_RefObjItem.Desc17_128,_RefObjItem.Param18,_RefObjItem.Desc18_128,_RefObjItem.Param19,_RefObjItem.Desc19_128,_RefObjItem.Param20,_RefObjItem.Desc20_128,_RefObjItem.MaxMagicOptCount,_RefObjItem.ChildItemCount
FROM _RefObjCommon INNER JOIN _RefObjItem ON _RefObjCommon.Link=_RefObjItem.ID
WHERE _RefObjCommon.CodeName128 LIKE @CodeName AND _RefObjCommon.Service=1 ORDER BY _RefObjCommon.ID ASC
END
IF(@Type=2)
BEGIN
SELECT
_RefObjCommon.Service,_RefObjCommon.ID,_RefObjCommon.CodeName128,_RefObjCommon.ObjName128,_RefObjCommon.OrgObjCodeName128,_RefObjCommon.NameStrID128,_RefObjCommon.DescStrID128,_RefObjCommon.CashItem,_RefObjCommon.Bionic,_RefObjCommon.TypeID1,_RefObjCommon.TypeID2,_RefObjCommon.TypeID3,_RefObjCommon.TypeID4,_RefObjCommon.DecayTime,_RefObjCommon.Country,_RefObjCommon.Rarity,_RefObjCommon.CanTrade,_RefObjCommon.CanSell,_RefObjCommon.CanBuy,_RefObjCommon.CanBorrow,_RefObjCommon.CanDrop,_RefObjCommon.CanPick,_RefObjCommon.CanRepair,_RefObjCommon.CanRevive,_RefObjCommon.CanUse,_RefObjCommon.CanThrow,_RefObjCommon.Price,_RefObjCommon.CostRepair,_RefObjCommon.CostRevive,_RefObjCommon.CostBorrow,_RefObjCommon.KeepingFee,_RefObjCommon.SellPrice,_RefObjCommon.ReqLevelType1,_RefObjCommon.ReqLevel1,_RefObjCommon.ReqLevelType2,_RefObjCommon.ReqLevel2,_RefObjCommon.ReqLevelType3,_RefObjCommon.ReqLevel3,_RefObjCommon.ReqLevelType4,_RefObjCommon.ReqLevel4,_RefObjCommon.MaxContain,_RefObjCommon.RegionID,_RefObjCommon.Dir,_RefObjCommon.OffsetX,_RefObjCommon.OffsetY,_RefObjCommon.OffsetZ,_RefObjCommon.Speed1,_RefObjCommon.Speed2,_RefObjCommon.Scale,_RefObjCommon.BCHeight,_RefObjCommon.BCRadius,_RefObjCommon.EventID,_RefObjCommon.AssocFileObj128,_RefObjCommon.AssocFileDrop128,_RefObjCommon.AssocFileIcon128,_RefObjCommon.AssocFile1_128,_RefObjCommon.AssocFile2_128,
_RefObjChar.Lvl,_RefObjChar.CharGender,_RefObjChar.MaxHP,_RefObjChar.MaxMP,_RefObjChar.InventorySize,_RefObjChar.CanStore_TID1,_RefObjChar.CanStore_TID2,_RefObjChar.CanStore_TID3,_RefObjChar.CanStore_TID4,_RefObjChar.CanBeVehicle,_RefObjChar.CanControl,_RefObjChar.DamagePortion,_RefObjChar.MaxPassenger,_RefObjChar.AssocTactics,_RefObjChar.PD,_RefObjChar.MD,_RefObjChar.PAR,_RefObjChar.MAR,_RefObjChar.ER,_RefObjChar.BR,_RefObjChar.HR,_RefObjChar.CHR,_RefObjChar.ExpToGive,_RefObjChar.CreepType,_RefObjChar.Knockdown,_RefObjChar.KO_RecoverTime,_RefObjChar.DefaultSkill_1,_RefObjChar.DefaultSkill_2,_RefObjChar.DefaultSkill_3,_RefObjChar.DefaultSkill_4,_RefObjChar.DefaultSkill_5,_RefObjChar.DefaultSkill_6,_RefObjChar.DefaultSkill_7,_RefObjChar.DefaultSkill_8,_RefObjChar.DefaultSkill_9,_RefObjChar.DefaultSkill_10,_RefObjChar.TextureType,_RefObjChar.Except_1,_RefObjChar.Except_2,_RefObjChar.Except_3,_RefObjChar.Except_4,_RefObjChar.Except_5,_RefObjChar.Except_6,_RefObjChar.Except_7,_RefObjChar.Except_8,_RefObjChar.Except_9,_RefObjChar.Except_10
FROM _RefObjCommon INNER JOIN _RefObjChar ON _RefObjCommon.Link=_RefObjChar.ID WHERE CodeName128 LIKE @CodeName AND _RefObjCommon.Service=1 ORDER BY _RefObjCommon.ID ASC
END
IF(@Type!=1 OR @Type!=2)
BEGIN
PRINT 'The Type must be 1 OR 2!'
PRINT 'Use @Type=1 for Items'
PRINT 'Use @Type=2 for Characters'
END
بعد كده دى هتطلعلك ال Media Lines اللى هتحطها فى Itemdata45000.txt
كود PHP:
USE SRO_VT_SHARD
EXEC _GetMediaLines 1,'ITEM_ETC_JAY_FB_WEAPON'
EXEC _GetMediaLines 1,'ITEM_ETC_JAY_FB_SHIELD'
EXEC _GetMediaLines 1,'ITEM_ETC_JAY_FB_HAT'
EXEC _GetMediaLines 1,'ITEM_ETC_JAY_FB_CHEST'
EXEC _GetMediaLines 1,'ITEM_ETC_JAY_FB_SHOULDER'
EXEC _GetMediaLines 1,'ITEM_ETC_JAY_FB_HAND'
EXEC _GetMediaLines 1,'ITEM_ETC_JAY_FB_LEGS'
EXEC _GetMediaLines 1,'ITEM_ETC_JAY_FB_BOOTS'
EXEC _GetMediaLines 1,'ITEM_ETC_JAY_FB_RING_L'
EXEC _GetMediaLines 1,'ITEM_ETC_JAY_FB_RING_R'
EXEC _GetMediaLines 1,'ITEM_ETC_JAY_FB_EARRING'
EXEC _GetMediaLines 1,'ITEM_ETC_JAY_FB_NECKLACE'
Textdata_Object
كود PHP:
1 SN_ITEM_ETC_JAY_FB_WEAPON Weapons Full Blue Scroll
1 SN_ITEM_ETC_JAY_FB_SHIELD Shields Full Blue Scroll
1 SN_ITEM_ETC_JAY_FB_HAT Hat Full Blue Scroll
1 SN_ITEM_ETC_JAY_FB_CHEST Chest Full Blue Scroll
1 SN_ITEM_ETC_JAY_FB_SHOULDER Shoulder Full Blue Scroll
1 SN_ITEM_ETC_JAY_FB_HAND Hand Full Blue Scroll
1 SN_ITEM_ETC_JAY_FB_LEGS Legs Full Blue Scroll
1 SN_ITEM_ETC_JAY_FB_BOOTS Foot Full Blue Scroll
1 SN_ITEM_ETC_JAY_FB_RING_L Left Ring Full Blue Scroll
1 SN_ITEM_ETC_JAY_FB_RING_R Right Ring Full Blue Scroll
1 SN_ITEM_ETC_JAY_FB_EARRING Earring Full Blue Scroll
1 SN_ITEM_ETC_JAY_FB_NECKLACE Necklace Full Blue Scroll
رابط ال Icon
DOWNLOAD HERE
شوية ملحوظات
- اتأكد من ال ID فى ال Procedure بتاع ال system هو زى اللى انت عملتهم ولا لا
- اتأكد من ال ID فى AddLogItem_ زى اللى انت عملتهم ولا لا
- السيستم ده مش بتحط فيه الايتم فى اول slot لا ده لازم تبقى لابس ال item
- اللى عايز Lines EU يقدر يعملها من خلال SMC تعمل ال Items FB وبعدين تاخد ال Params وتعمل بيها Lines زى مانا وضحت فوق
- اللى عنده ستيستم Model Switchers او Dye اوLock اواى حاجة فيها Lines تانية لل Items مينساش يحط ال Items دى كمان مع ال Lines اللى انا كاتبها عشان السيستم يشتغل عليها
كده الموضوع انتهى واتمنى اكون ساعدت قدر الإمكان .. بالتوفيق |
