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

Planeshift: a 3D MMORPG

Email Archive: planeshift-cvs (read-only)

2001:	_Jan	_Feb	_Mar	_Apr	_May	_Jun	_Jul	_Aug	_Sep	_Oct	_Nov	_Dec (35)
2002:	_Jan (354)	_Feb (363)	_Mar (542)	_Apr (494)	_May (232)	_Jun (349)	_Jul (221)	_Aug (154)	_Sep (124)	_Oct (89)	_Nov (121)	_Dec (133)
2003:	_Jan (279)	_Feb (490)	_Mar (448)	_Apr (295)	_May (151)	_Jun (209)	_Jul (367)	_Aug (371)	_Sep (284)	_Oct (492)	_Nov (540)	_Dec (240)
2004:	_Jan (381)	_Feb (497)	_Mar (556)	_Apr (394)	_May (332)	_Jun (263)	_Jul (533)	_Aug (348)	_Sep (398)	_Oct (520)	_Nov (511)	_Dec (703)
2005:	_Jan (700)	_Feb (354)	_Mar (456)	_Apr (300)	_May (444)	_Jun (405)	_Jul (312)	_Aug (480)	_Sep (302)	_Oct (660)	_Nov (448)	_Dec (658)
2006:	_Jan (543)	_Feb (313)	_Mar (293)	_Apr (293)	_May (244)	_Jun (256)	_Jul (257)	_Aug (194)	_Sep (64)	_Oct (174)	_Nov (340)	_Dec (250)
2007:	_Jan (281)	_Feb (350)	_Mar (245)	_Apr (348)	_May (262)	_Jun (188)	_Jul (233)	_Aug (303)	_Sep (426)	_Oct (470)	_Nov (181)	_Dec (242)
2008:	_Jan (176)	_Feb (268)	_Mar (253)	_Apr (136)	_May (198)	_Jun (207)	_Jul (134)	_Aug (166)	_Sep (65)	_Oct (113)	_Nov (248)	_Dec (222)
2009:	_Jan (170)	_Feb (163)	_Mar (247)	_Apr (225)	_May (202)	_Jun (84)	_Jul (281)	_Aug (138)	_Sep (292)	_Oct (118)	_Nov (140)	_Dec (278)
2010:	_Jan (304)	_Feb (219)	_Mar (110)	_Apr (88)	_May (94)	_Jun (53)	_Jul (74)	_Aug (98)	_Sep (63)	_Oct (90)	_Nov (134)	_Dec (216)
2011:	_Jan (166)	_Feb (179)	_Mar (94)	_Apr (82)	_May (140)	_Jun (141)	_Jul (92)	_Aug (56)	_Sep (35)	_Oct (38)	_Nov (75)	_Dec (187)
2012:	_Jan (96)	_Feb (49)	_Mar (36)	_Apr (111)	_May (87)	_Jun (28)	_Jul (40)	_Aug (15)	_Sep (28)	_Oct (23)	_Nov (18)	_Dec (32)
2013:	_Jan (44)	_Feb (53)	_Mar (32)	_Apr (46)	_May (16)	_Jun (8)	_Jul	_Aug	_Sep	_Oct	_Nov	_Dec

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

From: <Lanarel@us...> - 2010-05-03 18:19

Revision: 5856
          http://planeshift.svn.sourceforge.net/planeshift/?rev=5856&view=rev
Author:   Lanarel
Date:     2010-05-03 18:19:11 +0000 (Mon, 03 May 2010)

Log Message:
-----------
Corrected Torch entry in item_stats (fix by RlyDontKnow) so psserver now starts with svn db.

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

