[Planeshift-cvs] CVS: planeshift/src/server/database/mysql item_instances.sql,1.40,1.41 item_stats.sql,1.65,1.66 progress_events.sql,1.31,1.32

[Luca P. <lpa...@us...>]

Update of /cvsroot/planeshift/planeshift/src/server/database/mysql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv12920

Modified Files:
	item_instances.sql item_stats.sql progress_events.sql 
Log Message:
fixed potions to enable more test cases

Index: item_instances.sql
===================================================================
RCS file: /cvsroot/planeshift/planeshift/src/server/database/mysql/item_instances.sql,v
retrieving revision 1.40
retrieving revision 1.41
diff -C2 -d -r1.40 -r1.41
*** item_instances.sql	15 Dec 2005 19:54:27 -0000	1.40
--- item_instances.sql	3 Feb 2006 14:06:36 -0000	1.41
***************
*** 90,96 ****
  INSERT INTO item_instances VALUES (49,3,0,3,1,5,0,0,0.00,0.00,0.00,0.00,1,1.00,71,0,'I','0','',0,-1, '');
  INSERT INTO item_instances VALUES (50,3,0,4,1,5,0,0,0.00,0.00,0.00,0.00,1,1.00,69,0,'I','0','',0,-1, '');
! INSERT INTO item_instances VALUES (51,0,0,0,1,0,0,3,-6.67,0.12,-140.50,0.00,1,1.00,91,0,'0',NULL,'NOPICKUP',0,-1, '');
! INSERT INTO item_instances VALUES (52,0,0,0,1,0,0,3,-6.67,0.12,-142.50,0.00,1,1.00,92,0,'0',NULL,'NOPICKUP',0,-1, '');
! INSERT INTO item_instances VALUES (53,0,0,0,1,0,0,3,-6.67,0.12,-144.50,0.00,1,1.00,93,0,'0',NULL,NULL,0,-1, '');
  INSERT INTO item_instances VALUES (54,0,0,0,1,0,0,3,-6.67,0.12,-146.50,0.00,1,1.00,94,0,'0',NULL,NULL,0,-1, '');
  INSERT INTO item_instances VALUES (55,0,0,0,1,0,0,3,-6.67,0.12,-148.50,0.00,1,1.00,95,0,'0',NULL,NULL,0,-1, '');
--- 90,96 ----
  INSERT INTO item_instances VALUES (49,3,0,3,1,5,0,0,0.00,0.00,0.00,0.00,1,1.00,71,0,'I','0','',0,-1, '');
  INSERT INTO item_instances VALUES (50,3,0,4,1,5,0,0,0.00,0.00,0.00,0.00,1,1.00,69,0,'I','0','',0,-1, '');
! INSERT INTO item_instances VALUES (51,0,0,0,1,0,0,3,-6.67,0.12,-140.50,0.00,1,1.00,91,0,'0',NULL,NULL,0,-1, '');
! INSERT INTO item_instances VALUES (52,0,0,0,1,0,0,3,-6.67,0.12,-142.50,0.00,1,1.00,92,0,'0',NULL,NULL,0,-1, '');
! INSERT INTO item_instances VALUES (53,0,0,0,1,0,0,3,-6.67,0.12,-144.50,0.00,1,1.00,93,0,'0',NULL,'NOPICKUP',0,-1, '');
  INSERT INTO item_instances VALUES (54,0,0,0,1,0,0,3,-6.67,0.12,-146.50,0.00,1,1.00,94,0,'0',NULL,NULL,0,-1, '');
  INSERT INTO item_instances VALUES (55,0,0,0,1,0,0,3,-6.67,0.12,-148.50,0.00,1,1.00,95,0,'0',NULL,NULL,0,-1, '');

Index: item_stats.sql
===================================================================
RCS file: /cvsroot/planeshift/planeshift/src/server/database/mysql/item_stats.sql,v
retrieving revision 1.65
retrieving revision 1.66
diff -C2 -d -r1.65 -r1.66
*** item_stats.sql	3 Feb 2006 12:43:16 -0000	1.65
--- item_stats.sql	3 Feb 2006 14:06:37 -0000	1.66
***************
*** 192,200 ****
  INSERT INTO `item_stats` VALUES (90, 'B', 'Mixer', '2.00', '5.00', 25, 0, 'BULK LEFTHAND RIGHTHAND', '0.00', 'STACKABLE', -1, -1, -1, '0', '0', '0', '0.00', '0.00', '0.00', '1.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.10', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 44, 45, 0, 0, '0', 1, '0.00', 'TOOL', '', '0.00', '', '0.00', '0', '0.00', 0, 0, '0.0000', 0, 0, 0, 0, '0', 'nosound', 1, '', '');
  INSERT INTO `item_stats` VALUES (101, 'B', 'Book', '1.00', '5.00', 20, 0, 'BULK LEFTHAND RIGHTHAND MIND', '0.00', 'READABLE', -1, -1, -1, '0', '0', '0', '0.00', '0.00', '0.00', '4.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2.00', '0.20', '0.20', '0.20', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 42, 43, 0, 0, '0', 3, '50.00', 'GENERIC', '', '0.00', '', '0.00', '0', '0.00', 0, 0, '0.0000', 0, 0, 0, 0, 'The Ancient Tome of Test:  Years ago, some guy was lame', 'nosound', 1, '', '');
