[Planeshift-cvs] CVS: planeshift/src/server/database/mysql loot_categories.sql,NONE,1.1 server_options.sql,1.16,1.17 npc_spawn_rules.sql,1.1,1.2 create_all.sql,1.15,1.16

[Keith F. <ven...@us...>]

Update of /cvsroot/planeshift/planeshift/src/server/database/mysql
In directory sc8-pr-cvs1:/tmp/cvs-serv21745

Modified Files:
	server_options.sql npc_spawn_rules.sql create_all.sql 
Added Files:
	loot_categories.sql 
Log Message:
Added loot_categories table, which contains probabilities and item distribution
for NPC loot when they die.  This is loaded into SpawnManager and calculated
when they die.  The psCharacter now holds an array of lootable items,
waiting for implementation of looting GUI.

--- NEW FILE: loot_categories.sql ---
# MySQL-Front Dump 1.16 beta
#
# Host: localhost Database: planeshift
#--------------------------------------------------------
# Server version 3.23.52-max-nt
#
# Table structure for table 'loot_categories'
#

CREATE TABLE loot_categories (
  cat_id int(10) unsigned NOT NULL DEFAULT '0' ,
  item_stat_id int(10) unsigned NOT NULL DEFAULT '0' ,
  probability float(5,4) NOT NULL DEFAULT '0.0000' ,
  min_money int(10) unsigned NOT NULL DEFAULT '0' ,
  max_money int(10) unsigned NOT NULL DEFAULT '0' ,
  PRIMARY KEY (cat_id,item_stat_id)
);


#
# Dumping data for table 'loot_categories'
#

INSERT INTO loot_categories VALUES("1","8","0.5000","0","0");
INSERT INTO loot_categories VALUES("1","7","0.3500","0","0");
INSERT INTO loot_categories VALUES("1","6","0.1500","0","0");

Index: server_options.sql
===================================================================
RCS file: /cvsroot/planeshift/planeshift/src/server/database/mysql/server_options.sql,v
retrieving revision 1.16
retrieving revision 1.17
diff -C2 -d -r1.16 -r1.17
*** server_options.sql	1 Oct 2003 22:16:00 -0000	1.16
--- server_options.sql	5 Oct 2003 07:50:05 -0000	1.17
***************
*** 19,21 ****
  #
  
! INSERT INTO server_options VALUES("db_version","1014");
--- 19,21 ----
  #
  
! INSERT INTO server_options VALUES("db_version","1015");

Index: npc_spawn_rules.sql
===================================================================
RCS file: /cvsroot/planeshift/planeshift/src/server/database/mysql/npc_spawn_rules.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -d -r1.1 -r1.2
*** npc_spawn_rules.sql	25 Jul 2003 06:00:50 -0000	1.1
--- npc_spawn_rules.sql	5 Oct 2003 07:50:05 -0000	1.2
***************
*** 19,22 ****
--- 19,24 ----
    fixed_spawn_rot float(6,4) DEFAULT '0.0000' ,
    fixed_spawn_sector varchar(40) DEFAULT 'room' ,
+   loot_category_id int(10) unsigned NOT NULL DEFAULT '0' ,
+   dead_remain_time int(10) unsigned NOT NULL DEFAULT '0' ,
    PRIMARY KEY (id)
  );
***************
*** 27,29 ****
  #
  
! INSERT INTO npc_spawn_rules VALUES("999","25000","60000","0.0000","0","-4.50","-1.10","-4.00","4.5500","hydlaa_plaza");
--- 29,32 ----
  #
  
! INSERT INTO npc_spawn_rules VALUES("999","25000","60000","0.0000","0","-4.50","-1.10","-4.00","4.5500","hydlaa_plaza","0","0");
! INSERT INTO npc_spawn_rules VALUES("1","10000","20000","0.0000","0","0.00","0.00","0.00","0.0000","npcroom","1","60000");

Index: create_all.sql
===================================================================
RCS file: /cvsroot/planeshift/planeshift/src/server/database/mysql/create_all.sql,v
retrieving revision 1.15
retrieving revision 1.16
diff -C2 -d -r1.15 -r1.16
*** create_all.sql	28 Sep 2003 00:18:04 -0000	1.15
--- create_all.sql	5 Oct 2003 07:50:06 -0000	1.16
***************
*** 20,23 ****
--- 20,24 ----
  source item_stats.sql;
  source item_animations.sql;
+ source loot_categories.sql;
  source merchant_item_cats.sql;
  source npc_bad_text.sql;