How i can disabled Dimensional Pilar?

[seriouscos]

i added mobs drop diennsional hole and i want disabled dimensional pilar cuz envy kill all player how i can disabled dimensional pilar spawn?

[​Goofie​]

Test this:

PHP Code:

UPDATE _RefObjCommon set Service = 0 where CodeName128 like '%PILLAR%'

DELETE FROM Tab_RefTactics where dwTacticsID in (

43800,
43810,
43820,
43830,
43840,
43850,
43860
);


DELETE FROM _RefMonster_AssignedItemDrop where RefMonsterID in (SELECT id FROM _RefObjCommon where CodeName128 like '%PILLAR%'
)


DELETE FROM _RefCustomizingReservedItemDropForMonster where RefMonsterID in (SELECT id FROM _RefObjCommon where CodeName128 like '%PILLAR%') 


Make database backup, tested on my server and no errors on starting, u need to check if they disappeared.

[VintageSro]

next time you can find this query in the forum i already release it

[​Goofie​]

Originally Posted by VintageSro

next time you can find this query in the forum i already release it

So my query = working?

[VintageSro]

yes its working also but i made it some kind of different

[seriouscos]

no works.. i get this error

 Spoiler

Msg 208, Level 16, State 1, Line 1
Invalid object name '_RefObjCommon'.

[WickedNite.]

Originally Posted by seriouscos

no works.. i get this error

 Spoiler

Msg 208, Level 16, State 1, Line 1
Invalid object name '_RefObjCommon'.

Then use it in the correct database aka shard, or simply write at the beginning USE [SRO_VT_SHARD] or w/e your db name is.