Thanks for the DB, here are a few issues i have found.
Many of the class numbers for the NPC's are incorrect, many that are supposed to be GM's are set to merchants (41). There is no easy way to fix this other than referencing the class numbers from a db with correct data. I used this query to construct a query to perform the udates, where the EQ1 db is the current DB and the EQ db is an older version containing the correct class numbers:
SELECT CONCAT('UPDATE eq1.npc_types SET class = ', b.class, ' WHERE id = ', a.id, ';')
FROM eq1.npc_types a, eq.npc_types b
WHERE a.id = b.id
AND a.class <> b.class
(
Here's the resultant query)
Is there a reason why the start_zones table is not indexed? There are many redundant (replicated) records in this table.
Some of the start_zones.race, class, zone and deity records have no corresponding starting_items. race, class, zone and deity records (e.g. Any Freeport Cleric):
select start_zones.zone_id
, zone.short_name
, start_zones.player_race
, start_zones.player_choice
, start_zones.player_class
, class_skill.name
, start_zones.player_deity
, starting_items.id, items.name
from start_zones, zone, class_skill
left join starting_items
on start_zones.zone_id = starting_items.zoneid
and start_zones.player_race = starting_items.race
and start_zones.player_class = starting_items.class
and start_zones.player_deity = starting_items.deityid
left join items
on starting_items.itemid = items.id
where start_zones.zone_id = zone.zoneidnumber
and start_zones.player_class = class_skill.class
order by start_zones.player_race
, class_skill.name
, zone.short_name
This seems to be because of problems with the start_zones table, rather than the start_items table (some of the start_zone zone id's are incorrect). e.g. This update will fix the evil Erudite Clerics:
update start_zones
set zone_id = 75, start_zone = 75, x = 880, y = 456, z = -120.19
where start_zones.player_race = 3
and start_zones.player_class = 2
and start_zones.player_deity = 203
(I have referenced the x,y and z values from the Shodownights as I don