M
M.Moamen
المستوي:
Scroll Status
نبذة عن الموضوع
الاسكرولات دي بتعمل Full Stats للايتم 61-80-100 علي حسب الاسكرول اللي هتستخدمها
ندخل في الموضوع
Databesa
RefobjCommon
PHP:
1 50235 ITEM_MALL_STAT_WEP_60 Scroll Stat Wep 60% xxx SN_ITEM_MALL_STAT_WEP_60 SN_ITEM_MALL_STAT_WEP_60_TT_DESC 0 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 1 1 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\coupon_weapon.ddj xxx xxx 48696
1 50236 ITEM_MALL_STAT_WEP_80 Scroll Stat Wep 80% xxx SN_ITEM_MALL_STAT_WEP_80 SN_ITEM_MALL_STAT_WEP_80_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 1 1 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\coupon_weapon.ddj xxx xxx 48697
1 50237 ITEM_MALL_STAT_WEP_100 Scroll Stat Wep 100% xxx SN_ITEM_MALL_STAT_WEP_100 SN_ITEM_MALL_STAT_WEP_100_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 1 1 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\coupon_weapon.ddj xxx xxx 48698
1 50238 ITEM_MALL_STAT_SH_60 Scroll Stat Sh 60% xxx SN_ITEM_MALL_STAT_SH_60 SN_ITEM_MALL_STAT_SH_60_TT_DESC 0 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 1 1 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\coupon_weapon.ddj xxx xxx 48699
1 50239 ITEM_MALL_STAT_SH_80 Scroll Stat sh 80% xxx SN_ITEM_MALL_STAT_SH_80 SN_ITEM_MALL_STAT_SH_80_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 1 1 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\coupon_weapon.ddj xxx xxx 48700
1 50240 ITEM_MALL_STAT_SH_100 Scroll Stat sh 100% xxx SN_ITEM_MALL_STAT_SH_100 SN_ITEM_MALL_STAT_SH_100_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 1 1 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\coupon_weapon.ddj xxx xxx 48701
1 50241 ITEM_MALL_STAT_ITEM_60 Scroll Stat Item 60% xxx SN_ITEM_MALL_STAT_ITEM_60 SN_ITEM_MALL_STAT_ITEM_60_TT_DESC 0 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 1 1 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\coupon_weapon.ddj xxx xxx 48702
1 50242 ITEM_MALL_STAT_ITEM_80 Scroll Stat Item 80% xxx SN_ITEM_MALL_STAT_ITEM_80 SN_ITEM_MALL_STAT_ITEM_80_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 1 1 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\coupon_weapon.ddj xxx xxx 48703
1 50243 ITEM_MALL_STAT_ITEM_100 Scroll Stat Item 100% xxx SN_ITEM_MALL_STAT_ITEM_100 SN_ITEM_MALL_STAT_ITEM_100_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 1 1 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\coupon_weapon.ddj xxx xxx 48704
1 50244 ITEM_MALL_STAT_ACC_60 Scroll Stat Acc 60% xxx SN_ITEM_MALL_STAT_ACC_60 SN_ITEM_MALL_STAT_ACC_60_TT_DESC 0 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 1 1 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\coupon_weapon.ddj xxx xxx 48705
1 50245 ITEM_MALL_STAT_ACC_80 Scroll Stat Acc 80% xxx SN_ITEM_MALL_STAT_ACC_80 SN_ITEM_MALL_STAT_ACC_80_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 1 1 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\coupon_weapon.ddj xxx xxx 48706
1 50246 ITEM_MALL_STAT_ACC_100 Scroll Stat Acc 100% xxx SN_ITEM_MALL_STAT_ACC_100 SN_ITEM_MALL_STAT_ACC_100_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 1 1 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\coupon_weapon.ddj xxx xxx 48707
Refobjitem
PHP:
48696 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 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
48697 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 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
48698 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 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
48699 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 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
48700 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 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
48701 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 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
48702 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 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
48703 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 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
48704 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 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
48705 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 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
48706 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 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
48707 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
Media
ITEMDATA
PHP:
1 50235 ITEM_MALL_STAT_WEP_60 ???? ???? ??? (???) xxx SN_ITEM_MALL_STAT_WEP_60 SN_ITEM_MALL_STAT_WEP_60_TT_DESC 0 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 1 1 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\coupon_weapon.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 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 50236 ITEM_MALL_STAT_WEP_80 ???? ???? ??? (???) xxx SN_ITEM_MALL_STAT_WEP_80 SN_ITEM_MALL_STAT_WEP_80_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 1 1 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\coupon_weapon.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 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 50237 ITEM_MALL_STAT_WEP_100 ???? ???? ??? (???) xxx SN_ITEM_MALL_STAT_WEP_100 SN_ITEM_MALL_STAT_WEP_100_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 1 1 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\coupon_weapon.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 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 50238 ITEM_MALL_STAT_SH_60 ???? ???? ??? (???) xxx SN_ITEM_MALL_STAT_SH_60 SN_ITEM_MALL_STAT_SH_60_TT_DESC 0 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 1 1 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\coupon_weapon.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 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 50239 ITEM_MALL_STAT_SH_80 ???? ???? ??? (???) xxx SN_ITEM_MALL_STAT_SH_80 SN_ITEM_MALL_STAT_SH_80_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 1 1 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\coupon_weapon.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 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 50240 ITEM_MALL_STAT_SH_100 ???? ???? ??? (???) xxx SN_ITEM_MALL_STAT_SH_100 SN_ITEM_MALL_STAT_SH_100_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 1 1 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\coupon_weapon.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 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 50241 ITEM_MALL_STAT_ITEM_60 ???? ???? ??? (???) xxx SN_ITEM_MALL_STAT_ITEM_60 SN_ITEM_MALL_STAT_ITEM_60_TT_DESC 0 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 1 1 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\coupon_weapon.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 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 50242 ITEM_MALL_STAT_ITEM_80 ???? ???? ??? (???) xxx SN_ITEM_MALL_STAT_ITEM_80 SN_ITEM_MALL_STAT_ITEM_80_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 1 1 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\coupon_weapon.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 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 50243 ITEM_MALL_STAT_ITEM_100 ???? ???? ??? (???) xxx SN_ITEM_MALL_STAT_ITEM_100 SN_ITEM_MALL_STAT_ITEM_100_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 1 1 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\coupon_weapon.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 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 50244 ITEM_MALL_STAT_ACC_60 ???? ???? ??? (???) xxx SN_ITEM_MALL_STAT_ACC_60 SN_ITEM_MALL_STAT_ACC_60_TT_DESC 0 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 1 1 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\coupon_weapon.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 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 50245 ITEM_MALL_STAT_ACC_80 ???? ???? ??? (???) xxx SN_ITEM_MALL_STAT_ACC_80 SN_ITEM_MALL_STAT_ACC_80_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 1 1 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\coupon_weapon.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 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 50246 ITEM_MALL_STAT_ACC_100 ???? ???? ??? (???) xxx SN_ITEM_MALL_STAT_ACC_100 SN_ITEM_MALL_STAT_ACC_100_TT_DESC 1 0 3 3 3 1 180000 3 0 1 1 1 3 0 1 0 0 129 0 0 0 0 0 0 0 1 1 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\coupon_weapon.ddj xxx xxx 1 2 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1500 ???? 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
PHP:
1 SN_SN_ITEM_MALL_STAT_WEP_60 Scroll Stat Weapon 60%
1 SN_SN_ITEM_MALL_STAT_WEP_80 Scroll Stat Weapon 80%
1 SN_SN_ITEM_MALL_STAT_WEP_100 Scroll Stat Weapon 100%
1 SN_SN_ITEM_MALL_STAT_SH_60 Scroll Stat Shield 60%
1 SN_SN_ITEM_MALL_STAT_SH_80 Scroll Stat Shield 80%
1 SN_SN_ITEM_MALL_STAT_SH_100 Scroll Stat Shield 100%
1 SN_SN_ITEM_MALL_STAT_ITEM_60 Scroll Stat Set 60%
1 SN_SN_ITEM_MALL_STAT_ITEM_80 Scroll Stat Set 80%
1 SN_SN_ITEM_MALL_STAT_ITEM_100 Scroll Stat Set 100%
1 SN_SN_ITEM_MALL_STAT_ACC_60 Scroll Stat Accessory 60%
1 SN_SN_ITEM_MALL_STAT_ACC_80 Scroll Stat Accessory 80%
1 SN_SN_ITEM_MALL_STAT_ACC_100 Scroll Stat Accessory 100%
1 SN_SN_ITEM_MALL_STAT_WEP_60_TT_DESC Scroll Stat
1 SN_SN_ITEM_MALL_STAT_WEP_80_TT_DESC Scroll Stat
1 SN_SN_ITEM_MALL_STAT_WEP_100_TT_DESC Scroll Stat
1 SN_SN_ITEM_MALL_STAT_SH_60_TT_DESC Scroll Stat
1 SN_SN_ITEM_MALL_STAT_SH_80_TT_DESC Scroll Stat
1 SN_SN_ITEM_MALL_STAT_SH_100_TT_DESC Scroll Stat
1 SN_SN_ITEM_MALL_STAT_ITEM_60_TT_DESC Scroll Stat
1 SN_SN_ITEM_MALL_STAT_ITEM_80_TT_DESC Scroll Stat
1 SN_SN_ITEM_MALL_STAT_ITEM_100_TT_DESC Scroll Stat
1 SN_SN_ITEM_MALL_STAT_ACC_60_TT_DESC Scroll Stat
1 SN_SN_ITEM_MALL_STAT_ACC_80_TT_DESC Scroll Stat
1 SN_SN_ITEM_MALL_STAT_ACC_100_TT_DESC Scroll Stat
procedure
[Copy To [SRO_VT_SHARDLOG].[dbo].[_AddLogItem
PHP:
--> Weapon Stat Scrolls :
-- Weapon 61%
IF (@Operation = 41) and (@ItemRefID = 50235)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '21059194464' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '6' and ItemID > 0)
End
-- Weapon 80%
IF (@Operation = 41) and (@ItemRefID = 50236)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '27709466400' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '6' and ItemID > 0)
End
-- Weapon 100%
IF (@Operation = 41) and (@ItemRefID = 50237)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '34359738367' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '6' and ItemID > 0)
End
--> Shield Stat Scrolls :
-- SH 61%
IF (@Operation = 41) and (@ItemRefID = 50238)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '7' and ItemID > 0)
End
-- SH 80%
IF (@Operation = 41) and (@ItemRefID = 50239)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '7' and ItemID > 0)
End
-- SH 100%
IF (@Operation = 41) and (@ItemRefID = 50240)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '7' and ItemID > 0)
End
--> Armor Stat Scrolls :
-- AR 61%
IF (@Operation = 41) and (@ItemRefID = 50241)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '0' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '1' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '2' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '3' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '4' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '5' and ItemID > 0)
End
-- AR 80%
IF (@Operation = 41) and (@ItemRefID = 50242)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '0' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '1' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '2' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '3' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '4' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '5' and ItemID > 0)
End
-- AR 100%
IF (@Operation = 41) and (@ItemRefID = 50243)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '0' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '1' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '2' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '3' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '4' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '5' and ItemID > 0)
End
--> Accessory Stat Scrolls :
-- Acc 61%
IF (@Operation = 41) and (@ItemRefID = 50244)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '9' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '10' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '11' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '12' and ItemID > 0)
End
-- Acc 80%
IF (@Operation = 41) and (@ItemRefID = 50245)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '9' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '10' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '11' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '12' and ItemID > 0)
End
-- Acc 100%
IF (@Operation = 41) and (@ItemRefID = 50246)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '9' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '10' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '11' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '12' and ItemID > 0)
End
نيجي لل Blue
PHP:
--> Weapon Stat Scrolls :
-- Weapon 61%
IF (@Operation = 41) and (@ItemRefID = 50235)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '21059194464',MagParamNum = '5' , MagParam1 = '34359738807' , MagParam2 = '34359738808' , MagParam3 = '429496730043' , MagParam4 = '858993459641' , MagParam5 = '257698038202' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '6' and ItemID > 0)
End
-- Weapon 80%
IF (@Operation = 41) and (@ItemRefID = 50236)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '27709466400',MagParamNum = '5' , MagParam1 = '34359738807' , MagParam2 = '34359738808' , MagParam3 = '429496730043' , MagParam4 = '858993459641' , MagParam5 = '257698038202' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '6' and ItemID > 0)
End
-- Weapon 100%
IF (@Operation = 41) and (@ItemRefID = 50237)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '34359738367',MagParamNum = '5' , MagParam1 = '34359738807' , MagParam2 = '34359738808' , MagParam3 = '429496730043' , MagParam4 = '858993459641' , MagParam5 = '257698038202' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '6' and ItemID > 0)
End
--> Shield Stat Scrolls :
-- SH 61%
IF (@Operation = 41) and (@ItemRefID = 50238)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='4 ',MagParam1='858993459291',MagParam2= '429496729727',MagParam3='34359738447',MagParam4= '34359738441',MagParam5= '257698038202' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '7' and ItemID > 0)
End
-- SH 80%
IF (@Operation = 41) and (@ItemRefID = 50239)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='4 ',MagParam1='858993459291',MagParam2= '429496729727',MagParam3='34359738447',MagParam4= '34359738441',MagParam5= '257698038202' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '7' and ItemID > 0)
End
-- SH 100%
IF (@Operation = 41) and (@ItemRefID = 50240)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='4 ',MagParam1='858993459291',MagParam2= '429496729727',MagParam3='34359738447',MagParam4= '34359738441',MagParam5= '257698038202' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '7' and ItemID > 0)
End
--> Armor Stat Scrolls :
-- AR 61%
IF (@Operation = 41) and (@ItemRefID = 50241)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '0' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '1' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '2' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '3' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '4' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '5' and ItemID > 0)
End
-- AR 80%
IF (@Operation = 41) and (@ItemRefID = 50242)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '0' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '1' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '2' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '3' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '4' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '5' and ItemID > 0)
End
-- AR 100%
IF (@Operation = 41) and (@ItemRefID = 50243)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '0' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '1' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '2' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '3' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='6',MagParam1='34359738808',MagParam2= '858993459641',MagParam3='34359738807',MagParam4 = '7301444403647',MagParam5= '7301444403646',MagParam6= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '4' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='4',MagParam1='34359738808',MagParam2= '34359738807',MagParam3='858993459641',MagParam4= '257698038205' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '5' and ItemID > 0)
End
--> Accessory Stat Scrolls :
-- Acc 61%
IF (@Operation = 41) and (@ItemRefID = 50244)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '9' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '10' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '11' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '12' and ItemID > 0)
End
-- Acc 80%
IF (@Operation = 41) and (@ItemRefID = 50245)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '9' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '10' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '11' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '12' and ItemID > 0)
End
-- Acc 100%
IF (@Operation = 41) and (@ItemRefID = 50246)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '9' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '10' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '11' and ItemID > 0)
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023',MagParamNum='7',MagParam1='85899346369',MagParam2= '85899346370',MagParam3='85899346368',MagParam4= '85899346371',MagParam5= '85899346372',MagParam6= '34359738808',MagParam7= '34359738807' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '12' and ItemID > 0)
End
التعديل الأخير بواسطة المشرف: