AmIMad

Bakalım be.
Kayıt
7 Şubat 2015
Mesajlar
412
Beğeniler
45
Şehir
Ankara
Merhaba Arkadaşlar Konu Daha önce vardı fakat güncel versionnu yoktu bu yenisidir

RefObjCommon

Kod:
    41925    ITEM_STORXY_MASTERY_PACHEON    ?????    xxx    SN_ITEM_STORXY_MASTERY_PACHEON    SN_ITEM_STORXY_MASTERY_PACHEON_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_bow.ddj    xxx    xxx    21443
1    41926    ITEM_STORXY_MASTERY_HEUKSAL    ?????    xxx    SN_ITEM_STORXY_MASTERY_HEUKSAL    SN_ITEM_STORXY_MASTERY_HEUKSAL_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_spear.ddj    xxx    xxx    21444
1    41927    ITEM_STORXY_MASTERY_BICHEON    ?????    xxx    SN_ITEM_STORXY_MASTERY_BICHEON    SN_ITEM_STORXY_MASTERY_BICHEON_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_sword.ddj    xxx    xxx    21445
1    41928    ITEM_STORXY_MASTERY_FIRE    ?????    xxx    SN_ITEM_STORXY_MASTERY_FIRE    SN_ITEM_STORXY_MASTERY_FIRE_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_fire.ddj    xxx    xxx    21446
1    41929    ITEM_STORXY_MASTERY_LIGHTNING    ?????    xxx    SN_ITEM_STORXY_MASTERY_LIGHTNING    SN_ITEM_STORXY_MASTERY_LIGHTNING_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_lightning.ddj    xxx    xxx    21447
1    41930    ITEM_STORXY_MASTERY_COLD    ?????    xxx    SN_ITEM_STORXY_MASTERY_COLD    SN_ITEM_STORXY_MASTERY_COLD_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_cold.ddj    xxx    xxx    21448
1    41931    ITEM_STORXY_MASTERY_FORCE    ?????    xxx    SN_ITEM_STORXY_MASTERY_FORCE    SN_ITEM_STORXY_MASTERY_FORCE_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_water.ddj    xxx    xxx    21449
1    41932    ITEM_STORXY_MASTERY_WIZARD    ?????    xxx    SN_ITEM_STORXY_MASTERY_WIZARD    SN_ITEM_STORXY_MASTERY_WIZARD_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_wizard.ddj    xxx    xxx    21450
1    41933    ITEM_STORXY_MASTERY_WARRIOR    ?????    xxx    SN_ITEM_STORXY_MASTERY_WARRIOR    SN_ITEM_STORXY_MASTERY_WARRIOR_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_warrior.ddj    xxx    xxx    21451
1    41934    ITEM_STORXY_MASTERY_ROUGE    ?????    xxx    SN_ITEM_STORXY_MASTERY_ROUGE    SN_ITEM_STORXY_MASTERY_ROUGE_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_rog.ddj    xxx    xxx    21452
1    41935    ITEM_STORXY_MASTERY_CLERICE    ?????    xxx    SN_ITEM_STORXY_MASTERY_CLERIC    SN_ITEM_STORXY_MASTERY_CLERIC_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_cleric.ddj    xxx    xxx    21453
1    41936    ITEM_STORXY_MASTERY_BARD    ?????    xxx    SN_ITEM_STORXY_MASTERY_BARD    SN_ITEM_STORXY_MASTERY_BARD_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_bard.ddj    xxx    xxx    21454
1    41937    ITEM_STORXY_MASTERY_WARLOCK    ?????    xxx    SN_ITEM_STORXY_MASTERY_WARLOCK    SN_ITEM_STORXY_MASTERY_WARLOCK_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_warlock.ddj    xxx    xxx    21455

RefObjItem
Kod:
21443    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21444    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21445    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21446    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21447    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21448    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21449    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21450    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21451    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21452    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21453    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21454    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21455    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0

