View Single Post
  #2  
Old 11-23-2021, 05:58 PM
Splose
Banned
 
Join Date: Apr 2014
Posts: 279
Default

Quote:
Originally Posted by Ishkur View Post
Hello All,

I play on a solo private server and one thing I do not like is having to wait for roots or charms to break on me so I can continue on my way. I found a way to make myself immune to fear and stuns via AA to eliminate some of this headache but I don't see one for Root or Charms.

What would be the best way to make players immune to roots and charms? Some folks said to remove the spells from NPC spell lists and some said to use AA or maybe spell buffs?

I am pretty new at anything modifying spells or spell lists but AA I have a decent grasp on.

Please advise any help is greatly appreciated thanks!!!
Code:
SELECT
	npc_spells_entries.id,
	npc_spells_entries.npc_spells_id,
	npc_spells_entries.spellid,
	npc_spells_entries.type,
	npc_spells_entries.minlevel,
	npc_spells_entries.maxlevel,
	npc_spells_entries.manacost,
	npc_spells_entries.recast_delay,
	npc_spells_entries.priority,
	npc_spells_entries.resist_adjust,
	npc_spells_entries.min_hp,
	npc_spells_entries.max_hp 
FROM
	npc_spells_entries
	INNER JOIN spells_new ON npc_spells_entries.spellid = spells_new.id 
WHERE
	( spell_category = 101 OR spell_category = 50 );
Delete everything that you get back from this query. It will stop NPCs from casting roots or snares entirely. There may be a negligible amount of spells that do not have the category set properly but this should work for 99.9999% of cases.
Reply With Quote