Reducing guild capacity and removing alliance => how to fix/ready DB

[Zirius 1]

Hello! I successfully reduced the max guild capacity and also planning to remove guild alliance feature.

I tried in local dev, but seems like existing guilds are giving console error since in DB they have max guild capacity greater than what the source allows.

 

How can I:

Make the max guild capacity applies then

Kick all players from their guild IF NOT guild master

Then also remove the alliance the guild has

 

I don't wanna truncate all guild database

 

Thanks!

Edited November 24, 2014 by Zirius

[jaBote 438]

Oh, sorry, I understood you just wanted to remove alliances.

 

I couldn't understand you what you mean with makint the max guild capacity apply, so please elaborate a bit on that. In any case, please remember that if you edit the max guild capacity (I think that's a source edit) you should recompile to make it effective.

 

To kick every guild member from the guilds except the guild master, you could issue the following SQL query (remember to try on a backup first, I haven't tested it):

 

DELETE FROM `guild_member` WHERE `char_id` NOT IN (SELECT `char_id` FROM `guild`)

[jaBote 438]

If you want to remove any existing guild alliances, please check out the guild_alliance table on your SQL side. Maybe you'll want to truncate the table (remove all data on it).

 

Please do test on a server backup and while the server is shut down if you don't want to find out unexpected behavior, since I haven't tested but that should do.

[Zirius 1]

If you want to remove any existing guild alliances, please check out the guild_alliance table on your SQL side. Maybe you'll want to truncate the table (remove all data on it).

 

Please do test on a server backup and while the server is shut down if you don't want to find out unexpected behavior, since I haven't tested but that should do.

 

Yes removing alliance is easy how about this bro? :

 

 

Make the max guild capacity applies then

Kick all players from their guild IF NOT guild master

[Zirius 1]

Oh, sorry, I understood you just wanted to remove alliances.

 

I couldn't understand you what you mean with makint the max guild capacity apply, so please elaborate a bit on that. In any case, please remember that if you edit the max guild capacity (I think that's a source edit) you should recompile to make it effective.

 

To kick every guild member from the guilds except the guild master, you could issue the following SQL query (remember to try on a backup first, I haven't tested it):

 

 

DELETE FROM `guild_member` WHERE `char_id` NOT IN (SELECT `char_id` FROM `guild`)

 

 

Thanks!

I am referring to updating the sql database with the new guild capacity as based on new src edit.

 

If the old max guild capacity is 36. 16 initial, and 2 per Guild extension level.

A guild which capped their guild extension will have at SQL table guild capacity of 36.

And this number won't get updated and keep on showing as warning on console because of this:

 

if (g->max_member > MAX_GUILD) {

// Fix reduction of MAX_GUILD [PoW]

ShowWarning("Guild %d:%s specifies higher capacity (%d) than MAX_GUILD (%d)n", guild_id, g->name, g->max_member, MAX_GUILD);

g->max_member = MAX_GUILD;

}

Is there a way Herc would run on all guilds on server, update the `max_member` table based on src edit?

 

Thanks.

[jaBote 438]

You can do it manually, but I think Guild Extension would need an edit to avoid other guilds get over the limit.

 

UPDATE `guild` SET `max_member` = yourmaxvalue WHERE `max_member` > yourmaxvalue

[Zirius 1]

You can do it manually, but I think Guild Extension would need an edit to avoid other guilds get over the limit.

 

UPDATE `guild` SET `max_member` = yourmaxvalue WHERE `max_member` > yourmaxvalue

you mean at

 

src/char/int_guild.c

g->max_member = 6 + inter_guild->checkskill(g, GD_EXTENSION) * 6;

and

 

src/common/mmo.h

#define MAX_GUILD (6+10*6)

right?

 

it was already done. anything else I should note bro?

[jaBote 438]

I guess not, but don't forget to recompile and try that last SQL query I sentido you.