vSro Quest Rewardları (Zerk & Damage Scroll ve Diğer güçlü item rewardları) [QUERY]

DontAsk

Aktif Üye
Yönetici
#1
Merhaba değerli sroloji üyeleri/ziyaretçileri

Bugün sizlere açacağınız/açtığınız serverlarda başınıza bela olabilecek gözden kaçırabileceğiniz güçlü görev itemlarını paylaşacağım.

Item Codenameleri ve Güçlendirmeleri;
ITEM_QNO_EU_EASTEU_21_02 -- Damage inc Scroll %30
ITEM_QNO_CA_GORIA_6_03 -- Damage inc Scroll %20
ITEM_QNO_CH_GENARAL_1_01 -- Damage inc Scroll %20
ITEM_QNO_CH_SPECIAL_2_02 -- Damage inc Scroll %20
ITEM_QNO_WC_WAREHOUSE_W_2_04 -- Damage inc Scroll %20
ITEM_QNO_EU_EASTEU_6_02 -- Damage abs Scroll %20
ITEM_QNO_CH_LOTTERY_2_02 -- Attack & Parry rate %20
ITEM_QNO_RM_MEETROC_ECT_2_01 -- Attack & Parry rate %30
ITEM_QNO_WC_DOCTOR_2_02 -- Parry rate %20
ITEM_QNO_EU_WITCH_1_03 -- Parry rate %20
ITEM_QNO_RM_VILLAGECHIEF_2_01 -- Attack rate %20
ITEM_QNO_CA_TREASURE_5_03 -- Attack rate %20
ITEM_QNO_WC_ACCESSORY_3_03 -- Attack rate %20
ITEM_QNO_EU_EASTEU_8_02 -- Attack rate %20
ITEM_QNO_EU_CONS_12_02 -- HP Reincarnation rate %500
ITEM_QNO_CA_THIEF_5_02 -- HP Reincarnation rate %500
ITEM_QNO_EU_GENERAL_1_03 -- HP Reincarnation rate %500
ITEM_QNO_EU_EASTEU_17_1_02 -- MP Reincarnation rate %500
ITEM_QNO_RM_OLDWOMAN_7_02 -- MaxHP&MP Increase %20
ITEM_QNO_CA_GORIA_7_04 -- Max HP & MP 500 Increase
ITEM_QNO_EU_FERRY2_1_02 -- Max HP 300 Increase
ITEM_QNO_EU_FERRY2_1_03 -- Max MP 300 Increase
ITEM_QNO_TQ_BAEKRYEONG_16_01 -- Instant recovery potion %100
ITEM_QNO_RM_MEETROC_ECT_1_01 -- Instant recovery potion %100
ITEM_QNO_TQ_STONEBOARD_5_02 -- Gender Switcher up to 9d
ITEM_QNO_RM_FLYSHIP2_2_03 -- Gender Switcher up to 9d
ITEM_QNO_EU_EASTEU_14_1_01 -- Gender Switcher no limit
ITEM_QNO_RM_FLYSHIP2_2_02 -- Instant Berserk
ITEM_QNO_EU_IVY_3_07 -- Instant Berserk
ITEM_QNO_RM_SLAVE2_2_01 -- Resurrection Scroll
ITEM_QNO_TQ_ORNAMENT_4_03 -- Resurrection Scroll
ITEM_QNO_WC_POTION_4_01 -- Resurrection Scroll
ITEM_QNO_RM_MEETROC_ECT_3_01 -- Resurrection Scroll
ITEM_QNO_RM_OLDWOMAN_2_02 -- Skill restore potion
ITEM_QNO_EU_EASTEU_5_02 -- Str 5
ITEM_QNO_EU_EASTEU_5_03 -- Int 5
ITEM_ETC_ARCHEMY_MAGICSTONE_SHARP_10 -- Special Stone
ITEM_ETC_ARCHEMY_MAGICSTONE_IRONWALL_10 -- Special Stone
ITEM_ETC_ARCHEMY_MAGICSTONE_GUARD_10 -- Special Stone
ITEM_ETC_ARCHEMY_MAGICSTONE_DEVIL_10 -- Special Stone
ITEM_ETC_ARCHEMY_MAGICSTONE_ABYSS_10 -- Special Stone
ITEM_ETC_ARCHEMY_MAGICSTONE_HEAT_10 -- Special Stone
ITEM_ETC_ARCHEMY_MAGICSTONE_STUPOR_10 -- Special Stone
ITEM_ETC_ARCHEMY_MAGICSTONE_STRONGMIND_10 -- Special Stone

Hepsini toplu şekilde kapatmak isteyenler için query;
SQL:
update _RefQuestRewardItems set Service = 0 where ItemCodeName in ('ITEM_QNO_EU_EASTEU_21_02','ITEM_QNO_CA_GORIA_6_03',
'ITEM_QNO_CH_GENARAL_1_01','ITEM_QNO_CH_SPECIAL_2_02','ITEM_QNO_WC_WAREHOUSE_W_2_04','ITEM_QNO_EU_EASTEU_6_02',
'ITEM_QNO_CH_LOTTERY_2_02','ITEM_QNO_RM_MEETROC_ECT_2_01','ITEM_QNO_WC_DOCTOR_2_02','ITEM_QNO_EU_WITCH_1_03',
'ITEM_QNO_RM_VILLAGECHIEF_2_01','ITEM_QNO_CA_TREASURE_5_03','ITEM_QNO_WC_ACCESSORY_3_03','ITEM_QNO_EU_EASTEU_8_02',
'ITEM_QNO_EU_CONS_12_02','ITEM_QNO_CA_THIEF_5_02','ITEM_QNO_EU_GENERAL_1_03','ITEM_QNO_EU_EASTEU_17_1_02',
'ITEM_QNO_RM_OLDWOMAN_7_02','ITEM_QNO_CA_GORIA_7_04','ITEM_QNO_EU_FERRY2_1_02','ITEM_QNO_EU_FERRY2_1_03',
'ITEM_QNO_TQ_BAEKRYEONG_16_01','ITEM_QNO_RM_MEETROC_ECT_1_01','ITEM_QNO_TQ_STONEBOARD_5_02','ITEM_QNO_RM_FLYSHIP2_2_03',
'ITEM_QNO_EU_EASTEU_14_1_01','ITEM_QNO_RM_FLYSHIP2_2_02','ITEM_QNO_EU_IVY_3_07','ITEM_QNO_RM_SLAVE2_2_01','ITEM_QNO_TQ_ORNAMENT_4_03',
'ITEM_QNO_WC_POTION_4_01','ITEM_QNO_RM_MEETROC_ECT_3_01','ITEM_QNO_RM_OLDWOMAN_2_02','ITEM_QNO_EU_EASTEU_5_02','ITEM_QNO_EU_EASTEU_5_03',
'ITEM_ETC_ARCHEMY_MAGICSTONE_SHARP_10','ITEM_ETC_ARCHEMY_MAGICSTONE_IRONWALL_10','ITEM_ETC_ARCHEMY_MAGICSTONE_GUARD_10','ITEM_ETC_ARCHEMY_MAGICSTONE_DEVIL_10',
'ITEM_ETC_ARCHEMY_MAGICSTONE_ABYSS_10','ITEM_ETC_ARCHEMY_MAGICSTONE_HEAT_10','ITEM_ETC_ARCHEMY_MAGICSTONE_STUPOR_10','ITEM_ETC_ARCHEMY_MAGICSTONE_STRONGMIND_10')