how to remove Uniques?

hey guys, well i have a dB that is to overedited lol, and have like more then 20 new uniques in random spots, how do i remove them? i search already about that but i look to some querys and they simple dont work dont know why

any sugestion?

Remove unique from the DB using this query: D
USE [SRO_VT_SHARD]
delete Tab_RefNest where dwTacticsID = '33' ---hotinh
delete Tab_RefNest where dwTacticsID = '63' ---olote
delete Tab_RefNest where dwTacticsID = '113' --BCN
delete Tab_RefNest where dwTacticsID = '154' --yakhan
delete Tab_RefNest where dwTacticsID = '185' --sythan
delete Tab_RefNest where dwTacticsID = '26600' --lyvy
delete Tab_RefNest where dwTacticsID = '33500' --BLX
delete Tab_RefNest where dwTacticsID = '46077' -- nhen klo 60
delete Tab_RefNest where dwTacticsID = '46075' --hinh thien lv40
delete Tab_RefNest where dwTacticsID = '46082' --han a 80
delete Tab_RefNest where dwTacticsID = '229' --cho ba dau
delete Tab_RefNest where dwTacticsID = '46074' --ho Trang 100
delete Tab_RefNest where dwTacticsID = '32200' --phu quynh tuong quan lv 88
delete Tab_RefNest where dwTacticsID = '32300' --luu hao tuong quan 89
delete Tab_RefNest where dwTacticsID = '32400' -- ho phi tuong quan 90
delete Tab_RefNest where dwTacticsID = '32100' --- huyen lang tuong quan lv 85
delete Tab_RefNest where dwTacticsID = '32500' -- xa lan khi 95
delete Tab_RefNest where dwTacticsID = '32600' -- thien xa lan 95
delete Tab_RefNest where dwTacticsID = '32700' -- xa lan luat
delete Tab_RefNest where dwTacticsID = '32800' -- lao xa lan
delete Tab_RefNest where dwTacticsID like '46076' --HauVuogPhu
delete Tab_RefNest where dwTacticsID like '46081' --Ganiazo
---delete Tab_RefNest where dwTacticsID = '32100'
delete Tab_RefNest where dwTacticsID like '46080' --nguoi khong lo 1 mat 30
delete Tab_RefNest where dwTacticsID like '46078' --Battli Golem 50
delete Tab_RefNest where dwTacticsID like '46079' --o den 90
Viet them
select * from _RefObjCommon where NameStrID128 like 'SN_MOB_RM_TAHOMET_L3'
--update _RefObjCommon set Service = '1' where NameStrID128 like 'SN_MOB_CH_TIGERWOMAN_L3'
--update _RefObjCommon set Service = '1' where NameStrID128 like 'SN_MOB_OA_URUCHI_L3'
--update _RefObjCommon set Service = '1' where NameStrID128 like 'SN_MOB_KK_ISYUTARU_L3'
--update _RefObjCommon set Service = '1' where NameStrID128 like 'SN_MOB_TK_BONELORD_L3'
--update _RefObjCommon set Service = '1' where NameStrID128 like 'SN_MOB_RM_TAHOMET_L3'
select * from _RefObjChar where ID like '2112'
--select * from Tab_RefNest where dwTacticsID like '7551'
update _RefObjChar set ExpToGive = '1' where ID like '2110' --9927327 yakhan
update _RefObjChar set MaxHP = '980591360' where ID like '2110' --28059136 yakhan
update _RefObjChar set ExpToGive = '1' where ID like '2104' --902400 ho tinh
update _RefObjChar set MaxHP = '980591360' where ID like '2104' --1796159 ho tinh
update _RefObjChar set ExpToGive = '1' where ID like '2106' --2632394 olote
update _RefObjChar set MaxHP = '980591360' where ID like '2106' --5338585 olote
update _RefObjChar set ExpToGive = '1' where ID like '2108' --5496520 BCN
update _RefObjChar set MaxHP = '980591360' where ID like '2108' --12973835 BCN
update _RefObjChar set ExpToGive = '1' where ID like '2112' --13341498 satang
update _RefObjChar set MaxHP = '980591360' where ID like '2112' --38196181 satang

