Release :Scroll Status [الأرشيف] - الموقع العربي الاول للعبة Silkroad Online

MarOz

21-02-2015, 09:11 PM

http://www2.0zz0.com/2012/10/22/15/311256858.gif

http://www2.0zz0.com/2012/10/22/16/593531309.png

http://im45.gulfup.com/wsCcCQ.png

Scroll Status

نبذة عن الموضوع

الاسكرولات دي بتعمل Full Stats للايتم 61-80-100 علي حسب الاسكرول اللي هتستخدمها

ندخل في الموضوع

Databesa

RefobjCommon

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

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

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

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]
--> 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

اشكر العضو Lazcano و Hamza FiGo سعدني في Procedure

ملحوظة: لازم تلبس اللبس قبل ما تعمل الاسكرول

الموضوع مش منقول

يارب ينقل الموضوع يقول المصدر

بعض التعديلات علي البروسيدر . فية بعض الحاجات مش شغالة عندك يا First

والتعديل انا ضايف فية الــ Full Blue علشان يبقي كامل . تحياتي ^^

--> 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='3435973880 8',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='3435973880 8',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='3435973880 8',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='3435973880 8',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='3435973880 8',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='3435973880 8',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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',Mag Param2= '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',Mag Param2= '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',Mag Param2= '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',Mag Param2= '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

Hamza FiGo

21-02-2015, 09:24 PM

تسلم ايديكو

بس ياريت لو نبذة صغيرة كدة الاسكرول بتعمل اية علشان الناس تفهم

Mr Z!dane

21-02-2015, 09:24 PM

#ِApproved
تــمام الله ينور !!
سبقتني :111 (21):

Dangers SrO

21-02-2015, 09:27 PM

hhhhhhhhhhhhhhhhhhhhhhh xD
معلشي يا Mr Z!dane
تعوضها المرا الجيا
GodJop:crash:

MarOz

21-02-2015, 09:36 PM

بيعمل Status

زي Status السلاح

http://store2.up-00.com/2015-02/1424543632281.png

تقدر تخلي 61 او 80 او 100

#ِApproved
تــمام الله ينور !!
سبقتني :111 (21):

Thanks

Hamza FiGo

21-02-2015, 09:39 PM

بيعمل Status

زي Status السلاح

http://store2.up-00.com/2015-02/1424543632281.png

تقدر تخلي 61 او 80 او 100

Thanks

قصدي ياباشا تقول في الموضوع فوق نبذه صغيرة

يعني مثلا تقول. الاسكرولات دي بتعمل Full Stats للايتم 61-80-100 علي حسب الاسكرول اللي هتستخدمها ^^

غير ان فية حتة ناقصة . اسامي الاسكرولات . textdata_object ^^ ضيفها فوق

MarOz

21-02-2015, 09:42 PM

تم التعديل
^_^

MarOz

21-02-2015, 09:42 PM

تم التعديل
^_^

Dangers SrO

21-02-2015, 09:48 PM

تم
تسلم

MarOz

21-02-2015, 10:13 PM

تم
تسلم
:wave:

gameman

21-02-2015, 11:01 PM

N1 keep it going

Dangers SrO

21-02-2015, 11:42 PM

انا نزلو تمام بس معلش statsخليص

Dangers SrO

22-02-2015, 12:43 AM

تم الحل : :baby:

Hamza FiGo

22-02-2015, 01:46 AM

بعض التعديلات علي البروسيدر . فية بعض الحاجات مش شغالة عندك يا First

والتعديل انا ضايف فية الــ Full Blue علشان يبقي كامل . تحياتي ^^

--> 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='3435973880 8',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='3435973880 8',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='3435973880 8',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='3435973880 8',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='3435973880 8',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='3435973880 8',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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',Mag Param2= '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',Mag Param2= '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',Mag Param2= '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',Mag Param2= '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

Hamza FiGo

22-02-2015, 01:47 AM

بعض التعديلات علي البروسيدر . فية بعض الحاجات مش شغالة عندك يا First

والتعديل انا ضايف فية الــ Full Blue علشان يبقي كامل . تحياتي ^^

