So since Wildfire was already taken, no one else can register the Guild name “Wildfire” anymore. Interesting. Just letting people know.
that mean , the guild is still in thier database. they need to remove all guild name wildfire in the server
So basically someone could power level a bunch of characters into Templar and grief the server by taking popular names then deleting a bunch of times?
This is another one of those stupidly incomprehensible things like the / command to crash the server or disband guilds. Like seriously what kind of half baked code do you have where once a guild is made it gets stored into the database forever.
I would like someone to double check and confirm this is true.
1 Like
You can do that each time on a same character for one million.
Sounds like a job for necro farmers
1 Like
And even after the Templar character is deleted or guild disbanded nobody else can take that guild name?
Hmmm why can’t they remove the row which houses the guildname when the templar disbands the guild? I hope they are not using the guildname as a unique primary field for the table.
Coudln’t it just be that the templar and the guild still exist in the depths of an abandoned account?
But, that said. would you, in all honestly. WANT THEM to do something so complex as a “Delete from database”? They’ll probably miss the “where” or put a drop table in hopes of acomplishing the task.
Please. PLEEASE do not let them touch the already established database. imagine the struggle they must be going through trying to fix the GvG standings from like 2 months ago!
Oh, I don’t expect the current staff here to fix it just wondering if this works exactly as the original post says. Where if you disband a guild a or delete the Templar character it ties up the name forever. Given the nature of this it’s not exactly game impeding like a lot of other things so it would fall under low priority but yet another small thing to list.
As @Nekorin mentioned it probably is a primary key, why in god’s name would a varchar be a primary key? I don’t know.
Why is the name kept? Well a database likes to keep things. However, when a guild is disbanded, why is that name unavailable from the pool of possible names? you’d have to look at the database design to truly know. It is as you’ve said an oversight.
I’d fear for my account if they were to touch the database in such a way with the lack of specialized staff we have here on IToS.
The only reason why they keep guildnames and can’t change it is
- They made it as a primary key
- The keys are used in other tables as foreign keys, like playerid associations
This makes it extremely hard to change as 1 change creates many ripple effects, have to change many rows just to change a name. Hopefully this is not the case for ToS… Hmm it also kind of explains why guildnames can’t have special chars and spaces…
However it does make querying has 1 lesser join though… since dun need to join the guildtable just to get the guild name. lol.
My guild got affected by the destruction bug. Back then it was 1TOS and when I wanted to remake that name, apparently it was taken, therefore this info is most likely true.
I’d probably left the guild table as:
guild_id int primary key
name varchar unique
templar_id int obvious fk
active int (or bool, whatever you prefer)
the relationship between guildtable and templar would have to be 1 to many to accomodate having the name be reusable.
I like joining my tables it is a nice way to spend an hour or two. But we don’t know what really is going on. and probably shouldnt either. not our software and all that. not an excuse to provide good service sob
1 Like
I’d be very surprised if IMC stored them by name, considering the fact that Team Names are stored by unique number keys. There are also reasons why they wouldn’t want multiple guilds having the same name, there are announcements, drama threads, etc. that all refer to guild names. This is a common practice with usernames in almost every game and website.
1 Like
This topic was automatically closed after 62 days. New replies are no longer allowed.