Welcome To Silkroad4Ever
اهلا وسهلا بك زائرنا الكريم



اطلب تصميمك $ شعار$ بنرات اعلانية $ تصميم احترفية $فقط من Silkroad4Ever

بنر متحركه +اعلان في المنتدي =50جنية

الان أفـضـل و أرخـص عـروض الـ VPS و السيرفـرات فـقـط مـن Silkroad4Ever

register سجل في المنتدي الان




الموقع العربي الاول العاب Online
 
الرئيسيةس .و .جالأعضاءالمجموعاتالتسجيلفيس بوكدخول


شاطر | 
 

  Lock / Unlock Scroll

استعرض الموضوع السابق استعرض الموضوع التالي اذهب الى الأسفل 
كاتب الموضوعرسالة
MrCheToS
نائب عام
نائب عام
avatar

عدد المساهمات : 19
السٌّمعَة : 3
تاريخ التسجيل : 29/12/2015

مُساهمةموضوع: Lock / Unlock Scroll   الخميس يناير 14, 2016 12:20 pm


سلام عليكم. في بعض الناس سالوني علي السيستم دا
السيستم ببساطة بيقفل الايتم مش بيخليها تتنقل ومتطلعش برة الشخصية منعا للهاك
1- Create this table:
الكود:
Use [SRO_VT_SHARDLOG]
Create Table [dbo].[LockItemsID]
([LockItemID] [Int] NOT NULL PRIMARY KEY ,
[ReqItemID] [Int] NOT NULL)
- اعمل سطور جديدة للاسلحة او الايتم.

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

مهم:

في السطور الجديدة لازم تراعي انك تعمل الحاجات دي صفر
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_DES
الكود:
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

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

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        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      
1 SN_ITEM_CHAOS_UNLOCK        UNLock Scroll      
1 SN_ITEM_CHAOS_UNLOCK_TT_DESC        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] CheToS

الرجوع الى أعلى الصفحة اذهب الى الأسفل
معاينة صفحة البيانات الشخصي للعضو http://oversro.ddns.net/
 
Lock / Unlock Scroll
استعرض الموضوع السابق استعرض الموضوع التالي الرجوع الى أعلى الصفحة 
صفحة 1 من اصل 1
 مواضيع مماثلة
-
» قاموس إختصارات الكيبورد Keyboard Shortcuts

صلاحيات هذا المنتدى:لاتستطيع الرد على المواضيع في هذا المنتدى
Welcome To Silkroad4Ever :: منتدى عمل السيرفرات الخاصة :: قسم تطوير السيرفرات الخاصه-
انتقل الى: