SQL method:
stop the servers
run this query: TRUNCATE TABLE guild_castle;
restart servers
Script method:
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);
}
@loadnpc folder/filename.txt
click or whisper the NPC (npc:reset_castles)