Home / Browse / Planeshift: a 3D MMORPG / Mail / Archive

Planeshift: a 3D MMORPG

Email Archive: planeshift-cvs (read-only)

[PlaneShift-svn] SF.net SVN: planeshift:[4273] trunk/src/server/database/mysql/sectors.sql

From: <kennygraunke@us...> - 2009-08-28 17:07

Revision: 4273
          http://planeshift.svn.sourceforge.net/planeshift/?rev=4273&view=rev
Author:   kennygraunke
Date:     2009-08-28 17:06:52 +0000 (Fri, 28 Aug 2009)

Log Message:
-----------
Sorry bud, you've been demoted

Modified Paths:
--------------
    trunk/src/server/database/mysql/sectors.sql

Modified: trunk/src/server/database/mysql/sectors.sql
===================================================================
--- trunk/src/server/database/mysql/sectors.sql	2009-08-28 16:09:12 UTC (rev 4272)
+++ trunk/src/server/database/mysql/sectors.sql	2009-08-28 17:06:52 UTC (rev 4273)
@@ -51,7 +51,7 @@
  (1,'room','N',0,0,0,0,0,0,0,0,0,0,0,0,0, 0, 10.0, 'Laanx'),
  (2,'temple','N',0,0,0,0,0,0,0,0,0,0,0,0,0, 0, 10.0, 'Laanx'),
  (3,'NPCroom','N',15000,15000,10000,10000,8000,8000,5000,5000,5000,5000,4000,4000,0, 0, 10.0, 'Laanx'),
- (4,'NPCroom1','N',15000,15000,10000,10000,8000,8000,5000,5000,5000,5000,4000,4000,0, 0, 10.0, 'Kemedes'),
+ (4,'NPCroom1','N',15000,15000,10000,10000,8000,8000,5000,5000,5000,5000,4000,4000,0, 0, 10.0, 'Laanx'),
  (5,'NPCroom2','N',15000,15000,10000,10000,8000,8000,5000,5000,5000,5000,4000,4000,0, 0, 10.0, 'Laanx'),
  (6,'NPCroom3','N',15000,15000,10000,10000,8000,8000,5000,5000,5000,5000,4000,4000,1, 1, 10.0, 'Laanx'),
  (7,'NPCroomwarp','N',15000,15000,10000,10000,8000,8000,5000,5000,5000,5000,4000,4000,0, 0, 10.0, 'Laanx');


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

Thread View

Thread	Author	Date
[PlaneShift-svn] SF.net SVN: planeshift:[4273] trunk/src/server/database/mysql/sectors.sql	<kennygraunke@us...>

[PlaneShift-svn] SF.net SVN: planeshift:[5755] trunk/src/server/database/mysql/sectors.sql

From: <weltall2@us...> - 2010-04-02 14:51

Revision: 5755
          http://planeshift.svn.sourceforge.net/planeshift/?rev=5755&view=rev
Author:   weltall2
Date:     2010-04-02 14:51:36 +0000 (Fri, 02 Apr 2010)

