Turn off the ability for mobs to summon players

[strider51]

Hi Guys, on my solo server I'd like to remove the mob summon from the game. Anyone know the right database entries for this ??

thanks much!

[Akkadius]

Originally Posted by strider51

Hi Guys, on my solo server I'd like to remove the mob summon from the game. Anyone know the right database entries for this ??

thanks much!

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

[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.

[provocating]

Yes, there was a major change months (8++) back on special attacks. Looks like you got it though.

[Chakan]

Hello,
I'm dying to rid my little server of the scourge that is chain NPC summon but this code:

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

doesn't work. I get an SQL error truncated incorrect double value '0'.

Any help would be greatly appreciated,

[GRUMPY]

Remove the 0, from set special_abilities = '0,' so you just use ' ' (like below).
Works, removing over 4K entries :P

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