Remove uniques

[ikosmin2018]

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

[#HB]

Spot delete:

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:

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.

[ikosmin2018]

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

[#HB]

You're welcome bud. Try to dodge any mockery/sarcasm from people about your question.

[iAmAndrew]

Originally Posted by #HB

Spot delete:

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:

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!

[#HB]

Originally Posted by dekortwo

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.

[iAmAndrew]

Originally Posted by #HB

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!

Originally Posted by #HB

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!

[iAmAndrew]

Originally Posted by dekortwo

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+

[suntrockdinokna]

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'))