I think latest is giving no NPC's.
I debugged with this:
$ tail -f ~/server/logs/zone-dynamic_05.log
Error loading NPCs from database. Bad query: #1054: Unknown column 'npc_types.ammo_idfile' in 'field list'
peqbeta_2014-07-23-02-01.tar.gz inside peqbeta*.sql file line 37124:
Code:
CREATE TABLE `npc_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text NOT NULL,
`lastname` varchar(32) DEFAULT NULL,
`level` tinyint(2) unsigned NOT NULL DEFAULT '0',
`race` smallint(5) unsigned NOT NULL DEFAULT '0',
`class` tinyint(2) unsigned NOT NULL DEFAULT '0',
`bodytype` int(11) DEFAULT NULL,
`hp` int(11) NOT NULL DEFAULT '0',
`mana` int(11) NOT NULL DEFAULT '0',
`gender` tinyint(2) unsigned NOT NULL DEFAULT '0',
`texture` tinyint(2) unsigned NOT NULL DEFAULT '0',
`helmtexture` tinyint(2) unsigned NOT NULL DEFAULT '0',
`size` float NOT NULL DEFAULT '0',
`hp_regen_rate` int(11) unsigned NOT NULL DEFAULT '0',
`mana_regen_rate` int(11) unsigned NOT NULL DEFAULT '0',
`loottable_id` int(11) unsigned NOT NULL DEFAULT '0',
`merchant_id` int(11) unsigned NOT NULL DEFAULT '0',
`alt_currency_id` int(11) unsigned NOT NULL DEFAULT '0',
`npc_spells_id` int(11) unsigned NOT NULL DEFAULT '0',
`npc_spells_effects_id` int(11) unsigned NOT NULL DEFAULT '0',
`npc_faction_id` int(11) NOT NULL DEFAULT '0',
`adventure_template_id` int(10) unsigned NOT NULL DEFAULT '0',
`trap_template` int(10) unsigned DEFAULT '0',
`mindmg` int(10) unsigned NOT NULL DEFAULT '0',
`maxdmg` int(10) unsigned NOT NULL DEFAULT '0',
`attack_count` smallint(6) NOT NULL DEFAULT '-1',
`npcspecialattks` varchar(36) NOT NULL DEFAULT '',
`special_abilities` text NOT NULL,
`aggroradius` int(10) unsigned NOT NULL DEFAULT '0',
`assistradius` int(10) unsigned NOT NULL DEFAULT '0',
`face` int(10) unsigned NOT NULL DEFAULT '1',
`luclin_hairstyle` int(10) unsigned NOT NULL DEFAULT '1',
`luclin_haircolor` int(10) unsigned NOT NULL DEFAULT '1',
`luclin_eyecolor` int(10) unsigned NOT NULL DEFAULT '1',
`luclin_eyecolor2` int(10) unsigned NOT NULL DEFAULT '1',
`luclin_beardcolor` int(10) unsigned NOT NULL DEFAULT '1',
`luclin_beard` int(10) unsigned NOT NULL DEFAULT '0',
`drakkin_heritage` int(10) NOT NULL DEFAULT '0',
`drakkin_tattoo` int(10) NOT NULL DEFAULT '0',
`drakkin_details` int(10) NOT NULL DEFAULT '0',
`armortint_id` int(10) unsigned NOT NULL DEFAULT '0',
`armortint_red` tinyint(3) unsigned NOT NULL DEFAULT '0',
`armortint_green` tinyint(3) unsigned NOT NULL DEFAULT '0',
`armortint_blue` tinyint(3) unsigned NOT NULL DEFAULT '0',
`d_meele_texture1` int(10) unsigned NOT NULL DEFAULT '0',
`d_meele_texture2` int(10) unsigned NOT NULL DEFAULT '0',
`prim_melee_type` tinyint(4) unsigned NOT NULL DEFAULT '28',
`sec_melee_type` tinyint(4) unsigned NOT NULL DEFAULT '28',
`runspeed` float NOT NULL DEFAULT '0',
`MR` smallint(5) NOT NULL DEFAULT '0',
`CR` smallint(5) NOT NULL DEFAULT '0',
`DR` smallint(5) NOT NULL DEFAULT '0',
`FR` smallint(5) NOT NULL DEFAULT '0',
`PR` smallint(5) NOT NULL DEFAULT '0',
`Corrup` smallint(5) NOT NULL DEFAULT '0',
`PhR` smallint(5) unsigned NOT NULL DEFAULT '0',
`see_invis` smallint(4) NOT NULL DEFAULT '0',
`see_invis_undead` smallint(4) NOT NULL DEFAULT '0',
`qglobal` int(2) unsigned NOT NULL DEFAULT '0',
`AC` smallint(5) NOT NULL DEFAULT '0',
`npc_aggro` tinyint(4) NOT NULL DEFAULT '0',
`spawn_limit` tinyint(4) NOT NULL DEFAULT '0',
`attack_speed` float NOT NULL DEFAULT '0',
`findable` tinyint(4) NOT NULL DEFAULT '0',
`STR` mediumint(8) unsigned NOT NULL DEFAULT '75',
`STA` mediumint(8) unsigned NOT NULL DEFAULT '75',
`DEX` mediumint(8) unsigned NOT NULL DEFAULT '75',
`AGI` mediumint(8) unsigned NOT NULL DEFAULT '75',
`_INT` mediumint(8) unsigned NOT NULL DEFAULT '80',
`WIS` mediumint(8) unsigned NOT NULL DEFAULT '75',
`CHA` mediumint(8) unsigned NOT NULL DEFAULT '75',
`see_hide` tinyint(4) NOT NULL DEFAULT '0',
`see_improved_hide` tinyint(4) NOT NULL DEFAULT '0',
`trackable` tinyint(4) NOT NULL DEFAULT '1',
`isbot` tinyint(4) NOT NULL DEFAULT '0',
`exclude` tinyint(4) NOT NULL DEFAULT '1',
`ATK` mediumint(9) NOT NULL DEFAULT '0',
`Accuracy` mediumint(9) NOT NULL DEFAULT '0',
`slow_mitigation` smallint(4) NOT NULL DEFAULT '0',
`version` smallint(5) unsigned NOT NULL DEFAULT '0',
`maxlevel` tinyint(3) NOT NULL DEFAULT '0',
`scalerate` int(11) NOT NULL DEFAULT '100',
`private_corpse` tinyint(3) unsigned NOT NULL DEFAULT '0',
`unique_spawn_by_name` tinyint(3) unsigned NOT NULL DEFAULT '0',
`underwater` tinyint(3) unsigned NOT NULL DEFAULT '0',
`isquest` tinyint(3) NOT NULL DEFAULT '0',
`emoteid` int(10) unsigned NOT NULL DEFAULT '0',
`spellscale` float NOT NULL DEFAULT '100',
`healscale` float NOT NULL DEFAULT '100',
`no_target_hotkey` tinyint(1) unsigned NOT NULL DEFAULT '0',
`armtexture` tinyint(2) NOT NULL DEFAULT '0',
`bracertexture` tinyint(2) NOT NULL DEFAULT '0',
`handtexture` tinyint(2) NOT NULL DEFAULT '0',
`legtexture` tinyint(2) NOT NULL DEFAULT '0',
`feettexture` tinyint(2) NOT NULL DEFAULT '0',
`light` tinyint(2) NOT NULL DEFAULT '0',
`walkspeed` tinyint(2) NOT NULL DEFAULT '0',
`peqid` int(11) NOT NULL DEFAULT '0',
`unique_` tinyint(2) NOT NULL DEFAULT '0',
`fixed` tinyint(2) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=999216 DEFAULT CHARSET=latin1 PACK_KEYS=0;
ALTER TABLE `eq`.`npc_types` ADD COLUMN `ammo_idfile` INT NULL DEFAULT 0 AFTER `fixed`;
then got Error loading NPCs from database. Bad query: #1054: Unknown column 'npc_types.ranged_type' in 'field list'
so,
ALTER TABLE `eq`.`npc_types` ADD COLUMN `ammo_idfile` INT NULL DEFAULT 0 AFTER `fixed`;
Error loading NPCs from database. Bad query: #1054: Unknown column 'npc_types.Avoidance' in 'field list'
ALTER TABLE `eq`.`npc_types` ADD COLUMN `Avoidance` INT NULL DEFAULT 0 AFTER `fixed`;
And, now we are in business.. NPC's load. Obviously, this is because peqbeta's SQL tables doesn't have all the fields that the latest EQEMU is expecting