المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : كويري مومكن تحتجها

$Waxy
17-12-2012, 11:53 AM
دي شوية كويري بتفتح d14 set and weopens and accsory
و كل ال ديجري تاريبن انا العملها كولها
UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_SWORD_12%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_SWORD_12%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_TSWORD_12%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_BLADE_12%'
UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_HARP_12%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_TBLADE_12%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_CROSSBOW_12%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_BOW_12%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_DAGGER_12%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_SPEAR_12%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_SHIELD_12%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_SHIELD_12%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_DARKSTAFF_12%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_SWORD_14%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_SWORD_14%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_TSWORD_14%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_BLADE_14%'
UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_HARP_14%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_TBLADE_14%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_CROSSBOW_14%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_BOW_14%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_DAGGER_14%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_SPEAR_14%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_SHIELD_14%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_SHIELD_14%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_DARKSTAFF_14%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_STAFF_14%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_TSTAFF_14%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_AXE_14%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_SWORD_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_SWORD_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_TSWORD_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_BLADE_13%'
UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_HARP_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_TBLADE_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_CROSSBOW_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_BOW_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_DAGGER_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_SPEAR_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_SHIELD_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_SHIELD_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_DARKSTAFF_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_STAFF_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_TSTAFF_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_AXE_13%'
/*Credit To : Waxy$ Not Other >> Dont Re Release Under Your Name*/


UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_EU_M_HEAVY_14%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_CH_M_HEAVY_14%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_EU_W_HEAVY_14%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_CH_W_HEAVY_14%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_EU_M_LIGHT_14%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_CH_M_LIGHT_14%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_EU_W_LIGHT_14%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_CH_W_LIGHT_14%'
UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_EU_M_CLOTHES_14%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_CH_M_CLOTHES_14%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_EU_W_CLOTHES_14%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_EU_W_CLOTHES_14%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_EU_M_HEAVY_13%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_CH_M_HEAVY_13%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_EU_W_HEAVY_13%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_CH_W_HEAVY_13%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_EU_M_LIGHT_13%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_CH_M_LIGHT_13%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_EU_W_LIGHT_13%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_CH_W_LIGHT_13%'
UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_EU_M_CLOTHES_13%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_CH_M_CLOTHES_13%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_EU_W_CLOTHES_13%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_CH_W_CLOTHES_13%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_EU_M_HEAVY_12%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_CH_M_HEAVY_12%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_EU_W_HEAVY_12%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_CH_W_HEAVY_12%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_EU_M_LIGHT_12%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_CH_M_LIGHT_12%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_EU_W_LIGHT_12%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_CH_W_LIGHT_12%
'
UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_EU_M_CLOTHES_12%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_CH_M_CLOTHES_12%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_EU_W_CLOTHES_12%'

UPDATE [dbo].[_RefObjCommon]
set service = 1
WHERE CodeName128 like '%ITEM_CH_W_CLOTHES_12%'
/*Credit To : Waxy$ Not Other Dont Re Release Under Your Name*/
UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_RING_14%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_RING_14%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_EARRING_14%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_EARRING_14%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_NECKLACE_14%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_NECKLACE_14%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_RING_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_RING_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_EARRING_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_EARRING_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_NECKLACE_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_NECKLACE_13%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_RING_12%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_RING_12%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_EARRING_12%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_EARRING_12%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU_NECKLACE_12%'

UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH_NECKLACE_12%'
/*Credit To : Waxy$ Not Other >> Dont Re Release Under Your Name*/


Stone query
UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_STR_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_INT_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_DUR_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_LUCK_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_HR_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_EVADE_BLOCK_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_EVADE_CRITICAL_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_HP_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_MP_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_FROSTBITE_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_ESHOCK_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_BURN_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_POISON_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_ZOMBIE_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_ATHANASIA_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_SOLID_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_ASTRAL_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_PA_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_PASTR_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_MA_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_MAINT_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_CRITICAL_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_HR_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_PD_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_PDSTR_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_MD_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_MDINT_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_ER_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_BR_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_PAR_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_MAR_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_STR_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_INT_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_DUR_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_HR_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_EVADE_BLOCK_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_EVADE_CRITICAL_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_ER_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_HP_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_MP_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_FROSTBITE_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_ESHOCK_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_BURN_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_POISON_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_ZOMBIE_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_ATHANASIA_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_SOLID_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_LUCK_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_ASTRAL_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_PA_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_PASTR_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_MA_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_MAINT_13%'
UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_CRITICAL_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_HR_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_PD_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_PDSTR_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_MD_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_MDINT_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_ER_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_BR_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_PAR_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_MAR_13%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_STR_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_INT_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_DUR_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_LUCK_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_HR_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_EVADE_BLOCK_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_EVADE_CRITICAL_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_HP_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_MP_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_FROSTBITE_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_ESHOCK_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_BURN_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_POISON_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_ZOMBIE_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_ATHANASIA_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_SOLID_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICTABLET_ASTRAL_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_PA_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_PASTR_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_MA_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_MAINT_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_CRITICAL_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_HR_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_PD_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_PDSTR_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_MD_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_MDINT_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_ER_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_BR_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_PAR_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRTABLET_MAR_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_STR_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_INT_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_DUR_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_HR_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_EVADE_BLOCK_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_EVADE_CRITICAL_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_ER_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_HP_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_MP_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_FROSTBITE_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_ESHOCK_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_BURN_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_POISON_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_ZOMBIE_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_ATHANASIA_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_SOLID_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_LUCK_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_MAGICSTONE_ASTRAL_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_PA_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_PASTR_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_MA_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_MAINT_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_CRITICAL_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_HR_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_PD_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_PDSTR_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_MD_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_MDINT_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_ER_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_BR_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_PAR_12%'

UPDATE [dbo].[_RefObjCommon]
Set Service = 1
Where CodeName128 like '%ITEM_ETC_ARCHEMY_ATTRSTONE_MAR_12%'
/*Credit To : Waxy$ Not Other >> Dont Re Release Under Your Name*/
●♥ Marwan1337 ♥●
17-12-2012, 12:06 PM
تمـــــــــــامـ , جــارى التجـــربـة ...
$Waxy
17-12-2012, 12:12 PM
تم تعديل علي كويري الاستون لو عملتو استعمل الجديد
BabiliOn
17-12-2012, 12:18 PM
بتفتحها ازاى يعنى مش فاهم ؟
$Waxy
17-12-2012, 12:22 PM
بتوفر التعب من الاخر بتفتح السيرفيس ال 0 تخليه 1 و يا مروان لو ينفع يتسبت ده هيزبت الناس
●♥ Marwan1337 ♥●
17-12-2012, 12:36 PM
تـــمـ أضــافــة الــ Querys لــ █ ₪ كـــل الــQuery اللــى تحتاجهــــا هنـــــا ₪ █ (http://www.silkroad4arab.com/vb/showthread.php?p=4382084#post4382084)
$Waxy
17-12-2012, 01:05 PM
لا يا باشا لتسبتو بي اسمي لمتسبتوش خالص انت هتسبتو لي نفسك كمان انا مش موافق
ღ♥_iMoRy_♥ღ
18-12-2012, 01:51 AM
عادى مالناس كدة هتستفيد وبردو اسمك موجود تحت فى الكيورى
$Waxy
18-12-2012, 02:16 AM
شفت انا زكي ازااي حفظت اسمي بردو :hands:
CriZ
18-12-2012, 07:55 AM
لا يا باشا لتسبتو بي اسمي لمتسبتوش خالص انت هتسبتو لي نفسك كمان انا مش موافق
:111:
واحد