Lock / Unlock Scroll [الأرشيف] - الموقع العربي الاول للعبة Silkroad Online

Hamza FiGo

03-11-2015, 09:05 AM

Lock / Unlock Scroll

سلام عليكم. في بعض الناس سالوني علي السيستم دا
السيستم ببساطة بيقفل الايتم مش بيخليها تتنقل ومتطلعش برة الشخصية منعا للهاك

1- Create this table:

Use [SRO_VT_SHARDLOG]
Create Table [dbo].[LockItemsID]
([LockItemID] [Int] NOT NULL PRIMARY KEY ,
[ReqItemID] [Int] NOT NULL)

2- اعمل سطور جديدة للاسلحة او الايتم.

خد كوبي من السطور الاصلية بتاع الايتم او الاسلحة وغير الاي دي هات والاسامي

مهم:

في السطور الجديدة لازم تراعي انك تعمل الحاجات دي صفر
Can trade-Can Drop-Can Borrow-Can Sell = 0

Example:

** The original 15D weapon:

1 40315 ITEM_EU_DAGGER_15_A_RARE 15? ?? (??) xxx SN_ITEM_EU_DAGGER_15_A_RARE SN_ITEM_EU_DAGGER_15_A_RARE_TT_DESC 0 0 3 1 6 13 180000 1 2 1 1 1 255 3 1 1 1 0 0 19748000 14667 22000 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\dagger_91.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\dagger_15.ddj xxx xxx 1 2 0 0 43 0 157 236 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 3 5836 6154 7132 7521 179.1 0 0 0 0 0 6487 7162 7928 8753 0 0 0 0 142 303 0 4 25 1 ITEM_EU_DAGGER_15_A_RARE 1 ITEM_EU_DAGGER_15_B_RARE 1 ITEM_EU_DAGGER_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 40336 ITEM_EU_SWORD_15_A_RARE 15? ??? (??) xxx SN_ITEM_EU_SWORD_15_A_RARE SN_ITEM_EU_SWORD_15_A_RARE_TT_DESC 0 0 3 1 6 7 180000 1 2 1 1 1 255 3 1 1 1 0 0 17773000 10353 15530 0 9000 6220550 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\sword_91.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\sword_15.ddj xxx xxx 1 2 0 0 43 0 111 167 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 5836 6154 7132 7521 179.1 0 0 0 0 0 6487 7162 7928 8753 0 0 0 0 142 303 0 2 15 1 ITEM_EU_SWORD_15_A_RARE 1 ITEM_EU_SWORD_15_B_RARE 1 ITEM_EU_SWORD_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 40357 ITEM_EU_TSWORD_15_A_RARE 15? ??? (??) xxx SN_ITEM_EU_TSWORD_15_A_RARE SN_ITEM_EU_TSWORD_15_A_RARE_TT_DESC 0 0 3 1 6 8 180000 1 2 1 1 1 255 3 1 1 1 0 0 19748000 8628 12941 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\tsword_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\tsword_15.ddj xxx xxx 1 2 0 0 43 0 93 139 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 18 5836 6154 7132 7521 179.1 0 0 0 0 0 6487 7162 7928 8753 0 0 0 0 142 303 0 2 15 1 ITEM_EU_TSWORD_15_A_RARE 1 ITEM_EU_TSWORD_15_B_RARE 1 ITEM_EU_TSWORD_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 40378 ITEM_EU_AXE_15_A_RARE 15? ???? (??) xxx SN_ITEM_EU_AXE_15_A_RARE SN_ITEM_EU_AXE_15_A_RARE_TT_DESC 0 0 3 1 6 9 180000 1 2 1 1 1 255 3 1 1 1 0 0 19748000 14667 22000 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\axe_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\axe_15.ddj xxx xxx 1 2 0 0 43 0 157 236 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 6 5836 6154 7132 7521 179.1 0 0 0 0 0 6487 7162 7928 8753 0 0 0 0 142 303 0 2 15 1 ITEM_EU_AXE_15_A_RARE 1 ITEM_EU_AXE_15_B_RARE 1 ITEM_EU_AXE_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 40399 ITEM_EU_CROSSBOW_15_A_RARE 15? ????? (??) xxx SN_ITEM_EU_CROSSBOW_15_A_RARE SN_ITEM_EU_CROSSBOW_15_A_RARE_TT_DESC 0 0 3 1 6 12 180000 1 2 1 1 1 255 3 1 1 1 0 0 19748000 10353 15530 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\crossbow_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\crossbow_15.ddj xxx xxx 1 2 0 0 43 0 111 167 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 180 5836 6154 7132 7521 179.1 0 0 0 0 0 6487 7162 7928 8753 0 0 0 0 142 303 0 4 20 1 ITEM_EU_CROSSBOW_15_A_RARE 1 ITEM_EU_CROSSBOW_15_B_RARE 1 ITEM_EU_CROSSBOW_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 40420 ITEM_EU_DARKSTAFF_15_A_RARE 15? ???? (??) xxx SN_ITEM_EU_DARKSTAFF_15_A_RARE SN_ITEM_EU_DARKSTAFF_15_A_RARE_TT_DESC 0 0 3 1 6 10 180000 1 2 1 1 1 255 3 1 1 1 0 0 17773000 8628 12941 0 9000 6220550 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\darkstaff_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\darkstaff_15.ddj xxx xxx 1 2 0 0 43 0 185 278 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 0 0 0 0 0 9337 9846 11412 12034 286.5 0 0 0 0 10378 11459 12685 14005 142 303 0 2 2 1 ITEM_EU_DARKSTAFF_15_A_RARE 1 ITEM_EU_DARKSTAFF_15_B_RARE 1 ITEM_EU_DARKSTAFF_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 40441 ITEM_EU_TSTAFF_15_A_RARE 15? ??? (??) xxx SN_ITEM_EU_TSTAFF_15_A_RARE SN_ITEM_EU_TSTAFF_15_A_RARE_TT_DESC 0 0 3 1 6 11 180000 1 2 1 1 1 255 3 1 1 1 0 0 19748000 8628 12941 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\tstaff_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\tstaff_15.ddj xxx xxx 1 2 0 0 43 0 93 139 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 6 0 0 0 0 0 9337 9846 11412 12034 286.5 0 0 0 0 10378 11459 12685 14005 142 303 0 2 2 1 ITEM_EU_TSTAFF_15_A_RARE 1 ITEM_EU_TSTAFF_15_B_RARE 1 ITEM_EU_TSTAFF_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 40462 ITEM_EU_HARP_15_A_RARE 15? ?? (??) xxx SN_ITEM_EU_HARP_15_A_RARE SN_ITEM_EU_HARP_15_A_RARE_TT_DESC 0 0 3 1 6 14 180000 1 2 1 1 1 255 3 1 1 1 0 0 19748000 7765 11647 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\harp_12.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\harp_15.ddj xxx xxx 1 2 0 0 43 0 83 125 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 6 0 0 0 0 0 9337 9846 11412 12034 286.5 0 0 0 0 10378 11459 12685 14005 142 303 0 2 2 1 ITEM_EU_HARP_15_A_RARE 1 ITEM_EU_HARP_15_B_RARE 1 ITEM_EU_HARP_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 40483 ITEM_EU_STAFF_15_A_RARE 15? ??? ?? (??) xxx SN_ITEM_EU_STAFF_15_A_RARE SN_ITEM_EU_STAFF_15_A_RARE_TT_DESC 0 0 3 1 6 15 180000 1 2 1 1 1 255 3 1 1 1 0 0 19748000 8628 12941 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\staff_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\staff_15.ddj xxx xxx 1 2 0 0 43 0 93 139 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 0 0 0 0 0 9337 9846 11412 12034 286.5 0 0 0 0 10378 11459 12685 14005 142 303 0 2 2 1 ITEM_EU_STAFF_15_A_RARE 1 ITEM_EU_STAFF_15_B_RARE 1 ITEM_EU_STAFF_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 40504 ITEM_EU_SHIELD_15_A_RARE 15? ?? ?? (??) xxx SN_ITEM_EU_SHIELD_15_A_RARE SN_ITEM_EU_SHIELD_15_A_RARE_TT_DESC 0 0 3 1 4 2 180000 1 2 1 1 1 255 3 1 1 1 0 0 9874000 9059 13588 0 9000 3455900 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\shield\shield_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\shield\shield_15.ddj xxx xxx 1 2 0 0 43 0 97 146 648.4 683.8 17.9 0 0 0 0 0 0 14 23 1037.4 1094 28.6 0 0 0 721 796 1153 1273 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 ITEM_EU_SHIELD_15_A_RARE 1 ITEM_EU_SHIELD_15_B_RARE 1 ITEM_EU_SHIELD_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_SH_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 ?? ??? ?? ?? ? 9 0

1 39370 ITEM_CH_SWORD_15_A_RARE 15? ? (??) xxx SN_ITEM_CH_SWORD_15_A_RARE SN_ITEM_CH_SWORD_15_A_RARE_TT_DESC 0 0 3 1 6 2 180000 0 2 1 1 1 255 3 1 1 1 0 0 17773000 12294 18441 0 9000 6220550 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\weapon\sword_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\sword_15.ddj xxx xxx 1 2 0 0 43 0 148 181 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 4349 4586 4902 5169 127.7 7400 7804 8507 8971 219.6 4930 5130 5558 5782 8390 8729 9645 10035 142 303 0 4 16 1 ITEM_CH_SWORD_15_A_RARE 1 ITEM_CH_SWORD_15_B_RARE 1 ITEM_CH_SWORD_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 39391 ITEM_CH_BLADE_15_A_RARE 15? ? (??) xxx SN_ITEM_CH_BLADE_15_A_RARE SN_ITEM_CH_BLADE_15_A_RARE_TT_DESC 0 0 3 1 6 3 180000 0 2 1 1 1 255 3 1 1 1 0 0 17773000 13588 20382 0 9000 6220550 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\weapon\blade_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\blade_15.ddj xxx xxx 1 2 0 0 43 0 164 200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 4625 4878 5317 5607 137.3 6958 7337 7843 8271 204.4 5244 5456 6028 6272 7889 8207 8892 9251 142 303 0 3 15 1 ITEM_CH_BLADE_15_A_RARE 1 ITEM_CH_BLADE_15_B_RARE 1 ITEM_CH_BLADE_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 39412 ITEM_CH_SPEAR_15_A_RARE 15? ? (??) xxx SN_ITEM_CH_SPEAR_15_A_RARE SN_ITEM_CH_SPEAR_15_A_RARE_TT_DESC 0 0 3 1 6 4 180000 0 2 1 1 1 255 3 1 1 1 0 0 19748000 8196 12294 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\weapon\spear_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\spear_15.ddj xxx xxx 1 2 0 0 43 0 99 121 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 18 4539 4786 5403 5698 137.3 7781 8205 9510 10029 238.8 5146 5354 6126 6374 8822 9178 10782 11218 142 303 0 5 17 1 ITEM_CH_SPEAR_15_A_RARE 1 ITEM_CH_SPEAR_15_B_RARE 1 ITEM_CH_SPEAR_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 39433 ITEM_CH_TBLADE_15_A_RARE 15? ?? (??) xxx SN_ITEM_CH_TBLADE_15_A_RARE SN_ITEM_CH_TBLADE_15_A_RARE_TT_DESC 0 0 3 1 6 5 180000 0 2 1 1 1 255 3 1 1 1 0 0 19748000 9059 13588 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\weapon\tblade_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\tblade_15.ddj xxx xxx 1 2 0 0 43 0 109 134 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 18 4863 5128 5944 6268 149.2 7262 7658 8645 9117 219.6 5514 5736 6739 7011 8234 8566 9802 10198 142 303 0 4 16 1 ITEM_CH_TBLADE_15_A_RARE 1 ITEM_CH_TBLADE_15_B_RARE 1 ITEM_CH_TBLADE_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 39454 ITEM_CH_BOW_15_A_RARE 15? ? (??) xxx SN_ITEM_CH_BOW_15_A_RARE SN_ITEM_CH_BOW_15_A_RARE_TT_DESC 0 0 3 1 6 6 180000 0 2 1 1 1 255 3 1 1 1 0 0 19748000 9318 13977 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\weapon\bow_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\bow_15.ddj xxx xxx 1 2 0 0 43 0 112 137 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 2 1 180 4399 4639 5391 5686 135.2 7039 7423 8626 9097 216.3 4988 5189 6113 6360 7981 8303 9780 10175 142 303 0 4 14 1 ITEM_CH_BOW_15_A_RARE 1 ITEM_CH_BOW_15_B_RARE 1 ITEM_CH_BOW_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 39475 ITEM_CH_SHIELD_15_A_RARE 15? ?? (??) xxx SN_ITEM_CH_SHIELD_15_A_RARE SN_ITEM_CH_SHIELD_15_A_RARE_TT_DESC 0 0 3 1 4 1 180000 0 2 1 1 1 255 3 1 1 1 0 0 9874000 9059 13588 0 9000 3455900 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\shield\shield_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\shield\shield_15.ddj xxx xxx 1 2 0 0 43 0 109 134 648.4 683.8 17.9 0 0 0 0 0 0 14 23 1037.4 1094 28.6 0 0 0 735 765 1235 1285 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 ITEM_CH_SHIELD_15_A_RARE 1 ITEM_CH_SHIELD_15_B_RARE 1 ITEM_CH_SHIELD_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_SH_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 ?? ??? ?? ?? ? 9 0

