Modcraft - The community dedicated to quality WoW modding!

Wrath of the Lich King Modding => Serverside Modding => Topic started by: Sentinel on September 04, 2013, 10:27:15 pm

Title: [SOLVED] Guild name symbols limit
Post by: Sentinel on September 04, 2013, 10:27:15 pm

Hello, Modcraft.
I have a little problem. When I create a new guild with long name (more than 24-25 symbols) the last symbol of the name is deleted. It looks like server has a limit of symbols for the name of the Guild.
Could you help me: where I can remove this limit?
Thanks. And sorry for my bad English.

Title: Re: [QUESTION] Guild name symbols limit
Post by: Ascathos on September 04, 2013, 10:40:53 pm

24 is the limit given for the sql column.

Title: [SOLVED] Re: [QUESTION] Guild name symbols limit
Post by: Sentinel on September 04, 2013, 11:42:30 pm

Does it mean i cannot remove limit?

I found this command for MySQL, will it help?
"ALTER TABLE tablename MODIFY columnname VARCHAR(50)"

Title: Re: [QUESTION] Guild name symbols limit
Post by: Ascathos on September 05, 2013, 03:41:15 am

Quote from: "Sentinel"

Does it mean i cannot remove limit?

I found this command for MySQL, will it help?
"ALTER TABLE tablename MODIFY columnname VARCHAR(50)"

Code: [Select]

ALTER TABLE `guild`
CHANGE COLUMN `name` `name` VARCHAR(50) NOT NULL DEFAULT '' AFTER `guildid`;


Title: [SOLVED] Re: [QUESTION] Guild name symbols limit
Post by: Sentinel on September 05, 2013, 06:03:33 am

Quote from: "Ascathos"

Quote from: "Sentinel"

Does it mean i cannot remove limit?

I found this command for MySQL, will it help?
"ALTER TABLE tablename MODIFY columnname VARCHAR(50)"

Code: [Select]

ALTER TABLE `guild`
CHANGE COLUMN `name` `name` VARCHAR(50) NOT NULL DEFAULT '' AFTER `guildid`;


Inputing this command in MySql consol could solve my problem?
Or this string is the part of *.patch file for the Core?
----
Thanks a lot, my problem has solved!