| قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة [ قسم متخصص فى شروحات و البرامج في عمل السيرفرات الخاصة ] [ يرجى عدم وضع الأسئلة والاستفسارات في هذا القسم ] |
 |
|
|
أدوات الموضوع | انواع عرض الموضوع |
03-11-2015, 09:05 AM
|
#1 | ||||||||||
  
|
Lock / Unlock Scroll سلام عليكم. في بعض الناس سالوني علي السيستم دا السيستم ببساطة بيقفل الايتم مش بيخليها تتنقل ومتطلعش برة الشخصية منعا للهاك 1- Create this table: كود:
Use [SRO_VT_SHARDLOG] Create Table [dbo].[LockItemsID] ([LockItemID] [Int] NOT NULL PRIMARY KEY , [ReqItemID] [Int] NOT NULL) خد كوبي من السطور الاصلية بتاع الايتم او الاسلحة وغير الاي دي هات والاسامي مهم: في السطور الجديدة لازم تراعي انك تعمل الحاجات دي صفر Can trade-Can Drop-Can Borrow-Can Sell = 0 Example: ** The original 15D weapon: كود:
1 40315 ITEM_EU_DAGGER_15_A_RARE 15? ?? (??) xxx SN_ITEM_EU_DAGGER_15_A_RARE SN_ITEM_EU_DAGGER_15_A_RARE_TT_DESC 0 0 3 1 6 13 180000 1 2 1 1 1 255 3 1 1 1 0 0 19748000 14667 22000 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\dagger_91.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\dagger_15.ddj xxx xxx 1 2 0 0 43 0 157 236 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 3 5836 6154 7132 7521 179.1 0 0 0 0 0 6487 7162 7928 8753 0 0 0 0 142 303 0 4 25 1 ITEM_EU_DAGGER_15_A_RARE 1 ITEM_EU_DAGGER_15_B_RARE 1 ITEM_EU_DAGGER_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 1 40336 ITEM_EU_SWORD_15_A_RARE 15? ??? (??) xxx SN_ITEM_EU_SWORD_15_A_RARE SN_ITEM_EU_SWORD_15_A_RARE_TT_DESC 0 0 3 1 6 7 180000 1 2 1 1 1 255 3 1 1 1 0 0 17773000 10353 15530 0 9000 6220550 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\sword_91.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\sword_15.ddj xxx xxx 1 2 0 0 43 0 111 167 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 5836 6154 7132 7521 179.1 0 0 0 0 0 6487 7162 7928 8753 0 0 0 0 142 303 0 2 15 1 ITEM_EU_SWORD_15_A_RARE 1 ITEM_EU_SWORD_15_B_RARE 1 ITEM_EU_SWORD_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 1 40357 ITEM_EU_TSWORD_15_A_RARE 15? ??? (??) xxx SN_ITEM_EU_TSWORD_15_A_RARE SN_ITEM_EU_TSWORD_15_A_RARE_TT_DESC 0 0 3 1 6 8 180000 1 2 1 1 1 255 3 1 1 1 0 0 19748000 8628 12941 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\tsword_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\tsword_15.ddj xxx xxx 1 2 0 0 43 0 93 139 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 18 5836 6154 7132 7521 179.1 0 0 0 0 0 6487 7162 7928 8753 0 0 0 0 142 303 0 2 15 1 ITEM_EU_TSWORD_15_A_RARE 1 ITEM_EU_TSWORD_15_B_RARE 1 ITEM_EU_TSWORD_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 1 40378 ITEM_EU_AXE_15_A_RARE 15? ???? (??) xxx SN_ITEM_EU_AXE_15_A_RARE SN_ITEM_EU_AXE_15_A_RARE_TT_DESC 0 0 3 1 6 9 180000 1 2 1 1 1 255 3 1 1 1 0 0 19748000 14667 22000 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\axe_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\axe_15.ddj xxx xxx 1 2 0 0 43 0 157 236 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 6 5836 6154 7132 7521 179.1 0 0 0 0 0 6487 7162 7928 8753 0 0 0 0 142 303 0 2 15 1 ITEM_EU_AXE_15_A_RARE 1 ITEM_EU_AXE_15_B_RARE 1 ITEM_EU_AXE_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 1 40399 ITEM_EU_CROSSBOW_15_A_RARE 15? ????? (??) xxx SN_ITEM_EU_CROSSBOW_15_A_RARE SN_ITEM_EU_CROSSBOW_15_A_RARE_TT_DESC 0 0 3 1 6 12 180000 1 2 1 1 1 255 3 1 1 1 0 0 19748000 10353 15530 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\crossbow_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\crossbow_15.ddj xxx xxx 1 2 0 0 43 0 111 167 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 180 5836 6154 7132 7521 179.1 0 0 0 0 0 6487 7162 7928 8753 0 0 0 0 142 303 0 4 20 1 ITEM_EU_CROSSBOW_15_A_RARE 1 ITEM_EU_CROSSBOW_15_B_RARE 1 ITEM_EU_CROSSBOW_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 1 40420 ITEM_EU_DARKSTAFF_15_A_RARE 15? ???? (??) xxx SN_ITEM_EU_DARKSTAFF_15_A_RARE SN_ITEM_EU_DARKSTAFF_15_A_RARE_TT_DESC 0 0 3 1 6 10 180000 1 2 1 1 1 255 3 1 1 1 0 0 17773000 8628 12941 0 9000 6220550 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\darkstaff_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\darkstaff_15.ddj xxx xxx 1 2 0 0 43 0 185 278 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 0 0 0 0 0 9337 9846 11412 12034 286.5 0 0 0 0 10378 11459 12685 14005 142 303 0 2 2 1 ITEM_EU_DARKSTAFF_15_A_RARE 1 ITEM_EU_DARKSTAFF_15_B_RARE 1 ITEM_EU_DARKSTAFF_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 1 40441 ITEM_EU_TSTAFF_15_A_RARE 15? ??? (??) xxx SN_ITEM_EU_TSTAFF_15_A_RARE SN_ITEM_EU_TSTAFF_15_A_RARE_TT_DESC 0 0 3 1 6 11 180000 1 2 1 1 1 255 3 1 1 1 0 0 19748000 8628 12941 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\tstaff_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\tstaff_15.ddj xxx xxx 1 2 0 0 43 0 93 139 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 6 0 0 0 0 0 9337 9846 11412 12034 286.5 0 0 0 0 10378 11459 12685 14005 142 303 0 2 2 1 ITEM_EU_TSTAFF_15_A_RARE 1 ITEM_EU_TSTAFF_15_B_RARE 1 ITEM_EU_TSTAFF_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 1 40462 ITEM_EU_HARP_15_A_RARE 15? ?? (??) xxx SN_ITEM_EU_HARP_15_A_RARE SN_ITEM_EU_HARP_15_A_RARE_TT_DESC 0 0 3 1 6 14 180000 1 2 1 1 1 255 3 1 1 1 0 0 19748000 7765 11647 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\harp_12.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\harp_15.ddj xxx xxx 1 2 0 0 43 0 83 125 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 6 0 0 0 0 0 9337 9846 11412 12034 286.5 0 0 0 0 10378 11459 12685 14005 142 303 0 2 2 1 ITEM_EU_HARP_15_A_RARE 1 ITEM_EU_HARP_15_B_RARE 1 ITEM_EU_HARP_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 1 40483 ITEM_EU_STAFF_15_A_RARE 15? ??? ?? (??) xxx SN_ITEM_EU_STAFF_15_A_RARE SN_ITEM_EU_STAFF_15_A_RARE_TT_DESC 0 0 3 1 6 15 180000 1 2 1 1 1 255 3 1 1 1 0 0 19748000 8628 12941 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\weapon\staff_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\weapon\staff_15.ddj xxx xxx 1 2 0 0 43 0 93 139 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 0 0 0 0 0 9337 9846 11412 12034 286.5 0 0 0 0 10378 11459 12685 14005 142 303 0 2 2 1 ITEM_EU_STAFF_15_A_RARE 1 ITEM_EU_STAFF_15_B_RARE 1 ITEM_EU_STAFF_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 1 40504 ITEM_EU_SHIELD_15_A_RARE 15? ?? ?? (??) xxx SN_ITEM_EU_SHIELD_15_A_RARE SN_ITEM_EU_SHIELD_15_A_RARE_TT_DESC 0 0 3 1 4 2 180000 1 2 1 1 1 255 3 1 1 1 0 0 9874000 9059 13588 0 9000 3455900 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\europe\shield\shield_20.bsr item\etc\drop_eu_equip_rare.bsr item\europe\shield\shield_15.ddj xxx xxx 1 2 0 0 43 0 97 146 648.4 683.8 17.9 0 0 0 0 0 0 14 23 1037.4 1094 28.6 0 0 0 721 796 1153 1273 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 ITEM_EU_SHIELD_15_A_RARE 1 ITEM_EU_SHIELD_15_B_RARE 1 ITEM_EU_SHIELD_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_SH_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 ?? ??? ?? ?? ? 9 0 1 39370 ITEM_CH_SWORD_15_A_RARE 15? ? (??) xxx SN_ITEM_CH_SWORD_15_A_RARE SN_ITEM_CH_SWORD_15_A_RARE_TT_DESC 0 0 3 1 6 2 180000 0 2 1 1 1 255 3 1 1 1 0 0 17773000 12294 18441 0 9000 6220550 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\weapon\sword_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\sword_15.ddj xxx xxx 1 2 0 0 43 0 148 181 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 4349 4586 4902 5169 127.7 7400 7804 8507 8971 219.6 4930 5130 5558 5782 8390 8729 9645 10035 142 303 0 4 16 1 ITEM_CH_SWORD_15_A_RARE 1 ITEM_CH_SWORD_15_B_RARE 1 ITEM_CH_SWORD_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 1 39391 ITEM_CH_BLADE_15_A_RARE 15? ? (??) xxx SN_ITEM_CH_BLADE_15_A_RARE SN_ITEM_CH_BLADE_15_A_RARE_TT_DESC 0 0 3 1 6 3 180000 0 2 1 1 1 255 3 1 1 1 0 0 17773000 13588 20382 0 9000 6220550 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\weapon\blade_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\blade_15.ddj xxx xxx 1 2 0 0 43 0 164 200 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 6 4625 4878 5317 5607 137.3 6958 7337 7843 8271 204.4 5244 5456 6028 6272 7889 8207 8892 9251 142 303 0 3 15 1 ITEM_CH_BLADE_15_A_RARE 1 ITEM_CH_BLADE_15_B_RARE 1 ITEM_CH_BLADE_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 1 39412 ITEM_CH_SPEAR_15_A_RARE 15? ? (??) xxx SN_ITEM_CH_SPEAR_15_A_RARE SN_ITEM_CH_SPEAR_15_A_RARE_TT_DESC 0 0 3 1 6 4 180000 0 2 1 1 1 255 3 1 1 1 0 0 19748000 8196 12294 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\weapon\spear_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\spear_15.ddj xxx xxx 1 2 0 0 43 0 99 121 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 18 4539 4786 5403 5698 137.3 7781 8205 9510 10029 238.8 5146 5354 6126 6374 8822 9178 10782 11218 142 303 0 5 17 1 ITEM_CH_SPEAR_15_A_RARE 1 ITEM_CH_SPEAR_15_B_RARE 1 ITEM_CH_SPEAR_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 1 39433 ITEM_CH_TBLADE_15_A_RARE 15? ?? (??) xxx SN_ITEM_CH_TBLADE_15_A_RARE SN_ITEM_CH_TBLADE_15_A_RARE_TT_DESC 0 0 3 1 6 5 180000 0 2 1 1 1 255 3 1 1 1 0 0 19748000 9059 13588 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\weapon\tblade_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\tblade_15.ddj xxx xxx 1 2 0 0 43 0 109 134 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 1 18 4863 5128 5944 6268 149.2 7262 7658 8645 9117 219.6 5514 5736 6739 7011 8234 8566 9802 10198 142 303 0 4 16 1 ITEM_CH_TBLADE_15_A_RARE 1 ITEM_CH_TBLADE_15_B_RARE 1 ITEM_CH_TBLADE_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 1 39454 ITEM_CH_BOW_15_A_RARE 15? ? (??) xxx SN_ITEM_CH_BOW_15_A_RARE SN_ITEM_CH_BOW_15_A_RARE_TT_DESC 0 0 3 1 6 6 180000 0 2 1 1 1 255 3 1 1 1 0 0 19748000 9318 13977 0 9000 6911800 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\weapon\bow_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\weapon\bow_15.ddj xxx xxx 1 2 0 0 43 0 112 137 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 2 1 180 4399 4639 5391 5686 135.2 7039 7423 8626 9097 216.3 4988 5189 6113 6360 7981 8303 9780 10175 142 303 0 4 14 1 ITEM_CH_BOW_15_A_RARE 1 ITEM_CH_BOW_15_B_RARE 1 ITEM_CH_BOW_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_WE_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 3 ?? ??? ?? ?? ? 9 0 1 39475 ITEM_CH_SHIELD_15_A_RARE 15? ?? (??) xxx SN_ITEM_CH_SHIELD_15_A_RARE SN_ITEM_CH_SHIELD_15_A_RARE_TT_DESC 0 0 3 1 4 1 180000 0 2 1 1 1 255 3 1 1 1 0 0 9874000 9059 13588 0 9000 3455900 1 101 -1 0 -1 0 -1 0 -1 0 0 0 0 0 0 0 100 0 0 0 item\china\shield\shield_20.bsr item\etc\drop_ch_equip_rare.bsr item\china\shield\shield_15.ddj xxx xxx 1 2 0 0 43 0 109 134 648.4 683.8 17.9 0 0 0 0 0 0 14 23 1037.4 1094 28.6 0 0 0 735 765 1235 1285 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 ITEM_CH_SHIELD_15_A_RARE 1 ITEM_CH_SHIELD_15_B_RARE 1 ITEM_CH_SHIELD_15_C_RARE 1 ITEM_ETC_ARCHEMY_ENHANCER_SH_13_S -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx -1 xxx 0 ?? ??? ?? ?? ? 9 0 كود:
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
كود:
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 كود:
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 كود:
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 كود:
1 SN_ITEM_CHAOS_LOCK Lock Scroll 1 SN_ITEM_CHAOS_LOCK_TT_DESC <sml2>This scroll will LOCK your items to avoid to be scammed. <br><br><font color="255,255,255,0">How to use:</font><br>-Put ur item at the first slot in ur inventory (LEFT)<br>- Use the scroll. Regards from [GM] Figoz</sml2> 1 SN_ITEM_CHAOS_UNLOCK UNLock Scroll 1 SN_ITEM_CHAOS_UNLOCK_TT_DESC <sml2>This scroll will unlock your items, so u can trade/sell it.<br><br><font color="255,255,255,0">How to use:</font><br>-Put ur item at the first slot in ur inventory (LEFT)<br>- Use the scroll. Regards from [GM] Figoz</sml2>  وبخصوص البلاص تم عمل الصح ^^ من برنامج Zealous كدة زي isro بالظبط. لو الاكونت بتاعك مع السيرفر كله متخافش علية [YOUTUBE]4vhDJxMHplw[/YOUTUBE] Regards |
||||||||||
|
التعديل الأخير تم بواسطة Hamza FiGo ; 05-11-2015 الساعة 05:31 PM
|
| إعلانات google |
|
|
|
03-11-2015, 01:43 PM
|
#2 | ||||||||||
  
