بص استخدم ده بيعمل fb في الايتمز في NPC بس قبل ماتستخدمه اعمل باك اب
كود PHP:
-- Gear UPDATE [_RefScrapOfPackageItem] SET Variance = 450278829, MagParamNum = 2, MagParam1 = 25769803846, MagParam2 = 25769803852 WHERE RefItemCodeName IN ( SELECT Codename128 FROM dbo.[_RefObjCommon] WHERE CodeName128 LIKE 'ITEM_CH%_10%' 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%_10%' 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%_10%' 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%_10%' 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%_10%' 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%_10%' 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%_10%' 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%_10%' 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%_10%' 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%_10%' 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%_10%' 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%_10%' AND TypeID3=4)
لو عايز تعمل ايتم معينة بقا بنفسك مش في NPC
يعني هتبقى متاحة وهي fb فقط
كود PHP:
UPDATE dbo._Items set MagParamNum='5',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='5583457484950',MagParam4= '5583457484962',MagParam5='257698037898'WHERE ID64='ITEM ID'