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
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
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
[Request Help] Remove mobs / remove eur items / remove npc 02/15/2013 - SRO Private Server - 0 Replies Iam sure all now saies this guy is mad :D why not remove the db
i want to know how i can remove mobs from samrkand and add alex mobs there and remove eur item from npc and drobs
and remove some npcs
ty guys
_________________________
I see that there is too much help here
it's my topic no.2
without any answer
WTT UNIQUES ITEMS ETC ON DERI FOR THINGS AND UNIQUES ON GRACIA!!!!!!!!!!!!!!!!! 07/27/2011 - Archlord Trading - 0 Replies GUYs !
I have ON DERIBELLE BEST realms with ashtals and lvl 5 stones for sorc / knight
many cast rings and crit rings with ring spirit stones lvl 2,3,4,
cloak lvl 6 but in nec and wings etc
many stones
some wp toas and so on
BIGLOS 2 SLOT with LVL 5 CLOAK AND LVL 4 ANGEL WINGS spiral rings , shuta
and some other good items and very nice weaps for knight and sorc .
FORRRRRR things or 1-2 uniques on GRACIA/STULL/TULLAN SERVER
wts uniques on archon/brumhart for uniques or wp on stull 05/02/2011 - Archlord Trading - 8 Replies eu3 wts kark with lvl 1 cloak >>>> 3 scrolls stull or kark
archon wts brilliant gaurdimesh >>> 2 scrolls stull
barom ring x2 >>> 1 scroll + gold stull
kark lvl 2 ele cloak >> 2 scrolls stull
luke lvl 4 ele cloak >>> 2 scrolls stull
WTT Uniques on Deribelle for Uniques on Archon 11/22/2010 - Archlord Trading - 0 Replies Hello all, so i wanna trade some uniques on Deribelle for the same ones or maybe diferents one on Sylvia.
1x Intelligent Shuta
1x Shuta
1x Intelligent Karkaen
2x Blode
Cheers
hi WTT uniques in brumh for uniques in even 01/05/2010 - Archlord Trading - 0 Replies hi i have biglos lvl 5 wings 2 red sing 1 okheros 1 podon 1 haul 1 logo 1 fortune i wana trade for uniques in evengarda im serius no scammer send me a mail if you need trading tks.
how to remove Uniques?
