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( unsigned NOT NULL default '0',
slot tinyint(3) unsigned NOT NULL default '0',
effectid mediumint( unsigned NOT NULL default '0',
base1 mediumint( unsigned NOT NULL default '0',
base2 mediumint( unsigned NOT NULL default '0',
PRIMARY KEY (id),
UNIQUE KEY NewIndex (aaid,slot)
) TYPE=MyISAM;

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

hope this works it did for me

kc7wzl