--> 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='3435973880 8',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='3435973880 8',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='3435973880 8',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='3435973880 8',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='3435973880 8',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='3435973880 8',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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',Mag Param2= '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',Mag Param2= '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',Mag Param2= '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',Mag Param2= '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

Dangers SrO

22-02-2015, 01:54 AM

ايوا كدي انا كا new here انبهارت xD

Dev. iLegend

22-02-2015, 03:21 AM

عااااش يا وحش
:rocket::rocket::rocket:

™MaR™

22-02-2015, 06:43 AM

تمام .شغل جامد

ruxana

22-02-2015, 08:24 PM

تمام يا باشا بس ناقصة Skil effect and skilldata35000enc

Hamza FiGo

22-02-2015, 09:06 PM

تمام يا باشا بس ناقصة Skil effect and skilldata35000enc

ملهاش ياباشا . دا شغال علي AddLogItem ملوش علاقة بيها خالص

MarOz

23-02-2015, 02:07 PM

بعض التعديلات علي البروسيدر . فية بعض الحاجات مش شغالة عندك يا First

والتعديل انا ضايف فية الــ Full Blue علشان يبقي كامل . تحياتي ^^

--> 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='3435973880 8',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='3435973880 8',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='3435973880 8',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='3435973880 8',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='3435973880 8',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='3435973880 8',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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',MagP aram2= '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',Mag Param2= '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',Mag Param2= '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',Mag Param2= '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',Mag Param2= '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

تسلم

MikrotikBody

27-02-2015, 02:33 AM

اظن إن الفكره دي كنت مديها لحضرتك
ثانيآ انت مكبر البروسيدور اوي
ممكن بدل ده كله
تعمل 3 سكرولات لي الايتمز والأكسوسري مع بعض
وسيبك من السلاح والشيلد عشان متبوخشي اللعبه
تقبل مروري

MikrotikBody

27-02-2015, 03:38 AM

iF (@Operation = 41) -- Scroll is used
BEGIN

IF (@ItemRefID = 50235) -- Your Test scroll 61% Protectro & Accessory
BEGIN
SELECT @CharName = CharName16 from [Dan_com].[dbo].[_Char] WHERE CharID = @CharID
Declare @HelmItemID64 int = 0----- HelmItem,MailItem,PantsItem
Declare @MailItemID64 int = 1----- HelmItem,MailItem,PantsItem
Declare @ShoulderItemID64 int = 2----- ShoulderItem,GauntletItem,BootsItem
Declare @GauntletItemID64 int = 3----- ShoulderItem,GauntletItem,BootsItem
Declare @PantsItemID64 int = 4----- HelmItem,MailItem,PantsItem
Declare @BootsItemID64 int = 5----- ShoulderItem,GauntletItem,BootsItem
Declare @WeaponItemID64 int = 6----- Weapon
Declare @ShieldItemID64 int = 7----- SHield
Declare @NecklaceItemID64 int = 9---- Accessory
Declare @EarringItemID64 int = 10---- Accessory
Declare @RingLItemID64 int = 11---- Accessory
Declare @RingRItemID64 int = 12---- Accessory

UPDATE Dan_com.dbo._Items SET Variance = 658099827, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 0 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 658099827, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 1 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 658099827, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 4 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 658099827, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 2 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 658099827, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 3 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 658099827, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 5 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 627, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 10 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 627, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 11 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 627, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 12 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 627, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 9 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
END
END

IF (@ItemRefID = 50236) -- Your Test scroll 80% Protectro & Accessory
BEGIN
SELECT @CharName = CharName16 from [Dan_com].[dbo].[_Char] WHERE CharID = @CharID

UPDATE Dan_com.dbo._Items SET Variance = 865920825, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 0 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 865920825, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 1 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 865920825, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 4 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 865920825, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 2 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 865920825, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 3 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 865920825, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 5 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 825, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 10 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 825, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 11 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 825, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 12 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 825, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 9 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
END
IF (@ItemRefID = 50237) -- Your Test scroll 100% Protectro & Accessory
BEGIN
SELECT @CharName = CharName16 from [Dan_com].[dbo].[_Char] WHERE CharID = @CharID