Modified: trunk/src/server/database/mysql/item_stats.sql
===================================================================
--- trunk/src/server/database/mysql/item_stats.sql	2010-05-03 13:23:10 UTC (rev 5855)
+++ trunk/src/server/database/mysql/item_stats.sql	2010-05-03 18:19:11 UTC (rev 5856)
@@ -265,7 +265,7 @@
 INSERT INTO `item_stats` VALUES (4815,'B','Forge',99999.00,100.00,1,50,16,'BULK','CONTAINER CANTRANSFORM',0.10,4,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,1.00,0.00,2.10,1.00,0.20,0.20,0.20,0.00,'items#chest','/planeshift/items/chest.dds','','','','','0',6,5000.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'A standard smith forge used to heat metal so it is malleable.','nosound',50,'',NULL,NULL,-1,2);
 INSERT INTO `item_stats` VALUES (4816,'B','Hammer',3.00,100.00,3,50,0,'BULK LEFTHAND RIGHTHAND','STACKABLE',0.10,4,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,1.00,0.00,2.10,1.00,0.20,0.20,0.20,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','Hammer',6,50.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'A simple smith hammer.','nosound',50,'',NULL,NULL,-1,2);
 INSERT INTO `item_stats` VALUES (236,'B','Quiver',1.00,100.00,1,20,16,'BULK LEFTHAND RIGHTHAND','CONTAINER',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,1.00,0.00,2.10,1.00,0.20,0.20,0.20,0.00,'potions#potion01a','/planeshift/potions/smallpotion01a_icon.dds','','','','','0',3,4.00,'GENERIC','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'A Quiver','nosound',50,'','','',-1,2);
-INSERT INTO `item_stats` VALUES (7331,'B','Torch',8.00,5.00,80,0,0,'BULK LEFTHAND RIGHTHAND','STACKABLE',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,9.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'items#torch','/planeshift/items/torch.png','','','','Torch',1,550.00,'TOOL','','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'A torch to light your way.','env.fire_small',50,'',NULL,NULL,-1,2);
+INSERT INTO `item_stats` VALUES (7331,'B','Torch',8.00,5.00,80,0,0,'BULK LEFTHAND RIGHTHAND','STACKABLE',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,9.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'items#torch','/planeshift/items/torch.png','','','','','Torch',1,550.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'A torch to light your way.','env.fire_small',50,'',NULL,NULL,-1,2);
 INSERT INTO `item_stats` VALUES (7332,'B','Campfire',8.00,5.00,80,0,0,'BULK','STACKABLE',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,9.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'items#campfire01a','/planeshift/items/campfire01a.dds','','','','','Campfire',1,550.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'A camp fire to keep you warm at night.','env.fire_medium',50,'',NULL,NULL,-1,2);
 INSERT INTO `item_stats` VALUES (4001,'B','Red Paperclip',10.00,5.00,1,0,0,'BULK,RIGHTHAND,LEFTHAND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','0',7,50.00,'GENERIC','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2);
 INSERT INTO `item_stats` VALUES (4002,'B','Sandwich Plate',1.00,500.00,65535,300,0,'BULK,RIGHTHAND,LEFTHAND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'items#chest','/planeshift/items/chest.dds','','','','','0',3,0.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2);


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

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

From: <rlydontknow@us...> - 2010-08-14 22:10

Revision: 6154
          http://planeshift.svn.sourceforge.net/planeshift/?rev=6154&view=rev
Author:   rlydontknow
Date:     2010-08-14 22:09:55 +0000 (Sat, 14 Aug 2010)

Log Message:
-----------
typo fix by botanic

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

Modified: trunk/src/server/database/mysql/item_stats.sql
===================================================================
--- trunk/src/server/database/mysql/item_stats.sql	2010-08-12 22:59:35 UTC (rev 6153)
+++ trunk/src/server/database/mysql/item_stats.sql	2010-08-14 22:09:55 UTC (rev 6154)
@@ -170,7 +170,7 @@
 INSERT INTO `item_stats` VALUES (71,'B','Gareths waybread recipe',1.00,25.00,1,0,0,'BULK MIND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,0.00,'RECIPE','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2);
 INSERT INTO `item_stats` VALUES (72,'B','Burnt bread',2.00,25.00,8,0,0,'BULK','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'money#circle_01a_01','/planeshift/money/circle01a_icon.dds','','','','','0',3,0.00,'FOOD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2);
 INSERT INTO `item_stats` VALUES (73,'B','Pile of dust',2.00,25.00,1,0,0,'BULK','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'money#circle_01a_01','/planeshift/money/circle01a_icon.dds','','','','','0',3,0.00,'GENERIC','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2);
-INSERT INTO `item_stats` VALUES (74,'B','Oven',1.00,500.00,65535,300,16,'','CONTAINER CANTRANSFORM',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'items#chest','/planeshift/items/chest.dds','','','''',,'0',3,0.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2);
+INSERT INTO `item_stats` VALUES (74,'B','Oven',1.00,500.00,65535,300,16,'','CONTAINER CANTRANSFORM',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'items#chest','/planeshift/items/chest.dds','','','','','0',3,0.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2);
 INSERT INTO `item_stats` VALUES (75,'B','Gobblygook',2.00,25.00,1,0,0,'BULK','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'money#circle_01a_01','/planeshift/money/circle01a_icon.dds','','','','','0',3,0.00,'GENERIC','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2);
 INSERT INTO `item_stats` VALUES (76,'B','Slop',2.00,25.00,1,0,0,'BULK','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'money#circle_01a_01','/planeshift/money/circle01a_icon.dds','','','','','0',3,0.00,'FOOD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2);
 INSERT INTO `item_stats` VALUES (77,'B','Nutty slop',2.00,25.00,1,0,0,'BULK','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'money#circle_01a_01','/planeshift/money/circle01a_icon.dds','','','','','0',3,0.00,'FOOD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2);


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

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

From: <weltall2@us...> - 2010-11-06 10:10

Revision: 6359
          http://planeshift.svn.sourceforge.net/planeshift/?rev=6359&view=rev
Author:   weltall2
Date:     2010-11-06 10:10:50 +0000 (Sat, 06 Nov 2010)

Log Message:
-----------
fixed schema

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

Modified: trunk/src/server/database/mysql/item_stats.sql
===================================================================
--- trunk/src/server/database/mysql/item_stats.sql	2010-11-06 10:04:19 UTC (rev 6358)
+++ trunk/src/server/database/mysql/item_stats.sql	2010-11-06 10:10:50 UTC (rev 6359)
@@ -57,7 +57,7 @@
   `cstr_gfx_texture` varchar(200) NOT NULL DEFAULT '',
   `cstr_part` varchar(200) NOT NULL DEFAULT '',
   `cstr_part_mesh` varchar(200) NOT NULL DEFAULT '',
-  `removed_mesh` varchar(200) NOT NULL COMMENT 'Lists the mesh to be removed when this item is equipped. It''s defined in this format slotname:mesh1,mesh2; slotname:mesh3; mesh4,mesh5. slotname is optional.',
+  `removed_mesh` varchar(200) NOT NULL DEFAULT '' COMMENT 'Lists the mesh to be removed when this item is equipped. It''s defined in this format slotname:mesh1,mesh2; slotname:mesh3; mesh4,mesh5. slotname is optional.',
   `armorvsweapon_type` varchar(20) DEFAULT NULL,
   `category_id` int(8) unsigned DEFAULT '0',
   `base_sale_price` float(10,2) DEFAULT '0.00',


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

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

From: <whacko88@us...> - 2011-08-31 19:27

Revision: 7627
          http://planeshift.svn.sourceforge.net/planeshift/?rev=7627&view=rev
Author:   whacko88
Date:     2011-08-31 19:27:03 +0000 (Wed, 31 Aug 2011)
Log Message:
-----------
added blank score to item_stats table

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

Modified: trunk/src/server/database/mysql/item_stats.sql
===================================================================
--- trunk/src/server/database/mysql/item_stats.sql	2011-08-31 06:20:46 UTC (rev 7626)
+++ trunk/src/server/database/mysql/item_stats.sql	2011-08-31 19:27:03 UTC (rev 7627)
@@ -255,6 +255,7 @@
 INSERT INTO `item_stats` VALUES (421,'B','Blank Map',1.00,5.00,1,0,0,'BULK LEFTHAND RIGHTHAND','STACKABLE BUY_PERSONALISE CREATIVE WRITEABLE',0.00,-1,1,1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,50.00,'GENERIC',NULL,0.00,NULL,0.00,NULL,0.00,'0',0,0.0000,0,0,0,0,NULL,'nosound',99,NULL,NULL,'<creative type=\"sketch\"><content><pages><page l=\"20\" t=\"50\" w=\"300\" h=\"400\"></page></pages></content></creative>',-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (462,'B','Armors repair kit',5.00,100.00,5,0,0,'BULK RIGHTHAND LEFTHAND','STACKABLE',0.10,30,-1,-1,'','','',0.00,0.00,0.00,0.00,0.00,0.00,1.00,0.00,0.00,0.00,0.00,0.00,'books#bookclosed01','/planeshift/potions/potion01c_icon.dds','','','','','0',2,50.00,'HAMMER','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'A kit of spare parts and tools that allows you to repair an armor','nosound',100,'',NULL,'',-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (423,'B','Public Blank Map',1.00,5.00,1,0,0,'BULK LEFTHAND RIGHTHAND','STACKABLE BUY_PERSONALISE CREATIVE WRITEABLE',0.00,-1,1,1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,50.00,'GENERIC',NULL,0.00,NULL,0.00,'0',0.00,'0',0,0.0000,0,0,0,0,NULL,'nosound',99,NULL,NULL,'<creative type=\"sketch\" creator=\"public\"><content><pages><page l=\"20\" t=\"50\" w=\"300\" h=\"400\"></page></pages></content></creative>',-1,2,"",'Y');
+INSERT INTO `item_stats` VALUES (424,'B','Blank Score',1.00,5.00,1,0,0,'BULK LEFTHAND RIGHTHAND','STACKABLE BUY_PERSONALISE CREATIVE WRITEABLE',0.00,-1,1,1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,50.00,'GENERIC',NULL,0.00,NULL,0.00,NULL,0.00,'0',0,0.0000,0,0,0,0,NULL,'nosound',99,NULL,NULL,'<creative type=\"sketch\"><content</content></creative>',-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (531,'B','Weapons repair kit',4.00,100.00,4,0,0,'BULK RIGHTHAND LEFTHAND','STACKABLE',0.10,33,-1,-1,'0','0','0',0.00,0.00,0.00,0.10,0.00,0.00,1.00,0.00,0.10,0.00,0.10,0.00,'books#bookclosed01','/planeshift/potions/potion01c_icon.dds','','','','','Hammer',1,40.00,'HAMMER','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'A kit of spare parts and tools that allows you to repair a weapon','nosound',1,'',NULL,'',-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (600,'B','Buffed Sword of Strength',7.00,5.00,100,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,6.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#broadsword01a','/planeshift/weapons/broadsword01a_icon.dds','','','','','Sabre',1,150.00,'SWORD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'<apply aim=\"Actor\" type=\"buff\" name=\"Sword Strength\"><str value=\"30\"/><skill name=\"Sword\" value=\"3\"/></apply>',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (601,'B','Buffed Sword of Negativity',7.00,5.00,100,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,6.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#broadsword01a','/planeshift/weapons/broadsword01a_icon.dds','','','','','Sabre',1,150.00,'SWORD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'<apply aim=\"Actor\" type=\"debuff\" name=\"Sword Negativity\"><str value=\"-50\"/><skill name=\"Sword\" value=\"-5\"/></apply>',NULL,NULL,-1,2,"",'Y');

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

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

From: <whacko88@us...> - 2011-08-31 19:34

Revision: 7628
          http://planeshift.svn.sourceforge.net/planeshift/?rev=7628&view=rev
Author:   whacko88
Date:     2011-08-31 19:34:42 +0000 (Wed, 31 Aug 2011)
Log Message:
-----------
fixed creative definition of blank score

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

Modified: trunk/src/server/database/mysql/item_stats.sql
===================================================================
--- trunk/src/server/database/mysql/item_stats.sql	2011-08-31 19:27:03 UTC (rev 7627)
+++ trunk/src/server/database/mysql/item_stats.sql	2011-08-31 19:34:42 UTC (rev 7628)
@@ -255,7 +255,7 @@
 INSERT INTO `item_stats` VALUES (421,'B','Blank Map',1.00,5.00,1,0,0,'BULK LEFTHAND RIGHTHAND','STACKABLE BUY_PERSONALISE CREATIVE WRITEABLE',0.00,-1,1,1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,50.00,'GENERIC',NULL,0.00,NULL,0.00,NULL,0.00,'0',0,0.0000,0,0,0,0,NULL,'nosound',99,NULL,NULL,'<creative type=\"sketch\"><content><pages><page l=\"20\" t=\"50\" w=\"300\" h=\"400\"></page></pages></content></creative>',-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (462,'B','Armors repair kit',5.00,100.00,5,0,0,'BULK RIGHTHAND LEFTHAND','STACKABLE',0.10,30,-1,-1,'','','',0.00,0.00,0.00,0.00,0.00,0.00,1.00,0.00,0.00,0.00,0.00,0.00,'books#bookclosed01','/planeshift/potions/potion01c_icon.dds','','','','','0',2,50.00,'HAMMER','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'A kit of spare parts and tools that allows you to repair an armor','nosound',100,'',NULL,'',-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (423,'B','Public Blank Map',1.00,5.00,1,0,0,'BULK LEFTHAND RIGHTHAND','STACKABLE BUY_PERSONALISE CREATIVE WRITEABLE',0.00,-1,1,1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,50.00,'GENERIC',NULL,0.00,NULL,0.00,'0',0.00,'0',0,0.0000,0,0,0,0,NULL,'nosound',99,NULL,NULL,'<creative type=\"sketch\" creator=\"public\"><content><pages><page l=\"20\" t=\"50\" w=\"300\" h=\"400\"></page></pages></content></creative>',-1,2,"",'Y');
-INSERT INTO `item_stats` VALUES (424,'B','Blank Score',1.00,5.00,1,0,0,'BULK LEFTHAND RIGHTHAND','STACKABLE BUY_PERSONALISE CREATIVE WRITEABLE',0.00,-1,1,1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,50.00,'GENERIC',NULL,0.00,NULL,0.00,NULL,0.00,'0',0,0.0000,0,0,0,0,NULL,'nosound',99,NULL,NULL,'<creative type=\"sketch\"><content</content></creative>',-1,2,"",'Y');
+INSERT INTO `item_stats` VALUES (424,'B','Blank Score',1.00,5.00,1,0,0,'BULK LEFTHAND RIGHTHAND','STACKABLE BUY_PERSONALISE CREATIVE WRITEABLE',0.00,-1,1,1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,50.00,'GENERIC',NULL,0.00,NULL,0.00,NULL,0.00,'0',0,0.0000,0,0,0,0,NULL,'nosound',99,NULL,NULL,'<creative type=\"music\"><content</content></creative>',-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (531,'B','Weapons repair kit',4.00,100.00,4,0,0,'BULK RIGHTHAND LEFTHAND','STACKABLE',0.10,33,-1,-1,'0','0','0',0.00,0.00,0.00,0.10,0.00,0.00,1.00,0.00,0.10,0.00,0.10,0.00,'books#bookclosed01','/planeshift/potions/potion01c_icon.dds','','','','','Hammer',1,40.00,'HAMMER','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'A kit of spare parts and tools that allows you to repair a weapon','nosound',1,'',NULL,'',-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (600,'B','Buffed Sword of Strength',7.00,5.00,100,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,6.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#broadsword01a','/planeshift/weapons/broadsword01a_icon.dds','','','','','Sabre',1,150.00,'SWORD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'<apply aim=\"Actor\" type=\"buff\" name=\"Sword Strength\"><str value=\"30\"/><skill name=\"Sword\" value=\"3\"/></apply>',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (601,'B','Buffed Sword of Negativity',7.00,5.00,100,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,6.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#broadsword01a','/planeshift/weapons/broadsword01a_icon.dds','','','','','Sabre',1,150.00,'SWORD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'<apply aim=\"Actor\" type=\"debuff\" name=\"Sword Negativity\"><str value=\"-50\"/><skill name=\"Sword\" value=\"-5\"/></apply>',NULL,NULL,-1,2,"",'Y');

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

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

From: <whacko88@us...> - 2011-08-31 19:43

Revision: 7629
          http://planeshift.svn.sourceforge.net/planeshift/?rev=7629&view=rev
Author:   whacko88
Date:     2011-08-31 19:43:27 +0000 (Wed, 31 Aug 2011)
Log Message:
-----------
fixed creative definition of blank score

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

Modified: trunk/src/server/database/mysql/item_stats.sql
===================================================================
--- trunk/src/server/database/mysql/item_stats.sql	2011-08-31 19:34:42 UTC (rev 7628)
+++ trunk/src/server/database/mysql/item_stats.sql	2011-08-31 19:43:27 UTC (rev 7629)
@@ -255,7 +255,7 @@
 INSERT INTO `item_stats` VALUES (421,'B','Blank Map',1.00,5.00,1,0,0,'BULK LEFTHAND RIGHTHAND','STACKABLE BUY_PERSONALISE CREATIVE WRITEABLE',0.00,-1,1,1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,50.00,'GENERIC',NULL,0.00,NULL,0.00,NULL,0.00,'0',0,0.0000,0,0,0,0,NULL,'nosound',99,NULL,NULL,'<creative type=\"sketch\"><content><pages><page l=\"20\" t=\"50\" w=\"300\" h=\"400\"></page></pages></content></creative>',-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (462,'B','Armors repair kit',5.00,100.00,5,0,0,'BULK RIGHTHAND LEFTHAND','STACKABLE',0.10,30,-1,-1,'','','',0.00,0.00,0.00,0.00,0.00,0.00,1.00,0.00,0.00,0.00,0.00,0.00,'books#bookclosed01','/planeshift/potions/potion01c_icon.dds','','','','','0',2,50.00,'HAMMER','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'A kit of spare parts and tools that allows you to repair an armor','nosound',100,'',NULL,'',-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (423,'B','Public Blank Map',1.00,5.00,1,0,0,'BULK LEFTHAND RIGHTHAND','STACKABLE BUY_PERSONALISE CREATIVE WRITEABLE',0.00,-1,1,1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,50.00,'GENERIC',NULL,0.00,NULL,0.00,'0',0.00,'0',0,0.0000,0,0,0,0,NULL,'nosound',99,NULL,NULL,'<creative type=\"sketch\" creator=\"public\"><content><pages><page l=\"20\" t=\"50\" w=\"300\" h=\"400\"></page></pages></content></creative>',-1,2,"",'Y');
-INSERT INTO `item_stats` VALUES (424,'B','Blank Score',1.00,5.00,1,0,0,'BULK LEFTHAND RIGHTHAND','STACKABLE BUY_PERSONALISE CREATIVE WRITEABLE',0.00,-1,1,1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,50.00,'GENERIC',NULL,0.00,NULL,0.00,NULL,0.00,'0',0,0.0000,0,0,0,0,NULL,'nosound',99,NULL,NULL,'<creative type=\"music\"><content</content></creative>',-1,2,"",'Y');
+INSERT INTO `item_stats` VALUES (424,'B','Blank Score',1.00,5.00,1,0,0,'BULK LEFTHAND RIGHTHAND','STACKABLE BUY_PERSONALISE CREATIVE WRITEABLE',0.00,-1,1,1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,50.00,'GENERIC',NULL,0.00,NULL,0.00,NULL,0.00,'0',0,0.0000,0,0,0,0,NULL,'nosound',99,NULL,NULL,'<creative type=\"music\"><content></content></creative>',-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (531,'B','Weapons repair kit',4.00,100.00,4,0,0,'BULK RIGHTHAND LEFTHAND','STACKABLE',0.10,33,-1,-1,'0','0','0',0.00,0.00,0.00,0.10,0.00,0.00,1.00,0.00,0.10,0.00,0.10,0.00,'books#bookclosed01','/planeshift/potions/potion01c_icon.dds','','','','','Hammer',1,40.00,'HAMMER','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'A kit of spare parts and tools that allows you to repair a weapon','nosound',1,'',NULL,'',-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (600,'B','Buffed Sword of Strength',7.00,5.00,100,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,6.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#broadsword01a','/planeshift/weapons/broadsword01a_icon.dds','','','','','Sabre',1,150.00,'SWORD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'<apply aim=\"Actor\" type=\"buff\" name=\"Sword Strength\"><str value=\"30\"/><skill name=\"Sword\" value=\"3\"/></apply>',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (601,'B','Buffed Sword of Negativity',7.00,5.00,100,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,6.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#broadsword01a','/planeshift/weapons/broadsword01a_icon.dds','','','','','Sabre',1,150.00,'SWORD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'<apply aim=\"Actor\" type=\"debuff\" name=\"Sword Negativity\"><str value=\"-50\"/><skill name=\"Sword\" value=\"-5\"/></apply>',NULL,NULL,-1,2,"",'Y');

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

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

From: <lpancallo@us...> - 2012-04-24 18:24

Revision: 8245
          http://planeshift.svn.sourceforge.net/planeshift/?rev=8245&view=rev
Author:   lpancallo
Date:     2012-04-24 18:24:09 +0000 (Tue, 24 Apr 2012)
Log Message:
-----------
made some items stackable for testing purposes

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

Modified: trunk/src/server/database/mysql/item_stats.sql
===================================================================
--- trunk/src/server/database/mysql/item_stats.sql	2012-04-24 17:44:34 UTC (rev 8244)
+++ trunk/src/server/database/mysql/item_stats.sql	2012-04-24 18:24:09 UTC (rev 8245)
@@ -98,17 +98,17 @@
 LOCK TABLES `item_stats` WRITE;
 /*!40000 ALTER TABLE `item_stats` DISABLE KEYS */;
 INSERT INTO `item_stats` VALUES (1,'B','Fist',0.00,100.00,0,0,0,'LEFTHAND RIGHTHAND','MELEEWEAPON',0.10,4,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,1.00,0.00,2.10,1.00,0.20,0.20,0.20,0.00,'','','','','','','Hammer',1,0.00,'HAMMER','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,1,"",'Y');
-INSERT INTO `item_stats` VALUES (2,'B','Small Battle Axe',5.00,5.00,100,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON',0.10,2,-1,-1,'0','0','0',0.00,0.00,0.00,5.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','Axe',1,350.00,'AXE','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','smallaxe',50,'',NULL,NULL,-1,2,"",'Y');
-INSERT INTO `item_stats` VALUES (3,'B','Battle Axe',10.00,5.00,150,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON',0.10,2,-1,-1,'0','0','0',0.00,0.00,0.00,5.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#doubleaxe02a','/planeshift/weapons/doubleaxe02a_icon.dds','','','','','Axe',1,650.00,'AXE','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
-INSERT INTO `item_stats` VALUES (4,'B','Broad Sword',7.00,5.00,100,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,6.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#broadsword01a','/planeshift/weapons/broadsword01a_icon.dds','','','','','Sabre',1,150.00,'SWORD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
-INSERT INTO `item_stats` VALUES (5,'B','Claymore',9.00,5.00,120,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,8.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#claymore01a','/planeshift/weapons/claymore01a_icon.dds','','','','','Claymore',1,800.00,'SWORD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,5,"",'Y');
-INSERT INTO `item_stats` VALUES (6,'B','Gold Falchion',8.00,5.00,80,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,9.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#falchion01a','/planeshift/weapons/falchion01a_icon.dds','','','','','Sabre',1,550.00,'SWORD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
-INSERT INTO `item_stats` VALUES (7,'B','Falchion',7.00,5.00,80,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#falchion01b','/planeshift/weapons/falchion01b_icon.dds','','','','','Sabre',1,500.00,'SWORD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
-INSERT INTO `item_stats` VALUES (8,'B','Steel Falchion',6.50,5.00,80,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#falchion01c','/planeshift/weapons/falchion01c_icon.dds','','','','','Sabre',1,450.00,'SWORD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
+INSERT INTO `item_stats` VALUES (2,'B','Small Battle Axe',5.00,5.00,100,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON STACKABLE',0.10,2,-1,-1,'0','0','0',0.00,0.00,0.00,5.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','Axe',1,350.00,'AXE','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','smallaxe',50,'',NULL,NULL,-1,2,"",'Y');
+INSERT INTO `item_stats` VALUES (3,'B','Battle Axe',10.00,5.00,150,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON STACKABLE',0.10,2,-1,-1,'0','0','0',0.00,0.00,0.00,5.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#doubleaxe02a','/planeshift/weapons/doubleaxe02a_icon.dds','','','','','Axe',1,650.00,'AXE','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
+INSERT INTO `item_stats` VALUES (4,'B','Broad Sword',7.00,5.00,100,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON STACKABLE',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,6.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#broadsword01a','/planeshift/weapons/broadsword01a_icon.dds','','','','','Sabre',1,150.00,'SWORD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
+INSERT INTO `item_stats` VALUES (5,'B','Claymore',9.00,5.00,120,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON STACKABLE',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,8.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#claymore01a','/planeshift/weapons/claymore01a_icon.dds','','','','','Claymore',1,800.00,'SWORD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,5,"",'Y');
+INSERT INTO `item_stats` VALUES (6,'B','Gold Falchion',8.00,5.00,80,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON STACKABLE',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,9.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#falchion01a','/planeshift/weapons/falchion01a_icon.dds','','','','','Sabre',1,550.00,'SWORD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
+INSERT INTO `item_stats` VALUES (7,'B','Falchion',7.00,5.00,80,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON STACKABLE',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#falchion01b','/planeshift/weapons/falchion01b_icon.dds','','','','','Sabre',1,500.00,'SWORD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
+INSERT INTO `item_stats` VALUES (8,'B','Steel Falchion',6.50,5.00,80,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON STACKABLE',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#falchion01c','/planeshift/weapons/falchion01c_icon.dds','','','','','Sabre',1,450.00,'SWORD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (9,'B','Mug',1.00,5.00,20,0,16,'BULK LEFTHAND RIGHTHAND MIND','CONTAINER',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,50.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
-INSERT INTO `item_stats` VALUES (10,'B','Hatchet',2.00,5.00,60,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON',0.10,2,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,4.00,0.00,0.00,0.00,0.20,0.00,'weapons#normalaxe01a','/planeshift/weapons/normalaxe01a_icon.dds','','','','','Axe',1,100.00,'AXE','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
-INSERT INTO `item_stats` VALUES (11,'B','Sabre',5.00,5.00,60,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,4.00,0.00,0.00,0.00,0.00,0.00,'weapons#sabre01a','/planeshift/weapons/sabre01a_icon.dds','','','','','Sabre',1,250.00,'SWORD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
-INSERT INTO `item_stats` VALUES (12,'B','Galkard',7.00,5.00,100,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,4.00,0.00,0.00,0.00,0.00,0.00,'weapons#galkard01a','/planeshift/weapons/galkard01a_icon.dds','','','','','Sabre',1,1000.00,'SWORD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
+INSERT INTO `item_stats` VALUES (10,'B','Hatchet',2.00,5.00,60,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON STACKABLE',0.10,2,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,4.00,0.00,0.00,0.00,0.20,0.00,'weapons#normalaxe01a','/planeshift/weapons/normalaxe01a_icon.dds','','','','','Axe',1,100.00,'AXE','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
+INSERT INTO `item_stats` VALUES (11,'B','Sabre',5.00,5.00,60,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON STACKABLE',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,4.00,0.00,0.00,0.00,0.00,0.00,'weapons#sabre01a','/planeshift/weapons/sabre01a_icon.dds','','','','','Sabre',1,250.00,'SWORD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
+INSERT INTO `item_stats` VALUES (12,'B','Galkard',7.00,5.00,100,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON STACKABLE',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,4.00,0.00,0.00,0.00,0.00,0.00,'weapons#galkard01a','/planeshift/weapons/galkard01a_icon.dds','','','','','Sabre',1,1000.00,'SWORD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (13,'B','Arrow',0.00,5.00,40,0,0,'BULK,CRYSTAL','STACKABLE,GLYPH',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'crystal_way#glyph_crystal_01a','glyph_arrow_icon.dds','','','','','0',5,2000.00,'GLYPH','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (14,'B','Door',0.00,5.00,300,0,0,'BULK,CRYSTAL','STACKABLE,GLYPH',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'crystal_way#glyph_crystal_01a','glyph_door_icon.dds','','','','','0',5,2000.00,'GLYPH','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (15,'B','Energy',0.00,5.00,1,0,0,'BULK,CRYSTAL','STACKABLE,GLYPH',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'crystal_way#glyph_crystal_01a','glyph_energy_icon.dds','','','','','0',5,2000.00,'GLYPH','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');

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

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

From: <lpancallo@us...> - 2012-06-03 12:28

Revision: 8347
          http://planeshift.svn.sourceforge.net/planeshift/?rev=8347&view=rev
Author:   lpancallo
Date:     2012-06-03 12:28:07 +0000 (Sun, 03 Jun 2012)
Log Message:
-----------
fixed comments, which seem to give an error on linux

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

Modified: trunk/src/server/database/mysql/item_stats.sql
===================================================================
--- trunk/src/server/database/mysql/item_stats.sql	2012-06-01 22:49:36 UTC (rev 8346)
+++ trunk/src/server/database/mysql/item_stats.sql	2012-06-03 12:28:07 UTC (rev 8347)
@@ -112,7 +112,7 @@
 INSERT INTO `item_stats` VALUES (11,'B','Sabre',5.00,5.00,60,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON STACKABLE',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,4.00,0.00,0.00,0.00,0.00,0.00,'weapons#sabre01a','/planeshift/weapons/sabre01a_icon.dds','','','','','Sabre',1,250.00,'SWORD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (12,'B','Galkard',7.00,5.00,100,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON STACKABLE',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,4.00,0.00,0.00,0.00,0.00,0.00,'weapons#galkard01a','/planeshift/weapons/galkard01a_icon.dds','','','','','Sabre',1,1000.00,'SWORD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
 
---Glyphs
+-- Glyphs
 INSERT INTO `item_stats` VALUES (13,'B','Arrow',0.00,5.00,40,0,0,'BULK RIGHTHAND LEFTHAND CRYSTAL','STACKABLE,GLYPH',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'crystal_way#glyph_crystal_01a','glyph_arrow_icon.dds','','','','','0',5,2000.00,'GLYPH','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (14,'B','Door',0.00,5.00,300,0,0,'BULK,CRYSTAL','STACKABLE,GLYPH',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'crystal_way#glyph_crystal_01a','glyph_door_icon.dds','','','','','0',5,2000.00,'GLYPH','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (15,'B','Energy',0.00,5.00,1,0,0,'BULK,CRYSTAL','STACKABLE,GLYPH',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'crystal_way#glyph_crystal_01a','glyph_energy_icon.dds','','','','','0',5,2000.00,'GLYPH','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
@@ -191,7 +191,7 @@
 
 INSERT INTO `item_stats` VALUES (90,'B','Mixer',2.00,5.00,25,0,0,'BULK LEFTHAND RIGHTHAND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,1.00,0.00,0.00,0.00,0.10,0.00,'weapons#normalaxe01a','/planeshift/weapons/normalaxe01a_icon.dds','','','','','0',1,0.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
 
---Mining
+-- Mining
 INSERT INTO `item_stats` VALUES (84,'B','Rock Pick',5.00,5.00,1,0,0,'BULK, RIGHTHAND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,10.00,0.00,10.00,1.00,2.00,3.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','0',6,0.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (85,'B','Gold Ore',10.00,5.00,1,0,0,'BULK,RIGHTHAND,LEFTHAND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','Hammer',16,50.00,'GENERIC','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (102,'B','Iron Ore',10.00,5.00,1,0,0,'BULK,RIGHTHAND,LEFTHAND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','Hammer',16,50.00,'GENERIC','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
@@ -200,13 +200,13 @@
 INSERT INTO `item_stats` VALUES (105,'B','Smelter',1.00,500.00,65535,300,16,'','CONTAINER CANTRANSFORM',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'items#chest','/planeshift/items/chest.dds','','','','','0',3,0.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (106,'B','Hot Coke',10.00,5.00,1,0,0,'','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','0',7,50.00,'GENERIC','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
 
---Money
+-- Money
 INSERT INTO `item_stats` VALUES (86,'B','Tria',10.00,5.00,1,0,0,'TRIA','TRIA',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','n/a',21,1.00,'GENERIC','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (87,'B','Hexa',10.00,5.00,1,0,0,'HEXA','HEXA',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','n/a',21,6.00,'GENERIC','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (88,'B','Octa',10.00,5.00,1,0,0,'OCTA','OCTA',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','n/a',21,55.00,'GENERIC','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (89,'B','Circle',10.00,5.00,1,0,0,'CIRCLE','CIRCLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','n/a',21,275.00,'GENERIC','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
 
---Potions
+-- Potions
 INSERT INTO `item_stats` VALUES (91,'B','Potion of Speed',0.00,100.00,1,1,0,'BULK','STACKABLE CONSUMABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'potions#potion01a','/planeshift/potions/potion01a_icon.dds','','','','','0',7,0.00,NULL,NULL,0.00,NULL,0.00,NULL,0.00,'0',NULL,0.0000,NULL,0,NULL,0,'0','nosound',50,'','drink_speed_potion',NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (92,'B','Potion of Confusion',0.00,100.00,1,1,0,'BULK','STACKABLE CONSUMABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'potions#potion01b','/planeshift/potions/potion01b_icon.dds','','','','','0',7,0.00,NULL,NULL,0.00,NULL,0.00,NULL,0.00,'0',NULL,0.0000,NULL,0,NULL,0,'0','nosound',50,'','drink_strange_potion',NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (93,'B','Potion No Pickup',0.00,100.00,1,1,0,'BULK','STACKABLE CONSUMABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'potions#potion01a','/planeshift/potions/potion01a_icon.dds','','','','','0',7,0.00,NULL,NULL,0.00,NULL,0.00,NULL,0.00,'0',NULL,0.0000,NULL,0,NULL,0,'0','nosound',50,'','drink_potion',NULL,-1,2,"",'Y');
@@ -232,7 +232,7 @@
 INSERT INTO `item_stats` VALUES (118,'B','Clay Mold',5.00,5.00,1,0,0,'BULK, RIGHTHAND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,10.00,0.00,10.00,1.00,2.00,3.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','0',6,0.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (119,'B','Casting Mold',5.00,5.00,1,0,0,'BULK, RIGHTHAND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,10.00,0.00,10.00,1.00,2.00,3.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','0',6,0.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
 
---Fishing
+-- Fishing
 INSERT INTO `item_stats` VALUES (120,'B','Fishing reel design',1.00,25.00,1,0,0,'BULK MIND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,0.00,'RECIPE','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (121,'B','Fishing Reel',5.00,5.00,1,0,0,'BULK','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,10.00,0.00,10.00,1.00,2.00,3.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','0',6,0.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (122,'B','Fishing Rod',1.00,25.00,40,35,16,'BULK LEFTHAND RIGHTHAND','CONTAINER',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,0.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
@@ -256,7 +256,7 @@
 INSERT INTO `item_stats` VALUES (409,'B','Long Bow',2.00,100.00,1,5,0,'BULK RIGHTHAND LEFTHAND','RANGEWEAPON USESAMMO',0.10,6,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,9.00,2.00,7.00,0.00,0.00,0.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','/planeshift/weapons/doubleaxe01a_icon.dds','','','','Stick',1,25.00,'BOW','',0.00,'',0.00,'',0.00,'410',0,0.0000,0,0,0,1,'A long bow of normal quality. Common among rangers and is reputed for its long range.','nosound',50,'',NULL,NULL,-1,20,"",'Y');
 INSERT INTO `item_stats` VALUES (410,'B','Bronze Arrow',0.25,100.00,1,1,0,'BULK RIGHTHAND LEFTHAND','AMMO STACKABLE EQUIP_STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','/planeshift/weapons/doubleaxe01a_icon.dds','','','','Arrow',1,0.00,'ARROW',NULL,0.00,NULL,0.00,NULL,0.00,'0',NULL,0.0000,NULL,0,NULL,0,'Simple bronze arrows that deal a bit less damage than iron arrows. These are cheap and easily available in huge amounts.','nosound',50,NULL,NULL,NULL,-1,2,"",'Y');
 
---Summon Pets
+-- Summon Pets
 INSERT INTO `item_stats` VALUES (411,'B','Ring of Familiar',1.00,100.00,1,0,0,'BULK RIGHTFINGER LEFTFINGER','QUESTITEM STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,1.00,0.00,2.10,1.00,0.20,0.20,0.20,0.00,'potions#potion01a','/planeshift/potions/smallpotion01a_icon.dds','','','','','0',3,400.00,'GENERIC','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'','nosound',50,'<apply aim=\"Actor\" name=\"Familiar Link\" type=\"buff\"><can-summon-familiar/><msg text=\"You feel the link with your familiar grow stronger.\" undo=\"The link with your familiar feels weaker.\"/></apply>',NULL,NULL,1,2,"",'Y');
 
 INSERT INTO `item_stats` VALUES (412,'B','Small Box',1.00,10.00,70,65,16,'BULK','CONTAINER',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','3c',3,200.00,'CONTAINER','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
@@ -274,7 +274,7 @@
 INSERT INTO `item_stats` VALUES (462,'B','Armors repair kit',5.00,100.00,5,0,0,'BULK RIGHTHAND LEFTHAND','STACKABLE',0.10,30,-1,-1,'','','',0.00,0.00,0.00,0.00,0.00,0.00,1.00,0.00,0.00,0.00,0.00,0.00,'books#bookclosed01','/planeshift/potions/potion01c_icon.dds','','','','','0',2,50.00,'HAMMER','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'A kit of spare parts and tools that allows you to repair an armor','nosound',100,'',NULL,'',-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (531,'B','Weapons repair kit',4.00,100.00,4,0,0,'BULK RIGHTHAND LEFTHAND','STACKABLE',0.10,33,-1,-1,'0','0','0',0.00,0.00,0.00,0.10,0.00,0.00,1.00,0.00,0.10,0.00,0.10,0.00,'books#bookclosed01','/planeshift/potions/potion01c_icon.dds','','','','','Hammer',1,40.00,'HAMMER','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'A kit of spare parts and tools that allows you to repair a weapon','nosound',1,'',NULL,'',-1,2,"",'Y');
 
---Maps
+-- Maps
 INSERT INTO `item_stats` VALUES (419,'B','Treasure Map',1.00,5.00,1,0,0,'BULK LEFTHAND RIGHTHAND','STACKABLE CREATIVE',0.00,-1,1,1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,50.00,'GENERIC',NULL,0.00,NULL,0.00,NULL,0.00,'0',0,0.0000,0,0,0,0,NULL,'nosound',99,NULL,NULL,'<creative type=\"sketch\"><content><pages><page l=\"20\" t=\"50\" w=\"300\" h=\"400\"><ic x=\"364\" y=\"260\" i=\"x_01\"/><tx x=\"356\" y=\"292\" t=\"Treasure!\"/><ic x=\"40\" y=\"40\" i=\"house_01\"/><ic x=\"60\" y=\"60\" i=\"house_01\"/><ic x=\"20\" y=\"60\" i=\"house_01\"/><ic x=\"65\" y=\"205\" i=\"grass_01\"/><ic x=\"94\" y=\"196\" i=\"grass_01\"/><ic x=\"237\" y=\"112\" i=\"dec_07\"/><ic x=\"249\" y=\"118\" i=\"dec_07\"/><ic x=\"227\" y=\"120\" i=\"dec_07\"/><ic x=\"124\" y=\"205\" i=\"grass_01\"/><ic x=\"110\" y=\"226\" i=\"grass_01\"/><ic x=\"76\" y=\"225\" i=\"grass_01\"/><ic x=\"75\" y=\"205\" i=\"city_01\"/><tx x=\"23\" y=\"94\" t=\"Outpost\"/><ln pts=\"93 89 165 83\"/><ln pts=\"164 83 269 99\"/><ln pts=\"270 98 286 138\"/><ln pts=\"286 139 268 161\"/><ln pts=\"268 162 197 154\"/></page></pages></content></creative>',-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (421,'B','Blank Map',1.00,5.00,1,0,0,'BULK LEFTHAND RIGHTHAND','STACKABLE BUY_PERSONALISE CREATIVE WRITEABLE',0.00,-1,1,1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,50.00,'GENERIC',NULL,0.00,NULL,0.00,NULL,0.00,'0',0,0.0000,0,0,0,0,NULL,'nosound',99,NULL,NULL,'<creative type=\"sketch\"><content><pages><page l=\"20\" t=\"50\" w=\"300\" h=\"400\"></page></pages></content></creative>',-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (423,'B','Public Blank Map',1.00,5.00,1,0,0,'BULK LEFTHAND RIGHTHAND','STACKABLE BUY_PERSONALISE CREATIVE WRITEABLE',0.00,-1,1,1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,50.00,'GENERIC',NULL,0.00,NULL,0.00,'0',0.00,'0',0,0.0000,0,0,0,0,NULL,'nosound',99,NULL,NULL,'<creative type=\"sketch\" creator=\"public\"><content><pages><page l=\"20\" t=\"50\" w=\"300\" h=\"400\"></page></pages></content></creative>',-1,2,"",'Y');
@@ -282,7 +282,7 @@
 -- Music
 INSERT INTO `item_stats` VALUES (424,'B','Blank Score',1.00,5.00,1,0,0,'BULK LEFTHAND RIGHTHAND','STACKABLE BUY_PERSONALISE CREATIVE WRITEABLE',0.00,-1,1,1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,50.00,'GENERIC',NULL,0.00,NULL,0.00,NULL,0.00,'0',0,0.0000,0,0,0,0,NULL,'nosound',99,NULL,NULL,'<creative type=\"music\"><content></content></creative>',-1,2,"",'Y');
 
---Buff items
+-- Buff items
 INSERT INTO `item_stats` VALUES (129,'B','Ring of HP',1.00,25.00,1,0,0,'BULK LEFTFINGER RIGHTFINGER','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,0.00,'GENERIC','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'<apply aim=\"Actor\" type=\"buff\" name=\"Extra HP\"><hp-max value=\"100\"/></apply>',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (130,'B','Ring of mana',1.00,25.00,1,0,0,'BULK LEFTFINGER RIGHTFINGER','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,0.00,'GENERIC','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'<apply aim=\"Actor\" type=\"buff\" name=\"Extra Mana\"><mana-max value=\"50\"/></apply>',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (131,'B','Ring of strength',1.00,25.00,1,0,0,'BULK LEFTFINGER RIGHTFINGER','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,0.00,'GENERIC','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'<apply aim=\"Actor\" type=\"buff\" name=\"Strong\"><str value=\"10\"/><msg text=\"You feel stronger.\" undo=\"You feel weaker.\"/></apply>',NULL,NULL,-1,2,"",'Y');
@@ -293,13 +293,13 @@
 INSERT INTO `item_stats` VALUES (601,'B','Buffed Sword of Negativity',7.00,5.00,100,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,6.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#broadsword01a','/planeshift/weapons/broadsword01a_icon.dds','','','','','Sabre',1,150.00,'SWORD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'<apply aim=\"Actor\" type=\"debuff\" name=\"Sword Negativity\"><str value=\"-50\"/><skill name=\"Sword\" value=\"-5\"/></apply>',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (602,'B','Sword of Variables',7.00,5.00,100,0,0,'BULK LEFTHAND RIGHTHAND','MELEEWEAPON',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,6.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#broadsword01a','/planeshift/weapons/broadsword01a_icon.dds','','','','','Sabre',1,150.00,'SWORD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'<apply aim=\"Actor\" type=\"buff\" name=\"Sword of Variables\"><variable-int name=\"Myvariable\" value=\"50\"/></apply>',NULL,NULL,-1,2,"",'Y');
 
---Test on books
+-- Test on books
 INSERT INTO `item_stats` VALUES (101,'B','Book',1.00,5.00,20,0,0,'BULK LEFTHAND RIGHTHAND MIND','READABLE CREATIVE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,50.00,'GENERIC','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'A book.','nosound',50,'',NULL,'<creative type=\"literature\"><content><Contents><Content type=\"text\">This is a text content. The next line is images that are displayed in a row with left align. The paddings are \"5,5,0,0\".</Content><Content type=\"pic\" align=\"0\" padding=\"5 5 0 0\" width=\"32\" height=\"32\" src=\"ButtonSpeak;/paws/real_skin/mouse.png;ButtonOpen;\"></Content><Content type=\"text\">center align;padding 5 5 5 5; the src attributes could be defined in VFS style or specified as texture recources managed by texturemanager.</Content><Content type=\"pic\" align=\"1\" padding=\"5 5 5 5\" width=\"32\" height=\"32\" src=\"ButtonCombine;/paws/real_skin/mouse.png;ButtonPush;\"></Content><Content type=\"text\">right align;padding 5 5 5 5;</Content><Content type=\"pic\" align=\"2\" padding=\"5 5 5 5\" width=\"32\" height=\"32\" src=\"ButtonConstruct;/paws/real_skin/mouse.png;ButtonBanking;\"></Content><Content type=\"text\">Files options.cfg: This file contains some camera-settingsplaneshift.cfg: This file contains additional settings, like the email seen on the login-screen and options which can be set via the pssetup application.questnotes_YourCharactersFirstName_YourCharactersLastName.xml: This file contains all the notes you made on the quests you have done.</Content></Contents></content></creative>',-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (232,'B','Blank Book',1.00,5.00,20,0,0,'BULK LEFTHAND RIGHTHAND','READABLE WRITEABLE BUY_PERSONALISE CREATIVE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,50.00,'BOOK','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'A book written solely by the owner.','nosound',50,'',NULL,'<creative type=\"literature\"><content>GENERIC</content></creative>',-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (233,'B','Blank Public Book',1.00,5.00,20,0,0,'BULK LEFTHAND RIGHTHAND','READABLE WRITEABLE BUY_PERSONALISE CREATIVE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,50.00,'BOOK','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'A book for contributions by anyone.','nosound',50,'',NULL,'<creative type=\"literature\" creator=\"public\"><content>GENERIC</content></creative>',-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (2008,'B','Book of the bug fixer',2.00,100.00,1,0,0,'BULK','READABLE CREATIVE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,1.00,0.00,2.10,1.00,0.20,0.20,0.20,0.00,'potions#potion01a','/planeshift/potions/smallpotion01a_icon.dds','','','','','0',13,100.00,'GENERIC','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'A book.','nosound',50,'',NULL,'<creative type=\"literature\"><content>Bards tell that there are magical ways to fix bugs. The knowledge you have to obtain can be found in the Dark Way.</content></creative>',-1,2,"",'Y');
 
---Test on crafting
+-- Test on crafting
 INSERT INTO `item_stats` VALUES (3013,'B','Catalog of Shields',1.00,100.00,15,0,0,'BULK MIND','STACKABLE',0.10,4,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,1.00,0.00,2.10,1.00,0.20,0.20,0.20,0.00,'books#bookclosed01','/planeshift/potions/potion01c_icon.dds','','','','','0',15,400.00,'RECIPE','',0.00,'',0.00,'',0.00,'0',0,0.0000,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,'',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (4000,'B','Round Shield',7.00,5.00,100,0,0,'BULK LEFTHAND RIGHTHAND','STACKABLE',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,6.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'weapons#round_shield_01a','/planeshift/weapons/roundshield01a_icon.dds','','','','','0',1,150.00,'SHIELD','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (4085,'B','Heated Iron Stock',3.00,100.00,5,0,0,'BULK LEFTHAND RIGHTHAND','STACKABLE EQUIP_STACKABLE',0.10,4,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,1.00,0.00,2.10,1.00,0.20,0.20,0.20,0.00,'potions#potion01a','/planeshift/potions/smallpotion01a_icon.dds','','','','','0',16,10.00,'','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'Long metal bars of iron used in smiting that are yellow hot.','nosound',50,'',NULL,NULL,-1,2,"",'Y');
@@ -321,7 +321,7 @@
 INSERT INTO `item_stats` VALUES (4009,'B','Silver Penny',5.00,5.00,1,0,0,'BULK, RIGHTHAND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,10.00,0.00,10.00,1.00,2.00,3.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','0',6,0.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (9001,'B','Trap of Final Flash',8.00,5.00,80,0,0,'BULK','STACKABLE CONSTRUCTIBLE TRAP',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,9.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'items#campfire01a','/planeshift/items/campfire01a.dds','','','','','Trap',26,550.00,'TRAP','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'A trap kit. Place it anywhere you like and watch the unlucky soul who steps on it get blown to little bits.','nosound',50,'','vegeta',NULL,-1,2,"",'Y');
 
---Test on mining
+-- Test on mining
 INSERT INTO `item_stats` VALUES (9002,'B','Silver Ore',10.00,5.00,1,0,0,'BULK,RIGHTHAND,LEFTHAND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','Hammer',7,50.00,'GENERIC','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (9003,'B','Tin Ore',10.00,5.00,1,0,0,'BULK,RIGHTHAND,LEFTHAND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','Hammer',7,50.00,'GENERIC','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (9004,'B','Platinum Ore',10.00,5.00,1,0,0,'BULK,RIGHTHAND,LEFTHAND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','Hammer',7,50.00,'GENERIC','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');

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

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

From: <lpancallo@us...> - 2012-06-29 17:10

Revision: 8369
          http://planeshift.svn.sourceforge.net/planeshift/?rev=8369&view=rev
Author:   lpancallo
Date:     2012-06-29 17:10:23 +0000 (Fri, 29 Jun 2012)
Log Message:
-----------
advanced crafting container is no more auto-transform in test data.

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

Modified: trunk/src/server/database/mysql/item_stats.sql
===================================================================
--- trunk/src/server/database/mysql/item_stats.sql	2012-06-29 14:31:30 UTC (rev 8368)
+++ trunk/src/server/database/mysql/item_stats.sql	2012-06-29 17:10:23 UTC (rev 8369)
@@ -329,7 +329,7 @@
 -- Advanced crafting
 INSERT INTO `item_stats` VALUES (673,'B','Ruby Crystal',2,100,3,0,0,'BULK RIGHTHAND LEFTHAND','STACKABLE',0.1,-1,-1,-1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'naturalres#crystal_ruby','/planeshift/materials/crystalruby_icon.dds','','','','','',16,1,'GENERIC','',0,'',0,'',0,0,0,0,0,0,0,1,'A ruby crystal','nosound',50,'','','',-1,2,'','Y');
 INSERT INTO `item_stats` VALUES (3034,'B','Enchanting Gems',1,100,0.5,0,0,'BULK MIND','STACKABLE',0.1,-1,-1,-1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'books#bookclosed01','/planeshift/materials/bookclosed01_icon.dds','','','','','',15,500,'RECIPE','',0,'',0,'',0,0,0,0,0,0,0,1,'Book of Enchanting Gems','nosound',50,'','','',-1,2,'','Y');
-INSERT INTO `item_stats` VALUES (4928,'B','Enchanter',2,100,6,100,24,'BULK','CONTAINER CANTRANSFORM',0.1,-1,-1,-1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'tools#alchemy_forge01a','/planeshift/materials/ironpot02a_icon.dds','','','','','',9,500,'TOOL','',0,'',0,'',0,0,0,0,0,0,0,1,'A magical artifact used to enchant gems','nosound',50,'','','',-1,2,'','Y');
+INSERT INTO `item_stats` VALUES (4928,'B','Enchanter',2,100,6,100,24,'BULK','CONTAINER',0.1,-1,-1,-1,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'tools#alchemy_forge01a','/planeshift/materials/ironpot02a_icon.dds','','','','','',9,500,'TOOL','',0,'',0,'',0,0,0,0,0,0,0,1,'A magical artifact used to enchant gems','nosound',50,'','','',-1,2,'','Y');
 
 
 /*!40000 ALTER TABLE `item_stats` ENABLE KEYS */;

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

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

From: <lpancallo@us...> - 2012-12-19 18:24

Revision: 8514
          http://planeshift.svn.sourceforge.net/planeshift/?rev=8514&view=rev
Author:   lpancallo
Date:     2012-12-19 18:24:17 +0000 (Wed, 19 Dec 2012)
Log Message:
-----------
Changed some IDs to avoid conflict with production data.

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

Modified: trunk/src/server/database/mysql/item_stats.sql
===================================================================
--- trunk/src/server/database/mysql/item_stats.sql	2012-12-19 18:12:53 UTC (rev 8513)
+++ trunk/src/server/database/mysql/item_stats.sql	2012-12-19 18:24:17 UTC (rev 8514)
@@ -311,14 +311,14 @@
 INSERT INTO `item_stats` VALUES (7074,'B','Small Tent',30.000,100.00,150.000,0,0,'BULK','STACKABLE',0.01,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,1.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'items#tentsmall_01','/planeshift/materials/food_generic01a_icon.dds','','','','','0',51,1000.00,'GENERIC','NULL',0.00,'NULL',0.00,'NULL',0.00,'0',0,0.0000,0,0,0,1,'A small tent','nosound',100,'','','',-1,2,'','Y');
 INSERT INTO `item_stats` VALUES (7331,'B','Torch',8.00,5.00,80,0,0,'BULK LEFTHAND RIGHTHAND','STACKABLE',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,9.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'items#torch','/planeshift/items/torch.png','','','','','Torch',1,550.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'A torch to light your way.','env.fire_small',50,'',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (7332,'B','Campfire',8.00,5.00,80,0,0,'BULK','STACKABLE',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,9.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'items#campfire01a','/planeshift/items/campfire01a.dds','','','','','Campfire',1,550.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'A camp fire to keep you warm at night.','env.fire_medium',50,'',NULL,NULL,-1,2,"",'Y');
-INSERT INTO `item_stats` VALUES (4001,'B','Red Paperclip',10.00,5.00,1,0,0,'BULK,RIGHTHAND,LEFTHAND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','0',7,50.00,'GENERIC','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
-INSERT INTO `item_stats` VALUES (4002,'B','Sandwich Plate',1.00,500.00,65535,300,0,'BULK,RIGHTHAND,LEFTHAND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'items#chest','/planeshift/items/chest.dds','','','','','0',3,0.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
-INSERT INTO `item_stats` VALUES (4003,'B','Artisan Waybread',5.00,5.00,1,0,0,'BULK, RIGHTHAND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,10.00,0.00,10.00,1.00,2.00,3.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','0',6,0.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
-INSERT INTO `item_stats` VALUES (4005,'B','Corned Beef',5.00,5.00,1,0,0,'BULK, RIGHTHAND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,10.00,0.00,10.00,1.00,2.00,3.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','0',6,0.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
-INSERT INTO `item_stats` VALUES (4006,'B','Smoked Provolone',1.00,25.00,1,0,0,'BULK MIND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,0.00,'RECIPE','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
-INSERT INTO `item_stats` VALUES (4007,'B','Sublime Sandwich',10.00,5.00,1,0,0,'BULK,RIGHTHAND,LEFTHAND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','0',7,50.00,'GENERIC','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
-INSERT INTO `item_stats` VALUES (4008,'B','Condiment Recipe',1.00,500.00,65535,300,0,'BULK,RIGHTHAND,LEFTHAND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'items#chest','/planeshift/items/chest.dds','','','','','0',3,0.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
-INSERT INTO `item_stats` VALUES (4009,'B','Silver Penny',5.00,5.00,1,0,0,'BULK, RIGHTHAND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,10.00,0.00,10.00,1.00,2.00,3.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','0',6,0.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
+INSERT INTO `item_stats` VALUES (14001,'B','Red Paperclip',10.00,5.00,1,0,0,'BULK,RIGHTHAND,LEFTHAND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','0',7,50.00,'GENERIC','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
+INSERT INTO `item_stats` VALUES (14002,'B','Sandwich Plate',1.00,500.00,65535,300,0,'BULK,RIGHTHAND,LEFTHAND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'items#chest','/planeshift/items/chest.dds','','','','','0',3,0.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
+INSERT INTO `item_stats` VALUES (14003,'B','Artisan Waybread',5.00,5.00,1,0,0,'BULK, RIGHTHAND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,10.00,0.00,10.00,1.00,2.00,3.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','0',6,0.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
+INSERT INTO `item_stats` VALUES (14005,'B','Corned Beef',5.00,5.00,1,0,0,'BULK, RIGHTHAND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,10.00,0.00,10.00,1.00,2.00,3.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','0',6,0.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
+INSERT INTO `item_stats` VALUES (14006,'B','Smoked Provolone',1.00,25.00,1,0,0,'BULK MIND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#jug01a','/planeshift/weapons/jug01a_icon.dds','','','','','0',3,0.00,'RECIPE','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
+INSERT INTO `item_stats` VALUES (14007,'B','Sublime Sandwich',10.00,5.00,1,0,0,'BULK,RIGHTHAND,LEFTHAND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','0',7,50.00,'GENERIC','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
+INSERT INTO `item_stats` VALUES (14008,'B','Condiment Recipe',1.00,500.00,65535,300,0,'BULK,RIGHTHAND,LEFTHAND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'items#chest','/planeshift/items/chest.dds','','','','','0',3,0.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,0,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
+INSERT INTO `item_stats` VALUES (14009,'B','Silver Penny',5.00,5.00,1,0,0,'BULK, RIGHTHAND','STACKABLE',0.10,-1,-1,-1,'0','0','0',0.00,0.00,0.00,0.00,0.00,10.00,0.00,10.00,1.00,2.00,3.00,0.00,'weapons#doubleaxe01a','/planeshift/weapons/doubleaxe01a_icon.dds','','','','','0',6,0.00,'TOOL','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'0','nosound',50,'',NULL,NULL,-1,2,"",'Y');
 INSERT INTO `item_stats` VALUES (9001,'B','Trap of Final Flash',8.00,5.00,80,0,0,'BULK','STACKABLE CONSTRUCTIBLE TRAP',0.10,0,-1,-1,'0','0','0',0.00,0.00,0.00,9.00,0.00,0.00,4.00,2.00,0.20,0.20,0.20,0.00,'items#campfire01a','/planeshift/items/campfire01a.dds','','','','','Trap',26,550.00,'TRAP','',0.00,'',0.00,'',0.00,'0',0,0.0000,0,0,0,1,'A trap kit. Place it anywhere you like and watch the unlucky soul who steps on it get blown to little bits.','nosound',50,'','vegeta',NULL,-1,2,"",'Y');
 
 -- Test on mining

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