[SQL-Resource] [All Expansions] Remove Dungeon Deserter Debuff

[Dracythyr]

To remove the Dungeon Deserter Debuff spells you have to go into your World Database and manually add the spells to your 'disables' table. But instead of manually looking for the spell I made a quick query to disable it for you.


Here is a step-by-step guide on how to achieve this :

1. Login into your Database either using HeidiSQL ( Recommended ) or another Database access interface.
2. Locate your world database.
3. Click the query tab and input this

4. INSERT INTO `disables` VALUES (0, 71041, 1, '', '', 'Disable Dungeon Deserter');
   INSERT INTO `disables` VALUES (0, 144075, 1, '', '', 'Disable Dungeon Deserter Part 2');
   INSERT INTO `disables` VALUES (0, 71328, 1, '', '', 'Disable Dungeon Deserter Part 3');

5. Run the query.
6. Restart your server.
7. Have fun.

This will insert values into your World Database 'disables' table, and will disable the spells. You can do this with any spell as long as you have the spell ID. You can locate this on wowhead, or a respected wow database for your expansion.

 

[davidpere]

buen aporte

 

[Nakyang]

Can't you just modify this

to 0 ? it's in mop_auth => config.

 

[Apheleos]

Thanks for sharing !

 

[Dread1313]

To remove the Dungeon Deserter Debuff spells you have to go into your World Database and manually add the spells to your 'disables' table. But instead of manually looking for the spell I made a quick query to disable it for you.


Here is a step-by-step guide on how to achieve this :

1. Login into your Database either using HeidiSQL ( Recommended ) or another Database access interface.
2. Locate your world database.
3. Click the query tab and input this

4. INSERT INTO `disables` VALUES (0, 71041, 1, '', '', 'Disable Dungeon Deserter');
   INSERT INTO `disables` VALUES (0, 144075, 1, '', '', 'Disable Dungeon Deserter Part 2');
   INSERT INTO `disables` VALUES (0, 71328, 1, '', '', 'Disable Dungeon Deserter Part 3');

5. Run the query.
6. Restart your server.
7. Have fun.

This will insert values into your World Database 'disables' table, and will disable the spells. You can do this with any spell as long as you have the spell ID. You can locate this on wowhead, or a respected wow database for your expansion.

You are a literal saint bro, THANK YOU <3