29-03-2017, 11:27 AM
|
#1
|
|
|
• الانـتـسـاب » Dec 2015
|
|
• رقـم العـضـويـة » 128556
|
|
• المشـــاركـات » 1,336
|
|
• الـدولـة » 3mrany
|
|
• الـهـوايـة » Design-MySQL-C#-HTML-CSS3-WinServer-More
|
|
• اسـم الـسـيـرفـر » Aquarius
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 47
|
|
|
|
.gif)
عاوز تفتح دجرى تانى غير 11 فى داتا D11 ادخل هنــــــا
نظرا لتعدد الأسئلة اليومين دول حول ان الناس شغالة بــ داتا D11 و عايزة تفتح Dg تانى قررنا عمل الموضوع التالى ان شاء الله الموضوع هيكون مقسم ع قسمين قسم هنظبط فيه الداتا و قسم هنظبط فيه الميديا
1- تعديل الداتا
عشان تفتح D12
كود PHP:
USE [SRO_VT_SHARD]
GO
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%12_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%12_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%12_C_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%12_HA_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%12_HA_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%12_HA_C_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%12_FA_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%12_FA_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%12_FA_C_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%12_LA_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%12_LA_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%12_LA_C_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%12_SA_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%12_SA_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%12_SA_C_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%12_BA_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%12_BA_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%12_BA_C_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%12_AA_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%12_AA_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%12_AA_C_RARE%'
عشان تفتح D13
كود PHP:
USE [SRO_VT_SHARD]
GO
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%13_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%13_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%13_C_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%13_HA_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%13_HA_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%13_HA_C_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%13_FA_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%13_FA_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%13_FA_C_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%13_LA_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%13_LA_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%13_LA_C_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%13_SA_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%13_SA_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%13_SA_C_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%13_BA_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%13_BA_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%13_BA_C_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%13_AA_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%13_AA_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%13_AA_C_RARE%'
عشان تفتح D12 و D13 مع بعض
كود PHP:
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
كود PHP:
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%'
عشان تفتح D15
كود PHP:
USE [SRO_VT_SHARD]
GO
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%15_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%15_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%15_C_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%15_HA_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%15_HA_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%15_HA_C_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%15_FA_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%15_FA_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%15_FA_C_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%15_LA_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%15_LA_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%15_LA_C_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%15_SA_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%15_SA_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%15_SA_C_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%15_BA_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%15_BA_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%15_BA_C_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%15_AA_A_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%15_AA_B_RARE%'
UPDATE _RefObjCommon SET Service = 1 WHERE CodeName128 LIKE '%15_AA_C_RARE%'
كدا احنا حلصنا الداتا ندخل ع الميديا
2- تعديل الميديا
أيا كان الــ Query اللى انت عملتها فوق او حتى عملتهم كلهم استخدم البرنامج دا و هو هيجبلك كل سطور الميديا
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
|
|
|
|