[PlaneShift-svn] SF.net SVN: planeshift:[2167] trunk

[<are...@us...>]

Revision: 2167
          http://planeshift.svn.sourceforge.net/planeshift/?rev=2167&view=rev
Author:   aresilek
Date:     2008-09-20 02:12:49 +0000 (Sat, 20 Sep 2008)

Log Message:
-----------
- Changed "command area" to GM2+, patch by Kerol.

Modified Paths:
--------------
    trunk/docs/history.txt
    trunk/src/server/database/mysql/command_access.sql
    trunk/src/server/database/mysql/server_options.sql
    trunk/src/server/database/mysql/upgrade_schema.sql
    trunk/src/server/psserver.cpp

Modified: trunk/docs/history.txt
===================================================================
--- trunk/docs/history.txt	2008-09-19 17:35:35 UTC (rev 2166)
+++ trunk/docs/history.txt	2008-09-20 02:12:49 UTC (rev 2167)
@@ -1,3 +1,6 @@
+*** 2008-09-20 by Steven Patrick
+- Changed "command area" to GM2+, patch by Kerol.
+
 *** 2008-09-19 by Stefano Angeleri
 - Hopefully a complete fix for FS#2208
 

Modified: trunk/src/server/database/mysql/command_access.sql
===================================================================
--- trunk/src/server/database/mysql/command_access.sql	2008-09-19 17:35:35 UTC (rev 2166)
+++ trunk/src/server/database/mysql/command_access.sql	2008-09-20 02:12:49 UTC (rev 2167)
@@ -89,9 +89,6 @@
 INSERT INTO command_group_assignment VALUES( "/money", 30 );
 INSERT INTO command_group_assignment VALUES( "/money", 25 );
 INSERT INTO command_group_assignment VALUES( "/money", 24 );
-INSERT INTO command_group_assignment VALUES( "command area", 30 );
-INSERT INTO command_group_assignment VALUES( "command area", 25 );
-INSERT INTO command_group_assignment VALUES( "command area", 24 );
 INSERT INTO command_group_assignment VALUES( "/event", 30 );
 INSERT INTO command_group_assignment VALUES( "/event", 25 );
 INSERT INTO command_group_assignment VALUES( "/event", 24 );
@@ -144,6 +141,11 @@
 INSERT INTO command_group_assignment VALUES( "changenameall", 23 );
 
 # GM2 and above
+INSERT INTO command_group_assignment VALUES( "command area", 30 );
+INSERT INTO command_group_assignment VALUES( "command area", 25 );
+INSERT INTO command_group_assignment VALUES( "command area", 24 );
+INSERT INTO command_group_assignment VALUES( "command area", 23 );
+INSERT INTO command_group_assignment VALUES( "command area", 22 );
 INSERT INTO command_group_assignment VALUES( "/divorce", 30 );
 INSERT INTO command_group_assignment VALUES( "/divorce", 25 );
 INSERT INTO command_group_assignment VALUES( "/divorce", 24 );

Modified: trunk/src/server/database/mysql/server_options.sql
===================================================================
--- trunk/src/server/database/mysql/server_options.sql	2008-09-19 17:35:35 UTC (rev 2166)
+++ trunk/src/server/database/mysql/server_options.sql	2008-09-20 02:12:49 UTC (rev 2167)
@@ -28,7 +28,7 @@
 # Dumping data for table server_options
 #
 
-INSERT INTO `server_options` VALUES ('db_version','1193');
+INSERT INTO `server_options` VALUES ('db_version','1194');
 INSERT INTO `server_options` VALUES ('game_time','15:00');
 INSERT INTO `server_options` VALUES ('game_date','100-1-1');
 INSERT INTO `server_options` VALUES ('standard_motd','This is the message of the day from server_options table.');

Modified: trunk/src/server/database/mysql/upgrade_schema.sql
===================================================================
--- trunk/src/server/database/mysql/upgrade_schema.sql	2008-09-19 17:35:35 UTC (rev 2166)
+++ trunk/src/server/database/mysql/upgrade_schema.sql	2008-09-20 02:12:49 UTC (rev 2167)
@@ -956,6 +956,11 @@
 INSERT INTO command_group_assignment VALUES( "/changeguildleader", 22 );
 UPDATE `server_options` SET `option_value`='1193' WHERE `option_name`='db_version';
 
+#### 1194 - Steven Patrick - Adding /changeguildleader GM command
+INSERT INTO command_group_assignment VALUES( "command area", 23 );
+INSERT INTO command_group_assignment VALUES( "command area", 22 );
+UPDATE `server_options` SET `option_value`='1194' WHERE `option_name`='db_version';
+
 # Insert your upgrade before this line. Remember when you set a new db_version
 # to update the server_options.sql file and update psserver.cpp as well.
 # This to ensure that everything is working if you use the create_all.sql to

Modified: trunk/src/server/psserver.cpp
===================================================================
--- trunk/src/server/psserver.cpp	2008-09-19 17:35:35 UTC (rev 2166)
+++ trunk/src/server/psserver.cpp	2008-09-20 02:12:49 UTC (rev 2167)
@@ -90,7 +90,7 @@
 #include "introductionmanager.h"
 
 // Remember to bump this in server_options.sql and add to upgrade_schema.sql!
-#define DATABASE_VERSION_STR "1193"
+#define DATABASE_VERSION_STR "1194"
 
 
 psCharacterLoader psServer::CharacterLoader;


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