15-03-2017, 09:18 PM
|
#2
|
|
|
• الانـتـسـاب » Oct 2008
|
|
• رقـم العـضـويـة » 37620
|
|
• المشـــاركـات » 3,136
|
|
• الـدولـة » فوق السطوح
|
|
• الـهـوايـة » التخريب
|
|
• اسـم الـسـيـرفـر » No Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 55
|
|
|
|
.gif)
رد: 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)
|
|
|
|