View Single Post
  #7  
Old 01-30-2008, 07:47 AM
leslamarch
Discordant
 
Join Date: Sep 2006
Location: Green Bay, WI
Posts: 436
Default

Quote:
Originally Posted by shawnluc View Post
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);
Reply With Quote