|
|
• الانـتـسـاب » Oct 2012
|
|
• رقـم العـضـويـة » 106620
|
|
• المشـــاركـات » 621
|
|
• الـدولـة » سَّوٍّهِّآجِّ
|
|
• الـهـوايـة » AKTSA7
|
|
• اسـم الـسـيـرفـر » Private Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 48
|
|
|
|
.gif)
مشكله في Lock/Unlok Scroll
انا عملت زي ما الاستاز حمزه كاتب في الموضوع دا
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
ودي نسخ من التاب و البروسيدر
_RefObjCommon
كود PHP:
1 60362 ITEM_CH_SWORD_11_SET_B_RARE_SPICOO ???_?? xxx SN_ITEM_CH_SWORD_11_SET_B SN_ITEM_CH_SWORD_11_SET_B_TT_DESC 0 0 3 1 6 2 180000 0 2 1 1 1 255 3 1 1 1 0 0 11286000 7733 11600 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\ch_sword_11_set_b.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\ch_sword_11_set_b.ddj xxx xxx 2238149
1 60363 ITEM_CH_BLADE_11_SET_B_RARE_SPICOO ???_?? xxx SN_ITEM_CH_BLADE_11_SET_B SN_ITEM_CH_BLADE_11_SET_B_TT_DESC 0 0 3 1 6 3 180000 0 2 1 1 1 255 3 1 1 1 0 0 11286000 8548 12821 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\ch_blade_11_set_b.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\ch_blade_11_set_b.ddj xxx xxx 2238150
1 60364 ITEM_CH_SPEAR_11_SET_B_RARE_SPICOO ?????_?? xxx SN_ITEM_CH_SPEAR_11_SET_B SN_ITEM_CH_SPEAR_11_SET_B_TT_DESC 0 0 3 1 6 4 180000 0 2 1 1 1 255 3 1 1 1 0 0 12540000 5156 7733 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\ch_spear_11_set_b.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\ch_spear_11_set_b.ddj xxx xxx 2238151
1 60365 ITEM_CH_TBLADE_11_SET_B_RARE_SPICOO ??_?? xxx SN_ITEM_CH_TBLADE_11_SET_B SN_ITEM_CH_TBLADE_11_SET_B_TT_DESC 0 0 3 1 6 5 180000 0 2 1 1 1 255 3 1 1 1 0 0 12540000 5698 8548 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\ch_tblade_11_set_b.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\ch_tblade_11_set_b.ddj xxx xxx 2238152
1 60366 ITEM_CH_BOW_11_SET_B_RARE_SPICOO ????_?? xxx SN_ITEM_CH_BOW_11_SET_B SN_ITEM_CH_BOW_11_SET_B_TT_DESC 0 0 3 1 6 6 180000 0 2 1 1 1 255 3 1 1 1 0 0 12540000 5861 8792 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\ch_bow_11_set_b.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\ch_bow_11_set_b.ddj xxx xxx 2238153
1 60367 ITEM_CH_SHIELD_11_SET_B_RARE_SPICOO ????_?? xxx SN_ITEM_CH_SHIELD_11_SET_B SN_ITEM_CH_SHIELD_11_SET_B_TT_DESC 0 0 3 1 4 1 180000 0 2 1 1 1 255 3 1 1 1 0 0 6270000 5698 8548 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\ch_shield_11_set_b.bsr item\etc\drop_ch_equip_rare.bsr item\china\shield\ch_shield_11_set_b.ddj xxx xxx 2238154
1 60368 ITEM_EU_SWORD_11_SET_B_RARE_SPICOO ???_?? xxx SN_ITEM_EU_SWORD_11_SET_B SN_ITEM_EU_SWORD_11_SET_B_TT_DESC 0 0 3 1 6 7 180000 1 2 1 1 1 255 3 1 1 1 0 0 11286000 6512 9769 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\eu_sword_11_set_b.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\eu_sword_11_set_b.ddj xxx xxx 2238155
1 60369 ITEM_EU_TSWORD_11_SET_B_RARE_SPICOO ?????_?? xxx SN_ITEM_EU_TSWORD_11_SET_B SN_ITEM_EU_TSWORD_11_SET_B_TT_DESC 0 0 3 1 6 8 180000 1 2 1 1 1 255 3 1 1 1 0 0 12540000 5427 8141 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\eu_tsword_11_set_b.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\eu_tsword_11_set_b.ddj xxx xxx 2238156
1 60370 ITEM_EU_AXE_11_SET_B_RARE_SPICOO ???_?? xxx SN_ITEM_EU_AXE_11_SET_B SN_ITEM_EU_AXE_11_SET_B_TT_DESC 0 0 3 1 6 9 180000 1 2 1 1 1 255 3 1 1 1 0 0 12540000 9226 13839 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\eu_axe_11_set_b.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\eu_axe_11_set_b.ddj xxx xxx 2238157
1 60371 ITEM_EU_DAGGER_11_SET_B_RARE_SPICOO ???_?? xxx SN_ITEM_EU_DAGGER_11_SET_B SN_ITEM_EU_DAGGER_11_SET_B_TT_DESC 0 0 3 1 6 13 180000 1 2 1 1 1 255 3 1 1 1 0 0 12540000 9226 13839 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\eu_dagger_11_set_b.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\eu_dagger_11_set_b.ddj xxx xxx 2238158
1 60372 ITEM_EU_CROSSBOW_11_SET_B_RARE_SPICOO ?????_?? xxx SN_ITEM_EU_CROSSBOW_11_SET_B SN_ITEM_EU_CROSSBOW_11_SET_B_TT_DESC 0 0 3 1 6 12 180000 1 2 1 1 1 255 3 1 1 1 0 0 12540000 6512 9769 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\eu_crossbow_11_set_b.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\eu_crossbow_11_set_b.ddj xxx xxx 2238159
1 60373 ITEM_EU_TSTAFF_11_SET_B_RARE_SPICOO ?????_?? xxx SN_ITEM_EU_TSTAFF_11_SET_B SN_ITEM_EU_TSTAFF_11_SET_B_TT_DESC 0 0 3 1 6 11 180000 1 2 1 1 1 255 3 1 1 1 0 0 12540000 5427 8141 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\eu_tstaff_11_set_b.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\eu_tstaff_11_set_b.ddj xxx xxx 2238160
1 60374 ITEM_EU_DARKSTAFF_11_SET_B_RARE_SPICOO ????_?? xxx SN_ITEM_EU_DARKSTAFF_11_SET_B SN_ITEM_EU_DARKSTAFF_11_SET_B_TT_DESC 0 0 3 1 6 10 180000 1 2 1 1 1 255 3 1 1 1 0 0 11286000 5427 8141 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\eu_darkstaff_11_set_b.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\eu_darkstaff_11_set_b.ddj xxx xxx 2238161
1 60375 ITEM_EU_STAFF_11_SET_B_RARE_SPICOO ????_?? xxx SN_ITEM_EU_STAFF_11_SET_B SN_ITEM_EU_STAFF_11_SET_B_TT_DESC 0 0 3 1 6 15 180000 1 2 1 1 1 255 3 1 1 1 0 0 12540000 5427 8141 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\eu_staff_11_set_b.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\eu_staff_11_set_b.ddj xxx xxx 2238162
1 60376 ITEM_EU_HARP_11_SET_B_RARE_SPICOO ???_?? xxx SN_ITEM_EU_HARP_11_SET_B SN_ITEM_EU_HARP_11_SET_B_TT_DESC 0 0 3 1 6 14 180000 1 2 1 1 1 255 3 1 1 1 0 0 12540000 4884 7326 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\eu_harp_11_set_b.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\eu_harp_11_set_b.ddj xxx xxx 2238163
1 60377 ITEM_EU_SHIELD_11_SET_B_RARE_SPICOO ??_?? xxx SN_ITEM_EU_SHIELD_11_SET_B SN_ITEM_EU_SHIELD_11_SET_B_TT_DESC 0 0 3 1 4 2 180000 1 2 1 1 1 255 3 1 1 1 0 0 6270000 5698 8548 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\eu_shield_11_set_b.bsr item\etc\drop_eu_equip_rare.bsr item\europe\shield\eu_shield_11_set_b.ddj xxx xxx 2238164
1 60378 ITEM_CH_SWORD_11_SET_B_RARE_FLASH ???_?? xxx SN_ITEM_CH_SWORD_11_SET_B SN_ITEM_CH_SWORD_11_SET_B_TT_DESC 0 0 3 1 6 2 180000 0 2 0 0 1 0 0 1 1 1 0 0 11286000 7733 11600 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\ch_sword_11_set_b.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\ch_sword_11_set_b.ddj xxx xxx 2238165
1 60379 ITEM_CH_BLADE_11_SET_B_RARE_FLASH ???_?? xxx SN_ITEM_CH_BLADE_11_SET_B SN_ITEM_CH_BLADE_11_SET_B_TT_DESC 0 0 3 1 6 3 180000 0 2 0 0 1 0 0 1 1 1 0 0 11286000 8548 12821 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\ch_blade_11_set_b.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\ch_blade_11_set_b.ddj xxx xxx 2238166
1 60380 ITEM_CH_SPEAR_11_SET_B_RARE_FLASH ?????_?? xxx SN_ITEM_CH_SPEAR_11_SET_B SN_ITEM_CH_SPEAR_11_SET_B_TT_DESC 0 0 3 1 6 4 180000 0 2 0 0 1 0 0 1 1 1 0 0 12540000 5156 7733 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\ch_spear_11_set_b.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\ch_spear_11_set_b.ddj xxx xxx 2238167
1 60381 ITEM_CH_TBLADE_11_SET_B_RARE_FLASH ??_?? xxx SN_ITEM_CH_TBLADE_11_SET_B SN_ITEM_CH_TBLADE_11_SET_B_TT_DESC 0 0 3 1 6 5 180000 0 2 0 0 1 0 0 1 1 1 0 0 12540000 5698 8548 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\ch_tblade_11_set_b.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\ch_tblade_11_set_b.ddj xxx xxx 2238168
1 60382 ITEM_CH_BOW_11_SET_B_RARE_FLASH ????_?? xxx SN_ITEM_CH_BOW_11_SET_B SN_ITEM_CH_BOW_11_SET_B_TT_DESC 0 0 3 1 6 6 180000 0 2 0 0 1 0 0 1 1 1 0 0 12540000 5861 8792 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\ch_bow_11_set_b.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\ch_bow_11_set_b.ddj xxx xxx 2238169
1 60383 ITEM_CH_SHIELD_11_SET_B_RARE_FLASH ????_?? xxx SN_ITEM_CH_SHIELD_11_SET_B SN_ITEM_CH_SHIELD_11_SET_B_TT_DESC 0 0 3 1 4 1 180000 0 2 0 0 1 0 0 1 1 1 0 0 6270000 5698 8548 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\ch_shield_11_set_b.bsr item\etc\drop_ch_equip_rare.bsr item\china\shield\ch_shield_11_set_b.ddj xxx xxx 2238170
1 60384 ITEM_EU_SWORD_11_SET_B_RARE_FLASH ???_?? xxx SN_ITEM_EU_SWORD_11_SET_B SN_ITEM_EU_SWORD_11_SET_B_TT_DESC 0 0 3 1 6 7 180000 1 2 0 0 1 0 0 1 1 1 0 0 11286000 6512 9769 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\eu_sword_11_set_b.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\eu_sword_11_set_b.ddj xxx xxx 2238171
1 60385 ITEM_EU_TSWORD_11_SET_B_RARE_FLASH ?????_?? xxx SN_ITEM_EU_TSWORD_11_SET_B SN_ITEM_EU_TSWORD_11_SET_B_TT_DESC 0 0 3 1 6 8 180000 1 2 0 0 1 0 0 1 1 1 0 0 12540000 5427 8141 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\eu_tsword_11_set_b.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\eu_tsword_11_set_b.ddj xxx xxx 2238172
1 60386 ITEM_EU_AXE_11_SET_B_RARE_FLASH ???_?? xxx SN_ITEM_EU_AXE_11_SET_B SN_ITEM_EU_AXE_11_SET_B_TT_DESC 0 0 3 1 6 9 180000 1 2 0 0 1 0 0 1 1 1 0 0 12540000 9226 13839 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\eu_axe_11_set_b.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\eu_axe_11_set_b.ddj xxx xxx 2238173
1 60387 ITEM_EU_DAGGER_11_SET_B_RARE_FLASH ???_?? xxx SN_ITEM_EU_DAGGER_11_SET_B SN_ITEM_EU_DAGGER_11_SET_B_TT_DESC 0 0 3 1 6 13 180000 1 2 0 0 1 0 0 1 1 1 0 0 12540000 9226 13839 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\eu_dagger_11_set_b.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\eu_dagger_11_set_b.ddj xxx xxx 2238174
1 60388 ITEM_EU_CROSSBOW_11_SET_B_RARE_FLASH ?????_?? xxx SN_ITEM_EU_CROSSBOW_11_SET_B SN_ITEM_EU_CROSSBOW_11_SET_B_TT_DESC 0 0 3 1 6 12 180000 1 2 0 0 1 0 0 1 1 1 0 0 12540000 6512 9769 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\eu_crossbow_11_set_b.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\eu_crossbow_11_set_b.ddj xxx xxx 2238175
1 60389 ITEM_EU_TSTAFF_11_SET_B_RARE_FLASH ?????_?? xxx SN_ITEM_EU_TSTAFF_11_SET_B SN_ITEM_EU_TSTAFF_11_SET_B_TT_DESC 0 0 3 1 6 11 180000 1 2 0 0 1 0 0 1 1 1 0 0 12540000 5427 8141 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\eu_tstaff_11_set_b.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\eu_tstaff_11_set_b.ddj xxx xxx 2238176
1 60390 ITEM_EU_DARKSTAFF_11_SET_B_RARE_FLASH ????_?? xxx SN_ITEM_EU_DARKSTAFF_11_SET_B SN_ITEM_EU_DARKSTAFF_11_SET_B_TT_DESC 0 0 3 1 6 10 180000 1 2 0 0 1 0 0 1 1 1 0 0 11286000 5427 8141 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\eu_darkstaff_11_set_b.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\eu_darkstaff_11_set_b.ddj xxx xxx 2238177
1 60391 ITEM_EU_STAFF_11_SET_B_RARE_FLASH ????_?? xxx SN_ITEM_EU_STAFF_11_SET_B SN_ITEM_EU_STAFF_11_SET_B_TT_DESC 0 0 3 1 6 15 180000 1 2 0 0 1 0 0 1 1 1 0 0 12540000 5427 8141 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\eu_staff_11_set_b.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\eu_staff_11_set_b.ddj xxx xxx 2238178
1 60392 ITEM_EU_HARP_11_SET_B_RARE_FLASH ???_?? xxx SN_ITEM_EU_HARP_11_SET_B SN_ITEM_EU_HARP_11_SET_B_TT_DESC 0 0 3 1 6 14 180000 1 2 0 0 1 0 0 1 1 1 0 0 12540000 4884 7326 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\eu_harp_11_set_b.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\eu_harp_11_set_b.ddj xxx xxx 2238179
1 60393 ITEM_EU_SHIELD_11_SET_B_RARE_FLASH ??_?? xxx SN_ITEM_EU_SHIELD_11_SET_B SN_ITEM_EU_SHIELD_11_SET_B_TT_DESC 0 0 3 1 4 2 180000 1 2 0 0 1 0 0 1 1 1 0 0 6270000 5698 8548 0 9000 1 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\etc\weapon\eu_shield_11_set_b.bsr item\etc\drop_eu_equip_rare.bsr item\europe\shield\eu_shield_11_set_b.ddj xxx xxx 2238180
1 60394 ITEM_CHAOS_LOCK ????? (????) xxx SN_ITEM_CHAOS_LOCK SN_ITEM_CHAOS_LOCK_TT_DESC 0 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 0 0 0 0 0 1 -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\lock_indulgence.ddj xxx xxx 2238181
1 60395 ITEM_CHAOS_UNLOCK ????? (????) xxx SN_ITEM_CHAOS_UNLOCK SN_ITEM_CHAOS_UNLOCK_TT_DESC 0 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 0 0 0 0 0 1 -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\unlock_indulgence.ddj xxx xxx 2238182
_RefObjItem
كود PHP:
2238149 1 2 0 0 31 40 129 158 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 1857 1966 2094 2216 58.4 3161 3345 3633 3845 100.4 2669 2776 3008 3130 4541 4725 5220 5431 123 259 0 4 16 1 ITEM_CH_SWORD_12_A_RARE_SPICOO 1 ITEM_CH_SWORD_12_B_RARE 1 ITEM_CH_SWORD_12_C_RARE_SPICOO -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238150 1 2 0 0 31 40 143 175 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 1975 2091 2271 2403 62.7 2972 3145 3350 3545 93.4 2838 2953 3263 3395 4270 4442 4813 5007 123 259 0 3 15 1 ITEM_CH_BLADE_12_A_RARE_SPICOO 1 ITEM_CH_BLADE_12_B_RARE 1 ITEM_CH_BLADE_12_C_RARE_SPICOO -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238151 1 2 0 0 31 40 86 105 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 18 1939 2052 2308 2442 62.7 3323 3517 4062 4299 109.1 2785 2898 3316 3450 4775 4968 5836 6071 123 259 0 5 17 1 ITEM_CH_SPEAR_12_A_RARE_SPICOO 1 ITEM_CH_SPEAR_12_B_RARE 1 ITEM_CH_SPEAR_12_C_RARE_SPICOO -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238152 1 2 0 0 31 40 95 116 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 18 2077 2198 2539 2687 68.2 3102 3283 3692 3908 100.4 2984 3105 3647 3795 4456 4636 5305 5520 123 259 0 4 16 1 ITEM_CH_TBLADE_12_A_RARE_SPICOO 1 ITEM_CH_TBLADE_12_B_RARE 1 ITEM_CH_TBLADE_12_C_RARE_SPICOO -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238153 1 2 0 0 31 40 98 120 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 2 1 180 1879 1989 2303 2437 61.8 3006 3182 3684 3899 98.8 2700 2809 3308 3442 4320 4494 5294 5507 123 259 0 4 14 1 ITEM_CH_BOW_12_A_RARE_SPICOO 1 ITEM_CH_BOW_12_B_RARE 1 ITEM_CH_BOW_12_C_RARE_SPICOO -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238154 1 2 0 0 31 42 95 116 276.9 293.1 8.2 0 0 0 0 0 0 14 23 443.1 468.9 13.1 0 0 0 398 414 669 696 0 0 0 0 0 0 2 0 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 ITEM_CH_SHIELD_12_A_RARE_SPICOO 1 ITEM_CH_SHIELD_12_B_RARE 1 ITEM_CH_SHIELD_12_C_RARE_SPICOO -1 xxx -1 xxx -1 xxx -1 xxx -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 ?? ??? ?? ?? ? 9 0 0
2238155 1 2 0 0 31 40 97 145 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 2492 2638 3046 3224 81.8 0 0 0 0 0 3511 3876 4291 4738 0 0 0 0 123 259 0 2 15 1 ITEM_EU_SWORD_12_A_RARE_SPICOO 1 ITEM_EU_SWORD_12_B_RARE 1 ITEM_EU_SWORD_12_C_RARE_SPICOO -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238156 1 2 0 0 31 40 81 121 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 18 2492 2638 3046 3224 81.8 0 0 0 0 0 3511 3876 4291 4738 0 0 0 0 123 259 0 2 15 1 ITEM_EU_TSWORD_12_A_RARE_SPICOO 1 ITEM_EU_TSWORD_12_B_RARE 1 ITEM_EU_TSWORD_12_C_RARE_SPICOO -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238157 1 2 0 0 31 40 137 206 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 6 2492 2638 3046 3224 81.8 0 0 0 0 0 3511 3876 4291 4738 0 0 0 0 123 259 0 2 15 1 ITEM_EU_AXE_12_A_RARE_SPICOO 1 ITEM_EU_AXE_12_B_RARE 1 ITEM_EU_AXE_12_C_RARE_SPICOO -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238158 1 2 0 0 31 40 137 206 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 3 2492 2638 3046 3224 81.8 0 0 0 0 0 3511 3876 4291 4738 0 0 0 0 123 259 0 4 25 1 ITEM_EU_DAGGER_12_A_RARE_SPICOO 1 ITEM_EU_DAGGER_12_B_RARE 1 ITEM_EU_DAGGER_12_C_RARE_SPICOO -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238159 1 2 0 0 31 40 97 145 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 180 2492 2638 3046 3224 81.8 0 0 0 0 0 3511 3876 4291 4738 0 0 0 0 123 259 0 4 20 1 ITEM_EU_CROSSBOW_12_A_RARE_SPICOO 1 ITEM_EU_CROSSBOW_12_B_RARE 1 ITEM_EU_CROSSBOW_12_C_RARE_SPICOO -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238160 1 2 0 0 31 40 81 121 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 6 0 0 0 0 0 3988 4220 4874 5158 130.9 0 0 0 0 5617 6202 6866 7580 123 259 0 2 2 1 ITEM_EU_TSTAFF_12_A_RARE_SPICOO 1 ITEM_EU_TSTAFF_12_B_RARE 1 ITEM_EU_TSTAFF_12_C_RARE_SPICOO -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238161 1 2 0 0 31 40 161 242 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 0 0 0 0 0 3988 4220 4874 5158 130.9 0 0 0 0 5617 6202 6866 7580 123 259 0 2 2 1 ITEM_EU_DARKSTAFF_12_A_RARE_SPICOO 1 ITEM_EU_DARKSTAFF_12_B_RARE 1 ITEM_EU_DARKSTAFF_12_C_RARE_SPICOO -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238162 1 2 0 0 31 40 81 121 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 0 0 0 0 0 3988 4220 4874 5158 130.9 0 0 0 0 5617 6202 6866 7580 123 259 0 2 2 1 ITEM_EU_STAFF_12_A_RARE_SPICOO 1 ITEM_EU_STAFF_12_B_RARE 1 ITEM_EU_STAFF_12_C_RARE_SPICOO -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238163 1 2 0 0 31 40 73 109 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 6 0 0 0 0 0 3988 4220 4874 5158 130.9 0 0 0 0 5617 6202 6866 7580 123 259 0 2 2 1 ITEM_EU_HARP_12_A_RARE_SPICOO 1 ITEM_EU_HARP_12_B_RARE 1 ITEM_EU_HARP_12_C_RARE_SPICOO -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238164 1 2 0 0 31 42 85 127 276.9 293.1 8.2 0 0 0 0 0 0 14 23 443.1 468.9 13.1 0 0 0 390 431 624 689 0 0 0 0 0 0 2 0 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 ITEM_EU_SHIELD_12_A_RARE_SPICOO 1 ITEM_EU_SHIELD_12_B_RARE 1 ITEM_EU_SHIELD_12_C_RARE_SPICOO -1 xxx -1 xxx -1 xxx -1 xxx -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 ?? ??? ?? ?? ? 9 0 0
2238165 1 2 0 0 31 40 129 158 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 1857 1966 2094 2216 58.4 3161 3345 3633 3845 100.4 2669 2776 3008 3130 4541 4725 5220 5431 123 259 0 4 16 1 ITEM_CH_SWORD_12_A_RARE_FLASH 1 ITEM_CH_SWORD_12_B_RARE 1 ITEM_CH_SWORD_12_C_RARE_FLASH -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238166 1 2 0 0 31 40 143 175 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 1975 2091 2271 2403 62.7 2972 3145 3350 3545 93.4 2838 2953 3263 3395 4270 4442 4813 5007 123 259 0 3 15 1 ITEM_CH_BLADE_12_A_RARE_FLASH 1 ITEM_CH_BLADE_12_B_RARE 1 ITEM_CH_BLADE_12_C_RARE_FLASH -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238167 1 2 0 0 31 40 86 105 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 18 1939 2052 2308 2442 62.7 3323 3517 4062 4299 109.1 2785 2898 3316 3450 4775 4968 5836 6071 123 259 0 5 17 1 ITEM_CH_SPEAR_12_A_RARE_FLASH 1 ITEM_CH_SPEAR_12_B_RARE 1 ITEM_CH_SPEAR_12_C_RARE_FLASH -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238168 1 2 0 0 31 40 95 116 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 18 2077 2198 2539 2687 68.2 3102 3283 3692 3908 100.4 2984 3105 3647 3795 4456 4636 5305 5520 123 259 0 4 16 1 ITEM_CH_TBLADE_12_A_RARE_FLASH 1 ITEM_CH_TBLADE_12_B_RARE 1 ITEM_CH_TBLADE_12_C_RARE_FLASH -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238169 1 2 0 0 31 40 98 120 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 2 1 180 1879 1989 2303 2437 61.8 3006 3182 3684 3899 98.8 2700 2809 3308 3442 4320 4494 5294 5507 123 259 0 4 14 1 ITEM_CH_BOW_12_A_RARE_FLASH 1 ITEM_CH_BOW_12_B_RARE 1 ITEM_CH_BOW_12_C_RARE_FLASH -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238170 1 2 0 0 31 42 95 116 276.9 293.1 8.2 0 0 0 0 0 0 14 23 443.1 468.9 13.1 0 0 0 398 414 669 696 0 0 0 0 0 0 2 0 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 ITEM_CH_SHIELD_12_A_RARE_FLASH 1 ITEM_CH_SHIELD_12_B_RARE 1 ITEM_CH_SHIELD_12_C_RARE_FLASH -1 xxx -1 xxx -1 xxx -1 xxx -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 ?? ??? ?? ?? ? 9 0 0
2238171 1 2 0 0 31 40 97 145 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 2492 2638 3046 3224 81.8 0 0 0 0 0 3511 3876 4291 4738 0 0 0 0 123 259 0 2 15 1 ITEM_EU_SWORD_12_A_RARE_FLASH 1 ITEM_EU_SWORD_12_B_RARE 1 ITEM_EU_SWORD_12_C_RARE_FLASH -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238172 1 2 0 0 31 40 81 121 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 18 2492 2638 3046 3224 81.8 0 0 0 0 0 3511 3876 4291 4738 0 0 0 0 123 259 0 2 15 1 ITEM_EU_TSWORD_12_A_RARE_FLASH 1 ITEM_EU_TSWORD_12_B_RARE 1 ITEM_EU_TSWORD_12_C_RARE_FLASH -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238173 1 2 0 0 31 40 137 206 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 6 2492 2638 3046 3224 81.8 0 0 0 0 0 3511 3876 4291 4738 0 0 0 0 123 259 0 2 15 1 ITEM_EU_AXE_12_A_RARE_FLASH 1 ITEM_EU_AXE_12_B_RARE 1 ITEM_EU_AXE_12_C_RARE_FLASH -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238174 1 2 0 0 31 40 137 206 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 3 2492 2638 3046 3224 81.8 0 0 0 0 0 3511 3876 4291 4738 0 0 0 0 123 259 0 4 25 1 ITEM_EU_DAGGER_12_A_RARE_FLASH 1 ITEM_EU_DAGGER_12_B_RARE 1 ITEM_EU_DAGGER_12_C_RARE_FLASH -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238175 1 2 0 0 31 40 97 145 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 180 2492 2638 3046 3224 81.8 0 0 0 0 0 3511 3876 4291 4738 0 0 0 0 123 259 0 4 20 1 ITEM_EU_CROSSBOW_12_A_RARE_FLASH 1 ITEM_EU_CROSSBOW_12_B_RARE 1 ITEM_EU_CROSSBOW_12_C_RARE_FLASH -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238176 1 2 0 0 31 40 81 121 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 6 0 0 0 0 0 3988 4220 4874 5158 130.9 0 0 0 0 5617 6202 6866 7580 123 259 0 2 2 1 ITEM_EU_TSTAFF_12_A_RARE_FLASH 1 ITEM_EU_TSTAFF_12_B_RARE 1 ITEM_EU_TSTAFF_12_C_RARE_FLASH -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238177 1 2 0 0 31 40 161 242 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 0 0 0 0 0 3988 4220 4874 5158 130.9 0 0 0 0 5617 6202 6866 7580 123 259 0 2 2 1 ITEM_EU_DARKSTAFF_12_A_RARE_FLASH 1 ITEM_EU_DARKSTAFF_12_B_RARE 1 ITEM_EU_DARKSTAFF_12_C_RARE_FLASH -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238178 1 2 0 0 31 40 81 121 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 0 0 0 0 0 3988 4220 4874 5158 130.9 0 0 0 0 5617 6202 6866 7580 123 259 0 2 2 1 ITEM_EU_STAFF_12_A_RARE_FLASH 1 ITEM_EU_STAFF_12_B_RARE 1 ITEM_EU_STAFF_12_C_RARE_FLASH -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238179 1 2 0 0 31 40 73 109 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 6 0 0 0 0 0 3988 4220 4874 5158 130.9 0 0 0 0 5617 6202 6866 7580 123 259 0 2 2 1 ITEM_EU_HARP_12_A_RARE_FLASH 1 ITEM_EU_HARP_12_B_RARE 1 ITEM_EU_HARP_12_C_RARE_FLASH -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 0
2238180 1 2 0 0 31 42 85 127 276.9 293.1 8.2 0 0 0 0 0 0 14 23 443.1 468.9 13.1 0 0 0 390 431 624 689 0 0 0 0 0 0 2 0 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 ITEM_EU_SHIELD_12_A_RARE_FLASH 1 ITEM_EU_SHIELD_12_B_RARE 1 ITEM_EU_SHIELD_12_C_RARE_FLASH -1 xxx -1 xxx -1 xxx -1 xxx -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 ?? ??? ?? ?? ? 9 0 0
2238181 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
2238182 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[/QUOTE]
SRO_VT_SHARDLOG>Program>Procedures>_HamzaLockSyste mD15
كود PHP:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_HamzaLockSystemD15] Script Date: 20/05/2016 02:31:09 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_HamzaLockSystemD15]
@CharID Int
As
-- Declare expression.
Declare @CreaterName Varchar(60) = 'Spicoo' , -- Creater Name
@Slot Int = '13' , -- char inventory slot 1.
@ReqOptLevel Int = '0' , -- Requiared Opt Level to upgrade
@OptDifference Int = '2' , -- Set the difference optlevel between old plus and new plus.
@OldOptLevel Int ,
@NewOptLevel Int ,
@AdvValue Int ,
@ID64 Int ,
-------------------------
-- Set Old and New Item RefObjCommon ID below
-- Use This Query to get each item ID by Codename128
-- Select ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where CodeName128 Like 'Item Code Name'
---> Old weapon ID's ---> New weapons ID's
@Old_CH_SWORD_ID Int = 60362 , @New_CH_SWORD_ID Int = 60378 , --@New Chinese Sword
@Old_CH_BLADE_ID Int = 60363 , @New_CH_BLADE_ID Int = 60379 , --@Chinese Blade
@Old_CH_SPEAR_ID Int = 60364 , @New_CH_SPEAR_ID Int = 60380 , --@Chinese Spear
@Old_CH_TBLADE_ID Int = 60365 , @New_CH_TBLADE_ID Int = 60381 , --@Chinese Glaive
@Old_CH_BOW_ID Int = 60366 , @New_CH_BOW_ID Int = 60382 , --@Chinese Bow
@Old_CH_SHIELD_ID Int = 60367 , @New_CH_SHIELD_ID Int = 60383 , --@Chinese Shield
@Old_EU_DAGGER_ID Int = 60371 , @New_EU_DAGGER_ID Int = 60387 , --@European Dagger
@Old_EU_XBOW_ID Int = 60372 , @New_EU_XBOW_ID Int = 60388 , --@European CrossBow
@Old_EU_AXE_ID Int = 60370 , @New_EU_AXE_ID Int = 60386 , --@European Axe
@Old_EU_SWORD_ID Int = 60368 , @New_EU_SWORD_ID Int = 60384 , --@European One Hand Sword
@Old_EU_TSWORD_ID Int = 60369 , @New_EU_TSWORD_ID Int = 60385 , --@European Two Hand Sword
@Old_EU_TSTAFF_ID Int = 60373 , @New_EU_TSTAFF_ID Int = 60389 , --@European Two Hand Staff
@Old_EU_STAFF_ID Int = 60375 , @New_EU_STAFF_ID Int = 60391 , --@European Claric Rod
@Old_EU_DSTAFF_ID Int = 60374 , @New_EU_DSTAFF_ID Int = 60390 , --@European Warlock Rod
@Old_EU_HARP_ID Int = 60376 , @New_EU_HARP_ID Int = 60392 , --@European Harp
@Old_EU_SHIELD_ID Int = 60377 , @New_EU_SHIELD_ID Int = 60393 --@European Shield
--------------------------------------------------------------------------------------------
Set @ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @Slot and ItemID > 0)
Set @OldOptLevel = (Select OptLevel From [SRO_VT_SHARD].[dbo].[_Items] Where ID64 = @ID64)
-- Start Lock system :
-- First Case :
-- IF Item has not advanced elixir :
IF NOT EXISTS (Select * From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
Begin
IF @OldOptLevel >= @ReqOptLevel
Begin
Set @NewOptLevel = @OldOptLevel - @OptDifference
-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SWORD_ID and (OptLevel = @OldOptLevel) --@Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BLADE_ID and (OptLevel = @OldOptLevel) --@Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SPEAR_ID and (OptLevel = @OldOptLevel) --@Spear
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_TBLADE_ID and (OptLevel = @OldOptLevel) --@T-Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BOW_ID and (OptLevel = @OldOptLevel) --@Bow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
-- EU Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DAGGER_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DAGGER_ID and (OptLevel = @OldOptLevel) --@Dagger
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_XBOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_XBOW_ID and (OptLevel = @OldOptLevel) --@Crossbow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_AXE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_AXE_ID and (OptLevel = @OldOptLevel) --@Axe
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SWORD_ID and (OptLevel = @OldOptLevel) --@OneHand Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSWORD_ID and (OptLevel = @OldOptLevel) --@T-Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSTAFF_ID and (OptLevel = @OldOptLevel) --@T-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_STAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_STAFF_ID and (OptLevel = @OldOptLevel) --@Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DSTAFF_ID and (OptLevel = @OldOptLevel) --@Dark-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_HARP_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_HARP_ID and (OptLevel = @OldOptLevel) --@Harp
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
End
End
-- Second Case :
-- IF Item has advanced elixir :
ELSE IF EXISTS (Select * From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
Begin
Set @AdvValue = (Select nOptValue From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
IF @OldOptLevel >= @ReqOptLevel
Begin
Set @NewOptLevel = (@OldOptLevel - @OptDifference) + @AdvValue
-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SWORD_ID and (OptLevel = @OldOptLevel) --@Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BLADE_ID and (OptLevel = @OldOptLevel) --@Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SPEAR_ID and (OptLevel = @OldOptLevel) --@Spear
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_TBLADE_ID and (OptLevel = @OldOptLevel) --@T-Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BOW_ID and (OptLevel = @OldOptLevel) --@Bow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
-- EU Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DAGGER_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DAGGER_ID and (OptLevel = @OldOptLevel) --@Dagger
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_XBOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_XBOW_ID and (OptLevel = @OldOptLevel) --@Crossbow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_AXE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_AXE_ID and (OptLevel = @OldOptLevel) --@Axe
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SWORD_ID and (OptLevel = @OldOptLevel) --@OneHand Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSWORD_ID and (OptLevel = @OldOptLevel) --@T-Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSTAFF_ID and (OptLevel = @OldOptLevel) --@T-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_STAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_STAFF_ID and (OptLevel = @OldOptLevel) --@Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DSTAFF_ID and (OptLevel = @OldOptLevel) --@Dark-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_HARP_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_HARP_ID and (OptLevel = @OldOptLevel) --@Harp
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
End
End
SRO_VT_SHARDLOG>Program>Procedures>_HamzaLockSyste mD15Unlock
كود PHP:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_HamzaLockSystemD15Unlock] Script Date: 20/05/2016 02:33:51 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_HamzaLockSystemD15Unlock]
@CharID Int
As
-- Declare expression.
Declare @CreaterName Varchar(60) = 'Spicoo' , -- Creater Name
@Slot Int = '13' , -- char inventory slot 1.
@ReqOptLevel Int = '0' , -- Requiared Opt Level to upgrade
@OptDifference Int = '2' , -- Set the difference optlevel between old plus and new plus.
@OldOptLevel Int ,
@NewOptLevel Int ,
@AdvValue Int ,
@ID64 Int ,
-------------------------
-- Set Old and New Item RefObjCommon ID below
-- Use This Query to get each item ID by Codename128
-- Select ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where CodeName128 Like 'Item Code Name'
---> Old weapon ID's ---> New weapons ID's
@Old_CH_SWORD_ID Int = 60378 , @New_CH_SWORD_ID Int = 60362 , --@New Chinese Sword
@Old_CH_BLADE_ID Int = 60379 , @New_CH_BLADE_ID Int = 60363 , --@Chinese Blade
@Old_CH_SPEAR_ID Int = 60380 , @New_CH_SPEAR_ID Int = 60364 , --@Chinese Spear
@Old_CH_TBLADE_ID Int = 60381 , @New_CH_TBLADE_ID Int = 60365 , --@Chinese Glaive
@Old_CH_BOW_ID Int = 60382 , @New_CH_BOW_ID Int = 60366 , --@Chinese Bow
@Old_CH_SHIELD_ID Int = 60383 , @New_CH_SHIELD_ID Int = 60367 , --@Chinese Shield
@Old_EU_SWORD_ID Int = 60384 , @New_EU_SWORD_ID Int = 60368 , --@European One Hand Sword
@Old_EU_TSWORD_ID Int = 60385 , @New_EU_TSWORD_ID Int = 60369 , --@European Two Hand Sword
@Old_EU_AXE_ID Int = 60386 , @New_EU_AXE_ID Int = 60370 , --@European Axe
@Old_EU_DAGGER_ID Int = 60387 , @New_EU_DAGGER_ID Int = 60371 , --@European Dagger
@Old_EU_XBOW_ID Int = 60388 , @New_EU_XBOW_ID Int = 60372 , --@European CrossBow
@Old_EU_TSTAFF_ID Int = 60389 , @New_EU_TSTAFF_ID Int = 60373 , --@European Two Hand Staff
@Old_EU_DSTAFF_ID Int = 60390 , @New_EU_DSTAFF_ID Int = 60374 , --@European Warlock Rod
@Old_EU_STAFF_ID Int = 60391 , @New_EU_STAFF_ID Int = 60375 , --@European Claric Rod
@Old_EU_HARP_ID Int = 60392 , @New_EU_HARP_ID Int = 60376 , --@European Harp
@Old_EU_SHIELD_ID Int = 60393 , @New_EU_SHIELD_ID Int = 60377 --@European Shield
--------------------------------------------------------------------------------------------
Set @ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @Slot and ItemID > 0)
Set @OldOptLevel = (Select OptLevel From [SRO_VT_SHARD].[dbo].[_Items] Where ID64 = @ID64)
-- Start Lock system :
-- First Case :
-- IF Item has not advanced elixir :
IF NOT EXISTS (Select * From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
Begin
IF @OldOptLevel >= @ReqOptLevel
Begin
Set @NewOptLevel = @OldOptLevel - @OptDifference
-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SWORD_ID and (OptLevel = @OldOptLevel) --@Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BLADE_ID and (OptLevel = @OldOptLevel) --@Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SPEAR_ID and (OptLevel = @OldOptLevel) --@Spear
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_TBLADE_ID and (OptLevel = @OldOptLevel) --@T-Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BOW_ID and (OptLevel = @OldOptLevel) --@Bow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
-- EU Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DAGGER_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DAGGER_ID and (OptLevel = @OldOptLevel) --@Dagger
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_XBOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_XBOW_ID and (OptLevel = @OldOptLevel) --@Crossbow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_AXE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_AXE_ID and (OptLevel = @OldOptLevel) --@Axe
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SWORD_ID and (OptLevel = @OldOptLevel) --@OneHand Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSWORD_ID and (OptLevel = @OldOptLevel) --@T-Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSTAFF_ID and (OptLevel = @OldOptLevel) --@T-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_STAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_STAFF_ID and (OptLevel = @OldOptLevel) --@Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DSTAFF_ID and (OptLevel = @OldOptLevel) --@Dark-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_HARP_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_HARP_ID and (OptLevel = @OldOptLevel) --@Harp
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
End
End
-- Second Case :
-- IF Item has advanced elixir :
ELSE IF EXISTS (Select * From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
Begin
Set @AdvValue = (Select nOptValue From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
IF @OldOptLevel >= @ReqOptLevel
Begin
Set @NewOptLevel = (@OldOptLevel - @OptDifference) + @AdvValue
-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SWORD_ID and (OptLevel = @OldOptLevel) --@Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BLADE_ID and (OptLevel = @OldOptLevel) --@Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SPEAR_ID and (OptLevel = @OldOptLevel) --@Spear
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_TBLADE_ID and (OptLevel = @OldOptLevel) --@T-Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BOW_ID and (OptLevel = @OldOptLevel) --@Bow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
-- EU Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DAGGER_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DAGGER_ID and (OptLevel = @OldOptLevel) --@Dagger
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_XBOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_XBOW_ID and (OptLevel = @OldOptLevel) --@Crossbow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_AXE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_AXE_ID and (OptLevel = @OldOptLevel) --@Axe
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SWORD_ID and (OptLevel = @OldOptLevel) --@OneHand Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSWORD_ID and (OptLevel = @OldOptLevel) --@T-Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSTAFF_ID and (OptLevel = @OldOptLevel) --@T-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_STAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_STAFF_ID and (OptLevel = @OldOptLevel) --@Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DSTAFF_ID and (OptLevel = @OldOptLevel) --@Dark-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_HARP_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_HARP_ID and (OptLevel = @OldOptLevel) --@Harp
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
End
End
ودا ال AddLogItem
كود PHP:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 24/05/2016 04:00:31 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-------------------------------------------------------------------------------------------------------------------
-- Step 2
-- ±âأپ¸ ¾أ†أ€أŒأ…أ› ·أژ±× أ€أ”·أ‚ Stored procedure ¼أ¶أپ¤
-- DataBase : Shard Log
ALTER procedure [dbo].[_AddLogItem]
@CharID int,
@ItemRefID int,
@ItemSerial bigint,
@dwData int,
@TargetStorage tinyint,
@Operation tinyint,
@Slot_From tinyint,
@Slot_To tinyint,
@EventPos varchar(64),
@strDesc varchar(128),
@Gold bigint -- #ifdef EXTEND_GOLD_TYPE »أ°أ€أ”
as
declare @len_pos int
declare @len_desc int
declare @strDesc_separado varchar(128)
declare @len_desc1 int
set @len_pos = len(@EventPos)
set @len_desc = len(@strDesc)
if (@len_pos > 0 and @len_desc > 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, strDesc, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أƒ¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @strDesc, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أƒ¼
end
else if (@len_pos > 0 and @len_desc = 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أƒ¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أƒ¼
end
else if (@len_pos = 0 and @len_desc > 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, strDesc, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أƒ¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @strDesc, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أƒ¼
end
else if (@len_pos = 0 and @len_desc = 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أƒ¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أƒ¼
end
-- أ€¯·أ، ¾أ†أ€أŒأ…أ› ±¸أ€أ”أ€أŒ¸é!
-- #define LOG_ITEMEVENT_BUY_CASHITEM (BYTE)35
if (@Operation = 35)
begin
insert _LogCashItem (RefItemID, CharID, Cnt, EventTime, Serial64)
values(@ItemRefID, @CharID, @dwData, GetDate(), @ItemSerial)
end
if (@Operation = 90 OR @Operation = 160)
begin
set @len_desc1 = CHARINDEX (']',@strDesc)
if(@len_desc1 = 9)
begin
set @strDesc = SUBSTRING(@strDesc,0,9)
set @strDesc_separado = SUBSTRING(@strDesc, 8, 1)
end
else if(@len_desc1 = 10)
begin
set @strDesc = SUBSTRING(@strDesc,0,10)
set @strDesc_separado = SUBSTRING(@strDesc, 8, 2)
end
if(@strDesc_separado >= 8 and @strDesc_separado < 16)
begin
--set @strDesc_separado = @len_desc1
insert _LogItemPlus(CharID, Serial64, Plus, Data, Lido) values(@CharID, @ItemSerial, @strDesc_separado, GetDate(), '0')
end
end
-------------------------------
IF (@operation = 41 and @ItemRefID = '60394')
Begin
Declare @ID64 Int , @RefItemID Int , @NewRefID Int
Select Top 1 @ID64 = Inv.ItemID , @RefItemID = Items.RefItemID From [SRO_VT_SHARD].[dbo].[_Inventory] As Inv Inner Join [SRO_VT_SHARD].[dbo].[_Items] As Items ON Inv.ItemID = Items.ID64 Where Inv.CharID = @CharID and Inv.ItemID > 0 and Inv.Slot = 13
Select Top 1 @NewRefID = LockItemID From [dbo].[LockItemsID] Where ReqItemID = @RefItemID
IF @NewRefID IS NOT NULL and @ID64 IS NOT NULL
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @NewRefID Where ID64 = @ID64
End
End
-- Unlock
IF (@operation = 41 and @ItemRefID = '60395')
Begin
Select Top 1 @ID64 = Inv.ItemID , @RefItemID = Items.RefItemID From [SRO_VT_SHARD].[dbo].[_Inventory] As Inv Inner Join [SRO_VT_SHARD].[dbo].[_Items] As Items ON Inv.ItemID = Items.ID64 Where Inv.CharID = @CharID and Inv.ItemID > 0 and Inv.Slot = 13
Select Top 1 @NewRefID = ReqItemID From [dbo].[LockItemsID] Where LockItemID = @RefItemID
IF @NewRefID IS NOT NULL and @ID64 IS NOT NULL
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @NewRefID Where ID64 = @ID64
End
End
المشكله اما باجي ادرب الاسكرول بتيجي عامله تيلبوت علي طوا من غير متغير اي حاجه
|
شـريـط الاهـداءات
21-05-2016, 07:00 PM
العرض الشجري