UPDATE Dan_com.dbo._Items SET Variance = 1073741823, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 0 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 1073741823, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 1 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 1073741823, MagParamNum = 6, MagParam1 = 876173328830, MagParam2 = 7301444403651, MagParam3 = 283467841986, MagParam4 = 51539607997, MagParam5 = 7301444403652, MagParam6 = 51539607996, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 4 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 1073741823, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 2 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 1073741823, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 3 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 1073741823, MagParamNum = 4, MagParam1 = 876173328830, MagParam2 = 283467841986, MagParam3 = 51539607997, MagParam4 = 51539607996, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 5 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 1023, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 10 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 1023, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 11 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 1023, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 12 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
UPDATE Dan_com.dbo._Items SET Variance = 1023, MagParamNum = 7, MagParam1 = 51539607997, MagParam2 = 51539607996, MagParam3 = 85899346373, MagParam4 = 85899346374, MagParam5 = 85899346375, MagParam6 = 85899346376, MagParam7 = 85899346377, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL WHERE ID64 IN (select ItemID from Dan_com.dbo._Inventory WHERE Slot = 9 AND CharID = (select CharID from Dan_com.dbo._Char where CharName16 = @CharName))
END

ده البروسيدور 61%-80%-100%
بدل ما تعمل كل البروسيدور ده كله
ولو عايز تعمل سلاح وشيلد برحتك
ملحوظه ياريت تعديل علي البرام عشان هيكون مختلف بين لعبه ولعبه
من حيث HP-MP-STR-INT-Durability ETC ETC ETC

TalatSaad

25-04-2015, 12:59 AM

انا عندى مشكله فى الاسكرول دى بتعمل عندى بلو انا مش عوزها تعمل بلو خالص http://www6.0zz0.com/2015/04/25/00/530097313.png
او تعمل بلو صح

!_Ahmed Elabbasy_!

14-05-2015, 09:28 PM

يا جدعان لو عندى حاجة فى ال البروسيدور مضافة اخود كا مسطرة و احوت ال كود ولا لزم امسحا ؟؟؟؟؟

MR D.B

19-05-2015, 12:19 AM

استمر

MikrotikBody

25-05-2015, 06:47 AM

الموضوع مش منقول
يارب ينقل الموضوع يقول المصدر
متأكد ياباشا إنك مش ناقله :)

Gummies

25-05-2015, 04:54 PM

عاش :grin:

GM Java Sro

29-05-2015, 02:58 PM

:thumb_yello::thumb_yello::thumb_yello::thumb_yell o:

M.HADAD

04-06-2015, 04:47 PM

دا البروسيدر بعد تعديل البلو الصحيح
--> Weapon Stat Scrolls :
-- Weapon 61%
IF (@Operation = 41) and (@ItemRefID = 67247)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '21059194464',MagParamNum= '5' ,MagParam1='30064771144',MagParam2= '30064771150',MagParam3='858993459290',MagParam4 = '257698037862',MagParam5= '429496729714'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 = 67248)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '27709466400',MagParamNum= '5' ,MagParam1='30064771144',MagParam2= '30064771150',MagParam3='858993459290',MagParam4 = '257698037862',MagParam5= '429496729714'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 = 67249)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '34359738367',MagParamNum= '5' ,MagParam1='30064771144',MagParam2= '30064771150',MagParam3='858993459290',MagParam4 = '257698037862' ,MagParam5= '429496729714'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 = 67250)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '21059194464',MagParamNum= '4 ',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='858993459290',MagParam4 = '429496729726'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 = 67251)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '27709466425',MagParamNum= '4 ',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='858993459290',MagParam4 = '429496729726' 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 = 67252)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '34359738336',MagParamNum= '4 ',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='858993459290',MagParam4 = '429496729726' 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 = 67253)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='6',MagParam1='30064771144 ',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' 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='30064771144 ',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' 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='30064771144 ',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' 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='30064771144 ',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' 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='30064771144 ',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' 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='30064771144 ',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' 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 = 67254)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='6',MagParam1='30064771144 ',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' 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='30064771144 ',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' 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='30064771144 ',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' 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='30064771144 ',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' 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='30064771144 ',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' 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='30064771144 ',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' 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 = 67255)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='6',MagParam1='3006477114 4',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' 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='3006477114 4',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' 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='3006477114 4',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' 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='3006477114 4',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' 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='3006477114 4',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' 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='3006477114 4',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' 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 = 67256)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627',MagParamNum='7',MagParam1='30064771144',MagP aram2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' 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='30064771144',MagP aram2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' 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='30064771144',MagP aram2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' 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='30064771144',MagP aram2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' 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 = 67257)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825',MagParamNum='7',MagParam1='30064771144',MagP aram2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' 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='30064771144',MagP aram2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' 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='30064771144',MagP aram2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' 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='30064771144',MagP aram2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' 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 = 67258)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023',MagParamNum='7',MagParam1='30064771144',Mag Param2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' 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='30064771144',Mag Param2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' 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='30064771144',Mag Param2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' 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='30064771144',Mag Param2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '12' and ItemID > 0)
End

