27-09-2017, 12:59 PM
|
#2
|
|
|
• الانـتـسـاب » Mar 2015
|
|
• رقـم العـضـويـة » 121247
|
|
• المشـــاركـات » 3,301
|
|
• الـدولـة » مصر
|
|
• الـهـوايـة » ذكر الله ~ لا اله الا الله ~
|
|
• اسـم الـسـيـرفـر » No Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 98
|
|
|
|
رد: مساعده في كويري
بص استخدم ده بيعمل 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'
وحط ID الايتم
|
|
|
|