[Planeshift-cvs] CVS: planeshift/src/server/database/mysql deletenpc.sql,1.2,1.2.2.1

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

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

Modified Files:
      Tag: MB
	deletenpc.sql 
Log Message:
fixed bug on knowledge area

Index: deletenpc.sql
===================================================================
RCS file: /cvsroot/planeshift/planeshift/src/server/database/mysql/deletenpc.sql,v
retrieving revision 1.2
retrieving revision 1.2.2.1
diff -C2 -d -r1.2 -r1.2.2.1
*** deletenpc.sql	11 Mar 2003 20:52:55 -0000	1.2
--- deletenpc.sql	13 Mar 2003 17:07:53 -0000	1.2.2.1
***************
*** 27,31 ****
  # perform deletion
  delete from npc_bad_text where npc=@npc_name;
! delete from npc_knowledge_areas where player_id=00;
  
  # replace min and max with values obtained above
--- 27,31 ----
  # perform deletion
  delete from npc_bad_text where npc=@npc_name;
! delete from npc_knowledge_areas where player_id=@npc_id;
  
  # replace min and max with values obtained above