Guild Rename/Change Leader NPC.

[Eyjafjallajokull]

Attempted to create SQL based script where you can change the Guild Name and Guild Leader.

(Basically I just tried to tweak the character rename script I have, but failed.) 

Searched around for a while and couldn't find anything.

 

Any help or prior scripts anyone has lying around that I might have missed?

 

I appreciate it in advance.

[Lil Troll]

If you rename your character when you are in a guild, your name in guild wont change, you must leave guild first. Tested it already.

I also tried changing all names available in sql, including Guild, char, etc.. etc.. still not working.

[Eyjafjallajokull]

Figured out the guild leader changer, but still need help with the Guild Name changer, which.....

 

If you rename your character when you are in a guild, your name in guild wont change, you must leave guild first. Tested it already.

I also tried changing all names available in sql, including Guild, char, etc.. etc.. still not working.

 

was not my point. Sorry.

 

Not requesting something to change the character name -- requesting something to change the guild name (if possible, I guess?)

[GmOcean]

prontera,150,180,4    script    GuildName Changer    123,{
mes "Input your new guild name.";
input .@name$;
set .@a$,charat(.@name$,0); //We run this so we can see if the first "character" is a Space.
if( !compare("1234567890",.@a$) && !charisalpha(.@a$,0) ){mes "^FF0000 INVALID NAME ^000000"; close;} //We've determined it's a Space so invalid name.
set .@n$,escape_sql(.@name$);
query_sql("UPDATE guild SET name='"+ .@n$ +"' WHERE guild_id='"+ getcharid(2) +"'");
next;
mes "Guild name successfully updated.";
close;

Not sure if the update will show without a relog or not. You'd have to test.