ÇáãÓÇÚÏ ÇáÔÎÕí ÇáÑÞãí

ãÔÇåÏÉ ÇáäÓÎÉ ßÇãáÉ : íÇ ÌãÇÇÇÇÇÇÇÇÇÇÇÇÇÇÇÇÇÇÇÇÇÚÉ ÍÏ íÑÏ

zizo200004
05-09-2012, 04:41 AM
ÇäÇ ÇáÓíÑÝÑ ÈÊÇÚí d11 ÚÇíÒ ÇÎáíå d13 ÈäÝÓ Çá db íÇ ÑíÊ ÍÏ íÑÏ
Hector_
05-09-2012, 10:53 AM
ÇÊÝÖá íÇ ÈÇÔÇ
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

æÊÛíÑ ÇÓã ÇáÏÇÊÇ áæ ÇáÏÇÊÇ ÈÊÇÚÊß ÛíÑ SRO_VT_SHARD
ÍÊáÇÞí ÇáÏÇÊÇ ÝíåÇ ÏÌÑí 12 æ 13
æØÈÚÇ ÇáßáíäÊ ÇäÊÇ ÍÊÊÓÑÝ Ýíå
ãáÍæÙå : ÇáÏÇÊÇ ÓÄÇÁ ÏÌÑí 11 Çæ 12 Çæ 13 Çæ 20 ãÔ ÍÊÃËÑ Ú ÇáÓíÑÝÑ

ÊÇäí ÍÇÌå ÇÖÇÝÉ Çá 120 Level Skill In Database
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 1 AND 273

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 276 AND 3481

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 3486 AND 3491

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 3493 AND 8321

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 8328 AND 8328

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 8331 AND 12176

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12178 AND 12186

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12188 AND 12196

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12198 AND 12199

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12201 AND 12206


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12210 AND 12216


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12218 AND 12222


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12225 AND 12306


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12323 AND 20309


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 20311 AND 20501


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 20503 AND 21266


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 21268 AND 29693


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 29696 AND 30897


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31038 AND 31086


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31088 AND 31103


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31105 AND 31181


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31190 AND 31196


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31198 AND 31924


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 32088 AND 32874

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 32891 AND 32894

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 32897 AND 32904

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33042 AND 33045

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33072 AND 33073

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33072 AND 33073

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33077 AND 33287


UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33289 AND 33294

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33296 AND 33300

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33302 AND 33307

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33309 AND 33312

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33314 AND 33338

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33340 AND 33347

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33349 AND 33372

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33374 AND 33382

UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33740 AND 33785

UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 7182 AND 7184

UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 3436 AND 3440

UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 5409 AND 5409