[Guide] Fixing Medusa duplicated spawn

[dyandro]

Hi guys,
basically disable the spawn of Medusa in the database and let the GameServer work!
The event is hardcoded in GameServer not needing so set it to spawn it. Just configure the Schedule by SMC and it will work perfectly.
For those who do not know how to disable a mob spawn, follow these steps:

1 - Find the mobs in _RefObjCommon table;

USE SRO_VT_SHARD
SELECT ID, CodeName128
  FROM _RefObjCommon
WHERE CodeName128 = 'MOB_TQ_NORTHGUARDIAN' or CodeName128 = 'MOB_TQ_SOUTHGUARDIAN'
or CodeName128 = 'MOB_TQ_WESTGUARDIAN' or CodeName128 = 'MOB_TQ_EASTGUARDIAN'
or CodeName128 = 'MOB_TQ_BLACKSNAKE' or CodeName128 = 'MOB_TQ_FLAMEMASTER'
or CodeName128 = 'MOB_TQ_WHITESNAKE'
order by ID

2 - Find the mobs in _Tab_RefTactics table;

USE SRO_VT_SHARD
SELECT dwTacticsID, dwObjID
  FROM Tab_RefTactics
WHERE dwObjID BETWEEN 14991 AND 14997

3 - Find the mobs in Tab_RefNest table;

USE SRO_VT)SHARD
SELECT dwNestID, dwTacticsID, dwMaxTotalCount
  FROM Tab_RefNest
WHERE dwTacticsID IN (32900, 33000, 33100, 33200, 33300, 33400, 33500)

4 - Change value of dwMaxTotalCount for 0;

USE SRO_VT_SHARD
UPDATE Tab_RefNest
   SET dwMaxTotalCount = 0
 WHERE dwTacticsID IN (32900, 33000, 33100, 33200, 33300, 33400, 33500)

I showed all these steps so that you can follow to find any mob and change the amount. There are some guides here on the forum teaching change the amount of mobs and I give full credit to them, because in the beginning I also learned from them.
Besides these uniques still inside the event will have some other duplicates, then simply find their name in the database and follow the same steps described here to find them and disabled.
For the more experienced, you probably noticed, instead of reducing the amount of mobs to 0, you can simply delete them, but as I do not like deleting anything for future reference, so feel free to perform the action of greater liking for you.
I hope you enjoyed!
I am very grateful to the entire community that always helps contribute some releases, fixes and guides that help us learn more about how to work with files and databases without any documentation available for obvious reasons!

[PortalDark]

#Approved

[Power Road]

niceeeeeeeeeeeeeeeeeeee

[Hamza FiGo]

Up, (Useful thread). Ty

[​Goofie​]

Originally Posted by hamzafigo

Up, (Useful thread). Ty

You deserve to be slapped, bumping a 3 year old thread .

[blapanda]

Originally Posted by ​Goofie​

You deserve to be slapped, bumping a 3 year old thread .

*Slapping* now take it and redirect that pain to the bumper #1!

[Hamza FiGo]

Originally Posted by ​Goofie​

You deserve to be slapped, bumping a 3 year old thread .

How stupid u r Goofie. You don't like helping ppl right?

That thread useful for many ppl so i upped it and its not ur business. So move ur @$$ from here if u don't like it.

[KrollyTrader]

Haha, kinda old thread but still usefull

[White Ros3]

Thanks It Is help Full

[lepitismak]

its possible to change the location?

[xxnukertube]

If U Want to See

 Spoiler

PHP Code:

SELECT * FROM Tab_RefNest 
        WHERE dwTacticsID IN (
SELECT dwTacticsID
    FROM Tab_RefTactics
        WHERE dwObjID in (
    SELECT ID
        FROM _RefObjCommon
            WHERE CodeName128 IN (
                'MOB_TQ_NORTHGUARDIAN',
                'MOB_TQ_SOUTHGUARDIAN',
                'MOB_TQ_WESTGUARDIAN',
                'MOB_TQ_EASTGUARDIAN',
                'MOB_TQ_BLACKSNAKE',
                'MOB_TQ_FLAMEMASTER',
                'MOB_TQ_WHITESNAKE'
                )
            )
        ) 


If u want to Update

 Spoiler

PHP Code:

UPDATE Tab_RefNest SET
    dwMaxTotalCount = 0
        WHERE dwTacticsID IN (
SELECT dwTacticsID
    FROM Tab_RefTactics
        WHERE dwObjID in (
    SELECT ID
        FROM _RefObjCommon
            WHERE CodeName128 IN (
                'MOB_TQ_NORTHGUARDIAN',
                'MOB_TQ_SOUTHGUARDIAN',
                'MOB_TQ_WESTGUARDIAN',
                'MOB_TQ_EASTGUARDIAN',
                'MOB_TQ_BLACKSNAKE',
                'MOB_TQ_FLAMEMASTER',
                'MOB_TQ_WHITESNAKE'
                )
            )
        ) 


Originally Posted by lepitismak

its possible to change the location?

yes