الموقع العربي الاول للعبة Silkroad Online

الموقع العربي الاول للعبة Silkroad Online (https://silkroad4arab.com/vb/index.php)
-   قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة (https://silkroad4arab.com/vb/forumdisplay.php?f=226)
-   -   عاوز Query يفتح كل الاسكلات (https://silkroad4arab.com/vb/showthread.php?t=487841)

Orphan 09-03-2013 01:03 AM
عاوز Query يفتح كل الاسكلات
 
يا ريت لو سمحت ّ!

[GM 09-03-2013 01:06 AM
كود بلغة HTML:

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'

BomBom 09-03-2013 01:12 AM
يعنى ايه يفتح كل الاسكلات ؟

يفتح كل الاسكلات عندك فى اكونت ال Gm

ولا عندك فى اللعبة و ولا ايه بظبت ؟

Orphan 09-03-2013 01:19 AM
عاوز افتح سكلات اكونت الجى ام كلها مع الشرح لو سمحت ..

BomBom 09-03-2013 01:21 AM
اتفضل

غير كلمة kira ب اسم الchar بتاعك

كود:
USE([SRO_VT_SHARD])
GO()

Declare @CharName Varchar (64)
Set @CharName    =    'Kira' /* Char Name */

Update([dbo].[_CharSkillMastery])
Level = 120
WHERE CharID = (SELECT CharID FROM [dbo].[_Char] WHERE CharName16 = @CharName)

Orphan 09-03-2013 01:33 AM
اقتباس:
المشاركة الأصلية كتبت بواسطة BomBom (المشاركة 4595160)
اتفضل

غير كلمة kira ب اسم الchar بتاعك

كود:
USE([SRO_VT_SHARD])
GO()

Declare @CharName Varchar (64)
Set @CharName    =    'Kira' /* Char Name */

Update([dbo].[_CharSkillMastery])
Level = 120
WHERE CharID = (SELECT CharID FROM [dbo].[_Char] WHERE CharName16 = @CharName)

A fatal scripting error occurred.
Incorrect syntax was encountered while parsing GO.

مش شغال !!

BomBom 09-03-2013 01:40 AM
اسف جدا

استخدم دى

كود:
USE [SRO_VT_SHARD]
GO
Declare @CharName Varchar (64)
Set @CharName = 'kira'

UPDATE [dbo].[_CharSkillMastery]
SET Level= 120
WHERE CharID = (SELECT CharID FROM [dbo].[_Char] WHERE CharName16 = @CharName)

Orphan 09-03-2013 01:44 AM
تمام بس دا فتحلىMastery up بس

فى query تانى بيفتح كل الاسكلات بتبقى MAX

Orphan 09-03-2013 01:57 AM
و هل ينفع اخلى ال hp و mp بتاع اكونت الجي ام اكتر من 5 مليون ؟

Orphan 09-03-2013 02:25 AM
up

kimo77 09-03-2013 09:25 AM
كود بلغة HTML:


USE [SRO_VT_SHARD]
DECLARE @CharName varchar(255)
DECLARE @CharID INT
SET @CharName='EU'
SELECT @CharID = CharID FROM _Char WHERE CharName16=@CharName
UPDATE _CharSkillMastery SET Level = '120' WHERE CharID=@CharID
INSERT INTO _CharSkill VALUES (@CharID,1,1)
INSERT INTO _CharSkill VALUES (@CharID,2,1)
INSERT INTO _CharSkill VALUES (@CharID,40,1)
INSERT INTO _CharSkill VALUES (@CharID,70,1)
INSERT INTO _CharSkill VALUES (@CharID,298,1)
INSERT INTO _CharSkill VALUES (@CharID,306,1)
INSERT INTO _CharSkill VALUES (@CharID,314,1)
INSERT INTO _CharSkill VALUES (@CharID,322,1)
INSERT INTO _CharSkill VALUES (@CharID,346,1)
INSERT INTO _CharSkill VALUES (@CharID,378,1)
INSERT INTO _CharSkill VALUES (@CharID,418,1)
INSERT INTO _CharSkill VALUES (@CharID,463,1)
INSERT INTO _CharSkill VALUES (@CharID,558,1)
INSERT INTO _CharSkill VALUES (@CharID,569,1)
INSERT INTO _CharSkill VALUES (@CharID,580,1)
INSERT INTO _CharSkill VALUES (@CharID,588,1)
INSERT INTO _CharSkill VALUES (@CharID,596,1)
INSERT INTO _CharSkill VALUES (@CharID,604,1)
INSERT INTO _CharSkill VALUES (@CharID,647,1)
INSERT INTO _CharSkill VALUES (@CharID,655,1)
INSERT INTO _CharSkill VALUES (@CharID,672,1)
INSERT INTO _CharSkill VALUES (@CharID,689,1)
INSERT INTO _CharSkill VALUES (@CharID,699,1)
INSERT INTO _CharSkill VALUES (@CharID,708,1)
INSERT INTO _CharSkill VALUES (@CharID,716,1)
INSERT INTO _CharSkill VALUES (@CharID,724,1)
INSERT INTO _CharSkill VALUES (@CharID,735,1)
INSERT INTO _CharSkill VALUES (@CharID,746,1)
INSERT INTO _CharSkill VALUES (@CharID,757,1)
INSERT INTO _CharSkill VALUES (@CharID,765,1)
INSERT INTO _CharSkill VALUES (@CharID,773,1)
INSERT INTO _CharSkill VALUES (@CharID,781,1)
INSERT INTO _CharSkill VALUES (@CharID,789,1)
INSERT INTO _CharSkill VALUES (@CharID,797,1)
INSERT INTO _CharSkill VALUES (@CharID,805,1)
INSERT INTO _CharSkill VALUES (@CharID,813,1)
INSERT INTO _CharSkill VALUES (@CharID,821,1)
INSERT INTO _CharSkill VALUES (@CharID,829,1)
INSERT INTO _CharSkill VALUES (@CharID,853,1)
INSERT INTO _CharSkill VALUES (@CharID,885,1)
INSERT INTO _CharSkill VALUES (@CharID,925,1)
INSERT INTO _CharSkill VALUES (@CharID,933,1)
INSERT INTO _CharSkill VALUES (@CharID,943,1)
INSERT INTO _CharSkill VALUES (@CharID,952,1)
INSERT INTO _CharSkill VALUES (@CharID,960,1)
INSERT INTO _CharSkill VALUES (@CharID,968,1)
INSERT INTO _CharSkill VALUES (@CharID,976,1)
INSERT INTO _CharSkill VALUES (@CharID,984,1)
INSERT INTO _CharSkill VALUES (@CharID,992,1)
INSERT INTO _CharSkill VALUES (@CharID,1003,1)
INSERT INTO _CharSkill VALUES (@CharID,1014,1)
INSERT INTO _CharSkill VALUES (@CharID,1025,1)
INSERT INTO _CharSkill VALUES (@CharID,1033,1)
INSERT INTO _CharSkill VALUES (@CharID,1041,1)
INSERT INTO _CharSkill VALUES (@CharID,1049,1)
INSERT INTO _CharSkill VALUES (@CharID,1053,1)
INSERT INTO _CharSkill VALUES (@CharID,1057,1)
INSERT INTO _CharSkill VALUES (@CharID,1065,1)
INSERT INTO _CharSkill VALUES (@CharID,1073,1)
INSERT INTO _CharSkill VALUES (@CharID,1081,1)
INSERT INTO _CharSkill VALUES (@CharID,1089,1)
INSERT INTO _CharSkill VALUES (@CharID,1099,1)
INSERT INTO _CharSkill VALUES (@CharID,1108,1)
INSERT INTO _CharSkill VALUES (@CharID,1116,1)
INSERT INTO _CharSkill VALUES (@CharID,1124,1)
INSERT INTO _CharSkill VALUES (@CharID,1132,1)
INSERT INTO _CharSkill VALUES (@CharID,1140,1)
INSERT INTO _CharSkill VALUES (@CharID,1148,1)
INSERT INTO _CharSkill VALUES (@CharID,1153,1)
INSERT INTO _CharSkill VALUES (@CharID,1158,1)
INSERT INTO _CharSkill VALUES (@CharID,1163,1)
INSERT INTO _CharSkill VALUES (@CharID,1168,1)
INSERT INTO _CharSkill VALUES (@CharID,1173,1)
INSERT INTO _CharSkill VALUES (@CharID,1178,1)
INSERT INTO _CharSkill VALUES (@CharID,1189,1)
INSERT INTO _CharSkill VALUES (@CharID,1200,1)
INSERT INTO _CharSkill VALUES (@CharID,1217,1)
INSERT INTO _CharSkill VALUES (@CharID,1234,1)
INSERT INTO _CharSkill VALUES (@CharID,1244,1)
INSERT INTO _CharSkill VALUES (@CharID,1253,1)
INSERT INTO _CharSkill VALUES (@CharID,1261,1)
INSERT INTO _CharSkill VALUES (@CharID,1269,1)
INSERT INTO _CharSkill VALUES (@CharID,1271,1)
INSERT INTO _CharSkill VALUES (@CharID,1273,1)
INSERT INTO _CharSkill VALUES (@CharID,1275,1)
INSERT INTO _CharSkill VALUES (@CharID,1286,1)
INSERT INTO _CharSkill VALUES (@CharID,1297,1)
INSERT INTO _CharSkill VALUES (@CharID,1308,1)
INSERT INTO _CharSkill VALUES (@CharID,1316,1)
INSERT INTO _CharSkill VALUES (@CharID,1324,1)
INSERT INTO _CharSkill VALUES (@CharID,1332,1)
INSERT INTO _CharSkill VALUES (@CharID,1337,1)
INSERT INTO _CharSkill VALUES (@CharID,1342,1)
INSERT INTO _CharSkill VALUES (@CharID,1350,1)
INSERT INTO _CharSkill VALUES (@CharID,1358,1)
INSERT INTO _CharSkill VALUES (@CharID,1368,1)
INSERT INTO _CharSkill VALUES (@CharID,1377,1)
INSERT INTO _CharSkill VALUES (@CharID,1385,1)
INSERT INTO _CharSkill VALUES (@CharID,1393,1)
INSERT INTO _CharSkill VALUES (@CharID,1398,1)
INSERT INTO _CharSkill VALUES (@CharID,1403,1)
INSERT INTO _CharSkill VALUES (@CharID,1408,1)
INSERT INTO _CharSkill VALUES (@CharID,1410,1)
INSERT INTO _CharSkill VALUES (@CharID,1412,1)
INSERT INTO _CharSkill VALUES (@CharID,1414,1)
INSERT INTO _CharSkill VALUES (@CharID,1422,1)
INSERT INTO _CharSkill VALUES (@CharID,1430,1)
INSERT INTO _CharSkill VALUES (@CharID,1438,1)
INSERT INTO _CharSkill VALUES (@CharID,1443,1)
INSERT INTO _CharSkill VALUES (@CharID,1448,1)
INSERT INTO _CharSkill VALUES (@CharID,1465,1)
INSERT INTO _CharSkill VALUES (@CharID,1482,1)
INSERT INTO _CharSkill VALUES (@CharID,1499,1)
INSERT INTO _CharSkill VALUES (@CharID,1509,1)
INSERT INTO _CharSkill VALUES (@CharID,1518,1)
INSERT INTO _CharSkill VALUES (@CharID,1526,1)
INSERT INTO _CharSkill VALUES (@CharID,1534,1)
INSERT INTO _CharSkill VALUES (@CharID,1539,1)
INSERT INTO _CharSkill VALUES (@CharID,1544,1)
INSERT INTO _CharSkill VALUES (@CharID,1549,1)
INSERT INTO _CharSkill VALUES (@CharID,1557,1)
INSERT INTO _CharSkill VALUES (@CharID,1565,1)
INSERT INTO _CharSkill VALUES (@CharID,1573,1)
INSERT INTO _CharSkill VALUES (@CharID,1578,1)
INSERT INTO _CharSkill VALUES (@CharID,1583,1)
INSERT INTO _CharSkill VALUES (@CharID,1588,1)
INSERT INTO _CharSkill VALUES (@CharID,1593,1)
INSERT INTO _CharSkill VALUES (@CharID,1598,1)
INSERT INTO _CharSkill VALUES (@CharID,1609,1)
INSERT INTO _CharSkill VALUES (@CharID,1617,1)
INSERT INTO _CharSkill VALUES (@CharID,1628,1)
INSERT INTO _CharSkill VALUES (@CharID,3149,1)
INSERT INTO _CharSkill VALUES (@CharID,3167,1)
INSERT INTO _CharSkill VALUES (@CharID,3176,1)
INSERT INTO _CharSkill VALUES (@CharID,3224,1)
INSERT INTO _CharSkill VALUES (@CharID,3340,1)
INSERT INTO _CharSkill VALUES (@CharID,3349,1)
INSERT INTO _CharSkill VALUES (@CharID,3364,1)
INSERT INTO _CharSkill VALUES (@CharID,3379,1)
INSERT INTO _CharSkill VALUES (@CharID,3391,1)
INSERT INTO _CharSkill VALUES (@CharID,3406,1)
INSERT INTO _CharSkill VALUES (@CharID,3409,1)
INSERT INTO _CharSkill VALUES (@CharID,3415,1)
INSERT INTO _CharSkill VALUES (@CharID,3430,1)
INSERT INTO _CharSkill VALUES (@CharID,3431,1)
INSERT INTO _CharSkill VALUES (@CharID,3446,1)
INSERT INTO _CharSkill VALUES (@CharID,3461,1)
INSERT INTO _CharSkill VALUES (@CharID,3467,1)
INSERT INTO _CharSkill VALUES (@CharID,3473,1)
INSERT INTO _CharSkill VALUES (@CharID,7139,1)
INSERT INTO _CharSkill VALUES (@CharID,7159,1)
INSERT INTO _CharSkill VALUES (@CharID,7203,1)
INSERT INTO _CharSkill VALUES (@CharID,7322,1)
INSERT INTO _CharSkill VALUES (@CharID,7385,1)
INSERT INTO _CharSkill VALUES (@CharID,7390,1)
INSERT INTO _CharSkill VALUES (@CharID,7392,1)
INSERT INTO _CharSkill VALUES (@CharID,7404,1)
INSERT INTO _CharSkill VALUES (@CharID,7418,1)
INSERT INTO _CharSkill VALUES (@CharID,7474,1)
INSERT INTO _CharSkill VALUES (@CharID,7484,1)
INSERT INTO _CharSkill VALUES (@CharID,7513,1)
INSERT INTO _CharSkill VALUES (@CharID,7520,1)
INSERT INTO _CharSkill VALUES (@CharID,7536,1)
INSERT INTO _CharSkill VALUES (@CharID,7554,1)
INSERT INTO _CharSkill VALUES (@CharID,7577,1)
INSERT INTO _CharSkill VALUES (@CharID,7582,1)
INSERT INTO _CharSkill VALUES (@CharID,7584,1)
INSERT INTO _CharSkill VALUES (@CharID,7596,1)
INSERT INTO _CharSkill VALUES (@CharID,7612,1)
INSERT INTO _CharSkill VALUES (@CharID,7637,1)
INSERT INTO _CharSkill VALUES (@CharID,7651,1)
INSERT INTO _CharSkill VALUES (@CharID,7672,1)
INSERT INTO _CharSkill VALUES (@CharID,7675,1)
INSERT INTO _CharSkill VALUES (@CharID,7688,1)
INSERT INTO _CharSkill VALUES (@CharID,7798,1)
INSERT INTO _CharSkill VALUES (@CharID,7805,1)
INSERT INTO _CharSkill VALUES (@CharID,7829,1)
INSERT INTO _CharSkill VALUES (@CharID,7838,1)
INSERT INTO _CharSkill VALUES (@CharID,7839,1)
INSERT INTO _CharSkill VALUES (@CharID,7853,1)
INSERT INTO _CharSkill VALUES (@CharID,7862,1)
INSERT INTO _CharSkill VALUES (@CharID,7877,1)
INSERT INTO _CharSkill VALUES (@CharID,7881,1)
INSERT INTO _CharSkill VALUES (@CharID,7894,1)
INSERT INTO _CharSkill VALUES (@CharID,7899,1)
INSERT INTO _CharSkill VALUES (@CharID,7907,1)
INSERT INTO _CharSkill VALUES (@CharID,7919,1)
INSERT INTO _CharSkill VALUES (@CharID,7931,1)
INSERT INTO _CharSkill VALUES (@CharID,7938,1)
INSERT INTO _CharSkill VALUES (@CharID,7947,1)
INSERT INTO _CharSkill VALUES (@CharID,7953,1)
INSERT INTO _CharSkill VALUES (@CharID,7959,1)
INSERT INTO _CharSkill VALUES (@CharID,7962,1)
INSERT INTO _CharSkill VALUES (@CharID,7972,1)
INSERT INTO _CharSkill VALUES (@CharID,7980,1)
INSERT INTO _CharSkill VALUES (@CharID,7995,1)
INSERT INTO _CharSkill VALUES (@CharID,7997,1)
INSERT INTO _CharSkill VALUES (@CharID,8010,1)
INSERT INTO _CharSkill VALUES (@CharID,8024,1)
INSERT INTO _CharSkill VALUES (@CharID,8050,1)
INSERT INTO _CharSkill VALUES (@CharID,8084,1)
INSERT INTO _CharSkill VALUES (@CharID,8097,1)
INSERT INTO _CharSkill VALUES (@CharID,8103,1)
INSERT INTO _CharSkill VALUES (@CharID,8109,1)
INSERT INTO _CharSkill VALUES (@CharID,8115,1)
INSERT INTO _CharSkill VALUES (@CharID,8119,1)
INSERT INTO _CharSkill VALUES (@CharID,8129,1)
INSERT INTO _CharSkill VALUES (@CharID,8133,1)
INSERT INTO _CharSkill VALUES (@CharID,8142,1)
INSERT INTO _CharSkill VALUES (@CharID,8150,1)
INSERT INTO _CharSkill VALUES (@CharID,8164,1)
INSERT INTO _CharSkill VALUES (@CharID,8171,1)
INSERT INTO _CharSkill VALUES (@CharID,8183,1)
INSERT INTO _CharSkill VALUES (@CharID,8195,1)
INSERT INTO _CharSkill VALUES (@CharID,8204,1)
INSERT INTO _CharSkill VALUES (@CharID,8214,1)
INSERT INTO _CharSkill VALUES (@CharID,8220,1)
INSERT INTO _CharSkill VALUES (@CharID,8221,1)
INSERT INTO _CharSkill VALUES (@CharID,8238,1)
INSERT INTO _CharSkill VALUES (@CharID,8239,1)
INSERT INTO _CharSkill VALUES (@CharID,8250,1)
INSERT INTO _CharSkill VALUES (@CharID,8253,1)
INSERT INTO _CharSkill VALUES (@CharID,8276,1)
INSERT INTO _CharSkill VALUES (@CharID,8291,1)
INSERT INTO _CharSkill VALUES (@CharID,8304,1)
INSERT INTO _CharSkill VALUES (@CharID,8316,1)
INSERT INTO _CharSkill VALUES (@CharID,8320,1)
INSERT INTO _CharSkill VALUES (@CharID,8338,1)
INSERT INTO _CharSkill VALUES (@CharID,8347,1)
INSERT INTO _CharSkill VALUES (@CharID,8348,1)
INSERT INTO _CharSkill VALUES (@CharID,8361,1)
INSERT INTO _CharSkill VALUES (@CharID,8370,1)
INSERT INTO _CharSkill VALUES (@CharID,8379,1)
INSERT INTO _CharSkill VALUES (@CharID,8383,1)
INSERT INTO _CharSkill VALUES (@CharID,8390,1)
INSERT INTO _CharSkill VALUES (@CharID,8399,1)
INSERT INTO _CharSkill VALUES (@CharID,8405,1)
INSERT INTO _CharSkill VALUES (@CharID,8410,1)
INSERT INTO _CharSkill VALUES (@CharID,8414,1)
INSERT INTO _CharSkill VALUES (@CharID,8416,1)
INSERT INTO _CharSkill VALUES (@CharID,20494,1)
INSERT INTO _CharSkill VALUES (@CharID,20497,1)
INSERT INTO _CharSkill VALUES (@CharID,20500,1)
INSERT INTO _CharSkill VALUES (@CharID,21215,1)
INSERT INTO _CharSkill VALUES (@CharID,21217,1)
INSERT INTO _CharSkill VALUES (@CharID,30578,1)
INSERT INTO _CharSkill VALUES (@CharID,30584,1)
INSERT INTO _CharSkill VALUES (@CharID,30590,1)
INSERT INTO _CharSkill VALUES (@CharID,30596,1)
INSERT INTO _CharSkill VALUES (@CharID,30600,1)

TYKE 09-03-2013 02:46 PM
هو بيتفتح بس اسكلات 120 وانت تمكسها
ثانيا ممكن تخليه 5 مليون من تابل sro_vt_shard
روح تابل char وتعدل صحتك

اسلام محمود 07-05-2018 03:15 PM
رد: عاوز Query يفتح كل الاسكلات
 
اشكركم ^_^ <3


الساعة الآن 11:47 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions, Inc.