|
|
• الانـتـسـاب » Mar 2013
|
|
• رقـم العـضـويـة » 110603
|
|
• المشـــاركـات » 341
|
|
• الـدولـة » Hurghada
|
|
• الـهـوايـة » DeveloP AnyThing
|
|
• اسـم الـسـيـرفـر » Private Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 10
|
|
|
|
.gif)
Full Change Items System By HLP
يا رب كل يكون بخير
اولا انا كونت عامل سيستم ده من زمان
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
واحد حقولي ايه الاختلاف اقولك
سيستم القديم كان D14 بس انما سيستم الجديد من D1 الي D14
كمان لو عايز تغير Wpen او Set من صيني لاروبي او العكس كل اللي عليك
انت صيني وعايز تغير Bow ل 2Hand مثلا امسك السلاح و اضرب سكرولة 2hand ال Bow حيتغير ل 2hand
1) سكرولات
- RefObjCommon
كود PHP:
1 42099 ITEM_CHANGE_WPN_CH_SWORD ????? xxx SN_ITEM_CHANGE_WPN_CH_SWORD SN_ITEM_CHANGE_WPN_CH_SWORD_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\trade\hunter\sword_14.ddj xxx xxx 21515
1 42100 ITEM_CHANGE_WPN_CH_BLADE ????? xxx SN_ITEM_CHANGE_WPN_CH_BLADE SN_ITEM_CHANGE_WPN_CH_BLADE_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\trade\hunter\blade_14.ddj xxx xxx 21516
1 42101 ITEM_CHANGE_WPN_CH_SPEAR ????? xxx SN_ITEM_CHANGE_WPN_CH_SPEAR SN_ITEM_CHANGE_WPN_CH_SPEAR_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\trade\hunter\spear_14.ddj xxx xxx 21517
1 42102 ITEM_CHANGE_WPN_CH_GLAIVE ????? xxx SN_ITEM_CHANGE_WPN_CH_GLAIVE SN_ITEM_CHANGE_WPN_CH_GLAIVE_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\trade\hunter\tblade_14.ddj xxx xxx 21518
1 42103 ITEM_CHANGE_WPN_CH_BOW ????? xxx SN_ITEM_CHANGE_WPN_CH_BOW SN_ITEM_CHANGE_WPN_CH_BOW_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\trade\hunter\bow_14.ddj xxx xxx 21519
1 42104 ITEM_CHANGE_WPN_EU_DAGGER ????? xxx SN_ITEM_CHANGE_WPN_EU_DAGGER SN_ITEM_CHANGE_WPN_EU_DAGGER_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\trade\hunter\dagger_14.ddj xxx xxx 21520
1 42105 ITEM_CHANGE_WPN_EU_XBOW ????? xxx SN_ITEM_CHANGE_WPN_EU_XBOW SN_ITEM_CHANGE_WPN_EU_XBOW_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\trade\hunter\crossbow_14.ddj xxx xxx 21521
1 42106 ITEM_CHANGE_WPN_EU_AXE ????? xxx SN_ITEM_CHANGE_WPN_EU_AXE SN_ITEM_CHANGE_WPN_EU_AXE_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\trade\hunter\axe_14.ddj xxx xxx 21522
1 42107 ITEM_CHANGE_WPN_EU_SWORD ????? xxx SN_ITEM_CHANGE_WPN_EU_SWORD SN_ITEM_CHANGE_WPN_EU_SWORD_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\trade\hunter\esword_14.ddj xxx xxx 21523
1 42108 ITEM_CHANGE_WPN_EU_TSWORD ????? xxx SN_ITEM_CHANGE_WPN_EU_TSWORD SN_ITEM_CHANGE_WPN_EU_TSWORD_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\trade\hunter\tsword_14.ddj xxx xxx 21524
1 42109 ITEM_CHANGE_WPN_EU_TSTAFF ????? xxx SN_ITEM_CHANGE_WPN_EU_TSTAFF SN_ITEM_CHANGE_WPN_EU_TSTAFF_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\trade\hunter\tstaff_14.ddj xxx xxx 21525
1 42110 ITEM_CHANGE_WPN_EU_STAFF ????? xxx SN_ITEM_CHANGE_WPN_EU_STAFF SN_ITEM_CHANGE_WPN_EU_STAFF_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\trade\hunter\staff_14.ddj xxx xxx 21526
1 42111 ITEM_CHANGE_WPN_EU_DSTAFF ????? xxx SN_ITEM_CHANGE_WPN_EU_DSTAFF SN_ITEM_CHANGE_WPN_EU_DSTAFF_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\trade\hunter\darkstaff_14.ddj xxx xxx 21527
1 42112 ITEM_CHANGE_WPN_EU_HARP ????? xxx SN_ITEM_CHANGE_WPN_EU_HARP SN_ITEM_CHANGE_WPN_EU_HARP_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\trade\hunter\harp_14.ddj xxx xxx 21528
1 42113 ITEM_CHANGE_SET_CH_ARMOR ????? xxx SN_ITEM_CHANGE_SET_CH_ARMOR SN_ITEM_CHANGE_SET_CH_ARMOR_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\trade\hunter\armor_test.ddj xxx xxx 21529
1 42114 ITEM_CHANGE_SET_CH_PRO ????? xxx SN_ITEM_CHANGE_SET_CH_PRO SN_ITEM_CHANGE_SET_CH_PRO_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\trade\hunter\armor_test.ddj xxx xxx 21530
1 42115 ITEM_CHANGE_SET_CH_GRAMENT ????? xxx SN_ITEM_CHANGE_SET_CH_GRAMENT SN_ITEM_CHANGE_SET_CH_GRAMENT_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\trade\hunter\armor_test.ddj xxx xxx 21531
1 42116 ITEM_CHANGE_SET_EU_HA ????? xxx SN_ITEM_CHANGE_SET_EU_HA SN_ITEM_CHANGE_SET_EU_HA_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\trade\hunter\armor_test.ddj xxx xxx 21532
1 42117 ITEM_CHANGE_SET_EU_LA ????? xxx SN_ITEM_CHANGE_SET_EU_LA SN_ITEM_CHANGE_SET_EU_LA_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\trade\hunter\armor_test.ddj xxx xxx 21533
1 42118 ITEM_CHANGE_SET_EU_ROBE ????? xxx SN_ITEM_CHANGE_SET_EU_ROBE SN_ITEM_CHANGE_SET_EU_ROBE_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\trade\hunter\armor_test.ddj xxx xxx 21534
2) RefObjItem
كود PHP:
21515 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
21516 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
21517 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
21518 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
21519 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
21520 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
21521 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
21522 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
21523 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
21524 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
21525 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
21526 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
21527 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
21528 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
21529 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
21530 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
21531 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
21532 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
21533 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
21534 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
3) AddLogItem
كود PHP:
--- Weapon and Set Change
IF (@ItemRefID Between 42099 and 42112) and (@Operation = 41)-- Weapon change System
Begin
Execute [SRO_VT_SHARDLOG].[dbo].[_NewChangeSystem] @CharID , @operation , @itemrefid
END
IF (@ItemRefID between 42113 and 42118) and (@Operation = 41)-- Set change System
Begin
Execute [SRO_VT_SHARDLOG].[dbo].[_NewChangeSystemSET] @CharID , @operation , @itemrefid
END
4)Create Procedure
كود PHP:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_NewChangeSystem] Script Date: 22/04/2016 06:36:50 ص ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create procedure [dbo].[_NewChangeSystem]
@Charid int,
@Operation tinyint,
@ItemRefid int
AS
DECLARE @IID int,@RefID int,@Type varchar(50) = NULL,@ID int,@ID1 int
,@NID int ,@Gender varchar(8),@DG varchar(50),@ItemID int
Select @Type = Case
When @ItemRefID ='42099' THEN 'Sword'
When @ItemRefID ='42100' THEN 'blade'
When @ItemRefID ='42101' THEN 'Spear'
When @ItemRefID ='42102' THEN 'TBALDE'
When @ItemRefID ='42103' THEN 'Bow'
When @ItemRefID ='42104' THEN 'Dagger'
When @ItemRefID ='42105' THEN 'Xbow'
When @ItemRefID ='42106' THEN 'Axe'
When @ItemRefID ='42107' THEN '1Hand'
When @ItemRefID ='42108' THEN '2Hand'
When @ItemRefID ='42109' THEN 'Tstaff'
When @ItemRefID ='42110' THEN 'Staff'
When @ItemRefID ='42111' THEN 'DarkStaff'
When @ItemRefID ='42112' THEN 'harp'
Else Null End
--Get info About item in Slot 6
SELECT @ItemID=I.ID64 , @RefID = 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 = '6' AND Iv.CharID = @CharID
--Get Info about item in Table
select @ID = ID ,@DG = DG , @Gender = Gender
FROM SRO_VT_SHARDLOG.dbo._SystemChangeByHLP
WITH(NOLOCK) where ID = @RefID
--Get Info about New item
Select @NID = ID
FROM SRO_VT_SHARDLOG.dbo._SystemChangeByHLP
WITH(NOLOCK) WHERE
TYPE = @Type
and Gender = @Gender
AND DG = @DG
-- Start Updtae Item CH
IF (@Operation = 41)and(@ItemRefID Between 42099 and 42112)
Begin
IF @RefID =@ID
begin
Update SRO_VT_SHARD.._Items Set RefItemID=@NID,CreaterName='HLP' Where ID64 = @ItemID
END
end
--End Update Item CH
كود PHP:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_NewChangeSystemSET] Script Date: 22/04/2016 07:46:30 ص ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create procedure [dbo].[_NewChangeSystemSET]
@CharID int,
@Operation tinyint,
@ItemRefid int
AS
DECLARE
@IID INT,@IID1 INT,@IID2 INT,@IID3 INT,@IID4 INT,@IID5 INT,@ID INT,@ID1 INT,@ID2 INT,@ID3 INT,@ID4 INT,@ID5 INT,@RefID int
,@RefID1 INT,@RefID2 INT,@RefID3 INT,@RefID4 INT,@RefID5 INT ,@Type varchar(50) = NULL,@DG INT,@DG1 INT,@DG2 INT
,@DG3 INT,@DG4 INT,@DG5 INT,@NID int ,@NID1 int ,@NID2 int ,@NID3 int ,@NID4 int ,@NID5 int ,@Gender varchar(50),@Gender1 varchar(50)
,@Gender2 varchar(50),@Gender3 varchar(50),@Gender4 varchar(50),@Gender5 varchar(50),@Set_Gender varchar(50),@Set_Gender1 varchar(50)
,@Set_Gender2 varchar(50),@Set_Gender3 varchar(50),@Set_Gender4 varchar(50),@Set_Gender5 varchar(50)
Select @Type =Case
When @ItemRefID = '42113' Then 'Armor'
When @ItemRefID = '42114' Then 'Protector'
When @ItemRefID = '42115' Then 'Garment'
When @ItemRefID = '42116' Then 'Heavy'
When @ItemRefID = '42117' Then 'Light'
When @ItemRefID = '42118' Then 'Robe'
ELSE Null END
-- Item Slot 0
Select @IID = I.ID64 ,@RefID = I.RefItemID
From SRO_VT_SHARD.._Items I inner join SRO_VT_SHARD.._Inventory IV On I.ID64 = Iv.ItemID
where IV.Slot = '0' and Iv.CharID = @CharID
-- Item Slot 1
Select @IID1 = I.ID64 ,@RefID1 = I.RefItemID
From SRO_VT_SHARD.._Items I inner join SRO_VT_SHARD.._Inventory IV On I.ID64 = Iv.ItemID
where IV.Slot = '1' and Iv.CharID = @CharID
-- Item Slot 2
Select @IID2 = I.ID64 ,@RefID2 = I.RefItemID
From SRO_VT_SHARD.._Items I inner join SRO_VT_SHARD.._Inventory IV On I.ID64 = Iv.ItemID
where IV.Slot = '2' and Iv.CharID = @CharID
-- Item Slot 3
Select @IID3 = I.ID64 ,@RefID3 = I.RefItemID
From SRO_VT_SHARD.._Items I inner join SRO_VT_SHARD.._Inventory IV On I.ID64 = Iv.ItemID
where IV.Slot = '3' and Iv.CharID = @CharID
-- Item Slot 4
Select @IID4 = I.ID64 ,@RefID4 = I.RefItemID
From SRO_VT_SHARD.._Items I inner join SRO_VT_SHARD.._Inventory IV On I.ID64 = Iv.ItemID
where IV.Slot = '4' and Iv.CharID = @CharID
-- Item Slot 5
Select @IID5 = I.ID64 ,@RefID5 = I.RefItemID
From SRO_VT_SHARD.._Items I inner join SRO_VT_SHARD.._Inventory IV On I.ID64 = Iv.ItemID
where IV.Slot = '5' and Iv.CharID = @CharID
--Get Info OF Select Items
--Item on Slot 0
Select @ID= ID , @Gender = Gender , @Set_Gender = Set_Gender ,@DG = DG
FROM SRO_VT_SHARDLOG.dbo._SystemChangeByHLP2 WITH(NOLOCK) where ID = @RefID
--Item on Slot 1
Select @ID1= ID , @Gender1 = Gender , @Set_Gender1 = Set_Gender ,@DG1 = DG
FROM SRO_VT_SHARDLOG.dbo._SystemChangeByHLP2 WITH(NOLOCK) where ID = @RefID1
--Item on Slot 2
Select @ID2= ID , @Gender2 = Gender , @Set_Gender2 = Set_Gender ,@DG2 = DG
FROM SRO_VT_SHARDLOG.dbo._SystemChangeByHLP2 WITH(NOLOCK) where ID = @RefID2
--Item on Slot 3
Select @ID3= ID , @Gender3 = Gender , @Set_Gender3 = Set_Gender ,@DG3 = DG
FROM SRO_VT_SHARDLOG.dbo._SystemChangeByHLP2 WITH(NOLOCK) where ID = @RefID3
--Item on Slot 4
Select @ID4= ID , @Gender4 = Gender , @Set_Gender4 = Set_Gender ,@DG4 = DG
FROM SRO_VT_SHARDLOG.dbo._SystemChangeByHLP2 WITH(NOLOCK) where ID = @RefID4
--Item on Slot 5
Select @ID5= ID , @Gender5 = Gender , @Set_Gender5 = Set_Gender ,@DG5 = DG
FROM SRO_VT_SHARDLOG.dbo._SystemChangeByHLP2 WITH(NOLOCK) where ID = @RefID5
-- New Item on Slot 1
Select @NID = ID From SRO_VT_SHARDLOG.dbo._SystemChangeByHLP2 Where
TYPE = @Type and Gender = @Gender and Set_Gender = @Set_Gender and DG = @DG
-- New Item on Slot 2
Select @NID1 = ID From SRO_VT_SHARDLOG.dbo._SystemChangeByHLP2 Where
TYPE = @Type and Gender = @Gender1 and Set_Gender = @Set_Gender1 and DG = @DG1
-- New Item on Slot 3
Select @NID2 = ID From SRO_VT_SHARDLOG.dbo._SystemChangeByHLP2 Where
TYPE = @Type and Gender = @Gender2 and Set_Gender = @Set_Gender2 and DG = @DG2
-- New Item on Slot 4
Select @NID3 = ID From SRO_VT_SHARDLOG.dbo._SystemChangeByHLP2 Where
TYPE = @Type and Gender = @Gender3 and Set_Gender = @Set_Gender3 and DG = @DG3
-- New Item on Slot 5
Select @NID4 = ID From SRO_VT_SHARDLOG.dbo._SystemChangeByHLP2 Where
TYPE = @Type and Gender = @Gender4 and Set_Gender = @Set_Gender4 and DG = @DG4
-- New Item on Slot 5
Select @NID5 = ID From SRO_VT_SHARDLOG.dbo._SystemChangeByHLP2 Where
TYPE = @Type and Gender = @Gender5 and Set_Gender = @Set_Gender5 and DG = @DG4
--Start Update Items
IF (@ItemRefID Between 42113 and 42118)
and (@Operation = 41)
begin
Update SRO_VT_SHARD.._Items Set RefItemID = @NID,CreaterName='HLP' Where ID64 = @IID
Update SRO_VT_SHARD.._Items Set RefItemID = @NID1,CreaterName='HLP' Where ID64 = @IID1
Update SRO_VT_SHARD.._Items Set RefItemID = @NID2,CreaterName='HLP' Where ID64 = @IID2
Update SRO_VT_SHARD.._Items Set RefItemID = @NID3,CreaterName='HLP' Where ID64 = @IID3
Update SRO_VT_SHARD.._Items Set RefItemID = @NID4,CreaterName='HLP' Where ID64 = @IID4
Update SRO_VT_SHARD.._Items Set RefItemID = @NID5,CreaterName='HLP' Where ID64 = @IID5
end
-- End Update items
5) CREATE TABLE
كود PHP:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: Table [dbo].[_SystemChangeByHLP] Script Date: 20/04/2016 05:57:58 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_SystemChangeByHLP](
[ID] [int] NOT NULL,
[Codename] [varchar](50) NULL,
[Type] [varchar](50) NULL,
[Gender] [varchar](8) NULL,
[DG] [int] NULL,
CONSTRAINT [PK__SystemChangeByHLP] 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
/****** Object: Table [dbo].[_SystemChangeByHLP2] Script Date: 20/04/2016 05:58:37 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_SystemChangeByHLP2](
[ID] [int] NOT NULL,
[Codename] [varchar](50) NULL,
[Set_Gender] [varchar](50) NULL,
[Type] [varchar](50) NULL,
[Gender] [varchar](50) NULL,
[DG] [int] NOT NULL,
CONSTRAINT [PK__SystemChangeByHLP2] 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
6) Tables Lines
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
7) Vedio
[YOUTUBE]?v=1v4DEccAtVw[/YOUTUBE]
|
20-04-2016, 07:06 PM
المواضيع المتشابهه
العرض الشجري