requesting a "change guild name" npc

[andrew0960]

requesting a " guild name changer" npc

 

 

 

just the funtion that can chage a guild's name will do!

 

i can add del item by myself.

 

 

thanks so much!!! 

 

my life saver ><

 

[Mosaic]

requesting a " guild name changer" npc

 

 

 

just the funtion that can chage a guild's name will do!

 

i can add del item by myself.

 

 

thanks so much!!! 

 

my life saver ><

 

I don't know if this one will work but you can try

 

prontera,161,180,4 script Mr. Nick 709,{
mes "Hello there! I am Nick, the Guild Name changer."
mes "you can use my service if you have TCG and 50 Million Zennies! "
next;
mes "Input new name";
input @NewName$;
if(countitem(7227) || Zeny < 50000000) {
mes "I do apologize but you did not meet my requirements..";
close;
}
next;
mes "Please relog for the changes to take effect";
query_sql("UPDATE `name` FROM `guild` SET `name`='"+@NewName$+"' WHERE `name`='"+strcharinfo(2)+"'");
delitem 7227,1;
set Zeny,Zeny-50000000;
close;

I used +strcharinfo(2)+ because type "2" is for the name of the guild and "0" is for the player(as per wiki), but I'm not so sure about this...

 

Edited November 5, 2016 by Mosaic

[Emistry]

trick like this wouldnt work well.

 

you have to shut down the server and then update the guild name through SQL then restart the server, that's the proper way to updates these value that shared and used by more than one char.