SQL Query Help

[Linkin Park]

Hi,

I need to remove all members of all the guilds except the guild master of the guilds in my database, how to do it?

It's like wiping all members of the guilds except the guild master to still save the guilds.

[Emistry]

try run this in your SQL....make sure you do backup 1st just in case anything happen...

DELETE FROM `guild` WHERE `name` <> `master` ;

[Linkin Park]

try run this in your SQL....make sure you do backup 1st just in case anything happen...

DELETE FROM `guild` WHERE `name` <> `master` ;

I don't think this is the right query as the guild members are located inside the guild_member table.

Will this query work?

DELETE FROM `guild_member` where position <> 0

Edited September 12, 2012 by RaGERO

[Brian]

1. stop the login, char, and map servers
   
2. run this first SQL query:
   

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

   
   

3. run this second SQL query:
   

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

[Linkin Park]

1. stop the login, char, and map servers
   
2. run this first SQL query:
   

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

   
   

3. run this second SQL query:
   

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

   
   

Thank you!