|
جميل يا باشا بس فين باقي الحاجات زي itemdata4500 . refskill . refibjitem .refobjcommon |
||||||||||
|
|
|
03-11-2015, 01:51 PM
|
#3 | |||||||||||
|
اقتباس:
متعرفش تعمل سكرول ياباشا عادية؟ علي العموم ضيفتها فوق Edit تمت اضافة الاسكرول لتجميعة سكرولات 2015 |
|||||||||||
|
التعديل الأخير تم بواسطة Hamza FiGo ; 03-11-2015 الساعة 01:56 PM
|
|
03-11-2015, 03:44 PM
|
#4 | ||||||||||
|
تمام يا باشا شكرا |
||||||||||
|
|
|
03-11-2015, 04:15 PM
|
#5 | ||||||||||
  
|
كلام جميل اوي تسلم بس في حاجه كدا انا مثلا عامل السلاح مقفول ما ممكن حد يجيب اسكرول البتفتاحو ويخد السلاح ؟ |
||||||||||
|
|
|
03-11-2015, 08:29 PM
|
#6 | ||||||||||
|
سوال مهم |
||||||||||
|
|
|
03-11-2015, 11:06 PM
|
#7 | |||||||||||
|
اقتباس:
طبعا انا مفهم الناس كلها علي نظام الاسكرول ان صاحب الاكونت نفسه يكلمني علي الفيس علشان اعرف كل واحد واكونته لافة شوية بس ضمان للناس |
|||||||||||
|
|
|
04-11-2015, 12:44 AM
|
#8 | ||||||||||
  
