ahmedbadrbedo
15-03-2017, 08:58 PM
محتاج الParams لل d13
علشان اخليها d13 full blue at npc ?!
Mahmoud Rashwan
15-03-2017, 09:18 PM
اتفضل
UPDATE [_RefScrapOfPackageItem] SET Variance = 450278829, MagParamNum = 2, MagParam1 = 25769803846, MagParam2 = 25769803852 WHERE RefItemCodeName IN ( SELECT Codename128 FROM dbo.[_RefObjCommon] WHERE CodeName128 LIKE 'ITEM_CH%_13%' AND TypeID3=1)
UPDATE [_RefScrapOfPackageItem] SET Variance = 450278829, MagParamNum = 2, MagParam1 = 25769803846, MagParam2 = 25769803852 WHERE RefItemCodeName IN ( SELECT Codename128 FROM dbo.[_RefObjCommon] WHERE CodeName128 LIKE 'ITEM_CH%_13%' AND TypeID3=2)
UPDATE [_RefScrapOfPackageItem] SET Variance = 450278829, MagParamNum = 2, MagParam1 = 25769803846, MagParam2 = 25769803852 WHERE RefItemCodeName IN ( SELECT Codename128 FROM dbo.[_RefObjCommon] WHERE CodeName128 LIKE 'ITEM_CH%_13%' AND TypeID3=3)
UPDATE [_RefScrapOfPackageItem] SET Variance = 450278829, MagParamNum = 2, MagParam1 = 25769803846, MagParam2 = 25769803852 WHERE RefItemCodeName IN ( SELECT Codename128 FROM dbo.[_RefObjCommon] WHERE CodeName128 LIKE 'ITEM_EU%_13%' AND TypeID3=9)
UPDATE [_RefScrapOfPackageItem] SET Variance = 450278829, MagParamNum = 2, MagParam1 = 25769803846, MagParam2 = 25769803852 WHERE RefItemCodeName IN ( SELECT Codename128 FROM dbo.[_RefObjCommon] WHERE CodeName128 LIKE 'ITEM_EU%_13%' AND TypeID3=10)
UPDATE [_RefScrapOfPackageItem] SET Variance = 450278829, MagParamNum = 2, MagParam1 = 25769803846, MagParam2 = 25769803852 WHERE RefItemCodeName IN ( SELECT Codename128 FROM dbo.[_RefObjCommon] WHERE CodeName128 LIKE 'ITEM_EU%_13%' AND TypeID3=11)
-- Accessories
UPDATE [_RefScrapOfPackageItem] SET Variance = 429, MagParamNum = 2, MagParam1 = 25769803846, MagParam2 = 25769803852 WHERE RefItemCodeName IN ( SELECT Codename128 FROM dbo.[_RefObjCommon] WHERE CodeName128 LIKE 'ITEM_CH%_13%' AND TypeID3=5)
UPDATE [_RefScrapOfPackageItem] SET Variance = 429, MagParamNum = 2, MagParam1 = 25769803846, MagParam2 = 25769803852 WHERE RefItemCodeName IN ( SELECT Codename128 FROM dbo.[_RefObjCommon] WHERE CodeName128 LIKE 'ITEM_EU%_13%' AND TypeID3=12)
-- Weapon
UPDATE [_RefScrapOfPackageItem] SET Variance = 14408922541, MagParamNum = 2, MagParam1 = 25769803846, MagParam2 = 25769803852 WHERE RefItemCodeName IN ( SELECT Codename128 FROM dbo.[_RefObjCommon] WHERE CodeName128 LIKE 'ITEM_CH%_13%' AND TypeID3=6)
UPDATE [_RefScrapOfPackageItem] SET Variance = 14408922541, MagParamNum = 2, MagParam1 = 25769803846, MagParam2 = 25769803852 WHERE RefItemCodeName IN ( SELECT Codename128 FROM dbo.[_RefObjCommon] WHERE CodeName128 LIKE 'ITEM_EU%_13%' AND TypeID3=6)
-- Shield
UPDATE [_RefScrapOfPackageItem] SET Variance = 450278829, MagParamNum = 2, MagParam1 = 25769803846, MagParam2 = 12884901893 WHERE RefItemCodeName IN ( SELECT Codename128 FROM dbo.[_RefObjCommon] WHERE CodeName128 LIKE 'ITEM_CH%_13%' AND TypeID3=4)
UPDATE [_RefScrapOfPackageItem] SET Variance = 450278829, MagParamNum = 2, MagParam1 = 25769803846, MagParam2 = 12884901893 WHERE RefItemCodeName IN ( SELECT Codename128 FROM dbo.[_RefObjCommon] WHERE CodeName128 LIKE 'ITEM_EU%_13%' AND TypeID3=4)