joysro

game12
Resource icon

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  ,    [email protected] Chinese Sword
   @Old_CH_BLADE_ID Int  = 39391    , @New_CH_BLADE_ID Int  = 80391  ,    [email protected] Blade
   @Old_CH_SPEAR_ID Int  = 39412    , @New_CH_SPEAR_ID Int  = 80412  ,    [email protected] Spear
   @Old_CH_TBLADE_ID Int = 39433    , @New_CH_TBLADE_ID Int = 80433  ,    [email protected] Glaive
   @Old_CH_BOW_ID Int    = 39454    , @New_CH_BOW_ID Int    = 80454  ,    [email protected] Bow
   @Old_CH_SHIELD_ID Int = 39475    , @New_CH_SHIELD_ID Int = 80475  ,    [email protected] Shield
   @Old_EU_DAGGER_ID Int = 40315    , @New_EU_DAGGER_ID Int = 80315  ,    [email protected] Dagger
   @Old_EU_XBOW_ID Int   = 40399    , @New_EU_XBOW_ID Int   = 80399  ,    [email protected] CrossBow
   @Old_EU_AXE_ID Int    = 40378    , @New_EU_AXE_ID Int    = 80378  ,    [email protected] Axe
   @Old_EU_SWORD_ID Int  = 40336    , @New_EU_SWORD_ID Int  = 80336  ,    [email protected] One Hand Sword
   @Old_EU_TSWORD_ID Int = 40357    , @New_EU_TSWORD_ID Int = 80357  ,    [email protected] Two Hand Sword
   @Old_EU_TSTAFF_ID Int = 40441    , @New_EU_TSTAFF_ID Int = 80441  ,    [email protected] Two Hand Staff
   @Old_EU_STAFF_ID Int  = 40483    , @New_EU_STAFF_ID Int  = 80483  ,    [email protected] Claric Rod
   @Old_EU_DSTAFF_ID Int = 40420    , @New_EU_DSTAFF_ID Int = 80420  ,    [email protected] Warlock Rod
   @Old_EU_HARP_ID Int   = 40462    , @New_EU_HARP_ID Int   = 80462  ,    [email protected] Harp
   @Old_EU_SHIELD_ID Int = 40504    , @New_EU_SHIELD_ID Int = 80504  [email protected] 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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    -- 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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected] 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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    -- 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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected] 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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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  ,    [email protected] Chinese Sword
   @Old_CH_BLADE_ID Int  = 80391    , @New_CH_BLADE_ID Int  = 39391  ,    [email protected] Blade
   @Old_CH_SPEAR_ID Int  = 80412    , @New_CH_SPEAR_ID Int  = 39412  ,    [email protected] Spear
   @Old_CH_TBLADE_ID Int = 80433    , @New_CH_TBLADE_ID Int = 39433  ,    [email protected] Glaive
   @Old_CH_BOW_ID Int    = 80454    , @New_CH_BOW_ID Int    = 39454  ,    [email protected] Bow
   @Old_CH_SHIELD_ID Int = 80475    , @New_CH_SHIELD_ID Int = 39475  ,    [email protected] Shield
   @Old_EU_DAGGER_ID Int = 80315    , @New_EU_DAGGER_ID Int = 40315  ,    [email protected] Dagger
   @Old_EU_XBOW_ID Int   = 80399    , @New_EU_XBOW_ID Int   = 40399  ,    [email protected] CrossBow
   @Old_EU_AXE_ID Int    = 80378    , @New_EU_AXE_ID Int    = 40378  ,    [email protected] Axe
   @Old_EU_SWORD_ID Int  = 80336    , @New_EU_SWORD_ID Int  = 40336  ,    [email protected] One Hand Sword
   @Old_EU_TSWORD_ID Int = 80357    , @New_EU_TSWORD_ID Int = 40357  ,    [email protected] Two Hand Sword
   @Old_EU_TSTAFF_ID Int = 80441    , @New_EU_TSTAFF_ID Int = 40441  ,    [email protected] Two Hand Staff
   @Old_EU_STAFF_ID Int  = 80483    , @New_EU_STAFF_ID Int  = 40483  ,    [email protected] Claric Rod
   @Old_EU_DSTAFF_ID Int = 80420    , @New_EU_DSTAFF_ID Int = 40420  ,    [email protected] Warlock Rod
   @Old_EU_HARP_ID Int   = 80462    , @New_EU_HARP_ID Int   = 40462  ,    [email protected] Harp
   @Old_EU_SHIELD_ID Int = 80504    , @New_EU_SHIELD_ID Int = 40504  [email protected] 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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    -- 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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected] 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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    -- 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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected] 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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    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)    [email protected]
    End
   End
  • Beğen
Reactions: kkyykk
Yazar
Chorus
Okunma
222
İlk yayımlanma
Son güncellenen
Değer
5,00 yıldız 2 ratings

Chorus - Daha fazla dosya

Son incelemeler

Mukemmel Derecede
iyi.
Yukarı Alt