|
الله ينور فعلا انا كنت عايز السكرول ديه :v و جار التجربه ........... |
||||||||||
|
|
|
04-11-2015, 12:50 AM
|
#9 | ||||||||||
|
بس عندي استفسار هنعمل سطور جديده في ال Refobjjcommon بس ؟ و الTable هنعدل فيها حاجه ؟ |
||||||||||
|
التعديل الأخير تم بواسطة Xan ; 04-11-2015 الساعة 01:15 AM
|
|
04-11-2015, 01:21 AM
|
#10 | |||||||||||
|
اقتباس:
داتا وميديا ياباشا كانك بتعمل اسلحة جديدة. والتابل هتضيف فية ID كل الاسلحة اللي مقفول واللي مفتوح علشان لما تضرب الاسكرول يقرا هنا ويروح هنا وهكذا |
|||||||||||
|
|
|
04-11-2015, 03:27 PM
|
#11 | ||||||||||
|
كلام جميل اوي بس انا عندي فكره مينفعش نعمل الاسكرول بي بسورد :D بمعني ان اسكرول ال Lock لما تيجي تعملها علي السلاح تطلب منك بسورد و لما تحب تفكو علشان تبيعو اسكرول ال unLock تطلب بسورد اللي انتا عملتو بسكرول الLock ^^ كدا هتبقي احسن من حوار الفيس دا ^^ |
||||||||||
|
|
|
04-11-2015, 03:30 PM
|
#12 | |||||||||||
|
اقتباس:
موضوع الباس ورد مش سهل كل واحد بقا يفكر ويبتكر . احنا بنعمل اللي علينا ^^ |
|||||||||||
|
|
|
04-11-2015, 04:07 PM
|
#13 | |||||||||||
 