تــــــقبل مرورى

GM Java Sro

06-06-2015, 09:55 PM

تمام عااش:mfr_bl5:

eshak

11-06-2015, 07:35 AM

not work i try with items 13D and 14D not work ?
i use Evolution Gaming Network databas

plz some help

when i use it just telport and no thing happen

thxx for ur time

MarOz

12-06-2015, 12:58 AM

Scroll Work All Dg

MrBlackHeart

16-06-2015, 03:57 AM

ana el scroll msh sh8ala 3ndy 5ales lbt3ml full blue wla stats :D

MrBlackHeart

16-06-2015, 10:49 AM

me too
im useing database evolution and this scroll not work :tears:

Xan

27-06-2015, 05:43 AM

تسلم <3

MarOz

07-09-2015, 11:07 PM

تم التعديل علي procedure
كدة مفهوش اي مشكلة ولا كراش ولا اي حاجة

AbdoSaid

08-09-2015, 02:14 AM

xD

ابو ليلى

09-09-2015, 07:05 AM

دا البروسيدر بعد تعديل البلو الصحيح
--> Weapon Stat Scrolls :
-- Weapon 61%
IF (@Operation = 41) and (@ItemRefID = 67247)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '21059194464',MagParamNum= '5' ,MagParam1='30064771144',MagParam2= '30064771150',MagParam3='858993459290',MagParam4 = '257698037862',MagParam5= '429496729714'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 = 67248)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '27709466400',MagParamNum= '5' ,MagParam1='30064771144',MagParam2= '30064771150',MagParam3='858993459290',MagParam4 = '257698037862',MagParam5= '429496729714'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 = 67249)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '34359738367',MagParamNum= '5' ,MagParam1='30064771144',MagParam2= '30064771150',MagParam3='858993459290',MagParam4 = '257698037862' ,MagParam5= '429496729714'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 = 67250)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '21059194464',MagParamNum= '4 ',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='858993459290',MagParam4 = '429496729726'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 = 67251)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '27709466425',MagParamNum= '4 ',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='858993459290',MagParam4 = '429496729726' 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 = 67252)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '34359738336',MagParamNum= '4 ',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='858993459290',MagParam4 = '429496729726' 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 = 67253)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '658099827',MagParamNum='6',MagParam1='30064771144 ',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' 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='30064771144 ',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' 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='30064771144 ',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' 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='30064771144 ',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' 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='30064771144 ',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' 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='30064771144 ',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' 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 = 67254)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '865920825',MagParamNum='6',MagParam1='30064771144 ',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' 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='30064771144 ',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' 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='30064771144 ',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' 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='30064771144 ',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' 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='30064771144 ',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' 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='30064771144 ',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' 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 = 67255)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1073741823',MagParamNum='6',MagParam1='3006477114 4',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' 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='3006477114 4',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' 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='3006477114 4',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' 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='3006477114 4',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' 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='3006477114 4',MagParam2= '858993459290',MagParam3='30064771150',MagParam4 = '257698037898',MagParam5= '5583457484962',MagParam6= '5583457484950' 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='3006477114 4',MagParam2= '858993459290',MagParam3='30064771150',MagParam4= '257698037898' 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 = 67256)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '627',MagParamNum='7',MagParam1='30064771144',MagP aram2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' 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='30064771144',MagP aram2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' 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='30064771144',MagP aram2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' 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='30064771144',MagP aram2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' 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 = 67257)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '825',MagParamNum='7',MagParam1='30064771144',MagP aram2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' 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='30064771144',MagP aram2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' 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='30064771144',MagP aram2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' 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='30064771144',MagP aram2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' 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 = 67258)
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set Variance = '1023',MagParamNum='7',MagParam1='30064771144',Mag Param2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' 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='30064771144',Mag Param2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' 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='30064771144',Mag Param2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' 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='30064771144',Mag Param2= '30064771150',MagParam3='85899346100',MagParam4= '85899346094',MagParam5= '85899346112',MagParam6= '85899346106',MagParam7= '85899346088' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '12' and ItemID > 0)
End

