NPCDEKİ 10 DG İTEMLERİ FULL BLUEE YAPMAK QUERY
[HIDE]USE SRO_VT_SHARD
UPDATE _RefScrapOfPackageItem SET --Weapon
OptLevel= 5,
Variance= 1073741823,
MagParamNum= 5,
MagParam1= 25769803847,
MagParam2= 25769803853,
MagParam3= 687194767449,
MagParam4= 429496729713,
MagParam5= 257698037861
WHERE Service=1 AND
(
RefPackageItemCodeName LIKE 'PACKAGE_ITEM_CH_BOW%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_CH_SPEAR%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_CH_SWORD%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_CH_BLADE%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_CH_TBLADE%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_CH_BOW%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_CH_SPEAR%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_CH_SWORD%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_CH_BLADE%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_CH_TBLADE%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_EU_SWORD%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_EU_TSWORD%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_EU_AXE%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_EU_DAGGER%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_EU_CROSSBOW%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_EU_TSTAFF%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_EU_DARKSTAFF%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_EU_HARP%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_EU_STAFF%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_EU_SWORD%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_EU_TSWORD%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_EU_AXE%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_EU_DAGGER%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_EU_CROSSBOW%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_EU_TSTAFF%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_EU_DARKSTAFF%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_EU_HARP%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_EU_STAFF%_A'
)
UPDATE _RefScrapOfPackageItem SET --Protector [Head,Chest,Legs]
OptLevel= 5,
Variance= 1073741823,
MagParamNum= 6,
MagParam1= 25769803847,
MagParam2= 25769803853,
MagParam3= 687194767449,
MagParam4= 257698037897,
MagParam5= 3650722201749,
MagParam6= 3650722201761
WHERE Service=1 AND
(
RefPackageItemCodeName LIKE 'PACKAGE_ITEM_CH_%CA_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_CH_%BA_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_CH_%LA_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_EU_%HA_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_EU_%BA_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_EU_%LA_A'
)
UPDATE _RefScrapOfPackageItem SET --Protector [Shoulder,Hands,Foot]
OptLevel= 5,
Variance= 1073741823,
MagParamNum= 4,
MagParam1= 25769803847,
MagParam2= 25769803853,
MagParam3= 687194767449,
MagParam4= 257698037897
WHERE Service=1 AND
(
RefPackageItemCodeName LIKE 'PACKAGE_ITEM_CH_%SA_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_CH_%AA_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_CH_%FA_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_EU_%SA_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_EU_%AA_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_EU_%FA_A'
)
UPDATE _RefScrapOfPackageItem SET --Accessory
OptLevel= 5,
Variance= 1023,
MagParamNum= 7,
MagParam1= 25769803847,
MagParam2= 25769803853,
MagParam3= 85899346099,
MagParam4= 85899346093,
MagParam5= 85899346087,
MagParam6= 85899346105,
MagParam7= 85899346111
WHERE Service=1 AND
(
RefPackageItemCodeName LIKE 'PACKAGE_%ITEM_CH_RING_%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_%ITEM_EU_RING_%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_%ITEM_CH_NECKLACE_%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_%ITEM_EU_NECKLACE_%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_%ITEM_CH_EARRING_%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_%ITEM_EU_EARRING_%_A'
)
UPDATE _RefScrapOfPackageItem SET --Shield
OptLevel= 5,
Variance= 1072726015,
MagParamNum= 4,
MagParam1= 25769803847,
MagParam2= 25769803853,
MagParam3= 687194767449,
MagParam4= 429496729725
WHERE Service=1 AND
(
RefPackageItemCodeName LIKE 'PACKAGE_ITEM_CH_SHIELD_%_A'
OR RefPackageItemCodeName LIKE 'PACKAGE_ITEM_EU_SHIELD_%_A'
)
[/HIDE]
