عاوز اشيل d12 من الماجك بوب ميدا وداتا كاست اواى

[ღ♥_iMoRy_♥ღ]

عاوز اشيل الدجرى 12 وى الدجرى 13 من الماجك بوب شغال على كاست اواى :flag_austria:

[weloveahmed]

دى query تشيل 12D

Database
UPDATE [dbo].[_RefObjCommon]
SET Service = 0
WHERE CodeName128 like '%ITEM_EU%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 0
WHERE CodeName128 like '%ITEM_CH%'

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 8994 AND 9005

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9008 AND 9025

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9028 AND 9045

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9048 AND 9065

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9068 AND 9085

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9088 AND 9105

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9114 AND 9125

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9134 AND 9145

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9154 AND 9225

UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID = 38620

[weloveahmed]

دى magic pop 12
update _RefGachaItemSet
SET Service = 0
from _RefGachaItemSet p
inner join _RefObjCommon a on a.ID = p.RefItemID
where a.CodeName128 like '%_12_%' and p.Service = 1 and a.CodeName128 not like '%etc%'

دى 13 D
update _RefGachaItemSet
SET Service = 0
from _RefGachaItemSet p
inner join _RefObjCommon a on a.ID = p.RefItemID
where a.CodeName128 like '%_13_%' and p.Service = 1 and a.CodeName128 not like '%etc%'

[weloveahmed]

دجرى 13 weapon
UPDATE [dbo].[_RefObjCommon]
SET Service = 0
WHERE CodeName128 like '%ITEM_EU_SWORD_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 0
WHERE CodeName128 like '%ITEM_CH_SWORD_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 0
WHERE CodeName128 like '%ITEM_EU_TSWORD_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 0
WHERE CodeName128 like '%ITEM_CH_BLADE_13%'
UPDATE [dbo].[_RefObjCommon]
SET Service = 0
WHERE CodeName128 like '%ITEM_EU_HARP_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 0
WHERE CodeName128 like '%ITEM_CH_TBLADE_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 0
WHERE CodeName128 like '%ITEM_EU_CROSSBOW_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 0
WHERE CodeName128 like '%ITEM_CH_BOW_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 0
WHERE CodeName128 like '%ITEM_EU_DAGGER_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 0
WHERE CodeName128 like '%ITEM_CH_SPEAR_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 0
WHERE CodeName128 like '%ITEM_EU_SHIELD_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 0
WHERE CodeName128 like '%ITEM_CH_SHIELD_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 0
WHERE CodeName128 like '%ITEM_EU_DARKSTAFF_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 0
WHERE CodeName128 like '%ITEM_EU_STAFF_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 0
WHERE CodeName128 like '%ITEM_EU_TSTAFF_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 0
WHERE CodeName128 like '%ITEM_EU_AXE_13%'



Set
UPDATE [dbo].[_RefObjCommon]
set service = 0
WHERE CodeName128 like '%ITEM_EU_M_HEAVY_13%'

UPDATE [dbo].[_RefObjCommon]
set service = 0
WHERE CodeName128 like '%ITEM_CH_M_HEAVY_13%'

UPDATE [dbo].[_RefObjCommon]
set service = 0
WHERE CodeName128 like '%ITEM_EU_W_HEAVY_13%'

UPDATE [dbo].[_RefObjCommon]
set service = 0
WHERE CodeName128 like '%ITEM_CH_W_HEAVY_13%'

UPDATE [dbo].[_RefObjCommon]
set service = 0
WHERE CodeName128 like '%ITEM_EU_M_LIGHT_13%'

UPDATE [dbo].[_RefObjCommon]
set service = 0
WHERE CodeName128 like '%ITEM_CH_M_LIGHT_13%'

UPDATE [dbo].[_RefObjCommon]
set service = 0
WHERE CodeName128 like '%ITEM_EU_W_LIGHT_13%'

UPDATE [dbo].[_RefObjCommon]
set service = 0
WHERE CodeName128 like '%ITEM_CH_W_LIGHT_13%'
UPDATE [dbo].[_RefObjCommon]
set service = 0
WHERE CodeName128 like '%ITEM_EU_M_CLOTHES_13%'

UPDATE [dbo].[_RefObjCommon]
set service = 0
WHERE CodeName128 like '%ITEM_CH_M_CLOTHES_13%'

UPDATE [dbo].[_RefObjCommon]
set service = 0
WHERE CodeName128 like '%ITEM_EU_W_CLOTHES_13%'

UPDATE [dbo].[_RefObjCommon]
set service = 0
WHERE CodeName128 like '%ITEM_CH_W_CLOTHES_13%'


Accessory

UPDATE [dbo].[_RefObjCommon]
SET Service = 0
WHERE CodeName128 like '%ITEM_EU_RING_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 0
WHERE CodeName128 like '%ITEM_CH_RING_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 0
WHERE CodeName128 like '%ITEM_EU_EARRING_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 0
WHERE CodeName128 like '%ITEM_CH_EARRING_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 0
WHERE CodeName128 like '%ITEM_EU_NECKLACE_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 0
WHERE CodeName128 like '%ITEM_CH_NECKLACE_13%'



Good luck

[ღ♥_iMoRy_♥ღ]

ty i will try now

[ღ♥_iMoRy_♥ღ]

مش نافع :(