Having issues getting zones to load.

[leslamarch]

Originally Posted by shawnluc

Hmmm ok now im a bit confused. The guide only references sourcing the load_player.sql, and load_system.sql, but wincvs downloaded a bunch of .sql files. Do I need to source all of them?

That is Correct thats all you need to source, Those two .sql files call all the other *.sql to source.

What sfisque Was referring to is check the change log for any changes to the database Like this

Required SQL:
alter table zone add column graveyard_id float NOT NULL default '0' after safe_z;

DROP TABLE IF EXISTS `graveyard`;
CREATE TABLE `graveyard` (
  `id` int(11) NOT NULL auto_increment,
  `zone_id` int(4) NOT NULL default '0',
  `x` float NOT NULL default '0',
  `y` float NOT NULL default '0',
  `z` float NOT NULL default '0',
  `heading` float NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `zone_id` (`zone_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

insert into rule_values values(0, 'Zone:GraveyardTimeMS', 1200000);