Trig
05-22-2002, 08:50 PM
Ok any of you clever guys and girls out there know what sql command would bring back the following with this scenario.
eq.npc_types (ID, name) [Where ID =eq.spawnentry(NPCID)
eq.spawnentry (spawngroupID, NPCID)
eq.spawn2 (spawngroupID, Zone)
now with that information in mind (yes i realise they have other fields as well but from what i can tell those are the pertinent ones) what would the SQL command be (if possible) to return:
eq.spawn2's zone=>spawngroupid associated and displayed directly alongside the appropriate information in eq.npc_types?
Any ideas?
Trig
eq.npc_types (ID, name) [Where ID =eq.spawnentry(NPCID)
eq.spawnentry (spawngroupID, NPCID)
eq.spawn2 (spawngroupID, Zone)
now with that information in mind (yes i realise they have other fields as well but from what i can tell those are the pertinent ones) what would the SQL command be (if possible) to return:
eq.spawn2's zone=>spawngroupid associated and displayed directly alongside the appropriate information in eq.npc_types?
Any ideas?
Trig