View Single Post
  #8  
Old 11-04-2004, 08:19 AM
govtcheeze
Hill Giant
 
Join Date: Mar 2004
Location: South Florida
Posts: 247
Default

It was an item causing the issue, no idea why but here is my theory:

Code:
mysql> select name, id from items where focusid = 2360 limit 10;
+----------------------------+-------+
| name                       | id    |
+----------------------------+-------+
| Granite Bracer             |  4311 |
| Polished Stone Anklet      | 10129 |
| Ring of Goblin Lords       | 10340 |
| Crown of Below             | 19806 |
| Affliction Haste I Benefit | 56401 |
+----------------------------+-------+
5 rows in set (1.03 sec)

mysql> select * from inventory where itemid = 4311;
Empty set (0.05 sec)

mysql> select * from inventory where itemid = 10129;
+--------+--------+--------+---------+-------+
| charid | slotid | itemid | charges | color |
+--------+--------+--------+---------+-------+
|   1172 |     19 |  10129 |       1 |     0 |
|   2079 |    326 |  10129 |       1 |     0 |
|   2054 |     19 |  10129 |       1 |     0 |
|  99999 |     19 |  10129 |       1 |     0 |
+--------+--------+--------+---------+-------+
4 rows in set (0.04 sec)

mysql> select * from inventory where itemid = 10340;
Empty set (0.01 sec)

mysql> select * from inventory where itemid = 19806;
Empty set (0.00 sec)

mysql> select * from inventory where itemid = 56401;
Empty set (0.00 sec)

mysql> SELECT name FROM character_ WHERE id =1172 OR id =2079 OR id =2054;
+------------+
| name       |
+------------+
| Rangerdown |
| Dradoh     |
| Miethos    |
+------------+
3 rows in set (0.11 sec)
Anyways I removed the item and neckynot was able to move, zone, etc.
__________________
GovtCheeze, Welfare Warrior
"Listen, here's the thing. If you can't spot the sucker in the first half hour at the table, then you ARE the sucker." -- Mike McDermott, Rounders

Developer of the original (circa 2004):
Loots v2.0, bitch!
Faction v1.0, bitch!
Magelo-like clone v0.3, bitch!
Zone geometry and spawn/path viewer, bitch!
Reply With Quote