[PlaneShift-svn] SF.net SVN: planeshift:[8505] trunk/src/server/database/mysql/ delete_npc_checkonly.sql

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

Revision: 8505
          http://planeshift.svn.sourceforge.net/planeshift/?rev=8505&view=rev
Author:   lpancallo
Date:     2012-12-11 17:16:38 +0000 (Tue, 11 Dec 2012)
Log Message:
-----------
can be used to check dependencies before deleting an NPC

Added Paths:
-----------
    trunk/src/server/database/mysql/delete_npc_checkonly.sql

Added: trunk/src/server/database/mysql/delete_npc_checkonly.sql
===================================================================
--- trunk/src/server/database/mysql/delete_npc_checkonly.sql	                        (rev 0)
+++ trunk/src/server/database/mysql/delete_npc_checkonly.sql	2012-12-11 17:16:38 UTC (rev 8505)
@@ -0,0 +1,16 @@
+
+# You can use this to check if there are any dependencies on other tables before deleting a monster
+
+set @npcid=100024;
+select count(*) from character_traits where character_id=@npcid;
+select count(*) from item_instances where char_id_owner=@npcid;
+select count(*) from character_skills where character_id=@npcid;
+select count(*) from npc_knowledge_areas where player_id=@npc_id;
+select count(*) from merchant_item_categories where player_id=@npc_id;
+
+# Others tables you may be interested in checking for sentient NPCs are:
+
+# npc_triggers where area=@npc_name;
+# npc_bad_text where npc=@npc_name;
+# npc_knowledge_areas where player_id=@npc_id;
+# npc_responses where id>=@min_resp and id<=@max_resp;


Property changes on: trunk/src/server/database/mysql/delete_npc_checkonly.sql
___________________________________________________________________
Added: svn:mime-type
   + text/plain
Added: svn:eol-style
   + native

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.