Page 1 of 1
[Help] Alliance
Posted: Wed Sep 16, 2009 1:12 pm
by Mage
Hi,
How can i delete all alliance in the server? thx
Re: [Help] Alliance
Posted: Wed Sep 16, 2009 1:16 pm
by Mage
Maybe with this?
Code: Select all
UPDATE clan_data SET ally_id = 0;UPDATE clan_data SET ally_name = NULL;UPDATE clan_data SET ally_crest_id = 0;
Re: [Help] Alliance
Posted: Wed Sep 16, 2009 2:13 pm
by Mage
Up
Re: [Help] Alliance
Posted: Wed Sep 16, 2009 2:18 pm
by janiii
yes, the query wou wrote is fine. i thought somebody answered you, didnt notice it was you
Code: Select all
UPDATE clan_data SET ally_id = 0, ally_name = NULL, ally_crest_id = 0, ally_penalty_expiry_time = 0, ally_penalty_type = 0;