a planar projection

[epilz]

Anyone have a sql query to pull up all planar projections? Want to make them all immune to attacks.

[Akkadius]

Use the NPC editor in EOC and search for them without specifying a zone.

You can easily do what you want to do.

[epilz]

ahh thats true, thanks akka.....

[epilz]

So much easier with EOC now with your changes. I tried the other day and it was kinda flaky. Works so much better now.

[Akkadius]

Originally Posted by epilz

So much easier with EOC now with your changes. I tried the other day and it was kinda flaky. Works so much better now.

It was flaky and you didn't report what made it flaky or what is flaky about it?

Akka is confused

[epilz]

When updating the fields would make my browser refresh and reset the settings. Whatever change you made in the past two days has resolved it

[Akkadius]

Originally Posted by epilz

When updating the fields would make my browser refresh and reset the settings. Whatever change you made in the past two days has resolved it

I don't even....

[epilz]

I blame Google chrome lol

[atrayas]

I have noticed that when mass editing a zone with a large number of npc's that i have to click the execute button for about a minute for all of the mobs to take the changes. If i only click it once only about a third of the npc's get changed and the rest are untouched.

If it is a zone with a small number of npc's it only takes one click and you're all set.

[Akkadius]

Originally Posted by atrayas

I have noticed that when mass editing a zone with a large number of npc's that i have to click the execute button for about a minute for all of the mobs to take the changes. If i only click it once only about a third of the npc's get changed and the rest are untouched.

If it is a zone with a small number of npc's it only takes one click and you're all set.

You need to take in account that there are a lot of individual 'UPDATE' statements happening for each NPC when you do a mass execute.

I seriously doubt that it is missing any of them, it just takes a bit of time for each query to execute on your own depending on how fast your MySQL server responds to EoC. When you click several times, its only doing this for each NPC several times over so it will slow it down even more.

I could speed this up but programatically its a bit harder to do and I didnt because for one its not terribly slow and I have other things to get done before that.

[Akkadius]

Updated mass field editor so it at least lets you know it is trying to work your NPC list and will let you know when its finished instead of spamming hundreds of notifications.

Code:

https://github.com/Akkadius/EQEmuEOC...ae1dbf64af65c0

Result:

[epilz]

awesome changes Akka. I just tested and updated an entire zone in about 30 seconds. This tool has saved me MANY hours when making a lot of changes at once.