دور عليها في refskill و خلى ال service 0 او اعمل الكوري دى
كود PHP:
USE [SRO_VT_SHARD]
GO
UPDATE _RefSkill SET Service = 0 WHERE Basic_Level = 120
UPDATE _RefSkill SET Service = 0 WHERE Basic_Level = 119
UPDATE _RefSkill SET Service = 0 WHERE Basic_Level = 118
UPDATE _RefSkill SET Service = 0 WHERE Basic_Level = 117
UPDATE _RefSkill SET Service = 0 WHERE Basic_Level = 116
UPDATE _RefSkill SET Service = 0 WHERE Basic_Level = 115
UPDATE _RefSkill SET Service = 0 WHERE Basic_Level = 114
UPDATE _RefSkill SET Service = 0 WHERE Basic_Level = 113
UPDATE _RefSkill SET Service = 0 WHERE Basic_Level = 112
UPDATE _RefSkill SET Service = 0 WHERE Basic_Level = 111
دى هتخلى الاسكلات اللفل بتعها 110
وبعدين اعمل دى
كود PHP:
USE [SRO_VT_SHARD]
GO
SELECT * FROM _RefSkill WHERE Basic_Level = 120
SELECT * FROM _RefSkill WHERE Basic_Level = 119
SELECT * FROM _RefSkill WHERE Basic_Level = 118
SELECT * FROM _RefSkill WHERE Basic_Level = 117
SELECT * FROM _RefSkill WHERE Basic_Level = 116
SELECT * FROM _RefSkill WHERE Basic_Level = 115
SELECT * FROM _RefSkill WHERE Basic_Level = 114
SELECT * FROM _RefSkill WHERE Basic_Level = 113
SELECT * FROM _RefSkill WHERE Basic_Level = 112
SELECT * FROM _RefSkill WHERE Basic_Level = 111
دى هتجبلك شوية سطور دور عليهم في ال skilldata_xxxenc عند كل سطر في ال skilldata_xxenc هتلقيه مختلف عن النتائج (اللى هي السطور يعنى ) المهم نت هتروح تدور في ال skilldata_xxxenc على النتائج هتلاقيها في ال skilldata_xxenc في 1 على الشمال خليه 0