Itemdata_xxxxx.txt
Kod:
1    41925    ITEM_STORXY_MASTERY_PACHEON    ?????    xxx    SN_ITEM_STORXY_MASTERY_PACHEON    SN_ITEM_STORXY_MASTERY_PACHEON_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_bow.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0   
1    41926    ITEM_STORXY_MASTERY_HEUKSAL    ?????    xxx    SN_ITEM_STORXY_MASTERY_HEUKSAL    SN_ITEM_STORXY_MASTERY_HEUKSAL_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_spear.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0  
1    41927    ITEM_STORXY_MASTERY_BICHEON    ?????    xxx    SN_ITEM_STORXY_MASTERY_BICHEON    SN_ITEM_STORXY_MASTERY_BICHEON_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_sword.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0  
1    41928    ITEM_STORXY_MASTERY_FIRE    ?????    xxx    SN_ITEM_STORXY_MASTERY_FIRE    SN_ITEM_STORXY_MASTERY_FIRE_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_fire.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0  
1    41929    ITEM_STORXY_MASTERY_LIGHTNING    ?????    xxx    SN_ITEM_STORXY_MASTERY_LIGHTNING    SN_ITEM_STORXY_MASTERY_LIGHTNING_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_lightning.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0  
1    41930    ITEM_STORXY_MASTERY_COLD    ?????    xxx    SN_ITEM_STORXY_MASTERY_COLD    SN_ITEM_STORXY_MASTERY_COLD_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_cold.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0  
1    41931    ITEM_STORXY_MASTERY_FORCE    ?????    xxx    SN_ITEM_STORXY_MASTERY_FORCE    SN_ITEM_STORXY_MASTERY_FORCE_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_water.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0  
1    41932    ITEM_STORXY_MASTERY_WIZARD    ?????    xxx    SN_ITEM_STORXY_MASTERY_WIZARD    SN_ITEM_STORXY_MASTERY_WIZARD_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_wizard.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0  
1    41933    ITEM_STORXY_MASTERY_WARRIOR    ?????    xxx    SN_ITEM_STORXY_MASTERY_WARRIOR    SN_ITEM_STORXY_MASTERY_WARRIOR_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_warrior.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0  
1    41934    ITEM_STORXY_MASTERY_ROUGE    ?????    xxx    SN_ITEM_STORXY_MASTERY_ROUGE    SN_ITEM_STORXY_MASTERY_ROUGE_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_rog.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0  
1    41935    ITEM_STORXY_MASTERY_CLERICE    ?????    xxx    SN_ITEM_STORXY_MASTERY_CLERIC    SN_ITEM_STORXY_MASTERY_CLERIC_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_cleric.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0  
1    41936    ITEM_STORXY_MASTERY_BARD    ?????    xxx    SN_ITEM_STORXY_MASTERY_BARD    SN_ITEM_STORXY_MASTERY_BARD_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_bard.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0  
1    41937    ITEM_STORXY_MASTERY_WARLOCK    ?????    xxx    SN_ITEM_STORXY_MASTERY_WARLOCK    SN_ITEM_STORXY_MASTERY_WARLOCK_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_warlock.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0
Textdata_Object.txt

Kod:
1    SN_ITEM_STORXY_MASTERY_PACHEON                            Mastery Level Up (Pacheon)
1    SN_ITEM_STORXY_MASTERY_HEUKSAL                            Mastery Level Up (Heuksal)
1    SN_ITEM_STORXY_MASTERY_BICHEON                            Mastery Level Up (Bicheon)
1    SN_ITEM_STORXY_MASTERY_FIRE                            Mastery Level Up (Fire)
1    SN_ITEM_STORXY_MASTERY_LIGHTNING                            Mastery Level Up (Lightning)
1    SN_ITEM_STORXY_MASTERY_COLD                            Mastery Level Up (Cold)
1    SN_ITEM_STORXY_MASTERY_FORCE                            Mastery Level Up (Force)
1    SN_ITEM_STORXY_MASTERY_WIZARD                            Mastery Level Up (Wizard)
1    SN_ITEM_STORXY_MASTERY_WARRIOR                            Mastery Level Up (Warrior)
1    SN_ITEM_STORXY_MASTERY_ROUGE                            Mastery Level Up (Rouge)
1    SN_ITEM_STORXY_MASTERY_CLERIC                            Mastery Level Up (Cleric)
1    SN_ITEM_STORXY_MASTERY_BARD                            Mastery Level Up (Bard)
1    SN_ITEM_STORXY_MASTERY_WARLOCK                            Mastery Level Up (Warlock)
Proseturlere Geçiyoruz

AddLogItem >>> Kodlarınızı Düzenleyin Yoksa Çalışmıyacaktır
Kod:
  ---------------------------STORXY--------------------------------------------------------------   [/B]
