I'd guess the error message is coming from here..
database.cpp:
MakeAnyLenString(&query, "SELECT id,name,level,race,class,hp,gender,texture,helmtex ture,size,loottable_id, merchant_id, banish, mindmg, maxdmg, npcspecialattks,usedspells,d_meele_texture1,d_meel e_texture2, walkspeed, runspeed,fixedz FROM npc_types");//WHERE zone='%s'", zone_name
This is the npc_types structure...
mysql> describe npc_types;
+-------------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+---------------------+------+-----+---------+----------------+
| id | int(11) | | PRI | NULL | auto_increment |
| name | text | | | | |
| level | tinyint(2) unsigned | | | 0 | |
| race | tinyint(2) unsigned | | | 0 | |
| class | tinyint(2) unsigned | | | 0 | |
| hp | int(11) | | | 0 | |
| gender | tinyint(2) unsigned | | | 0 | |
| texture | tinyint(2) unsigned | | | 0 | |
| helmtexture | tinyint(2) unsigned | | | 0 | |
| size | float | | | 0 | |
| hp_regen_rate | int(11) unsigned | | | 0 | |
| mana_regen_rate | int(11) unsigned | | | 0 | |
| loottable_id | int(11) unsigned | | | 0 | |
| merchant_id | int(11) unsigned | | | 0 | |
| mindmg | int(10) unsigned | | | 0 | |
| maxdmg | int(10) unsigned | | | 0 | |
| usedspells | varchar(70) | | | | |
| npcspecialattks | char(1) | | | | |
| banish | int(10) unsigned | | | 0 | |
| aggroradius | int(10) unsigned | | | 0 | |
| social | int(10) unsigned | | | 0 | |
| face | int(10) unsigned | | | 1 | |
| luclin_hairstyle | int(10) unsigned | | | 1 | |
| luclin_haircolor | int(10) unsigned | | | 1 | |
| luclin_eyecolor | int(10) unsigned | | | 1 | |
| luclin_beardcolor | int(10) unsigned | | | 1 | |
+-------------------+---------------------+------+-----+---------+----------------+
If makes a note in the file about supporting an old database type, so Im guessing it's running an old style db query against the new database format, hence the unknown column error..
Don't know if this is causing any problems or not, have to look at it in a little more depth when I get home..
|