What if the GUID of all these npcs is (for any reason) like +1 in difference compared to the query and you then run the query.
What will happen?
Exactly, you will add these npcs a second time.
Well it's fairly easy, whenever I do movement scripts, I walk/fly the route that I want the npc to follow and from time to time I use .gps to get the coordinates and insert the waypoints inside the waypoints table inside the database.
Core movement would use another table for that, but since you...
Since this Repack is not getting any updates, I would advise you to just insert the waypoints manually inside the database and restart the worldserver.
That's how I always do it when scripting Waypoint movement (SAI wise - not core wise).
We are already aware of the loot issue and we are also working on all ends to keep fixing reported issues, make sure to join the discord for better communication with our staff team :)
https://discord.gg/PsaQVZA
This query is not handling anything related to the chest spawn, so this query will not fix it.
Could be linked inside the source or directly onto the gameobject, to either spawn the chest when ultraxion dies OR change the phase of the gobject.