[B]    IF (@Operation=41 AND @ItemRefID BETWEEN 41932 AND 41937) ---------------- European Mastery Scrolls -------------------
    BEGIN
    IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE MasteryID='513')
    BEGIN
    DECLARE @Wizard INT,@Warrior INT,@Rouge INT,@Warlock INT,@Bard INT,@Cleric INT
    SELECT @Wizard=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='514'
    SELECT @Warrior=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='513'
    SELECT @Rouge=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='515'
    SELECT @Warlock=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='516'
    SELECT @Bard=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='517'
    SELECT @Cleric=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='518'
    IF (@Wizard+@Warrior+@Rouge+@Warlock+@Bard+@Cleric<='110')
    BEGIN
    DECLARE @EuropeanMasteryType INT;
            SET @EuropeanMasteryType = CASE
                WHEN @ItemRefID=41932 --------------- Wizard
                THEN 514
                WHEN @ItemRefID=41933 --------------- Warrior
                THEN 513
                WHEN @ItemRefID=41934 --------------- Rouge
                THEN 515
                WHEN @ItemRefID=41935 --------------- Cleric
                THEN 518
                WHEN @ItemRefID=41936 --------------- Bard
                THEN 517
                WHEN @ItemRefID=41937 --------------- Warlock
                THEN 516
                END
    UPDATE SRO_VT_SHARD.dbo._CharSkillMastery SET [Level]='110' WHERE CharID=@CharID AND MasteryID=@EuropeanMasteryType
    INSERT SRO_VT_SHARD.dbo._CharSkill SELECT @CharID,SkillID,'1' FROM SRO_VT_SHARDLOG.dbo._CharacterSkills WHERE MasteryID=@EuropeanMasteryType
    END
    END
    END
    IF (@Operation=41 AND @ItemRefID BETWEEN 41925 AND 41931) ---------------- Chinese Mastery Scrolls -------------------
    BEGIN
    IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE MasteryID='257')
    BEGIN
    DECLARE @Bicheon INT,@Heuksal INT,@Pacheon INT,@Cold INT,@Lightning INT,@Fire INT,@Force INT
    SELECT @Bicheon=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='257'
    SELECT @Heuksal=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='258'
    SELECT @Pacheon=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='259'
    SELECT @Cold=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='273'
    SELECT @Lightning=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='274'
    SELECT @Fire=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='275'
    SELECT @Force=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='276'
    IF (@Bicheon+@Heuksal+@Pacheon+@Cold+@Lightning+@Fire+@Force <='220')
    BEGIN
    DECLARE @ChineseMasteryType INT;
            SET @ChineseMasteryType = Case
                WHEN @ItemRefID=41927   ---------------    Bacheon
                THEN 257
                WHEN @ItemRefID=41926   ---------------    Heuksal
                THEN 258
                WHEN @ItemRefID=41925   ---------------    Pacheon
                THEN 259
                WHEN @ItemRefID=41930   ---------------    Cold
                THEN 273
                WHEN @ItemRefID=41929   ---------------    Lightning
                THEN 274
                WHEN @ItemRefID=41928   ---------------    Fire
                THEN 275
                WHEN @ItemRefID=41931   ---------------    Foce
                THEN 276
                END
    UPDATE SRO_VT_SHARD.dbo._CharSkillMastery SET [Level]='110' WHERE CharID=@CharID AND MasteryID=@ChineseMasteryType
    INSERT SRO_VT_SHARD.dbo._CharSkill SELECT @CharID,SkillID,'1' FROM SRO_VT_SHARDLOG.dbo._CharacterSkills WHERE MasteryID=@ChineseMasteryType
    END
    END
    END
    ---------------------------STORXY--------------------------------------------------------------
Okutun
Kod:
USE [SRO_VT_SHARDLOG]
GO

