اولا كنت بضيف السكل 125 فى الداتا بيز بيظهرلى ال 2 Error دول فى Shard and Sr_GameServer
صوره لى Errors
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
************************************************
المشكله الثانيه انى ضفت New GM Skill و كلو تمام و فتحت الجيم ملقتش اى حاجه الخانه بتاعت ال Skill مش ظاهر اصلا ده من ايه !!
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
المشاركة الأصلية كتبت بواسطة Dark_Legend
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
الايرور اللي في الداتا بيز يبقا انت ضايف حاجه غلط
وانك مالقتش الاسكلات في الجيم
يبقا انت ضايفها غلط في الميديا كمان !!
اولا ازاى انا ضيفها فى المديا غلط الكلام ده بخصوص ال New GM SKILL تمام فك التشفير صح مختش كراش ولا ميديا ولا داتا بيز المشكله انها مش موجوده يبقى المشكله فى انهى ملف فى المديا 90% مش من Skilldata_35000enc لانى عارف ازاى بفولك التشفير
عندك بعد كده Skill Effect و ده تمام بعد كده Skill Group و بعد كده Skill Group المفروض بضيف فيهم 3 سطور دول
رقم 289 ده رقم ثابت صح لان ده رقم بتاع Skill GM جو الجيم او الى بتفتح Table GM الى بيظهر فىه السكل صح كده
بعد كده SkillMastrydata
و ده السطر الى بيضاف فيها
ده برضو نفس النظام رقم 289 مش هيتغير
كده معرفش بقى المشكله منين
***********************
بخصوص Error الى فى الداتا بيز انا بقول لى حضرتك لما بضفهم فى الداتا بيظهر ال Error ده بس انا نسيت اوضح انى ضفت كل China Skill فى الداتا و ال Shard and Sr_Game فتحو كا نوع من الاختبار علشان اعرف المشكله منين و ضفت شويه من EUR لحد ما عرفت المشكله فى انهى سطر المشكله فى السطور ده
بص حضرتك خلاصه الكلام
اول مشكله سببها إن فيه ID مشابه او skills name مشابه
تاني مشكله هتعمل حاجه صغيره
هتروح عند SRO_VT_SHARD
_AddNewChar
Search
INSERT _CharNameList VALUES(@CharName, @NewCharID)
and put it down
---------------------------------------------------------------------------------
---- Add Mastery For Gm'S
-----------------------------------------------------------------------------
DECLARE @sec_primary TINYINT,
@sec_content TINYINT
SELECT @sec_primary = sec_primary,
@sec_content = sec_primary
FROM Dan_Acc.dbo.TB_User
WITH (NOLOCK)
WHERE JID = @UserJID
IF @sec_primary != 3
AND @sec_content ! = 3
BEGIN
INSERT INTO _CharSkillMastery
VALUES
(
@NewCharID,
'289',
1
)
END
IF @@ERROR != 0
BEGIN
ROLLBACK TRANSACTION
RETURN
END
-----------------------------------------------------------------------------
المشاركة الأصلية كتبت بواسطة MikrotikBody
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
بص حضرتك خلاصه الكلام
اول مشكله سببها إن فيه ID مشابه او skills name مشابه
تاني مشكله هتعمل حاجه صغيره
هتروح عند SRO_VT_SHARD
_AddNewChar
Search
INSERT _CharNameList VALUES(@CharName, @NewCharID)
and put it down
---------------------------------------------------------------------------------
---- Add Mastery For Gm'S
-----------------------------------------------------------------------------
DECLARE @sec_primary TINYINT,
@sec_content TINYINT
SELECT @sec_primary = sec_primary,
@sec_content = sec_primary
FROM Dan_Acc.dbo.TB_User
WITH (NOLOCK)
WHERE JID = @UserJID
IF @sec_primary != 3
AND @sec_content ! = 3
BEGIN
INSERT INTO _CharSkillMastery
VALUES
(
@NewCharID,
'289',
1
)
END
IF @@ERROR != 0
BEGIN
ROLLBACK TRANSACTION
RETURN
END
-----------------------------------------------------------------------------
بخصوص الى انت قولتو بخصوص ال GM Skill عملت زى ما قلت و مفيش حاجه ظهرت جوه الجيم
و اول مشكله هشوف و ارد عليك
اخى الحبيب
بالنسبة للمشكلة التانية بتاعت عدم ظهور الاسكلات للجي ام الحل كالآتي:-
1- افتح الداتابيز shard هتلاقى تيبول اسمه _CharSkillMastery
2 - هنضيف فيه السطر التالي
????? 289 1
بس بدل علامات الاستفهام حط رقم ID el GM المطلوب اضهار السكلات ليه
معلش اقلب السطر ID GMمن الشمال مش عارف ازبطها
عموماًالجدول فيه سطور جديد هيكون التنسيق بنفس تنسيق الجدول ID EL GM شمال ثم 289 فى الوسط ثم 1 فى الاخر
التعديل الأخير تم بواسطة aw_elkady ; 11-10-2014 الساعة 03:26 AM
المشكلة من ال ID فعلا تانى مشكلة كاتب مشكلة فى تاب
بص انت تحمل الملفات بس تتاكد انها شغالة
و تعمل رستورى للداتا بيز ة تفتح الجيم قبل ما تضيف الملفات عشان تتاكد انى مفيش ايرور :]
لو انت متاكد يبقا اعمل رستورى و ضيف الملفات من تانى و برضو احنا معاك
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_SHIELD_F_07'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_FRONTAREA_F2_05'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_COLD_GIGONGSUL_D_18'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_DUALA_CROSS_B_01' UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_DUALA_TWIST_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_DUALA_TWIST_C2_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_DUALA_TWIST_C3_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_DUALA_TWIST_C4_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_DUALA_COUNTER_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_DUALA_COUNTER_C2_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_DUALA_COUNTER_C3_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_DUALA_WHIRLWIND_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_DUALA_WHIRLWIND_C2_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_ROG_BOWP_DAMAGE_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARLOCK_DOTA_DISEASE_B_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARLOCK_RAZEA_PHY_MAG_A_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARLOCK_RAZEA_STR_INT_A_01' UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARLOCK_BLOODP_DAMAGE_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARLOCK_BLOODA_POINT_A_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARLOCK_BLOODA_POINT_B_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARLOCK_SOULA_STUN_A_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARLOCK_SOULA_STUN_B_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARLOCK_CONFUSIONA_RANGE_A_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARLOCK_CONFUSIONA_RANGE_B_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARLOCK_BLOODP_INCREASE_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_ETC_DETECT_06_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_ETC_DETECT_07_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_FRONTAREA_F3_04'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_FRONTAREA_F3_05'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_ROUNDAREA_F_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_ROUNDAREA_F_03'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_1S_04'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_1S_05'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_2S_04'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_2S_05'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_3S_04'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_3S_05'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_4S_04'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_4S_05'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_COLD_GIGONGSUL_E_03'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_COLD_GIGONGSUL_E_04'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_COLD_SHIELD_F_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_LIGHTNING_GIGONGTA_F_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_LIGHTNING_GIGONGTA_F_03'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_LIGHTNING_CHUNDUNG_F_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_LIGHTNING_STORM_E_04'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_LIGHTNING_STORM_E_05'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_FIRE_GIGONGTA_F_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_FIRE_GIGONGTA_F_03'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_FIRE_GANGGI_E_07'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_FIRE_GANGGI_E_08'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_DUALP_ATTACK_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_FRENZYA_DEFENSE_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_ROG_BOWP_MAD_BOW_UP_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARLOCK_SPELLP_PARTY_HWAN_UP_A_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_ROG_BOWA_POWER_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_ROG_BOWA_POWER_C2_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_ROG_BOWA_POWER_C3_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_ROG_BOWA_FAST_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_ROG_BOWA_FAST_C_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_ROG_BOWA_RANGE_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_ROG_POISONA_BLADE_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_ROG_POIS_DAGP_DAMAGE_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_ROG_POIS_DAGP_DAGGAR_UP_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_ROG_STEALTHP_DAMAGE_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_ROG_DAGGERA_CHAIN_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_ROG_DAGGERA_WOUND_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARLOCK_DOTA_BLOODING_B_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARLOCK_DOTA_DISEASE_A_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARLOCK_SPELLP_DMG_UP_DFS_DOWN_A_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARLOCK_BLOODA_LIFEDRAIN_A_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARLOCK_BLOODA_LIFEDRAIN_B_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARLOCK_SOULA_CHAOS_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARLOCK_SOULA_STUNLINK_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_ROG_POISONA_FIELD_B_03'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_ROG_TRANSFORMA_DUPLE_B_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_ROG_BOWA_KNOCK_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_BARD_MUSICP_ATTPOINT_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_BARD_BATTLAA_DAMAGE_A_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_BARD_BATTLAA_DAMAGE_B_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_GEOMGI_F_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_GEOMGI_F_03'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_GEOMGI_F2_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_GEOMGI_F2_03'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_GEOMGI_F3_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_GEOMGI_F3_03'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_KNOCKDOWN_E_06'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_KNOCKDOWN_E_07'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_KNOCKDOWN_E2_06'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_KNOCKDOWN_E2_07'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_SPECIAL_D_13'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_SPECIAL_D_14'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_CLERIC_REBIRTHA_TARGET_B_06'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_ETC_DETECT_05_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_7S_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_7S_03'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_SPECIAL_E_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_5S_04'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_FIRE_GIGONGSUL_G_03'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_ROG_DAGGERA_WOUND_C2_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_BARD_BATTLAA_EXPLOSION_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_SPECIAL_E_03'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_SPECIAL_E2_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_SPECIAL_E2_03'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_SHIELDPD_F_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_PIERCE_F_04'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_PIERCE_F_05'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_PIERCE_F2_04'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_PIERCE_F2_05'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_PIERCE_F3_04'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_PIERCE_F3_05'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_SPIN_F_07'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_FRONTAREA_F_04'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_5S_05'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_6S_04'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_6S_05'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_7S_04'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_7S_05'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_SHOOT_E_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_SHOOT_E_03'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_SHOOT_E2_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_SHOOT_E2_03'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_DAMAGE_DIVIDE_A_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_DAMAGE_DIVIDE_A_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_DAMAGE_DIVIDE_A_03'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_FIRE_GIGONGSUL_G_04'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_WATER_SELFHEAL_F_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_WATER_SELFHEAL_F_03'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_WATER_CURE_F_06'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_WATER_RESURRECTION_F_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_WATER_RESURRECTION_F_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_WATER_HARMONY_E_04'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_WATER_HARMONY_E_05'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_WATER_CANCEL2_A_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_WATER_CANCEL2_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_FRENZYA_TOUNT_AREA_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_FRENZYA_HEALTH_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_ROG_DAGGERA_WOUND_C3_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WIZARD_SPIRITP_EARTH_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WIZARD_EARTHA_POINT_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WIZARD_EARTHA_AREA_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WIZARD_SPIRITP_COLD_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WIZARD_COLDA_POINT_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WIZARD_COLDA_POINT_C2_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WIZARD_COLDA_AREA_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WIZARD_SPIRITP_FIRE_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WIZARD_FIREA_POINT_A_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WIZARD_FIREA_POINT_B_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_BARD_BATTLAA_MPSTEAL_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_BARD_BATTLAA_ROOT_A_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_BARD_FORGETA_MPABSORB_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_BARD_RECOVERA_MANATRANS_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_CLERIC_PRAISEP_DAMAGE_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_CLERIC_BATTLEA_CROSS_A_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_CLERIC_BATTLEA_CROSS_B_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_CLERIC_HEALA_TARGET_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_CLERIC_SAINTA_INNOCENT_A_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_CLERIC_PRAISEP_HEAL_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_CLERIC_BATTLEA_OVERHEAL_A_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_COLD_BINGPAN_E_04'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_COLD_GIGONGSUL_D_17'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_FRENZYA_TOUNT_SPRINT_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WIZARD_FIREA_TRAP_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_CLERIC_BATTLEA_OVERHEAL_B_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_FRENZYA_ALL_BLOCK_A_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_SHIELDP_ATTACK_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_SHIELDP_DEFENSE_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_ONEHANDA_STRIKE2_A_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_ONEHANDA_SHIELD2_A_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_ONEHANDA_SHIELD2_A2_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_ONEHANDA_SHIELD2_A3_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_ONEHANDA_PIERCE2_A_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_ONEHANDA_PIERCE2_A2_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_ONEHANDA_PIERCE2_A3_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_ONEHANDA_CRITICAL2_A_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WIZARD_FIREA_SPRAY_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WIZARD_FIREA_SPRAY_C2_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WIZARD_FIREA_SPRAY_C3_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WIZARD_FIREA_SPRAY_C4_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WIZARD_FIREA_SPRAY_C5_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WIZARD_FIREA_SPRAY_C6_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WIZARD_FIREA_SPRAY_C7_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WIZARD_SPIRITP_PSYCHIC_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WIZARD_PSYCHICA_LIGHT_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WIZARD_PSYCHICA_AREA_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WIZARD_PSYCHICA_AREA_C2_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_CLERIC_HEALA_GROUP_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_CLERIC_HEALA_DIVIDE_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_CLERIC_RECOVERYA_TARGET_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_CLERIC_REBIRTHA_GROUP_B_03'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_CLERIC_GLORYP_PHYSICAL_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_CLERIC_GLORYP_MAGICAL_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_CLERIC_BATTLEA_SACRIFICE_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_CLERIC_SAINTA_ABNORMAL_A_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_CLERIC_BLESSA_PHYSICAL_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_CLERIC_BLESSA_MAGICAL_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_ROG_BOWA_KNOCK_C2_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_FRONTAREA_F_05'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_FRONTAREA_F2_04'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_DAMAGE_DIVIDE_A_04'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_ONEHANDA_CRITICAL2_A2_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARLOCK_MINDP_DAMAGE_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARLOCK_MINDP_MANA_DECREASE_A_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARLOCK_DOTA_BURN_A_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARLOCK_DOTA_BURN_B_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARLOCK_DOTA_POISON_A_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARLOCK_DOTA_POISON_B_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARLOCK_DOTA_BLOODING_A_1_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_1S_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_1S_03'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_2S_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_2S_03'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_3S_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_3S_03'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_4S_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_4S_03'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_5S_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_5S_03'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_6S_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_6S_03'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SWORD_DAMAGE_DIVIDE_A_05'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_DAMAGE_DIVIDE_A_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_DAMAGE_DIVIDE_A_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_DAMAGE_DIVIDE_A_03'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_DAMAGE_DIVIDE_A_04'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_SPEAR_DAMAGE_DIVIDE_A_05'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_COLD_GIGONGTA_F_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_COLD_GIGONGTA_F_03'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_COLD_GANGGI_F_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_COLD_GANGGI_F_02'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_COLD_GIGONGJANG_F_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_CH_COLD_BINGBYEOK_E_05'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_ONEHANDA_CRITICAL2_A3_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_TWOHANDP_ATTACK_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_TWOHANDA_DASH_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_TWOHANDA_RISING_B_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_TWOHANDA_CHARGE_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_TWOHANDA_CHARGE_C2_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_TWOHANDA_CHARGE_C3_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_TWOHANDA_CRY_C_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_TWOHANDA_CRY_C2_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_TWOHANDA_CRY_C3_01'
UPDATE [dbo].[_RefSkill] SET Service = 1 WHERE Basic_Code like 'SKILL_EU_WARRIOR_FRENZYA_DAMAGE_B_01'
المشاركة الأصلية كتبت بواسطة Hero
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
شوف كدة الكورى دى
كود PHP:
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_SHIELD_F_07'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_FRONTAREA_F2_05'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_COLD_GIGONGSUL_D_18'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_DUALA_CROSS_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_DUALA_TWIST_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_DUALA_TWIST_C2_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_DUALA_TWIST_C3_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_DUALA_TWIST_C4_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_DUALA_COUNTER_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_DUALA_COUNTER_C2_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_DUALA_COUNTER_C3_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_DUALA_WHIRLWIND_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_DUALA_WHIRLWIND_C2_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_ROG_BOWP_DAMAGE_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARLOCK_DOTA_DISEASE_B_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARLOCK_RAZEA_PHY_MAG_A_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARLOCK_RAZEA_STR_INT_A_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARLOCK_BLOODP_DAMAGE_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARLOCK_BLOODA_POINT_A_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARLOCK_BLOODA_POINT_B_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARLOCK_SOULA_STUN_A_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARLOCK_SOULA_STUN_B_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARLOCK_CONFUSIONA_RANGE_A_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARLOCK_CONFUSIONA_RANGE_B_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARLOCK_BLOODP_INCREASE_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_ETC_DETECT_06_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_ETC_DETECT_07_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_FRONTAREA_F3_04'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_FRONTAREA_F3_05'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_ROUNDAREA_F_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_ROUNDAREA_F_03'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_1S_04'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_1S_05'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_2S_04'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_2S_05'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_3S_04'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_3S_05'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_4S_04'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_4S_05'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_COLD_GIGONGSUL_E_03'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_COLD_GIGONGSUL_E_04'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_COLD_SHIELD_F_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_LIGHTNING_GIGONGTA_F_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_LIGHTNING_GIGONGTA_F_03'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_LIGHTNING_CHUNDUNG_F_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_LIGHTNING_STORM_E_04'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_LIGHTNING_STORM_E_05'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_FIRE_GIGONGTA_F_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_FIRE_GIGONGTA_F_03'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_FIRE_GANGGI_E_07'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_FIRE_GANGGI_E_08'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_DUALP_ATTACK_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_FRENZYA_DEFENSE_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_ROG_BOWP_MAD_BOW_UP_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARLOCK_SPELLP_PARTY_HWAN_UP_A_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_ROG_BOWA_POWER_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_ROG_BOWA_POWER_C2_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_ROG_BOWA_POWER_C3_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_ROG_BOWA_FAST_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_ROG_BOWA_FAST_C_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_ROG_BOWA_RANGE_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_ROG_POISONA_BLADE_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_ROG_POIS_DAGP_DAMAGE_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_ROG_POIS_DAGP_DAGGAR_UP_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_ROG_STEALTHP_DAMAGE_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_ROG_DAGGERA_CHAIN_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_ROG_DAGGERA_WOUND_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARLOCK_DOTA_BLOODING_B_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARLOCK_DOTA_DISEASE_A_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARLOCK_SPELLP_DMG_UP_DFS_DOWN_A_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARLOCK_BLOODA_LIFEDRAIN_A_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARLOCK_BLOODA_LIFEDRAIN_B_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARLOCK_SOULA_CHAOS_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARLOCK_SOULA_STUNLINK_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_ROG_POISONA_FIELD_B_03'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_ROG_TRANSFORMA_DUPLE_B_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_ROG_BOWA_KNOCK_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_BARD_MUSICP_ATTPOINT_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_BARD_BATTLAA_DAMAGE_A_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_BARD_BATTLAA_DAMAGE_B_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_GEOMGI_F_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_GEOMGI_F_03'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_GEOMGI_F2_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_GEOMGI_F2_03'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_GEOMGI_F3_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_GEOMGI_F3_03'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_KNOCKDOWN_E_06'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_KNOCKDOWN_E_07'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_KNOCKDOWN_E2_06'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_KNOCKDOWN_E2_07'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_SPECIAL_D_13'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_SPECIAL_D_14'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_CLERIC_REBIRTHA_TARGET_B_06'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_ETC_DETECT_05_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_7S_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_7S_03'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_SPECIAL_E_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_5S_04'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_FIRE_GIGONGSUL_G_03'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_ROG_DAGGERA_WOUND_C2_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_BARD_BATTLAA_EXPLOSION_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_SPECIAL_E_03'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_SPECIAL_E2_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_SPECIAL_E2_03'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_SHIELDPD_F_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_PIERCE_F_04'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_PIERCE_F_05'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_PIERCE_F2_04'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_PIERCE_F2_05'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_PIERCE_F3_04'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_PIERCE_F3_05'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_SPIN_F_07'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_FRONTAREA_F_04'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_5S_05'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_6S_04'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_6S_05'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_7S_04'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_CHAIN_G_7S_05'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_SHOOT_E_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_SHOOT_E_03'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_SHOOT_E2_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_SHOOT_E2_03'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_DAMAGE_DIVIDE_A_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_DAMAGE_DIVIDE_A_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_DAMAGE_DIVIDE_A_03'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_FIRE_GIGONGSUL_G_04'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_WATER_SELFHEAL_F_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_WATER_SELFHEAL_F_03'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_WATER_CURE_F_06'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_WATER_RESURRECTION_F_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_WATER_RESURRECTION_F_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_WATER_HARMONY_E_04'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_WATER_HARMONY_E_05'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_WATER_CANCEL2_A_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_WATER_CANCEL2_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_FRENZYA_TOUNT_AREA_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_FRENZYA_HEALTH_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_ROG_DAGGERA_WOUND_C3_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WIZARD_SPIRITP_EARTH_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WIZARD_EARTHA_POINT_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WIZARD_EARTHA_AREA_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WIZARD_SPIRITP_COLD_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WIZARD_COLDA_POINT_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WIZARD_COLDA_POINT_C2_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WIZARD_COLDA_AREA_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WIZARD_SPIRITP_FIRE_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WIZARD_FIREA_POINT_A_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WIZARD_FIREA_POINT_B_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_BARD_BATTLAA_MPSTEAL_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_BARD_BATTLAA_ROOT_A_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_BARD_FORGETA_MPABSORB_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_BARD_RECOVERA_MANATRANS_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_CLERIC_PRAISEP_DAMAGE_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_CLERIC_BATTLEA_CROSS_A_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_CLERIC_BATTLEA_CROSS_B_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_CLERIC_HEALA_TARGET_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_CLERIC_SAINTA_INNOCENT_A_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_CLERIC_PRAISEP_HEAL_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_CLERIC_BATTLEA_OVERHEAL_A_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_COLD_BINGPAN_E_04'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_COLD_GIGONGSUL_D_17'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_FRENZYA_TOUNT_SPRINT_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WIZARD_FIREA_TRAP_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_CLERIC_BATTLEA_OVERHEAL_B_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_FRENZYA_ALL_BLOCK_A_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_SHIELDP_ATTACK_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_SHIELDP_DEFENSE_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_ONEHANDA_STRIKE2_A_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_ONEHANDA_SHIELD2_A_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_ONEHANDA_SHIELD2_A2_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_ONEHANDA_SHIELD2_A3_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_ONEHANDA_PIERCE2_A_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_ONEHANDA_PIERCE2_A2_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_ONEHANDA_PIERCE2_A3_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_ONEHANDA_CRITICAL2_A_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WIZARD_FIREA_SPRAY_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WIZARD_FIREA_SPRAY_C2_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WIZARD_FIREA_SPRAY_C3_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WIZARD_FIREA_SPRAY_C4_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WIZARD_FIREA_SPRAY_C5_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WIZARD_FIREA_SPRAY_C6_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WIZARD_FIREA_SPRAY_C7_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WIZARD_SPIRITP_PSYCHIC_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WIZARD_PSYCHICA_LIGHT_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WIZARD_PSYCHICA_AREA_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WIZARD_PSYCHICA_AREA_C2_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_CLERIC_HEALA_GROUP_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_CLERIC_HEALA_DIVIDE_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_CLERIC_RECOVERYA_TARGET_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_CLERIC_REBIRTHA_GROUP_B_03'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_CLERIC_GLORYP_PHYSICAL_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_CLERIC_GLORYP_MAGICAL_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_CLERIC_BATTLEA_SACRIFICE_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_CLERIC_SAINTA_ABNORMAL_A_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_CLERIC_BLESSA_PHYSICAL_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_CLERIC_BLESSA_MAGICAL_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_ROG_BOWA_KNOCK_C2_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_FRONTAREA_F_05'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_FRONTAREA_F2_04'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_DAMAGE_DIVIDE_A_04'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_ONEHANDA_CRITICAL2_A2_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARLOCK_MINDP_DAMAGE_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARLOCK_MINDP_MANA_DECREASE_A_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARLOCK_DOTA_BURN_A_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARLOCK_DOTA_BURN_B_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARLOCK_DOTA_POISON_A_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARLOCK_DOTA_POISON_B_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARLOCK_DOTA_BLOODING_A_1_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_1S_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_1S_03'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_2S_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_2S_03'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_3S_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_3S_03'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_4S_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_4S_03'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_5S_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_5S_03'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_6S_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_CHAIN_H_6S_03'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SWORD_DAMAGE_DIVIDE_A_05'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_DAMAGE_DIVIDE_A_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_DAMAGE_DIVIDE_A_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_DAMAGE_DIVIDE_A_03'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_DAMAGE_DIVIDE_A_04'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_SPEAR_DAMAGE_DIVIDE_A_05'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_COLD_GIGONGTA_F_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_COLD_GIGONGTA_F_03'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_COLD_GANGGI_F_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_COLD_GANGGI_F_02'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_COLD_GIGONGJANG_F_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_CH_COLD_BINGBYEOK_E_05'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_ONEHANDA_CRITICAL2_A3_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_TWOHANDP_ATTACK_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_TWOHANDA_DASH_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_TWOHANDA_RISING_B_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_TWOHANDA_CHARGE_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_TWOHANDA_CHARGE_C2_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_TWOHANDA_CHARGE_C3_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_TWOHANDA_CRY_C_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_TWOHANDA_CRY_C2_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_TWOHANDA_CRY_C3_01'
UPDATE [dbo].[_RefSkill]
SET Service = 1
WHERE Basic_Code like 'SKILL_EU_WARRIOR_FRENZYA_DAMAGE_B_01'
ما انا معايه الكويرى ده بس ده بتقفل السكل و تشغلها ده لما بتكون مضافه اصلا فا هى عندى مش موجوده فى RefSkill فا هتعمل Update لىها ازاى يعنى ؟؟
الكورى بيفتح افتكرت الاسكلات موجودة على العموم تقريبا حلها انك لازم تظبط المكان على حسب الداتا بتعتك فهمت يعنى لازم الضربات تكون موجودة فى مكنها الصح تقريبا يعنى
10-10-2014, 12:27 PM
المواضيع المتشابهه
.gif){kind=icon}
العرض المتطور
