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

 Lock / Unlock Scroll (6)

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

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

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

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


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

 Lock / Unlock Scroll (6)

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

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

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

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


Welcome To Silkroad4Ever
هل تريد التفاعل مع هذه المساهمة؟ كل ما عليك هو إنشاء حساب جديد ببضع خطوات أو تسجيل الدخول للمتابعة.
Welcome To Silkroad4Ever

الموقع العربي الاول العاب Online
 
الرئيسيةالرئيسية  أحدث الصورأحدث الصور  التسجيلالتسجيل  FaceBooK(فيسبوك)FaceBooK(فيسبوك)  للـشكاوي  دخولدخول  

 

  Lock / Unlock Scroll

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


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

 Lock / Unlock Scroll Empty
مُساهمةموضوع: Lock / Unlock Scroll    Lock / Unlock Scroll Emptyالخميس يناير 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

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