/****** Object:  Table [dbo].[_CharacterSkills]    Script Date: 19/04/2016 09:12:04 ? ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_CharacterSkills](
    [SkillID] [int] NOT NULL,
    [Build] [varchar](50) NOT NULL,
    [Race] [varchar](50) NOT NULL,
    [MasteryID] [int] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

İndirme Link >>> Bana Tıkla
Rar Şifresi >>>> STORXY







 
Kayıt
30 Nisan 2010
Mesajlar
125
Beğeniler
8
Şehir
İstanbul
Takımı
Fenerbahce
Merhaba Arkadaşlar Konu Daha önce vardı fakat güncel versionnu yoktu bu yenisidir

RefObjCommon

Kod:
    41925    ITEM_STORXY_MASTERY_PACHEON    ?????    xxx    SN_ITEM_STORXY_MASTERY_PACHEON    SN_ITEM_STORXY_MASTERY_PACHEON_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_bow.ddj    xxx    xxx    21443
1    41926    ITEM_STORXY_MASTERY_HEUKSAL    ?????    xxx    SN_ITEM_STORXY_MASTERY_HEUKSAL    SN_ITEM_STORXY_MASTERY_HEUKSAL_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_spear.ddj    xxx    xxx    21444
1    41927    ITEM_STORXY_MASTERY_BICHEON    ?????    xxx    SN_ITEM_STORXY_MASTERY_BICHEON    SN_ITEM_STORXY_MASTERY_BICHEON_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_sword.ddj    xxx    xxx    21445
1    41928    ITEM_STORXY_MASTERY_FIRE    ?????    xxx    SN_ITEM_STORXY_MASTERY_FIRE    SN_ITEM_STORXY_MASTERY_FIRE_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_fire.ddj    xxx    xxx    21446
1    41929    ITEM_STORXY_MASTERY_LIGHTNING    ?????    xxx    SN_ITEM_STORXY_MASTERY_LIGHTNING    SN_ITEM_STORXY_MASTERY_LIGHTNING_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_lightning.ddj    xxx    xxx    21447
1    41930    ITEM_STORXY_MASTERY_COLD    ?????    xxx    SN_ITEM_STORXY_MASTERY_COLD    SN_ITEM_STORXY_MASTERY_COLD_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_cold.ddj    xxx    xxx    21448
1    41931    ITEM_STORXY_MASTERY_FORCE    ?????    xxx    SN_ITEM_STORXY_MASTERY_FORCE    SN_ITEM_STORXY_MASTERY_FORCE_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_water.ddj    xxx    xxx    21449
1    41932    ITEM_STORXY_MASTERY_WIZARD    ?????    xxx    SN_ITEM_STORXY_MASTERY_WIZARD    SN_ITEM_STORXY_MASTERY_WIZARD_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_wizard.ddj    xxx    xxx    21450
1    41933    ITEM_STORXY_MASTERY_WARRIOR    ?????    xxx    SN_ITEM_STORXY_MASTERY_WARRIOR    SN_ITEM_STORXY_MASTERY_WARRIOR_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_warrior.ddj    xxx    xxx    21451
1    41934    ITEM_STORXY_MASTERY_ROUGE    ?????    xxx    SN_ITEM_STORXY_MASTERY_ROUGE    SN_ITEM_STORXY_MASTERY_ROUGE_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_rog.ddj    xxx    xxx    21452
1    41935    ITEM_STORXY_MASTERY_CLERICE    ?????    xxx    SN_ITEM_STORXY_MASTERY_CLERIC    SN_ITEM_STORXY_MASTERY_CLERIC_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_cleric.ddj    xxx    xxx    21453
1    41936    ITEM_STORXY_MASTERY_BARD    ?????    xxx    SN_ITEM_STORXY_MASTERY_BARD    SN_ITEM_STORXY_MASTERY_BARD_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_bard.ddj    xxx    xxx    21454
1    41937    ITEM_STORXY_MASTERY_WARLOCK    ?????    xxx    SN_ITEM_STORXY_MASTERY_WARLOCK    SN_ITEM_STORXY_MASTERY_WARLOCK_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_warlock.ddj    xxx    xxx    21455

RefObjItem
Kod:
21443    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21444    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21445    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21446    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21447    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21448    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21449    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21450    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21451    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21452    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21453    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21454    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21455    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0

Itemdata_xxxxx.txt
Kod:
1    41925    ITEM_STORXY_MASTERY_PACHEON    ?????    xxx    SN_ITEM_STORXY_MASTERY_PACHEON    SN_ITEM_STORXY_MASTERY_PACHEON_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_bow.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0   
1    41926    ITEM_STORXY_MASTERY_HEUKSAL    ?????    xxx    SN_ITEM_STORXY_MASTERY_HEUKSAL    SN_ITEM_STORXY_MASTERY_HEUKSAL_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_spear.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0 
1    41927    ITEM_STORXY_MASTERY_BICHEON    ?????    xxx    SN_ITEM_STORXY_MASTERY_BICHEON    SN_ITEM_STORXY_MASTERY_BICHEON_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_sword.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0 
1    41928    ITEM_STORXY_MASTERY_FIRE    ?????    xxx    SN_ITEM_STORXY_MASTERY_FIRE    SN_ITEM_STORXY_MASTERY_FIRE_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_fire.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0 
1    41929    ITEM_STORXY_MASTERY_LIGHTNING    ?????    xxx    SN_ITEM_STORXY_MASTERY_LIGHTNING    SN_ITEM_STORXY_MASTERY_LIGHTNING_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_lightning.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0 
1    41930    ITEM_STORXY_MASTERY_COLD    ?????    xxx    SN_ITEM_STORXY_MASTERY_COLD    SN_ITEM_STORXY_MASTERY_COLD_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_cold.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0 
1    41931    ITEM_STORXY_MASTERY_FORCE    ?????    xxx    SN_ITEM_STORXY_MASTERY_FORCE    SN_ITEM_STORXY_MASTERY_FORCE_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_water.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0 
1    41932    ITEM_STORXY_MASTERY_WIZARD    ?????    xxx    SN_ITEM_STORXY_MASTERY_WIZARD    SN_ITEM_STORXY_MASTERY_WIZARD_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_wizard.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0 
1    41933    ITEM_STORXY_MASTERY_WARRIOR    ?????    xxx    SN_ITEM_STORXY_MASTERY_WARRIOR    SN_ITEM_STORXY_MASTERY_WARRIOR_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_warrior.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0 
1    41934    ITEM_STORXY_MASTERY_ROUGE    ?????    xxx    SN_ITEM_STORXY_MASTERY_ROUGE    SN_ITEM_STORXY_MASTERY_ROUGE_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_rog.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0 
1    41935    ITEM_STORXY_MASTERY_CLERICE    ?????    xxx    SN_ITEM_STORXY_MASTERY_CLERIC    SN_ITEM_STORXY_MASTERY_CLERIC_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_cleric.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0 
1    41936    ITEM_STORXY_MASTERY_BARD    ?????    xxx    SN_ITEM_STORXY_MASTERY_BARD    SN_ITEM_STORXY_MASTERY_BARD_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_bard.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0 
1    41937    ITEM_STORXY_MASTERY_WARLOCK    ?????    xxx    SN_ITEM_STORXY_MASTERY_WARLOCK    SN_ITEM_STORXY_MASTERY_WARLOCK_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_warlock.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0
Textdata_Object.txt

Kod:
1    SN_ITEM_STORXY_MASTERY_PACHEON                            Mastery Level Up (Pacheon)
1    SN_ITEM_STORXY_MASTERY_HEUKSAL                            Mastery Level Up (Heuksal)
1    SN_ITEM_STORXY_MASTERY_BICHEON                            Mastery Level Up (Bicheon)
1    SN_ITEM_STORXY_MASTERY_FIRE                            Mastery Level Up (Fire)
1    SN_ITEM_STORXY_MASTERY_LIGHTNING                            Mastery Level Up (Lightning)
1    SN_ITEM_STORXY_MASTERY_COLD                            Mastery Level Up (Cold)
1    SN_ITEM_STORXY_MASTERY_FORCE                            Mastery Level Up (Force)
1    SN_ITEM_STORXY_MASTERY_WIZARD                            Mastery Level Up (Wizard)
1    SN_ITEM_STORXY_MASTERY_WARRIOR                            Mastery Level Up (Warrior)
1    SN_ITEM_STORXY_MASTERY_ROUGE                            Mastery Level Up (Rouge)
1    SN_ITEM_STORXY_MASTERY_CLERIC                            Mastery Level Up (Cleric)
1    SN_ITEM_STORXY_MASTERY_BARD                            Mastery Level Up (Bard)
1    SN_ITEM_STORXY_MASTERY_WARLOCK                            Mastery Level Up (Warlock)
Proseturlere Geçiyoruz

AddLogItem >>> Kodlarınızı Düzenleyin Yoksa Çalışmıyacaktır
Kod:
  ---------------------------STORXY--------------------------------------------------------------   [/B][/B]
[B][B]    IF (@Operation=41 AND @ItemRefID BETWEEN 41932 AND 41937) ---------------- European Mastery Scrolls -------------------
    BEGIN
    IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE MasteryID='513')
    BEGIN
    DECLARE @Wizard INT,@Warrior INT,@Rouge INT,@Warlock INT,@Bard INT,@Cleric INT
    SELECT @Wizard=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='514'
    SELECT @Warrior=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='513'
    SELECT @Rouge=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='515'
    SELECT @Warlock=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='516'
    SELECT @Bard=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='517'
    SELECT @Cleric=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='518'
    IF (@Wizard+@Warrior+@Rouge+@Warlock+@Bard+@Cleric<='110')
    BEGIN
    DECLARE @EuropeanMasteryType INT;
            SET @EuropeanMasteryType = CASE
                WHEN @ItemRefID=41932 --------------- Wizard
                THEN 514
                WHEN @ItemRefID=41933 --------------- Warrior
                THEN 513
                WHEN @ItemRefID=41934 --------------- Rouge
                THEN 515
                WHEN @ItemRefID=41935 --------------- Cleric
                THEN 518
                WHEN @ItemRefID=41936 --------------- Bard
                THEN 517
                WHEN @ItemRefID=41937 --------------- Warlock
                THEN 516
                END
    UPDATE SRO_VT_SHARD.dbo._CharSkillMastery SET [Level]='110' WHERE CharID=@CharID AND MasteryID=@EuropeanMasteryType
    INSERT SRO_VT_SHARD.dbo._CharSkill SELECT @CharID,SkillID,'1' FROM SRO_VT_SHARDLOG.dbo._CharacterSkills WHERE MasteryID=@EuropeanMasteryType
    END
    END
    END
    IF (@Operation=41 AND @ItemRefID BETWEEN 41925 AND 41931) ---------------- Chinese Mastery Scrolls -------------------
    BEGIN
    IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE MasteryID='257')
    BEGIN
    DECLARE @Bicheon INT,@Heuksal INT,@Pacheon INT,@Cold INT,@Lightning INT,@Fire INT,@Force INT
    SELECT @Bicheon=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='257'
    SELECT @Heuksal=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='258'
    SELECT @Pacheon=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='259'
    SELECT @Cold=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='273'
    SELECT @Lightning=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='274'
    SELECT @Fire=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='275'
    SELECT @Force=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='276'
    IF (@Bicheon+@Heuksal+@Pacheon+@Cold+@Lightning+@Fire+@Force <='220')
    BEGIN
    DECLARE @ChineseMasteryType INT;
            SET @ChineseMasteryType = Case
                WHEN @ItemRefID=41927   ---------------    Bacheon
                THEN 257
                WHEN @ItemRefID=41926   ---------------    Heuksal
                THEN 258
                WHEN @ItemRefID=41925   ---------------    Pacheon
                THEN 259
                WHEN @ItemRefID=41930   ---------------    Cold
                THEN 273
                WHEN @ItemRefID=41929   ---------------    Lightning
                THEN 274
                WHEN @ItemRefID=41928   ---------------    Fire
                THEN 275
                WHEN @ItemRefID=41931   ---------------    Foce
                THEN 276
                END
    UPDATE SRO_VT_SHARD.dbo._CharSkillMastery SET [Level]='110' WHERE CharID=@CharID AND MasteryID=@ChineseMasteryType
    INSERT SRO_VT_SHARD.dbo._CharSkill SELECT @CharID,SkillID,'1' FROM SRO_VT_SHARDLOG.dbo._CharacterSkills WHERE MasteryID=@ChineseMasteryType
    END
    END
    END
    ---------------------------STORXY--------------------------------------------------------------
Okutun
Kod:
USE [SRO_VT_SHARDLOG]
GO

/****** Object:  Table [dbo].[_CharacterSkills]    Script Date: 19/04/2016 09:12:04 ? ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_CharacterSkills](
    [SkillID] [int] NOT NULL,
    [Build] [varchar](50) NOT NULL,
    [Race] [varchar](50) NOT NULL,
    [MasteryID] [int] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

İndirme Link >>> Bana Tıkla
Rar Şifresi >>>> STORXY







Yararlı bir paylaşım olmuş teşekkürler.
 

defender92

BLueSRo
Kayıt
2 Temmuz 2014
Mesajlar
6
Beğeniler
0
Şehir
İstanbul
Server
Seçiniz...
Takımı
Fenerbahce
Merhaba Arkadaşlar Konu Daha önce vardı fakat güncel versionnu yoktu bu yenisidir

RefObjCommon

Kod:
    41925    ITEM_STORXY_MASTERY_PACHEON    ?????    xxx    SN_ITEM_STORXY_MASTERY_PACHEON    SN_ITEM_STORXY_MASTERY_PACHEON_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_bow.ddj    xxx    xxx    21443
1    41926    ITEM_STORXY_MASTERY_HEUKSAL    ?????    xxx    SN_ITEM_STORXY_MASTERY_HEUKSAL    SN_ITEM_STORXY_MASTERY_HEUKSAL_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_spear.ddj    xxx    xxx    21444
1    41927    ITEM_STORXY_MASTERY_BICHEON    ?????    xxx    SN_ITEM_STORXY_MASTERY_BICHEON    SN_ITEM_STORXY_MASTERY_BICHEON_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_sword.ddj    xxx    xxx    21445
1    41928    ITEM_STORXY_MASTERY_FIRE    ?????    xxx    SN_ITEM_STORXY_MASTERY_FIRE    SN_ITEM_STORXY_MASTERY_FIRE_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_fire.ddj    xxx    xxx    21446
1    41929    ITEM_STORXY_MASTERY_LIGHTNING    ?????    xxx    SN_ITEM_STORXY_MASTERY_LIGHTNING    SN_ITEM_STORXY_MASTERY_LIGHTNING_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_lightning.ddj    xxx    xxx    21447
1    41930    ITEM_STORXY_MASTERY_COLD    ?????    xxx    SN_ITEM_STORXY_MASTERY_COLD    SN_ITEM_STORXY_MASTERY_COLD_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_cold.ddj    xxx    xxx    21448
1    41931    ITEM_STORXY_MASTERY_FORCE    ?????    xxx    SN_ITEM_STORXY_MASTERY_FORCE    SN_ITEM_STORXY_MASTERY_FORCE_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_water.ddj    xxx    xxx    21449
1    41932    ITEM_STORXY_MASTERY_WIZARD    ?????    xxx    SN_ITEM_STORXY_MASTERY_WIZARD    SN_ITEM_STORXY_MASTERY_WIZARD_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_wizard.ddj    xxx    xxx    21450
1    41933    ITEM_STORXY_MASTERY_WARRIOR    ?????    xxx    SN_ITEM_STORXY_MASTERY_WARRIOR    SN_ITEM_STORXY_MASTERY_WARRIOR_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_warrior.ddj    xxx    xxx    21451
1    41934    ITEM_STORXY_MASTERY_ROUGE    ?????    xxx    SN_ITEM_STORXY_MASTERY_ROUGE    SN_ITEM_STORXY_MASTERY_ROUGE_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_rog.ddj    xxx    xxx    21452
1    41935    ITEM_STORXY_MASTERY_CLERICE    ?????    xxx    SN_ITEM_STORXY_MASTERY_CLERIC    SN_ITEM_STORXY_MASTERY_CLERIC_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_cleric.ddj    xxx    xxx    21453
1    41936    ITEM_STORXY_MASTERY_BARD    ?????    xxx    SN_ITEM_STORXY_MASTERY_BARD    SN_ITEM_STORXY_MASTERY_BARD_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_bard.ddj    xxx    xxx    21454
1    41937    ITEM_STORXY_MASTERY_WARLOCK    ?????    xxx    SN_ITEM_STORXY_MASTERY_WARLOCK    SN_ITEM_STORXY_MASTERY_WARLOCK_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_warlock.ddj    xxx    xxx    21455
RefObjItem
Kod:
21443    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21444    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21445    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21446    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21447    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21448    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21449    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21450    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21451    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21452    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21453    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21454    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
21455    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????                                                                                                                               -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0    0
Itemdata_xxxxx.txt
Kod:
1    41925    ITEM_STORXY_MASTERY_PACHEON    ?????    xxx    SN_ITEM_STORXY_MASTERY_PACHEON    SN_ITEM_STORXY_MASTERY_PACHEON_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_bow.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0   
1    41926    ITEM_STORXY_MASTERY_HEUKSAL    ?????    xxx    SN_ITEM_STORXY_MASTERY_HEUKSAL    SN_ITEM_STORXY_MASTERY_HEUKSAL_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_spear.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0  
1    41927    ITEM_STORXY_MASTERY_BICHEON    ?????    xxx    SN_ITEM_STORXY_MASTERY_BICHEON    SN_ITEM_STORXY_MASTERY_BICHEON_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_sword.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0  
1    41928    ITEM_STORXY_MASTERY_FIRE    ?????    xxx    SN_ITEM_STORXY_MASTERY_FIRE    SN_ITEM_STORXY_MASTERY_FIRE_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_fire.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0  
1    41929    ITEM_STORXY_MASTERY_LIGHTNING    ?????    xxx    SN_ITEM_STORXY_MASTERY_LIGHTNING    SN_ITEM_STORXY_MASTERY_LIGHTNING_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_lightning.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0  
1    41930    ITEM_STORXY_MASTERY_COLD    ?????    xxx    SN_ITEM_STORXY_MASTERY_COLD    SN_ITEM_STORXY_MASTERY_COLD_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_cold.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0  
1    41931    ITEM_STORXY_MASTERY_FORCE    ?????    xxx    SN_ITEM_STORXY_MASTERY_FORCE    SN_ITEM_STORXY_MASTERY_FORCE_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\mastery_water.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0  
1    41932    ITEM_STORXY_MASTERY_WIZARD    ?????    xxx    SN_ITEM_STORXY_MASTERY_WIZARD    SN_ITEM_STORXY_MASTERY_WIZARD_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_wizard.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0  
1    41933    ITEM_STORXY_MASTERY_WARRIOR    ?????    xxx    SN_ITEM_STORXY_MASTERY_WARRIOR    SN_ITEM_STORXY_MASTERY_WARRIOR_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_warrior.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0  
1    41934    ITEM_STORXY_MASTERY_ROUGE    ?????    xxx    SN_ITEM_STORXY_MASTERY_ROUGE    SN_ITEM_STORXY_MASTERY_ROUGE_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_rog.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0  
1    41935    ITEM_STORXY_MASTERY_CLERICE    ?????    xxx    SN_ITEM_STORXY_MASTERY_CLERIC    SN_ITEM_STORXY_MASTERY_CLERIC_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_cleric.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0  
1    41936    ITEM_STORXY_MASTERY_BARD    ?????    xxx    SN_ITEM_STORXY_MASTERY_BARD    SN_ITEM_STORXY_MASTERY_BARD_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_bard.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0  
1    41937    ITEM_STORXY_MASTERY_WARLOCK    ?????    xxx    SN_ITEM_STORXY_MASTERY_WARLOCK    SN_ITEM_STORXY_MASTERY_WARLOCK_TT_DESC    1    0    3    3    3    1    180000    3    0    1    1    1    223    0    1    0    0    1    0    1    0    0    0    0    0    -1    0    -1    0    -1    0    -1    0    -1    0    0    0    0    0    0    0    100    0    0    0    xxx    item\etc\drop_mall_scroll.bsr    storxy\eu_warlock.ddj    xxx    xxx    1    2    0    0    1    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    1000    ????    1    ??????    -1    RESURRECT    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    -1    xxx    0    0
Textdata_Object.txt

Kod:
1    SN_ITEM_STORXY_MASTERY_PACHEON                            Mastery Level Up (Pacheon)
1    SN_ITEM_STORXY_MASTERY_HEUKSAL                            Mastery Level Up (Heuksal)
1    SN_ITEM_STORXY_MASTERY_BICHEON                            Mastery Level Up (Bicheon)
1    SN_ITEM_STORXY_MASTERY_FIRE                            Mastery Level Up (Fire)
1    SN_ITEM_STORXY_MASTERY_LIGHTNING                            Mastery Level Up (Lightning)
1    SN_ITEM_STORXY_MASTERY_COLD                            Mastery Level Up (Cold)
1    SN_ITEM_STORXY_MASTERY_FORCE                            Mastery Level Up (Force)
1    SN_ITEM_STORXY_MASTERY_WIZARD                            Mastery Level Up (Wizard)
1    SN_ITEM_STORXY_MASTERY_WARRIOR                            Mastery Level Up (Warrior)
1    SN_ITEM_STORXY_MASTERY_ROUGE                            Mastery Level Up (Rouge)
1    SN_ITEM_STORXY_MASTERY_CLERIC                            Mastery Level Up (Cleric)
1    SN_ITEM_STORXY_MASTERY_BARD                            Mastery Level Up (Bard)
1    SN_ITEM_STORXY_MASTERY_WARLOCK                            Mastery Level Up (Warlock)
Proseturlere Geçiyoruz

AddLogItem >>> Kodlarınızı Düzenleyin Yoksa Çalışmıyacaktır
Kod:
  ---------------------------STORXY--------------------------------------------------------------   
    IF (@Operation=41 AND @ItemRefID BETWEEN 41932 AND 41937) ---------------- European Mastery Scrolls -------------------
    BEGIN
    IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE MasteryID='513')
    BEGIN
    DECLARE @Wizard INT,@Warrior INT,@Rouge INT,@Warlock INT,@Bard INT,@Cleric INT
    SELECT @Wizard=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='514'
    SELECT @Warrior=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='513'
    SELECT @Rouge=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='515'
    SELECT @Warlock=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='516'
    SELECT @Bard=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='517'
    SELECT @Cleric=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='518'
    IF (@Wizard+@Warrior+@Rouge+@Warlock+@Bard+@Cleric<='110')
    BEGIN
    DECLARE @EuropeanMasteryType INT;
            SET @EuropeanMasteryType = CASE
                WHEN @ItemRefID=41932 --------------- Wizard
                THEN 514
                WHEN @ItemRefID=41933 --------------- Warrior
                THEN 513
                WHEN @ItemRefID=41934 --------------- Rouge
                THEN 515
                WHEN @ItemRefID=41935 --------------- Cleric
                THEN 518
                WHEN @ItemRefID=41936 --------------- Bard
                THEN 517
                WHEN @ItemRefID=41937 --------------- Warlock
                THEN 516
                END
    UPDATE SRO_VT_SHARD.dbo._CharSkillMastery SET [Level]='110' WHERE CharID=@CharID AND MasteryID=@EuropeanMasteryType
    INSERT SRO_VT_SHARD.dbo._CharSkill SELECT @CharID,SkillID,'1' FROM SRO_VT_SHARDLOG.dbo._CharacterSkills WHERE MasteryID=@EuropeanMasteryType
    END
    END
    END
    IF (@Operation=41 AND @ItemRefID BETWEEN 41925 AND 41931) ---------------- Chinese Mastery Scrolls -------------------
    BEGIN
    IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE MasteryID='257')
    BEGIN
    DECLARE @Bicheon INT,@Heuksal INT,@Pacheon INT,@Cold INT,@Lightning INT,@Fire INT,@Force INT
    SELECT @Bicheon=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='257'
    SELECT @Heuksal=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='258'
    SELECT @Pacheon=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='259'
    SELECT @Cold=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='273'
    SELECT @Lightning=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='274'
    SELECT @Fire=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='275'
    SELECT @Force=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='276'
    IF (@Bicheon+@Heuksal+@Pacheon+@Cold+@Lightning+@Fire+@Force <='220')
    BEGIN
    DECLARE @ChineseMasteryType INT;
            SET @ChineseMasteryType = Case
                WHEN @ItemRefID=41927   ---------------    Bacheon
                THEN 257
                WHEN @ItemRefID=41926   ---------------    Heuksal
                THEN 258
                WHEN @ItemRefID=41925   ---------------    Pacheon
                THEN 259
                WHEN @ItemRefID=41930   ---------------    Cold
                THEN 273
                WHEN @ItemRefID=41929   ---------------    Lightning
                THEN 274
                WHEN @ItemRefID=41928   ---------------    Fire
                THEN 275
                WHEN @ItemRefID=41931   ---------------    Foce
                THEN 276
                END
    UPDATE SRO_VT_SHARD.dbo._CharSkillMastery SET [Level]='110' WHERE CharID=@CharID AND MasteryID=@ChineseMasteryType
    INSERT SRO_VT_SHARD.dbo._CharSkill SELECT @CharID,SkillID,'1' FROM SRO_VT_SHARDLOG.dbo._CharacterSkills WHERE MasteryID=@ChineseMasteryType
    END
    END
    END
    ---------------------------STORXY--------------------------------------------------------------
Okutun
Kod:
USE [SRO_VT_SHARDLOG]
GO

/****** Object:  Table [dbo].[_CharacterSkills]    Script Date: 19/04/2016 09:12:04 ? ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_CharacterSkills](
    [SkillID] [int] NOT NULL,
    [Build] [varchar](50) NOT NULL,
    [Race] [varchar](50) NOT NULL,
    [MasteryID] [int] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO
İndirme Link >>> Bana Tıkla
Rar Şifresi >>>> STORXY
linkler kırık güncellermisiniz
 
Yukarı Alt