Vsro Kod Paylaşım Vsro 10D İtemleri FB +7 Query (1 Viewer)

10 D İtemleri +7 %100 Stat FB Yapma Query

'%ITEM_%_%_%_10_BA_A_RARE%' : A_RARE Star İtemdir.!
'%ITEM_%_%_%_10_BA_B_RARE%' : B_RARE Moon İtemdir.!
'%ITEM_%_%_%_10_BA_C_RARE%' : C_RARE Sun İtemdir.!

Görsel
-



Kod:
USE SRO_VT_SHARD

UPDATE dbo._RefScrapOfPackageItem SET OptLevel='7',Variance='34359738367',MagParamNum='5',MagParam1='858993459290',MagParam2='429496729714',MagParam3='257698037862',MagParam4='30064771150',MagParam5='30064771144',MagParam6='0' WHERE RefItemCodeName like '%ITEM_%_%_10_C_RARE%' AND NOT RefItemCodeName like '%RING%' AND NOT RefItemCodeName like '%SHIELD%'


UPDATE dbo._RefScrapOfPackageItem SET OptLevel='7',Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='30064771150',MagParam3='429496729726',MagParam4='30064771144',MagParam5='30064771144',MagParam6='0' WHERE RefItemCodeName like '%ITEM_%_SHIELD_10_C_RARE%'


UPDATE dbo._RefScrapOfPackageItem SET OptLevel='7',Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='5583457484950',MagParam4='30064771150',MagParam5='5583457484962',MagParam6='30064771144' WHERE RefItemCodeName like '%ITEM_%_%_%_10_HA_C_RARE%'
UPDATE dbo._RefScrapOfPackageItem SET OptLevel='7',Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='5583457484950',MagParam4='30064771150',MagParam5='5583457484962',MagParam6='30064771144' WHERE RefItemCodeName like '%ITEM_%_%_%_10_LA_C_RARE%'
UPDATE dbo._RefScrapOfPackageItem SET OptLevel='7',Variance='1073741823',MagParamNum='6',MagParam1='858993459290',MagParam2='257698037898',MagParam3='5583457484950',MagParam4='30064771150',MagParam5='5583457484962',MagParam6='30064771144' WHERE RefItemCodeName like '%ITEM_%_%_%_10_BA_C_RARE%'
UPDATE dbo._RefScrapOfPackageItem SET OptLevel='7',Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='30064771150',MagParam4='30064771144',MagParam5='0',MagParam6='0' WHERE RefItemCodeName like '%ITEM_%_%_%_10_SA_C_RARE%'
UPDATE dbo._RefScrapOfPackageItem SET OptLevel='7',Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='30064771150',MagParam4='30064771144',MagParam5='0',MagParam6='0' WHERE RefItemCodeName like '%ITEM_%_%_%_10_AA_C_RARE%'
UPDATE dbo._RefScrapOfPackageItem SET OptLevel='7',Variance='1073741823',MagParamNum='4',MagParam1='858993459290',MagParam2='257698037898',MagParam3='30064771150',MagParam4='30064771144',MagParam5='0',MagParam6='0' WHERE RefItemCodeName like '%ITEM_%_%_%_10_FA_C_RARE%'


UPDATE dbo._RefScrapOfPackageItem SET OptLevel='7',Variance='1023',MagParamNum='7',MagParam1='30064771150',MagParam2='85899346100',MagParam3='85899346094',MagParam4='85899346088',MagParam5='85899346106',MagParam6='85899346112',MagParam7='30064771144' WHERE RefItemCodeName like '%ITEM_%_RING_10_C_RARE%'
UPDATE dbo._RefScrapOfPackageItem SET OptLevel='7',Variance='1023',MagParamNum='7',MagParam1='30064771150',MagParam2='85899346100',MagParam3='85899346094',MagParam4='85899346088',MagParam5='85899346106',MagParam6='85899346112',MagParam7='30064771144' WHERE RefItemCodeName like '%ITEM_%_EARRING_10_C_RARE%'
UPDATE dbo._RefScrapOfPackageItem SET OptLevel='7',Variance='1023',MagParamNum='7',MagParam1='30064771150',MagParam2='85899346100',MagParam3='85899346094',MagParam4='85899346088',MagParam5='85899346106',MagParam6='85899346112',MagParam7='30064771144' WHERE RefItemCodeName like '%ITEM_%_NECKLACE_10_C_RARE%'