View Single Post
  #9  
Old 03-18-2010, 04:09 PM
KLS
Administrator
 
Join Date: Sep 2006
Posts: 1,348
Default

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.
Reply With Quote