How to kick all guilds members except masters?

[yazankayed]

Hello:

 

How to kick all guilds members except masters? because i have reduced max guild members.

 

Thanks.

Any help guys ?

[Brian]

Run these SQL queries while your server is offline:

UPDATE `char` SET guild_id=0 WHERE char_id NOT IN (SELECT char_id FROM guild);

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

[Digos]

Use the query below to delete all members (except the leader) from guilds that have more than 70 members (you can change this number in the query).

CHANGE THE 70 BELOW TO THE NEW MAX GUILD MEMBER!!! 

DELETE `guild_member`
    FROM `guild_member`
    LEFT JOIN `guild`
        ON `guild_member`.`char_id` = `guild`.`char_id`
    WHERE
        `guild`.`char_id` IS NULL
        AND `guild_member`.`guild_id` IN (
            SELECT `guild_id` FROM ( SELECT COUNT(*) members, `guild_id` FROM `guild_member` GROUP BY `guild_id` HAVING members > 70 ) gids
        );

And this is to update the characters that are not in a guild.

UPDATE `char`
	SET `guild_id` = 0
	WHERE `char_id` NOT IN ( SELECT `char_id` FROM `guild_member`	);

Edited May 1, 2013 by Digos

[yazankayed]

Thanks Brian