Eyjafjallajokull Posted October 12, 2013 Posted October 12, 2013 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. Quote
Lil Troll Posted October 12, 2013 Posted October 12, 2013 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. Quote
Eyjafjallajokull Posted October 13, 2013 Author Posted October 13, 2013 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?) Quote
GmOcean Posted October 26, 2013 Posted October 26, 2013 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. Quote
Question
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.
3 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.