Changing special attacks quickly

[Secrets]

Think this would be it...

UPDATE `npc_types` SET `npcspecialattks`='F' WHERE `level` > 35 AND level < 65

Would set the flag 'F' in the field `npcspecialattks` where the level is 36-64.

[Sprig]

I did some testing with that syntax, it replaces the entire string which isnt exactly what I was looking for but still saved me a ton of time since with some minor changes It allowed me to at least make all npcs with no special attacks immune to fleeing. turning off the for summon charm and snare wont be nearly as bad to do manually as turning on the one to prevent fleeing for the thousands of fields that are in that table.

-thanks

[GeorgeS]

I don't have a one line solution either. There's a way with PLSQL i'm told, but the way I do this is with vb code. If you want I can write something fast to do this later in VB


GeorgeS

[Sprig]

That would be great. I have my special attacks set the way i want them for now but will likely be needing to do similar changes in the future in other areas.

-sprig

[sfisque]

Originally Posted by Secrets

Think this would be it...

UPDATE `npc_types` SET `npcspecialattks`='F' WHERE `level` > 35 AND level < 65

Would set the flag 'F' in the field `npcspecialattks` where the level is 36-64.

mysql supports a concat function, you might be able to use something like:

UPDATE `npc_types` 
        SET `npcspecialattks`= concat( `npcspecialattks`, 'F' ) 
        WHERE `level` > 35 AND level < 65 
        AND `npcspecialattks` not like '%F%'

[GeorgeS]

Ok here's a zip of the program that does this

http://66.159.225.58/eqemu/special_attacks_mod.zip


GeorgeS

[Sprig]

thank you for the tool =)
-sprig