تــــــقبل مرورى

سلام عليكوم باشا بعد اذن حضرتك دلوقتى انا لما اخد الكوير دة واحطو كوبى باست فى ال sql
هل فى ارقام معينة اعدل عليها عشان ختها زى مهيا ودوست f5 جالى ايرور كتير كدة وهل دة كدة يسبب مشكلة فى الاسكرو لو عدلت علي الكوير تانى بس عاوز اعرف الارقام اللى يتعدل عليها اية بظبط

[GM]White Shadow

27-09-2015, 07:19 PM

يا جماعة انا عملت زي الموضوع و كل حاجة تمام بس لما باجي اعمل excute لــ بروسيدور بيجيبلي الايرور دا :sad2:

https://www.photobox.co.uk/my/photo?album_id=3716977414&photo_id=8849746356#8849746356

أرجو المساعدة انا محتاج الـسكرول دي ضروري :vibrate:

[GM]White Shadow

28-09-2015, 07:51 AM

يا جماعة انا عرفت المشكلة فين انا كنت ناسي حاجة من البرديوس , بس المشكلة دلوقت اني لما بضرب الـسكرول مش بتعمل حاجة ! :icon15:

revldo25

06-01-2016, 02:59 AM

المشكلة دلوقت اني لما بضرب الـسكرول مش بتعمل حاجة

HLP

07-01-2016, 12:37 AM

الله ينور

MR.KaBO

22-01-2016, 01:45 AM

تسلم والله :clapping:

EGY_ANG3L

27-03-2016, 10:55 PM

تمام يا كبير بس ممكن تقولي اظبط ال Prod ازاي

MR.KaBO

22-04-2016, 07:40 AM

هو فين صور icon وفي مشكلة لما بضربها مش بتعمل حاجة

basselhatemmm

20-07-2016, 12:44 AM

Keep it Up :)
:59::59::59:

Abdo.Mohamed

22-04-2017, 07:51 PM

الاسكرولات مش شغله و الاسمى بتعت ال الاسكرولات مش بتضهر :axesmiley::axesmiley::axesmiley::axesmiley::axesm iley::mf_frankie:

OoMasterOo

05-10-2017, 06:10 AM

شكرا على الموضوع الجميل
الاسكرولات شغالة تمام بس فى مشكلة الااسكرول بدون اسم ولا صورة يا ريت لو تقولنا نزبطهم ازاى ولو ممكن ال icons
https://img1.mrkzgulf.com/i/00116/inugbg6aym29_t.jpg (https://www.mrkzgulf.com/inugbg6aym29)

Helper4You

13-10-2017, 11:26 AM

:shutup3: جميل جدا

™Kabloz

28-11-2017, 01:35 AM

الله ينور مجهود رائع :munch_h4h:

The_Reason

03-12-2017, 03:16 AM

تسلم ايدك :lulu12:

homos007

10-03-2018, 12:46 AM

البروسيدور بيجبلى كراش ؟؟

HRawashVodafone

20-02-2020, 03:33 PM

السكرول لما بعملها بتدبنى
return scroll
ممكن حل

T3iMeT0Die

22-04-2020, 03:45 PM

بعد اذنك ممكن اعرف حاجه بس اذاي اجيب ال File دول