Quote:
Originally Posted by KLS
Code:
mysql> select * from spawn2 where spawngroupID=(select spawngroupID from spawnentry where npcID=2093);
+-------+--------------+---------+---------+------------+------------+----------+----------+-------------+----------+----------+------------+------------+---------+
| id | spawngroupID | zone | version | x | y | z | heading | respawntime | variance | pathgrid | _condition | cond_value | enabled |
+-------+--------------+---------+---------+------------+------------+----------+----------+-------------+----------+----------+------------+------------+---------+
| 10842 | 7667 | qeynos2 | 0 | 139.699997 | 312.700012 | 3.100000 | 0.000000 | 640 | 0 | 0 | 0 | 1 | 1 |
+-------+--------------+---------+---------+------------+------------+----------+----------+-------------+----------+----------+------------+------------+---------+
1 row in set (0.18 sec)
Keep in mind these are spawn points you don't turn them all on and off at once, they're one at a time. |
This query doesn't work when there are multiple spawnentrys for npcID which I'm sure there often will be.
I'll give ya a dollar to impliment DIsable/Enable_Spawn like I posted above.
