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

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

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

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

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

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