those that installed cavedude server please read

[kc7wzl]

sorry if this is in the wrong area but it touches diff areas of topic.

for those that installed Cave dude's server setup. that wishes to install the latest ver of the EQEmu (like the 0.7.0-992 ) and/or PEQ data base and is getting fustrated with the zone crashing.. and is also gettting fustrated with combing through changelog.txt files here is what I sourced into my MySql DB

I made a file called kc7wzl.sql

then I put this stuff in it ( saving as ansi stand. )

-------------------------------------------------------------------------

ALTER TABLE `npc_types` ADD `see_hide` tinyint(4) NOT NULL default '0';
ALTER TABLE `npc_types` ADD `see_improved_hide` tinyint(4) NOT NULL default '0';
UPDATE `npc_types` SET `see_hide` = 1 WHERE see_invis = '1';
UPDATE `npc_types` SET `see_hide` = 1 WHERE see_invis_undead = '1';
ALTER TABLE quest_globals CHANGE expdate expdate INT;
alter table npc_types add column trackable tinyint(4) not null default 1;
alter table altadv_vars add column cost_inc tinyint(4) not null default 0;
ALTER TABLE `zone` ADD `cancombat` tinyint(4) NOT NULL default '1';
UPDATE `zone` SET `cancombat` = 0 WHERE short_name = 'nexus';
UPDATE `zone` SET `cancombat` = 0 WHERE short_name = 'poknowledge';
UPDATE `zone` SET `cancombat` = 0 WHERE short_name = 'potranquility';
CREATE TABLE aa_effects (
id int(10) unsigned NOT NULL auto_increment,
aaid mediumint(8) unsigned NOT NULL default '0',
slot tinyint(3) unsigned NOT NULL default '0',
effectid mediumint(8) unsigned NOT NULL default '0',
base1 mediumint(8) unsigned NOT NULL default '0',
base2 mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (id),
UNIQUE KEY NewIndex (aaid,slot)
) TYPE=MyISAM;

--------------------------------------------------------------------------

hope this works it did for me

kc7wzl

[Angelox]

What you need to do is learn how to download/install the PEQ database from the PEQ CVS - all that is already added and more.
As for the different database, The PEQ databse that is available for download VIA CVS, has more packet-spawned zones than any of the others.
Everyone is hard at work fixing things to the emulator and database, this is why the Cavedude installer fell behind.
You can still use Cavedudes installer, then after it is all running - update PEQ from CVS (this will give you a superior database), so you can then update the binaries.