Remove uniques

11/20/2018 13:06 ikosmin2018#1
Hello guys

Can someone tell me how to remove some custom uniques that i put earlier into the game?i don't need them anymore

Or at least redirect me to a good query or a method

Thx alot
11/20/2018 13:34 #HB#2
Spot delete:
Code:
USE [SRO_VT_SHARD]
declare #MobCode varchar(max) = 'MOB_CODE'

DELETE nest from [dbo].[Tab_RefNest] as nest 
join [dbo].[Tab_RefTactics] as tact on nest.dwTacticsID = tact.dwTacticsID
join [dbo].[_RefObjCommon] as com on tact.dwObjID = com.ID
where com.CodeName128 like #MobCode and com.Rarity in (3,8)
Permanent delete:
Code:
USE [SRO_VT_SHARD]
declare #MobCode varchar(max) = 'MOB_CODE'

DELETE nest from [dbo].[Tab_RefNest] as nest 
join [dbo].[Tab_RefTactics] as tact on nest.dwTacticsID = tact.dwTacticsID
join [dbo].[_RefObjCommon] as com on tact.dwObjID = com.ID
where com.CodeName128 like #MobCode and com.Rarity in (3,8)

UPDATE com set com.Service = 0 from [dbo].[_RefObjCommon] as com where com.CodeName128 like #MobCode
Replace any "#" with "@", I did that to dodge EPVP's mentioning system.
11/20/2018 22:44 ikosmin2018#3
Thank you very much.I have to tell you i expected sarcasm and irony instead of answers but i'm glad to see there are still good people around here.Tnx again
11/20/2018 23:41 #HB#4
You're welcome bud. Try to dodge any mockery/sarcasm from people about your question.
04/18/2019 16:50 iAmAndrew#5
Quote:
Originally Posted by #HB View Post
Spot delete:
Code:
USE [SRO_VT_SHARD]
declare #MobCode varchar(max) = 'MOB_CODE'

DELETE nest from [dbo].[Tab_RefNest] as nest 
join [dbo].[Tab_RefTactics] as tact on nest.dwTacticsID = tact.dwTacticsID
join [dbo].[_RefObjCommon] as com on tact.dwObjID = com.ID
where com.CodeName128 like #MobCode and com.Rarity in (3,8)
Permanent delete:
Code:
USE [SRO_VT_SHARD]
declare #MobCode varchar(max) = 'MOB_CODE'

DELETE nest from [dbo].[Tab_RefNest] as nest 
join [dbo].[Tab_RefTactics] as tact on nest.dwTacticsID = tact.dwTacticsID
join [dbo].[_RefObjCommon] as com on tact.dwObjID = com.ID
where com.CodeName128 like #MobCode and com.Rarity in (3,8)

UPDATE com set com.Service = 0 from [dbo].[_RefObjCommon] as com where com.CodeName128 like #MobCode
Replace any "#" with "@", I did that to dodge EPVP's mentioning system.
sorry my noob question, that permanent query that means even if i try to make that unique on gm console will not work?

thanks!
04/18/2019 17:28 #HB#6
Quote:
Originally Posted by dekortwo View Post
sorry my noob question, that permanent query that means even if i try to make that unique on gm console will not work?

thanks!
Nah, permanent means disabling the unique, so it won't be defined in the GS objects anymore.
04/18/2019 17:37 iAmAndrew#7
Quote:
Originally Posted by #HB View Post
Nah, permanent means disabling the unique, so it won't be defined in the GS objects anymore.
ok so if i want to remove the unique from a certain place (spot) i need to use the other query! thanks for help!

Quote:
Originally Posted by #HB View Post
Nah, permanent means disabling the unique, so it won't be defined in the GS objects anymore.
hey mate, i use the query but i have received this error

'' Msg 155, Level 15, State 2, Line 2
'varchar' is not a recognized CURSOR option. ''

any sugestion? thanks!
04/22/2019 04:38 iAmAndrew#8
Quote:
Originally Posted by dekortwo View Post
ok so if i want to remove the unique from a certain place (spot) i need to use the other query! thanks for help!



hey mate, i use the query but i have received this error

'' Msg 155, Level 15, State 2, Line 2
'varchar' is not a recognized CURSOR option. ''

any sugestion? thanks!
up+
07/30/2019 11:27 suntrockdinokna#9
use this query better

USE [SRO_VT_SHARD]
Update Tab_RefNest Set
fLocalPosX=NULL ,
fLocalPosY=NULL ,
fLocalPosZ=NULL
WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID =
(SELECT ID FROM _RefObjCommon WHERE Codename128 like 'YOUR MOB CODE NAME'))