Log Message:
-----------
fixed file

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-04-02 01:34:56 UTC (rev 5754)
+++ trunk/src/server/database/mysql/sectors.sql	2010-04-02 14:51:36 UTC (rev 5755)
@@ -56,7 +56,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`, `god_name`) VALUES 
+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 
  (1,'room','N',0,0,0,0,0,0,0,0,0,0,0,0,0, 0, 10.0, '','','','','N','N', 'Y','Y', 'Laanx'),
  (2,'temple','N',0,0,0,0,0,0,0,0,0,0,0,0,0, 0, 10.0, '','','','','N','N', 'Y','Y', 'Laanx'),
  (3,'NPCroom','N',15000,15000,10000,10000,8000,8000,5000,5000,5000,5000,4000,4000,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.

[PlaneShift-svn] SF.net SVN: planeshift:[6538] trunk/src/server/database/mysql/sectors.sql

From: <weltall2@us...> - 2010-12-16 09:03

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.

[PlaneShift-svn] SF.net SVN: planeshift:[8092] trunk/src/server/database/mysql/sectors.sql

From: <lpancallo@us...> - 2012-02-25 20:21

Revision: 8092
          http://planeshift.svn.sourceforge.net/planeshift/?rev=8092&view=rev
Author:   lpancallo
Date:     2012-02-25 20:20:54 +0000 (Sat, 25 Feb 2012)
Log Message:
-----------
typo

Modified Paths:
--------------
    trunk/src/server/database/mysql/sectors.sql

Modified: trunk/src/server/database/mysql/sectors.sql
===================================================================
--- trunk/src/server/database/mysql/sectors.sql	2012-02-25 20:20:24 UTC (rev 8091)
+++ trunk/src/server/database/mysql/sectors.sql	2012-02-25 20:20:54 UTC (rev 8092)
@@ -69,7 +69,7 @@
   `DeathRestoreHP` char(1) NOT NULL DEFAULT 'Y' COMMENT 'When not N the sector will restore HP when the player dies in it, else it just sets the minimum to keep him alive and not death loop.',
   `god_name` varchar(45) NOT NULL DEFAULT 'Laanx' COMMENT 'Sets a name of an entity associated to the sector as overseer.',
   PRIMARY KEY (`id`),
-  UNIQUE KEY `name` (`name`),
+  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.';
 

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[PlaneShift-svn] SF.net SVN: planeshift:[8112] trunk/src/server/database/mysql/sectors.sql

From: <lpancallo@us...> - 2012-03-10 14:46

Revision: 8112
          http://planeshift.svn.sourceforge.net/planeshift/?rev=8112&view=rev
Author:   lpancallo
Date:     2012-03-10 14:46:40 +0000 (Sat, 10 Mar 2012)
Log Message:
-----------
fixed comment

Modified Paths:
--------------
    trunk/src/server/database/mysql/sectors.sql

Modified: trunk/src/server/database/mysql/sectors.sql
===================================================================
--- trunk/src/server/database/mysql/sectors.sql	2012-03-10 14:44:58 UTC (rev 8111)
+++ trunk/src/server/database/mysql/sectors.sql	2012-03-10 14:46:40 UTC (rev 8112)
@@ -70,7 +70,7 @@
   `god_name` varchar(45) NOT NULL DEFAULT 'Laanx' COMMENT 'Sets a name of an entity associated to the sector as overseer.',
   PRIMARY KEY (`id`),
   UNIQUE KEY `name` (`name`)
-  --KEY `indx_sector_name` (`name`)
+  -- KEY `indx_sector_name` (`name`)
 ) ENGINE=MyISAM AUTO_INCREMENT=84 DEFAULT CHARSET=latin1 COMMENT='Stores data about sectors available in game.';
 
 

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[PlaneShift-svn] SF.net SVN: planeshift:[8456] trunk/src/server/database/mysql/sectors.sql

From: <lpancallo@us...> - 2012-10-02 22:24

Revision: 8456
          http://planeshift.svn.sourceforge.net/planeshift/?rev=8456&view=rev
Author:   lpancallo
Date:     2012-10-02 22:24:26 +0000 (Tue, 02 Oct 2012)
Log Message:
-----------
added missing default values.

Modified Paths:
--------------
    trunk/src/server/database/mysql/sectors.sql

Modified: trunk/src/server/database/mysql/sectors.sql
===================================================================
--- trunk/src/server/database/mysql/sectors.sql	2012-10-02 21:07:34 UTC (rev 8455)
+++ trunk/src/server/database/mysql/sectors.sql	2012-10-02 22:24:26 UTC (rev 8456)
@@ -59,10 +59,10 @@
   `collide_objects` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Determines if the items dropped in this sector should have collision detection always enabled.',
   `non_transient_objects` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Determines if the items dropped in this sector should be transient.',
   `say_range` float(5,2) unsigned NOT NULL DEFAULT '0.00' COMMENT 'Determines the range of say in the specific sector. Set 0.0 to use default.',
-  `TeleportingSector` varchar(30) NOT NULL COMMENT 'Sector where the player will be teleported automatically when entering this sector',
-  `TeleportingCords` varchar(30) NOT NULL COMMENT 'Cordinates where the player will be teleported automatically when entering this sector',
-  `DeathSector` varchar(30) NOT NULL COMMENT 'Sector where the player will be teleported automatically when dieing in this sector',
-  `DeathCords` varchar(30) NOT NULL COMMENT 'Cordinates where the player will be teleported automatically when dieing in this sector',
+  `TeleportingSector` varchar(30) NOT NULL DEFAULT '' COMMENT 'Sector where the player will be teleported automatically when entering this sector',
+  `TeleportingCords` varchar(30) NOT NULL DEFAULT '' COMMENT 'Cordinates where the player will be teleported automatically when entering this sector',
+  `DeathSector` varchar(30) NOT NULL DEFAULT '' COMMENT 'Sector where the player will be teleported automatically when dieing in this sector',
+  `DeathCords` varchar(30) NOT NULL DEFAULT '' COMMENT 'Cordinates where the player will be teleported automatically when dieing in this sector',
   `TeleportingSectorEnable` char(1) NOT NULL DEFAULT 'N' COMMENT 'When not N the sector will teleport when accessing it according to teleportingsector and teleportingcords',
   `TeleportingPenaltyEnable` char(1) NOT NULL DEFAULT 'N' COMMENT 'When not N when teleported when entering this sector it will apply the death penalty',
   `DeathRestoreMana` char(1) NOT NULL DEFAULT 'Y' COMMENT 'When not N the sector will restore mana when the player dies in it, else nothing is done.',

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.