Al' Kabor's Almanac

sesmar · #4 02-05-2007, 01:42 AM

I found one error in this so far. In the file zone_list.php on line 47 and 48 you have:

Code:

$q->addJoin("Inner join $tbspawn2 on $tbspawnentry.spawngroupID=$tbspawn2.spawngroupID");
$q->addJoin("Inner join $tbspawnentry on $tbspawnentry.npcID=$tbnpctypes.id");

It should be

Code:

$q->addJoin("Inner join $tbspawnentry on $tbspawnentry.npcID=$tbnpctypes.id");
$q->addJoin("Inner join $tbspawn2 on $tbspawnentry.spawngroupID=$tbspawn2.spawngroupID");

It was throwing an error on this page for me. I made this little change and it works for me. It seems the problem was with the order of the Joins. Since your main table in the query is npc_types you have to reference the join to spawnentry first then the join to spawn2.