How to Reset The Castle

[Mechomorph XD]

I tried UPDATE SQL already. Just change guild_id of guild_castle table to 0 but not work.

else I tried /breakguild, It's work.

SetCastleData "mapname",0,0; /* NOT WORK TOO */

Can use script reset the castle?

Thank You

Edited May 8, 2012 by Mechomorph XD

[Brian]

SQL method:

1. stop the servers
   
2. run this query:

   TRUNCATE TABLE guild_castle;

   
   

3. restart servers
   

Script method:

1. create a file containing this npc script
   

   poring_c01,100,100,0	script	reset_castles	910,{
   OnWhisperGlobal:
   setarray .@maps$[0], 
   	"aldeg_cas01", "aldeg_cas02", "aldeg_cas03", "aldeg_cas04", "aldeg_cas05", 
   	"gefg_cas01", "gefg_cas02", "gefg_cas03", "gefg_cas04", "gefg_cas05", 
   	"payg_cas01", "payg_cas02", "payg_cas03", "payg_cas04", "payg_cas05", 
   	"prtg_cas01", "prtg_cas02", "prtg_cas03", "prtg_cas04", "prtg_cas05", 
   	"nguild_alde", "nguild_gef", "nguild_pay", "nguild_prt", 
   	"schg_cas01", "schg_cas02", "schg_cas03", "schg_cas04", "schg_cas05", 
   	"arug_cas01", "arug_cas02", "arug_cas03", "arug_cas04", "arug_cas05";
   
   // castle_ID from 0 to 33
   for (set .@i,0; .@i < getarraysize(.@maps$); set .@i,.@i+1) {
   	for (set .@j,1; .@j<=17; set .@j,.@j+1)
   		setcastledata .@maps$[.@i], .@j, 0;
   }
   
   atcommand "@unloadnpc " + strnpcinfo(3);
   }
   

   
   

2. @loadnpc folder/filename.txt
   
3. click or whisper the NPC (npc:reset_castles)
   

[Mechomorph XD]

Thank You. IT's work