|
اقتباس:
|
|||||||||||
|
|
|
05-11-2015, 12:47 AM
|
#14 | |||||||||||
|
اقتباس:
جالك رامي بنفسه اهو ^^ ماهو فية طريقة احسن صديق ليا قال عليها. انها ممكن تكون PM لشخصية GM مثلا يبعت رسالة للكاركتر يجيلة الباس العشوائي. ولما يجي يفتح يبعتله الباس دا يتفك الايتم |
|||||||||||
|
|
|
05-11-2015, 07:03 AM
|
#15 | ||||||||||
 
|
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] |
||||||||||
|
|
|
| يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر) | |
|
|
المواضيع المتشابهه
|
||||
| الموضوع | كاتب الموضوع | المنتدى | الردود | آخر مشاركة |
| LOCK & Unlock System By Massage With Secret Word By HLP | HLP | قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة | 29 | 22-07-2016 04:42 AM |
| مشكله في Lock/Unlok Scroll | Spicoo | قسم المواضيع المكررة و المخالفة | 7 | 25-05-2016 01:06 AM |
| مشكله في Lock/UnLock Scroll | Spicoo | قسم المواضيع المكررة و المخالفة | 0 | 20-05-2016 02:38 PM |
| lock / unlock | ekleess | قـسـم الاسـئـلـه و الاسـتـفـسـارات حـول الـلـعـبـة | 5 | 02-01-2013 09:51 PM |
.gif){kind=icon}
.gif){kind=icon}
العرض العادي
