• Cannot find where these are located

Posted: **Sat Jan 07, 2017 9:35 am**

I cannot for the life of me find these. I can normally locate a hard to find spawn by query. I am standing at the loc and giving a decent range of error, I also cannot tab to find these. I am sure they are spawns because they go away with a depop.

Code: Select all

SELECT s.name, slp.*
FROM 
spawn s
INNER JOIN
spawn_location_entry sle ON s.id=sle.spawn_id
INNER JOIN
spawn_location_placement slp ON sle.spawn_location_id=slp.spawn_location_id
WHERE (slp.x>504 AND slp.x<=506) AND (y > 200 AND y< 205)

Posted: **Sat Jan 07, 2017 4:00 pm**

It could be a widget or sign with an effect, the widget x/y/z can change the location in game from what is in the spawn placement so that query would fail to locate it in that case. Tab target does not work on certain effect type spawns making it annoying as hell trying to target stuff, for example that wizard ring of fire spell is a spawn but can't be tab targeted, several of them scattered in commonlands.

Posted: **Sun Jan 08, 2017 9:04 am**

That helps dude, I appreciate it.

Posted: **Sun Jan 08, 2017 9:46 am**

Well I found them. The x,y and z were nowhere close to where the emitter was. They were spawns, not object, sign or widget. They were called "a Favorable Wind", does not look like wind to me. I found them by slowly inching the x,y and z of my query to grab every spawn in my area.

Cannot find where these are located - Timorous blue swirls

Cannot find where these are located - Timorous blue swirls

Re: Cannot find where these are located - Timorous blue swir

Re: Cannot find where these are located - Timorous blue swir

Re: Cannot find where these are located - Timorous blue swir