سؤال موهم

[safwot]

انا عندى داتا وكلين دجرى 11 ممكن ارفعهم بالملفات لحد 14

[Mahmoud Rashwan]

اكيد طبعا تقدر تعمل كل حاجة و دى حاجة كويسة انت لو بداءت كدا هتبقا كويس جدا جدا في حوار السيرفرات

عندك قسمـ الشروحات هات منو الموضيع و اشتغل و اى حاجة تقف معاك اعمل بيها موضوع هنا

[Dev.Klito]

استخدم دا عشان تفتح D12 و D13

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

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
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

و استخدم دى عشان تفتح D14

USE [SRO_VT_SHARD]
GO
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_C_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_HA_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_HA_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_HA_C_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_FA_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_FA_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_FA_C_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_LA_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_LA_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_LA_C_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_SA_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_SA_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_SA_C_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_BA_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_BA_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_BA_C_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_AA_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_AA_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%14_AA_C_RARE%'

عشان سطور المديا استخدم دا

https://mega.nz/#!mN1GWICY!NjawmNo0mw5KstBwekfQVSxKM1OIfCXN1KljFuk pwfk

[Dev.Klito]

##