SQL for Unfearable Mobs 65+

[Jibbatwinkers]

Hi other developers, Jibbatwinkers here from over at the Zebuxoruk server. Alot of the coding and development we do is pretty custom so I can't see much of it being of use. One of the great guides over at my server Validus/Lanik constructed this SQL query to help with the fear exploitation that goes on with alot of servers. He is pretty good at this stuff and I thank him very much.

This SQL query will:
Add MCND (Unmezable, Uncharmable, Unstunable, Unfearable) to all mobs 65+, feel free to modify it to whatever level you want.
This will not remove the special attacks that were there previously. First it removes all MCND or mcnd and then adds it, ensuring no duplicates.

I hope this helps, follow the instructions or your results will be very eradic. Make sure you backup your stuff first. We did it on 2 different DB's without any problems.

The following code removes existing M,C,N, or D tags (upper or lower) from all mobs 65 and above. Running these commands all at once makes only the last line take affect. You'll have to run them separately in order for them to all process.

Code:

UPDATE npc_types SET npcspecialattks=INSERT(npcspecialattks,INSTR(npcsp ecialattks,'M'),1,'') WHERE level>=65;
UPDATE npc_types SET npcspecialattks=INSERT(npcspecialattks,INSTR(npcsp ecialattks,'C'),1,'') WHERE level>=65;
UPDATE npc_types SET npcspecialattks=INSERT(npcspecialattks,INSTR(npcsp ecialattks,'N'),1,'') WHERE level>=65;
UPDATE npc_types SET npcspecialattks=INSERT(npcspecialattks,INSTR(npcsp ecialattks,'D'),1,'') WHERE level>=65;
UPDATE npc_types SET npcspecialattks=INSERT(npcspecialattks,INSTR(npcsp ecialattks,'m'),1,'') WHERE level>=65;
UPDATE npc_types SET npcspecialattks=INSERT(npcspecialattks,INSTR(npcsp ecialattks,'c'),1,'') WHERE level>=65;
UPDATE npc_types SET npcspecialattks=INSERT(npcspecialattks,INSTR(npcsp ecialattks,'n'),1,'') WHERE level>=65;
UPDATE npc_types SET npcspecialattks=INSERT(npcspecialattks,INSTR(npcsp ecialattks,'d'),1,'') WHERE level>=65;


And the following code is what adds back all four letter codes to make all npcs level 65 and above unMezable, unCharmable, unstuNable, and unfearable.

Code:

UPDATE npc_types SET npcspecialattks=UPPER(CONCAT(npcspecialattks,'MCND ')) WHERE level>=65;


After that last SQL has finished, all npcs 65+ should be unfearable.