! INSERT INTO `item_stats` VALUES (91, 'B', 'Super Potion of Speed', '0.00', '100.00', 1, 1, 'BULK', '0.00', 'STACKABLE CONSUMABLE', -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', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 131, 155, 0, 0, '0', 7, '0.00', NULL, NULL, '0.00', NULL, '0.00', '0', '0.00', 0, NULL, '0.0000', NULL, 0, NULL, 0, '0', 'nosound', 0, 'drink_speed_potion', '');
! INSERT INTO `item_stats` VALUES (92, 'B', 'Strange Potion', '0.00', '100.00', 1, 1, 'BULK', '0.00', 'STACKABLE CONSUMABLE', -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', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 132, 156, 0, 0, '0', 7, '0.00', NULL, NULL, '0.00', NULL, '0.00', '0', '0.00', 0, NULL, '0.0000', NULL, 0, NULL, 0, '0', 'nosound', 0, 'drink_strange_potion', '');
! INSERT INTO `item_stats` VALUES (93, 'B', 'Potion 3', '0.00', '100.00', 1, 1, 'BULK', '0.00', 'STACKABLE CONSUMABLE', -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', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 131, 155, 0, 0, '0', 7, '0.00', NULL, NULL, '0.00', NULL, '0.00', '0', '0.00', 0, NULL, '0.0000', NULL, 0, NULL, 0, '0', 'nosound', 0, 'drink_potion', '');
! INSERT INTO `item_stats` VALUES (94, 'B', 'Potion 4', '0.00', '100.00', 1, 1, 'BULK', '0.00', 'STACKABLE CONSUMABLE', -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', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 131, 155, 0, 0, '0', 7, '0.00', NULL, NULL, '0.00', NULL, '0.00', '0', '0.00', 0, NULL, '0.0000', NULL, 0, NULL, 0, '0', 'nosound', 0, 'drink_potion', '');
! INSERT INTO `item_stats` VALUES (95, 'B', 'Potion 5', '0.00', '100.00', 1, 1, 'BULK', '0.00', 'STACKABLE CONSUMABLE', -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', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 131, 155, 0, 0, '0', 7, '0.00', NULL, NULL, '0.00', NULL, '0.00', '0', '0.00', 0, NULL, '0.0000', NULL, 0, NULL, 0, '0', 'nosound', 0, 'drink_potion', '');
  INSERT INTO `item_stats` VALUES (96, 'B', 'Potion 6', '0.00', '100.00', 1, 1, 'BULK', '0.00', 'STACKABLE CONSUMABLE', -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', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 132, 156, 0, 0, '0', 7, '0.00', NULL, NULL, '0.00', NULL, '0.00', '0', '0.00', 0, NULL, '0.0000', NULL, 0, NULL, 0, '0', 'nosound', 0, 'drink_potion', '');
  INSERT INTO `item_stats` VALUES (97, 'B', 'Potion 7', '0.00', '100.00', 1, 1, 'BULK', '0.00', 'STACKABLE CONSUMABLE', -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', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 132, 156, 0, 0, '0', 7, '0.00', NULL, NULL, '0.00', NULL, '0.00', '0', '0.00', 0, NULL, '0.0000', NULL, 0, NULL, 0, '0', 'nosound', 0, 'drink_potion', '');
--- 192,200 ----
  INSERT INTO `item_stats` VALUES (90, 'B', 'Mixer', '2.00', '5.00', 25, 0, 'BULK LEFTHAND RIGHTHAND', '0.00', 'STACKABLE', -1, -1, -1, '0', '0', '0', '0.00', '0.00', '0.00', '1.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.10', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 44, 45, 0, 0, '0', 1, '0.00', 'TOOL', '', '0.00', '', '0.00', '0', '0.00', 0, 0, '0.0000', 0, 0, 0, 0, '0', 'nosound', 1, '', '');
  INSERT INTO `item_stats` VALUES (101, 'B', 'Book', '1.00', '5.00', 20, 0, 'BULK LEFTHAND RIGHTHAND MIND', '0.00', 'READABLE', -1, -1, -1, '0', '0', '0', '0.00', '0.00', '0.00', '4.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '2.00', '0.20', '0.20', '0.20', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 42, 43, 0, 0, '0', 3, '50.00', 'GENERIC', '', '0.00', '', '0.00', '0', '0.00', 0, 0, '0.0000', 0, 0, 0, 0, 'The Ancient Tome of Test:  Years ago, some guy was lame', 'nosound', 1, '', '');
! INSERT INTO `item_stats` VALUES (91, 'B', 'Potion of Speed', '0.00', '100.00', 1, 1, 'BULK', '0.00', 'STACKABLE CONSUMABLE', -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', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 131, 155, 0, 0, '0', 7, '0.00', NULL, NULL, '0.00', NULL, '0.00', '0', '0.00', 0, NULL, '0.0000', NULL, 0, NULL, 0, '0', 'nosound', 0, 'drink_speed_potion', '');
! INSERT INTO `item_stats` VALUES (92, 'B', 'Potion of Confusion', '0.00', '100.00', 1, 1, 'BULK', '0.00', 'STACKABLE CONSUMABLE', -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', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 132, 156, 0, 0, '0', 7, '0.00', NULL, NULL, '0.00', NULL, '0.00', '0', '0.00', 0, NULL, '0.0000', NULL, 0, NULL, 0, '0', 'nosound', 0, 'drink_strange_potion', '');
! INSERT INTO `item_stats` VALUES (93, 'B', 'Potion No Pickup', '0.00', '100.00', 1, 1, 'BULK', '0.00', 'STACKABLE CONSUMABLE', -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', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 131, 155, 0, 0, '0', 7, '0.00', NULL, NULL, '0.00', NULL, '0.00', '0', '0.00', 0, NULL, '0.0000', NULL, 0, NULL, 0, '0', 'nosound', 0, 'drink_potion', '');
! INSERT INTO `item_stats` VALUES (94, 'B', 'Potion of Healing', '0.00', '100.00', 1, 1, 'BULK', '0.00', 'STACKABLE CONSUMABLE', -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', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 131, 155, 0, 0, '0', 7, '0.00', NULL, NULL, '0.00', NULL, '0.00', '0', '0.00', 0, NULL, '0.0000', NULL, 0, NULL, 0, '0', 'nosound', 0, 'drink_potion', '');
! INSERT INTO `item_stats` VALUES (95, 'B', 'Poison Bottle', '0.00', '100.00', 1, 1, 'BULK', '0.00', 'STACKABLE CONSUMABLE', -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', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 131, 155, 0, 0, '0', 7, '0.00', NULL, NULL, '0.00', NULL, '0.00', '0', '0.00', 0, NULL, '0.0000', NULL, 0, NULL, 0, '0', 'nosound', 0, 'drink_poison', '');
  INSERT INTO `item_stats` VALUES (96, 'B', 'Potion 6', '0.00', '100.00', 1, 1, 'BULK', '0.00', 'STACKABLE CONSUMABLE', -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', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 132, 156, 0, 0, '0', 7, '0.00', NULL, NULL, '0.00', NULL, '0.00', '0', '0.00', 0, NULL, '0.0000', NULL, 0, NULL, 0, '0', 'nosound', 0, 'drink_potion', '');
  INSERT INTO `item_stats` VALUES (97, 'B', 'Potion 7', '0.00', '100.00', 1, 1, 'BULK', '0.00', 'STACKABLE CONSUMABLE', -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', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', '0.00', 132, 156, 0, 0, '0', 7, '0.00', NULL, NULL, '0.00', NULL, '0.00', '0', '0.00', 0, NULL, '0.0000', NULL, 0, NULL, 0, '0', 'nosound', 0, 'drink_potion', '');

Index: progress_events.sql
===================================================================
RCS file: /cvsroot/planeshift/planeshift/src/server/database/mysql/progress_events.sql,v
retrieving revision 1.31
retrieving revision 1.32
diff -C2 -d -r1.31 -r1.32
*** progress_events.sql	3 Feb 2006 12:43:16 -0000	1.31
--- progress_events.sql	3 Feb 2006 14:06:38 -0000	1.32
***************
*** 38,41 ****
--- 38,42 ----
  INSERT INTO progression_events VALUES("mageFather","<evt><int attribute=\"adjust\" base=\"yes\" value=\"5*Parm0\" /></evt>");
  INSERT INTO progression_events VALUES("drink_potion","<evt><hp attribute=\"adjust\" base=\"no\" value=\"10\" /><msg text=\"You drink an healing potion and feel better.\"/></evt>");
+ INSERT INTO progression_events VALUES("drink_poison","<evt><hp attribute=\"adjust\" base=\"no\" value=\"-20\" /><msg text=\"You drink some poison and feel bad.\"/></evt>");
  INSERT INTO progression_events VALUES("equip_mind","<evt><msg text=\"You now have something in mind.\"/></evt>");
  INSERT INTO progression_events VALUES("de_equip_mind","<evt><msg text=\"Your mind is now clear.\"/></evt>");