Ok, I know this is a big huge query, but try this out on your database. This is what it does when it tries to load all NPC types for a zone (in this example, Nexus).
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;
If that reports an error, and it should, it will give a clue as to what the problem querying is.
|
Threaded Mode
