k this is what i got
mysql> SELECT npc_types.id,npc_types.name,npc_types.level,
-> npc_types.race,npc_types.class,npc_types.hp,
-> npc_types.gender,npc_types.texture,npc_types.helmt exture,
-> npc_types.size,npc_types.loottable_id,
-> npc_types.merchant_id,npc_types.banish,npc_types.m indmg,
-> npc_types.maxdmg,npc_types.npcspecialattks,
-> npc_types.npc_spells_id,npc_types.d_meele_texture1 ,
-> npc_types.d_meele_texture2,npc_types.walkspeed,
-> npc_types.runspeed,npc_types.fixedz,
-> npc_types.hp_regen_rate,npc_types.mana_regen_rate,
-> npc_types.aggroradius,npc_types.bodytype,
-> npc_types.npc_faction_id,npc_types.face,
-> npc_types.see_invis,npc_types.see_invis_undead,
-> npc_types.lastname,npc_types.qglobal,npc_types.AC
-> FROM npc_types,spawn2 WHERE spawn2.zone='nexus'
-> AND npc_types.id=spawn2.id;
ERROR 1054: Unknown column 'npc_types.AC' in 'field list'
mysql>
|