Quote:

Originally Posted by srothanglong Remove unique from the DB using this query: D USE [SRO_VT_SHARD] delete Tab_RefNest where dwTacticsID = '33' ---hotinh delete Tab_RefNest where dwTacticsID = '63' ---olote delete Tab_RefNest where dwTacticsID = '113' --BCN delete Tab_RefNest where dwTacticsID = '154' --yakhan delete Tab_RefNest where dwTacticsID = '185' --sythan delete Tab_RefNest where dwTacticsID = '26600' --lyvy delete Tab_RefNest where dwTacticsID = '33500' --BLX delete Tab_RefNest where dwTacticsID = '46077' -- nhen klo 60 delete Tab_RefNest where dwTacticsID = '46075' --hinh thien lv40 delete Tab_RefNest where dwTacticsID = '46082' --han a 80 delete Tab_RefNest where dwTacticsID = '229' --cho ba dau delete Tab_RefNest where dwTacticsID = '46074' --ho Trang 100 delete Tab_RefNest where dwTacticsID = '32200' --phu quynh tuong quan lv 88 delete Tab_RefNest where dwTacticsID = '32300' --luu hao tuong quan 89 delete Tab_RefNest where dwTacticsID = '32400' -- ho phi tuong quan 90 delete Tab_RefNest where dwTacticsID = '32100' --- huyen lang tuong quan lv 85 delete Tab_RefNest where dwTacticsID = '32500' -- xa lan khi 95 delete Tab_RefNest where dwTacticsID = '32600' -- thien xa lan 95 delete Tab_RefNest where dwTacticsID = '32700' -- xa lan luat delete Tab_RefNest where dwTacticsID = '32800' -- lao xa lan delete Tab_RefNest where dwTacticsID like '46076' --HauVuogPhu delete Tab_RefNest where dwTacticsID like '46081' --Ganiazo ---delete Tab_RefNest where dwTacticsID = '32100' delete Tab_RefNest where dwTacticsID like '46080' --nguoi khong lo 1 mat 30 delete Tab_RefNest where dwTacticsID like '46078' --Battli Golem 50 delete Tab_RefNest where dwTacticsID like '46079' --o den 90 Viet them select * from _RefObjCommon where NameStrID128 like 'SN_MOB_RM_TAHOMET_L3' --update _RefObjCommon set Service = '1' where NameStrID128 like 'SN_MOB_CH_TIGERWOMAN_L3' --update _RefObjCommon set Service = '1' where NameStrID128 like 'SN_MOB_OA_URUCHI_L3' --update _RefObjCommon set Service = '1' where NameStrID128 like 'SN_MOB_KK_ISYUTARU_L3' --update _RefObjCommon set Service = '1' where NameStrID128 like 'SN_MOB_TK_BONELORD_L3' --update _RefObjCommon set Service = '1' where NameStrID128 like 'SN_MOB_RM_TAHOMET_L3' select * from _RefObjChar where ID like '2112' --select * from Tab_RefNest where dwTacticsID like '7551' update _RefObjChar set ExpToGive = '1' where ID like '2110' --9927327 yakhan update _RefObjChar set MaxHP = '980591360' where ID like '2110' --28059136 yakhan update _RefObjChar set ExpToGive = '1' where ID like '2104' --902400 ho tinh update _RefObjChar set MaxHP = '980591360' where ID like '2104' --1796159 ho tinh update _RefObjChar set ExpToGive = '1' where ID like '2106' --2632394 olote update _RefObjChar set MaxHP = '980591360' where ID like '2106' --5338585 olote update _RefObjChar set ExpToGive = '1' where ID like '2108' --5496520 BCN update _RefObjChar set MaxHP = '980591360' where ID like '2108' --12973835 BCN update _RefObjChar set ExpToGive = '1' where ID like '2112' --13341498 satang update _RefObjChar set MaxHP = '980591360' where ID like '2112' --38196181 satang

lol you wrong.

up