Revision: 6538
http://planeshift.svn.sourceforge.net/planeshift/?rev=6538&view=rev
Author: weltall2
Date: 2010-12-16 09:03:07 +0000 (Thu, 16 Dec 2010)
Log Message:
-----------
fixed sectors sql patch by rnickell
Modified Paths:
--------------
trunk/src/server/database/mysql/sectors.sql
Modified: trunk/src/server/database/mysql/sectors.sql
===================================================================
--- trunk/src/server/database/mysql/sectors.sql 2010-12-14 23:48:51 UTC (rev 6537)
+++ trunk/src/server/database/mysql/sectors.sql 2010-12-16 09:03:07 UTC (rev 6538)
@@ -71,7 +71,7 @@
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `indx_sector_name` (`name`)
-) ENGINE=MyISAM AUTO_INCREMENT=84 DEFAULT CHARSET=latin1 COMMENT='Stores data about sectors available in game.'
+) ENGINE=MyISAM AUTO_INCREMENT=84 DEFAULT CHARSET=latin1 COMMENT='Stores data about sectors available in game.';
--
@@ -79,7 +79,7 @@
--
/*!40000 ALTER TABLE `sectors` DISABLE KEYS */;
-INSERT INTO `sectors` (`id`,`name`,`rain_enabled`,`rain_min_gap`,`rain_max_gap`,`rain_min_duration`,`rain_max_duration`,`rain_min_drops`,`rain_max_drops`,`rain_min_fade_in`,`rain_max_fade_in`,`rain_min_fade_out`,`rain_max_fade_out`,`lightning_min_gap`,`lightning_max_gap`,`collide_objects`, `non_transient_objects`, `say_range`,`TeleportingSector`, `TeleportingCords`, `DeathSector`, `DeathCords`, `TeleportingSectorEnable`, `TeleportingPenaltyEnable`, `DeathRestoreMana`, `DeathRestoreHP`, `god_name`) VALUES
+INSERT INTO `sectors` (`id`,`name`,`rain_enabled`,`snow_enabled`,`fog_enabled`,`rain_min_gap`,`rain_max_gap`,`rain_min_duration`,`rain_max_duration`,`rain_min_drops`,`rain_max_drops`,`rain_min_fade_in`,`rain_max_fade_in`,`rain_min_fade_out`,`rain_max_fade_out`,`lightning_min_gap`,`lightning_max_gap`,`snow_min_gap`,`snow_max_gap`,`snow_min_duration`,`snow_max_duration`,`snow_min_flakes`,`snow_max_flakes`,`snow_min_fade_in`,`snow_max_fade_in`,`snow_min_fade_out`,`snow_max_fade_out`,`fog_min_gap`,`fog_max_gap`,`fog_min_duration`,`fog_max_duration`,`fog_min_density`,`fog_max_density`,`fog_min_fade_in`,`fog_max_fade_in`,`fog_min_fade_out`,`fog_max_fade_out`,`collide_objects`, `non_transient_objects`, `say_range`,`TeleportingSector`, `TeleportingCords`, `DeathSector`, `DeathCords`, `TeleportingSectorEnable`, `TeleportingPenaltyEnable`, `DeathRestoreMana`, `DeathRestoreHP`, `god_name`) VALUES
(1,'room','N','N','N',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0, 10.0, '','','','','N','N', 'Y','Y', 'Laanx'),
(2,'temple','N','N','N',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0, 10.0, '','','','','N','N', 'Y','Y', 'Laanx'),
(3,'NPCroom','N','N','N',15000,15000,10000,10000,8000,8000,5000,5000,5000,5000,4000,4000,15000,15000,10000,10000,8000,8000,5000,5000,5000,5000,15000,15000,10000,10000,8000,8000,5000,5000,5000,5000,0, 0, 10.0, '','', 'NPCroom','-20.0,1.0,-180.0,0.0','N','N', 'Y','Y', 'Laanx'),
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|