View Single Post
  #2  
Old 05-09-2009, 05:13 PM
Derision
Developer
 
Join Date: Feb 2004
Location: UK
Posts: 1,540
Default

From a quick glance at the code, the way that can fail if is:
Code:
SELECT id, spawngroupID, x, y, z, heading, respawntime, variance, pathgrid, _condition, cond_value FROM spawn2 WHERE id=58855
doesn't return exactly one row, i.e. you have no spawn2 entry with id=58855. Don't think it can return more than 1, since id is a primary key.

That query on a standard PEQ DB returns this:
Code:
mysql> SELECT id, spawngroupID, x, y, z, heading, respawntime, variance, pathgrid, _condition, cond_value FROM spawn2 WHERE id=58855 ;
+-------+--------------+-------------+-------------+-----------+-----------+-------------+----------+----------+------------+------------+
| id    | spawngroupID | x           | y           | z         | heading   | respawntime | variance | pathgrid | _condition | cond_value |
+-------+--------------+-------------+-------------+-----------+-----------+-------------+----------+----------+------------+------------+
| 58855 |        48308 | -755.447266 | 1443.891113 | 34.248760 | 90.000000 |        1200 |        0 |        0 |          0 |          1 |
+-------+--------------+-------------+-------------+-----------+-----------+-------------+----------+----------+------------+------------+
1 row in set (0.00 sec)

mysql> quit
Reply With Quote