old guide is old, apparently (2008).
it lists 24 fields for the table, and there are only 22 (and in a different order)
use
describe <tablename>; to get an overview of the table you are working with in mysql
output:
Code:
mysql> describe object;
+------------+----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+----------------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| zoneid | int(11) unsigned | NO | MUL | 0 | |
| version | smallint(5) | NO | | 0 | |
| xpos | float | NO | | 0 | |
| ypos | float | NO | | 0 | |
| zpos | float | NO | | 0 | |
| heading | float | NO | | 0 | |
| itemid | int(11) | NO | | 0 | |
| charges | smallint(3) unsigned | NO | | 0 | |
| objectname | varchar(32) | YES | | NULL | |
| type | int(11) | NO | | 0 | |
| icon | int(11) | NO | | 0 | |
| unknown08 | mediumint(5) | NO | | 0 | |
| unknown10 | mediumint(5) | NO | | 0 | |
| unknown20 | int(11) | NO | | 0 | |
| unknown24 | int(11) | NO | | 0 | |
| unknown60 | int(11) | NO | | 0 | |
| unknown64 | int(11) | NO | | 0 | |
| unknown68 | int(11) | NO | | 0 | |
| unknown72 | int(11) | NO | | 0 | |
| unknown76 | int(11) | NO | | 0 | |
| unknown84 | int(11) | NO | | 0 | |
+------------+----------------------+------+-----+---------+----------------+
22 rows in set (1.33 sec)
then you'll need to make corrections to you query to match the order in the current database and add/remove fields that are incorrect in the guide.
this line is quite obviously misleading:
Quote:
|
Basic SQL knowledge (Not necessary but useful)
|
might be handy to update the guide after you get it working. :)