Turn off the ability for mobs to summon players

[mutidotpaul]

Sorry to raise the dead thread, but I tried this earlier and mobs in Kael are still summoning.

I tried to check and see (pretty sloppy, i know ):

SELECT * FROM npc_types WHERE npcspecialattks LIKE 's'
SELECT * FROM npc_types WHERE npcspecialattks LIKE 's%'
SELECT * FROM npc_types WHERE npcspecialattks LIKE '%s'
SELECT * FROM npc_types WHERE npcspecialattks LIKE '%s%'

if any were left after running the query:

UPDATE npc_types SET npcspecialattks = REPLACE(npcspecialattks, 'S', '');

, and oddly enough only a frost giant scout had it set.

After making sure none had it set, and after killing all the server processes and restarting them, and then closing my client and reopening, mobs still seem to summon.

Ok - I'm starting to see why

http://wiki.eqemulator.org/p?NPC_Special_Attacks
Changelog from 07/11/2013 -- npcspecialattks field was removed and a new field special_abilities was added. Not removing legacy information, for those that have not updated their DB yet.

So if the 1st number in the example (1,1,2,10000,90) indicates whether a mob can summon or not, how would one go about setting the 1st character in the field to 0 on all mobs?

...

Was able to knock em all out using this:

update  npc_types
set     special_abilities = '0,' + substring(special_abilities, 2, length(special_abilities)-2)
where   special_abilities like '1,%';

and it seems to work - no more summoning mobs so far!

Not quite sure how it works, but I found an example of the usage and just tailored it a little. Very much new to SQL still.