** The locked 15D weapons:
1 80315 ITEM_EU_DAGGER_15_A_RARE_CHAOS 15? ?? (??) xxx SN_ITEM_EU_DAGGER_15_A_RARE_CHAOS SN_ITEM_EU_DAGGER_15_A_RARE_TT_DESC 0 0 3 1 6 13 180000 1 2 0 0 0 0 0 0 0 0 0 0 19748000 14667 22000 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\dagger_91.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\dagger_15.ddj xxx xxx 1 2 0 0 43 0 157 236 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 3 5836 6154 7132 7521 179.1 0 0 0 0 0 6487 7162 7928 8753 0 0 0 0 142 303 0 4 25 1 ITEM_EU_DAGGER_15_A_RARE_CHAOS 1 ITEM_EU_DAGGER_15_B_RARE 1 ITEM_EU_DAGGER_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80336 ITEM_EU_SWORD_15_A_RARE_CHAOS 15? ??? (??) xxx SN_ITEM_EU_SWORD_15_A_RARE_CHAOS SN_ITEM_EU_SWORD_15_A_RARE_TT_DESC 0 0 3 1 6 7 180000 1 2 0 0 0 0 0 0 0 0 0 0 17773000 10353 15530 0 9000 6220550 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\sword_91.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\sword_15.ddj xxx xxx 1 2 0 0 43 0 111 167 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 5836 6154 7132 7521 179.1 0 0 0 0 0 6487 7162 7928 8753 0 0 0 0 142 303 0 2 15 1 ITEM_EU_SWORD_15_A_RARE_CHAOS 1 ITEM_EU_SWORD_15_B_RARE 1 ITEM_EU_SWORD_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80357 ITEM_EU_TSWORD_15_A_RARE_CHAOS 15? ??? (??) xxx SN_ITEM_EU_TSWORD_15_A_RARE_CHAOS SN_ITEM_EU_TSWORD_15_A_RARE_TT_DESC 0 0 3 1 6 8 180000 1 2 0 0 0 0 0 0 0 0 0 0 19748000 8628 12941 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\tsword_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\tsword_15.ddj xxx xxx 1 2 0 0 43 0 93 139 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 18 5836 6154 7132 7521 179.1 0 0 0 0 0 6487 7162 7928 8753 0 0 0 0 142 303 0 2 15 1 ITEM_EU_TSWORD_15_A_RARE_CHAOS 1 ITEM_EU_TSWORD_15_B_RARE 1 ITEM_EU_TSWORD_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80378 ITEM_EU_AXE_15_A_RARE_CHAOS 15? ???? (??) xxx SN_ITEM_EU_AXE_15_A_RARE_CHAOS SN_ITEM_EU_AXE_15_A_RARE_TT_DESC 0 0 3 1 6 9 180000 1 2 0 0 0 0 0 0 0 0 0 0 19748000 14667 22000 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\axe_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\axe_15.ddj xxx xxx 1 2 0 0 43 0 157 236 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 6 5836 6154 7132 7521 179.1 0 0 0 0 0 6487 7162 7928 8753 0 0 0 0 142 303 0 2 15 1 ITEM_EU_AXE_15_A_RARE_CHAOS 1 ITEM_EU_AXE_15_B_RARE 1 ITEM_EU_AXE_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80399 ITEM_EU_CROSSBOW_15_A_RARE_CHAOS 15? ????? (??) xxx SN_ITEM_EU_CROSSBOW_15_A_RARE_CHAOS SN_ITEM_EU_CROSSBOW_15_A_RARE_TT_DESC 0 0 3 1 6 12 180000 1 2 0 0 0 0 0 0 0 0 0 0 19748000 10353 15530 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\crossbow_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\crossbow_15.ddj xxx xxx 1 2 0 0 43 0 111 167 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 180 5836 6154 7132 7521 179.1 0 0 0 0 0 6487 7162 7928 8753 0 0 0 0 142 303 0 4 20 1 ITEM_EU_CROSSBOW_15_A_RARE_CHAOS 1 ITEM_EU_CROSSBOW_15_B_RARE 1 ITEM_EU_CROSSBOW_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80420 ITEM_EU_DARKSTAFF_15_A_RARE_CHAOS 15? ???? (??) xxx SN_ITEM_EU_DARKSTAFF_15_A_RARE_CHAOS SN_ITEM_EU_DARKSTAFF_15_A_RARE_TT_DESC 0 0 3 1 6 10 180000 1 2 0 0 0 0 0 0 0 0 0 0 17773000 8628 12941 0 9000 6220550 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\darkstaff_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\darkstaff_15.ddj xxx xxx 1 2 0 0 43 0 185 278 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 0 0 0 0 0 9337 9846 11412 12034 286.5 0 0 0 0 10378 11459 12685 14005 142 303 0 2 2 1 ITEM_EU_DARKSTAFF_15_A_RARE_CHAOS 1 ITEM_EU_DARKSTAFF_15_B_RARE 1 ITEM_EU_DARKSTAFF_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80441 ITEM_EU_TSTAFF_15_A_RARE_CHAOS 15? ??? (??) xxx SN_ITEM_EU_TSTAFF_15_A_RARE_CHAOS SN_ITEM_EU_TSTAFF_15_A_RARE_TT_DESC 0 0 3 1 6 11 180000 1 2 0 0 0 0 0 0 0 0 0 0 19748000 8628 12941 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\tstaff_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\tstaff_15.ddj xxx xxx 1 2 0 0 43 0 93 139 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 6 0 0 0 0 0 9337 9846 11412 12034 286.5 0 0 0 0 10378 11459 12685 14005 142 303 0 2 2 1 ITEM_EU_TSTAFF_15_A_RARE_CHAOS 1 ITEM_EU_TSTAFF_15_B_RARE 1 ITEM_EU_TSTAFF_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80462 ITEM_EU_HARP_15_A_RARE_CHAOS 15? ?? (??) xxx SN_ITEM_EU_HARP_15_A_RARE_CHAOS SN_ITEM_EU_HARP_15_A_RARE_TT_DESC 0 0 3 1 6 14 180000 1 2 0 0 0 0 0 0 0 0 0 0 19748000 7765 11647 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\harp_12.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\harp_15.ddj xxx xxx 1 2 0 0 43 0 83 125 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 6 0 0 0 0 0 9337 9846 11412 12034 286.5 0 0 0 0 10378 11459 12685 14005 142 303 0 2 2 1 ITEM_EU_HARP_15_A_RARE_CHAOS 1 ITEM_EU_HARP_15_B_RARE 1 ITEM_EU_HARP_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80483 ITEM_EU_STAFF_15_A_RARE_CHAOS 15? ??? ?? (??) xxx SN_ITEM_EU_STAFF_15_A_RARE_CHAOS SN_ITEM_EU_STAFF_15_A_RARE_TT_DESC 0 0 3 1 6 15 180000 1 2 0 0 0 0 0 0 0 0 0 0 19748000 8628 12941 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\staff_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\staff_15.ddj xxx xxx 1 2 0 0 43 0 93 139 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 0 0 0 0 0 9337 9846 11412 12034 286.5 0 0 0 0 10378 11459 12685 14005 142 303 0 2 2 1 ITEM_EU_STAFF_15_A_RARE_CHAOS 1 ITEM_EU_STAFF_15_B_RARE 1 ITEM_EU_STAFF_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80504 ITEM_EU_SHIELD_15_A_RARE_CHAOS 15? ?? ?? (??) xxx SN_ITEM_EU_SHIELD_15_A_RARE_CHAOS SN_ITEM_EU_SHIELD_15_A_RARE_TT_DESC 0 0 3 1 4 2 180000 1 2 0 0 0 0 0 0 0 0 0 0 9874000 9059 13588 0 9000 3455900 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\shield\shield_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\shield\shield_15.ddj xxx xxx 1 2 0 0 43 0 97 146 648.4 683.8 17.9 0 0 0 0 0 0 14 23 1037.4 1094 28.6 0 0 0 721 796 1153 1273 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 ITEM_EU_SHIELD_15_A_RARE_CHAOS 1 ITEM_EU_SHIELD_15_B_RARE 1 ITEM_EU_SHIELD_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_SH_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 ?? ??? ?? ?? ? 9 0

1 80370 ITEM_CH_SWORD_15_A_RARE_CHAOS 15? ? (??) xxx SN_ITEM_CH_SWORD_15_A_RARE_CHAOS SN_ITEM_CH_SWORD_15_A_RARE_TT_DESC 0 0 3 1 6 2 180000 0 2 0 0 0 0 0 0 0 0 0 0 17773000 12294 18441 0 9000 6220550 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\weapon\sword_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\sword_15.ddj xxx xxx 1 2 0 0 43 0 148 181 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 4349 4586 4902 5169 127.7 7400 7804 8507 8971 219.6 4930 5130 5558 5782 8390 8729 9645 10035 142 303 0 4 16 1 ITEM_CH_SWORD_15_A_RARE_CHAOS 1 ITEM_CH_SWORD_15_B_RARE 1 ITEM_CH_SWORD_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80391 ITEM_CH_BLADE_15_A_RARE_CHAOS 15? ? (??) xxx SN_ITEM_CH_BLADE_15_A_RARE_CHAOS SN_ITEM_CH_BLADE_15_A_RARE_TT_DESC 0 0 3 1 6 3 180000 0 2 0 0 0 0 0 0 0 0 0 0 17773000 13588 20382 0 9000 6220550 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\weapon\blade_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\blade_15.ddj xxx xxx 1 2 0 0 43 0 164 200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 4625 4878 5317 5607 137.3 6958 7337 7843 8271 204.4 5244 5456 6028 6272 7889 8207 8892 9251 142 303 0 3 15 1 ITEM_CH_BLADE_15_A_RARE_CHAOS 1 ITEM_CH_BLADE_15_B_RARE 1 ITEM_CH_BLADE_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80412 ITEM_CH_SPEAR_15_A_RARE_CHAOS 15? ? (??) xxx SN_ITEM_CH_SPEAR_15_A_RARE_CHAOS SN_ITEM_CH_SPEAR_15_A_RARE_TT_DESC 0 0 3 1 6 4 180000 0 2 0 0 0 0 0 0 0 0 0 0 19748000 8196 12294 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\weapon\spear_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\spear_15.ddj xxx xxx 1 2 0 0 43 0 99 121 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 18 4539 4786 5403 5698 137.3 7781 8205 9510 10029 238.8 5146 5354 6126 6374 8822 9178 10782 11218 142 303 0 5 17 1 ITEM_CH_SPEAR_15_A_RARE_CHAOS 1 ITEM_CH_SPEAR_15_B_RARE 1 ITEM_CH_SPEAR_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80433 ITEM_CH_TBLADE_15_A_RARE_CHAOS 15? ?? (??) xxx SN_ITEM_CH_TBLADE_15_A_RARE_CHAOS SN_ITEM_CH_TBLADE_15_A_RARE_TT_DESC 0 0 3 1 6 5 180000 0 2 0 0 0 0 0 0 0 0 0 0 19748000 9059 13588 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\weapon\tblade_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\tblade_15.ddj xxx xxx 1 2 0 0 43 0 109 134 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 18 4863 5128 5944 6268 149.2 7262 7658 8645 9117 219.6 5514 5736 6739 7011 8234 8566 9802 10198 142 303 0 4 16 1 ITEM_CH_TBLADE_15_A_RARE_CHAOS 1 ITEM_CH_TBLADE_15_B_RARE 1 ITEM_CH_TBLADE_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80454 ITEM_CH_BOW_15_A_RARE_CHAOS 15? ? (??) xxx SN_ITEM_CH_BOW_15_A_RARE_CHAOS SN_ITEM_CH_BOW_15_A_RARE_TT_DESC 0 0 3 1 6 6 180000 0 2 0 0 0 0 0 0 0 0 0 0 19748000 9318 13977 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\weapon\bow_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\bow_15.ddj xxx xxx 1 2 0 0 43 0 112 137 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 2 1 180 4399 4639 5391 5686 135.2 7039 7423 8626 9097 216.3 4988 5189 6113 6360 7981 8303 9780 10175 142 303 0 4 14 1 ITEM_CH_BOW_15_A_RARE_CHAOS 1 ITEM_CH_BOW_15_B_RARE 1 ITEM_CH_BOW_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80475 ITEM_CH_SHIELD_15_A_RARE_CHAOS 15? ?? (??) xxx SN_ITEM_CH_SHIELD_15_A_RARE_CHAOS SN_ITEM_CH_SHIELD_15_A_RARE_TT_DESC 0 0 3 1 4 1 180000 0 2 0 0 0 0 0 0 0 0 0 0 9874000 9059 13588 0 9000 3455900 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\shield\shield_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\shield\shield_15.ddj xxx xxx 1 2 0 0 43 0 109 134 648.4 683.8 17.9 0 0 0 0 0 0 14 23 1037.4 1094 28.6 0 0 0 735 765 1235 1285 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 ITEM_CH_SHIELD_15_A_RARE_CHAOS 1 ITEM_CH_SHIELD_15_B_RARE 1 ITEM_CH_SHIELD_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_SH_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 ?? ??? ?? ?? ? 9 0

