15-03-2017, 09:18 PM
|
#2
|
|
• الانـتـسـاب » Oct 2008
|
• رقـم العـضـويـة » 37620
|
• المشـــاركـات » 3,134
|
• الـدولـة » فوق السطوح
|
• الـهـوايـة » التخريب
|
• اسـم الـسـيـرفـر » No Server
|
• الـجـنـس » Male
|
• نقـاط التقييم » 1081
|
|
|
رد: Params d13 to make fb at npc
اتفضل
كود PHP:
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)
|
|
|