Update of /cvsroot/planeshift/planeshift/src/server/database/mysql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv13804/server/database/mysql
Modified Files:
item_categories.sql item_stats.sql
Log Message:
added data for testing repair. added MaxQuality as item variable to be used in scripts.
Index: item_categories.sql
===================================================================
RCS file: /cvsroot/planeshift/planeshift/src/server/database/mysql/item_categories.sql,v
retrieving revision 1.10
retrieving revision 1.11
diff -C2 -d -r1.10 -r1.11
*** item_categories.sql 5 May 2006 07:07:37 -0000 1.10
--- item_categories.sql 29 Jul 2006 17:27:22 -0000 1.11
***************
*** 32,37 ****
#
! INSERT INTO `item_categories` VALUES (1,'Weapons',NULL,'Y',33);
! INSERT INTO `item_categories` VALUES (2,'Armor',NULL,'Y',30);
INSERT INTO `item_categories` VALUES (3,'Items',NULL,'Y',NULL);
INSERT INTO `item_categories` VALUES (4,'Gems',NULL,'Y',NULL);
--- 32,37 ----
#
! INSERT INTO `item_categories` VALUES (1,'Weapons',531,'Y',33);
! INSERT INTO `item_categories` VALUES (2,'Armor',462,'Y',30);
INSERT INTO `item_categories` VALUES (3,'Items',NULL,'Y',NULL);
INSERT INTO `item_categories` VALUES (4,'Gems',NULL,'Y',NULL);
Index: item_stats.sql
===================================================================
RCS file: /cvsroot/planeshift/planeshift/src/server/database/mysql/item_stats.sql,v
retrieving revision 1.82
retrieving revision 1.83
diff -C2 -d -r1.82 -r1.83
*** item_stats.sql 19 Jul 2006 12:42:55 -0000 1.82
--- item_stats.sql 29 Jul 2006 17:27:22 -0000 1.83
***************
*** 1,14 ****
# MySQL-Front 3.2 (Build 13.0)
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
- /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
- /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
-
- /*!40101 SET NAMES latin1 */;
- /*!40103 SET TIME_ZONE='SYSTEM' */;
-
# Host: localhost Database: planeshift
# ------------------------------------------------------
--- 1,4 ----
***************
*** 255,258 ****
--- 245,252 ----
INSERT INTO `item_stats` VALUES (418,'B','Plate Torso Armor',5,100,10,0,'TORSO BULK','ARMOR',0.1,7,-1,-1,'STR','AGI','',4,4,0,1,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,2,2.5,2,0,0,0,0,0,0,0,0,132,156,216,2701,221,'1c',2,500,'ARMOR','',0,'',0,'',0,0,0,0,0,0,0,1,'A simple leather armor covering the torso','nosound',50,'','',NULL);
INSERT INTO `item_stats` VALUES (419,'B','Treasure Map',1,5,1,0,'BULK LEFTHAND RIGHTHAND','STACKABLE',0,-1,1,1,'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,0,0,0,0,0,0,0,0,0,0,0,42,43,0,0,0,'0',3,50,'GENERIC',NULL,0,NULL,0,'0',0,0,0,0,0,0,0,0,NULL,'nosound',100,NULL,NULL,'<pages><page><back bg=\"leather\" w=\"450\" h=\"300\"/></page></pages>');
+
+ INSERT INTO `item_stats` VALUES (462,'B','Armors repair kit',5,100,5,0,'BULK RIGHTHAND LEFTHAND','STACKABLE',0.1,'30',-1,-1,'','','',0,0,0,1,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,0,0,0,0,700,701,0,0,0,'0',2,50,'HAMMER','',0,'',0,'',0,0,0,0,0,0,0,1,'A kit of spare parts and tools that allows you to repair an armor','nosound',100,'','','');
+ INSERT INTO `item_stats` VALUES (531,'B','Weapons repair kit',4,100,4,0,'BULK RIGHTHAND LEFTHAND','STACKABLE',0.1,33,-1,-1,0,0,0,0,0,0,1,0.1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0.1,0,0.1,0,0,0,0,0,0,0,0,0,0,0,0,700,701,0,0,0,'Hammer',1,40,'HAMMER','',0,'',0,'',0,0,0,0,0,0,0,1,'A kit of spare parts and tools that allows you to repair a weapon','nosound',1,'','','');
+
INSERT INTO `item_stats` VALUES (2008,'B','Book of the bug fixer',2,100,1,0,'BULK','READABLE',0.1,-1,-1,-1,'0','0','0',0,0,0,2.1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0.2,0.2,0.2,0,0,0,0,0,0,0,0,0,0,0,0,131,151,0,0,0,'0',13,100,'GENERIC','',0,'',0,'',0,0,0,0,0,0,0,1,'Bards tell that there are magical ways to fix bugs. The knowledge you have to obtain can be found in the Dark Way.','nosound',50,'','',NULL);
INSERT INTO `item_stats` VALUES (3013,'B','Catalog of Shields',1,100,15,0,'BULK MIND','STACKABLE',0.1,4,-1,-1,'0','0','0',0,0,0,2.1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0.2,0.2,0.2,0,0,0,0,0,0,0,0,0,0,0,0,149,157,0,0,0,'0',15,400,'RECIPE','',0,'',0,'',0,0,0,0,0,0,0,1,'Extensive catalog of shield designs. Armed with these designs, a skilled smith will be able to construct most common shields. The illustrations show how a variety of shield cores can be created by hammering different amounts of hot metal that is shaped upon the anvil with a hammer. The shield core can then be combined with a shield handle to create the final piece of equipment.','nosound',50,'equip_mind','de_equip_mind',NULL);
***************
*** 263,270 ****
INSERT INTO `item_stats` VALUES (4816,'B','Hammer',3,100,3,50,'BULK LEFTHAND RIGHTHAND','STACKABLE',0.1,4,-1,-1,'0','0','0',0,0,0,2.1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0.2,0.2,0.2,0,0,0,0,0,0,0,0,0,0,0,0,28,29,0,0,0,'Hammer',6,50,'TOOL','',0,'',0,'',0,0,0,0,0,0,0,1,'A simple smith hammer.','nosound',50,'','',NULL);
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
- /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
- /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
--- 257,258 ----
|