vSro Item Kilitleme Scrollu Yapımı

vSro serverlarının bir çoğunda yapılan Item Kilitleme scroll'u.

Tablo'yu oluşturun ;

Kod:

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

Kilitlemek istediğiniz itemler için yeni satır oluşturun.

Satırları kopyalayın ve ismini değiştirin.

Önemli :

"Can traded Can Drop Can Borrow" satırlarını "0" olarak ayarlamanız gerekiyor.

Örnek :

Varsayılan 15 D Item

Kod:

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

Ayarlanmış 15D Item

Kod:

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[/CENTER] 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

LOG DB'de ki AddLogItem'e ekleyin.

Kod:

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

Sonra bunu oluşturun ;

Kod:

USE [SRO_VT_SHARDLOG] GO /****** Object: StoredProcedure [dbo].[_HamzaLockSystemD15] Script Date: 11/1/2015 10:25:15 PM ******/ 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

Kod:

USE [SRO_VT_SHARDLOG] GO /****** Object: StoredProcedure [dbo].[_HamzaLockSystemD15Unlock] Script Date: 11/2/2015 5:46:40 PM ******/ 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

Reactions: kkyykk

vSro Item Kilitleme Scrollu Yapımı

Chorus - Daha fazla dosya

Bu dosyayı paylaş

Son incelemeler