[Planeshift-cvs] CVS: planeshift/src/server/database/mysql natural_resources.sql,1.4,1.5 server_options.sql,1.74,1.75

[Anders R. <ma...@us...>]

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

Modified Files:
	natural_resources.sql server_options.sql 
Log Message:
- Added visibility range to natural resources. The natural_resources table
  have been changed to include a visible_range.
- Added clamping of probabilitis in the HandleProduction function
  in the workmanager. This include 0.0 probability for distance to find a resource
  if outside resource range. Still there will be a 0.1 probability to find
  the resource within the visible_range.
- Changed Set/GetLastMiningPosition to Set/GetLastProductionPosition
  since this is used for general production events and not only
  mining. To allow for easy extending to /chop wood, /pick mushrooms, ...
- Changed the Set[HP|Mana|Fatigue] function to not allow to set higher
  value than max for thise. If a poision should increas any of this
  values higher than max a change to the max value should be done
  first in the potion script.
- Added view/edit of the min_faction field in the trainer_skills table
  to the serverconsole.


Index: natural_resources.sql
===================================================================
RCS file: /cvsroot/planeshift/planeshift/src/server/database/mysql/natural_resources.sql,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** natural_resources.sql	21 Oct 2004 07:37:46 -0000	1.4
--- natural_resources.sql	30 Jan 2005 21:03:37 -0000	1.5
***************
*** 15,18 ****
--- 15,19 ----
    loc_z float(10,2) DEFAULT '0.00' ,
    radius float(10,2) DEFAULT '0.00' ,
+   visible_radius float(10,2) DEFAULT '0.00' ,
    probability float(10,6) DEFAULT '0.000000' ,
    skill smallint(4) unsigned DEFAULT '0' ,
***************
*** 32,38 ****
  #
  
! INSERT INTO natural_resources VALUES("1","npcroom","-50.00","0.00","-150.00","40.00","0.200000","37","50","6","0.500000","greet","10","85","gold");
! INSERT INTO natural_resources VALUES("2","npcroom","50.00","0.00","-150.00","40.00","0.200000","37","50","6","0.500000","greet","10","102","iron");
! INSERT INTO natural_resources VALUES("3","npcroom","50.00","0.00","-150.00","40.00","0.200000","37","50","6","0.500000","greet","10","103","coal");
! INSERT INTO natural_resources VALUES("4","npcroom","50.00","0.00","-150.00","40.00","0.200000","37","50","6","0.500000","greet","10","115","clay");
! INSERT INTO natural_resources VALUES("5","npcroom","50.00","0.00","-150.00","40.00","0.200000","37","50","6","0.500000","greet","10","116","sand");
--- 33,39 ----
  #
  
! INSERT INTO natural_resources VALUES("1","npcroom","-50.00","0.00","-150.00","40.00","50.0","0.200000","37","50","6","0.500000","greet","10","85","gold");
! INSERT INTO natural_resources VALUES("2","npcroom","50.00","0.00","-150.00","40.00","50.0","0.200000","37","50","6","0.500000","greet","10","102","iron");
! INSERT INTO natural_resources VALUES("3","npcroom","50.00","0.00","-150.00","40.00","50.0","0.200000","37","50","6","0.500000","greet","10","103","coal");
! INSERT INTO natural_resources VALUES("4","npcroom","50.00","0.00","-150.00","40.00","50.0","0.200000","37","50","6","0.500000","greet","10","115","clay");
! INSERT INTO natural_resources VALUES("5","npcroom","50.00","0.00","-150.00","40.00","50.0","0.200000","37","50","6","0.500000","greet","10","116","sand");

Index: server_options.sql
===================================================================
RCS file: /cvsroot/planeshift/planeshift/src/server/database/mysql/server_options.sql,v
retrieving revision 1.74
retrieving revision 1.75
diff -C2 -d -r1.74 -r1.75
*** server_options.sql	26 Jan 2005 20:32:30 -0000	1.74
--- server_options.sql	30 Jan 2005 21:03:37 -0000	1.75
***************
*** 19,22 ****
  #
  
! INSERT INTO server_options VALUES("db_version","1072");
  INSERT INTO server_options VALUES("standard_motd","This is the message of the day from server_options table.");
--- 19,22 ----
  #
  
! INSERT INTO server_options VALUES("db_version","1073");
  INSERT INTO server_options VALUES("standard_motd","This is the message of the day from server_options table.");