How to reset castle

[madtoyz]

How to reset castle ?

 

[Louis T Steinhil]

http://rathena.org/board/topic/63048-how-to-reset-the-castle/

 

[Dastgir]

From Topic http://rathena.org/board/topic/63048-how-to-reset-the-castle/ :

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)

 

[Patskie]

How to reset castle ?

This :

TRUNCATE TABLE `guild_castle`;

 

[Angelmelody]

I conceive  a simple idea , but not sure  whether it work  or not

function    script    resetcastle    {    setarray .@maps$[0],"aldeg_cas01","aldeg_cas02","aldeg_cas03","aldeg_cas04","aldeg_cas05";    setarray .@maps$[5],"gefg_cas01","gefg_cas02","gefg_cas03","gefg_cas04","gefg_cas05";    setarray .@maps$[10],"payg_cas01","payg_cas02","payg_cas03","payg_cas04","payg_cas05";    setarray .@maps$[15],"prtg_cas01","prtg_cas02","prtg_cas03","prtg_cas04","prtg_cas05";    for( set .@i, 0; .@i <= 19; set .@i, .@i+1 )        SetCastleData .@maps$[.@i],1,0;}

 

[madtoyz]

it mean,need clean the castle table from database and then run the script resetcastle right ?