لاحظو الفرق بين الاتنين واعملوها علي اي ديجري انتو عايزينه

Add this at LOG db at AddLogItem

IF (@operation = 41 and @ItemRefID = '81023')
Begin
Declare @ID64 Int , @RefItemID Int , @NewRefID Int
Select Top 1 @ID64 = Inv.ItemID , @RefItemID = Items.RefItemID From [SRO_VT_SHARD].[dbo].[_Inventory] As Inv Inner Join [SRO_VT_SHARD].[dbo].[_Items] As Items ON Inv.ItemID = Items.ID64 Where Inv.CharID = @CharID and Inv.ItemID > 0 and Inv.Slot = 13
Select Top 1 @NewRefID = LockItemID From [dbo].[LockItemsID] Where ReqItemID = @RefItemID
IF @NewRefID IS NOT NULL and @ID64 IS NOT NULL
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @NewRefID Where ID64 = @ID64
End
End

-- Unlock
IF (@operation = 41 and @ItemRefID = '81024')
Begin
Select Top 1 @ID64 = Inv.ItemID , @RefItemID = Items.RefItemID From [SRO_VT_SHARD].[dbo].[_Inventory] As Inv Inner Join [SRO_VT_SHARD].[dbo].[_Items] As Items ON Inv.ItemID = Items.ID64 Where Inv.CharID = @CharID and Inv.ItemID > 0 and Inv.Slot = 13
Select Top 1 @NewRefID = ReqItemID From [dbo].[LockItemsID] Where LockItemID = @RefItemID
IF @NewRefID IS NOT NULL and @ID64 IS NOT NULL
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @NewRefID Where ID64 = @ID64
End
End

Then create this :

USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_HamzaLockSystemD15] Script Date: 11/3/2015 8:01:33 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[_HamzaLockSystemD15]
@CharID Int
As

-- Declare expression.
Declare @CreaterName Varchar(60) = 'Figozz' , -- Creater Name
@Slot Int = '13' , -- char inventory slot 1.
@ReqOptLevel Int = '0' , -- Requiared Opt Level to upgrade
@OptDifference Int = '2' , -- Set the difference optlevel between old plus and new plus.
@OldOptLevel Int ,
@NewOptLevel Int ,
@AdvValue Int ,
@ID64 Int ,
-------------------------

-- Set Old and New Item RefObjCommon ID below
-- Use This Query to get each item ID by Codename128
-- Select ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where CodeName128 Like 'Item Code Name'

---> Old weapon ID's ---> New weapons ID's
@Old_CH_SWORD_ID Int = 39368 , @New_CH_SWORD_ID Int = 80370 , --@New Chinese Sword
@Old_CH_BLADE_ID Int = 39391 , @New_CH_BLADE_ID Int = 80391 , --@Chinese Blade
@Old_CH_SPEAR_ID Int = 39412 , @New_CH_SPEAR_ID Int = 80412 , --@Chinese Spear
@Old_CH_TBLADE_ID Int = 39433 , @New_CH_TBLADE_ID Int = 80433 , --@Chinese Glaive
@Old_CH_BOW_ID Int = 39454 , @New_CH_BOW_ID Int = 80454 , --@Chinese Bow
@Old_CH_SHIELD_ID Int = 39475 , @New_CH_SHIELD_ID Int = 80475 , --@Chinese Shield
@Old_EU_DAGGER_ID Int = 40315 , @New_EU_DAGGER_ID Int = 80315 , --@European Dagger
@Old_EU_XBOW_ID Int = 40399 , @New_EU_XBOW_ID Int = 80399 , --@European CrossBow
@Old_EU_AXE_ID Int = 40378 , @New_EU_AXE_ID Int = 80378 , --@European Axe
@Old_EU_SWORD_ID Int = 40336 , @New_EU_SWORD_ID Int = 80336 , --@European One Hand Sword
@Old_EU_TSWORD_ID Int = 40357 , @New_EU_TSWORD_ID Int = 80357 , --@European Two Hand Sword
@Old_EU_TSTAFF_ID Int = 40441 , @New_EU_TSTAFF_ID Int = 80441 , --@European Two Hand Staff
@Old_EU_STAFF_ID Int = 40483 , @New_EU_STAFF_ID Int = 80483 , --@European Claric Rod
@Old_EU_DSTAFF_ID Int = 40420 , @New_EU_DSTAFF_ID Int = 80420 , --@European Warlock Rod
@Old_EU_HARP_ID Int = 40462 , @New_EU_HARP_ID Int = 80462 , --@European Harp
@Old_EU_SHIELD_ID Int = 40504 , @New_EU_SHIELD_ID Int = 80504 --@European Shield
--------------------------------------------------------------------------------------------
Set @ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @Slot and ItemID > 0)
Set @OldOptLevel = (Select OptLevel From [SRO_VT_SHARD].[dbo].[_Items] Where ID64 = @ID64)

-- Start Lock system :

-- First Case :
-- IF Item has not advanced elixir :

