Patch notes

[marie]

Originally Posted by COLGATETHEGRANDMASTER [You must be logged in to view images. Log in or Register.]

wipe it clean

[quido]

DELETE FROM character_ WHERE id IN (SELECT char_id FROM guild_members WHERE guild_id IN (SELECT id FROM guilds WHERE name='Nihilum'));

[Rogean]

Originally Posted by quido [You must be logged in to view images. Log in or Register.]

DELETE FROM character_ WHERE id IN (SELECT char_id FROM guild_members WHERE guild_id IN (SELECT id FROM guilds WHERE name='Nihilum'));

wow that would take a year to execute

[quido]

i suck at sql

[quido]

u should try it tho

[Rogean]

DELETE c, gm, g FROM character_ c LEFT OUTER JOIN guild_members gm on gm.char_id = c.id LEFT OUTER JOIN guilds g on g.id = gm.guild_id WHERE g.name = "Nihilum";

[quido]

now we're talking ... clicking donate button......

[Twainz]

DELETE c, gm, g FROM character_ c LEFT OUTER JOIN guild_members gm on gm.char_id = c.id LEFT OUTER JOIN guilds g on g.id = gm.guild_id WHERE g.name = "The Mystical Order";

[Juhstin]

Originally Posted by COLGATETHEGRANDMASTER [You must be logged in to view images. Log in or Register.]

wipe it clean

[Azure]

Originally Posted by Rogean [You must be logged in to view images. Log in or Register.]

Smedy, do you even SQL?!!!11