[Planeshift-cvs] CVS: planeshift/src/server/database/mysql npc_responses.sql,1.24,1.25 sc_npc_definitions.sql,1.7,1.8 traits.sql,1.9,1.10

[stfrn <st...@us...>]

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

Modified Files:
	npc_responses.sql sc_npc_definitions.sql traits.sql 
Log Message:
Fixes for warnings that prevented support for MySQL 5.0.
For example, "" cannot be used for ints, use "0"

Index: npc_responses.sql
===================================================================
RCS file: /cvsroot/planeshift/planeshift/src/server/database/mysql/npc_responses.sql,v
retrieving revision 1.24
retrieving revision 1.25
diff -C2 -d -r1.24 -r1.25
*** npc_responses.sql	30 Nov 2005 21:03:15 -0000	1.24
--- npc_responses.sql	11 Dec 2005 22:18:03 -0000	1.25
***************
*** 44,48 ****
  INSERT INTO npc_responses VALUES("19","Oh weird, it's like deja vu!","","","","","","","","","","0");
  INSERT INTO npc_responses VALUES("20","I have already responded to that and I will not do so again, $sir!","","","","","","","","","","0");
! INSERT INTO npc_responses VALUES("21","I'm not giving you anything.  What have you given me?","","","","","","","","","","");
  INSERT INTO npc_responses VALUES("22","Ok, I will give you some exp.","","","","","","","","","<response><respond/><run scr=\"give_exp\" param0=\"200\" /></response>","0");
  INSERT INTO npc_responses VALUES("23","Hi $sir!, I will say thank you for 11 trias.","","","","","","","","","","0");
--- 44,48 ----
  INSERT INTO npc_responses VALUES("19","Oh weird, it's like deja vu!","","","","","","","","","","0");
  INSERT INTO npc_responses VALUES("20","I have already responded to that and I will not do so again, $sir!","","","","","","","","","","0");
! INSERT INTO npc_responses VALUES("21","I'm not giving you anything.  What have you given me?","","","","","","","","","","0");
  INSERT INTO npc_responses VALUES("22","Ok, I will give you some exp.","","","","","","","","","<response><respond/><run scr=\"give_exp\" param0=\"200\" /></response>","0");
  INSERT INTO npc_responses VALUES("23","Hi $sir!, I will say thank you for 11 trias.","","","","","","","","","","0");

Index: sc_npc_definitions.sql
===================================================================
RCS file: /cvsroot/planeshift/planeshift/src/server/database/mysql/sc_npc_definitions.sql,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** sc_npc_definitions.sql	27 Nov 2005 15:09:06 -0000	1.7
--- sc_npc_definitions.sql	11 Dec 2005 22:18:03 -0000	1.8
***************
*** 25,32 ****
  #
  
! INSERT INTO sc_npc_definitions VALUES("4","MaleEnki","Wanderer","wander region","","","","N");
! INSERT INTO sc_npc_definitions VALUES("5","Smith","Wanderer","wander region","","","","");
! INSERT INTO sc_npc_definitions VALUES("6","Ynnwn","Wanderer","wander region","","","","");
! INSERT INTO sc_npc_definitions VALUES("7","Ylian","Wanderer","wander region","","","","");
! INSERT INTO sc_npc_definitions VALUES("8","Merchant","Wanderer","wander region","","","","");
! INSERT INTO sc_npc_definitions VALUES("10","FAMILIAR:Rogue","Minion","wander region","","","","Y");
--- 25,32 ----
  #
  
! INSERT INTO sc_npc_definitions VALUES("4","MaleEnki","Wanderer","wander region","0.00","0.00","0","N");
! INSERT INTO sc_npc_definitions VALUES("5","Smith","Wanderer","wander region","0.00","0.00","0","");
! INSERT INTO sc_npc_definitions VALUES("6","Ynnwn","Wanderer","wander region","0.00","0.00","0","");
! INSERT INTO sc_npc_definitions VALUES("7","Ylian","Wanderer","wander region","0.00","0.00","0","");
! INSERT INTO sc_npc_definitions VALUES("8","Merchant","Wanderer","wander region","0.00","0.00","0","");
! INSERT INTO sc_npc_definitions VALUES("10","FAMILIAR:Rogue","Minion","wander region","0.00","0.00","0","Y");

Index: traits.sql
===================================================================
RCS file: /cvsroot/planeshift/planeshift/src/server/database/mysql/traits.sql,v
retrieving revision 1.9
retrieving revision 1.10
diff -C2 -d -r1.9 -r1.10
*** traits.sql	7 Sep 2005 00:17:45 -0000	1.9
--- traits.sql	11 Dec 2005 22:18:03 -0000	1.10
***************
*** 35,39 ****
  CREATE TABLE traits (
    id int(10) unsigned NOT NULL auto_increment,  
!   next_trait int(10) unsigned NOT NULL DEFAULT '-1',
    race_id int(30),
    only_npc int(1),
--- 35,39 ----
  CREATE TABLE traits (
    id int(10) unsigned NOT NULL auto_increment,  
!   next_trait int(10) NOT NULL DEFAULT '-1',
    race_id int(30),
    only_npc int(1),