لاقيت فى ناس كتير لحد دلوقتي مش عارفة تشغل ال Model Switcher Scroll
فقولت انزلكو شرح كامل ليها هنا
فكرة الاسكرول ودي لازم تقراها كويس
الفكرة ان الاسكرول دي ليها بروسيودر بيحول الايتم من ID ل ID ايتم تاني
بمعني انك عاوز تعمل الاسكرول دي مثلا تشتغل علي ال DG 10 EU/CH
هتروح علي ال _RfObjCommon وتجيب السطور بتاعة الدجري 10 كلو وتجيب السطور بتاعتو من _REFobjItem ومن هنا بتبدي الشغل بقا
هتقولى مثلا مش بعرف اجيب السطور من الدات هقولك سهلة
استخدم الكويري دا عشان تجيب بيه سطور ال _RefObjCommon
كود PHP:
USE SRO_VT_SHARD
SELECT * from _RefObjCommon Where CodeName128 like 'ITEM_EU_TSTAFF_10_C_RARE'
ودا عشان تجيب السطر بتاع السلاح من ال _refObjItem
كود PHP:
USE SRO_VT_SHARD
SELECT * from _RefObjItem Where ID like '6953'
طبعا انت عارف ان ال id بتاع REFOBJITEM هوا اللي بيبقا موجود فخانة link ف ال REFOBJCOMMON
ولو مش عارف يبقا اقفل الموضوع ولا كانك شوفتو
كدا انت بقا معاك سطور ال D10 الاصليه يعني فيه الاستات الصح كلو Phy/Dmg/Crit
تمام هنعمل نسخة تانيه منهم // يعني هناخد سطور ال (Common/Item) ونعمل بيهم نسخة تانيه عن طريق تعديل كود الايتم
مثال كود ال Staff مثلا
كود:
ITEM_EU_TSTAFF_10_C_RARE
ITEM_EU_TSTAFF_10_C_RARE_D1
كدا احنا عدلنا علي الكود ,, نعدل بقا علي شكل السلاح .. هتروح علي ال Line بتاع _RefObjCommon اللي احنا لسا عاملينو دا وهتغير خانة الشكل هنلاقي مكتوب فيها كدا
كود:
item\europe\shield\shield_10.bsr
هنغيرو لكدا عشان يبقا شكل الدجري 1 مثلا
item\europe\shield\shield_01.bsr
وعشان تجيب السطور بتاعة الميديا للايتم الجديد اللي بمعني اصح هتحطهم ف Itemdata_XXX hsjo استخدم الكويري دي
كود:
USE [SRO_VT_SHARD]
exec _GetMediaLines
@Type=1,
@CodeName='%ITEM%_%_%10_C_RARE_D%'
وهكذا مع كل الايتم اللي عاوز يشتغل عليها السيستم دا
نيجي بقا للجزء الاهم
Database/Media
سطور الاسكرولاية
كود PHP:
-------------------------------------------------------------------------
RefObjCommon_
-------------------------------------------------------------------------
1 63630 ITEM_ITEM_MULTI_MODEL_01 ????? xxx SN_ITEM_MULTI_MODEL_01 SN_ITEM_MULTI_MODEL_01_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 90 -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\vortex\model_d1.ddj xxx xxx 33654
1 63631 ITEM_ITEM_MULTI_MODEL_02 ????? xxx SN_ITEM_MULTI_MODEL_02 SN_ITEM_MULTI_MODEL_02_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 90 -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\vortex\model_d2.ddj xxx xxx 33655
1 63632 ITEM_ITEM_MULTI_MODEL_03 ????? xxx SN_ITEM_MULTI_MODEL_03 SN_ITEM_MULTI_MODEL_03_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 90 -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\vortex\model_d3.ddj xxx xxx 33656
1 63633 ITEM_ITEM_MULTI_MODEL_04 ????? xxx SN_ITEM_MULTI_MODEL_04 SN_ITEM_MULTI_MODEL_04_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 90 -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\vortex\model_d4.ddj xxx xxx 33657
1 63634 ITEM_ITEM_MULTI_MODEL_05 ????? xxx SN_ITEM_MULTI_MODEL_05 SN_ITEM_MULTI_MODEL_05_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 90 -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\vortex\model_d5.ddj xxx xxx 33658
1 63635 ITEM_ITEM_MULTI_MODEL_06 ????? xxx SN_ITEM_MULTI_MODEL_06 SN_ITEM_MULTI_MODEL_06_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 90 -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\vortex\model_d6.ddj xxx xxx 33659
1 63636 ITEM_ITEM_MULTI_MODEL_07 ????? xxx SN_ITEM_MULTI_MODEL_07 SN_ITEM_MULTI_MODEL_07_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 90 -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\vortex\model_d7.ddj xxx xxx 33660
1 63637 ITEM_ITEM_MULTI_MODEL_08 ????? xxx SN_ITEM_MULTI_MODEL_08 SN_ITEM_MULTI_MODEL_08_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 90 -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\vortex\model_d8.ddj xxx xxx 33661
1 63638 ITEM_ITEM_MULTI_MODEL_09 ????? xxx SN_ITEM_MULTI_MODEL_09 SN_ITEM_MULTI_MODEL_09_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 90 -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\vortex\model_d9.ddj xxx xxx 33662
1 63639 ITEM_ITEM_MULTI_MODEL_10 ????? xxx SN_ITEM_MULTI_MODEL_10 SN_ITEM_MULTI_MODEL_10_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 90 -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\vortex\model_d10.ddj xxx xxx 33663
1 63640 ITEM_ITEM_MULTI_MODEL_11 ????? xxx SN_ITEM_MULTI_MODEL_11 SN_ITEM_MULTI_MODEL_11_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 90 -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\vortex\model_d11.ddj xxx xxx 33664
1 63641 ITEM_ITEM_MULTI_MODEL_12 ????? xxx SN_ITEM_MULTI_MODEL_12 SN_ITEM_MULTI_MODEL_12_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 90 -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\vortex\model_d12.ddj xxx xxx 33665
-------------------------------------------------------------------------
RefObjItem_
-------------------------------------------------------------------------
33654 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
33655 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
33656 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
33657 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
33658 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
33659 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
33660 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
33661 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
33662 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
33663 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
33664 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
33665 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
Media Side
-------------------------------------------------------------------------
Itemdata_45000
-------------------------------------------------------------------------
1 63630 ITEM_ITEM_MULTI_MODEL_01 ????? xxx SN_ITEM_MULTI_MODEL_01 SN_ITEM_MULTI_MODEL_01_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 90 -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\vortex\model_d1.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 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
1 63631 ITEM_ITEM_MULTI_MODEL_02 ????? xxx SN_ITEM_MULTI_MODEL_02 SN_ITEM_MULTI_MODEL_02_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 90 -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\vortex\model_d2.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 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
1 63632 ITEM_ITEM_MULTI_MODEL_03 ????? xxx SN_ITEM_MULTI_MODEL_03 SN_ITEM_MULTI_MODEL_03_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 90 -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\vortex\model_d3.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 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
1 63633 ITEM_ITEM_MULTI_MODEL_04 ????? xxx SN_ITEM_MULTI_MODEL_04 SN_ITEM_MULTI_MODEL_04_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 90 -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\vortex\model_d4.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 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
1 63634 ITEM_ITEM_MULTI_MODEL_05 ????? xxx SN_ITEM_MULTI_MODEL_05 SN_ITEM_MULTI_MODEL_05_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 90 -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\vortex\model_d5.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 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
1 63635 ITEM_ITEM_MULTI_MODEL_06 ????? xxx SN_ITEM_MULTI_MODEL_06 SN_ITEM_MULTI_MODEL_06_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 90 -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\vortex\model_d6.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 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
1 63636 ITEM_ITEM_MULTI_MODEL_07 ????? xxx SN_ITEM_MULTI_MODEL_07 SN_ITEM_MULTI_MODEL_07_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 90 -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\vortex\model_d7.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 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
1 63637 ITEM_ITEM_MULTI_MODEL_08 ????? xxx SN_ITEM_MULTI_MODEL_08 SN_ITEM_MULTI_MODEL_08_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 90 -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\vortex\model_d8.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 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
1 63638 ITEM_ITEM_MULTI_MODEL_09 ????? xxx SN_ITEM_MULTI_MODEL_09 SN_ITEM_MULTI_MODEL_09_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 90 -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\vortex\model_d9.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 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
1 63639 ITEM_ITEM_MULTI_MODEL_10 ????? xxx SN_ITEM_MULTI_MODEL_10 SN_ITEM_MULTI_MODEL_10_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 90 -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\vortex\model_d10.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 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
1 63640 ITEM_ITEM_MULTI_MODEL_11 ????? xxx SN_ITEM_MULTI_MODEL_11 SN_ITEM_MULTI_MODEL_11_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 90 -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\vortex\model_d11.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 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
1 63641 ITEM_ITEM_MULTI_MODEL_12 ????? xxx SN_ITEM_MULTI_MODEL_12 SN_ITEM_MULTI_MODEL_12_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 90 -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\vortex\model_d12.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 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
-------------------------------------------------------------------------
Textdata_object
-------------------------------------------------------------------------
1 SN_ITEM_MULTI_MODEL_01 Model Switcher 1Dg
1 SN_ITEM_MULTI_MODEL_02 Model Switcher 2Dg
1 SN_ITEM_MULTI_MODEL_03 Model Switcher 3Dg
1 SN_ITEM_MULTI_MODEL_04 Model Switcher 4Dg
1 SN_ITEM_MULTI_MODEL_05 Model Switcher 5Dg
1 SN_ITEM_MULTI_MODEL_06 Model Switcher 6Dg
1 SN_ITEM_MULTI_MODEL_07 Model Switcher 7Dg
1 SN_ITEM_MULTI_MODEL_08 Model Switcher 8Dg
1 SN_ITEM_MULTI_MODEL_09 Model Switcher 9Dg
1 SN_ITEM_MULTI_MODEL_10 Model Switcher 10Dg
1 SN_ITEM_MULTI_MODEL_11 Model Switcher 11Dg
1 SN_ITEM_MULTI_MODEL_12 Model Switcher 12Dg
1 SN_ITEM_MULTI_MODEL_01_TT_DESC <sml2>Using this scroll, you will be able to switch the model "the look" of any custom items (equipment) to a specific degrees model.<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Place any item into your inventories first slot.<br>Activate this scroll.<br><br><strong><font color="255,236,219,156">Model</font></strong><br>First Degree<br><br><strong><font color="255,236,219,156">Notice:</font></strong><br>This item works on DG[10] items only.</sml2>
1 SN_ITEM_MULTI_MODEL_02_TT_DESC <sml2>Using this scroll, you will be able to switch the model "the look" of any custom items (equipment) to a specific degrees model.<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Place any item into your inventories first slot.<br>Activate this scroll.<br><br><strong><font color="255,236,219,156">Model</font></strong><br>Second Degree<br><strong><font color="255,236,219,156">Notice:</font></strong><br>This item works on DG[10] items only.</sml2>
1 SN_ITEM_MULTI_MODEL_03_TT_DESC <sml2>Using this scroll, you will be able to switch the model "the look" of any custom items (equipment) to a specific degrees model.<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Place any item into your inventories first slot.<br>Activate this scroll.<br><br><strong><font color="255,236,219,156">Model</font></strong><br>Third Degree<br><strong><font color="255,236,219,156">Notice:</font></strong><br>This item works on DG[10] items only.</sml2>
1 SN_ITEM_MULTI_MODEL_04_TT_DESC <sml2>Using this scroll, you will be able to switch the model "the look" of any custom items (equipment) to a specific degrees model.<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Place any item into your inventories first slot.<br>Activate this scroll.<br><br><strong><font color="255,236,219,156">Model</font></strong><br>Fourth Degree<br><strong><font color="255,236,219,156">Notice:</font></strong><br>This item works on DG[10] items only.</sml2>
1 SN_ITEM_MULTI_MODEL_05_TT_DESC <sml2>Using this scroll, you will be able to switch the model "the look" of any custom items (equipment) to a specific degrees model.<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Place any item into your inventories first slot.<br>Activate this scroll.<br><br><strong><font color="255,236,219,156">Model</font></strong><br>Fifth Degree<br><strong><font color="255,236,219,156">Notice:</font></strong><br>This item works on DG[10] items only.</sml2>
1 SN_ITEM_MULTI_MODEL_06_TT_DESC <sml2>Using this scroll, you will be able to switch the model "the look" of any custom items (equipment) to a specific degrees model.<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Place any item into your inventories first slot.<br>Activate this scroll.<br><br><strong><font color="255,236,219,156">Model</font></strong><br>Sixth Degree<br><strong><font color="255,236,219,156">Notice:</font></strong><br>This item works on DG[10] items only.</sml2>
1 SN_ITEM_MULTI_MODEL_07_TT_DESC <sml2>Using this scroll, you will be able to switch the model "the look" of any custom items (equipment) to a specific degrees model.<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Place any item into your inventories first slot.<br>Activate this scroll.<br><br><strong><font color="255,236,219,156">Model</font></strong><br>Seventh Degree<br><strong><font color="255,236,219,156">Notice:</font></strong><br>This item works on DG[10] items only.</sml2>
1 SN_ITEM_MULTI_MODEL_08_TT_DESC <sml2>Using this scroll, you will be able to switch the model "the look" of any custom items (equipment) to a specific degrees model.<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Place any item into your inventories first slot.<br>Activate this scroll.<br><br><strong><font color="255,236,219,156">Model</font></strong><br>Eighth Degree<br><strong><font color="255,236,219,156">Notice:</font></strong><br>This item works on DG[10] items only.</sml2>
1 SN_ITEM_MULTI_MODEL_09_TT_DESC <sml2>Using this scroll, you will be able to switch the model "the look" of any custom items (equipment) to a specific degrees model.<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Place any item into your inventories first slot.<br>Activate this scroll.<br><br><strong><font color="255,236,219,156">Model</font></strong><br>Ninth Degree<br><strong><font color="255,236,219,156">Notice:</font></strong><br>This item works on DG[10] items only.</sml2>
1 SN_ITEM_MULTI_MODEL_10_TT_DESC <sml2>Using this scroll, you will be able to switch the model "the look" of any custom items (equipment) to a specific degrees model.<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Place any item into your inventories first slot.<br>Activate this scroll.<br><br><strong><font color="255,236,219,156">Model</font></strong><br>Tenth Degree<br><strong><font color="255,236,219,156">Notice:</font></strong><br>This item works on DG[10] items only.</sml2>
1 SN_ITEM_MULTI_MODEL_11_TT_DESC <sml2>Using this scroll, you will be able to switch the model "the look" of any custom items (equipment) to a specific degrees model.<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Place any item into your inventories first slot.<br>Activate this scroll.<br><br><strong><font color="255,236,219,156">Model</font></strong><br>Eleventh Degree<br><strong><font color="255,236,219,156">Notice:</font></strong><br>This item works on DG[10] items only.</sml2>
1 SN_ITEM_MULTI_MODEL_12_TT_DESC <sml2>Using this scroll, you will be able to switch the model "the look" of any custom items (equipment) to a specific degrees model.<br><br><strong><font color="255,236,219,156">How To Use</font></strong><br>Place any item into your inventories first slot.<br>Activate this scroll.<br><br><strong><font color="255,236,219,156">Model</font></strong><br>Twelfth Degree<br><strong><font color="255,236,219,156">Notice:</font></strong><br>This item works on DG[10] items only.</sml2>
دا البروسيودر هتفتح NewQurey وهتعملو Execute علطول
كود PHP:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_ModelSwitcher] Script Date: 3/31/2016 7:36:27 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[_ModelSwitcher]
@CharID int,
@ItemRefID int
AS
DECLARE @ItemID int
,@RefItemID int
,@DG int
,@NoItem int
,@Color varchar(50)
,@GEN varchar(50)
,@RARET VARCHAR(50)
,@T1 tinyint
,@T2 tinyint
,@T3 tinyint
,@T4 tinyint
SELECT @DG = CASE WHEN @ItemRefID = '63630' THEN '1' --------1=Degree Number
WHEN @ItemRefID = '63631' THEN '2' ---63630 = Scroll id
WHEN @ItemRefID = '63632' THEN '3'
WHEN @ItemRefID = '63633' THEN '4'
WHEN @ItemRefID = '63634' THEN '5'
WHEN @ItemRefID = '63635' THEN '6'
WHEN @ItemRefID = '63636' THEN '7'
WHEN @ItemRefID = '63637' THEN '8'
WHEN @ItemRefID = '63638' THEN '9'
WHEN @ItemRefID = '63639' THEN '10'
WHEN @ItemRefID = '63640' THEN '11'
WHEN @ItemRefID = '63641' THEN '12'
ELSE NULL END
SELECT @ItemID=I.ID64 , @RefItemID = I.RefItemID
FROM SRO_VT_SHARD.dbo._Items I INNER JOIN SRO_Vt_SHARD.dbo._Inventory Iv
ON I.ID64 = Iv.ItemID
WHERE Iv.Slot = '13' AND Iv.CharID = @CharID
-- First item
SELECT @T1 = TypeID1 , @T2 = TypeID2 , @T3 = TypeID3 , @T4 = TypeID4 ,@Color = Color , @GEN = Gender , @RareT = RareT
FROM SRO_VT_SHARDLOG.dbo._ModelSwitchers WHERE ID = @RefItemID
-- Second item
SELECT TOP 1 @NoItem = ID FROM SRO_VT_SHARDLOG.dbo._ModelSwitchers
WHERE TypeID1 = @T1
AND TypeID2 = @T2
AND TypeID3 = @T3
AND TypeID4 = @T4
AND Color = @Color
AND DG = @DG
AND Gender = @GEN
AND RareT = @RareT
-- Upcating
UPDATE SRO_VT_SHARD.dbo._Items SET RefItemID = @NoItem WHERE ID64 = @ItemID
بعد كدا هتروح علي SRO_VT_SHARDLOG وتروح علي AddlogItem
وتحط فيها دا
كود PHP:
/*Mod Switcher*/
IF @ItemRefID BETWEEN '63630' and '63641' AND @Operation = '41'
BEGIN EXEC SRO_VT_SHARDLOG.dbo._ModelSwitcher @CharId, @ItemRefID
END
63630 دا اول كود للاسكرولات اللي هتضيفها عشان تضربها وتغيرلك شكل الايتم او السلاح 63641 دا اخر id لاسكرولات الموديل
اخر حاجة ال Table اللى الاسكرولايه هتجيب منو الايتم اللي انت بتغيرو
كود PHP:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: Table [dbo].[_ModelSwitchers] Script Date: 4/1/2016 3:13:24 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_ModelSwitchers](
[ID] [int] NOT NULL,
[CodeName] [varchar](128) NULL,
[TypeID1] [int] NULL,
[TypeID2] [int] NULL,
[TypeID3] [int] NULL,
[TypeID4] [int] NULL,
[Color] [varchar](50) NULL,
[RareT] [varchar](16) NULL,
[DG] [int] NULL,
[Gender] [varchar](50) NULL,
CONSTRAINT [PK__ModSwitch] 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
نشرحلكو بقا بيعمل ايه ال Table دا
اولا بتضيف اكواد الايتم الاصلي اللي هيتعملها Switch
1 = ID الايتم ف ال _RefObjCommon
2= TypeID4 دا كود تمييز للتفرقة بين الاسلحة يعني بمعني اصح كل سلاح وليه رقم وهديكم مثال التابل بتاعي كلو دلوقتي
3=دا ال Rarity بتاع الايتم لو نورمال اكتب نورمال لو A_RARE تبقا Nova لو C_RARE تبق Sun
4=dg الايتم اللي انت ضايف الكود بتاعها هنا والدجري هنا يقصد بيه شكل الدجريي يعني وبرضو المثال هيوضح اكتر
5= دي لو انت ضايف فيها ال Set لو Male h او Female
وادي ال Table بتاعي اهو عشان لو حد لسا مش فاهم
كود PHP:
4043 ITEM_CH_SWORD_10_C_RARE 3 1 6 2 NORMAL SUN 10 USELSS
4079 ITEM_CH_BLADE_10_C_RARE 3 1 6 3 NORMAL SUN 10 USELSS
4115 ITEM_CH_SPEAR_10_C_RARE 3 1 6 4 NORMAL SUN 10 USELSS
4151 ITEM_CH_TBLADE_10_C_RARE 3 1 6 5 NORMAL SUN 10 USELSS
4187 ITEM_CH_BOW_10_C_RARE 3 1 6 6 NORMAL SUN 10 USELSS
4223 ITEM_CH_SHIELD_10_C_RARE 3 1 4 1 NORMAL SUN 10 USELSS
11250 ITEM_EU_DAGGER_10_C_RARE 3 1 6 13 NORMAL SUN 10 USELSS
11286 ITEM_EU_SWORD_10_C_RARE 3 1 6 7 NORMAL SUN 10 USELSS
11322 ITEM_EU_TSWORD_10_C_RARE 3 1 6 8 NORMAL SUN 10 USELSS
11358 ITEM_EU_AXE_10_C_RARE 3 1 6 9 NORMAL SUN 10 USELSS
11394 ITEM_EU_CROSSBOW_10_C_RARE 3 1 6 12 NORMAL SUN 10 USELSS
11430 ITEM_EU_DARKSTAFF_10_C_RARE 3 1 6 10 NORMAL SUN 10 USELSS
11466 ITEM_EU_TSTAFF_10_C_RARE 3 1 6 11 NORMAL SUN 10 USELSS
11502 ITEM_EU_HARP_10_C_RARE 3 1 6 14 NORMAL SUN 10 USELSS
11538 ITEM_EU_STAFF_10_C_RARE 3 1 6 15 NORMAL SUN 10 USELSS
11610 ITEM_EU_SHIELD_10_C_RARE 3 1 4 2 NORMAL SUN 10 USELSS
405695 ITEM_CH_SWORD_10_C_13_VORTEX 3 1 6 2 NORMAL SUN 13 USELSS
405696 ITEM_CH_BLADE_10_C_13_VORTEX 3 1 6 3 NORMAL SUN 13 USELSS
405697 ITEM_CH_SPEAR_10_C_13_VORTEX 3 1 6 4 NORMAL SUN 13 USELSS
405698 ITEM_CH_TBLADE_10_C_13_VORTEX 3 1 6 5 NORMAL SUN 13 USELSS
405699 ITEM_CH_BOW_10_C_13_VORTEX 3 1 6 6 NORMAL SUN 13 USELSS
405700 ITEM_CH_SHIELD_10_C_13_VORTEX 3 1 4 1 NORMAL SUN 13 USELSS
405701 ITEM_EU_DAGGER_10_C_13_VORTEX 3 1 6 13 NORMAL SUN 13 USELSS
405702 ITEM_EU_SWORD_10_C_13_VORTEX 3 1 6 7 NORMAL SUN 13 USELSS
405703 ITEM_EU_TSWORD_10_C_13_VORTEX 3 1 6 8 NORMAL SUN 13 USELSS
405704 ITEM_EU_AXE_10_C_13_VORTEX 3 1 6 9 NORMAL SUN 13 USELSS
405705 ITEM_EU_CROSSBOW_10_C_13_VORTEX 3 1 6 12 NORMAL SUN 13 USELSS
405706 ITEM_EU_DARKSTAFF_10_C_13_VORTEX 3 1 6 10 NORMAL SUN 13 USELSS
405707 ITEM_EU_TSTAFF_10_C_13_VORTEX 3 1 6 11 NORMAL SUN 13 USELSS
405708 ITEM_EU_HARP_10_C_13_VORTEX 3 1 6 14 NORMAL SUN 13 USELSS
405709 ITEM_EU_STAFF_10_C_13_VORTEX 3 1 6 15 NORMAL SUN 13 USELSS
405710 ITEM_EU_SHIELD_10_C_13_VORTEX 3 1 4 2 NORMAL SUN 13 USELSS
406695 ITEM_CH_SWORD_10_C_1_VORTEX 3 1 6 2 NORMAL SUN 1 USELSS
406696 ITEM_CH_BLADE_10_C_1_VORTEX 3 1 6 3 NORMAL SUN 1 USELSS
406697 ITEM_CH_SPEAR_10_C_1_VORTEX 3 1 6 4 NORMAL SUN 1 USELSS
406698 ITEM_CH_TBLADE_10_C_1_VORTEX 3 1 6 5 NORMAL SUN 1 USELSS
406699 ITEM_CH_BOW_10_C_1_VORTEX 3 1 6 6 NORMAL SUN 1 USELSS
406700 ITEM_CH_SHIELD_10_C_1_VORTEX 3 1 4 1 NORMAL SUN 1 USELSS
406701 ITEM_EU_DAGGER_10_C_1_VORTEX 3 1 6 13 NORMAL SUN 1 USELSS
406702 ITEM_EU_SWORD_10_C_1_VORTEX 3 1 6 7 NORMAL SUN 1 USELSS
406703 ITEM_EU_TSWORD_10_C_1_VORTEX 3 1 6 8 NORMAL SUN 1 USELSS
406704 ITEM_EU_AXE_10_C_1_VORTEX 3 1 6 9 NORMAL SUN 1 USELSS
406705 ITEM_EU_CROSSBOW_10_C_1_VORTEX 3 1 6 12 NORMAL SUN 1 USELSS
406706 ITEM_EU_DARKSTAFF_10_C_1_VORTEX 3 1 6 10 NORMAL SUN 1 USELSS
406707 ITEM_EU_TSTAFF_10_C_1_VORTEX 3 1 6 11 NORMAL SUN 1 USELSS
406708 ITEM_EU_HARP_10_C_1_VORTEX 3 1 6 14 NORMAL SUN 1 USELSS
406709 ITEM_EU_STAFF_10_C_1_VORTEX 3 1 6 15 NORMAL SUN 1 USELSS
406710 ITEM_EU_SHIELD_10_C_1_VORTEX 3 1 4 2 NORMAL SUN 1 USELSS
406711 ITEM_CH_SWORD_10_C_2_VORTEX 3 1 6 2 NORMAL SUN 2 USELSS
406712 ITEM_CH_BLADE_10_C_2_VORTEX 3 1 6 3 NORMAL SUN 2 USELSS
406713 ITEM_CH_SPEAR_10_C_2_VORTEX 3 1 6 4 NORMAL SUN 2 USELSS
406714 ITEM_CH_TBLADE_10_C_2_VORTEX 3 1 6 5 NORMAL SUN 2 USELSS
406715 ITEM_CH_BOW_10_C_2_VORTEX 3 1 6 6 NORMAL SUN 2 USELSS
406716 ITEM_CH_SHIELD_10_C_2_VORTEX 3 1 4 1 NORMAL SUN 2 USELSS
406717 ITEM_EU_DAGGER_10_C_2_VORTEX 3 1 6 13 NORMAL SUN 2 USELSS
406718 ITEM_EU_SWORD_10_C_2_VORTEX 3 1 6 7 NORMAL SUN 2 USELSS
406719 ITEM_EU_TSWORD_10_C_2_VORTEX 3 1 6 8 NORMAL SUN 2 USELSS
406720 ITEM_EU_AXE_10_C_2_VORTEX 3 1 6 9 NORMAL SUN 2 USELSS
406721 ITEM_EU_CROSSBOW_10_C_2_VORTEX 3 1 6 12 NORMAL SUN 2 USELSS
406722 ITEM_EU_DARKSTAFF_10_C_2_VORTEX 3 1 6 10 NORMAL SUN 2 USELSS
406723 ITEM_EU_TSTAFF_10_C_2_VORTEX 3 1 6 11 NORMAL SUN 2 USELSS
406724 ITEM_EU_HARP_10_C_2_VORTEX 3 1 6 14 NORMAL SUN 2 USELSS
406725 ITEM_EU_STAFF_10_C_2_VORTEX 3 1 6 15 NORMAL SUN 2 USELSS
406726 ITEM_EU_SHIELD_10_C_2_VORTEX 3 1 4 2 NORMAL SUN 2 USELSS
406727 ITEM_CH_SWORD_10_C_3_VORTEX 3 1 6 2 NORMAL SUN 3 USELSS
406728 ITEM_CH_BLADE_10_C_3_VORTEX 3 1 6 3 NORMAL SUN 3 USELSS
406729 ITEM_CH_SPEAR_10_C_3_VORTEX 3 1 6 4 NORMAL SUN 3 USELSS
406730 ITEM_CH_TBLADE_10_C_3_VORTEX 3 1 6 5 NORMAL SUN 3 USELSS
406731 ITEM_CH_BOW_10_C_3_VORTEX 3 1 6 6 NORMAL SUN 3 USELSS
406732 ITEM_CH_SHIELD_10_C_3_VORTEX 3 1 4 1 NORMAL SUN 3 USELSS
406733 ITEM_EU_DAGGER_10_C_3_VORTEX 3 1 6 13 NORMAL SUN 3 USELSS
406734 ITEM_EU_SWORD_10_C_3_VORTEX 3 1 6 7 NORMAL SUN 3 USELSS
406735 ITEM_EU_TSWORD_10_C_3_VORTEX 3 1 6 8 NORMAL SUN 3 USELSS
406736 ITEM_EU_AXE_10_C_3_VORTEX 3 1 6 9 NORMAL SUN 3 USELSS
406737 ITEM_EU_CROSSBOW_10_C_3_VORTEX 3 1 6 12 NORMAL SUN 3 USELSS
406738 ITEM_EU_DARKSTAFF_10_C_3_VORTEX 3 1 6 10 NORMAL SUN 3 USELSS
406739 ITEM_EU_TSTAFF_10_C_3_VORTEX 3 1 6 11 NORMAL SUN 3 USELSS
406740 ITEM_EU_HARP_10_C_3_VORTEX 3 1 6 14 NORMAL SUN 3 USELSS
406741 ITEM_EU_STAFF_10_C_3_VORTEX 3 1 6 15 NORMAL SUN 3 USELSS
406742 ITEM_EU_SHIELD_10_C_3_VORTEX 3 1 4 2 NORMAL SUN 3 USELSS
406743 ITEM_CH_SWORD_10_C_4_VORTEX 3 1 6 2 NORMAL SUN 4 USELSS
406744 ITEM_CH_BLADE_10_C_4_VORTEX 3 1 6 3 NORMAL SUN 4 USELSS
406745 ITEM_CH_SPEAR_10_C_4_VORTEX 3 1 6 4 NORMAL SUN 4 USELSS
406746 ITEM_CH_TBLADE_10_C_4_VORTEX 3 1 6 5 NORMAL SUN 4 USELSS
406747 ITEM_CH_BOW_10_C_4_VORTEX 3 1 6 6 NORMAL SUN 4 USELSS
406748 ITEM_CH_SHIELD_10_C_4_VORTEX 3 1 4 1 NORMAL SUN 4 USELSS
406749 ITEM_EU_DAGGER_10_C_4_VORTEX 3 1 6 13 NORMAL SUN 4 USELSS
406750 ITEM_EU_SWORD_10_C_4_VORTEX 3 1 6 7 NORMAL SUN 4 USELSS
406751 ITEM_EU_TSWORD_10_C_4_VORTEX 3 1 6 8 NORMAL SUN 4 USELSS
406752 ITEM_EU_AXE_10_C_4_VORTEX 3 1 6 9 NORMAL SUN 4 USELSS
406753 ITEM_EU_CROSSBOW_10_C_4_VORTEX 3 1 6 12 NORMAL SUN 4 USELSS
406754 ITEM_EU_DARKSTAFF_10_C_4_VORTEX 3 1 6 10 NORMAL SUN 4 USELSS
406755 ITEM_EU_TSTAFF_10_C_4_VORTEX 3 1 6 11 NORMAL SUN 4 USELSS
406756 ITEM_EU_HARP_10_C_4_VORTEX 3 1 6 14 NORMAL SUN 4 USELSS
406757 ITEM_EU_STAFF_10_C_4_VORTEX 3 1 6 15 NORMAL SUN 4 USELSS
406758 ITEM_EU_SHIELD_10_C_4_VORTEX 3 1 4 2 NORMAL SUN 4 USELSS
406759 ITEM_CH_SWORD_10_C_5_VORTEX 3 1 6 2 NORMAL SUN 5 USELSS
406760 ITEM_CH_BLADE_10_C_5_VORTEX 3 1 6 3 NORMAL SUN 5 USELSS
406761 ITEM_CH_SPEAR_10_C_5_VORTEX 3 1 6 4 NORMAL SUN 5 USELSS
406762 ITEM_CH_TBLADE_10_C_5_VORTEX 3 1 6 5 NORMAL SUN 5 USELSS
406763 ITEM_CH_BOW_10_C_5_VORTEX 3 1 6 6 NORMAL SUN 5 USELSS
406764 ITEM_CH_SHIELD_10_C_5_VORTEX 3 1 4 1 NORMAL SUN 5 USELSS
406765 ITEM_EU_DAGGER_10_C_5_VORTEX 3 1 6 13 NORMAL SUN 5 USELSS
406766 ITEM_EU_SWORD_10_C_5_VORTEX 3 1 6 7 NORMAL SUN 5 USELSS
406767 ITEM_EU_TSWORD_10_C_5_VORTEX 3 1 6 8 NORMAL SUN 5 USELSS
406768 ITEM_EU_AXE_10_C_5_VORTEX 3 1 6 9 NORMAL SUN 5 USELSS
406769 ITEM_EU_CROSSBOW_10_C_5_VORTEX 3 1 6 12 NORMAL SUN 5 USELSS
406770 ITEM_EU_DARKSTAFF_10_C_5_VORTEX 3 1 6 10 NORMAL SUN 5 USELSS
406771 ITEM_EU_TSTAFF_10_C_5_VORTEX 3 1 6 11 NORMAL SUN 5 USELSS
406772 ITEM_EU_HARP_10_C_5_VORTEX 3 1 6 14 NORMAL SUN 5 USELSS
406773 ITEM_EU_STAFF_10_C_5_VORTEX 3 1 6 15 NORMAL SUN 5 USELSS
406774 ITEM_EU_SHIELD_10_C_5_VORTEX 3 1 4 2 NORMAL SUN 5 USELSS
406775 ITEM_CH_SWORD_10_C_6_VORTEX 3 1 6 2 NORMAL SUN 6 USELSS
406776 ITEM_CH_BLADE_10_C_6_VORTEX 3 1 6 3 NORMAL SUN 6 USELSS
406777 ITEM_CH_SPEAR_10_C_6_VORTEX 3 1 6 4 NORMAL SUN 6 USELSS
406778 ITEM_CH_TBLADE_10_C_6_VORTEX 3 1 6 5 NORMAL SUN 6 USELSS
406779 ITEM_CH_BOW_10_C_6_VORTEX 3 1 6 6 NORMAL SUN 6 USELSS
406780 ITEM_CH_SHIELD_10_C_6_VORTEX 3 1 4 1 NORMAL SUN 6 USELSS
406781 ITEM_EU_DAGGER_10_C_6_VORTEX 3 1 6 13 NORMAL SUN 6 USELSS
406782 ITEM_EU_SWORD_10_C_6_VORTEX 3 1 6 7 NORMAL SUN 6 USELSS
406783 ITEM_EU_TSWORD_10_C_6_VORTEX 3 1 6 8 NORMAL SUN 6 USELSS
406784 ITEM_EU_AXE_10_C_6_VORTEX 3 1 6 9 NORMAL SUN 6 USELSS
406785 ITEM_EU_CROSSBOW_10_C_6_VORTEX 3 1 6 12 NORMAL SUN 6 USELSS
406786 ITEM_EU_DARKSTAFF_10_C_6_VORTEX 3 1 6 10 NORMAL SUN 6 USELSS
406787 ITEM_EU_TSTAFF_10_C_6_VORTEX 3 1 6 11 NORMAL SUN 6 USELSS
406788 ITEM_EU_HARP_10_C_6_VORTEX 3 1 6 14 NORMAL SUN 6 USELSS
406789 ITEM_EU_STAFF_10_C_6_VORTEX 3 1 6 15 NORMAL SUN 6 USELSS
406790 ITEM_EU_SHIELD_10_C_6_VORTEX 3 1 4 2 NORMAL SUN 6 USELSS
406791 ITEM_CH_SWORD_10_C_7_VORTEX 3 1 6 2 NORMAL SUN 7 USELSS
406792 ITEM_CH_BLADE_10_C_7_VORTEX 3 1 6 3 NORMAL SUN 7 USELSS
406793 ITEM_CH_SPEAR_10_C_7_VORTEX 3 1 6 4 NORMAL SUN 7 USELSS
406794 ITEM_CH_TBLADE_10_C_7_VORTEX 3 1 6 5 NORMAL SUN 7 USELSS
406795 ITEM_CH_BOW_10_C_7_VORTEX 3 1 6 6 NORMAL SUN 7 USELSS
406796 ITEM_CH_SHIELD_10_C_7_VORTEX 3 1 4 1 NORMAL SUN 7 USELSS
406797 ITEM_EU_DAGGER_10_C_7_VORTEX 3 1 6 13 NORMAL SUN 7 USELSS
406798 ITEM_EU_SWORD_10_C_7_VORTEX 3 1 6 7 NORMAL SUN 7 USELSS
406799 ITEM_EU_TSWORD_10_C_7_VORTEX 3 1 6 8 NORMAL SUN 7 USELSS
406800 ITEM_EU_AXE_10_C_7_VORTEX 3 1 6 9 NORMAL SUN 7 USELSS
406801 ITEM_EU_CROSSBOW_10_C_7_VORTEX 3 1 6 12 NORMAL SUN 7 USELSS
406802 ITEM_EU_DARKSTAFF_10_C_7_VORTEX 3 1 6 10 NORMAL SUN 7 USELSS
406803 ITEM_EU_TSTAFF_10_C_7_VORTEX 3 1 6 11 NORMAL SUN 7 USELSS
406804 ITEM_EU_HARP_10_C_7_VORTEX 3 1 6 14 NORMAL SUN 7 USELSS
406805 ITEM_EU_STAFF_10_C_7_VORTEX 3 1 6 15 NORMAL SUN 7 USELSS
406806 ITEM_EU_SHIELD_10_C_7_VORTEX 3 1 4 2 NORMAL SUN 7 USELSS
406807 ITEM_CH_SWORD_10_C_8_VORTEX 3 1 6 2 NORMAL SUN 8 USELSS
406808 ITEM_CH_BLADE_10_C_8_VORTEX 3 1 6 3 NORMAL SUN 8 USELSS
406809 ITEM_CH_SPEAR_10_C_8_VORTEX 3 1 6 4 NORMAL SUN 8 USELSS
406810 ITEM_CH_TBLADE_10_C_8_VORTEX 3 1 6 5 NORMAL SUN 8 USELSS
406811 ITEM_CH_BOW_10_C_8_VORTEX 3 1 6 6 NORMAL SUN 8 USELSS
406812 ITEM_CH_SHIELD_10_C_8_VORTEX 3 1 4 1 NORMAL SUN 8 USELSS
406813 ITEM_EU_DAGGER_10_C_8_VORTEX 3 1 6 13 NORMAL SUN 8 USELSS
406814 ITEM_EU_SWORD_10_C_8_VORTEX 3 1 6 7 NORMAL SUN 8 USELSS
406815 ITEM_EU_TSWORD_10_C_8_VORTEX 3 1 6 8 NORMAL SUN 8 USELSS
406816 ITEM_EU_AXE_10_C_8_VORTEX 3 1 6 9 NORMAL SUN 8 USELSS
406817 ITEM_EU_CROSSBOW_10_C_8_VORTEX 3 1 6 12 NORMAL SUN 8 USELSS
406818 ITEM_EU_DARKSTAFF_10_C_8_VORTEX 3 1 6 10 NORMAL SUN 8 USELSS
406819 ITEM_EU_TSTAFF_10_C_8_VORTEX 3 1 6 11 NORMAL SUN 8 USELSS
406820 ITEM_EU_HARP_10_C_8_VORTEX 3 1 6 14 NORMAL SUN 8 USELSS
406821 ITEM_EU_STAFF_10_C_8_VORTEX 3 1 6 15 NORMAL SUN 8 USELSS
406822 ITEM_EU_SHIELD_10_C_8_VORTEX 3 1 4 2 NORMAL SUN 8 USELSS
406823 ITEM_CH_SWORD_10_C_9_VORTEX 3 1 6 2 NORMAL SUN 9 USELSS
406824 ITEM_CH_BLADE_10_C_9_VORTEX 3 1 6 3 NORMAL SUN 9 USELSS
406825 ITEM_CH_SPEAR_10_C_9_VORTEX 3 1 6 4 NORMAL SUN 9 USELSS
406826 ITEM_CH_TBLADE_10_C_9_VORTEX 3 1 6 5 NORMAL SUN 9 USELSS
406827 ITEM_CH_BOW_10_C_9_VORTEX 3 1 6 6 NORMAL SUN 9 USELSS
406828 ITEM_CH_SHIELD_10_C_9_VORTEX 3 1 4 1 NORMAL SUN 9 USELSS
406829 ITEM_EU_DAGGER_10_C_9_VORTEX 3 1 6 13 NORMAL SUN 9 USELSS
406830 ITEM_EU_SWORD_10_C_9_VORTEX 3 1 6 7 NORMAL SUN 9 USELSS
406831 ITEM_EU_TSWORD_10_C_9_VORTEX 3 1 6 8 NORMAL SUN 9 USELSS
406832 ITEM_EU_AXE_10_C_9_VORTEX 3 1 6 9 NORMAL SUN 9 USELSS
406833 ITEM_EU_CROSSBOW_10_C_9_VORTEX 3 1 6 12 NORMAL SUN 9 USELSS
406834 ITEM_EU_DARKSTAFF_10_C_9_VORTEX 3 1 6 10 NORMAL SUN 9 USELSS
406835 ITEM_EU_TSTAFF_10_C_9_VORTEX 3 1 6 11 NORMAL SUN 9 USELSS
406836 ITEM_EU_HARP_10_C_9_VORTEX 3 1 6 14 NORMAL SUN 9 USELSS
406837 ITEM_EU_STAFF_10_C_9_VORTEX 3 1 6 15 NORMAL SUN 9 USELSS
406838 ITEM_EU_SHIELD_10_C_9_VORTEX 3 1 4 2 NORMAL SUN 9 USELSS
406839 ITEM_CH_SWORD_10_C_11_VORTEX 3 1 6 2 NORMAL SUN 11 USELSS
406840 ITEM_CH_BLADE_10_C_11_VORTEX 3 1 6 3 NORMAL SUN 11 USELSS
406841 ITEM_CH_SPEAR_10_C_11_VORTEX 3 1 6 4 NORMAL SUN 11 USELSS
406842 ITEM_CH_TBLADE_10_C_11_VORTEX 3 1 6 5 NORMAL SUN 11 USELSS
406843 ITEM_CH_BOW_10_C_11_VORTEX 3 1 6 6 NORMAL SUN 11 USELSS
406844 ITEM_CH_SHIELD_10_C_11_VORTEX 3 1 4 1 NORMAL SUN 11 USELSS
406845 ITEM_EU_DAGGER_10_C_11_VORTEX 3 1 6 13 NORMAL SUN 11 USELSS
406846 ITEM_EU_SWORD_10_C_11_VORTEX 3 1 6 7 NORMAL SUN 11 USELSS
406847 ITEM_EU_TSWORD_10_C_11_VORTEX 3 1 6 8 NORMAL SUN 11 USELSS
406848 ITEM_EU_AXE_10_C_11_VORTEX 3 1 6 9 NORMAL SUN 11 USELSS
406849 ITEM_EU_CROSSBOW_10_C_11_VORTEX 3 1 6 12 NORMAL SUN 11 USELSS
406850 ITEM_EU_DARKSTAFF_10_C_11_VORTEX 3 1 6 10 NORMAL SUN 11 USELSS
406851 ITEM_EU_TSTAFF_10_C_11_VORTEX 3 1 6 11 NORMAL SUN 11 USELSS
406852 ITEM_EU_HARP_10_C_11_VORTEX 3 1 6 14 NORMAL SUN 11 USELSS
406853 ITEM_EU_STAFF_10_C_11_VORTEX 3 1 6 15 NORMAL SUN 11 USELSS
406854 ITEM_EU_SHIELD_10_C_11_VORTEX 3 1 4 2 NORMAL SUN 11 USELSS
406855 ITEM_CH_SWORD_10_C_12_VORTEX 3 1 6 2 NORMAL SUN 12 USELSS
406856 ITEM_CH_BLADE_10_C_12_VORTEX 3 1 6 3 NORMAL SUN 12 USELSS
406857 ITEM_CH_SPEAR_10_C_12_VORTEX 3 1 6 4 NORMAL SUN 12 USELSS
406858 ITEM_CH_TBLADE_10_C_12_VORTEX 3 1 6 5 NORMAL SUN 12 USELSS
406859 ITEM_CH_BOW_10_C_12_VORTEX 3 1 6 6 NORMAL SUN 12 USELSS
406860 ITEM_CH_SHIELD_10_C_12_VORTEX 3 1 4 1 NORMAL SUN 12 USELSS
406861 ITEM_EU_DAGGER_10_C_12_VORTEX 3 1 6 13 NORMAL SUN 12 USELSS
406862 ITEM_EU_SWORD_10_C_12_VORTEX 3 1 6 7 NORMAL SUN 12 USELSS
406863 ITEM_EU_TSWORD_10_C_12_VORTEX 3 1 6 8 NORMAL SUN 12 USELSS
406864 ITEM_EU_AXE_10_C_12_VORTEX 3 1 6 9 NORMAL SUN 12 USELSS
406865 ITEM_EU_CROSSBOW_10_C_12_VORTEX 3 1 6 12 NORMAL SUN 12 USELSS
406866 ITEM_EU_DARKSTAFF_10_C_12_VORTEX 3 1 6 10 NORMAL SUN 12 USELSS
406867 ITEM_EU_TSTAFF_10_C_12_VORTEX 3 1 6 11 NORMAL SUN 12 USELSS
406868 ITEM_EU_HARP_10_C_12_VORTEX 3 1 6 14 NORMAL SUN 12 USELSS
406869 ITEM_EU_STAFF_10_C_12_VORTEX 3 1 6 15 NORMAL SUN 12 USELSS
406870 ITEM_EU_SHIELD_10_C_12_VORTEX 3 1 4 2 NORMAL SUN 12 USELSS
406871 ITEM_CH_SWORD_10_C_14_VORTEX 3 1 6 2 NORMAL SUN 14 USELSS
406872 ITEM_CH_BLADE_10_C_14_VORTEX 3 1 6 3 NORMAL SUN 14 USELSS
406873 ITEM_CH_SPEAR_10_C_14_VORTEX 3 1 6 4 NORMAL SUN 14 USELSS
406874 ITEM_CH_TBLADE_10_C_14_VORTEX 3 1 6 5 NORMAL SUN 14 USELSS
406875 ITEM_CH_BOW_10_C_14_VORTEX 3 1 6 6 NORMAL SUN 14 USELSS
406876 ITEM_CH_SHIELD_10_C_14_VORTEX 3 1 4 1 NORMAL SUN 14 USELSS
406877 ITEM_EU_DAGGER_10_C_14_VORTEX 3 1 6 13 NORMAL SUN 14 USELSS
406878 ITEM_EU_SWORD_10_C_14_VORTEX 3 1 6 7 NORMAL SUN 14 USELSS
406879 ITEM_EU_TSWORD_10_C_14_VORTEX 3 1 6 8 NORMAL SUN 14 USELSS
406880 ITEM_EU_AXE_10_C_14_VORTEX 3 1 6 9 NORMAL SUN 14 USELSS
406881 ITEM_EU_CROSSBOW_10_C_14_VORTEX 3 1 6 12 NORMAL SUN 14 USELSS
406882 ITEM_EU_DARKSTAFF_10_C_14_VORTEX 3 1 6 10 NORMAL SUN 14 USELSS
406883 ITEM_EU_TSTAFF_10_C_14_VORTEX 3 1 6 11 NORMAL SUN 14 USELSS
406884 ITEM_EU_HARP_10_C_14_VORTEX 3 1 6 14 NORMAL SUN 14 USELSS
406885 ITEM_EU_STAFF_10_C_14_VORTEX 3 1 6 15 NORMAL SUN 14 USELSS
406886 ITEM_EU_SHIELD_10_C_14_VORTEX 3 1 4 2 NORMAL SUN 14 USELSS
406887 ITEM_CH_SWORD_10_C_15_VORTEX 3 1 6 2 NORMAL SUN 15 USELSS
406888 ITEM_CH_BLADE_10_C_15_VORTEX 3 1 6 3 NORMAL SUN 15 USELSS
406889 ITEM_CH_SPEAR_10_C_15_VORTEX 3 1 6 4 NORMAL SUN 15 USELSS
406890 ITEM_CH_TBLADE_10_C_15_VORTEX 3 1 6 5 NORMAL SUN 15 USELSS
406891 ITEM_CH_BOW_10_C_15_VORTEX 3 1 6 6 NORMAL SUN 15 USELSS
406892 ITEM_CH_SHIELD_10_C_15_VORTEX 3 1 4 1 NORMAL SUN 15 USELSS
406893 ITEM_EU_DAGGER_10_C_15_VORTEX 3 1 6 13 NORMAL SUN 15 USELSS
406894 ITEM_EU_SWORD_10_C_15_VORTEX 3 1 6 7 NORMAL SUN 15 USELSS
406895 ITEM_EU_TSWORD_10_C_15_VORTEX 3 1 6 8 NORMAL SUN 15 USELSS
406896 ITEM_EU_AXE_10_C_15_VORTEX 3 1 6 9 NORMAL SUN 15 USELSS
406897 ITEM_EU_CROSSBOW_10_C_15_VORTEX 3 1 6 12 NORMAL SUN 15 USELSS
406898 ITEM_EU_DARKSTAFF_10_C_15_VORTEX 3 1 6 10 NORMAL SUN 15 USELSS
406899 ITEM_EU_TSTAFF_10_C_15_VORTEX 3 1 6 11 NORMAL SUN 15 USELSS
406900 ITEM_EU_HARP_10_C_15_VORTEX 3 1 6 14 NORMAL SUN 15 USELSS
406901 ITEM_EU_STAFF_10_C_15_VORTEX 3 1 6 15 NORMAL SUN 15 USELSS
406902 ITEM_EU_SHIELD_10_C_15_VORTEX 3 1 4 2 NORMAL SUN 15 USELSS
اللي عندو اي سوال يسال
[/PHP]
طبعا ممكن يجي واحد ميكونش عارف يجيب سطور ال ItemData_xxx من الsql
كود PHP:
USE [SRO_VT_SHARD]
exec _GetMediaLines
@Type=1,
@CodeName='ITEM_CH_BOW_11_A_RARE'
لينك ال icons عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا
[ للتسجيل اضغط هنا ]
اتمني اكون افدت اي حد
لو اي حد وقفت قدامة مشكلة يكلمني ..
15-08-2019, 09:09 PM
المواضيع المتشابهه
.gif){kind=icon}
العرض الشجري