تجميعة سكرولات
بسم الله الرحمن الرحيم
النهرادا جايب تجميعة اسكرولات والموضوع ده هجدد فيه بستمرار عشان انا بجرب الاسكرولات ابل ما بحطها والبعض بخدو من موقع بس بعد مبجربو طبعا عشان لو فيه مشكله
نبداء
1-Scroll FB+Stats 100% + Plus +16
طبعا الموضوع باين من عنوانه .. اسكرولاية صغيرة كدا عملتها ف حبيت اشاركها معاكو هنا :)
الاسكرولاية بأختصار لو انت عايز تعمل Reward لي الناس الجديدة ف السيرفر من غير ما تتعب نفسك بتعمل الاسكرول دي( بتعملك الحاجه اللي الشخصية لابساها +16 100% FB ) ممكن تعملها 80% / 0% انت وراحت وممكن تعدل علي ال + في Procedure برضه انت وراحتك ..
نخش في الموضوع بقا معلش طولت عليكو
Database Slide
_RefObjCommon
RefObjItem
Media Slide
Itemdata45000.txt
Textdata_Object.txt
_AddLogItem
Create Procedure
لو تلاحظو في ال Procedure انا عامل ال + بالاحمر عشان اللي حابب يعدل عليه
بمعني انك عاوز تعمل ابجريد بالأسكرول مثلاً لـ Ring +7 دجري 8 مثلاً ل Ring دجري 9 +0
هتضيف ال Old Ring RefObjCommon ID و New Ring RefObjCommon ID
جنب بعض في الجدول وتيجي في الكيوري تعدل عليها انا شارح كل حاجة هيتعدل عليها في الكيوري
أول حاجة هتكريت الجدول دا
تاني حاجة هتكريت سكرول وطبعاً دي مفروغ منها أو لو عندك اسكرول عاوز تعدل عليها اهم حاجة يكون معاك ال RefItemID بتاعها
ودي الكيوري هتحطها في SRO_VT_SHARDLOG.dbo._AddLogItem
انا نزلت الأسكرول دي لأن في ناس كلمتني كتير عشان الموضوع اللي كنت عامله قبل كدا بتاع الأبجريد سكرول القديمة ،،
عموماً انا مجربتهاش بس انا متأكد من الأكواد إن شاء الله مش هتلاقوا مشاكل
اللي عنده مشكلة ينزلها في قسم الأسئلة لأني بجد معنديش وقت ارد علي كل واحد مش عارف يضيف الأسكرول او يعدل علي الكيوري ،،
حاطت كومينتات في الكيوري عشان تشرحلك كل سطر هتعدل عليه بتاع إيه مفهمتش الكلام ترجمه علي جوجل
عشان متقولوش انت مش بترد علينا ليه او معاملتك ناشفة والكلام دا
تحياتي
مش عارف الموضوع ده موجود قبل كده ولا لا او بنفس ال Performance ولا لا بس عمتا حبيت اساعد وان شاء الله يعجبكم
نخش فى المفيد
الأول هنعمل Execute لكام حاجة كده
وتضيف دى فى AddLogItem_
دلوقتى نركز هنا شوية ..
دلوقتى هنفتح ال Table اللى لسه عاملنها دى وتشوف انت السيرفر بتاعك Degree كام فلنفترض انك Degree 10 فهتحط ال Lines دى فيها
طيب واحد هييجى يقولى انا Degree تانى وبتاع عادى استخدم نفس ال Lines بس غير ال _10_ لرقم الديجرى بتاعك .. ايه !! وانا هعد اعمل كل السطور دى ؟! .. لا يا عم اتفضل ال Query دى هتخلص الدنيا
كل اللى عليك تكتب رقم الديجرى بتاعك بس
خلاص كده ؟
.. انت مستعجل ليه يا عم ^^ فاضل حاجة واحده كمان
ال ID بتاع كل Item لازم يكون زى ال ID اللى فى RefObjCommon_ وكمان ال Level بتاعهم
ماحنا بقينا فى ديجرى تانى بقى صحصح معايا كده
إيه !! طب وبعدين انا همسك سطر سطر ولا ايه ده عبورنا اسهل من كده !!
لا يا عم انا ساعدتك وكتبتلك Query لذيذة كده اعملها Execute مش اكتر وهى هتقوم بالواجب
ملحوظة : ال Lines دى CH بس
كده احنا ظبطنا الدنيا عشان ال Scrolls .. هى فين بقى ال Scrolls ^^
اهى يا عمنا
RefObjCommon_
RefObjItem_
بعد كده اعمل Execute لى دى
بعد كده دى هتطلعلك ال Media Lines اللى هتحطها فى Itemdata45000.txt
Textdata_Object
رابط ال 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 اللى انا كاتبها عشان السيستم يشتغل عليها
[/CENTER]
[/CENTER]
[/CENTER]
وقت تحمل
[/CENTER]
اللي عندوا كلمة حلوة يقولها و ونبي اقرا كويس
RefObjCommon
RefObjItem
_AddLogItem
:-Media
-------
itemdata_xxxxx
textdata_object
RefObjItem
Server_dep Side
Itemdata_xxxxx.txt
Textdata_Object.txt
--------------------------Procedure--------------------------
مبدئيا كدة البروسيدر مظبوط على كاب 110 فلو انت مش 110 هتطر تعدل على رقم 110 التحت ده لرقم الكاب عندك
وتعدل على 220 لرقم الميسترى الايروبى الى عندك وكذلك فى الصينى
Skills Table
Table Lines
ملحوظة ان ديه اسكلات ال 110 فلو انت كاب تانى هتطر تعملهم بنفسك
بالنسبة للايكونز هانا خدت كل الفوق ده تيكستات ومعاهم الايكونز وكل حاجة ورفعتهم عشان تضيف اسرع واسهل
Mastery Scroll - Google Drive
Password: STORXY
النهرادا جايب تجميعة اسكرولات والموضوع ده هجدد فيه بستمرار عشان انا بجرب الاسكرولات ابل ما بحطها والبعض بخدو من موقع بس بعد مبجربو طبعا عشان لو فيه مشكله
نبداء
1-Scroll FB+Stats 100% + Plus +16
طبعا الموضوع باين من عنوانه .. اسكرولاية صغيرة كدا عملتها ف حبيت اشاركها معاكو هنا :)
الاسكرولاية بأختصار لو انت عايز تعمل Reward لي الناس الجديدة ف السيرفر من غير ما تتعب نفسك بتعمل الاسكرول دي( بتعملك الحاجه اللي الشخصية لابساها +16 100% FB ) ممكن تعملها 80% / 0% انت وراحت وممكن تعدل علي ال + في Procedure برضه انت وراحتك ..
نخش في الموضوع بقا معلش طولت عليكو
Database Slide
_RefObjCommon
كود:
1 61536 ITEM_MALL_GAMER_FB ????? xxx SN_ITEM_MALL_SILK_SCROLL_5 SN_ITEM_POINT_1_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\archemy_reinforce_athanasia_a.ddj xxx xxx 2236467
كود:
2236467 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 1000 ???? 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
Media Slide
Itemdata45000.txt
كود:
1 61536 ITEM_MALL_GAMER_FB ????? xxx SN_ITEM_MALL_GAMER_FB SN_ITEM_MALL_GAMER_FB_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 pet2\item\item_pet2_system_name_remove.ddj xxx xxx 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 1000 ???? 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
كود:
1 SN_ITEM_MALL_GAMER_FB Reward Scroll
_AddLogItem
كود:
IF (@Operation=41 AND @ItemRefID=61536) BEGIN -- Codded By Gamer1337 EXEC FB @CHARID END
كود:
USE [SRO_VT_SHARDLOG] -- Codded By Gamer1337
GO
/****** Object: StoredProcedure [dbo].[FB] Script Date: 14/03/2017 12:00:00 ص ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
CREATE PROCEDURE [dbo].[FB]
@CHARID INT
AS
BEGIN
SET NOCOUNT ON;
DECLARE @ItemID int
,@Charname VarChar(50)
,@PLUS int
, @Head int
,@CHEST int
,@LEGS int
,@SHOULDER int
,@HAND int
, @FOOT int
,@RING1 int
,@RING2 int
,@NECK int
,@ERRING int
,@WEP int
,@SHIELD int
SELECT @Charname=CHARNAME16 FROM SRO_VT_SHARD__JOoOo.._CHAR WHERE CHARID=@Charid
SET @PLUS = '16'
SET @Charid = (select CharID from SRO_VT_SHARD__JOoOo.._Char where CharName16=@Charname)
SET @Head = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=0 and CharID=@Charid)
SET @CHEST = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=1 and CharID=@Charid)
SET @LEGS = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=4 and CharID=@Charid)
SET @SHOULDER = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=2 and CharID=@Charid)
SET @HAND = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=3 and CharID=@Charid)
SET @FOOT = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=5 and CharID=@Charid)
SET @RING1 = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=11 and CharID=@Charid)
SET @RING2 = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=12 and CharID=@Charid)
SET @NECK = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=10 and CharID=@Charid)
SET @ERRING = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=9 and CharID=@Charid)
SET @WEP =(Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=6 and CharID=@Charid)
SET @SHIELD =(Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=7 and CharID=@Charid)
update SRO_VT_SHARD__JOoOo.._Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =5583457484950,
MagParam2 =5583457484962,
MagParam3 =30064771144,
MagParam4=858993459290,
MagParam5=30064771150,
MagParam6=257698037898,
Variance=1073741823
where ID64 =@Head
---------------
update SRO_VT_SHARD__JOoOo.._Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =5583457484950,
MagParam2 =5583457484962,
MagParam3 =30064771144,
MagParam4=858993459290,
MagParam5=30064771150,
MagParam6=257698037898,
Variance=1073741823
where ID64 =@CHEST
----------------------
update SRO_VT_SHARD__JOoOo.._Items
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
MagParam4=257698037898,
Variance=1073741823
where ID64 =@SHOULDER
----------------------
update SRO_VT_SHARD__JOoOo.._Items
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
MagParam4=257698037898,
Variance=1073741823
where ID64 =@HAND
update SRO_VT_SHARD__JOoOo.._Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =5583457484950,
MagParam2 =5583457484962,
MagParam3 =30064771144,
MagParam4=858993459290,
MagParam5=30064771150,
MagParam6=257698037898,
Variance=1073741823
where ID64 =@LEGS
-----------------------
update SRO_VT_SHARD__JOoOo.._Items
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
MagParam4=257698037898,
Variance=1073741823
where ID64 =@FOOT
update SRO_VT_SHARD__JOoOo.._Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =30064771144,
MagParam2 =30064771150,
MagParam3 =85899346100,
MagParam4 =85899346094,
MagParam5 =85899346112,
MagParam6 =85899346106,
Variance=1023
where ID64 =@RING1
update SRO_VT_SHARD__JOoOo.._Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =30064771144,
MagParam2 =30064771150,
MagParam3 =85899346100,
MagParam4 =85899346094,
MagParam5 =85899346112,
MagParam6 =85899346106,
Variance=1023
where ID64 =@RING2
update SRO_VT_SHARD__JOoOo.._Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =30064771144,
MagParam2 =30064771150,
MagParam3 =85899346100,
MagParam4 =85899346094,
MagParam5 =85899346112,
MagParam6 =85899346106,
Variance=1023
where ID64 =@NECK
update SRO_VT_SHARD__JOoOo.._Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =30064771144,
MagParam2 =30064771150,
MagParam3 =85899346100,
MagParam4 =85899346094,
MagParam5 =85899346112,
MagParam6 =85899346106,
Variance=1023
where ID64 =@ERRING
update SRO_VT_SHARD__JOoOo.._Items
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
MagParam4 =257698037862,
Variance=34359738367
where ID64 =@WEP
update SRO_VT_SHARD__JOoOo.._Items
set MagParamNum=3,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
Variance=1073741823
where ID64 =@SHIELD
set nocount off;
END
لو تلاحظو في ال Procedure انا عامل ال + بالاحمر عشان اللي حابب يعدل عليه
2-لموضوع وبكل اختصار بيعمل ابجريد لأي أيتم موجود في Slot 13 أياً كان بس شرط انه يلاقيه في الـ OldItemID في جدول الأبجريد ،،
بمعني انك عاوز تعمل ابجريد بالأسكرول مثلاً لـ Ring +7 دجري 8 مثلاً ل Ring دجري 9 +0
هتضيف ال Old Ring RefObjCommon ID و New Ring RefObjCommon ID
جنب بعض في الجدول وتيجي في الكيوري تعدل عليها انا شارح كل حاجة هيتعدل عليها في الكيوري
أول حاجة هتكريت الجدول دا
كود PHP:
Use SRO_VT_SHARDLOG
Create Table [dbo].[ItemsUpgrade]
([OldRefItemID] [Int] NOT NULL,
[NewRefItemID] [Int] NOT NULL) تاني حاجة هتكريت سكرول وطبعاً دي مفروغ منها أو لو عندك اسكرول عاوز تعدل عليها اهم حاجة يكون معاك ال RefItemID بتاعها
ودي الكيوري هتحطها في SRO_VT_SHARDLOG.dbo._AddLogItem
كود PHP:
IF (@Operation = 41 and @ItemRefID = 'Scroll CommonID')
Begin
Declare @NewItemID Int , @ID64 Int, @Slot Int, @ReqPlus Int, @NewPlus Int, @Name Varchar(100), @Codename Varchar(128), @Msg Varchar(128);
Set @Slot = 13; -- Upgrade Slot
Set @ReqPlus = 8; -- Required Optlevel
Set @NewPlus = 0; -- New Item OptLevel
Set @Codename = 'ITEM_MALL_UPGRADE_SCROLL_ALL_SLOT_13'; -- Upgrade Scroll CodeName128
Set @Msg = 'Target item cannot be upgraded, scroll has returned to your inventory.'; -- Private Message for fail upgrading process
Set @Name = (Select Charname16 From [SRO_VT_SHARD].[dbo].[_Char] Where CharID = @CharID);
Select @NewItemID = U.NewRefItemID , @ID64 = I.ID64 From [dbo].[ItemsUpgrade] U Inner Join [SRO_VT_SHARD].[dbo].[_Items] I
ON U.OldRefItemID = I.RefItemID Inner Join [SRO_VT_SHARD].[dbo].[_Inventory] V ON I.ID64 = V.ItemID Where V.CharID = @CharID
and V.Slot = @Slot and I.OptLevel = @ReqPlus;
IF (@NewItemID Is Not Null)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @NewItemID , OptLevel = @NewPlus Where ID64 = @ID64;
End ELSE Begin
-- Vsro Multi Tool Table
Insert Into [iLegendBot].[dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values ('1','Private',@Name,@Msg,Getdate());
Exec [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @Name,@Codename,1,0;
End
End انا نزلت الأسكرول دي لأن في ناس كلمتني كتير عشان الموضوع اللي كنت عامله قبل كدا بتاع الأبجريد سكرول القديمة ،،
عموماً انا مجربتهاش بس انا متأكد من الأكواد إن شاء الله مش هتلاقوا مشاكل
اللي عنده مشكلة ينزلها في قسم الأسئلة لأني بجد معنديش وقت ارد علي كل واحد مش عارف يضيف الأسكرول او يعدل علي الكيوري ،،
حاطت كومينتات في الكيوري عشان تشرحلك كل سطر هتعدل عليه بتاع إيه مفهمتش الكلام ترجمه علي جوجل
عشان متقولوش انت مش بترد علينا ليه او معاملتك ناشفة والكلام دا
تحياتي
اقتباس:
المشاركة الأصلية كتبت بواسطة Levi
work perfectly well
Video Here! Scroll Line .. refobjCommon
كود PHP:
كود PHP:
كود PHP:
|
3-طبعا ناس كتير جدا كانت بتسأل عن ال 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
كود 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 كل اللى عليك تكتب رقم الديجرى بتاعك بس
كود PHP:
USE SRO_VT_SHARDLOGDECLARE @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 كده احنا ظبطنا الدنيا عشان ال 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
كود 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
كود 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
ENDIF(@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
كود 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'
كود 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 DOWNLOAD HERE
شوية ملحوظات
- اتأكد من ال ID فى ال Procedure بتاع ال system هو زى اللى انت عملتهم ولا لا
- اتأكد من ال ID فى AddLogItem_ زى اللى انت عملتهم ولا لا
- السيستم ده مش بتحط فيه الايتم فى اول slot لا ده لازم تبقى لابس ال item
- اللى عايز Lines EU يقدر يعملها من خلال SMC تعمل ال Items FB وبعدين تاخد ال Params وتعمل بيها Lines زى مانا وضحت فوق
- اللى عنده ستيستم Model Switchers او Dye اوLock اواى حاجة فيها Lines تانية لل Items مينساش يحط ال Items دى كمان مع ال Lines اللى انا كاتبها عشان السيستم يشتغل عليها
4-Scroll FB Devil
ٌRefObjCommon
RefObjItem
RefSkill
RefSkillGroup
Media--server_dep--
Itemdata_xxx.txt
textdata_object
skilldata_xxxxxenc
كود PHP:
1 103062 ITEM_MALL_BLUEDEVIL ???? ???? ??? (???) xxx SN_ITEM_MALL_BLUEDEVIL SN_ITEM_MALL_BLUEDEVIL_TT_DESC 1 0 3 3 13 14 180000 3 0 1 1 1 255 0 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 item\etc\BD_BlueDevil.ddj xxx xxx 2236104 RefObjItem
كود PHP:
2236104 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 1000 ????(?) 1 [USU1:SKILL_MALL_BLUEDEVIL] -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 -1 xxx 0 0 0 RefSkill
كود PHP:
1 34003 12023 SKILL_MALL_BLUEDEVIL ???? SKILL_MALL_BLUEDEVIL 0 1 1 0 0 0 0 0 1000 0 0 0 3599 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 255 255 0 0 0 0 0 255 255 255 255 item\etc\mall_optlevel_upgrade_scroll_1.ddj SN_SKILL_MALL_BLUEDEVIL xxx SN_SKILL_MALL_BLUEDEVIL_TT_DESC xxx 0 0 3 1667396966 1851946342 1685418593 1500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 RefSkillGroup
كود PHP:
12023 SKILL_MALL_BLUEDEVIL Media--server_dep--
Itemdata_xxx.txt
كود PHP:
1 103062 ITEM_MALL_BLUEDEVIL ???? ???? ??? (???) xxx SN_ITEM_MALL_BLUEDEVIL SN_ITEM_MALL_BLUEDEVIL_TT_DESC 1 0 3 3 13 14 180000 3 0 1 1 1 255 0 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 item\etc\BD_BlueDevil.ddj xxx xxx 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 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1000 ????(?) 1 [USU1:SKILL_MALL_BLUEDEVIL] -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 -1 xxx 0 0
كود PHP:
1 SN_ITEM_MALL_BLUEDEVIL Scroll Blue Devil
1 SN_ITEM_MALL_BLUEDEVIL_TT_DESC scroll to blue By Hardy skilldata_xxxxxenc
كود PHP:
1 34003 12023 SKILL_MALL_BLUEDEVIL ???? SKILL_MALL_BLUEDEVIL 0 1 1 0 0 0 0 0 1000 0 0 0 3599 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 255 255 0 0 0 0 0 255 255 255 255 item\etc\mall_optlevel_upgrade_scroll_1.ddj SN_SKILL_MALL_BLUEDEVIL xxx SN_SKILL_MALL_BLUEDEVIL_TT_DESC xxx 0 0 3 1667396966 1851946342 1685418593 1500 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
كود PHP:
AddTimedJob Procedure ByHardy [/CENTER]
كود PHP:
if(@JobID = '34003') --- Credit To Hardy1337
BEGIN declare @ItemID1 varchar (64)select ItemID=@ItemID1 from _InventoryForAvatar where CharID = @CharID and Slot = '4'UPDATE dbo._Items set MagParamNum='5',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='5583457484950',MagParam4= '5583457484962',MagParam5='257698037898'WHERE ID64 = (select ItemID from _InventoryForAvatar where CharID = @CharID and Slot = '4' and ItemID>0)END وقت تحمل
كود PHP:
https://mega.nz/#!UNx1TRwA!SU7dafBknT5tAu63FKI7MgHI-zanQ2k6xkopPuz17ys
5-دلواقتي انا جبتلكم اسكرولة جديدة هي سهلة جدا جدا جدا جدا و بسيطة جدا جدا جدا بس محدش باين فكر فيها قبل كدة بس ادينا بنساعد علي قد منقدر
الاسكرولة عبارة عن اسكرولة بتديك جولد بمعني انك في البروسيدور تحدد مليار هتضرب الاسكرولة هيجيلك مليار و اللي انت عاوزه شكرااللي عندوا كلمة حلوة يقولها و ونبي اقرا كويس
RefObjCommon
كود PHP:
1 79710 ITEM_GIVE_GOLD ?? ??? xxx SN_ITEM_GIVE_GOLD SN_ITEM_GIVE_GOLD_TT_DESC 0 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 15000 0 0 0 150 4500 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_ch_eventbox.bsr item\etc\mall_indulgence.ddj xxx xxx 755200
كود PHP:
755200 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 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 5000 ???? 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
كود PHP:
IF (@Operation = 41) AND @ItemRefID = '62582'
BEGIN
UPDATE [SRO_VT_SHARD].[dbo]._Char SET RemainGold = RemainGold + '1000000000' WHERE CharID = @CharID
End :-Media
-------
itemdata_xxxxx
كود PHP:
1 79710 ITEM_GIVE_GOLD ?? ??? xxx SN_ITEM_GIVE_GOLD SN_ITEM_GIVE_GOLD_TT_DESC 0 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 15000 0 0 0 150 4500 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_ch_eventbox.bsr item\etc\mall_indulgence.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 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 5000 ???? 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
كود PHP:
1 SN_ITEM_GIVE_GOLD Give Money Scroll
1 SN_ITEM_GIVE_GOLD_TT_DESC This scrol
6-Mastery Scrolls - Full one
RefObjCommon
كود PHP:
1 41925 ITEM_STORXY_MASTERY_PACHEON ????? xxx SN_ITEM_STORXY_MASTERY_PACHEON SN_ITEM_STORXY_MASTERY_PACHEON_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 223 0 1 0 0 1 0 1 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 storxy\mastery_bow.ddj xxx xxx 21443
1 41926 ITEM_STORXY_MASTERY_HEUKSAL ????? xxx SN_ITEM_STORXY_MASTERY_HEUKSAL SN_ITEM_STORXY_MASTERY_HEUKSAL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 223 0 1 0 0 1 0 1 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 storxy\mastery_spear.ddj xxx xxx 21444
1 41927 ITEM_STORXY_MASTERY_BICHEON ????? xxx SN_ITEM_STORXY_MASTERY_BICHEON SN_ITEM_STORXY_MASTERY_BICHEON_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 223 0 1 0 0 1 0 1 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 storxy\mastery_sword.ddj xxx xxx 21445
1 41928 ITEM_STORXY_MASTERY_FIRE ????? xxx SN_ITEM_STORXY_MASTERY_FIRE SN_ITEM_STORXY_MASTERY_FIRE_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 223 0 1 0 0 1 0 1 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 storxy\mastery_fire.ddj xxx xxx 21446
1 41929 ITEM_STORXY_MASTERY_LIGHTNING ????? xxx SN_ITEM_STORXY_MASTERY_LIGHTNING SN_ITEM_STORXY_MASTERY_LIGHTNING_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 223 0 1 0 0 1 0 1 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 storxy\mastery_lightning.ddj xxx xxx 21447
1 41930 ITEM_STORXY_MASTERY_COLD ????? xxx SN_ITEM_STORXY_MASTERY_COLD SN_ITEM_STORXY_MASTERY_COLD_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 223 0 1 0 0 1 0 1 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 storxy\mastery_cold.ddj xxx xxx 21448
1 41931 ITEM_STORXY_MASTERY_FORCE ????? xxx SN_ITEM_STORXY_MASTERY_FORCE SN_ITEM_STORXY_MASTERY_FORCE_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 223 0 1 0 0 1 0 1 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 storxy\mastery_water.ddj xxx xxx 21449
1 41932 ITEM_STORXY_MASTERY_WIZARD ????? xxx SN_ITEM_STORXY_MASTERY_WIZARD SN_ITEM_STORXY_MASTERY_WIZARD_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 223 0 1 0 0 1 0 1 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 storxy\eu_wizard.ddj xxx xxx 21450
1 41933 ITEM_STORXY_MASTERY_WARRIOR ????? xxx SN_ITEM_STORXY_MASTERY_WARRIOR SN_ITEM_STORXY_MASTERY_WARRIOR_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 223 0 1 0 0 1 0 1 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 storxy\eu_warrior.ddj xxx xxx 21451
1 41934 ITEM_STORXY_MASTERY_ROUGE ????? xxx SN_ITEM_STORXY_MASTERY_ROUGE SN_ITEM_STORXY_MASTERY_ROUGE_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 223 0 1 0 0 1 0 1 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 storxy\eu_rog.ddj xxx xxx 21452
1 41935 ITEM_STORXY_MASTERY_CLERICE ????? xxx SN_ITEM_STORXY_MASTERY_CLERIC SN_ITEM_STORXY_MASTERY_CLERIC_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 223 0 1 0 0 1 0 1 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 storxy\eu_cleric.ddj xxx xxx 21453
1 41936 ITEM_STORXY_MASTERY_BARD ????? xxx SN_ITEM_STORXY_MASTERY_BARD SN_ITEM_STORXY_MASTERY_BARD_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 223 0 1 0 0 1 0 1 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 storxy\eu_bard.ddj xxx xxx 21454
1 41937 ITEM_STORXY_MASTERY_WARLOCK ????? xxx SN_ITEM_STORXY_MASTERY_WARLOCK SN_ITEM_STORXY_MASTERY_WARLOCK_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 223 0 1 0 0 1 0 1 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 storxy\eu_warlock.ddj xxx xxx 21455
كود PHP:
21443 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 1000 ???? 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
21444 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 1000 ???? 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
21445 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 1000 ???? 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
21446 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 1000 ???? 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
21447 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 1000 ???? 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
21448 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 1000 ???? 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
21449 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 1000 ???? 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
21450 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 1000 ???? 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
21451 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 1000 ???? 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
21452 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 1000 ???? 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
21453 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 1000 ???? 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
21454 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 1000 ???? 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
21455 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 1000 ???? 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 Itemdata_xxxxx.txt
كود PHP:
1 41925 ITEM_STORXY_MASTERY_PACHEON ????? xxx SN_ITEM_STORXY_MASTERY_PACHEON SN_ITEM_STORXY_MASTERY_PACHEON_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 223 0 1 0 0 1 0 1 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 storxy\mastery_bow.ddj xxx xxx 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 1000 ???? 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
1 41926 ITEM_STORXY_MASTERY_HEUKSAL ????? xxx SN_ITEM_STORXY_MASTERY_HEUKSAL SN_ITEM_STORXY_MASTERY_HEUKSAL_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 223 0 1 0 0 1 0 1 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 storxy\mastery_spear.ddj xxx xxx 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 1000 ???? 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
1 41927 ITEM_STORXY_MASTERY_BICHEON ????? xxx SN_ITEM_STORXY_MASTERY_BICHEON SN_ITEM_STORXY_MASTERY_BICHEON_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 223 0 1 0 0 1 0 1 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 storxy\mastery_sword.ddj xxx xxx 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 1000 ???? 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
1 41928 ITEM_STORXY_MASTERY_FIRE ????? xxx SN_ITEM_STORXY_MASTERY_FIRE SN_ITEM_STORXY_MASTERY_FIRE_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 223 0 1 0 0 1 0 1 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 storxy\mastery_fire.ddj xxx xxx 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 1000 ???? 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
1 41929 ITEM_STORXY_MASTERY_LIGHTNING ????? xxx SN_ITEM_STORXY_MASTERY_LIGHTNING SN_ITEM_STORXY_MASTERY_LIGHTNING_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 223 0 1 0 0 1 0 1 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 storxy\mastery_lightning.ddj xxx xxx 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 1000 ???? 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
1 41930 ITEM_STORXY_MASTERY_COLD ????? xxx SN_ITEM_STORXY_MASTERY_COLD SN_ITEM_STORXY_MASTERY_COLD_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 223 0 1 0 0 1 0 1 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 storxy\mastery_cold.ddj xxx xxx 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 1000 ???? 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
1 41931 ITEM_STORXY_MASTERY_FORCE ????? xxx SN_ITEM_STORXY_MASTERY_FORCE SN_ITEM_STORXY_MASTERY_FORCE_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 223 0 1 0 0 1 0 1 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 storxy\mastery_water.ddj xxx xxx 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 1000 ???? 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
1 41932 ITEM_STORXY_MASTERY_WIZARD ????? xxx SN_ITEM_STORXY_MASTERY_WIZARD SN_ITEM_STORXY_MASTERY_WIZARD_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 223 0 1 0 0 1 0 1 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 storxy\eu_wizard.ddj xxx xxx 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 1000 ???? 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
1 41933 ITEM_STORXY_MASTERY_WARRIOR ????? xxx SN_ITEM_STORXY_MASTERY_WARRIOR SN_ITEM_STORXY_MASTERY_WARRIOR_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 223 0 1 0 0 1 0 1 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 storxy\eu_warrior.ddj xxx xxx 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 1000 ???? 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
1 41934 ITEM_STORXY_MASTERY_ROUGE ????? xxx SN_ITEM_STORXY_MASTERY_ROUGE SN_ITEM_STORXY_MASTERY_ROUGE_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 223 0 1 0 0 1 0 1 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 storxy\eu_rog.ddj xxx xxx 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 1000 ???? 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
1 41935 ITEM_STORXY_MASTERY_CLERICE ????? xxx SN_ITEM_STORXY_MASTERY_CLERIC SN_ITEM_STORXY_MASTERY_CLERIC_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 223 0 1 0 0 1 0 1 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 storxy\eu_cleric.ddj xxx xxx 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 1000 ???? 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
1 41936 ITEM_STORXY_MASTERY_BARD ????? xxx SN_ITEM_STORXY_MASTERY_BARD SN_ITEM_STORXY_MASTERY_BARD_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 223 0 1 0 0 1 0 1 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 storxy\eu_bard.ddj xxx xxx 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 1000 ???? 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
1 41937 ITEM_STORXY_MASTERY_WARLOCK ????? xxx SN_ITEM_STORXY_MASTERY_WARLOCK SN_ITEM_STORXY_MASTERY_WARLOCK_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 223 0 1 0 0 1 0 1 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 storxy\eu_warlock.ddj xxx xxx 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 1000 ???? 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
كود PHP:
1 SN_ITEM_STORXY_MASTERY_PACHEON Mastery Level Up (Pacheon)1 SN_ITEM_STORXY_MASTERY_HEUKSAL Mastery Level Up (Heuksal)1 SN_ITEM_STORXY_MASTERY_BICHEON Mastery Level Up (Bicheon)1 SN_ITEM_STORXY_MASTERY_FIRE Mastery Level Up (Fire)1 SN_ITEM_STORXY_MASTERY_LIGHTNING Mastery Level Up (Lightning)1 SN_ITEM_STORXY_MASTERY_COLD Mastery Level Up (Cold)1 SN_ITEM_STORXY_MASTERY_FORCE Mastery Level Up (Force)1 SN_ITEM_STORXY_MASTERY_WIZARD Mastery Level Up (Wizard)1 SN_ITEM_STORXY_MASTERY_WARRIOR Mastery Level Up (Warrior)1 SN_ITEM_STORXY_MASTERY_ROUGE Mastery Level Up (Rouge)1 SN_ITEM_STORXY_MASTERY_CLERIC Mastery Level Up (Cleric)1 SN_ITEM_STORXY_MASTERY_BARD Mastery Level Up (Bard)1 SN_ITEM_STORXY_MASTERY_WARLOCK Mastery Level Up (Warlock) --------------------------Procedure--------------------------
مبدئيا كدة البروسيدر مظبوط على كاب 110 فلو انت مش 110 هتطر تعدل على رقم 110 التحت ده لرقم الكاب عندك
وتعدل على 220 لرقم الميسترى الايروبى الى عندك وكذلك فى الصينى
كود PHP:
---------------------------STORXY-------------------------------Skype:Storxy1337-------------------------------
IF (@Operation=41 AND @ItemRefID BETWEEN 41932 AND 41937) ---------------- European Mastery Scrolls -------------------
BEGIN
IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE MasteryID='513')
BEGIN
DECLARE @Wizard INT,@Warrior INT,@Rouge INT,@Warlock INT,@Bard INT,@Cleric INT
SELECT @Wizard=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='514'
SELECT @Warrior=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='513'
SELECT @Rouge=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='515'
SELECT @Warlock=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='516'
SELECT @Bard=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='517'
SELECT @Cleric=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='518'
IF (@Wizard+@Warrior+@Rouge+@Warlock+@Bard+@Cleric<='110')
BEGIN
DECLARE @EuropeanMasteryType INT;
SET @EuropeanMasteryType = CASE
WHEN @ItemRefID=41932 --------------- Wizard
THEN 514
WHEN @ItemRefID=41933 --------------- Warrior
THEN 513
WHEN @ItemRefID=41934 --------------- Rouge
THEN 515
WHEN @ItemRefID=41935 --------------- Cleric
THEN 518
WHEN @ItemRefID=41936 --------------- Bard
THEN 517
WHEN @ItemRefID=41937 --------------- Warlock
THEN 516
END
UPDATE SRO_VT_SHARD.dbo._CharSkillMastery SET [Level]='110' WHERE CharID=@CharID AND MasteryID=@EuropeanMasteryType
INSERT SRO_VT_SHARD.dbo._CharSkill SELECT @CharID,SkillID,'1' FROM SRO_VT_SHARDLOG.dbo._CharacterSkills WHERE MasteryID=@EuropeanMasteryType
END
END
END
IF (@Operation=41 AND @ItemRefID BETWEEN 41925 AND 41931) ---------------- Chinese Mastery Scrolls -------------------
BEGIN
IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE MasteryID='257')
BEGIN
DECLARE @Bicheon INT,@Heuksal INT,@Pacheon INT,@Cold INT,@Lightning INT,@Fire INT,@Force INT
SELECT @Bicheon=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='257'
SELECT @Heuksal=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='258'
SELECT @Pacheon=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='259'
SELECT @Cold=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='273'
SELECT @Lightning=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='274'
SELECT @Fire=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='275'
SELECT @Force=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='276'
IF (@Bicheon+@Heuksal+@Pacheon+@Cold+@Lightning+@Fire+@Force <='220')
BEGIN
DECLARE @ChineseMasteryType INT;
SET @ChineseMasteryType = Case
WHEN @ItemRefID=41927 --------------- Bacheon
THEN 257
WHEN @ItemRefID=41926 --------------- Heuksal
THEN 258
WHEN @ItemRefID=41925 --------------- Pacheon
THEN 259
WHEN @ItemRefID=41930 --------------- Cold
THEN 273
WHEN @ItemRefID=41929 --------------- Lightning
THEN 274
WHEN @ItemRefID=41928 --------------- Fire
THEN 275
WHEN @ItemRefID=41931 --------------- Foce
THEN 276
END
UPDATE SRO_VT_SHARD.dbo._CharSkillMastery SET [Level]='110' WHERE CharID=@CharID AND MasteryID=@ChineseMasteryType
INSERT SRO_VT_SHARD.dbo._CharSkill SELECT @CharID,SkillID,'1' FROM SRO_VT_SHARDLOG.dbo._CharacterSkills WHERE MasteryID=@ChineseMasteryType
END
END
END
---------------------------STORXY-------------------------------Skype:Storxy1337-------------------------------
كود PHP:
USE [SRO_VT_SHARDLOG]GO
/****** Object: Table [dbo].[_CharacterSkills] Script Date: 19/04/2016 09:12:04 ? ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_CharacterSkills](
[SkillID] [int] NOT NULL,
[Build] [varchar](50) NOT NULL,
[Race] [varchar](50) NOT NULL,
[MasteryID] [int] NOT NULL) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO ملحوظة ان ديه اسكلات ال 110 فلو انت كاب تانى هتطر تعملهم بنفسك
كود PHP:
###### Note: Only working with cap 110 #####8437 Warrior European 513
8447 Warrior European 513
8465 Warrior European 513
8476 Warrior European 513
8496 Warrior European 513
8512 Warrior European 513
8522 Warrior European 513
8571 Warrior European 513
8581 Warrior European 513
8595 Warrior European 513
8624 Warrior European 513
8645 Warrior European 513
8658 Warrior European 513
8668 Warrior European 513
8695 Warrior European 513
8710 Warrior European 513
8721 Warrior European 513
8752 Warrior European 513
8772 Warrior European 513
8812 Warrior European 513
8827 Warrior European 513
8879 Warrior European 513
8893 Warrior European 513
8903 Warrior European 513
8930 Warrior European 513
8958 Warrior European 513
8974 Warrior European 513
8994 Warrior European 513
9034 Warrior European 513
9040 Warrior European 513
9072 Warrior European 513
9100 Warrior European 513
9114 Warrior European 513
9124 Warrior European 513
9142 Warrior European 513
9170 Warrior European 513
9187 Warrior European 513
9210 Warrior European 513
9249 Warrior European 513
9262 Warrior European 513
9282 Warrior European 513
9322 Warrior European 513
9337 Warrior European 513
21224 Warrior European 513
11187 Bard European 517
11199 Bard European 517
11209 Bard European 517
11216 Bard European 517
11243 Bard European 517
11259 Bard European 517
11282 Bard European 517
11295 Bard European 517
11299 Bard European 517
11337 Bard European 517
11339 Bard European 517
11350 Bard European 517
11355 Bard European 517
11363 Bard European 517
11365 Bard European 517
11375 Bard European 517
11379 Bard European 517
11387 Bard European 517
11388 Bard European 517
11399 Bard European 517
11432 Bard European 517
11443 Bard European 517
11462 Bard European 517
11471 Bard European 517
11479 Bard European 517
11486 Bard European 517
11492 Bard European 517
11496 Bard European 517
11513 Bard European 517
11515 Bard European 517
11522 Bard European 517
11523 Bard European 517
30197 Bard European 517
30213 Bard European 517
30222 Bard European 517
30242 Bard European 517
30247 Bard European 517
9951 Wizard European 514
9956 Wizard European 514
9965 Wizard European 514
9970 Wizard European 514
9999 Wizard European 514
10017 Wizard European 514
10028 Wizard European 514
10041 Wizard European 514
10046 Wizard European 514
10062 Wizard European 514
10068 Wizard European 514
10076 Wizard European 514
10078 Wizard European 514
10104 Wizard European 514
10122 Wizard European 514
10133 Wizard European 514
10161 Wizard European 514
10166 Wizard European 514
10182 Wizard European 514
10188 Wizard European 514
10200 Wizard European 514
10205 Wizard European 514
10232 Wizard European 514
10262 Wizard European 514
10278 Wizard European 514
10296 Wizard European 514
10304 Wizard European 514
10323 Wizard European 514
10413 Wizard European 514
10489 Wizard European 514
10492 Wizard European 514
10519 Wizard European 514
10537 Wizard European 514
10548 Wizard European 514
10561 Wizard European 514
10566 Wizard European 514
10582 Wizard European 514
10602 Wizard European 514
10621 Wizard European 514
10623 Wizard European 514
9363 Rouge European 515
9369 Rouge European 515
9372 Rouge European 515
9378 Rouge European 515
9381 Rouge European 515
9388 Rouge European 515
9391 Rouge European 515
9397 Rouge European 515
9399 Rouge European 515
9407 Rouge European 515
9410 Rouge European 515
9417 Rouge European 515
9420 Rouge European 515
9428 Rouge European 515
9429 Rouge European 515
9437 Rouge European 515
9444 Rouge European 515
9448 Rouge European 515
9453 Rouge European 515
9454 Rouge European 515
9479 Rouge European 515
9488 Rouge European 515
9498 Rouge European 515
9514 Rouge European 515
9528 Rouge European 515
9541 Rouge European 515
9574 Rouge European 515
9585 Rouge European 515
9601 Rouge European 515
9609 Rouge European 515
9623 Rouge European 515
9629 Rouge European 515
9670 Rouge European 515
9685 Rouge European 515
9701 Rouge European 515
9713 Rouge European 515
9720 Rouge European 515
9734 Rouge European 515
9742 Rouge European 515
9768 Rouge European 515
9785 Rouge European 515
9796 Rouge European 515
9843 Rouge European 515
9866 Rouge European 515
9880 Rouge European 515
9895 Rouge European 515
9938 Rouge European 515
10650 Warlock European 516
10659 Warlock European 516
10685 Warlock European 516
10702 Warlock European 516
10730 Warlock European 516
10746 Warlock European 516
10772 Warlock European 516
10784 Warlock European 516
10805 Warlock European 516
10816 Warlock European 516
10830 Warlock European 516
10836 Warlock European 516
10846 Warlock European 516
10851 Warlock European 516
10860 Warlock European 516
10864 Warlock European 516
10872 Warlock European 516
10875 Warlock European 516
10902 Warlock European 516
10915 Warlock European 516
10942 Warlock European 516
10960 Warlock European 516
10971 Warlock European 516
10975 Warlock European 516
10986 Warlock European 516
10991 Warlock European 516
11001 Warlock European 516
11005 Warlock European 516
11011 Warlock European 516
11014 Warlock European 516
11040 Warlock European 516
11069 Warlock European 516
11086 Warlock European 516
11094 Warlock European 516
11107 Warlock European 516
11116 Warlock European 516
11127 Warlock European 516
11132 Warlock European 516
11142 Warlock European 516
11146 Warlock European 516
11154 Warlock European 516
11158 Warlock European 516
30184 Warlock European 516
30192 Warlock European 516
11551 Cleric European 518
11581 Cleric European 518
11597 Cleric European 518
11611 Cleric European 518
11618 Cleric European 518
11627 Cleric European 518
11632 Cleric European 518
11641 Cleric European 518
11647 Cleric European 518
11665 Cleric European 518
11682 Cleric European 518
11691 Cleric European 518
11702 Cleric European 518
11708 Cleric European 518
11719 Cleric European 518
11725 Cleric European 518
11740 Cleric European 518
11748 Cleric European 518
11764 Cleric European 518
11776 Cleric European 518
11780 Cleric European 518
11791 Cleric European 518
11793 Cleric European 518
11805 Cleric European 518
11807 Cleric European 518
11848 Cleric European 518
11865 Cleric European 518
11880 Cleric European 518
11893 Cleric European 518
11899 Cleric European 518
11912 Cleric European 518
11917 Cleric European 518
11928 Cleric European 518
11933 Cleric European 518
298 Bicheon Chinese 257
306 Bicheon Chinese 257
314 Bicheon Chinese 257
322 Bicheon Chinese 257
346 Bicheon Chinese 257
378 Bicheon Chinese 257
418 Bicheon Chinese 257
463 Bicheon Chinese 257
558 Bicheon Chinese 257
569 Bicheon Chinese 257
580 Bicheon Chinese 257
588 Bicheon Chinese 257
596 Bicheon Chinese 257
604 Bicheon Chinese 257
621 Bicheon Chinese 257
638 Bicheon Chinese 257
647 Bicheon Chinese 257
655 Bicheon Chinese 257
672 Bicheon Chinese 257
689 Bicheon Chinese 257
699 Bicheon Chinese 257
3140 Bicheon Chinese 257
3149 Bicheon Chinese 257
7139 Bicheon Chinese 257
7159 Bicheon Chinese 257
7203 Bicheon Chinese 257
7322 Bicheon Chinese 257
7385 Bicheon Chinese 257
7390 Bicheon Chinese 257
7392 Bicheon Chinese 257
7404 Bicheon Chinese 257
7418 Bicheon Chinese 257
7450 Bicheon Chinese 257
7474 Bicheon Chinese 257
7484 Bicheon Chinese 257
7513 Bicheon Chinese 257
7520 Bicheon Chinese 257
30578 Bicheon Chinese 257
30584 Bicheon Chinese 257
30590 Bicheon Chinese 257
30596 Bicheon Chinese 257
30600 Bicheon Chinese 257
708 Heuksal Chinese 258
716 Heuksal Chinese 258
724 Heuksal Chinese 258
735 Heuksal Chinese 258
746 Heuksal Chinese 258
757 Heuksal Chinese 258
765 Heuksal Chinese 258
773 Heuksal Chinese 258
781 Heuksal Chinese 258
789 Heuksal Chinese 258
797 Heuksal Chinese 258
805 Heuksal Chinese 258
813 Heuksal Chinese 258
821 Heuksal Chinese 258
829 Heuksal Chinese 258
853 Heuksal Chinese 258
885 Heuksal Chinese 258
925 Heuksal Chinese 258
933 Heuksal Chinese 258
943 Heuksal Chinese 258
3167 Heuksal Chinese 258
3176 Heuksal Chinese 258
3224 Heuksal Chinese 258
7536 Heuksal Chinese 258
7554 Heuksal Chinese 258
7577 Heuksal Chinese 258
7582 Heuksal Chinese 258
7584 Heuksal Chinese 258
7596 Heuksal Chinese 258
7612 Heuksal Chinese 258
7637 Heuksal Chinese 258
7651 Heuksal Chinese 258
7672 Heuksal Chinese 258
7675 Heuksal Chinese 258
7688 Heuksal Chinese 258
7798 Heuksal Chinese 258
7805 Heuksal Chinese 258
952 Pacheon Chinese 259
960 Pacheon Chinese 259
968 Pacheon Chinese 259
976 Pacheon Chinese 259
984 Pacheon Chinese 259
992 Pacheon Chinese 259
1003 Pacheon Chinese 259
1014 Pacheon Chinese 259
1025 Pacheon Chinese 259
1033 Pacheon Chinese 259
1041 Pacheon Chinese 259
1049 Pacheon Chinese 259
1053 Pacheon Chinese 259
1057 Pacheon Chinese 259
1065 Pacheon Chinese 259
1073 Pacheon Chinese 259
1081 Pacheon Chinese 259
1089 Pacheon Chinese 259
1099 Pacheon Chinese 259
3340 Pacheon Chinese 259
3349 Pacheon Chinese 259
7829 Pacheon Chinese 259
7838 Pacheon Chinese 259
7839 Pacheon Chinese 259
7853 Pacheon Chinese 259
7862 Pacheon Chinese 259
7877 Pacheon Chinese 259
7881 Pacheon Chinese 259
7894 Pacheon Chinese 259
7899 Pacheon Chinese 259
7907 Pacheon Chinese 259
7919 Pacheon Chinese 259
7931 Pacheon Chinese 259
7938 Pacheon Chinese 259
7947 Pacheon Chinese 259
7953 Pacheon Chinese 259
7959 Pacheon Chinese 259
7962 Pacheon Chinese 259
1108 Cold Chinese 273
1116 Cold Chinese 273
1124 Cold Chinese 273
1132 Cold Chinese 273
1140 Cold Chinese 273
1148 Cold Chinese 273
1153 Cold Chinese 273
1158 Cold Chinese 273
1163 Cold Chinese 273
1168 Cold Chinese 273
1173 Cold Chinese 273
1178 Cold Chinese 273
1189 Cold Chinese 273
1200 Cold Chinese 273
1217 Cold Chinese 273
1234 Cold Chinese 273
1244 Cold Chinese 273
3364 Cold Chinese 273
3379 Cold Chinese 273
3391 Cold Chinese 273
7972 Cold Chinese 273
7980 Cold Chinese 273
7995 Cold Chinese 273
7997 Cold Chinese 273
8010 Cold Chinese 273
8024 Cold Chinese 273
8050 Cold Chinese 273
8084 Cold Chinese 273
8097 Cold Chinese 273
8103 Cold Chinese 273
8109 Cold Chinese 273
8115 Cold Chinese 273
8119 Cold Chinese 273
1253 Lightning Chinese 274
1261 Lightning Chinese 274
1269 Lightning Chinese 274
1271 Lightning Chinese 274
1273 Lightning Chinese 274
1275 Lightning Chinese 274
1286 Lightning Chinese 274
1297 Lightning Chinese 274
1308 Lightning Chinese 274
1316 Lightning Chinese 274
1324 Lightning Chinese 274
1332 Lightning Chinese 274
1337 Lightning Chinese 274
1342 Lightning Chinese 274
1350 Lightning Chinese 274
1358 Lightning Chinese 274
1368 Lightning Chinese 274
3406 Lightning Chinese 274
3409 Lightning Chinese 274
3415 Lightning Chinese 274
8129 Lightning Chinese 274
8133 Lightning Chinese 274
8141 Lightning Chinese 274
8150 Lightning Chinese 274
8164 Lightning Chinese 274
8171 Lightning Chinese 274
8183 Lightning Chinese 274
8195 Lightning Chinese 274
8204 Lightning Chinese 274
1377 Fire Chinese 275
1385 Fire Chinese 275
1393 Fire Chinese 275
1398 Fire Chinese 275
1403 Fire Chinese 275
1408 Fire Chinese 275
1410 Fire Chinese 275
1412 Fire Chinese 275
1414 Fire Chinese 275
1422 Fire Chinese 275
1430 Fire Chinese 275
1438 Fire Chinese 275
1443 Fire Chinese 275
1448 Fire Chinese 275
1465 Fire Chinese 275
1482 Fire Chinese 275
1499 Fire Chinese 275
1509 Fire Chinese 275
3430 Fire Chinese 275
3435 Fire Chinese 275
3446 Fire Chinese 275
8214 Fire Chinese 275
8220 Fire Chinese 275
8221 Fire Chinese 275
8238 Fire Chinese 275
8239 Fire Chinese 275
8250 Fire Chinese 275
8253 Fire Chinese 275
8276 Fire Chinese 275
8291 Fire Chinese 275
8304 Fire Chinese 275
8316 Fire Chinese 275
8320 Fire Chinese 275
21215 Fire Chinese 275
21217 Fire Chinese 275
1518 Force Chinese 276
1526 Force Chinese 276
1534 Force Chinese 276
1539 Force Chinese 276
1544 Force Chinese 276
1549 Force Chinese 276
1557 Force Chinese 276
1565 Force Chinese 276
1573 Force Chinese 276
1578 Force Chinese 276
1583 Force Chinese 276
1588 Force Chinese 276
1593 Force Chinese 276
1598 Force Chinese 276
1609 Force Chinese 276
1617 Force Chinese 276
1628 Force Chinese 276
3461 Force Chinese 276
3467 Force Chinese 276
3473 Force Chinese 276
8338 Force Chinese 276
8347 Force Chinese 276
8348 Force Chinese 276
8361 Force Chinese 276
8370 Force Chinese 276
8379 Force Chinese 276
8383 Force Chinese 276
8390 Force Chinese 276
8399 Force Chinese 276
8405 Force Chinese 276
8410 Force Chinese 276
8414 Force Chinese 276
8416 Force Chinese 276
20494 Force Chinese 276
20497 Force Chinese 276
20500 Force Chinese 276
11978 Cleric European 518
11982 Cleric European 518
11993 Cleric European 518
11995 Cleric European 518
21213 Fire Chinese 275 Mastery Scroll - Google Drive
Password: STORXY
شكرا وبكده يكون خلصانا النهردا كدا والموضوع ان شاء الله هيكون متححدث بستمرار اخرتحديث (21-6-2017)
تعليقات
إرسال تعليق