Quote:
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
Code:
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);