IF NOT EXISTS (Select * From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
Begin
IF @OldOptLevel >= @ReqOptLevel
Begin
Set @NewOptLevel = @OldOptLevel - @OptDifference
-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SWORD_ID and (OptLevel = @OldOptLevel) --@Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BLADE_ID and (OptLevel = @OldOptLevel) --@Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SPEAR_ID and (OptLevel = @OldOptLevel) --@Spear
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_TBLADE_ID and (OptLevel = @OldOptLevel) --@T-Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BOW_ID and (OptLevel = @OldOptLevel) --@Bow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
-- EU Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DAGGER_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DAGGER_ID and (OptLevel = @OldOptLevel) --@Dagger
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_XBOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_XBOW_ID and (OptLevel = @OldOptLevel) --@Crossbow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_AXE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_AXE_ID and (OptLevel = @OldOptLevel) --@Axe
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SWORD_ID and (OptLevel = @OldOptLevel) --@OneHand Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSWORD_ID and (OptLevel = @OldOptLevel) --@T-Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSTAFF_ID and (OptLevel = @OldOptLevel) --@T-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_STAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_STAFF_ID and (OptLevel = @OldOptLevel) --@Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DSTAFF_ID and (OptLevel = @OldOptLevel) --@Dark-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_HARP_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_HARP_ID and (OptLevel = @OldOptLevel) --@Harp
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
End
End

-- Second Case :
-- IF Item has advanced elixir :

ELSE IF EXISTS (Select * From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
Begin
Set @AdvValue = (Select nOptValue From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
IF @OldOptLevel >= @ReqOptLevel
Begin
Set @NewOptLevel = (@OldOptLevel - @OptDifference) + @AdvValue
-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SWORD_ID and (OptLevel = @OldOptLevel) --@Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BLADE_ID and (OptLevel = @OldOptLevel) --@Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SPEAR_ID and (OptLevel = @OldOptLevel) --@Spear
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_TBLADE_ID and (OptLevel = @OldOptLevel) --@T-Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BOW_ID and (OptLevel = @OldOptLevel) --@Bow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
-- EU Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DAGGER_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DAGGER_ID and (OptLevel = @OldOptLevel) --@Dagger
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_XBOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_XBOW_ID and (OptLevel = @OldOptLevel) --@Crossbow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_AXE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_AXE_ID and (OptLevel = @OldOptLevel) --@Axe
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SWORD_ID and (OptLevel = @OldOptLevel) --@OneHand Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSWORD_ID and (OptLevel = @OldOptLevel) --@T-Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSTAFF_ID and (OptLevel = @OldOptLevel) --@T-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_STAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_STAFF_ID and (OptLevel = @OldOptLevel) --@Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DSTAFF_ID and (OptLevel = @OldOptLevel) --@Dark-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_HARP_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_HARP_ID and (OptLevel = @OldOptLevel) --@Harp
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
End
End

USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_HamzaLockSystemD15Unlock] Script Date: 11/3/2015 8:02:10 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[_HamzaLockSystemD15Unlock]
@CharID Int
As

-- Declare expression.
Declare @CreaterName Varchar(60) = 'Figozz' , -- Creater Name
@Slot Int = '13' , -- char inventory slot 1.
@ReqOptLevel Int = '0' , -- Requiared Opt Level to upgrade
@OptDifference Int = '2' , -- Set the difference optlevel between old plus and new plus.
@OldOptLevel Int ,
@NewOptLevel Int ,
@AdvValue Int ,
@ID64 Int ,
-------------------------

-- Set Old and New Item RefObjCommon ID below
-- Use This Query to get each item ID by Codename128
-- Select ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where CodeName128 Like 'Item Code Name'

---> Old weapon ID's ---> New weapons ID's
@Old_CH_SWORD_ID Int = 80370 , @New_CH_SWORD_ID Int = 39370 , --@New Chinese Sword
@Old_CH_BLADE_ID Int = 80391 , @New_CH_BLADE_ID Int = 39391 , --@Chinese Blade
@Old_CH_SPEAR_ID Int = 80412 , @New_CH_SPEAR_ID Int = 39412 , --@Chinese Spear
@Old_CH_TBLADE_ID Int = 80433 , @New_CH_TBLADE_ID Int = 39433 , --@Chinese Glaive
@Old_CH_BOW_ID Int = 80454 , @New_CH_BOW_ID Int = 39454 , --@Chinese Bow
@Old_CH_SHIELD_ID Int = 80475 , @New_CH_SHIELD_ID Int = 39475 , --@Chinese Shield
@Old_EU_DAGGER_ID Int = 80315 , @New_EU_DAGGER_ID Int = 40315 , --@European Dagger
@Old_EU_XBOW_ID Int = 80399 , @New_EU_XBOW_ID Int = 40399 , --@European CrossBow
@Old_EU_AXE_ID Int = 80378 , @New_EU_AXE_ID Int = 40378 , --@European Axe
@Old_EU_SWORD_ID Int = 80336 , @New_EU_SWORD_ID Int = 40336 , --@European One Hand Sword
@Old_EU_TSWORD_ID Int = 80357 , @New_EU_TSWORD_ID Int = 40357 , --@European Two Hand Sword
@Old_EU_TSTAFF_ID Int = 80441 , @New_EU_TSTAFF_ID Int = 40441 , --@European Two Hand Staff
@Old_EU_STAFF_ID Int = 80483 , @New_EU_STAFF_ID Int = 40483 , --@European Claric Rod
@Old_EU_DSTAFF_ID Int = 80420 , @New_EU_DSTAFF_ID Int = 40420 , --@European Warlock Rod
@Old_EU_HARP_ID Int = 80462 , @New_EU_HARP_ID Int = 40462 , --@European Harp
@Old_EU_SHIELD_ID Int = 80504 , @New_EU_SHIELD_ID Int = 40504 --@European Shield
--------------------------------------------------------------------------------------------
Set @ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @Slot and ItemID > 0)
Set @OldOptLevel = (Select OptLevel From [SRO_VT_SHARD].[dbo].[_Items] Where ID64 = @ID64)

-- Start Lock system :

-- First Case :
-- IF Item has not advanced elixir :

IF NOT EXISTS (Select * From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
Begin
IF @OldOptLevel >= @ReqOptLevel
Begin
Set @NewOptLevel = @OldOptLevel - @OptDifference
-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SWORD_ID and (OptLevel = @OldOptLevel) --@Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BLADE_ID and (OptLevel = @OldOptLevel) --@Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SPEAR_ID and (OptLevel = @OldOptLevel) --@Spear
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_TBLADE_ID and (OptLevel = @OldOptLevel) --@T-Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BOW_ID and (OptLevel = @OldOptLevel) --@Bow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
-- EU Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DAGGER_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DAGGER_ID and (OptLevel = @OldOptLevel) --@Dagger
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_XBOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_XBOW_ID and (OptLevel = @OldOptLevel) --@Crossbow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_AXE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_AXE_ID and (OptLevel = @OldOptLevel) --@Axe
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SWORD_ID and (OptLevel = @OldOptLevel) --@OneHand Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSWORD_ID and (OptLevel = @OldOptLevel) --@T-Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSTAFF_ID and (OptLevel = @OldOptLevel) --@T-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_STAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_STAFF_ID and (OptLevel = @OldOptLevel) --@Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DSTAFF_ID and (OptLevel = @OldOptLevel) --@Dark-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_HARP_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_HARP_ID and (OptLevel = @OldOptLevel) --@Harp
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
End
End

-- Second Case :
-- IF Item has advanced elixir :

ELSE IF EXISTS (Select * From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
Begin
Set @AdvValue = (Select nOptValue From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
IF @OldOptLevel >= @ReqOptLevel
Begin
Set @NewOptLevel = (@OldOptLevel - @OptDifference) + @AdvValue
-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SWORD_ID and (OptLevel = @OldOptLevel) --@Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BLADE_ID and (OptLevel = @OldOptLevel) --@Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SPEAR_ID and (OptLevel = @OldOptLevel) --@Spear
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_TBLADE_ID and (OptLevel = @OldOptLevel) --@T-Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BOW_ID and (OptLevel = @OldOptLevel) --@Bow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
-- EU Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DAGGER_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DAGGER_ID and (OptLevel = @OldOptLevel) --@Dagger
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_XBOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_XBOW_ID and (OptLevel = @OldOptLevel) --@Crossbow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_AXE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_AXE_ID and (OptLevel = @OldOptLevel) --@Axe
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SWORD_ID and (OptLevel = @OldOptLevel) --@OneHand Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSWORD_ID and (OptLevel = @OldOptLevel) --@T-Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSTAFF_ID and (OptLevel = @OldOptLevel) --@T-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_STAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_STAFF_ID and (OptLevel = @OldOptLevel) --@Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DSTAFF_ID and (OptLevel = @OldOptLevel) --@Dark-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_HARP_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_HARP_ID and (OptLevel = @OldOptLevel) --@Harp
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
End
End

Thanks to Dev. iLegend ~_^

الاسكرول الرئيسي لـ اللي ميعرفش يعملها

refObjCommon

1 81023 ITEM_CHAOS_LOCK ????? (????) xxx SN_ITEM_CHAOS_LOCK SN_ITEM_CHAOS_LOCK_TT_DESC 0 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 0 0 0 0 0 1 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\lock_indulgence.ddj xxx xxx 90000
1 81024 ITEM_CHAOS_UNLOCK ????? (????) xxx SN_ITEM_CHAOS_UNLOCK SN_ITEM_CHAOS_UNLOCK_TT_DESC 0 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 0 0 0 0 0 1 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\unlock_indulgence.ddj xxx xxx 90001

refObjItem

90000 1 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
90001 1 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0

itemdata_xxxxxx

1 81023 ITEM_CHAOS_LOCK ????? (????) xxx SN_ITEM_CHAOS_LOCK SN_ITEM_CHAOS_LOCK_TT_DESC 0 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 0 0 0 0 0 1 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\lock_indulgence.ddj xxx xxx 1 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0
1 81024 ITEM_CHAOS_UNLOCK ????? (????) xxx SN_ITEM_CHAOS_UNLOCK SN_ITEM_CHAOS_UNLOCK_TT_DESC 0 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 0 0 0 0 0 1 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\unlock_indulgence.ddj xxx xxx 1 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0

textdata_object

1 SN_ITEM_CHAOS_LOCK Lock Scroll
1 SN_ITEM_CHAOS_LOCK_TT_DESC <sml2>This scroll will LOCK your items to avoid to be scammed. How to use: -Put ur item at the first slot in ur inventory (LEFT) - Use the scroll. Regards from [GM] Figoz</sml2>
1 SN_ITEM_CHAOS_UNLOCK UNLock Scroll
1 SN_ITEM_CHAOS_UNLOCK_TT_DESC <sml2>This scroll will unlock your items, so u can trade/sell it. How to use: -Put ur item at the first slot in ur inventory (LEFT) - Use the scroll. Regards from [GM] Figoz</sml2>

http://s26.postimg.org/g48jv4ie1/2683849alt2c6g21e.gif

وبخصوص البلاص تم عمل الصح ^^ من برنامج Zealous

كدة زي isro بالظبط. لو الاكونت بتاعك مع السيرفر كله متخافش علية

4vhDJxMHplw

Regards

ruxana

03-11-2015, 01:43 PM

جميل يا باشا بس فين باقي الحاجات زي itemdata4500 . refskill . refibjitem .refobjcommon

Hamza FiGo

03-11-2015, 01:51 PM

جميل يا باشا بس فين باقي الحاجات زي itemdata4500 . refskill . refibjitem .refobjcommon

متعرفش تعمل سكرول ياباشا عادية؟

علي العموم ضيفتها فوق

Edit

تمت اضافة الاسكرول لتجميعة سكرولات 2015

ruxana

03-11-2015, 03:44 PM

تمام يا باشا شكرا

Dangers SrO

03-11-2015, 04:15 PM

كلام جميل اوي
تسلم

بس في حاجه كدا انا مثلا عامل السلاح مقفول
ما ممكن حد يجيب اسكرول البتفتاحو ويخد السلاح ؟

ruxana

03-11-2015, 08:29 PM

سوال مهم

Hamza FiGo

03-11-2015, 11:06 PM

كلام جميل اوي
تسلم

بس في حاجه كدا انا مثلا عامل السلاح مقفول
ما ممكن حد يجيب اسكرول البتفتاحو ويخد السلاح ؟

بالنسبة ليا في سيرفري حاطط سكرول اللوك بس في الان بي سي. ولما حد بيحب يفتح الايتم. صاحب الاكونت نفسه بيكلمني علي الفيس او موبايل

طبعا انا مفهم الناس كلها علي نظام الاسكرول ان صاحب الاكونت نفسه يكلمني علي الفيس علشان اعرف كل واحد واكونته

لافة شوية بس ضمان للناس

Xan

04-11-2015, 12:44 AM

الله ينور فعلا انا كنت عايز السكرول ديه :v
و جار التجربه ...........

Xan

04-11-2015, 12:50 AM

بس عندي استفسار هنعمل سطور جديده في ال Refobjjcommon بس ؟
و الTable هنعدل فيها حاجه ؟

Hamza FiGo

04-11-2015, 01:21 AM

;5232021']بس عندي استفسار هنعمل سطور جديده في ال Refobjjcommon بس ؟
و الTable هنعدل فيها حاجه ؟

داتا وميديا ياباشا كانك بتعمل اسلحة جديدة. والتابل هتضيف فية ID كل الاسلحة اللي مقفول واللي مفتوح

علشان لما تضرب الاسكرول يقرا هنا ويروح هنا وهكذا

Dangers SrO

04-11-2015, 03:27 PM

كلام جميل اوي
بس انا عندي فكره مينفعش نعمل الاسكرول بي بسورد :D
بمعني ان اسكرول ال Lock لما تيجي تعملها علي السلاح تطلب منك بسورد
و لما تحب تفكو علشان تبيعو اسكرول ال unLock تطلب بسورد اللي انتا عملتو بسكرول الLock ^^
كدا هتبقي احسن من حوار الفيس دا ^^

Hamza FiGo

04-11-2015, 03:30 PM

كلام جميل اوي
بس انا عندي فكره مينفعش نعمل الاسكرول بي بسورد :D
بمعني ان اسكرول ال Lock لما تيجي تعملها علي السلاح تطلب منك بسورد
و لما تحب تفكو علشان تبيعو اسكرول ال unLock تطلب بسورد اللي انتا عملتو بسكرول الLock ^^
كدا هتبقي احسن من حوار الفيس دا ^^

موضوع الباس ورد مش سهل كل واحد بقا يفكر ويبتكر . احنا بنعمل اللي علينا ^^

Dev. iLegend

04-11-2015, 04:07 PM

كلام جميل اوي
بس انا عندي فكره مينفعش نعمل الاسكرول بي بسورد :D
بمعني ان اسكرول ال Lock لما تيجي تعملها علي السلاح تطلب منك بسورد
و لما تحب تفكو علشان تبيعو اسكرول ال unLock تطلب بسورد اللي انتا عملتو بسكرول الLock ^^
كدا هتبقي احسن من حوار الفيس دا ^^

أعتقد انك ممكن تستخدم Memo_Add أو برنامج بيستقبل ال incoming chat دا فى حالة الأسكرول عشان تقدر تاخد منه باصورد فى الأول وتقدر تشتغل عليها ،،

Hamza FiGo

05-11-2015, 12:47 AM

أعتقد انك ممكن تستخدم Memo_Add أو برنامج بيستقبل ال incoming chat دا فى حالة الأسكرول عشان تقدر تاخد منه باصورد فى الأول وتقدر تشتغل عليها ،،

جالك رامي بنفسه اهو ^^

ماهو فية طريقة احسن صديق ليا قال عليها. انها ممكن تكون PM لشخصية GM مثلا

يبعت رسالة للكاركتر يجيلة الباس العشوائي. ولما يجي يفتح يبعتله الباس دا يتفك الايتم

JanGanSRO

05-11-2015, 07:03 AM

https://www.youtube.com/watch?v=y-W-PFFgCKU

Xan

05-11-2015, 11:32 AM

حلو بارضو فكرة Janjan :wine:
:basketball::basketball::basketball:

Hamza FiGo

05-11-2015, 05:41 PM

https://www.youtube.com/watch?v=y-W-PFFgCKU

بخصوص الفكرة احنا بالفعل شغالين عليها بس بطريقة تانية. هيا تبعت PM مش msg بحاجة معينه زي Lock مثلا هيجيلة الرد بباس عشوائي وهو دا الكود اللي هيتفك بية الايتم.نفس فكرتك تقريبا

بس احنا كبداية ابتدينا فيها كان اولهم رامي والافكار بدات تتوالي . وانهاردة حلينا مشكلة البلاص. يعني الايتم يبقي مؤمن 100%. اتفرجو علي الفيديو وهتفهم قصدي

4vhDJxMHplw

بس سيستم زي بتاع الباس هيكون صعب وطبيعي مش هيكون فري من اللي بيعمله. انا معرفش اعمله فا حد زي Zealous او اي حد من الناس التقيلة دي تعمل اي حاجة ^^

JanGanSRO

05-11-2015, 06:48 PM

بخصوص الفكرة احنا بالفعل شغالين عليها بس بطريقة تانية. هيا تبعت PM مش msg بحاجة معينه زي Lock مثلا هيجيلة الرد بباس عشوائي وهو دا الكود اللي هيتفك بية الايتم.نفس فكرتك تقريبا

بس احنا كبداية ابتدينا فيها كان اولهم رامي والافكار بدات تتوالي . وانهاردة حلينا مشكلة البلاص. يعني الايتم يبقي مؤمن 100%. اتفرجو علي الفيديو وهتفهم قصدي

4vhDJxMHplw

بس سيستم زي بتاع الباس هيكون صعب وطبيعي مش هيكون فري من اللي بيعمله. انا معرفش اعمله فا حد زي Zealous او اي حد من الناس التقيلة دي تعمل اي حاجة ^^

نفترض ان الاعب جالو كراش او دى سى لاى سبب مهما كان موضع PM انا عن نفسى مش مقتنع بيه و شايف انه يكون MSG افضل .

Hamza FiGo

05-11-2015, 07:21 PM

https://www.youtube.com/watch?v=y-W-PFFgCKU

نفترض ان الاعب جالو كراش او دى سى لاى سبب مهما كان موضع PM انا عن نفسى مش مقتنع بيه و شايف انه يكون MSG افضل .

ولنفترض انها MSG طيب ولو كانت FULL ؟

هل هيعمل كل باص في رسالة. وانت متاح عندك 20 رسالة فقط. يعني لو السيت والاسلحة كله كدة هيجيب 12-13 مكان

هيفضل عندك 6. كدة انت بتقفل الMSG عند البلاير

فكرة الــ PM انه لو جالة الــ PM هيحفظ الباس ورد عنده في صورة علي الجهاز في تكست في اي مكان ^^

cairoke

05-11-2015, 11:01 PM

تمام يا باشا والف شكر انا كنت بدور عليها والله
+1

JanGanSRO

06-11-2015, 06:17 AM

ولنفترض انها MSG طيب ولو كانت FULL ؟

هل هيعمل كل باص في رسالة. وانت متاح عندك 20 رسالة فقط. يعني لو السيت والاسلحة كله كدة هيجيب 12-13 مكان

هيفضل عندك 6. كدة انت بتقفل الMSG عند البلاير

فكرة الــ PM انه لو جالة الــ PM هيحفظ الباس ورد عنده في صورة علي الجهاز في تكست في اي مكان ^^

مظبوط كلامك من ناحيه ال PM
لكن انا بتكلم على MSG على اساس ان الباسوورد يكون اللاعب حافظة من غير ما يحتفظ بيه
و من ناحيه ان الرسايل تتملى عنده اكيد كل لاعب عارف موضوع انهم 20 و حيتابع و احنا بردو مش حنسيبهم اكيد حنعملهم شروحات عن كيفيه اغلاق الايتم و فتحه

Hamza FiGo

06-11-2015, 12:31 PM

مظبوط كلامك من ناحيه ال PM
لكن انا بتكلم على MSG على اساس ان الباسوورد يكون اللاعب حافظة من غير ما يحتفظ بيه
و من ناحيه ان الرسايل تتملى عنده اكيد كل لاعب عارف موضوع انهم 20 و حيتابع و احنا بردو مش حنسيبهم اكيد حنعملهم شروحات عن كيفيه اغلاق الايتم و فتحه

انت نسيت نقطه مهمه جدا. بخصوص الــ MSG. اولا احنا عاملين السيستم لية؟ علشان الاكونت لو اتسرق محدش يعرف يفتح الايتم الا صاحب الاكونت مظبوط؟

دلوقتي لو عملناها علي MSG كدة قدمنا الباس للي سرق الاكونت علي طبق من دهب. يعني معملناش حاجة ^^

هيفتح الــ MSG box وياخد الباس ويقلب الاكونت وشكرا عزيزي علي الاكونت

شوفت الفرق بين الــ PM و الــ MSG ^^

Dangers SrO

06-11-2015, 02:10 PM

تماام اوي يا همزا
برنس والله لما بتشغل دماغك ^^

Hamza FiGo

07-11-2015, 01:20 AM

تماام اوي يا همزا
برنس والله لما بتشغل دماغك ^^

بتغلط في اسمي كتير بس كفاية بقا ^^ اسمي حمزة :hypocrite1:

Dangers SrO

07-11-2015, 01:25 AM

ههههههههههه
حبيبي احمزه :D

Hamza FiGo

07-11-2015, 02:29 AM

ههههههههههه
حبيبي احمزه :D

الراجل دا يا جدعان معاه سكيلات 130 ومخبيها :bleh:

هشردك :winksmiley02: . سالتك قبل كدا ونفضتلي وكمان مش فري

JanGanSRO

07-11-2015, 04:59 PM

انت نسيت نقطه مهمه جدا. بخصوص الــ MSG. اولا احنا عاملين السيستم لية؟ علشان الاكونت لو اتسرق محدش يعرف يفتح الايتم الا صاحب الاكونت مظبوط؟

دلوقتي لو عملناها علي MSG كدة قدمنا الباس للي سرق الاكونت علي طبق من دهب. يعني معملناش حاجة ^^

هيفتح الــ MSG box وياخد الباس ويقلب الاكونت وشكرا عزيزي علي الاكونت

شوفت الفرق بين الــ PM و الــ MSG ^^

لا يا حوبى مش على طبق ولا حاجة لانى كتبت فى ردى اللى فات ان اللاعب يكون حافظة مش محتفظ بيه حافظة يعنى فى دماغه
محتفظ بيه يعنى يفضل على الاكونت

عموما الفكرة نفسها فى الاصل جميله
تتعمل باى اسلوب المهم نوصل للاسلوب الامثل

ربنا معاكم.

Dangers SrO

09-11-2015, 01:14 AM

الراجل دا يا جدعان معاه سكيلات 130 ومخبيها :bleh:

هشردك :winksmiley02: . سالتك قبل كدا ونفضتلي وكمان مش فري

ادا ادا ادا فينا من كدا احمزا
وبعدبن الاسكلات 140 مش 130 :bleh:
وبعدبن انتا عارف انتا الوحيد اللي مش ممكن اطنشو
https://youtu.be/QEkzu4N1qEY

Jaffa

10-11-2015, 01:56 AM

موضوع مفيد جدا و جميل جدا جدا

Hamza FiGo

10-11-2015, 02:12 AM

ادا ادا ادا فينا من كدا احمزا
وبعدبن الاسكلات 140 مش 130 :bleh:
وبعدبن انتا عارف انتا الوحيد اللي مش ممكن اطنشو
https://youtu.be/QEkzu4N1qEY

والله اسمي حمزة :laser:

Jayden

16-11-2015, 07:02 AM

فى فكرة احسن من موضوع الPw
وهى اننا ممكن نستخدم برنامج يتربط ب Table معينة ال Table دى بتخزن ال Ip بتاع صاحب ال Char ولما ييجى يعمل Unlock البرنامج يشوف ال Ip لو هو تشتغل لو لا خلاص .. انا ممكن ان شاء الله ابقى اعملها و اكمل معاك الموضوع ده بس حاليا مش فاضى بس

Dangers SrO

16-11-2015, 01:59 PM

انا مش مع الفكره دي يااshefa علشان مثلا صاحب الاكونت فتح في مكان تاني
اكيد ال ip هيتغير وبكدا مش هيقدر يفكها ....
وكمان افرد انو عملو علي جهازو وعمل وندوس الip هيتغير
اقبل مروري ..

Jayden

16-11-2015, 03:56 PM

تمام انا معاك بس احنا هنعرف الناس الكلام ده قبل ما يستخدموها يعنى استخدامها هيكون على مسئوليتهم
و انا جاالى فكرة ممكن نخليها بال HWID بدل ال Ip بس لسه مش متأكد تنفع ولا لا الصراحة لكن هشوف
اصل كده كده فكرة انو يكلمو على الفيس وكده دى مش داخله دماغى و يبقى احسنلى محطش السيستم ده لو كده اصلا

Dangers SrO

17-11-2015, 02:11 PM

تمام انا معاك بس احنا هنعرف الناس الكلام ده قبل ما يستخدموها يعنى استخدامها هيكون على مسئوليتهم
و انا جاالى فكرة ممكن نخليها بال HWID بدل ال Ip بس لسه مش متأكد تنفع ولا لا الصراحة لكن هشوف
اصل كده كده فكرة انو يكلمو على الفيس وكده دى مش داخله دماغى و يبقى احسنلى محطش السيستم ده لو كده اصلا

هي فكره ال ip حلوه بس المشكله انو لو عمل مثلا windos لجهازو الip هيتغير
فا احنا ممكن نقولو ايه يستخدم الscroll ويطلب من الGMال ip بتاعو
بس في نفس الوقت الضرب فيه الscroll ليه بقي علشان ال GM يعرف انو هو صاحب ال account الضربها وفي الحاله دي صاحب الaccount هيضمن يفكها من غير مشاكل

MikrotikBody

18-11-2015, 08:02 AM

جميل جدآ
بس ممكن تستخدم بتاع csro افضل

Dev. iLegend

18-11-2015, 11:44 PM

كل الردود والأفكار جملية بس الفكرة الأفضل هي فكرة الـ Memo_Add وعلى فكرة يا حمزة معلومة ليك ال Memo_Add لما بتحط الكود قبل متبدأ الـ Transaction بيشتغل حتي لو ال Message inbox ال 20 رسالة كاملين دا في حالة انك هتخلي أكونت أسمه Lock System مثلاً يبقا مشترك لكل الناس أو ممكن تخليه يبعت المسيج لنفسه دي اسهل ،، وموضوع ان كل أيتم ليه باسورد دا موضوع فاكس ،، هو يدخل باسورد فى الأول وتبقا على كل السيستم للكركتر لأي أيتم يتبعت بإسم أو أي دي الكراكتر للـ Lock or Unlock وهو اللي يدخلها عشان يبقا فاكرها ،، بالنسبة للسيرفرات اللى الموقع بتاعها التسجيل بتدخل فيه سكريت كود للاكونت لما يتكريت دي أفضل لها تشتغل بالـ Secret code دا عشان هو عمره ما هينساه عشان بيغير بيه الباسورد ،، أو للي شغال بالإيميل ممكن يشتغل على الإيميل عادي ،، اهم حاجة تكون باسورد ثابتة لأكونت أو الكراكتر وهو اللي يدخلها عشان يحتفظ بيها ،،
موضوع الأي بي دا مش هينفع عشان ال Usb modem مع كل Connect بيغير الـ IP وموضوع الـ Hwan ID مينفعش خالص هتشتغل عليه إزاي ؟
موضوع البرايفت شات دا جميل لو اشتغل بنفس النظام اللي قولت عليه فوق بتاع المسيج بس لو الكراكتر اللي هيبعتلها خدت Dc لو البرنامج مفهوش Re-Log مش هيشتغل ،،

ودي صورة من عندي

http://i.epvpimg.com/vmB1e.png

MR.KaBO

23-01-2016, 06:30 AM

تسلم . رائع

Admin.White

21-03-2016, 08:10 PM

Lock / Unlock Scroll

سلام عليكم. في بعض الناس سالوني علي السيستم دا
السيستم ببساطة بيقفل الايتم مش بيخليها تتنقل ومتطلعش برة الشخصية منعا للهاك

1- Create this table:

Use [SRO_VT_SHARDLOG]
Create Table [dbo].[LockItemsID]
([LockItemID] [Int] NOT NULL PRIMARY KEY ,
[ReqItemID] [Int] NOT NULL)

2- اعمل سطور جديدة للاسلحة او الايتم.

خد كوبي من السطور الاصلية بتاع الايتم او الاسلحة وغير الاي دي هات والاسامي

مهم:

في السطور الجديدة لازم تراعي انك تعمل الحاجات دي صفر
Can trade-Can Drop-Can Borrow-Can Sell = 0

Example:

** The original 15D weapon:

1 40315 ITEM_EU_DAGGER_15_A_RARE 15? ?? (??) xxx SN_ITEM_EU_DAGGER_15_A_RARE SN_ITEM_EU_DAGGER_15_A_RARE_TT_DESC 0 0 3 1 6 13 180000 1 2 1 1 1 255 3 1 1 1 0 0 19748000 14667 22000 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\dagger_91.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\dagger_15.ddj xxx xxx 1 2 0 0 43 0 157 236 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 3 5836 6154 7132 7521 179.1 0 0 0 0 0 6487 7162 7928 8753 0 0 0 0 142 303 0 4 25 1 ITEM_EU_DAGGER_15_A_RARE 1 ITEM_EU_DAGGER_15_B_RARE 1 ITEM_EU_DAGGER_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 40336 ITEM_EU_SWORD_15_A_RARE 15? ??? (??) xxx SN_ITEM_EU_SWORD_15_A_RARE SN_ITEM_EU_SWORD_15_A_RARE_TT_DESC 0 0 3 1 6 7 180000 1 2 1 1 1 255 3 1 1 1 0 0 17773000 10353 15530 0 9000 6220550 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\sword_91.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\sword_15.ddj xxx xxx 1 2 0 0 43 0 111 167 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 5836 6154 7132 7521 179.1 0 0 0 0 0 6487 7162 7928 8753 0 0 0 0 142 303 0 2 15 1 ITEM_EU_SWORD_15_A_RARE 1 ITEM_EU_SWORD_15_B_RARE 1 ITEM_EU_SWORD_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 40357 ITEM_EU_TSWORD_15_A_RARE 15? ??? (??) xxx SN_ITEM_EU_TSWORD_15_A_RARE SN_ITEM_EU_TSWORD_15_A_RARE_TT_DESC 0 0 3 1 6 8 180000 1 2 1 1 1 255 3 1 1 1 0 0 19748000 8628 12941 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\tsword_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\tsword_15.ddj xxx xxx 1 2 0 0 43 0 93 139 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 18 5836 6154 7132 7521 179.1 0 0 0 0 0 6487 7162 7928 8753 0 0 0 0 142 303 0 2 15 1 ITEM_EU_TSWORD_15_A_RARE 1 ITEM_EU_TSWORD_15_B_RARE 1 ITEM_EU_TSWORD_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 40378 ITEM_EU_AXE_15_A_RARE 15? ???? (??) xxx SN_ITEM_EU_AXE_15_A_RARE SN_ITEM_EU_AXE_15_A_RARE_TT_DESC 0 0 3 1 6 9 180000 1 2 1 1 1 255 3 1 1 1 0 0 19748000 14667 22000 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\axe_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\axe_15.ddj xxx xxx 1 2 0 0 43 0 157 236 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 6 5836 6154 7132 7521 179.1 0 0 0 0 0 6487 7162 7928 8753 0 0 0 0 142 303 0 2 15 1 ITEM_EU_AXE_15_A_RARE 1 ITEM_EU_AXE_15_B_RARE 1 ITEM_EU_AXE_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 40399 ITEM_EU_CROSSBOW_15_A_RARE 15? ????? (??) xxx SN_ITEM_EU_CROSSBOW_15_A_RARE SN_ITEM_EU_CROSSBOW_15_A_RARE_TT_DESC 0 0 3 1 6 12 180000 1 2 1 1 1 255 3 1 1 1 0 0 19748000 10353 15530 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\crossbow_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\crossbow_15.ddj xxx xxx 1 2 0 0 43 0 111 167 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 180 5836 6154 7132 7521 179.1 0 0 0 0 0 6487 7162 7928 8753 0 0 0 0 142 303 0 4 20 1 ITEM_EU_CROSSBOW_15_A_RARE 1 ITEM_EU_CROSSBOW_15_B_RARE 1 ITEM_EU_CROSSBOW_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 40420 ITEM_EU_DARKSTAFF_15_A_RARE 15? ???? (??) xxx SN_ITEM_EU_DARKSTAFF_15_A_RARE SN_ITEM_EU_DARKSTAFF_15_A_RARE_TT_DESC 0 0 3 1 6 10 180000 1 2 1 1 1 255 3 1 1 1 0 0 17773000 8628 12941 0 9000 6220550 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\darkstaff_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\darkstaff_15.ddj xxx xxx 1 2 0 0 43 0 185 278 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 0 0 0 0 0 9337 9846 11412 12034 286.5 0 0 0 0 10378 11459 12685 14005 142 303 0 2 2 1 ITEM_EU_DARKSTAFF_15_A_RARE 1 ITEM_EU_DARKSTAFF_15_B_RARE 1 ITEM_EU_DARKSTAFF_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 40441 ITEM_EU_TSTAFF_15_A_RARE 15? ??? (??) xxx SN_ITEM_EU_TSTAFF_15_A_RARE SN_ITEM_EU_TSTAFF_15_A_RARE_TT_DESC 0 0 3 1 6 11 180000 1 2 1 1 1 255 3 1 1 1 0 0 19748000 8628 12941 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\tstaff_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\tstaff_15.ddj xxx xxx 1 2 0 0 43 0 93 139 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 6 0 0 0 0 0 9337 9846 11412 12034 286.5 0 0 0 0 10378 11459 12685 14005 142 303 0 2 2 1 ITEM_EU_TSTAFF_15_A_RARE 1 ITEM_EU_TSTAFF_15_B_RARE 1 ITEM_EU_TSTAFF_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 40462 ITEM_EU_HARP_15_A_RARE 15? ?? (??) xxx SN_ITEM_EU_HARP_15_A_RARE SN_ITEM_EU_HARP_15_A_RARE_TT_DESC 0 0 3 1 6 14 180000 1 2 1 1 1 255 3 1 1 1 0 0 19748000 7765 11647 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\harp_12.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\harp_15.ddj xxx xxx 1 2 0 0 43 0 83 125 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 6 0 0 0 0 0 9337 9846 11412 12034 286.5 0 0 0 0 10378 11459 12685 14005 142 303 0 2 2 1 ITEM_EU_HARP_15_A_RARE 1 ITEM_EU_HARP_15_B_RARE 1 ITEM_EU_HARP_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 40483 ITEM_EU_STAFF_15_A_RARE 15? ??? ?? (??) xxx SN_ITEM_EU_STAFF_15_A_RARE SN_ITEM_EU_STAFF_15_A_RARE_TT_DESC 0 0 3 1 6 15 180000 1 2 1 1 1 255 3 1 1 1 0 0 19748000 8628 12941 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\staff_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\staff_15.ddj xxx xxx 1 2 0 0 43 0 93 139 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 0 0 0 0 0 9337 9846 11412 12034 286.5 0 0 0 0 10378 11459 12685 14005 142 303 0 2 2 1 ITEM_EU_STAFF_15_A_RARE 1 ITEM_EU_STAFF_15_B_RARE 1 ITEM_EU_STAFF_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 40504 ITEM_EU_SHIELD_15_A_RARE 15? ?? ?? (??) xxx SN_ITEM_EU_SHIELD_15_A_RARE SN_ITEM_EU_SHIELD_15_A_RARE_TT_DESC 0 0 3 1 4 2 180000 1 2 1 1 1 255 3 1 1 1 0 0 9874000 9059 13588 0 9000 3455900 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\shield\shield_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\shield\shield_15.ddj xxx xxx 1 2 0 0 43 0 97 146 648.4 683.8 17.9 0 0 0 0 0 0 14 23 1037.4 1094 28.6 0 0 0 721 796 1153 1273 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 ITEM_EU_SHIELD_15_A_RARE 1 ITEM_EU_SHIELD_15_B_RARE 1 ITEM_EU_SHIELD_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_SH_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 ?? ??? ?? ?? ? 9 0

1 39370 ITEM_CH_SWORD_15_A_RARE 15? ? (??) xxx SN_ITEM_CH_SWORD_15_A_RARE SN_ITEM_CH_SWORD_15_A_RARE_TT_DESC 0 0 3 1 6 2 180000 0 2 1 1 1 255 3 1 1 1 0 0 17773000 12294 18441 0 9000 6220550 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\weapon\sword_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\sword_15.ddj xxx xxx 1 2 0 0 43 0 148 181 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 4349 4586 4902 5169 127.7 7400 7804 8507 8971 219.6 4930 5130 5558 5782 8390 8729 9645 10035 142 303 0 4 16 1 ITEM_CH_SWORD_15_A_RARE 1 ITEM_CH_SWORD_15_B_RARE 1 ITEM_CH_SWORD_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 39391 ITEM_CH_BLADE_15_A_RARE 15? ? (??) xxx SN_ITEM_CH_BLADE_15_A_RARE SN_ITEM_CH_BLADE_15_A_RARE_TT_DESC 0 0 3 1 6 3 180000 0 2 1 1 1 255 3 1 1 1 0 0 17773000 13588 20382 0 9000 6220550 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\weapon\blade_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\blade_15.ddj xxx xxx 1 2 0 0 43 0 164 200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 4625 4878 5317 5607 137.3 6958 7337 7843 8271 204.4 5244 5456 6028 6272 7889 8207 8892 9251 142 303 0 3 15 1 ITEM_CH_BLADE_15_A_RARE 1 ITEM_CH_BLADE_15_B_RARE 1 ITEM_CH_BLADE_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 39412 ITEM_CH_SPEAR_15_A_RARE 15? ? (??) xxx SN_ITEM_CH_SPEAR_15_A_RARE SN_ITEM_CH_SPEAR_15_A_RARE_TT_DESC 0 0 3 1 6 4 180000 0 2 1 1 1 255 3 1 1 1 0 0 19748000 8196 12294 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\weapon\spear_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\spear_15.ddj xxx xxx 1 2 0 0 43 0 99 121 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 18 4539 4786 5403 5698 137.3 7781 8205 9510 10029 238.8 5146 5354 6126 6374 8822 9178 10782 11218 142 303 0 5 17 1 ITEM_CH_SPEAR_15_A_RARE 1 ITEM_CH_SPEAR_15_B_RARE 1 ITEM_CH_SPEAR_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 39433 ITEM_CH_TBLADE_15_A_RARE 15? ?? (??) xxx SN_ITEM_CH_TBLADE_15_A_RARE SN_ITEM_CH_TBLADE_15_A_RARE_TT_DESC 0 0 3 1 6 5 180000 0 2 1 1 1 255 3 1 1 1 0 0 19748000 9059 13588 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\weapon\tblade_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\tblade_15.ddj xxx xxx 1 2 0 0 43 0 109 134 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 18 4863 5128 5944 6268 149.2 7262 7658 8645 9117 219.6 5514 5736 6739 7011 8234 8566 9802 10198 142 303 0 4 16 1 ITEM_CH_TBLADE_15_A_RARE 1 ITEM_CH_TBLADE_15_B_RARE 1 ITEM_CH_TBLADE_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 39454 ITEM_CH_BOW_15_A_RARE 15? ? (??) xxx SN_ITEM_CH_BOW_15_A_RARE SN_ITEM_CH_BOW_15_A_RARE_TT_DESC 0 0 3 1 6 6 180000 0 2 1 1 1 255 3 1 1 1 0 0 19748000 9318 13977 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\weapon\bow_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\bow_15.ddj xxx xxx 1 2 0 0 43 0 112 137 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 2 1 180 4399 4639 5391 5686 135.2 7039 7423 8626 9097 216.3 4988 5189 6113 6360 7981 8303 9780 10175 142 303 0 4 14 1 ITEM_CH_BOW_15_A_RARE 1 ITEM_CH_BOW_15_B_RARE 1 ITEM_CH_BOW_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 39475 ITEM_CH_SHIELD_15_A_RARE 15? ?? (??) xxx SN_ITEM_CH_SHIELD_15_A_RARE SN_ITEM_CH_SHIELD_15_A_RARE_TT_DESC 0 0 3 1 4 1 180000 0 2 1 1 1 255 3 1 1 1 0 0 9874000 9059 13588 0 9000 3455900 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\shield\shield_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\shield\shield_15.ddj xxx xxx 1 2 0 0 43 0 109 134 648.4 683.8 17.9 0 0 0 0 0 0 14 23 1037.4 1094 28.6 0 0 0 735 765 1235 1285 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 ITEM_CH_SHIELD_15_A_RARE 1 ITEM_CH_SHIELD_15_B_RARE 1 ITEM_CH_SHIELD_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_SH_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 ?? ??? ?? ?? ? 9 0

** The locked 15D weapons:
1 80315 ITEM_EU_DAGGER_15_A_RARE_CHAOS 15? ?? (??) xxx SN_ITEM_EU_DAGGER_15_A_RARE_CHAOS SN_ITEM_EU_DAGGER_15_A_RARE_TT_DESC 0 0 3 1 6 13 180000 1 2 0 0 0 0 0 0 0 0 0 0 19748000 14667 22000 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\dagger_91.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\dagger_15.ddj xxx xxx 1 2 0 0 43 0 157 236 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 3 5836 6154 7132 7521 179.1 0 0 0 0 0 6487 7162 7928 8753 0 0 0 0 142 303 0 4 25 1 ITEM_EU_DAGGER_15_A_RARE_CHAOS 1 ITEM_EU_DAGGER_15_B_RARE 1 ITEM_EU_DAGGER_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80336 ITEM_EU_SWORD_15_A_RARE_CHAOS 15? ??? (??) xxx SN_ITEM_EU_SWORD_15_A_RARE_CHAOS SN_ITEM_EU_SWORD_15_A_RARE_TT_DESC 0 0 3 1 6 7 180000 1 2 0 0 0 0 0 0 0 0 0 0 17773000 10353 15530 0 9000 6220550 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\sword_91.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\sword_15.ddj xxx xxx 1 2 0 0 43 0 111 167 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 5836 6154 7132 7521 179.1 0 0 0 0 0 6487 7162 7928 8753 0 0 0 0 142 303 0 2 15 1 ITEM_EU_SWORD_15_A_RARE_CHAOS 1 ITEM_EU_SWORD_15_B_RARE 1 ITEM_EU_SWORD_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80357 ITEM_EU_TSWORD_15_A_RARE_CHAOS 15? ??? (??) xxx SN_ITEM_EU_TSWORD_15_A_RARE_CHAOS SN_ITEM_EU_TSWORD_15_A_RARE_TT_DESC 0 0 3 1 6 8 180000 1 2 0 0 0 0 0 0 0 0 0 0 19748000 8628 12941 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\tsword_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\tsword_15.ddj xxx xxx 1 2 0 0 43 0 93 139 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 18 5836 6154 7132 7521 179.1 0 0 0 0 0 6487 7162 7928 8753 0 0 0 0 142 303 0 2 15 1 ITEM_EU_TSWORD_15_A_RARE_CHAOS 1 ITEM_EU_TSWORD_15_B_RARE 1 ITEM_EU_TSWORD_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80378 ITEM_EU_AXE_15_A_RARE_CHAOS 15? ???? (??) xxx SN_ITEM_EU_AXE_15_A_RARE_CHAOS SN_ITEM_EU_AXE_15_A_RARE_TT_DESC 0 0 3 1 6 9 180000 1 2 0 0 0 0 0 0 0 0 0 0 19748000 14667 22000 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\axe_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\axe_15.ddj xxx xxx 1 2 0 0 43 0 157 236 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 6 5836 6154 7132 7521 179.1 0 0 0 0 0 6487 7162 7928 8753 0 0 0 0 142 303 0 2 15 1 ITEM_EU_AXE_15_A_RARE_CHAOS 1 ITEM_EU_AXE_15_B_RARE 1 ITEM_EU_AXE_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80399 ITEM_EU_CROSSBOW_15_A_RARE_CHAOS 15? ????? (??) xxx SN_ITEM_EU_CROSSBOW_15_A_RARE_CHAOS SN_ITEM_EU_CROSSBOW_15_A_RARE_TT_DESC 0 0 3 1 6 12 180000 1 2 0 0 0 0 0 0 0 0 0 0 19748000 10353 15530 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\crossbow_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\crossbow_15.ddj xxx xxx 1 2 0 0 43 0 111 167 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 180 5836 6154 7132 7521 179.1 0 0 0 0 0 6487 7162 7928 8753 0 0 0 0 142 303 0 4 20 1 ITEM_EU_CROSSBOW_15_A_RARE_CHAOS 1 ITEM_EU_CROSSBOW_15_B_RARE 1 ITEM_EU_CROSSBOW_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80420 ITEM_EU_DARKSTAFF_15_A_RARE_CHAOS 15? ???? (??) xxx SN_ITEM_EU_DARKSTAFF_15_A_RARE_CHAOS SN_ITEM_EU_DARKSTAFF_15_A_RARE_TT_DESC 0 0 3 1 6 10 180000 1 2 0 0 0 0 0 0 0 0 0 0 17773000 8628 12941 0 9000 6220550 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\darkstaff_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\darkstaff_15.ddj xxx xxx 1 2 0 0 43 0 185 278 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 0 0 0 0 0 9337 9846 11412 12034 286.5 0 0 0 0 10378 11459 12685 14005 142 303 0 2 2 1 ITEM_EU_DARKSTAFF_15_A_RARE_CHAOS 1 ITEM_EU_DARKSTAFF_15_B_RARE 1 ITEM_EU_DARKSTAFF_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80441 ITEM_EU_TSTAFF_15_A_RARE_CHAOS 15? ??? (??) xxx SN_ITEM_EU_TSTAFF_15_A_RARE_CHAOS SN_ITEM_EU_TSTAFF_15_A_RARE_TT_DESC 0 0 3 1 6 11 180000 1 2 0 0 0 0 0 0 0 0 0 0 19748000 8628 12941 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\tstaff_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\tstaff_15.ddj xxx xxx 1 2 0 0 43 0 93 139 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 6 0 0 0 0 0 9337 9846 11412 12034 286.5 0 0 0 0 10378 11459 12685 14005 142 303 0 2 2 1 ITEM_EU_TSTAFF_15_A_RARE_CHAOS 1 ITEM_EU_TSTAFF_15_B_RARE 1 ITEM_EU_TSTAFF_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80462 ITEM_EU_HARP_15_A_RARE_CHAOS 15? ?? (??) xxx SN_ITEM_EU_HARP_15_A_RARE_CHAOS SN_ITEM_EU_HARP_15_A_RARE_TT_DESC 0 0 3 1 6 14 180000 1 2 0 0 0 0 0 0 0 0 0 0 19748000 7765 11647 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\harp_12.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\harp_15.ddj xxx xxx 1 2 0 0 43 0 83 125 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 6 0 0 0 0 0 9337 9846 11412 12034 286.5 0 0 0 0 10378 11459 12685 14005 142 303 0 2 2 1 ITEM_EU_HARP_15_A_RARE_CHAOS 1 ITEM_EU_HARP_15_B_RARE 1 ITEM_EU_HARP_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80483 ITEM_EU_STAFF_15_A_RARE_CHAOS 15? ??? ?? (??) xxx SN_ITEM_EU_STAFF_15_A_RARE_CHAOS SN_ITEM_EU_STAFF_15_A_RARE_TT_DESC 0 0 3 1 6 15 180000 1 2 0 0 0 0 0 0 0 0 0 0 19748000 8628 12941 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\staff_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\staff_15.ddj xxx xxx 1 2 0 0 43 0 93 139 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 0 0 0 0 0 9337 9846 11412 12034 286.5 0 0 0 0 10378 11459 12685 14005 142 303 0 2 2 1 ITEM_EU_STAFF_15_A_RARE_CHAOS 1 ITEM_EU_STAFF_15_B_RARE 1 ITEM_EU_STAFF_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80504 ITEM_EU_SHIELD_15_A_RARE_CHAOS 15? ?? ?? (??) xxx SN_ITEM_EU_SHIELD_15_A_RARE_CHAOS SN_ITEM_EU_SHIELD_15_A_RARE_TT_DESC 0 0 3 1 4 2 180000 1 2 0 0 0 0 0 0 0 0 0 0 9874000 9059 13588 0 9000 3455900 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\shield\shield_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\shield\shield_15.ddj xxx xxx 1 2 0 0 43 0 97 146 648.4 683.8 17.9 0 0 0 0 0 0 14 23 1037.4 1094 28.6 0 0 0 721 796 1153 1273 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 ITEM_EU_SHIELD_15_A_RARE_CHAOS 1 ITEM_EU_SHIELD_15_B_RARE 1 ITEM_EU_SHIELD_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_SH_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 ?? ??? ?? ?? ? 9 0

1 80370 ITEM_CH_SWORD_15_A_RARE_CHAOS 15? ? (??) xxx SN_ITEM_CH_SWORD_15_A_RARE_CHAOS SN_ITEM_CH_SWORD_15_A_RARE_TT_DESC 0 0 3 1 6 2 180000 0 2 0 0 0 0 0 0 0 0 0 0 17773000 12294 18441 0 9000 6220550 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\weapon\sword_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\sword_15.ddj xxx xxx 1 2 0 0 43 0 148 181 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 4349 4586 4902 5169 127.7 7400 7804 8507 8971 219.6 4930 5130 5558 5782 8390 8729 9645 10035 142 303 0 4 16 1 ITEM_CH_SWORD_15_A_RARE_CHAOS 1 ITEM_CH_SWORD_15_B_RARE 1 ITEM_CH_SWORD_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80391 ITEM_CH_BLADE_15_A_RARE_CHAOS 15? ? (??) xxx SN_ITEM_CH_BLADE_15_A_RARE_CHAOS SN_ITEM_CH_BLADE_15_A_RARE_TT_DESC 0 0 3 1 6 3 180000 0 2 0 0 0 0 0 0 0 0 0 0 17773000 13588 20382 0 9000 6220550 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\weapon\blade_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\blade_15.ddj xxx xxx 1 2 0 0 43 0 164 200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 4625 4878 5317 5607 137.3 6958 7337 7843 8271 204.4 5244 5456 6028 6272 7889 8207 8892 9251 142 303 0 3 15 1 ITEM_CH_BLADE_15_A_RARE_CHAOS 1 ITEM_CH_BLADE_15_B_RARE 1 ITEM_CH_BLADE_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80412 ITEM_CH_SPEAR_15_A_RARE_CHAOS 15? ? (??) xxx SN_ITEM_CH_SPEAR_15_A_RARE_CHAOS SN_ITEM_CH_SPEAR_15_A_RARE_TT_DESC 0 0 3 1 6 4 180000 0 2 0 0 0 0 0 0 0 0 0 0 19748000 8196 12294 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\weapon\spear_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\spear_15.ddj xxx xxx 1 2 0 0 43 0 99 121 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 18 4539 4786 5403 5698 137.3 7781 8205 9510 10029 238.8 5146 5354 6126 6374 8822 9178 10782 11218 142 303 0 5 17 1 ITEM_CH_SPEAR_15_A_RARE_CHAOS 1 ITEM_CH_SPEAR_15_B_RARE 1 ITEM_CH_SPEAR_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80433 ITEM_CH_TBLADE_15_A_RARE_CHAOS 15? ?? (??) xxx SN_ITEM_CH_TBLADE_15_A_RARE_CHAOS SN_ITEM_CH_TBLADE_15_A_RARE_TT_DESC 0 0 3 1 6 5 180000 0 2 0 0 0 0 0 0 0 0 0 0 19748000 9059 13588 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\weapon\tblade_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\tblade_15.ddj xxx xxx 1 2 0 0 43 0 109 134 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 18 4863 5128 5944 6268 149.2 7262 7658 8645 9117 219.6 5514 5736 6739 7011 8234 8566 9802 10198 142 303 0 4 16 1 ITEM_CH_TBLADE_15_A_RARE_CHAOS 1 ITEM_CH_TBLADE_15_B_RARE 1 ITEM_CH_TBLADE_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80454 ITEM_CH_BOW_15_A_RARE_CHAOS 15? ? (??) xxx SN_ITEM_CH_BOW_15_A_RARE_CHAOS SN_ITEM_CH_BOW_15_A_RARE_TT_DESC 0 0 3 1 6 6 180000 0 2 0 0 0 0 0 0 0 0 0 0 19748000 9318 13977 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\weapon\bow_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\bow_15.ddj xxx xxx 1 2 0 0 43 0 112 137 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 2 1 180 4399 4639 5391 5686 135.2 7039 7423 8626 9097 216.3 4988 5189 6113 6360 7981 8303 9780 10175 142 303 0 4 14 1 ITEM_CH_BOW_15_A_RARE_CHAOS 1 ITEM_CH_BOW_15_B_RARE 1 ITEM_CH_BOW_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0
1 80475 ITEM_CH_SHIELD_15_A_RARE_CHAOS 15? ?? (??) xxx SN_ITEM_CH_SHIELD_15_A_RARE_CHAOS SN_ITEM_CH_SHIELD_15_A_RARE_TT_DESC 0 0 3 1 4 1 180000 0 2 0 0 0 0 0 0 0 0 0 0 9874000 9059 13588 0 9000 3455900 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\shield\shield_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\shield\shield_15.ddj xxx xxx 1 2 0 0 43 0 109 134 648.4 683.8 17.9 0 0 0 0 0 0 14 23 1037.4 1094 28.6 0 0 0 735 765 1235 1285 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 ITEM_CH_SHIELD_15_A_RARE_CHAOS 1 ITEM_CH_SHIELD_15_B_RARE 1 ITEM_CH_SHIELD_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_SH_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 ?? ??? ?? ?? ? 9 0

لاحظو الفرق بين الاتنين واعملوها علي اي ديجري انتو عايزينه

Add this at LOG db at AddLogItem

IF (@operation = 41 and @ItemRefID = '81023')
Begin
Declare @ID64 Int , @RefItemID Int , @NewRefID Int
Select Top 1 @ID64 = Inv.ItemID , @RefItemID = Items.RefItemID From [SRO_VT_SHARD].[dbo].[_Inventory] As Inv Inner Join [SRO_VT_SHARD].[dbo].[_Items] As Items ON Inv.ItemID = Items.ID64 Where Inv.CharID = @CharID and Inv.ItemID > 0 and Inv.Slot = 13
Select Top 1 @NewRefID = LockItemID From [dbo].[LockItemsID] Where ReqItemID = @RefItemID
IF @NewRefID IS NOT NULL and @ID64 IS NOT NULL
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @NewRefID Where ID64 = @ID64
End
End

-- Unlock
IF (@operation = 41 and @ItemRefID = '81024')
Begin
Select Top 1 @ID64 = Inv.ItemID , @RefItemID = Items.RefItemID From [SRO_VT_SHARD].[dbo].[_Inventory] As Inv Inner Join [SRO_VT_SHARD].[dbo].[_Items] As Items ON Inv.ItemID = Items.ID64 Where Inv.CharID = @CharID and Inv.ItemID > 0 and Inv.Slot = 13
Select Top 1 @NewRefID = ReqItemID From [dbo].[LockItemsID] Where LockItemID = @RefItemID
IF @NewRefID IS NOT NULL and @ID64 IS NOT NULL
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @NewRefID Where ID64 = @ID64
End
End

Then create this :

USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_HamzaLockSystemD15] Script Date: 11/3/2015 8:01:33 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[_HamzaLockSystemD15]
@CharID Int
As

-- Declare expression.
Declare @CreaterName Varchar(60) = 'Figozz' , -- Creater Name
@Slot Int = '13' , -- char inventory slot 1.
@ReqOptLevel Int = '0' , -- Requiared Opt Level to upgrade
@OptDifference Int = '2' , -- Set the difference optlevel between old plus and new plus.
@OldOptLevel Int ,
@NewOptLevel Int ,
@AdvValue Int ,
@ID64 Int ,
-------------------------

-- Set Old and New Item RefObjCommon ID below
-- Use This Query to get each item ID by Codename128
-- Select ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where CodeName128 Like 'Item Code Name'

---> Old weapon ID's ---> New weapons ID's
@Old_CH_SWORD_ID Int = 39368 , @New_CH_SWORD_ID Int = 80370 , --@New Chinese Sword
@Old_CH_BLADE_ID Int = 39391 , @New_CH_BLADE_ID Int = 80391 , --@Chinese Blade
@Old_CH_SPEAR_ID Int = 39412 , @New_CH_SPEAR_ID Int = 80412 , --@Chinese Spear
@Old_CH_TBLADE_ID Int = 39433 , @New_CH_TBLADE_ID Int = 80433 , --@Chinese Glaive
@Old_CH_BOW_ID Int = 39454 , @New_CH_BOW_ID Int = 80454 , --@Chinese Bow
@Old_CH_SHIELD_ID Int = 39475 , @New_CH_SHIELD_ID Int = 80475 , --@Chinese Shield
@Old_EU_DAGGER_ID Int = 40315 , @New_EU_DAGGER_ID Int = 80315 , --@European Dagger
@Old_EU_XBOW_ID Int = 40399 , @New_EU_XBOW_ID Int = 80399 , --@European CrossBow
@Old_EU_AXE_ID Int = 40378 , @New_EU_AXE_ID Int = 80378 , --@European Axe
@Old_EU_SWORD_ID Int = 40336 , @New_EU_SWORD_ID Int = 80336 , --@European One Hand Sword
@Old_EU_TSWORD_ID Int = 40357 , @New_EU_TSWORD_ID Int = 80357 , --@European Two Hand Sword
@Old_EU_TSTAFF_ID Int = 40441 , @New_EU_TSTAFF_ID Int = 80441 , --@European Two Hand Staff
@Old_EU_STAFF_ID Int = 40483 , @New_EU_STAFF_ID Int = 80483 , --@European Claric Rod
@Old_EU_DSTAFF_ID Int = 40420 , @New_EU_DSTAFF_ID Int = 80420 , --@European Warlock Rod
@Old_EU_HARP_ID Int = 40462 , @New_EU_HARP_ID Int = 80462 , --@European Harp
@Old_EU_SHIELD_ID Int = 40504 , @New_EU_SHIELD_ID Int = 80504 --@European Shield
--------------------------------------------------------------------------------------------
Set @ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @Slot and ItemID > 0)
Set @OldOptLevel = (Select OptLevel From [SRO_VT_SHARD].[dbo].[_Items] Where ID64 = @ID64)

-- Start Lock system :

-- First Case :
-- IF Item has not advanced elixir :

IF NOT EXISTS (Select * From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
Begin
IF @OldOptLevel >= @ReqOptLevel
Begin
Set @NewOptLevel = @OldOptLevel - @OptDifference
-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SWORD_ID and (OptLevel = @OldOptLevel) --@Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BLADE_ID and (OptLevel = @OldOptLevel) --@Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SPEAR_ID and (OptLevel = @OldOptLevel) --@Spear
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_TBLADE_ID and (OptLevel = @OldOptLevel) --@T-Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BOW_ID and (OptLevel = @OldOptLevel) --@Bow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
-- EU Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DAGGER_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DAGGER_ID and (OptLevel = @OldOptLevel) --@Dagger
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_XBOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_XBOW_ID and (OptLevel = @OldOptLevel) --@Crossbow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_AXE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_AXE_ID and (OptLevel = @OldOptLevel) --@Axe
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SWORD_ID and (OptLevel = @OldOptLevel) --@OneHand Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSWORD_ID and (OptLevel = @OldOptLevel) --@T-Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSTAFF_ID and (OptLevel = @OldOptLevel) --@T-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_STAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_STAFF_ID and (OptLevel = @OldOptLevel) --@Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DSTAFF_ID and (OptLevel = @OldOptLevel) --@Dark-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_HARP_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_HARP_ID and (OptLevel = @OldOptLevel) --@Harp
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
End
End

-- Second Case :
-- IF Item has advanced elixir :

ELSE IF EXISTS (Select * From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
Begin
Set @AdvValue = (Select nOptValue From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
IF @OldOptLevel >= @ReqOptLevel
Begin
Set @NewOptLevel = (@OldOptLevel - @OptDifference) + @AdvValue
-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SWORD_ID and (OptLevel = @OldOptLevel) --@Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BLADE_ID and (OptLevel = @OldOptLevel) --@Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SPEAR_ID and (OptLevel = @OldOptLevel) --@Spear
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_TBLADE_ID and (OptLevel = @OldOptLevel) --@T-Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BOW_ID and (OptLevel = @OldOptLevel) --@Bow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
-- EU Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DAGGER_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DAGGER_ID and (OptLevel = @OldOptLevel) --@Dagger
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_XBOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_XBOW_ID and (OptLevel = @OldOptLevel) --@Crossbow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_AXE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_AXE_ID and (OptLevel = @OldOptLevel) --@Axe
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SWORD_ID and (OptLevel = @OldOptLevel) --@OneHand Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSWORD_ID and (OptLevel = @OldOptLevel) --@T-Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSTAFF_ID and (OptLevel = @OldOptLevel) --@T-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_STAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_STAFF_ID and (OptLevel = @OldOptLevel) --@Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DSTAFF_ID and (OptLevel = @OldOptLevel) --@Dark-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_HARP_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_HARP_ID and (OptLevel = @OldOptLevel) --@Harp
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
End
End

USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_HamzaLockSystemD15Unlock] Script Date: 11/3/2015 8:02:10 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[_HamzaLockSystemD15Unlock]
@CharID Int
As

-- Declare expression.
Declare @CreaterName Varchar(60) = 'Figozz' , -- Creater Name
@Slot Int = '13' , -- char inventory slot 1.
@ReqOptLevel Int = '0' , -- Requiared Opt Level to upgrade
@OptDifference Int = '2' , -- Set the difference optlevel between old plus and new plus.
@OldOptLevel Int ,
@NewOptLevel Int ,
@AdvValue Int ,
@ID64 Int ,
-------------------------

-- Set Old and New Item RefObjCommon ID below
-- Use This Query to get each item ID by Codename128
-- Select ID From [SRO_VT_SHARD].[dbo].[_RefObjCommon] Where CodeName128 Like 'Item Code Name'

---> Old weapon ID's ---> New weapons ID's
@Old_CH_SWORD_ID Int = 80370 , @New_CH_SWORD_ID Int = 39370 , --@New Chinese Sword
@Old_CH_BLADE_ID Int = 80391 , @New_CH_BLADE_ID Int = 39391 , --@Chinese Blade
@Old_CH_SPEAR_ID Int = 80412 , @New_CH_SPEAR_ID Int = 39412 , --@Chinese Spear
@Old_CH_TBLADE_ID Int = 80433 , @New_CH_TBLADE_ID Int = 39433 , --@Chinese Glaive
@Old_CH_BOW_ID Int = 80454 , @New_CH_BOW_ID Int = 39454 , --@Chinese Bow
@Old_CH_SHIELD_ID Int = 80475 , @New_CH_SHIELD_ID Int = 39475 , --@Chinese Shield
@Old_EU_DAGGER_ID Int = 80315 , @New_EU_DAGGER_ID Int = 40315 , --@European Dagger
@Old_EU_XBOW_ID Int = 80399 , @New_EU_XBOW_ID Int = 40399 , --@European CrossBow
@Old_EU_AXE_ID Int = 80378 , @New_EU_AXE_ID Int = 40378 , --@European Axe
@Old_EU_SWORD_ID Int = 80336 , @New_EU_SWORD_ID Int = 40336 , --@European One Hand Sword
@Old_EU_TSWORD_ID Int = 80357 , @New_EU_TSWORD_ID Int = 40357 , --@European Two Hand Sword
@Old_EU_TSTAFF_ID Int = 80441 , @New_EU_TSTAFF_ID Int = 40441 , --@European Two Hand Staff
@Old_EU_STAFF_ID Int = 80483 , @New_EU_STAFF_ID Int = 40483 , --@European Claric Rod
@Old_EU_DSTAFF_ID Int = 80420 , @New_EU_DSTAFF_ID Int = 40420 , --@European Warlock Rod
@Old_EU_HARP_ID Int = 80462 , @New_EU_HARP_ID Int = 40462 , --@European Harp
@Old_EU_SHIELD_ID Int = 80504 , @New_EU_SHIELD_ID Int = 40504 --@European Shield
--------------------------------------------------------------------------------------------
Set @ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = @Slot and ItemID > 0)
Set @OldOptLevel = (Select OptLevel From [SRO_VT_SHARD].[dbo].[_Items] Where ID64 = @ID64)

-- Start Lock system :

-- First Case :
-- IF Item has not advanced elixir :

IF NOT EXISTS (Select * From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
Begin
IF @OldOptLevel >= @ReqOptLevel
Begin
Set @NewOptLevel = @OldOptLevel - @OptDifference
-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SWORD_ID and (OptLevel = @OldOptLevel) --@Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BLADE_ID and (OptLevel = @OldOptLevel) --@Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SPEAR_ID and (OptLevel = @OldOptLevel) --@Spear
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_TBLADE_ID and (OptLevel = @OldOptLevel) --@T-Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BOW_ID and (OptLevel = @OldOptLevel) --@Bow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
-- EU Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DAGGER_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DAGGER_ID and (OptLevel = @OldOptLevel) --@Dagger
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_XBOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_XBOW_ID and (OptLevel = @OldOptLevel) --@Crossbow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_AXE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_AXE_ID and (OptLevel = @OldOptLevel) --@Axe
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SWORD_ID and (OptLevel = @OldOptLevel) --@OneHand Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSWORD_ID and (OptLevel = @OldOptLevel) --@T-Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSTAFF_ID and (OptLevel = @OldOptLevel) --@T-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_STAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_STAFF_ID and (OptLevel = @OldOptLevel) --@Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DSTAFF_ID and (OptLevel = @OldOptLevel) --@Dark-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_HARP_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_HARP_ID and (OptLevel = @OldOptLevel) --@Harp
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
End
End

-- Second Case :
-- IF Item has advanced elixir :

ELSE IF EXISTS (Select * From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
Begin
Set @AdvValue = (Select nOptValue From [SRO_VT_SHARD].[dbo].[_BindingOptionWithItem] Where bOptType = 2 and nItemDBID = @ID64)
IF @OldOptLevel >= @ReqOptLevel
Begin
Set @NewOptLevel = (@OldOptLevel - @OptDifference) + @AdvValue
-- CH Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SWORD_ID and (OptLevel = @OldOptLevel) --@Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BLADE_ID and (OptLevel = @OldOptLevel) --@Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SPEAR_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SPEAR_ID and (OptLevel = @OldOptLevel) --@Spear
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_TBLADE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_TBLADE_ID and (OptLevel = @OldOptLevel) --@T-Blade
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_BOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_BOW_ID and (OptLevel = @OldOptLevel) --@Bow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_CH_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_CH_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
-- EU Weapons Upgrade.
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DAGGER_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DAGGER_ID and (OptLevel = @OldOptLevel) --@Dagger
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_XBOW_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_XBOW_ID and (OptLevel = @OldOptLevel) --@Crossbow
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_AXE_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_AXE_ID and (OptLevel = @OldOptLevel) --@Axe
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SWORD_ID and (OptLevel = @OldOptLevel) --@OneHand Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSWORD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSWORD_ID and (OptLevel = @OldOptLevel) --@T-Sword
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_TSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_TSTAFF_ID and (OptLevel = @OldOptLevel) --@T-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_STAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_STAFF_ID and (OptLevel = @OldOptLevel) --@Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_DSTAFF_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_DSTAFF_ID and (OptLevel = @OldOptLevel) --@Dark-Staff
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_HARP_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_HARP_ID and (OptLevel = @OldOptLevel) --@Harp
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID = @New_EU_SHIELD_ID , OptLevel = @NewOptLevel Where ID64 = @ID64 and RefItemID = @Old_EU_SHIELD_ID and (OptLevel = @OldOptLevel) --@Shield
End
End

Thanks to Dev. iLegend ~_^

الاسكرول الرئيسي لـ اللي ميعرفش يعملها

refObjCommon

1 81023 ITEM_CHAOS_LOCK ????? (????) xxx SN_ITEM_CHAOS_LOCK SN_ITEM_CHAOS_LOCK_TT_DESC 0 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 0 0 0 0 0 1 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\lock_indulgence.ddj xxx xxx 90000
1 81024 ITEM_CHAOS_UNLOCK ????? (????) xxx SN_ITEM_CHAOS_UNLOCK SN_ITEM_CHAOS_UNLOCK_TT_DESC 0 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 0 0 0 0 0 1 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\unlock_indulgence.ddj xxx xxx 90001

refObjItem

90000 1 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0
90001 1 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0 0

itemdata_xxxxxx

1 81023 ITEM_CHAOS_LOCK ????? (????) xxx SN_ITEM_CHAOS_LOCK SN_ITEM_CHAOS_LOCK_TT_DESC 0 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 0 0 0 0 0 1 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\lock_indulgence.ddj xxx xxx 1 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0
1 81024 ITEM_CHAOS_UNLOCK ????? (????) xxx SN_ITEM_CHAOS_UNLOCK SN_ITEM_CHAOS_UNLOCK_TT_DESC 0 0 3 3 3 1 180000 3 0 1 1 1 255 3 1 0 0 1 0 0 0 0 0 0 1 -1 0 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 xxx item\etc\drop_mall_scroll.bsr item\etc\unlock_indulgence.ddj xxx xxx 1 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1000 ???? 1 ?????? -1 RESURRECT -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 0

textdata_object

1 SN_ITEM_CHAOS_LOCK Lock Scroll
1 SN_ITEM_CHAOS_LOCK_TT_DESC <sml2>This scroll will LOCK your items to avoid to be scammed. How to use: -Put ur item at the first slot in ur inventory (LEFT) - Use the scroll. Regards from [GM] Figoz</sml2>
1 SN_ITEM_CHAOS_UNLOCK UNLock Scroll
1 SN_ITEM_CHAOS_UNLOCK_TT_DESC <sml2>This scroll will unlock your items, so u can trade/sell it. How to use: -Put ur item at the first slot in ur inventory (LEFT) - Use the scroll. Regards from [GM] Figoz</sml2>

http://s26.postimg.org/g48jv4ie1/2683849alt2c6g21e.gif

وبخصوص البلاص تم عمل الصح ^^ من برنامج Zealous

كدة زي isro بالظبط. لو الاكونت بتاعك مع السيرفر كله متخافش علية

4vhDJxMHplw

Regards

أستاذ حمزه أنا عملت الرساله دي بس ماإشتغلتش وبالرغم إنى مفيش حاجه ناقصه ... ممكن رد

Admin.White

21-03-2016, 08:30 PM

وبرده أنا مش شايف أي صله مابين LockItemsID مابين _HamzaLockSystemD15 . _HamzaLockSystemD15Unlock

S4A_Knight

27-03-2016, 01:43 PM

تسلم يا باشا :kissing:

HLP

03-04-2016, 03:38 PM

Lock & Unlock System By Secret word

bElBiLkS96I

Hamza FiGo

03-04-2016, 04:12 PM

Lock & Unlock System By Secret word

bElBiLkS96I

25 ثانية كمقدمة كتير ^^ دا اولا

ثانيا السيستم جميل وسهل علي ان الناس تفهمه . تسلم ايدك

بس انت موضحتش في الفيديو ازاي كل شخصية تعمل كلمة السر

HLP

03-04-2016, 05:09 PM

25 ثانية كمقدمة كتير ^^ دا اولا

ثانيا السيستم جميل وسهل علي ان الناس تفهمه . تسلم ايدك

بس انت موضحتش في الفيديو ازاي كل شخصية تعمل كلمة السر

حبيبي يا حمزة
اولا - المقدمة انا لسه شغال عليه علشان كدة هي طويلة شويه
ثانيا - انا شغال ب Secret Word و ممكن يشتغل ب Email كمان
ثالثا - انا حنزل السيستم كامل في موضوع قريب علشان Dangers SrO كان طلبه مني

Black Shield

03-04-2016, 06:01 PM

عاش يا رامي كنت ناوي اشتغل عليه
بس عاش اختصرت لي وقت كتير
مستنيين الموضوع

Dangers SrO

03-04-2016, 07:18 PM

حبيبي يا حمزة
اولا - المقدمة انا لسه شغال عليه علشان كدة هي طويلة شويه
ثانيا - انا شغال ب Secret Word و ممكن يشتغل ب Email كمان
ثالثا - انا حنزل السيستم كامل في موضوع قريب علشان Dangers SrO كان طلبه مني
شكرا يا رامي انا كنت شغال عليه
علشان انا قولت انك تنشتني بس شكرا اوي ومستنيك
:111:

HLP

03-04-2016, 08:10 PM

عاش يا رامي كنت ناوي اشتغل عليه
بس عاش اختصرت لي وقت كتير
مستنيين الموضوع

حبيبي يا كيبر

شكرا يا رامي انا كنت شغال عليه
علشان انا قولت انك تنشتني بس شكرا اوي ومستنيك
:111:

حبيبي انا عمري ما نسيت حد بس انا كونت مشغول شويه و انت كونت عارف او ما خلصت عملت السيستم
انشاء الله بكرة حنزله ب secret word و ب Email

Black Shield

03-04-2016, 10:57 PM

تمام و ان شاء الله لما اخلص من الي ورايا
هحاول اعمله من الويب سايت

mafiapate

15-01-2017, 04:20 PM

تسلم ايدك حمزه تمام بس ف حاجه انى لما اضربها بسفرنى عادى اجى ارمى الويبون بيترمى عادى